participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,247 rows where station_code = "KR000E" 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 |
---|---|---|---|---|---|
5097087 | 5097087 | 20240912143127_RSs8M | KR000E | 2024-09-16T12:16:44.699Z | 2024-09-16T12:17:32.028Z |
5097009 | 5097009 | 20240912133511_81m8q | KR000E | 2024-09-16T12:16:42.220Z | 2024-09-16T12:17:31.996Z |
5096964 | 5096964 | 20240912131245_1kkz1 | KR000E | 2024-09-16T12:16:40.796Z | 2024-09-16T12:17:31.981Z |
5096848 | 5096848 | 20240912115704_ukO7L | KR000E | 2024-09-16T12:16:35.788Z | 2024-09-16T12:17:31.937Z |
5083769 | 5083769 | 20240912152041_CjcRD | KR000E | 2024-09-16T12:00:18.444Z | 2024-09-16T12:17:03.892Z |
5068996 | 5068996 | 20240910132022_DRJ0C | KR000E | 2024-09-14T12:19:23.605Z | 2024-09-16T12:20:16.128Z |
5068847 | 5068847 | 20240910124453_Rx6JY | KR000E | 2024-09-14T12:19:22.047Z | 2024-09-16T12:20:15.449Z |
5068105 | 5068105 | 20240910105651_tfjbl | KR000E | 2024-09-14T12:19:09.072Z | 2024-09-16T12:20:12.904Z |
5063116 | 5063116 | 20240909195918_CBaoF | KR000E | 2024-09-14T12:13:31.688Z | 2024-09-16T12:19:41.964Z |
5063092 | 5063092 | 20240909195053_Dq9aO | KR000E | 2024-09-14T12:13:26.835Z | 2024-09-16T12:19:41.611Z |
5062802 | 5062802 | 20240909182720_EFn83 | KR000E | 2024-09-14T12:12:53.160Z | 2024-09-16T12:19:39.639Z |
5062248 | 5062248 | 20240909170349_c3ft7 | KR000E | 2024-09-14T12:12:00.392Z | 2024-09-16T12:19:36.753Z |
5062037 | 5062037 | 20240909163503_lMQty | KR000E | 2024-09-14T12:11:46.049Z | 2024-09-16T12:19:35.342Z |
5061767 | 5061767 | 20240909155618_ttgd3 | KR000E | 2024-09-14T12:11:22.617Z | 2024-09-16T12:19:33.824Z |
5061727 | 5061727 | 20240909154746_Cc5w1 | KR000E | 2024-09-14T12:11:16.392Z | 2024-09-16T12:19:33.256Z |
5061532 | 5061532 | 20240909152143_fIXv5 | KR000E | 2024-09-14T12:10:56.239Z | 2024-09-16T12:19:32.057Z |
5061462 | 5061462 | 20240909150831_g9i19 | KR000E | 2024-09-14T12:10:51.225Z | 2024-09-16T12:19:31.711Z |
5061069 | 5061069 | 20240909140401_d93G6 | KR000E | 2024-09-14T12:10:13.099Z | 2024-09-16T12:19:28.955Z |
5061012 | 5061012 | 20240909135119_K8XG3 | KR000E | 2024-09-14T12:10:05.468Z | 2024-09-16T12:19:28.598Z |
5060931 | 5060931 | 20240909132757_oC4eZ | KR000E | 2024-09-14T12:09:56.611Z | 2024-09-16T12:19:28.310Z |
5060897 | 5060897 | 20240909131707_Fe0aJ | KR000E | 2024-09-14T12:09:54.239Z | 2024-09-16T12:19:28.110Z |
5052059 | 5052059 | 20240907193724_WyPQW | KR000E | 2024-09-13T12:14:55.519Z | 2024-09-16T12:21:03.520Z |
5051937 | 5051937 | 20240907190907_PbeRO | KR000E | 2024-09-13T12:14:47.982Z | 2024-09-16T12:21:02.550Z |
5051743 | 5051743 | 20240907183037_05pp5 | KR000E | 2024-09-13T12:14:32.417Z | 2024-09-16T12:21:01.740Z |
5051686 | 5051686 | 20240907182419_tml0f | KR000E | 2024-09-13T12:14:29.693Z | 2024-09-16T12:21:01.619Z |
5051567 | 5051567 | 20240907174643_vsT3E | KR000E | 2024-09-13T12:14:23.219Z | 2024-09-16T12:21:01.344Z |
5051475 | 5051475 | 20240907173239_HsQ8H | KR000E | 2024-09-13T12:14:18.296Z | 2024-09-16T12:21:00.549Z |
5051452 | 5051452 | 20240907172933_Xgp3a | KR000E | 2024-09-13T12:14:16.463Z | 2024-09-16T12:21:00.500Z |
5051151 | 5051151 | 20240907165413_gvfjE | KR000E | 2024-09-13T12:14:04.413Z | 2024-09-16T12:20:59.738Z |
5050862 | 5050862 | 20240907161656_c70Es | KR000E | 2024-09-13T12:13:49.910Z | 2024-09-16T12:20:58.821Z |
5050484 | 5050484 | 20240907152515_y20cL | KR000E | 2024-09-13T12:13:33.457Z | 2024-09-16T12:20:57.812Z |
5050379 | 5050379 | 20240907151554_JDerz | KR000E | 2024-09-13T12:13:29.523Z | 2024-09-16T12:20:57.508Z |
5050286 | 5050286 | 20240907150424_kozuQ | KR000E | 2024-09-13T12:13:22.663Z | 2024-09-16T12:20:56.927Z |
5050200 | 5050200 | 20240907144716_EN1jw | KR000E | 2024-09-13T12:13:16.361Z | 2024-09-16T12:20:56.692Z |
5050084 | 5050084 | 20240909124115_4kpI3 | KR000E | 2024-09-13T12:12:39.241Z | 2024-09-16T12:20:45.414Z |
5044659 | 5044659 | 20240908152703_cK8A3 | KR000E | 2024-09-13T12:02:44.805Z | 2024-09-16T12:20:22.944Z |
5044567 | 5044567 | 20240908151724_tOqFs | KR000E | 2024-09-13T12:02:25.079Z | 2024-09-16T12:20:22.698Z |
5044503 | 5044503 | 20240908150721_DcBPO | KR000E | 2024-09-13T12:02:17.643Z | 2024-09-16T12:20:22.396Z |
5044395 | 5044395 | 20240908145606_peyLV | KR000E | 2024-09-13T12:02:06.963Z | 2024-09-16T12:20:21.850Z |
5044198 | 5044198 | 20240908142659_DRsgZ | KR000E | 2024-09-13T12:01:39.519Z | 2024-09-16T12:20:20.489Z |
5044004 | 5044004 | 20240908135023_Caint | KR000E | 2024-09-13T12:01:14.284Z | 2024-09-16T12:20:19.614Z |
5043642 | 5043642 | 20240908123125_KbbpR | KR000E | 2024-09-13T12:00:18.991Z | 2024-09-16T12:20:18.394Z |
5043269 | 5043269 | 20240907142006_ibLgb | KR000E | 2024-09-12T12:17:25.965Z | 2024-09-16T12:20:56.141Z |
5043131 | 5043131 | 20240907135645_V94Cd | KR000E | 2024-09-12T12:17:23.853Z | 2024-09-16T12:20:55.571Z |
5042994 | 5042994 | 20240907132746_hN424 | KR000E | 2024-09-12T12:17:21.483Z | 2024-09-16T12:20:55.094Z |
5038402 | 5038402 | 20240905200358_5Y4CC | KR000E | 2024-09-12T12:14:38.394Z | 2024-09-14T12:22:55.942Z |
5036873 | 5036873 | 20240905143818_HTe9e | KR000E | 2024-09-12T12:13:56.675Z | 2024-09-14T12:22:53.524Z |
5036695 | 5036695 | 20240905141503_DS5z3 | KR000E | 2024-09-12T12:13:52.550Z | 2024-09-14T12:22:53.110Z |
5036691 | 5036691 | 20240905141437_JHhY2 | KR000E | 2024-09-12T12:13:52.244Z | 2024-09-14T12:22:53.105Z |
5036587 | 5036587 | 20240905135711_WSe76 | KR000E | 2024-09-12T12:13:49.550Z | 2024-09-14T12:22:52.606Z |
5036229 | 5036229 | 20240905130012_3dMlt | KR000E | 2024-09-12T12:13:30.222Z | 2024-09-14T12:22:52.119Z |
5030659 | 5030659 | 20240906172816_ZhgAx | KR000E | 2024-09-12T12:02:35.365Z | 2024-09-15T12:21:19.418Z |
5030655 | 5030655 | 20240906172807_e2cDe | KR000E | 2024-09-12T12:02:34.518Z | 2024-09-15T12:21:19.407Z |
5024091 | 5024091 | 20240905200358_K5UcD | KR000E | 2024-09-11T12:02:36.690Z | 2024-09-11T12:16:31.936Z |
5018757 | 5018757 | 20240904200746_KBdHG | KR000E | 2024-09-10T12:11:30.607Z | 2024-09-13T12:19:48.833Z |
5018701 | 5018701 | 20240904194633_WfVAZ | KR000E | 2024-09-10T12:11:19.747Z | 2024-09-13T12:19:48.537Z |
5018593 | 5018593 | 20240904190654_gFS75 | KR000E | 2024-09-10T12:10:57.642Z | 2024-09-13T12:19:48.273Z |
5018499 | 5018499 | 20240904182820_MvyGt | KR000E | 2024-09-10T12:10:43.591Z | 2024-09-13T12:19:47.984Z |
5018493 | 5018493 | 20240904182711_1wili | KR000E | 2024-09-10T12:10:42.913Z | 2024-09-13T12:19:47.964Z |
5018477 | 5018477 | 20240904182018_slLPz | KR000E | 2024-09-10T12:10:41.730Z | 2024-09-13T12:19:47.952Z |
5018473 | 5018473 | 20240904182000_38BGV | KR000E | 2024-09-10T12:10:41.259Z | 2024-09-13T12:19:47.949Z |
5018444 | 5018444 | 20240904181154_ZzDPJ | KR000E | 2024-09-10T12:10:37.798Z | 2024-09-13T12:19:47.903Z |
5018423 | 5018423 | 20240904180353_T0bCG | KR000E | 2024-09-10T12:10:36.250Z | 2024-09-13T12:19:47.880Z |
5018408 | 5018408 | 20240904180020_oEySd | KR000E | 2024-09-10T12:10:34.684Z | 2024-09-13T12:19:47.824Z |
5018405 | 5018405 | 20240904175712_UpGSZ | KR000E | 2024-09-10T12:10:34.503Z | 2024-09-13T12:19:47.781Z |
5016912 | 5016912 | 20240904151043_oX2OX | KR000E | 2024-09-10T12:08:30.821Z | 2024-09-13T12:19:46.444Z |
5016730 | 5016730 | 20240904144741_Oly5U | KR000E | 2024-09-10T12:08:13.159Z | 2024-09-13T12:19:46.205Z |
5016334 | 5016334 | 20240904140113_HZuey | KR000E | 2024-09-10T12:07:42.208Z | 2024-09-13T12:19:45.523Z |
5016078 | 5016078 | 20240904132919_lG97c | KR000E | 2024-09-10T12:07:19.586Z | 2024-09-13T12:19:45.195Z |
5015904 | 5015904 | 20240904130033_ggjNQ | KR000E | 2024-09-10T12:06:58.147Z | 2024-09-13T12:19:44.925Z |
5015899 | 5015899 | 20240904125625_Zs3dH | KR000E | 2024-09-10T12:06:57.318Z | 2024-09-13T12:19:44.846Z |
5015878 | 5015878 | 20240904125144_Mbyex | KR000E | 2024-09-10T12:06:55.065Z | 2024-09-13T12:19:44.786Z |
5015726 | 5015726 | 20240904122022_olT9n | KR000E | 2024-09-10T12:06:42.158Z | 2024-09-13T12:19:44.627Z |
5015527 | 5015527 | 20240904114909_olCXg | KR000E | 2024-09-10T12:06:18.613Z | 2024-09-13T12:19:44.173Z |
5015166 | 5015166 | 20240905143818_oG4if | KR000E | 2024-09-10T12:04:37.358Z | 2024-09-11T12:16:31.410Z |
5015011 | 5015011 | 20240905141503_bbyEh | KR000E | 2024-09-10T12:04:23.629Z | 2024-09-11T12:16:31.351Z |
5015007 | 5015007 | 20240905141437_7BSjJ | KR000E | 2024-09-10T12:04:22.846Z | 2024-09-11T12:16:31.349Z |
5014895 | 5014895 | 20240905135711_2An4I | KR000E | 2024-09-10T12:04:12.511Z | 2024-09-11T12:16:31.318Z |
5014554 | 5014554 | 20240905130012_0vrrN | KR000E | 2024-09-10T12:03:26.923Z | 2024-09-11T12:16:31.202Z |
5006727 | 5006727 | 20240903183941_Bj5b4 | KR000E | 2024-09-09T12:04:57.789Z | 2024-09-12T12:19:09.341Z |
5005770 | 5005770 | 20240903160941_2rqGE | KR000E | 2024-09-09T12:04:03.541Z | 2024-09-12T12:19:06.611Z |
5005737 | 5005737 | 20240903160203_WVhql | KR000E | 2024-09-09T12:04:00.879Z | 2024-09-12T12:19:06.522Z |
5005700 | 5005700 | 20240903155925_TaJJF | KR000E | 2024-09-09T12:03:56.136Z | 2024-09-12T12:19:06.481Z |
5005618 | 5005618 | 20240903154545_PH4qL | KR000E | 2024-09-09T12:03:51.721Z | 2024-09-12T12:19:06.255Z |
5005578 | 5005578 | 20240903153956_xvldZ | KR000E | 2024-09-09T12:03:49.506Z | 2024-09-12T12:19:06.207Z |
5005484 | 5005484 | 20240903152004_gx9XQ | KR000E | 2024-09-09T12:03:45.177Z | 2024-09-12T12:19:06.010Z |
5005301 | 5005301 | 20240903145019_UVdPw | KR000E | 2024-09-09T12:03:34.939Z | 2024-09-12T12:19:05.679Z |
5005008 | 5005008 | 20240903134512_XoqZQ | KR000E | 2024-09-09T12:03:15.692Z | 2024-09-12T12:19:05.142Z |
5004843 | 5004843 | 20240903130501_4nGJB | KR000E | 2024-09-09T12:03:06.782Z | 2024-09-12T12:19:04.344Z |
5004826 | 5004826 | 20240903130028_cGW8s | KR000E | 2024-09-09T12:03:04.834Z | 2024-09-12T12:19:04.280Z |
5004759 | 5004759 | 20240903123044_ROjq0 | KR000E | 2024-09-09T12:03:00.207Z | 2024-09-12T12:19:03.754Z |
5004691 | 5004691 | 20240903120908_L3EWY | KR000E | 2024-09-09T12:02:54.932Z | 2024-09-12T12:19:03.517Z |
5004434 | 5004434 | 20240903112840_zH7iP | KR000E | 2024-09-09T12:02:42.239Z | 2024-09-12T12:19:02.099Z |
5004429 | 5004429 | 20240903112753_NZxNk | KR000E | 2024-09-09T12:02:41.833Z | 2024-09-12T12:19:02.094Z |
5003277 | 5003277 | 20240904113123_001ui | KR000E | 2024-09-09T12:01:31.620Z | 2024-09-13T12:19:43.952Z |
4988126 | 4988126 | 20240901195920_E9xN0 | KR000E | 2024-09-07T12:06:53.865Z | 2024-09-10T12:19:12.777Z |
4988036 | 4988036 | 20240901194454_n5wmA | KR000E | 2024-09-07T12:06:45.704Z | 2024-09-10T12:19:12.327Z |
4987691 | 4987691 | 20240901183239_j0mkD | KR000E | 2024-09-07T12:06:07.481Z | 2024-09-10T12:19:11.185Z |
4987383 | 4987383 | 20240901172227_1QKlk | KR000E | 2024-09-07T12:05:42.298Z | 2024-09-10T12:19:10.684Z |
4987196 | 4987196 | 20240901165852_x83U8 | KR000E | 2024-09-07T12:05:26.639Z | 2024-09-10T12:19:10.243Z |
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);