participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,426 rows where station_code = "UK002X" 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 |
---|---|---|---|---|---|
5497840 | 5497840 | 20241107053149_bG8gF | UK002X | 2024-11-08T14:14:26.312Z | 2024-11-09T14:18:52.665Z |
5422958 | 5422958 | 20241026230214_JhQYp | UK002X | 2024-10-30T12:22:15.866Z | 2024-11-04T14:28:50.367Z |
5410892 | 5410892 | 20241027054715_Oo4Uh | UK002X | 2024-10-29T12:18:09.425Z | 2024-11-04T14:29:05.992Z |
5409907 | 5409907 | 20241027044129_WoBRi | UK002X | 2024-10-29T12:17:43.926Z | 2024-11-04T14:29:02.919Z |
5409787 | 5409787 | 20241027043606_kmwok | UK002X | 2024-10-29T12:17:41.045Z | 2024-11-04T14:29:02.641Z |
5409763 | 5409763 | 20241027043450_ehWo1 | UK002X | 2024-10-29T12:17:40.498Z | 2024-11-04T14:29:02.623Z |
5409584 | 5409584 | 20241027042722_QJHXP | UK002X | 2024-10-29T12:17:31.883Z | 2024-11-04T14:29:01.968Z |
5409352 | 5409352 | 20241027041211_cDKX0 | UK002X | 2024-10-29T12:17:17.253Z | 2024-11-04T14:29:01.595Z |
5409038 | 5409038 | 20241027035620_lO7ic | UK002X | 2024-10-29T12:17:02.522Z | 2024-11-04T14:29:00.975Z |
5408458 | 5408458 | 20241027032801_7qn1R | UK002X | 2024-10-29T12:16:31.455Z | 2024-11-04T14:28:59.542Z |
5408373 | 5408373 | 20241027032416_t0QgP | UK002X | 2024-10-29T12:16:25.291Z | 2024-11-04T14:28:59.295Z |
5407929 | 5407929 | 20241027025823_jYT3w | UK002X | 2024-10-29T12:15:54.115Z | 2024-11-04T14:28:58.511Z |
5407857 | 5407857 | 20241027025540_jtxy4 | UK002X | 2024-10-29T12:15:49.326Z | 2024-11-04T14:28:58.248Z |
5407718 | 5407718 | 20241027024909_5KLQQ | UK002X | 2024-10-29T12:15:35.742Z | 2024-11-04T14:28:58.076Z |
5407669 | 5407669 | 20241027024651_pn9Md | UK002X | 2024-10-29T12:15:33.945Z | 2024-11-04T14:28:58.025Z |
5407610 | 5407610 | 20241027024416_ENltf | UK002X | 2024-10-29T12:15:31.327Z | 2024-11-04T14:28:57.934Z |
5407488 | 5407488 | 20241027023847_h52k1 | UK002X | 2024-10-29T12:15:26.760Z | 2024-11-04T14:28:57.768Z |
5406677 | 5406677 | 20241027015311_9emEf | UK002X | 2024-10-29T12:14:31.239Z | 2024-11-04T14:28:56.028Z |
5406634 | 5406634 | 20241027015121_e4x6F | UK002X | 2024-10-29T12:14:27.693Z | 2024-11-04T14:28:55.961Z |
5406241 | 5406241 | 20241027012331_BbnsN | UK002X | 2024-10-29T12:13:59.057Z | 2024-11-04T14:28:55.249Z |
5405911 | 5405911 | 20241027010720_Zw4Tl | UK002X | 2024-10-29T12:13:32.374Z | 2024-11-04T14:28:54.601Z |
5405790 | 5405790 | 20241027005853_nEioo | UK002X | 2024-10-29T12:13:17.975Z | 2024-11-04T14:28:54.246Z |
5405737 | 5405737 | 20241027005510_B6BHM | UK002X | 2024-10-29T12:13:11.343Z | 2024-11-04T14:28:54.129Z |
5405607 | 5405607 | 20241027004849_9hCG4 | UK002X | 2024-10-29T12:13:04.574Z | 2024-11-04T14:28:53.710Z |
5405251 | 5405251 | 20241027002547_lNBYz | UK002X | 2024-10-29T12:12:46.320Z | 2024-11-04T14:28:53.176Z |
5405211 | 5405211 | 20241027002342_FXWm3 | UK002X | 2024-10-29T12:12:43.189Z | 2024-11-04T14:28:52.978Z |
5405133 | 5405133 | 20241027001536_kD0yB | UK002X | 2024-10-29T12:12:32.021Z | 2024-11-04T14:28:52.720Z |
5404781 | 5404781 | 20241026235232_SMQBs | UK002X | 2024-10-29T12:11:57.674Z | 2024-11-04T14:28:51.937Z |
5404328 | 5404328 | 20241026231818_nN0rE | UK002X | 2024-10-29T12:11:10.456Z | 2024-11-04T14:28:50.685Z |
5404260 | 5404260 | 20241026231306_OAwVo | UK002X | 2024-10-29T12:11:03.760Z | 2024-11-04T14:28:50.559Z |
5404201 | 5404201 | 20241026230812_fWwLf | UK002X | 2024-10-29T12:11:00.153Z | 2024-11-04T14:28:50.454Z |
5404193 | 5404193 | 20241026230712_KzQ2X | UK002X | 2024-10-29T12:10:59.315Z | 2024-11-04T14:28:50.438Z |
5404167 | 5404167 | 20241026230351_UeIko | UK002X | 2024-10-29T12:10:57.482Z | 2024-11-04T14:28:50.393Z |
5404138 | 5404138 | 20241026230210_OO3ek | UK002X | 2024-10-29T12:10:55.886Z | 2024-11-04T14:28:50.356Z |
5404118 | 5404118 | 20241026225931_6dX0x | UK002X | 2024-10-29T12:10:54.685Z | 2024-11-04T14:28:50.343Z |
5403854 | 5403854 | 20241026223847_0SwCp | UK002X | 2024-10-29T12:10:20.834Z | 2024-11-04T14:28:49.880Z |
5399476 | 5399476 | 20241026042639_GP8u8 | UK002X | 2024-10-28T12:20:00.499Z | 2024-11-03T14:27:39.842Z |
5385308 | 5385308 | 20241024222101_Hul7N | UK002X | 2024-10-27T12:18:43.693Z | 2024-11-02T12:28:29.539Z |
5385174 | 5385174 | 20241024220220_2O3H5 | UK002X | 2024-10-27T12:18:32.180Z | 2024-11-02T12:28:29.238Z |
5384998 | 5384998 | 20241024213411_ZE2c2 | UK002X | 2024-10-27T12:18:09.101Z | 2024-11-02T12:28:28.900Z |
5384569 | 5384569 | 20241024202152_xVFNF | UK002X | 2024-10-27T12:17:11.958Z | 2024-11-02T12:28:27.331Z |
5384556 | 5384556 | 20241024202130_qaUi4 | UK002X | 2024-10-27T12:17:11.080Z | 2024-11-02T12:28:27.321Z |
5383931 | 5383931 | 20241024191617_ZbuQG | UK002X | 2024-10-27T12:16:27.969Z | 2024-11-02T12:28:26.575Z |
5383570 | 5383570 | 20241024183428_PrrJU | UK002X | 2024-10-27T12:15:47.572Z | 2024-11-02T12:28:25.767Z |
5383484 | 5383484 | 20241024182456_mKUPB | UK002X | 2024-10-27T12:15:35.386Z | 2024-11-02T12:28:25.387Z |
5372267 | 5372267 | 20241024004204_iXmt9 | UK002X | 2024-10-26T12:19:17.429Z | 2024-11-01T12:26:57.334Z |
5365617 | 5365617 | 20241023234115_09L9W | UK002X | 2024-10-25T12:18:03.211Z | 2024-11-01T12:26:56.291Z |
5365524 | 5365524 | 20241023233606_4yI6A | UK002X | 2024-10-25T12:17:59.862Z | 2024-11-01T12:26:56.186Z |
5365481 | 5365481 | 20241023233426_9aNDv | UK002X | 2024-10-25T12:17:59.030Z | 2024-11-01T12:26:56.170Z |
5365180 | 5365180 | 20241023231952_lvqb2 | UK002X | 2024-10-25T12:17:50.396Z | 2024-11-01T12:26:55.959Z |
5364831 | 5364831 | 20241023225538_oJ2XX | UK002X | 2024-10-25T12:17:36.647Z | 2024-11-01T12:26:55.669Z |
5364664 | 5364664 | 20241023224535_3czGB | UK002X | 2024-10-25T12:17:29.062Z | 2024-11-01T12:26:55.351Z |
5364081 | 5364081 | 20241023220553_8qBUH | UK002X | 2024-10-25T12:17:08.358Z | 2024-11-01T12:26:54.524Z |
5348446 | 5348446 | 20241022182011_Slbrq | UK002X | 2024-10-24T12:11:26.256Z | 2024-10-31T12:29:52.587Z |
5345252 | 5345252 | 20241022053015_eypZb | UK002X | 2024-10-23T12:19:12.339Z | 2024-10-30T12:26:52.364Z |
5344789 | 5344789 | 20241022044611_95qHC | UK002X | 2024-10-23T12:18:50.647Z | 2024-10-30T12:26:51.686Z |
5344644 | 5344644 | 20241022043556_XkIZ2 | UK002X | 2024-10-23T12:18:44.635Z | 2024-10-30T12:26:51.445Z |
5344629 | 5344629 | 20241022043456_bS1jJ | UK002X | 2024-10-23T12:18:43.787Z | 2024-10-30T12:26:51.435Z |
5344434 | 5344434 | 20241022042201_5YCb2 | UK002X | 2024-10-23T12:18:36.893Z | 2024-10-30T12:26:51.242Z |
5344302 | 5344302 | 20241022041452_iCUMv | UK002X | 2024-10-23T12:18:31.103Z | 2024-10-30T12:26:51.122Z |
5343980 | 5343980 | 20241022035848_Uijw7 | UK002X | 2024-10-23T12:18:16.895Z | 2024-10-30T12:26:50.835Z |
5343816 | 5343816 | 20241022034731_KjGLr | UK002X | 2024-10-23T12:18:09.061Z | 2024-10-30T12:26:50.629Z |
5327449 | 5327449 | 20241020021323_DpiOZ | UK002X | 2024-10-21T12:12:10.339Z | 2024-10-28T12:26:45.058Z |
5327411 | 5327411 | 20241020020438_3ECav | UK002X | 2024-10-21T12:12:06.153Z | 2024-10-28T12:26:44.861Z |
5326603 | 5326603 | 20241019191011_jz1L0 | UK002X | 2024-10-21T12:10:01.607Z | 2024-10-28T12:26:42.136Z |
5321617 | 5321617 | 20241018052553_qa0d9 | UK002X | 2024-10-19T12:07:55.770Z | 2024-10-26T12:27:57.072Z |
5321521 | 5321521 | 20241018050614_l0U09 | UK002X | 2024-10-19T12:07:45.660Z | 2024-10-26T12:27:56.925Z |
5321480 | 5321480 | 20241018045634_So05z | UK002X | 2024-10-19T12:07:37.352Z | 2024-10-26T12:27:56.884Z |
5321195 | 5321195 | 20241018040349_LES1C | UK002X | 2024-10-19T12:07:00.620Z | 2024-10-26T12:27:56.336Z |
5321153 | 5321153 | 20241018035745_QCeMT | UK002X | 2024-10-19T12:06:56.239Z | 2024-10-26T12:27:56.249Z |
5321042 | 5321042 | 20241018033635_6Ac63 | UK002X | 2024-10-19T12:06:35.366Z | 2024-10-26T12:27:56.059Z |
5320970 | 5320970 | 20241018032737_vkuCS | UK002X | 2024-10-19T12:06:27.437Z | 2024-10-26T12:27:56.002Z |
5320921 | 5320921 | 20241018031402_FJZw7 | UK002X | 2024-10-19T12:06:21.365Z | 2024-10-26T12:27:55.757Z |
5313257 | 5313257 | 20241014042411_S352j | UK002X | 2024-10-16T12:13:59.920Z | 2024-10-22T12:24:44.891Z |
5313246 | 5313246 | 20241014041930_Z3dE6 | UK002X | 2024-10-16T12:13:59.114Z | 2024-10-22T12:24:44.750Z |
5313244 | 5313244 | 20241014041729_rGwW4 | UK002X | 2024-10-16T12:13:58.966Z | 2024-10-22T12:24:44.730Z |
5313227 | 5313227 | 20241014040840_fTYYk | UK002X | 2024-10-16T12:13:57.282Z | 2024-10-22T12:24:44.555Z |
5313201 | 5313201 | 20241014040010_wUeyq | UK002X | 2024-10-16T12:13:54.864Z | 2024-10-22T12:24:43.706Z |
5313194 | 5313194 | 20241014035440_EZw3T | UK002X | 2024-10-16T12:13:53.215Z | 2024-10-22T12:24:43.120Z |
5313176 | 5313176 | 20241014034717_q3d0C | UK002X | 2024-10-16T12:13:52.046Z | 2024-10-22T12:24:42.979Z |
5313156 | 5313156 | 20241014033104_WYwbd | UK002X | 2024-10-16T12:13:47.490Z | 2024-10-22T12:24:41.916Z |
5313107 | 5313107 | 20241014030212_4D8cV | UK002X | 2024-10-16T12:13:42.071Z | 2024-10-22T12:24:40.990Z |
5313098 | 5313098 | 20241014030022_V6UBA | UK002X | 2024-10-16T12:13:40.812Z | 2024-10-22T12:24:40.928Z |
5312930 | 5312930 | 20241014005915_D9qUM | UK002X | 2024-10-16T12:13:09.873Z | 2024-10-22T12:24:35.061Z |
5312749 | 5312749 | 20241015045603_UNOk7 | UK002X | 2024-10-16T12:10:58.057Z | 2024-10-23T12:24:53.633Z |
5312578 | 5312578 | 20241015040142_2gK5y | UK002X | 2024-10-16T12:10:49.330Z | 2024-10-23T12:24:52.054Z |
5312556 | 5312556 | 20241015035930_Adnvl | UK002X | 2024-10-16T12:10:48.165Z | 2024-10-23T12:24:51.758Z |
5312530 | 5312530 | 20241015034956_yGFQt | UK002X | 2024-10-16T12:10:46.222Z | 2024-10-23T12:24:51.599Z |
5312457 | 5312457 | 20241015034128_kR6ij | UK002X | 2024-10-16T12:10:42.028Z | 2024-10-23T12:24:51.132Z |
5312443 | 5312443 | 20241015034014_Xqncp | UK002X | 2024-10-16T12:10:40.996Z | 2024-10-23T12:24:51.002Z |
5311554 | 5311554 | 20241015010808_eXg3r | UK002X | 2024-10-16T12:09:01.728Z | 2024-10-23T12:24:43.775Z |
5311522 | 5311522 | 20241015010106_GsCAV | UK002X | 2024-10-16T12:09:00.313Z | 2024-10-23T12:24:43.732Z |
5311170 | 5311170 | 20241014233210_rckXK | UK002X | 2024-10-16T12:08:36.734Z | 2024-10-23T12:24:41.718Z |
5311079 | 5311079 | 20241014225547_y7ifa | UK002X | 2024-10-16T12:08:16.295Z | 2024-10-23T12:24:40.950Z |
5311067 | 5311067 | 20241014225116_2wP2n | UK002X | 2024-10-16T12:08:14.634Z | 2024-10-23T12:24:40.927Z |
5311032 | 5311032 | 20241014223738_GNaDC | UK002X | 2024-10-16T12:08:11.097Z | 2024-10-23T12:24:40.686Z |
5311019 | 5311019 | 20241014223236_aauFe | UK002X | 2024-10-16T12:08:09.468Z | 2024-10-23T12:24:40.637Z |
5306881 | 5306881 | 20241014044003_eeOSu | UK002X | 2024-10-15T12:08:40.254Z | 2024-10-22T12:24:45.574Z |
5306873 | 5306873 | 20241014043533_BDA0J | UK002X | 2024-10-15T12:08:38.693Z | 2024-10-22T12:24:45.273Z |
5306859 | 5306859 | 20241014043233_D3jZz | UK002X | 2024-10-15T12:08:36.639Z | 2024-10-22T12:24:45.253Z |
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);