participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "US0005" 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 |
---|---|---|---|---|---|
5486463 | 5486463 | 20241106114648_kk8RW | US0005 | 2024-11-07T14:03:03.745Z | 2024-11-09T14:16:47.158Z |
5486356 | 5486356 | 20241106110552_pEgMM | US0005 | 2024-11-07T14:02:41.859Z | 2024-11-09T14:16:43.485Z |
5486330 | 5486330 | 20241106104857_dydhR | US0005 | 2024-11-07T14:02:38.211Z | 2024-11-09T14:16:42.757Z |
5486245 | 5486245 | 20241106101357_aF2nS | US0005 | 2024-11-07T14:02:19.322Z | 2024-11-09T14:16:40.204Z |
5486243 | 5486243 | 20241106101354_1M2Yk | US0005 | 2024-11-07T14:02:18.617Z | 2024-11-09T14:16:40.157Z |
5486232 | 5486232 | 20241106100956_Q6bJF | US0005 | 2024-11-07T14:02:17.087Z | 2024-11-09T14:16:40.047Z |
5486230 | 5486230 | 20241106100849_QjnIk | US0005 | 2024-11-07T14:02:16.769Z | 2024-11-09T14:16:40.020Z |
5486165 | 5486165 | 20241106095654_3oLJ2 | US0005 | 2024-11-07T14:02:06.800Z | 2024-11-09T14:16:38.965Z |
5486159 | 5486159 | 20241106095456_NTAIT | US0005 | 2024-11-07T14:02:06.050Z | 2024-11-09T14:16:38.914Z |
5486156 | 5486156 | 20241106095421_0G7FN | US0005 | 2024-11-07T14:02:05.587Z | 2024-11-09T14:16:38.813Z |
5486152 | 5486152 | 20241106095349_0B23l | US0005 | 2024-11-07T14:02:04.734Z | 2024-11-09T14:16:38.750Z |
5486003 | 5486003 | 20241106090549_82nPx | US0005 | 2024-11-07T14:01:27.740Z | 2024-11-09T14:16:35.953Z |
5485904 | 5485904 | 20241106082758_gowu6 | US0005 | 2024-11-07T14:01:05.724Z | 2024-11-09T14:16:34.265Z |
5485871 | 5485871 | 20241106080756_iEnlm | US0005 | 2024-11-07T14:00:54.782Z | 2024-11-09T14:16:33.792Z |
5485718 | 5485718 | 20241106065614_5bVRf | US0005 | 2024-11-07T14:00:23.484Z | 2024-11-09T14:16:31.065Z |
5485693 | 5485693 | 20241106064607_Qq7ae | US0005 | 2024-11-07T14:00:17.666Z | 2024-11-09T14:16:30.780Z |
5485528 | 5485528 | 20241105061800_bwDj6 | US0005 | 2024-11-06T14:18:25.394Z | 2024-11-09T14:21:22.613Z |
5485518 | 5485518 | 20241105061551_4b5l4 | US0005 | 2024-11-06T14:18:24.224Z | 2024-11-09T14:21:22.518Z |
5485460 | 5485460 | 20241105054732_OPJt0 | US0005 | 2024-11-06T14:18:19.704Z | 2024-11-09T14:21:21.758Z |
5480369 | 5480369 | 20241105123713_wRnFS | US0005 | 2024-11-06T14:05:21.957Z | 2024-11-09T14:19:23.363Z |
5480324 | 5480324 | 20241105122605_B5sCk | US0005 | 2024-11-06T14:05:15.410Z | 2024-11-09T14:19:22.842Z |
5480299 | 5480299 | 20241105121911_RciBR | US0005 | 2024-11-06T14:05:11.370Z | 2024-11-09T14:19:22.396Z |
5480281 | 5480281 | 20241105121535_GPLI2 | US0005 | 2024-11-06T14:05:08.153Z | 2024-11-09T14:19:22.032Z |
5480274 | 5480274 | 20241105121246_6sgI0 | US0005 | 2024-11-06T14:05:06.970Z | 2024-11-09T14:19:21.710Z |
5480228 | 5480228 | 20241105120407_U7Il9 | US0005 | 2024-11-06T14:05:00.287Z | 2024-11-09T14:19:20.629Z |
5480160 | 5480160 | 20241105115428_P2wY4 | US0005 | 2024-11-06T14:04:41.617Z | 2024-11-09T14:19:19.707Z |
5480157 | 5480157 | 20241105115343_IVoAK | US0005 | 2024-11-06T14:04:40.737Z | 2024-11-09T14:19:19.449Z |
5480149 | 5480149 | 20241105114745_0VzXG | US0005 | 2024-11-06T14:04:39.025Z | 2024-11-09T14:19:19.155Z |
5480132 | 5480132 | 20241105114600_F7VqO | US0005 | 2024-11-06T14:04:35.410Z | 2024-11-09T14:19:18.725Z |
5480126 | 5480126 | 20241105114509_KP6ac | US0005 | 2024-11-06T14:04:34.405Z | 2024-11-09T14:19:18.591Z |
5480108 | 5480108 | 20241105113937_Lyo7s | US0005 | 2024-11-06T14:04:31.730Z | 2024-11-09T14:19:17.870Z |
5480100 | 5480100 | 20241105113840_RbvTv | US0005 | 2024-11-06T14:04:30.551Z | 2024-11-09T14:19:17.417Z |
5480092 | 5480092 | 20241105113508_BJqpd | US0005 | 2024-11-06T14:04:29.671Z | 2024-11-09T14:19:17.316Z |
5480032 | 5480032 | 20241105112428_WQg7G | US0005 | 2024-11-06T14:04:21.546Z | 2024-11-09T14:19:15.560Z |
5480019 | 5480019 | 20241105111800_8wPQP | US0005 | 2024-11-06T14:04:19.680Z | 2024-11-09T14:19:15.105Z |
5480010 | 5480010 | 20241105111740_D8AhN | US0005 | 2024-11-06T14:04:18.896Z | 2024-11-09T14:19:15.055Z |
5479969 | 5479969 | 20241105111043_DF3Cq | US0005 | 2024-11-06T14:04:11.847Z | 2024-11-09T14:19:14.598Z |
5479921 | 5479921 | 20241105105935_PrJMA | US0005 | 2024-11-06T14:03:54.131Z | 2024-11-09T14:19:13.944Z |
5479857 | 5479857 | 20241105105359_6eHBi | US0005 | 2024-11-06T14:03:45.776Z | 2024-11-09T14:19:13.281Z |
5479787 | 5479787 | 20241105104137_zEgyc | US0005 | 2024-11-06T14:03:35.281Z | 2024-11-09T14:19:12.396Z |
5479729 | 5479729 | 20241105102751_8yGN5 | US0005 | 2024-11-06T14:03:18.719Z | 2024-11-09T14:19:10.903Z |
5479721 | 5479721 | 20241105102541_PN3xI | US0005 | 2024-11-06T14:03:14.876Z | 2024-11-09T14:19:10.762Z |
5479625 | 5479625 | 20241105100703_x5Z2j | US0005 | 2024-11-06T14:02:55.157Z | 2024-11-09T14:19:09.944Z |
5479594 | 5479594 | 20241105100326_z33Kt | US0005 | 2024-11-06T14:02:51.214Z | 2024-11-09T14:19:09.558Z |
5479498 | 5479498 | 20241105094359_uUBTe | US0005 | 2024-11-06T14:02:28.344Z | 2024-11-09T14:19:07.216Z |
5479479 | 5479479 | 20241105093800_PakfF | US0005 | 2024-11-06T14:02:23.557Z | 2024-11-09T14:19:06.802Z |
5479463 | 5479463 | 20241105093526_cRf92 | US0005 | 2024-11-06T14:02:21.886Z | 2024-11-09T14:19:06.566Z |
5479461 | 5479461 | 20241105093448_E2902 | US0005 | 2024-11-06T14:02:21.480Z | 2024-11-09T14:19:06.558Z |
5479453 | 5479453 | 20241105093154_Lno70 | US0005 | 2024-11-06T14:02:18.868Z | 2024-11-09T14:19:06.324Z |
5479446 | 5479446 | 20241105093026_gwNu8 | US0005 | 2024-11-06T14:02:18.041Z | 2024-11-09T14:19:06.298Z |
5479431 | 5479431 | 20241105092631_oMGpn | US0005 | 2024-11-06T14:02:15.436Z | 2024-11-09T14:19:06.083Z |
5479420 | 5479420 | 20241105092550_UO84u | US0005 | 2024-11-06T14:02:14.496Z | 2024-11-09T14:19:06.014Z |
5479403 | 5479403 | 20241105091854_24qDs | US0005 | 2024-11-06T14:02:12.327Z | 2024-11-09T14:19:05.840Z |
5479380 | 5479380 | 20241105091506_ikF9a | US0005 | 2024-11-06T14:02:09.458Z | 2024-11-09T14:19:05.344Z |
5479357 | 5479357 | 20241105091103_bEoW7 | US0005 | 2024-11-06T14:02:05.985Z | 2024-11-09T14:19:04.773Z |
5479303 | 5479303 | 20241105090130_lcJCZ | US0005 | 2024-11-06T14:01:51.207Z | 2024-11-09T14:19:03.816Z |
5479298 | 5479298 | 20241105090113_pttdl | US0005 | 2024-11-06T14:01:49.695Z | 2024-11-09T14:19:03.771Z |
5479282 | 5479282 | 20241105085643_n213q | US0005 | 2024-11-06T14:01:44.301Z | 2024-11-09T14:19:03.354Z |
5479234 | 5479234 | 20241105083846_6sH9o | US0005 | 2024-11-06T14:01:35.287Z | 2024-11-09T14:19:02.262Z |
5479195 | 5479195 | 20241105082828_3mFCU | US0005 | 2024-11-06T14:01:27.109Z | 2024-11-09T14:19:01.257Z |
5479143 | 5479143 | 20241105081635_z3jTq | US0005 | 2024-11-06T14:01:13.776Z | 2024-11-09T14:19:00.147Z |
5479109 | 5479109 | 20241105080656_6d5F0 | US0005 | 2024-11-06T14:01:02.060Z | 2024-11-09T14:18:59.550Z |
5479070 | 5479070 | 20241105075122_llG2t | US0005 | 2024-11-06T14:00:54.611Z | 2024-11-09T14:18:59.203Z |
5479059 | 5479059 | 20241105074156_N07BM | US0005 | 2024-11-06T14:00:51.642Z | 2024-11-09T14:18:59.055Z |
5478909 | 5478909 | 20241105065230_nin5a | US0005 | 2024-11-06T14:00:19.960Z | 2024-11-09T14:18:56.784Z |
5478903 | 5478903 | 20241105065223_wIfa5 | US0005 | 2024-11-06T14:00:18.939Z | 2024-11-09T14:18:56.598Z |
5469093 | 5469093 | 20241103023620_ODcf2 | US0005 | 2024-11-04T14:15:36.044Z | 2024-11-09T14:23:00.963Z |
5465513 | 5465513 | 20241103123647_6NVKz | US0005 | 2024-11-04T14:03:51.845Z | 2024-11-09T14:21:34.879Z |
5464003 | 5464003 | 20241102063256_pJA92 | US0005 | 2024-11-03T14:19:29.104Z | 2024-11-09T14:23:45.256Z |
5463949 | 5463949 | 20241102061902_xtZ3W | US0005 | 2024-11-03T14:19:26.842Z | 2024-11-09T14:23:44.972Z |
5463922 | 5463922 | 20241102061318_x9SBj | US0005 | 2024-11-03T14:19:25.704Z | 2024-11-09T14:23:44.580Z |
5463911 | 5463911 | 20241102060906_SWjwb | US0005 | 2024-11-03T14:19:24.805Z | 2024-11-09T14:23:44.552Z |
5463878 | 5463878 | 20241102055651_zLus6 | US0005 | 2024-11-03T14:19:21.826Z | 2024-11-09T14:23:44.353Z |
5463858 | 5463858 | 20241102054630_00Vfg | US0005 | 2024-11-03T14:19:21.176Z | 2024-11-09T14:23:44.204Z |
5463818 | 5463818 | 20241102052222_VqlMJ | US0005 | 2024-11-03T14:19:18.464Z | 2024-11-09T14:23:44.049Z |
5463708 | 5463708 | 20241102044153_zt87q | US0005 | 2024-11-03T14:19:11.362Z | 2024-11-09T14:23:43.546Z |
5462747 | 5462747 | 20241102012133_nAJKs | US0005 | 2024-11-03T14:18:02.475Z | 2024-11-09T14:23:36.028Z |
5460024 | 5460024 | 20241101123131_0X2vk | US0005 | 2024-11-03T14:13:11.582Z | 2024-11-09T14:23:22.019Z |
5459966 | 5459966 | 20241101122509_xBVZ8 | US0005 | 2024-11-03T14:12:59.208Z | 2024-11-09T14:23:21.581Z |
5459847 | 5459847 | 20241101120131_CgMdt | US0005 | 2024-11-03T14:12:39.775Z | 2024-11-09T14:23:21.124Z |
5459845 | 5459845 | 20241101120042_TyPFA | US0005 | 2024-11-03T14:12:39.614Z | 2024-11-09T14:23:21.123Z |
5459837 | 5459837 | 20241101115950_xG9He | US0005 | 2024-11-03T14:12:39.110Z | 2024-11-09T14:23:21.107Z |
5459780 | 5459780 | 20241101114938_MJ0oM | US0005 | 2024-11-03T14:12:35.495Z | 2024-11-09T14:23:20.841Z |
5459759 | 5459759 | 20241101114836_DK35I | US0005 | 2024-11-03T14:12:34.333Z | 2024-11-09T14:23:20.609Z |
5459682 | 5459682 | 20241101113726_Q6G8y | US0005 | 2024-11-03T14:12:28.112Z | 2024-11-09T14:23:20.194Z |
5459648 | 5459648 | 20241101112937_ERzSN | US0005 | 2024-11-03T14:12:24.643Z | 2024-11-09T14:23:20.057Z |
5459637 | 5459637 | 20241101112816_m6nlG | US0005 | 2024-11-03T14:12:23.783Z | 2024-11-09T14:23:20.052Z |
5459618 | 5459618 | 20241101112433_QEcPd | US0005 | 2024-11-03T14:12:22.341Z | 2024-11-09T14:23:19.999Z |
5459577 | 5459577 | 20241101111929_avoKq | US0005 | 2024-11-03T14:12:19.797Z | 2024-11-09T14:23:19.869Z |
5459558 | 5459558 | 20241101111741_uleQp | US0005 | 2024-11-03T14:12:17.596Z | 2024-11-09T14:23:19.469Z |
5459531 | 5459531 | 20241101111353_drlyj | US0005 | 2024-11-03T14:12:14.964Z | 2024-11-09T14:23:18.875Z |
5459454 | 5459454 | 20241101110142_e263b | US0005 | 2024-11-03T14:11:57.411Z | 2024-11-09T14:23:18.013Z |
5459393 | 5459393 | 20241101105438_KImmH | US0005 | 2024-11-03T14:11:49.071Z | 2024-11-09T14:23:17.731Z |
5459123 | 5459123 | 20241101101115_dSI2I | US0005 | 2024-11-03T14:11:21.926Z | 2024-11-09T14:23:16.498Z |
5459001 | 5459001 | 20241101095704_bNb1C | US0005 | 2024-11-03T14:10:57.705Z | 2024-11-09T14:23:15.648Z |
5458981 | 5458981 | 20241101095259_mWroP | US0005 | 2024-11-03T14:10:54.747Z | 2024-11-09T14:23:15.604Z |
5458963 | 5458963 | 20241101095128_74M3f | US0005 | 2024-11-03T14:10:52.946Z | 2024-11-09T14:23:15.573Z |
5458867 | 5458867 | 20241101093124_VQi9u | US0005 | 2024-11-03T14:10:44.330Z | 2024-11-09T14:23:14.786Z |
5458841 | 5458841 | 20241101092532_gWN18 | US0005 | 2024-11-03T14:10:41.785Z | 2024-11-09T14:23:14.711Z |
5458800 | 5458800 | 20241101091936_KJoUL | US0005 | 2024-11-03T14:10:38.526Z | 2024-11-09T14:23:14.579Z |
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);