participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
622 rows where station_code = "UK00CC" 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 |
---|---|---|---|---|---|
5135669 | 5135669 | 20240914032803_Z9V0y | UK00CC | 2024-09-19T12:20:00.602Z | 2024-09-19T12:20:00.602Z |
5135311 | 5135311 | 20240915034452_7Om9l | UK00CC | 2024-09-19T12:19:12.501Z | 2024-09-19T12:19:12.501Z |
5129736 | 5129736 | 20240917042446_4c0yQ | UK00CC | 2024-09-19T12:12:02.431Z | 2024-09-19T12:12:02.431Z |
5128001 | 5128001 | 20240917001919_iSM1L | UK00CC | 2024-09-19T12:09:53.630Z | 2024-09-19T12:09:53.630Z |
5127893 | 5127893 | 20240917000013_TaN8V | UK00CC | 2024-09-19T12:09:45.565Z | 2024-09-19T12:09:45.565Z |
5127869 | 5127869 | 20240916235259_WIz2t | UK00CC | 2024-09-19T12:09:44.338Z | 2024-09-19T12:09:44.338Z |
5127853 | 5127853 | 20240916234922_0JWGJ | UK00CC | 2024-09-19T12:09:43.734Z | 2024-09-19T12:09:43.734Z |
5127837 | 5127837 | 20240916234549_odMUB | UK00CC | 2024-09-19T12:09:42.369Z | 2024-09-19T12:09:42.369Z |
5127792 | 5127792 | 20240916232954_E4Zqu | UK00CC | 2024-09-19T12:09:38.700Z | 2024-09-19T12:09:38.700Z |
5127773 | 5127773 | 20240916232436_VgJLe | UK00CC | 2024-09-19T12:09:36.975Z | 2024-09-19T12:09:36.975Z |
5127723 | 5127723 | 20240916231020_Lo0L5 | UK00CC | 2024-09-19T12:09:34.297Z | 2024-09-19T12:09:34.297Z |
5127473 | 5127473 | 20240916220327_5JFVg | UK00CC | 2024-09-19T12:09:12.991Z | 2024-09-19T12:09:12.991Z |
5127466 | 5127466 | 20240916215806_SdF3p | UK00CC | 2024-09-19T12:09:11.154Z | 2024-09-19T12:09:11.154Z |
5127455 | 5127455 | 20240916215228_fyYNu | UK00CC | 2024-09-19T12:09:07.598Z | 2024-09-19T12:09:07.598Z |
5127422 | 5127422 | 20240916214620_NCFqq | UK00CC | 2024-09-19T12:09:05.127Z | 2024-09-19T12:09:05.127Z |
5127355 | 5127355 | 20240916213453_YHrjt | UK00CC | 2024-09-19T12:08:56.810Z | 2024-09-19T12:08:56.810Z |
5127213 | 5127213 | 20240916205455_3OK9Z | UK00CC | 2024-09-19T12:08:32.234Z | 2024-09-19T12:08:32.234Z |
5126906 | 5126906 | 20240916194848_vd6lL | UK00CC | 2024-09-19T12:07:37.803Z | 2024-09-19T12:07:37.803Z |
5126872 | 5126872 | 20240916194132_mW4qH | UK00CC | 2024-09-19T12:07:28.727Z | 2024-09-19T12:07:28.727Z |
5126834 | 5126834 | 20240916194024_Ud8Qt | UK00CC | 2024-09-19T12:07:24.402Z | 2024-09-19T12:07:24.402Z |
5125401 | 5125401 | 20240918022835_IQf3K | UK00CC | 2024-09-19T12:03:09.420Z | 2024-09-19T12:06:42.026Z |
5125320 | 5125320 | 20240918020530_3UEta | UK00CC | 2024-09-19T12:02:48.302Z | 2024-09-19T12:06:42.011Z |
5124338 | 5124338 | 20240917193402_iW4mb | UK00CC | 2024-09-19T12:00:35.978Z | 2024-09-19T12:06:41.879Z |
5121944 | 5121944 | 20240914042145_aRjtH | UK00CC | 2024-09-18T12:11:03.196Z | 2024-09-19T12:20:02.523Z |
5121595 | 5121595 | 20240914041015_fnO1f | UK00CC | 2024-09-18T12:10:58.727Z | 2024-09-19T12:20:02.160Z |
5121368 | 5121368 | 20240914035905_QiNcV | UK00CC | 2024-09-18T12:10:54.685Z | 2024-09-19T12:20:01.699Z |
5121296 | 5121296 | 20240914035744_4lrF8 | UK00CC | 2024-09-18T12:10:54.113Z | 2024-09-19T12:20:01.619Z |
5121258 | 5121258 | 20240914035641_jtQxq | UK00CC | 2024-09-18T12:10:53.299Z | 2024-09-19T12:20:01.533Z |
5121124 | 5121124 | 20240914035228_sJvYo | UK00CC | 2024-09-18T12:10:51.280Z | 2024-09-19T12:20:01.367Z |
5120945 | 5120945 | 20240914034205_Gq0aN | UK00CC | 2024-09-18T12:10:48.814Z | 2024-09-19T12:20:01.076Z |
5120807 | 5120807 | 20240914033549_HftPa | UK00CC | 2024-09-18T12:10:47.080Z | 2024-09-19T12:20:00.901Z |
5120738 | 5120738 | 20240914033304_2dWFf | UK00CC | 2024-09-18T12:10:46.215Z | 2024-09-19T12:20:00.801Z |
5120649 | 5120649 | 20240914033037_YKJCw | UK00CC | 2024-09-18T12:10:44.189Z | 2024-09-19T12:20:00.671Z |
5120553 | 5120553 | 20240914032754_uE9bi | UK00CC | 2024-09-18T12:10:42.964Z | 2024-09-19T12:20:00.564Z |
5120460 | 5120460 | 20240914032048_RlZ3d | UK00CC | 2024-09-18T12:10:40.749Z | 2024-09-19T12:20:00.331Z |
5120040 | 5120040 | 20240914025743_bg8z7 | UK00CC | 2024-09-18T12:10:31.178Z | 2024-09-19T12:19:59.342Z |
5119891 | 5119891 | 20240914025141_uCbHb | UK00CC | 2024-09-18T12:10:28.432Z | 2024-09-19T12:19:59.053Z |
5119859 | 5119859 | 20240914025107_tYCQn | UK00CC | 2024-09-18T12:10:28.236Z | 2024-09-19T12:19:59.028Z |
5119671 | 5119671 | 20240914024356_3tGR8 | UK00CC | 2024-09-18T12:10:23.879Z | 2024-09-19T12:19:58.715Z |
5119511 | 5119511 | 20240914023649_c77Dl | UK00CC | 2024-09-18T12:10:21.809Z | 2024-09-19T12:19:58.397Z |
5119140 | 5119140 | 20240914021227_p9Q83 | UK00CC | 2024-09-18T12:10:16.493Z | 2024-09-19T12:19:57.218Z |
5117299 | 5117299 | 20240915041633_GX8vC | UK00CC | 2024-09-18T12:07:37.210Z | 2024-09-19T12:19:14.148Z |
5116873 | 5116873 | 20240915034443_G1tt1 | UK00CC | 2024-09-18T12:07:23.700Z | 2024-09-19T12:19:12.484Z |
5116769 | 5116769 | 20240915034018_8sSmw | UK00CC | 2024-09-18T12:07:20.178Z | 2024-09-19T12:19:12.313Z |
5116589 | 5116589 | 20240915033225_MK2tZ | UK00CC | 2024-09-18T12:07:10.683Z | 2024-09-19T12:19:11.568Z |
5116508 | 5116508 | 20240915033018_VgXWk | UK00CC | 2024-09-18T12:07:07.881Z | 2024-09-19T12:19:11.410Z |
5116369 | 5116369 | 20240915032348_51WgL | UK00CC | 2024-09-18T12:07:00.127Z | 2024-09-19T12:19:10.742Z |
5116195 | 5116195 | 20240915031532_ci99d | UK00CC | 2024-09-18T12:06:47.178Z | 2024-09-19T12:19:09.604Z |
5116173 | 5116173 | 20240915031254_FwXDE | UK00CC | 2024-09-18T12:06:45.632Z | 2024-09-19T12:19:09.098Z |
5116146 | 5116146 | 20240915031156_ahNCo | UK00CC | 2024-09-18T12:06:43.795Z | 2024-09-19T12:19:08.957Z |
5116072 | 5116072 | 20240915030714_e97Xy | UK00CC | 2024-09-18T12:06:36.742Z | 2024-09-19T12:19:08.385Z |
5115932 | 5115932 | 20240915025921_Xj6EX | UK00CC | 2024-09-18T12:06:31.911Z | 2024-09-19T12:19:07.870Z |
5115916 | 5115916 | 20240915025912_eze3N | UK00CC | 2024-09-18T12:06:31.499Z | 2024-09-19T12:19:07.807Z |
5115783 | 5115783 | 20240915025326_CVwGf | UK00CC | 2024-09-18T12:06:23.758Z | 2024-09-19T12:19:07.328Z |
5115374 | 5115374 | 20240915023515_zDfX8 | UK00CC | 2024-09-18T12:06:11.906Z | 2024-09-19T12:19:04.067Z |
5115273 | 5115273 | 20240915023052_NiTKC | UK00CC | 2024-09-18T12:06:09.253Z | 2024-09-19T12:19:03.567Z |
5115140 | 5115140 | 20240915022149_vJkX6 | UK00CC | 2024-09-18T12:06:02.791Z | 2024-09-19T12:19:02.495Z |
5114825 | 5114825 | 20240915020025_2J9Ay | UK00CC | 2024-09-18T12:05:35.842Z | 2024-09-19T12:19:00.092Z |
5114647 | 5114647 | 20240915015238_54fTx | UK00CC | 2024-09-18T12:05:26.560Z | 2024-09-19T12:18:59.152Z |
5114392 | 5114392 | 20240915014044_iD3CJ | UK00CC | 2024-09-18T12:05:14.129Z | 2024-09-19T12:18:57.925Z |
5114154 | 5114154 | 20240915012945_XOYjJ | UK00CC | 2024-09-18T12:05:04.252Z | 2024-09-19T12:18:56.435Z |
5114089 | 5114089 | 20240915012615_INRhS | UK00CC | 2024-09-18T12:05:01.383Z | 2024-09-19T12:18:55.801Z |
5113914 | 5113914 | 20240915011813_4rPkM | UK00CC | 2024-09-18T12:04:55.121Z | 2024-09-19T12:18:54.250Z |
5113864 | 5113864 | 20240915011552_lJSl9 | UK00CC | 2024-09-18T12:04:53.314Z | 2024-09-19T12:18:53.443Z |
5113687 | 5113687 | 20240915010509_grEkf | UK00CC | 2024-09-18T12:04:39.659Z | 2024-09-19T12:18:51.253Z |
5113605 | 5113605 | 20240915010038_yynXa | UK00CC | 2024-09-18T12:04:34.570Z | 2024-09-19T12:18:50.528Z |
5113559 | 5113559 | 20240915005842_zCgmm | UK00CC | 2024-09-18T12:04:30.204Z | 2024-09-19T12:18:50.377Z |
5113451 | 5113451 | 20240915004949_mcy3v | UK00CC | 2024-09-18T12:04:17.704Z | 2024-09-19T12:18:49.142Z |
5113265 | 5113265 | 20240915003432_6n1N7 | UK00CC | 2024-09-18T12:04:05.017Z | 2024-09-19T12:18:48.290Z |
5113045 | 5113045 | 20240915001649_t9UHd | UK00CC | 2024-09-18T12:03:52.782Z | 2024-09-19T12:18:46.683Z |
5112661 | 5112661 | 20240914233857_oFHQB | UK00CC | 2024-09-18T12:03:19.364Z | 2024-09-19T12:18:42.651Z |
5112599 | 5112599 | 20240914233034_ABu4f | UK00CC | 2024-09-18T12:03:15.509Z | 2024-09-19T12:18:41.527Z |
5112557 | 5112557 | 20240914232901_rULlG | UK00CC | 2024-09-18T12:03:13.309Z | 2024-09-19T12:18:41.438Z |
5112486 | 5112486 | 20240914232049_jVqPh | UK00CC | 2024-09-18T12:03:10.355Z | 2024-09-19T12:18:41.147Z |
5112480 | 5112480 | 20240914231854_40L2a | UK00CC | 2024-09-18T12:03:09.635Z | 2024-09-19T12:18:41.112Z |
5112466 | 5112466 | 20240914231847_2KZA0 | UK00CC | 2024-09-18T12:03:09.177Z | 2024-09-19T12:18:41.085Z |
5112444 | 5112444 | 20240914231447_tdCWJ | UK00CC | 2024-09-18T12:03:06.394Z | 2024-09-19T12:18:41.023Z |
5112035 | 5112035 | 20240914220133_n9GpU | UK00CC | 2024-09-18T12:02:42.739Z | 2024-09-19T12:18:36.650Z |
5111952 | 5111952 | 20240914214554_0Ehjz | UK00CC | 2024-09-18T12:02:31.944Z | 2024-09-19T12:18:35.473Z |
5111896 | 5111896 | 20240914213134_Iov9u | UK00CC | 2024-09-18T12:02:28.899Z | 2024-09-19T12:18:34.928Z |
5111788 | 5111788 | 20240914211700_pLBEl | UK00CC | 2024-09-18T12:02:17.053Z | 2024-09-19T12:18:34.037Z |
5111705 | 5111705 | 20240914210049_wBjPi | UK00CC | 2024-09-18T12:02:11.198Z | 2024-09-19T12:18:33.329Z |
5111589 | 5111589 | 20240914205051_F6LRZ | UK00CC | 2024-09-18T12:02:04.393Z | 2024-09-19T12:18:31.498Z |
5111571 | 5111571 | 20240914204925_jNPIh | UK00CC | 2024-09-18T12:02:03.715Z | 2024-09-19T12:18:31.430Z |
5111498 | 5111498 | 20240914204238_hSIkr | UK00CC | 2024-09-18T12:01:59.530Z | 2024-09-19T12:18:30.823Z |
5111384 | 5111384 | 20240914203000_lOAmu | UK00CC | 2024-09-18T12:01:53.242Z | 2024-09-19T12:18:29.753Z |
5111306 | 5111306 | 20240914202048_RBYeT | UK00CC | 2024-09-18T12:01:48.338Z | 2024-09-19T12:18:28.847Z |
5111240 | 5111240 | 20240914201314_Fgem2 | UK00CC | 2024-09-18T12:01:44.638Z | 2024-09-19T12:18:27.914Z |
5111177 | 5111177 | 20240914200837_zjWMY | UK00CC | 2024-09-18T12:01:41.650Z | 2024-09-19T12:18:27.193Z |
5111139 | 5111139 | 20240914200745_M1ElU | UK00CC | 2024-09-18T12:01:39.888Z | 2024-09-19T12:18:26.932Z |
5111040 | 5111040 | 20240914194527_qURbs | UK00CC | 2024-09-18T12:01:22.579Z | 2024-09-19T12:18:25.566Z |
5110979 | 5110979 | 20240914193728_DJtmL | UK00CC | 2024-09-18T12:01:17.398Z | 2024-09-19T12:18:25.203Z |
5110930 | 5110930 | 20240914192850_63oxz | UK00CC | 2024-09-18T12:01:12.841Z | 2024-09-19T12:18:24.875Z |
5110454 | 5110454 | 20240911010346_TXvjR | UK00CC | 2024-09-17T12:17:57.870Z | 2024-09-19T12:21:39.378Z |
5110430 | 5110430 | 20240910230535_Pm9rG | UK00CC | 2024-09-17T12:17:52.510Z | 2024-09-19T12:21:36.376Z |
5110426 | 5110426 | 20240910224240_Q1l5m | UK00CC | 2024-09-17T12:17:51.511Z | 2024-09-19T12:21:35.911Z |
5108201 | 5108201 | 20240913042950_cRSgj | UK00CC | 2024-09-17T12:13:32.481Z | 2024-09-19T12:20:47.916Z |
5108189 | 5108189 | 20240913042949_vHcOJ | UK00CC | 2024-09-17T12:13:32.374Z | 2024-09-19T12:20:47.911Z |
5107680 | 5107680 | 20240913040748_x4tvX | UK00CC | 2024-09-17T12:13:20.791Z | 2024-09-19T12:20:47.447Z |
5107553 | 5107553 | 20240913035854_mqhvd | UK00CC | 2024-09-17T12:13:16.758Z | 2024-09-19T12:20:47.214Z |
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);