participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,482 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 |
---|---|---|---|---|---|
5573221 | 5573221 | 20241121040957_L0q3J | UK005V | 2024-11-22T14:19:16.706Z | 2024-11-22T14:19:22.472Z |
5573097 | 5573097 | 20241121035059_30wDC | UK005V | 2024-11-22T14:19:09.648Z | 2024-11-22T14:19:22.448Z |
5573054 | 5573054 | 20241121034442_wGr2u | UK005V | 2024-11-22T14:19:07.551Z | 2024-11-22T14:19:22.441Z |
5572873 | 5572873 | 20241121031826_Lb44n | UK005V | 2024-11-22T14:18:55.308Z | 2024-11-22T14:19:22.405Z |
5572647 | 5572647 | 20241121025248_Oct7v | UK005V | 2024-11-22T14:18:41.216Z | 2024-11-22T14:19:22.367Z |
5572159 | 5572159 | 20241121014240_MuSJG | UK005V | 2024-11-22T14:18:02.289Z | 2024-11-22T14:19:22.271Z |
5571948 | 5571948 | 20241121011002_iB4MB | UK005V | 2024-11-22T14:17:48.944Z | 2024-11-22T14:19:22.230Z |
5571719 | 5571719 | 20241121003605_375Nr | UK005V | 2024-11-22T14:17:35.955Z | 2024-11-22T14:19:22.180Z |
5571551 | 5571551 | 20241121000603_Q4WR8 | UK005V | 2024-11-22T14:17:16.623Z | 2024-11-22T14:19:22.147Z |
5571336 | 5571336 | 20241120232450_7Fbu8 | UK005V | 2024-11-22T14:16:51.874Z | 2024-11-22T14:19:22.104Z |
5571243 | 5571243 | 20241120230733_ogDn1 | UK005V | 2024-11-22T14:16:43.205Z | 2024-11-22T14:19:22.077Z |
5570855 | 5570855 | 20241120211906_i9kgS | UK005V | 2024-11-22T14:16:09.504Z | 2024-11-22T14:19:21.995Z |
5570498 | 5570498 | 20241120194904_XUquK | UK005V | 2024-11-22T14:15:37.370Z | 2024-11-22T14:19:21.927Z |
5570449 | 5570449 | 20241120194114_LHdNB | UK005V | 2024-11-22T14:15:26.915Z | 2024-11-22T14:19:21.918Z |
5570425 | 5570425 | 20241120193535_Mam9W | UK005V | 2024-11-22T14:15:24.430Z | 2024-11-22T14:19:21.915Z |
5570389 | 5570389 | 20241120193141_b32Gz | UK005V | 2024-11-22T14:15:19.210Z | 2024-11-22T14:19:21.910Z |
5570286 | 5570286 | 20241120191243_506qi | UK005V | 2024-11-22T14:15:06.113Z | 2024-11-22T14:19:21.892Z |
5569886 | 5569886 | 20241120175338_khRPy | UK005V | 2024-11-22T14:14:29.587Z | 2024-11-22T14:19:21.822Z |
5565857 | 5565857 | 20241121045524_CUhXT | UK005V | 2024-11-22T14:01:12.981Z | 2024-11-22T14:01:12.981Z |
5565810 | 5565810 | 20241121044955_3mri5 | UK005V | 2024-11-22T14:01:00.224Z | 2024-11-22T14:01:00.224Z |
5565579 | 5565579 | 20241121042334_ZTAtB | UK005V | 2024-11-22T14:00:19.937Z | 2024-11-22T14:00:19.937Z |
5564243 | 5564243 | 20241120024056_lXHGV | UK005V | 2024-11-21T14:17:21.434Z | 2024-11-22T14:21:29.289Z |
5563699 | 5563699 | 20241120015822_Gtn1C | UK005V | 2024-11-21T14:16:34.990Z | 2024-11-22T14:21:21.210Z |
5562114 | 5562114 | 20241119230157_2wlaD | UK005V | 2024-11-21T14:14:26.129Z | 2024-11-22T14:20:52.973Z |
5553902 | 5553902 | 20241118044533_DeMuw | UK005V | 2024-11-19T14:11:32.850Z | 2024-11-22T14:22:57.184Z |
5552624 | 5552624 | 20241117192449_QRQH8 | UK005V | 2024-11-19T14:08:47.361Z | 2024-11-22T14:22:43.179Z |
5549726 | 5549726 | 20241118061108_sow3G | UK005V | 2024-11-19T14:00:40.951Z | 2024-11-22T14:21:51.804Z |
5549604 | 5549604 | 20241118053659_US1Zg | UK005V | 2024-11-19T14:00:24.141Z | 2024-11-22T14:21:50.614Z |
5539204 | 5539204 | 20241114054926_Xmt1K | UK005V | 2024-11-15T14:00:21.813Z | 2024-11-22T14:23:42.443Z |
5539003 | 5539003 | 20241113053226_rMAwE | UK005V | 2024-11-14T14:14:08.205Z | 2024-11-21T14:26:31.008Z |
5538743 | 5538743 | 20241113044941_tQ0Jl | UK005V | 2024-11-14T14:13:54.506Z | 2024-11-21T14:26:28.683Z |
5538714 | 5538714 | 20241113044319_yPZ6F | UK005V | 2024-11-14T14:13:52.681Z | 2024-11-21T14:26:28.570Z |
5538708 | 5538708 | 20241113044316_nnRXN | UK005V | 2024-11-14T14:13:52.394Z | 2024-11-21T14:26:28.569Z |
5538672 | 5538672 | 20241113043335_qvs8L | UK005V | 2024-11-14T14:13:48.284Z | 2024-11-21T14:26:28.472Z |
5538624 | 5538624 | 20241113042500_NY6WJ | UK005V | 2024-11-14T14:13:44.597Z | 2024-11-21T14:26:28.205Z |
5538589 | 5538589 | 20241113041640_7rptk | UK005V | 2024-11-14T14:13:41.937Z | 2024-11-21T14:26:27.308Z |
5538435 | 5538435 | 20241113034226_UK7FH | UK005V | 2024-11-14T14:13:26.830Z | 2024-11-21T14:26:25.722Z |
5538349 | 5538349 | 20241113031723_ylhaj | UK005V | 2024-11-14T14:13:17.414Z | 2024-11-21T14:26:24.259Z |
5538030 | 5538030 | 20241113015739_Vum20 | UK005V | 2024-11-14T14:12:45.111Z | 2024-11-21T14:26:19.438Z |
5531828 | 5531828 | 20241112041143_R3moY | UK005V | 2024-11-13T14:15:57.132Z | 2024-11-20T14:26:14.826Z |
5531587 | 5531587 | 20241112035023_Abjvj | UK005V | 2024-11-13T14:15:45.701Z | 2024-11-20T14:26:12.589Z |
5530553 | 5530553 | 20241112022802_FuL6p | UK005V | 2024-11-13T14:14:22.041Z | 2024-11-20T14:26:01.607Z |
5524204 | 5524204 | 20241111033048_gdW9k | UK005V | 2024-11-12T14:16:45.577Z | 2024-11-19T14:22:18.779Z |
5524000 | 5524000 | 20241111030109_zKSRD | UK005V | 2024-11-12T14:16:25.542Z | 2024-11-19T14:22:16.488Z |
5523955 | 5523955 | 20241111025407_4R3t7 | UK005V | 2024-11-12T14:16:22.266Z | 2024-11-19T14:22:16.117Z |
5523892 | 5523892 | 20241111024359_CRZFa | UK005V | 2024-11-12T14:16:19.141Z | 2024-11-19T14:22:15.717Z |
5523688 | 5523688 | 20241111020651_DowG7 | UK005V | 2024-11-12T14:16:07.521Z | 2024-11-19T14:22:14.353Z |
5523673 | 5523673 | 20241111020326_GC2pD | UK005V | 2024-11-12T14:16:06.911Z | 2024-11-19T14:22:14.313Z |
5523632 | 5523632 | 20241111015817_1WpG3 | UK005V | 2024-11-12T14:16:04.912Z | 2024-11-19T14:22:13.941Z |
5523583 | 5523583 | 20241111014944_gxQtI | UK005V | 2024-11-12T14:16:02.000Z | 2024-11-19T14:22:13.501Z |
5523565 | 5523565 | 20241111014631_DNeEO | UK005V | 2024-11-12T14:16:00.590Z | 2024-11-19T14:22:13.355Z |
5523506 | 5523506 | 20241111013817_mNrlK | UK005V | 2024-11-12T14:15:50.253Z | 2024-11-19T14:22:13.027Z |
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 |
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);