participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
278 rows where station_code = "KR001N" 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 |
---|---|---|---|---|---|
5488520 | 5488520 | 20241105152552_7dy13 | KR001N | 2024-11-07T14:10:04.305Z | 2024-11-14T14:23:06.402Z |
5488250 | 5488250 | 20241105122511_0Luo4 | KR001N | 2024-11-07T14:09:17.513Z | 2024-11-14T14:23:03.886Z |
5487791 | 5487791 | 20241106183627_oLCWV | KR001N | 2024-11-07T14:06:47.359Z | 2024-11-15T14:24:46.596Z |
5131229 | 5131229 | 20240915184419_uJQnf | KR001N | 2024-09-19T12:14:41.497Z | 2024-09-24T12:15:31.959Z |
5111146 | 5111146 | 20240914200822_7ApVi | KR001N | 2024-09-18T12:01:40.777Z | 2024-09-23T12:15:54.583Z |
4507097 | 4507097 | 20240627155551_qzKUD | KR001N | 2024-06-28T12:01:03.880Z | 2024-07-06T12:16:12.121Z |
4389036 | 4389036 | 20240528174829_MHhhg | KR001N | 2024-05-30T12:04:44.705Z | 2024-06-06T12:14:26.047Z |
4385474 | 4385474 | 20240528154950_LwwBl | KR001N | 2024-05-29T12:03:33.788Z | 2024-06-06T12:14:24.943Z |
4385110 | 4385110 | 20240528141206_ZSAcj | KR001N | 2024-05-29T12:02:54.826Z | 2024-06-06T12:14:24.080Z |
4344702 | 4344702 | 20240510152810_XgrLU | KR001N | 2024-05-20T12:02:19.505Z | 2024-05-22T12:09:47.555Z |
4344556 | 4344556 | 20240510152004_3bmQu | KR001N | 2024-05-20T12:02:07.233Z | 2024-05-22T12:09:45.151Z |
4099796 | 4099796 | 20240320184907_Y9Fdc | KR001N | 2024-03-22T12:07:29.127Z | 2024-03-29T12:13:57.856Z |
4099726 | 4099726 | 20240320183631_2RQPe | KR001N | 2024-03-22T12:07:24.272Z | 2024-03-29T12:13:56.570Z |
4099637 | 4099637 | 20240320182223_ZGPnG | KR001N | 2024-03-22T12:07:17.087Z | 2024-03-29T12:13:54.437Z |
4075393 | 4075393 | 20240315185019_HeRA7 | KR001N | 2024-03-17T12:05:54.579Z | 2024-03-24T12:20:30.921Z |
4056430 | 4056430 | 20240309193310_MegC2 | KR001N | 2024-03-11T12:08:09.060Z | 2024-03-18T12:19:53.826Z |
4056224 | 4056224 | 20240309185015_f1cyj | KR001N | 2024-03-11T12:07:43.593Z | 2024-03-18T12:19:52.174Z |
4056203 | 4056203 | 20240309184752_Yp6KC | KR001N | 2024-03-11T12:07:42.567Z | 2024-03-18T12:19:52.069Z |
4056063 | 4056063 | 20240309183052_JoYAO | KR001N | 2024-03-11T12:07:34.776Z | 2024-03-18T12:19:50.908Z |
4055587 | 4055587 | 20240309171915_VBf2r | KR001N | 2024-03-11T12:06:46.273Z | 2024-03-18T12:19:47.313Z |
4055573 | 4055573 | 20240309171856_W3svO | KR001N | 2024-03-11T12:06:45.772Z | 2024-03-18T12:19:47.239Z |
4055549 | 4055549 | 20240309171721_xND2B | KR001N | 2024-03-11T12:06:44.828Z | 2024-03-18T12:19:47.182Z |
4055479 | 4055479 | 20240309171016_JoUH0 | KR001N | 2024-03-11T12:06:41.375Z | 2024-03-18T12:19:46.713Z |
3985169 | 3985169 | 20240217181719_P0GB6 | KR001N | 2024-02-19T14:05:03.098Z | 2024-02-26T14:16:23.298Z |
3985072 | 3985072 | 20240217173850_yZkZB | KR001N | 2024-02-19T14:04:42.042Z | 2024-02-26T14:16:20.486Z |
3984820 | 3984820 | 20240217162739_dQWOj | KR001N | 2024-02-19T14:04:01.450Z | 2024-02-26T14:16:11.119Z |
3984713 | 3984713 | 20240217160449_Wo2HS | KR001N | 2024-02-19T14:03:48.370Z | 2024-02-26T14:16:06.562Z |
3984642 | 3984642 | 20240217155042_psPCV | KR001N | 2024-02-19T14:03:35.006Z | 2024-02-26T14:16:01.787Z |
3984638 | 3984638 | 20240217155015_pyj0Z | KR001N | 2024-02-19T14:03:34.539Z | 2024-02-26T14:16:01.712Z |
3984607 | 3984607 | 20240217154524_Lf2OX | KR001N | 2024-02-19T14:03:30.890Z | 2024-02-26T14:16:00.460Z |
3981183 | 3981183 | 20240216210013_y72QF | KR001N | 2024-02-18T14:05:52.943Z | 2024-02-25T14:18:32.392Z |
3981116 | 3981116 | 20240216203730_y6YoJ | KR001N | 2024-02-18T14:05:47.500Z | 2024-02-25T14:18:31.360Z |
3981049 | 3981049 | 20240216202052_552Te | KR001N | 2024-02-18T14:05:31.995Z | 2024-02-25T14:18:30.122Z |
3981032 | 3981032 | 20240216201353_jOOw4 | KR001N | 2024-02-18T14:05:30.957Z | 2024-02-25T14:18:30.010Z |
3981016 | 3981016 | 20240216201237_4jiWe | KR001N | 2024-02-18T14:05:28.254Z | 2024-02-25T14:18:29.785Z |
3980980 | 3980980 | 20240216200508_zmzrQ | KR001N | 2024-02-18T14:05:24.312Z | 2024-02-25T14:18:29.244Z |
3980910 | 3980910 | 20240216194804_405PN | KR001N | 2024-02-18T14:05:15.252Z | 2024-02-25T14:18:27.921Z |
3980798 | 3980798 | 20240216192247_JhVL4 | KR001N | 2024-02-18T14:04:57.621Z | 2024-02-25T14:18:26.092Z |
3980661 | 3980661 | 20240216184307_33WjJ | KR001N | 2024-02-18T14:04:39.631Z | 2024-02-25T14:18:23.521Z |
3975539 | 3975539 | 20240215195300_vWISV | KR001N | 2024-02-17T14:04:55.536Z | 2024-02-24T14:23:15.528Z |
3975529 | 3975529 | 20240215194613_lFnEQ | KR001N | 2024-02-17T14:04:53.574Z | 2024-02-24T14:23:15.276Z |
3975491 | 3975491 | 20240215192124_yJ6AO | KR001N | 2024-02-17T14:04:43.200Z | 2024-02-24T14:23:14.181Z |
3975471 | 3975471 | 20240215190240_KzpaI | KR001N | 2024-02-17T14:04:40.470Z | 2024-02-24T14:23:13.800Z |
3975464 | 3975464 | 20240215190133_3ZMvT | KR001N | 2024-02-17T14:04:40.046Z | 2024-02-24T14:23:13.553Z |
3837791 | 3837791 | 20240115212019_e7OG2 | KR001N | 2024-01-18T14:14:51.749Z | 2024-01-24T14:19:17.229Z |
3837716 | 3837716 | 20240115211446_OkLIh | KR001N | 2024-01-18T14:14:46.744Z | 2024-01-24T14:19:16.866Z |
3837528 | 3837528 | 20240115210052_dZAOI | KR001N | 2024-01-18T14:14:30.493Z | 2024-01-24T14:19:14.794Z |
3837292 | 3837292 | 20240115203624_gjQV4 | KR001N | 2024-01-18T14:14:14.041Z | 2024-01-24T14:19:13.673Z |
3837160 | 3837160 | 20240115202403_SYmHo | KR001N | 2024-01-18T14:14:08.427Z | 2024-01-24T14:19:12.713Z |
3837141 | 3837141 | 20240115202227_N1Zqi | KR001N | 2024-01-18T14:14:07.811Z | 2024-01-24T14:19:12.700Z |
3837124 | 3837124 | 20240115201949_QlEnu | KR001N | 2024-01-18T14:14:07.407Z | 2024-01-24T14:19:12.691Z |
3836722 | 3836722 | 20240115194830_Qkguw | KR001N | 2024-01-18T14:13:54.139Z | 2024-01-24T14:19:10.688Z |
3836630 | 3836630 | 20240115194058_WXovm | KR001N | 2024-01-18T14:13:47.360Z | 2024-01-24T14:19:10.205Z |
3836401 | 3836401 | 20240115191614_0ib3l | KR001N | 2024-01-18T14:13:29.561Z | 2024-01-24T14:19:09.143Z |
3836271 | 3836271 | 20240115190556_QYD7I | KR001N | 2024-01-18T14:13:20.177Z | 2024-01-24T14:19:08.314Z |
3836115 | 3836115 | 20240115184828_atf1w | KR001N | 2024-01-18T14:13:11.328Z | 2024-01-24T14:19:06.896Z |
3835946 | 3835946 | 20240115183318_pn9ur | KR001N | 2024-01-18T14:12:55.405Z | 2024-01-24T14:19:06.026Z |
3835929 | 3835929 | 20240115183224_TUUmA | KR001N | 2024-01-18T14:12:54.628Z | 2024-01-24T14:19:06.010Z |
3835850 | 3835850 | 20240115182710_6nMgy | KR001N | 2024-01-18T14:12:46.816Z | 2024-01-24T14:19:05.631Z |
3834551 | 3834551 | 20240115145739_QT4RS | KR001N | 2024-01-18T14:10:47.512Z | 2024-01-24T14:18:58.408Z |
3830690 | 3830690 | 20240114212520_67Ls7 | KR001N | 2024-01-17T14:13:54.113Z | 2024-01-23T14:25:22.557Z |
3830618 | 3830618 | 20240114211800_c8FsP | KR001N | 2024-01-17T14:13:50.408Z | 2024-01-23T14:25:22.308Z |
3830609 | 3830609 | 20240114211543_2Nmp6 | KR001N | 2024-01-17T14:13:49.156Z | 2024-01-23T14:25:22.248Z |
3830580 | 3830580 | 20240114210853_foC3V | KR001N | 2024-01-17T14:13:45.164Z | 2024-01-23T14:25:21.864Z |
3830542 | 3830542 | 20240114210313_4LID9 | KR001N | 2024-01-17T14:13:42.343Z | 2024-01-23T14:25:21.716Z |
3830394 | 3830394 | 20240114202221_PeAe7 | KR001N | 2024-01-17T14:13:33.948Z | 2024-01-23T14:25:20.082Z |
3812635 | 3812635 | 20240112171849_gOtCW | KR001N | 2024-01-15T14:12:11.174Z | 2024-01-21T14:27:50.965Z |
3777069 | 3777069 | 20240107211647_fOT2Z | KR001N | 2024-01-10T14:12:22.786Z | 2024-01-16T14:27:28.130Z |
3776924 | 3776924 | 20240107210028_zvhwA | KR001N | 2024-01-10T14:12:15.746Z | 2024-01-16T14:27:27.831Z |
3776755 | 3776755 | 20240107204435_BLDXS | KR001N | 2024-01-10T14:12:03.810Z | 2024-01-16T14:27:27.146Z |
3776653 | 3776653 | 20240107203316_PZPPJ | KR001N | 2024-01-10T14:11:51.285Z | 2024-01-16T14:27:26.390Z |
3776603 | 3776603 | 20240107202816_9022U | KR001N | 2024-01-10T14:11:44.894Z | 2024-01-16T14:27:26.243Z |
3776486 | 3776486 | 20240107201636_z63ZO | KR001N | 2024-01-10T14:11:35.716Z | 2024-01-16T14:27:25.761Z |
3776289 | 3776289 | 20240107195434_SOWUj | KR001N | 2024-01-10T14:11:22.653Z | 2024-01-16T14:27:25.296Z |
3775921 | 3775921 | 20240107192031_mCS3W | KR001N | 2024-01-10T14:10:46.499Z | 2024-01-16T14:27:23.341Z |
3775350 | 3775350 | 20240107183451_chKfe | KR001N | 2024-01-10T14:09:55.327Z | 2024-01-16T14:27:21.319Z |
3775306 | 3775306 | 20240107183053_03b2r | KR001N | 2024-01-10T14:09:52.323Z | 2024-01-16T14:27:20.989Z |
3775208 | 3775208 | 20240107182205_H6dsb | KR001N | 2024-01-10T14:09:47.344Z | 2024-01-16T14:27:20.724Z |
3775113 | 3775113 | 20240107181110_2g06O | KR001N | 2024-01-10T14:09:42.397Z | 2024-01-16T14:27:20.333Z |
3775034 | 3775034 | 20240107180538_TKYK1 | KR001N | 2024-01-10T14:09:35.660Z | 2024-01-16T14:27:20.240Z |
3774976 | 3774976 | 20240107180328_V2RPx | KR001N | 2024-01-10T14:09:29.154Z | 2024-01-16T14:27:20.146Z |
3774495 | 3774495 | 20240107171143_GSTX2 | KR001N | 2024-01-10T14:08:37.695Z | 2024-01-16T14:27:17.928Z |
3205418 | 3205418 | 20231018155106_Sgifz | KR001N | 2024-01-06T00:02:58.977Z | 2024-01-06T00:02:58.977Z |
3199565 | 3199565 | 20231017203026_NpQ3w | KR001N | 2024-01-06T00:02:55.130Z | 2024-01-06T00:02:55.130Z |
3199483 | 3199483 | 20231017201846_k3qlJ | KR001N | 2024-01-06T00:02:55.111Z | 2024-01-06T00:02:55.111Z |
3199224 | 3199224 | 20231017194621_AVaJP | KR001N | 2024-01-06T00:02:55.058Z | 2024-01-06T00:02:55.058Z |
3199134 | 3199134 | 20231017193508_lJysP | KR001N | 2024-01-06T00:02:55.037Z | 2024-01-06T00:02:55.037Z |
3199088 | 3199088 | 20231017192909_mjXbT | KR001N | 2024-01-06T00:02:55.029Z | 2024-01-06T00:02:55.029Z |
3199013 | 3199013 | 20231017191558_HerlA | KR001N | 2024-01-06T00:02:55.009Z | 2024-01-06T00:02:55.009Z |
3199000 | 3199000 | 20231017191142_n8Gud | KR001N | 2024-01-06T00:02:55.006Z | 2024-01-06T00:02:55.006Z |
3198990 | 3198990 | 20231017191110_EKtb3 | KR001N | 2024-01-06T00:02:55.005Z | 2024-01-06T00:02:55.005Z |
3198954 | 3198954 | 20231017190309_MPqRK | KR001N | 2024-01-06T00:02:54.996Z | 2024-01-06T00:02:54.996Z |
3198941 | 3198941 | 20231017190022_P3DOr | KR001N | 2024-01-06T00:02:54.993Z | 2024-01-06T00:02:54.993Z |
3198911 | 3198911 | 20231017185559_KlcYv | KR001N | 2024-01-06T00:02:54.987Z | 2024-01-06T00:02:54.987Z |
3198746 | 3198746 | 20231017183617_bi5sD | KR001N | 2024-01-06T00:02:54.954Z | 2024-01-06T00:02:54.954Z |
3198672 | 3198672 | 20231017182820_38wsS | KR001N | 2024-01-06T00:02:54.940Z | 2024-01-06T00:02:54.940Z |
3198632 | 3198632 | 20231017182134_sND52 | KR001N | 2024-01-06T00:02:54.932Z | 2024-01-06T00:02:54.932Z |
3198447 | 3198447 | 20231017175318_Uy7eX | KR001N | 2024-01-06T00:02:54.890Z | 2024-01-06T00:02:54.890Z |
3198395 | 3198395 | 20231017174525_LkAaL | KR001N | 2024-01-06T00:02:54.877Z | 2024-01-06T00:02:54.877Z |
3198342 | 3198342 | 20231017174128_MYm5P | KR001N | 2024-01-06T00:02:54.866Z | 2024-01-06T00:02:54.866Z |
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);