participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
306 rows where station_code = "UK00C6" 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 |
---|---|---|---|---|---|
5564698 | 5564698 | 20241120032108_vszfg | UK00C6 | 2024-11-21T14:17:58.618Z | 2024-11-21T14:18:54.085Z |
5563546 | 5563546 | 20241120013927_h9RaX | UK00C6 | 2024-11-21T14:16:16.201Z | 2024-11-21T14:18:53.873Z |
5562881 | 5562881 | 20241120002259_ApmAp | UK00C6 | 2024-11-21T14:15:25.869Z | 2024-11-21T14:18:53.754Z |
5562774 | 5562774 | 20241120001059_eT7gc | UK00C6 | 2024-11-21T14:15:21.370Z | 2024-11-21T14:18:53.736Z |
5562739 | 5562739 | 20241120000706_RlB3U | UK00C6 | 2024-11-21T14:15:19.164Z | 2024-11-21T14:18:53.730Z |
5562632 | 5562632 | 20241119235851_PcgYC | UK00C6 | 2024-11-21T14:15:14.402Z | 2024-11-21T14:18:53.712Z |
5562557 | 5562557 | 20241119235218_3mUva | UK00C6 | 2024-11-21T14:15:08.329Z | 2024-11-21T14:18:53.701Z |
5562462 | 5562462 | 20241119234029_4vET7 | UK00C6 | 2024-11-21T14:14:53.615Z | 2024-11-21T14:18:53.688Z |
5562140 | 5562140 | 20241119230258_L3Qrs | UK00C6 | 2024-11-21T14:14:28.483Z | 2024-11-21T14:18:53.639Z |
5561950 | 5561950 | 20241119223851_JbdP9 | UK00C6 | 2024-11-21T14:14:16.576Z | 2024-11-21T14:18:53.610Z |
5561826 | 5561826 | 20241119221459_33sA3 | UK00C6 | 2024-11-21T14:14:08.755Z | 2024-11-21T14:18:53.588Z |
5561791 | 5561791 | 20241119220822_kjGFT | UK00C6 | 2024-11-21T14:14:06.416Z | 2024-11-21T14:18:53.581Z |
5561773 | 5561773 | 20241119220547_pcRmQ | UK00C6 | 2024-11-21T14:14:03.883Z | 2024-11-21T14:18:53.578Z |
5561738 | 5561738 | 20241119215432_HE2lz | UK00C6 | 2024-11-21T14:13:53.850Z | 2024-11-21T14:18:53.571Z |
5543265 | 5543265 | 20241114233403_MH14E | UK00C6 | 2024-11-16T14:05:54.944Z | 2024-11-21T14:24:25.524Z |
5543214 | 5543214 | 20241114230632_K3hVz | UK00C6 | 2024-11-16T14:05:45.815Z | 2024-11-21T14:24:25.301Z |
5543208 | 5543208 | 20241114230107_P3w0i | UK00C6 | 2024-11-16T14:05:43.611Z | 2024-11-21T14:24:25.247Z |
5543139 | 5543139 | 20241114214910_NhDcA | UK00C6 | 2024-11-16T14:05:36.564Z | 2024-11-21T14:24:24.178Z |
5541284 | 5541284 | 20241113234151_OnA53 | UK00C6 | 2024-11-15T14:07:22.287Z | 2024-11-21T14:25:13.414Z |
5541241 | 5541241 | 20241113214910_jBDLd | UK00C6 | 2024-11-15T14:07:06.169Z | 2024-11-21T14:25:11.729Z |
5538527 | 5538527 | 20241113040306_493ZW | UK00C6 | 2024-11-14T14:13:35.620Z | 2024-11-21T14:26:26.999Z |
5538209 | 5538209 | 20241113023906_89zUV | UK00C6 | 2024-11-14T14:13:03.798Z | 2024-11-21T14:26:21.705Z |
5537997 | 5537997 | 20241113015104_ptxPK | UK00C6 | 2024-11-14T14:12:42.166Z | 2024-11-21T14:26:18.599Z |
5537824 | 5537824 | 20241113004917_Pz3Is | UK00C6 | 2024-11-14T14:12:31.855Z | 2024-11-21T14:26:16.373Z |
5537354 | 5537354 | 20241112221841_8Nu5o | UK00C6 | 2024-11-14T14:11:39.746Z | 2024-11-21T14:26:11.364Z |
5532676 | 5532676 | 20241112055038_dPHBC | UK00C6 | 2024-11-13T14:17:08.766Z | 2024-11-20T14:26:25.599Z |
5532628 | 5532628 | 20241112054443_yfoL3 | UK00C6 | 2024-11-13T14:17:03.950Z | 2024-11-20T14:26:25.194Z |
5532604 | 5532604 | 20241112054320_2ctLY | UK00C6 | 2024-11-13T14:17:02.572Z | 2024-11-20T14:26:25.052Z |
5532536 | 5532536 | 20241112053522_rDplF | UK00C6 | 2024-11-13T14:16:58.168Z | 2024-11-20T14:26:24.316Z |
5532528 | 5532528 | 20241112053408_c64Cg | UK00C6 | 2024-11-13T14:16:57.445Z | 2024-11-20T14:26:24.255Z |
5532502 | 5532502 | 20241112053204_EAZEo | UK00C6 | 2024-11-13T14:16:53.852Z | 2024-11-20T14:26:24.022Z |
5532352 | 5532352 | 20241112051054_bt12S | UK00C6 | 2024-11-13T14:16:38.583Z | 2024-11-20T14:26:22.136Z |
5532184 | 5532184 | 20241112044754_tIfyq | UK00C6 | 2024-11-13T14:16:25.162Z | 2024-11-20T14:26:20.710Z |
5531926 | 5531926 | 20241112041953_jwbWW | UK00C6 | 2024-11-13T14:16:02.612Z | 2024-11-20T14:26:15.939Z |
5531894 | 5531894 | 20241112041722_Xr93z | UK00C6 | 2024-11-13T14:16:00.870Z | 2024-11-20T14:26:15.711Z |
5531889 | 5531889 | 20241112041716_ofxe2 | UK00C6 | 2024-11-13T14:16:00.760Z | 2024-11-20T14:26:15.673Z |
5531863 | 5531863 | 20241112041343_ar35n | UK00C6 | 2024-11-13T14:15:59.333Z | 2024-11-20T14:26:15.301Z |
5531847 | 5531847 | 20241112041246_z2lyL | UK00C6 | 2024-11-13T14:15:58.408Z | 2024-11-20T14:26:15.158Z |
5531698 | 5531698 | 20241112040019_CnnY7 | UK00C6 | 2024-11-13T14:15:50.961Z | 2024-11-20T14:26:13.556Z |
5531305 | 5531305 | 20241112033020_X8SUz | UK00C6 | 2024-11-13T14:15:33.712Z | 2024-11-20T14:26:10.188Z |
5531205 | 5531205 | 20241112032156_Nbm4Z | UK00C6 | 2024-11-13T14:15:24.902Z | 2024-11-20T14:26:08.568Z |
5531106 | 5531106 | 20241112031500_qBMeg | UK00C6 | 2024-11-13T14:15:14.765Z | 2024-11-20T14:26:07.870Z |
5530947 | 5530947 | 20241112030132_EvW7D | UK00C6 | 2024-11-13T14:14:52.718Z | 2024-11-20T14:26:05.529Z |
5530502 | 5530502 | 20241112022439_8rDCQ | UK00C6 | 2024-11-13T14:14:19.300Z | 2024-11-20T14:26:00.946Z |
5530456 | 5530456 | 20241112021915_fxFQv | UK00C6 | 2024-11-13T14:14:16.652Z | 2024-11-20T14:26:00.405Z |
5530182 | 5530182 | 20241112015423_Z7n7V | UK00C6 | 2024-11-13T14:14:00.351Z | 2024-11-20T14:25:55.336Z |
5529897 | 5529897 | 20241112011841_kqTXN | UK00C6 | 2024-11-13T14:13:20.146Z | 2024-11-20T14:25:50.507Z |
5529627 | 5529627 | 20241112004507_a5B23 | UK00C6 | 2024-11-13T14:13:02.624Z | 2024-11-20T14:25:46.825Z |
5528422 | 5528422 | 20241111204538_MRfoP | UK00C6 | 2024-11-13T14:10:36.174Z | 2024-11-20T14:25:30.263Z |
5528245 | 5528245 | 20241111200349_B3fEi | UK00C6 | 2024-11-13T14:10:19.086Z | 2024-11-20T14:25:27.223Z |
5528045 | 5528045 | 20241111192108_kGuc5 | UK00C6 | 2024-11-13T14:09:44.528Z | 2024-11-20T14:25:24.570Z |
5525704 | 5525704 | 20241112061305_N2CM6 | UK00C6 | 2024-11-13T14:00:24.079Z | 2024-11-21T14:25:25.548Z |
5525691 | 5525691 | 20241112060704_TXB91 | UK00C6 | 2024-11-13T14:00:21.550Z | 2024-11-21T14:25:25.408Z |
5462912 | 5462912 | 20241102015558_YW3hi | UK00C6 | 2024-11-03T14:18:09.692Z | 2024-11-10T14:26:33.701Z |
5462819 | 5462819 | 20241102013912_ztztj | UK00C6 | 2024-11-03T14:18:06.206Z | 2024-11-10T14:26:33.427Z |
5462775 | 5462775 | 20241102012910_AgchP | UK00C6 | 2024-11-03T14:18:04.405Z | 2024-11-10T14:26:33.275Z |
5452607 | 5452607 | 20241101035123_iU596 | UK00C6 | 2024-11-02T12:19:04.821Z | 2024-11-09T14:24:32.084Z |
5452601 | 5452601 | 20241101034849_JWhxN | UK00C6 | 2024-11-02T12:19:04.432Z | 2024-11-09T14:24:31.962Z |
5452559 | 5452559 | 20241101034040_iaLCM | UK00C6 | 2024-11-02T12:19:00.425Z | 2024-11-09T14:24:31.506Z |
5452539 | 5452539 | 20241101033718_tGeu0 | UK00C6 | 2024-11-02T12:18:57.899Z | 2024-11-09T14:24:31.404Z |
5452523 | 5452523 | 20241101032951_W0ZXq | UK00C6 | 2024-11-02T12:18:55.267Z | 2024-11-09T14:24:31.335Z |
5452186 | 5452186 | 20241101022004_o9au3 | UK00C6 | 2024-11-02T12:18:24.830Z | 2024-11-09T14:24:28.732Z |
5452174 | 5452174 | 20241101021437_qoIzr | UK00C6 | 2024-11-02T12:18:23.109Z | 2024-11-09T14:24:28.596Z |
5451992 | 5451992 | 20241101014214_o2cky | UK00C6 | 2024-11-02T12:18:09.890Z | 2024-11-09T14:24:27.526Z |
5451831 | 5451831 | 20241101011241_TznCs | UK00C6 | 2024-11-02T12:18:00.193Z | 2024-11-09T14:24:25.807Z |
5440622 | 5440622 | 20241030223520_hzh43 | UK00C6 | 2024-11-01T12:15:39.633Z | 2024-11-08T14:23:10.075Z |
5432997 | 5432997 | 20241029053857_6mRdw | UK00C6 | 2024-10-31T12:21:42.430Z | 2024-11-06T14:27:29.499Z |
5431944 | 5431944 | 20241029021940_2E2zC | UK00C6 | 2024-10-31T12:20:51.712Z | 2024-11-06T14:27:25.565Z |
5431911 | 5431911 | 20241029021518_uasN5 | UK00C6 | 2024-10-31T12:20:48.466Z | 2024-11-06T14:27:25.287Z |
5410877 | 5410877 | 20241027054405_DzBhN | UK00C6 | 2024-10-29T12:18:07.641Z | 2024-11-04T14:29:05.945Z |
5408687 | 5408687 | 20241027033632_5i8Gg | UK00C6 | 2024-10-29T12:16:45.112Z | 2024-11-04T14:29:00.304Z |
5407991 | 5407991 | 20241027030058_62XJv | UK00C6 | 2024-10-29T12:15:57.179Z | 2024-11-04T14:28:58.553Z |
5407191 | 5407191 | 20241027022509_NvqtG | UK00C6 | 2024-10-29T12:15:16.314Z | 2024-11-04T14:28:57.232Z |
5406165 | 5406165 | 20241027011957_dHLCG | UK00C6 | 2024-10-29T12:13:55.100Z | 2024-11-04T14:28:55.173Z |
5406163 | 5406163 | 20241027011956_OYwy8 | UK00C6 | 2024-10-29T12:13:54.765Z | 2024-11-04T14:28:55.170Z |
5406116 | 5406116 | 20241027011737_X8fXu | UK00C6 | 2024-10-29T12:13:52.586Z | 2024-11-04T14:28:55.137Z |
5406044 | 5406044 | 20241027011257_HfAjS | UK00C6 | 2024-10-29T12:13:48.836Z | 2024-11-04T14:28:54.897Z |
5405573 | 5405573 | 20241027004554_7kUXO | UK00C6 | 2024-10-29T12:13:02.829Z | 2024-11-04T14:28:53.625Z |
5405542 | 5405542 | 20241027004239_dypN2 | UK00C6 | 2024-10-29T12:13:00.921Z | 2024-11-04T14:28:53.598Z |
5405430 | 5405430 | 20241027003316_GPrPl | UK00C6 | 2024-10-29T12:12:55.430Z | 2024-11-04T14:28:53.467Z |
5405132 | 5405132 | 20241027001501_r8A7I | UK00C6 | 2024-10-29T12:12:31.081Z | 2024-11-04T14:28:52.716Z |
5405019 | 5405019 | 20241027000921_6ZDWj | UK00C6 | 2024-10-29T12:12:17.252Z | 2024-11-04T14:28:52.593Z |
5401935 | 5401935 | 20241026181000_EOdeR | UK00C6 | 2024-10-29T12:05:52.212Z | 2024-11-04T14:28:41.076Z |
5400168 | 5400168 | 20241026054809_zM12p | UK00C6 | 2024-10-28T12:20:25.275Z | 2024-11-03T14:27:41.451Z |
5400085 | 5400085 | 20241026053722_jV2o3 | UK00C6 | 2024-10-28T12:20:21.857Z | 2024-11-03T14:27:41.269Z |
5400012 | 5400012 | 20241026052210_xBNw2 | UK00C6 | 2024-10-28T12:20:18.931Z | 2024-11-03T14:27:41.104Z |
5399794 | 5399794 | 20241026050301_Q7xhn | UK00C6 | 2024-10-28T12:20:11.247Z | 2024-11-03T14:27:40.529Z |
5398579 | 5398579 | 20241026030948_QNEmv | UK00C6 | 2024-10-28T12:19:22.822Z | 2024-11-03T14:27:36.874Z |
5398414 | 5398414 | 20241026025525_lvjcQ | UK00C6 | 2024-10-28T12:19:14.513Z | 2024-11-03T14:27:36.346Z |
5398281 | 5398281 | 20241026024056_wYzIq | UK00C6 | 2024-10-28T12:19:09.111Z | 2024-11-03T14:27:35.813Z |
5398028 | 5398028 | 20241026021849_RmeXY | UK00C6 | 2024-10-28T12:18:57.572Z | 2024-11-03T14:27:34.918Z |
5397990 | 5397990 | 20241026021322_moNS3 | UK00C6 | 2024-10-28T12:18:55.007Z | 2024-11-03T14:27:34.781Z |
5397770 | 5397770 | 20241026015553_vw3I8 | UK00C6 | 2024-10-28T12:18:40.357Z | 2024-11-03T14:27:34.117Z |
5397139 | 5397139 | 20241026010515_qeq7S | UK00C6 | 2024-10-28T12:18:09.160Z | 2024-11-03T14:27:32.078Z |
5396827 | 5396827 | 20241026003929_uEpU2 | UK00C6 | 2024-10-28T12:17:56.767Z | 2024-11-03T14:27:31.013Z |
5395851 | 5395851 | 20241025231533_RicEh | UK00C6 | 2024-10-28T12:16:59.684Z | 2024-11-03T14:27:27.305Z |
5395339 | 5395339 | 20241025223349_Q8NCm | UK00C6 | 2024-10-28T12:16:09.823Z | 2024-11-03T14:27:25.144Z |
5394685 | 5394685 | 20241025210812_fdcm4 | UK00C6 | 2024-10-28T12:15:13.624Z | 2024-11-03T14:27:22.240Z |
5374710 | 5374710 | 20241024024109_drQ9C | UK00C6 | 2024-10-26T12:20:59.615Z | 2024-11-01T12:26:59.550Z |
5374157 | 5374157 | 20241024021336_6I3B0 | UK00C6 | 2024-10-26T12:20:38.137Z | 2024-11-01T12:26:58.713Z |
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);