participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,360 rows where station_code = "CZ000F" 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 |
---|---|---|---|---|---|
5478424 | 5478424 | 20241104040844_pImpE | CZ000F | 2024-11-05T14:18:21.551Z | 2024-11-12T14:28:15.276Z |
5478321 | 5478321 | 20241104035150_CA22h | CZ000F | 2024-11-05T14:18:13.680Z | 2024-11-12T14:28:14.950Z |
5478311 | 5478311 | 20241104035111_JxN3B | CZ000F | 2024-11-05T14:18:12.969Z | 2024-11-12T14:28:14.916Z |
5478203 | 5478203 | 20241104033513_p2WPz | CZ000F | 2024-11-05T14:18:03.553Z | 2024-11-12T14:28:14.546Z |
5478175 | 5478175 | 20241104033202_hUY2r | CZ000F | 2024-11-05T14:18:02.007Z | 2024-11-12T14:28:14.506Z |
5477933 | 5477933 | 20241104025555_OXeQC | CZ000F | 2024-11-05T14:17:37.512Z | 2024-11-12T14:28:13.318Z |
5477837 | 5477837 | 20241104024437_MtOHF | CZ000F | 2024-11-05T14:17:31.074Z | 2024-11-12T14:28:13.085Z |
5477715 | 5477715 | 20241104022535_vP5K2 | CZ000F | 2024-11-05T14:17:18.849Z | 2024-11-12T14:28:12.497Z |
5477703 | 5477703 | 20241104022321_2r3ai | CZ000F | 2024-11-05T14:17:16.457Z | 2024-11-12T14:28:12.476Z |
5477695 | 5477695 | 20241104022205_N9w8r | CZ000F | 2024-11-05T14:17:15.500Z | 2024-11-12T14:28:12.451Z |
5477628 | 5477628 | 20241104021610_54BT1 | CZ000F | 2024-11-05T14:17:10.547Z | 2024-11-12T14:28:12.180Z |
5477412 | 5477412 | 20241104014924_lvGhn | CZ000F | 2024-11-05T14:16:50.974Z | 2024-11-12T14:28:11.260Z |
5477280 | 5477280 | 20241104013025_LZa5c | CZ000F | 2024-11-05T14:16:39.585Z | 2024-11-12T14:28:10.518Z |
5477268 | 5477268 | 20241104012947_mt7wI | CZ000F | 2024-11-05T14:16:38.910Z | 2024-11-12T14:28:10.477Z |
5476967 | 5476967 | 20241104004652_OXOhs | CZ000F | 2024-11-05T14:16:15.001Z | 2024-11-12T14:28:07.936Z |
5476909 | 5476909 | 20241104004039_Cg2ny | CZ000F | 2024-11-05T14:16:11.764Z | 2024-11-12T14:28:07.886Z |
5476432 | 5476432 | 20241103232539_FUFwV | CZ000F | 2024-11-05T14:15:21.362Z | 2024-11-12T14:28:06.021Z |
5476415 | 5476415 | 20241103232223_4q22M | CZ000F | 2024-11-05T14:15:18.842Z | 2024-11-12T14:28:05.977Z |
5476229 | 5476229 | 20241103224915_EB6PO | CZ000F | 2024-11-05T14:14:55.774Z | 2024-11-12T14:28:03.899Z |
5476203 | 5476203 | 20241103224231_zt3jk | CZ000F | 2024-11-05T14:14:51.641Z | 2024-11-12T14:28:03.839Z |
5476122 | 5476122 | 20241103222953_oXtbL | CZ000F | 2024-11-05T14:14:46.605Z | 2024-11-12T14:28:03.068Z |
5476114 | 5476114 | 20241103222856_roFBP | CZ000F | 2024-11-05T14:14:46.177Z | 2024-11-12T14:28:03.044Z |
5476037 | 5476037 | 20241103221045_GYiIR | CZ000F | 2024-11-05T14:14:41.120Z | 2024-11-12T14:28:02.487Z |
5476020 | 5476020 | 20241103220916_pVMxP | CZ000F | 2024-11-05T14:14:40.098Z | 2024-11-12T14:28:02.426Z |
5476009 | 5476009 | 20241103220653_1FFND | CZ000F | 2024-11-05T14:14:38.980Z | 2024-11-12T14:28:02.396Z |
5475944 | 5475944 | 20241103215742_vxKPo | CZ000F | 2024-11-05T14:14:35.176Z | 2024-11-12T14:28:01.870Z |
5475811 | 5475811 | 20241103212947_9mf9B | CZ000F | 2024-11-05T14:14:15.404Z | 2024-11-12T14:28:01.127Z |
5475774 | 5475774 | 20241103212040_KiSkB | CZ000F | 2024-11-05T14:14:10.915Z | 2024-11-12T14:28:00.909Z |
5475633 | 5475633 | 20241103205234_apX9k | CZ000F | 2024-11-05T14:13:54.879Z | 2024-11-12T14:28:00.106Z |
5475591 | 5475591 | 20241103204557_BCzYz | CZ000F | 2024-11-05T14:13:51.740Z | 2024-11-12T14:28:00.028Z |
5475502 | 5475502 | 20241103201939_C5uQQ | CZ000F | 2024-11-05T14:13:44.501Z | 2024-11-12T14:27:58.895Z |
5475470 | 5475470 | 20241103201121_fwsuW | CZ000F | 2024-11-05T14:13:42.464Z | 2024-11-12T14:27:58.785Z |
5475408 | 5475408 | 20241103200151_Q2z2d | CZ000F | 2024-11-05T14:13:28.649Z | 2024-11-12T14:27:58.506Z |
5475215 | 5475215 | 20241103193048_242R2 | CZ000F | 2024-11-05T14:12:46.716Z | 2024-11-12T14:27:57.613Z |
5475185 | 5475185 | 20241103192449_Xc6sa | CZ000F | 2024-11-05T14:12:40.345Z | 2024-11-12T14:27:57.466Z |
5475124 | 5475124 | 20241103191153_vS29c | CZ000F | 2024-11-05T14:12:35.094Z | 2024-11-12T14:27:57.200Z |
5475043 | 5475043 | 20241103185535_6VYAW | CZ000F | 2024-11-05T14:12:26.926Z | 2024-11-12T14:27:56.694Z |
5474977 | 5474977 | 20241103184529_aFaUq | CZ000F | 2024-11-05T14:12:21.283Z | 2024-11-12T14:27:55.956Z |
5474508 | 5474508 | 20241103173322_R2B1B | CZ000F | 2024-11-05T14:11:11.155Z | 2024-11-12T14:27:52.421Z |
5468910 | 5468910 | 20241103020905_ief3s | CZ000F | 2024-11-04T14:15:13.176Z | 2024-11-11T14:22:56.916Z |
5468733 | 5468733 | 20241103013521_tCgF0 | CZ000F | 2024-11-04T14:14:59.126Z | 2024-11-11T14:22:55.258Z |
5468724 | 5468724 | 20241103013411_pHEIC | CZ000F | 2024-11-04T14:14:58.431Z | 2024-11-11T14:22:55.239Z |
5468699 | 5468699 | 20241103012912_ErJKu | CZ000F | 2024-11-04T14:14:56.319Z | 2024-11-11T14:22:54.986Z |
5463077 | 5463077 | 20241102023024_MrBcx | CZ000F | 2024-11-03T14:18:17.322Z | 2024-11-10T14:26:34.248Z |
5462970 | 5462970 | 20241102020823_ASpqW | CZ000F | 2024-11-03T14:18:12.488Z | 2024-11-10T14:26:33.866Z |
5462333 | 5462333 | 20241101235102_2ul5R | CZ000F | 2024-11-03T14:17:16.639Z | 2024-11-10T14:26:32.368Z |
5462291 | 5462291 | 20241101234210_6Aq5Y | CZ000F | 2024-11-03T14:17:10.171Z | 2024-11-10T14:26:32.103Z |
5462274 | 5462274 | 20241101233657_QQd7A | CZ000F | 2024-11-03T14:17:08.437Z | 2024-11-10T14:26:32.086Z |
5462244 | 5462244 | 20241101233049_b2Tvh | CZ000F | 2024-11-03T14:17:05.841Z | 2024-11-10T14:26:32.028Z |
5462193 | 5462193 | 20241101231850_dFfQr | CZ000F | 2024-11-03T14:17:03.031Z | 2024-11-10T14:26:31.888Z |
5462163 | 5462163 | 20241101231412_A7QAT | CZ000F | 2024-11-03T14:17:00.983Z | 2024-11-10T14:26:31.744Z |
5462137 | 5462137 | 20241101230831_2kZWQ | CZ000F | 2024-11-03T14:16:59.117Z | 2024-11-10T14:26:31.610Z |
5462042 | 5462042 | 20241101224941_RyFfd | CZ000F | 2024-11-03T14:16:54.459Z | 2024-11-10T14:26:31.416Z |
5461994 | 5461994 | 20241101223656_aouDU | CZ000F | 2024-11-03T14:16:51.297Z | 2024-11-10T14:26:31.172Z |
5461971 | 5461971 | 20241101223027_AsI1G | CZ000F | 2024-11-03T14:16:49.942Z | 2024-11-10T14:26:31.096Z |
5461928 | 5461928 | 20241101221638_SJ3Cd | CZ000F | 2024-11-03T14:16:47.042Z | 2024-11-10T14:26:30.812Z |
5461890 | 5461890 | 20241101220056_gWfFD | CZ000F | 2024-11-03T14:16:37.168Z | 2024-11-10T14:26:30.745Z |
5461867 | 5461867 | 20241101215431_itplY | CZ000F | 2024-11-03T14:16:29.493Z | 2024-11-10T14:26:30.690Z |
5461814 | 5461814 | 20241101213702_QHpP8 | CZ000F | 2024-11-03T14:16:21.102Z | 2024-11-10T14:26:30.379Z |
5461643 | 5461643 | 20241101203929_1pSMO | CZ000F | 2024-11-03T14:16:00.905Z | 2024-11-10T14:26:29.549Z |
5461593 | 5461593 | 20241101200907_7xCJu | CZ000F | 2024-11-03T14:15:57.530Z | 2024-11-10T14:26:29.234Z |
5461569 | 5461569 | 20241101200157_cunTp | CZ000F | 2024-11-03T14:15:56.257Z | 2024-11-10T14:26:29.198Z |
5461550 | 5461550 | 20241101195307_q6KWg | CZ000F | 2024-11-03T14:15:54.738Z | 2024-11-10T14:26:29.156Z |
5461434 | 5461434 | 20241101185827_aGEWK | CZ000F | 2024-11-03T14:15:43.323Z | 2024-11-10T14:26:28.807Z |
5461432 | 5461432 | 20241101185806_aiIJK | CZ000F | 2024-11-03T14:15:42.861Z | 2024-11-10T14:26:28.792Z |
5461385 | 5461385 | 20241101183635_Gzk3O | CZ000F | 2024-11-03T14:15:27.998Z | 2024-11-10T14:26:28.435Z |
5461337 | 5461337 | 20241101180318_ipVy6 | CZ000F | 2024-11-03T14:15:11.779Z | 2024-11-10T14:26:28.139Z |
5461271 | 5461271 | 20241101172803_WDWvP | CZ000F | 2024-11-03T14:14:59.385Z | 2024-11-10T14:26:27.846Z |
5461262 | 5461262 | 20241101172459_U09g2 | CZ000F | 2024-11-03T14:14:58.658Z | 2024-11-10T14:26:27.803Z |
5461249 | 5461249 | 20241101172124_qiryL | CZ000F | 2024-11-03T14:14:57.436Z | 2024-11-10T14:26:27.726Z |
5454397 | 5454397 | 20241031041615_IPTnr | CZ000F | 2024-11-02T12:23:05.320Z | 2024-11-08T14:23:22.655Z |
5453875 | 5453875 | 20241031031107_XtyE1 | CZ000F | 2024-11-02T12:22:44.049Z | 2024-11-08T14:23:19.600Z |
5453554 | 5453554 | 20241031022441_qIy2M | CZ000F | 2024-11-02T12:22:35.939Z | 2024-11-08T14:23:18.069Z |
5453460 | 5453460 | 20241031021425_NrnjV | CZ000F | 2024-11-02T12:22:34.061Z | 2024-11-08T14:23:17.422Z |
5452554 | 5452554 | 20241101033949_gH9PJ | CZ000F | 2024-11-02T12:18:59.772Z | 2024-11-09T14:24:31.463Z |
5452540 | 5452540 | 20241101033723_SmE6d | CZ000F | 2024-11-02T12:18:58.666Z | 2024-11-09T14:24:31.417Z |
5452212 | 5452212 | 20241101022337_C1nd2 | CZ000F | 2024-11-02T12:18:28.490Z | 2024-11-09T14:24:28.863Z |
5452141 | 5452141 | 20241101020639_L23cJ | CZ000F | 2024-11-02T12:18:19.711Z | 2024-11-09T14:24:28.430Z |
5452117 | 5452117 | 20241101020349_pig43 | CZ000F | 2024-11-02T12:18:17.476Z | 2024-11-09T14:24:28.320Z |
5452059 | 5452059 | 20241101015029_Lbbtf | CZ000F | 2024-11-02T12:18:14.799Z | 2024-11-09T14:24:27.797Z |
5452048 | 5452048 | 20241101014940_MTP91 | CZ000F | 2024-11-02T12:18:13.804Z | 2024-11-09T14:24:27.682Z |
5451930 | 5451930 | 20241101012917_3RPZb | CZ000F | 2024-11-02T12:18:06.801Z | 2024-11-09T14:24:26.904Z |
5450294 | 5450294 | 20241031183455_vWlrZ | CZ000F | 2024-11-02T12:14:54.413Z | 2024-11-09T14:24:15.081Z |
5450219 | 5450219 | 20241031181845_xaubw | CZ000F | 2024-11-02T12:14:48.181Z | 2024-11-09T14:24:14.809Z |
5444409 | 5444409 | 20241031011726_PN20P | CZ000F | 2024-11-01T12:21:16.570Z | 2024-11-08T14:23:15.364Z |
5443682 | 5443682 | 20241031000455_3Eegi | CZ000F | 2024-11-01T12:20:45.938Z | 2024-11-08T14:23:11.980Z |
5443241 | 5443241 | 20241030041517_VD69F | CZ000F | 2024-11-01T12:20:24.496Z | 2024-11-07T14:26:50.154Z |
5443181 | 5443181 | 20241030035221_tvDLa | CZ000F | 2024-11-01T12:20:21.136Z | 2024-11-07T14:26:49.988Z |
5443154 | 5443154 | 20241030034243_QBxWO | CZ000F | 2024-11-01T12:20:19.680Z | 2024-11-07T14:26:49.791Z |
5443152 | 5443152 | 20241030034227_lIrsi | CZ000F | 2024-11-01T12:20:19.578Z | 2024-11-07T14:26:49.787Z |
5443001 | 5443001 | 20241030031040_0ahFi | CZ000F | 2024-11-01T12:20:15.398Z | 2024-11-07T14:26:49.251Z |
5442972 | 5442972 | 20241030030800_6Zp3Y | CZ000F | 2024-11-01T12:20:14.770Z | 2024-11-07T14:26:49.089Z |
5442856 | 5442856 | 20241030024515_NHBWv | CZ000F | 2024-11-01T12:20:10.959Z | 2024-11-07T14:26:48.630Z |
5442824 | 5442824 | 20241030023817_R598e | CZ000F | 2024-11-01T12:20:09.861Z | 2024-11-07T14:26:48.503Z |
5442743 | 5442743 | 20241030022646_bXqXr | CZ000F | 2024-11-01T12:20:07.200Z | 2024-11-07T14:26:48.101Z |
5442736 | 5442736 | 20241030022531_Uma2h | CZ000F | 2024-11-01T12:20:06.947Z | 2024-11-07T14:26:48.098Z |
5442717 | 5442717 | 20241030022115_crjIp | CZ000F | 2024-11-01T12:20:06.441Z | 2024-11-07T14:26:47.782Z |
5442637 | 5442637 | 20241030020753_r1Yh6 | CZ000F | 2024-11-01T12:20:03.848Z | 2024-11-07T14:26:47.244Z |
5442611 | 5442611 | 20241030020341_YfDPR | CZ000F | 2024-11-01T12:20:03.218Z | 2024-11-07T14:26:47.172Z |
5442291 | 5442291 | 20241030010924_nn9ZY | CZ000F | 2024-11-01T12:19:40.038Z | 2024-11-07T14:26:46.016Z |
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);