participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,789 rows where station_code = "KR0026" 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 |
---|---|---|---|---|---|
5495589 | 5495589 | 20241106202748_hSniH | KR0026 | 2024-11-08T14:10:26.405Z | 2024-11-08T14:14:34.878Z |
5495572 | 5495572 | 20241106202229_WP3dO | KR0026 | 2024-11-08T14:10:25.034Z | 2024-11-08T14:14:34.872Z |
5495528 | 5495528 | 20241106201100_XfSNC | KR0026 | 2024-11-08T14:10:21.087Z | 2024-11-08T14:14:34.855Z |
5495311 | 5495311 | 20241106192111_CSQPQ | KR0026 | 2024-11-08T14:09:55.665Z | 2024-11-08T14:14:34.785Z |
5495249 | 5495249 | 20241106190522_p79wi | KR0026 | 2024-11-08T14:09:44.224Z | 2024-11-08T14:14:34.760Z |
5494519 | 5494519 | 20241106152746_53zRb | KR0026 | 2024-11-08T14:07:39.852Z | 2024-11-08T14:14:34.476Z |
5494488 | 5494488 | 20241106152133_pBSdg | KR0026 | 2024-11-08T14:07:36.923Z | 2024-11-08T14:14:34.463Z |
5494426 | 5494426 | 20241106145154_x2344 | KR0026 | 2024-11-08T14:07:28.856Z | 2024-11-08T14:14:34.423Z |
5494365 | 5494365 | 20241106140943_hhUBa | KR0026 | 2024-11-08T14:07:13.522Z | 2024-11-08T14:14:34.376Z |
5494298 | 5494298 | 20241106131342_inCmJ | KR0026 | 2024-11-08T14:06:42.284Z | 2024-11-08T14:14:34.320Z |
5490112 | 5490112 | 20241105210208_F2LA3 | KR0026 | 2024-11-07T14:13:13.305Z | 2024-11-08T14:16:17.713Z |
5490087 | 5490087 | 20241105205524_v5bq8 | KR0026 | 2024-11-07T14:13:09.409Z | 2024-11-08T14:16:16.880Z |
5489999 | 5489999 | 20241105204053_APsyt | KR0026 | 2024-11-07T14:13:00.741Z | 2024-11-08T14:16:14.735Z |
5489962 | 5489962 | 20241105203403_41DhO | KR0026 | 2024-11-07T14:12:58.050Z | 2024-11-08T14:16:13.757Z |
5489439 | 5489439 | 20241105185535_N0Nij | KR0026 | 2024-11-07T14:12:02.175Z | 2024-11-08T14:16:01.962Z |
5489430 | 5489430 | 20241105185120_eWG59 | KR0026 | 2024-11-07T14:12:00.791Z | 2024-11-08T14:16:01.620Z |
5489415 | 5489415 | 20241105184809_AE20O | KR0026 | 2024-11-07T14:11:59.457Z | 2024-11-08T14:16:01.408Z |
5489370 | 5489370 | 20241105184054_4GKuK | KR0026 | 2024-11-07T14:11:56.406Z | 2024-11-08T14:16:00.911Z |
5489359 | 5489359 | 20241105183934_6SNhh | KR0026 | 2024-11-07T14:11:55.895Z | 2024-11-08T14:16:00.766Z |
5489114 | 5489114 | 20241105175021_2zXi2 | KR0026 | 2024-11-07T14:11:19.237Z | 2024-11-08T14:15:55.564Z |
5488705 | 5488705 | 20241105163035_HkTc1 | KR0026 | 2024-11-07T14:10:30.689Z | 2024-11-08T14:15:45.643Z |
5488584 | 5488584 | 20241105155129_CxPbc | KR0026 | 2024-11-07T14:10:21.006Z | 2024-11-08T14:15:40.821Z |
5488444 | 5488444 | 20241105144626_SM0Jd | KR0026 | 2024-11-07T14:09:54.936Z | 2024-11-08T14:15:35.874Z |
5488317 | 5488317 | 20241105132349_YHRzM | KR0026 | 2024-11-07T14:09:38.981Z | 2024-11-08T14:15:28.767Z |
5488192 | 5488192 | 20241105112244_Ooqn3 | KR0026 | 2024-11-07T14:08:53.611Z | 2024-11-08T14:15:13.262Z |
5488011 | 5488011 | 20241106201025_AgM37 | KR0026 | 2024-11-07T14:07:23.193Z | 2024-11-08T14:14:34.854Z |
5487965 | 5487965 | 20241106194644_h3lXG | KR0026 | 2024-11-07T14:07:18.640Z | 2024-11-08T14:14:34.820Z |
5487936 | 5487936 | 20241106193809_xeqsf | KR0026 | 2024-11-07T14:07:16.238Z | 2024-11-08T14:14:34.805Z |
5487891 | 5487891 | 20241106191832_e2OCe | KR0026 | 2024-11-07T14:07:04.860Z | 2024-11-08T14:14:34.780Z |
5487848 | 5487848 | 20241106190718_L2FLj | KR0026 | 2024-11-07T14:06:56.899Z | 2024-11-08T14:14:34.763Z |
5487638 | 5487638 | 20241106173838_Jbz8i | KR0026 | 2024-11-07T14:06:21.805Z | 2024-11-08T14:14:34.628Z |
5487602 | 5487602 | 20241106172904_OBTfA | KR0026 | 2024-11-07T14:06:18.143Z | 2024-11-08T14:14:34.615Z |
5487274 | 5487274 | 20241106152708_eMHqI | KR0026 | 2024-11-07T14:05:26.172Z | 2024-11-08T14:14:34.474Z |
5486954 | 5486954 | 20241106140943_GI2Hm | KR0026 | 2024-11-07T14:04:27.902Z | 2024-11-07T14:04:27.902Z |
5486614 | 5486614 | 20241106123224_G3568 | KR0026 | 2024-11-07T14:03:30.575Z | 2024-11-08T14:14:34.283Z |
5486601 | 5486601 | 20241106123036_HJdfp | KR0026 | 2024-11-07T14:03:28.908Z | 2024-11-08T14:14:34.279Z |
5481532 | 5481532 | 20241104181205_3X8c9 | KR0026 | 2024-11-06T14:10:44.918Z | 2024-11-08T14:18:03.707Z |
5481004 | 5481004 | 20241104122927_7OEGJ | KR0026 | 2024-11-06T14:08:26.134Z | 2024-11-08T14:17:39.782Z |
5475067 | 5475067 | 20241103190110_BDk4P | KR0026 | 2024-11-05T14:12:29.105Z | 2024-11-08T14:19:35.752Z |
5474897 | 5474897 | 20241103183414_OdJPb | KR0026 | 2024-11-05T14:12:14.592Z | 2024-11-08T14:19:32.397Z |
5474406 | 5474406 | 20241103171101_JD5CO | KR0026 | 2024-11-05T14:11:02.972Z | 2024-11-08T14:19:25.706Z |
5474327 | 5474327 | 20241103165615_iMf60 | KR0026 | 2024-11-05T14:10:54.667Z | 2024-11-08T14:19:24.591Z |
5474258 | 5474258 | 20241103163731_VEy7j | KR0026 | 2024-11-05T14:10:37.838Z | 2024-11-08T14:19:23.496Z |
5473916 | 5473916 | 20241103152040_FdVj8 | KR0026 | 2024-11-05T14:09:53.394Z | 2024-11-08T14:19:19.342Z |
5473546 | 5473546 | 20241103143041_0SJyP | KR0026 | 2024-11-05T14:09:05.404Z | 2024-11-08T14:19:17.458Z |
5473197 | 5473197 | 20241103133903_HHOY4 | KR0026 | 2024-11-05T14:08:32.404Z | 2024-11-08T14:19:14.148Z |
5473195 | 5473195 | 20241103133831_Ct5yc | KR0026 | 2024-11-05T14:08:31.628Z | 2024-11-08T14:19:14.136Z |
5472912 | 5472912 | 20241103125905_T85op | KR0026 | 2024-11-05T14:07:51.321Z | 2024-11-08T14:19:11.382Z |
5467356 | 5467356 | 20241102205143_zxYA9 | KR0026 | 2024-11-04T14:11:21.172Z | 2024-11-08T14:20:54.081Z |
5467183 | 5467183 | 20241102202037_2EFS3 | KR0026 | 2024-11-04T14:11:03.867Z | 2024-11-08T14:20:52.557Z |
5467144 | 5467144 | 20241102201543_4OEIE | KR0026 | 2024-11-04T14:10:48.760Z | 2024-11-08T14:20:52.357Z |
5467017 | 5467017 | 20241102194703_Dqbd5 | KR0026 | 2024-11-04T14:10:28.609Z | 2024-11-08T14:20:50.903Z |
5466974 | 5466974 | 20241102193804_0ocgL | KR0026 | 2024-11-04T14:10:24.670Z | 2024-11-08T14:20:50.607Z |
5466847 | 5466847 | 20241102190933_fI21D | KR0026 | 2024-11-04T14:10:01.587Z | 2024-11-08T14:20:49.577Z |
5466637 | 5466637 | 20241102182335_0rLc5 | KR0026 | 2024-11-04T14:09:28.534Z | 2024-11-08T14:20:48.076Z |
5466616 | 5466616 | 20241102181723_2yQ26 | KR0026 | 2024-11-04T14:09:25.494Z | 2024-11-08T14:20:47.782Z |
5466445 | 5466445 | 20241102174327_ocwnJ | KR0026 | 2024-11-04T14:08:54.802Z | 2024-11-08T14:20:45.905Z |
5466342 | 5466342 | 20241102171819_omA7B | KR0026 | 2024-11-04T14:08:39.794Z | 2024-11-08T14:20:44.613Z |
5466205 | 5466205 | 20241102164802_9vome | KR0026 | 2024-11-04T14:08:14.605Z | 2024-11-08T14:20:43.432Z |
5466178 | 5466178 | 20241102164024_3N5FO | KR0026 | 2024-11-04T14:08:11.073Z | 2024-11-08T14:20:43.251Z |
5466106 | 5466106 | 20241102162003_ewtVY | KR0026 | 2024-11-04T14:08:01.913Z | 2024-11-08T14:20:42.793Z |
5466088 | 5466088 | 20241102161755_AHnMf | KR0026 | 2024-11-04T14:07:59.396Z | 2024-11-08T14:20:42.724Z |
5466052 | 5466052 | 20241102160947_Jq1HZ | KR0026 | 2024-11-04T14:07:56.784Z | 2024-11-08T14:20:42.504Z |
5465975 | 5465975 | 20241102154434_NdNRg | KR0026 | 2024-11-04T14:07:39.890Z | 2024-11-08T14:20:41.914Z |
5465937 | 5465937 | 20241102152637_RVBw6 | KR0026 | 2024-11-04T14:07:28.034Z | 2024-11-08T14:20:41.342Z |
5465875 | 5465875 | 20241102150348_n2qgC | KR0026 | 2024-11-04T14:07:16.581Z | 2024-11-08T14:20:40.006Z |
5465789 | 5465789 | 20241102140443_B1TG9 | KR0026 | 2024-11-04T14:06:43.187Z | 2024-11-08T14:20:38.632Z |
5465738 | 5465738 | 20241102133025_Hkphx | KR0026 | 2024-11-04T14:06:32.015Z | 2024-11-08T14:20:37.695Z |
5465702 | 5465702 | 20241102131758_OxgtT | KR0026 | 2024-11-04T14:06:17.740Z | 2024-11-08T14:20:37.419Z |
5465643 | 5465643 | 20241102124108_p5F8x | KR0026 | 2024-11-04T14:06:02.135Z | 2024-11-08T14:20:35.582Z |
5465562 | 5465562 | 20241102113120_pyLv2 | KR0026 | 2024-11-04T14:05:26.994Z | 2024-11-08T14:20:31.094Z |
5465495 | 5465495 | 20241103121306_WZHm2 | KR0026 | 2024-11-04T14:03:49.054Z | 2024-11-08T14:19:08.759Z |
5447338 | 5447338 | 20241031113310_ewUEl | KR0026 | 2024-11-02T12:07:49.537Z | 2024-11-08T14:22:11.609Z |
5439990 | 5439990 | 20241030210345_1WvWe | KR0026 | 2024-11-01T12:14:43.004Z | 2024-11-08T14:23:06.595Z |
5439930 | 5439930 | 20241030205027_LEMOz | KR0026 | 2024-11-01T12:14:38.957Z | 2024-11-08T14:23:06.208Z |
5439754 | 5439754 | 20241030202806_n33bL | KR0026 | 2024-11-01T12:14:25.306Z | 2024-11-08T14:23:05.547Z |
5439480 | 5439480 | 20241030195711_85FVy | KR0026 | 2024-11-01T12:13:52.706Z | 2024-11-08T14:23:03.508Z |
5439352 | 5439352 | 20241030194648_SKPba | KR0026 | 2024-11-01T12:13:44.818Z | 2024-11-08T14:23:03.172Z |
5439009 | 5439009 | 20241030184326_bwrsI | KR0026 | 2024-11-01T12:12:59.155Z | 2024-11-08T14:23:01.709Z |
5438978 | 5438978 | 20241030184014_mA3uh | KR0026 | 2024-11-01T12:12:56.026Z | 2024-11-08T14:23:01.676Z |
5438927 | 5438927 | 20241030183230_Tq3dS | KR0026 | 2024-11-01T12:12:46.776Z | 2024-11-08T14:23:01.628Z |
5438596 | 5438596 | 20241030174005_tXU5d | KR0026 | 2024-11-01T12:12:01.724Z | 2024-11-08T14:23:00.342Z |
5438590 | 5438590 | 20241030173931_cfGVv | KR0026 | 2024-11-01T12:12:01.330Z | 2024-11-08T14:23:00.331Z |
5438533 | 5438533 | 20241030173216_eREmf | KR0026 | 2024-11-01T12:11:50.616Z | 2024-11-08T14:23:00.211Z |
5438296 | 5438296 | 20241030165726_hh7Oa | KR0026 | 2024-11-01T12:11:29.802Z | 2024-11-08T14:22:59.259Z |
5438034 | 5438034 | 20241030161701_sWxM3 | KR0026 | 2024-11-01T12:10:53.686Z | 2024-11-08T14:22:58.751Z |
5437968 | 5437968 | 20241030160737_Ae4PB | KR0026 | 2024-11-01T12:10:47.586Z | 2024-11-08T14:22:58.558Z |
5436987 | 5436987 | 20241030141520_ci03H | KR0026 | 2024-11-01T12:08:40.500Z | 2024-11-08T14:22:56.048Z |
5436178 | 5436178 | 20241030123525_vX235 | KR0026 | 2024-11-01T12:07:02.808Z | 2024-11-08T14:22:53.151Z |
5435970 | 5435970 | 20241030121553_H8F5Y | KR0026 | 2024-11-01T12:06:27.970Z | 2024-11-08T14:22:52.304Z |
5435824 | 5435824 | 20241030120107_XwAdv | KR0026 | 2024-11-01T12:06:01.075Z | 2024-11-08T14:22:51.764Z |
5429868 | 5429868 | 20241028201624_30bLK | KR0026 | 2024-10-31T12:17:09.946Z | 2024-11-06T14:27:17.942Z |
5429284 | 5429284 | 20241028190724_cdHpp | KR0026 | 2024-10-31T12:16:18.553Z | 2024-11-06T14:27:15.661Z |
5429021 | 5429021 | 20241028183513_eSzkH | KR0026 | 2024-10-31T12:15:52.947Z | 2024-11-06T14:27:14.909Z |
5428561 | 5428561 | 20241028173233_OhD0R | KR0026 | 2024-10-31T12:15:16.145Z | 2024-11-06T14:27:13.886Z |
5426437 | 5426437 | 20241029194745_gyr9H | KR0026 | 2024-10-31T12:10:00.405Z | 2024-11-07T14:26:39.276Z |
5426356 | 5426356 | 20241029193921_ok9P2 | KR0026 | 2024-10-31T12:09:53.321Z | 2024-11-07T14:26:38.988Z |
5426088 | 5426088 | 20241029184012_0ZdMH | KR0026 | 2024-10-31T12:09:15.720Z | 2024-11-07T14:26:37.418Z |
5425995 | 5425995 | 20241029182540_oJnhX | KR0026 | 2024-10-31T12:09:03.997Z | 2024-11-07T14:26:36.996Z |
5425837 | 5425837 | 20241029180242_3kONM | KR0026 | 2024-10-31T12:08:50.055Z | 2024-11-07T14:26:36.225Z |
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);