participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,383 rows where station_code = "US001V" 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 |
---|---|---|---|---|---|
5478829 | 5478829 | 20241104063430_rlLVm | US001V | 2024-11-05T14:18:54.272Z | 2024-11-05T14:18:58.988Z |
5478804 | 5478804 | 20241104061550_fBDJI | US001V | 2024-11-05T14:18:52.535Z | 2024-11-05T14:18:58.983Z |
5478792 | 5478792 | 20241104060850_8kP3G | US001V | 2024-11-05T14:18:50.964Z | 2024-11-05T14:18:58.980Z |
5478788 | 5478788 | 20241104060456_UVfpA | US001V | 2024-11-05T14:18:50.768Z | 2024-11-05T14:18:58.979Z |
5478728 | 5478728 | 20241104052622_dZ6VZ | US001V | 2024-11-05T14:18:45.275Z | 2024-11-05T14:18:58.963Z |
5471662 | 5471662 | 20241104121953_6zYde | US001V | 2024-11-05T14:04:15.910Z | 2024-11-05T14:04:15.910Z |
5471354 | 5471354 | 20241104113131_XAKvP | US001V | 2024-11-05T14:03:31.269Z | 2024-11-05T14:03:31.269Z |
5471277 | 5471277 | 20241104112459_34ytr | US001V | 2024-11-05T14:03:17.524Z | 2024-11-05T14:03:17.524Z |
5471194 | 5471194 | 20241104105958_9CeJH | US001V | 2024-11-05T14:03:05.275Z | 2024-11-05T14:03:05.275Z |
5471157 | 5471157 | 20241104105418_oyJfq | US001V | 2024-11-05T14:03:00.024Z | 2024-11-05T14:03:00.024Z |
5471077 | 5471077 | 20241104104306_yHbXh | US001V | 2024-11-05T14:02:45.824Z | 2024-11-05T14:02:45.824Z |
5471020 | 5471020 | 20241104103232_vwY4N | US001V | 2024-11-05T14:02:31.521Z | 2024-11-05T14:02:31.521Z |
5471018 | 5471018 | 20241104103204_JLGZy | US001V | 2024-11-05T14:02:31.152Z | 2024-11-05T14:02:31.152Z |
5470969 | 5470969 | 20241104101728_jyFtI | US001V | 2024-11-05T14:02:24.765Z | 2024-11-05T14:02:24.765Z |
5470918 | 5470918 | 20241104100313_2j6Ty | US001V | 2024-11-05T14:02:17.516Z | 2024-11-05T14:02:17.516Z |
5470907 | 5470907 | 20241104100232_peMVq | US001V | 2024-11-05T14:02:15.706Z | 2024-11-05T14:02:15.706Z |
5470840 | 5470840 | 20241104095505_QTF68 | US001V | 2024-11-05T14:02:01.098Z | 2024-11-05T14:02:01.098Z |
5470798 | 5470798 | 20241104095006_BbvsY | US001V | 2024-11-05T14:01:53.953Z | 2024-11-05T14:01:53.953Z |
5470791 | 5470791 | 20241104094819_OrDKu | US001V | 2024-11-05T14:01:52.659Z | 2024-11-05T14:01:52.659Z |
5470697 | 5470697 | 20241104092348_1zfrX | US001V | 2024-11-05T14:01:34.968Z | 2024-11-05T14:01:34.968Z |
5470664 | 5470664 | 20241104091732_Gl2PO | US001V | 2024-11-05T14:01:30.232Z | 2024-11-05T14:01:30.232Z |
5470576 | 5470576 | 20241104085403_Y9za3 | US001V | 2024-11-05T14:01:08.210Z | 2024-11-05T14:01:08.210Z |
5470533 | 5470533 | 20241104083652_mbsQv | US001V | 2024-11-05T14:01:01.431Z | 2024-11-05T14:01:01.431Z |
5470480 | 5470480 | 20241104081447_QRfJr | US001V | 2024-11-05T14:00:51.386Z | 2024-11-05T14:00:51.386Z |
5470461 | 5470461 | 20241104081220_fHXp6 | US001V | 2024-11-05T14:00:46.180Z | 2024-11-05T14:00:46.180Z |
5470459 | 5470459 | 20241104081210_prQL9 | US001V | 2024-11-05T14:00:45.785Z | 2024-11-05T14:00:45.785Z |
5470420 | 5470420 | 20241104080219_pTZpu | US001V | 2024-11-05T14:00:35.740Z | 2024-11-05T14:00:35.740Z |
5470396 | 5470396 | 20241104075351_j2fPh | US001V | 2024-11-05T14:00:29.975Z | 2024-11-05T14:00:29.975Z |
5470386 | 5470386 | 20241104075036_HVemF | US001V | 2024-11-05T14:00:27.984Z | 2024-11-05T14:00:27.984Z |
5470362 | 5470362 | 20241104073800_7uNiy | US001V | 2024-11-05T14:00:23.492Z | 2024-11-05T14:00:23.492Z |
5470356 | 5470356 | 20241104073425_o85Jp | US001V | 2024-11-05T14:00:22.145Z | 2024-11-05T14:00:22.145Z |
5470318 | 5470318 | 20241104070543_GvLZT | US001V | 2024-11-05T14:00:13.623Z | 2024-11-05T14:00:13.623Z |
5470316 | 5470316 | 20241104070237_EtcjW | US001V | 2024-11-05T14:00:13.330Z | 2024-11-05T14:00:13.330Z |
5469838 | 5469838 | 20241103042737_9OANH | US001V | 2024-11-04T14:17:08.007Z | 2024-11-05T14:21:54.219Z |
5469836 | 5469836 | 20241103042729_QRYhV | US001V | 2024-11-04T14:17:07.663Z | 2024-11-05T14:21:54.092Z |
5468830 | 5468830 | 20241103015310_64NyS | US001V | 2024-11-04T14:15:06.786Z | 2024-11-05T14:21:33.202Z |
5463995 | 5463995 | 20241102063054_g3PKO | US001V | 2024-11-03T14:19:28.466Z | 2024-11-05T14:23:15.684Z |
5463856 | 5463856 | 20241102054526_UTTvz | US001V | 2024-11-03T14:19:21.130Z | 2024-11-05T14:23:14.204Z |
5463839 | 5463839 | 20241102053525_S1Uk0 | US001V | 2024-11-03T14:19:19.581Z | 2024-11-05T14:23:14.157Z |
5463732 | 5463732 | 20241102044727_A0myi | US001V | 2024-11-03T14:19:12.130Z | 2024-11-05T14:23:13.050Z |
5463696 | 5463696 | 20241102043936_zqYgl | US001V | 2024-11-03T14:19:10.540Z | 2024-11-05T14:23:12.722Z |
5463685 | 5463685 | 20241102043446_0Y28A | US001V | 2024-11-03T14:19:09.906Z | 2024-11-05T14:23:12.643Z |
5463480 | 5463480 | 20241102034509_4uj3M | US001V | 2024-11-03T14:18:49.860Z | 2024-11-05T14:23:10.339Z |
5463387 | 5463387 | 20241102033107_qa6Hw | US001V | 2024-11-03T14:18:41.132Z | 2024-11-05T14:23:09.200Z |
5463182 | 5463182 | 20241102024903_oqJIB | US001V | 2024-11-03T14:18:25.589Z | 2024-11-05T14:23:06.605Z |
5459865 | 5459865 | 20241101120719_3kEQV | US001V | 2024-11-03T14:12:42.571Z | 2024-11-05T14:22:31.765Z |
5455310 | 5455310 | 20241102071624_Rwkmy | US001V | 2024-11-03T14:00:30.715Z | 2024-11-05T14:19:05.439Z |
5455304 | 5455304 | 20241102071440_IxppC | US001V | 2024-11-03T14:00:29.683Z | 2024-11-05T14:19:05.237Z |
5455221 | 5455221 | 20241102065127_vbB3I | US001V | 2024-11-03T14:00:11.756Z | 2024-11-05T14:19:01.032Z |
5423552 | 5423552 | 20241029105530_EfmEP | US001V | 2024-10-31T12:01:57.094Z | 2024-11-05T14:25:44.712Z |
5423464 | 5423464 | 20241029102654_AK253 | US001V | 2024-10-31T12:01:32.137Z | 2024-11-05T14:25:43.872Z |
5423350 | 5423350 | 20241029094720_aYS1R | US001V | 2024-10-31T12:01:11.631Z | 2024-11-05T14:25:42.957Z |
5423344 | 5423344 | 20241029094448_Mltbd | US001V | 2024-10-31T12:01:10.840Z | 2024-11-05T14:25:42.951Z |
5423326 | 5423326 | 20241029093356_FpYng | US001V | 2024-10-31T12:01:04.187Z | 2024-11-05T14:25:42.871Z |
5423315 | 5423315 | 20241029093013_1lSmN | US001V | 2024-10-31T12:00:58.480Z | 2024-11-05T14:25:42.796Z |
5423307 | 5423307 | 20241029092736_WtfU1 | US001V | 2024-10-31T12:00:57.115Z | 2024-11-05T14:25:42.778Z |
5423281 | 5423281 | 20241029091338_P37FF | US001V | 2024-10-31T12:00:52.382Z | 2024-11-05T14:25:42.495Z |
5423215 | 5423215 | 20241029083415_o4scs | US001V | 2024-10-31T12:00:39.801Z | 2024-11-05T14:25:41.621Z |
5421216 | 5421216 | 20241028050845_2B3u0 | US001V | 2024-10-30T12:19:43.432Z | 2024-11-05T14:27:17.798Z |
5421149 | 5421149 | 20241028044723_hkela | US001V | 2024-10-30T12:19:37.771Z | 2024-11-05T14:27:17.530Z |
5420880 | 5420880 | 20241028035004_SlEHP | US001V | 2024-10-30T12:19:24.162Z | 2024-11-05T14:27:16.622Z |
5420765 | 5420765 | 20241028033252_yhRKZ | US001V | 2024-10-30T12:19:15.475Z | 2024-11-05T14:27:16.267Z |
5420673 | 5420673 | 20241028031837_bSQhc | US001V | 2024-10-30T12:19:09.889Z | 2024-11-05T14:27:16.026Z |
5420667 | 5420667 | 20241028031658_4MHfs | US001V | 2024-10-30T12:19:09.274Z | 2024-11-05T14:27:16.018Z |
5420420 | 5420420 | 20241028024051_jhqZC | US001V | 2024-10-30T12:18:50.559Z | 2024-11-05T14:27:15.402Z |
5419809 | 5419809 | 20241028011225_uxvqU | US001V | 2024-10-30T12:17:54.365Z | 2024-11-05T14:27:13.966Z |
5414728 | 5414728 | 20241027120516_3Gfng | US001V | 2024-10-30T12:08:01.803Z | 2024-11-05T14:27:01.664Z |
5414697 | 5414697 | 20241027120322_3HJgg | US001V | 2024-10-30T12:07:59.291Z | 2024-11-05T14:27:01.528Z |
5414305 | 5414305 | 20241027112558_d6N6v | US001V | 2024-10-30T12:07:10.210Z | 2024-11-05T14:26:59.968Z |
5414301 | 5414301 | 20241027112545_DOKXd | US001V | 2024-10-30T12:07:09.552Z | 2024-11-05T14:26:59.943Z |
5414299 | 5414299 | 20241027112519_YvjWW | US001V | 2024-10-30T12:07:09.293Z | 2024-11-05T14:26:59.942Z |
5414215 | 5414215 | 20241027111549_mTCbX | US001V | 2024-10-30T12:06:52.720Z | 2024-11-05T14:26:59.671Z |
5414042 | 5414042 | 20241027105815_S9iaI | US001V | 2024-10-30T12:06:30.401Z | 2024-11-05T14:26:59.050Z |
5414002 | 5414002 | 20241027105454_4k5EK | US001V | 2024-10-30T12:06:26.329Z | 2024-11-05T14:26:59.007Z |
5413877 | 5413877 | 20241027103812_u330v | US001V | 2024-10-30T12:06:02.078Z | 2024-11-05T14:26:58.596Z |
5413735 | 5413735 | 20241027102230_V33ez | US001V | 2024-10-30T12:05:42.470Z | 2024-11-05T14:26:58.165Z |
5413733 | 5413733 | 20241027102227_imVUU | US001V | 2024-10-30T12:05:42.073Z | 2024-11-05T14:26:58.146Z |
5412265 | 5412265 | 20241027101845_J8HCj | US001V | 2024-10-29T12:19:35.370Z | 2024-11-05T14:26:58.008Z |
5412042 | 5412042 | 20241027095431_EIUJc | US001V | 2024-10-29T12:19:25.375Z | 2024-11-05T14:26:57.346Z |
5411994 | 5411994 | 20241027094934_lYyxg | US001V | 2024-10-29T12:19:22.710Z | 2024-11-05T14:26:57.163Z |
5411983 | 5411983 | 20241027094759_ZuBSX | US001V | 2024-10-29T12:19:21.472Z | 2024-11-05T14:26:57.133Z |
5411766 | 5411766 | 20241027092355_HIvgY | US001V | 2024-10-29T12:19:11.487Z | 2024-11-05T14:26:56.012Z |
5411726 | 5411726 | 20241027091657_lo3Fx | US001V | 2024-10-29T12:19:09.116Z | 2024-11-05T14:26:55.794Z |
5411674 | 5411674 | 20241027091150_wRzSY | US001V | 2024-10-29T12:19:07.042Z | 2024-11-05T14:26:55.513Z |
5411438 | 5411438 | 20241027083916_Fj7pa | US001V | 2024-10-29T12:18:52.681Z | 2024-11-05T14:26:54.263Z |
5411367 | 5411367 | 20241027082908_MidZq | US001V | 2024-10-29T12:18:45.068Z | 2024-11-05T14:26:53.743Z |
5411264 | 5411264 | 20241027082210_HPyxG | US001V | 2024-10-29T12:18:38.187Z | 2024-11-05T14:26:53.259Z |
5411204 | 5411204 | 20241027064224_SYSiv | US001V | 2024-10-29T12:18:33.777Z | 2024-11-04T14:29:07.487Z |
5411157 | 5411157 | 20241027063557_V2tgP | US001V | 2024-10-29T12:18:29.858Z | 2024-11-04T14:29:07.303Z |
5411087 | 5411087 | 20241027062257_GCPQt | US001V | 2024-10-29T12:18:23.727Z | 2024-11-04T14:29:07.081Z |
5411077 | 5411077 | 20241027062133_YPEvh | US001V | 2024-10-29T12:18:22.337Z | 2024-11-04T14:29:07.061Z |
5410959 | 5410959 | 20241027055654_uDUxV | US001V | 2024-10-29T12:18:13.971Z | 2024-11-04T14:29:06.437Z |
5410824 | 5410824 | 20241027053939_Mum0D | US001V | 2024-10-29T12:18:05.751Z | 2024-11-04T14:29:05.636Z |
5410215 | 5410215 | 20241027050023_xzzph | US001V | 2024-10-29T12:17:50.771Z | 2024-11-04T14:29:04.045Z |
5410029 | 5410029 | 20241027044829_okaYK | US001V | 2024-10-29T12:17:46.192Z | 2024-11-04T14:29:03.598Z |
5409903 | 5409903 | 20241027044029_6c84N | US001V | 2024-10-29T12:17:43.856Z | 2024-11-04T14:29:02.914Z |
5409895 | 5409895 | 20241027044003_egIVX | US001V | 2024-10-29T12:17:43.613Z | 2024-11-04T14:29:02.901Z |
5409564 | 5409564 | 20241027042500_bXdGM | US001V | 2024-10-29T12:17:30.527Z | 2024-11-04T14:29:01.957Z |
5409027 | 5409027 | 20241027035604_qQw32 | US001V | 2024-10-29T12:17:01.970Z | 2024-11-04T14:29:00.943Z |
5408597 | 5408597 | 20241027033121_LGl1A | US001V | 2024-10-29T12:16:38.691Z | 2024-11-04T14:28:59.668Z |
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);