participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,045 rows where station_code = "CZ000P" 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 |
---|---|---|---|---|---|
5569730 | 5569730 | 20241120164547_ckaHF | CZ000P | 2024-11-22T14:13:58.896Z | 2024-11-23T14:22:50.312Z |
5553466 | 5553466 | 20241118024804_2RW2H | CZ000P | 2024-11-19T14:10:38.427Z | 2024-11-23T14:25:29.826Z |
5517767 | 5517767 | 20241110044716_GfrYk | CZ000P | 2024-11-11T14:14:50.738Z | 2024-11-18T14:26:38.128Z |
5517686 | 5517686 | 20241110042956_KUpMN | CZ000P | 2024-11-11T14:14:44.697Z | 2024-11-18T14:26:37.817Z |
5517619 | 5517619 | 20241110041237_6Ym2B | CZ000P | 2024-11-11T14:14:40.516Z | 2024-11-18T14:26:37.440Z |
5517578 | 5517578 | 20241110040341_alriK | CZ000P | 2024-11-11T14:14:37.057Z | 2024-11-18T14:26:37.217Z |
5517430 | 5517430 | 20241110034318_oKjkj | CZ000P | 2024-11-11T14:14:23.613Z | 2024-11-18T14:26:36.419Z |
5517365 | 5517365 | 20241110033324_73f0v | CZ000P | 2024-11-11T14:14:18.692Z | 2024-11-18T14:26:36.154Z |
5517184 | 5517184 | 20241110030001_DbjU2 | CZ000P | 2024-11-11T14:14:02.236Z | 2024-11-18T14:26:35.172Z |
5517123 | 5517123 | 20241110025029_AGPn6 | CZ000P | 2024-11-11T14:13:56.763Z | 2024-11-18T14:26:34.796Z |
5517105 | 5517105 | 20241110024835_B24om | CZ000P | 2024-11-11T14:13:54.761Z | 2024-11-18T14:26:34.761Z |
5517007 | 5517007 | 20241110023203_YZiWY | CZ000P | 2024-11-11T14:13:42.396Z | 2024-11-18T14:26:34.192Z |
5516936 | 5516936 | 20241110022308_oYWk8 | CZ000P | 2024-11-11T14:13:34.008Z | 2024-11-18T14:26:33.915Z |
5516720 | 5516720 | 20241110014838_838N3 | CZ000P | 2024-11-11T14:13:16.747Z | 2024-11-18T14:26:32.987Z |
5516693 | 5516693 | 20241110014316_MRfVg | CZ000P | 2024-11-11T14:13:15.370Z | 2024-11-18T14:26:32.837Z |
5516650 | 5516650 | 20241110013359_bB20C | CZ000P | 2024-11-11T14:13:13.154Z | 2024-11-18T14:26:32.622Z |
5516514 | 5516514 | 20241110011052_BPFtG | CZ000P | 2024-11-11T14:13:05.727Z | 2024-11-18T14:26:31.617Z |
5516498 | 5516498 | 20241110010812_Nz1Zx | CZ000P | 2024-11-11T14:13:05.043Z | 2024-11-18T14:26:31.550Z |
5516485 | 5516485 | 20241110010630_ZgYdR | CZ000P | 2024-11-11T14:13:03.995Z | 2024-11-18T14:26:31.459Z |
5516431 | 5516431 | 20241110005844_BD3Ch | CZ000P | 2024-11-11T14:13:00.953Z | 2024-11-18T14:26:31.197Z |
5516422 | 5516422 | 20241110005629_B8vgG | CZ000P | 2024-11-11T14:13:00.172Z | 2024-11-18T14:26:31.144Z |
5516412 | 5516412 | 20241110005439_Rd6kV | CZ000P | 2024-11-11T14:12:59.463Z | 2024-11-18T14:26:31.080Z |
5516257 | 5516257 | 20241110002258_0lzZ9 | CZ000P | 2024-11-11T14:12:35.995Z | 2024-11-18T14:26:30.355Z |
5516199 | 5516199 | 20241110001221_GNUVw | CZ000P | 2024-11-11T14:12:26.735Z | 2024-11-18T14:26:30.063Z |
5516158 | 5516158 | 20241110000115_djEUo | CZ000P | 2024-11-11T14:12:21.029Z | 2024-11-18T14:26:29.860Z |
5516139 | 5516139 | 20241109235831_d3CNs | CZ000P | 2024-11-11T14:12:19.241Z | 2024-11-18T14:26:29.683Z |
5515957 | 5515957 | 20241109232014_dg3Yf | CZ000P | 2024-11-11T14:11:50.877Z | 2024-11-18T14:26:28.640Z |
5515938 | 5515938 | 20241109231528_2g2y9 | CZ000P | 2024-11-11T14:11:48.334Z | 2024-11-18T14:26:28.547Z |
5515903 | 5515903 | 20241109231023_GefIC | CZ000P | 2024-11-11T14:11:45.755Z | 2024-11-18T14:26:28.391Z |
5515768 | 5515768 | 20241109223812_P5nXh | CZ000P | 2024-11-11T14:11:27.207Z | 2024-11-18T14:26:27.861Z |
5515724 | 5515724 | 20241109223054_KKgDF | CZ000P | 2024-11-11T14:11:24.543Z | 2024-11-18T14:26:27.747Z |
5515719 | 5515719 | 20241109222955_9C2Fg | CZ000P | 2024-11-11T14:11:24.209Z | 2024-11-18T14:26:27.728Z |
5515671 | 5515671 | 20241109221824_sh3GR | CZ000P | 2024-11-11T14:11:20.670Z | 2024-11-18T14:26:27.343Z |
5515665 | 5515665 | 20241109221751_rtmxv | CZ000P | 2024-11-11T14:11:20.315Z | 2024-11-18T14:26:27.292Z |
5515579 | 5515579 | 20241109220337_B0iKl | CZ000P | 2024-11-11T14:11:14.574Z | 2024-11-18T14:26:26.848Z |
5515561 | 5515561 | 20241109215919_d2Air | CZ000P | 2024-11-11T14:11:13.439Z | 2024-11-18T14:26:26.744Z |
5515556 | 5515556 | 20241109215816_NTyHl | CZ000P | 2024-11-11T14:11:13.231Z | 2024-11-18T14:26:26.726Z |
5515506 | 5515506 | 20241109214021_XLv0z | CZ000P | 2024-11-11T14:11:09.154Z | 2024-11-18T14:26:26.413Z |
5515496 | 5515496 | 20241109213821_8k6n2 | CZ000P | 2024-11-11T14:11:08.329Z | 2024-11-18T14:26:26.329Z |
5515451 | 5515451 | 20241109212640_5IrF3 | CZ000P | 2024-11-11T14:11:05.788Z | 2024-11-18T14:26:26.103Z |
5515422 | 5515422 | 20241109212058_QmaXt | CZ000P | 2024-11-11T14:11:01.917Z | 2024-11-18T14:26:25.936Z |
5515393 | 5515393 | 20241109210630_PaPQP | CZ000P | 2024-11-11T14:10:53.936Z | 2024-11-18T14:26:25.814Z |
5515250 | 5515250 | 20241109200404_xEvQz | CZ000P | 2024-11-11T14:10:27.065Z | 2024-11-18T14:26:25.106Z |
5515241 | 5515241 | 20241109200051_7eusE | CZ000P | 2024-11-11T14:10:25.630Z | 2024-11-18T14:26:25.079Z |
5515134 | 5515134 | 20241109193159_GEzP1 | CZ000P | 2024-11-11T14:10:07.939Z | 2024-11-18T14:26:24.444Z |
5515119 | 5515119 | 20241109192737_sYbvT | CZ000P | 2024-11-11T14:10:06.234Z | 2024-11-18T14:26:24.372Z |
5514928 | 5514928 | 20241109183407_R3idM | CZ000P | 2024-11-11T14:09:44.907Z | 2024-11-18T14:26:23.379Z |
5514866 | 5514866 | 20241109180605_6qryC | CZ000P | 2024-11-11T14:09:37.160Z | 2024-11-18T14:26:22.924Z |
5514817 | 5514817 | 20241109174335_m82sX | CZ000P | 2024-11-11T14:09:20.650Z | 2024-11-18T14:26:22.666Z |
5511170 | 5511170 | 20241109045459_Vd9Vu | CZ000P | 2024-11-10T14:16:23.796Z | 2024-11-17T14:24:06.044Z |
5511082 | 5511082 | 20241109042137_yWZt0 | CZ000P | 2024-11-10T14:16:12.897Z | 2024-11-17T14:24:04.394Z |
5511038 | 5511038 | 20241109041049_Sw44q | CZ000P | 2024-11-10T14:16:06.756Z | 2024-11-17T14:24:03.628Z |
5511015 | 5511015 | 20241109040800_NgNwR | CZ000P | 2024-11-10T14:16:04.243Z | 2024-11-17T14:24:03.397Z |
5510996 | 5510996 | 20241109040446_Utobo | CZ000P | 2024-11-10T14:16:02.143Z | 2024-11-17T14:24:03.221Z |
5510700 | 5510700 | 20241109032723_NGImI | CZ000P | 2024-11-10T14:15:34.828Z | 2024-11-17T14:24:00.531Z |
5510691 | 5510691 | 20241109032658_RQj3v | CZ000P | 2024-11-10T14:15:34.468Z | 2024-11-17T14:24:00.394Z |
5510485 | 5510485 | 20241109024645_wqxw0 | CZ000P | 2024-11-10T14:15:21.526Z | 2024-11-17T14:23:58.227Z |
5510411 | 5510411 | 20241109023737_oPQof | CZ000P | 2024-11-10T14:15:10.435Z | 2024-11-17T14:23:57.144Z |
5510385 | 5510385 | 20241109023121_QH1kT | CZ000P | 2024-11-10T14:15:07.796Z | 2024-11-17T14:23:56.756Z |
5510245 | 5510245 | 20241109020536_BzpGv | CZ000P | 2024-11-10T14:14:51.363Z | 2024-11-17T14:23:54.540Z |
5510219 | 5510219 | 20241109020142_Q5vrW | CZ000P | 2024-11-10T14:14:48.872Z | 2024-11-17T14:23:54.299Z |
5510192 | 5510192 | 20241109015714_zfWTW | CZ000P | 2024-11-10T14:14:46.011Z | 2024-11-17T14:23:53.780Z |
5510070 | 5510070 | 20241109013852_R27EG | CZ000P | 2024-11-10T14:14:32.613Z | 2024-11-17T14:23:52.653Z |
5510041 | 5510041 | 20241109013251_9KfER | CZ000P | 2024-11-10T14:14:30.019Z | 2024-11-17T14:23:52.299Z |
5509953 | 5509953 | 20241109011540_3Jhm3 | CZ000P | 2024-11-10T14:14:19.264Z | 2024-11-17T14:23:51.370Z |
5509939 | 5509939 | 20241109011249_zFkhD | CZ000P | 2024-11-10T14:14:17.768Z | 2024-11-17T14:23:51.280Z |
5509887 | 5509887 | 20241109010403_msoTn | CZ000P | 2024-11-10T14:14:10.811Z | 2024-11-17T14:23:50.469Z |
5509847 | 5509847 | 20241109004958_p7es4 | CZ000P | 2024-11-10T14:14:06.720Z | 2024-11-17T14:23:49.988Z |
5509799 | 5509799 | 20241109003914_uJLvr | CZ000P | 2024-11-10T14:14:02.094Z | 2024-11-17T14:23:49.442Z |
5509730 | 5509730 | 20241109002427_tUzDg | CZ000P | 2024-11-10T14:13:54.735Z | 2024-11-17T14:23:48.623Z |
5509714 | 5509714 | 20241109001714_Mcg3O | CZ000P | 2024-11-10T14:13:53.435Z | 2024-11-17T14:23:48.519Z |
5509661 | 5509661 | 20241109000557_J2HkA | CZ000P | 2024-11-10T14:13:48.533Z | 2024-11-17T14:23:48.117Z |
5509567 | 5509567 | 20241108234710_2s4nd | CZ000P | 2024-11-10T14:13:35.579Z | 2024-11-17T14:23:46.899Z |
5509543 | 5509543 | 20241108234312_jE0ZB | CZ000P | 2024-11-10T14:13:33.230Z | 2024-11-17T14:23:46.709Z |
5509515 | 5509515 | 20241108233730_VBPRl | CZ000P | 2024-11-10T14:13:29.935Z | 2024-11-17T14:23:46.430Z |
5509506 | 5509506 | 20241108233402_y0gUs | CZ000P | 2024-11-10T14:13:28.586Z | 2024-11-17T14:23:46.266Z |
5509378 | 5509378 | 20241108230220_v9Wlc | CZ000P | 2024-11-10T14:13:17.027Z | 2024-11-17T14:23:43.737Z |
5509363 | 5509363 | 20241108225653_S76Ki | CZ000P | 2024-11-10T14:13:15.875Z | 2024-11-17T14:23:43.543Z |
5509337 | 5509337 | 20241108225308_C323u | CZ000P | 2024-11-10T14:13:13.290Z | 2024-11-17T14:23:43.213Z |
5509209 | 5509209 | 20241108222527_G1eyY | CZ000P | 2024-11-10T14:12:54.873Z | 2024-11-17T14:23:41.466Z |
5509099 | 5509099 | 20241108214950_hi1VL | CZ000P | 2024-11-10T14:12:33.147Z | 2024-11-17T14:23:40.245Z |
5509068 | 5509068 | 20241108214029_1O51Q | CZ000P | 2024-11-10T14:12:26.619Z | 2024-11-17T14:23:39.960Z |
5508897 | 5508897 | 20241108203048_NlrTX | CZ000P | 2024-11-10T14:12:00.776Z | 2024-11-17T14:23:36.167Z |
5508895 | 5508895 | 20241108203006_Aj2p1 | CZ000P | 2024-11-10T14:12:00.643Z | 2024-11-17T14:23:36.151Z |
5508886 | 5508886 | 20241108202050_e9K0n | CZ000P | 2024-11-10T14:11:59.857Z | 2024-11-17T14:23:35.992Z |
5508867 | 5508867 | 20241108201312_cZnf5 | CZ000P | 2024-11-10T14:11:58.285Z | 2024-11-17T14:23:35.740Z |
5508860 | 5508860 | 20241108200533_6UXpm | CZ000P | 2024-11-10T14:11:57.184Z | 2024-11-17T14:23:34.829Z |
5508830 | 5508830 | 20241108195042_pqmsA | CZ000P | 2024-11-10T14:11:54.410Z | 2024-11-17T14:23:34.453Z |
5508820 | 5508820 | 20241108193909_d4lLv | CZ000P | 2024-11-10T14:11:52.287Z | 2024-11-17T14:23:34.253Z |
5508737 | 5508737 | 20241108183045_iqFp2 | CZ000P | 2024-11-10T14:11:31.282Z | 2024-11-17T14:23:31.445Z |
5483388 | 5483388 | 20241105003510_PDmsZ | CZ000P | 2024-11-06T14:15:09.808Z | 2024-11-13T14:27:36.170Z |
5483176 | 5483176 | 20241105000722_iYpO5 | CZ000P | 2024-11-06T14:14:44.544Z | 2024-11-13T14:27:35.820Z |
5482612 | 5482612 | 20241104224840_ek0Cm | CZ000P | 2024-11-06T14:13:26.568Z | 2024-11-13T14:27:34.901Z |
5482422 | 5482422 | 20241104220958_evH75 | CZ000P | 2024-11-06T14:13:09.563Z | 2024-11-13T14:27:34.531Z |
5482383 | 5482383 | 20241104220238_Nnhwb | CZ000P | 2024-11-06T14:13:06.819Z | 2024-11-13T14:27:34.464Z |
5482277 | 5482277 | 20241104214232_Jkw36 | CZ000P | 2024-11-06T14:12:47.494Z | 2024-11-13T14:27:34.250Z |
5478588 | 5478588 | 20241104043546_x9tt6 | CZ000P | 2024-11-05T14:18:32.777Z | 2024-11-12T14:28:16.282Z |
5478520 | 5478520 | 20241104042400_M01Ap | CZ000P | 2024-11-05T14:18:27.840Z | 2024-11-12T14:28:15.779Z |
5478273 | 5478273 | 20241104034504_pRCfo | CZ000P | 2024-11-05T14:18:08.499Z | 2024-11-12T14:28:14.775Z |
5477900 | 5477900 | 20241104025216_WfIh6 | CZ000P | 2024-11-05T14:17:35.472Z | 2024-11-12T14:28:13.188Z |
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);