participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,916 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 |
---|---|---|---|---|---|
5556219 | 5556219 | 20241119210424_OGKz3 | KR0014 | 2024-11-20T14:07:41.120Z | 2024-11-21T14:18:53.539Z |
5556011 | 5556011 | 20241119191427_kAwXu | KR0014 | 2024-11-20T14:07:13.185Z | 2024-11-21T14:18:53.441Z |
5552352 | 5552352 | 20241118205519_uUJ2d | KR0014 | 2024-11-19T14:06:25.269Z | 2024-11-21T14:20:22.784Z |
5552328 | 5552328 | 20241118203748_scGIH | KR0014 | 2024-11-19T14:06:22.818Z | 2024-11-21T14:20:22.095Z |
5552229 | 5552229 | 20241118192945_Y6mUB | KR0014 | 2024-11-19T14:06:08.694Z | 2024-11-21T14:20:18.750Z |
5552194 | 5552194 | 20241118191427_aEDhm | KR0014 | 2024-11-19T14:06:06.992Z | 2024-11-21T14:20:17.815Z |
5552060 | 5552060 | 20241118174321_JEBy3 | KR0014 | 2024-11-19T14:05:58.798Z | 2024-11-21T14:20:13.450Z |
5552046 | 5552046 | 20241118173026_0MCKC | KR0014 | 2024-11-19T14:05:57.922Z | 2024-11-21T14:20:12.425Z |
5551951 | 5551951 | 20241118160703_7w5vh | KR0014 | 2024-11-19T14:05:50.135Z | 2024-11-21T14:20:07.898Z |
5551780 | 5551780 | 20241118151321_iXPKX | KR0014 | 2024-11-19T14:05:29.887Z | 2024-11-21T14:20:03.242Z |
5551514 | 5551514 | 20241118140433_dACZ2 | KR0014 | 2024-11-19T14:04:56.095Z | 2024-11-21T14:19:55.018Z |
5547842 | 5547842 | 20241117200221_5NfWF | KR0014 | 2024-11-18T14:06:43.883Z | 2024-11-21T14:21:54.501Z |
5547830 | 5547830 | 20241117195751_Gtzec | KR0014 | 2024-11-18T14:06:42.806Z | 2024-11-21T14:21:54.339Z |
5547772 | 5547772 | 20241117194227_2JtMA | KR0014 | 2024-11-18T14:06:31.121Z | 2024-11-21T14:21:52.014Z |
5547742 | 5547742 | 20241117193000_5rywk | KR0014 | 2024-11-18T14:06:25.649Z | 2024-11-21T14:21:51.551Z |
5547604 | 5547604 | 20241117183123_oaH3N | KR0014 | 2024-11-18T14:06:07.439Z | 2024-11-21T14:21:47.469Z |
5547570 | 5547570 | 20241117181043_Pec3x | KR0014 | 2024-11-18T14:06:04.447Z | 2024-11-21T14:21:45.258Z |
5547487 | 5547487 | 20241117171841_Ts2GU | KR0014 | 2024-11-18T14:05:57.509Z | 2024-11-21T14:21:42.262Z |
5547159 | 5547159 | 20241117150206_Sxpkc | KR0014 | 2024-11-18T14:05:12.260Z | 2024-11-21T14:21:36.440Z |
5547134 | 5547134 | 20241117145750_3wcIA | KR0014 | 2024-11-18T14:05:09.584Z | 2024-11-21T14:21:35.957Z |
5547054 | 5547054 | 20241117143053_I9f2j | KR0014 | 2024-11-18T14:04:51.424Z | 2024-11-21T14:21:34.704Z |
5525581 | 5525581 | 20241105191200_MwWPE | KR0014 | 2024-11-12T14:26:43.619Z | 2024-11-14T14:23:13.685Z |
5525470 | 5525470 | 20241105142753_tlNJM | KR0014 | 2024-11-12T14:26:33.505Z | 2024-11-14T14:23:05.397Z |
5525291 | 5525291 | 20241106162837_3qDA7 | KR0014 | 2024-11-12T14:25:41.884Z | 2024-11-15T14:24:40.821Z |
5521999 | 5521999 | 20241110184509_3Epls | KR0014 | 2024-11-12T14:12:23.386Z | 2024-11-19T14:21:56.686Z |
5521707 | 5521707 | 20241110180602_A5246 | KR0014 | 2024-11-12T14:11:52.519Z | 2024-11-19T14:21:54.485Z |
5521593 | 5521593 | 20241110173931_PARan | KR0014 | 2024-11-12T14:11:42.120Z | 2024-11-19T14:21:53.685Z |
5521179 | 5521179 | 20241110162011_owmxH | KR0014 | 2024-11-12T14:10:35.605Z | 2024-11-19T14:21:49.908Z |
5521086 | 5521086 | 20241110160055_2437R | KR0014 | 2024-11-12T14:10:26.612Z | 2024-11-19T14:21:48.311Z |
5520946 | 5520946 | 20241110153040_wnZok | KR0014 | 2024-11-12T14:09:51.972Z | 2024-11-19T14:21:46.363Z |
5520923 | 5520923 | 20241110152601_B2jbm | KR0014 | 2024-11-12T14:09:49.003Z | 2024-11-19T14:21:45.719Z |
5520815 | 5520815 | 20241110144823_QnT29 | KR0014 | 2024-11-12T14:09:33.285Z | 2024-11-19T14:21:44.224Z |
5502221 | 5502221 | 20241107174340_c6Iwz | KR0014 | 2024-11-09T14:11:04.500Z | 2024-11-16T14:27:51.795Z |
5501829 | 5501829 | 20241107161112_UgO1K | KR0014 | 2024-11-09T14:10:31.761Z | 2024-11-16T14:27:48.677Z |
5501803 | 5501803 | 20241107155844_P5AQ7 | KR0014 | 2024-11-09T14:10:27.048Z | 2024-11-16T14:27:48.398Z |
5501777 | 5501777 | 20241107154329_LiB79 | KR0014 | 2024-11-09T14:10:22.433Z | 2024-11-16T14:27:48.255Z |
5501723 | 5501723 | 20241107152704_lUsiP | KR0014 | 2024-11-09T14:10:15.748Z | 2024-11-16T14:27:46.237Z |
5501018 | 5501018 | 20241108185834_Pk8Hr | KR0014 | 2024-11-09T14:07:34.151Z | 2024-11-17T14:23:32.006Z |
5500743 | 5500743 | 20241108171543_uZ3pi | KR0014 | 2024-11-09T14:07:01.083Z | 2024-11-17T14:23:27.391Z |
5500705 | 5500705 | 20241108170519_s9Y7t | KR0014 | 2024-11-09T14:06:57.228Z | 2024-11-17T14:23:26.737Z |
5499663 | 5499663 | 20241108125349_C4EuM | KR0014 | 2024-11-09T14:04:40.931Z | 2024-11-17T14:23:14.313Z |
5489400 | 5489400 | 20241105184734_dt4gG | KR0014 | 2024-11-07T14:11:58.905Z | 2024-11-14T14:23:12.751Z |
5489384 | 5489384 | 20241105184326_TxVit | KR0014 | 2024-11-07T14:11:57.937Z | 2024-11-14T14:23:12.672Z |
5488942 | 5488942 | 20241105172412_sHLq2 | KR0014 | 2024-11-07T14:11:03.820Z | 2024-11-14T14:23:08.757Z |
5488830 | 5488830 | 20241105170407_2lTZL | KR0014 | 2024-11-07T14:10:40.434Z | 2024-11-14T14:23:08.028Z |
5488812 | 5488812 | 20241105165918_CDzj5 | KR0014 | 2024-11-07T14:10:39.099Z | 2024-11-14T14:23:07.803Z |
5488611 | 5488611 | 20241105155749_ch33t | KR0014 | 2024-11-07T14:10:22.280Z | 2024-11-14T14:23:06.803Z |
5488594 | 5488594 | 20241105155505_2DVsD | KR0014 | 2024-11-07T14:10:21.672Z | 2024-11-14T14:23:06.772Z |
5488577 | 5488577 | 20241105154901_Bk3Gz | KR0014 | 2024-11-07T14:10:20.865Z | 2024-11-14T14:23:06.746Z |
5487605 | 5487605 | 20241106173024_ohD2B | KR0014 | 2024-11-07T14:06:18.467Z | 2024-11-15T14:24:43.412Z |
5487442 | 5487442 | 20241106161623_iyEXV | KR0014 | 2024-11-07T14:05:47.879Z | 2024-11-15T14:24:40.484Z |
5486725 | 5486725 | 20241106130330_mQJ11 | KR0014 | 2024-11-07T14:03:52.445Z | 2024-11-15T14:24:33.509Z |
5486516 | 5486516 | 20241106115805_Oynl4 | KR0014 | 2024-11-07T14:03:16.623Z | 2024-11-15T14:24:30.860Z |
5486434 | 5486434 | 20241106113745_OrhRL | KR0014 | 2024-11-07T14:02:57.905Z | 2024-11-15T14:24:30.060Z |
5481110 | 5481110 | 20241104141802_HqVk1 | KR0014 | 2024-11-06T14:09:07.475Z | 2024-11-13T14:27:26.002Z |
5481015 | 5481015 | 20241104123314_SNbkh | KR0014 | 2024-11-06T14:08:29.504Z | 2024-11-13T14:27:25.059Z |
5474203 | 5474203 | 20241103162528_PApxK | KR0014 | 2024-11-05T14:10:24.767Z | 2024-11-12T14:27:50.709Z |
5474161 | 5474161 | 20241103161348_kib9b | KR0014 | 2024-11-05T14:10:15.787Z | 2024-11-12T14:27:50.646Z |
5473921 | 5473921 | 20241103152124_UFRL6 | KR0014 | 2024-11-05T14:09:53.827Z | 2024-11-12T14:27:50.226Z |
5472889 | 5472889 | 20241103125658_ifoNL | KR0014 | 2024-11-05T14:07:50.112Z | 2024-11-12T14:27:46.863Z |
5466810 | 5466810 | 20241102190247_7blr9 | KR0014 | 2024-11-04T14:09:53.210Z | 2024-11-11T14:22:43.580Z |
5466705 | 5466705 | 20241102183716_1Hyas | KR0014 | 2024-11-04T14:09:35.692Z | 2024-11-11T14:22:42.697Z |
5466602 | 5466602 | 20241102181632_KfxO2 | KR0014 | 2024-11-04T14:09:24.883Z | 2024-11-11T14:22:41.623Z |
5466524 | 5466524 | 20241102175437_7yN6W | KR0014 | 2024-11-04T14:09:07.226Z | 2024-11-11T14:22:41.214Z |
5466475 | 5466475 | 20241102174929_tQR2W | KR0014 | 2024-11-04T14:08:57.362Z | 2024-11-11T14:22:41.068Z |
5466351 | 5466351 | 20241102172130_BXgvu | KR0014 | 2024-11-04T14:08:41.403Z | 2024-11-11T14:22:40.618Z |
5465529 | 5465529 | 20241102100602_CBKqy | KR0014 | 2024-11-04T14:04:52.265Z | 2024-11-11T14:22:25.442Z |
5430007 | 5430007 | 20241028204548_Z0wrH | KR0014 | 2024-10-31T12:17:23.692Z | 2024-11-06T14:27:18.312Z |
5429521 | 5429521 | 20241028193012_3h35M | KR0014 | 2024-10-31T12:16:40.973Z | 2024-11-06T14:27:16.193Z |
5429389 | 5429389 | 20241028191849_vTVAH | KR0014 | 2024-10-31T12:16:30.371Z | 2024-11-06T14:27:15.884Z |
5425709 | 5425709 | 20241029174403_9LCkG | KR0014 | 2024-10-31T12:08:24.284Z | 2024-11-07T14:26:35.819Z |
5425561 | 5425561 | 20241029171241_fpaib | KR0014 | 2024-10-31T12:08:06.724Z | 2024-11-07T14:26:34.965Z |
5425410 | 5425410 | 20241029164228_vRcqS | KR0014 | 2024-10-31T12:07:36.611Z | 2024-11-07T14:26:34.326Z |
5425330 | 5425330 | 20241029162818_htjgd | KR0014 | 2024-10-31T12:07:29.665Z | 2024-11-07T14:26:34.223Z |
5425243 | 5425243 | 20241029161346_a80Ck | KR0014 | 2024-10-31T12:07:20.145Z | 2024-11-07T14:26:33.976Z |
5424815 | 5424815 | 20241029151645_l3Q8k | KR0014 | 2024-10-31T12:06:05.274Z | 2024-11-07T14:26:32.912Z |
5424543 | 5424543 | 20241029144234_v4aDJ | KR0014 | 2024-10-31T12:05:20.763Z | 2024-11-07T14:26:32.014Z |
5424120 | 5424120 | 20241029131744_WRREo | KR0014 | 2024-10-31T12:03:50.611Z | 2024-11-07T14:26:30.327Z |
5392072 | 5392072 | 20241026145819_4KY2L | KR0014 | 2024-10-28T12:07:07.113Z | 2024-11-04T14:28:37.269Z |
5391941 | 5391941 | 20241026141642_2HrL1 | KR0014 | 2024-10-28T12:06:55.067Z | 2024-11-04T14:28:37.036Z |
5391900 | 5391900 | 20241026140752_0pZxx | KR0014 | 2024-10-28T12:06:50.789Z | 2024-11-04T14:28:36.887Z |
5391526 | 5391526 | 20241026121230_7vFSy | KR0014 | 2024-10-28T12:05:46.605Z | 2024-11-04T14:28:35.328Z |
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 |
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);