participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,633 rows where station_code = "UK0088" 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 |
---|---|---|---|---|---|
5573239 | 5573239 | 20241121041218_0J7Nq | UK0088 | 2024-11-22T14:19:17.616Z | 2024-11-22T14:19:22.474Z |
5573217 | 5573217 | 20241121040848_zuPYb | UK0088 | 2024-11-22T14:19:15.941Z | 2024-11-22T14:19:22.471Z |
5573165 | 5573165 | 20241121040121_YZ7j7 | UK0088 | 2024-11-22T14:19:13.477Z | 2024-11-22T14:19:22.462Z |
5573017 | 5573017 | 20241121033949_lPJ8S | UK0088 | 2024-11-22T14:19:04.562Z | 2024-11-22T14:19:22.434Z |
5572768 | 5572768 | 20241121030741_kkVq8 | UK0088 | 2024-11-22T14:18:48.592Z | 2024-11-22T14:19:22.387Z |
5572652 | 5572652 | 20241121025321_uWaRS | UK0088 | 2024-11-22T14:18:41.384Z | 2024-11-22T14:19:22.368Z |
5571603 | 5571603 | 20241121001530_V3aR2 | UK0088 | 2024-11-22T14:17:22.228Z | 2024-11-22T14:19:22.157Z |
5571535 | 5571535 | 20241121000145_K97Td | UK0088 | 2024-11-22T14:17:14.311Z | 2024-11-22T14:19:22.143Z |
5571513 | 5571513 | 20241121000021_3Wks9 | UK0088 | 2024-11-22T14:17:11.890Z | 2024-11-22T14:19:22.140Z |
5571366 | 5571366 | 20241120233233_5TqUv | UK0088 | 2024-11-22T14:16:57.829Z | 2024-11-22T14:19:22.111Z |
5571357 | 5571357 | 20241120232750_70g2P | UK0088 | 2024-11-22T14:16:56.563Z | 2024-11-22T14:19:22.109Z |
5571179 | 5571179 | 20241120224359_oELIY | UK0088 | 2024-11-22T14:16:34.453Z | 2024-11-22T14:19:22.057Z |
5571101 | 5571101 | 20241120222237_m3EmF | UK0088 | 2024-11-22T14:16:25.703Z | 2024-11-22T14:19:22.042Z |
5570947 | 5570947 | 20241120214009_DdX3j | UK0088 | 2024-11-22T14:16:13.777Z | 2024-11-22T14:19:22.011Z |
5570674 | 5570674 | 20241120204003_2IpSl | UK0088 | 2024-11-22T14:16:00.097Z | 2024-11-22T14:19:21.961Z |
5566508 | 5566508 | 20241121062501_70UhW | UK0088 | 2024-11-22T14:03:01.947Z | 2024-11-22T14:03:01.947Z |
5566342 | 5566342 | 20241121060207_aXcBg | UK0088 | 2024-11-22T14:02:29.622Z | 2024-11-22T14:02:29.622Z |
5566284 | 5566284 | 20241121055510_Sy06k | UK0088 | 2024-11-22T14:02:21.583Z | 2024-11-22T14:02:21.583Z |
5566224 | 5566224 | 20241121054851_NWWhN | UK0088 | 2024-11-22T14:02:15.870Z | 2024-11-22T14:02:15.870Z |
5566126 | 5566126 | 20241121053529_52w1X | UK0088 | 2024-11-22T14:01:54.288Z | 2024-11-22T14:01:54.288Z |
5566122 | 5566122 | 20241121053522_6urZL | UK0088 | 2024-11-22T14:01:53.729Z | 2024-11-22T14:01:53.729Z |
5566079 | 5566079 | 20241121052653_Yx27D | UK0088 | 2024-11-22T14:01:45.302Z | 2024-11-22T14:01:45.302Z |
5565734 | 5565734 | 20241121043933_cwexb | UK0088 | 2024-11-22T14:00:48.562Z | 2024-11-22T14:00:48.562Z |
5565684 | 5565684 | 20241121043524_rAGUD | UK0088 | 2024-11-22T14:00:40.705Z | 2024-11-22T14:00:40.705Z |
5565666 | 5565666 | 20241121043305_85RQf | UK0088 | 2024-11-22T14:00:37.756Z | 2024-11-22T14:00:37.756Z |
5565642 | 5565642 | 20241121043031_yMVhM | UK0088 | 2024-11-22T14:00:30.534Z | 2024-11-22T14:00:30.534Z |
5565534 | 5565534 | 20241121041944_Pk1Dy | UK0088 | 2024-11-22T14:00:13.150Z | 2024-11-22T14:00:13.150Z |
5565447 | 5565447 | 20241120042631_oQTAv | UK0088 | 2024-11-21T14:18:49.411Z | 2024-11-22T14:21:47.227Z |
5565318 | 5565318 | 20241120041908_9Y43M | UK0088 | 2024-11-21T14:18:46.485Z | 2024-11-22T14:21:45.971Z |
5565313 | 5565313 | 20241120041839_B8neb | UK0088 | 2024-11-21T14:18:46.205Z | 2024-11-22T14:21:45.887Z |
5565295 | 5565295 | 20241120041701_aDnh0 | UK0088 | 2024-11-21T14:18:45.551Z | 2024-11-22T14:21:45.752Z |
5565088 | 5565088 | 20241120035100_IBmkW | UK0088 | 2024-11-21T14:18:28.623Z | 2024-11-22T14:21:41.383Z |
5564892 | 5564892 | 20241120033614_PEJty | UK0088 | 2024-11-21T14:18:13.713Z | 2024-11-22T14:21:39.073Z |
5564809 | 5564809 | 20241120032847_3N51N | UK0088 | 2024-11-21T14:18:05.218Z | 2024-11-22T14:21:36.704Z |
5564777 | 5564777 | 20241120032537_O9I35 | UK0088 | 2024-11-21T14:18:02.738Z | 2024-11-22T14:21:36.330Z |
5563388 | 5563388 | 20241120012418_BX0eD | UK0088 | 2024-11-21T14:16:01.911Z | 2024-11-22T14:21:14.858Z |
5562517 | 5562517 | 20241119234657_Z8Mv2 | UK0088 | 2024-11-21T14:15:04.758Z | 2024-11-22T14:20:59.745Z |
5561280 | 5561280 | 20241119192927_KAKUl | UK0088 | 2024-11-21T14:12:56.560Z | 2024-11-22T14:20:29.538Z |
5561222 | 5561222 | 20241119190815_zehxp | UK0088 | 2024-11-21T14:12:40.799Z | 2024-11-22T14:20:26.764Z |
5561070 | 5561070 | 20241119174906_t2xa4 | UK0088 | 2024-11-21T14:12:19.500Z | 2024-11-22T14:20:18.860Z |
5561048 | 5561048 | 20241119172331_eyllf | UK0088 | 2024-11-21T14:12:13.711Z | 2024-11-22T14:20:16.623Z |
5558519 | 5558519 | 20241120062018_2UAg9 | UK0088 | 2024-11-21T14:03:29.450Z | 2024-11-22T14:19:21.243Z |
5558509 | 5558509 | 20241120061922_tFwiZ | UK0088 | 2024-11-21T14:03:27.739Z | 2024-11-22T14:19:21.242Z |
5558388 | 5558388 | 20241120060139_ItavS | UK0088 | 2024-11-21T14:03:10.710Z | 2024-11-22T14:19:21.222Z |
5557999 | 5557999 | 20241120052934_9j9Ib | UK0088 | 2024-11-21T14:02:14.404Z | 2024-11-22T14:19:21.159Z |
5557933 | 5557933 | 20241120052413_cU6Ow | UK0088 | 2024-11-21T14:02:05.737Z | 2024-11-22T14:19:21.148Z |
5557826 | 5557826 | 20241120051537_MSkTo | UK0088 | 2024-11-21T14:01:52.498Z | 2024-11-22T14:19:21.135Z |
5557675 | 5557675 | 20241120050436_6sJAR | UK0088 | 2024-11-21T14:01:28.972Z | 2024-11-22T14:19:21.109Z |
5557627 | 5557627 | 20241120050225_8hSlr | UK0088 | 2024-11-21T14:01:23.435Z | 2024-11-22T14:19:21.102Z |
5553873 | 5553873 | 20241118043641_MHJBX | UK0088 | 2024-11-19T14:11:30.777Z | 2024-11-22T14:22:56.646Z |
5553851 | 5553851 | 20241118043210_0wg1a | UK0088 | 2024-11-19T14:11:29.961Z | 2024-11-22T14:22:56.554Z |
5553843 | 5553843 | 20241118043106_1VkeE | UK0088 | 2024-11-19T14:11:29.563Z | 2024-11-22T14:22:56.527Z |
5553835 | 5553835 | 20241118042805_u5gTX | UK0088 | 2024-11-19T14:11:29.429Z | 2024-11-22T14:22:56.522Z |
5553806 | 5553806 | 20241118042312_at51j | UK0088 | 2024-11-19T14:11:27.738Z | 2024-11-22T14:22:56.378Z |
5553499 | 5553499 | 20241118030035_MXsQ4 | UK0088 | 2024-11-19T14:10:43.328Z | 2024-11-22T14:22:53.568Z |
5553419 | 5553419 | 20241118022917_6EX8t | UK0088 | 2024-11-19T14:10:32.776Z | 2024-11-22T14:22:53.117Z |
5553362 | 5553362 | 20241118021024_Dj3kD | UK0088 | 2024-11-19T14:10:22.946Z | 2024-11-22T14:22:52.404Z |
5553211 | 5553211 | 20241118013914_gAQdC | UK0088 | 2024-11-19T14:10:09.866Z | 2024-11-22T14:22:51.085Z |
5553162 | 5553162 | 20241118011054_LUfP7 | UK0088 | 2024-11-19T14:10:07.182Z | 2024-11-22T14:22:50.932Z |
5549773 | 5549773 | 20241118062319_3Nzqa | UK0088 | 2024-11-19T14:00:48.680Z | 2024-11-22T14:21:52.542Z |
5549741 | 5549741 | 20241118061342_dXuJi | UK0088 | 2024-11-19T14:00:42.015Z | 2024-11-22T14:21:51.905Z |
5549737 | 5549737 | 20241118061226_VUk9t | UK0088 | 2024-11-19T14:00:41.799Z | 2024-11-22T14:21:51.872Z |
5549685 | 5549685 | 20241118055949_t3asF | UK0088 | 2024-11-19T14:00:33.993Z | 2024-11-22T14:21:51.187Z |
5549671 | 5549671 | 20241118055559_ueMwq | UK0088 | 2024-11-19T14:00:32.797Z | 2024-11-22T14:21:51.126Z |
5549451 | 5549451 | 20241117045522_a6n5U | UK0088 | 2024-11-18T14:11:37.519Z | 2024-11-22T14:23:21.064Z |
5549292 | 5549292 | 20241117041219_0eP1W | UK0088 | 2024-11-18T14:11:25.353Z | 2024-11-22T14:23:20.030Z |
5549184 | 5549184 | 20241117033847_l8oyu | UK0088 | 2024-11-18T14:11:14.233Z | 2024-11-22T14:23:19.178Z |
5548982 | 5548982 | 20241117023441_Ts8sN | UK0088 | 2024-11-18T14:10:34.937Z | 2024-11-22T14:23:17.386Z |
5548906 | 5548906 | 20241117021159_dNE5U | UK0088 | 2024-11-18T14:10:25.068Z | 2024-11-22T14:23:16.757Z |
5548748 | 5548748 | 20241117012635_cRIkQ | UK0088 | 2024-11-18T14:10:09.296Z | 2024-11-22T14:23:15.431Z |
5548744 | 5548744 | 20241117012520_Pp9mW | UK0088 | 2024-11-18T14:10:08.589Z | 2024-11-22T14:23:15.406Z |
5548671 | 5548671 | 20241117010054_B9LeE | UK0088 | 2024-11-18T14:09:49.104Z | 2024-11-22T14:23:15.088Z |
5542053 | 5542053 | 20241114053428_2oBAv | UK0088 | 2024-11-15T14:08:51.297Z | 2024-11-22T14:24:21.906Z |
5542012 | 5542012 | 20241114052908_33NpS | UK0088 | 2024-11-15T14:08:47.678Z | 2024-11-22T14:24:21.694Z |
5541916 | 5541916 | 20241114050909_OCWfe | UK0088 | 2024-11-15T14:08:39.844Z | 2024-11-22T14:24:21.010Z |
5541898 | 5541898 | 20241114050508_IPV29 | UK0088 | 2024-11-15T14:08:38.375Z | 2024-11-22T14:24:20.971Z |
5541728 | 5541728 | 20241114040627_n6HUl | UK0088 | 2024-11-15T14:08:17.227Z | 2024-11-22T14:24:20.038Z |
5541696 | 5541696 | 20241114035727_2gPJn | UK0088 | 2024-11-15T14:08:11.704Z | 2024-11-22T14:24:19.971Z |
5541616 | 5541616 | 20241114031349_xHl7p | UK0088 | 2024-11-15T14:07:57.294Z | 2024-11-22T14:24:19.621Z |
5541547 | 5541547 | 20241114022958_MIk8K | UK0088 | 2024-11-15T14:07:49.467Z | 2024-11-22T14:24:19.380Z |
5541536 | 5541536 | 20241114022746_RxpTr | UK0088 | 2024-11-15T14:07:48.440Z | 2024-11-22T14:24:19.362Z |
5539283 | 5539283 | 20241114060437_ce35M | UK0088 | 2024-11-15T14:00:34.598Z | 2024-11-22T14:23:42.852Z |
5539280 | 5539280 | 20241114060432_KcoVx | UK0088 | 2024-11-15T14:00:34.239Z | 2024-11-22T14:23:42.849Z |
5539154 | 5539154 | 20241114054205_NiVKB | UK0088 | 2024-11-15T14:00:13.548Z | 2024-11-22T14:23:42.188Z |
5537801 | 5537801 | 20241113004037_dCHo6 | UK0088 | 2024-11-14T14:12:30.825Z | 2024-11-21T14:26:16.193Z |
5537764 | 5537764 | 20241113002947_z0fUW | UK0088 | 2024-11-14T14:12:29.070Z | 2024-11-21T14:26:15.848Z |
5537632 | 5537632 | 20241112235604_ShkYw | UK0088 | 2024-11-14T14:12:19.876Z | 2024-11-21T14:26:15.012Z |
5537618 | 5537618 | 20241112235400_z8fmY | UK0088 | 2024-11-14T14:12:17.365Z | 2024-11-21T14:26:14.960Z |
5537346 | 5537346 | 20241112221404_b22TI | UK0088 | 2024-11-14T14:11:39.556Z | 2024-11-21T14:26:11.361Z |
5537206 | 5537206 | 20241112210024_ESgWx | UK0088 | 2024-11-14T14:11:18.481Z | 2024-11-21T14:26:09.719Z |
5532077 | 5532077 | 20241112043509_IfBmZ | UK0088 | 2024-11-13T14:16:16.071Z | 2024-11-20T14:26:18.387Z |
5531763 | 5531763 | 20241112040756_bnqEn | UK0088 | 2024-11-13T14:15:53.951Z | 2024-11-20T14:26:14.086Z |
5531718 | 5531718 | 20241112040338_cI8Mw | UK0088 | 2024-11-13T14:15:52.129Z | 2024-11-20T14:26:13.649Z |
5531469 | 5531469 | 20241112034119_BoEq1 | UK0088 | 2024-11-13T14:15:41.355Z | 2024-11-20T14:26:11.592Z |
5531412 | 5531412 | 20241112033824_AuADN | UK0088 | 2024-11-13T14:15:38.234Z | 2024-11-20T14:26:11.165Z |
5530717 | 5530717 | 20241112023953_DMH7F | UK0088 | 2024-11-13T14:14:30.655Z | 2024-11-20T14:26:02.876Z |
5530487 | 5530487 | 20241112022258_8lb6E | UK0088 | 2024-11-13T14:14:18.469Z | 2024-11-20T14:26:00.718Z |
5530111 | 5530111 | 20241112014428_7buJ0 | UK0088 | 2024-11-13T14:13:55.921Z | 2024-11-20T14:25:54.356Z |
5529847 | 5529847 | 20241112011025_ScYzq | UK0088 | 2024-11-13T14:13:15.222Z | 2024-11-20T14:25:49.969Z |
5529790 | 5529790 | 20241112010512_cEo2D | UK0088 | 2024-11-13T14:13:11.379Z | 2024-11-20T14:25:48.235Z |
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);