participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,025 rows where station_code = "RU0004" 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 |
---|---|---|---|---|---|
5135653 | 5135653 | 20240914012621_h277N | RU0004 | 2024-09-19T12:19:54.464Z | 2024-09-20T12:18:53.529Z |
5132528 | 5132528 | 20240916012421_vZS2m | RU0004 | 2024-09-19T12:16:17.457Z | 2024-09-20T12:13:14.038Z |
5132319 | 5132319 | 20240916003325_25MsY | RU0004 | 2024-09-19T12:16:07.058Z | 2024-09-20T12:13:07.002Z |
5132302 | 5132302 | 20240916002823_4ebiN | RU0004 | 2024-09-19T12:16:04.504Z | 2024-09-20T12:13:06.214Z |
5113655 | 5113655 | 20240915010302_N3F7t | RU0004 | 2024-09-18T12:04:37.303Z | 2024-09-20T12:16:00.718Z |
5113267 | 5113267 | 20240915003440_QwqAN | RU0004 | 2024-09-18T12:04:05.282Z | 2024-09-20T12:15:51.836Z |
5113058 | 5113058 | 20240915001742_yX1Nd | RU0004 | 2024-09-18T12:03:53.548Z | 2024-09-20T12:15:45.117Z |
5112761 | 5112761 | 20240914235032_SC9hQ | RU0004 | 2024-09-18T12:03:29.036Z | 2024-09-20T12:15:37.190Z |
5102449 | 5102449 | 20240914012621_gFtem | RU0004 | 2024-09-17T12:07:12.412Z | 2024-09-18T12:12:27.224Z |
5101994 | 5101994 | 20240914005836_wFRlW | RU0004 | 2024-09-17T12:06:37.811Z | 2024-09-20T12:18:51.154Z |
5100366 | 5100366 | 20240913232354_mFN9F | RU0004 | 2024-09-17T12:04:31.088Z | 2024-09-20T12:18:32.261Z |
5100051 | 5100051 | 20240913224443_O2121 | RU0004 | 2024-09-17T12:03:54.984Z | 2024-09-20T12:18:28.797Z |
5100024 | 5100024 | 20240913224134_Nb1qv | RU0004 | 2024-09-17T12:03:52.592Z | 2024-09-20T12:18:27.525Z |
5099533 | 5099533 | 20240913213313_PeHYX | RU0004 | 2024-09-17T12:03:07.901Z | 2024-09-20T12:18:21.686Z |
5052418 | 5052418 | 20240907203730_vAwXN | RU0004 | 2024-09-13T12:15:08.382Z | 2024-09-16T12:21:05.484Z |
5052339 | 5052339 | 20240907202318_kdUDr | RU0004 | 2024-09-13T12:15:04.867Z | 2024-09-16T12:21:05.183Z |
5038740 | 5038740 | 20240905213628_p2u1R | RU0004 | 2024-09-12T12:14:57.334Z | 2024-09-14T12:22:57.459Z |
5032650 | 5032650 | 20240907012559_8PjFu | RU0004 | 2024-09-12T12:07:48.413Z | 2024-09-15T12:21:27.285Z |
5032480 | 5032480 | 20240907010730_uUM6v | RU0004 | 2024-09-12T12:07:23.453Z | 2024-09-15T12:21:26.572Z |
5031888 | 5031888 | 20240906233636_c17bc | RU0004 | 2024-09-12T12:06:00.478Z | 2024-09-15T12:21:24.621Z |
5031748 | 5031748 | 20240906230846_cGlYf | RU0004 | 2024-09-12T12:05:43.612Z | 2024-09-15T12:21:24.209Z |
5031475 | 5031475 | 20240906220355_2tMQ7 | RU0004 | 2024-09-12T12:05:00.587Z | 2024-09-15T12:21:22.674Z |
5025847 | 5025847 | 20240905012832_L3HaN | RU0004 | 2024-09-11T12:11:16.672Z | 2024-09-13T12:19:55.903Z |
5024315 | 5024315 | 20240905213628_N1zdz | RU0004 | 2024-09-11T12:03:18.996Z | 2024-09-11T12:16:32.063Z |
5020286 | 5020286 | 20240905012832_cbLPX | RU0004 | 2024-09-10T12:14:14.128Z | 2024-09-10T12:16:55.118Z |
5020024 | 5020024 | 20240905004128_3DEzq | RU0004 | 2024-09-10T12:13:50.540Z | 2024-09-13T12:19:54.877Z |
5019797 | 5019797 | 20240904235153_guPbT | RU0004 | 2024-09-10T12:13:32.967Z | 2024-09-13T12:19:53.819Z |
5019662 | 5019662 | 20240904232821_L0QrQ | RU0004 | 2024-09-10T12:13:07.502Z | 2024-09-13T12:19:53.291Z |
4920857 | 4920857 | 20240810004007_zZ4uh | RU0004 | 2024-08-30T12:13:42.093Z | 2024-09-02T12:26:41.102Z |
4915338 | 4915338 | 20240809224615_20KHp | RU0004 | 2024-08-30T12:09:50.656Z | 2024-09-02T12:23:54.141Z |
4915247 | 4915247 | 20240809224442_doLjN | RU0004 | 2024-08-30T12:09:47.999Z | 2024-09-02T12:23:53.021Z |
4634721 | 4634721 | 20240712213730_t01Jt | RU0004 | 2024-07-15T12:06:46.329Z | 2024-07-21T12:13:29.763Z |
1747879 | 1747879 | 20221007003903_oOuSA | RU0004 | 2024-01-05T23:50:51.176Z | 2024-01-05T23:50:51.176Z |
1691970 | 1691970 | 20220924212234_jCj6B | RU0004 | 2024-01-05T23:50:26.976Z | 2024-01-05T23:50:26.976Z |
1508464 | 1508464 | 20220808221939_arV3t | RU0004 | 2024-01-05T23:48:53.173Z | 2024-01-05T23:48:53.173Z |
1508373 | 1508373 | 20220808221311_KBDmZ | RU0004 | 2024-01-05T23:48:53.147Z | 2024-01-05T23:48:53.147Z |
1502703 | 1502703 | 20220808004244_Yur6R | RU0004 | 2024-01-05T23:48:49.627Z | 2024-01-05T23:48:49.627Z |
1499639 | 1499639 | 20220807215331_P4eOX | RU0004 | 2024-01-05T23:48:48.908Z | 2024-01-05T23:48:48.908Z |
1499087 | 1499087 | 20220807205043_fbk9P | RU0004 | 2024-01-05T23:48:48.782Z | 2024-01-05T23:48:48.782Z |
1499069 | 1499069 | 20220807204207_8uU2E | RU0004 | 2024-01-05T23:48:48.775Z | 2024-01-05T23:48:48.775Z |
1404135 | 1404135 | 20220707230353_GuHa2 | RU0004 | 2024-01-05T23:47:37.643Z | 2024-01-05T23:47:37.643Z |
1391244 | 1391244 | 20220702220652_3HbpH | RU0004 | 2024-01-05T23:47:25.486Z | 2024-01-05T23:47:25.486Z |
1387174 | 1387174 | 20220630233051_gP1Lt | RU0004 | 2024-01-05T23:47:22.105Z | 2024-01-05T23:47:22.105Z |
1386962 | 1386962 | 20220630223930_hikeG | RU0004 | 2024-01-05T23:47:22.079Z | 2024-01-05T23:47:22.079Z |
1360619 | 1360619 | 20220610233304_DiP2K | RU0004 | 2024-01-05T23:46:53.988Z | 2024-01-05T23:46:53.988Z |
1210860 | 1210860 | 20220306200711_RL0pZ | RU0004 | 2024-01-05T23:42:50.968Z | 2024-01-05T23:42:50.968Z |
977988 | 977988 | 20211126223038_Vs2pE | RU0004 | 2024-01-05T23:39:16.267Z | 2024-01-05T23:39:16.267Z |
977997 | 977997 | 20211126224506_FwY7m | RU0004 | 2024-01-05T23:39:16.267Z | 2024-01-05T23:39:16.267Z |
975404 | 975404 | 20211125214454_0EhYs | RU0004 | 2024-01-05T23:39:14.766Z | 2024-01-05T23:39:14.766Z |
975284 | 975284 | 20211125171402_E3kUv | RU0004 | 2024-01-05T23:39:14.747Z | 2024-01-05T23:39:14.747Z |
975269 | 975269 | 20211125155800_52KGT | RU0004 | 2024-01-05T23:39:14.744Z | 2024-01-05T23:39:14.744Z |
973365 | 973365 | 20211125020525_42kUf | RU0004 | 2024-01-05T23:39:13.326Z | 2024-01-05T23:39:13.326Z |
973285 | 973285 | 20211125014831_NwZDM | RU0004 | 2024-01-05T23:39:13.311Z | 2024-01-05T23:39:13.311Z |
972966 | 972966 | 20211124230003_s2PYJ | RU0004 | 2024-01-05T23:39:13.257Z | 2024-01-05T23:39:13.257Z |
960286 | 960286 | 20211118024859_9uf3r | RU0004 | 2024-01-05T23:38:59.186Z | 2024-01-05T23:38:59.186Z |
960260 | 960260 | 20211118023125_YracY | RU0004 | 2024-01-05T23:38:59.179Z | 2024-01-05T23:38:59.179Z |
960258 | 960258 | 20211118023023_RfK1c | RU0004 | 2024-01-05T23:38:59.178Z | 2024-01-05T23:38:59.178Z |
957760 | 957760 | 20211117022026_hXmMv | RU0004 | 2024-01-05T23:38:56.861Z | 2024-01-05T23:38:56.861Z |
957717 | 957717 | 20211117020409_2YTfP | RU0004 | 2024-01-05T23:38:56.845Z | 2024-01-05T23:38:56.845Z |
957564 | 957564 | 20211117003826_WYm2h | RU0004 | 2024-01-05T23:38:56.790Z | 2024-01-05T23:38:56.790Z |
949029 | 949029 | 20211113010519_9XWp2 | RU0004 | 2024-01-05T23:38:48.575Z | 2024-01-05T23:38:48.575Z |
945984 | 945984 | 20211112022056_0OIZU | RU0004 | 2024-01-05T23:38:46.935Z | 2024-01-05T23:38:46.935Z |
945170 | 945170 | 20211111200905_yZiOP | RU0004 | 2024-01-05T23:38:46.824Z | 2024-01-05T23:38:46.824Z |
927546 | 927546 | 20211107025352_y3FOC | RU0004 | 2024-01-05T23:38:35.531Z | 2024-01-05T23:38:35.531Z |
896097 | 896097 | 20211030233941_10QmE | RU0004 | 2024-01-05T23:38:16.902Z | 2024-01-05T23:38:16.902Z |
895763 | 895763 | 20211030221938_JIQHG | RU0004 | 2024-01-05T23:38:16.864Z | 2024-01-05T23:38:16.864Z |
891452 | 891452 | 20211030012038_nsiYR | RU0004 | 2024-01-05T23:38:14.570Z | 2024-01-05T23:38:14.570Z |
891334 | 891334 | 20211030003113_p2n0v | RU0004 | 2024-01-05T23:38:14.552Z | 2024-01-05T23:38:14.552Z |
891320 | 891320 | 20211030002751_Lqlo6 | RU0004 | 2024-01-05T23:38:14.551Z | 2024-01-05T23:38:14.551Z |
891316 | 891316 | 20211030002639_b8BGh | RU0004 | 2024-01-05T23:38:14.550Z | 2024-01-05T23:38:14.550Z |
882223 | 882223 | 20211028024100_v7IGs | RU0004 | 2024-01-05T23:38:10.706Z | 2024-01-05T23:38:10.706Z |
882206 | 882206 | 20211028023913_BmeE5 | RU0004 | 2024-01-05T23:38:10.704Z | 2024-01-05T23:38:10.704Z |
882162 | 882162 | 20211028023414_LiBHb | RU0004 | 2024-01-05T23:38:10.698Z | 2024-01-05T23:38:10.698Z |
881933 | 881933 | 20211028015615_y68n5 | RU0004 | 2024-01-05T23:38:10.665Z | 2024-01-05T23:38:10.665Z |
881914 | 881914 | 20211028015145_eH6xt | RU0004 | 2024-01-05T23:38:10.662Z | 2024-01-05T23:38:10.662Z |
881769 | 881769 | 20211028012601_lR6oS | RU0004 | 2024-01-05T23:38:10.641Z | 2024-01-05T23:38:10.641Z |
881507 | 881507 | 20211028001332_JMAzT | RU0004 | 2024-01-05T23:38:10.600Z | 2024-01-05T23:38:10.600Z |
881483 | 881483 | 20211028000857_7ft16 | RU0004 | 2024-01-05T23:38:10.596Z | 2024-01-05T23:38:10.596Z |
881373 | 881373 | 20211027233715_mYRs2 | RU0004 | 2024-01-05T23:38:10.581Z | 2024-01-05T23:38:10.581Z |
881101 | 881101 | 20211027221221_THCIV | RU0004 | 2024-01-05T23:38:10.542Z | 2024-01-05T23:38:10.542Z |
881032 | 881032 | 20211027214725_5buQA | RU0004 | 2024-01-05T23:38:10.532Z | 2024-01-05T23:38:10.532Z |
880782 | 880782 | 20211027194143_Zn5QC | RU0004 | 2024-01-05T23:38:10.495Z | 2024-01-05T23:38:10.495Z |
877804 | 877804 | 20211027020306_LBu50 | RU0004 | 2024-01-05T23:38:08.777Z | 2024-01-05T23:38:08.777Z |
877658 | 877658 | 20211027010237_mrGY8 | RU0004 | 2024-01-05T23:38:08.754Z | 2024-01-05T23:38:08.754Z |
877578 | 877578 | 20211027001530_oZAZn | RU0004 | 2024-01-05T23:38:08.741Z | 2024-01-05T23:38:08.741Z |
877565 | 877565 | 20211027000957_OZZPh | RU0004 | 2024-01-05T23:38:08.739Z | 2024-01-05T23:38:08.739Z |
876071 | 876071 | 20211026024557_8EPCh | RU0004 | 2024-01-05T23:38:05.420Z | 2024-01-05T23:38:05.420Z |
876054 | 876054 | 20211026023258_NbMju | RU0004 | 2024-01-05T23:38:05.417Z | 2024-01-05T23:38:05.417Z |
875964 | 875964 | 20211026015421_oNij0 | RU0004 | 2024-01-05T23:38:05.404Z | 2024-01-05T23:38:05.404Z |
875929 | 875929 | 20211026013615_CG67u | RU0004 | 2024-01-05T23:38:05.398Z | 2024-01-05T23:38:05.398Z |
875856 | 875856 | 20211026003532_c9SWf | RU0004 | 2024-01-05T23:38:05.386Z | 2024-01-05T23:38:05.386Z |
875854 | 875854 | 20211026003528_koqYZ | RU0004 | 2024-01-05T23:38:05.385Z | 2024-01-05T23:38:05.385Z |
854444 | 854444 | 20211017023256_Zjazr | RU0004 | 2024-01-05T23:37:51.469Z | 2024-01-05T23:37:51.469Z |
854156 | 854156 | 20211017010247_ogfF9 | RU0004 | 2024-01-05T23:37:51.386Z | 2024-01-05T23:37:51.386Z |
850471 | 850471 | 20211016003710_Y9uq5 | RU0004 | 2024-01-05T23:37:48.557Z | 2024-01-05T23:37:48.557Z |
836412 | 836412 | 20211011213734_kZv26 | RU0004 | 2024-01-05T23:37:36.404Z | 2024-01-05T23:37:36.404Z |
783819 | 783819 | 20210914221130_2L9jx | RU0004 | 2024-01-05T23:36:57.091Z | 2024-01-05T23:36:57.091Z |
773067 | 773067 | 20210911000111_3YZq2 | RU0004 | 2024-01-05T23:36:50.773Z | 2024-01-05T23:36:50.773Z |
773044 | 773044 | 20210910235218_pddvo | RU0004 | 2024-01-05T23:36:50.770Z | 2024-01-05T23:36:50.770Z |
772810 | 772810 | 20210910215448_ysLl7 | RU0004 | 2024-01-05T23:36:50.736Z | 2024-01-05T23:36:50.736Z |
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);