participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,389 rows where station_code = "CZ000H" 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 |
---|---|---|---|---|---|
5079146 | 5079146 | 20240911023443_NegD8 | CZ000H | 2024-09-15T12:16:08.248Z | 2024-09-19T12:21:41.166Z |
5078623 | 5078623 | 20240911020622_yc3mE | CZ000H | 2024-09-15T12:15:45.521Z | 2024-09-19T12:21:40.619Z |
5077009 | 5077009 | 20240911002046_uXR2x | CZ000H | 2024-09-15T12:14:17.372Z | 2024-09-19T12:21:37.960Z |
5076676 | 5076676 | 20240910235839_NDbfr | CZ000H | 2024-09-15T12:13:54.246Z | 2024-09-19T12:21:37.455Z |
5076570 | 5076570 | 20240910234731_Gc5MA | CZ000H | 2024-09-15T12:13:44.070Z | 2024-09-19T12:21:37.358Z |
5076394 | 5076394 | 20240910233142_32QoH | CZ000H | 2024-09-15T12:13:32.238Z | 2024-09-19T12:21:36.790Z |
5076080 | 5076080 | 20240910230640_rEVBJ | CZ000H | 2024-09-15T12:13:17.271Z | 2024-09-19T12:21:36.423Z |
5075981 | 5075981 | 20240910230328_13ruN | CZ000H | 2024-09-15T12:13:14.724Z | 2024-09-19T12:21:36.343Z |
5070481 | 5070481 | 20240908012306_thkOi | CZ000H | 2024-09-14T12:21:43.570Z | 2024-09-16T12:21:12.631Z |
5070195 | 5070195 | 20240910224121_hJ2FK | CZ000H | 2024-09-14T12:20:16.378Z | 2024-09-19T12:21:35.869Z |
5069876 | 5069876 | 20240910221208_D9F33 | CZ000H | 2024-09-14T12:20:08.382Z | 2024-09-19T12:21:35.383Z |
5069489 | 5069489 | 20240910214551_khx46 | CZ000H | 2024-09-14T12:19:58.202Z | 2024-09-19T12:21:34.944Z |
5069404 | 5069404 | 20240910214000_DW2Z9 | CZ000H | 2024-09-14T12:19:56.508Z | 2024-09-19T12:21:34.870Z |
5069360 | 5069360 | 20240910213555_GRt3v | CZ000H | 2024-09-14T12:19:54.794Z | 2024-09-19T12:21:34.766Z |
5069259 | 5069259 | 20240910212348_E1PAy | CZ000H | 2024-09-14T12:19:50.687Z | 2024-09-19T12:21:34.367Z |
5069175 | 5069175 | 20240910211517_OnHTg | CZ000H | 2024-09-14T12:19:47.240Z | 2024-09-19T12:21:33.776Z |
5069106 | 5069106 | 20240910210829_Ecyku | CZ000H | 2024-09-14T12:19:44.969Z | 2024-09-19T12:21:33.625Z |
5069101 | 5069101 | 20240910210828_YKbtS | CZ000H | 2024-09-14T12:19:44.858Z | 2024-09-19T12:21:33.624Z |
5063269 | 5063269 | 20240909203157_U2DAP | CZ000H | 2024-09-14T12:13:47.416Z | 2024-09-18T12:15:13.491Z |
5060652 | 5060652 | 20240910204847_Te1nB | CZ000H | 2024-09-14T12:09:17.979Z | 2024-09-19T12:21:33.401Z |
5060607 | 5060607 | 20240910204231_Iglum | CZ000H | 2024-09-14T12:09:11.330Z | 2024-09-19T12:21:33.116Z |
5060533 | 5060533 | 20240910203609_8Qr4G | CZ000H | 2024-09-14T12:08:59.079Z | 2024-09-19T12:21:32.518Z |
5060307 | 5060307 | 20240910201707_nWzqw | CZ000H | 2024-09-14T12:08:37.132Z | 2024-09-19T12:21:32.145Z |
5060210 | 5060210 | 20240910200747_ttlr1 | CZ000H | 2024-09-14T12:08:29.586Z | 2024-09-19T12:21:32.003Z |
5060133 | 5060133 | 20240910195554_wNOzM | CZ000H | 2024-09-14T12:08:16.416Z | 2024-09-19T12:21:31.844Z |
5060001 | 5060001 | 20240910192917_0nzUK | CZ000H | 2024-09-14T12:07:56.016Z | 2024-09-19T12:21:31.576Z |
5054585 | 5054585 | 20240908031432_yryQn | CZ000H | 2024-09-13T12:16:47.590Z | 2024-09-16T12:21:16.128Z |
5054557 | 5054557 | 20240908031006_ckKIx | CZ000H | 2024-09-13T12:16:46.876Z | 2024-09-16T12:21:16.052Z |
5054522 | 5054522 | 20240908030433_ogrR3 | CZ000H | 2024-09-13T12:16:45.830Z | 2024-09-16T12:21:15.880Z |
5054467 | 5054467 | 20240908025448_mpbbV | CZ000H | 2024-09-13T12:16:42.660Z | 2024-09-16T12:21:15.654Z |
5054381 | 5054381 | 20240908024456_WlLoB | CZ000H | 2024-09-13T12:16:39.780Z | 2024-09-16T12:21:15.424Z |
5054226 | 5054226 | 20240908023009_9kFik | CZ000H | 2024-09-13T12:16:34.573Z | 2024-09-16T12:21:14.590Z |
5054185 | 5054185 | 20240908022236_vrDCT | CZ000H | 2024-09-13T12:16:32.616Z | 2024-09-16T12:21:14.218Z |
5054095 | 5054095 | 20240908020906_nEfQq | CZ000H | 2024-09-13T12:16:29.454Z | 2024-09-16T12:21:13.948Z |
5054021 | 5054021 | 20240908020116_LlYm2 | CZ000H | 2024-09-13T12:16:26.720Z | 2024-09-16T12:21:13.777Z |
5054014 | 5054014 | 20240908020055_Tif1X | CZ000H | 2024-09-13T12:16:26.414Z | 2024-09-16T12:21:13.757Z |
5053929 | 5053929 | 20240908015012_qLTl2 | CZ000H | 2024-09-13T12:16:23.164Z | 2024-09-16T12:21:13.325Z |
5053924 | 5053924 | 20240908014945_oeN3b | CZ000H | 2024-09-13T12:16:23.148Z | 2024-09-16T12:21:13.322Z |
5053807 | 5053807 | 20240908013325_2i9Q2 | CZ000H | 2024-09-13T12:16:17.918Z | 2024-09-16T12:21:12.795Z |
5053791 | 5053791 | 20240908013115_qr6ca | CZ000H | 2024-09-13T12:16:17.583Z | 2024-09-16T12:21:12.776Z |
5053777 | 5053777 | 20240908012833_p1XdE | CZ000H | 2024-09-13T12:16:17.166Z | 2024-09-16T12:21:12.766Z |
5053768 | 5053768 | 20240908012724_Ehfaq | CZ000H | 2024-09-13T12:16:17.069Z | 2024-09-16T12:21:12.752Z |
5053754 | 5053754 | 20240908012355_yslM3 | CZ000H | 2024-09-13T12:16:16.898Z | 2024-09-16T12:21:12.650Z |
5053725 | 5053725 | 20240908012135_vLdKZ | CZ000H | 2024-09-13T12:16:15.416Z | 2024-09-16T12:21:12.602Z |
5053722 | 5053722 | 20240908012120_43OO2 | CZ000H | 2024-09-13T12:16:15.082Z | 2024-09-16T12:21:12.601Z |
5053709 | 5053709 | 20240908012005_blW4R | CZ000H | 2024-09-13T12:16:14.602Z | 2024-09-16T12:21:12.480Z |
5053619 | 5053619 | 20240908010718_vgIft | CZ000H | 2024-09-13T12:16:10.449Z | 2024-09-16T12:21:12.175Z |
5053611 | 5053611 | 20240908010631_XiL3i | CZ000H | 2024-09-13T12:16:10.231Z | 2024-09-16T12:21:12.167Z |
5053603 | 5053603 | 20240908010611_7T5GU | CZ000H | 2024-09-13T12:16:10.148Z | 2024-09-16T12:21:12.160Z |
5053566 | 5053566 | 20240908005653_ujlTk | CZ000H | 2024-09-13T12:16:08.617Z | 2024-09-16T12:21:11.923Z |
5053510 | 5053510 | 20240908005034_KJqYT | CZ000H | 2024-09-13T12:16:07.183Z | 2024-09-16T12:21:11.737Z |
5053495 | 5053495 | 20240908004553_Z03D9 | CZ000H | 2024-09-13T12:16:06.402Z | 2024-09-16T12:21:11.677Z |
5053453 | 5053453 | 20240908003738_31HTf | CZ000H | 2024-09-13T12:16:04.456Z | 2024-09-16T12:21:11.266Z |
5053408 | 5053408 | 20240908003111_mcooj | CZ000H | 2024-09-13T12:16:03.126Z | 2024-09-16T12:21:10.555Z |
5053304 | 5053304 | 20240908000637_KPbRh | CZ000H | 2024-09-13T12:15:57.785Z | 2024-09-16T12:21:10.295Z |
5053268 | 5053268 | 20240908000005_SSvKe | CZ000H | 2024-09-13T12:15:55.728Z | 2024-09-16T12:21:10.173Z |
5053264 | 5053264 | 20240908000005_IXKeN | CZ000H | 2024-09-13T12:15:55.653Z | 2024-09-16T12:21:10.172Z |
5053237 | 5053237 | 20240907235527_QavYz | CZ000H | 2024-09-13T12:15:54.536Z | 2024-09-16T12:21:10.051Z |
5053190 | 5053190 | 20240907234844_EI2Cp | CZ000H | 2024-09-13T12:15:52.952Z | 2024-09-16T12:21:09.975Z |
5053181 | 5053181 | 20240907234447_HxHvq | CZ000H | 2024-09-13T12:15:52.460Z | 2024-09-16T12:21:09.966Z |
5053103 | 5053103 | 20240907232644_d305Y | CZ000H | 2024-09-13T12:15:46.690Z | 2024-09-16T12:21:09.476Z |
5053085 | 5053085 | 20240907232020_vjKvZ | CZ000H | 2024-09-13T12:15:45.459Z | 2024-09-16T12:21:09.447Z |
5053053 | 5053053 | 20240907231125_Q40C9 | CZ000H | 2024-09-13T12:15:43.677Z | 2024-09-16T12:21:09.214Z |
5053048 | 5053048 | 20240907231018_9eYUg | CZ000H | 2024-09-13T12:15:43.542Z | 2024-09-16T12:21:09.182Z |
5053027 | 5053027 | 20240907230610_oTPln | CZ000H | 2024-09-13T12:15:42.383Z | 2024-09-16T12:21:09.024Z |
5053014 | 5053014 | 20240907230118_G1oDf | CZ000H | 2024-09-13T12:15:42.115Z | 2024-09-16T12:21:08.952Z |
5053005 | 5053005 | 20240907225919_9jign | CZ000H | 2024-09-13T12:15:41.701Z | 2024-09-16T12:21:08.939Z |
5052996 | 5052996 | 20240907225648_EF4lK | CZ000H | 2024-09-13T12:15:41.219Z | 2024-09-16T12:21:08.892Z |
5052957 | 5052957 | 20240907224615_bZ2Vs | CZ000H | 2024-09-13T12:15:38.581Z | 2024-09-16T12:21:08.721Z |
5052953 | 5052953 | 20240907224550_jnRS7 | CZ000H | 2024-09-13T12:15:37.933Z | 2024-09-16T12:21:08.679Z |
5052942 | 5052942 | 20240907224301_xhPC0 | CZ000H | 2024-09-13T12:15:37.302Z | 2024-09-16T12:21:08.646Z |
5052864 | 5052864 | 20240907222506_G8q2a | CZ000H | 2024-09-13T12:15:33.098Z | 2024-09-16T12:21:08.282Z |
5052846 | 5052846 | 20240907222006_XtWC2 | CZ000H | 2024-09-13T12:15:31.793Z | 2024-09-16T12:21:08.218Z |
5052825 | 5052825 | 20240907221307_n3vmH | CZ000H | 2024-09-13T12:15:30.009Z | 2024-09-16T12:21:08.101Z |
5052753 | 5052753 | 20240907215249_IUTLu | CZ000H | 2024-09-13T12:15:25.283Z | 2024-09-16T12:21:07.544Z |
5052702 | 5052702 | 20240907214014_lcgUt | CZ000H | 2024-09-13T12:15:21.738Z | 2024-09-16T12:21:07.236Z |
5052690 | 5052690 | 20240907213656_MLVtl | CZ000H | 2024-09-13T12:15:19.644Z | 2024-09-16T12:21:07.109Z |
5052578 | 5052578 | 20240907210756_KW8p5 | CZ000H | 2024-09-13T12:15:14.409Z | 2024-09-16T12:21:06.495Z |
5052576 | 5052576 | 20240907210717_3ZVJY | CZ000H | 2024-09-13T12:15:14.333Z | 2024-09-16T12:21:06.494Z |
5052573 | 5052573 | 20240907210536_7Rltg | CZ000H | 2024-09-13T12:15:14.263Z | 2024-09-16T12:21:06.491Z |
5052537 | 5052537 | 20240907210031_XGxAh | CZ000H | 2024-09-13T12:15:13.184Z | 2024-09-16T12:21:06.192Z |
5052455 | 5052455 | 20240907204552_P2mcs | CZ000H | 2024-09-13T12:15:09.677Z | 2024-09-16T12:21:05.647Z |
5052190 | 5052190 | 20240907195610_jFXKd | CZ000H | 2024-09-13T12:14:59.752Z | 2024-09-16T12:21:04.335Z |
5052094 | 5052094 | 20240907194044_N3pyF | CZ000H | 2024-09-13T12:14:56.578Z | 2024-09-16T12:21:03.715Z |
5051996 | 5051996 | 20240907192333_tva7j | CZ000H | 2024-09-13T12:14:52.289Z | 2024-09-16T12:21:02.768Z |
5051983 | 5051983 | 20240907191938_Xub69 | CZ000H | 2024-09-13T12:14:51.702Z | 2024-09-16T12:21:02.713Z |
5051981 | 5051981 | 20240907191829_UHU7E | CZ000H | 2024-09-13T12:14:51.509Z | 2024-09-16T12:21:02.703Z |
5051831 | 5051831 | 20240907184905_WI6Km | CZ000H | 2024-09-13T12:14:37.039Z | 2024-09-16T12:21:02.106Z |
5033595 | 5033595 | 20240907031445_zsxmD | CZ000H | 2024-09-12T12:09:43.628Z | 2024-09-15T12:21:30.601Z |
5033567 | 5033567 | 20240907031200_H3P5G | CZ000H | 2024-09-12T12:09:41.243Z | 2024-09-15T12:21:30.500Z |
5033564 | 5033564 | 20240907031015_13siy | CZ000H | 2024-09-12T12:09:40.864Z | 2024-09-15T12:21:30.495Z |
5033544 | 5033544 | 20240907030815_sypfA | CZ000H | 2024-09-12T12:09:38.732Z | 2024-09-15T12:21:30.462Z |
5033530 | 5033530 | 20240907030637_3zCHf | CZ000H | 2024-09-12T12:09:37.746Z | 2024-09-15T12:21:30.405Z |
5033462 | 5033462 | 20240907030042_qgiLX | CZ000H | 2024-09-12T12:09:33.290Z | 2024-09-15T12:21:30.168Z |
5033228 | 5033228 | 20240907024021_YAjCH | CZ000H | 2024-09-12T12:08:59.495Z | 2024-09-15T12:21:29.264Z |
5033097 | 5033097 | 20240907022456_U9meM | CZ000H | 2024-09-12T12:08:49.236Z | 2024-09-15T12:21:29.007Z |
5033092 | 5033092 | 20240907022417_DLMdz | CZ000H | 2024-09-12T12:08:48.913Z | 2024-09-15T12:21:29.005Z |
5033088 | 5033088 | 20240907022410_VrfJI | CZ000H | 2024-09-12T12:08:48.627Z | 2024-09-15T12:21:28.985Z |
5033042 | 5033042 | 20240907021849_cH5Uk | CZ000H | 2024-09-12T12:08:45.495Z | 2024-09-15T12:21:28.904Z |
5033037 | 5033037 | 20240907021752_QgqAL | CZ000H | 2024-09-12T12:08:45.144Z | 2024-09-15T12:21:28.900Z |
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);