participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "USL012" 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 |
---|---|---|---|---|---|
5568536 | 5568536 | 20241121125616_hm5IF | USL012 | 2024-11-22T14:09:17.653Z | 2024-11-22T14:09:17.653Z |
5568224 | 5568224 | 20241121120848_93ws9 | USL012 | 2024-11-22T14:08:30.792Z | 2024-11-22T14:08:30.792Z |
5568214 | 5568214 | 20241121120621_MBb85 | USL012 | 2024-11-22T14:08:28.235Z | 2024-11-22T14:08:28.235Z |
5568166 | 5568166 | 20241121115739_TrSkz | USL012 | 2024-11-22T14:08:15.164Z | 2024-11-22T14:08:15.164Z |
5568137 | 5568137 | 20241121115403_Nv0Qt | USL012 | 2024-11-22T14:08:11.654Z | 2024-11-22T14:08:11.654Z |
5568102 | 5568102 | 20241121114902_eefnM | USL012 | 2024-11-22T14:08:06.159Z | 2024-11-22T14:08:06.159Z |
5567989 | 5567989 | 20241121113838_l5LtM | USL012 | 2024-11-22T14:07:54.784Z | 2024-11-22T14:07:54.784Z |
5567848 | 5567848 | 20241121111924_g2D9C | USL012 | 2024-11-22T14:07:23.361Z | 2024-11-22T14:07:23.361Z |
5567647 | 5567647 | 20241121104809_XIMhV | USL012 | 2024-11-22T14:06:43.589Z | 2024-11-22T14:06:43.589Z |
5567625 | 5567625 | 20241121104524_33jPC | USL012 | 2024-11-22T14:06:40.760Z | 2024-11-22T14:06:40.760Z |
5567169 | 5567169 | 20241121093636_Otjnw | USL012 | 2024-11-22T14:05:29.508Z | 2024-11-22T14:05:29.508Z |
5567069 | 5567069 | 20241121090843_H0nAE | USL012 | 2024-11-22T14:05:02.741Z | 2024-11-22T14:05:02.741Z |
5566905 | 5566905 | 20241121083306_N2965 | USL012 | 2024-11-22T14:04:26.774Z | 2024-11-22T14:04:26.774Z |
5566903 | 5566903 | 20241121083241_f2WEM | USL012 | 2024-11-22T14:04:25.434Z | 2024-11-22T14:04:25.434Z |
5566711 | 5566711 | 20241121073028_ZjwYN | USL012 | 2024-11-22T14:03:43.089Z | 2024-11-22T14:03:43.089Z |
5566685 | 5566685 | 20241121071829_0XAHz | USL012 | 2024-11-22T14:03:38.804Z | 2024-11-22T14:03:38.804Z |
5566591 | 5566591 | 20241121065427_P798p | USL012 | 2024-11-22T14:03:18.313Z | 2024-11-22T14:03:18.313Z |
5566586 | 5566586 | 20241121065310_Vxbg7 | USL012 | 2024-11-22T14:03:16.646Z | 2024-11-22T14:03:16.646Z |
5566577 | 5566577 | 20241121064914_k1tWo | USL012 | 2024-11-22T14:03:13.338Z | 2024-11-22T14:03:13.338Z |
5566474 | 5566474 | 20241121061947_qJxHS | USL012 | 2024-11-22T14:02:58.432Z | 2024-11-22T14:02:58.432Z |
5566454 | 5566454 | 20241121061425_JMcLj | USL012 | 2024-11-22T14:02:56.027Z | 2024-11-22T14:02:56.027Z |
5560086 | 5560086 | 20241120115745_Ek9P7 | USL012 | 2024-11-21T14:08:00.693Z | 2024-11-22T14:19:21.584Z |
5559608 | 5559608 | 20241120104855_QTe4f | USL012 | 2024-11-21T14:06:42.896Z | 2024-11-22T14:19:21.483Z |
5559317 | 5559317 | 20241120100256_gubr2 | USL012 | 2024-11-21T14:05:57.199Z | 2024-11-22T14:19:21.415Z |
5559261 | 5559261 | 20241120095012_SvlIy | USL012 | 2024-11-21T14:05:45.168Z | 2024-11-22T14:19:21.400Z |
5559230 | 5559230 | 20241120094134_6hiWL | USL012 | 2024-11-21T14:05:39.343Z | 2024-11-22T14:19:21.391Z |
5559138 | 5559138 | 20241120092733_pgcDC | USL012 | 2024-11-21T14:05:26.943Z | 2024-11-22T14:19:21.372Z |
5559134 | 5559134 | 20241120092719_CdsA7 | USL012 | 2024-11-21T14:05:26.586Z | 2024-11-22T14:19:21.371Z |
5559070 | 5559070 | 20241120091414_5Hkp8 | USL012 | 2024-11-21T14:05:13.180Z | 2024-11-22T14:19:21.356Z |
5558998 | 5558998 | 20241120090420_lJTj9 | USL012 | 2024-11-21T14:05:00.463Z | 2024-11-22T14:19:21.344Z |
5558952 | 5558952 | 20241120085622_EhJk7 | USL012 | 2024-11-21T14:04:51.891Z | 2024-11-22T14:19:21.333Z |
5558942 | 5558942 | 20241120085246_dlx2S | USL012 | 2024-11-21T14:04:51.207Z | 2024-11-22T14:19:21.332Z |
5558925 | 5558925 | 20241120085046_pxCXX | USL012 | 2024-11-21T14:04:49.270Z | 2024-11-22T14:19:21.329Z |
5558839 | 5558839 | 20241120082404_O7jP3 | USL012 | 2024-11-21T14:04:34.994Z | 2024-11-22T14:19:21.311Z |
5558762 | 5558762 | 20241120075835_BaOhw | USL012 | 2024-11-21T14:04:18.335Z | 2024-11-22T14:19:21.296Z |
5558014 | 5558014 | 20241120053135_cJF7v | USL012 | 2024-11-21T14:02:18.401Z | 2024-11-22T14:19:21.163Z |
5555236 | 5555236 | 20241119122039_Cpfl9 | USL012 | 2024-11-20T14:04:58.146Z | 2024-11-22T14:20:02.016Z |
5555164 | 5555164 | 20241119115919_7lio9 | USL012 | 2024-11-20T14:04:35.589Z | 2024-11-22T14:20:00.431Z |
5555062 | 5555062 | 20241119112903_x3EZd | USL012 | 2024-11-20T14:04:21.745Z | 2024-11-22T14:19:56.619Z |
5555049 | 5555049 | 20241119112634_CPrKk | USL012 | 2024-11-20T14:04:13.719Z | 2024-11-22T14:19:56.086Z |
5554976 | 5554976 | 20241119111419_IbTnx | USL012 | 2024-11-20T14:03:58.928Z | 2024-11-22T14:19:54.788Z |
5554914 | 5554914 | 20241119110131_quEsz | USL012 | 2024-11-20T14:03:47.706Z | 2024-11-22T14:19:53.864Z |
5554883 | 5554883 | 20241119105502_Y3WlO | USL012 | 2024-11-20T14:03:42.660Z | 2024-11-22T14:19:53.157Z |
5554842 | 5554842 | 20241119104759_a4dUa | USL012 | 2024-11-20T14:03:30.452Z | 2024-11-22T14:19:52.370Z |
5554672 | 5554672 | 20241119100245_Spupy | USL012 | 2024-11-20T14:02:58.702Z | 2024-11-22T14:19:48.576Z |
5554607 | 5554607 | 20241119094744_bTTzJ | USL012 | 2024-11-20T14:02:38.243Z | 2024-11-22T14:19:45.427Z |
5554584 | 5554584 | 20241119094158_N5qb5 | USL012 | 2024-11-20T14:02:32.348Z | 2024-11-22T14:19:44.390Z |
5554477 | 5554477 | 20241119091332_CAdn6 | USL012 | 2024-11-20T14:02:16.003Z | 2024-11-22T14:19:41.620Z |
5554302 | 5554302 | 20241119075855_zub3o | USL012 | 2024-11-20T14:01:26.798Z | 2024-11-22T14:19:35.917Z |
5554289 | 5554289 | 20241119074742_MXnZ4 | USL012 | 2024-11-20T14:01:24.188Z | 2024-11-22T14:19:35.257Z |
5554210 | 5554210 | 20241119070717_PhXZw | USL012 | 2024-11-20T14:01:08.198Z | 2024-11-22T14:19:33.378Z |
5554106 | 5554106 | 20241119060825_86uG0 | USL012 | 2024-11-20T14:00:45.164Z | 2024-11-22T14:19:29.733Z |
5554033 | 5554033 | 20241119053616_uHWrQ | USL012 | 2024-11-20T14:00:29.009Z | 2024-11-22T14:19:27.334Z |
5554018 | 5554018 | 20241119052749_KZrMU | USL012 | 2024-11-20T14:00:24.744Z | 2024-11-22T14:19:26.929Z |
5550405 | 5550405 | 20241118101731_BisD1 | USL012 | 2024-11-19T14:02:18.054Z | 2024-11-22T14:22:02.739Z |
5550372 | 5550372 | 20241118101005_xLtfT | USL012 | 2024-11-19T14:02:14.939Z | 2024-11-22T14:22:01.947Z |
5550220 | 5550220 | 20241118094835_ctw84 | USL012 | 2024-11-19T14:01:47.989Z | 2024-11-22T14:21:59.900Z |
5550161 | 5550161 | 20241118094212_FPq3G | USL012 | 2024-11-19T14:01:40.082Z | 2024-11-22T14:21:59.098Z |
5550147 | 5550147 | 20241118093813_ypnqp | USL012 | 2024-11-19T14:01:38.239Z | 2024-11-22T14:21:58.835Z |
5550062 | 5550062 | 20241118092217_cbGsg | USL012 | 2024-11-19T14:01:31.561Z | 2024-11-22T14:21:57.648Z |
5549976 | 5549976 | 20241118085951_fr8zA | USL012 | 2024-11-19T14:01:23.077Z | 2024-11-22T14:21:55.994Z |
5549962 | 5549962 | 20241118085640_c4akF | USL012 | 2024-11-19T14:01:21.865Z | 2024-11-22T14:21:55.811Z |
5549922 | 5549922 | 20241118084435_mo0v7 | USL012 | 2024-11-19T14:01:14.293Z | 2024-11-22T14:21:55.147Z |
5549913 | 5549913 | 20241118084347_kMPaX | USL012 | 2024-11-19T14:01:13.637Z | 2024-11-22T14:21:55.076Z |
5549895 | 5549895 | 20241118083404_qoYt2 | USL012 | 2024-11-19T14:01:09.368Z | 2024-11-22T14:21:54.773Z |
5548817 | 5548817 | 20241117015047_Nd6Lk | USL012 | 2024-11-18T14:10:16.135Z | 2024-11-22T14:23:16.003Z |
5545889 | 5545889 | 20241117074213_lotbK | USL012 | 2024-11-18T14:01:18.694Z | 2024-11-22T14:22:27.056Z |
5544124 | 5544124 | 20241116063952_lE2Tu | USL012 | 2024-11-17T14:00:16.158Z | 2024-11-22T14:22:59.690Z |
5541559 | 5541559 | 20241114023836_7uUFE | USL012 | 2024-11-15T14:07:51.208Z | 2024-11-22T14:24:19.462Z |
5541515 | 5541515 | 20241114022054_rrPoX | USL012 | 2024-11-15T14:07:46.404Z | 2024-11-22T14:24:19.277Z |
5541018 | 5541018 | 20241114124730_32ne9 | USL012 | 2024-11-15T14:04:56.736Z | 2024-11-22T14:23:54.308Z |
5541004 | 5541004 | 20241114124445_VYI38 | USL012 | 2024-11-15T14:04:55.421Z | 2024-11-22T14:23:54.164Z |
5540987 | 5540987 | 20241114124120_fIVYW | USL012 | 2024-11-15T14:04:54.180Z | 2024-11-22T14:23:53.771Z |
5540812 | 5540812 | 20241114120844_vF965 | USL012 | 2024-11-15T14:04:30.776Z | 2024-11-22T14:23:52.750Z |
5540791 | 5540791 | 20241114120557_g9PC3 | USL012 | 2024-11-15T14:04:28.322Z | 2024-11-22T14:23:52.708Z |
5540758 | 5540758 | 20241114120324_JWJWl | USL012 | 2024-11-15T14:04:25.192Z | 2024-11-22T14:23:52.566Z |
5540443 | 5540443 | 20241114110740_s5A3a | USL012 | 2024-11-15T14:03:49.680Z | 2024-11-22T14:23:51.013Z |
5540256 | 5540256 | 20241114102939_4pvU9 | USL012 | 2024-11-15T14:03:11.819Z | 2024-11-22T14:23:50.120Z |
5540203 | 5540203 | 20241114102226_YNpVq | USL012 | 2024-11-15T14:03:07.325Z | 2024-11-22T14:23:49.495Z |
5539030 | 5539030 | 20241113053414_tN6oK | USL012 | 2024-11-14T14:14:09.055Z | 2024-11-21T14:26:31.041Z |
5538309 | 5538309 | 20241113030644_vk1X2 | USL012 | 2024-11-14T14:13:12.986Z | 2024-11-21T14:26:23.097Z |
5535393 | 5535393 | 20241112122331_7lz8R | USL012 | 2024-11-14T14:07:53.291Z | 2024-11-21T14:25:46.918Z |
5535205 | 5535205 | 20241112115456_m3bcP | USL012 | 2024-11-14T14:07:29.778Z | 2024-11-21T14:25:45.026Z |
5535178 | 5535178 | 20241112115215_k2031 | USL012 | 2024-11-14T14:07:25.879Z | 2024-11-21T14:25:44.522Z |
5535120 | 5535120 | 20241112113955_K8iol | USL012 | 2024-11-14T14:07:16.334Z | 2024-11-21T14:25:43.966Z |
5535113 | 5535113 | 20241112113937_rwC5C | USL012 | 2024-11-14T14:07:16.132Z | 2024-11-21T14:25:43.939Z |
5535086 | 5535086 | 20241112113440_PlGLI | USL012 | 2024-11-14T14:07:12.601Z | 2024-11-21T14:25:43.835Z |
5534400 | 5534400 | 20241113115911_uZO5O | USL012 | 2024-11-14T14:04:21.758Z | 2024-11-22T14:24:13.813Z |
5534220 | 5534220 | 20241113112129_U5z3O | USL012 | 2024-11-14T14:03:50.352Z | 2024-11-22T14:24:13.023Z |
5534133 | 5534133 | 20241113110312_Jjm7J | USL012 | 2024-11-14T14:03:38.911Z | 2024-11-22T14:24:12.499Z |
5534066 | 5534066 | 20241113105328_3JB43 | USL012 | 2024-11-14T14:03:31.009Z | 2024-11-22T14:24:12.177Z |
5534013 | 5534013 | 20241113103813_Loae7 | USL012 | 2024-11-14T14:03:26.125Z | 2024-11-22T14:24:11.989Z |
5533974 | 5533974 | 20241113103310_y25BO | USL012 | 2024-11-14T14:03:22.583Z | 2024-11-22T14:24:11.856Z |
5533708 | 5533708 | 20241113095154_HK1gz | USL012 | 2024-11-14T14:02:40.166Z | 2024-11-22T14:24:10.799Z |
5533479 | 5533479 | 20241113090612_utAhH | USL012 | 2024-11-14T14:02:05.936Z | 2024-11-22T14:24:09.567Z |
5533441 | 5533441 | 20241113085718_2VWxK | USL012 | 2024-11-14T14:02:00.138Z | 2024-11-22T14:24:09.364Z |
5533394 | 5533394 | 20241113084736_G742A | USL012 | 2024-11-14T14:01:52.938Z | 2024-11-22T14:24:08.956Z |
5533073 | 5533073 | 20241113070532_fEfUd | USL012 | 2024-11-14T14:01:03.960Z | 2024-11-22T14:24:06.929Z |
5532162 | 5532162 | 20241112044553_YPvLm | USL012 | 2024-11-13T14:16:23.756Z | 2024-11-20T14:26:20.511Z |
5527038 | 5527038 | 20241112105041_tq0VK | USL012 | 2024-11-13T14:04:54.102Z | 2024-11-21T14:25:40.762Z |
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);