participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
388 rows where station_code = "UK00BD" 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 |
---|---|---|---|---|---|
5129757 | 5129757 | 20240917042512_YPcGy | UK00BD | 2024-09-19T12:12:02.895Z | 2024-09-19T12:12:02.895Z |
5129682 | 5129682 | 20240917042148_53vsL | UK00BD | 2024-09-19T12:12:00.538Z | 2024-09-19T12:12:00.538Z |
5128371 | 5128371 | 20240917013113_7lp2l | UK00BD | 2024-09-19T12:10:29.052Z | 2024-09-19T12:10:29.052Z |
5128257 | 5128257 | 20240917010944_y4nji | UK00BD | 2024-09-19T12:10:21.933Z | 2024-09-19T12:10:21.933Z |
5127919 | 5127919 | 20240917000505_sC3Ql | UK00BD | 2024-09-19T12:09:46.715Z | 2024-09-19T12:09:46.715Z |
5121670 | 5121670 | 20240914041155_QyLxn | UK00BD | 2024-09-18T12:10:59.188Z | 2024-09-19T12:20:02.207Z |
5120827 | 5120827 | 20240914033552_fwlf5 | UK00BD | 2024-09-18T12:10:47.149Z | 2024-09-19T12:20:00.904Z |
5113744 | 5113744 | 20240915011104_fXah3 | UK00BD | 2024-09-18T12:04:48.698Z | 2024-09-19T12:18:51.810Z |
5113382 | 5113382 | 20240915004314_Y2KMQ | UK00BD | 2024-09-18T12:04:11.438Z | 2024-09-19T12:18:48.732Z |
5106717 | 5106717 | 20240913033244_xNwMk | UK00BD | 2024-09-17T12:12:59.797Z | 2024-09-19T12:20:46.295Z |
5103971 | 5103971 | 20240913014540_yI5mU | UK00BD | 2024-09-17T12:11:20.430Z | 2024-09-19T12:20:40.687Z |
5101360 | 5101360 | 20240914002207_Yy82N | UK00BD | 2024-09-17T12:05:38.007Z | 2024-09-19T12:19:50.355Z |
5100994 | 5100994 | 20240913235534_dvXWJ | UK00BD | 2024-09-17T12:05:13.182Z | 2024-09-19T12:19:49.465Z |
5097292 | 5097292 | 20240913003832_Ye3ds | UK00BD | 2024-09-16T12:17:09.388Z | 2024-09-19T12:20:38.026Z |
5093016 | 5093016 | 20240912030749_NalPx | UK00BD | 2024-09-16T12:14:09.937Z | 2024-09-19T12:21:14.827Z |
5092081 | 5092081 | 20240912023621_HDYVD | UK00BD | 2024-09-16T12:13:40.018Z | 2024-09-19T12:21:13.622Z |
5089888 | 5089888 | 20240912010055_DDjeX | UK00BD | 2024-09-16T12:11:47.963Z | 2024-09-19T12:21:10.596Z |
5086881 | 5086881 | 20240912225324_GIaug | UK00BD | 2024-09-16T12:06:10.745Z | 2024-09-19T12:20:32.790Z |
5086543 | 5086543 | 20240912223949_nIAn3 | UK00BD | 2024-09-16T12:05:51.326Z | 2024-09-19T12:20:31.399Z |
5086368 | 5086368 | 20240912223048_vp4ZW | UK00BD | 2024-09-16T12:05:35.997Z | 2024-09-19T12:20:30.913Z |
5086025 | 5086025 | 20240912220441_ASoHF | UK00BD | 2024-09-16T12:05:10.170Z | 2024-09-19T12:20:30.007Z |
5080331 | 5080331 | 20240911034855_DxXbB | UK00BD | 2024-09-15T12:16:57.437Z | 2024-09-19T12:21:43.182Z |
5078788 | 5078788 | 20240911021542_bQ0X8 | UK00BD | 2024-09-15T12:15:51.781Z | 2024-09-19T12:21:40.710Z |
5074706 | 5074706 | 20240911225634_ecAQr | UK00BD | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.619Z |
5073798 | 5073798 | 20240911214411_E39HJ | UK00BD | 2024-09-15T12:07:37.906Z | 2024-09-19T12:21:06.181Z |
5073562 | 5073562 | 20240911212956_sHarz | UK00BD | 2024-09-15T12:07:18.501Z | 2024-09-19T12:21:05.859Z |
5073537 | 5073537 | 20240911212955_iHjoM | UK00BD | 2024-09-15T12:07:18.068Z | 2024-09-19T12:21:05.855Z |
5073477 | 5073477 | 20240911212725_Qytal | UK00BD | 2024-09-15T12:07:12.769Z | 2024-09-19T12:21:05.827Z |
5069539 | 5069539 | 20240910215022_H7pHH | UK00BD | 2024-09-14T12:19:59.629Z | 2024-09-19T12:21:34.997Z |
4971211 | 4971211 | 20240811223243_ZgBbV | UK00BD | 2024-09-05T12:09:40.957Z | 2024-09-06T12:08:50.346Z |
4941451 | 4941451 | 20240810233313_u2gKY | UK00BD | 2024-09-02T12:10:29.911Z | 2024-09-06T12:23:48.509Z |
4939982 | 4939982 | 20240810230218_2pEEK | UK00BD | 2024-09-01T12:10:14.490Z | 2024-09-06T12:23:29.703Z |
4903810 | 4903810 | 20240808031434_F2XP0 | UK00BD | 2024-08-28T12:19:55.507Z | 2024-08-28T12:19:55.507Z |
4903052 | 4903052 | 20240808023823_yG0nF | UK00BD | 2024-08-28T12:19:28.563Z | 2024-08-28T12:19:28.563Z |
4902526 | 4902526 | 20240808021612_TAWbh | UK00BD | 2024-08-28T12:19:19.766Z | 2024-08-28T12:19:19.766Z |
4902456 | 4902456 | 20240808021320_tcOkH | UK00BD | 2024-08-28T12:19:18.250Z | 2024-08-28T12:19:18.250Z |
4901556 | 4901556 | 20240808013644_xVGAt | UK00BD | 2024-08-28T12:18:46.548Z | 2024-08-28T12:18:46.548Z |
4876880 | 4876880 | 20240806234942_6tTZM | UK00BD | 2024-08-19T12:13:04.329Z | 2024-08-27T12:12:53.938Z |
4876702 | 4876702 | 20240806234426_k9v7V | UK00BD | 2024-08-19T12:12:58.543Z | 2024-08-27T12:12:47.282Z |
4876498 | 4876498 | 20240806234039_1JjTr | UK00BD | 2024-08-19T12:12:54.771Z | 2024-08-27T12:12:44.028Z |
4876062 | 4876062 | 20240806233049_fY5gw | UK00BD | 2024-08-19T12:12:36.699Z | 2024-08-27T12:12:29.399Z |
4874498 | 4874498 | 20240806225031_9KfAc | UK00BD | 2024-08-19T12:11:28.377Z | 2024-08-27T12:11:46.711Z |
4873942 | 4873942 | 20240806223733_vzQ0A | UK00BD | 2024-08-19T12:11:11.245Z | 2024-08-27T12:11:27.221Z |
4873304 | 4873304 | 20240806221747_WCuyR | UK00BD | 2024-08-19T12:10:41.855Z | 2024-08-27T12:11:05.545Z |
4826399 | 4826399 | 20240804030640_Kb6Rg | UK00BD | 2024-08-14T12:20:59.475Z | 2024-08-15T12:26:17.830Z |
4826392 | 4826392 | 20240804030543_B6Ijh | UK00BD | 2024-08-14T12:20:59.297Z | 2024-08-15T12:26:17.798Z |
4796885 | 4796885 | 20240802023554_fzm2p | UK00BD | 2024-08-11T12:16:13.564Z | 2024-08-11T12:16:13.564Z |
4796540 | 4796540 | 20240802021605_fROwI | UK00BD | 2024-08-11T12:16:07.184Z | 2024-08-11T12:16:07.184Z |
4796040 | 4796040 | 20240802015312_XcDFC | UK00BD | 2024-08-11T12:15:55.094Z | 2024-08-11T12:15:55.094Z |
4795867 | 4795867 | 20240802014534_XVJmO | UK00BD | 2024-08-11T12:15:51.089Z | 2024-08-11T12:15:51.089Z |
4786631 | 4786631 | 20240802010700_LEL3q | UK00BD | 2024-08-10T12:17:08.459Z | 2024-08-11T12:15:06.804Z |
4784681 | 4784681 | 20240801234209_9hUJH | UK00BD | 2024-08-10T12:15:18.969Z | 2024-08-11T12:14:34.680Z |
4783297 | 4783297 | 20240801221643_yHmFu | UK00BD | 2024-08-10T12:13:38.926Z | 2024-08-11T12:14:08.128Z |
4762676 | 4762676 | 20240731022455_OZY5t | UK00BD | 2024-08-06T12:02:56.987Z | 2024-08-10T12:17:52.825Z |
4762633 | 4762633 | 20240731022115_YsxMF | UK00BD | 2024-08-06T12:02:53.138Z | 2024-08-10T12:17:51.498Z |
4761465 | 4761465 | 20240731011742_YLNaF | UK00BD | 2024-08-06T12:00:23.288Z | 2024-08-10T12:17:17.427Z |
4761000 | 4761000 | 20240731000127_nkq3c | UK00BD | 2024-08-05T12:16:21.086Z | 2024-08-08T12:24:53.848Z |
4759509 | 4759509 | 20240730225254_21Z6p | UK00BD | 2024-08-05T12:15:27.584Z | 2024-08-08T12:24:04.069Z |
4747937 | 4747937 | 20240729215414_R6lP2 | UK00BD | 2024-08-04T12:14:57.592Z | 2024-08-06T12:15:23.378Z |
4744137 | 4744137 | 20240730014035_OC9Wr | UK00BD | 2024-08-04T12:05:51.635Z | 2024-08-08T12:17:49.152Z |
4741679 | 4741679 | 20240730003327_n7Ulv | UK00BD | 2024-08-04T12:01:56.326Z | 2024-08-08T12:16:43.127Z |
4736309 | 4736309 | 20240729024404_bBES3 | UK00BD | 2024-08-01T12:05:26.350Z | 2024-08-06T12:14:55.452Z |
4736076 | 4736076 | 20240729023250_766xP | UK00BD | 2024-08-01T12:05:21.548Z | 2024-08-06T12:14:54.520Z |
4735851 | 4735851 | 20240729022919_J250Y | UK00BD | 2024-08-01T12:05:18.137Z | 2024-08-06T12:14:54.112Z |
4735442 | 4735442 | 20240729021500_1Di8n | UK00BD | 2024-08-01T12:05:04.090Z | 2024-08-06T12:14:52.798Z |
4735380 | 4735380 | 20240729021402_rhKmr | UK00BD | 2024-08-01T12:05:01.992Z | 2024-08-06T12:14:52.630Z |
4733917 | 4733917 | 20240729013451_xG3ck | UK00BD | 2024-08-01T12:04:09.585Z | 2024-08-06T12:14:48.821Z |
4733773 | 4733773 | 20240729013155_VlIt8 | UK00BD | 2024-08-01T12:04:04.712Z | 2024-08-06T12:14:48.381Z |
4732543 | 4732543 | 20240729010029_KF1nH | UK00BD | 2024-08-01T12:03:08.153Z | 2024-08-06T12:14:44.246Z |
4732269 | 4732269 | 20240729005431_skiLB | UK00BD | 2024-08-01T12:02:57.236Z | 2024-08-06T12:14:43.713Z |
4732252 | 4732252 | 20240729005420_UaU9k | UK00BD | 2024-08-01T12:02:56.355Z | 2024-08-06T12:14:43.630Z |
4720444 | 4720444 | 20240728232653_zzyWa | UK00BD | 2024-07-31T12:01:22.563Z | 2024-08-06T12:14:32.633Z |
4718696 | 4718696 | 20240728024249_I6sr5 | UK00BD | 2024-07-30T12:09:47.589Z | 2024-08-05T12:19:56.033Z |
4717923 | 4717923 | 20240728021811_aBqat | UK00BD | 2024-07-30T12:08:59.730Z | 2024-08-05T12:19:53.873Z |
4715183 | 4715183 | 20240728010159_iYLIW | UK00BD | 2024-07-30T12:05:57.946Z | 2024-08-05T12:19:43.046Z |
4714550 | 4714550 | 20240728004135_dmPzW | UK00BD | 2024-07-30T12:05:16.040Z | 2024-08-05T12:19:40.768Z |
4707213 | 4707213 | 20240728002943_nupQx | UK00BD | 2024-07-29T12:04:15.061Z | 2024-08-05T12:19:39.319Z |
4705833 | 4705833 | 20240727231938_wJJHf | UK00BD | 2024-07-29T12:02:26.120Z | 2024-08-05T12:19:30.772Z |
4705415 | 4705415 | 20240727230009_h6S8Z | UK00BD | 2024-07-29T12:01:43.381Z | 2024-08-05T12:19:26.406Z |
4705321 | 4705321 | 20240727225731_RmExn | UK00BD | 2024-07-29T12:01:38.767Z | 2024-08-05T12:19:25.408Z |
4705053 | 4705053 | 20240727224256_5CYu9 | UK00BD | 2024-07-29T12:01:11.518Z | 2024-08-05T12:19:23.396Z |
4705014 | 4705014 | 20240727224126_l8hRm | UK00BD | 2024-07-29T12:01:07.882Z | 2024-08-05T12:19:23.176Z |
4704997 | 4704997 | 20240727224056_zrhVG | UK00BD | 2024-07-29T12:01:06.908Z | 2024-08-05T12:19:22.790Z |
4704766 | 4704766 | 20240727222125_8E6eg | UK00BD | 2024-07-29T12:00:49.284Z | 2024-08-05T12:19:19.263Z |
4697243 | 4697243 | 20240726235617_KMppF | UK00BD | 2024-07-28T12:04:03.292Z | 2024-08-04T12:19:13.717Z |
4696165 | 4696165 | 20240726224654_P1Cdd | UK00BD | 2024-07-28T12:02:27.255Z | 2024-08-04T12:19:09.089Z |
4695788 | 4695788 | 20240726222103_Hng5j | UK00BD | 2024-07-28T12:01:51.741Z | 2024-08-04T12:19:07.947Z |
4695607 | 4695607 | 20240726220702_IcWr6 | UK00BD | 2024-07-28T12:01:24.944Z | 2024-08-04T12:19:07.411Z |
4690858 | 4690858 | 20240726004151_Wws7D | UK00BD | 2024-07-27T12:04:14.344Z | 2024-08-03T12:21:13.722Z |
4690780 | 4690780 | 20240726003210_juwNH | UK00BD | 2024-07-27T12:04:05.422Z | 2024-08-03T12:21:12.957Z |
4690681 | 4690681 | 20240726002041_Q9diZ | UK00BD | 2024-07-27T12:03:56.100Z | 2024-08-03T12:21:12.055Z |
4690571 | 4690571 | 20240726000859_SwnlI | UK00BD | 2024-07-27T12:03:35.410Z | 2024-08-03T12:21:10.783Z |
4690207 | 4690207 | 20240725232424_tLoE2 | UK00BD | 2024-07-27T12:02:49.234Z | 2024-08-03T12:21:08.082Z |
4668604 | 4668604 | 20240719020918_btsV6 | UK00BD | 2024-07-20T12:04:46.376Z | 2024-07-27T12:17:18.091Z |
4667292 | 4667292 | 20240719003910_KMrUj | UK00BD | 2024-07-20T12:03:38.707Z | 2024-07-27T12:17:10.266Z |
4664070 | 4664070 | 20240717010941_UaDV5 | UK00BD | 2024-07-19T12:08:42.502Z | 2024-07-25T12:14:04.940Z |
4648849 | 4648849 | 20240715001513_l32fh | UK00BD | 2024-07-17T12:08:19.366Z | 2024-07-23T12:08:44.282Z |
4648394 | 4648394 | 20240714234428_O083q | UK00BD | 2024-07-17T12:07:53.776Z | 2024-07-23T12:08:42.862Z |
4648150 | 4648150 | 20240714232851_Nulab | UK00BD | 2024-07-17T12:07:41.788Z | 2024-07-23T12:08:42.318Z |
4647206 | 4647206 | 20240714222312_9jwoY | UK00BD | 2024-07-17T12:06:42.104Z | 2024-07-23T12:08:40.286Z |
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);