participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,172 rows where station_code = "KR0039" 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 |
---|---|---|---|---|---|
5131326 | 5131326 | 20240915191623_pNX17 | KR0039 | 2024-09-19T12:14:56.610Z | 2024-09-19T12:14:56.610Z |
5131117 | 5131117 | 20240915175159_R57lC | KR0039 | 2024-09-19T12:14:23.141Z | 2024-09-19T12:14:23.141Z |
5123677 | 5123677 | 20240914110326_lbRyz | KR0039 | 2024-09-18T12:11:53.876Z | 2024-09-19T12:20:13.748Z |
5068558 | 5068558 | 20240910114817_8EyhN | KR0039 | 2024-09-14T12:19:17.923Z | 2024-09-18T12:15:26.309Z |
5063136 | 5063136 | 20240909200140_3Jgz3 | KR0039 | 2024-09-14T12:13:33.757Z | 2024-09-18T12:15:13.083Z |
5063098 | 5063098 | 20240909195133_9bNg2 | KR0039 | 2024-09-14T12:13:27.712Z | 2024-09-18T12:15:13.004Z |
5062932 | 5062932 | 20240909191247_ujLYN | KR0039 | 2024-09-14T12:13:05.050Z | 2024-09-18T12:15:12.565Z |
5062774 | 5062774 | 20240909182136_2t8WD | KR0039 | 2024-09-14T12:12:49.615Z | 2024-09-18T12:15:12.058Z |
5062747 | 5062747 | 20240909181237_eV3oH | KR0039 | 2024-09-14T12:12:46.971Z | 2024-09-18T12:15:12.000Z |
5061907 | 5061907 | 20240909162245_3Tg2g | KR0039 | 2024-09-14T12:11:37.836Z | 2024-09-18T12:15:10.130Z |
5061852 | 5061852 | 20240909160955_uJe2I | KR0039 | 2024-09-14T12:11:32.825Z | 2024-09-18T12:15:10.064Z |
5061828 | 5061828 | 20240909160544_wUu5P | KR0039 | 2024-09-14T12:11:30.972Z | 2024-09-18T12:15:10.019Z |
5061688 | 5061688 | 20240909154246_DeSBz | KR0039 | 2024-09-14T12:11:11.473Z | 2024-09-18T12:15:09.869Z |
5061432 | 5061432 | 20240909150552_ApLYo | KR0039 | 2024-09-14T12:10:49.724Z | 2024-09-18T12:15:09.212Z |
5061387 | 5061387 | 20240909145843_vd2J2 | KR0039 | 2024-09-14T12:10:45.754Z | 2024-09-18T12:15:09.079Z |
5060992 | 5060992 | 20240909134353_gRGXV | KR0039 | 2024-09-14T12:10:03.476Z | 2024-09-18T12:15:07.742Z |
5060947 | 5060947 | 20240909133244_odYO4 | KR0039 | 2024-09-14T12:09:58.382Z | 2024-09-18T12:15:07.482Z |
5059820 | 5059820 | 20240910185922_UtvF9 | KR0039 | 2024-09-14T12:07:20.554Z | 2024-09-19T12:21:31.286Z |
5059508 | 5059508 | 20240910175416_Lk8uj | KR0039 | 2024-09-14T12:06:14.526Z | 2024-09-19T12:21:30.832Z |
5059449 | 5059449 | 20240910174413_oTUi9 | KR0039 | 2024-09-14T12:06:06.779Z | 2024-09-19T12:21:30.774Z |
5059231 | 5059231 | 20240910172502_QOsy4 | KR0039 | 2024-09-14T12:05:29.078Z | 2024-09-19T12:21:30.465Z |
5058757 | 5058757 | 20240910164138_jSbyv | KR0039 | 2024-09-14T12:04:27.287Z | 2024-09-19T12:21:29.990Z |
5058357 | 5058357 | 20240910160642_cV63v | KR0039 | 2024-09-14T12:03:34.996Z | 2024-09-19T12:21:29.460Z |
5058129 | 5058129 | 20240910154703_Z7qmF | KR0039 | 2024-09-14T12:03:00.547Z | 2024-09-19T12:21:29.162Z |
5057478 | 5057478 | 20240910143337_Wv3r2 | KR0039 | 2024-09-14T12:01:09.843Z | 2024-09-19T12:21:27.922Z |
5057023 | 5057023 | 20240908115545_fonw7 | KR0039 | 2024-09-13T12:17:43.827Z | 2024-09-16T12:21:28.462Z |
5056901 | 5056901 | 20240908113831_pLcSR | KR0039 | 2024-09-13T12:17:40.784Z | 2024-09-16T12:21:27.686Z |
5052102 | 5052102 | 20240907194101_Vm96s | KR0039 | 2024-09-13T12:14:56.612Z | 2024-09-16T12:21:03.718Z |
5051945 | 5051945 | 20240907191202_w4Mkl | KR0039 | 2024-09-13T12:14:49.035Z | 2024-09-16T12:21:02.556Z |
5051919 | 5051919 | 20240907190456_tcu9A | KR0039 | 2024-09-13T12:14:45.283Z | 2024-09-16T12:21:02.499Z |
5051910 | 5051910 | 20240907190340_25DJN | KR0039 | 2024-09-13T12:14:43.829Z | 2024-09-16T12:21:02.470Z |
5051765 | 5051765 | 20240907183336_YHrPH | KR0039 | 2024-09-13T12:14:32.712Z | 2024-09-16T12:21:01.826Z |
5051725 | 5051725 | 20240907182934_rw0JV | KR0039 | 2024-09-13T12:14:31.510Z | 2024-09-16T12:21:01.667Z |
5051691 | 5051691 | 20240907182442_zrYSJ | KR0039 | 2024-09-13T12:14:29.796Z | 2024-09-16T12:21:01.624Z |
5051596 | 5051596 | 20240907174808_zLQFE | KR0039 | 2024-09-13T12:14:23.832Z | 2024-09-16T12:21:01.358Z |
5051529 | 5051529 | 20240907173958_BsCRO | KR0039 | 2024-09-13T12:14:21.776Z | 2024-09-16T12:21:01.152Z |
5051279 | 5051279 | 20240907171051_CtB2j | KR0039 | 2024-09-13T12:14:08.554Z | 2024-09-16T12:21:00.001Z |
5050874 | 5050874 | 20240907161806_qigoP | KR0039 | 2024-09-13T12:13:50.670Z | 2024-09-16T12:20:58.855Z |
5050437 | 5050437 | 20240907152113_yMEUh | KR0039 | 2024-09-13T12:13:32.027Z | 2024-09-16T12:20:57.681Z |
5050417 | 5050417 | 20240907151948_B3zl6 | KR0039 | 2024-09-13T12:13:30.953Z | 2024-09-16T12:20:57.589Z |
5050187 | 5050187 | 20240907144605_a96df | KR0039 | 2024-09-13T12:13:16.062Z | 2024-09-16T12:20:56.674Z |
5049577 | 5049577 | 20240909111320_v7fXR | KR0039 | 2024-09-13T12:12:18.736Z | 2024-09-17T12:19:10.946Z |
5045684 | 5045684 | 20240908180305_p5JUM | KR0039 | 2024-09-13T12:04:42.147Z | 2024-09-17T12:18:57.019Z |
5045583 | 5045583 | 20240908172622_0973w | KR0039 | 2024-09-13T12:04:23.939Z | 2024-09-17T12:18:56.809Z |
5044924 | 5044924 | 20240908155545_iupY2 | KR0039 | 2024-09-13T12:03:11.779Z | 2024-09-17T12:18:55.433Z |
5044001 | 5044001 | 20240908134831_fi813 | KR0039 | 2024-09-13T12:01:11.080Z | 2024-09-17T12:18:53.171Z |
5043814 | 5043814 | 20240908131513_9N3qv | KR0039 | 2024-09-13T12:00:44.148Z | 2024-09-17T12:18:52.897Z |
5043338 | 5043338 | 20240907143425_luzxA | KR0039 | 2024-09-12T12:17:26.551Z | 2024-09-16T12:20:56.394Z |
5042670 | 5042670 | 20240907122235_Wekko | KR0039 | 2024-09-12T12:17:16.644Z | 2024-09-16T12:20:53.884Z |
5042639 | 5042639 | 20240907121054_G982l | KR0039 | 2024-09-12T12:17:16.426Z | 2024-09-16T12:20:53.827Z |
5017619 | 5017619 | 20240904162510_WWFmu | KR0039 | 2024-09-10T12:09:20.398Z | 2024-09-13T12:19:47.010Z |
5016159 | 5016159 | 20240904133934_v3T39 | KR0039 | 2024-09-10T12:07:31.190Z | 2024-09-13T12:19:45.293Z |
5015973 | 5015973 | 20240904131139_6j3g2 | KR0039 | 2024-09-10T12:07:06.429Z | 2024-09-13T12:19:45.083Z |
5015644 | 5015644 | 20240904120401_oJPvn | KR0039 | 2024-09-10T12:06:34.640Z | 2024-09-13T12:19:44.557Z |
5006978 | 5006978 | 20240903193734_1ePvw | KR0039 | 2024-09-09T12:05:17.104Z | 2024-09-12T12:19:10.993Z |
5006733 | 5006733 | 20240903184330_bXXzx | KR0039 | 2024-09-09T12:04:58.065Z | 2024-09-12T12:19:09.363Z |
5006034 | 5006034 | 20240903164745_8xwjp | KR0039 | 2024-09-09T12:04:17.535Z | 2024-09-12T12:19:07.251Z |
5005338 | 5005338 | 20240903145559_V50so | KR0039 | 2024-09-09T12:03:37.701Z | 2024-09-12T12:19:05.773Z |
5005081 | 5005081 | 20240903135653_sHBV5 | KR0039 | 2024-09-09T12:03:19.024Z | 2024-09-12T12:19:05.221Z |
5004948 | 5004948 | 20240903133640_M6iRK | KR0039 | 2024-09-09T12:03:13.251Z | 2024-09-12T12:19:04.545Z |
5004911 | 5004911 | 20240903132310_Oq56i | KR0039 | 2024-09-09T12:03:10.964Z | 2024-09-12T12:19:04.468Z |
5004866 | 5004866 | 20240903131024_JoXc7 | KR0039 | 2024-09-09T12:03:08.727Z | 2024-09-12T12:19:04.393Z |
5004751 | 5004751 | 20240903122316_4UUZD | KR0039 | 2024-09-09T12:02:58.586Z | 2024-09-12T12:19:03.724Z |
5004391 | 5004391 | 20240903112415_YT0Kv | KR0039 | 2024-09-09T12:02:40.137Z | 2024-09-12T12:19:01.897Z |
5004323 | 5004323 | 20240903111620_Xa4ov | KR0039 | 2024-09-09T12:02:35.629Z | 2024-09-12T12:19:01.645Z |
4996245 | 4996245 | 20240902190406_BaoOi | KR0039 | 2024-09-08T12:04:37.289Z | 2024-09-11T12:20:52.212Z |
4996038 | 4996038 | 20240902183316_RL633 | KR0039 | 2024-09-08T12:04:18.961Z | 2024-09-11T12:20:50.752Z |
4995797 | 4995797 | 20240902175419_tvZdp | KR0039 | 2024-09-08T12:04:04.831Z | 2024-09-11T12:20:48.120Z |
4995726 | 4995726 | 20240902173922_7xh2m | KR0039 | 2024-09-08T12:03:57.657Z | 2024-09-11T12:20:47.599Z |
4995412 | 4995412 | 20240902165119_e3KeL | KR0039 | 2024-09-08T12:03:38.032Z | 2024-09-11T12:20:45.179Z |
4995155 | 4995155 | 20240902162247_gZnLc | KR0039 | 2024-09-08T12:03:18.514Z | 2024-09-11T12:20:42.516Z |
4994155 | 4994155 | 20240902123228_nMdeJ | KR0039 | 2024-09-08T12:02:15.470Z | 2024-09-11T12:20:30.864Z |
4994115 | 4994115 | 20240902121712_2bpdx | KR0039 | 2024-09-08T12:02:12.859Z | 2024-09-11T12:20:30.436Z |
4994086 | 4994086 | 20240902120459_wdJIg | KR0039 | 2024-09-08T12:02:11.200Z | 2024-09-11T12:20:30.132Z |
4986602 | 4986602 | 20240901152905_4WtPz | KR0039 | 2024-09-07T12:04:46.393Z | 2024-09-10T12:19:09.466Z |
4962852 | 4962852 | 20240811192751_wHKg4 | KR0039 | 2024-09-04T12:04:55.578Z | 2024-09-06T12:04:08.568Z |
4962817 | 4962817 | 20240811192455_c7oDa | KR0039 | 2024-09-04T12:04:54.249Z | 2024-09-06T12:04:07.040Z |
4962042 | 4962042 | 20240811183110_nrUPm | KR0039 | 2024-09-04T12:04:13.444Z | 2024-09-06T12:03:25.568Z |
4962026 | 4962026 | 20240811182826_D7JQg | KR0039 | 2024-09-04T12:04:12.331Z | 2024-09-06T12:03:24.603Z |
4962023 | 4962023 | 20240811182752_ObSod | KR0039 | 2024-09-04T12:04:12.157Z | 2024-09-06T12:03:24.478Z |
4961984 | 4961984 | 20240811182210_0OYyw | KR0039 | 2024-09-04T12:04:07.338Z | 2024-09-06T12:03:22.734Z |
4961732 | 4961732 | 20240811175911_2sbOL | KR0039 | 2024-09-04T12:03:52.401Z | 2024-09-06T12:03:11.938Z |
4961481 | 4961481 | 20240811174328_E5y28 | KR0039 | 2024-09-04T12:03:41.830Z | 2024-09-06T12:03:02.330Z |
4961444 | 4961444 | 20240811174120_jzQd1 | KR0039 | 2024-09-04T12:03:39.888Z | 2024-09-06T12:02:59.598Z |
4961022 | 4961022 | 20240811171107_E5P11 | KR0039 | 2024-09-04T12:03:12.353Z | 2024-09-06T12:02:39.875Z |
4960998 | 4960998 | 20240811170831_O688i | KR0039 | 2024-09-04T12:03:10.363Z | 2024-09-06T12:02:38.590Z |
4960928 | 4960928 | 20240811170316_JEGx7 | KR0039 | 2024-09-04T12:03:06.272Z | 2024-09-06T12:02:33.584Z |
4960620 | 4960620 | 20240811163751_52p6F | KR0039 | 2024-09-04T12:02:46.590Z | 2024-09-06T12:02:19.518Z |
4960337 | 4960337 | 20240811161648_pYEEw | KR0039 | 2024-09-04T12:02:26.672Z | 2024-09-06T12:02:04.128Z |
4960284 | 4960284 | 20240811161431_yv3Ry | KR0039 | 2024-09-04T12:02:23.661Z | 2024-09-06T12:02:01.472Z |
4960087 | 4960087 | 20240811155953_qc2fC | KR0039 | 2024-09-04T12:02:10.839Z | 2024-09-06T12:01:51.586Z |
4959952 | 4959952 | 20240811155044_UM09k | KR0039 | 2024-09-04T12:02:03.923Z | 2024-09-06T12:01:44.473Z |
4959919 | 4959919 | 20240811154816_xIgm2 | KR0039 | 2024-09-04T12:02:02.769Z | 2024-09-06T12:01:43.380Z |
4959916 | 4959916 | 20240811154815_bvWv2 | KR0039 | 2024-09-04T12:02:02.612Z | 2024-09-06T12:01:43.241Z |
4959888 | 4959888 | 20240811154521_UQeMA | KR0039 | 2024-09-04T12:02:01.174Z | 2024-09-06T12:01:41.793Z |
4959878 | 4959878 | 20240811154412_CZDIQ | KR0039 | 2024-09-04T12:02:00.869Z | 2024-09-06T12:01:41.499Z |
4959835 | 4959835 | 20240811154055_gjDiz | KR0039 | 2024-09-04T12:01:58.272Z | 2024-09-06T12:01:39.409Z |
4959769 | 4959769 | 20240811153646_noMd4 | KR0039 | 2024-09-04T12:01:54.990Z | 2024-09-06T12:01:36.692Z |
4959716 | 4959716 | 20240811153044_GJGLm | KR0039 | 2024-09-04T12:01:51.109Z | 2024-09-06T12:01:33.894Z |
4959574 | 4959574 | 20240811152007_DRHQI | KR0039 | 2024-09-04T12:01:42.669Z | 2024-09-06T12:01:24.334Z |
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);