participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,305 rows where station_code = "US003T" 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 |
---|---|---|---|---|---|
5563667 | 5563667 | 20241120015612_kugBq | US003T | 2024-11-21T14:16:33.115Z | 2024-11-21T14:18:53.898Z |
5563664 | 5563664 | 20241120015612_Z7tpu | US003T | 2024-11-21T14:16:32.971Z | 2024-11-21T14:18:53.898Z |
5560413 | 5560413 | 20241120124845_wk3zR | US003T | 2024-11-21T14:08:48.482Z | 2024-11-21T14:08:48.482Z |
5560361 | 5560361 | 20241120124206_8CPj5 | US003T | 2024-11-21T14:08:44.400Z | 2024-11-21T14:08:44.400Z |
5560352 | 5560352 | 20241120124126_IXIGQ | US003T | 2024-11-21T14:08:42.825Z | 2024-11-21T14:08:42.825Z |
5560309 | 5560309 | 20241120123322_Tap3g | US003T | 2024-11-21T14:08:34.843Z | 2024-11-21T14:08:34.843Z |
5560300 | 5560300 | 20241120123237_GalAj | US003T | 2024-11-21T14:08:33.426Z | 2024-11-21T14:08:33.426Z |
5560299 | 5560299 | 20241120123210_S8hHK | US003T | 2024-11-21T14:08:33.162Z | 2024-11-21T14:08:33.162Z |
5560164 | 5560164 | 20241120120921_vuXO6 | US003T | 2024-11-21T14:08:10.161Z | 2024-11-21T14:08:10.161Z |
5559933 | 5559933 | 20241120113555_Zrbn3 | US003T | 2024-11-21T14:07:36.164Z | 2024-11-21T14:07:36.164Z |
5559539 | 5559539 | 20241120103921_ShKxG | US003T | 2024-11-21T14:06:33.336Z | 2024-11-21T14:06:33.336Z |
5559418 | 5559418 | 20241120102055_y74fx | US003T | 2024-11-21T14:06:16.836Z | 2024-11-21T14:06:16.836Z |
5559205 | 5559205 | 20241120093740_uhPWs | US003T | 2024-11-21T14:05:36.141Z | 2024-11-21T14:05:36.141Z |
5559158 | 5559158 | 20241120093052_jitOH | US003T | 2024-11-21T14:05:29.765Z | 2024-11-21T14:05:29.765Z |
5559075 | 5559075 | 20241120091701_8NIQG | US003T | 2024-11-21T14:05:14.436Z | 2024-11-21T14:05:14.436Z |
5559020 | 5559020 | 20241120090532_UeljT | US003T | 2024-11-21T14:05:04.078Z | 2024-11-21T14:05:04.078Z |
5558399 | 5558399 | 20241120060149_4Ol7n | US003T | 2024-11-21T14:03:11.757Z | 2024-11-21T14:03:11.757Z |
5558364 | 5558364 | 20241120055914_ojZjX | US003T | 2024-11-21T14:03:07.495Z | 2024-11-21T14:03:07.495Z |
5557204 | 5557204 | 20241119043158_PBTSm | US003T | 2024-11-20T14:12:27.527Z | 2024-11-21T14:20:49.515Z |
5556764 | 5556764 | 20241119014549_QEDh2 | US003T | 2024-11-20T14:11:26.367Z | 2024-11-21T14:20:34.743Z |
5554828 | 5554828 | 20241119104527_zDAeM | US003T | 2024-11-20T14:03:24.709Z | 2024-11-21T14:18:53.142Z |
5554644 | 5554644 | 20241119095357_9cdtI | US003T | 2024-11-20T14:02:55.257Z | 2024-11-21T14:18:53.101Z |
5554604 | 5554604 | 20241119094740_iaLxl | US003T | 2024-11-20T14:02:37.136Z | 2024-11-21T14:18:53.092Z |
5554550 | 5554550 | 20241119093258_Agdn5 | US003T | 2024-11-20T14:02:25.744Z | 2024-11-21T14:18:53.079Z |
5554295 | 5554295 | 20241119075108_V8Ge7 | US003T | 2024-11-20T14:01:25.408Z | 2024-11-21T14:18:53.021Z |
5544513 | 5544513 | 20241116120324_gSWAz | US003T | 2024-11-17T14:01:21.813Z | 2024-11-21T14:22:35.407Z |
5544474 | 5544474 | 20241116114047_v1YKd | US003T | 2024-11-17T14:01:15.714Z | 2024-11-21T14:22:34.468Z |
5544409 | 5544409 | 20241116105328_fdrNw | US003T | 2024-11-17T14:01:02.844Z | 2024-11-21T14:22:33.300Z |
5544372 | 5544372 | 20241116102928_bWE6l | US003T | 2024-11-17T14:00:57.993Z | 2024-11-21T14:22:32.441Z |
5544202 | 5544202 | 20241116080742_cKmTO | US003T | 2024-11-17T14:00:26.887Z | 2024-11-21T14:22:28.508Z |
5544189 | 5544189 | 20241116075142_2wBgP | US003T | 2024-11-17T14:00:25.145Z | 2024-11-21T14:22:28.377Z |
5544181 | 5544181 | 20241116073220_d4x7f | US003T | 2024-11-17T14:00:23.990Z | 2024-11-21T14:22:28.339Z |
5544080 | 5544080 | 20241116053724_UKcct | US003T | 2024-11-17T14:00:08.986Z | 2024-11-21T14:22:26.645Z |
5542695 | 5542695 | 20241115115210_dSeK5 | US003T | 2024-11-16T14:02:12.603Z | 2024-11-21T14:23:33.305Z |
5542650 | 5542650 | 20241115113108_K8SxK | US003T | 2024-11-16T14:02:06.856Z | 2024-11-21T14:23:32.441Z |
5542400 | 5542400 | 20241115091334_Baq5G | US003T | 2024-11-16T14:01:09.512Z | 2024-11-21T14:23:26.556Z |
5542373 | 5542373 | 20241115090014_TBfhJ | US003T | 2024-11-16T14:01:05.585Z | 2024-11-21T14:23:26.250Z |
5542317 | 5542317 | 20241115082402_7as0Z | US003T | 2024-11-16T14:00:57.570Z | 2024-11-21T14:23:25.248Z |
5542190 | 5542190 | 20241115065826_9VgqP | US003T | 2024-11-16T14:00:34.564Z | 2024-11-21T14:23:22.491Z |
5542178 | 5542178 | 20241115064110_gYiXM | US003T | 2024-11-16T14:00:30.707Z | 2024-11-21T14:23:21.993Z |
5542037 | 5542037 | 20241114053112_3hOCI | US003T | 2024-11-15T14:08:49.220Z | 2024-11-21T14:25:21.669Z |
5540999 | 5540999 | 20241114124222_VNsGI | US003T | 2024-11-15T14:04:54.906Z | 2024-11-21T14:24:18.167Z |
5540764 | 5540764 | 20241114120326_S62gV | US003T | 2024-11-15T14:04:25.765Z | 2024-11-21T14:24:15.578Z |
5540332 | 5540332 | 20241114103734_plyda | US003T | 2024-11-15T14:03:26.832Z | 2024-11-21T14:24:10.361Z |
5540295 | 5540295 | 20241114103439_LKcuC | US003T | 2024-11-15T14:03:17.511Z | 2024-11-21T14:24:10.089Z |
5540247 | 5540247 | 20241114102811_HRCb3 | US003T | 2024-11-15T14:03:11.117Z | 2024-11-21T14:24:09.378Z |
5540002 | 5540002 | 20241114094710_ndT6p | US003T | 2024-11-15T14:02:31.238Z | 2024-11-21T14:24:06.585Z |
5539952 | 5539952 | 20241114093652_5gMLC | US003T | 2024-11-15T14:02:23.804Z | 2024-11-21T14:24:05.464Z |
5539744 | 5539744 | 20241114084953_cK7zQ | US003T | 2024-11-15T14:01:48.990Z | 2024-11-21T14:24:00.665Z |
5539660 | 5539660 | 20241114082425_19txB | US003T | 2024-11-15T14:01:37.499Z | 2024-11-21T14:23:59.160Z |
5539592 | 5539592 | 20241114080132_T0BNV | US003T | 2024-11-15T14:01:29.519Z | 2024-11-21T14:23:57.911Z |
5539381 | 5539381 | 20241114063744_B135G | US003T | 2024-11-15T14:00:52.260Z | 2024-11-21T14:23:54.654Z |
5539220 | 5539220 | 20241114055013_Uj1k6 | US003T | 2024-11-15T14:00:23.100Z | 2024-11-21T14:23:51.356Z |
5539201 | 5539201 | 20241114054913_vxgNM | US003T | 2024-11-15T14:00:21.398Z | 2024-11-21T14:23:51.157Z |
5539161 | 5539161 | 20241114054258_VSvVk | US003T | 2024-11-15T14:00:14.897Z | 2024-11-21T14:23:49.805Z |
5538827 | 5538827 | 20241113050257_Ufq63 | US003T | 2024-11-14T14:13:59.249Z | 2024-11-21T14:26:28.855Z |
5538650 | 5538650 | 20241113043111_VoX2G | US003T | 2024-11-14T14:13:46.765Z | 2024-11-21T14:26:28.347Z |
5538225 | 5538225 | 20241113024222_o462Q | US003T | 2024-11-14T14:13:06.035Z | 2024-11-21T14:26:21.834Z |
5538152 | 5538152 | 20241113022259_y2Op6 | US003T | 2024-11-14T14:12:56.609Z | 2024-11-21T14:26:21.105Z |
5535171 | 5535171 | 20241112115203_jE6xW | US003T | 2024-11-14T14:07:24.909Z | 2024-11-21T14:25:44.491Z |
5535076 | 5535076 | 20241112113331_5nONw | US003T | 2024-11-14T14:07:10.512Z | 2024-11-21T14:25:43.667Z |
5534974 | 5534974 | 20241112111906_xij5L | US003T | 2024-11-14T14:07:02.999Z | 2024-11-21T14:25:42.723Z |
5534969 | 5534969 | 20241112111739_NZepz | US003T | 2024-11-14T14:07:02.491Z | 2024-11-21T14:25:42.708Z |
5534907 | 5534907 | 20241112110715_AtEzP | US003T | 2024-11-14T14:06:58.210Z | 2024-11-21T14:25:41.521Z |
5534438 | 5534438 | 20241113120735_zxJKy | US003T | 2024-11-14T14:04:24.639Z | 2024-11-21T14:25:02.175Z |
5534300 | 5534300 | 20241113113809_Oqd0b | US003T | 2024-11-14T14:04:07.779Z | 2024-11-21T14:25:00.628Z |
5534297 | 5534297 | 20241113113804_MMzkM | US003T | 2024-11-14T14:04:06.621Z | 2024-11-21T14:25:00.610Z |
5534279 | 5534279 | 20241113113256_XdcTr | US003T | 2024-11-14T14:04:02.968Z | 2024-11-21T14:25:00.403Z |
5534160 | 5534160 | 20241113111047_Iho83 | US003T | 2024-11-14T14:03:41.138Z | 2024-11-21T14:24:59.544Z |
5534141 | 5534141 | 20241113110650_93zIn | US003T | 2024-11-14T14:03:39.365Z | 2024-11-21T14:24:59.247Z |
5534120 | 5534120 | 20241113110158_euapT | US003T | 2024-11-14T14:03:35.489Z | 2024-11-21T14:24:58.984Z |
5534086 | 5534086 | 20241113105607_IO0sy | US003T | 2024-11-14T14:03:32.225Z | 2024-11-21T14:24:58.670Z |
5534043 | 5534043 | 20241113105102_Y3Hvs | US003T | 2024-11-14T14:03:29.296Z | 2024-11-21T14:24:58.414Z |
5533874 | 5533874 | 20241113102153_qskJd | US003T | 2024-11-14T14:03:07.904Z | 2024-11-21T14:24:56.453Z |
5533763 | 5533763 | 20241113100301_AaCXf | US003T | 2024-11-14T14:02:45.786Z | 2024-11-21T14:24:54.821Z |
5533706 | 5533706 | 20241113095116_rfkTe | US003T | 2024-11-14T14:02:39.900Z | 2024-11-21T14:24:54.343Z |
5533681 | 5533681 | 20241113094416_Y3HJp | US003T | 2024-11-14T14:02:37.211Z | 2024-11-21T14:24:54.172Z |
5533649 | 5533649 | 20241113093836_3ghIG | US003T | 2024-11-14T14:02:33.861Z | 2024-11-21T14:24:53.788Z |
5533476 | 5533476 | 20241113090604_YypLc | US003T | 2024-11-14T14:02:05.384Z | 2024-11-21T14:24:50.474Z |
5533407 | 5533407 | 20241113084855_2PTl2 | US003T | 2024-11-14T14:01:54.413Z | 2024-11-21T14:24:49.462Z |
5533303 | 5533303 | 20241113082547_76QuY | US003T | 2024-11-14T14:01:40.779Z | 2024-11-21T14:24:47.976Z |
5533107 | 5533107 | 20241113071628_wpOuS | US003T | 2024-11-14T14:01:08.960Z | 2024-11-21T14:24:45.477Z |
5532990 | 5532990 | 20241113063558_3ugg9 | US003T | 2024-11-14T14:00:44.336Z | 2024-11-21T14:24:42.992Z |
5532688 | 5532688 | 20241112055304_3ZmUc | US003T | 2024-11-13T14:17:09.564Z | 2024-11-20T14:26:25.676Z |
5532532 | 5532532 | 20241112053521_GC53e | US003T | 2024-11-13T14:16:57.688Z | 2024-11-20T14:26:24.285Z |
5531936 | 5531936 | 20241112042105_AiCdK | US003T | 2024-11-13T14:16:02.975Z | 2024-11-20T14:26:16.256Z |
5526914 | 5526914 | 20241112102854_PlHDZ | US003T | 2024-11-13T14:04:32.228Z | 2024-11-21T14:25:39.638Z |
5526778 | 5526778 | 20241112101441_HohES | US003T | 2024-11-13T14:04:08.465Z | 2024-11-21T14:25:38.414Z |
5526426 | 5526426 | 20241112091740_TpitK | US003T | 2024-11-13T14:02:58.713Z | 2024-11-21T14:25:34.871Z |
5526243 | 5526243 | 20241112084246_MHOoO | US003T | 2024-11-13T14:02:22.851Z | 2024-11-21T14:25:33.062Z |
5526133 | 5526133 | 20241112081335_T1ebG | US003T | 2024-11-13T14:01:58.993Z | 2024-11-21T14:25:30.648Z |
5525870 | 5525870 | 20241112070625_JgpMw | US003T | 2024-11-13T14:01:02.261Z | 2024-11-21T14:25:28.569Z |
5525781 | 5525781 | 20241112063550_hscjn | US003T | 2024-11-13T14:00:44.203Z | 2024-11-21T14:25:26.591Z |
5525714 | 5525714 | 20241112061452_Z3jAa | US003T | 2024-11-13T14:00:26.661Z | 2024-11-21T14:25:25.655Z |
5524834 | 5524834 | 20241111055811_uRKfy | US003T | 2024-11-12T14:18:02.781Z | 2024-11-19T14:22:24.271Z |
5524738 | 5524738 | 20241111052455_3oCrr | US003T | 2024-11-12T14:17:58.717Z | 2024-11-19T14:22:23.653Z |
5524698 | 5524698 | 20241111051415_0tICo | US003T | 2024-11-12T14:17:55.769Z | 2024-11-19T14:22:23.423Z |
5524515 | 5524515 | 20241111042414_2RaWR | US003T | 2024-11-12T14:17:30.810Z | 2024-11-19T14:22:21.866Z |
5524020 | 5524020 | 20241111030219_qt2pQ | US003T | 2024-11-12T14:16:27.952Z | 2024-11-19T14:22:16.581Z |
5523943 | 5523943 | 20241111025101_rifwq | US003T | 2024-11-12T14:16:21.481Z | 2024-11-19T14:22:16.039Z |
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);