participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,900 rows where station_code = "RU0007" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
1829066 | 1829066 | 20221025023140_hVm9L | RU0007 | 2024-01-05T23:51:26.785Z | 2024-01-05T23:51:26.785Z |
1828410 | 1828410 | 20221025015814_fOwAE | RU0007 | 2024-01-05T23:51:26.665Z | 2024-01-05T23:51:26.665Z |
1827179 | 1827179 | 20221025004832_TbAxu | RU0007 | 2024-01-05T23:51:26.418Z | 2024-01-05T23:51:26.418Z |
1781349 | 1781349 | 20221018024857_hNqQ8 | RU0007 | 2024-01-05T23:51:11.387Z | 2024-01-05T23:51:11.387Z |
1781181 | 1781181 | 20221018022906_MeKhw | RU0007 | 2024-01-05T23:51:11.367Z | 2024-01-05T23:51:11.367Z |
1780756 | 1780756 | 20221018015426_3QL7s | RU0007 | 2024-01-05T23:51:11.317Z | 2024-01-05T23:51:11.317Z |
1779587 | 1779587 | 20221018000333_RyAhN | RU0007 | 2024-01-05T23:51:11.186Z | 2024-01-05T23:51:11.186Z |
1779051 | 1779051 | 20221017230559_5eV3s | RU0007 | 2024-01-05T23:51:11.126Z | 2024-01-05T23:51:11.126Z |
1778575 | 1778575 | 20221017215736_mqxCS | RU0007 | 2024-01-05T23:51:11.075Z | 2024-01-05T23:51:11.075Z |
1778368 | 1778368 | 20221017211204_Ieilk | RU0007 | 2024-01-05T23:51:11.050Z | 2024-01-05T23:51:11.050Z |
1778244 | 1778244 | 20221017204510_ilHlB | RU0007 | 2024-01-05T23:51:11.037Z | 2024-01-05T23:51:11.037Z |
1777608 | 1777608 | 20221017171439_WNdNC | RU0007 | 2024-01-05T23:51:10.955Z | 2024-01-05T23:51:10.955Z |
1776017 | 1776017 | 20221017020748_2IYhQ | RU0007 | 2024-01-05T23:51:09.044Z | 2024-01-05T23:51:09.044Z |
1769197 | 1769197 | 20221015021325_2FGu3 | RU0007 | 2024-01-05T23:51:05.196Z | 2024-01-05T23:51:05.196Z |
1769140 | 1769140 | 20221015015650_r9Ir4 | RU0007 | 2024-01-05T23:51:05.187Z | 2024-01-05T23:51:05.187Z |
1769007 | 1769007 | 20221015010137_h3pEL | RU0007 | 2024-01-05T23:51:05.165Z | 2024-01-05T23:51:05.165Z |
1768976 | 1768976 | 20221015003917_eECzi | RU0007 | 2024-01-05T23:51:05.159Z | 2024-01-05T23:51:05.159Z |
1768758 | 1768758 | 20221014230718_3vgBI | RU0007 | 2024-01-05T23:51:05.124Z | 2024-01-05T23:51:05.124Z |
1768601 | 1768601 | 20221014221310_CTs6q | RU0007 | 2024-01-05T23:51:05.104Z | 2024-01-05T23:51:05.104Z |
1767942 | 1767942 | 20221014155641_t8Luv | RU0007 | 2024-01-05T23:51:03.612Z | 2024-01-05T23:51:03.612Z |
1751642 | 1751642 | 20221008020418_XwuLE | RU0007 | 2024-01-05T23:50:53.132Z | 2024-01-05T23:50:53.132Z |
1748231 | 1748231 | 20221007015816_Pb54K | RU0007 | 2024-01-05T23:50:51.220Z | 2024-01-05T23:50:51.220Z |
1748113 | 1748113 | 20221007013133_ST3im | RU0007 | 2024-01-05T23:50:51.205Z | 2024-01-05T23:50:51.205Z |
1748101 | 1748101 | 20221007013021_ZDb2T | RU0007 | 2024-01-05T23:50:51.204Z | 2024-01-05T23:50:51.204Z |
1747880 | 1747880 | 20221007003903_oOuSA | RU0007 | 2024-01-05T23:50:51.176Z | 2024-01-05T23:50:51.176Z |
1747800 | 1747800 | 20221007002223_3E5Cx | RU0007 | 2024-01-05T23:50:51.165Z | 2024-01-05T23:50:51.165Z |
1725685 | 1725685 | 20221001211639_wPWL0 | RU0007 | 2024-01-05T23:50:40.850Z | 2024-01-05T23:50:40.850Z |
1720567 | 1720567 | 20220930224646_1ff4q | RU0007 | 2024-01-05T23:50:39.032Z | 2024-01-05T23:50:39.032Z |
1720444 | 1720444 | 20220930215056_0rxEY | RU0007 | 2024-01-05T23:50:39.016Z | 2024-01-05T23:50:39.016Z |
1720359 | 1720359 | 20220930212033_z2NXh | RU0007 | 2024-01-05T23:50:39.008Z | 2024-01-05T23:50:39.008Z |
1720336 | 1720336 | 20220930211358_HVA3T | RU0007 | 2024-01-05T23:50:39.005Z | 2024-01-05T23:50:39.005Z |
1720276 | 1720276 | 20220930203729_Ent3Q | RU0007 | 2024-01-05T23:50:38.996Z | 2024-01-05T23:50:38.996Z |
1720185 | 1720185 | 20220930193534_J9uCd | RU0007 | 2024-01-05T23:50:38.982Z | 2024-01-05T23:50:38.982Z |
1713547 | 1713547 | 20220929213928_PPgMG | RU0007 | 2024-01-05T23:50:37.113Z | 2024-01-05T23:50:37.113Z |
1713481 | 1713481 | 20220929212844_xmlQ2 | RU0007 | 2024-01-05T23:50:37.108Z | 2024-01-05T23:50:37.108Z |
1693687 | 1693687 | 20220925015020_3Fy3i | RU0007 | 2024-01-05T23:50:27.120Z | 2024-01-05T23:50:27.120Z |
1693109 | 1693109 | 20220925004902_96Ekc | RU0007 | 2024-01-05T23:50:27.074Z | 2024-01-05T23:50:27.074Z |
1692187 | 1692187 | 20220924221453_z2ENe | RU0007 | 2024-01-05T23:50:26.997Z | 2024-01-05T23:50:26.997Z |
1692087 | 1692087 | 20220924215550_aoI8w | RU0007 | 2024-01-05T23:50:26.987Z | 2024-01-05T23:50:26.987Z |
1691971 | 1691971 | 20220924212234_jCj6B | RU0007 | 2024-01-05T23:50:26.976Z | 2024-01-05T23:50:26.976Z |
1691961 | 1691961 | 20220924211640_MDT1E | RU0007 | 2024-01-05T23:50:26.975Z | 2024-01-05T23:50:26.975Z |
1691910 | 1691910 | 20220924210238_avcv3 | RU0007 | 2024-01-05T23:50:26.969Z | 2024-01-05T23:50:26.969Z |
1674447 | 1674447 | 20220920015011_bX3Fs | RU0007 | 2024-01-05T23:50:17.277Z | 2024-01-05T23:50:17.277Z |
1674356 | 1674356 | 20220920013009_rq52w | RU0007 | 2024-01-05T23:50:17.266Z | 2024-01-05T23:50:17.266Z |
1674319 | 1674319 | 20220920012437_u4x6I | RU0007 | 2024-01-05T23:50:17.262Z | 2024-01-05T23:50:17.262Z |
1673674 | 1673674 | 20220919231339_oiWAY | RU0007 | 2024-01-05T23:50:17.184Z | 2024-01-05T23:50:17.184Z |
1673672 | 1673672 | 20220919231338_vZVjs | RU0007 | 2024-01-05T23:50:17.183Z | 2024-01-05T23:50:17.183Z |
1673424 | 1673424 | 20220919215518_YNzuX | RU0007 | 2024-01-05T23:50:17.151Z | 2024-01-05T23:50:17.151Z |
1673301 | 1673301 | 20220919210953_ubxgE | RU0007 | 2024-01-05T23:50:17.135Z | 2024-01-05T23:50:17.135Z |
1673088 | 1673088 | 20220919170605_Y1dZ9 | RU0007 | 2024-01-05T23:50:17.096Z | 2024-01-05T23:50:17.096Z |
1669182 | 1669182 | 20220918193837_ksZCm | RU0007 | 2024-01-05T23:50:15.274Z | 2024-01-05T23:50:15.274Z |
1649357 | 1649357 | 20220910175625_zQWTU | RU0007 | 2024-01-05T23:50:03.210Z | 2024-01-05T23:50:03.210Z |
1646946 | 1646946 | 20220908012126_d25cQ | RU0007 | 2024-01-05T23:50:00.513Z | 2024-01-05T23:50:00.513Z |
1646900 | 1646900 | 20220908005832_7wwZg | RU0007 | 2024-01-05T23:50:00.506Z | 2024-01-05T23:50:00.506Z |
1646756 | 1646756 | 20220907234006_XDhUb | RU0007 | 2024-01-05T23:50:00.484Z | 2024-01-05T23:50:00.484Z |
1646719 | 1646719 | 20220907230419_M9NZb | RU0007 | 2024-01-05T23:49:59.331Z | 2024-01-05T23:49:59.331Z |
1646723 | 1646723 | 20220907230509_C9u5o | RU0007 | 2024-01-05T23:49:59.331Z | 2024-01-05T23:49:59.331Z |
1646699 | 1646699 | 20220907224017_38qhu | RU0007 | 2024-01-05T23:49:59.328Z | 2024-01-05T23:49:59.328Z |
1644157 | 1644157 | 20220907010406_8KCuI | RU0007 | 2024-01-05T23:49:59.025Z | 2024-01-05T23:49:59.025Z |
1643868 | 1643868 | 20220906234519_QTxmJ | RU0007 | 2024-01-05T23:49:58.987Z | 2024-01-05T23:49:58.987Z |
1640477 | 1640477 | 20220906004001_yzEuk | RU0007 | 2024-01-05T23:49:56.899Z | 2024-01-05T23:49:56.899Z |
1630186 | 1630186 | 20220902231349_pl3G1 | RU0007 | 2024-01-05T23:49:49.697Z | 2024-01-05T23:49:49.697Z |
1630156 | 1630156 | 20220902230428_Odh2F | RU0007 | 2024-01-05T23:49:49.691Z | 2024-01-05T23:49:49.691Z |
1626365 | 1626365 | 20220901234547_TxM1Z | RU0007 | 2024-01-05T23:49:47.897Z | 2024-01-05T23:49:47.897Z |
1599013 | 1599013 | 20220826225850_0wk6k | RU0007 | 2024-01-05T23:49:33.420Z | 2024-01-05T23:49:33.420Z |
1592770 | 1592770 | 20220824235451_d2mXv | RU0007 | 2024-01-05T23:49:27.240Z | 2024-01-05T23:49:27.240Z |
1590162 | 1590162 | 20220824001516_3qS0M | RU0007 | 2024-01-05T23:49:24.483Z | 2024-01-05T23:49:24.483Z |
1587359 | 1587359 | 20220823011047_LztW3 | RU0007 | 2024-01-05T23:49:22.624Z | 2024-01-05T23:49:22.624Z |
1587239 | 1587239 | 20220823001551_7Kut0 | RU0007 | 2024-01-05T23:49:22.608Z | 2024-01-05T23:49:22.608Z |
1587177 | 1587177 | 20220823000124_g8ro2 | RU0007 | 2024-01-05T23:49:22.600Z | 2024-01-05T23:49:22.600Z |
1587150 | 1587150 | 20220822235750_2km3e | RU0007 | 2024-01-05T23:49:22.597Z | 2024-01-05T23:49:22.597Z |
1587071 | 1587071 | 20220822233246_gMNq4 | RU0007 | 2024-01-05T23:49:22.586Z | 2024-01-05T23:49:22.586Z |
1587001 | 1587001 | 20220822231146_JXbhd | RU0007 | 2024-01-05T23:49:22.576Z | 2024-01-05T23:49:22.576Z |
1586969 | 1586969 | 20220822230239_nre32 | RU0007 | 2024-01-05T23:49:22.571Z | 2024-01-05T23:49:22.571Z |
1586956 | 1586956 | 20220822230040_iTxaf | RU0007 | 2024-01-05T23:49:22.570Z | 2024-01-05T23:49:22.570Z |
1572087 | 1572087 | 20220817200619_PGLbL | RU0007 | 2024-01-05T23:49:12.997Z | 2024-01-05T23:49:12.997Z |
1572069 | 1572069 | 20220817195538_4nCCh | RU0007 | 2024-01-05T23:49:12.994Z | 2024-01-05T23:49:12.994Z |
1572062 | 1572062 | 20220817194906_JVXNx | RU0007 | 2024-01-05T23:49:12.993Z | 2024-01-05T23:49:12.993Z |
1572064 | 1572064 | 20220817194913_StyXm | RU0007 | 2024-01-05T23:49:12.993Z | 2024-01-05T23:49:12.993Z |
1572046 | 1572046 | 20220817193225_2KNar | RU0007 | 2024-01-05T23:49:12.990Z | 2024-01-05T23:49:12.990Z |
1572040 | 1572040 | 20220817192538_T62GU | RU0007 | 2024-01-05T23:49:12.989Z | 2024-01-05T23:49:12.989Z |
1511645 | 1511645 | 20220809010037_cs1Id | RU0007 | 2024-01-05T23:48:54.062Z | 2024-01-05T23:48:54.062Z |
1511641 | 1511641 | 20220809005926_csWNk | RU0007 | 2024-01-05T23:48:54.061Z | 2024-01-05T23:48:54.061Z |
1511396 | 1511396 | 20220809005040_8sxSr | RU0007 | 2024-01-05T23:48:54.014Z | 2024-01-05T23:48:54.014Z |
1511239 | 1511239 | 20220809004300_czGzb | RU0007 | 2024-01-05T23:48:53.979Z | 2024-01-05T23:48:53.979Z |
1509572 | 1509572 | 20220808232725_dDwWE | RU0007 | 2024-01-05T23:48:53.626Z | 2024-01-05T23:48:53.626Z |
1509232 | 1509232 | 20220808231023_TkmCq | RU0007 | 2024-01-05T23:48:53.480Z | 2024-01-05T23:48:53.480Z |
1509210 | 1509210 | 20220808230824_jTSYa | RU0007 | 2024-01-05T23:48:53.469Z | 2024-01-05T23:48:53.469Z |
1509190 | 1509190 | 20220808230628_3d3kK | RU0007 | 2024-01-05T23:48:53.454Z | 2024-01-05T23:48:53.454Z |
1508707 | 1508707 | 20220808223531_5urk6 | RU0007 | 2024-01-05T23:48:53.249Z | 2024-01-05T23:48:53.249Z |
1508638 | 1508638 | 20220808222930_OJjLo | RU0007 | 2024-01-05T23:48:53.229Z | 2024-01-05T23:48:53.229Z |
1508516 | 1508516 | 20220808222356_2J0ag | RU0007 | 2024-01-05T23:48:53.193Z | 2024-01-05T23:48:53.193Z |
1508465 | 1508465 | 20220808221939_arV3t | RU0007 | 2024-01-05T23:48:53.173Z | 2024-01-05T23:48:53.173Z |
1508374 | 1508374 | 20220808221311_KBDmZ | RU0007 | 2024-01-05T23:48:53.147Z | 2024-01-05T23:48:53.147Z |
1508372 | 1508372 | 20220808221311_8yM6I | RU0007 | 2024-01-05T23:48:53.146Z | 2024-01-05T23:48:53.146Z |
1508310 | 1508310 | 20220808220311_2sHrR | RU0007 | 2024-01-05T23:48:53.124Z | 2024-01-05T23:48:53.124Z |
1508302 | 1508302 | 20220808220245_GJCgn | RU0007 | 2024-01-05T23:48:53.120Z | 2024-01-05T23:48:53.120Z |
1502704 | 1502704 | 20220808004244_Yur6R | RU0007 | 2024-01-05T23:48:49.627Z | 2024-01-05T23:48:49.627Z |
1501268 | 1501268 | 20220807233657_2dx1y | RU0007 | 2024-01-05T23:48:49.332Z | 2024-01-05T23:48:49.332Z |
1501257 | 1501257 | 20220807233611_47jAP | RU0007 | 2024-01-05T23:48:49.328Z | 2024-01-05T23:48:49.328Z |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE participating_station ( meteor_unique_trajectory_identifier text NOT NULL, station_code text NOT NULL, created_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), updated_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier), FOREIGN KEY (station_code) REFERENCES station (code), UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE ); CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier); CREATE INDEX participating_station_created_at_index ON participating_station (created_at); CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);