participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,385 rows where station_code = "UK008X" 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 |
---|---|---|---|---|---|
5444492 | 5444492 | 20241031012558_2yC02 | UK008X | 2024-11-01T12:21:19.968Z | 2024-11-08T14:23:15.737Z |
5444299 | 5444299 | 20241031010540_vvAxm | UK008X | 2024-11-01T12:21:12.258Z | 2024-11-08T14:23:14.289Z |
5444292 | 5444292 | 20241031010528_ZzFGc | UK008X | 2024-11-01T12:21:12.158Z | 2024-11-08T14:23:14.282Z |
5440596 | 5440596 | 20241030223112_2scyg | UK008X | 2024-11-01T12:15:38.649Z | 2024-11-08T14:23:09.976Z |
5440441 | 5440441 | 20241030221300_bZf3w | UK008X | 2024-11-01T12:15:30.905Z | 2024-11-08T14:23:09.437Z |
5440416 | 5440416 | 20241030220853_1tx8l | UK008X | 2024-11-01T12:15:29.499Z | 2024-11-08T14:23:09.370Z |
5440356 | 5440356 | 20241030220212_DSR3I | UK008X | 2024-11-01T12:15:26.190Z | 2024-11-08T14:23:09.194Z |
5440314 | 5440314 | 20241030215554_ZwxHj | UK008X | 2024-11-01T12:15:21.835Z | 2024-11-08T14:23:08.939Z |
5440208 | 5440208 | 20241030214320_2wrRa | UK008X | 2024-11-01T12:14:58.164Z | 2024-11-08T14:23:07.709Z |
5440185 | 5440185 | 20241030213846_GVFSz | UK008X | 2024-11-01T12:14:56.183Z | 2024-11-08T14:23:07.676Z |
5440106 | 5440106 | 20241030212312_cPqJP | UK008X | 2024-11-01T12:14:50.416Z | 2024-11-08T14:23:07.350Z |
5440009 | 5440009 | 20241030210651_l7aCB | UK008X | 2024-11-01T12:14:44.277Z | 2024-11-08T14:23:06.789Z |
5433007 | 5433007 | 20241029054238_DpWzr | UK008X | 2024-10-31T12:21:42.717Z | 2024-11-06T14:27:29.600Z |
5432930 | 5432930 | 20241029051904_Yq71a | UK008X | 2024-10-31T12:21:39.264Z | 2024-11-06T14:27:29.325Z |
5432920 | 5432920 | 20241029051557_vzksp | UK008X | 2024-10-31T12:21:38.855Z | 2024-11-06T14:27:29.287Z |
5432884 | 5432884 | 20241029050615_EiyHx | UK008X | 2024-10-31T12:21:37.712Z | 2024-11-06T14:27:29.090Z |
5432809 | 5432809 | 20241029044303_wrtpT | UK008X | 2024-10-31T12:21:35.859Z | 2024-11-06T14:27:28.782Z |
5432684 | 5432684 | 20241029041630_jgIiI | UK008X | 2024-10-31T12:21:31.201Z | 2024-11-06T14:27:28.437Z |
5432651 | 5432651 | 20241029040908_wJHoF | UK008X | 2024-10-31T12:21:30.036Z | 2024-11-06T14:27:28.304Z |
5432618 | 5432618 | 20241029040451_5nk7f | UK008X | 2024-10-31T12:21:28.887Z | 2024-11-06T14:27:28.245Z |
5432574 | 5432574 | 20241029035426_Lh3QG | UK008X | 2024-10-31T12:21:27.410Z | 2024-11-06T14:27:27.958Z |
5432525 | 5432525 | 20241029034636_oGTD2 | UK008X | 2024-10-31T12:21:26.152Z | 2024-11-06T14:27:27.783Z |
5417781 | 5417781 | 20241027191232_Gz1bM | UK008X | 2024-10-30T12:14:27.701Z | 2024-11-05T14:27:08.255Z |
5417615 | 5417615 | 20241027185350_nnM0P | UK008X | 2024-10-30T12:13:59.783Z | 2024-11-05T14:27:07.802Z |
5417345 | 5417345 | 20241027181706_YFUT0 | UK008X | 2024-10-30T12:13:33.209Z | 2024-11-05T14:27:06.985Z |
5410842 | 5410842 | 20241027054026_oAmxG | UK008X | 2024-10-29T12:18:05.999Z | 2024-11-04T14:29:05.647Z |
5410548 | 5410548 | 20241027051723_5XDE3 | UK008X | 2024-10-29T12:17:57.937Z | 2024-11-04T14:29:04.806Z |
5410338 | 5410338 | 20241027050707_1K6eG | UK008X | 2024-10-29T12:17:53.420Z | 2024-11-04T14:29:04.346Z |
5410182 | 5410182 | 20241027045842_zgaZJ | UK008X | 2024-10-29T12:17:50.045Z | 2024-11-04T14:29:03.987Z |
5410052 | 5410052 | 20241027044921_a0NsN | UK008X | 2024-10-29T12:17:46.601Z | 2024-11-04T14:29:03.633Z |
5409629 | 5409629 | 20241027042827_h9c2W | UK008X | 2024-10-29T12:17:34.168Z | 2024-11-04T14:29:02.023Z |
5409506 | 5409506 | 20241027042230_ZaRyf | UK008X | 2024-10-29T12:17:27.029Z | 2024-11-04T14:29:01.919Z |
5409116 | 5409116 | 20241027040102_nW2s3 | UK008X | 2024-10-29T12:17:07.080Z | 2024-11-04T14:29:01.175Z |
5409098 | 5409098 | 20241027035948_eGLL8 | UK008X | 2024-10-29T12:17:05.462Z | 2024-11-04T14:29:01.045Z |
5408989 | 5408989 | 20241027035230_OoKjm | UK008X | 2024-10-29T12:16:59.827Z | 2024-11-04T14:29:00.898Z |
5408974 | 5408974 | 20241027035141_YSaAm | UK008X | 2024-10-29T12:16:58.777Z | 2024-11-04T14:29:00.881Z |
5408874 | 5408874 | 20241027034726_v9utT | UK008X | 2024-10-29T12:16:55.485Z | 2024-11-04T14:29:00.744Z |
5408799 | 5408799 | 20241027034349_rxYtc | UK008X | 2024-10-29T12:16:52.701Z | 2024-11-04T14:29:00.554Z |
5408640 | 5408640 | 20241027033405_Yu5Dt | UK008X | 2024-10-29T12:16:41.913Z | 2024-11-04T14:28:59.711Z |
5408593 | 5408593 | 20241027033120_FgEod | UK008X | 2024-10-29T12:16:38.400Z | 2024-11-04T14:28:59.668Z |
5408553 | 5408553 | 20241027033015_JimKY | UK008X | 2024-10-29T12:16:35.922Z | 2024-11-04T14:28:59.615Z |
5408528 | 5408528 | 20241027032901_2BMhE | UK008X | 2024-10-29T12:16:34.560Z | 2024-11-04T14:28:59.605Z |
5408450 | 5408450 | 20241027032738_UTREC | UK008X | 2024-10-29T12:16:30.940Z | 2024-11-04T14:28:59.506Z |
5408307 | 5408307 | 20241027032207_DhZA9 | UK008X | 2024-10-29T12:16:21.954Z | 2024-11-04T14:28:59.078Z |
5408164 | 5408164 | 20241027031221_B0CNF | UK008X | 2024-10-29T12:16:13.206Z | 2024-11-04T14:28:58.941Z |
5408141 | 5408141 | 20241027031140_6MiAb | UK008X | 2024-10-29T12:16:11.545Z | 2024-11-04T14:28:58.918Z |
5407882 | 5407882 | 20241027025623_Pyuft | UK008X | 2024-10-29T12:15:50.494Z | 2024-11-04T14:28:58.289Z |
5407628 | 5407628 | 20241027024517_RVdVd | UK008X | 2024-10-29T12:15:31.926Z | 2024-11-04T14:28:57.954Z |
5407390 | 5407390 | 20241027023430_87xUX | UK008X | 2024-10-29T12:15:23.418Z | 2024-11-04T14:28:57.485Z |
5407297 | 5407297 | 20241027023036_BfjWF | UK008X | 2024-10-29T12:15:20.142Z | 2024-11-04T14:28:57.298Z |
5407095 | 5407095 | 20241027022218_4q33v | UK008X | 2024-10-29T12:15:12.227Z | 2024-11-04T14:28:56.843Z |
5406996 | 5406996 | 20241027021605_qNjBH | UK008X | 2024-10-29T12:15:06.673Z | 2024-11-04T14:28:56.765Z |
5406898 | 5406898 | 20241027020738_ISO3D | UK008X | 2024-10-29T12:14:53.866Z | 2024-11-04T14:28:56.589Z |
5406756 | 5406756 | 20241027015831_ulGiZ | UK008X | 2024-10-29T12:14:39.233Z | 2024-11-04T14:28:56.345Z |
5406749 | 5406749 | 20241027015752_AmhKr | UK008X | 2024-10-29T12:14:38.965Z | 2024-11-04T14:28:56.335Z |
5406468 | 5406468 | 20241027013929_eAP5T | UK008X | 2024-10-29T12:14:11.950Z | 2024-11-04T14:28:55.735Z |
5406422 | 5406422 | 20241027013627_tP1U6 | UK008X | 2024-10-29T12:14:07.824Z | 2024-11-04T14:28:55.689Z |
5406347 | 5406347 | 20241027013001_Bxy0T | UK008X | 2024-10-29T12:14:03.360Z | 2024-11-04T14:28:55.487Z |
5406168 | 5406168 | 20241027012004_rfrNy | UK008X | 2024-10-29T12:13:55.302Z | 2024-11-04T14:28:55.175Z |
5405814 | 5405814 | 20241027010042_G2Nyl | UK008X | 2024-10-29T12:13:19.321Z | 2024-11-04T14:28:54.399Z |
5405658 | 5405658 | 20241027005222_Acms5 | UK008X | 2024-10-29T12:13:08.009Z | 2024-11-04T14:28:53.873Z |
5405517 | 5405517 | 20241027004003_eZt4a | UK008X | 2024-10-29T12:12:59.731Z | 2024-11-04T14:28:53.581Z |
5405458 | 5405458 | 20241027003714_F4J18 | UK008X | 2024-10-29T12:12:57.196Z | 2024-11-04T14:28:53.517Z |
5405436 | 5405436 | 20241027003422_2A5Kv | UK008X | 2024-10-29T12:12:55.796Z | 2024-11-04T14:28:53.482Z |
5405412 | 5405412 | 20241027003242_RrX59 | UK008X | 2024-10-29T12:12:54.769Z | 2024-11-04T14:28:53.458Z |
5405378 | 5405378 | 20241027003041_10kZB | UK008X | 2024-10-29T12:12:52.410Z | 2024-11-04T14:28:53.374Z |
5405056 | 5405056 | 20241027001111_d6QGN | UK008X | 2024-10-29T12:12:21.104Z | 2024-11-04T14:28:52.643Z |
5405015 | 5405015 | 20241027000921_6ZDWj | UK008X | 2024-10-29T12:12:17.251Z | 2024-11-04T14:28:52.593Z |
5404814 | 5404814 | 20241026235426_N59yi | UK008X | 2024-10-29T12:11:59.592Z | 2024-11-04T14:28:52.029Z |
5404795 | 5404795 | 20241026235236_4BpHX | UK008X | 2024-10-29T12:11:58.053Z | 2024-11-04T14:28:51.952Z |
5404737 | 5404737 | 20241026234931_0HqUQ | UK008X | 2024-10-29T12:11:55.331Z | 2024-11-04T14:28:51.875Z |
5404600 | 5404600 | 20241026234003_k2iKG | UK008X | 2024-10-29T12:11:45.558Z | 2024-11-04T14:28:51.377Z |
5404354 | 5404354 | 20241026231910_s1lZf | UK008X | 2024-10-29T12:11:12.501Z | 2024-11-04T14:28:50.788Z |
5404340 | 5404340 | 20241026231842_Ru2n4 | UK008X | 2024-10-29T12:11:11.257Z | 2024-11-04T14:28:50.728Z |
5403884 | 5403884 | 20241026224252_a3ned | UK008X | 2024-10-29T12:10:24.745Z | 2024-11-04T14:28:49.939Z |
5403810 | 5403810 | 20241026223257_npkrJ | UK008X | 2024-10-29T12:10:15.250Z | 2024-11-04T14:28:49.784Z |
5403370 | 5403370 | 20241026214653_23kU0 | UK008X | 2024-10-29T12:09:25.415Z | 2024-11-04T14:28:48.583Z |
5403307 | 5403307 | 20241026213913_F7x7K | UK008X | 2024-10-29T12:09:21.047Z | 2024-11-04T14:28:48.294Z |
5403241 | 5403241 | 20241026213154_RylR6 | UK008X | 2024-10-29T12:09:15.295Z | 2024-11-04T14:28:48.071Z |
5402970 | 5402970 | 20241026205452_q5fGv | UK008X | 2024-10-29T12:08:41.010Z | 2024-11-04T14:28:47.222Z |
5402937 | 5402937 | 20241026204833_8SEz4 | UK008X | 2024-10-29T12:08:37.473Z | 2024-11-04T14:28:47.011Z |
5402351 | 5402351 | 20241026192039_WJilt | UK008X | 2024-10-29T12:07:03.917Z | 2024-11-04T14:28:43.923Z |
5395199 | 5395199 | 20241025221933_ropJh | UK008X | 2024-10-28T12:16:00.826Z | 2024-11-03T14:27:24.188Z |
5394884 | 5394884 | 20241025214001_Mxpc2 | UK008X | 2024-10-28T12:15:37.403Z | 2024-11-03T14:27:23.278Z |
5394681 | 5394681 | 20241025210802_CAUPG | UK008X | 2024-10-28T12:15:13.411Z | 2024-11-03T14:27:22.214Z |
5394478 | 5394478 | 20241025203939_mFRX7 | UK008X | 2024-10-28T12:14:44.009Z | 2024-11-03T14:27:21.365Z |
5394421 | 5394421 | 20241025203241_dNMYW | UK008X | 2024-10-28T12:14:36.286Z | 2024-11-03T14:27:21.179Z |
5386642 | 5386642 | 20241025010812_23zKv | UK008X | 2024-10-27T12:20:12.726Z | 2024-11-02T12:28:31.408Z |
5385575 | 5385575 | 20241024230219_iKv35 | UK008X | 2024-10-27T12:19:07.459Z | 2024-11-02T12:28:29.944Z |
5385224 | 5385224 | 20241024220959_PwBAv | UK008X | 2024-10-27T12:18:35.557Z | 2024-11-02T12:28:29.291Z |
5385031 | 5385031 | 20241024213935_SEZZl | UK008X | 2024-10-27T12:18:15.884Z | 2024-11-02T12:28:28.977Z |
5384813 | 5384813 | 20241024205742_Tfhir | UK008X | 2024-10-27T12:17:44.865Z | 2024-11-02T12:28:27.744Z |
5378261 | 5378261 | 20241024054355_MuZ1s | UK008X | 2024-10-26T12:22:59.052Z | 2024-11-01T12:27:03.516Z |
5378174 | 5378174 | 20241024053443_ZaN0Q | UK008X | 2024-10-26T12:22:57.211Z | 2024-11-01T12:27:03.373Z |
5378003 | 5378003 | 20241024052323_x4Pcf | UK008X | 2024-10-26T12:22:52.548Z | 2024-11-01T12:27:03.221Z |
5377827 | 5377827 | 20241024051243_Hn47e | UK008X | 2024-10-26T12:22:47.850Z | 2024-11-01T12:27:03.080Z |
5377752 | 5377752 | 20241024050706_QJjnv | UK008X | 2024-10-26T12:22:46.270Z | 2024-11-01T12:27:02.773Z |
5377700 | 5377700 | 20241024050458_e41ba | UK008X | 2024-10-26T12:22:44.194Z | 2024-11-01T12:27:02.724Z |
5377558 | 5377558 | 20241024045702_pDnxj | UK008X | 2024-10-26T12:22:40.627Z | 2024-11-01T12:27:02.596Z |
5377530 | 5377530 | 20241024045606_AQoIM | UK008X | 2024-10-26T12:22:39.886Z | 2024-11-01T12:27:02.568Z |
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);