participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,849 rows where station_code = "KR0014" 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 |
---|---|---|---|---|---|
5430007 | 5430007 | 20241028204548_Z0wrH | KR0014 | 2024-10-31T12:17:23.692Z | 2024-11-03T14:24:59.520Z |
5429521 | 5429521 | 20241028193012_3h35M | KR0014 | 2024-10-31T12:16:40.973Z | 2024-11-03T14:24:57.664Z |
5429389 | 5429389 | 20241028191849_vTVAH | KR0014 | 2024-10-31T12:16:30.371Z | 2024-11-03T14:24:57.307Z |
5425709 | 5425709 | 20241029174403_9LCkG | KR0014 | 2024-10-31T12:08:24.284Z | 2024-11-03T14:23:46.077Z |
5425561 | 5425561 | 20241029171241_fpaib | KR0014 | 2024-10-31T12:08:06.724Z | 2024-11-03T14:23:45.012Z |
5425410 | 5425410 | 20241029164228_vRcqS | KR0014 | 2024-10-31T12:07:36.611Z | 2024-11-03T14:23:42.632Z |
5425330 | 5425330 | 20241029162818_htjgd | KR0014 | 2024-10-31T12:07:29.665Z | 2024-11-03T14:23:42.215Z |
5425243 | 5425243 | 20241029161346_a80Ck | KR0014 | 2024-10-31T12:07:20.145Z | 2024-11-03T14:23:41.485Z |
5424815 | 5424815 | 20241029151645_l3Q8k | KR0014 | 2024-10-31T12:06:05.274Z | 2024-11-03T14:23:39.303Z |
5424543 | 5424543 | 20241029144234_v4aDJ | KR0014 | 2024-10-31T12:05:20.763Z | 2024-11-03T14:23:38.052Z |
5424120 | 5424120 | 20241029131744_WRREo | KR0014 | 2024-10-31T12:03:50.611Z | 2024-11-03T14:23:34.433Z |
5392072 | 5392072 | 20241026145819_4KY2L | KR0014 | 2024-10-28T12:07:07.113Z | 2024-11-03T14:26:16.602Z |
5391941 | 5391941 | 20241026141642_2HrL1 | KR0014 | 2024-10-28T12:06:55.067Z | 2024-11-03T14:26:16.206Z |
5391900 | 5391900 | 20241026140752_0pZxx | KR0014 | 2024-10-28T12:06:50.789Z | 2024-11-03T14:26:16.108Z |
5391526 | 5391526 | 20241026121230_7vFSy | KR0014 | 2024-10-28T12:05:46.605Z | 2024-11-03T14:26:14.573Z |
5389158 | 5389158 | 20241023175937_g2OCr | KR0014 | 2024-10-27T12:24:16.539Z | 2024-11-01T12:26:49.514Z |
5381445 | 5381445 | 20241025182843_Ghp39 | KR0014 | 2024-10-27T12:08:28.295Z | 2024-11-03T14:27:17.370Z |
5381330 | 5381330 | 20241025170521_oyjcD | KR0014 | 2024-10-27T12:08:16.505Z | 2024-11-03T14:27:14.936Z |
5371352 | 5371352 | 20241024144501_asDRK | KR0014 | 2024-10-26T12:11:46.583Z | 2024-11-02T12:28:22.082Z |
5360883 | 5360883 | 20241023172647_oCfsT | KR0014 | 2024-10-25T12:11:41.680Z | 2024-11-01T12:26:48.243Z |
5360490 | 5360490 | 20241023162642_p23PO | KR0014 | 2024-10-25T12:10:59.534Z | 2024-11-01T12:26:47.468Z |
5360375 | 5360375 | 20241023160642_X3wai | KR0014 | 2024-10-25T12:10:42.808Z | 2024-11-01T12:26:47.400Z |
5359327 | 5359327 | 20241023131342_jShAu | KR0014 | 2024-10-25T12:08:11.708Z | 2024-11-01T12:26:45.429Z |
5359303 | 5359303 | 20241023131118_d4b1P | KR0014 | 2024-10-25T12:08:06.324Z | 2024-11-01T12:26:45.397Z |
5359297 | 5359297 | 20241023130945_44Rai | KR0014 | 2024-10-25T12:08:06.034Z | 2024-11-01T12:26:45.394Z |
5348173 | 5348173 | 20241022173615_xI0Kt | KR0014 | 2024-10-24T12:10:27.486Z | 2024-10-31T12:29:51.726Z |
5325766 | 5325766 | 20241020172731_ZI2Ao | KR0014 | 2024-10-21T12:06:51.009Z | 2024-10-29T12:26:31.956Z |
5325664 | 5325664 | 20241020165418_R3nqI | KR0014 | 2024-10-21T12:06:21.777Z | 2024-10-29T12:26:31.529Z |
5325509 | 5325509 | 20241020155529_VkiGK | KR0014 | 2024-10-21T12:05:59.817Z | 2024-10-29T12:26:31.272Z |
5325450 | 5325450 | 20241020153516_eIHuP | KR0014 | 2024-10-21T12:05:52.501Z | 2024-10-29T12:26:31.163Z |
5324600 | 5324600 | 20241020103846_nS2VB | KR0014 | 2024-10-21T12:03:17.438Z | 2024-10-29T12:26:29.546Z |
5324593 | 5324593 | 20241020103837_YELvB | KR0014 | 2024-10-21T12:03:16.417Z | 2024-10-29T12:26:29.536Z |
5322973 | 5322973 | 20241019204625_sLSLt | KR0014 | 2024-10-20T12:03:40.007Z | 2024-10-28T12:26:42.564Z |
5322945 | 5322945 | 20241019193604_8n235 | KR0014 | 2024-10-20T12:03:36.254Z | 2024-10-28T12:26:42.268Z |
5322935 | 5322935 | 20241019193046_fBbni | KR0014 | 2024-10-20T12:03:34.659Z | 2024-10-28T12:26:42.260Z |
5322928 | 5322928 | 20241019192213_tAwkX | KR0014 | 2024-10-20T12:03:33.510Z | 2024-10-28T12:26:42.187Z |
5322860 | 5322860 | 20241019164334_31ur3 | KR0014 | 2024-10-20T12:03:22.628Z | 2024-10-28T12:26:41.426Z |
5273680 | 5273680 | 20241009181210_jVZ0G | KR0014 | 2024-10-11T12:12:59.064Z | 2024-10-18T12:22:03.757Z |
5273301 | 5273301 | 20241009165833_ffCKb | KR0014 | 2024-10-11T12:12:13.135Z | 2024-10-18T12:22:00.919Z |
5271291 | 5271291 | 20241010113822_9vvr4 | KR0014 | 2024-10-11T12:06:30.729Z | 2024-10-19T12:27:04.513Z |
5242522 | 5242522 | 20241005141929_3xugl | KR0014 | 2024-10-07T12:12:18.936Z | 2024-10-14T12:24:29.045Z |
5241332 | 5241332 | 20241005102937_qsl0K | KR0014 | 2024-10-07T12:10:16.253Z | 2024-10-14T12:24:26.122Z |
5231001 | 5231001 | 20241004131559_HITU2 | KR0014 | 2024-10-06T12:09:40.563Z | 2024-10-13T12:26:17.192Z |
5209984 | 5209984 | 20241001181622_fAR2C | KR0014 | 2024-10-03T12:14:10.063Z | 2024-10-10T12:24:44.531Z |
5209947 | 5209947 | 20241001180630_k6U7s | KR0014 | 2024-10-03T12:14:02.384Z | 2024-10-10T12:24:44.392Z |
5209703 | 5209703 | 20241001164713_oAE2C | KR0014 | 2024-10-03T12:13:40.630Z | 2024-10-10T12:24:43.653Z |
5209696 | 5209696 | 20241001164518_ftPif | KR0014 | 2024-10-03T12:13:40.348Z | 2024-10-10T12:24:43.651Z |
5209621 | 5209621 | 20241001160920_D6A4T | KR0014 | 2024-10-03T12:13:35.004Z | 2024-10-10T12:24:43.397Z |
5209593 | 5209593 | 20241001155220_VzyEY | KR0014 | 2024-10-03T12:13:32.771Z | 2024-10-10T12:24:43.324Z |
5209478 | 5209478 | 20241001151333_2vb1W | KR0014 | 2024-10-03T12:13:21.854Z | 2024-10-10T12:24:43.057Z |
5209325 | 5209325 | 20241001132047_P3Gen | KR0014 | 2024-10-03T12:12:53.838Z | 2024-10-10T12:24:42.671Z |
5208885 | 5208885 | 20241002175830_Jb7B0 | KR0014 | 2024-10-03T12:09:30.351Z | 2024-10-11T12:23:30.647Z |
5208827 | 5208827 | 20241002173443_vOUMd | KR0014 | 2024-10-03T12:09:21.131Z | 2024-10-11T12:23:30.562Z |
5208822 | 5208822 | 20241002173315_Z579T | KR0014 | 2024-10-03T12:09:20.907Z | 2024-10-11T12:23:30.559Z |
5208619 | 5208619 | 20241002150039_vYN3S | KR0014 | 2024-10-03T12:08:52.309Z | 2024-10-11T12:23:30.144Z |
5208515 | 5208515 | 20241002134028_924x3 | KR0014 | 2024-10-03T12:08:26.908Z | 2024-10-11T12:23:29.696Z |
5204161 | 5204161 | 20240930190540_rJv5d | KR0014 | 2024-10-02T12:11:16.109Z | 2024-10-09T12:29:13.260Z |
5203905 | 5203905 | 20240930175451_2kam8 | KR0014 | 2024-10-02T12:10:51.026Z | 2024-10-09T12:29:10.954Z |
5203521 | 5203521 | 20240930161354_y4efz | KR0014 | 2024-10-02T12:10:21.832Z | 2024-10-09T12:29:08.304Z |
5203505 | 5203505 | 20240930160649_syVDW | KR0014 | 2024-10-02T12:10:20.991Z | 2024-10-09T12:29:08.270Z |
5203486 | 5203486 | 20240930160110_I6R3h | KR0014 | 2024-10-02T12:10:20.198Z | 2024-10-09T12:29:08.246Z |
5202866 | 5202866 | 20240930104430_fySMM | KR0014 | 2024-10-02T12:08:54.921Z | 2024-10-09T12:29:05.768Z |
5198818 | 5198818 | 20240929201101_liVNY | KR0014 | 2024-10-01T12:15:14.404Z | 2024-10-07T12:21:35.880Z |
5198380 | 5198380 | 20240929182210_aSUgu | KR0014 | 2024-10-01T12:14:41.073Z | 2024-10-07T12:21:32.964Z |
5198344 | 5198344 | 20240929181315_t3i3j | KR0014 | 2024-10-01T12:14:39.394Z | 2024-10-07T12:21:32.784Z |
5198213 | 5198213 | 20240929173555_YVLBH | KR0014 | 2024-10-01T12:14:31.826Z | 2024-10-07T12:21:30.910Z |
5198173 | 5198173 | 20240929171807_2vmD3 | KR0014 | 2024-10-01T12:14:27.428Z | 2024-10-07T12:21:30.838Z |
5197763 | 5197763 | 20240929160002_mKOEk | KR0014 | 2024-10-01T12:13:48.779Z | 2024-10-07T12:21:29.781Z |
5193938 | 5193938 | 20240929142645_2x1LZ | KR0014 | 2024-09-30T12:19:30.295Z | 2024-10-07T12:21:28.456Z |
5193705 | 5193705 | 20240929131855_KMlGO | KR0014 | 2024-09-30T12:19:24.522Z | 2024-10-07T12:21:26.957Z |
5193516 | 5193516 | 20240929121855_4xW2k | KR0014 | 2024-09-30T12:19:19.701Z | 2024-10-07T12:21:26.139Z |
5193424 | 5193424 | 20240929115807_8zJXG | KR0014 | 2024-09-30T12:19:16.966Z | 2024-10-07T12:21:25.640Z |
5191076 | 5191076 | 20240928191554_5BQub | KR0014 | 2024-09-30T12:17:28.620Z | 2024-10-06T12:28:21.744Z |
5190984 | 5190984 | 20240928190120_IQtd8 | KR0014 | 2024-09-30T12:17:21.960Z | 2024-10-06T12:28:21.474Z |
5190851 | 5190851 | 20240928184312_32ubM | KR0014 | 2024-09-30T12:17:13.466Z | 2024-10-06T12:28:20.963Z |
5190793 | 5190793 | 20240928182903_CWjsD | KR0014 | 2024-09-30T12:17:10.621Z | 2024-10-06T12:28:20.606Z |
5190791 | 5190791 | 20240928182843_rQi4Z | KR0014 | 2024-09-30T12:17:10.512Z | 2024-10-06T12:28:20.595Z |
5190762 | 5190762 | 20240928182516_aPPe7 | KR0014 | 2024-09-30T12:17:09.380Z | 2024-10-06T12:28:20.459Z |
5190687 | 5190687 | 20240928175932_k24K5 | KR0014 | 2024-09-30T12:17:05.868Z | 2024-10-06T12:28:20.034Z |
5190518 | 5190518 | 20240928172239_5e9S2 | KR0014 | 2024-09-30T12:16:56.534Z | 2024-10-06T12:28:19.624Z |
5190509 | 5190509 | 20240928172116_8DBJK | KR0014 | 2024-09-30T12:16:55.885Z | 2024-10-06T12:28:19.599Z |
5188837 | 5188837 | 20240928114139_Lmvan | KR0014 | 2024-09-30T12:14:39.261Z | 2024-10-06T12:28:16.174Z |
5188477 | 5188477 | 20240928104828_qOJCC | KR0014 | 2024-09-30T12:14:08.099Z | 2024-10-06T12:28:15.214Z |
5188376 | 5188376 | 20240928103757_b3Edm | KR0014 | 2024-09-30T12:14:00.521Z | 2024-10-06T12:28:14.974Z |
5174684 | 5174684 | 20240927202452_Jyc8d | KR0014 | 2024-09-28T12:14:15.534Z | 2024-10-05T12:29:05.160Z |
5174654 | 5174654 | 20240927193836_FtP2q | KR0014 | 2024-09-28T12:14:12.650Z | 2024-10-05T12:29:02.556Z |
5173515 | 5173515 | 20240927150627_E3FOU | KR0014 | 2024-09-28T12:12:25.060Z | 2024-10-05T12:28:55.657Z |
5173152 | 5173152 | 20240927142110_Xl3WM | KR0014 | 2024-09-28T12:11:59.515Z | 2024-10-05T12:28:54.899Z |
5163383 | 5163383 | 20240924142824_tO22j | KR0014 | 2024-09-26T12:11:43.937Z | 2024-10-02T12:19:00.052Z |
5153971 | 5153971 | 20240923144211_qWAdm | KR0014 | 2024-09-24T12:07:11.451Z | 2024-10-01T12:22:19.138Z |
5149795 | 5149795 | 20240922193937_SjGti | KR0014 | 2024-09-23T12:08:57.706Z | 2024-09-30T12:22:50.154Z |
5149764 | 5149764 | 20240922190725_cduHp | KR0014 | 2024-09-23T12:08:56.158Z | 2024-09-30T12:22:49.790Z |
5149672 | 5149672 | 20240922174137_kSyR0 | KR0014 | 2024-09-23T12:08:51.099Z | 2024-09-30T12:22:49.090Z |
5149414 | 5149414 | 20240922154720_cjveF | KR0014 | 2024-09-23T12:08:28.516Z | 2024-09-30T12:22:48.463Z |
5148999 | 5148999 | 20240922130752_8dmYQ | KR0014 | 2024-09-23T12:07:40.903Z | 2024-09-30T12:22:47.425Z |
5148948 | 5148948 | 20240922124715_bLmPw | KR0014 | 2024-09-23T12:07:35.806Z | 2024-09-30T12:22:47.367Z |
5148891 | 5148891 | 20240922122246_XhShT | KR0014 | 2024-09-23T12:07:32.012Z | 2024-09-30T12:22:47.258Z |
5135623 | 5135623 | 20240915164609_Bn0TP | KR0014 | 2024-09-19T12:19:34.072Z | 2024-09-23T12:16:40.929Z |
5135604 | 5135604 | 20240915163046_AAbz0 | KR0014 | 2024-09-19T12:19:33.906Z | 2024-09-23T12:16:40.909Z |
5135582 | 5135582 | 20240915161520_iz98k | KR0014 | 2024-09-19T12:19:33.535Z | 2024-09-23T12:16:40.681Z |
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);