participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,786 rows where station_code = "CZ000C" 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 |
---|---|---|---|---|---|
5570770 | 5570770 | 20241120205349_ELE9Q | CZ000C | 2024-11-22T14:16:04.720Z | 2024-11-22T14:19:21.978Z |
5570604 | 5570604 | 20241120202350_39GRj | CZ000C | 2024-11-22T14:15:53.389Z | 2024-11-22T14:19:21.947Z |
5570173 | 5570173 | 20241120185608_3BAli | CZ000C | 2024-11-22T14:14:57.432Z | 2024-11-22T14:19:21.875Z |
5570114 | 5570114 | 20241120184354_pZXTO | CZ000C | 2024-11-22T14:14:53.074Z | 2024-11-22T14:19:21.864Z |
5553714 | 5553714 | 20241118035633_mp3c8 | CZ000C | 2024-11-19T14:11:19.948Z | 2024-11-22T14:22:55.679Z |
5553653 | 5553653 | 20241118034048_tCI3U | CZ000C | 2024-11-19T14:11:10.135Z | 2024-11-22T14:22:55.099Z |
5553641 | 5553641 | 20241118033942_kMYhE | CZ000C | 2024-11-19T14:11:08.073Z | 2024-11-22T14:22:55.015Z |
5553635 | 5553635 | 20241118033759_PCE7p | CZ000C | 2024-11-19T14:11:07.256Z | 2024-11-22T14:22:54.951Z |
5553633 | 5553633 | 20241118033735_DtCFA | CZ000C | 2024-11-19T14:11:07.144Z | 2024-11-22T14:22:54.947Z |
5517714 | 5517714 | 20241110043526_2Y724 | CZ000C | 2024-11-11T14:14:46.504Z | 2024-11-18T14:26:37.959Z |
5517552 | 5517552 | 20241110040154_Y9V2Z | CZ000C | 2024-11-11T14:14:34.778Z | 2024-11-18T14:26:37.127Z |
5517486 | 5517486 | 20241110035346_naUQn | CZ000C | 2024-11-11T14:14:29.550Z | 2024-11-18T14:26:36.760Z |
5517407 | 5517407 | 20241110033933_mgSGb | CZ000C | 2024-11-11T14:14:22.221Z | 2024-11-18T14:26:36.338Z |
5517389 | 5517389 | 20241110033730_93QXI | CZ000C | 2024-11-11T14:14:20.858Z | 2024-11-18T14:26:36.246Z |
5517317 | 5517317 | 20241110032404_ADKCA | CZ000C | 2024-11-11T14:14:14.115Z | 2024-11-18T14:26:35.875Z |
5517315 | 5517315 | 20241110032314_yLMrk | CZ000C | 2024-11-11T14:14:13.958Z | 2024-11-18T14:26:35.870Z |
5517304 | 5517304 | 20241110032139_plloL | CZ000C | 2024-11-11T14:14:13.260Z | 2024-11-18T14:26:35.821Z |
5517299 | 5517299 | 20241110032033_QPUPg | CZ000C | 2024-11-11T14:14:12.774Z | 2024-11-18T14:26:35.816Z |
5517252 | 5517252 | 20241110031447_zZqOR | CZ000C | 2024-11-11T14:14:09.951Z | 2024-11-18T14:26:35.651Z |
5517231 | 5517231 | 20241110030750_N3vec | CZ000C | 2024-11-11T14:14:07.571Z | 2024-11-18T14:26:35.460Z |
5517106 | 5517106 | 20241110024836_3HRh5 | CZ000C | 2024-11-11T14:13:54.860Z | 2024-11-18T14:26:34.769Z |
5516963 | 5516963 | 20241110022725_Z2xi8 | CZ000C | 2024-11-11T14:13:38.899Z | 2024-11-18T14:26:34.019Z |
5516794 | 5516794 | 20241110020422_3dyZL | CZ000C | 2024-11-11T14:13:22.507Z | 2024-11-18T14:26:33.330Z |
5516780 | 5516780 | 20241110020025_sW2wG | CZ000C | 2024-11-11T14:13:20.852Z | 2024-11-18T14:26:33.241Z |
5516727 | 5516727 | 20241110015021_ueEr2 | CZ000C | 2024-11-11T14:13:17.243Z | 2024-11-18T14:26:33.013Z |
5516527 | 5516527 | 20241110011219_7X79Y | CZ000C | 2024-11-11T14:13:06.582Z | 2024-11-18T14:26:31.708Z |
5516521 | 5516521 | 20241110011138_2XSyb | CZ000C | 2024-11-11T14:13:06.192Z | 2024-11-18T14:26:31.687Z |
5516425 | 5516425 | 20241110005826_oj2M1 | CZ000C | 2024-11-11T14:13:00.538Z | 2024-11-18T14:26:31.177Z |
5516423 | 5516423 | 20241110005714_bwf4I | CZ000C | 2024-11-11T14:13:00.286Z | 2024-11-18T14:26:31.148Z |
5516330 | 5516330 | 20241110004052_utxHn | CZ000C | 2024-11-11T14:12:46.028Z | 2024-11-18T14:26:30.698Z |
5516321 | 5516321 | 20241110003959_gnlAb | CZ000C | 2024-11-11T14:12:44.121Z | 2024-11-18T14:26:30.675Z |
5516254 | 5516254 | 20241110002236_tZ3Db | CZ000C | 2024-11-11T14:12:35.635Z | 2024-11-18T14:26:30.329Z |
5516150 | 5516150 | 20241110000020_7MQFs | CZ000C | 2024-11-11T14:12:20.558Z | 2024-11-18T14:26:29.835Z |
5516067 | 5516067 | 20241109234507_bNXEm | CZ000C | 2024-11-11T14:12:07.056Z | 2024-11-18T14:26:29.242Z |
5515979 | 5515979 | 20241109232356_GlJAw | CZ000C | 2024-11-11T14:11:52.607Z | 2024-11-18T14:26:28.776Z |
5515975 | 5515975 | 20241109232302_RxGpj | CZ000C | 2024-11-11T14:11:52.183Z | 2024-11-18T14:26:28.764Z |
5515971 | 5515971 | 20241109232139_u1muB | CZ000C | 2024-11-11T14:11:51.800Z | 2024-11-18T14:26:28.726Z |
5515838 | 5515838 | 20241109225502_qA96N | CZ000C | 2024-11-11T14:11:36.252Z | 2024-11-18T14:26:28.154Z |
5515810 | 5515810 | 20241109224831_C9mkN | CZ000C | 2024-11-11T14:11:31.653Z | 2024-11-18T14:26:28.062Z |
5515632 | 5515632 | 20241109221208_QF0TD | CZ000C | 2024-11-11T14:11:18.453Z | 2024-11-18T14:26:27.162Z |
5515603 | 5515603 | 20241109220754_p2Nfm | CZ000C | 2024-11-11T14:11:16.777Z | 2024-11-18T14:26:27.020Z |
5515516 | 5515516 | 20241109214539_9aPyW | CZ000C | 2024-11-11T14:11:10.421Z | 2024-11-18T14:26:26.523Z |
5515485 | 5515485 | 20241109213743_4DCon | CZ000C | 2024-11-11T14:11:07.727Z | 2024-11-18T14:26:26.269Z |
5515423 | 5515423 | 20241109212103_dbWQd | CZ000C | 2024-11-11T14:11:02.609Z | 2024-11-18T14:26:25.952Z |
5515410 | 5515410 | 20241109211531_9Ne6N | CZ000C | 2024-11-11T14:10:59.348Z | 2024-11-18T14:26:25.905Z |
5515402 | 5515402 | 20241109211017_Hkeq7 | CZ000C | 2024-11-11T14:10:57.488Z | 2024-11-18T14:26:25.854Z |
5515385 | 5515385 | 20241109210608_wvGf1 | CZ000C | 2024-11-11T14:10:53.044Z | 2024-11-18T14:26:25.789Z |
5515253 | 5515253 | 20241109200652_4hjYS | CZ000C | 2024-11-11T14:10:28.069Z | 2024-11-18T14:26:25.130Z |
5515206 | 5515206 | 20241109195247_XJUxC | CZ000C | 2024-11-11T14:10:20.670Z | 2024-11-18T14:26:24.920Z |
5515150 | 5515150 | 20241109194115_Lv0TR | CZ000C | 2024-11-11T14:10:11.491Z | 2024-11-18T14:26:24.556Z |
5515148 | 5515148 | 20241109194107_Bh4R3 | CZ000C | 2024-11-11T14:10:11.054Z | 2024-11-18T14:26:24.547Z |
5515028 | 5515028 | 20241109190451_stjMH | CZ000C | 2024-11-11T14:09:55.394Z | 2024-11-18T14:26:23.925Z |
5514897 | 5514897 | 20241109182525_FJSrh | CZ000C | 2024-11-11T14:09:42.092Z | 2024-11-18T14:26:23.178Z |
5514781 | 5514781 | 20241109173036_vdne2 | CZ000C | 2024-11-11T14:09:13.276Z | 2024-11-18T14:26:22.441Z |
5514719 | 5514719 | 20241109170628_3OkIX | CZ000C | 2024-11-11T14:09:04.093Z | 2024-11-18T14:26:22.112Z |
5511123 | 5511123 | 20241109043416_uxXWe | CZ000C | 2024-11-10T14:16:18.264Z | 2024-11-17T14:24:05.412Z |
5511010 | 5511010 | 20241109040733_RNXp3 | CZ000C | 2024-11-10T14:16:03.607Z | 2024-11-17T14:24:03.346Z |
5511008 | 5511008 | 20241109040732_sgYqG | CZ000C | 2024-11-10T14:16:03.475Z | 2024-11-17T14:24:03.328Z |
5510997 | 5510997 | 20241109040524_lpML5 | CZ000C | 2024-11-10T14:16:02.456Z | 2024-11-17T14:24:03.254Z |
5510849 | 5510849 | 20241109034429_8xDE9 | CZ000C | 2024-11-10T14:15:46.260Z | 2024-11-17T14:24:01.766Z |
5510773 | 5510773 | 20241109033533_FhHUN | CZ000C | 2024-11-10T14:15:41.347Z | 2024-11-17T14:24:01.244Z |
5510756 | 5510756 | 20241109033300_iiTiN | CZ000C | 2024-11-10T14:15:38.789Z | 2024-11-17T14:24:00.951Z |
5510728 | 5510728 | 20241109033008_DNuv0 | CZ000C | 2024-11-10T14:15:36.376Z | 2024-11-17T14:24:00.681Z |
5510527 | 5510527 | 20241109025459_3XVUW | CZ000C | 2024-11-10T14:15:24.825Z | 2024-11-17T14:23:58.583Z |
5510434 | 5510434 | 20241109024106_k7XtY | CZ000C | 2024-11-10T14:15:13.920Z | 2024-11-17T14:23:57.419Z |
5510408 | 5510408 | 20241109023730_FWrsF | CZ000C | 2024-11-10T14:15:10.178Z | 2024-11-17T14:23:57.108Z |
5510326 | 5510326 | 20241109022137_iRT5y | CZ000C | 2024-11-10T14:15:01.603Z | 2024-11-17T14:23:56.265Z |
5510273 | 5510273 | 20241109021444_xDM5Y | CZ000C | 2024-11-10T14:14:56.298Z | 2024-11-17T14:23:55.570Z |
5510110 | 5510110 | 20241109014340_MG1wl | CZ000C | 2024-11-10T14:14:36.273Z | 2024-11-17T14:23:53.043Z |
5510075 | 5510075 | 20241109013926_2SpoL | CZ000C | 2024-11-10T14:14:32.947Z | 2024-11-17T14:23:52.767Z |
5509973 | 5509973 | 20241109011841_R1R5V | CZ000C | 2024-11-10T14:14:20.852Z | 2024-11-17T14:23:51.449Z |
5509826 | 5509826 | 20241109004733_yRJSp | CZ000C | 2024-11-10T14:14:04.519Z | 2024-11-17T14:23:49.630Z |
5509555 | 5509555 | 20241108234447_76GS0 | CZ000C | 2024-11-10T14:13:34.705Z | 2024-11-17T14:23:46.818Z |
5509544 | 5509544 | 20241108234330_QErGB | CZ000C | 2024-11-10T14:13:33.524Z | 2024-11-17T14:23:46.724Z |
5509200 | 5509200 | 20241108222408_fKlrB | CZ000C | 2024-11-10T14:12:52.906Z | 2024-11-17T14:23:41.449Z |
5504623 | 5504623 | 20241108022616_OTlzB | CZ000C | 2024-11-09T14:14:57.746Z | 2024-11-16T14:28:21.787Z |
5504077 | 5504077 | 20241108005016_vzkQd | CZ000C | 2024-11-09T14:14:02.985Z | 2024-11-16T14:28:15.719Z |
5503986 | 5503986 | 20241108003354_GUH9T | CZ000C | 2024-11-09T14:13:56.893Z | 2024-11-16T14:28:14.644Z |
5503733 | 5503733 | 20241107234106_TTgvD | CZ000C | 2024-11-09T14:13:41.515Z | 2024-11-16T14:28:11.842Z |
5503701 | 5503701 | 20241107233253_6pRz2 | CZ000C | 2024-11-09T14:13:38.391Z | 2024-11-16T14:28:11.627Z |
5503359 | 5503359 | 20241107215509_uuKp4 | CZ000C | 2024-11-09T14:12:53.760Z | 2024-11-16T14:28:06.700Z |
5502051 | 5502051 | 20241107170033_IEi2n | CZ000C | 2024-11-09T14:10:52.423Z | 2024-11-16T14:27:49.758Z |
5501936 | 5501936 | 20241107164249_yQcOm | CZ000C | 2024-11-09T14:10:46.587Z | 2024-11-16T14:27:49.160Z |
5491186 | 5491186 | 20241106021832_RsxfM | CZ000C | 2024-11-07T14:15:25.290Z | 2024-11-14T14:23:24.387Z |
5491096 | 5491096 | 20241106015501_XhpHO | CZ000C | 2024-11-07T14:15:18.692Z | 2024-11-14T14:23:23.724Z |
5490671 | 5490671 | 20241106000217_yuiF5 | CZ000C | 2024-11-07T14:14:27.782Z | 2024-11-14T14:23:21.184Z |
5490631 | 5490631 | 20241105234758_U8aSY | CZ000C | 2024-11-07T14:14:20.309Z | 2024-11-14T14:23:21.032Z |
5490451 | 5490451 | 20241105225350_AuVmb | CZ000C | 2024-11-07T14:14:03.011Z | 2024-11-14T14:23:20.365Z |
5490390 | 5490390 | 20241105223341_mmQGZ | CZ000C | 2024-11-07T14:13:58.077Z | 2024-11-14T14:23:19.292Z |
5490357 | 5490357 | 20241105222156_3vYIR | CZ000C | 2024-11-07T14:13:55.258Z | 2024-11-14T14:23:19.131Z |
5490254 | 5490254 | 20241105214835_NATrX | CZ000C | 2024-11-07T14:13:45.698Z | 2024-11-14T14:23:18.400Z |
5490251 | 5490251 | 20241105214736_uu3qQ | CZ000C | 2024-11-07T14:13:44.897Z | 2024-11-14T14:23:18.398Z |
5490093 | 5490093 | 20241105205704_RYv3z | CZ000C | 2024-11-07T14:13:10.617Z | 2024-11-14T14:23:17.501Z |
5485063 | 5485063 | 20241105040024_w0SZr | CZ000C | 2024-11-06T14:17:43.130Z | 2024-11-13T14:27:40.594Z |
5484901 | 5484901 | 20241105033911_7WeZu | CZ000C | 2024-11-06T14:17:27.655Z | 2024-11-13T14:27:40.058Z |
5484683 | 5484683 | 20241105031953_LVdAu | CZ000C | 2024-11-06T14:17:09.737Z | 2024-11-13T14:27:39.331Z |
5484649 | 5484649 | 20241105031712_Efe3X | CZ000C | 2024-11-06T14:17:08.041Z | 2024-11-13T14:27:38.998Z |
5484501 | 5484501 | 20241105025809_NP7LZ | CZ000C | 2024-11-06T14:16:58.390Z | 2024-11-13T14:27:38.435Z |
5484398 | 5484398 | 20241105024506_gEfBX | CZ000C | 2024-11-06T14:16:52.690Z | 2024-11-13T14:27:37.839Z |
5484291 | 5484291 | 20241105023146_EyWZk | CZ000C | 2024-11-06T14:16:46.161Z | 2024-11-13T14:27:37.655Z |
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);