participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,571 rows where station_code = "KR002P" 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 |
---|---|---|---|---|---|
5467185 | 5467185 | 20241102202037_2EFS3 | KR002P | 2024-11-04T14:11:03.867Z | 2024-11-04T14:18:00.251Z |
5467022 | 5467022 | 20241102194703_Dqbd5 | KR002P | 2024-11-04T14:10:28.610Z | 2024-11-04T14:18:00.152Z |
5466975 | 5466975 | 20241102193804_0ocgL | KR002P | 2024-11-04T14:10:24.670Z | 2024-11-04T14:18:00.136Z |
5466973 | 5466973 | 20241102193611_FHhlx | KR002P | 2024-11-04T14:10:24.391Z | 2024-11-04T14:18:00.135Z |
5466848 | 5466848 | 20241102190933_fI21D | KR002P | 2024-11-04T14:10:01.587Z | 2024-11-04T14:18:00.076Z |
5466683 | 5466683 | 20241102183417_VVXOz | KR002P | 2024-11-04T14:09:33.535Z | 2024-11-04T14:18:00.014Z |
5466648 | 5466648 | 20241102182448_dJVLi | KR002P | 2024-11-04T14:09:29.680Z | 2024-11-04T14:17:59.995Z |
5466607 | 5466607 | 20241102181632_KfxO2 | KR002P | 2024-11-04T14:09:24.883Z | 2024-11-04T14:17:59.979Z |
5466595 | 5466595 | 20241102181134_O6F2s | KR002P | 2024-11-04T14:09:23.814Z | 2024-11-04T14:17:59.975Z |
5466574 | 5466574 | 20241102180542_eNpJj | KR002P | 2024-11-04T14:09:21.083Z | 2024-11-04T14:17:59.958Z |
5466565 | 5466565 | 20241102180514_sOLJ9 | KR002P | 2024-11-04T14:09:20.330Z | 2024-11-04T14:17:59.956Z |
5466463 | 5466463 | 20241102174623_LDvy2 | KR002P | 2024-11-04T14:08:56.238Z | 2024-11-04T14:17:59.907Z |
5466327 | 5466327 | 20241102171326_mRG89 | KR002P | 2024-11-04T14:08:37.450Z | 2024-11-04T14:17:59.821Z |
5466221 | 5466221 | 20241102165338_u12zA | KR002P | 2024-11-04T14:08:17.965Z | 2024-11-04T14:17:59.691Z |
5466072 | 5466072 | 20241102161446_1vuPQ | KR002P | 2024-11-04T14:07:58.208Z | 2024-11-04T14:17:59.583Z |
5466054 | 5466054 | 20241102160947_Jq1HZ | KR002P | 2024-11-04T14:07:56.784Z | 2024-11-04T14:17:59.576Z |
5466032 | 5466032 | 20241102160451_XNAbN | KR002P | 2024-11-04T14:07:54.368Z | 2024-11-04T14:17:59.562Z |
5465944 | 5465944 | 20241102152934_dA4Jp | KR002P | 2024-11-04T14:07:29.329Z | 2024-11-04T14:17:59.327Z |
5465877 | 5465877 | 20241102150348_n2qgC | KR002P | 2024-11-04T14:07:16.581Z | 2024-11-04T14:17:59.087Z |
5439817 | 5439817 | 20241030203421_kJKCV | KR002P | 2024-11-01T12:14:31.646Z | 2024-11-04T14:24:56.861Z |
5439756 | 5439756 | 20241030202806_n33bL | KR002P | 2024-11-01T12:14:25.306Z | 2024-11-04T14:24:56.574Z |
5439659 | 5439659 | 20241030201730_kbiub | KR002P | 2024-11-01T12:14:07.120Z | 2024-11-04T14:24:55.716Z |
5439552 | 5439552 | 20241030200647_MsoJy | KR002P | 2024-11-01T12:13:58.637Z | 2024-11-04T14:24:54.737Z |
5439533 | 5439533 | 20241030200414_UNdke | KR002P | 2024-11-01T12:13:56.826Z | 2024-11-04T14:24:54.586Z |
5439355 | 5439355 | 20241030194648_SKPba | KR002P | 2024-11-01T12:13:44.818Z | 2024-11-04T14:24:52.422Z |
5439249 | 5439249 | 20241030193044_VcOhh | KR002P | 2024-11-01T12:13:21.967Z | 2024-11-04T14:24:51.284Z |
5439202 | 5439202 | 20241030192218_RzMOr | KR002P | 2024-11-01T12:13:17.723Z | 2024-11-04T14:24:50.996Z |
5439142 | 5439142 | 20241030190655_BUvaZ | KR002P | 2024-11-01T12:13:11.073Z | 2024-11-04T14:24:49.193Z |
5439102 | 5439102 | 20241030185822_r3ZzV | KR002P | 2024-11-01T12:13:07.618Z | 2024-11-04T14:24:48.547Z |
5439021 | 5439021 | 20241030184530_uXbcS | KR002P | 2024-11-01T12:13:00.227Z | 2024-11-04T14:24:47.253Z |
5438785 | 5438785 | 20241030180359_P39Pj | KR002P | 2024-11-01T12:12:26.286Z | 2024-11-04T14:24:43.314Z |
5438598 | 5438598 | 20241030174005_tXU5d | KR002P | 2024-11-01T12:12:01.724Z | 2024-11-04T14:24:41.297Z |
5438535 | 5438535 | 20241030173216_eREmf | KR002P | 2024-11-01T12:11:50.617Z | 2024-11-04T14:24:40.466Z |
5438518 | 5438518 | 20241030172943_9jpbY | KR002P | 2024-11-01T12:11:49.265Z | 2024-11-04T14:24:40.409Z |
5438453 | 5438453 | 20241030172115_G3k32 | KR002P | 2024-11-01T12:11:43.320Z | 2024-11-04T14:24:38.749Z |
5438338 | 5438338 | 20241030170520_DVgpU | KR002P | 2024-11-01T12:11:33.649Z | 2024-11-04T14:24:37.303Z |
5438286 | 5438286 | 20241030165611_WbFfM | KR002P | 2024-11-01T12:11:28.665Z | 2024-11-04T14:24:36.957Z |
5438257 | 5438257 | 20241030165125_V9Hp8 | KR002P | 2024-11-01T12:11:25.330Z | 2024-11-04T14:24:36.770Z |
5438018 | 5438018 | 20241030161446_3A6Xz | KR002P | 2024-11-01T12:10:52.363Z | 2024-11-04T14:24:35.187Z |
5437671 | 5437671 | 20241030153349_SgiQT | KR002P | 2024-11-01T12:10:10.603Z | 2024-11-04T14:24:32.439Z |
5437534 | 5437534 | 20241030151801_IfXqw | KR002P | 2024-11-01T12:09:57.775Z | 2024-11-04T14:24:31.281Z |
5437148 | 5437148 | 20241030143422_okeKi | KR002P | 2024-11-01T12:09:09.396Z | 2024-11-04T14:24:28.128Z |
5436631 | 5436631 | 20241030132927_Y5Nuh | KR002P | 2024-11-01T12:07:59.273Z | 2024-11-04T14:24:23.800Z |
5426509 | 5426509 | 20241029195900_gppwY | KR002P | 2024-10-31T12:10:09.704Z | 2024-11-04T14:26:12.367Z |
5426372 | 5426372 | 20241029194110_rCfu5 | KR002P | 2024-10-31T12:09:54.367Z | 2024-11-04T14:26:11.076Z |
5426229 | 5426229 | 20241029191547_xCvSg | KR002P | 2024-10-31T12:09:41.672Z | 2024-11-04T14:26:09.186Z |
5426163 | 5426163 | 20241029190340_RsYYA | KR002P | 2024-10-31T12:09:30.011Z | 2024-11-04T14:26:08.670Z |
5426146 | 5426146 | 20241029185704_7alBL | KR002P | 2024-10-31T12:09:26.164Z | 2024-11-04T14:26:08.423Z |
5425746 | 5425746 | 20241029174943_6uXhN | KR002P | 2024-10-31T12:08:30.147Z | 2024-11-04T14:26:04.692Z |
5425742 | 5425742 | 20241029174942_WYhRR | KR002P | 2024-10-31T12:08:29.840Z | 2024-11-04T14:26:04.689Z |
5425687 | 5425687 | 20241029173736_AFQIm | KR002P | 2024-10-31T12:08:19.741Z | 2024-11-04T14:26:04.477Z |
5425647 | 5425647 | 20241029172740_b2ODr | KR002P | 2024-10-31T12:08:14.168Z | 2024-11-04T14:26:04.173Z |
5425356 | 5425356 | 20241029163012_nluzh | KR002P | 2024-10-31T12:07:31.060Z | 2024-11-04T14:26:02.233Z |
5425197 | 5425197 | 20241029160822_CR4bO | KR002P | 2024-10-31T12:07:08.938Z | 2024-11-04T14:26:01.646Z |
5424972 | 5424972 | 20241029153726_ZVY64 | KR002P | 2024-10-31T12:06:36.321Z | 2024-11-04T14:26:00.957Z |
5424693 | 5424693 | 20241029150042_KGmRV | KR002P | 2024-10-31T12:05:51.118Z | 2024-11-04T14:25:58.402Z |
5424641 | 5424641 | 20241029145435_wfUj3 | KR002P | 2024-10-31T12:05:38.917Z | 2024-11-04T14:25:58.216Z |
5424635 | 5424635 | 20241029145428_DVEMy | KR002P | 2024-10-31T12:05:37.742Z | 2024-11-04T14:25:58.203Z |
5424616 | 5424616 | 20241029145204_7LAuj | KR002P | 2024-10-31T12:05:34.772Z | 2024-11-04T14:25:58.186Z |
5394312 | 5394312 | 20241025201438_qOpTd | KR002P | 2024-10-28T12:14:22.155Z | 2024-11-03T14:27:20.797Z |
5394229 | 5394229 | 20241025200023_xP7B5 | KR002P | 2024-10-28T12:14:14.204Z | 2024-11-03T14:27:20.412Z |
5394002 | 5394002 | 20241025192312_g02nx | KR002P | 2024-10-28T12:13:57.899Z | 2024-11-03T14:27:19.525Z |
5393898 | 5393898 | 20241025190643_3w3Dx | KR002P | 2024-10-28T12:13:50.178Z | 2024-11-03T14:27:18.841Z |
5392031 | 5392031 | 20241026144115_dHUGE | KR002P | 2024-10-28T12:07:03.489Z | 2024-11-04T14:28:37.231Z |
5391896 | 5391896 | 20241026140722_5YXws | KR002P | 2024-10-28T12:06:49.887Z | 2024-11-04T14:28:36.882Z |
5391753 | 5391753 | 20241026130741_NRBhR | KR002P | 2024-10-28T12:06:21.736Z | 2024-11-04T14:28:36.407Z |
5389255 | 5389255 | 20241023195955_RcQbk | KR002P | 2024-10-27T12:24:38.642Z | 2024-11-01T12:26:52.441Z |
5382881 | 5382881 | 20241024171654_dKwcS | KR002P | 2024-10-27T12:14:33.561Z | 2024-11-02T12:28:24.499Z |
5382786 | 5382786 | 20241024170704_4RQ3x | KR002P | 2024-10-27T12:14:26.975Z | 2024-11-02T12:28:24.307Z |
5382506 | 5382506 | 20241024163209_WS9M0 | KR002P | 2024-10-27T12:13:55.735Z | 2024-11-02T12:28:23.711Z |
5382329 | 5382329 | 20241024161757_yrv2W | KR002P | 2024-10-27T12:13:26.848Z | 2024-11-02T12:28:23.595Z |
5382294 | 5382294 | 20241024161546_9lOcN | KR002P | 2024-10-27T12:13:23.895Z | 2024-11-02T12:28:23.561Z |
5382160 | 5382160 | 20241024160623_bwRG0 | KR002P | 2024-10-27T12:13:15.513Z | 2024-11-02T12:28:23.487Z |
5371807 | 5371807 | 20241024152236_PEWfE | KR002P | 2024-10-26T12:12:45.674Z | 2024-11-02T12:28:22.836Z |
5363107 | 5363107 | 20241023202637_ls4ui | KR002P | 2024-10-25T12:15:29.022Z | 2024-11-01T12:26:52.859Z |
5362794 | 5362794 | 20241023200037_fLEEq | KR002P | 2024-10-25T12:15:08.373Z | 2024-11-01T12:26:52.447Z |
5362723 | 5362723 | 20241023195619_kVdjY | KR002P | 2024-10-25T12:15:03.787Z | 2024-11-01T12:26:52.312Z |
5362498 | 5362498 | 20241023193655_LHfye | KR002P | 2024-10-25T12:14:36.059Z | 2024-11-01T12:26:51.868Z |
5362426 | 5362426 | 20241023193330_atJgM | KR002P | 2024-10-25T12:14:26.813Z | 2024-11-01T12:26:51.653Z |
5362221 | 5362221 | 20241023191733_OoOr2 | KR002P | 2024-10-25T12:14:02.252Z | 2024-11-01T12:26:51.109Z |
5362010 | 5362010 | 20241023190153_BBVW9 | KR002P | 2024-10-25T12:13:45.532Z | 2024-11-01T12:26:50.834Z |
5362005 | 5362005 | 20241023190112_9R6Gw | KR002P | 2024-10-25T12:13:45.228Z | 2024-11-01T12:26:50.804Z |
5361894 | 5361894 | 20241023185553_krVdc | KR002P | 2024-10-25T12:13:38.710Z | 2024-11-01T12:26:50.709Z |
5361873 | 5361873 | 20241023185345_4wOOJ | KR002P | 2024-10-25T12:13:37.224Z | 2024-11-01T12:26:50.636Z |
5361684 | 5361684 | 20241023183607_FZNgp | KR002P | 2024-10-25T12:13:09.990Z | 2024-11-01T12:26:50.457Z |
5361263 | 5361263 | 20241023180309_q9ImD | KR002P | 2024-10-25T12:12:31.138Z | 2024-10-26T12:23:09.042Z |
5361086 | 5361086 | 20241023174808_JYjnq | KR002P | 2024-10-25T12:12:18.571Z | 2024-11-01T12:26:48.863Z |
5360980 | 5360980 | 20241023173748_zF1TE | KR002P | 2024-10-25T12:12:01.152Z | 2024-11-01T12:26:48.460Z |
5360820 | 5360820 | 20241023171656_gFxae | KR002P | 2024-10-25T12:11:33.868Z | 2024-11-01T12:26:48.183Z |
5360760 | 5360760 | 20241023170544_E2VcK | KR002P | 2024-10-25T12:11:28.471Z | 2024-11-01T12:26:47.839Z |
5360615 | 5360615 | 20241023164712_Hy65I | KR002P | 2024-10-25T12:11:17.601Z | 2024-11-01T12:26:47.623Z |
5360295 | 5360295 | 20241023155536_vHqtD | KR002P | 2024-10-25T12:10:28.728Z | 2024-11-01T12:26:47.339Z |
5359993 | 5359993 | 20241023151108_YvSIK | KR002P | 2024-10-25T12:09:50.476Z | 2024-11-01T12:26:46.977Z |
5359650 | 5359650 | 20241023142051_7G3kx | KR002P | 2024-10-25T12:09:01.588Z | 2024-11-01T12:26:46.005Z |
5359374 | 5359374 | 20241023132212_s05Bv | KR002P | 2024-10-25T12:08:28.655Z | 2024-11-01T12:26:45.499Z |
5322966 | 5322966 | 20241019201906_22D6w | KR002P | 2024-10-20T12:03:38.627Z | 2024-10-28T12:26:42.499Z |
5322948 | 5322948 | 20241019193604_8n235 | KR002P | 2024-10-20T12:03:36.255Z | 2024-10-28T12:26:42.268Z |
5322920 | 5322920 | 20241019190536_pyjEB | KR002P | 2024-10-20T12:03:31.854Z | 2024-10-28T12:26:42.108Z |
5322914 | 5322914 | 20241019185922_3Gfu9 | KR002P | 2024-10-20T12:03:31.082Z | 2024-10-28T12:26:42.044Z |
5322908 | 5322908 | 20241019184553_dsQ3t | KR002P | 2024-10-20T12:03:29.918Z | 2024-10-28T12:26:41.902Z |
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);