participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,723 rows where station_code = "US001L" 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 |
---|---|---|---|---|---|
5524766 | 5524766 | 20241111053457_hB1ue | US001L | 2024-11-12T14:18:00.432Z | 2024-11-12T14:18:08.771Z |
5524681 | 5524681 | 20241111050947_6G13Q | US001L | 2024-11-12T14:17:54.585Z | 2024-11-12T14:18:08.735Z |
5524523 | 5524523 | 20241111042546_wlZul | US001L | 2024-11-12T14:17:34.117Z | 2024-11-12T14:18:08.661Z |
5524391 | 5524391 | 20241111040721_ev5zm | US001L | 2024-11-12T14:17:14.804Z | 2024-11-12T14:18:08.599Z |
5519583 | 5519583 | 20241111120446_3SWrf | US001L | 2024-11-12T14:04:32.956Z | 2024-11-12T14:04:32.956Z |
5519483 | 5519483 | 20241111113521_CRxeJ | US001L | 2024-11-12T14:04:10.669Z | 2024-11-12T14:04:10.669Z |
5519447 | 5519447 | 20241111112607_irabh | US001L | 2024-11-12T14:04:03.855Z | 2024-11-12T14:04:03.855Z |
5519442 | 5519442 | 20241111112453_7EDHk | US001L | 2024-11-12T14:04:01.671Z | 2024-11-12T14:04:01.671Z |
5519380 | 5519380 | 20241111111455_KT97h | US001L | 2024-11-12T14:03:53.879Z | 2024-11-12T14:03:53.879Z |
5519337 | 5519337 | 20241111110315_O3YFC | US001L | 2024-11-12T14:03:47.506Z | 2024-11-12T14:03:47.506Z |
5519283 | 5519283 | 20241111105422_EYm35 | US001L | 2024-11-12T14:03:35.562Z | 2024-11-12T14:03:35.562Z |
5519258 | 5519258 | 20241111104931_0xuwk | US001L | 2024-11-12T14:03:29.425Z | 2024-11-12T14:03:29.425Z |
5519197 | 5519197 | 20241111103849_ylBNL | US001L | 2024-11-12T14:03:19.960Z | 2024-11-12T14:03:19.960Z |
5519174 | 5519174 | 20241111103359_fdbcG | US001L | 2024-11-12T14:03:15.697Z | 2024-11-12T14:03:15.697Z |
5519138 | 5519138 | 20241111102255_nIukv | US001L | 2024-11-12T14:03:10.319Z | 2024-11-12T14:03:10.319Z |
5519111 | 5519111 | 20241111101743_jr44p | US001L | 2024-11-12T14:03:06.526Z | 2024-11-12T14:03:06.526Z |
5519098 | 5519098 | 20241111101540_8OgoW | US001L | 2024-11-12T14:03:04.247Z | 2024-11-12T14:03:04.247Z |
5519045 | 5519045 | 20241111100522_sgD3n | US001L | 2024-11-12T14:02:52.653Z | 2024-11-12T14:02:52.653Z |
5519037 | 5519037 | 20241111100028_uXegk | US001L | 2024-11-12T14:02:50.530Z | 2024-11-12T14:02:50.530Z |
5519031 | 5519031 | 20241111095942_5Plev | US001L | 2024-11-12T14:02:48.523Z | 2024-11-12T14:02:48.523Z |
5518978 | 5518978 | 20241111094646_Z2DLu | US001L | 2024-11-12T14:02:32.167Z | 2024-11-12T14:02:32.167Z |
5518918 | 5518918 | 20241111093334_cqTg3 | US001L | 2024-11-12T14:02:20.853Z | 2024-11-12T14:02:20.853Z |
5518815 | 5518815 | 20241111091727_Zyz6G | US001L | 2024-11-12T14:02:09.380Z | 2024-11-12T14:02:09.380Z |
5518680 | 5518680 | 20241111084939_SW2hI | US001L | 2024-11-12T14:01:39.475Z | 2024-11-12T14:01:39.475Z |
5518595 | 5518595 | 20241111083043_Dwn5W | US001L | 2024-11-12T14:01:27.297Z | 2024-11-12T14:01:27.297Z |
5518570 | 5518570 | 20241111082218_Jk31A | US001L | 2024-11-12T14:01:23.848Z | 2024-11-12T14:01:23.848Z |
5518533 | 5518533 | 20241111081213_1o7ve | US001L | 2024-11-12T14:01:14.098Z | 2024-11-12T14:01:14.098Z |
5518360 | 5518360 | 20241111071455_HBg6l | US001L | 2024-11-12T14:00:43.052Z | 2024-11-12T14:00:43.052Z |
5518279 | 5518279 | 20241111064849_mzswo | US001L | 2024-11-12T14:00:26.934Z | 2024-11-12T14:00:26.934Z |
5518097 | 5518097 | 20241110055940_nzdWc | US001L | 2024-11-11T14:15:12.898Z | 2024-11-12T14:22:01.918Z |
5518090 | 5518090 | 20241110055842_3WeFs | US001L | 2024-11-11T14:15:12.435Z | 2024-11-12T14:22:01.839Z |
5517973 | 5517973 | 20241110052906_20DOW | US001L | 2024-11-11T14:15:05.896Z | 2024-11-12T14:21:59.826Z |
5517844 | 5517844 | 20241110050114_QMOpE | US001L | 2024-11-11T14:14:55.990Z | 2024-11-12T14:21:56.552Z |
5513931 | 5513931 | 20241110125023_EhD5a | US001L | 2024-11-11T14:05:40.617Z | 2024-11-12T14:18:06.721Z |
5513845 | 5513845 | 20241110122844_jI5nv | US001L | 2024-11-11T14:05:32.269Z | 2024-11-12T14:18:06.668Z |
5513656 | 5513656 | 20241110120104_n6gJJ | US001L | 2024-11-11T14:05:06.910Z | 2024-11-12T14:18:06.592Z |
5513558 | 5513558 | 20241110114838_CvbjG | US001L | 2024-11-11T14:04:48.704Z | 2024-11-12T14:18:06.548Z |
5513446 | 5513446 | 20241110113231_Zfjsx | US001L | 2024-11-11T14:04:39.476Z | 2024-11-12T14:18:06.499Z |
5513411 | 5513411 | 20241110112642_EW5m2 | US001L | 2024-11-11T14:04:36.114Z | 2024-11-12T14:18:06.483Z |
5513338 | 5513338 | 20241110111757_S3MFg | US001L | 2024-11-11T14:04:29.941Z | 2024-11-12T14:18:06.453Z |
5513136 | 5513136 | 20241110104048_4wsOU | US001L | 2024-11-11T14:03:57.175Z | 2024-11-12T14:18:06.361Z |
5512810 | 5512810 | 20241110095154_shI19 | US001L | 2024-11-11T14:03:11.106Z | 2024-11-12T14:18:06.230Z |
5512666 | 5512666 | 20241110092619_IR16v | US001L | 2024-11-11T14:02:55.520Z | 2024-11-12T14:18:06.170Z |
5512528 | 5512528 | 20241110090244_vyWhX | US001L | 2024-11-11T14:02:31.411Z | 2024-11-12T14:18:06.108Z |
5512018 | 5512018 | 20241110074319_LhcDf | US001L | 2024-11-11T14:01:23.537Z | 2024-11-12T14:18:05.902Z |
5512013 | 5512013 | 20241110074302_YG3x2 | US001L | 2024-11-11T14:01:23.244Z | 2024-11-12T14:18:05.901Z |
5512007 | 5512007 | 20241110074144_2ewSN | US001L | 2024-11-11T14:01:22.476Z | 2024-11-12T14:18:05.899Z |
5511762 | 5511762 | 20241110065546_mlmk8 | US001L | 2024-11-11T14:00:46.138Z | 2024-11-12T14:18:05.795Z |
5511684 | 5511684 | 20241110063748_QaK61 | US001L | 2024-11-11T14:00:31.334Z | 2024-11-12T14:18:05.754Z |
5511597 | 5511597 | 20241110062011_hE7cG | US001L | 2024-11-11T14:00:17.358Z | 2024-11-12T14:18:05.707Z |
5506722 | 5506722 | 20241109092507_KNOMZ | US001L | 2024-11-10T14:03:11.266Z | 2024-11-12T14:18:31.157Z |
5506614 | 5506614 | 20241109090902_MDWM9 | US001L | 2024-11-10T14:02:42.656Z | 2024-11-12T14:18:26.764Z |
5506235 | 5506235 | 20241109080027_Q2lGf | US001L | 2024-11-10T14:01:38.324Z | 2024-11-12T14:18:20.980Z |
5506146 | 5506146 | 20241109074431_hB7EK | US001L | 2024-11-10T14:01:19.878Z | 2024-11-12T14:18:17.515Z |
5480332 | 5480332 | 20241105122919_xRWd3 | US001L | 2024-11-06T14:05:16.192Z | 2024-11-12T14:26:30.266Z |
5480186 | 5480186 | 20241105115916_iRvdG | US001L | 2024-11-06T14:04:47.889Z | 2024-11-12T14:26:28.369Z |
5480153 | 5480153 | 20241105115137_KoDmY | US001L | 2024-11-06T14:04:39.814Z | 2024-11-12T14:26:28.313Z |
5480047 | 5480047 | 20241105112619_VO23r | US001L | 2024-11-06T14:04:22.980Z | 2024-11-12T14:26:27.409Z |
5479957 | 5479957 | 20241105110907_kAQvb | US001L | 2024-11-06T14:04:04.429Z | 2024-11-12T14:26:27.051Z |
5479770 | 5479770 | 20241105103652_G2qVp | US001L | 2024-11-06T14:03:32.472Z | 2024-11-12T14:26:26.034Z |
5479688 | 5479688 | 20241105101904_8ATqP | US001L | 2024-11-06T14:03:05.281Z | 2024-11-12T14:26:25.560Z |
5479556 | 5479556 | 20241105095705_Ux8Ph | US001L | 2024-11-06T14:02:45.270Z | 2024-11-12T14:26:24.764Z |
5479306 | 5479306 | 20241105090229_Vc5DQ | US001L | 2024-11-06T14:01:53.027Z | 2024-11-12T14:26:22.849Z |
5479060 | 5479060 | 20241105074303_1ROxb | US001L | 2024-11-06T14:00:52.241Z | 2024-11-12T14:26:20.285Z |
5479041 | 5479041 | 20241105073801_a3bmK | US001L | 2024-11-06T14:00:47.687Z | 2024-11-12T14:26:20.232Z |
5478978 | 5478978 | 20241105071849_dwCdM | US001L | 2024-11-06T14:00:32.106Z | 2024-11-12T14:26:19.151Z |
5478967 | 5478967 | 20241105071700_skIgr | US001L | 2024-11-06T14:00:30.174Z | 2024-11-12T14:26:18.868Z |
5478966 | 5478966 | 20241105071608_eYuTS | US001L | 2024-11-06T14:00:29.671Z | 2024-11-12T14:26:18.867Z |
5462880 | 5462880 | 20241102015030_Dy6Wb | US001L | 2024-11-03T14:18:08.667Z | 2024-11-10T14:26:33.606Z |
5459903 | 5459903 | 20241101121405_6CVu6 | US001L | 2024-11-03T14:12:47.905Z | 2024-11-10T14:26:21.637Z |
5459776 | 5459776 | 20241101114854_OWL7H | US001L | 2024-11-03T14:12:35.088Z | 2024-11-10T14:26:21.034Z |
5459753 | 5459753 | 20241101114806_xTe5l | US001L | 2024-11-03T14:12:33.523Z | 2024-11-10T14:26:20.867Z |
5459616 | 5459616 | 20241101112421_Bmsvf | US001L | 2024-11-03T14:12:22.070Z | 2024-11-10T14:26:20.109Z |
5459607 | 5459607 | 20241101112337_DUjCg | US001L | 2024-11-03T14:12:21.630Z | 2024-11-10T14:26:20.091Z |
5459415 | 5459415 | 20241101105732_54fzo | US001L | 2024-11-03T14:11:52.727Z | 2024-11-10T14:26:19.253Z |
5459272 | 5459272 | 20241101103348_CdXX7 | US001L | 2024-11-03T14:11:36.540Z | 2024-11-10T14:26:18.784Z |
5458894 | 5458894 | 20241101093811_COCRg | US001L | 2024-11-03T14:10:47.204Z | 2024-11-10T14:26:16.669Z |
5458674 | 5458674 | 20241101090133_SS0Nc | US001L | 2024-11-03T14:10:25.840Z | 2024-11-10T14:26:15.221Z |
5458607 | 5458607 | 20241101084902_XQoRd | US001L | 2024-11-03T14:10:06.869Z | 2024-11-10T14:26:14.444Z |
5458482 | 5458482 | 20241101083419_uFRbF | US001L | 2024-11-03T14:09:50.119Z | 2024-11-10T14:26:13.961Z |
5458475 | 5458475 | 20241101083139_Xbg6v | US001L | 2024-11-03T14:09:49.209Z | 2024-11-10T14:26:13.908Z |
5458460 | 5458460 | 20241101082949_UGcmS | US001L | 2024-11-03T14:09:47.565Z | 2024-11-10T14:26:13.751Z |
5456668 | 5456668 | 20241102120140_L68w3 | US001L | 2024-11-03T14:05:17.779Z | 2024-11-11T14:22:30.371Z |
5456589 | 5456589 | 20241102114835_45kZC | US001L | 2024-11-03T14:05:03.590Z | 2024-11-11T14:22:29.949Z |
5456558 | 5456558 | 20241102114520_1DfzP | US001L | 2024-11-03T14:04:59.066Z | 2024-11-11T14:22:29.748Z |
5456408 | 5456408 | 20241102111629_fLaqN | US001L | 2024-11-03T14:04:28.964Z | 2024-11-11T14:22:28.756Z |
5456357 | 5456357 | 20241102110406_tJsOr | US001L | 2024-11-03T14:04:17.593Z | 2024-11-11T14:22:27.938Z |
5456182 | 5456182 | 20241102103715_Nw2Jm | US001L | 2024-11-03T14:03:43.905Z | 2024-11-11T14:22:27.058Z |
5456126 | 5456126 | 20241102102733_CIF9N | US001L | 2024-11-03T14:03:25.712Z | 2024-11-11T14:22:26.725Z |
5456006 | 5456006 | 20241102100600_94og3 | US001L | 2024-11-03T14:03:05.934Z | 2024-11-11T14:22:25.427Z |
5455947 | 5455947 | 20241102094920_lNLrI | US001L | 2024-11-03T14:02:54.802Z | 2024-11-11T14:22:25.134Z |
5455455 | 5455455 | 20241102075346_5iPfS | US001L | 2024-11-03T14:00:59.359Z | 2024-11-11T14:22:21.737Z |
5455436 | 5455436 | 20241102074524_U83FK | US001L | 2024-11-03T14:00:55.647Z | 2024-11-11T14:22:21.586Z |
5455339 | 5455339 | 20241102072501_2RR3p | US001L | 2024-11-03T14:00:36.374Z | 2024-11-11T14:22:20.582Z |
5455314 | 5455314 | 20241102071857_Jfqc4 | US001L | 2024-11-03T14:00:31.885Z | 2024-11-11T14:22:20.366Z |
5455312 | 5455312 | 20241102071626_DRf9S | US001L | 2024-11-03T14:00:31.323Z | 2024-11-11T14:22:20.331Z |
5455217 | 5455217 | 20241102064925_wB8Ww | US001L | 2024-11-03T14:00:10.262Z | 2024-11-11T14:22:19.454Z |
5455120 | 5455120 | 20241031063520_Fvj2S | US001L | 2024-11-02T12:23:31.390Z | 2024-11-08T14:23:27.495Z |
5455100 | 5455100 | 20241031063017_Pg9ln | US001L | 2024-11-02T12:23:30.953Z | 2024-11-08T14:23:27.388Z |
5455003 | 5455003 | 20241031060458_d67pv | US001L | 2024-11-02T12:23:29.428Z | 2024-11-08T14:23:26.737Z |
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);