participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,811 rows where station_code = "CZ000K" 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 |
---|---|---|---|---|---|
5604983 | 5604983 | 20241125022528_iPKJI | CZ000K | 2024-11-26T14:18:18.668Z | 2024-11-26T14:18:45.196Z |
5600054 | 5600054 | 20241125032927_2ZoWS | CZ000K | 2024-11-26T14:00:19.419Z | 2024-11-26T14:00:19.419Z |
5599587 | 5599587 | 20241124015620_TQG9e | CZ000K | 2024-11-25T14:17:13.042Z | 2024-11-26T14:21:46.281Z |
5599569 | 5599569 | 20241124015113_07E7a | CZ000K | 2024-11-25T14:17:11.973Z | 2024-11-26T14:21:45.523Z |
5599446 | 5599446 | 20241124012507_U47dT | CZ000K | 2024-11-25T14:17:04.461Z | 2024-11-26T14:21:41.550Z |
5591707 | 5591707 | 20241123003343_ineXN | CZ000K | 2024-11-24T14:20:11.595Z | 2024-11-26T14:23:28.498Z |
5591577 | 5591577 | 20241122235646_K4nhT | CZ000K | 2024-11-24T14:20:03.569Z | 2024-11-26T14:23:25.742Z |
5591476 | 5591476 | 20241122232036_1HyME | CZ000K | 2024-11-24T14:19:54.943Z | 2024-11-26T14:23:23.551Z |
5591035 | 5591035 | 20241122210343_aSZxi | CZ000K | 2024-11-24T14:19:19.497Z | 2024-11-26T14:23:15.439Z |
5590976 | 5590976 | 20241122205304_B2E3e | CZ000K | 2024-11-24T14:19:15.138Z | 2024-11-26T14:23:14.878Z |
5590771 | 5590771 | 20241122200459_gJqn9 | CZ000K | 2024-11-24T14:18:57.360Z | 2024-11-26T14:23:12.560Z |
5590432 | 5590432 | 20241122191917_IW3nG | CZ000K | 2024-11-24T14:18:30.010Z | 2024-11-26T14:23:06.410Z |
5584136 | 5584136 | 20241116184742_ENLER | CZ000K | 2024-11-23T14:25:37.364Z | 2024-11-25T14:22:41.235Z |
5582064 | 5582064 | 20241122030146_fuJws | CZ000K | 2024-11-23T14:20:55.540Z | 2024-11-26T14:25:23.536Z |
5571189 | 5571189 | 20241120224901_zBE1g | CZ000K | 2024-11-22T14:16:36.008Z | 2024-11-26T14:26:32.842Z |
5571053 | 5571053 | 20241120220452_B20PE | CZ000K | 2024-11-22T14:16:20.178Z | 2024-11-26T14:26:31.793Z |
5570630 | 5570630 | 20241120203157_ZbYNk | CZ000K | 2024-11-22T14:15:57.308Z | 2024-11-26T14:26:26.207Z |
5570585 | 5570585 | 20241120202019_9y8Hp | CZ000K | 2024-11-22T14:15:50.999Z | 2024-11-26T14:26:24.689Z |
5570521 | 5570521 | 20241120195237_Bdsi4 | CZ000K | 2024-11-22T14:15:40.017Z | 2024-11-26T14:26:22.699Z |
5548382 | 5548382 | 20241116230111_sceQ2 | CZ000K | 2024-11-18T14:09:03.860Z | 2024-11-25T14:22:43.533Z |
5548373 | 5548373 | 20241116225719_OuFFl | CZ000K | 2024-11-18T14:09:00.732Z | 2024-11-25T14:22:43.494Z |
5548363 | 5548363 | 20241116225036_uym2C | CZ000K | 2024-11-18T14:08:58.105Z | 2024-11-25T14:22:43.455Z |
5548342 | 5548342 | 20241116224212_ynjOm | CZ000K | 2024-11-18T14:08:49.253Z | 2024-11-25T14:22:43.375Z |
5548321 | 5548321 | 20241116222702_MWegP | CZ000K | 2024-11-18T14:08:45.449Z | 2024-11-25T14:22:43.215Z |
5548320 | 5548320 | 20241116222555_eGJA5 | CZ000K | 2024-11-18T14:08:44.796Z | 2024-11-25T14:22:43.193Z |
5548239 | 5548239 | 20241116215014_Vzu59 | CZ000K | 2024-11-18T14:08:32.584Z | 2024-11-25T14:22:42.832Z |
5548121 | 5548121 | 20241116195746_5Sk97 | CZ000K | 2024-11-18T14:08:16.688Z | 2024-11-25T14:22:42.091Z |
5548113 | 5548113 | 20241116195333_OI0fp | CZ000K | 2024-11-18T14:08:15.627Z | 2024-11-25T14:22:42.047Z |
5548103 | 5548103 | 20241116194825_WgVc1 | CZ000K | 2024-11-18T14:08:10.896Z | 2024-11-25T14:22:41.985Z |
5548093 | 5548093 | 20241116194100_7U1Ls | CZ000K | 2024-11-18T14:08:04.061Z | 2024-11-25T14:22:41.889Z |
5548090 | 5548090 | 20241116193340_371GV | CZ000K | 2024-11-18T14:08:02.045Z | 2024-11-25T14:22:41.851Z |
5539126 | 5539126 | 20241110190513_4n1Aq | CZ000K | 2024-11-14T14:18:17.963Z | 2024-11-19T14:21:57.719Z |
5517730 | 5517730 | 20241110043901_iDlfl | CZ000K | 2024-11-11T14:14:48.117Z | 2024-11-18T14:26:37.983Z |
5517719 | 5517719 | 20241110043558_7ylLW | CZ000K | 2024-11-11T14:14:46.595Z | 2024-11-18T14:26:37.964Z |
5517599 | 5517599 | 20241110040852_JGyrr | CZ000K | 2024-11-11T14:14:39.237Z | 2024-11-18T14:26:37.337Z |
5517591 | 5517591 | 20241110040727_Vk2KX | CZ000K | 2024-11-11T14:14:38.289Z | 2024-11-18T14:26:37.276Z |
5517289 | 5517289 | 20241110031922_3UDKz | CZ000K | 2024-11-11T14:14:12.206Z | 2024-11-18T14:26:35.788Z |
5517218 | 5517218 | 20241110030612_TEt8A | CZ000K | 2024-11-11T14:14:06.407Z | 2024-11-18T14:26:35.380Z |
5517182 | 5517182 | 20241110030001_DbjU2 | CZ000K | 2024-11-11T14:14:02.236Z | 2024-11-18T14:26:35.172Z |
5517163 | 5517163 | 20241110025632_J3xR8 | CZ000K | 2024-11-11T14:13:59.764Z | 2024-11-18T14:26:35.031Z |
5517141 | 5517141 | 20241110025318_isze9 | CZ000K | 2024-11-11T14:13:58.036Z | 2024-11-18T14:26:34.881Z |
5517072 | 5517072 | 20241110024247_QbPVr | CZ000K | 2024-11-11T14:13:50.112Z | 2024-11-18T14:26:34.594Z |
5517067 | 5517067 | 20241110024242_JqbLj | CZ000K | 2024-11-11T14:13:49.799Z | 2024-11-18T14:26:34.520Z |
5517043 | 5517043 | 20241110023830_aFxIG | CZ000K | 2024-11-11T14:13:46.487Z | 2024-11-18T14:26:34.389Z |
5517021 | 5517021 | 20241110023431_KTlbt | CZ000K | 2024-11-11T14:13:43.976Z | 2024-11-18T14:26:34.227Z |
5516974 | 5516974 | 20241110022857_vBcGn | CZ000K | 2024-11-11T14:13:39.682Z | 2024-11-18T14:26:34.042Z |
5516871 | 5516871 | 20241110021300_wyL0L | CZ000K | 2024-11-11T14:13:27.400Z | 2024-11-18T14:26:33.630Z |
5516639 | 5516639 | 20241110013212_O8wIS | CZ000K | 2024-11-11T14:13:12.581Z | 2024-11-18T14:26:32.540Z |
5516605 | 5516605 | 20241110012759_5X1pZ | CZ000K | 2024-11-11T14:13:10.695Z | 2024-11-18T14:26:32.311Z |
5516564 | 5516564 | 20241110012044_vrfvU | CZ000K | 2024-11-11T14:13:08.819Z | 2024-11-18T14:26:32.033Z |
5516472 | 5516472 | 20241110010453_w4pfD | CZ000K | 2024-11-11T14:13:03.317Z | 2024-11-18T14:26:31.411Z |
5516409 | 5516409 | 20241110005316_K9R8G | CZ000K | 2024-11-11T14:12:59.332Z | 2024-11-18T14:26:31.069Z |
5516142 | 5516142 | 20241109235916_rONOO | CZ000K | 2024-11-11T14:12:19.771Z | 2024-11-18T14:26:29.762Z |
5516052 | 5516052 | 20241109234143_IfeiV | CZ000K | 2024-11-11T14:12:03.729Z | 2024-11-18T14:26:29.176Z |
5516025 | 5516025 | 20241109233532_QSjjh | CZ000K | 2024-11-11T14:12:00.634Z | 2024-11-18T14:26:28.991Z |
5515960 | 5515960 | 20241109232017_5rL3N | CZ000K | 2024-11-11T14:11:50.978Z | 2024-11-18T14:26:28.660Z |
5515871 | 5515871 | 20241109230051_35mqD | CZ000K | 2024-11-11T14:11:40.153Z | 2024-11-18T14:26:28.268Z |
5515853 | 5515853 | 20241109225801_4fLiO | CZ000K | 2024-11-11T14:11:37.504Z | 2024-11-18T14:26:28.205Z |
5515809 | 5515809 | 20241109224738_As22K | CZ000K | 2024-11-11T14:11:30.889Z | 2024-11-18T14:26:28.034Z |
5515791 | 5515791 | 20241109224452_xDVrf | CZ000K | 2024-11-11T14:11:28.543Z | 2024-11-18T14:26:27.962Z |
5515774 | 5515774 | 20241109223922_xo5Tj | CZ000K | 2024-11-11T14:11:27.558Z | 2024-11-18T14:26:27.901Z |
5515731 | 5515731 | 20241109223226_NeiAW | CZ000K | 2024-11-11T14:11:24.875Z | 2024-11-18T14:26:27.767Z |
5515585 | 5515585 | 20241109220451_sMaBC | CZ000K | 2024-11-11T14:11:15.131Z | 2024-11-18T14:26:26.905Z |
5515544 | 5515544 | 20241109215522_ukVkB | CZ000K | 2024-11-11T14:11:12.582Z | 2024-11-18T14:26:26.673Z |
5515466 | 5515466 | 20241109213004_KENPy | CZ000K | 2024-11-11T14:11:06.533Z | 2024-11-18T14:26:26.180Z |
5515461 | 5515461 | 20241109212810_EbwlL | CZ000K | 2024-11-11T14:11:06.310Z | 2024-11-18T14:26:26.152Z |
5515389 | 5515389 | 20241109210613_UFtaz | CZ000K | 2024-11-11T14:10:53.286Z | 2024-11-18T14:26:25.790Z |
5515371 | 5515371 | 20241109205946_CQk2c | CZ000K | 2024-11-11T14:10:51.603Z | 2024-11-18T14:26:25.741Z |
5515223 | 5515223 | 20241109195624_UFG83 | CZ000K | 2024-11-11T14:10:21.927Z | 2024-11-18T14:26:24.958Z |
5515171 | 5515171 | 20241109194711_kF2E3 | CZ000K | 2024-11-11T14:10:14.412Z | 2024-11-18T14:26:24.660Z |
5515159 | 5515159 | 20241109194202_fJ8JE | CZ000K | 2024-11-11T14:10:12.755Z | 2024-11-18T14:26:24.579Z |
5515144 | 5515144 | 20241109193730_TTUJa | CZ000K | 2024-11-11T14:10:09.584Z | 2024-11-18T14:26:24.522Z |
5515022 | 5515022 | 20241109190325_kxQCm | CZ000K | 2024-11-11T14:09:54.716Z | 2024-11-18T14:26:23.878Z |
5514954 | 5514954 | 20241109184040_ev7dD | CZ000K | 2024-11-11T14:09:47.982Z | 2024-11-18T14:26:23.546Z |
5514856 | 5514856 | 20241109180421_yyftP | CZ000K | 2024-11-11T14:09:34.105Z | 2024-11-18T14:26:22.900Z |
5514829 | 5514829 | 20241109175613_hAO7H | CZ000K | 2024-11-11T14:09:25.287Z | 2024-11-18T14:26:22.767Z |
5514805 | 5514805 | 20241109174025_LAIxu | CZ000K | 2024-11-11T14:09:17.735Z | 2024-11-18T14:26:22.566Z |
5514802 | 5514802 | 20241109173839_QePBu | CZ000K | 2024-11-11T14:09:17.157Z | 2024-11-18T14:26:22.529Z |
5511163 | 5511163 | 20241109044657_qIhS0 | CZ000K | 2024-11-10T14:16:22.591Z | 2024-11-17T14:24:05.793Z |
5511156 | 5511156 | 20241109044524_wQuoV | CZ000K | 2024-11-10T14:16:21.547Z | 2024-11-17T14:24:05.635Z |
5511119 | 5511119 | 20241109043336_L0lQH | CZ000K | 2024-11-10T14:16:17.745Z | 2024-11-17T14:24:04.905Z |
5511116 | 5511116 | 20241109043106_XIpjY | CZ000K | 2024-11-10T14:16:17.077Z | 2024-11-17T14:24:04.814Z |
5511065 | 5511065 | 20241109041749_sDeug | CZ000K | 2024-11-10T14:16:10.075Z | 2024-11-17T14:24:04.142Z |
5510725 | 5510725 | 20241109032939_OhCm3 | CZ000K | 2024-11-10T14:15:36.129Z | 2024-11-17T14:24:00.652Z |
5510295 | 5510295 | 20241109021800_q8Std | CZ000K | 2024-11-10T14:14:57.734Z | 2024-11-17T14:23:55.691Z |
5510242 | 5510242 | 20241109020532_8cFDb | CZ000K | 2024-11-10T14:14:51.045Z | 2024-11-17T14:23:54.526Z |
5510184 | 5510184 | 20241109015555_Kp2rT | CZ000K | 2024-11-10T14:14:45.434Z | 2024-11-17T14:23:53.748Z |
5510179 | 5510179 | 20241109015528_JQjnu | CZ000K | 2024-11-10T14:14:45.191Z | 2024-11-17T14:23:53.735Z |
5510109 | 5510109 | 20241109014336_WCKqH | CZ000K | 2024-11-10T14:14:36.047Z | 2024-11-17T14:23:53.036Z |
5509956 | 5509956 | 20241109011602_w5Mv2 | CZ000K | 2024-11-10T14:14:19.459Z | 2024-11-17T14:23:51.388Z |
5509946 | 5509946 | 20241109011343_yyGg0 | CZ000K | 2024-11-10T14:14:18.634Z | 2024-11-17T14:23:51.307Z |
5509938 | 5509938 | 20241109011249_zFkhD | CZ000K | 2024-11-10T14:14:17.768Z | 2024-11-17T14:23:51.280Z |
5509846 | 5509846 | 20241109004958_p7es4 | CZ000K | 2024-11-10T14:14:06.720Z | 2024-11-17T14:23:49.988Z |
5509791 | 5509791 | 20241109003643_6KrD2 | CZ000K | 2024-11-10T14:14:01.203Z | 2024-11-17T14:23:49.235Z |
5509755 | 5509755 | 20241109002906_0Apx2 | CZ000K | 2024-11-10T14:13:57.028Z | 2024-11-17T14:23:48.780Z |
5509671 | 5509671 | 20241109000912_9PLUF | CZ000K | 2024-11-10T14:13:49.847Z | 2024-11-17T14:23:48.193Z |
5509578 | 5509578 | 20241108235002_TxZVL | CZ000K | 2024-11-10T14:13:36.666Z | 2024-11-17T14:23:47.059Z |
5509470 | 5509470 | 20241108232347_YjVOl | CZ000K | 2024-11-10T14:13:25.286Z | 2024-11-17T14:23:44.828Z |
5509456 | 5509456 | 20241108232028_2Sb3i | CZ000K | 2024-11-10T14:13:24.376Z | 2024-11-17T14:23:44.625Z |
5509325 | 5509325 | 20241108225150_Os3tc | CZ000K | 2024-11-10T14:13:12.688Z | 2024-11-17T14:23:43.143Z |
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);