participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,692 rows where station_code = "CZ000K" 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 |
---|---|---|---|---|---|
5505291 | 5505291 | 20241108042611_SaJNX | CZ000K | 2024-11-09T14:16:05.456Z | 2024-11-09T14:16:28.746Z |
5505161 | 5505161 | 20241108040138_63yOg | CZ000K | 2024-11-09T14:15:52.352Z | 2024-11-09T14:16:28.715Z |
5505155 | 5505155 | 20241108040116_qTyVL | CZ000K | 2024-11-09T14:15:51.617Z | 2024-11-09T14:16:28.714Z |
5505135 | 5505135 | 20241108035747_kulM3 | CZ000K | 2024-11-09T14:15:48.939Z | 2024-11-09T14:16:28.708Z |
5504877 | 5504877 | 20241108031135_59FLs | CZ000K | 2024-11-09T14:15:18.838Z | 2024-11-09T14:16:28.646Z |
5504865 | 5504865 | 20241108030916_fPjYe | CZ000K | 2024-11-09T14:15:17.831Z | 2024-11-09T14:16:28.644Z |
5504798 | 5504798 | 20241108025943_n2od3 | CZ000K | 2024-11-09T14:15:12.109Z | 2024-11-09T14:16:28.628Z |
5504739 | 5504739 | 20241108025016_VxlCI | CZ000K | 2024-11-09T14:15:08.334Z | 2024-11-09T14:16:28.614Z |
5504726 | 5504726 | 20241108024705_6Xa3v | CZ000K | 2024-11-09T14:15:07.397Z | 2024-11-09T14:16:28.610Z |
5504654 | 5504654 | 20241108023517_MWn87 | CZ000K | 2024-11-09T14:15:01.370Z | 2024-11-09T14:16:28.593Z |
5504384 | 5504384 | 20241108015008_dPxY6 | CZ000K | 2024-11-09T14:14:30.128Z | 2024-11-09T14:16:28.522Z |
5504238 | 5504238 | 20241108011841_rrRMl | CZ000K | 2024-11-09T14:14:15.935Z | 2024-11-09T14:16:28.483Z |
5504181 | 5504181 | 20241108010957_asSsM | CZ000K | 2024-11-09T14:14:11.844Z | 2024-11-09T14:16:28.469Z |
5504132 | 5504132 | 20241108005946_YBj5V | CZ000K | 2024-11-09T14:14:06.442Z | 2024-11-09T14:16:28.456Z |
5504117 | 5504117 | 20241108005640_6gwNi | CZ000K | 2024-11-09T14:14:05.659Z | 2024-11-09T14:16:28.453Z |
5503945 | 5503945 | 20241108002134_Xgct2 | CZ000K | 2024-11-09T14:13:54.291Z | 2024-11-09T14:16:28.407Z |
5503807 | 5503807 | 20241107235133_rkaFR | CZ000K | 2024-11-09T14:13:45.523Z | 2024-11-09T14:16:28.352Z |
5503664 | 5503664 | 20241107232000_Hdhfa | CZ000K | 2024-11-09T14:13:30.406Z | 2024-11-09T14:16:28.315Z |
5503528 | 5503528 | 20241107224131_Yj0Is | CZ000K | 2024-11-09T14:13:15.389Z | 2024-11-09T14:16:28.283Z |
5503461 | 5503461 | 20241107222447_Jwzw2 | CZ000K | 2024-11-09T14:13:07.664Z | 2024-11-09T14:16:28.264Z |
5503156 | 5503156 | 20241107205318_aVGka | CZ000K | 2024-11-09T14:12:28.312Z | 2024-11-09T14:16:28.180Z |
5502530 | 5502530 | 20241107185552_VbCQt | CZ000K | 2024-11-09T14:11:39.742Z | 2024-11-09T14:16:28.048Z |
5490459 | 5490459 | 20241105225610_f6dJ7 | CZ000K | 2024-11-07T14:14:03.753Z | 2024-11-09T14:19:55.876Z |
5485010 | 5485010 | 20241105035326_1ZCd9 | CZ000K | 2024-11-06T14:17:38.903Z | 2024-11-09T14:21:18.779Z |
5484828 | 5484828 | 20241105033221_yEQF6 | CZ000K | 2024-11-06T14:17:21.507Z | 2024-11-09T14:21:16.796Z |
5484710 | 5484710 | 20241105032128_11EYJ | CZ000K | 2024-11-06T14:17:10.787Z | 2024-11-09T14:21:16.023Z |
5484338 | 5484338 | 20241105023617_oaBYV | CZ000K | 2024-11-06T14:16:49.477Z | 2024-11-09T14:21:13.372Z |
5484155 | 5484155 | 20241105021542_xwWNl | CZ000K | 2024-11-06T14:16:23.327Z | 2024-11-09T14:21:11.474Z |
5484076 | 5484076 | 20241105020842_8xF8l | CZ000K | 2024-11-06T14:16:11.741Z | 2024-11-09T14:21:10.532Z |
5484028 | 5484028 | 20241105020136_mtq2a | CZ000K | 2024-11-06T14:16:05.813Z | 2024-11-09T14:21:10.208Z |
5483882 | 5483882 | 20241105014119_Qc6BA | CZ000K | 2024-11-06T14:15:49.855Z | 2024-11-09T14:21:08.985Z |
5483825 | 5483825 | 20241105013539_iAv2N | CZ000K | 2024-11-06T14:15:44.826Z | 2024-11-09T14:21:08.596Z |
5483509 | 5483509 | 20241105004831_GZu62 | CZ000K | 2024-11-06T14:15:25.794Z | 2024-11-09T14:21:05.691Z |
5483406 | 5483406 | 20241105003720_3yeqz | CZ000K | 2024-11-06T14:15:13.125Z | 2024-11-09T14:21:05.276Z |
5483368 | 5483368 | 20241105003212_xpyk4 | CZ000K | 2024-11-06T14:15:04.218Z | 2024-11-09T14:21:05.040Z |
5483292 | 5483292 | 20241105002346_MshKr | CZ000K | 2024-11-06T14:14:54.676Z | 2024-11-09T14:21:04.624Z |
5483202 | 5483202 | 20241105001149_RkOOY | CZ000K | 2024-11-06T14:14:46.285Z | 2024-11-09T14:21:04.013Z |
5482951 | 5482951 | 20241104234123_qN9Ou | CZ000K | 2024-11-06T14:14:30.664Z | 2024-11-09T14:21:02.618Z |
5482947 | 5482947 | 20241104234033_i3F22 | CZ000K | 2024-11-06T14:14:30.128Z | 2024-11-09T14:21:02.573Z |
5482942 | 5482942 | 20241104233737_bqKNS | CZ000K | 2024-11-06T14:14:29.210Z | 2024-11-09T14:21:02.546Z |
5482929 | 5482929 | 20241104233447_zNeOU | CZ000K | 2024-11-06T14:14:21.515Z | 2024-11-09T14:21:02.423Z |
5482813 | 5482813 | 20241104231709_w5KpJ | CZ000K | 2024-11-06T14:14:05.091Z | 2024-11-09T14:21:01.709Z |
5481490 | 5481490 | 20241104175714_3V13i | CZ000K | 2024-11-06T14:10:40.010Z | 2024-11-09T14:20:46.462Z |
5478567 | 5478567 | 20241104043401_vsGqd | CZ000K | 2024-11-05T14:18:31.926Z | 2024-11-09T14:22:29.726Z |
5477987 | 5477987 | 20241104030441_Durjx | CZ000K | 2024-11-05T14:17:42.778Z | 2024-11-09T14:22:23.267Z |
5477849 | 5477849 | 20241104024621_OmTRX | CZ000K | 2024-11-05T14:17:31.951Z | 2024-11-09T14:22:22.438Z |
5477838 | 5477838 | 20241104024437_MtOHF | CZ000K | 2024-11-05T14:17:31.074Z | 2024-11-09T14:22:22.422Z |
5477573 | 5477573 | 20241104021008_pvAPj | CZ000K | 2024-11-05T14:17:04.537Z | 2024-11-09T14:22:19.634Z |
5477442 | 5477442 | 20241104015404_xuxGi | CZ000K | 2024-11-05T14:16:53.723Z | 2024-11-09T14:22:17.702Z |
5477269 | 5477269 | 20241104012947_mt7wI | CZ000K | 2024-11-05T14:16:38.910Z | 2024-11-09T14:22:16.276Z |
5477148 | 5477148 | 20241104010822_JOEEX | CZ000K | 2024-11-05T14:16:27.026Z | 2024-11-09T14:22:14.831Z |
5477142 | 5477142 | 20241104010805_Hifdp | CZ000K | 2024-11-05T14:16:26.687Z | 2024-11-09T14:22:14.819Z |
5477103 | 5477103 | 20241104010115_frT8V | CZ000K | 2024-11-05T14:16:22.821Z | 2024-11-09T14:22:14.341Z |
5476915 | 5476915 | 20241104004128_X6PEf | CZ000K | 2024-11-05T14:16:12.031Z | 2024-11-09T14:22:13.304Z |
5476769 | 5476769 | 20241104001940_v2k9s | CZ000K | 2024-11-05T14:16:03.805Z | 2024-11-09T14:22:12.298Z |
5476626 | 5476626 | 20241103235650_3T6mJ | CZ000K | 2024-11-05T14:15:46.213Z | 2024-11-09T14:22:11.271Z |
5476586 | 5476586 | 20241103234841_KxnRN | CZ000K | 2024-11-05T14:15:41.808Z | 2024-11-09T14:22:10.989Z |
5476537 | 5476537 | 20241103234047_DIUc2 | CZ000K | 2024-11-05T14:15:35.432Z | 2024-11-09T14:22:10.327Z |
5476507 | 5476507 | 20241103233734_7u9Vy | CZ000K | 2024-11-05T14:15:32.320Z | 2024-11-09T14:22:10.201Z |
5476357 | 5476357 | 20241103231336_7ohhr | CZ000K | 2024-11-05T14:15:09.834Z | 2024-11-09T14:22:08.733Z |
5476323 | 5476323 | 20241103230849_n85pH | CZ000K | 2024-11-05T14:15:04.016Z | 2024-11-09T14:22:07.893Z |
5476260 | 5476260 | 20241103225454_TNn8v | CZ000K | 2024-11-05T14:14:58.963Z | 2024-11-09T14:22:07.397Z |
5476230 | 5476230 | 20241103224915_EB6PO | CZ000K | 2024-11-05T14:14:55.774Z | 2024-11-09T14:22:07.188Z |
5476207 | 5476207 | 20241103224412_nqQ29 | CZ000K | 2024-11-05T14:14:51.963Z | 2024-11-09T14:22:06.888Z |
5476094 | 5476094 | 20241103222333_eu9rA | CZ000K | 2024-11-05T14:14:44.667Z | 2024-11-09T14:22:05.718Z |
5476039 | 5476039 | 20241103221045_GYiIR | CZ000K | 2024-11-05T14:14:41.120Z | 2024-11-09T14:22:05.005Z |
5476027 | 5476027 | 20241103221017_6PDtK | CZ000K | 2024-11-05T14:14:40.484Z | 2024-11-09T14:22:04.851Z |
5476021 | 5476021 | 20241103220916_pVMxP | CZ000K | 2024-11-05T14:14:40.098Z | 2024-11-09T14:22:04.795Z |
5476010 | 5476010 | 20241103220653_1FFND | CZ000K | 2024-11-05T14:14:38.980Z | 2024-11-09T14:22:04.709Z |
5475983 | 5475983 | 20241103220424_8svtb | CZ000K | 2024-11-05T14:14:37.370Z | 2024-11-09T14:22:04.409Z |
5475945 | 5475945 | 20241103215742_vxKPo | CZ000K | 2024-11-05T14:14:35.176Z | 2024-11-09T14:22:04.082Z |
5475924 | 5475924 | 20241103215147_pjf3D | CZ000K | 2024-11-05T14:14:33.720Z | 2024-11-09T14:22:03.971Z |
5475904 | 5475904 | 20241103214833_cB2u0 | CZ000K | 2024-11-05T14:14:32.925Z | 2024-11-09T14:22:03.871Z |
5475875 | 5475875 | 20241103214411_fa1WU | CZ000K | 2024-11-05T14:14:28.611Z | 2024-11-09T14:22:03.417Z |
5475788 | 5475788 | 20241103212404_AW31n | CZ000K | 2024-11-05T14:14:12.450Z | 2024-11-09T14:22:02.254Z |
5475634 | 5475634 | 20241103205234_apX9k | CZ000K | 2024-11-05T14:13:54.879Z | 2024-11-09T14:22:00.631Z |
5475614 | 5475614 | 20241103205032_NHZ2D | CZ000K | 2024-11-05T14:13:53.303Z | 2024-11-09T14:22:00.537Z |
5475585 | 5475585 | 20241103204337_agpwB | CZ000K | 2024-11-05T14:13:51.338Z | 2024-11-09T14:22:00.330Z |
5475549 | 5475549 | 20241103203352_shBbt | CZ000K | 2024-11-05T14:13:48.206Z | 2024-11-09T14:21:59.993Z |
5475220 | 5475220 | 20241103193219_WrwHt | CZ000K | 2024-11-05T14:12:47.435Z | 2024-11-09T14:21:56.645Z |
5475125 | 5475125 | 20241103191153_vS29c | CZ000K | 2024-11-05T14:12:35.094Z | 2024-11-09T14:21:56.032Z |
5475044 | 5475044 | 20241103185535_6VYAW | CZ000K | 2024-11-05T14:12:26.926Z | 2024-11-09T14:21:55.412Z |
5474905 | 5474905 | 20241103183609_d557L | CZ000K | 2024-11-05T14:12:15.390Z | 2024-11-09T14:21:54.112Z |
5474509 | 5474509 | 20241103173322_R2B1B | CZ000K | 2024-11-05T14:11:11.158Z | 2024-11-09T14:21:47.510Z |
5469631 | 5469631 | 20241103035424_GQtv9 | CZ000K | 2024-11-04T14:16:41.727Z | 2024-11-09T14:23:03.241Z |
5469448 | 5469448 | 20241103033015_2xi33 | CZ000K | 2024-11-04T14:16:29.040Z | 2024-11-09T14:23:02.626Z |
5469264 | 5469264 | 20241103025838_aTYrs | CZ000K | 2024-11-04T14:16:08.386Z | 2024-11-09T14:23:01.815Z |
5469228 | 5469228 | 20241103025359_T87mk | CZ000K | 2024-11-04T14:15:58.893Z | 2024-11-09T14:23:01.527Z |
5469214 | 5469214 | 20241103025124_kmnDU | CZ000K | 2024-11-04T14:15:56.991Z | 2024-11-09T14:23:01.307Z |
5469014 | 5469014 | 20241103022301_AiMvc | CZ000K | 2024-11-04T14:15:23.064Z | 2024-11-09T14:23:00.649Z |
5468994 | 5468994 | 20241103022036_8K6rY | CZ000K | 2024-11-04T14:15:21.500Z | 2024-11-09T14:23:00.602Z |
5468808 | 5468808 | 20241103015121_nndEk | CZ000K | 2024-11-04T14:15:05.185Z | 2024-11-09T14:22:59.741Z |
5468734 | 5468734 | 20241103013521_tCgF0 | CZ000K | 2024-11-04T14:14:59.126Z | 2024-11-09T14:22:59.460Z |
5468725 | 5468725 | 20241103013411_pHEIC | CZ000K | 2024-11-04T14:14:58.431Z | 2024-11-09T14:22:59.448Z |
5468645 | 5468645 | 20241103011506_FoIZJ | CZ000K | 2024-11-04T14:14:45.893Z | 2024-11-09T14:22:59.160Z |
5468608 | 5468608 | 20241103010654_GbNaI | CZ000K | 2024-11-04T14:14:35.201Z | 2024-11-09T14:22:58.948Z |
5468600 | 5468600 | 20241103010602_MCDBH | CZ000K | 2024-11-04T14:14:33.443Z | 2024-11-09T14:22:58.929Z |
5468597 | 5468597 | 20241103010308_NJVAL | CZ000K | 2024-11-04T14:14:32.694Z | 2024-11-09T14:22:58.928Z |
5468492 | 5468492 | 20241103004535_qdbDk | CZ000K | 2024-11-04T14:14:12.110Z | 2024-11-09T14:22:58.566Z |
5468484 | 5468484 | 20241103004412_j7oMo | CZ000K | 2024-11-04T14:14:11.321Z | 2024-11-09T14:22:58.546Z |
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);