participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,578 rows where station_code = "KR000B" 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 |
---|---|---|---|---|---|
5467226 | 5467226 | 20241102202600_k9QZT | KR000B | 2024-11-04T14:11:07.820Z | 2024-11-04T14:18:00.282Z |
5467195 | 5467195 | 20241102202228_FSD3W | KR000B | 2024-11-04T14:11:05.053Z | 2024-11-04T14:18:00.256Z |
5467174 | 5467174 | 20241102201906_rEaCh | KR000B | 2024-11-04T14:11:01.767Z | 2024-11-04T14:18:00.242Z |
5466996 | 5466996 | 20241102194245_yHeYG | KR000B | 2024-11-04T14:10:26.725Z | 2024-11-04T14:18:00.142Z |
5466750 | 5466750 | 20241102184622_Up3Cs | KR000B | 2024-11-04T14:09:43.117Z | 2024-11-04T14:18:00.040Z |
5466568 | 5466568 | 20241102180542_eNpJj | KR000B | 2024-11-04T14:09:21.083Z | 2024-11-04T14:17:59.958Z |
5466518 | 5466518 | 20241102175407_JOXCQ | KR000B | 2024-11-04T14:09:05.820Z | 2024-11-04T14:17:59.928Z |
5466455 | 5466455 | 20241102174512_2OCQR | KR000B | 2024-11-04T14:08:55.851Z | 2024-11-04T14:17:59.906Z |
5466407 | 5466407 | 20241102173408_FTOVw | KR000B | 2024-11-04T14:08:48.640Z | 2024-11-04T14:17:59.882Z |
5466288 | 5466288 | 20241102170344_RTdmk | KR000B | 2024-11-04T14:08:33.179Z | 2024-11-04T14:17:59.786Z |
5466266 | 5466266 | 20241102165916_BhS33 | KR000B | 2024-11-04T14:08:28.969Z | 2024-11-04T14:17:59.763Z |
5465998 | 5465998 | 20241102155606_TjTKa | KR000B | 2024-11-04T14:07:50.568Z | 2024-11-04T14:17:59.521Z |
5465962 | 5465962 | 20241102153843_iSjBI | KR000B | 2024-11-04T14:07:34.641Z | 2024-11-04T14:17:59.450Z |
5465956 | 5465956 | 20241102153740_HXrqK | KR000B | 2024-11-04T14:07:34.025Z | 2024-11-04T14:17:59.437Z |
5465939 | 5465939 | 20241102152643_T8M3a | KR000B | 2024-11-04T14:07:28.568Z | 2024-11-04T14:17:59.315Z |
5465897 | 5465897 | 20241102151035_cVs4X | KR000B | 2024-11-04T14:07:20.292Z | 2024-11-04T14:17:59.122Z |
5465841 | 5465841 | 20241102144935_R0g8n | KR000B | 2024-11-04T14:07:12.150Z | 2024-11-04T14:17:59.043Z |
5465837 | 5465837 | 20241102144612_pyEl3 | KR000B | 2024-11-04T14:07:09.737Z | 2024-11-04T14:17:59.028Z |
5465779 | 5465779 | 20241102140311_Aj1b1 | KR000B | 2024-11-04T14:06:42.006Z | 2024-11-04T14:17:58.754Z |
5465655 | 5465655 | 20241102124537_wR4oG | KR000B | 2024-11-04T14:06:04.956Z | 2024-11-04T14:17:58.439Z |
5465550 | 5465550 | 20241102111732_fz8gE | KR000B | 2024-11-04T14:05:22.911Z | 2024-11-04T14:17:58.067Z |
5392520 | 5392520 | 20241026175549_p3zLN | KR000B | 2024-10-28T12:08:05.584Z | 2024-11-04T14:28:40.522Z |
5392509 | 5392509 | 20241026174725_eMPsZ | KR000B | 2024-10-28T12:08:03.426Z | 2024-11-04T14:28:40.281Z |
5392491 | 5392491 | 20241026173439_YBKEn | KR000B | 2024-10-28T12:08:01.530Z | 2024-11-04T14:28:39.374Z |
5392434 | 5392434 | 20241026170137_1TrmT | KR000B | 2024-10-28T12:07:55.811Z | 2024-11-04T14:28:38.757Z |
5392289 | 5392289 | 20241026154738_vo142 | KR000B | 2024-10-28T12:07:40.386Z | 2024-11-04T14:28:38.048Z |
5392094 | 5392094 | 20241026150340_oftOv | KR000B | 2024-10-28T12:07:08.785Z | 2024-11-04T14:28:37.300Z |
5392067 | 5392067 | 20241026145754_Nycze | KR000B | 2024-10-28T12:07:06.897Z | 2024-11-04T14:28:37.266Z |
5391845 | 5391845 | 20241026134351_3i58k | KR000B | 2024-10-28T12:06:37.478Z | 2024-11-04T14:28:36.740Z |
5391762 | 5391762 | 20241026131003_CAR9A | KR000B | 2024-10-28T12:06:22.804Z | 2024-11-04T14:28:36.442Z |
5391622 | 5391622 | 20241026122205_XurZz | KR000B | 2024-10-28T12:05:58.842Z | 2024-11-04T14:28:35.838Z |
5391573 | 5391573 | 20241026121647_xL0M8 | KR000B | 2024-10-28T12:05:51.755Z | 2024-11-04T14:28:35.715Z |
5391316 | 5391316 | 20241026114013_UB9az | KR000B | 2024-10-28T12:05:12.878Z | 2024-11-04T14:28:34.221Z |
5391209 | 5391209 | 20241026112317_F8hEL | KR000B | 2024-10-28T12:04:57.348Z | 2024-11-04T14:28:33.835Z |
5391165 | 5391165 | 20241026111803_MYg5o | KR000B | 2024-10-28T12:04:48.204Z | 2024-11-04T14:28:33.665Z |
5389258 | 5389258 | 20241023201728_fLRrD | KR000B | 2024-10-27T12:24:42.147Z | 2024-11-01T12:26:52.769Z |
5389256 | 5389256 | 20241023200310_FiWIG | KR000B | 2024-10-27T12:24:38.904Z | 2024-11-01T12:26:52.461Z |
5389250 | 5389250 | 20241023195955_RcQbk | KR000B | 2024-10-27T12:24:38.642Z | 2024-11-01T12:26:52.441Z |
5389243 | 5389243 | 20241023194836_73zLd | KR000B | 2024-10-27T12:24:36.583Z | 2024-11-01T12:26:52.143Z |
5389233 | 5389233 | 20241023193828_Qp0OP | KR000B | 2024-10-27T12:24:34.578Z | 2024-11-01T12:26:51.886Z |
5389194 | 5389194 | 20241023190016_6RV04 | KR000B | 2024-10-27T12:24:28.570Z | 2024-11-01T12:26:50.794Z |
5389155 | 5389155 | 20241023174608_Wu2dZ | KR000B | 2024-10-27T12:24:13.455Z | 2024-11-01T12:26:48.700Z |
5389147 | 5389147 | 20241023173943_cmwtR | KR000B | 2024-10-27T12:24:12.615Z | 2024-11-01T12:26:48.467Z |
5389138 | 5389138 | 20241023172445_OKKNu | KR000B | 2024-10-27T12:24:09.962Z | 2024-11-01T12:26:48.227Z |
5389058 | 5389058 | 20241023160520_0425A | KR000B | 2024-10-27T12:24:00.222Z | 2024-11-01T12:26:47.393Z |
5389041 | 5389041 | 20241023153830_N6fdc | KR000B | 2024-10-27T12:23:57.402Z | 2024-11-01T12:26:47.208Z |
5389027 | 5389027 | 20241023152246_fb39y | KR000B | 2024-10-27T12:23:55.348Z | 2024-11-01T12:26:47.040Z |
5388984 | 5388984 | 20241023141005_KKRcC | KR000B | 2024-10-27T12:23:46.927Z | 2024-11-01T12:26:45.972Z |
5388975 | 5388975 | 20241023134430_JaDsr | KR000B | 2024-10-27T12:23:43.929Z | 2024-11-01T12:26:45.691Z |
5388957 | 5388957 | 20241023123201_ACYa9 | KR000B | 2024-10-27T12:23:34.074Z | 2024-11-01T12:26:44.787Z |
5300400 | 5300400 | 20241012203635_7MRDm | KR000B | 2024-10-14T12:13:58.502Z | 2024-10-21T12:23:48.914Z |
5300157 | 5300157 | 20241012200756_2iwiy | KR000B | 2024-10-14T12:13:31.374Z | 2024-10-21T12:23:46.880Z |
5300130 | 5300130 | 20241012200519_BqhbX | KR000B | 2024-10-14T12:13:29.998Z | 2024-10-21T12:23:46.595Z |
5299874 | 5299874 | 20241012194238_Rvlh2 | KR000B | 2024-10-14T12:13:14.819Z | 2024-10-21T12:23:44.662Z |
5299500 | 5299500 | 20241012185609_IVrVA | KR000B | 2024-10-14T12:12:21.571Z | 2024-10-21T12:23:39.801Z |
5299381 | 5299381 | 20241012184021_Vgs6c | KR000B | 2024-10-14T12:12:13.614Z | 2024-10-21T12:23:38.262Z |
5299335 | 5299335 | 20241012183313_Ko81X | KR000B | 2024-10-14T12:12:10.526Z | 2024-10-21T12:23:37.578Z |
5299324 | 5299324 | 20241012183216_QFE2R | KR000B | 2024-10-14T12:12:09.818Z | 2024-10-21T12:23:37.424Z |
5299238 | 5299238 | 20241012182227_a23hS | KR000B | 2024-10-14T12:12:03.557Z | 2024-10-21T12:23:36.032Z |
5298914 | 5298914 | 20241012173346_3s2Hz | KR000B | 2024-10-14T12:11:17.890Z | 2024-10-21T12:23:32.716Z |
5298847 | 5298847 | 20241012172209_DIVtT | KR000B | 2024-10-14T12:11:13.053Z | 2024-10-21T12:23:31.887Z |
5298839 | 5298839 | 20241012172026_VmBP1 | KR000B | 2024-10-14T12:11:12.686Z | 2024-10-21T12:23:31.726Z |
5298787 | 5298787 | 20241012171154_JTAEA | KR000B | 2024-10-14T12:11:09.097Z | 2024-10-21T12:23:31.402Z |
5298764 | 5298764 | 20241012170953_xBsYE | KR000B | 2024-10-14T12:11:07.523Z | 2024-10-21T12:23:30.848Z |
5298745 | 5298745 | 20241012170636_n5J72 | KR000B | 2024-10-14T12:11:06.443Z | 2024-10-21T12:23:30.758Z |
5298699 | 5298699 | 20241012165721_O89qf | KR000B | 2024-10-14T12:11:03.065Z | 2024-10-21T12:23:30.437Z |
5298693 | 5298693 | 20241012165636_0ToOK | KR000B | 2024-10-14T12:11:02.252Z | 2024-10-21T12:23:30.173Z |
5291156 | 5291156 | 20241011201122_HeNHX | KR000B | 2024-10-13T12:14:01.724Z | 2024-10-20T12:24:27.136Z |
5291057 | 5291057 | 20241011194424_cw3hx | KR000B | 2024-10-13T12:13:53.903Z | 2024-10-20T12:24:24.638Z |
5290666 | 5290666 | 20241011183822_i1jLk | KR000B | 2024-10-13T12:13:04.237Z | 2024-10-20T12:24:18.627Z |
5290599 | 5290599 | 20241011183100_jYh5U | KR000B | 2024-10-13T12:12:54.680Z | 2024-10-20T12:24:17.922Z |
5290596 | 5290596 | 20241011183046_ptT5O | KR000B | 2024-10-13T12:12:54.302Z | 2024-10-20T12:24:17.908Z |
5290538 | 5290538 | 20241011181458_0ABJV | KR000B | 2024-10-13T12:12:44.229Z | 2024-10-20T12:24:17.304Z |
5290308 | 5290308 | 20241011171417_THNvZ | KR000B | 2024-10-13T12:12:09.948Z | 2024-10-20T12:24:14.708Z |
5290279 | 5290279 | 20241011170320_smHgs | KR000B | 2024-10-13T12:12:07.551Z | 2024-10-20T12:24:14.436Z |
5289949 | 5289949 | 20241011161857_q2WGV | KR000B | 2024-10-13T12:11:42.043Z | 2024-10-20T12:24:12.070Z |
5289435 | 5289435 | 20241011152917_nk3oP | KR000B | 2024-10-13T12:10:45.798Z | 2024-10-20T12:24:06.710Z |
5288426 | 5288426 | 20241011135824_KrmWh | KR000B | 2024-10-13T12:09:17.339Z | 2024-10-20T12:23:59.109Z |
5288116 | 5288116 | 20241011130338_xJMt3 | KR000B | 2024-10-13T12:08:50.452Z | 2024-10-20T12:23:57.351Z |
5234005 | 5234005 | 20241004203629_mjyJU | KR000B | 2024-10-06T12:14:15.938Z | 2024-10-13T12:26:22.210Z |
5233695 | 5233695 | 20241004201040_iV8ar | KR000B | 2024-10-06T12:13:50.881Z | 2024-10-13T12:26:21.492Z |
5233543 | 5233543 | 20241004195417_ji9Yc | KR000B | 2024-10-06T12:13:41.234Z | 2024-10-13T12:26:21.243Z |
5233452 | 5233452 | 20241004194335_T1xzM | KR000B | 2024-10-06T12:13:31.478Z | 2024-10-13T12:26:21.136Z |
5233356 | 5233356 | 20241004193121_WZUb2 | KR000B | 2024-10-06T12:13:13.915Z | 2024-10-13T12:26:20.887Z |
5233266 | 5233266 | 20241004191831_t1C1q | KR000B | 2024-10-06T12:13:05.461Z | 2024-10-13T12:26:20.777Z |
5233226 | 5233226 | 20241004191429_IRu94 | KR000B | 2024-10-06T12:13:03.157Z | 2024-10-13T12:26:20.739Z |
5233165 | 5233165 | 20241004190848_CP6Gw | KR000B | 2024-10-06T12:12:59.546Z | 2024-10-13T12:26:20.677Z |
5233153 | 5233153 | 20241004190731_tJkA2 | KR000B | 2024-10-06T12:12:58.806Z | 2024-10-13T12:26:20.667Z |
5233108 | 5233108 | 20241004190147_lToY2 | KR000B | 2024-10-06T12:12:55.215Z | 2024-10-13T12:26:20.523Z |
5233104 | 5233104 | 20241004190133_TF2TO | KR000B | 2024-10-06T12:12:54.707Z | 2024-10-13T12:26:20.505Z |
5233070 | 5233070 | 20241004185649_r40fA | KR000B | 2024-10-06T12:12:52.727Z | 2024-10-13T12:26:20.410Z |
5233060 | 5233060 | 20241004185633_3XOjg | KR000B | 2024-10-06T12:12:52.130Z | 2024-10-13T12:26:20.397Z |
5232964 | 5232964 | 20241004183913_ADXXP | KR000B | 2024-10-06T12:12:45.708Z | 2024-10-13T12:26:20.044Z |
5232841 | 5232841 | 20241004182453_CuggH | KR000B | 2024-10-06T12:12:27.343Z | 2024-10-13T12:26:19.848Z |
5232781 | 5232781 | 20241004181558_3I28B | KR000B | 2024-10-06T12:12:18.673Z | 2024-10-13T12:26:19.770Z |
5232770 | 5232770 | 20241004181250_OaGCN | KR000B | 2024-10-06T12:12:18.005Z | 2024-10-13T12:26:19.761Z |
5232685 | 5232685 | 20241004174951_14ONO | KR000B | 2024-10-06T12:12:12.544Z | 2024-10-13T12:26:19.590Z |
5232658 | 5232658 | 20241004173800_hM7rZ | KR000B | 2024-10-06T12:12:10.996Z | 2024-10-13T12:26:19.561Z |
5232643 | 5232643 | 20241004173531_kWEyq | KR000B | 2024-10-06T12:12:10.216Z | 2024-10-13T12:26:19.549Z |
5232587 | 5232587 | 20241004172023_nCm2Z | KR000B | 2024-10-06T12:12:05.821Z | 2024-10-13T12:26:19.428Z |
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);