participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,678 rows where station_code = "US001N" 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 |
---|---|---|---|---|---|
5117765 | 5117765 | 20240915065514_YzsiZ | US001N | 2024-09-18T12:07:57.081Z | 2024-09-19T12:19:17.660Z |
5108365 | 5108365 | 20240913050212_uzhr3 | US001N | 2024-09-17T12:13:38.772Z | 2024-09-19T12:20:48.430Z |
5107572 | 5107572 | 20240913040158_tKhXc | US001N | 2024-09-17T12:13:17.432Z | 2024-09-19T12:20:47.265Z |
5103432 | 5103432 | 20240913013041_h3Ehh | US001N | 2024-09-17T12:10:57.431Z | 2024-09-19T12:20:40.176Z |
5095584 | 5095584 | 20240912081232_ETIHA | US001N | 2024-09-16T12:15:49.689Z | 2024-09-19T12:21:19.165Z |
5095303 | 5095303 | 20240912070404_O97RW | US001N | 2024-09-16T12:15:31.429Z | 2024-09-19T12:21:18.049Z |
5095109 | 5095109 | 20240912055556_9fl75 | US001N | 2024-09-16T12:15:14.620Z | 2024-09-19T12:21:17.290Z |
5095001 | 5095001 | 20240912050630_wmtoC | US001N | 2024-09-16T12:15:08.527Z | 2024-09-19T12:21:16.908Z |
5091589 | 5091589 | 20240912021423_bYOBq | US001N | 2024-09-16T12:13:11.874Z | 2024-09-19T12:21:13.239Z |
5067065 | 5067065 | 20240910085151_NJog2 | US001N | 2024-09-14T12:18:28.981Z | 2024-09-18T12:15:23.317Z |
5048847 | 5048847 | 20240909092043_l3Ef6 | US001N | 2024-09-13T12:11:19.065Z | 2024-09-17T12:19:08.528Z |
5048238 | 5048238 | 20240909072600_vs0HK | US001N | 2024-09-13T12:10:22.135Z | 2024-09-17T12:19:06.164Z |
5047472 | 5047472 | 20240909042334_Ut654 | US001N | 2024-09-13T12:09:07.206Z | 2024-09-17T12:19:02.779Z |
5047224 | 5047224 | 20240909030813_NbKrZ | US001N | 2024-09-13T12:08:41.035Z | 2024-09-17T12:19:01.728Z |
5040392 | 5040392 | 20240906035701_B523S | US001N | 2024-09-12T12:16:08.315Z | 2024-09-14T12:23:08.911Z |
5039634 | 5039634 | 20240906014028_crigL | US001N | 2024-09-12T12:15:40.584Z | 2024-09-14T12:23:03.849Z |
5032306 | 5032306 | 20240907004342_nTz3I | US001N | 2024-09-12T12:07:05.815Z | 2024-09-15T12:21:25.984Z |
5028165 | 5028165 | 20240905090949_qko2f | US001N | 2024-09-11T12:14:55.880Z | 2024-09-13T12:20:05.620Z |
5027277 | 5027277 | 20240905071739_WNeTX | US001N | 2024-09-11T12:14:03.656Z | 2024-09-13T12:20:02.227Z |
5025298 | 5025298 | 20240906014028_fNhj5 | US001N | 2024-09-11T12:06:10.536Z | 2024-09-14T12:23:03.846Z |
5022601 | 5022601 | 20240905090949_Fsw3R | US001N | 2024-09-10T12:16:24.618Z | 2024-09-10T12:16:55.580Z |
5021730 | 5021730 | 20240905071739_ill0F | US001N | 2024-09-10T12:15:49.675Z | 2024-09-10T12:16:55.429Z |
5003328 | 5003328 | 20240903083745_XTlGp | US001N | 2024-09-09T12:01:36.513Z | 2024-09-12T12:18:55.874Z |
4957498 | 4957498 | 20240811085026_XP6b7 | US001N | 2024-09-03T12:21:22.567Z | 2024-09-06T12:31:21.596Z |
4955846 | 4955846 | 20240811061155_FDdNR | US001N | 2024-09-03T12:19:29.434Z | 2024-09-06T12:30:01.231Z |
4904325 | 4904325 | 20240808051155_kuWi7 | US001N | 2024-08-28T12:20:18.167Z | 2024-08-28T12:20:18.167Z |
4904248 | 4904248 | 20240808044208_bHlTl | US001N | 2024-08-28T12:20:12.727Z | 2024-08-28T12:20:12.727Z |
4904144 | 4904144 | 20240808041316_23S2J | US001N | 2024-08-28T12:20:07.294Z | 2024-08-28T12:20:07.294Z |
4797202 | 4797202 | 20240802030525_9K35a | US001N | 2024-08-11T12:16:21.704Z | 2024-08-11T12:16:21.704Z |
4787447 | 4787447 | 20240802064750_gsJOJ | US001N | 2024-08-11T12:02:05.050Z | 2024-08-13T12:15:32.148Z |
4787315 | 4787315 | 20240802060334_4138W | US001N | 2024-08-11T12:01:37.511Z | 2024-08-13T12:15:25.977Z |
4786983 | 4786983 | 20240802035247_ed4RE | US001N | 2024-08-11T12:00:33.696Z | 2024-08-13T12:15:13.696Z |
4772654 | 4772654 | 20240801075536_wOqm4 | US001N | 2024-08-07T12:04:08.351Z | 2024-08-11T12:11:35.158Z |
4762548 | 4762548 | 20240731021618_3Y7s0 | US001N | 2024-08-06T12:02:48.233Z | 2024-08-10T12:17:49.794Z |
4761656 | 4761656 | 20240731012534_sbcS2 | US001N | 2024-08-06T12:00:47.237Z | 2024-08-10T12:17:23.235Z |
4105416 | 4105416 | 20240322091103_qJCme | US001N | 2024-03-23T12:08:42.076Z | 2024-03-30T12:18:19.595Z |
3857866 | 3857866 | 20240118084017_7JLek | US001N | 2024-01-21T14:12:49.195Z | 2024-01-26T14:21:48.298Z |
3633453 | 3633453 | 20231214102105_0V4NL | US001N | 2024-01-06T00:05:26.064Z | 2024-01-06T00:05:26.064Z |
3431438 | 3431438 | 20231119071948_3MA6D | US001N | 2024-01-06T00:04:31.064Z | 2024-01-06T00:04:31.064Z |
3431382 | 3431382 | 20231119065444_yzhP2 | US001N | 2024-01-06T00:04:31.056Z | 2024-01-06T00:04:31.056Z |
3269600 | 3269600 | 20231024071131_uLt5f | US001N | 2024-01-06T00:03:25.184Z | 2024-01-06T00:03:25.184Z |
2955557 | 2955557 | 20230908032651_3o1He | US001N | 2024-01-06T00:01:36.619Z | 2024-01-06T00:01:36.619Z |
2954428 | 2954428 | 20230908013135_S3Bpn | US001N | 2024-01-06T00:01:36.488Z | 2024-01-06T00:01:36.488Z |
2954115 | 2954115 | 20230908005108_O6yKd | US001N | 2024-01-06T00:01:36.450Z | 2024-01-06T00:01:36.450Z |
2948773 | 2948773 | 20230907090001_SnYzj | US001N | 2024-01-06T00:01:35.867Z | 2024-01-06T00:01:35.867Z |
2948607 | 2948607 | 20230907082339_Eby3Q | US001N | 2024-01-06T00:01:35.847Z | 2024-01-06T00:01:35.847Z |
2948531 | 2948531 | 20230907081311_xc45H | US001N | 2024-01-06T00:01:35.838Z | 2024-01-06T00:01:35.838Z |
2948442 | 2948442 | 20230907074833_QpWMK | US001N | 2024-01-06T00:01:35.827Z | 2024-01-06T00:01:35.827Z |
2948328 | 2948328 | 20230907072154_oWdFd | US001N | 2024-01-06T00:01:35.814Z | 2024-01-06T00:01:35.814Z |
2948115 | 2948115 | 20230907061209_hFH8d | US001N | 2024-01-06T00:01:35.789Z | 2024-01-06T00:01:35.789Z |
2947857 | 2947857 | 20230907050547_N0rMH | US001N | 2024-01-06T00:01:35.760Z | 2024-01-06T00:01:35.760Z |
2947741 | 2947741 | 20230907041859_a5x9C | US001N | 2024-01-06T00:01:34.442Z | 2024-01-06T00:01:34.442Z |
2947676 | 2947676 | 20230907035829_iXXkp | US001N | 2024-01-06T00:01:34.434Z | 2024-01-06T00:01:34.434Z |
2947545 | 2947545 | 20230907033652_EgGWx | US001N | 2024-01-06T00:01:34.419Z | 2024-01-06T00:01:34.419Z |
2947392 | 2947392 | 20230907031631_XHp8E | US001N | 2024-01-06T00:01:34.400Z | 2024-01-06T00:01:34.400Z |
2946624 | 2946624 | 20230907015715_90r7U | US001N | 2024-01-06T00:01:34.314Z | 2024-01-06T00:01:34.314Z |
2946512 | 2946512 | 20230907014708_3q0h2 | US001N | 2024-01-06T00:01:34.300Z | 2024-01-06T00:01:34.300Z |
2945763 | 2945763 | 20230907002606_k4443 | US001N | 2024-01-06T00:01:34.216Z | 2024-01-06T00:01:34.216Z |
2941021 | 2941021 | 20230906045629_r2weu | US001N | 2024-01-06T00:01:33.661Z | 2024-01-06T00:01:33.661Z |
2940938 | 2940938 | 20230906042339_E53GN | US001N | 2024-01-06T00:01:33.652Z | 2024-01-06T00:01:33.652Z |
2940324 | 2940324 | 20230906025224_5Wbh7 | US001N | 2024-01-06T00:01:32.272Z | 2024-01-06T00:01:32.272Z |
2940097 | 2940097 | 20230906023333_cS6ir | US001N | 2024-01-06T00:01:32.247Z | 2024-01-06T00:01:32.247Z |
2939954 | 2939954 | 20230906022246_TcQ2s | US001N | 2024-01-06T00:01:32.234Z | 2024-01-06T00:01:32.234Z |
2939477 | 2939477 | 20230906012231_hZKt8 | US001N | 2024-01-06T00:01:32.180Z | 2024-01-06T00:01:32.180Z |
2931356 | 2931356 | 20230905010623_O3Ge7 | US001N | 2024-01-06T00:01:30.092Z | 2024-01-06T00:01:30.092Z |
2926358 | 2926358 | 20230904055549_gBAiV | US001N | 2024-01-06T00:01:29.608Z | 2024-01-06T00:01:29.608Z |
2926271 | 2926271 | 20230904052033_GMA9C | US001N | 2024-01-06T00:01:29.597Z | 2024-01-06T00:01:29.597Z |
2926273 | 2926273 | 20230904052146_jpOI7 | US001N | 2024-01-06T00:01:29.597Z | 2024-01-06T00:01:29.597Z |
2925070 | 2925070 | 20230904020522_uddPi | US001N | 2024-01-06T00:01:28.129Z | 2024-01-06T00:01:28.129Z |
2922469 | 2922469 | 20230903090354_qYcut | US001N | 2024-01-06T00:01:27.900Z | 2024-01-06T00:01:27.900Z |
2919023 | 2919023 | 20230902002703_LURAJ | US001N | 2024-01-06T00:01:25.006Z | 2024-01-06T00:01:25.006Z |
2918227 | 2918227 | 20230901084900_A8iRl | US001N | 2024-01-06T00:01:24.905Z | 2024-01-06T00:01:24.905Z |
2918142 | 2918142 | 20230901081409_PSd51 | US001N | 2024-01-06T00:01:24.895Z | 2024-01-06T00:01:24.895Z |
2918133 | 2918133 | 20230901080741_hHcjH | US001N | 2024-01-06T00:01:24.894Z | 2024-01-06T00:01:24.894Z |
2918062 | 2918062 | 20230901072315_mMjQC | US001N | 2024-01-06T00:01:24.886Z | 2024-01-06T00:01:24.886Z |
2918047 | 2918047 | 20230901070731_BHcKK | US001N | 2024-01-06T00:01:24.884Z | 2024-01-06T00:01:24.884Z |
2918022 | 2918022 | 20230901064541_dQ1KA | US001N | 2024-01-06T00:01:24.881Z | 2024-01-06T00:01:24.881Z |
2916934 | 2916934 | 20230831080122_zVpMi | US001N | 2024-01-06T00:01:23.502Z | 2024-01-06T00:01:23.502Z |
2910399 | 2910399 | 20230828073400_WOI2r | US001N | 2024-01-06T00:01:19.247Z | 2024-01-06T00:01:19.247Z |
2910397 | 2910397 | 20230828073338_u265v | US001N | 2024-01-06T00:01:19.246Z | 2024-01-06T00:01:19.246Z |
2910368 | 2910368 | 20230828072546_tL3SX | US001N | 2024-01-06T00:01:19.242Z | 2024-01-06T00:01:19.242Z |
2910267 | 2910267 | 20230828070438_dZ41j | US001N | 2024-01-06T00:01:19.229Z | 2024-01-06T00:01:19.229Z |
2910241 | 2910241 | 20230828065849_3Ez73 | US001N | 2024-01-06T00:01:19.225Z | 2024-01-06T00:01:19.225Z |
2910142 | 2910142 | 20230828061718_6tZTr | US001N | 2024-01-06T00:01:19.210Z | 2024-01-06T00:01:19.210Z |
2910108 | 2910108 | 20230828055209_3oR9m | US001N | 2024-01-06T00:01:19.206Z | 2024-01-06T00:01:19.206Z |
2910043 | 2910043 | 20230828050839_gAWqg | US001N | 2024-01-06T00:01:19.196Z | 2024-01-06T00:01:19.196Z |
2909470 | 2909470 | 20230828030128_dufGo | US001N | 2024-01-06T00:01:19.132Z | 2024-01-06T00:01:19.132Z |
2906027 | 2906027 | 20230827090445_ESqlE | US001N | 2024-01-06T00:01:17.514Z | 2024-01-06T00:01:17.514Z |
2905955 | 2905955 | 20230827082246_wKgsZ | US001N | 2024-01-06T00:01:17.504Z | 2024-01-06T00:01:17.504Z |
2905943 | 2905943 | 20230827081402_NElp2 | US001N | 2024-01-06T00:01:17.503Z | 2024-01-06T00:01:17.503Z |
2905885 | 2905885 | 20230827073049_Gfr5p | US001N | 2024-01-06T00:01:17.495Z | 2024-01-06T00:01:17.495Z |
2904276 | 2904276 | 20230827014540_tTmEJ | US001N | 2024-01-06T00:01:17.362Z | 2024-01-06T00:01:17.362Z |
2889491 | 2889491 | 20230824082324_bPrA3 | US001N | 2024-01-06T00:01:12.096Z | 2024-01-06T00:01:12.096Z |
2889483 | 2889483 | 20230824081908_jhd8N | US001N | 2024-01-06T00:01:12.095Z | 2024-01-06T00:01:12.095Z |
2889454 | 2889454 | 20230824080303_h3K70 | US001N | 2024-01-06T00:01:12.090Z | 2024-01-06T00:01:12.090Z |
2889446 | 2889446 | 20230824075744_HvcsN | US001N | 2024-01-06T00:01:12.089Z | 2024-01-06T00:01:12.089Z |
2889438 | 2889438 | 20230824075140_ZsVnN | US001N | 2024-01-06T00:01:12.087Z | 2024-01-06T00:01:12.087Z |
2889430 | 2889430 | 20230824074815_ijRxX | US001N | 2024-01-06T00:01:12.086Z | 2024-01-06T00:01:12.086Z |
2889432 | 2889432 | 20230824074840_f1C5G | US001N | 2024-01-06T00:01:12.086Z | 2024-01-06T00:01:12.086Z |
2889416 | 2889416 | 20230824074334_7DRff | US001N | 2024-01-06T00:01:12.084Z | 2024-01-06T00:01:12.084Z |
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);