participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
910 rows where station_code = "UK00C1" 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 |
---|---|---|---|---|---|
5410246 | 5410246 | 20241027050234_4umfj | UK00C1 | 2024-10-29T12:17:51.307Z | 2024-11-04T14:29:04.239Z |
5409808 | 5409808 | 20241027043623_HzM20 | UK00C1 | 2024-10-29T12:17:41.211Z | 2024-11-04T14:29:02.668Z |
5409583 | 5409583 | 20241027042713_LUPXj | UK00C1 | 2024-10-29T12:17:31.751Z | 2024-11-04T14:29:01.964Z |
5407105 | 5407105 | 20241027022230_r3dcA | UK00C1 | 2024-10-29T12:15:12.389Z | 2024-11-04T14:28:56.846Z |
5402495 | 5402495 | 20241026194509_lP9VO | UK00C1 | 2024-10-29T12:07:24.321Z | 2024-11-04T14:28:44.920Z |
5401962 | 5401962 | 20241026181210_XZPqg | UK00C1 | 2024-10-29T12:05:54.979Z | 2024-11-04T14:28:41.121Z |
5385041 | 5385041 | 20241024214028_C8CMn | UK00C1 | 2024-10-27T12:18:16.687Z | 2024-11-02T12:28:28.980Z |
5384949 | 5384949 | 20241024212057_UR2Q4 | UK00C1 | 2024-10-27T12:18:02.604Z | 2024-11-02T12:28:28.778Z |
5384926 | 5384926 | 20241024211616_W44bK | UK00C1 | 2024-10-27T12:17:58.886Z | 2024-11-02T12:28:28.703Z |
5383975 | 5383975 | 20241024192006_p1jo6 | UK00C1 | 2024-10-27T12:16:35.551Z | 2024-11-02T12:28:26.611Z |
5383447 | 5383447 | 20241024182122_ayR0A | UK00C1 | 2024-10-27T12:15:28.001Z | 2024-11-02T12:28:25.311Z |
5375987 | 5375987 | 20241024033708_wBh61 | UK00C1 | 2024-10-26T12:21:45.693Z | 2024-11-01T12:27:01.305Z |
5375057 | 5375057 | 20241024025511_ta7Eb | UK00C1 | 2024-10-26T12:21:10.874Z | 2024-11-01T12:27:00.131Z |
5374909 | 5374909 | 20241024024853_lWliO | UK00C1 | 2024-10-26T12:21:05.626Z | 2024-11-01T12:27:00.033Z |
5374805 | 5374805 | 20241024024446_2Xtlg | UK00C1 | 2024-10-26T12:21:02.386Z | 2024-11-01T12:26:59.829Z |
5374725 | 5374725 | 20241024024125_UT62c | UK00C1 | 2024-10-26T12:20:59.916Z | 2024-11-01T12:26:59.554Z |
5364636 | 5364636 | 20241023224437_1XVjR | UK00C1 | 2024-10-25T12:17:27.391Z | 2024-11-01T12:26:55.261Z |
5364311 | 5364311 | 20241023222008_HWaSf | UK00C1 | 2024-10-25T12:17:16.238Z | 2024-11-01T12:26:54.665Z |
5363059 | 5363059 | 20241023202230_3ZsRV | UK00C1 | 2024-10-25T12:15:26.383Z | 2024-11-01T12:26:52.803Z |
5354413 | 5354413 | 20241023022538_Quqcr | UK00C1 | 2024-10-24T12:20:32.158Z | 2024-10-31T12:30:05.743Z |
5354330 | 5354330 | 20241023022028_YrI92 | UK00C1 | 2024-10-24T12:20:28.290Z | 2024-10-31T12:30:05.645Z |
5354109 | 5354109 | 20241023020423_MQfXS | UK00C1 | 2024-10-24T12:20:15.739Z | 2024-10-31T12:30:05.363Z |
5353646 | 5353646 | 20241023013738_PwCOo | UK00C1 | 2024-10-24T12:19:50.209Z | 2024-10-31T12:30:04.602Z |
5352957 | 5352957 | 20241023005801_32Eg7 | UK00C1 | 2024-10-24T12:19:27.732Z | 2024-10-31T12:30:03.577Z |
5352874 | 5352874 | 20241023005358_JjYrL | UK00C1 | 2024-10-24T12:19:20.443Z | 2024-10-31T12:30:03.448Z |
5352164 | 5352164 | 20241023001557_0yRqR | UK00C1 | 2024-10-24T12:18:27.808Z | 2024-10-31T12:30:02.258Z |
5351414 | 5351414 | 20241022232626_FvPt5 | UK00C1 | 2024-10-24T12:17:30.614Z | 2024-10-31T12:30:00.313Z |
5351330 | 5351330 | 20241022231716_bwxF0 | UK00C1 | 2024-10-24T12:17:26.838Z | 2024-10-31T12:30:00.206Z |
5350955 | 5350955 | 20241022224416_BN5Tk | UK00C1 | 2024-10-24T12:16:54.948Z | 2024-10-31T12:29:59.141Z |
5350805 | 5350805 | 20241022222942_PwnI1 | UK00C1 | 2024-10-24T12:16:34.114Z | 2024-10-31T12:29:58.804Z |
5350245 | 5350245 | 20241022212932_gEOeE | UK00C1 | 2024-10-24T12:15:31.122Z | 2024-10-31T12:29:57.614Z |
5349588 | 5349588 | 20241022201530_gmvUS | UK00C1 | 2024-10-24T12:14:05.607Z | 2024-10-31T12:29:55.876Z |
5349491 | 5349491 | 20241022200435_yD3WU | UK00C1 | 2024-10-24T12:13:47.511Z | 2024-10-31T12:29:55.610Z |
5349306 | 5349306 | 20241022194114_ZWtmh | UK00C1 | 2024-10-24T12:13:26.458Z | 2024-10-31T12:29:55.023Z |
5349137 | 5349137 | 20241022192734_h22oK | UK00C1 | 2024-10-24T12:13:12.185Z | 2024-10-31T12:29:54.626Z |
5348401 | 5348401 | 20241022181438_oi2vj | UK00C1 | 2024-10-24T12:11:20.924Z | 2024-10-31T12:29:52.375Z |
5338372 | 5338372 | 20241021192259_h9d3d | UK00C1 | 2024-10-23T12:10:50.697Z | 2024-10-30T12:26:42.192Z |
5321630 | 5321630 | 20241018052705_rBSAC | UK00C1 | 2024-10-19T12:07:56.947Z | 2024-10-26T12:27:57.074Z |
5321365 | 5321365 | 20241018044101_2V2Sp | UK00C1 | 2024-10-19T12:07:15.320Z | 2024-10-26T12:27:56.564Z |
5321286 | 5321286 | 20241018042151_lkQ4G | UK00C1 | 2024-10-19T12:07:08.518Z | 2024-10-26T12:27:56.439Z |
5321173 | 5321173 | 20241018035843_HQK68 | UK00C1 | 2024-10-19T12:06:58.643Z | 2024-10-26T12:27:56.262Z |
5319653 | 5319653 | 20241017192037_Eu6Rv | UK00C1 | 2024-10-19T12:03:28.974Z | 2024-10-26T12:27:52.800Z |
5319629 | 5319629 | 20241017190136_nwGLC | UK00C1 | 2024-10-19T12:03:26.117Z | 2024-10-26T12:27:52.716Z |
5304305 | 5304305 | 20241013043426_ZhV8s | UK00C1 | 2024-10-14T12:17:47.576Z | 2024-10-21T12:24:24.715Z |
5291868 | 5291868 | 20241011220849_WQvtM | UK00C1 | 2024-10-13T12:15:22.459Z | 2024-10-20T12:24:37.128Z |
5291728 | 5291728 | 20241011214951_oWicD | UK00C1 | 2024-10-13T12:15:05.568Z | 2024-10-20T12:24:35.458Z |
5291682 | 5291682 | 20241011214156_ob3uA | UK00C1 | 2024-10-13T12:14:59.092Z | 2024-10-20T12:24:34.787Z |
5291663 | 5291663 | 20241011214025_2S0xZ | UK00C1 | 2024-10-13T12:14:57.310Z | 2024-10-20T12:24:34.423Z |
5282527 | 5282527 | 20241010220900_ENxIN | UK00C1 | 2024-10-12T12:15:41.619Z | 2024-10-19T12:27:44.551Z |
5282437 | 5282437 | 20241010214818_oJNBA | UK00C1 | 2024-10-12T12:15:32.980Z | 2024-10-19T12:27:43.781Z |
5282106 | 5282106 | 20241010201515_XHQRs | UK00C1 | 2024-10-12T12:15:12.190Z | 2024-10-19T12:27:40.887Z |
5276803 | 5276803 | 20241011050943_mnkjW | UK00C1 | 2024-10-12T12:01:43.469Z | 2024-10-20T12:23:14.013Z |
5276668 | 5276668 | 20241011045509_6zehK | UK00C1 | 2024-10-12T12:01:28.749Z | 2024-10-20T12:23:12.609Z |
5247781 | 5247781 | 20241007031745_TnM6y | UK00C1 | 2024-10-08T12:00:39.318Z | 2024-10-16T12:20:56.935Z |
5247728 | 5247728 | 20241007031243_L2FUU | UK00C1 | 2024-10-08T12:00:32.365Z | 2024-10-16T12:20:56.547Z |
5239341 | 5239341 | 20241005035131_1Gb3D | UK00C1 | 2024-10-07T12:06:17.544Z | 2024-10-14T12:24:19.060Z |
5239185 | 5239185 | 20241005033640_mGjoD | UK00C1 | 2024-10-07T12:06:04.554Z | 2024-10-14T12:24:18.627Z |
5227818 | 5227818 | 20241004014837_BCTt2 | UK00C1 | 2024-10-05T12:21:40.408Z | 2024-10-12T12:25:13.040Z |
5227074 | 5227074 | 20241004010026_2S3nH | UK00C1 | 2024-10-05T12:21:12.059Z | 2024-10-12T12:25:12.416Z |
5226332 | 5226332 | 20241004000633_1VoD5 | UK00C1 | 2024-10-05T12:20:37.668Z | 2024-10-12T12:25:11.606Z |
5225852 | 5225852 | 20241003232243_EQb6r | UK00C1 | 2024-10-05T12:20:13.578Z | 2024-10-12T12:25:10.934Z |
5225747 | 5225747 | 20241003231547_CnopA | UK00C1 | 2024-10-05T12:20:07.142Z | 2024-10-12T12:25:10.722Z |
5225582 | 5225582 | 20241003225713_sit27 | UK00C1 | 2024-10-05T12:19:55.924Z | 2024-10-12T12:25:10.432Z |
5223665 | 5223665 | 20241003191649_pRAwL | UK00C1 | 2024-10-05T12:17:24.258Z | 2024-10-12T12:25:06.888Z |
5223532 | 5223532 | 20241003185700_LNKYJ | UK00C1 | 2024-10-05T12:17:12.984Z | 2024-10-12T12:25:06.427Z |
5218615 | 5218615 | 20241004035459_2U8jg | UK00C1 | 2024-10-05T12:04:47.953Z | 2024-10-13T12:26:08.761Z |
5218500 | 5218500 | 20241004034459_TSqFY | UK00C1 | 2024-10-05T12:04:29.714Z | 2024-10-13T12:26:08.657Z |
5218409 | 5218409 | 20241004033712_3tjIa | UK00C1 | 2024-10-05T12:04:17.373Z | 2024-10-13T12:26:08.457Z |
5216848 | 5216848 | 20241003013056_QKvwO | UK00C1 | 2024-10-04T12:13:51.234Z | 2024-10-11T12:23:37.823Z |
5216760 | 5216760 | 20241003012301_jgE3G | UK00C1 | 2024-10-04T12:13:46.359Z | 2024-10-11T12:23:37.749Z |
5214466 | 5214466 | 20241002214340_AwzwT | UK00C1 | 2024-10-04T12:10:20.693Z | 2024-10-11T12:23:33.659Z |
5214100 | 5214100 | 20241002205135_nqd8y | UK00C1 | 2024-10-04T12:09:40.651Z | 2024-10-11T12:23:32.766Z |
5213664 | 5213664 | 20241002193508_qFUtE | UK00C1 | 2024-10-04T12:08:48.278Z | 2024-10-11T12:23:31.587Z |
5213041 | 5213041 | 20241003033908_Sjzwl | UK00C1 | 2024-10-04T12:04:17.846Z | 2024-10-12T12:24:55.368Z |
5206252 | 5206252 | 20241002030009_C05DF | UK00C1 | 2024-10-03T12:01:35.860Z | 2024-10-11T12:23:21.662Z |
5206213 | 5206213 | 20241002025015_ejv4P | UK00C1 | 2024-10-03T12:01:28.441Z | 2024-10-11T12:23:21.561Z |
5191892 | 5191892 | 20240928210816_Gw2Qj | UK00C1 | 2024-09-30T12:18:13.740Z | 2024-10-06T12:28:24.436Z |
5186628 | 5186628 | 20240929043653_XOUf3 | UK00C1 | 2024-09-30T12:07:25.094Z | 2024-10-07T12:21:21.060Z |
5186613 | 5186613 | 20240929043528_Nchlc | UK00C1 | 2024-09-30T12:07:23.282Z | 2024-10-07T12:21:20.995Z |
5186507 | 5186507 | 20240929041402_e9esX | UK00C1 | 2024-09-30T12:07:03.059Z | 2024-10-07T12:21:20.755Z |
5186259 | 5186259 | 20240929034201_xI89b | UK00C1 | 2024-09-30T12:06:30.442Z | 2024-10-07T12:21:20.075Z |
5185958 | 5185958 | 20240929031055_Snojr | UK00C1 | 2024-09-30T12:05:38.871Z | 2024-10-07T12:21:19.308Z |
5185880 | 5185880 | 20240929030643_Vp4t8 | UK00C1 | 2024-09-30T12:05:23.967Z | 2024-10-07T12:21:19.192Z |
5185429 | 5185429 | 20240929022236_4Ozy4 | UK00C1 | 2024-09-30T12:04:13.511Z | 2024-10-07T12:21:17.671Z |
5183976 | 5183976 | 20240929000402_SnIcx | UK00C1 | 2024-09-30T12:00:21.051Z | 2024-10-07T12:21:14.039Z |
5182823 | 5182823 | 20240927232038_8bUXj | UK00C1 | 2024-09-29T12:16:17.928Z | 2024-10-05T12:29:09.136Z |
5180769 | 5180769 | 20240927192142_q2mWZ | UK00C1 | 2024-09-29T12:14:16.117Z | 2024-10-05T12:29:01.820Z |
5180651 | 5180651 | 20240927190549_6tTyp | UK00C1 | 2024-09-29T12:14:09.790Z | 2024-10-05T12:29:00.695Z |
5178649 | 5178649 | 20240928030922_0XExq | UK00C1 | 2024-09-29T12:06:41.454Z | 2024-10-06T12:28:00.400Z |
5178351 | 5178351 | 20240928024758_Xr2fk | UK00C1 | 2024-09-29T12:06:10.493Z | 2024-10-06T12:27:59.252Z |
5178036 | 5178036 | 20240928022803_XPj74 | UK00C1 | 2024-09-29T12:05:36.503Z | 2024-10-06T12:27:57.842Z |
5178007 | 5178007 | 20240928022618_CLK5d | UK00C1 | 2024-09-29T12:05:35.216Z | 2024-10-06T12:27:57.829Z |
5177927 | 5177927 | 20240928021936_eSnpT | UK00C1 | 2024-09-29T12:05:21.431Z | 2024-10-06T12:27:56.734Z |
5177304 | 5177304 | 20240928013315_nxujU | UK00C1 | 2024-09-29T12:04:07.628Z | 2024-10-06T12:27:54.881Z |
5177190 | 5177190 | 20240928012333_PHEEh | UK00C1 | 2024-09-29T12:03:57.894Z | 2024-10-06T12:27:54.427Z |
5176634 | 5176634 | 20240928004707_1Pg7q | UK00C1 | 2024-09-29T12:02:41.337Z | 2024-10-06T12:27:51.849Z |
5176183 | 5176183 | 20240928001555_yIyVG | UK00C1 | 2024-09-29T12:01:46.415Z | 2024-10-06T12:27:50.474Z |
5176064 | 5176064 | 20240928000951_Ap7Ch | UK00C1 | 2024-09-29T12:01:25.651Z | 2024-10-06T12:27:50.124Z |
5175689 | 5175689 | 20240927234158_YKr73 | UK00C1 | 2024-09-29T12:00:36.753Z | 2024-10-06T12:27:48.320Z |
5168816 | 5168816 | 20240925215758_XJqOY | UK00C1 | 2024-09-27T12:10:43.236Z | 2024-10-03T12:25:35.601Z |
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);