participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
154 rows where station_code = "US004A" 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 |
---|---|---|---|---|---|
5534984 | 5534984 | 20241112112142_JKbjV | US004A | 2024-11-14T14:07:03.584Z | 2024-11-14T14:14:15.825Z |
5534949 | 5534949 | 20241112111519_x2Y8H | US004A | 2024-11-14T14:07:01.190Z | 2024-11-14T14:14:15.818Z |
5534197 | 5534197 | 20241113111720_zvI2R | US004A | 2024-11-14T14:03:44.578Z | 2024-11-14T14:03:44.578Z |
5533746 | 5533746 | 20241113100019_aGlrw | US004A | 2024-11-14T14:02:44.254Z | 2024-11-14T14:02:44.254Z |
5526803 | 5526803 | 20241112101702_tTCLK | US004A | 2024-11-13T14:04:11.600Z | 2024-11-14T14:14:15.730Z |
5526534 | 5526534 | 20241112094015_a1tzq | US004A | 2024-11-13T14:03:25.176Z | 2024-11-14T14:14:15.663Z |
5526376 | 5526376 | 20241112090833_sScEo | US004A | 2024-11-13T14:02:48.847Z | 2024-11-14T14:14:15.632Z |
5526223 | 5526223 | 20241112083442_DB5SZ | US004A | 2024-11-13T14:02:15.821Z | 2024-11-14T14:14:15.600Z |
5526074 | 5526074 | 20241112080009_bHn82 | US004A | 2024-11-13T14:01:48.958Z | 2024-11-14T14:14:15.568Z |
5519458 | 5519458 | 20241111112810_BXehV | US004A | 2024-11-12T14:04:05.576Z | 2024-11-14T14:14:56.598Z |
5519341 | 5519341 | 20241111110317_7SLI5 | US004A | 2024-11-12T14:03:47.867Z | 2024-11-14T14:14:51.783Z |
5519142 | 5519142 | 20241111102256_VZYOt | US004A | 2024-11-12T14:03:10.688Z | 2024-11-14T14:14:47.401Z |
5519000 | 5519000 | 20241111095212_wH1ZT | US004A | 2024-11-12T14:02:36.075Z | 2024-11-14T14:14:43.102Z |
5518977 | 5518977 | 20241111094613_STFwn | US004A | 2024-11-12T14:02:31.638Z | 2024-11-14T14:14:42.353Z |
5518845 | 5518845 | 20241111092034_8XalC | US004A | 2024-11-12T14:02:12.373Z | 2024-11-14T14:14:39.500Z |
5518317 | 5518317 | 20241111070247_gkzIv | US004A | 2024-11-12T14:00:33.273Z | 2024-11-14T14:14:21.870Z |
5513009 | 5513009 | 20241110102124_LqgaL | US004A | 2024-11-11T14:03:44.386Z | 2024-11-14T14:17:42.878Z |
5512787 | 5512787 | 20241110094755_4irKu | US004A | 2024-11-11T14:03:08.734Z | 2024-11-14T14:17:39.970Z |
5507261 | 5507261 | 20241109110000_dGVTN | US004A | 2024-11-10T14:04:43.615Z | 2024-11-14T14:19:19.658Z |
5491849 | 5491849 | 20241106053307_O5Dbl | US004A | 2024-11-07T14:17:10.306Z | 2024-11-14T14:23:26.987Z |
5491829 | 5491829 | 20241106052357_vAiCQ | US004A | 2024-11-07T14:17:05.864Z | 2024-11-14T14:23:26.936Z |
5491219 | 5491219 | 20241106022535_JakYh | US004A | 2024-11-07T14:15:32.875Z | 2024-11-14T14:23:24.708Z |
5486493 | 5486493 | 20241106115251_AgWhF | US004A | 2024-11-07T14:03:13.151Z | 2024-11-14T14:22:24.190Z |
5486428 | 5486428 | 20241106113528_c3cmM | US004A | 2024-11-07T14:02:56.827Z | 2024-11-14T14:22:23.991Z |
5486359 | 5486359 | 20241106110644_2YmSZ | US004A | 2024-11-07T14:02:42.745Z | 2024-11-14T14:22:23.382Z |
5486333 | 5486333 | 20241106105044_PXAHD | US004A | 2024-11-07T14:02:38.626Z | 2024-11-14T14:22:23.146Z |
5486181 | 5486181 | 20241106095939_IeeZE | US004A | 2024-11-07T14:02:09.458Z | 2024-11-14T14:22:22.494Z |
5486039 | 5486039 | 20241106091657_PE4k0 | US004A | 2024-11-07T14:01:37.317Z | 2024-11-14T14:22:21.208Z |
5486012 | 5486012 | 20241106090954_nmvWM | US004A | 2024-11-07T14:01:29.427Z | 2024-11-14T14:22:20.946Z |
5485879 | 5485879 | 20241106081323_hVfZX | US004A | 2024-11-07T14:00:59.325Z | 2024-11-14T14:22:20.454Z |
5485834 | 5485834 | 20241106074927_APkRc | US004A | 2024-11-07T14:00:46.146Z | 2024-11-14T14:22:20.241Z |
5485769 | 5485769 | 20241106072351_THXq3 | US004A | 2024-11-07T14:00:34.557Z | 2024-11-14T14:22:19.982Z |
5421174 | 5421174 | 20241028045629_C0pPj | US004A | 2024-10-30T12:19:40.012Z | 2024-11-05T14:27:17.639Z |
5412872 | 5412872 | 20241028075608_AcA2W | US004A | 2024-10-30T12:01:01.895Z | 2024-11-06T14:27:03.419Z |
5412675 | 5412675 | 20241028070247_U1PZA | US004A | 2024-10-30T12:00:17.933Z | 2024-11-06T14:27:01.617Z |
5412233 | 5412233 | 20241027101346_UH7X8 | US004A | 2024-10-29T12:19:34.442Z | 2024-11-05T14:26:57.926Z |
5411941 | 5411941 | 20241027094129_hDjbn | US004A | 2024-10-29T12:19:19.756Z | 2024-11-05T14:26:56.918Z |
5411746 | 5411746 | 20241027091938_WKghZ | US004A | 2024-10-29T12:19:10.458Z | 2024-11-05T14:26:55.887Z |
5411629 | 5411629 | 20241027090531_3pGSl | US004A | 2024-10-29T12:19:04.491Z | 2024-11-05T14:26:55.148Z |
5411149 | 5411149 | 20241027063458_LwTj0 | US004A | 2024-10-29T12:18:28.866Z | 2024-11-04T14:29:07.292Z |
5408228 | 5408228 | 20241027031746_eS6LM | US004A | 2024-10-29T12:16:18.024Z | 2024-11-04T14:28:59.012Z |
5401695 | 5401695 | 20241026102245_ZOP7m | US004A | 2024-10-29T12:03:31.298Z | 2024-11-04T14:28:31.182Z |
5401237 | 5401237 | 20241027072844_dqtkS | US004A | 2024-10-29T12:00:55.109Z | 2024-11-05T14:26:50.729Z |
5401139 | 5401139 | 20241027071353_tD1nH | US004A | 2024-10-29T12:00:40.243Z | 2024-11-05T14:26:50.264Z |
5401074 | 5401074 | 20241027070152_mqLqs | US004A | 2024-10-29T12:00:27.146Z | 2024-11-05T14:26:49.989Z |
5391295 | 5391295 | 20241026113531_UK0mh | US004A | 2024-10-28T12:05:10.358Z | 2024-11-04T14:28:34.110Z |
5389525 | 5389525 | 20241026071433_qQHNp | US004A | 2024-10-28T12:00:34.940Z | 2024-11-04T14:28:22.944Z |
5389498 | 5389498 | 20241026071016_sO2iS | US004A | 2024-10-28T12:00:27.341Z | 2024-11-04T14:28:22.817Z |
5388625 | 5388625 | 20241025054117_3SaCo | US004A | 2024-10-27T12:22:23.759Z | 2024-11-02T12:28:34.686Z |
5388340 | 5388340 | 20241025043623_cdkPo | US004A | 2024-10-27T12:22:10.297Z | 2024-11-02T12:28:33.967Z |
5388158 | 5388158 | 20241025041034_bZ9Sr | US004A | 2024-10-27T12:22:02.597Z | 2024-11-02T12:28:33.798Z |
5388101 | 5388101 | 20241025040321_6bOfa | US004A | 2024-10-27T12:21:59.686Z | 2024-11-02T12:28:33.747Z |
5373751 | 5373751 | 20241024015304_HcXWk | US004A | 2024-10-26T12:20:25.102Z | 2024-11-01T12:26:58.462Z |
5372964 | 5372964 | 20241024011642_Z10o1 | US004A | 2024-10-26T12:19:50.333Z | 2024-11-01T12:26:58.050Z |
5367163 | 5367163 | 20241023055007_Zy4Nj | US004A | 2024-10-25T12:21:47.309Z | 2024-10-31T12:30:11.667Z |
5367145 | 5367145 | 20241023053803_KJWzP | US004A | 2024-10-25T12:21:46.878Z | 2024-10-31T12:30:11.588Z |
5366912 | 5366912 | 20241023043920_IuKGM | US004A | 2024-10-25T12:21:36.364Z | 2024-10-31T12:30:09.260Z |
5358360 | 5358360 | 20241023112500_6KAP8 | US004A | 2024-10-25T12:05:51.335Z | 2024-11-01T12:26:42.689Z |
5356313 | 5356313 | 20241020092847_okcvM | US004A | 2024-10-24T12:25:11.720Z | 2024-10-29T12:26:28.572Z |
5334144 | 5334144 | 20241021020034_t8tN9 | US004A | 2024-10-22T12:16:22.654Z | 2024-10-29T12:26:34.838Z |
5333877 | 5333877 | 20241021013529_14LCf | US004A | 2024-10-22T12:16:09.662Z | 2024-10-29T12:26:34.671Z |
5329088 | 5329088 | 20241021093606_Pj7Lm | US004A | 2024-10-22T12:03:14.727Z | 2024-10-30T12:26:33.804Z |
5328730 | 5328730 | 20241021084005_IQh3m | US004A | 2024-10-22T12:02:15.216Z | 2024-10-30T12:26:32.798Z |
5324865 | 5324865 | 20241020113123_4lVDy | US004A | 2024-10-21T12:04:16.044Z | 2024-10-29T12:26:30.213Z |
5324811 | 5324811 | 20241020112220_R2V2h | US004A | 2024-10-21T12:04:00.749Z | 2024-10-29T12:26:30.140Z |
5324775 | 5324775 | 20241020111409_qlszy | US004A | 2024-10-21T12:03:53.565Z | 2024-10-29T12:26:30.000Z |
5324743 | 5324743 | 20241020110843_P9F3e | US004A | 2024-10-21T12:03:47.493Z | 2024-10-29T12:26:29.969Z |
5324684 | 5324684 | 20241020105511_kiifM | US004A | 2024-10-21T12:03:38.946Z | 2024-10-29T12:26:29.786Z |
5324577 | 5324577 | 20241020103437_ajS5E | US004A | 2024-10-21T12:03:11.465Z | 2024-10-29T12:26:29.497Z |
5324192 | 5324192 | 20241020085814_3H8ax | US004A | 2024-10-21T12:02:00.685Z | 2024-10-29T12:26:28.250Z |
5317846 | 5317846 | 20241017110226_FiURy | US004A | 2024-10-18T12:00:56.910Z | 2024-10-26T12:27:51.791Z |
5314943 | 5314943 | 20241015111742_VbYjI | US004A | 2024-10-17T12:04:01.151Z | 2024-10-24T12:27:48.053Z |
5313798 | 5313798 | 20241016101208_Gi12i | US004A | 2024-10-17T12:01:02.827Z | 2024-10-25T12:24:27.135Z |
5308633 | 5308633 | 20241014102132_IqLF6 | US004A | 2024-10-16T12:04:04.211Z | 2024-10-23T12:24:18.658Z |
5308593 | 5308593 | 20241014101558_B8h7j | US004A | 2024-10-16T12:04:01.361Z | 2024-10-23T12:24:17.885Z |
5308169 | 5308169 | 20241014084652_yx2Z8 | US004A | 2024-10-16T12:03:08.930Z | 2024-10-23T12:24:13.810Z |
5307986 | 5307986 | 20241014072125_O4apP | US004A | 2024-10-16T12:02:48.348Z | 2024-10-23T12:24:11.486Z |
5307810 | 5307810 | 20241015110700_jK28q | US004A | 2024-10-16T12:02:18.152Z | 2024-10-24T12:27:46.775Z |
5307628 | 5307628 | 20241015103806_qHlrs | US004A | 2024-10-16T12:01:53.229Z | 2024-10-24T12:27:45.180Z |
5307609 | 5307609 | 20241015103558_DtUwT | US004A | 2024-10-16T12:01:50.283Z | 2024-10-24T12:27:45.107Z |
5307578 | 5307578 | 20241015103225_a6a3Z | US004A | 2024-10-16T12:01:47.320Z | 2024-10-24T12:27:44.942Z |
5307139 | 5307139 | 20241015080942_tCF9e | US004A | 2024-10-16T12:00:47.665Z | 2024-10-24T12:27:40.514Z |
5304165 | 5304165 | 20241013042228_q5Erl | US004A | 2024-10-14T12:17:43.872Z | 2024-10-21T12:24:23.857Z |
5296377 | 5296377 | 20241012100835_QfjpQ | US004A | 2024-10-14T12:05:53.806Z | 2024-10-21T12:23:03.256Z |
5295813 | 5295813 | 20241013090652_Z8dYI | US004A | 2024-10-14T12:03:34.102Z | 2024-10-22T12:24:15.209Z |
5295797 | 5295797 | 20241013090442_NMAlz | US004A | 2024-10-14T12:03:32.036Z | 2024-10-22T12:24:15.086Z |
5295735 | 5295735 | 20241013085257_jjejX | US004A | 2024-10-14T12:03:11.398Z | 2024-10-22T12:24:14.591Z |
5295632 | 5295632 | 20241013083555_F9H9k | US004A | 2024-10-14T12:02:58.381Z | 2024-10-22T12:24:13.688Z |
5295389 | 5295389 | 20241013074020_vM6if | US004A | 2024-10-14T12:02:13.366Z | 2024-10-22T12:24:11.623Z |
5295335 | 5295335 | 20241013072752_5ODSw | US004A | 2024-10-14T12:01:56.390Z | 2024-10-22T12:24:11.252Z |
5295132 | 5295132 | 20241013062856_VdTDG | US004A | 2024-10-14T12:01:14.334Z | 2024-10-22T12:24:08.963Z |
5286740 | 5286740 | 20241012092139_JOG5K | US004A | 2024-10-13T12:03:22.376Z | 2024-10-21T12:22:58.882Z |
5286535 | 5286535 | 20241012085015_kzu9Z | US004A | 2024-10-13T12:02:41.997Z | 2024-10-21T12:22:55.156Z |
5286052 | 5286052 | 20241012072331_S2H8H | US004A | 2024-10-13T12:01:21.956Z | 2024-10-21T12:22:48.644Z |
5278368 | 5278368 | 20241011101543_Utv8A | US004A | 2024-10-12T12:05:58.006Z | 2024-10-20T12:23:40.749Z |
5277726 | 5277726 | 20241011084153_zXE0h | US004A | 2024-10-12T12:04:16.645Z | 2024-10-20T12:23:32.359Z |
5275908 | 5275908 | 20241010033707_yBM19 | US004A | 2024-10-11T12:16:35.220Z | 2024-10-18T12:22:21.114Z |
5270786 | 5270786 | 20241010102849_K9B6S | US004A | 2024-10-11T12:05:23.371Z | 2024-10-19T12:27:00.753Z |
5270673 | 5270673 | 20241010101314_4xh4C | US004A | 2024-10-11T12:05:05.011Z | 2024-10-19T12:27:00.318Z |
5270451 | 5270451 | 20241010094128_PEOxZ | US004A | 2024-10-11T12:04:33.225Z | 2024-10-19T12:26:59.352Z |
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);