participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,359 rows where station_code = "USV002" 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 |
---|---|---|---|---|---|
3983401 | 3983401 | 20240217121551_wYyDG | USV002 | 2024-02-18T14:13:16.805Z | 2024-02-25T14:19:38.029Z |
3982466 | 3982466 | 20240217094530_mJRoc | USV002 | 2024-02-18T14:09:00.751Z | 2024-02-25T14:19:11.701Z |
3982394 | 3982394 | 20240217092557_L2yfM | USV002 | 2024-02-18T14:08:46.756Z | 2024-02-25T14:19:09.273Z |
3982328 | 3982328 | 20240217090216_44aXD | USV002 | 2024-02-18T14:08:37.759Z | 2024-02-25T14:19:06.678Z |
3982219 | 3982219 | 20240217080802_J1LRO | USV002 | 2024-02-18T14:08:25.598Z | 2024-02-25T14:19:01.779Z |
3978528 | 3978528 | 20240216111145_h3mby | USV002 | 2024-02-17T14:14:26.255Z | 2024-02-24T14:24:27.783Z |
3978343 | 3978343 | 20240216104238_Cg2xd | USV002 | 2024-02-17T14:14:08.764Z | 2024-02-24T14:24:23.826Z |
3978223 | 3978223 | 20240216102553_0SY5z | USV002 | 2024-02-17T14:14:00.634Z | 2024-02-24T14:24:22.202Z |
3977977 | 3977977 | 20240215121127_uEKPd | USV002 | 2024-02-17T14:13:40.409Z | 2024-02-23T14:21:40.902Z |
3976869 | 3976869 | 20240216085024_cg2bc | USV002 | 2024-02-17T14:09:10.658Z | 2024-02-24T14:24:10.764Z |
3976815 | 3976815 | 20240216083549_pSHc5 | USV002 | 2024-02-17T14:09:00.324Z | 2024-02-24T14:24:09.000Z |
3976798 | 3976798 | 20240216083123_X2dl0 | USV002 | 2024-02-17T14:08:56.039Z | 2024-02-24T14:24:08.581Z |
3976778 | 3976778 | 20240216081744_xaXa9 | USV002 | 2024-02-17T14:08:50.601Z | 2024-02-24T14:24:07.784Z |
3976621 | 3976621 | 20240216072921_HdmBd | USV002 | 2024-02-17T14:08:31.981Z | 2024-02-24T14:24:04.186Z |
3976600 | 3976600 | 20240216071826_6bXGx | USV002 | 2024-02-17T14:08:29.808Z | 2024-02-24T14:24:03.796Z |
3976430 | 3976430 | 20240216060126_zf7nH | USV002 | 2024-02-17T14:08:02.446Z | 2024-02-24T14:23:57.629Z |
3976325 | 3976325 | 20240216045916_ZwyFW | USV002 | 2024-02-17T14:07:46.567Z | 2024-02-24T14:23:53.424Z |
3974271 | 3974271 | 20240215130730_wcHZ3 | USV002 | 2024-02-17T14:00:18.156Z | 2024-02-24T14:22:44.594Z |
3973608 | 3973608 | 20240215084351_jC2a9 | USV002 | 2024-02-16T14:13:13.618Z | 2024-02-23T14:21:20.657Z |
3971855 | 3971855 | 20240215073837_Va1eY | USV002 | 2024-02-16T14:07:29.411Z | 2024-02-23T14:21:16.810Z |
3971735 | 3971735 | 20240215065700_E8k0v | USV002 | 2024-02-16T14:07:17.173Z | 2024-02-23T14:21:14.498Z |
3971429 | 3971429 | 20240215040518_3VDnE | USV002 | 2024-02-16T14:06:31.954Z | 2024-02-23T14:21:07.389Z |
3971318 | 3971318 | 20240215031337_hBNAr | USV002 | 2024-02-16T14:06:05.810Z | 2024-02-23T14:21:04.135Z |
3874875 | 3874875 | 20240120104356_o9Phl | USV002 | 2024-01-23T14:11:24.899Z | 2024-01-28T14:20:25.954Z |
3869502 | 3869502 | 20240119131159_pqLkR | USV002 | 2024-01-22T14:10:43.971Z | 2024-01-27T14:21:21.624Z |
3869387 | 3869387 | 20240119124444_N5JwY | USV002 | 2024-01-22T14:10:30.730Z | 2024-01-27T14:21:16.875Z |
3869226 | 3869226 | 20240119120717_RJeYe | USV002 | 2024-01-22T14:10:16.422Z | 2024-01-27T14:21:12.663Z |
3868513 | 3868513 | 20240119085456_pVXqK | USV002 | 2024-01-22T14:08:57.180Z | 2024-01-27T14:20:50.388Z |
3868497 | 3868497 | 20240119085057_Ye1tm | USV002 | 2024-01-22T14:08:56.201Z | 2024-01-27T14:20:50.192Z |
3868368 | 3868368 | 20240119082419_2u8w9 | USV002 | 2024-01-22T14:08:34.406Z | 2024-01-27T14:20:45.159Z |
3867974 | 3867974 | 20240119063901_MuI0P | USV002 | 2024-01-22T14:07:55.245Z | 2024-01-27T14:20:30.204Z |
3867933 | 3867933 | 20240119063437_YeYyB | USV002 | 2024-01-22T14:07:50.633Z | 2024-01-27T14:20:29.495Z |
3867558 | 3867558 | 20240119061608_cDk0z | USV002 | 2024-01-22T14:07:38.853Z | 2024-01-27T14:20:24.382Z |
3864721 | 3864721 | 20240119035016_hKOsp | USV002 | 2024-01-22T14:04:51.363Z | 2024-01-27T14:19:54.551Z |
3863497 | 3863497 | 20240119025123_cRLV7 | USV002 | 2024-01-22T14:03:42.540Z | 2024-01-27T14:19:30.567Z |
3859182 | 3859182 | 20240118124725_vSXgx | USV002 | 2024-01-21T14:15:55.533Z | 2024-01-26T14:22:24.355Z |
3858914 | 3858914 | 20240118120102_ephXb | USV002 | 2024-01-21T14:15:28.345Z | 2024-01-26T14:22:16.957Z |
3858731 | 3858731 | 20240118113604_s2xjP | USV002 | 2024-01-21T14:14:58.954Z | 2024-01-26T14:22:10.679Z |
3858628 | 3858628 | 20240118112013_4hLiU | USV002 | 2024-01-21T14:14:49.543Z | 2024-01-26T14:22:07.474Z |
3858330 | 3858330 | 20240118102934_WWOMf | USV002 | 2024-01-21T14:14:09.904Z | 2024-01-26T14:22:00.767Z |
3857677 | 3857677 | 20240118072323_LeLPe | USV002 | 2024-01-21T14:11:55.108Z | 2024-01-26T14:21:42.680Z |
3857199 | 3857199 | 20240118062420_VJXCA | USV002 | 2024-01-21T14:10:51.598Z | 2024-01-26T14:21:35.475Z |
3855920 | 3855920 | 20240118051143_An3Op | USV002 | 2024-01-21T14:07:41.708Z | 2024-01-26T14:21:19.562Z |
3852948 | 3852948 | 20240117132309_7s3W3 | USV002 | 2024-01-20T14:12:56.940Z | 2024-01-21T14:21:07.466Z |
3852737 | 3852737 | 20240117124439_AiULf | USV002 | 2024-01-20T14:12:40.625Z | 2024-01-21T14:21:00.453Z |
3852519 | 3852519 | 20240117120346_BeGUD | USV002 | 2024-01-20T14:12:15.327Z | 2024-01-21T14:20:54.613Z |
3852366 | 3852366 | 20240117113952_5UlAd | USV002 | 2024-01-20T14:12:04.900Z | 2024-01-21T14:20:49.747Z |
3851130 | 3851130 | 20240117070447_28K9Q | USV002 | 2024-01-20T14:10:06.691Z | 2024-01-21T14:20:25.085Z |
3850863 | 3850863 | 20240117061432_NLJZ3 | USV002 | 2024-01-20T14:09:29.657Z | 2024-01-21T14:20:15.985Z |
3842233 | 3842233 | 20240116115934_6oPai | USV002 | 2024-01-19T14:08:37.395Z | 2024-01-25T14:21:59.982Z |
3841049 | 3841049 | 20240116094421_2U4N7 | USV002 | 2024-01-19T14:06:21.754Z | 2024-01-25T14:21:43.422Z |
3840964 | 3840964 | 20240116093416_cnfTk | USV002 | 2024-01-19T14:06:14.117Z | 2024-01-25T14:21:41.921Z |
3840606 | 3840606 | 20240116081857_gWGja | USV002 | 2024-01-19T14:05:22.844Z | 2024-01-25T14:21:36.592Z |
3840449 | 3840449 | 20240116073609_rSDQ7 | USV002 | 2024-01-19T14:05:00.349Z | 2024-01-25T14:21:34.247Z |
3840299 | 3840299 | 20240116065121_UMK9m | USV002 | 2024-01-19T14:04:41.819Z | 2024-01-25T14:21:32.737Z |
3839892 | 3839892 | 20240116060432_stw6A | USV002 | 2024-01-19T14:04:00.148Z | 2024-01-25T14:21:27.711Z |
3839418 | 3839418 | 20240116050310_rNL2L | USV002 | 2024-01-19T14:03:09.427Z | 2024-01-25T14:21:20.585Z |
3839325 | 3839325 | 20240116044803_v2SCd | USV002 | 2024-01-19T14:02:56.961Z | 2024-01-25T14:21:19.158Z |
3838953 | 3838953 | 20240116034231_bnLMj | USV002 | 2024-01-19T14:02:02.224Z | 2024-01-25T14:21:12.342Z |
3833731 | 3833731 | 20240115124740_t5UBX | USV002 | 2024-01-18T14:09:03.824Z | 2024-01-24T14:18:53.212Z |
3833348 | 3833348 | 20240115120202_rKT6H | USV002 | 2024-01-18T14:08:06.735Z | 2024-01-24T14:18:50.216Z |
3833297 | 3833297 | 20240115115611_Px7E7 | USV002 | 2024-01-18T14:08:00.924Z | 2024-01-24T14:18:49.655Z |
3833225 | 3833225 | 20240115114505_26eQ3 | USV002 | 2024-01-18T14:07:51.764Z | 2024-01-24T14:18:49.071Z |
3833169 | 3833169 | 20240115113757_qjtt1 | USV002 | 2024-01-18T14:07:47.239Z | 2024-01-24T14:18:48.553Z |
3833043 | 3833043 | 20240115112014_4ssJt | USV002 | 2024-01-18T14:07:24.325Z | 2024-01-24T14:18:47.375Z |
3828427 | 3828427 | 20240114124846_m9AZ2 | USV002 | 2024-01-17T14:10:40.455Z | 2024-01-23T14:25:04.330Z |
3828041 | 3828041 | 20240114101832_FKq3u | USV002 | 2024-01-17T14:09:46.884Z | 2024-01-23T14:24:58.482Z |
3828006 | 3828006 | 20240114093327_Uby9Z | USV002 | 2024-01-17T14:09:42.931Z | 2024-01-23T14:24:57.624Z |
3827536 | 3827536 | 20240114043731_YPLYM | USV002 | 2024-01-17T14:08:43.689Z | 2024-01-23T14:24:50.848Z |
3827398 | 3827398 | 20240114035005_3PjXb | USV002 | 2024-01-17T14:08:16.169Z | 2024-01-23T14:24:48.523Z |
3827159 | 3827159 | 20240115093239_QJ3Hw | USV002 | 2024-01-17T14:07:29.831Z | 2024-01-24T14:18:40.399Z |
3825869 | 3825869 | 20240115054705_OmryC | USV002 | 2024-01-17T14:05:33.644Z | 2024-01-24T14:18:26.896Z |
3825200 | 3825200 | 20240115050112_nsEOf | USV002 | 2024-01-17T14:04:49.843Z | 2024-01-24T14:18:23.813Z |
3823352 | 3823352 | 20240115022722_KUQ5O | USV002 | 2024-01-17T14:01:51.204Z | 2024-01-24T14:18:12.326Z |
3822466 | 3822466 | 20240114024621_Pt33t | USV002 | 2024-01-16T14:15:39.619Z | 2024-01-23T14:24:45.912Z |
3822361 | 3822361 | 20240114020208_Iy6sR | USV002 | 2024-01-16T14:15:21.583Z | 2024-01-23T14:24:44.298Z |
3818084 | 3818084 | 20240113121701_7ViPs | USV002 | 2024-01-16T14:07:02.928Z | 2024-01-22T14:22:34.876Z |
3817750 | 3817750 | 20240113114326_aq2GF | USV002 | 2024-01-16T14:06:18.595Z | 2024-01-22T14:22:28.101Z |
3816916 | 3816916 | 20240113101412_OQBFK | USV002 | 2024-01-16T14:04:15.809Z | 2024-01-22T14:22:12.762Z |
3816556 | 3816556 | 20240113092509_g0Il4 | USV002 | 2024-01-16T14:03:21.227Z | 2024-01-22T14:22:08.597Z |
3816546 | 3816546 | 20240113092145_ooB13 | USV002 | 2024-01-16T14:03:19.494Z | 2024-01-22T14:22:08.539Z |
3814678 | 3814678 | 20240113052811_WyD30 | USV002 | 2024-01-15T14:14:29.139Z | 2024-01-22T14:21:54.325Z |
3814623 | 3814623 | 20240113051353_Dlstx | USV002 | 2024-01-15T14:14:23.340Z | 2024-01-22T14:21:53.359Z |
3814494 | 3814494 | 20240113044345_3tyoq | USV002 | 2024-01-15T14:14:07.327Z | 2024-01-22T14:21:51.099Z |
3811175 | 3811175 | 20240112131938_OXdsf | USV002 | 2024-01-15T14:10:00.627Z | 2024-01-21T14:27:47.365Z |
3810262 | 3810262 | 20240112115605_4MljB | USV002 | 2024-01-15T14:08:17.563Z | 2024-01-21T14:27:43.791Z |
3808910 | 3808910 | 20240112081505_a1vGW | USV002 | 2024-01-15T14:05:18.641Z | 2024-01-21T14:27:37.704Z |
3808870 | 3808870 | 20240112080454_Nsk2p | USV002 | 2024-01-15T14:05:12.852Z | 2024-01-21T14:27:37.382Z |
3808789 | 3808789 | 20240112073621_V7wY4 | USV002 | 2024-01-15T14:05:02.691Z | 2024-01-21T14:27:36.380Z |
3808665 | 3808665 | 20240112063151_IFOTH | USV002 | 2024-01-15T14:04:41.544Z | 2024-01-21T14:27:35.473Z |
3808637 | 3808637 | 20240112062009_1ms11 | USV002 | 2024-01-15T14:04:38.736Z | 2024-01-21T14:27:35.400Z |
3808081 | 3808081 | 20240112023059_1Lntr | USV002 | 2024-01-15T14:02:28.106Z | 2024-01-21T14:27:28.469Z |
3807751 | 3807751 | 20240113024910_C72Kl | USV002 | 2024-01-15T14:01:01.476Z | 2024-01-22T14:21:42.539Z |
3807723 | 3807723 | 20240113023023_Kc6En | USV002 | 2024-01-15T14:00:53.100Z | 2024-01-22T14:21:41.900Z |
3807706 | 3807706 | 20240113022256_tU783 | USV002 | 2024-01-15T14:00:47.450Z | 2024-01-22T14:21:41.609Z |
3804940 | 3804940 | 20240111132320_LjfQ3 | USV002 | 2024-01-14T14:09:20.114Z | 2024-01-20T14:22:52.314Z |
3804924 | 3804924 | 20240111131913_oP3K6 | USV002 | 2024-01-14T14:09:18.648Z | 2024-01-20T14:22:52.232Z |
3804256 | 3804256 | 20240111112436_9Hf6t | USV002 | 2024-01-14T14:08:07.253Z | 2024-01-20T14:22:50.174Z |
3804179 | 3804179 | 20240111110818_cvJPM | USV002 | 2024-01-14T14:07:59.023Z | 2024-01-20T14:22:49.796Z |
3803355 | 3803355 | 20240111072539_Kfsqx | USV002 | 2024-01-14T14:05:58.263Z | 2024-01-20T14:22:47.212Z |
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);