participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
955 rows where station_code = "CZ000P" 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 |
---|---|---|---|---|---|
5483388 | 5483388 | 20241105003510_PDmsZ | CZ000P | 2024-11-06T14:15:09.808Z | 2024-11-09T14:21:05.135Z |
5483176 | 5483176 | 20241105000722_iYpO5 | CZ000P | 2024-11-06T14:14:44.544Z | 2024-11-09T14:21:03.971Z |
5482612 | 5482612 | 20241104224840_ek0Cm | CZ000P | 2024-11-06T14:13:26.568Z | 2024-11-09T14:21:00.551Z |
5482422 | 5482422 | 20241104220958_evH75 | CZ000P | 2024-11-06T14:13:09.563Z | 2024-11-09T14:20:59.165Z |
5482383 | 5482383 | 20241104220238_Nnhwb | CZ000P | 2024-11-06T14:13:06.819Z | 2024-11-09T14:20:58.836Z |
5482277 | 5482277 | 20241104214232_Jkw36 | CZ000P | 2024-11-06T14:12:47.494Z | 2024-11-09T14:20:57.578Z |
5478588 | 5478588 | 20241104043546_x9tt6 | CZ000P | 2024-11-05T14:18:32.777Z | 2024-11-09T14:22:30.007Z |
5478520 | 5478520 | 20241104042400_M01Ap | CZ000P | 2024-11-05T14:18:27.840Z | 2024-11-09T14:22:28.888Z |
5478273 | 5478273 | 20241104034504_pRCfo | CZ000P | 2024-11-05T14:18:08.499Z | 2024-11-09T14:22:26.479Z |
5477900 | 5477900 | 20241104025216_WfIh6 | CZ000P | 2024-11-05T14:17:35.472Z | 2024-11-09T14:22:22.775Z |
5477704 | 5477704 | 20241104022321_2r3ai | CZ000P | 2024-11-05T14:17:16.457Z | 2024-11-09T14:22:21.056Z |
5477472 | 5477472 | 20241104020021_iEvBe | CZ000P | 2024-11-05T14:16:56.121Z | 2024-11-09T14:22:18.145Z |
5476910 | 5476910 | 20241104004039_Cg2ny | CZ000P | 2024-11-05T14:16:11.764Z | 2024-11-09T14:22:13.271Z |
5476881 | 5476881 | 20241104003745_RJmnR | CZ000P | 2024-11-05T14:16:09.810Z | 2024-11-09T14:22:13.014Z |
5476852 | 5476852 | 20241104003412_VC1S5 | CZ000P | 2024-11-05T14:16:07.785Z | 2024-11-09T14:22:12.738Z |
5476505 | 5476505 | 20241103233618_Koxm1 | CZ000P | 2024-11-05T14:15:32.076Z | 2024-11-09T14:22:10.189Z |
5476416 | 5476416 | 20241103232223_4q22M | CZ000P | 2024-11-05T14:15:18.842Z | 2024-11-09T14:22:09.281Z |
5476399 | 5476399 | 20241103232039_LVW7v | CZ000P | 2024-11-05T14:15:15.394Z | 2024-11-09T14:22:09.112Z |
5475839 | 5475839 | 20241103213153_nNTw1 | CZ000P | 2024-11-05T14:14:21.435Z | 2024-11-09T14:22:02.793Z |
5475709 | 5475709 | 20241103210849_3NkNs | CZ000P | 2024-11-05T14:14:02.596Z | 2024-11-09T14:22:01.310Z |
5475630 | 5475630 | 20241103205212_H0z1y | CZ000P | 2024-11-05T14:13:54.766Z | 2024-11-09T14:22:00.626Z |
5475599 | 5475599 | 20241103204720_TwetH | CZ000P | 2024-11-05T14:13:52.061Z | 2024-11-09T14:22:00.456Z |
5475328 | 5475328 | 20241103194802_g7xYt | CZ000P | 2024-11-05T14:13:10.067Z | 2024-11-09T14:21:57.317Z |
5475099 | 5475099 | 20241103190450_XfjIo | CZ000P | 2024-11-05T14:12:31.318Z | 2024-11-09T14:21:55.812Z |
5475090 | 5475090 | 20241103190400_vIqoV | CZ000P | 2024-11-05T14:12:30.698Z | 2024-11-09T14:21:55.737Z |
5474802 | 5474802 | 20241103181845_9j86J | CZ000P | 2024-11-05T14:12:03.741Z | 2024-11-09T14:21:52.539Z |
5474725 | 5474725 | 20241103180640_YKzxF | CZ000P | 2024-11-05T14:11:44.343Z | 2024-11-09T14:21:51.057Z |
5474658 | 5474658 | 20241103175559_rRMm5 | CZ000P | 2024-11-05T14:11:30.513Z | 2024-11-09T14:21:50.100Z |
5469588 | 5469588 | 20241103034847_UOf5G | CZ000P | 2024-11-04T14:16:39.052Z | 2024-11-09T14:23:03.145Z |
5469569 | 5469569 | 20241103034514_a8fC4 | CZ000P | 2024-11-04T14:16:36.692Z | 2024-11-09T14:23:03.076Z |
5469560 | 5469560 | 20241103034347_qCNKx | CZ000P | 2024-11-04T14:16:36.278Z | 2024-11-09T14:23:03.030Z |
5469517 | 5469517 | 20241103033906_v0xIt | CZ000P | 2024-11-04T14:16:33.489Z | 2024-11-09T14:23:02.880Z |
5469398 | 5469398 | 20241103032146_BRXHJ | CZ000P | 2024-11-04T14:16:23.986Z | 2024-11-09T14:23:02.419Z |
5469052 | 5469052 | 20241103022851_DoKUG | CZ000P | 2024-11-04T14:15:29.547Z | 2024-11-09T14:23:00.829Z |
5468882 | 5468882 | 20241103020432_HGvhq | CZ000P | 2024-11-04T14:15:11.308Z | 2024-11-09T14:23:00.156Z |
5468809 | 5468809 | 20241103015121_nndEk | CZ000P | 2024-11-04T14:15:05.186Z | 2024-11-09T14:22:59.741Z |
5468574 | 5468574 | 20241103010125_ppsoo | CZ000P | 2024-11-04T14:14:28.488Z | 2024-11-09T14:22:58.784Z |
5468471 | 5468471 | 20241103004211_Xlf5k | CZ000P | 2024-11-04T14:14:10.161Z | 2024-11-09T14:22:58.503Z |
5468465 | 5468465 | 20241103004148_zUBZU | CZ000P | 2024-11-04T14:14:09.812Z | 2024-11-09T14:22:58.463Z |
5468435 | 5468435 | 20241103003538_XKky9 | CZ000P | 2024-11-04T14:14:07.149Z | 2024-11-09T14:22:58.396Z |
5468426 | 5468426 | 20241103003332_FRZvG | CZ000P | 2024-11-04T14:14:05.593Z | 2024-11-09T14:22:58.334Z |
5468394 | 5468394 | 20241103002652_mCf5v | CZ000P | 2024-11-04T14:14:02.976Z | 2024-11-09T14:22:58.164Z |
5468387 | 5468387 | 20241103002408_0QwuU | CZ000P | 2024-11-04T14:14:02.556Z | 2024-11-09T14:22:58.147Z |
5468344 | 5468344 | 20241103001524_kzgxW | CZ000P | 2024-11-04T14:13:58.970Z | 2024-11-09T14:22:58.046Z |
5468287 | 5468287 | 20241103000318_pslXv | CZ000P | 2024-11-04T14:13:53.229Z | 2024-11-09T14:22:57.846Z |
5468268 | 5468268 | 20241103000042_ggAfk | CZ000P | 2024-11-04T14:13:51.435Z | 2024-11-09T14:22:57.778Z |
5468242 | 5468242 | 20241102235519_8KPTm | CZ000P | 2024-11-04T14:13:48.922Z | 2024-11-09T14:22:57.607Z |
5468190 | 5468190 | 20241102234740_R3G2l | CZ000P | 2024-11-04T14:13:38.876Z | 2024-11-09T14:22:57.421Z |
5468161 | 5468161 | 20241102234223_gGGBk | CZ000P | 2024-11-04T14:13:27.558Z | 2024-11-09T14:22:57.331Z |
5468137 | 5468137 | 20241102233650_qGi1f | CZ000P | 2024-11-04T14:13:21.212Z | 2024-11-09T14:22:57.256Z |
5468128 | 5468128 | 20241102233520_bxnNk | CZ000P | 2024-11-04T14:13:19.543Z | 2024-11-09T14:22:57.233Z |
5468104 | 5468104 | 20241102232846_cSQUY | CZ000P | 2024-11-04T14:13:17.048Z | 2024-11-09T14:22:57.119Z |
5468024 | 5468024 | 20241102231711_hHjnM | CZ000P | 2024-11-04T14:13:08.484Z | 2024-11-09T14:22:56.525Z |
5467953 | 5467953 | 20241102230130_V9jHd | CZ000P | 2024-11-04T14:13:01.365Z | 2024-11-09T14:22:56.157Z |
5467921 | 5467921 | 20241102225639_rbz4f | CZ000P | 2024-11-04T14:12:57.645Z | 2024-11-09T14:22:56.059Z |
5467898 | 5467898 | 20241102225157_Kq5eQ | CZ000P | 2024-11-04T14:12:55.695Z | 2024-11-09T14:22:55.916Z |
5467855 | 5467855 | 20241102224709_kfj2j | CZ000P | 2024-11-04T14:12:41.628Z | 2024-11-09T14:22:55.802Z |
5467847 | 5467847 | 20241102224642_JqBPy | CZ000P | 2024-11-04T14:12:39.199Z | 2024-11-09T14:22:55.788Z |
5467798 | 5467798 | 20241102223811_aPIJk | CZ000P | 2024-11-04T14:12:32.429Z | 2024-11-09T14:22:55.669Z |
5467700 | 5467700 | 20241102222026_3nIHn | CZ000P | 2024-11-04T14:12:22.427Z | 2024-11-09T14:22:55.407Z |
5467689 | 5467689 | 20241102221701_fK73z | CZ000P | 2024-11-04T14:12:21.477Z | 2024-11-09T14:22:55.397Z |
5467578 | 5467578 | 20241102215835_FZNye | CZ000P | 2024-11-04T14:12:05.755Z | 2024-11-09T14:22:55.089Z |
5467546 | 5467546 | 20241102214320_1JPG3 | CZ000P | 2024-11-04T14:11:58.890Z | 2024-11-09T14:22:55.012Z |
5467516 | 5467516 | 20241102213420_ypnxl | CZ000P | 2024-11-04T14:11:49.552Z | 2024-11-09T14:22:54.871Z |
5467170 | 5467170 | 20241102201850_9AosT | CZ000P | 2024-11-04T14:11:00.222Z | 2024-11-09T14:22:53.487Z |
5467099 | 5467099 | 20241102200650_QVtC3 | CZ000P | 2024-11-04T14:10:37.767Z | 2024-11-09T14:22:53.326Z |
5467056 | 5467056 | 20241102195945_QkeS8 | CZ000P | 2024-11-04T14:10:32.652Z | 2024-11-09T14:22:53.155Z |
5466913 | 5466913 | 20241102192227_ntJxr | CZ000P | 2024-11-04T14:10:17.232Z | 2024-11-09T14:22:52.766Z |
5466566 | 5466566 | 20241102180542_kZ8pr | CZ000P | 2024-11-04T14:09:20.742Z | 2024-11-09T14:22:51.167Z |
5466301 | 5466301 | 20241102170629_4FMNa | CZ000P | 2024-11-04T14:08:34.629Z | 2024-11-09T14:22:50.116Z |
5461633 | 5461633 | 20241101203514_IQmwb | CZ000P | 2024-11-03T14:15:59.940Z | 2024-11-09T14:23:30.285Z |
5452060 | 5452060 | 20241101015029_Lbbtf | CZ000P | 2024-11-02T12:18:14.799Z | 2024-11-09T14:24:27.797Z |
5451500 | 5451500 | 20241101000546_SczCl | CZ000P | 2024-11-02T12:17:20.365Z | 2024-11-09T14:24:23.936Z |
5451151 | 5451151 | 20241031225143_CkC6i | CZ000P | 2024-11-02T12:16:39.384Z | 2024-11-09T14:24:21.876Z |
5450884 | 5450884 | 20241031213223_Rlb3t | CZ000P | 2024-11-02T12:16:10.460Z | 2024-11-09T14:24:19.620Z |
5450635 | 5450635 | 20241031200557_OEIwf | CZ000P | 2024-11-02T12:15:41.070Z | 2024-11-09T14:24:17.197Z |
5450537 | 5450537 | 20241031194454_tcSeM | CZ000P | 2024-11-02T12:15:34.794Z | 2024-11-09T14:24:16.413Z |
5443224 | 5443224 | 20241030040612_CShYH | CZ000P | 2024-11-01T12:20:23.626Z | 2024-11-07T14:26:50.136Z |
5431484 | 5431484 | 20241029011929_l2KtY | CZ000P | 2024-10-31T12:20:13.121Z | 2024-11-06T14:27:23.894Z |
5431403 | 5431403 | 20241029010512_kpUdO | CZ000P | 2024-10-31T12:20:05.324Z | 2024-11-06T14:27:23.473Z |
5431320 | 5431320 | 20241029005502_lOBF1 | CZ000P | 2024-10-31T12:19:54.771Z | 2024-11-06T14:27:23.278Z |
5430738 | 5430738 | 20241028233104_x7nYy | CZ000P | 2024-10-31T12:18:56.192Z | 2024-11-06T14:27:21.191Z |
5430707 | 5430707 | 20241028232717_cfwiy | CZ000P | 2024-10-31T12:18:54.190Z | 2024-11-06T14:27:21.151Z |
5430515 | 5430515 | 20241028225143_CL2E3 | CZ000P | 2024-10-31T12:18:30.361Z | 2024-11-06T14:27:20.284Z |
5429966 | 5429966 | 20241028203523_SJDly | CZ000P | 2024-10-31T12:17:19.531Z | 2024-11-06T14:27:18.137Z |
5429763 | 5429763 | 20241028195947_puGKh | CZ000P | 2024-10-31T12:17:00.640Z | 2024-11-06T14:27:17.553Z |
5429697 | 5429697 | 20241028195133_B7ome | CZ000P | 2024-10-31T12:16:55.448Z | 2024-11-06T14:27:17.405Z |
5429532 | 5429532 | 20241028193223_UEmmn | CZ000P | 2024-10-31T12:16:41.878Z | 2024-11-06T14:27:16.359Z |
5428986 | 5428986 | 20241028183217_8SXAK | CZ000P | 2024-10-31T12:15:49.245Z | 2024-11-06T14:27:14.889Z |
5428959 | 5428959 | 20241028182842_2MpTu | CZ000P | 2024-10-31T12:15:46.703Z | 2024-11-06T14:27:14.846Z |
5388239 | 5388239 | 20241025042152_63MfQ | CZ000P | 2024-10-27T12:22:05.373Z | 2024-11-02T12:28:33.894Z |
5388218 | 5388218 | 20241025041922_4mq33 | CZ000P | 2024-10-27T12:22:04.773Z | 2024-11-02T12:28:33.874Z |
5388205 | 5388205 | 20241025041739_121qv | CZ000P | 2024-10-27T12:22:04.138Z | 2024-11-02T12:28:33.840Z |
5388137 | 5388137 | 20241025040809_bn31G | CZ000P | 2024-10-27T12:22:01.487Z | 2024-11-02T12:28:33.777Z |
5388135 | 5388135 | 20241025040804_cwsLA | CZ000P | 2024-10-27T12:22:01.373Z | 2024-11-02T12:28:33.775Z |
5388080 | 5388080 | 20241025035956_OiZZ2 | CZ000P | 2024-10-27T12:21:58.629Z | 2024-11-02T12:28:33.738Z |
5388067 | 5388067 | 20241025035814_RdHUL | CZ000P | 2024-10-27T12:21:57.818Z | 2024-11-02T12:28:33.734Z |
5388032 | 5388032 | 20241025035405_SFuud | CZ000P | 2024-10-27T12:21:54.460Z | 2024-11-02T12:28:33.631Z |
5387986 | 5387986 | 20241025034907_fSeKU | CZ000P | 2024-10-27T12:21:51.724Z | 2024-11-02T12:28:33.553Z |
5387883 | 5387883 | 20241025033455_kZ07k | CZ000P | 2024-10-27T12:21:47.403Z | 2024-11-02T12:28:33.358Z |
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);