participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
846 rows where station_code = "KR002Y" 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 |
---|---|---|---|---|---|
4518307 | 4518307 | 20240628160747_aGx9o | KR002Y | 2024-06-30T12:01:39.790Z | 2024-07-07T12:13:43.921Z |
4517836 | 4517836 | 20240628150048_osYHJ | KR002Y | 2024-06-30T12:01:01.745Z | 2024-07-07T12:13:41.822Z |
4517806 | 4517806 | 20240628145532_2AJK6 | KR002Y | 2024-06-30T12:00:57.162Z | 2024-07-07T12:13:41.778Z |
4512389 | 4512389 | 20240627172039_1Tde7 | KR002Y | 2024-06-29T12:03:48.988Z | 2024-07-06T12:16:13.350Z |
4512318 | 4512318 | 20240627171107_XPqYA | KR002Y | 2024-06-29T12:03:41.625Z | 2024-07-06T12:16:13.291Z |
4508699 | 4508699 | 20240626184433_HQMUs | KR002Y | 2024-06-28T12:03:02.705Z | 2024-07-05T12:11:23.626Z |
4507182 | 4507182 | 20240627162634_IFE2z | KR002Y | 2024-06-28T12:01:09.257Z | 2024-07-06T12:16:12.309Z |
4507127 | 4507127 | 20240627160325_KieDT | KR002Y | 2024-06-28T12:01:04.469Z | 2024-07-06T12:16:12.143Z |
4506852 | 4506852 | 20240627150212_OeQ2Z | KR002Y | 2024-06-28T12:00:47.708Z | 2024-07-06T12:16:10.975Z |
4506434 | 4506434 | 20240627123603_ERhYh | KR002Y | 2024-06-28T12:00:13.824Z | 2024-07-06T12:16:08.887Z |
4503382 | 4503382 | 20240626150444_N72ZB | KR002Y | 2024-06-27T12:01:33.308Z | 2024-07-05T12:11:21.707Z |
4498432 | 4498432 | 20240625135632_7LIwM | KR002Y | 2024-06-26T12:00:31.426Z | 2024-07-04T12:08:44.522Z |
4491650 | 4491650 | 20240620190515_3MJam | KR002Y | 2024-06-22T12:04:33.710Z | 2024-06-29T12:13:30.411Z |
4487805 | 4487805 | 20240619190625_Vf9uE | KR002Y | 2024-06-21T12:04:23.964Z | 2024-06-28T12:09:34.521Z |
4487793 | 4487793 | 20240619185931_qypAn | KR002Y | 2024-06-21T12:04:22.912Z | 2024-06-28T12:09:34.474Z |
4487633 | 4487633 | 20240619182409_5rjND | KR002Y | 2024-06-21T12:04:12.084Z | 2024-06-28T12:09:34.132Z |
4487610 | 4487610 | 20240619182203_Bc8AF | KR002Y | 2024-06-21T12:04:10.980Z | 2024-06-28T12:09:34.058Z |
4484131 | 4484131 | 20240618184610_KoNPB | KR002Y | 2024-06-20T12:05:05.337Z | 2024-06-27T12:11:27.557Z |
4483684 | 4483684 | 20240618174518_3dDz9 | KR002Y | 2024-06-20T12:04:30.160Z | 2024-06-27T12:11:24.427Z |
4483578 | 4483578 | 20240618172655_c5MW0 | KR002Y | 2024-06-20T12:04:23.875Z | 2024-06-27T12:11:23.632Z |
4482219 | 4482219 | 20240618121233_158SM | KR002Y | 2024-06-20T12:02:06.246Z | 2024-06-27T12:11:15.885Z |
4477883 | 4477883 | 20240617185554_hpvlT | KR002Y | 2024-06-19T12:06:05.359Z | 2024-06-26T12:14:37.209Z |
4477717 | 4477717 | 20240617183022_XG4SG | KR002Y | 2024-06-19T12:05:55.738Z | 2024-06-26T12:14:35.609Z |
4477655 | 4477655 | 20240617182239_W238j | KR002Y | 2024-06-19T12:05:44.343Z | 2024-06-26T12:14:35.330Z |
4477344 | 4477344 | 20240617173551_Cp7a9 | KR002Y | 2024-06-19T12:05:15.770Z | 2024-06-26T12:14:32.606Z |
4477045 | 4477045 | 20240617165348_A903w | KR002Y | 2024-06-19T12:04:45.689Z | 2024-06-26T12:14:29.715Z |
4476914 | 4476914 | 20240617162658_cHrtj | KR002Y | 2024-06-19T12:04:36.355Z | 2024-06-26T12:14:28.225Z |
4476903 | 4476903 | 20240617162336_2RiNW | KR002Y | 2024-06-19T12:04:35.592Z | 2024-06-26T12:14:28.089Z |
4470418 | 4470418 | 20240615174417_R947Y | KR002Y | 2024-06-17T12:07:26.935Z | 2024-06-23T12:12:30.194Z |
4470006 | 4470006 | 20240615165615_owSqT | KR002Y | 2024-06-17T12:06:36.426Z | 2024-06-23T12:12:27.719Z |
4466287 | 4466287 | 20240614163914_MJJKB | KR002Y | 2024-06-16T12:06:53.892Z | 2024-06-22T12:16:34.834Z |
4463148 | 4463148 | 20240613184739_4Tm8J | KR002Y | 2024-06-15T12:09:30.742Z | 2024-06-21T12:11:48.067Z |
4462456 | 4462456 | 20240613165755_tc2K7 | KR002Y | 2024-06-15T12:08:41.454Z | 2024-06-21T12:11:46.949Z |
4462443 | 4462443 | 20240613165429_a182Z | KR002Y | 2024-06-15T12:08:40.512Z | 2024-06-21T12:11:46.928Z |
4461980 | 4461980 | 20240613151808_FqVQz | KR002Y | 2024-06-15T12:07:54.661Z | 2024-06-21T12:11:46.086Z |
4459693 | 4459693 | 20240612185434_cVGk0 | KR002Y | 2024-06-14T12:05:46.449Z | 2024-06-20T12:12:05.705Z |
4459130 | 4459130 | 20240612165535_yh0Pp | KR002Y | 2024-06-14T12:05:22.015Z | 2024-06-20T12:12:04.805Z |
4458906 | 4458906 | 20240612160905_aYMAq | KR002Y | 2024-06-14T12:05:14.181Z | 2024-06-20T12:12:04.288Z |
4458868 | 4458868 | 20240612155711_NGCxr | KR002Y | 2024-06-14T12:05:13.025Z | 2024-06-20T12:12:04.258Z |
4455014 | 4455014 | 20240611185245_pqos2 | KR002Y | 2024-06-13T12:06:22.763Z | 2024-06-19T12:13:49.214Z |
4454930 | 4454930 | 20240611183548_SWB9w | KR002Y | 2024-06-13T12:06:20.832Z | 2024-06-19T12:13:48.916Z |
4454585 | 4454585 | 20240611175958_1L2JD | KR002Y | 2024-06-13T12:06:13.793Z | 2024-06-19T12:13:48.372Z |
4454080 | 4454080 | 20240611165637_DV7n1 | KR002Y | 2024-06-13T12:06:02.534Z | 2024-06-19T12:13:47.428Z |
4454034 | 4454034 | 20240611165210_f6jCh | KR002Y | 2024-06-13T12:06:01.406Z | 2024-06-19T12:13:47.410Z |
4448539 | 4448539 | 20240611191635_M7wUC | KR002Y | 2024-06-13T12:00:10.862Z | 2024-06-20T12:11:44.202Z |
4444528 | 4444528 | 20240609164905_193qL | KR002Y | 2024-06-11T12:06:51.905Z | 2024-06-17T12:15:23.796Z |
4444467 | 4444467 | 20240609163408_lm1ol | KR002Y | 2024-06-11T12:06:49.231Z | 2024-06-17T12:15:23.579Z |
4444303 | 4444303 | 20240609153820_gH2z7 | KR002Y | 2024-06-11T12:06:41.962Z | 2024-06-17T12:15:23.308Z |
4444291 | 4444291 | 20240609153332_h30h8 | KR002Y | 2024-06-11T12:06:40.342Z | 2024-06-17T12:15:23.286Z |
4444278 | 4444278 | 20240609152713_tqXiI | KR002Y | 2024-06-11T12:06:39.477Z | 2024-06-17T12:15:23.283Z |
4444270 | 4444270 | 20240609152426_39oHr | KR002Y | 2024-06-11T12:06:38.364Z | 2024-06-17T12:15:23.273Z |
4441741 | 4441741 | 20240609175959_yZtrP | KR002Y | 2024-06-11T12:00:28.518Z | 2024-06-18T12:11:01.220Z |
4439896 | 4439896 | 20240609144646_m6ARC | KR002Y | 2024-06-10T12:02:40.115Z | 2024-06-17T12:15:23.018Z |
4439716 | 4439716 | 20240609131757_Hyi3U | KR002Y | 2024-06-10T12:02:32.472Z | 2024-06-17T12:15:21.880Z |
4436377 | 4436377 | 20240608160955_SG2yh | KR002Y | 2024-06-10T12:00:10.921Z | 2024-06-17T12:14:59.674Z |
4426332 | 4426332 | 20240606172709_XrPxS | KR002Y | 2024-06-08T12:02:46.931Z | 2024-06-15T12:16:46.982Z |
4425497 | 4425497 | 20240606152708_ih91L | KR002Y | 2024-06-08T12:01:32.691Z | 2024-06-15T12:16:44.830Z |
4415054 | 4415054 | 20240604170539_pd6E5 | KR002Y | 2024-06-06T12:04:16.012Z | 2024-06-13T12:08:29.666Z |
4414988 | 4414988 | 20240604165558_9tk3c | KR002Y | 2024-06-06T12:04:02.115Z | 2024-06-13T12:08:29.587Z |
4414714 | 4414714 | 20240604162441_0cSUP | KR002Y | 2024-06-06T12:03:40.348Z | 2024-06-13T12:08:29.375Z |
4414655 | 4414655 | 20240604161955_VsaJR | KR002Y | 2024-06-06T12:03:37.043Z | 2024-06-13T12:08:29.340Z |
4414429 | 4414429 | 20240604155548_U3XOJ | KR002Y | 2024-06-06T12:03:23.862Z | 2024-06-13T12:08:29.199Z |
4412683 | 4412683 | 20240604120449_3shDl | KR002Y | 2024-06-06T12:00:26.036Z | 2024-06-13T12:08:28.049Z |
4411223 | 4411223 | 20240603185443_EeLLh | KR002Y | 2024-06-05T12:06:26.515Z | 2024-06-12T12:10:36.857Z |
4410881 | 4410881 | 20240603181314_V45ml | KR002Y | 2024-06-05T12:06:03.719Z | 2024-06-12T12:10:36.073Z |
4410768 | 4410768 | 20240603175859_ng3xF | KR002Y | 2024-06-05T12:05:48.190Z | 2024-06-12T12:10:35.344Z |
4410735 | 4410735 | 20240603175323_EH8pu | KR002Y | 2024-06-05T12:05:45.157Z | 2024-06-12T12:10:35.267Z |
4410500 | 4410500 | 20240603172052_mvjwl | KR002Y | 2024-06-05T12:05:28.362Z | 2024-06-12T12:10:34.857Z |
4409902 | 4409902 | 20240603161021_NGmoI | KR002Y | 2024-06-05T12:04:24.680Z | 2024-06-12T12:10:33.814Z |
4409746 | 4409746 | 20240603155349_mCWcj | KR002Y | 2024-06-05T12:04:13.375Z | 2024-06-12T12:10:33.634Z |
4409619 | 4409619 | 20240603152433_1Xz5z | KR002Y | 2024-06-05T12:03:50.537Z | 2024-06-12T12:10:33.401Z |
4409326 | 4409326 | 20240603144523_VfA33 | KR002Y | 2024-06-05T12:03:16.798Z | 2024-06-12T12:10:32.996Z |
4409076 | 4409076 | 20240603135622_OlRuX | KR002Y | 2024-06-05T12:02:41.345Z | 2024-06-12T12:10:32.212Z |
4405632 | 4405632 | 20240602181716_JcZl8 | KR002Y | 2024-06-04T12:05:04.452Z | 2024-06-11T12:13:31.879Z |
4405608 | 4405608 | 20240602181349_wewhm | KR002Y | 2024-06-04T12:05:01.921Z | 2024-06-11T12:13:31.854Z |
4405284 | 4405284 | 20240602171141_8hs5K | KR002Y | 2024-06-04T12:04:15.663Z | 2024-06-11T12:13:30.979Z |
4405020 | 4405020 | 20240602162741_P86TY | KR002Y | 2024-06-04T12:03:55.293Z | 2024-06-11T12:13:30.514Z |
4404809 | 4404809 | 20240602153518_yV5oi | KR002Y | 2024-06-04T12:03:23.349Z | 2024-06-11T12:13:29.673Z |
4404726 | 4404726 | 20240602151500_BTmM3 | KR002Y | 2024-06-04T12:03:12.293Z | 2024-06-11T12:13:29.470Z |
4400119 | 4400119 | 20240601184127_LW6Ab | KR002Y | 2024-06-03T12:05:14.338Z | 2024-06-10T12:06:45.663Z |
4400080 | 4400080 | 20240601183540_jXG9s | KR002Y | 2024-06-03T12:05:11.741Z | 2024-06-10T12:06:45.629Z |
4400070 | 4400070 | 20240601182800_gyKMF | KR002Y | 2024-06-03T12:05:10.496Z | 2024-06-10T12:06:45.617Z |
4399706 | 4399706 | 20240601165703_wUEVF | KR002Y | 2024-06-03T12:04:18.189Z | 2024-06-10T12:06:45.221Z |
4389184 | 4389184 | 20240528182928_mtJjt | KR002Y | 2024-05-30T12:05:08.609Z | 2024-06-06T12:14:26.610Z |
4389118 | 4389118 | 20240528180937_P0HzH | KR002Y | 2024-05-30T12:04:55.246Z | 2024-06-06T12:14:26.296Z |
4388772 | 4388772 | 20240528162216_6zRYR | KR002Y | 2024-05-30T12:04:19.676Z | 2024-06-06T12:14:25.343Z |
4385430 | 4385430 | 20240528154228_b6tYl | KR002Y | 2024-05-29T12:03:30.386Z | 2024-06-06T12:14:24.873Z |
4379688 | 4379688 | 20240526190215_NFOir | KR002Y | 2024-05-28T12:04:40.234Z | 2024-06-04T12:17:15.245Z |
4370756 | 4370756 | 20240518191212_LbZjz | KR002Y | 2024-05-26T12:09:45.669Z | 2024-05-26T12:09:53.601Z |
4360426 | 4360426 | 20240516191423_g2poT | KR002Y | 2024-05-25T12:01:56.892Z | 2024-05-25T12:09:10.422Z |
4359988 | 4359988 | 20240516180327_WYen3 | KR002Y | 2024-05-25T12:00:55.434Z | 2024-05-25T12:09:10.324Z |
4353718 | 4353718 | 20240511170334_PQnks | KR002Y | 2024-05-22T12:03:12.934Z | 2024-05-22T12:03:12.934Z |
4344430 | 4344430 | 20240510145922_P7E21 | KR002Y | 2024-05-20T12:01:54.363Z | 2024-05-22T12:09:42.241Z |
4344239 | 4344239 | 20240510143649_VqJ3G | KR002Y | 2024-05-20T12:01:34.977Z | 2024-05-22T12:09:37.497Z |
4344213 | 4344213 | 20240510143417_VMHdr | KR002Y | 2024-05-20T12:01:32.408Z | 2024-05-22T12:09:36.823Z |
4329908 | 4329908 | 20240508193322_LUBbW | KR002Y | 2024-05-17T12:09:10.038Z | 2024-05-19T12:14:29.994Z |
4329880 | 4329880 | 20240508193030_zTMvy | KR002Y | 2024-05-17T12:09:07.496Z | 2024-05-19T12:14:29.298Z |
4329459 | 4329459 | 20240508184112_BhNOO | KR002Y | 2024-05-17T12:08:44.573Z | 2024-05-19T12:14:23.005Z |
4328726 | 4328726 | 20240508180056_19ozz | KR002Y | 2024-05-17T12:07:57.359Z | 2024-05-19T12:14:04.998Z |
4327265 | 4327265 | 20240508171133_GCG3K | KR002Y | 2024-05-17T12:06:45.539Z | 2024-05-19T12:13:37.661Z |
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);