participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,062 rows where station_code = "UK001K" 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 |
---|---|---|---|---|---|
5564692 | 5564692 | 20241120032108_vszfg | UK001K | 2024-11-21T14:17:58.618Z | 2024-11-21T14:18:54.085Z |
5564275 | 5564275 | 20241120024505_Yot3P | UK001K | 2024-11-21T14:17:24.357Z | 2024-11-21T14:18:54.017Z |
5564063 | 5564063 | 20241120022632_o9Nde | UK001K | 2024-11-21T14:17:07.441Z | 2024-11-21T14:18:53.974Z |
5564032 | 5564032 | 20241120022453_GprHU | UK001K | 2024-11-21T14:17:05.627Z | 2024-11-21T14:18:53.968Z |
5563835 | 5563835 | 20241120020940_WamNN | UK001K | 2024-11-21T14:16:48.232Z | 2024-11-21T14:18:53.926Z |
5563462 | 5563462 | 20241120013131_MTPl8 | UK001K | 2024-11-21T14:16:07.542Z | 2024-11-21T14:18:53.859Z |
5563113 | 5563113 | 20241120005415_rN32y | UK001K | 2024-11-21T14:15:37.313Z | 2024-11-21T14:18:53.792Z |
5563022 | 5563022 | 20241120004416_o30XE | UK001K | 2024-11-21T14:15:32.127Z | 2024-11-21T14:18:53.779Z |
5562679 | 5562679 | 20241120000402_uSnHk | UK001K | 2024-11-21T14:15:16.501Z | 2024-11-21T14:18:53.720Z |
5562646 | 5562646 | 20241120000139_AeqYk | UK001K | 2024-11-21T14:15:15.297Z | 2024-11-21T14:18:53.715Z |
5562551 | 5562551 | 20241119235218_3mUva | UK001K | 2024-11-21T14:15:08.329Z | 2024-11-21T14:18:53.701Z |
5562376 | 5562376 | 20241119233209_QQk1C | UK001K | 2024-11-21T14:14:45.772Z | 2024-11-21T14:18:53.674Z |
5562224 | 5562224 | 20241119231214_kx2wC | UK001K | 2024-11-21T14:14:34.230Z | 2024-11-21T14:18:53.653Z |
5562204 | 5562204 | 20241119230935_2b2gR | UK001K | 2024-11-21T14:14:32.173Z | 2024-11-21T14:18:53.648Z |
5561971 | 5561971 | 20241119224031_iKoUY | UK001K | 2024-11-21T14:14:17.782Z | 2024-11-21T14:18:53.614Z |
5561786 | 5561786 | 20241119220822_kjGFT | UK001K | 2024-11-21T14:14:06.416Z | 2024-11-21T14:18:53.581Z |
5561732 | 5561732 | 20241119215432_HE2lz | UK001K | 2024-11-21T14:13:53.849Z | 2024-11-21T14:18:53.571Z |
5561245 | 5561245 | 20241119191754_VfGrw | UK001K | 2024-11-21T14:12:45.805Z | 2024-11-21T14:18:53.445Z |
5561123 | 5561123 | 20241119182441_TA3Iz | UK001K | 2024-11-21T14:12:26.227Z | 2024-11-21T14:18:53.410Z |
5544973 | 5544973 | 20241115204754_sOqLx | UK001K | 2024-11-17T14:03:33.033Z | 2024-11-21T14:23:40.616Z |
5538563 | 5538563 | 20241113041319_tbnLn | UK001K | 2024-11-14T14:13:38.923Z | 2024-11-21T14:26:27.187Z |
5538526 | 5538526 | 20241113040306_493ZW | UK001K | 2024-11-14T14:13:35.620Z | 2024-11-21T14:26:26.999Z |
5536637 | 5536637 | 20241112184329_58DuW | UK001K | 2024-11-14T14:10:25.038Z | 2024-11-21T14:26:04.093Z |
5532871 | 5532871 | 20241113060914_LseeP | UK001K | 2024-11-14T14:00:25.994Z | 2024-11-21T14:24:40.966Z |
5532721 | 5532721 | 20241112055442_TXWVr | UK001K | 2024-11-13T14:17:12.408Z | 2024-11-20T14:26:25.823Z |
5532649 | 5532649 | 20241112054811_8UcpU | UK001K | 2024-11-13T14:17:07.250Z | 2024-11-20T14:26:25.475Z |
5532490 | 5532490 | 20241112052922_J6BCI | UK001K | 2024-11-13T14:16:52.695Z | 2024-11-20T14:26:23.928Z |
5532406 | 5532406 | 20241112051854_pPpoi | UK001K | 2024-11-13T14:16:43.188Z | 2024-11-20T14:26:22.734Z |
5532260 | 5532260 | 20241112045945_kE7Ib | UK001K | 2024-11-13T14:16:32.127Z | 2024-11-20T14:26:21.447Z |
5532110 | 5532110 | 20241112043808_aRDCk | UK001K | 2024-11-13T14:16:19.390Z | 2024-11-20T14:26:18.880Z |
5531840 | 5531840 | 20241112041246_z2lyL | UK001K | 2024-11-13T14:15:58.408Z | 2024-11-20T14:26:15.158Z |
5531803 | 5531803 | 20241112041027_pHKRI | UK001K | 2024-11-13T14:15:55.694Z | 2024-11-20T14:26:14.619Z |
5531692 | 5531692 | 20241112040019_CnnY7 | UK001K | 2024-11-13T14:15:50.961Z | 2024-11-20T14:26:13.556Z |
5531580 | 5531580 | 20241112035022_hGz7c | UK001K | 2024-11-13T14:15:45.508Z | 2024-11-20T14:26:12.559Z |
5531567 | 5531567 | 20241112035013_kErfB | UK001K | 2024-11-13T14:15:45.127Z | 2024-11-20T14:26:12.369Z |
5531471 | 5531471 | 20241112034137_8FFEJ | UK001K | 2024-11-13T14:15:41.564Z | 2024-11-20T14:26:11.602Z |
5531415 | 5531415 | 20241112033848_bGux5 | UK001K | 2024-11-13T14:15:38.370Z | 2024-11-20T14:26:11.170Z |
5531261 | 5531261 | 20241112032725_mivT2 | UK001K | 2024-11-13T14:15:31.871Z | 2024-11-20T14:26:09.558Z |
5531165 | 5531165 | 20241112031919_D4jYs | UK001K | 2024-11-13T14:15:21.976Z | 2024-11-20T14:26:08.403Z |
5530816 | 5530816 | 20241112025032_6ROow | UK001K | 2024-11-13T14:14:41.838Z | 2024-11-20T14:26:03.895Z |
5530525 | 5530525 | 20241112022553_QNeG1 | UK001K | 2024-11-13T14:14:20.406Z | 2024-11-20T14:26:01.133Z |
5525618 | 5525618 | 20241112055656_hvWsl | UK001K | 2024-11-13T14:00:09.364Z | 2024-11-21T14:25:24.376Z |
5454949 | 5454949 | 20241031055304_QM4JR | UK001K | 2024-11-02T12:23:27.502Z | 2024-11-08T14:23:26.468Z |
5454877 | 5454877 | 20241031053803_u3Rq0 | UK001K | 2024-11-02T12:23:25.686Z | 2024-11-08T14:23:26.089Z |
5454794 | 5454794 | 20241031051718_3x5Mv | UK001K | 2024-11-02T12:23:23.508Z | 2024-11-08T14:23:25.671Z |
5454736 | 5454736 | 20241031050500_snRO7 | UK001K | 2024-11-02T12:23:19.516Z | 2024-11-08T14:23:25.424Z |
5454624 | 5454624 | 20241031044701_SCl33 | UK001K | 2024-11-02T12:23:14.635Z | 2024-11-08T14:23:24.484Z |
5454616 | 5454616 | 20241031044551_NLV53 | UK001K | 2024-11-02T12:23:14.274Z | 2024-11-08T14:23:24.459Z |
5454585 | 5454585 | 20241031044138_E1Lby | UK001K | 2024-11-02T12:23:13.297Z | 2024-11-08T14:23:24.289Z |
5454366 | 5454366 | 20241031041211_k67AD | UK001K | 2024-11-02T12:23:03.768Z | 2024-11-08T14:23:22.517Z |
5454153 | 5454153 | 20241031034828_Y3wQp | UK001K | 2024-11-02T12:22:52.197Z | 2024-11-08T14:23:20.776Z |
5453984 | 5453984 | 20241031032552_X64j1 | UK001K | 2024-11-02T12:22:46.799Z | 2024-11-08T14:23:19.827Z |
5453963 | 5453963 | 20241031032311_a1MQY | UK001K | 2024-11-02T12:22:46.257Z | 2024-11-08T14:23:19.793Z |
5453916 | 5453916 | 20241031031617_9qK6N | UK001K | 2024-11-02T12:22:44.935Z | 2024-11-08T14:23:19.663Z |
5453849 | 5453849 | 20241031031011_0uimx | UK001K | 2024-11-02T12:22:43.735Z | 2024-11-08T14:23:19.541Z |
5453763 | 5453763 | 20241031025737_Azrbe | UK001K | 2024-11-02T12:22:42.138Z | 2024-11-08T14:23:19.014Z |
5453668 | 5453668 | 20241031024101_xFdXo | UK001K | 2024-11-02T12:22:39.716Z | 2024-11-08T14:23:18.632Z |
5453620 | 5453620 | 20241031023313_67EM2 | UK001K | 2024-11-02T12:22:37.303Z | 2024-11-08T14:23:18.269Z |
5453602 | 5453602 | 20241031022946_fJq2a | UK001K | 2024-11-02T12:22:36.855Z | 2024-11-08T14:23:18.176Z |
5453562 | 5453562 | 20241031022525_5xCyh | UK001K | 2024-11-02T12:22:36.145Z | 2024-11-08T14:23:18.100Z |
5450838 | 5450838 | 20241031211910_Oqeqn | UK001K | 2024-11-02T12:16:02.458Z | 2024-11-09T14:24:18.796Z |
5450524 | 5450524 | 20241031193924_YUDc6 | UK001K | 2024-11-02T12:15:34.222Z | 2024-11-09T14:24:16.400Z |
5410932 | 5410932 | 20241027055447_Dl4Tf | UK001K | 2024-10-29T12:18:12.685Z | 2024-11-04T14:29:06.384Z |
5410926 | 5410926 | 20241027055341_XKj2v | UK001K | 2024-10-29T12:18:12.379Z | 2024-11-04T14:29:06.381Z |
5410547 | 5410547 | 20241027051723_5XDE3 | UK001K | 2024-10-29T12:17:57.937Z | 2024-11-04T14:29:04.806Z |
5410452 | 5410452 | 20241027051356_izjAW | UK001K | 2024-10-29T12:17:55.984Z | 2024-11-04T14:29:04.610Z |
5410261 | 5410261 | 20241027050420_ajY4E | UK001K | 2024-10-29T12:17:51.874Z | 2024-11-04T14:29:04.272Z |
5410220 | 5410220 | 20241027050029_2hblT | UK001K | 2024-10-29T12:17:50.921Z | 2024-11-04T14:29:04.202Z |
5409276 | 5409276 | 20241027040846_rxzqP | UK001K | 2024-10-29T12:17:14.575Z | 2024-11-04T14:29:01.447Z |
5408683 | 5408683 | 20241027033632_5i8Gg | UK001K | 2024-10-29T12:16:45.111Z | 2024-11-04T14:29:00.304Z |
5407185 | 5407185 | 20241027022509_NvqtG | UK001K | 2024-10-29T12:15:16.314Z | 2024-11-04T14:28:57.232Z |
5401930 | 5401930 | 20241026181000_EOdeR | UK001K | 2024-10-29T12:05:52.144Z | 2024-11-04T14:28:41.076Z |
5400080 | 5400080 | 20241026053722_jV2o3 | UK001K | 2024-10-28T12:20:21.857Z | 2024-11-03T14:27:41.269Z |
5399928 | 5399928 | 20241026051303_oyNEc | UK001K | 2024-10-28T12:20:17.129Z | 2024-11-03T14:27:40.870Z |
5399926 | 5399926 | 20241026051259_UVg4Q | UK001K | 2024-10-28T12:20:17.072Z | 2024-11-03T14:27:40.866Z |
5399793 | 5399793 | 20241026050301_Q7xhn | UK001K | 2024-10-28T12:20:11.247Z | 2024-11-03T14:27:40.529Z |
5399531 | 5399531 | 20241026043233_5buxY | UK001K | 2024-10-28T12:20:01.657Z | 2024-11-03T14:27:39.939Z |
5398832 | 5398832 | 20241026033213_krvse | UK001K | 2024-10-28T12:19:35.778Z | 2024-11-03T14:27:38.274Z |
5398676 | 5398676 | 20241026031816_9D2at | UK001K | 2024-10-28T12:19:28.132Z | 2024-11-03T14:27:37.673Z |
5397802 | 5397802 | 20241026015903_4b8bm | UK001K | 2024-10-28T12:18:43.613Z | 2024-11-03T14:27:34.163Z |
5397382 | 5397382 | 20241026012425_dJLYN | UK001K | 2024-10-28T12:18:18.803Z | 2024-11-03T14:27:32.761Z |
5397154 | 5397154 | 20241026010640_8KjOL | UK001K | 2024-10-28T12:18:09.645Z | 2024-11-03T14:27:32.113Z |
5397138 | 5397138 | 20241026010515_qeq7S | UK001K | 2024-10-28T12:18:09.160Z | 2024-11-03T14:27:32.078Z |
5396501 | 5396501 | 20241026000812_pz3O5 | UK001K | 2024-10-28T12:17:47.258Z | 2024-11-03T14:27:30.021Z |
5396453 | 5396453 | 20241026000531_vysEB | UK001K | 2024-10-28T12:17:44.454Z | 2024-11-03T14:27:29.915Z |
5396100 | 5396100 | 20241025234034_ajIkV | UK001K | 2024-10-28T12:17:18.600Z | 2024-11-03T14:27:28.535Z |
5396028 | 5396028 | 20241025233229_x2J1l | UK001K | 2024-10-28T12:17:13.966Z | 2024-11-03T14:27:28.150Z |
5396006 | 5396006 | 20241025232938_fYFq9 | UK001K | 2024-10-28T12:17:10.607Z | 2024-11-03T14:27:28.036Z |
5395850 | 5395850 | 20241025231533_RicEh | UK001K | 2024-10-28T12:16:59.684Z | 2024-11-03T14:27:27.305Z |
5395680 | 5395680 | 20241025230354_dFeBB | UK001K | 2024-10-28T12:16:38.871Z | 2024-11-03T14:27:26.404Z |
5395673 | 5395673 | 20241025230347_JLJZX | UK001K | 2024-10-28T12:16:38.172Z | 2024-11-03T14:27:26.387Z |
5395597 | 5395597 | 20241025225819_qI077 | UK001K | 2024-10-28T12:16:31.160Z | 2024-11-03T14:27:26.085Z |
5394768 | 5394768 | 20241025212420_FJxZj | UK001K | 2024-10-28T12:15:24.348Z | 2024-11-03T14:27:22.698Z |
5394651 | 5394651 | 20241025210233_2lFdb | UK001K | 2024-10-28T12:15:10.225Z | 2024-11-03T14:27:22.068Z |
5394549 | 5394549 | 20241025204938_C9Q6K | UK001K | 2024-10-28T12:14:54.684Z | 2024-11-03T14:27:21.555Z |
5394302 | 5394302 | 20241025201327_IOq2Y | UK001K | 2024-10-28T12:14:21.294Z | 2024-11-03T14:27:20.753Z |
5394255 | 5394255 | 20241025200434_RORKg | UK001K | 2024-10-28T12:14:16.378Z | 2024-11-03T14:27:20.511Z |
5394210 | 5394210 | 20241025195732_vrc8C | UK001K | 2024-10-28T12:14:11.500Z | 2024-11-03T14:27:20.300Z |
5394030 | 5394030 | 20241025192611_xR8zJ | UK001K | 2024-10-28T12:13:59.786Z | 2024-11-03T14:27:19.682Z |
5378029 | 5378029 | 20241024052459_lJHZ0 | UK001K | 2024-10-26T12:22:53.148Z | 2024-11-01T12:27:03.261Z |
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);