participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
776 rows where station_code = "CZ000Q" 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 |
---|---|---|---|---|---|
5572311 | 5572311 | 20241121020835_TmBFr | CZ000Q | 2024-11-22T14:18:14.869Z | 2024-11-22T14:19:22.303Z |
5572246 | 5572246 | 20241121015843_5Y064 | CZ000Q | 2024-11-22T14:18:07.306Z | 2024-11-22T14:19:22.288Z |
5572229 | 5572229 | 20241121015444_3EODi | CZ000Q | 2024-11-22T14:18:05.915Z | 2024-11-22T14:19:22.284Z |
5572031 | 5572031 | 20241121012204_LNIch | CZ000Q | 2024-11-22T14:17:53.335Z | 2024-11-22T14:19:22.245Z |
5571973 | 5571973 | 20241121011556_rUwwk | CZ000Q | 2024-11-22T14:17:50.495Z | 2024-11-22T14:19:22.235Z |
5571938 | 5571938 | 20241121010934_d1HNQ | CZ000Q | 2024-11-22T14:17:48.129Z | 2024-11-22T14:19:22.226Z |
5571868 | 5571868 | 20241121005819_xRPTL | CZ000Q | 2024-11-22T14:17:44.046Z | 2024-11-22T14:19:22.212Z |
5571792 | 5571792 | 20241121004808_OpJYh | CZ000Q | 2024-11-22T14:17:40.088Z | 2024-11-22T14:19:22.196Z |
5571740 | 5571740 | 20241121003909_U7jap | CZ000Q | 2024-11-22T14:17:36.889Z | 2024-11-22T14:19:22.184Z |
5571639 | 5571639 | 20241121002615_i63sY | CZ000Q | 2024-11-22T14:17:30.054Z | 2024-11-22T14:19:22.164Z |
5570772 | 5570772 | 20241120205349_ELE9Q | CZ000Q | 2024-11-22T14:16:04.720Z | 2024-11-22T14:19:21.978Z |
5570647 | 5570647 | 20241120203452_Ftpf8 | CZ000Q | 2024-11-22T14:15:58.367Z | 2024-11-22T14:19:21.956Z |
5570545 | 5570545 | 20241120200126_EVP6V | CZ000Q | 2024-11-22T14:15:44.162Z | 2024-11-22T14:19:21.935Z |
5570139 | 5570139 | 20241120185026_WaG2e | CZ000Q | 2024-11-22T14:14:54.621Z | 2024-11-22T14:19:21.868Z |
5570098 | 5570098 | 20241120184125_cyEQl | CZ000Q | 2024-11-22T14:14:51.398Z | 2024-11-22T14:19:21.861Z |
5553715 | 5553715 | 20241118035633_mp3c8 | CZ000Q | 2024-11-19T14:11:19.948Z | 2024-11-22T14:22:55.679Z |
5553713 | 5553713 | 20241118035535_LXWja | CZ000Q | 2024-11-19T14:11:19.412Z | 2024-11-22T14:22:55.554Z |
5553654 | 5553654 | 20241118034048_tCI3U | CZ000Q | 2024-11-19T14:11:10.135Z | 2024-11-22T14:22:55.099Z |
5553642 | 5553642 | 20241118033942_kMYhE | CZ000Q | 2024-11-19T14:11:08.073Z | 2024-11-22T14:22:55.015Z |
5553636 | 5553636 | 20241118033759_PCE7p | CZ000Q | 2024-11-19T14:11:07.256Z | 2024-11-22T14:22:54.951Z |
5553634 | 5553634 | 20241118033735_DtCFA | CZ000Q | 2024-11-19T14:11:07.144Z | 2024-11-22T14:22:54.947Z |
5553549 | 5553549 | 20241118031546_mOtDK | CZ000Q | 2024-11-19T14:10:49.886Z | 2024-11-22T14:22:54.138Z |
5548582 | 5548582 | 20241117002624_LdrlB | CZ000Q | 2024-11-18T14:09:32.002Z | 2024-11-22T14:23:14.418Z |
5509545 | 5509545 | 20241108234330_QErGB | CZ000Q | 2024-11-10T14:13:33.524Z | 2024-11-17T14:23:46.724Z |
5502115 | 5502115 | 20241107172228_sz7KH | CZ000Q | 2024-11-09T14:10:57.605Z | 2024-11-16T14:27:50.549Z |
5502035 | 5502035 | 20241107165826_QVA2S | CZ000Q | 2024-11-09T14:10:51.221Z | 2024-11-16T14:27:49.544Z |
5502029 | 5502029 | 20241107165609_TZuzc | CZ000Q | 2024-11-09T14:10:50.848Z | 2024-11-16T14:27:49.508Z |
5490681 | 5490681 | 20241106000629_qoLQy | CZ000Q | 2024-11-07T14:14:30.084Z | 2024-11-14T14:23:21.206Z |
5490672 | 5490672 | 20241106000217_yuiF5 | CZ000Q | 2024-11-07T14:14:27.782Z | 2024-11-14T14:23:21.184Z |
5490632 | 5490632 | 20241105234758_U8aSY | CZ000Q | 2024-11-07T14:14:20.309Z | 2024-11-14T14:23:21.032Z |
5490452 | 5490452 | 20241105225350_AuVmb | CZ000Q | 2024-11-07T14:14:03.011Z | 2024-11-14T14:23:20.365Z |
5490391 | 5490391 | 20241105223341_mmQGZ | CZ000Q | 2024-11-07T14:13:58.077Z | 2024-11-14T14:23:19.292Z |
5490358 | 5490358 | 20241105222156_3vYIR | CZ000Q | 2024-11-07T14:13:55.258Z | 2024-11-14T14:23:19.131Z |
5490252 | 5490252 | 20241105214736_uu3qQ | CZ000Q | 2024-11-07T14:13:44.897Z | 2024-11-14T14:23:18.398Z |
5490094 | 5490094 | 20241105205704_RYv3z | CZ000Q | 2024-11-07T14:13:10.661Z | 2024-11-14T14:23:17.501Z |
5488989 | 5488989 | 20241105173102_0oW3n | CZ000Q | 2024-11-07T14:11:08.298Z | 2024-11-14T14:23:09.213Z |
5484400 | 5484400 | 20241105024506_gEfBX | CZ000Q | 2024-11-06T14:16:52.690Z | 2024-11-13T14:27:37.839Z |
5484109 | 5484109 | 20241105021015_8g7KX | CZ000Q | 2024-11-06T14:16:17.526Z | 2024-11-13T14:27:37.306Z |
5483935 | 5483935 | 20241105014634_Rttq2 | CZ000Q | 2024-11-06T14:15:56.092Z | 2024-11-13T14:27:37.033Z |
5483839 | 5483839 | 20241105013650_GWezF | CZ000Q | 2024-11-06T14:15:45.554Z | 2024-11-13T14:27:36.874Z |
5483445 | 5483445 | 20241105004248_KUU03 | CZ000Q | 2024-11-06T14:15:20.396Z | 2024-11-13T14:27:36.289Z |
5482770 | 5482770 | 20241104231150_Nzubl | CZ000Q | 2024-11-06T14:13:54.295Z | 2024-11-13T14:27:35.084Z |
5482479 | 5482479 | 20241104222625_rm4U1 | CZ000Q | 2024-11-06T14:13:15.135Z | 2024-11-13T14:27:34.675Z |
5482351 | 5482351 | 20241104215533_geh5l | CZ000Q | 2024-11-06T14:13:04.490Z | 2024-11-13T14:27:34.406Z |
5482221 | 5482221 | 20241104212808_nDsMf | CZ000Q | 2024-11-06T14:12:37.286Z | 2024-11-13T14:27:34.143Z |
5478474 | 5478474 | 20241104041610_kK3hh | CZ000Q | 2024-11-05T14:18:24.292Z | 2024-11-12T14:28:15.559Z |
5478398 | 5478398 | 20241104040159_aIRU3 | CZ000Q | 2024-11-05T14:18:18.422Z | 2024-11-12T14:28:15.223Z |
5478177 | 5478177 | 20241104033221_476LK | CZ000Q | 2024-11-05T14:18:02.163Z | 2024-11-12T14:28:14.517Z |
5477784 | 5477784 | 20241104023525_GjtyD | CZ000Q | 2024-11-05T14:17:24.949Z | 2024-11-12T14:28:12.878Z |
5477614 | 5477614 | 20241104021322_oDgg4 | CZ000Q | 2024-11-05T14:17:09.363Z | 2024-11-12T14:28:12.144Z |
5477535 | 5477535 | 20241104020606_w4mO0 | CZ000Q | 2024-11-05T14:17:01.834Z | 2024-11-12T14:28:11.958Z |
5477335 | 5477335 | 20241104013922_cgED9 | CZ000Q | 2024-11-05T14:16:44.574Z | 2024-11-12T14:28:10.708Z |
5477313 | 5477313 | 20241104013545_z21sB | CZ000Q | 2024-11-05T14:16:42.733Z | 2024-11-12T14:28:10.685Z |
5477310 | 5477310 | 20241104013521_LB2Mb | CZ000Q | 2024-11-05T14:16:42.244Z | 2024-11-12T14:28:10.550Z |
5477171 | 5477171 | 20241104011133_22M17 | CZ000Q | 2024-11-05T14:16:28.792Z | 2024-11-12T14:28:09.942Z |
5476932 | 5476932 | 20241104004324_vyn2S | CZ000Q | 2024-11-05T14:16:12.856Z | 2024-11-12T14:28:07.916Z |
5476907 | 5476907 | 20241104004018_AarGc | CZ000Q | 2024-11-05T14:16:11.558Z | 2024-11-12T14:28:07.875Z |
5476847 | 5476847 | 20241104003318_y20rJ | CZ000Q | 2024-11-05T14:16:07.519Z | 2024-11-12T14:28:07.726Z |
5476661 | 5476661 | 20241104000406_vlil2 | CZ000Q | 2024-11-05T14:15:49.576Z | 2024-11-12T14:28:06.752Z |
5476316 | 5476316 | 20241103230700_cmMn7 | CZ000Q | 2024-11-05T14:15:03.254Z | 2024-11-12T14:28:05.380Z |
5476266 | 5476266 | 20241103225647_C4eWB | CZ000Q | 2024-11-05T14:14:59.524Z | 2024-11-12T14:28:04.771Z |
5476042 | 5476042 | 20241103221114_borrz | CZ000Q | 2024-11-05T14:14:41.238Z | 2024-11-12T14:28:02.487Z |
5475977 | 5475977 | 20241103220300_1D3m2 | CZ000Q | 2024-11-05T14:14:36.889Z | 2024-11-12T14:28:01.992Z |
5475823 | 5475823 | 20241103213043_7Hg6Q | CZ000Q | 2024-11-05T14:14:18.728Z | 2024-11-12T14:28:01.158Z |
5475769 | 5475769 | 20241103212009_cKBxI | CZ000Q | 2024-11-05T14:14:10.567Z | 2024-11-12T14:28:00.894Z |
5475715 | 5475715 | 20241103210913_qqRbC | CZ000Q | 2024-11-05T14:14:03.126Z | 2024-11-12T14:28:00.725Z |
5475696 | 5475696 | 20241103210411_Ruzi0 | CZ000Q | 2024-11-05T14:14:01.653Z | 2024-11-12T14:28:00.542Z |
5475518 | 5475518 | 20241103202210_TH6W6 | CZ000Q | 2024-11-05T14:13:45.523Z | 2024-11-12T14:27:59.557Z |
5475258 | 5475258 | 20241103193801_R7GY2 | CZ000Q | 2024-11-05T14:12:55.124Z | 2024-11-12T14:27:57.857Z |
5475066 | 5475066 | 20241103190052_Ibl0A | CZ000Q | 2024-11-05T14:12:28.839Z | 2024-11-12T14:27:56.932Z |
5475025 | 5475025 | 20241103185212_uclmg | CZ000Q | 2024-11-05T14:12:25.505Z | 2024-11-12T14:27:56.475Z |
5474995 | 5474995 | 20241103184716_NXiIX | CZ000Q | 2024-11-05T14:12:22.764Z | 2024-11-12T14:27:56.063Z |
5474989 | 5474989 | 20241103184705_Vcr7q | CZ000Q | 2024-11-05T14:12:22.231Z | 2024-11-12T14:27:56.007Z |
5474973 | 5474973 | 20241103184449_pi483 | CZ000Q | 2024-11-05T14:12:20.818Z | 2024-11-12T14:27:55.934Z |
5474862 | 5474862 | 20241103182646_dn226 | CZ000Q | 2024-11-05T14:12:11.877Z | 2024-11-12T14:27:55.175Z |
5474790 | 5474790 | 20241103181810_B6Myn | CZ000Q | 2024-11-05T14:12:00.979Z | 2024-11-12T14:27:54.712Z |
5474517 | 5474517 | 20241103173342_D7epj | CZ000Q | 2024-11-05T14:11:11.854Z | 2024-11-12T14:27:52.574Z |
5474514 | 5474514 | 20241103173336_qipTy | CZ000Q | 2024-11-05T14:11:11.611Z | 2024-11-12T14:27:52.497Z |
5468708 | 5468708 | 20241103013016_0ktOS | CZ000Q | 2024-11-04T14:14:57.246Z | 2024-11-11T14:22:55.148Z |
5468702 | 5468702 | 20241103012948_375Ze | CZ000Q | 2024-11-04T14:14:56.574Z | 2024-11-11T14:22:55.135Z |
5468515 | 5468515 | 20241103005059_uXqf4 | CZ000Q | 2024-11-04T14:14:17.704Z | 2024-11-11T14:22:53.949Z |
5468406 | 5468406 | 20241103002900_YLqOY | CZ000Q | 2024-11-04T14:14:04.140Z | 2024-11-11T14:22:53.190Z |
5468350 | 5468350 | 20241103001618_N8s3O | CZ000Q | 2024-11-04T14:13:59.978Z | 2024-11-11T14:22:52.807Z |
5468330 | 5468330 | 20241103001214_qjKYD | CZ000Q | 2024-11-04T14:13:57.854Z | 2024-11-11T14:22:52.748Z |
5468223 | 5468223 | 20241102235309_2NOhG | CZ000Q | 2024-11-04T14:13:46.863Z | 2024-11-11T14:22:52.161Z |
5468199 | 5468199 | 20241102234828_73odw | CZ000Q | 2024-11-04T14:13:43.707Z | 2024-11-11T14:22:52.006Z |
5468105 | 5468105 | 20241102232946_RU2JN | CZ000Q | 2024-11-04T14:13:17.231Z | 2024-11-11T14:22:51.385Z |
5467993 | 5467993 | 20241102231212_3RS9X | CZ000Q | 2024-11-04T14:13:05.316Z | 2024-11-11T14:22:50.682Z |
5467937 | 5467937 | 20241102225829_a2YZE | CZ000Q | 2024-11-04T14:12:59.098Z | 2024-11-11T14:22:50.358Z |
5467861 | 5467861 | 20241102224741_OwIgl | CZ000Q | 2024-11-04T14:12:45.992Z | 2024-11-11T14:22:50.079Z |
5467816 | 5467816 | 20241102224228_YR94k | CZ000Q | 2024-11-04T14:12:34.556Z | 2024-11-11T14:22:49.866Z |
5467759 | 5467759 | 20241102223131_xSvne | CZ000Q | 2024-11-04T14:12:28.441Z | 2024-11-11T14:22:49.312Z |
5467721 | 5467721 | 20241102222404_bDi2Q | CZ000Q | 2024-11-04T14:12:24.057Z | 2024-11-11T14:22:49.102Z |
5467683 | 5467683 | 20241102221657_9L3MC | CZ000Q | 2024-11-04T14:12:20.857Z | 2024-11-11T14:22:48.922Z |
5467597 | 5467597 | 20241102220240_H47Lk | CZ000Q | 2024-11-04T14:12:12.915Z | 2024-11-11T14:22:47.728Z |
5467518 | 5467518 | 20241102213425_PEaJD | CZ000Q | 2024-11-04T14:11:50.181Z | 2024-11-11T14:22:47.423Z |
5467482 | 5467482 | 20241102212655_ucylp | CZ000Q | 2024-11-04T14:11:40.270Z | 2024-11-11T14:22:47.309Z |
5467458 | 5467458 | 20241102212243_FxtKV | CZ000Q | 2024-11-04T14:11:34.672Z | 2024-11-11T14:22:47.235Z |
5467450 | 5467450 | 20241102211829_84At3 | CZ000Q | 2024-11-04T14:11:33.186Z | 2024-11-11T14:22:47.153Z |
5467126 | 5467126 | 20241102201309_1z18g | CZ000Q | 2024-11-04T14:10:44.952Z | 2024-11-11T14:22:45.365Z |
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);