participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,735 rows where station_code = "CZ0003" 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 |
---|---|---|---|---|---|
5583092 | 5583092 | 20241120180846_6aztH | CZ0003 | 2024-11-23T14:22:58.899Z | 2024-11-23T14:22:58.899Z |
5476243 | 5476243 | 20241103225205_ZVhl7 | CZ0003 | 2024-11-05T14:14:58.101Z | 2024-11-12T14:28:04.324Z |
5476166 | 5476166 | 20241103223659_QrN1B | CZ0003 | 2024-11-05T14:14:49.429Z | 2024-11-12T14:28:03.599Z |
5476045 | 5476045 | 20241103221236_qa8dS | CZ0003 | 2024-11-05T14:14:41.392Z | 2024-11-12T14:28:02.489Z |
5475971 | 5475971 | 20241103220251_zWTsF | CZ0003 | 2024-11-05T14:14:36.683Z | 2024-11-12T14:28:01.963Z |
5475882 | 5475882 | 20241103214505_A4lV2 | CZ0003 | 2024-11-05T14:14:29.754Z | 2024-11-12T14:28:01.732Z |
5475820 | 5475820 | 20241103213043_7Hg6Q | CZ0003 | 2024-11-05T14:14:18.728Z | 2024-11-12T14:28:01.158Z |
5475697 | 5475697 | 20241103210430_ZcThT | CZ0003 | 2024-11-05T14:14:01.875Z | 2024-11-12T14:28:00.560Z |
5468610 | 5468610 | 20241103010734_1fVWA | CZ0003 | 2024-11-04T14:14:35.628Z | 2024-11-11T14:22:54.149Z |
5468543 | 5468543 | 20241103005409_qWTTt | CZ0003 | 2024-11-04T14:14:23.766Z | 2024-11-11T14:22:54.048Z |
5468518 | 5468518 | 20241103005118_l9c50 | CZ0003 | 2024-11-04T14:14:18.376Z | 2024-11-11T14:22:53.963Z |
5468366 | 5468366 | 20241103002008_B8t3D | CZ0003 | 2024-11-04T14:14:01.164Z | 2024-11-11T14:22:52.889Z |
5468307 | 5468307 | 20241103000915_xNGvw | CZ0003 | 2024-11-04T14:13:55.982Z | 2024-11-11T14:22:52.636Z |
5468233 | 5468233 | 20241102235459_Pm4nW | CZ0003 | 2024-11-04T14:13:48.169Z | 2024-11-11T14:22:52.281Z |
5468138 | 5468138 | 20241102233710_DUwhk | CZ0003 | 2024-11-04T14:13:21.641Z | 2024-11-11T14:22:51.556Z |
5467844 | 5467844 | 20241102224632_JhvIm | CZ0003 | 2024-11-04T14:12:38.869Z | 2024-11-11T14:22:50.019Z |
5467740 | 5467740 | 20241102222906_3N9gJ | CZ0003 | 2024-11-04T14:12:26.695Z | 2024-11-11T14:22:49.234Z |
5467686 | 5467686 | 20241102221657_2dwfv | CZ0003 | 2024-11-04T14:12:21.186Z | 2024-11-11T14:22:48.931Z |
5466290 | 5466290 | 20241102170540_HC4Zc | CZ0003 | 2024-11-04T14:08:33.522Z | 2024-11-11T14:22:40.127Z |
5451145 | 5451145 | 20241031225140_1Cck1 | CZ0003 | 2024-11-02T12:16:39.158Z | 2024-11-09T14:24:21.815Z |
5450986 | 5450986 | 20241031221242_yQepM | CZ0003 | 2024-11-02T12:16:27.771Z | 2024-11-09T14:24:20.446Z |
5450914 | 5450914 | 20241031213927_T2Sgg | CZ0003 | 2024-11-02T12:16:15.931Z | 2024-11-09T14:24:19.917Z |
5430410 | 5430410 | 20241028222900_INA2w | CZ0003 | 2024-10-31T12:18:20.177Z | 2024-11-06T14:27:19.795Z |
5430351 | 5430351 | 20241028221444_zGI1y | CZ0003 | 2024-10-31T12:18:11.206Z | 2024-11-06T14:27:19.562Z |
5430208 | 5430208 | 20241028213559_605wQ | CZ0003 | 2024-10-31T12:17:52.877Z | 2024-11-06T14:27:19.337Z |
5430102 | 5430102 | 20241028210734_u0Rs5 | CZ0003 | 2024-10-31T12:17:39.102Z | 2024-11-06T14:27:18.843Z |
5386931 | 5386931 | 20241025014147_d5l6b | CZ0003 | 2024-10-27T12:20:40.902Z | 2024-11-02T12:28:31.719Z |
5386914 | 5386914 | 20241025014041_HemmB | CZ0003 | 2024-10-27T12:20:39.765Z | 2024-11-02T12:28:31.694Z |
5386876 | 5386876 | 20241025013711_5XiKt | CZ0003 | 2024-10-27T12:20:37.606Z | 2024-11-02T12:28:31.677Z |
5386264 | 5386264 | 20241025001944_xSVry | CZ0003 | 2024-10-27T12:19:57.727Z | 2024-11-02T12:28:30.907Z |
5385207 | 5385207 | 20241024220753_Qibih | CZ0003 | 2024-10-27T12:18:34.214Z | 2024-11-02T12:28:29.277Z |
5385143 | 5385143 | 20241024215640_x2oRt | CZ0003 | 2024-10-27T12:18:28.508Z | 2024-11-02T12:28:29.209Z |
5385010 | 5385010 | 20241024213644_71RYY | CZ0003 | 2024-10-27T12:18:12.778Z | 2024-11-02T12:28:28.926Z |
5384801 | 5384801 | 20241024205700_g6rEI | CZ0003 | 2024-10-27T12:17:43.386Z | 2024-11-02T12:28:27.736Z |
5384772 | 5384772 | 20241024205100_Ck01i | CZ0003 | 2024-10-27T12:17:39.348Z | 2024-11-02T12:28:27.707Z |
5316915 | 5316915 | 20241016020049_8583k | CZ0003 | 2024-10-17T12:07:21.865Z | 2024-10-24T12:27:58.367Z |
5316890 | 5316890 | 20241016015024_6G2tY | CZ0003 | 2024-10-17T12:07:17.638Z | 2024-10-24T12:27:58.242Z |
5316820 | 5316820 | 20241016011439_5wglg | CZ0003 | 2024-10-17T12:07:10.221Z | 2024-10-24T12:27:57.950Z |
5316798 | 5316798 | 20241016010317_SoN8f | CZ0003 | 2024-10-17T12:07:07.861Z | 2024-10-24T12:27:57.887Z |
5316776 | 5316776 | 20241016005938_HQ1iS | CZ0003 | 2024-10-17T12:07:05.810Z | 2024-10-24T12:27:57.871Z |
5316772 | 5316772 | 20241016005856_bdUHV | CZ0003 | 2024-10-17T12:07:05.649Z | 2024-10-24T12:27:57.868Z |
5316765 | 5316765 | 20241016005645_g3AK2 | CZ0003 | 2024-10-17T12:07:05.304Z | 2024-10-24T12:27:57.861Z |
5316699 | 5316699 | 20241016003516_D6tII | CZ0003 | 2024-10-17T12:07:00.719Z | 2024-10-24T12:27:57.727Z |
5316673 | 5316673 | 20241016002415_dWV49 | CZ0003 | 2024-10-17T12:06:57.599Z | 2024-10-24T12:27:57.227Z |
5316581 | 5316581 | 20241015233227_FVJIa | CZ0003 | 2024-10-17T12:06:51.668Z | 2024-10-24T12:27:56.997Z |
5316542 | 5316542 | 20241015230905_3Ldr7 | CZ0003 | 2024-10-17T12:06:48.570Z | 2024-10-24T12:27:56.779Z |
5316533 | 5316533 | 20241015225651_mNM6z | CZ0003 | 2024-10-17T12:06:47.832Z | 2024-10-24T12:27:56.742Z |
5313376 | 5313376 | 20241012000142_Gjj21 | CZ0003 | 2024-10-16T12:18:02.671Z | 2024-10-20T12:24:48.640Z |
5294171 | 5294171 | 20241012031548_1ZRAn | CZ0003 | 2024-10-13T12:18:21.943Z | 2024-10-20T12:25:08.701Z |
5294081 | 5294081 | 20241012025823_Tbhno | CZ0003 | 2024-10-13T12:18:14.599Z | 2024-10-20T12:25:07.099Z |
5294054 | 5294054 | 20241012025440_PigVr | CZ0003 | 2024-10-13T12:18:12.959Z | 2024-10-20T12:25:06.684Z |
5294000 | 5294000 | 20241012024740_3zF56 | CZ0003 | 2024-10-13T12:18:07.141Z | 2024-10-20T12:25:05.974Z |
5293906 | 5293906 | 20241012023733_1tJ9a | CZ0003 | 2024-10-13T12:18:00.539Z | 2024-10-20T12:25:05.129Z |
5293869 | 5293869 | 20241012023034_Ub7kX | CZ0003 | 2024-10-13T12:17:57.419Z | 2024-10-20T12:25:04.776Z |
5293865 | 5293865 | 20241012023015_i7RBC | CZ0003 | 2024-10-13T12:17:57.367Z | 2024-10-20T12:25:04.770Z |
5293681 | 5293681 | 20241012020601_QkDRS | CZ0003 | 2024-10-13T12:17:45.731Z | 2024-10-20T12:25:03.043Z |
5293616 | 5293616 | 20241012015902_048G8 | CZ0003 | 2024-10-13T12:17:41.904Z | 2024-10-20T12:25:02.553Z |
5293571 | 5293571 | 20241012015247_gz0HX | CZ0003 | 2024-10-13T12:17:38.961Z | 2024-10-20T12:25:02.138Z |
5293453 | 5293453 | 20241012013544_xNGg8 | CZ0003 | 2024-10-13T12:17:29.652Z | 2024-10-20T12:24:59.957Z |
5293445 | 5293445 | 20241012013446_3giko | CZ0003 | 2024-10-13T12:17:29.198Z | 2024-10-20T12:24:59.914Z |
5293361 | 5293361 | 20241012012436_CmhjW | CZ0003 | 2024-10-13T12:17:22.786Z | 2024-10-20T12:24:58.519Z |
5293295 | 5293295 | 20241012011525_3yMeV | CZ0003 | 2024-10-13T12:17:18.244Z | 2024-10-20T12:24:57.381Z |
5293292 | 5293292 | 20241012011515_hTZJY | CZ0003 | 2024-10-13T12:17:17.985Z | 2024-10-20T12:24:57.361Z |
5293010 | 5293010 | 20241012004420_2VMVc | CZ0003 | 2024-10-13T12:16:53.805Z | 2024-10-20T12:24:54.452Z |
5292951 | 5292951 | 20241012003819_Ok2li | CZ0003 | 2024-10-13T12:16:48.531Z | 2024-10-20T12:24:53.757Z |
5292939 | 5292939 | 20241012003640_gNX5k | CZ0003 | 2024-10-13T12:16:47.611Z | 2024-10-20T12:24:53.627Z |
5292521 | 5292521 | 20241011234358_6IIVw | CZ0003 | 2024-10-13T12:16:06.179Z | 2024-10-20T12:24:47.113Z |
5292238 | 5292238 | 20241011225524_oP6ws | CZ0003 | 2024-10-13T12:15:49.310Z | 2024-10-20T12:24:43.056Z |
5292226 | 5292226 | 20241011225243_K7IMF | CZ0003 | 2024-10-13T12:15:48.356Z | 2024-10-20T12:24:42.570Z |
5292001 | 5292001 | 20241011222632_lVsEd | CZ0003 | 2024-10-13T12:15:37.614Z | 2024-10-20T12:24:38.910Z |
5275187 | 5275187 | 20241010012614_v2Pzy | CZ0003 | 2024-10-11T12:15:27.100Z | 2024-10-18T12:22:14.450Z |
5274812 | 5274812 | 20241009233936_y24wX | CZ0003 | 2024-10-11T12:14:53.377Z | 2024-10-18T12:22:11.704Z |
5274805 | 5274805 | 20241009233855_g0ygf | CZ0003 | 2024-10-11T12:14:52.985Z | 2024-10-18T12:22:11.678Z |
5274750 | 5274750 | 20241009231912_dY1YH | CZ0003 | 2024-10-11T12:14:49.915Z | 2024-10-18T12:22:11.300Z |
5274737 | 5274737 | 20241009231307_CCGQ8 | CZ0003 | 2024-10-11T12:14:48.920Z | 2024-10-18T12:22:11.265Z |
5274682 | 5274682 | 20241009225219_2yvZ5 | CZ0003 | 2024-10-11T12:14:46.061Z | 2024-10-18T12:22:10.776Z |
5262622 | 5262622 | 20241008015853_Zd6zI | CZ0003 | 2024-10-09T12:16:00.851Z | 2024-10-16T12:21:19.336Z |
5262003 | 5262003 | 20241007233336_IpTZi | CZ0003 | 2024-10-09T12:15:00.381Z | 2024-10-16T12:21:17.040Z |
5261984 | 5261984 | 20241007232907_MwdGD | CZ0003 | 2024-10-09T12:14:59.143Z | 2024-10-16T12:21:17.009Z |
5261972 | 5261972 | 20241007232644_8GGgY | CZ0003 | 2024-10-09T12:14:57.916Z | 2024-10-16T12:21:16.978Z |
5261938 | 5261938 | 20241007231308_bGxn2 | CZ0003 | 2024-10-09T12:14:54.820Z | 2024-10-16T12:21:16.876Z |
5254247 | 5254247 | 20241007015127_eNij9 | CZ0003 | 2024-10-08T12:14:13.060Z | 2024-10-15T12:29:14.229Z |
5254188 | 5254188 | 20241007014642_BX5ol | CZ0003 | 2024-10-08T12:14:09.536Z | 2024-10-15T12:29:13.331Z |
5254185 | 5254185 | 20241007014641_wEERZ | CZ0003 | 2024-10-08T12:14:09.456Z | 2024-10-15T12:29:13.331Z |
5254165 | 5254165 | 20241007014500_Y27HF | CZ0003 | 2024-10-08T12:14:08.230Z | 2024-10-15T12:29:13.141Z |
5254057 | 5254057 | 20241007012415_utYxv | CZ0003 | 2024-10-08T12:14:01.999Z | 2024-10-15T12:29:12.737Z |
5253898 | 5253898 | 20241007010251_udeB2 | CZ0003 | 2024-10-08T12:13:50.712Z | 2024-10-15T12:29:12.077Z |
5253804 | 5253804 | 20241007004707_ZZmnZ | CZ0003 | 2024-10-08T12:13:42.471Z | 2024-10-15T12:29:11.087Z |
5253469 | 5253469 | 20241007000320_A1xES | CZ0003 | 2024-10-08T12:13:16.271Z | 2024-10-15T12:29:09.438Z |
5253459 | 5253459 | 20241006235900_na7Wu | CZ0003 | 2024-10-08T12:13:15.962Z | 2024-10-15T12:29:09.425Z |
5253421 | 5253421 | 20241006235307_ZhFH2 | CZ0003 | 2024-10-08T12:13:14.654Z | 2024-10-15T12:29:09.203Z |
5253344 | 5253344 | 20241006233829_IfdNu | CZ0003 | 2024-10-08T12:13:09.104Z | 2024-10-15T12:29:08.928Z |
5253297 | 5253297 | 20241006233039_Ia3M2 | CZ0003 | 2024-10-08T12:13:06.445Z | 2024-10-15T12:29:08.660Z |
5253214 | 5253214 | 20241006231023_s357K | CZ0003 | 2024-10-08T12:13:02.208Z | 2024-10-15T12:29:07.943Z |
5253061 | 5253061 | 20241006223701_whBWL | CZ0003 | 2024-10-08T12:12:55.110Z | 2024-10-15T12:29:06.743Z |
5253043 | 5253043 | 20241006223200_B3rCA | CZ0003 | 2024-10-08T12:12:53.896Z | 2024-10-15T12:29:06.542Z |
5253019 | 5253019 | 20241006222911_8p2sC | CZ0003 | 2024-10-08T12:12:52.593Z | 2024-10-15T12:29:06.393Z |
5252994 | 5252994 | 20241006222228_RLyLt | CZ0003 | 2024-10-08T12:12:51.005Z | 2024-10-15T12:29:06.283Z |
5252658 | 5252658 | 20241006205626_M1xMT | CZ0003 | 2024-10-08T12:12:12.399Z | 2024-10-15T12:29:02.435Z |
5252139 | 5252139 | 20241006174202_LHVdX | CZ0003 | 2024-10-08T12:11:03.234Z | 2024-10-15T12:28:56.880Z |
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);