participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,442 rows where station_code = "US004Q" 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 |
---|---|---|---|---|---|
5497947 | 5497947 | 20241107061705_Si32B | US004Q | 2024-11-08T14:14:31.662Z | 2024-11-09T14:18:54.117Z |
5497858 | 5497858 | 20241107053656_S3hI7 | US004Q | 2024-11-08T14:14:27.926Z | 2024-11-09T14:18:52.814Z |
5497847 | 5497847 | 20241107053424_zK2zv | US004Q | 2024-11-08T14:14:26.739Z | 2024-11-09T14:18:52.709Z |
5497763 | 5497763 | 20241107050117_cnTAQ | US004Q | 2024-11-08T14:14:19.277Z | 2024-11-09T14:18:51.616Z |
5497752 | 5497752 | 20241107045920_t1lA1 | US004Q | 2024-11-08T14:14:18.223Z | 2024-11-09T14:18:51.504Z |
5497699 | 5497699 | 20241107043609_gP30F | US004Q | 2024-11-08T14:14:13.134Z | 2024-11-09T14:18:50.809Z |
5497466 | 5497466 | 20241107034531_koP1d | US004Q | 2024-11-08T14:13:49.511Z | 2024-11-09T14:18:43.951Z |
5497223 | 5497223 | 20241107025951_pmnN4 | US004Q | 2024-11-08T14:13:22.654Z | 2024-11-09T14:18:37.526Z |
5497039 | 5497039 | 20241107023217_Dbb2e | US004Q | 2024-11-08T14:13:06.942Z | 2024-11-09T14:18:34.634Z |
5496588 | 5496588 | 20241107005814_nPEax | US004Q | 2024-11-08T14:12:29.088Z | 2024-11-09T14:18:26.157Z |
5496526 | 5496526 | 20241107004540_cRKyc | US004Q | 2024-11-08T14:12:19.945Z | 2024-11-09T14:18:24.232Z |
5492731 | 5492731 | 20241107094636_zs7gv | US004Q | 2024-11-08T14:01:59.146Z | 2024-11-09T14:16:27.439Z |
5492665 | 5492665 | 20241107092846_2NkgE | US004Q | 2024-11-08T14:01:50.818Z | 2024-11-09T14:16:27.424Z |
5492616 | 5492616 | 20241107091754_M9YAa | US004Q | 2024-11-08T14:01:35.541Z | 2024-11-09T14:16:27.413Z |
5492444 | 5492444 | 20241107083506_IllQo | US004Q | 2024-11-08T14:01:11.763Z | 2024-11-09T14:16:27.374Z |
5492357 | 5492357 | 20241107081357_rHzbk | US004Q | 2024-11-08T14:00:52.010Z | 2024-11-09T14:16:27.353Z |
5492343 | 5492343 | 20241107081146_V6H22 | US004Q | 2024-11-08T14:00:49.663Z | 2024-11-09T14:16:27.349Z |
5492303 | 5492303 | 20241107080411_uUn7w | US004Q | 2024-11-08T14:00:44.215Z | 2024-11-09T14:16:27.339Z |
5492283 | 5492283 | 20241107075504_jMqhH | US004Q | 2024-11-08T14:00:41.632Z | 2024-11-09T14:16:27.334Z |
5492235 | 5492235 | 20241107073955_JNxS2 | US004Q | 2024-11-08T14:00:35.493Z | 2024-11-09T14:16:27.325Z |
5492233 | 5492233 | 20241107073921_T3lQK | US004Q | 2024-11-08T14:00:35.196Z | 2024-11-09T14:16:27.324Z |
5492106 | 5492106 | 20241107064034_C15Ve | US004Q | 2024-11-08T14:00:11.813Z | 2024-11-09T14:16:27.276Z |
5491905 | 5491905 | 20241106061336_AbX6E | US004Q | 2024-11-07T14:17:18.991Z | 2024-11-09T14:20:15.989Z |
5491890 | 5491890 | 20241106060319_VNdNq | US004Q | 2024-11-07T14:17:17.718Z | 2024-11-09T14:20:15.881Z |
5491859 | 5491859 | 20241106053601_rIsZ3 | US004Q | 2024-11-07T14:17:13.119Z | 2024-11-09T14:20:15.446Z |
5491748 | 5491748 | 20241106045546_W8yJD | US004Q | 2024-11-07T14:16:54.010Z | 2024-11-09T14:20:14.124Z |
5491743 | 5491743 | 20241106045236_sKe38 | US004Q | 2024-11-07T14:16:53.261Z | 2024-11-09T14:20:14.073Z |
5491735 | 5491735 | 20241106044924_A3Ozx | US004Q | 2024-11-07T14:16:52.430Z | 2024-11-09T14:20:14.025Z |
5491707 | 5491707 | 20241106043547_xYsKO | US004Q | 2024-11-07T14:16:49.264Z | 2024-11-09T14:20:13.316Z |
5491674 | 5491674 | 20241106042232_MCujM | US004Q | 2024-11-07T14:16:43.627Z | 2024-11-09T14:20:12.672Z |
5491628 | 5491628 | 20241106040700_Ojwxn | US004Q | 2024-11-07T14:16:32.664Z | 2024-11-09T14:20:12.036Z |
5491620 | 5491620 | 20241106040347_gT8jn | US004Q | 2024-11-07T14:16:31.657Z | 2024-11-09T14:20:11.943Z |
5491525 | 5491525 | 20241106033512_WpY7g | US004Q | 2024-11-07T14:16:19.686Z | 2024-11-09T14:20:10.218Z |
5491509 | 5491509 | 20241106032945_qDV2F | US004Q | 2024-11-07T14:16:15.933Z | 2024-11-09T14:20:09.799Z |
5491363 | 5491363 | 20241106030523_dSYvQ | US004Q | 2024-11-07T14:15:57.485Z | 2024-11-09T14:20:07.181Z |
5491334 | 5491334 | 20241106025834_WX22y | US004Q | 2024-11-07T14:15:53.378Z | 2024-11-09T14:20:06.854Z |
5491306 | 5491306 | 20241106025230_OU99S | US004Q | 2024-11-07T14:15:49.892Z | 2024-11-09T14:20:06.500Z |
5491093 | 5491093 | 20241106015422_fbceR | US004Q | 2024-11-07T14:15:18.293Z | 2024-11-09T14:20:03.919Z |
5486462 | 5486462 | 20241106114440_NTnhm | US004Q | 2024-11-07T14:03:02.838Z | 2024-11-09T14:16:47.083Z |
5486409 | 5486409 | 20241106112518_a6wOj | US004Q | 2024-11-07T14:02:50.715Z | 2024-11-09T14:16:44.689Z |
5486389 | 5486389 | 20241106111718_b7Bbi | US004Q | 2024-11-07T14:02:47.151Z | 2024-11-09T14:16:44.357Z |
5486387 | 5486387 | 20241106111558_d48gC | US004Q | 2024-11-07T14:02:46.674Z | 2024-11-09T14:16:44.302Z |
5486316 | 5486316 | 20241106103938_oV4bA | US004Q | 2024-11-07T14:02:33.311Z | 2024-11-09T14:16:42.181Z |
5486270 | 5486270 | 20241106102030_dh4Xs | US004Q | 2024-11-07T14:02:23.211Z | 2024-11-09T14:16:40.574Z |
5486264 | 5486264 | 20241106101913_i7t2P | US004Q | 2024-11-07T14:02:22.436Z | 2024-11-09T14:16:40.500Z |
5486151 | 5486151 | 20241106095333_UWmVX | US004Q | 2024-11-07T14:02:04.410Z | 2024-11-09T14:16:38.701Z |
5486109 | 5486109 | 20241106093812_5r6tH | US004Q | 2024-11-07T14:01:53.403Z | 2024-11-09T14:16:38.065Z |
5486103 | 5486103 | 20241106093423_307ob | US004Q | 2024-11-07T14:01:50.450Z | 2024-11-09T14:16:37.859Z |
5486101 | 5486101 | 20241106093403_kgEEe | US004Q | 2024-11-07T14:01:48.879Z | 2024-11-09T14:16:37.822Z |
5486029 | 5486029 | 20241106091515_i2AoO | US004Q | 2024-11-07T14:01:35.301Z | 2024-11-09T14:16:36.269Z |
5486018 | 5486018 | 20241106091157_eGQgl | US004Q | 2024-11-07T14:01:32.633Z | 2024-11-09T14:16:36.122Z |
5486014 | 5486014 | 20241106091144_A2U4f | US004Q | 2024-11-07T14:01:30.595Z | 2024-11-09T14:16:36.073Z |
5485990 | 5485990 | 20241106090302_1Oeas | US004Q | 2024-11-07T14:01:25.311Z | 2024-11-09T14:16:35.747Z |
5485911 | 5485911 | 20241106082902_5t6en | US004Q | 2024-11-07T14:01:07.250Z | 2024-11-09T14:16:34.405Z |
5485909 | 5485909 | 20241106082901_26FEP | US004Q | 2024-11-07T14:01:06.859Z | 2024-11-09T14:16:34.358Z |
5485875 | 5485875 | 20241106081017_v32iC | US004Q | 2024-11-07T14:00:56.813Z | 2024-11-09T14:16:33.799Z |
5485865 | 5485865 | 20241106080635_52Kez | US004Q | 2024-11-07T14:00:53.358Z | 2024-11-09T14:16:33.701Z |
5485859 | 5485859 | 20241106080151_ySKGV | US004Q | 2024-11-07T14:00:52.108Z | 2024-11-09T14:16:33.568Z |
5485830 | 5485830 | 20241106074851_u9742 | US004Q | 2024-11-07T14:00:45.291Z | 2024-11-09T14:16:33.018Z |
5485792 | 5485792 | 20241106072936_7HC3T | US004Q | 2024-11-07T14:00:37.887Z | 2024-11-09T14:16:32.438Z |
5485754 | 5485754 | 20241106071912_m1J6j | US004Q | 2024-11-07T14:00:29.663Z | 2024-11-09T14:16:31.666Z |
5485692 | 5485692 | 20241106064543_rIid8 | US004Q | 2024-11-07T14:00:17.146Z | 2024-11-09T14:16:30.722Z |
5478763 | 5478763 | 20241104054906_YyLs6 | US004Q | 2024-11-05T14:18:48.010Z | 2024-11-09T14:22:31.172Z |
5478658 | 5478658 | 20241104045457_sVJKC | US004Q | 2024-11-05T14:18:38.457Z | 2024-11-09T14:22:30.512Z |
5470871 | 5470871 | 20241104095651_gWMSg | US004Q | 2024-11-05T14:02:08.240Z | 2024-11-09T14:20:25.471Z |
5470700 | 5470700 | 20241104092605_vTwe2 | US004Q | 2024-11-05T14:01:35.512Z | 2024-11-09T14:20:23.290Z |
5470694 | 5470694 | 20241104092239_MSm5V | US004Q | 2024-11-05T14:01:34.089Z | 2024-11-09T14:20:23.090Z |
5459139 | 5459139 | 20241101101526_uTRAu | US004Q | 2024-11-03T14:11:23.919Z | 2024-11-09T14:23:16.729Z |
5459101 | 5459101 | 20241101100753_IEzih | US004Q | 2024-11-03T14:11:20.106Z | 2024-11-09T14:23:16.417Z |
5458779 | 5458779 | 20241101091751_cZIdk | US004Q | 2024-11-03T14:10:36.455Z | 2024-11-09T14:23:14.438Z |
5458525 | 5458525 | 20241101083749_EunIZ | US004Q | 2024-11-03T14:09:55.022Z | 2024-11-09T14:23:12.764Z |
5458501 | 5458501 | 20241101083541_BSr6X | US004Q | 2024-11-03T14:09:51.737Z | 2024-11-09T14:23:12.607Z |
5458492 | 5458492 | 20241101083503_OUi6j | US004Q | 2024-11-03T14:09:51.095Z | 2024-11-09T14:23:12.578Z |
5458490 | 5458490 | 20241101083500_ZXlc3 | US004Q | 2024-11-03T14:09:50.839Z | 2024-11-09T14:23:12.480Z |
5458479 | 5458479 | 20241101083316_0b832 | US004Q | 2024-11-03T14:09:49.557Z | 2024-11-09T14:23:12.378Z |
5452959 | 5452959 | 20241101055212_aKpxv | US004Q | 2024-11-02T12:19:38.298Z | 2024-11-09T14:24:37.207Z |
5452815 | 5452815 | 20241101044443_Xinz4 | US004Q | 2024-11-02T12:19:24.525Z | 2024-11-09T14:24:34.198Z |
5452644 | 5452644 | 20241101035828_ce3cB | US004Q | 2024-11-02T12:19:08.667Z | 2024-11-09T14:24:32.322Z |
5452449 | 5452449 | 20241101031452_3d3xk | US004Q | 2024-11-02T12:18:49.809Z | 2024-11-09T14:24:31.135Z |
5452370 | 5452370 | 20241101030000_cg2jC | US004Q | 2024-11-02T12:18:43.581Z | 2024-11-09T14:24:30.772Z |
5451701 | 5451701 | 20241101004943_mDP2d | US004Q | 2024-11-02T12:17:52.790Z | 2024-11-09T14:24:25.030Z |
5451697 | 5451697 | 20241101004840_7Xd2R | US004Q | 2024-11-02T12:17:52.347Z | 2024-11-09T14:24:25.020Z |
5444966 | 5444966 | 20241101070700_8hrqr | US004Q | 2024-11-02T12:00:20.708Z | 2024-11-09T14:23:08.538Z |
5444961 | 5444961 | 20241101070002_3FCEE | US004Q | 2024-11-02T12:00:19.498Z | 2024-11-09T14:23:08.119Z |
5444945 | 5444945 | 20241101065656_hkA8h | US004Q | 2024-11-02T12:00:16.756Z | 2024-11-09T14:23:07.891Z |
5414394 | 5414394 | 20241027113615_ReYvb | US004Q | 2024-10-30T12:07:20.097Z | 2024-11-05T14:27:00.261Z |
5414210 | 5414210 | 20241027111511_q5vxc | US004Q | 2024-10-30T12:06:50.678Z | 2024-11-05T14:26:59.664Z |
5414094 | 5414094 | 20241027110431_TkmQS | US004Q | 2024-10-30T12:06:36.540Z | 2024-11-05T14:26:59.176Z |
5413994 | 5413994 | 20241027105307_xWZi3 | US004Q | 2024-10-30T12:06:25.290Z | 2024-11-05T14:26:58.976Z |
5412470 | 5412470 | 20241026062811_9nSWQ | US004Q | 2024-10-29T12:22:16.198Z | 2024-11-03T14:27:41.800Z |
5412465 | 5412465 | 20241026061627_tbG25 | US004Q | 2024-10-29T12:22:15.900Z | 2024-11-03T14:27:41.775Z |
5412447 | 5412447 | 20241026021600_bF9MM | US004Q | 2024-10-29T12:21:56.835Z | 2024-11-03T14:27:34.855Z |
5412445 | 5412445 | 20241026013125_rbNPO | US004Q | 2024-10-29T12:21:52.470Z | 2024-11-03T14:27:33.029Z |
5412264 | 5412264 | 20241027101809_aWDY3 | US004Q | 2024-10-29T12:19:35.303Z | 2024-11-05T14:26:58.007Z |
5412238 | 5412238 | 20241027101426_bhX0i | US004Q | 2024-10-29T12:19:34.552Z | 2024-11-05T14:26:57.928Z |
5412190 | 5412190 | 20241027100815_6LfkT | US004Q | 2024-10-29T12:19:32.809Z | 2024-11-05T14:26:57.835Z |
5412183 | 5412183 | 20241027100739_hfDji | US004Q | 2024-10-29T12:19:31.550Z | 2024-11-05T14:26:57.822Z |
5412133 | 5412133 | 20241027100338_AWkLI | US004Q | 2024-10-29T12:19:29.404Z | 2024-11-05T14:26:57.674Z |
5412131 | 5412131 | 20241027100304_T8Wc1 | US004Q | 2024-10-29T12:19:29.171Z | 2024-11-05T14:26:57.658Z |
5412129 | 5412129 | 20241027100251_iGciy | US004Q | 2024-10-29T12:19:29.050Z | 2024-11-05T14:26:57.656Z |
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);