participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,512 rows where station_code = "KR003M" 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 |
---|---|---|---|---|---|
5524887 | 5524887 | 20241109163313_1BjPi | KR003M | 2024-11-12T14:19:38.424Z | 2024-11-12T14:19:38.424Z |
5522639 | 5522639 | 20241110204957_4ygt7 | KR003M | 2024-11-12T14:13:50.005Z | 2024-11-12T14:18:07.835Z |
5522602 | 5522602 | 20241110204131_DC6xf | KR003M | 2024-11-12T14:13:43.846Z | 2024-11-12T14:18:07.820Z |
5522568 | 5522568 | 20241110203247_CxGgy | KR003M | 2024-11-12T14:13:37.232Z | 2024-11-12T14:18:07.805Z |
5522525 | 5522525 | 20241110201917_TVakx | KR003M | 2024-11-12T14:13:28.910Z | 2024-11-12T14:18:07.783Z |
5522468 | 5522468 | 20241110200710_WUuCB | KR003M | 2024-11-12T14:13:18.775Z | 2024-11-12T14:18:07.757Z |
5522295 | 5522295 | 20241110193921_HDTJ9 | KR003M | 2024-11-12T14:13:03.033Z | 2024-11-12T14:18:07.680Z |
5522212 | 5522212 | 20241110192609_sr7zR | KR003M | 2024-11-12T14:12:58.138Z | 2024-11-12T14:18:07.649Z |
5522153 | 5522153 | 20241110191416_0hwjq | KR003M | 2024-11-12T14:12:54.047Z | 2024-11-12T14:18:07.620Z |
5522080 | 5522080 | 20241110190320_3b5EF | KR003M | 2024-11-12T14:12:43.010Z | 2024-11-12T14:18:07.587Z |
5521991 | 5521991 | 20241110184418_9tGo3 | KR003M | 2024-11-12T14:12:23.059Z | 2024-11-12T14:18:07.549Z |
5521930 | 5521930 | 20241110183635_oQec3 | KR003M | 2024-11-12T14:12:11.837Z | 2024-11-12T14:18:07.522Z |
5521865 | 5521865 | 20241110182659_N551e | KR003M | 2024-11-12T14:12:04.944Z | 2024-11-12T14:18:07.495Z |
5521859 | 5521859 | 20241110182344_Q9uS4 | KR003M | 2024-11-12T14:12:04.632Z | 2024-11-12T14:18:07.492Z |
5521679 | 5521679 | 20241110175535_7sY98 | KR003M | 2024-11-12T14:11:50.122Z | 2024-11-12T14:18:07.416Z |
5521547 | 5521547 | 20241110173043_wv99t | KR003M | 2024-11-12T14:11:33.226Z | 2024-11-12T14:18:07.348Z |
5521528 | 5521528 | 20241110172626_4P00h | KR003M | 2024-11-12T14:11:28.178Z | 2024-11-12T14:18:07.338Z |
5521233 | 5521233 | 20241110163142_GMZlg | KR003M | 2024-11-12T14:10:39.290Z | 2024-11-12T14:18:07.197Z |
5521178 | 5521178 | 20241110161915_oZ2qY | KR003M | 2024-11-12T14:10:35.279Z | 2024-11-12T14:18:07.174Z |
5521082 | 5521082 | 20241110155636_M8WX7 | KR003M | 2024-11-12T14:10:25.472Z | 2024-11-12T14:18:07.131Z |
5521053 | 5521053 | 20241110155142_gLabQ | KR003M | 2024-11-12T14:10:19.572Z | 2024-11-12T14:18:07.117Z |
5520949 | 5520949 | 20241110153040_wnZok | KR003M | 2024-11-12T14:09:51.972Z | 2024-11-12T14:18:07.036Z |
5520942 | 5520942 | 20241110152941_q8mw3 | KR003M | 2024-11-12T14:09:51.457Z | 2024-11-12T14:18:07.032Z |
5508309 | 5508309 | 20241109160236_0wLCs | KR003M | 2024-11-10T14:07:26.184Z | 2024-11-12T14:19:35.236Z |
5508250 | 5508250 | 20241109152916_HPm60 | KR003M | 2024-11-10T14:07:18.938Z | 2024-11-12T14:19:32.627Z |
5508185 | 5508185 | 20241109150058_6gE2Y | KR003M | 2024-11-10T14:07:13.233Z | 2024-11-12T14:19:28.187Z |
5508180 | 5508180 | 20241109150058_v9W41 | KR003M | 2024-11-10T14:07:13.060Z | 2024-11-12T14:19:28.186Z |
5508144 | 5508144 | 20241109144359_xkwSW | KR003M | 2024-11-10T14:07:09.036Z | 2024-11-12T14:19:26.282Z |
5508126 | 5508126 | 20241109143708_cd1cr | KR003M | 2024-11-10T14:07:06.657Z | 2024-11-12T14:19:24.822Z |
5508045 | 5508045 | 20241109134856_XGU1o | KR003M | 2024-11-10T14:06:43.247Z | 2024-11-12T14:19:20.104Z |
5508041 | 5508041 | 20241109134813_c9eof | KR003M | 2024-11-10T14:06:42.246Z | 2024-11-12T14:19:20.101Z |
5507999 | 5507999 | 20241109133551_2hgJ5 | KR003M | 2024-11-10T14:06:37.813Z | 2024-11-12T14:19:18.332Z |
5507992 | 5507992 | 20241109133526_6otzv | KR003M | 2024-11-10T14:06:37.461Z | 2024-11-12T14:19:18.272Z |
5503004 | 5503004 | 20241107202640_DRIJa | KR003M | 2024-11-09T14:12:18.297Z | 2024-11-12T14:24:42.932Z |
5502676 | 5502676 | 20241107193120_3G9mB | KR003M | 2024-11-09T14:11:57.588Z | 2024-11-12T14:24:38.114Z |
5502408 | 5502408 | 20241107182508_4HLuK | KR003M | 2024-11-09T14:11:16.346Z | 2024-11-12T14:24:34.018Z |
5502305 | 5502305 | 20241107175935_Mbiu3 | KR003M | 2024-11-09T14:11:08.823Z | 2024-11-12T14:24:31.272Z |
5502297 | 5502297 | 20241107175913_WApUZ | KR003M | 2024-11-09T14:11:08.502Z | 2024-11-12T14:24:31.236Z |
5502283 | 5502283 | 20241107175600_BzY5d | KR003M | 2024-11-09T14:11:07.715Z | 2024-11-12T14:24:31.104Z |
5502094 | 5502094 | 20241107172055_H4J6a | KR003M | 2024-11-09T14:10:56.467Z | 2024-11-12T14:24:28.636Z |
5502006 | 5502006 | 20241107165146_YhPJx | KR003M | 2024-11-09T14:10:49.499Z | 2024-11-12T14:24:26.772Z |
5501946 | 5501946 | 20241107164353_0zsW8 | KR003M | 2024-11-09T14:10:47.129Z | 2024-11-12T14:24:26.235Z |
5501848 | 5501848 | 20241107161305_G0eSd | KR003M | 2024-11-09T14:10:32.909Z | 2024-11-12T14:24:24.871Z |
5501834 | 5501834 | 20241107161112_UgO1K | KR003M | 2024-11-09T14:10:31.761Z | 2024-11-12T14:24:24.837Z |
5501766 | 5501766 | 20241107154044_cVukD | KR003M | 2024-11-09T14:10:19.988Z | 2024-11-12T14:24:24.134Z |
5501664 | 5501664 | 20241107150553_vziMw | KR003M | 2024-11-09T14:10:10.422Z | 2024-11-12T14:24:22.428Z |
5501623 | 5501623 | 20241107145042_0Fxbi | KR003M | 2024-11-09T14:10:07.819Z | 2024-11-12T14:24:21.952Z |
5501610 | 5501610 | 20241107144421_brgUc | KR003M | 2024-11-09T14:10:07.049Z | 2024-11-12T14:24:21.648Z |
5501603 | 5501603 | 20241107144150_p4mj7 | KR003M | 2024-11-09T14:10:06.422Z | 2024-11-12T14:24:21.570Z |
5501599 | 5501599 | 20241107143741_4q5sU | KR003M | 2024-11-09T14:10:05.857Z | 2024-11-12T14:24:21.204Z |
5501372 | 5501372 | 20241107124006_CW2Ey | KR003M | 2024-11-09T14:09:17.926Z | 2024-11-12T14:24:13.236Z |
5501300 | 5501300 | 20241107115355_kVGWB | KR003M | 2024-11-09T14:09:04.575Z | 2024-11-12T14:24:10.086Z |
5501259 | 5501259 | 20241107113045_nFjDM | KR003M | 2024-11-09T14:09:00.285Z | 2024-11-12T14:24:08.952Z |
5499769 | 5499769 | 20241108131943_6ok2Q | KR003M | 2024-11-09T14:04:55.845Z | 2024-11-12T14:22:39.452Z |
5499728 | 5499728 | 20241108131251_V1ANI | KR003M | 2024-11-09T14:04:50.531Z | 2024-11-12T14:22:38.412Z |
5495251 | 5495251 | 20241106190522_p79wi | KR003M | 2024-11-08T14:09:44.224Z | 2024-11-12T14:25:51.085Z |
5494491 | 5494491 | 20241106152133_pBSdg | KR003M | 2024-11-08T14:07:36.923Z | 2024-11-12T14:25:38.347Z |
5490113 | 5490113 | 20241105210208_F2LA3 | KR003M | 2024-11-07T14:13:13.305Z | 2024-11-12T14:26:46.385Z |
5490106 | 5490106 | 20241105210005_p2U3B | KR003M | 2024-11-07T14:13:12.952Z | 2024-11-12T14:26:46.382Z |
5489965 | 5489965 | 20241105203403_41DhO | KR003M | 2024-11-07T14:12:58.050Z | 2024-11-12T14:26:45.604Z |
5489854 | 5489854 | 20241105201854_j8fYD | KR003M | 2024-11-07T14:12:50.070Z | 2024-11-12T14:26:45.152Z |
5489804 | 5489804 | 20241105200157_OYA4J | KR003M | 2024-11-07T14:12:46.432Z | 2024-11-12T14:26:44.976Z |
5489790 | 5489790 | 20241105200031_OlBPM | KR003M | 2024-11-07T14:12:45.738Z | 2024-11-12T14:26:44.966Z |
5489681 | 5489681 | 20241105194046_PeWAI | KR003M | 2024-11-07T14:12:32.569Z | 2024-11-12T14:26:44.591Z |
5489592 | 5489592 | 20241105192246_SjF2g | KR003M | 2024-11-07T14:12:14.742Z | 2024-11-12T14:26:43.949Z |
5489495 | 5489495 | 20241105190643_O2j1n | KR003M | 2024-11-07T14:12:05.952Z | 2024-11-12T14:26:43.497Z |
5489419 | 5489419 | 20241105184809_AE20O | KR003M | 2024-11-07T14:11:59.457Z | 2024-11-12T14:26:42.592Z |
5489403 | 5489403 | 20241105184734_dt4gG | KR003M | 2024-11-07T14:11:58.906Z | 2024-11-12T14:26:42.581Z |
5489309 | 5489309 | 20241105183340_jusut | KR003M | 2024-11-07T14:11:52.347Z | 2024-11-12T14:26:42.063Z |
5489056 | 5489056 | 20241105174244_RzQNe | KR003M | 2024-11-07T14:11:14.462Z | 2024-11-12T14:26:38.348Z |
5489012 | 5489012 | 20241105173434_6vw94 | KR003M | 2024-11-07T14:11:10.543Z | 2024-11-12T14:26:37.786Z |
5488867 | 5488867 | 20241105170704_Hg2hR | KR003M | 2024-11-07T14:10:44.425Z | 2024-11-12T14:26:35.883Z |
5488834 | 5488834 | 20241105170407_2lTZL | KR003M | 2024-11-07T14:10:40.434Z | 2024-11-12T14:26:35.581Z |
5488787 | 5488787 | 20241105165324_GoLy3 | KR003M | 2024-11-07T14:10:37.359Z | 2024-11-12T14:26:35.443Z |
5488708 | 5488708 | 20241105163035_HkTc1 | KR003M | 2024-11-07T14:10:30.689Z | 2024-11-12T14:26:35.116Z |
5488518 | 5488518 | 20241105152543_IOH3F | KR003M | 2024-11-07T14:10:03.932Z | 2024-11-12T14:26:34.167Z |
5488168 | 5488168 | 20241105105126_D4Ux2 | KR003M | 2024-11-07T14:08:42.416Z | 2024-11-12T14:26:26.556Z |
5488151 | 5488151 | 20241105103051_DUcc0 | KR003M | 2024-11-07T14:08:36.755Z | 2024-11-12T14:26:25.831Z |
5487937 | 5487937 | 20241106193809_xeqsf | KR003M | 2024-11-07T14:07:16.238Z | 2024-11-12T14:25:52.877Z |
5487893 | 5487893 | 20241106191832_e2OCe | KR003M | 2024-11-07T14:07:04.860Z | 2024-11-12T14:25:51.696Z |
5487842 | 5487842 | 20241106190539_awKks | KR003M | 2024-11-07T14:06:56.272Z | 2024-11-12T14:25:51.092Z |
5487819 | 5487819 | 20241106185534_7IKZz | KR003M | 2024-11-07T14:06:50.719Z | 2024-11-12T14:25:50.534Z |
5487728 | 5487728 | 20241106181401_Ge24G | KR003M | 2024-11-07T14:06:39.962Z | 2024-11-12T14:25:47.403Z |
5486974 | 5486974 | 20241106141341_3ww3i | KR003M | 2024-11-07T14:04:32.506Z | 2024-11-12T14:25:35.511Z |
5486952 | 5486952 | 20241106140908_26Mjt | KR003M | 2024-11-07T14:04:27.348Z | 2024-11-12T14:25:35.422Z |
5486764 | 5486764 | 20241106131511_u4T4y | KR003M | 2024-11-07T14:03:58.287Z | 2024-11-12T14:25:33.390Z |
5486759 | 5486759 | 20241106131455_XCctD | KR003M | 2024-11-07T14:03:57.751Z | 2024-11-12T14:25:33.389Z |
5486733 | 5486733 | 20241106130823_5DMAG | KR003M | 2024-11-07T14:03:53.174Z | 2024-11-12T14:25:33.316Z |
5486672 | 5486672 | 20241106124809_KJHbQ | KR003M | 2024-11-07T14:03:44.021Z | 2024-11-12T14:25:32.952Z |
5486603 | 5486603 | 20241106123036_HJdfp | KR003M | 2024-11-07T14:03:28.923Z | 2024-11-12T14:25:32.380Z |
5486596 | 5486596 | 20241106122158_i2kyH | KR003M | 2024-11-07T14:03:27.835Z | 2024-11-12T14:25:32.343Z |
5486507 | 5486507 | 20241106115318_ZayHY | KR003M | 2024-11-07T14:03:14.679Z | 2024-11-12T14:25:31.487Z |
5486454 | 5486454 | 20241106114242_fYAO5 | KR003M | 2024-11-07T14:03:01.155Z | 2024-11-12T14:25:31.132Z |
5486431 | 5486431 | 20241106113714_YsbKr | KR003M | 2024-11-07T14:02:57.392Z | 2024-11-12T14:25:31.082Z |
5486413 | 5486413 | 20241106112608_6dDzH | KR003M | 2024-11-07T14:02:53.557Z | 2024-11-12T14:25:30.946Z |
5474429 | 5474429 | 20241103171723_JZSkQ | KR003M | 2024-11-05T14:11:04.649Z | 2024-11-12T14:27:51.663Z |
5474407 | 5474407 | 20241103171101_JD5CO | KR003M | 2024-11-05T14:11:02.972Z | 2024-11-12T14:27:51.615Z |
5474379 | 5474379 | 20241103170717_TQmFa | KR003M | 2024-11-05T14:11:00.587Z | 2024-11-12T14:27:51.178Z |
5474298 | 5474298 | 20241103164817_r3JDV | KR003M | 2024-11-05T14:10:45.327Z | 2024-11-12T14:27:51.048Z |
5474242 | 5474242 | 20241103163419_5j2JS | KR003M | 2024-11-05T14:10:31.969Z | 2024-11-12T14:27:50.749Z |
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);