participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,466 rows where station_code = "KR0018" 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 |
---|---|---|---|---|---|
5297899 | 5297899 | 20241012145209_0fFMu | KR0018 | 2024-10-14T12:09:19.998Z | 2024-10-18T12:15:05.071Z |
5297711 | 5297711 | 20241012141910_16SBN | KR0018 | 2024-10-14T12:09:02.048Z | 2024-10-18T12:15:02.984Z |
5289493 | 5289493 | 20241011153428_52TJW | KR0018 | 2024-10-13T12:10:54.503Z | 2024-10-18T12:19:05.731Z |
5289286 | 5289286 | 20241011151638_s4vtk | KR0018 | 2024-10-13T12:10:34.273Z | 2024-10-18T12:19:04.148Z |
5289195 | 5289195 | 20241011150956_3IJ5b | KR0018 | 2024-10-13T12:10:30.047Z | 2024-10-18T12:19:03.322Z |
5273808 | 5273808 | 20241009183942_R18rY | KR0018 | 2024-10-11T12:13:16.599Z | 2024-10-18T12:22:04.602Z |
5273184 | 5273184 | 20241009163511_SXCrw | KR0018 | 2024-10-11T12:12:06.338Z | 2024-10-18T12:22:00.271Z |
5267400 | 5267400 | 20241008200248_UT2hR | KR0018 | 2024-10-10T12:13:55.087Z | 2024-10-17T12:20:09.145Z |
5266165 | 5266165 | 20241008132240_lc612 | KR0018 | 2024-10-10T12:11:26.308Z | 2024-10-17T12:20:02.953Z |
5209306 | 5209306 | 20241001130734_o1957 | KR0018 | 2024-10-03T12:12:50.796Z | 2024-10-10T12:24:42.612Z |
5209061 | 5209061 | 20241002194925_28QBH | KR0018 | 2024-10-03T12:09:47.718Z | 2024-10-11T12:23:31.969Z |
5204056 | 5204056 | 20240930183450_3S2zE | KR0018 | 2024-10-02T12:11:05.949Z | 2024-10-09T12:29:12.155Z |
5191331 | 5191331 | 20240928194856_AM4fA | KR0018 | 2024-09-30T12:17:41.441Z | 2024-10-06T12:28:22.387Z |
5191296 | 5191296 | 20240928194348_bxaS8 | KR0018 | 2024-09-30T12:17:39.749Z | 2024-10-06T12:28:22.322Z |
5191013 | 5191013 | 20240928190740_38dwp | KR0018 | 2024-09-30T12:17:23.343Z | 2024-10-06T12:28:21.602Z |
5190811 | 5190811 | 20240928183253_yCLK5 | KR0018 | 2024-09-30T12:17:11.619Z | 2024-10-06T12:28:20.719Z |
5190752 | 5190752 | 20240928182120_IUeOk | KR0018 | 2024-09-30T12:17:08.893Z | 2024-10-06T12:28:20.384Z |
5189665 | 5189665 | 20240928142655_V0Cl0 | KR0018 | 2024-09-30T12:15:59.229Z | 2024-10-06T12:28:18.101Z |
5174309 | 5174309 | 20240927165741_2Z0Dz | KR0018 | 2024-09-28T12:13:44.850Z | 2024-10-05T12:28:57.754Z |
5174277 | 5174277 | 20240927165054_aINvI | KR0018 | 2024-09-28T12:13:42.829Z | 2024-10-05T12:28:57.717Z |
5174002 | 5174002 | 20240927161545_bfvMT | KR0018 | 2024-09-28T12:13:12.538Z | 2024-10-05T12:28:56.567Z |
5173870 | 5173870 | 20240927155651_RzOs5 | KR0018 | 2024-09-28T12:13:03.915Z | 2024-10-05T12:28:56.322Z |
5173631 | 5173631 | 20240927152432_cBpGp | KR0018 | 2024-09-28T12:12:44.298Z | 2024-10-05T12:28:55.799Z |
5173498 | 5173498 | 20240927150348_p640t | KR0018 | 2024-09-28T12:12:22.855Z | 2024-10-05T12:28:55.650Z |
5173154 | 5173154 | 20240927142110_Xl3WM | KR0018 | 2024-09-28T12:11:59.516Z | 2024-10-05T12:28:54.899Z |
5172723 | 5172723 | 20240927132821_u10yH | KR0018 | 2024-09-28T12:11:18.445Z | 2024-10-05T12:28:53.486Z |
5172562 | 5172562 | 20240927125726_Cx1t2 | KR0018 | 2024-09-28T12:11:00.917Z | 2024-10-05T12:28:52.753Z |
5168031 | 5168031 | 20240926175153_UExvA | KR0018 | 2024-09-27T12:06:26.915Z | 2024-10-04T12:25:32.014Z |
5168022 | 5168022 | 20240926174214_ZWfEB | KR0018 | 2024-09-27T12:06:25.557Z | 2024-10-04T12:25:31.971Z |
5167739 | 5167739 | 20240926145533_MOggV | KR0018 | 2024-09-27T12:05:39.972Z | 2024-10-04T12:25:29.582Z |
5167467 | 5167467 | 20240926115429_25pMZ | KR0018 | 2024-09-27T12:05:08.523Z | 2024-10-04T12:25:26.806Z |
5164895 | 5164895 | 20240924190903_B5NVc | KR0018 | 2024-09-26T12:13:06.857Z | 2024-10-02T12:19:02.885Z |
5164870 | 5164870 | 20240924190037_QE9ui | KR0018 | 2024-09-26T12:13:05.690Z | 2024-10-02T12:19:02.805Z |
5164764 | 5164764 | 20240924182908_2s20b | KR0018 | 2024-09-26T12:12:58.351Z | 2024-10-02T12:19:02.602Z |
5153675 | 5153675 | 20240923131111_yfQK3 | KR0018 | 2024-09-24T12:06:49.231Z | 2024-10-01T12:22:18.743Z |
5149644 | 5149644 | 20240922171319_kdtJy | KR0018 | 2024-09-23T12:08:49.256Z | 2024-09-30T12:22:49.041Z |
5135563 | 5135563 | 20240915160238_qBHZe | KR0018 | 2024-09-19T12:19:33.285Z | 2024-09-23T12:16:40.612Z |
5131048 | 5131048 | 20240915170907_LO3V6 | KR0018 | 2024-09-19T12:14:14.784Z | 2024-09-24T12:15:30.904Z |
5131041 | 5131041 | 20240915170501_ZHnU1 | KR0018 | 2024-09-19T12:14:13.109Z | 2024-09-24T12:15:30.835Z |
5124128 | 5124128 | 20240914153136_EKYeW | KR0018 | 2024-09-18T12:12:08.696Z | 2024-09-22T12:18:13.628Z |
5124084 | 5124084 | 20240914145954_rUP49 | KR0018 | 2024-09-18T12:12:06.716Z | 2024-09-22T12:18:13.075Z |
5123745 | 5123745 | 20240914111928_Uqw0J | KR0018 | 2024-09-18T12:11:55.506Z | 2024-09-22T12:18:10.490Z |
5110958 | 5110958 | 20240914193314_Ixmtq | KR0018 | 2024-09-18T12:01:14.827Z | 2024-09-23T12:15:52.861Z |
5110482 | 5110482 | 20240914162514_o8tmB | KR0018 | 2024-09-18T12:00:15.539Z | 2024-09-23T12:15:48.125Z |
5110477 | 5110477 | 20240914162223_CElKF | KR0018 | 2024-09-18T12:00:14.847Z | 2024-09-23T12:15:48.097Z |
5110293 | 5110293 | 20240913143830_VpVGI | KR0018 | 2024-09-17T12:15:03.398Z | 2024-09-21T12:16:53.625Z |
5098724 | 5098724 | 20240913190930_HWpmE | KR0018 | 2024-09-17T12:01:26.005Z | 2024-09-22T12:17:43.369Z |
5098699 | 5098699 | 20240913190317_LdFx4 | KR0018 | 2024-09-17T12:01:23.178Z | 2024-09-22T12:17:43.031Z |
5098614 | 5098614 | 20240913183550_2DhRU | KR0018 | 2024-09-17T12:01:05.949Z | 2024-09-22T12:17:42.250Z |
5068954 | 5068954 | 20240910131242_MVW4q | KR0018 | 2024-09-14T12:19:23.270Z | 2024-09-18T12:15:26.894Z |
5068948 | 5068948 | 20240910131224_42CQZ | KR0018 | 2024-09-14T12:19:23.213Z | 2024-09-18T12:15:26.885Z |
5062067 | 5062067 | 20240909164126_hWCCn | KR0018 | 2024-09-14T12:11:47.567Z | 2024-09-18T12:15:10.359Z |
5061973 | 5061973 | 20240909163128_jlYeh | KR0018 | 2024-09-14T12:11:42.575Z | 2024-09-18T12:15:10.266Z |
5061969 | 5061969 | 20240909163110_13ecq | KR0018 | 2024-09-14T12:11:42.397Z | 2024-09-18T12:15:10.263Z |
5061581 | 5061581 | 20240909152535_dAY13 | KR0018 | 2024-09-14T12:10:58.987Z | 2024-09-18T12:15:09.686Z |
5061406 | 5061406 | 20240909150405_MtuHt | KR0018 | 2024-09-14T12:10:47.859Z | 2024-09-18T12:15:09.087Z |
5061052 | 5061052 | 20240909135859_wVTdl | KR0018 | 2024-09-14T12:10:10.531Z | 2024-09-18T12:15:07.939Z |
5061048 | 5061048 | 20240909135856_SE38K | KR0018 | 2024-09-14T12:10:09.202Z | 2024-09-18T12:15:07.937Z |
5059552 | 5059552 | 20240910180533_sfWX9 | KR0018 | 2024-09-14T12:06:26.720Z | 2024-09-19T12:21:30.875Z |
5059529 | 5059529 | 20240910180124_n5kAt | KR0018 | 2024-09-14T12:06:19.270Z | 2024-09-19T12:21:30.844Z |
5058940 | 5058940 | 20240910170232_YzIXL | KR0018 | 2024-09-14T12:04:54.707Z | 2024-09-19T12:21:30.256Z |
5058513 | 5058513 | 20240910161848_0YVyF | KR0018 | 2024-09-14T12:03:49.973Z | 2024-09-19T12:21:29.668Z |
5058316 | 5058316 | 20240910160218_ueR2L | KR0018 | 2024-09-14T12:03:27.654Z | 2024-09-19T12:21:29.421Z |
5058085 | 5058085 | 20240910154311_mWqta | KR0018 | 2024-09-14T12:02:54.089Z | 2024-09-19T12:21:29.094Z |
5058059 | 5058059 | 20240910154035_NlkAi | KR0018 | 2024-09-14T12:02:46.195Z | 2024-09-19T12:21:29.060Z |
5057936 | 5057936 | 20240910152836_8mFEJ | KR0018 | 2024-09-14T12:02:27.118Z | 2024-09-19T12:21:28.958Z |
5057836 | 5057836 | 20240910151711_vWhYR | KR0018 | 2024-09-14T12:02:12.594Z | 2024-09-19T12:21:28.846Z |
5056906 | 5056906 | 20240908114053_1O1P7 | KR0018 | 2024-09-13T12:17:41.021Z | 2024-09-16T12:21:27.741Z |
5051578 | 5051578 | 20240907174734_6Qmkf | KR0018 | 2024-09-13T12:14:23.420Z | 2024-09-16T12:21:01.351Z |
5051122 | 5051122 | 20240907165104_2Mqy3 | KR0018 | 2024-09-13T12:14:02.923Z | 2024-09-16T12:20:59.614Z |
5051012 | 5051012 | 20240907163628_c84l3 | KR0018 | 2024-09-13T12:13:56.846Z | 2024-09-16T12:20:59.454Z |
5045931 | 5045931 | 20240908200800_jS63L | KR0018 | 2024-09-13T12:05:24.111Z | 2024-09-17T12:18:58.217Z |
5045890 | 5045890 | 20240908195623_n5zuW | KR0018 | 2024-09-13T12:05:19.038Z | 2024-09-17T12:18:58.077Z |
5045843 | 5045843 | 20240908194207_tJotG | KR0018 | 2024-09-13T12:05:12.109Z | 2024-09-17T12:18:57.579Z |
5045689 | 5045689 | 20240908180822_RuftQ | KR0018 | 2024-09-13T12:04:43.469Z | 2024-09-17T12:18:57.028Z |
5045546 | 5045546 | 20240908171914_wZWQB | KR0018 | 2024-09-13T12:04:18.557Z | 2024-09-17T12:18:56.752Z |
5045312 | 5045312 | 20240908165219_85tVQ | KR0018 | 2024-09-13T12:03:57.233Z | 2024-09-17T12:18:56.373Z |
5045239 | 5045239 | 20240908163919_DdLiO | KR0018 | 2024-09-13T12:03:45.275Z | 2024-09-17T12:18:56.085Z |
5043593 | 5043593 | 20240908121834_ertpr | KR0018 | 2024-09-13T12:00:10.500Z | 2024-09-17T12:18:52.444Z |
5042736 | 5042736 | 20240907123331_2hum5 | KR0018 | 2024-09-12T12:17:17.742Z | 2024-09-16T12:20:54.052Z |
5030630 | 5030630 | 20240906172118_L9UO2 | KR0018 | 2024-09-12T12:02:31.054Z | 2024-09-15T12:21:19.366Z |
5018264 | 5018264 | 20240904173338_ICPR1 | KR0018 | 2024-09-10T12:10:17.924Z | 2024-09-13T12:19:47.488Z |
5018095 | 5018095 | 20240904171106_9T8gB | KR0018 | 2024-09-10T12:09:59.978Z | 2024-09-13T12:19:47.206Z |
5017905 | 5017905 | 20240904165203_vo3b2 | KR0018 | 2024-09-10T12:09:44.276Z | 2024-09-13T12:19:47.128Z |
5017724 | 5017724 | 20240904163630_eUN1b | KR0018 | 2024-09-10T12:09:27.390Z | 2024-09-13T12:19:47.065Z |
5016781 | 5016781 | 20240904145453_l3Rgp | KR0018 | 2024-09-10T12:08:17.608Z | 2024-09-13T12:19:46.310Z |
5015767 | 5015767 | 20240904122838_OYxu2 | KR0018 | 2024-09-10T12:06:45.373Z | 2024-09-13T12:19:44.653Z |
5007144 | 5007144 | 20240903200446_jkZcy | KR0018 | 2024-09-09T12:05:28.481Z | 2024-09-12T12:19:11.672Z |
5006341 | 5006341 | 20240903172555_ZqoMd | KR0018 | 2024-09-09T12:04:31.562Z | 2024-09-12T12:19:08.154Z |
5006277 | 5006277 | 20240903171047_I05D1 | KR0018 | 2024-09-09T12:04:28.701Z | 2024-09-12T12:19:08.071Z |
5006083 | 5006083 | 20240903165318_Q9JS6 | KR0018 | 2024-09-09T12:04:19.635Z | 2024-09-12T12:19:07.616Z |
5005963 | 5005963 | 20240903163820_q6wxi | KR0018 | 2024-09-09T12:04:14.833Z | 2024-09-12T12:19:07.149Z |
5005789 | 5005789 | 20240903161126_kfVfP | KR0018 | 2024-09-09T12:04:04.708Z | 2024-09-12T12:19:06.659Z |
5005632 | 5005632 | 20240903154758_jje7l | KR0018 | 2024-09-09T12:03:52.245Z | 2024-09-12T12:19:06.331Z |
5005084 | 5005084 | 20240903135704_eo7Bf | KR0018 | 2024-09-09T12:03:19.209Z | 2024-09-12T12:19:05.235Z |
5005073 | 5005073 | 20240903135652_NhkGe | KR0018 | 2024-09-09T12:03:18.862Z | 2024-09-12T12:19:05.220Z |
5004998 | 5004998 | 20240903134439_44orq | KR0018 | 2024-09-09T12:03:15.282Z | 2024-09-12T12:19:04.723Z |
5004845 | 5004845 | 20240903130509_cE609 | KR0018 | 2024-09-09T12:03:07.404Z | 2024-09-12T12:19:04.346Z |
5003085 | 5003085 | 20240904110915_30pdV | KR0018 | 2024-09-09T12:01:19.453Z | 2024-09-13T12:19:43.343Z |
4995874 | 4995874 | 20240902180316_LNsaB | KR0018 | 2024-09-08T12:04:09.225Z | 2024-09-11T12:20:49.204Z |
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);