participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
796 rows where station_code = "KR001U" 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 |
---|---|---|---|---|---|
5415090 | 5415090 | 20241027130043_dv8Hm | KR001U | 2024-10-30T12:08:56.168Z | 2024-11-05T14:27:03.274Z |
4495926 | 4495926 | 20240624130654_dDvcA | KR001U | 2024-06-25T12:00:19.684Z | 2024-07-03T12:13:04.424Z |
4495910 | 4495910 | 20240624121923_VeTJG | KR001U | 2024-06-25T12:00:17.687Z | 2024-07-03T12:13:04.236Z |
4491630 | 4491630 | 20240620185906_jmpC6 | KR001U | 2024-06-22T12:04:30.948Z | 2024-06-29T12:13:30.329Z |
4491522 | 4491522 | 20240620183853_rC0gk | KR001U | 2024-06-22T12:04:23.125Z | 2024-06-29T12:13:29.491Z |
4491251 | 4491251 | 20240620175449_dp4ei | KR001U | 2024-06-22T12:03:54.918Z | 2024-06-29T12:13:28.284Z |
4479844 | 4479844 | 20240616184401_3LbsF | KR001U | 2024-06-19T12:09:53.714Z | 2024-06-24T12:11:47.787Z |
4477933 | 4477933 | 20240617185912_VRCAk | KR001U | 2024-06-19T12:06:08.260Z | 2024-06-26T12:14:37.561Z |
4477406 | 4477406 | 20240617174839_ihWWC | KR001U | 2024-06-19T12:05:20.307Z | 2024-06-26T12:14:33.339Z |
4477327 | 4477327 | 20240617173406_NdLQV | KR001U | 2024-06-19T12:05:14.526Z | 2024-06-26T12:14:32.514Z |
4477181 | 4477181 | 20240617170829_HLkwx | KR001U | 2024-06-19T12:05:05.358Z | 2024-06-26T12:14:31.526Z |
4477053 | 4477053 | 20240617165354_F8Hqn | KR001U | 2024-06-19T12:04:45.930Z | 2024-06-26T12:14:29.778Z |
4477034 | 4477034 | 20240617164948_lbPce | KR001U | 2024-06-19T12:04:45.179Z | 2024-06-26T12:14:29.677Z |
4476951 | 4476951 | 20240617163152_Z9luv | KR001U | 2024-06-19T12:04:38.815Z | 2024-06-26T12:14:28.612Z |
4474081 | 4474081 | 20240616171559_3egVO | KR001U | 2024-06-18T12:04:48.464Z | 2024-06-24T12:11:38.275Z |
4474042 | 4474042 | 20240616170728_o1fZc | KR001U | 2024-06-18T12:04:45.902Z | 2024-06-24T12:11:37.847Z |
4473915 | 4473915 | 20240616164147_aGXo1 | KR001U | 2024-06-18T12:04:38.401Z | 2024-06-24T12:11:35.060Z |
4463098 | 4463098 | 20240613183851_FlPM8 | KR001U | 2024-06-15T12:09:26.388Z | 2024-06-21T12:11:47.890Z |
4463068 | 4463068 | 20240613183456_H4QZb | KR001U | 2024-06-15T12:09:24.516Z | 2024-06-21T12:11:47.872Z |
4462497 | 4462497 | 20240613170312_ch9vX | KR001U | 2024-06-15T12:08:44.650Z | 2024-06-21T12:11:47.000Z |
4462249 | 4462249 | 20240613162412_caRhG | KR001U | 2024-06-15T12:08:20.188Z | 2024-06-21T12:11:46.502Z |
4461833 | 4461833 | 20240613143123_3ttgA | KR001U | 2024-06-15T12:07:42.483Z | 2024-06-21T12:11:45.456Z |
4461512 | 4461512 | 20240613120207_k2jj0 | KR001U | 2024-06-15T12:07:04.415Z | 2024-06-21T12:11:44.322Z |
4458380 | 4458380 | 20240612132739_PMnRE | KR001U | 2024-06-14T12:04:50.319Z | 2024-06-20T12:12:03.599Z |
4454996 | 4454996 | 20240611184550_D4dkv | KR001U | 2024-06-13T12:06:22.297Z | 2024-06-19T12:13:49.201Z |
4454047 | 4454047 | 20240611165241_xPOqk | KR001U | 2024-06-13T12:06:01.681Z | 2024-06-19T12:13:47.416Z |
4447947 | 4447947 | 20240610162231_w2Od0 | KR001U | 2024-06-12T12:06:00.107Z | 2024-06-18T12:11:15.896Z |
4415415 | 4415415 | 20240604175718_WDYh3 | KR001U | 2024-06-06T12:04:38.762Z | 2024-06-13T12:08:29.934Z |
4415408 | 4415408 | 20240604175624_SJyxO | KR001U | 2024-06-06T12:04:38.534Z | 2024-06-13T12:08:29.933Z |
4415289 | 4415289 | 20240604174320_i6MJb | KR001U | 2024-06-06T12:04:31.830Z | 2024-06-13T12:08:29.826Z |
4415279 | 4415279 | 20240604174225_SO9EO | KR001U | 2024-06-06T12:04:31.370Z | 2024-06-13T12:08:29.801Z |
4414832 | 4414832 | 20240604163553_dYZl8 | KR001U | 2024-06-06T12:03:47.188Z | 2024-06-13T12:08:29.502Z |
4414538 | 4414538 | 20240604160434_3C1X8 | KR001U | 2024-06-06T12:03:30.422Z | 2024-06-13T12:08:29.281Z |
4414199 | 4414199 | 20240604153212_OyBif | KR001U | 2024-06-06T12:02:52.801Z | 2024-06-13T12:08:29.042Z |
4414151 | 4414151 | 20240604152827_QznKb | KR001U | 2024-06-06T12:02:49.958Z | 2024-06-13T12:08:29.028Z |
4414146 | 4414146 | 20240604152824_ICOO0 | KR001U | 2024-06-06T12:02:49.664Z | 2024-06-13T12:08:29.022Z |
4413942 | 4413942 | 20240604145959_Tw8qB | KR001U | 2024-06-06T12:02:34.554Z | 2024-06-13T12:08:28.877Z |
4412892 | 4412892 | 20240604123806_a4gp3 | KR001U | 2024-06-06T12:00:48.550Z | 2024-06-13T12:08:28.197Z |
4412628 | 4412628 | 20240604115803_Ert8t | KR001U | 2024-06-06T12:00:22.652Z | 2024-06-13T12:08:28.037Z |
4409227 | 4409227 | 20240603142944_3kOci | KR001U | 2024-06-05T12:03:05.658Z | 2024-06-12T12:10:32.743Z |
4409125 | 4409125 | 20240603140929_DK3Gp | KR001U | 2024-06-05T12:02:48.555Z | 2024-06-12T12:10:32.338Z |
4404489 | 4404489 | 20240602135733_fv9qh | KR001U | 2024-06-04T12:02:35.406Z | 2024-06-11T12:13:29.110Z |
4404471 | 4404471 | 20240602135242_CUhqm | KR001U | 2024-06-04T12:02:33.778Z | 2024-06-11T12:13:29.017Z |
4399436 | 4399436 | 20240601152652_tTLsr | KR001U | 2024-06-03T12:03:42.017Z | 2024-06-10T12:06:44.980Z |
4398857 | 4398857 | 20240601122358_xYkys | KR001U | 2024-06-03T12:02:21.612Z | 2024-06-10T12:06:44.526Z |
4392723 | 4392723 | 20240529161314_oNxVa | KR001U | 2024-05-31T12:07:30.467Z | 2024-06-07T12:15:58.039Z |
4385325 | 4385325 | 20240528151120_nLHTL | KR001U | 2024-05-29T12:03:16.676Z | 2024-06-06T12:14:24.546Z |
4385244 | 4385244 | 20240528144212_qPfL6 | KR001U | 2024-05-29T12:03:04.567Z | 2024-06-06T12:14:24.427Z |
4384950 | 4384950 | 20240528130447_gCATA | KR001U | 2024-05-29T12:02:40.107Z | 2024-06-06T12:14:23.780Z |
4384933 | 4384933 | 20240528130039_EuzYh | KR001U | 2024-05-29T12:02:37.695Z | 2024-06-06T12:14:23.778Z |
4384880 | 4384880 | 20240528123929_EMTtH | KR001U | 2024-05-29T12:02:29.838Z | 2024-06-06T12:14:23.703Z |
4384832 | 4384832 | 20240528121125_ZSPq7 | KR001U | 2024-05-29T12:02:21.471Z | 2024-06-06T12:14:23.597Z |
4369333 | 4369333 | 20240518144701_nhvbR | KR001U | 2024-05-26T12:08:09.809Z | 2024-05-26T12:09:53.227Z |
4362476 | 4362476 | 20240516121114_ip2Tz | KR001U | 2024-05-25T12:05:47.141Z | 2024-05-25T12:05:47.141Z |
4344293 | 4344293 | 20240510144748_9WFBd | KR001U | 2024-05-20T12:01:41.014Z | 2024-05-22T12:09:39.192Z |
4340366 | 4340366 | 20240509183332_A6r2n | KR001U | 2024-05-19T12:06:50.684Z | 2024-05-21T12:09:12.738Z |
4337782 | 4337782 | 20240509161553_qdrfj | KR001U | 2024-05-19T12:02:52.398Z | 2024-05-21T12:07:51.158Z |
4337627 | 4337627 | 20240509161051_Pv228 | KR001U | 2024-05-19T12:02:39.570Z | 2024-05-21T12:07:47.601Z |
4332422 | 4332422 | 20240509150545_c5bNy | KR001U | 2024-05-18T12:04:05.783Z | 2024-05-21T12:07:12.095Z |
4329762 | 4329762 | 20240508191639_4Pzu1 | KR001U | 2024-05-17T12:09:00.257Z | 2024-05-19T12:14:26.932Z |
4329750 | 4329750 | 20240508191615_Ogb3J | KR001U | 2024-05-17T12:09:00.047Z | 2024-05-19T12:14:26.708Z |
4329723 | 4329723 | 20240508191200_k7AEd | KR001U | 2024-05-17T12:08:58.679Z | 2024-05-19T12:14:26.333Z |
4329634 | 4329634 | 20240508190317_Q1qyq | KR001U | 2024-05-17T12:08:54.321Z | 2024-05-19T12:14:25.015Z |
4329502 | 4329502 | 20240508184834_Ju4UD | KR001U | 2024-05-17T12:08:47.498Z | 2024-05-19T12:14:23.906Z |
4329288 | 4329288 | 20240508182728_359Kd | KR001U | 2024-05-17T12:08:34.212Z | 2024-05-19T12:14:18.157Z |
4329242 | 4329242 | 20240508182308_3Dg3w | KR001U | 2024-05-17T12:08:31.401Z | 2024-05-19T12:14:16.704Z |
4327072 | 4327072 | 20240508170258_CRTK3 | KR001U | 2024-05-17T12:06:37.024Z | 2024-05-19T12:13:35.032Z |
4324907 | 4324907 | 20240508144935_f2njg | KR001U | 2024-05-17T12:03:24.239Z | 2024-05-19T12:12:57.087Z |
4324486 | 4324486 | 20240508135004_K6nEu | KR001U | 2024-05-17T12:02:36.042Z | 2024-05-19T12:12:50.152Z |
4324310 | 4324310 | 20240508132945_WSriM | KR001U | 2024-05-17T12:02:13.131Z | 2024-05-19T12:12:47.550Z |
4283392 | 4283392 | 20240503191944_SfCU0 | KR001U | 2024-05-06T12:11:35.839Z | 2024-05-12T12:19:00.536Z |
4282474 | 4282474 | 20240503180149_Q5z26 | KR001U | 2024-05-06T12:10:32.222Z | 2024-05-12T12:18:30.247Z |
4279571 | 4279571 | 20240503161307_UkkTw | KR001U | 2024-05-06T12:07:09.195Z | 2024-05-12T12:17:53.326Z |
4279137 | 4279137 | 20240503155247_STHVg | KR001U | 2024-05-06T12:06:32.429Z | 2024-05-12T12:17:41.346Z |
4275037 | 4275037 | 20240502190532_SrA1A | KR001U | 2024-05-05T12:10:08.777Z | 2024-05-11T12:27:52.291Z |
4274929 | 4274929 | 20240502184610_tP4hM | KR001U | 2024-05-05T12:10:03.367Z | 2024-05-11T12:27:48.954Z |
4274210 | 4274210 | 20240502174150_l9f3l | KR001U | 2024-05-05T12:09:00.153Z | 2024-05-11T12:27:35.074Z |
4274046 | 4274046 | 20240502172739_2qK2H | KR001U | 2024-05-05T12:08:43.536Z | 2024-05-11T12:27:31.460Z |
4271231 | 4271231 | 20240502162001_klWDO | KR001U | 2024-05-04T12:10:23.310Z | 2024-05-11T12:27:06.693Z |
4270031 | 4270031 | 20240502144428_a7QIv | KR001U | 2024-05-04T12:08:32.639Z | 2024-05-11T12:26:35.467Z |
4266216 | 4266216 | 20240501191955_YKHao | KR001U | 2024-05-03T12:07:16.584Z | 2024-05-10T12:23:35.083Z |
4266151 | 4266151 | 20240501185602_Tn5cg | KR001U | 2024-05-03T12:07:11.189Z | 2024-05-10T12:23:34.373Z |
4266122 | 4266122 | 20240501185050_QjaTX | KR001U | 2024-05-03T12:07:10.110Z | 2024-05-10T12:23:34.134Z |
4265777 | 4265777 | 20240501175011_bRvlQ | KR001U | 2024-05-03T12:06:52.189Z | 2024-05-10T12:23:30.463Z |
4265085 | 4265085 | 20240501162512_0wCJX | KR001U | 2024-05-03T12:05:37.410Z | 2024-05-10T12:23:12.412Z |
4264825 | 4264825 | 20240501152952_h6Mr3 | KR001U | 2024-05-03T12:05:01.639Z | 2024-05-10T12:23:06.495Z |
4264778 | 4264778 | 20240501152255_YXPQT | KR001U | 2024-05-03T12:04:57.148Z | 2024-05-10T12:23:05.821Z |
4264724 | 4264724 | 20240501150850_e4GI3 | KR001U | 2024-05-03T12:04:48.886Z | 2024-05-10T12:23:04.846Z |
4264703 | 4264703 | 20240501150558_Uu8jR | KR001U | 2024-05-03T12:04:47.024Z | 2024-05-10T12:23:04.473Z |
4264567 | 4264567 | 20240501144012_TXw3L | KR001U | 2024-05-03T12:04:33.793Z | 2024-05-10T12:23:01.415Z |
4246270 | 4246270 | 20240427155752_W1Y3F | KR001U | 2024-04-29T12:06:50.364Z | 2024-05-06T12:21:01.501Z |
4239196 | 4239196 | 20240425110547_mKLPS | KR001U | 2024-04-27T12:05:33.136Z | 2024-05-04T12:21:19.356Z |
4212015 | 4212015 | 20240417194811_xMTxP | KR001U | 2024-04-19T12:09:21.006Z | 2024-04-25T12:22:37.216Z |
4211670 | 4211670 | 20240417184347_AVKED | KR001U | 2024-04-19T12:09:08.652Z | 2024-04-25T12:22:33.882Z |
4211636 | 4211636 | 20240417183803_OAOAa | KR001U | 2024-04-19T12:09:07.841Z | 2024-04-25T12:22:33.631Z |
4205302 | 4205302 | 20240416174336_GEr29 | KR001U | 2024-04-18T12:12:13.261Z | 2024-04-24T12:24:55.581Z |
4204225 | 4204225 | 20240416151502_Wrpri | KR001U | 2024-04-18T12:10:33.025Z | 2024-04-24T12:24:43.778Z |
4188361 | 4188361 | 20240413181928_JTMSV | KR001U | 2024-04-15T12:12:31.681Z | 2024-04-21T12:22:01.415Z |
4184209 | 4184209 | 20240413194950_arMW4 | KR001U | 2024-04-15T12:00:57.189Z | 2024-04-22T12:22:03.423Z |
4183767 | 4183767 | 20240413163450_5RbNd | KR001U | 2024-04-14T12:12:59.148Z | 2024-04-21T12:22:00.016Z |
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);