participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,600 rows where station_code = "KR002Q" 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 |
---|---|---|---|---|---|
6114233 | 6114233 | 20250218174227_CxYnz | KR002Q | 2025-02-19T14:14:45.393Z | 2025-02-19T14:15:10.063Z |
6114227 | 6114227 | 20250218173924_7Zain | KR002Q | 2025-02-19T14:14:44.813Z | 2025-02-19T14:15:10.062Z |
6113980 | 6113980 | 20250218163236_HBPI8 | KR002Q | 2025-02-19T14:14:17.836Z | 2025-02-19T14:15:10.013Z |
6113394 | 6113394 | 20250218143649_M37e5 | KR002Q | 2025-02-19T14:12:55.967Z | 2025-02-19T14:15:09.898Z |
6112991 | 6112991 | 20250218131622_DlNtW | KR002Q | 2025-02-19T14:12:01.626Z | 2025-02-19T14:15:09.828Z |
6109884 | 6109884 | 20250218183350_gPPxg | KR002Q | 2025-02-19T14:00:23.648Z | 2025-02-19T14:00:23.648Z |
6109494 | 6109494 | 20250217155614_R3CME | KR002Q | 2025-02-18T14:10:45.792Z | 2025-02-19T14:20:18.335Z |
6109428 | 6109428 | 20250217151411_1K6cS | KR002Q | 2025-02-18T14:10:32.843Z | 2025-02-19T14:20:09.144Z |
6109331 | 6109331 | 20250217142119_stm9G | KR002Q | 2025-02-18T14:10:09.931Z | 2025-02-19T14:19:55.699Z |
6109307 | 6109307 | 20250217140135_6nHok | KR002Q | 2025-02-18T14:10:02.024Z | 2025-02-19T14:19:52.327Z |
6106461 | 6106461 | 20250216150209_RzxTv | KR002Q | 2025-02-17T14:08:44.718Z | 2025-02-19T14:24:46.283Z |
6094533 | 6094533 | 20250208144451_yiLIg | KR002Q | 2025-02-10T14:12:43.906Z | 2025-02-16T14:21:58.268Z |
6094425 | 6094425 | 20250208132923_4ScSa | KR002Q | 2025-02-10T14:12:07.570Z | 2025-02-16T14:21:34.928Z |
6092736 | 6092736 | 20250208212721_Ne3OU | KR002Q | 2025-02-10T14:00:41.257Z | 2025-02-17T14:23:41.382Z |
6092733 | 6092733 | 20250208212321_eMDOC | KR002Q | 2025-02-10T14:00:40.604Z | 2025-02-17T14:23:41.275Z |
6092701 | 6092701 | 20250208211102_WOMnz | KR002Q | 2025-02-10T14:00:33.189Z | 2025-02-17T14:23:39.973Z |
6092682 | 6092682 | 20250208205958_fcLTv | KR002Q | 2025-02-10T14:00:28.771Z | 2025-02-17T14:23:38.876Z |
6088452 | 6088452 | 20250207211536_jhqOE | KR002Q | 2025-02-09T14:00:13.173Z | 2025-02-16T14:19:39.070Z |
6088450 | 6088450 | 20250207211316_IMZXT | KR002Q | 2025-02-09T14:00:12.031Z | 2025-02-16T14:19:38.969Z |
6082588 | 6082588 | 20250204201321_9f0jE | KR002Q | 2025-02-07T14:41:29.552Z | 2025-02-12T14:50:14.965Z |
6082404 | 6082404 | 20250204194225_tDxgg | KR002Q | 2025-02-07T14:41:21.326Z | 2025-02-12T14:49:56.085Z |
6082292 | 6082292 | 20250204192731_E7ecp | KR002Q | 2025-02-07T14:41:15.574Z | 2025-02-12T14:49:50.075Z |
6082244 | 6082244 | 20250204191938_NgcQF | KR002Q | 2025-02-07T14:41:13.717Z | 2025-02-12T14:49:47.718Z |
6082222 | 6082222 | 20250204191526_sikpm | KR002Q | 2025-02-07T14:41:12.490Z | 2025-02-12T14:49:46.704Z |
6082133 | 6082133 | 20250204190019_p63I5 | KR002Q | 2025-02-07T14:41:08.263Z | 2025-02-12T14:49:43.432Z |
6078703 | 6078703 | 20250205212840_M99Bq | KR002Q | 2025-02-07T14:34:02.783Z | 2025-02-13T14:39:40.478Z |
6078699 | 6078699 | 20250205212810_AsxJ9 | KR002Q | 2025-02-07T14:34:02.528Z | 2025-02-13T14:39:40.324Z |
6078686 | 6078686 | 20250205212457_wsg5f | KR002Q | 2025-02-07T14:34:01.804Z | 2025-02-13T14:39:39.861Z |
6078645 | 6078645 | 20250205211844_562ag | KR002Q | 2025-02-07T14:33:59.853Z | 2025-02-13T14:39:38.660Z |
6078630 | 6078630 | 20250205211628_jTxEw | KR002Q | 2025-02-07T14:33:59.325Z | 2025-02-13T14:39:38.318Z |
6078508 | 6078508 | 20250205210242_pQs3l | KR002Q | 2025-02-07T14:33:55.700Z | 2025-02-13T14:39:35.375Z |
6078484 | 6078484 | 20250205210058_w3YOI | KR002Q | 2025-02-07T14:33:53.695Z | 2025-02-13T14:39:34.852Z |
6078400 | 6078400 | 20250205204920_zc9sQ | KR002Q | 2025-02-07T14:33:40.008Z | 2025-02-13T14:39:32.982Z |
6078388 | 6078388 | 20250205204358_a92P1 | KR002Q | 2025-02-07T14:33:38.222Z | 2025-02-13T14:39:32.356Z |
6078370 | 6078370 | 20250205203652_lqYNp | KR002Q | 2025-02-07T14:33:30.465Z | 2025-02-13T14:39:31.894Z |
6078312 | 6078312 | 20250205202959_MjnWS | KR002Q | 2025-02-07T14:33:24.015Z | 2025-02-13T14:39:30.532Z |
6078118 | 6078118 | 20250205195037_PtwQy | KR002Q | 2025-02-07T14:33:05.929Z | 2025-02-13T14:39:18.406Z |
6077876 | 6077876 | 20250205191244_wo2CN | KR002Q | 2025-02-07T14:32:54.189Z | 2025-02-13T14:38:58.557Z |
6077812 | 6077812 | 20250205190411_B30db | KR002Q | 2025-02-07T14:32:50.687Z | 2025-02-13T14:38:56.414Z |
6077665 | 6077665 | 20250205183508_sZGPb | KR002Q | 2025-02-07T14:32:44.583Z | 2025-02-13T14:38:50.218Z |
6077532 | 6077532 | 20250205181204_Qfcsa | KR002Q | 2025-02-07T14:32:29.476Z | 2025-02-13T14:38:45.909Z |
6077472 | 6077472 | 20250205180342_nivdv | KR002Q | 2025-02-07T14:32:19.046Z | 2025-02-13T14:38:44.316Z |
6076157 | 6076157 | 20250205144121_TzP4Z | KR002Q | 2025-02-07T14:30:25.153Z | 2025-02-13T14:37:47.540Z |
6075997 | 6075997 | 20250205142848_m5Xvi | KR002Q | 2025-02-07T14:30:17.768Z | 2025-02-13T14:37:30.291Z |
6075727 | 6075727 | 20250205134341_s5ajO | KR002Q | 2025-02-07T14:30:01.201Z | 2025-02-13T14:37:20.100Z |
6059800 | 6059800 | 20250203212305_lHzxV | KR002Q | 2025-02-05T14:20:17.385Z | 2025-02-11T14:43:00.686Z |
6058679 | 6058679 | 20250203175406_6Rvi4 | KR002Q | 2025-02-05T14:18:19.515Z | 2025-02-11T14:42:03.393Z |
6053635 | 6053635 | 20250202213317_Q272T | KR002Q | 2025-02-04T14:24:05.934Z | 2025-02-10T14:59:04.149Z |
6053469 | 6053469 | 20250202210740_LmMFW | KR002Q | 2025-02-04T14:23:52.586Z | 2025-02-10T14:58:53.381Z |
6053449 | 6053449 | 20250202210106_1zN4W | KR002Q | 2025-02-04T14:23:51.332Z | 2025-02-10T14:58:52.470Z |
6053393 | 6053393 | 20250202204900_8Cr1t | KR002Q | 2025-02-04T14:23:46.400Z | 2025-02-10T14:58:48.298Z |
6053268 | 6053268 | 20250202202937_k2GhT | KR002Q | 2025-02-04T14:23:34.454Z | 2025-02-10T14:58:43.159Z |
6053253 | 6053253 | 20250202202732_YKjND | KR002Q | 2025-02-04T14:23:33.820Z | 2025-02-10T14:58:42.996Z |
6053223 | 6053223 | 20250202202430_atEW2 | KR002Q | 2025-02-04T14:23:29.810Z | 2025-02-10T14:58:41.545Z |
6015597 | 6015597 | 20250129145059_JCqgV | KR002Q | 2025-01-30T14:14:04.783Z | 2025-02-07T14:58:20.624Z |
6015385 | 6015385 | 20250129141446_I4dZK | KR002Q | 2025-01-30T14:13:36.173Z | 2025-02-07T14:58:16.757Z |
6014435 | 6014435 | 20250129110352_QVoVb | KR002Q | 2025-01-30T14:10:23.221Z | 2025-02-07T14:57:54.660Z |
5997719 | 5997719 | 20250125195211_G0Ge5 | KR002Q | 2025-01-27T14:15:30.883Z | 2025-02-03T14:34:49.001Z |
5997665 | 5997665 | 20250125193525_zC60Z | KR002Q | 2025-01-27T14:15:25.341Z | 2025-02-03T14:34:48.372Z |
5997659 | 5997659 | 20250125193120_b9IoF | KR002Q | 2025-01-27T14:15:24.305Z | 2025-02-03T14:34:48.323Z |
5997578 | 5997578 | 20250125185359_iTgSZ | KR002Q | 2025-01-27T14:15:04.556Z | 2025-02-03T14:34:47.780Z |
5993702 | 5993702 | 20250124122043_L9VNV | KR002Q | 2025-01-26T14:11:29.923Z | 2025-02-02T14:37:04.041Z |
5993690 | 5993690 | 20250125182433_DPq7W | KR002Q | 2025-01-26T14:09:25.072Z | 2025-02-03T14:34:47.053Z |
5993667 | 5993667 | 20250125181154_nhlRZ | KR002Q | 2025-01-26T14:09:21.463Z | 2025-01-26T14:09:21.463Z |
5990118 | 5990118 | 20250124213757_ySzb4 | KR002Q | 2025-01-25T14:13:57.229Z | 2025-02-02T14:37:25.037Z |
5990115 | 5990115 | 20250124213703_5i9kJ | KR002Q | 2025-01-25T14:13:56.825Z | 2025-02-02T14:37:25.026Z |
5990025 | 5990025 | 20250124204305_PYTj5 | KR002Q | 2025-01-25T14:13:40.000Z | 2025-02-02T14:37:22.961Z |
5989949 | 5989949 | 20250124200522_m3L2Q | KR002Q | 2025-01-25T14:13:31.751Z | 2025-02-02T14:37:21.361Z |
5989943 | 5989943 | 20250124200323_U0qDy | KR002Q | 2025-01-25T14:13:30.916Z | 2025-02-02T14:37:21.278Z |
5989937 | 5989937 | 20250124200035_i4QvQ | KR002Q | 2025-01-25T14:13:29.466Z | 2025-02-02T14:37:21.160Z |
5989923 | 5989923 | 20250124195208_Cv3ub | KR002Q | 2025-01-25T14:13:26.563Z | 2025-02-02T14:37:21.074Z |
5989913 | 5989913 | 20250124193207_7wbTO | KR002Q | 2025-01-25T14:13:23.089Z | 2025-02-02T14:37:20.382Z |
5989849 | 5989849 | 20250124183130_l998k | KR002Q | 2025-01-25T14:13:15.543Z | 2025-02-02T14:37:18.949Z |
5989823 | 5989823 | 20250124180744_fM2Dz | KR002Q | 2025-01-25T14:13:02.697Z | 2025-02-02T14:37:18.358Z |
5989806 | 5989806 | 20250124175236_PdAJL | KR002Q | 2025-01-25T14:13:00.735Z | 2025-02-02T14:37:18.102Z |
5989686 | 5989686 | 20250124163308_cj5mY | KR002Q | 2025-01-25T14:12:39.945Z | 2025-02-02T14:37:16.792Z |
5989665 | 5989665 | 20250124162436_5JGiy | KR002Q | 2025-01-25T14:12:34.977Z | 2025-02-02T14:37:16.567Z |
5989564 | 5989564 | 20250124155102_OdW1v | KR002Q | 2025-01-25T14:12:11.232Z | 2025-02-02T14:37:15.201Z |
5988585 | 5988585 | 20250124122034_V3InO | KR002Q | 2025-01-25T14:09:17.062Z | 2025-02-02T14:37:04.017Z |
5988399 | 5988399 | 20250124115900_5RSsu | KR002Q | 2025-01-25T14:08:36.151Z | 2025-02-02T14:37:01.365Z |
5988215 | 5988215 | 20250124113247_nxDBa | KR002Q | 2025-01-25T14:07:52.946Z | 2025-02-02T14:36:58.869Z |
5982368 | 5982368 | 20250123114128_pbHGv | KR002Q | 2025-01-24T14:07:54.462Z | 2025-02-01T14:40:08.872Z |
5982275 | 5982275 | 20250123112331_Ok5XR | KR002Q | 2025-01-24T14:07:40.090Z | 2025-02-01T14:40:07.703Z |
5967409 | 5967409 | 20250116141120_I2NHj | KR002Q | 2025-01-22T14:27:57.831Z | 2025-01-25T14:39:33.802Z |
5956497 | 5956497 | 20250118141618_U6QgE | KR002Q | 2025-01-19T14:05:23.737Z | 2025-01-27T14:44:49.346Z |
5954447 | 5954447 | 20250117171037_c26FR | KR002Q | 2025-01-18T14:04:57.458Z | 2025-01-26T14:34:23.584Z |
5954158 | 5954158 | 20250117144552_RoQo6 | KR002Q | 2025-01-18T14:03:48.738Z | 2025-01-26T14:34:18.321Z |
5953874 | 5953874 | 20250117120710_QjLNa | KR002Q | 2025-01-18T14:02:27.130Z | 2025-01-26T14:34:12.848Z |
5953746 | 5953746 | 20250117105032_tQTpy | KR002Q | 2025-01-18T14:01:49.921Z | 2025-01-26T14:34:10.109Z |
5942469 | 5942469 | 20250108180822_NJGGC | KR002Q | 2025-01-10T14:15:15.847Z | 2025-01-17T14:18:00.461Z |
5942382 | 5942382 | 20250108175104_1YTO3 | KR002Q | 2025-01-10T14:15:06.831Z | 2025-01-17T14:17:58.065Z |
5942287 | 5942287 | 20250108172757_qV2OQ | KR002Q | 2025-01-10T14:14:42.639Z | 2025-01-17T14:17:54.594Z |
5942205 | 5942205 | 20250108171831_DnsrS | KR002Q | 2025-01-10T14:14:31.155Z | 2025-01-17T14:17:51.959Z |
5942165 | 5942165 | 20250108170830_wRMtU | KR002Q | 2025-01-10T14:14:27.748Z | 2025-01-17T14:17:50.948Z |
5942077 | 5942077 | 20250108163938_lZsCD | KR002Q | 2025-01-10T14:14:18.377Z | 2025-01-17T14:17:47.975Z |
5932357 | 5932357 | 20250107212553_gWHOW | KR002Q | 2025-01-09T14:12:15.379Z | 2025-01-16T14:21:18.537Z |
5932332 | 5932332 | 20250107212416_E4d6K | KR002Q | 2025-01-09T14:12:13.483Z | 2025-01-16T14:21:15.128Z |
5932165 | 5932165 | 20250107205538_LIJA3 | KR002Q | 2025-01-09T14:11:51.016Z | 2025-01-16T14:21:07.470Z |
5932027 | 5932027 | 20250107202335_gIWwj | KR002Q | 2025-01-09T14:11:35.707Z | 2025-01-16T14:20:59.826Z |
5930134 | 5930134 | 20250107142918_r63H2 | KR002Q | 2025-01-09T14:05:49.275Z | 2025-01-16T14:19:29.600Z |
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);