participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,746 rows where station_code = "KR000C" 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 |
---|---|---|---|---|---|
5124072 | 5124072 | 20240914144416_h5ImA | KR000C | 2024-09-18T12:12:05.373Z | 2024-09-18T12:12:29.029Z |
5110790 | 5110790 | 20240914184505_xMIi6 | KR000C | 2024-09-18T12:00:58.957Z | 2024-09-18T12:12:17.857Z |
5110622 | 5110622 | 20240914173921_h2eFw | KR000C | 2024-09-18T12:00:34.777Z | 2024-09-18T12:12:17.809Z |
5110602 | 5110602 | 20240914173230_nHpu0 | KR000C | 2024-09-18T12:00:32.481Z | 2024-09-18T12:12:17.804Z |
5110300 | 5110300 | 20240913144909_gAz3b | KR000C | 2024-09-17T12:15:03.890Z | 2024-09-18T12:13:31.911Z |
5110266 | 5110266 | 20240913142020_qVdXg | KR000C | 2024-09-17T12:15:02.248Z | 2024-09-18T12:13:31.239Z |
5098829 | 5098829 | 20240913194649_vDJz5 | KR000C | 2024-09-17T12:01:44.322Z | 2024-09-18T12:12:26.114Z |
5098821 | 5098821 | 20240913194541_Nh7PW | KR000C | 2024-09-17T12:01:42.441Z | 2024-09-18T12:12:26.108Z |
5098710 | 5098710 | 20240913190610_nWQOL | KR000C | 2024-09-17T12:01:24.208Z | 2024-09-18T12:12:26.045Z |
5098689 | 5098689 | 20240913185934_Cvxv4 | KR000C | 2024-09-17T12:01:21.582Z | 2024-09-18T12:12:26.034Z |
5098671 | 5098671 | 20240913185400_vj2ce | KR000C | 2024-09-17T12:01:16.992Z | 2024-09-18T12:12:26.021Z |
5098664 | 5098664 | 20240913185320_oNIhe | KR000C | 2024-09-17T12:01:15.850Z | 2024-09-18T12:12:26.016Z |
5098640 | 5098640 | 20240913184659_IfnZA | KR000C | 2024-09-17T12:01:12.656Z | 2024-09-18T12:12:26.004Z |
5098599 | 5098599 | 20240913182745_m8J2K | KR000C | 2024-09-17T12:01:01.330Z | 2024-09-18T12:12:25.977Z |
5098556 | 5098556 | 20240913181052_QyWZp | KR000C | 2024-09-17T12:00:54.612Z | 2024-09-18T12:12:25.949Z |
5098522 | 5098522 | 20240913175401_3oss9 | KR000C | 2024-09-17T12:00:49.388Z | 2024-09-18T12:12:25.924Z |
5097097 | 5097097 | 20240912143733_PTfg1 | KR000C | 2024-09-16T12:16:44.935Z | 2024-09-18T12:14:13.500Z |
5097003 | 5097003 | 20240912132937_cwVIT | KR000C | 2024-09-16T12:16:42.006Z | 2024-09-18T12:14:12.897Z |
5096963 | 5096963 | 20240912131245_1kkz1 | KR000C | 2024-09-16T12:16:40.796Z | 2024-09-18T12:14:12.713Z |
5096926 | 5096926 | 20240912122938_s8UFU | KR000C | 2024-09-16T12:16:38.234Z | 2024-09-18T12:14:12.612Z |
5096542 | 5096542 | 20240912111015_QVkgw | KR000C | 2024-09-16T12:16:27.164Z | 2024-09-18T12:14:10.826Z |
5096368 | 5096368 | 20240912103923_lqXLC | KR000C | 2024-09-16T12:16:21.746Z | 2024-09-18T12:14:10.059Z |
5084261 | 5084261 | 20240912190349_TubWd | KR000C | 2024-09-16T12:01:43.280Z | 2024-09-18T12:12:37.034Z |
5063188 | 5063188 | 20240909201315_aUPgg | KR000C | 2024-09-14T12:13:39.069Z | 2024-09-18T12:15:13.326Z |
5063120 | 5063120 | 20240909200000_PXU6w | KR000C | 2024-09-14T12:13:32.147Z | 2024-09-18T12:15:13.073Z |
5063024 | 5063024 | 20240909194026_U2ZcI | KR000C | 2024-09-14T12:13:19.721Z | 2024-09-18T12:15:12.899Z |
5063022 | 5063022 | 20240909193933_D251M | KR000C | 2024-09-14T12:13:19.227Z | 2024-09-18T12:15:12.897Z |
5062990 | 5062990 | 20240909193053_XZ3Gs | KR000C | 2024-09-14T12:13:14.651Z | 2024-09-18T12:15:12.778Z |
5062972 | 5062972 | 20240909192354_MtXP3 | KR000C | 2024-09-14T12:13:11.770Z | 2024-09-18T12:15:12.721Z |
5062749 | 5062749 | 20240909181327_COhaf | KR000C | 2024-09-14T12:12:47.196Z | 2024-09-18T12:15:12.019Z |
5062712 | 5062712 | 20240909180408_IXQRr | KR000C | 2024-09-14T12:12:44.775Z | 2024-09-18T12:15:11.947Z |
5062681 | 5062681 | 20240909180023_kKAd2 | KR000C | 2024-09-14T12:12:42.892Z | 2024-09-18T12:15:11.883Z |
5062634 | 5062634 | 20240909175156_5yXYP | KR000C | 2024-09-14T12:12:39.214Z | 2024-09-18T12:15:11.711Z |
5062599 | 5062599 | 20240909174532_HmfSh | KR000C | 2024-09-14T12:12:35.999Z | 2024-09-18T12:15:11.563Z |
5062390 | 5062390 | 20240909171907_K20WD | KR000C | 2024-09-14T12:12:16.849Z | 2024-09-18T12:15:11.286Z |
5062341 | 5062341 | 20240909171113_zc6t3 | KR000C | 2024-09-14T12:12:11.695Z | 2024-09-18T12:15:10.948Z |
5062320 | 5062320 | 20240909171032_i2BtJ | KR000C | 2024-09-14T12:12:09.319Z | 2024-09-18T12:15:10.897Z |
5062273 | 5062273 | 20240909170548_BlLr9 | KR000C | 2024-09-14T12:12:04.349Z | 2024-09-18T12:15:10.828Z |
5062233 | 5062233 | 20240909170148_7WLCY | KR000C | 2024-09-14T12:11:57.965Z | 2024-09-18T12:15:10.799Z |
5062116 | 5062116 | 20240909164531_5BJPc | KR000C | 2024-09-14T12:11:50.020Z | 2024-09-18T12:15:10.411Z |
5061545 | 5061545 | 20240909152217_U34PN | KR000C | 2024-09-14T12:10:57.090Z | 2024-09-18T12:15:09.569Z |
5060896 | 5060896 | 20240909131707_Fe0aJ | KR000C | 2024-09-14T12:09:54.239Z | 2024-09-18T12:15:07.214Z |
5057092 | 5057092 | 20240908121035_C6x9v | KR000C | 2024-09-13T12:17:44.601Z | 2024-09-16T12:21:28.766Z |
5051401 | 5051401 | 20240907172416_81mlH | KR000C | 2024-09-13T12:14:13.272Z | 2024-09-16T12:21:00.333Z |
5050717 | 5050717 | 20240907160145_IoNsD | KR000C | 2024-09-13T12:13:44.777Z | 2024-09-16T12:20:58.377Z |
5045775 | 5045775 | 20240908191632_6pA0v | KR000C | 2024-09-13T12:04:55.361Z | 2024-09-17T12:18:57.277Z |
5044686 | 5044686 | 20240908152819_5R9XP | KR000C | 2024-09-13T12:02:47.215Z | 2024-09-17T12:18:54.845Z |
5044630 | 5044630 | 20240908152512_tSLHf | KR000C | 2024-09-13T12:02:36.658Z | 2024-09-17T12:18:54.771Z |
5038401 | 5038401 | 20240905200358_5Y4CC | KR000C | 2024-09-12T12:14:38.394Z | 2024-09-14T12:22:55.942Z |
5036101 | 5036101 | 20240905124058_qNdFW | KR000C | 2024-09-12T12:13:23.567Z | 2024-09-14T12:22:51.867Z |
5024090 | 5024090 | 20240905200358_K5UcD | KR000C | 2024-09-11T12:02:36.685Z | 2024-09-11T12:16:31.936Z |
5018765 | 5018765 | 20240904201100_sNw8Z | KR000C | 2024-09-10T12:11:31.244Z | 2024-09-13T12:19:48.844Z |
5018741 | 5018741 | 20240904200243_Cb9v3 | KR000C | 2024-09-10T12:11:28.881Z | 2024-09-13T12:19:48.675Z |
5018706 | 5018706 | 20240904194702_6IMGa | KR000C | 2024-09-10T12:11:20.391Z | 2024-09-13T12:19:48.561Z |
5018681 | 5018681 | 20240904193158_0VjZL | KR000C | 2024-09-10T12:11:12.607Z | 2024-09-13T12:19:48.524Z |
5018637 | 5018637 | 20240904191613_3PNCd | KR000C | 2024-09-10T12:11:04.395Z | 2024-09-13T12:19:48.382Z |
5018581 | 5018581 | 20240904185522_3bOqy | KR000C | 2024-09-10T12:10:53.364Z | 2024-09-13T12:19:48.179Z |
5018577 | 5018577 | 20240904185509_M0nDR | KR000C | 2024-09-10T12:10:52.606Z | 2024-09-13T12:19:48.177Z |
5018568 | 5018568 | 20240904185104_4cYLi | KR000C | 2024-09-10T12:10:51.782Z | 2024-09-13T12:19:48.172Z |
5018464 | 5018464 | 20240904181507_g3YkA | KR000C | 2024-09-10T12:10:40.379Z | 2024-09-13T12:19:47.939Z |
5018449 | 5018449 | 20240904181241_XLKtq | KR000C | 2024-09-10T12:10:38.562Z | 2024-09-13T12:19:47.909Z |
5018259 | 5018259 | 20240904173219_peVHN | KR000C | 2024-09-10T12:10:17.285Z | 2024-09-13T12:19:47.467Z |
5018137 | 5018137 | 20240904171328_Gh62V | KR000C | 2024-09-10T12:10:03.246Z | 2024-09-13T12:19:47.250Z |
5018076 | 5018076 | 20240904170915_rtLJp | KR000C | 2024-09-10T12:09:57.818Z | 2024-09-13T12:19:47.183Z |
5016856 | 5016856 | 20240904150559_h3WvC | KR000C | 2024-09-10T12:08:25.424Z | 2024-09-13T12:19:46.397Z |
5016030 | 5016030 | 20240904132253_3ORGB | KR000C | 2024-09-10T12:07:14.243Z | 2024-09-13T12:19:45.140Z |
5016006 | 5016006 | 20240904131702_7wmhr | KR000C | 2024-09-10T12:07:10.459Z | 2024-09-13T12:19:45.104Z |
5015991 | 5015991 | 20240904131437_6IHAB | KR000C | 2024-09-10T12:07:09.095Z | 2024-09-13T12:19:45.091Z |
5014421 | 5014421 | 20240905124058_t4V5H | KR000C | 2024-09-10T12:03:06.659Z | 2024-09-11T12:16:31.152Z |
5007113 | 5007113 | 20240903195913_dqGqO | KR000C | 2024-09-09T12:05:26.937Z | 2024-09-12T12:19:11.529Z |
5006692 | 5006692 | 20240903182623_YDdCU | KR000C | 2024-09-09T12:04:55.456Z | 2024-09-12T12:19:09.244Z |
5006224 | 5006224 | 20240903170711_2525P | KR000C | 2024-09-09T12:04:25.678Z | 2024-09-12T12:19:07.984Z |
5005692 | 5005692 | 20240903155703_XhgFH | KR000C | 2024-09-09T12:03:55.539Z | 2024-09-12T12:19:06.450Z |
5005510 | 5005510 | 20240903152532_X7nLd | KR000C | 2024-09-09T12:03:46.783Z | 2024-09-12T12:19:06.115Z |
5005506 | 5005506 | 20240903152442_2ya24 | KR000C | 2024-09-09T12:03:46.443Z | 2024-09-12T12:19:06.102Z |
5005452 | 5005452 | 20240903151606_s7V0X | KR000C | 2024-09-09T12:03:43.324Z | 2024-09-12T12:19:05.954Z |
5005385 | 5005385 | 20240903150445_RV5g4 | KR000C | 2024-09-09T12:03:39.948Z | 2024-09-12T12:19:05.852Z |
5004916 | 5004916 | 20240903132433_3js8r | KR000C | 2024-09-09T12:03:11.205Z | 2024-09-12T12:19:04.483Z |
5004856 | 5004856 | 20240903130715_rN9KF | KR000C | 2024-09-09T12:03:08.118Z | 2024-09-12T12:19:04.354Z |
4987602 | 4987602 | 20240901180754_r2Qag | KR000C | 2024-09-07T12:05:59.014Z | 2024-09-10T12:19:11.017Z |
4987576 | 4987576 | 20240901180249_TH2K2 | KR000C | 2024-09-07T12:05:57.520Z | 2024-09-10T12:19:11.001Z |
4987463 | 4987463 | 20240901173732_2zWmC | KR000C | 2024-09-07T12:05:49.873Z | 2024-09-10T12:19:10.811Z |
4987398 | 4987398 | 20240901172437_KscQP | KR000C | 2024-09-07T12:05:43.254Z | 2024-09-10T12:19:10.706Z |
4986001 | 4986001 | 20240901140222_ilGlY | KR000C | 2024-09-07T12:04:00.869Z | 2024-09-10T12:19:08.766Z |
4985763 | 4985763 | 20240901133009_UB3kW | KR000C | 2024-09-07T12:03:44.525Z | 2024-09-10T12:19:08.334Z |
4963240 | 4963240 | 20240811195133_oQ2cz | KR000C | 2024-09-04T12:05:21.702Z | 2024-09-06T12:04:25.473Z |
4963104 | 4963104 | 20240811194330_5X19c | KR000C | 2024-09-04T12:05:11.074Z | 2024-09-06T12:04:18.519Z |
4963102 | 4963102 | 20240811194322_CHlTB | KR000C | 2024-09-04T12:05:10.836Z | 2024-09-06T12:04:18.321Z |
4963084 | 4963084 | 20240811194228_UlBHs | KR000C | 2024-09-04T12:05:10.053Z | 2024-09-06T12:04:17.623Z |
4963037 | 4963037 | 20240811193846_Pvw2P | KR000C | 2024-09-04T12:05:07.538Z | 2024-09-06T12:04:15.756Z |
4962927 | 4962927 | 20240811193230_e54uq | KR000C | 2024-09-04T12:04:59.905Z | 2024-09-06T12:04:11.631Z |
4962876 | 4962876 | 20240811192951_v3CXg | KR000C | 2024-09-04T12:04:57.297Z | 2024-09-06T12:04:09.919Z |
4962866 | 4962866 | 20240811192904_weZjP | KR000C | 2024-09-04T12:04:56.680Z | 2024-09-06T12:04:09.404Z |
4962844 | 4962844 | 20240811192721_LBlw0 | KR000C | 2024-09-04T12:04:55.300Z | 2024-09-06T12:04:08.418Z |
4962767 | 4962767 | 20240811192123_Hzsj5 | KR000C | 2024-09-04T12:04:51.084Z | 2024-09-06T12:04:01.822Z |
4962750 | 4962750 | 20240811192054_QDtZ1 | KR000C | 2024-09-04T12:04:50.105Z | 2024-09-06T12:04:01.026Z |
4962654 | 4962654 | 20240811191434_YCA9l | KR000C | 2024-09-04T12:04:45.608Z | 2024-09-06T12:03:55.055Z |
4962543 | 4962543 | 20240811190720_Ar0Bg | KR000C | 2024-09-04T12:04:38.238Z | 2024-09-06T12:03:50.685Z |
4962385 | 4962385 | 20240811185232_NIG4a | KR000C | 2024-09-04T12:04:28.122Z | 2024-09-06T12:03:44.305Z |
4962361 | 4962361 | 20240811185119_m98YT | KR000C | 2024-09-04T12:04:26.937Z | 2024-09-06T12:03:43.446Z |
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);