participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,440 rows where station_code = "UK005V" 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 |
---|---|---|---|---|---|
5524204 | 5524204 | 20241111033048_gdW9k | UK005V | 2024-11-12T14:16:45.577Z | 2024-11-12T14:18:08.512Z |
5524000 | 5524000 | 20241111030109_zKSRD | UK005V | 2024-11-12T14:16:25.542Z | 2024-11-12T14:18:08.428Z |
5523955 | 5523955 | 20241111025407_4R3t7 | UK005V | 2024-11-12T14:16:22.266Z | 2024-11-12T14:18:08.411Z |
5523892 | 5523892 | 20241111024359_CRZFa | UK005V | 2024-11-12T14:16:19.141Z | 2024-11-12T14:18:08.387Z |
5523688 | 5523688 | 20241111020651_DowG7 | UK005V | 2024-11-12T14:16:07.521Z | 2024-11-12T14:18:08.302Z |
5523673 | 5523673 | 20241111020326_GC2pD | UK005V | 2024-11-12T14:16:06.911Z | 2024-11-12T14:18:08.297Z |
5523632 | 5523632 | 20241111015817_1WpG3 | UK005V | 2024-11-12T14:16:04.912Z | 2024-11-12T14:18:08.281Z |
5523583 | 5523583 | 20241111014944_gxQtI | UK005V | 2024-11-12T14:16:02.000Z | 2024-11-12T14:18:08.260Z |
5523565 | 5523565 | 20241111014631_DNeEO | UK005V | 2024-11-12T14:16:00.590Z | 2024-11-12T14:18:08.251Z |
5523506 | 5523506 | 20241111013817_mNrlK | UK005V | 2024-11-12T14:15:50.253Z | 2024-11-12T14:18:08.227Z |
5430928 | 5430928 | 20241029000523_3tcRN | UK005V | 2024-10-31T12:19:19.125Z | 2024-11-06T14:27:22.279Z |
5409725 | 5409725 | 20241027043228_0ugNh | UK005V | 2024-10-29T12:17:39.447Z | 2024-11-04T14:29:02.186Z |
5409527 | 5409527 | 20241027042329_wiHUZ | UK005V | 2024-10-29T12:17:28.485Z | 2024-11-04T14:29:01.938Z |
5408724 | 5408724 | 20241027033940_xJKLx | UK005V | 2024-10-29T12:16:47.406Z | 2024-11-04T14:29:00.370Z |
5407934 | 5407934 | 20241027025823_jYT3w | UK005V | 2024-10-29T12:15:54.115Z | 2024-11-04T14:28:58.511Z |
5407922 | 5407922 | 20241027025823_t2lcI | UK005V | 2024-10-29T12:15:53.598Z | 2024-11-04T14:28:58.412Z |
5407509 | 5407509 | 20241027023954_3TMor | UK005V | 2024-10-29T12:15:27.771Z | 2024-11-04T14:28:57.810Z |
5407228 | 5407228 | 20241027022720_ekEnm | UK005V | 2024-10-29T12:15:17.885Z | 2024-11-04T14:28:57.254Z |
5406875 | 5406875 | 20241027020604_jFPhF | UK005V | 2024-10-29T12:14:52.345Z | 2024-11-04T14:28:56.541Z |
5406814 | 5406814 | 20241027020020_ATnTy | UK005V | 2024-10-29T12:14:44.361Z | 2024-11-04T14:28:56.464Z |
5406788 | 5406788 | 20241027015948_VWc9O | UK005V | 2024-10-29T12:14:42.191Z | 2024-11-04T14:28:56.383Z |
5406476 | 5406476 | 20241027013944_1aYMh | UK005V | 2024-10-29T12:14:12.261Z | 2024-11-04T14:28:55.740Z |
5405321 | 5405321 | 20241027002845_mUJ3x | UK005V | 2024-10-29T12:12:49.807Z | 2024-11-04T14:28:53.287Z |
5402534 | 5402534 | 20241026195313_LVKHv | UK005V | 2024-10-29T12:07:34.956Z | 2024-11-04T14:28:45.114Z |
5401959 | 5401959 | 20241026181210_XZPqg | UK005V | 2024-10-29T12:05:54.969Z | 2024-11-04T14:28:41.121Z |
5399856 | 5399856 | 20241026050719_jKinQ | UK005V | 2024-10-28T12:20:13.621Z | 2024-11-03T14:27:40.619Z |
5399650 | 5399650 | 20241026044435_4xxYx | UK005V | 2024-10-28T12:20:04.685Z | 2024-11-03T14:27:40.168Z |
5399584 | 5399584 | 20241026043612_3F26A | UK005V | 2024-10-28T12:20:03.245Z | 2024-11-03T14:27:40.016Z |
5399393 | 5399393 | 20241026041435_RzvOD | UK005V | 2024-10-28T12:19:57.883Z | 2024-11-03T14:27:39.596Z |
5398276 | 5398276 | 20241026024009_1HiTy | UK005V | 2024-10-28T12:19:08.743Z | 2024-11-03T14:27:35.765Z |
5397562 | 5397562 | 20241026014028_nsl8j | UK005V | 2024-10-28T12:18:27.973Z | 2024-11-03T14:27:33.405Z |
5397539 | 5397539 | 20241026013856_tI2Qi | UK005V | 2024-10-28T12:18:26.608Z | 2024-11-03T14:27:33.355Z |
5397406 | 5397406 | 20241026012638_3l5He | UK005V | 2024-10-28T12:18:20.316Z | 2024-11-03T14:27:32.797Z |
5397297 | 5397297 | 20241026011622_7nBQs | UK005V | 2024-10-28T12:18:14.868Z | 2024-11-03T14:27:32.551Z |
5384112 | 5384112 | 20241024193725_FmTJ2 | UK005V | 2024-10-27T12:16:47.685Z | 2024-11-02T12:28:26.760Z |
5384025 | 5384025 | 20241024192555_qmi2x | UK005V | 2024-10-27T12:16:43.595Z | 2024-11-02T12:28:26.674Z |
5373343 | 5373343 | 20241024013404_sSWxa | UK005V | 2024-10-26T12:20:08.389Z | 2024-11-01T12:26:58.230Z |
5373116 | 5373116 | 20241024012447_pB4hd | UK005V | 2024-10-26T12:19:58.333Z | 2024-11-01T12:26:58.138Z |
5372087 | 5372087 | 20241024003151_2FxSv | UK005V | 2024-10-26T12:19:07.104Z | 2024-11-01T12:26:57.087Z |
5366158 | 5366158 | 20241024000740_waCpp | UK005V | 2024-10-25T12:18:18.204Z | 2024-11-01T12:26:56.775Z |
5365035 | 5365035 | 20241023231114_Ts9Tg | UK005V | 2024-10-25T12:17:44.039Z | 2024-11-01T12:26:55.833Z |
5364955 | 5364955 | 20241023230559_Q2hrd | UK005V | 2024-10-25T12:17:42.079Z | 2024-11-01T12:26:55.808Z |
5356113 | 5356113 | 20241023045919_xIGJV | UK005V | 2024-10-24T12:21:52.686Z | 2024-10-31T12:30:10.430Z |
5355808 | 5355808 | 20241023042141_X1PhP | UK005V | 2024-10-24T12:21:37.578Z | 2024-10-31T12:30:08.928Z |
5355132 | 5355132 | 20241023031644_rH07F | UK005V | 2024-10-24T12:21:07.645Z | 2024-10-31T12:30:07.324Z |
5354889 | 5354889 | 20241023025339_ErT7v | UK005V | 2024-10-24T12:20:55.757Z | 2024-10-31T12:30:06.682Z |
5354663 | 5354663 | 20241023023852_C63ZW | UK005V | 2024-10-24T12:20:46.047Z | 2024-10-31T12:30:06.224Z |
5354603 | 5354603 | 20241023023507_K8Nsy | UK005V | 2024-10-24T12:20:43.233Z | 2024-10-31T12:30:06.152Z |
5354587 | 5354587 | 20241023023419_rcVa6 | UK005V | 2024-10-24T12:20:41.658Z | 2024-10-31T12:30:06.021Z |
5354278 | 5354278 | 20241023021603_Ft8EM | UK005V | 2024-10-24T12:20:25.372Z | 2024-10-31T12:30:05.579Z |
5353473 | 5353473 | 20241023012725_3CFnW | UK005V | 2024-10-24T12:19:43.787Z | 2024-10-31T12:30:04.276Z |
5353433 | 5353433 | 20241023012526_BS0UC | UK005V | 2024-10-24T12:19:42.624Z | 2024-10-31T12:30:04.250Z |
5352607 | 5352607 | 20241023004138_JFJ2m | UK005V | 2024-10-24T12:19:00.545Z | 2024-10-31T12:30:02.987Z |
5352426 | 5352426 | 20241023003207_wiSvV | UK005V | 2024-10-24T12:18:47.140Z | 2024-10-31T12:30:02.623Z |
5352269 | 5352269 | 20241023002346_hJfiI | UK005V | 2024-10-24T12:18:34.703Z | 2024-10-31T12:30:02.373Z |
5351525 | 5351525 | 20241022233517_w0xF3 | UK005V | 2024-10-24T12:17:37.781Z | 2024-10-31T12:30:00.494Z |
5348969 | 5348969 | 20241022191247_k1TSE | UK005V | 2024-10-24T12:12:41.525Z | 2024-10-31T12:29:54.363Z |
5344766 | 5344766 | 20241022044453_DTR5n | UK005V | 2024-10-23T12:18:50.103Z | 2024-10-30T12:26:51.648Z |
5342341 | 5342341 | 20241022022126_3VIS2 | UK005V | 2024-10-23T12:16:48.494Z | 2024-10-30T12:26:48.293Z |
5341785 | 5341785 | 20241022015231_VjJ31 | UK005V | 2024-10-23T12:16:14.504Z | 2024-10-30T12:26:47.457Z |
5341758 | 5341758 | 20241022015112_KWCsg | UK005V | 2024-10-23T12:16:12.051Z | 2024-10-30T12:26:47.445Z |
5340527 | 5340527 | 20241022002559_CHEGA | UK005V | 2024-10-23T12:14:37.303Z | 2024-10-30T12:26:45.960Z |
5340342 | 5340342 | 20241022000721_oL2fK | UK005V | 2024-10-23T12:14:29.232Z | 2024-10-30T12:26:45.691Z |
5321555 | 5321555 | 20241018051137_t9Mp1 | UK005V | 2024-10-19T12:07:48.463Z | 2024-10-26T12:27:56.968Z |
5321300 | 5321300 | 20241018042710_RMtEn | UK005V | 2024-10-19T12:07:10.177Z | 2024-10-26T12:27:56.454Z |
5321285 | 5321285 | 20241018042151_lkQ4G | UK005V | 2024-10-19T12:07:08.518Z | 2024-10-26T12:27:56.439Z |
5318662 | 5318662 | 20241017043105_8J72k | UK005V | 2024-10-18T12:04:15.828Z | 2024-10-25T12:24:36.541Z |
5304301 | 5304301 | 20241013043426_ZhV8s | UK005V | 2024-10-14T12:17:47.576Z | 2024-10-21T12:24:24.715Z |
5301224 | 5301224 | 20241012225503_07mDd | UK005V | 2024-10-14T12:15:06.936Z | 2024-10-21T12:23:56.573Z |
5292838 | 5292838 | 20241012002652_RTWQD | UK005V | 2024-10-13T12:16:37.431Z | 2024-10-20T12:24:52.707Z |
5292758 | 5292758 | 20241012001753_a32Ef | UK005V | 2024-10-13T12:16:29.889Z | 2024-10-20T12:24:50.264Z |
5292712 | 5292712 | 20241012001317_oPJeR | UK005V | 2024-10-13T12:16:25.948Z | 2024-10-20T12:24:49.453Z |
5292165 | 5292165 | 20241011224511_kLrU6 | UK005V | 2024-10-13T12:15:45.511Z | 2024-10-20T12:24:40.730Z |
5291970 | 5291970 | 20241011222151_IqB4c | UK005V | 2024-10-13T12:15:35.625Z | 2024-10-20T12:24:38.501Z |
5291865 | 5291865 | 20241011220849_WQvtM | UK005V | 2024-10-13T12:15:22.459Z | 2024-10-20T12:24:37.128Z |
5284578 | 5284578 | 20241011025500_e8Sv8 | UK005V | 2024-10-12T12:17:28.393Z | 2024-10-19T12:27:56.409Z |
5283813 | 5283813 | 20241011015620_pmV8L | UK005V | 2024-10-12T12:16:58.057Z | 2024-10-19T12:27:52.819Z |
5283002 | 5283002 | 20241011002822_r7ys7 | UK005V | 2024-10-12T12:16:17.914Z | 2024-10-19T12:27:48.134Z |
5282904 | 5282904 | 20241011000606_365zI | UK005V | 2024-10-12T12:16:10.845Z | 2024-10-19T12:27:47.287Z |
5282578 | 5282578 | 20241010222533_R8JOd | UK005V | 2024-10-12T12:15:45.200Z | 2024-10-19T12:27:44.835Z |
5282101 | 5282101 | 20241010201515_XHQRs | UK005V | 2024-10-12T12:15:12.190Z | 2024-10-19T12:27:40.887Z |
5282059 | 5282059 | 20241010201227_VISJm | UK005V | 2024-10-12T12:15:10.112Z | 2024-10-19T12:27:40.434Z |
5276483 | 5276483 | 20241011044339_MODZ2 | UK005V | 2024-10-12T12:01:14.749Z | 2024-10-20T12:23:10.012Z |
5276099 | 5276099 | 20241011041739_dfL5c | UK005V | 2024-10-12T12:00:24.402Z | 2024-10-20T12:23:05.504Z |
5276010 | 5276010 | 20241011041120_CCCKQ | UK005V | 2024-10-12T12:00:12.374Z | 2024-10-20T12:23:04.161Z |
5261810 | 5261810 | 20241007222359_1a0D0 | UK005V | 2024-10-09T12:14:43.412Z | 2024-10-16T12:21:16.207Z |
5254728 | 5254728 | 20241007025000_DnsVd | UK005V | 2024-10-08T12:14:42.510Z | 2024-10-15T12:29:16.775Z |
5254590 | 5254590 | 20241007023044_38OrJ | UK005V | 2024-10-08T12:14:34.407Z | 2024-10-15T12:29:16.241Z |
5254559 | 5254559 | 20241007022716_Rljzo | UK005V | 2024-10-08T12:14:32.885Z | 2024-10-15T12:29:16.163Z |
5254551 | 5254551 | 20241007022710_Vmwek | UK005V | 2024-10-08T12:14:31.408Z | 2024-10-15T12:29:16.135Z |
5248613 | 5248613 | 20241007050334_s3r2J | UK005V | 2024-10-08T12:02:49.159Z | 2024-10-16T12:21:00.438Z |
5248580 | 5248580 | 20241007045559_QmPRW | UK005V | 2024-10-08T12:02:41.207Z | 2024-10-16T12:21:00.319Z |
5248523 | 5248523 | 20241007044856_I3P3a | UK005V | 2024-10-08T12:02:33.760Z | 2024-10-16T12:21:00.200Z |
5248395 | 5248395 | 20241007042721_WOo6s | UK005V | 2024-10-08T12:02:20.720Z | 2024-10-16T12:20:59.582Z |
5248352 | 5248352 | 20241007041959_o266j | UK005V | 2024-10-08T12:02:12.708Z | 2024-10-16T12:20:59.453Z |
5248323 | 5248323 | 20241007041707_aVeCh | UK005V | 2024-10-08T12:02:06.607Z | 2024-10-16T12:20:59.426Z |
5248229 | 5248229 | 20241007040828_Pvk2f | UK005V | 2024-10-08T12:01:49.200Z | 2024-10-16T12:20:58.689Z |
5247598 | 5247598 | 20241005021615_IfKWJ | UK005V | 2024-10-07T12:18:56.781Z | 2024-10-13T12:26:26.481Z |
5247243 | 5247243 | 20241005014752_boree | UK005V | 2024-10-07T12:18:52.234Z | 2024-10-13T12:26:25.884Z |
5247087 | 5247087 | 20241005013634_apaYs | UK005V | 2024-10-07T12:18:50.422Z | 2024-10-13T12:26:25.697Z |
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);