participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,096 rows where station_code = "UK0084" 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 |
---|---|---|---|---|---|
5439800 | 5439800 | 20241030203329_rxcN1 | UK0084 | 2024-11-01T12:14:30.824Z | 2024-11-08T14:23:05.829Z |
5418652 | 5418652 | 20241027212852_RtTLT | UK0084 | 2024-10-30T12:15:57.514Z | 2024-11-05T14:27:10.899Z |
5418523 | 5418523 | 20241027210514_Cb2Xp | UK0084 | 2024-10-30T12:15:47.456Z | 2024-11-05T14:27:10.380Z |
5418456 | 5418456 | 20241027205050_PTTRx | UK0084 | 2024-10-30T12:15:42.593Z | 2024-11-05T14:27:10.071Z |
5418442 | 5418442 | 20241027204732_GoU2f | UK0084 | 2024-10-30T12:15:41.537Z | 2024-11-05T14:27:10.030Z |
5418315 | 5418315 | 20241027202158_k4DnE | UK0084 | 2024-10-30T12:15:24.869Z | 2024-11-05T14:27:09.618Z |
5418137 | 5418137 | 20241027195810_mEubV | UK0084 | 2024-10-30T12:14:58.852Z | 2024-11-05T14:27:09.260Z |
5418114 | 5418114 | 20241027195635_XPV1a | UK0084 | 2024-10-30T12:14:55.436Z | 2024-11-05T14:27:09.139Z |
5417768 | 5417768 | 20241027191218_36ro4 | UK0084 | 2024-10-30T12:14:26.874Z | 2024-11-05T14:27:08.205Z |
5417734 | 5417734 | 20241027190638_dJXFk | UK0084 | 2024-10-30T12:14:22.249Z | 2024-11-05T14:27:08.137Z |
5417596 | 5417596 | 20241027185016_b34gl | UK0084 | 2024-10-30T12:13:57.564Z | 2024-11-05T14:27:07.699Z |
5417344 | 5417344 | 20241027181706_YFUT0 | UK0084 | 2024-10-30T12:13:33.209Z | 2024-11-05T14:27:06.985Z |
5410831 | 5410831 | 20241027053957_mtQzN | UK0084 | 2024-10-29T12:18:05.850Z | 2024-11-04T14:29:05.637Z |
5410689 | 5410689 | 20241027052902_7v9sz | UK0084 | 2024-10-29T12:18:02.714Z | 2024-11-04T14:29:05.234Z |
5410669 | 5410669 | 20241027052601_vi3x0 | UK0084 | 2024-10-29T12:18:02.217Z | 2024-11-04T14:29:05.206Z |
5410663 | 5410663 | 20241027052555_zl4gO | UK0084 | 2024-10-29T12:18:02.211Z | 2024-11-04T14:29:05.203Z |
5410517 | 5410517 | 20241027051622_VhkyR | UK0084 | 2024-10-29T12:17:57.451Z | 2024-11-04T14:29:04.714Z |
5410483 | 5410483 | 20241027051501_nfgiN | UK0084 | 2024-10-29T12:17:56.886Z | 2024-11-04T14:29:04.643Z |
5410415 | 5410415 | 20241027051216_CG6LR | UK0084 | 2024-10-29T12:17:55.491Z | 2024-11-04T14:29:04.562Z |
5410175 | 5410175 | 20241027045834_ZwIQq | UK0084 | 2024-10-29T12:17:49.860Z | 2024-11-04T14:29:03.984Z |
5410151 | 5410151 | 20241027045550_gD33j | UK0084 | 2024-10-29T12:17:48.973Z | 2024-11-04T14:29:03.900Z |
5410089 | 5410089 | 20241027045222_hiTz5 | UK0084 | 2024-10-29T12:17:47.532Z | 2024-11-04T14:29:03.680Z |
5410011 | 5410011 | 20241027044738_IdH2R | UK0084 | 2024-10-29T12:17:45.746Z | 2024-11-04T14:29:03.260Z |
5410004 | 5410004 | 20241027044738_3x2KZ | UK0084 | 2024-10-29T12:17:45.707Z | 2024-11-04T14:29:03.258Z |
5409862 | 5409862 | 20241027043845_IEzAP | UK0084 | 2024-10-29T12:17:42.495Z | 2024-11-04T14:29:02.822Z |
5409828 | 5409828 | 20241027043718_TPpRm | UK0084 | 2024-10-29T12:17:41.961Z | 2024-11-04T14:29:02.773Z |
5409784 | 5409784 | 20241027043601_1aKFi | UK0084 | 2024-10-29T12:17:40.839Z | 2024-11-04T14:29:02.638Z |
5409726 | 5409726 | 20241027043228_0ugNh | UK0084 | 2024-10-29T12:17:39.447Z | 2024-11-04T14:29:02.186Z |
5409716 | 5409716 | 20241027043152_h6tiy | UK0084 | 2024-10-29T12:17:38.611Z | 2024-11-04T14:29:02.172Z |
5409707 | 5409707 | 20241027043146_Q8LtN | UK0084 | 2024-10-29T12:17:38.308Z | 2024-11-04T14:29:02.168Z |
5409669 | 5409669 | 20241027042959_eyu1f | UK0084 | 2024-10-29T12:17:36.363Z | 2024-11-04T14:29:02.061Z |
5409661 | 5409661 | 20241027042956_UToeI | UK0084 | 2024-10-29T12:17:36.291Z | 2024-11-04T14:29:02.059Z |
5409529 | 5409529 | 20241027042329_wiHUZ | UK0084 | 2024-10-29T12:17:28.485Z | 2024-11-04T14:29:01.938Z |
5409518 | 5409518 | 20241027042255_Sl3dy | UK0084 | 2024-10-29T12:17:28.040Z | 2024-11-04T14:29:01.925Z |
5409223 | 5409223 | 20241027040617_jKSML | UK0084 | 2024-10-29T12:17:12.183Z | 2024-11-04T14:29:01.383Z |
5409199 | 5409199 | 20241027040533_tyn82 | UK0084 | 2024-10-29T12:17:10.750Z | 2024-11-04T14:29:01.359Z |
5409133 | 5409133 | 20241027040156_3QHjB | UK0084 | 2024-10-29T12:17:08.511Z | 2024-11-04T14:29:01.211Z |
5408873 | 5408873 | 20241027034726_v9utT | UK0084 | 2024-10-29T12:16:55.485Z | 2024-11-04T14:29:00.744Z |
5408869 | 5408869 | 20241027034708_SDo2e | UK0084 | 2024-10-29T12:16:55.389Z | 2024-11-04T14:29:00.736Z |
5408813 | 5408813 | 20241027034408_gEJys | UK0084 | 2024-10-29T12:16:53.313Z | 2024-11-04T14:29:00.559Z |
5408524 | 5408524 | 20241027032901_tVlBs | UK0084 | 2024-10-29T12:16:34.284Z | 2024-11-04T14:28:59.593Z |
5408112 | 5408112 | 20241027030843_GYTJJ | UK0084 | 2024-10-29T12:16:06.878Z | 2024-11-04T14:28:58.877Z |
5407904 | 5407904 | 20241027025725_5xOQM | UK0084 | 2024-10-29T12:15:51.315Z | 2024-11-04T14:28:58.318Z |
5407600 | 5407600 | 20241027024356_BIlnj | UK0084 | 2024-10-29T12:15:31.001Z | 2024-11-04T14:28:57.909Z |
5407522 | 5407522 | 20241027024034_INvSO | UK0084 | 2024-10-29T12:15:28.161Z | 2024-11-04T14:28:57.840Z |
5407076 | 5407076 | 20241027022032_PZfMH | UK0084 | 2024-10-29T12:15:11.331Z | 2024-11-04T14:28:56.837Z |
5406762 | 5406762 | 20241027015842_R53Zk | UK0084 | 2024-10-29T12:14:39.731Z | 2024-11-04T14:28:56.361Z |
5406748 | 5406748 | 20241027015752_AmhKr | UK0084 | 2024-10-29T12:14:38.965Z | 2024-11-04T14:28:56.335Z |
5406744 | 5406744 | 20241027015741_DEZLL | UK0084 | 2024-10-29T12:14:38.484Z | 2024-11-04T14:28:56.332Z |
5406639 | 5406639 | 20241027015134_CKvA7 | UK0084 | 2024-10-29T12:14:28.054Z | 2024-11-04T14:28:55.968Z |
5406591 | 5406591 | 20241027014711_DH0VP | UK0084 | 2024-10-29T12:14:23.149Z | 2024-11-04T14:28:55.893Z |
5406578 | 5406578 | 20241027014613_WY1lb | UK0084 | 2024-10-29T12:14:22.679Z | 2024-11-04T14:28:55.888Z |
5406499 | 5406499 | 20241027014127_5lw44 | UK0084 | 2024-10-29T12:14:13.667Z | 2024-11-04T14:28:55.779Z |
5406413 | 5406413 | 20241027013605_O2Shq | UK0084 | 2024-10-29T12:14:07.399Z | 2024-11-04T14:28:55.665Z |
5406377 | 5406377 | 20241027013305_MsnM8 | UK0084 | 2024-10-29T12:14:05.127Z | 2024-11-04T14:28:55.620Z |
5406231 | 5406231 | 20241027012253_zpjxk | UK0084 | 2024-10-29T12:13:58.236Z | 2024-11-04T14:28:55.230Z |
5406000 | 5406000 | 20241027011200_6Ip7s | UK0084 | 2024-10-29T12:13:47.293Z | 2024-11-04T14:28:54.832Z |
5405984 | 5405984 | 20241027011146_1oNZQ | UK0084 | 2024-10-29T12:13:44.803Z | 2024-11-04T14:28:54.819Z |
5405657 | 5405657 | 20241027005222_Acms5 | UK0084 | 2024-10-29T12:13:08.009Z | 2024-11-04T14:28:53.873Z |
5405536 | 5405536 | 20241027004216_bx2W0 | UK0084 | 2024-10-29T12:13:00.792Z | 2024-11-04T14:28:53.594Z |
5405516 | 5405516 | 20241027004003_eZt4a | UK0084 | 2024-10-29T12:12:59.731Z | 2024-11-04T14:28:53.581Z |
5405423 | 5405423 | 20241027003309_mIghY | UK0084 | 2024-10-29T12:12:55.159Z | 2024-11-04T14:28:53.464Z |
5405322 | 5405322 | 20241027002845_mUJ3x | UK0084 | 2024-10-29T12:12:49.807Z | 2024-11-04T14:28:53.287Z |
5405278 | 5405278 | 20241027002634_Jtu4X | UK0084 | 2024-10-29T12:12:47.249Z | 2024-11-04T14:28:53.233Z |
5405266 | 5405266 | 20241027002606_Peah2 | UK0084 | 2024-10-29T12:12:46.806Z | 2024-11-04T14:28:53.208Z |
5404736 | 5404736 | 20241026234931_0HqUQ | UK0084 | 2024-10-29T12:11:55.331Z | 2024-11-04T14:28:51.875Z |
5404592 | 5404592 | 20241026233956_AI8fa | UK0084 | 2024-10-29T12:11:45.066Z | 2024-11-04T14:28:51.366Z |
5402816 | 5402816 | 20241026202902_ZJYYP | UK0084 | 2024-10-29T12:08:17.911Z | 2024-11-04T14:28:46.630Z |
5397583 | 5397583 | 20241026014147_o1YmO | UK0084 | 2024-10-28T12:18:28.749Z | 2024-11-03T14:27:33.431Z |
5397514 | 5397514 | 20241026013557_VFeWr | UK0084 | 2024-10-28T12:18:25.915Z | 2024-11-03T14:27:33.340Z |
5397167 | 5397167 | 20241026010709_WliwO | UK0084 | 2024-10-28T12:18:10.174Z | 2024-11-03T14:27:32.133Z |
5397145 | 5397145 | 20241026010528_7ELys | UK0084 | 2024-10-28T12:18:09.299Z | 2024-11-03T14:27:32.098Z |
5397001 | 5397001 | 20241026005521_nAGdv | UK0084 | 2024-10-28T12:18:01.871Z | 2024-11-03T14:27:31.662Z |
5396845 | 5396845 | 20241026004126_7IriY | UK0084 | 2024-10-28T12:17:57.700Z | 2024-11-03T14:27:31.212Z |
5396451 | 5396451 | 20241026000528_ZPP3x | UK0084 | 2024-10-28T12:17:44.021Z | 2024-11-03T14:27:29.907Z |
5396405 | 5396405 | 20241026000202_jkMCJ | UK0084 | 2024-10-28T12:17:39.412Z | 2024-11-03T14:27:29.737Z |
5395857 | 5395857 | 20241025231533_Qs3ZE | UK0084 | 2024-10-28T12:17:00.891Z | 2024-11-03T14:27:27.418Z |
5395782 | 5395782 | 20241025231016_db4D6 | UK0084 | 2024-10-28T12:16:50.894Z | 2024-11-03T14:27:26.690Z |
5395762 | 5395762 | 20241025230931_Aoyd5 | UK0084 | 2024-10-28T12:16:47.962Z | 2024-11-03T14:27:26.660Z |
5395602 | 5395602 | 20241025225906_EO143 | UK0084 | 2024-10-28T12:16:32.089Z | 2024-11-03T14:27:26.199Z |
5395545 | 5395545 | 20241025225146_Nt08F | UK0084 | 2024-10-28T12:16:25.555Z | 2024-11-03T14:27:25.702Z |
5395458 | 5395458 | 20241025224444_t4f3i | UK0084 | 2024-10-28T12:16:15.739Z | 2024-11-03T14:27:25.579Z |
5386606 | 5386606 | 20241025010520_8ZqpW | UK0084 | 2024-10-27T12:20:11.898Z | 2024-11-02T12:28:31.392Z |
5386261 | 5386261 | 20241025001858_hiyK0 | UK0084 | 2024-10-27T12:19:57.485Z | 2024-11-02T12:28:30.905Z |
5386211 | 5386211 | 20241025001402_yT1g3 | UK0084 | 2024-10-27T12:19:55.054Z | 2024-11-02T12:28:30.840Z |
5386188 | 5386188 | 20241025001215_ullXp | UK0084 | 2024-10-27T12:19:54.250Z | 2024-11-02T12:28:30.831Z |
5386012 | 5386012 | 20241024235311_LuDNm | UK0084 | 2024-10-27T12:19:45.669Z | 2024-11-02T12:28:30.579Z |
5385901 | 5385901 | 20241024234100_ZeFdi | UK0084 | 2024-10-27T12:19:35.556Z | 2024-11-02T12:28:30.450Z |
5385725 | 5385725 | 20241024232141_Oi2Zp | UK0084 | 2024-10-27T12:19:19.731Z | 2024-11-02T12:28:30.103Z |
5378071 | 5378071 | 20241024052604_JO8lL | UK0084 | 2024-10-26T12:22:54.200Z | 2024-11-01T12:27:03.272Z |
5377933 | 5377933 | 20241024051804_X22yk | UK0084 | 2024-10-26T12:22:50.197Z | 2024-11-01T12:27:03.166Z |
5377650 | 5377650 | 20241024050157_XWYpZ | UK0084 | 2024-10-26T12:22:43.064Z | 2024-11-01T12:27:02.692Z |
5377623 | 5377623 | 20241024050008_0I3EY | UK0084 | 2024-10-26T12:22:42.691Z | 2024-11-01T12:27:02.680Z |
5377592 | 5377592 | 20241024045819_DjBC3 | UK0084 | 2024-10-26T12:22:41.322Z | 2024-11-01T12:27:02.617Z |
5377527 | 5377527 | 20241024045606_AQoIM | UK0084 | 2024-10-26T12:22:39.886Z | 2024-11-01T12:27:02.568Z |
5377414 | 5377414 | 20241024044958_u4YMr | UK0084 | 2024-10-26T12:22:36.771Z | 2024-11-01T12:27:02.424Z |
5377349 | 5377349 | 20241024044557_6OlOq | UK0084 | 2024-10-26T12:22:34.738Z | 2024-11-01T12:27:02.385Z |
5377268 | 5377268 | 20241024044136_Ew0Pi | UK0084 | 2024-10-26T12:22:32.470Z | 2024-11-01T12:27:02.341Z |
5377244 | 5377244 | 20241024044105_nt2NM | UK0084 | 2024-10-26T12:22:31.789Z | 2024-11-01T12:27:02.335Z |
5377227 | 5377227 | 20241024043931_Za5MT | UK0084 | 2024-10-26T12:22:31.541Z | 2024-11-01T12:27:02.330Z |
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);