participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,745 rows where station_code = "KR000D" 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 |
---|---|---|---|---|---|
5060237 | 5060237 | 20240910201020_bQmW1 | KR000D | 2024-09-14T12:08:31.495Z | 2024-09-16T12:18:14.004Z |
5060067 | 5060067 | 20240910194639_60vRe | KR000D | 2024-09-14T12:08:08.821Z | 2024-09-16T12:18:12.549Z |
5059971 | 5059971 | 20240910192608_lwels | KR000D | 2024-09-14T12:07:51.975Z | 2024-09-16T12:18:10.528Z |
5059923 | 5059923 | 20240910192012_NrjjJ | KR000D | 2024-09-14T12:07:41.431Z | 2024-09-16T12:18:10.183Z |
5059896 | 5059896 | 20240910191501_0uBZV | KR000D | 2024-09-14T12:07:34.459Z | 2024-09-16T12:18:09.929Z |
5059731 | 5059731 | 20240910183911_Zvggj | KR000D | 2024-09-14T12:06:55.997Z | 2024-09-16T12:18:07.989Z |
5059691 | 5059691 | 20240910183310_htS1p | KR000D | 2024-09-14T12:06:46.924Z | 2024-09-16T12:18:07.689Z |
5059551 | 5059551 | 20240910180533_sfWX9 | KR000D | 2024-09-14T12:06:26.720Z | 2024-09-16T12:18:06.061Z |
5059545 | 5059545 | 20240910180437_TrEw7 | KR000D | 2024-09-14T12:06:26.130Z | 2024-09-16T12:18:06.044Z |
5059078 | 5059078 | 20240910171111_8Dnox | KR000D | 2024-09-14T12:05:12.644Z | 2024-09-16T12:18:01.648Z |
5059054 | 5059054 | 20240910170933_N526q | KR000D | 2024-09-14T12:05:09.523Z | 2024-09-16T12:18:01.351Z |
5058638 | 5058638 | 20240910163231_m14R2 | KR000D | 2024-09-14T12:04:14.478Z | 2024-09-16T12:17:56.759Z |
5058595 | 5058595 | 20240910162948_VgBuE | KR000D | 2024-09-14T12:04:06.378Z | 2024-09-16T12:17:56.396Z |
5058314 | 5058314 | 20240910160218_ueR2L | KR000D | 2024-09-14T12:03:27.654Z | 2024-09-16T12:17:52.913Z |
5058188 | 5058188 | 20240910155101_7hE2Y | KR000D | 2024-09-14T12:03:06.975Z | 2024-09-16T12:17:51.639Z |
5058057 | 5058057 | 20240910154035_NlkAi | KR000D | 2024-09-14T12:02:46.195Z | 2024-09-16T12:17:49.553Z |
5057833 | 5057833 | 20240910151711_vWhYR | KR000D | 2024-09-14T12:02:12.594Z | 2024-09-16T12:17:47.963Z |
5057564 | 5057564 | 20240910145041_qV1aM | KR000D | 2024-09-14T12:01:27.202Z | 2024-09-16T12:17:45.015Z |
5057429 | 5057429 | 20240910142919_ohYO8 | KR000D | 2024-09-14T12:01:03.713Z | 2024-09-16T12:17:43.970Z |
5051885 | 5051885 | 20240907190040_dqkUB | KR000D | 2024-09-13T12:14:42.097Z | 2024-09-16T12:21:02.406Z |
5051832 | 5051832 | 20240907184938_QAIwI | KR000D | 2024-09-13T12:14:37.139Z | 2024-09-16T12:21:02.107Z |
5051767 | 5051767 | 20240907183357_9aIzr | KR000D | 2024-09-13T12:14:32.797Z | 2024-09-16T12:21:01.830Z |
5051697 | 5051697 | 20240907182532_YzVvC | KR000D | 2024-09-13T12:14:30.122Z | 2024-09-16T12:21:01.637Z |
5051681 | 5051681 | 20240907182402_V2lPi | KR000D | 2024-09-13T12:14:29.618Z | 2024-09-16T12:21:01.601Z |
5051621 | 5051621 | 20240907175257_03P3x | KR000D | 2024-09-13T12:14:25.061Z | 2024-09-16T12:21:01.404Z |
5051574 | 5051574 | 20240907174734_6Qmkf | KR000D | 2024-09-13T12:14:23.420Z | 2024-09-16T12:21:01.351Z |
5051537 | 5051537 | 20240907174044_8LsoP | KR000D | 2024-09-13T12:14:22.003Z | 2024-09-16T12:21:01.180Z |
5051514 | 5051514 | 20240907173847_gXAQ8 | KR000D | 2024-09-13T12:14:21.506Z | 2024-09-16T12:21:01.121Z |
5051121 | 5051121 | 20240907165104_2Mqy3 | KR000D | 2024-09-13T12:14:02.923Z | 2024-09-16T12:20:59.614Z |
5050806 | 5050806 | 20240907161054_ipG3n | KR000D | 2024-09-13T12:13:47.121Z | 2024-09-16T12:20:58.540Z |
5050733 | 5050733 | 20240907160317_K9409 | KR000D | 2024-09-13T12:13:45.478Z | 2024-09-16T12:20:58.395Z |
5050622 | 5050622 | 20240907154850_2o2fB | KR000D | 2024-09-13T12:13:40.563Z | 2024-09-16T12:20:58.107Z |
5043415 | 5043415 | 20240907105923_gnhYd | KR000D | 2024-09-12T12:17:33.387Z | 2024-09-15T12:21:41.621Z |
5042970 | 5042970 | 20240907132318_cBEbs | KR000D | 2024-09-12T12:17:21.212Z | 2024-09-16T12:20:54.980Z |
5015815 | 5015815 | 20240904124106_JQSEf | KR000D | 2024-09-10T12:06:48.934Z | 2024-09-13T12:19:44.716Z |
5015765 | 5015765 | 20240904122838_OYxu2 | KR000D | 2024-09-10T12:06:45.350Z | 2024-09-13T12:19:44.653Z |
5006672 | 5006672 | 20240903182209_2B27f | KR000D | 2024-09-09T12:04:52.731Z | 2024-09-12T12:19:09.182Z |
5006656 | 5006656 | 20240903181918_K6GTd | KR000D | 2024-09-09T12:04:51.890Z | 2024-09-12T12:19:09.147Z |
5006582 | 5006582 | 20240903175558_POzQp | KR000D | 2024-09-09T12:04:47.484Z | 2024-09-12T12:19:08.971Z |
5006376 | 5006376 | 20240903173051_8ttiM | KR000D | 2024-09-09T12:04:34.349Z | 2024-09-12T12:19:08.226Z |
5006339 | 5006339 | 20240903172555_ZqoMd | KR000D | 2024-09-09T12:04:31.562Z | 2024-09-12T12:19:08.154Z |
5006227 | 5006227 | 20240903170737_9YC5O | KR000D | 2024-09-09T12:04:25.831Z | 2024-09-12T12:19:07.989Z |
5005960 | 5005960 | 20240903163815_thIi9 | KR000D | 2024-09-09T12:04:14.671Z | 2024-09-12T12:19:07.145Z |
5005739 | 5005739 | 20240903160247_fqrmc | KR000D | 2024-09-09T12:04:01.050Z | 2024-09-12T12:19:06.523Z |
5005502 | 5005502 | 20240903152345_2nYtg | KR000D | 2024-09-09T12:03:46.251Z | 2024-09-12T12:19:06.051Z |
5005440 | 5005440 | 20240903151358_5J0Ir | KR000D | 2024-09-09T12:03:43.020Z | 2024-09-12T12:19:05.949Z |
5005343 | 5005343 | 20240903145630_uJ2bf | KR000D | 2024-09-09T12:03:38.104Z | 2024-09-12T12:19:05.787Z |
5005285 | 5005285 | 20240903144728_elALO | KR000D | 2024-09-09T12:03:33.930Z | 2024-09-12T12:19:05.645Z |
5005121 | 5005121 | 20240903140407_OM6dg | KR000D | 2024-09-09T12:03:21.324Z | 2024-09-12T12:19:05.310Z |
5005072 | 5005072 | 20240903135652_NhkGe | KR000D | 2024-09-09T12:03:18.862Z | 2024-09-12T12:19:05.220Z |
5005025 | 5005025 | 20240903134923_fhW43 | KR000D | 2024-09-09T12:03:16.654Z | 2024-09-12T12:19:05.165Z |
5004995 | 5004995 | 20240903134439_44orq | KR000D | 2024-09-09T12:03:15.276Z | 2024-09-12T12:19:04.723Z |
5004973 | 5004973 | 20240903134031_531Vh | KR000D | 2024-09-09T12:03:14.276Z | 2024-09-12T12:19:04.626Z |
5004964 | 5004964 | 20240903134030_H0B4V | KR000D | 2024-09-09T12:03:14.133Z | 2024-09-12T12:19:04.621Z |
5004801 | 5004801 | 20240903124900_QRVSZ | KR000D | 2024-09-09T12:03:03.383Z | 2024-09-12T12:19:04.127Z |
5004716 | 5004716 | 20240903121326_tfc0c | KR000D | 2024-09-09T12:02:56.136Z | 2024-09-12T12:19:03.588Z |
5003204 | 5003204 | 20240904112338_MDQ9Q | KR000D | 2024-09-09T12:01:27.490Z | 2024-09-13T12:19:43.682Z |
4996524 | 4996524 | 20240902195311_o2fc6 | KR000D | 2024-09-08T12:04:54.175Z | 2024-09-11T12:20:55.681Z |
4996454 | 4996454 | 20240902194242_dcklT | KR000D | 2024-09-08T12:04:50.106Z | 2024-09-11T12:20:54.555Z |
4996059 | 4996059 | 20240902183552_1tK9H | KR000D | 2024-09-08T12:04:20.116Z | 2024-09-11T12:20:50.857Z |
4995872 | 4995872 | 20240902180316_LNsaB | KR000D | 2024-09-08T12:04:09.225Z | 2024-09-11T12:20:49.204Z |
4995845 | 4995845 | 20240902180019_HxNgN | KR000D | 2024-09-08T12:04:07.400Z | 2024-09-11T12:20:48.920Z |
4961928 | 4961928 | 20240811181816_aUlxi | KR000D | 2024-09-04T12:04:04.657Z | 2024-09-06T12:03:20.956Z |
4961703 | 4961703 | 20240811175807_BPOHN | KR000D | 2024-09-04T12:03:51.579Z | 2024-09-06T12:03:11.207Z |
4961601 | 4961601 | 20240811175141_2uC45 | KR000D | 2024-09-04T12:03:46.945Z | 2024-09-06T12:03:07.209Z |
4961541 | 4961541 | 20240811174640_lu1Tz | KR000D | 2024-09-04T12:03:44.808Z | 2024-09-06T12:03:04.780Z |
4961515 | 4961515 | 20240811174505_x6AUf | KR000D | 2024-09-04T12:03:43.634Z | 2024-09-06T12:03:03.860Z |
4961459 | 4961459 | 20240811174250_xFNA1 | KR000D | 2024-09-04T12:03:40.921Z | 2024-09-06T12:03:01.576Z |
4961300 | 4961300 | 20240811173017_JSfQN | KR000D | 2024-09-04T12:03:27.729Z | 2024-09-06T12:02:51.584Z |
4961224 | 4961224 | 20240811172458_qvkZ3 | KR000D | 2024-09-04T12:03:23.475Z | 2024-09-06T12:02:48.078Z |
4961197 | 4961197 | 20240811172326_ICWSz | KR000D | 2024-09-04T12:03:22.517Z | 2024-09-06T12:02:47.241Z |
4961137 | 4961137 | 20240811171926_JoiLX | KR000D | 2024-09-04T12:03:19.693Z | 2024-09-06T12:02:45.107Z |
4960868 | 4960868 | 20240811165801_UIlKC | KR000D | 2024-09-04T12:02:59.842Z | 2024-09-06T12:02:30.241Z |
4960835 | 4960835 | 20240811165420_RF2JI | KR000D | 2024-09-04T12:02:58.228Z | 2024-09-06T12:02:28.975Z |
4960818 | 4960818 | 20240811165124_fa0X9 | KR000D | 2024-09-04T12:02:56.730Z | 2024-09-06T12:02:27.800Z |
4960778 | 4960778 | 20240811164735_N98Hl | KR000D | 2024-09-04T12:02:54.430Z | 2024-09-06T12:02:25.936Z |
4960760 | 4960760 | 20240811164634_8zPY9 | KR000D | 2024-09-04T12:02:53.741Z | 2024-09-06T12:02:25.362Z |
4960671 | 4960671 | 20240811164220_0h7ei | KR000D | 2024-09-04T12:02:49.444Z | 2024-09-06T12:02:21.806Z |
4960531 | 4960531 | 20240811163209_wSnlh | KR000D | 2024-09-04T12:02:41.257Z | 2024-09-06T12:02:15.142Z |
4960495 | 4960495 | 20240811162831_JaDUH | KR000D | 2024-09-04T12:02:36.695Z | 2024-09-06T12:02:13.573Z |
4960429 | 4960429 | 20240811162514_YjWww | KR000D | 2024-09-04T12:02:32.292Z | 2024-09-06T12:02:09.096Z |
4960382 | 4960382 | 20240811162241_nwXp2 | KR000D | 2024-09-04T12:02:29.780Z | 2024-09-06T12:02:06.822Z |
4960116 | 4960116 | 20240811160244_wLnMv | KR000D | 2024-09-04T12:02:13.589Z | 2024-09-06T12:01:53.106Z |
4959900 | 4959900 | 20240811154755_KzoWZ | KR000D | 2024-09-04T12:02:02.140Z | 2024-09-06T12:01:42.613Z |
4959843 | 4959843 | 20240811154133_2M7bI | KR000D | 2024-09-04T12:01:58.845Z | 2024-09-06T12:01:39.937Z |
4959814 | 4959814 | 20240811154020_wT3ST | KR000D | 2024-09-04T12:01:57.455Z | 2024-09-06T12:01:38.889Z |
4959620 | 4959620 | 20240811152246_kCTvc | KR000D | 2024-09-04T12:01:45.339Z | 2024-09-06T12:01:27.358Z |
4959528 | 4959528 | 20240811151449_6KO7I | KR000D | 2024-09-04T12:01:39.775Z | 2024-09-06T12:01:21.330Z |
4959382 | 4959382 | 20240811145922_5r5Pb | KR000D | 2024-09-04T12:01:30.305Z | 2024-09-06T12:01:14.056Z |
4951909 | 4951909 | 20240811144432_l3e8V | KR000D | 2024-09-03T12:01:34.871Z | 2024-09-06T12:01:05.328Z |
4951799 | 4951799 | 20240811143140_hiSCt | KR000D | 2024-09-03T12:01:26.739Z | 2024-09-06T12:00:59.831Z |
4951709 | 4951709 | 20240811141716_uWX5h | KR000D | 2024-09-03T12:01:20.757Z | 2024-09-06T12:00:55.880Z |
4951563 | 4951563 | 20240811140206_vpTXw | KR000D | 2024-09-03T12:01:09.158Z | 2024-09-06T12:00:48.257Z |
4951546 | 4951546 | 20240811135949_ULdRT | KR000D | 2024-09-03T12:01:07.927Z | 2024-09-06T12:00:47.768Z |
4951534 | 4951534 | 20240811135940_5eyBl | KR000D | 2024-09-03T12:01:07.757Z | 2024-09-06T12:00:47.662Z |
4951509 | 4951509 | 20240811135725_QS0jw | KR000D | 2024-09-03T12:01:06.528Z | 2024-09-06T12:00:47.003Z |
4951499 | 4951499 | 20240811135655_lzpY3 | KR000D | 2024-09-03T12:01:06.028Z | 2024-09-06T12:00:46.586Z |
4951467 | 4951467 | 20240811135012_W1KM9 | KR000D | 2024-09-03T12:01:03.726Z | 2024-09-06T12:00:45.282Z |
4951326 | 4951326 | 20240811133056_EeZJ1 | KR000D | 2024-09-03T12:00:51.758Z | 2024-09-06T12:00:38.740Z |
4951110 | 4951110 | 20240811130746_xFEmt | KR000D | 2024-09-03T12:00:29.514Z | 2024-09-06T12:00:24.383Z |
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);