participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,777 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 |
---|---|---|---|---|---|
5517714 | 5517714 | 20241110043526_2Y724 | CZ000C | 2024-11-11T14:14:46.504Z | 2024-11-12T14:21:52.738Z |
5517552 | 5517552 | 20241110040154_Y9V2Z | CZ000C | 2024-11-11T14:14:34.778Z | 2024-11-12T14:21:46.589Z |
5517486 | 5517486 | 20241110035346_naUQn | CZ000C | 2024-11-11T14:14:29.550Z | 2024-11-12T14:21:43.812Z |
5517407 | 5517407 | 20241110033933_mgSGb | CZ000C | 2024-11-11T14:14:22.221Z | 2024-11-12T14:21:40.886Z |
5517389 | 5517389 | 20241110033730_93QXI | CZ000C | 2024-11-11T14:14:20.858Z | 2024-11-12T14:21:40.303Z |
5517317 | 5517317 | 20241110032404_ADKCA | CZ000C | 2024-11-11T14:14:14.115Z | 2024-11-12T14:21:37.675Z |
5517315 | 5517315 | 20241110032314_yLMrk | CZ000C | 2024-11-11T14:14:13.958Z | 2024-11-12T14:21:37.608Z |
5517304 | 5517304 | 20241110032139_plloL | CZ000C | 2024-11-11T14:14:13.260Z | 2024-11-12T14:21:37.279Z |
5517299 | 5517299 | 20241110032033_QPUPg | CZ000C | 2024-11-11T14:14:12.774Z | 2024-11-12T14:21:37.208Z |
5517252 | 5517252 | 20241110031447_zZqOR | CZ000C | 2024-11-11T14:14:09.951Z | 2024-11-12T14:21:36.276Z |
5517231 | 5517231 | 20241110030750_N3vec | CZ000C | 2024-11-11T14:14:07.571Z | 2024-11-12T14:21:35.518Z |
5517106 | 5517106 | 20241110024836_3HRh5 | CZ000C | 2024-11-11T14:13:54.860Z | 2024-11-12T14:21:31.889Z |
5516963 | 5516963 | 20241110022725_Z2xi8 | CZ000C | 2024-11-11T14:13:38.899Z | 2024-11-12T14:21:25.339Z |
5516794 | 5516794 | 20241110020422_3dyZL | CZ000C | 2024-11-11T14:13:22.507Z | 2024-11-12T14:21:20.151Z |
5516780 | 5516780 | 20241110020025_sW2wG | CZ000C | 2024-11-11T14:13:20.852Z | 2024-11-12T14:21:19.793Z |
5516727 | 5516727 | 20241110015021_ueEr2 | CZ000C | 2024-11-11T14:13:17.243Z | 2024-11-12T14:21:17.349Z |
5516527 | 5516527 | 20241110011219_7X79Y | CZ000C | 2024-11-11T14:13:06.582Z | 2024-11-12T14:21:09.581Z |
5516521 | 5516521 | 20241110011138_2XSyb | CZ000C | 2024-11-11T14:13:06.192Z | 2024-11-12T14:21:08.749Z |
5516425 | 5516425 | 20241110005826_oj2M1 | CZ000C | 2024-11-11T14:13:00.538Z | 2024-11-12T14:21:04.920Z |
5516423 | 5516423 | 20241110005714_bwf4I | CZ000C | 2024-11-11T14:13:00.286Z | 2024-11-12T14:21:04.835Z |
5516330 | 5516330 | 20241110004052_utxHn | CZ000C | 2024-11-11T14:12:46.028Z | 2024-11-12T14:21:00.723Z |
5516321 | 5516321 | 20241110003959_gnlAb | CZ000C | 2024-11-11T14:12:44.121Z | 2024-11-12T14:21:00.157Z |
5516254 | 5516254 | 20241110002236_tZ3Db | CZ000C | 2024-11-11T14:12:35.635Z | 2024-11-12T14:20:56.142Z |
5516150 | 5516150 | 20241110000020_7MQFs | CZ000C | 2024-11-11T14:12:20.558Z | 2024-11-12T14:20:51.709Z |
5516067 | 5516067 | 20241109234507_bNXEm | CZ000C | 2024-11-11T14:12:07.056Z | 2024-11-12T14:20:48.600Z |
5515979 | 5515979 | 20241109232356_GlJAw | CZ000C | 2024-11-11T14:11:52.607Z | 2024-11-12T14:20:45.546Z |
5515975 | 5515975 | 20241109232302_RxGpj | CZ000C | 2024-11-11T14:11:52.183Z | 2024-11-12T14:20:45.409Z |
5515971 | 5515971 | 20241109232139_u1muB | CZ000C | 2024-11-11T14:11:51.800Z | 2024-11-12T14:20:45.302Z |
5515838 | 5515838 | 20241109225502_qA96N | CZ000C | 2024-11-11T14:11:36.252Z | 2024-11-12T14:20:40.715Z |
5515810 | 5515810 | 20241109224831_C9mkN | CZ000C | 2024-11-11T14:11:31.653Z | 2024-11-12T14:20:39.685Z |
5515632 | 5515632 | 20241109221208_QF0TD | CZ000C | 2024-11-11T14:11:18.453Z | 2024-11-12T14:20:30.693Z |
5515603 | 5515603 | 20241109220754_p2Nfm | CZ000C | 2024-11-11T14:11:16.777Z | 2024-11-12T14:20:29.950Z |
5515516 | 5515516 | 20241109214539_9aPyW | CZ000C | 2024-11-11T14:11:10.421Z | 2024-11-12T14:20:24.991Z |
5515485 | 5515485 | 20241109213743_4DCon | CZ000C | 2024-11-11T14:11:07.727Z | 2024-11-12T14:20:23.836Z |
5515423 | 5515423 | 20241109212103_dbWQd | CZ000C | 2024-11-11T14:11:02.609Z | 2024-11-12T14:20:21.878Z |
5515410 | 5515410 | 20241109211531_9Ne6N | CZ000C | 2024-11-11T14:10:59.348Z | 2024-11-12T14:20:21.492Z |
5515402 | 5515402 | 20241109211017_Hkeq7 | CZ000C | 2024-11-11T14:10:57.488Z | 2024-11-12T14:20:21.082Z |
5515385 | 5515385 | 20241109210608_wvGf1 | CZ000C | 2024-11-11T14:10:53.044Z | 2024-11-12T14:20:20.682Z |
5515253 | 5515253 | 20241109200652_4hjYS | CZ000C | 2024-11-11T14:10:28.069Z | 2024-11-12T14:20:14.731Z |
5515206 | 5515206 | 20241109195247_XJUxC | CZ000C | 2024-11-11T14:10:20.670Z | 2024-11-12T14:20:13.196Z |
5515150 | 5515150 | 20241109194115_Lv0TR | CZ000C | 2024-11-11T14:10:11.491Z | 2024-11-12T14:20:10.614Z |
5515148 | 5515148 | 20241109194107_Bh4R3 | CZ000C | 2024-11-11T14:10:11.054Z | 2024-11-12T14:20:10.522Z |
5515028 | 5515028 | 20241109190451_stjMH | CZ000C | 2024-11-11T14:09:55.394Z | 2024-11-12T14:20:04.233Z |
5514897 | 5514897 | 20241109182525_FJSrh | CZ000C | 2024-11-11T14:09:42.092Z | 2024-11-12T14:19:55.708Z |
5514781 | 5514781 | 20241109173036_vdne2 | CZ000C | 2024-11-11T14:09:13.276Z | 2024-11-12T14:19:47.307Z |
5514719 | 5514719 | 20241109170628_3OkIX | CZ000C | 2024-11-11T14:09:04.093Z | 2024-11-12T14:19:44.167Z |
5511123 | 5511123 | 20241109043416_uxXWe | CZ000C | 2024-11-10T14:16:18.264Z | 2024-11-12T14:23:45.306Z |
5511010 | 5511010 | 20241109040733_RNXp3 | CZ000C | 2024-11-10T14:16:03.607Z | 2024-11-12T14:23:43.166Z |
5511008 | 5511008 | 20241109040732_sgYqG | CZ000C | 2024-11-10T14:16:03.475Z | 2024-11-12T14:23:43.156Z |
5510997 | 5510997 | 20241109040524_lpML5 | CZ000C | 2024-11-10T14:16:02.456Z | 2024-11-12T14:23:43.082Z |
5510849 | 5510849 | 20241109034429_8xDE9 | CZ000C | 2024-11-10T14:15:46.260Z | 2024-11-12T14:23:41.632Z |
5510773 | 5510773 | 20241109033533_FhHUN | CZ000C | 2024-11-10T14:15:41.347Z | 2024-11-12T14:23:40.752Z |
5510756 | 5510756 | 20241109033300_iiTiN | CZ000C | 2024-11-10T14:15:38.789Z | 2024-11-12T14:23:40.476Z |
5510728 | 5510728 | 20241109033008_DNuv0 | CZ000C | 2024-11-10T14:15:36.376Z | 2024-11-12T14:23:39.922Z |
5510527 | 5510527 | 20241109025459_3XVUW | CZ000C | 2024-11-10T14:15:24.825Z | 2024-11-12T14:23:37.518Z |
5510434 | 5510434 | 20241109024106_k7XtY | CZ000C | 2024-11-10T14:15:13.920Z | 2024-11-12T14:23:36.256Z |
5510408 | 5510408 | 20241109023730_FWrsF | CZ000C | 2024-11-10T14:15:10.178Z | 2024-11-12T14:23:35.758Z |
5510326 | 5510326 | 20241109022137_iRT5y | CZ000C | 2024-11-10T14:15:01.603Z | 2024-11-12T14:23:34.427Z |
5510273 | 5510273 | 20241109021444_xDM5Y | CZ000C | 2024-11-10T14:14:56.298Z | 2024-11-12T14:23:33.562Z |
5510110 | 5510110 | 20241109014340_MG1wl | CZ000C | 2024-11-10T14:14:36.273Z | 2024-11-12T14:23:30.243Z |
5510075 | 5510075 | 20241109013926_2SpoL | CZ000C | 2024-11-10T14:14:32.947Z | 2024-11-12T14:23:29.957Z |
5509973 | 5509973 | 20241109011841_R1R5V | CZ000C | 2024-11-10T14:14:20.852Z | 2024-11-12T14:23:28.189Z |
5509826 | 5509826 | 20241109004733_yRJSp | CZ000C | 2024-11-10T14:14:04.519Z | 2024-11-12T14:23:25.758Z |
5509555 | 5509555 | 20241108234447_76GS0 | CZ000C | 2024-11-10T14:13:34.705Z | 2024-11-12T14:23:21.733Z |
5509544 | 5509544 | 20241108234330_QErGB | CZ000C | 2024-11-10T14:13:33.524Z | 2024-11-12T14:23:21.665Z |
5509200 | 5509200 | 20241108222408_fKlrB | CZ000C | 2024-11-10T14:12:52.906Z | 2024-11-12T14:23:15.211Z |
5504623 | 5504623 | 20241108022616_OTlzB | CZ000C | 2024-11-09T14:14:57.746Z | 2024-11-12T14:25:05.641Z |
5504077 | 5504077 | 20241108005016_vzkQd | CZ000C | 2024-11-09T14:14:02.985Z | 2024-11-12T14:24:57.163Z |
5503986 | 5503986 | 20241108003354_GUH9T | CZ000C | 2024-11-09T14:13:56.893Z | 2024-11-12T14:24:55.229Z |
5503733 | 5503733 | 20241107234106_TTgvD | CZ000C | 2024-11-09T14:13:41.515Z | 2024-11-12T14:24:51.404Z |
5503701 | 5503701 | 20241107233253_6pRz2 | CZ000C | 2024-11-09T14:13:38.391Z | 2024-11-12T14:24:51.113Z |
5503359 | 5503359 | 20241107215509_uuKp4 | CZ000C | 2024-11-09T14:12:53.760Z | 2024-11-12T14:24:46.507Z |
5502051 | 5502051 | 20241107170033_IEi2n | CZ000C | 2024-11-09T14:10:52.423Z | 2024-11-12T14:24:27.600Z |
5501936 | 5501936 | 20241107164249_yQcOm | CZ000C | 2024-11-09T14:10:46.587Z | 2024-11-12T14:24:26.194Z |
5491186 | 5491186 | 20241106021832_RsxfM | CZ000C | 2024-11-07T14:15:25.290Z | 2024-11-12T14:26:53.400Z |
5491096 | 5491096 | 20241106015501_XhpHO | CZ000C | 2024-11-07T14:15:18.692Z | 2024-11-12T14:26:53.089Z |
5490671 | 5490671 | 20241106000217_yuiF5 | CZ000C | 2024-11-07T14:14:27.782Z | 2024-11-12T14:26:50.544Z |
5490631 | 5490631 | 20241105234758_U8aSY | CZ000C | 2024-11-07T14:14:20.309Z | 2024-11-12T14:26:50.146Z |
5490451 | 5490451 | 20241105225350_AuVmb | CZ000C | 2024-11-07T14:14:03.011Z | 2024-11-12T14:26:48.496Z |
5490390 | 5490390 | 20241105223341_mmQGZ | CZ000C | 2024-11-07T14:13:58.077Z | 2024-11-12T14:26:48.152Z |
5490357 | 5490357 | 20241105222156_3vYIR | CZ000C | 2024-11-07T14:13:55.258Z | 2024-11-12T14:26:47.893Z |
5490254 | 5490254 | 20241105214835_NATrX | CZ000C | 2024-11-07T14:13:45.698Z | 2024-11-12T14:26:47.476Z |
5490251 | 5490251 | 20241105214736_uu3qQ | CZ000C | 2024-11-07T14:13:44.897Z | 2024-11-12T14:26:47.475Z |
5490093 | 5490093 | 20241105205704_RYv3z | CZ000C | 2024-11-07T14:13:10.617Z | 2024-11-12T14:26:46.230Z |
5485063 | 5485063 | 20241105040024_w0SZr | CZ000C | 2024-11-06T14:17:43.130Z | 2024-11-12T14:27:36.583Z |
5484901 | 5484901 | 20241105033911_7WeZu | CZ000C | 2024-11-06T14:17:27.655Z | 2024-11-12T14:27:35.812Z |
5484683 | 5484683 | 20241105031953_LVdAu | CZ000C | 2024-11-06T14:17:09.737Z | 2024-11-12T14:27:35.206Z |
5484649 | 5484649 | 20241105031712_Efe3X | CZ000C | 2024-11-06T14:17:08.041Z | 2024-11-12T14:27:35.084Z |
5484501 | 5484501 | 20241105025809_NP7LZ | CZ000C | 2024-11-06T14:16:58.390Z | 2024-11-12T14:27:34.459Z |
5484398 | 5484398 | 20241105024506_gEfBX | CZ000C | 2024-11-06T14:16:52.690Z | 2024-11-12T14:27:33.711Z |
5484291 | 5484291 | 20241105023146_EyWZk | CZ000C | 2024-11-06T14:16:46.161Z | 2024-11-12T14:27:33.276Z |
5484236 | 5484236 | 20241105022309_0TA9u | CZ000C | 2024-11-06T14:16:36.865Z | 2024-11-12T14:27:32.857Z |
5484112 | 5484112 | 20241105021023_QPa8p | CZ000C | 2024-11-06T14:16:18.462Z | 2024-11-12T14:27:32.070Z |
5484108 | 5484108 | 20241105021015_8g7KX | CZ000C | 2024-11-06T14:16:17.526Z | 2024-11-12T14:27:32.031Z |
5483933 | 5483933 | 20241105014634_Rttq2 | CZ000C | 2024-11-06T14:15:56.081Z | 2024-11-12T14:27:30.721Z |
5475975 | 5475975 | 20241103220300_1D3m2 | CZ000C | 2024-11-05T14:14:36.889Z | 2024-11-12T14:28:01.992Z |
5475947 | 5475947 | 20241103215931_GBrUu | CZ000C | 2024-11-05T14:14:35.313Z | 2024-11-12T14:28:01.880Z |
5475883 | 5475883 | 20241103214505_A4lV2 | CZ000C | 2024-11-05T14:14:29.754Z | 2024-11-12T14:28:01.732Z |
5475822 | 5475822 | 20241103213043_7Hg6Q | CZ000C | 2024-11-05T14:14:18.728Z | 2024-11-12T14:28:01.158Z |
5475724 | 5475724 | 20241103210938_yl1LF | CZ000C | 2024-11-05T14:14:03.522Z | 2024-11-12T14:28:00.733Z |
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);