participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
41,491 rows where station_code = "US000L" 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 |
---|---|---|---|---|---|
5134109 | 5134109 | 20240916050716_2S6ow | US000L | 2024-09-19T12:17:21.574Z | 2024-09-19T12:17:21.574Z |
5134046 | 5134046 | 20240916043518_hAAPv | US000L | 2024-09-19T12:17:17.080Z | 2024-09-19T12:17:17.080Z |
5133821 | 5133821 | 20240916040758_OMDe3 | US000L | 2024-09-19T12:17:09.844Z | 2024-09-19T12:17:09.844Z |
5133739 | 5133739 | 20240916040148_Up4Tn | US000L | 2024-09-19T12:17:06.892Z | 2024-09-19T12:17:06.892Z |
5129944 | 5129944 | 20240917064234_2GZzG | US000L | 2024-09-19T12:12:18.832Z | 2024-09-19T12:12:18.832Z |
5129840 | 5129840 | 20240917043855_vB1FF | US000L | 2024-09-19T12:12:08.841Z | 2024-09-19T12:12:08.841Z |
5129159 | 5129159 | 20240917033054_wfXY2 | US000L | 2024-09-19T12:11:18.254Z | 2024-09-19T12:11:18.254Z |
5126448 | 5126448 | 20240918115353_WHZhA | US000L | 2024-09-19T12:05:58.642Z | 2024-09-19T12:06:42.202Z |
5126385 | 5126385 | 20240918112119_CXi3k | US000L | 2024-09-19T12:05:52.460Z | 2024-09-19T12:06:42.192Z |
5126374 | 5126374 | 20240918111823_KB2wT | US000L | 2024-09-19T12:05:51.370Z | 2024-09-19T12:06:42.191Z |
5126268 | 5126268 | 20240918102541_QIKKu | US000L | 2024-09-19T12:05:29.603Z | 2024-09-19T12:06:42.172Z |
5126243 | 5126243 | 20240918100500_bqUTG | US000L | 2024-09-19T12:05:25.243Z | 2024-09-19T12:06:42.167Z |
5126238 | 5126238 | 20240918095845_zLnAw | US000L | 2024-09-19T12:05:24.629Z | 2024-09-19T12:06:42.166Z |
5126122 | 5126122 | 20240918082936_isci3 | US000L | 2024-09-19T12:05:09.255Z | 2024-09-19T12:06:42.144Z |
5126100 | 5126100 | 20240918081720_ONeZr | US000L | 2024-09-19T12:05:06.716Z | 2024-09-19T12:06:42.140Z |
5126052 | 5126052 | 20240918074017_0MS5b | US000L | 2024-09-19T12:04:51.448Z | 2024-09-19T12:06:42.132Z |
5126030 | 5126030 | 20240918070244_htIkx | US000L | 2024-09-19T12:04:47.349Z | 2024-09-19T12:06:42.127Z |
5126008 | 5126008 | 20240918062948_h7Avd | US000L | 2024-09-19T12:04:44.407Z | 2024-09-19T12:06:42.124Z |
5125943 | 5125943 | 20240918050554_EqkkA | US000L | 2024-09-19T12:04:36.426Z | 2024-09-19T12:06:42.113Z |
5125610 | 5125610 | 20240918030844_itaKA | US000L | 2024-09-19T12:03:41.278Z | 2024-09-19T12:06:42.058Z |
5123851 | 5123851 | 20240914114527_rwxlQ | US000L | 2024-09-18T12:11:58.755Z | 2024-09-19T12:20:15.784Z |
5123780 | 5123780 | 20240914112929_7fRJx | US000L | 2024-09-18T12:11:57.387Z | 2024-09-19T12:20:14.824Z |
5123763 | 5123763 | 20240914112447_5D5Gl | US000L | 2024-09-18T12:11:56.846Z | 2024-09-19T12:20:14.739Z |
5123711 | 5123711 | 20240914111239_RqFwM | US000L | 2024-09-18T12:11:54.688Z | 2024-09-19T12:20:14.211Z |
5123700 | 5123700 | 20240914111018_A0e4n | US000L | 2024-09-18T12:11:54.460Z | 2024-09-19T12:20:13.847Z |
5123689 | 5123689 | 20240914110504_ns8pr | US000L | 2024-09-18T12:11:54.014Z | 2024-09-19T12:20:13.787Z |
5123674 | 5123674 | 20240914110324_jeZ5d | US000L | 2024-09-18T12:11:53.827Z | 2024-09-19T12:20:13.745Z |
5123576 | 5123576 | 20240914103730_Bsbep | US000L | 2024-09-18T12:11:51.537Z | 2024-09-19T12:20:12.759Z |
5123508 | 5123508 | 20240914102236_466d2 | US000L | 2024-09-18T12:11:50.529Z | 2024-09-19T12:20:11.524Z |
5123452 | 5123452 | 20240914101020_FJvBg | US000L | 2024-09-18T12:11:49.282Z | 2024-09-19T12:20:11.124Z |
5123381 | 5123381 | 20240914095544_hz1Ih | US000L | 2024-09-18T12:11:47.487Z | 2024-09-19T12:20:10.686Z |
5123370 | 5123370 | 20240914095300_qD3bp | US000L | 2024-09-18T12:11:47.138Z | 2024-09-19T12:20:10.612Z |
5123355 | 5123355 | 20240914095057_MApaa | US000L | 2024-09-18T12:11:46.476Z | 2024-09-19T12:20:10.527Z |
5123336 | 5123336 | 20240914094730_0J3LU | US000L | 2024-09-18T12:11:45.362Z | 2024-09-19T12:20:10.431Z |
5123295 | 5123295 | 20240914093638_k7OJM | US000L | 2024-09-18T12:11:44.631Z | 2024-09-19T12:20:09.969Z |
5123210 | 5123210 | 20240914091713_dJjku | US000L | 2024-09-18T12:11:42.468Z | 2024-09-19T12:20:08.964Z |
5123060 | 5123060 | 20240914084551_2Fmvh | US000L | 2024-09-18T12:11:39.326Z | 2024-09-19T12:20:07.510Z |
5123040 | 5123040 | 20240914084406_Nmo2j | US000L | 2024-09-18T12:11:38.837Z | 2024-09-19T12:20:07.447Z |
5122940 | 5122940 | 20240914082502_zvycd | US000L | 2024-09-18T12:11:34.448Z | 2024-09-19T12:20:06.753Z |
5122895 | 5122895 | 20240914081800_x3dBo | US000L | 2024-09-18T12:11:33.654Z | 2024-09-19T12:20:06.650Z |
5122773 | 5122773 | 20240914075620_mTmcC | US000L | 2024-09-18T12:11:30.716Z | 2024-09-19T12:20:06.101Z |
5122694 | 5122694 | 20240914073240_aOuf7 | US000L | 2024-09-18T12:11:28.555Z | 2024-09-19T12:20:05.754Z |
5122591 | 5122591 | 20240914071551_sw3Pu | US000L | 2024-09-18T12:11:24.263Z | 2024-09-19T12:20:05.222Z |
5122557 | 5122557 | 20240914070634_hnHzK | US000L | 2024-09-18T12:11:23.200Z | 2024-09-19T12:20:04.987Z |
5122539 | 5122539 | 20240914070400_2T9wC | US000L | 2024-09-18T12:11:22.410Z | 2024-09-19T12:20:04.859Z |
5121722 | 5121722 | 20240914041244_OPi6N | US000L | 2024-09-18T12:11:00.526Z | 2024-09-19T12:20:02.302Z |
5121588 | 5121588 | 20240914041009_ychrY | US000L | 2024-09-18T12:10:58.658Z | 2024-09-19T12:20:02.160Z |
5118985 | 5118985 | 20240915115606_MlG5W | US000L | 2024-09-18T12:09:16.995Z | 2024-09-19T12:19:28.034Z |
5118912 | 5118912 | 20240915113540_IpBp4 | US000L | 2024-09-18T12:09:12.585Z | 2024-09-19T12:19:27.570Z |
5118633 | 5118633 | 20240915103354_YRLoX | US000L | 2024-09-18T12:08:54.342Z | 2024-09-19T12:19:24.565Z |
5118599 | 5118599 | 20240915102437_9wlfJ | US000L | 2024-09-18T12:08:52.604Z | 2024-09-19T12:19:24.186Z |
5118054 | 5118054 | 20240915081959_4MP6u | US000L | 2024-09-18T12:08:21.006Z | 2024-09-19T12:19:19.987Z |
5117927 | 5117927 | 20240915074923_xFTII | US000L | 2024-09-18T12:08:07.634Z | 2024-09-19T12:19:19.041Z |
5117886 | 5117886 | 20240915073824_O5UcJ | US000L | 2024-09-18T12:08:04.841Z | 2024-09-19T12:19:18.736Z |
5117860 | 5117860 | 20240915072918_kYiuv | US000L | 2024-09-18T12:08:03.783Z | 2024-09-19T12:19:18.610Z |
5117800 | 5117800 | 20240915070521_l1Q8z | US000L | 2024-09-18T12:08:00.354Z | 2024-09-19T12:19:18.095Z |
5117742 | 5117742 | 20240915064135_nqT7M | US000L | 2024-09-18T12:07:54.774Z | 2024-09-19T12:19:17.420Z |
5117676 | 5117676 | 20240915061826_NJGg1 | US000L | 2024-09-18T12:07:51.828Z | 2024-09-19T12:19:16.906Z |
5117645 | 5117645 | 20240915055706_UjNiu | US000L | 2024-09-18T12:07:50.665Z | 2024-09-19T12:19:16.702Z |
5117613 | 5117613 | 20240915054740_cPbj7 | US000L | 2024-09-18T12:07:49.109Z | 2024-09-19T12:19:16.435Z |
5117591 | 5117591 | 20240915053746_9Mr36 | US000L | 2024-09-18T12:07:48.072Z | 2024-09-19T12:19:16.200Z |
5117519 | 5117519 | 20240915045339_PzhB3 | US000L | 2024-09-18T12:07:44.694Z | 2024-09-19T12:19:15.612Z |
5117379 | 5117379 | 20240915042139_cZV7h | US000L | 2024-09-18T12:07:39.119Z | 2024-09-19T12:19:14.576Z |
5117072 | 5117072 | 20240915035902_otGdx | US000L | 2024-09-18T12:07:31.239Z | 2024-09-19T12:19:13.236Z |
5109963 | 5109963 | 20240913114144_7kVix | US000L | 2024-09-17T12:14:51.827Z | 2024-09-19T12:20:55.500Z |
5109910 | 5109910 | 20240913113542_QJF6g | US000L | 2024-09-17T12:14:49.161Z | 2024-09-19T12:20:55.343Z |
5109835 | 5109835 | 20240913111703_J299G | US000L | 2024-09-17T12:14:47.269Z | 2024-09-19T12:20:54.914Z |
5109820 | 5109820 | 20240913111416_AQTZX | US000L | 2024-09-17T12:14:46.903Z | 2024-09-19T12:20:54.858Z |
5109813 | 5109813 | 20240913111410_Y4z19 | US000L | 2024-09-17T12:14:46.776Z | 2024-09-19T12:20:54.838Z |
5109608 | 5109608 | 20240913103558_MvYdy | US000L | 2024-09-17T12:14:42.035Z | 2024-09-19T12:20:53.815Z |
5109519 | 5109519 | 20240913101150_psblv | US000L | 2024-09-17T12:14:40.069Z | 2024-09-19T12:20:53.619Z |
5109440 | 5109440 | 20240913095542_B38Z3 | US000L | 2024-09-17T12:14:38.153Z | 2024-09-19T12:20:53.341Z |
5109433 | 5109433 | 20240913095311_S76DW | US000L | 2024-09-17T12:14:37.986Z | 2024-09-19T12:20:53.304Z |
5109423 | 5109423 | 20240913095207_pXfFF | US000L | 2024-09-17T12:14:37.858Z | 2024-09-19T12:20:53.276Z |
5109376 | 5109376 | 20240913094420_cU7CS | US000L | 2024-09-17T12:14:36.837Z | 2024-09-19T12:20:53.174Z |
5109287 | 5109287 | 20240913092721_mSmff | US000L | 2024-09-17T12:14:34.626Z | 2024-09-19T12:20:52.761Z |
5109218 | 5109218 | 20240913091530_GNDSW | US000L | 2024-09-17T12:14:33.543Z | 2024-09-19T12:20:52.534Z |
5109120 | 5109120 | 20240913085159_7ybCl | US000L | 2024-09-17T12:14:30.814Z | 2024-09-19T12:20:51.776Z |
5109066 | 5109066 | 20240913084057_gXZlg | US000L | 2024-09-17T12:14:29.027Z | 2024-09-19T12:20:51.614Z |
5109023 | 5109023 | 20240913082706_lid6i | US000L | 2024-09-17T12:14:26.088Z | 2024-09-19T12:20:51.487Z |
5108995 | 5108995 | 20240913082004_1rPj7 | US000L | 2024-09-17T12:14:24.169Z | 2024-09-19T12:20:51.379Z |
5108975 | 5108975 | 20240913081543_c3OQ8 | US000L | 2024-09-17T12:14:23.145Z | 2024-09-19T12:20:51.339Z |
5108894 | 5108894 | 20240913075757_Cb3J1 | US000L | 2024-09-17T12:14:15.118Z | 2024-09-19T12:20:51.044Z |
5108679 | 5108679 | 20240913065855_vFL5F | US000L | 2024-09-17T12:13:57.462Z | 2024-09-19T12:20:50.291Z |
5108655 | 5108655 | 20240913065535_FVTbf | US000L | 2024-09-17T12:13:56.155Z | 2024-09-19T12:20:50.199Z |
5108601 | 5108601 | 20240913064034_FKTUL | US000L | 2024-09-17T12:13:52.979Z | 2024-09-19T12:20:49.727Z |
5108470 | 5108470 | 20240913054745_Tqv3E | US000L | 2024-09-17T12:13:46.320Z | 2024-09-19T12:20:48.915Z |
5108458 | 5108458 | 20240913054716_iibdF | US000L | 2024-09-17T12:13:45.330Z | 2024-09-19T12:20:48.881Z |
5106654 | 5106654 | 20240913033132_AkEtw | US000L | 2024-09-17T12:12:58.878Z | 2024-09-19T12:20:46.239Z |
5106629 | 5106629 | 20240913033115_WFC2O | US000L | 2024-09-17T12:12:58.600Z | 2024-09-19T12:20:46.214Z |
5106327 | 5106327 | 20240913031925_bzGoD | US000L | 2024-09-17T12:12:50.204Z | 2024-09-19T12:20:45.898Z |
5105083 | 5105083 | 20240913023000_AxkFh | US000L | 2024-09-17T12:11:54.023Z | 2024-09-19T12:20:43.502Z |
5096757 | 5096757 | 20240912113829_Xj24B | US000L | 2024-09-16T12:16:34.137Z | 2024-09-19T12:21:23.571Z |
5096745 | 5096745 | 20240912113559_OvcKx | US000L | 2024-09-16T12:16:33.722Z | 2024-09-19T12:21:23.537Z |
5096657 | 5096657 | 20240912112727_NSUSF | US000L | 2024-09-16T12:16:30.856Z | 2024-09-19T12:21:23.361Z |
5096554 | 5096554 | 20240912111038_rknQ3 | US000L | 2024-09-16T12:16:27.403Z | 2024-09-19T12:21:22.754Z |
5096530 | 5096530 | 20240912110814_K5Yhx | US000L | 2024-09-16T12:16:26.509Z | 2024-09-19T12:21:22.542Z |
5096514 | 5096514 | 20240912110557_MRc9d | US000L | 2024-09-16T12:16:25.952Z | 2024-09-19T12:21:22.467Z |
5096385 | 5096385 | 20240912104120_saAzi | US000L | 2024-09-16T12:16:21.946Z | 2024-09-19T12:21:22.220Z |
5096355 | 5096355 | 20240912103726_phACf | US000L | 2024-09-16T12:16:21.335Z | 2024-09-19T12:21:22.189Z |
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);