participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,974 rows where station_code = "KR0004" 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 |
---|---|---|---|---|---|
5438570 | 5438570 | 20241030173707_JuzN4 | KR0004 | 2024-11-01T12:11:57.273Z | 2024-11-03T14:22:43.347Z |
5437119 | 5437119 | 20241030142956_cfO5O | KR0004 | 2024-11-01T12:08:58.359Z | 2024-11-03T14:22:38.625Z |
5436280 | 5436280 | 20241030124631_C0uFN | KR0004 | 2024-11-01T12:07:13.490Z | 2024-11-03T14:22:36.117Z |
5436177 | 5436177 | 20241030123525_vX235 | KR0004 | 2024-11-01T12:07:02.775Z | 2024-11-03T14:22:35.653Z |
5433695 | 5433695 | 20241029205524_Jfrs2 | KR0004 | 2024-10-31T12:22:28.061Z | 2024-11-03T14:23:58.567Z |
5433590 | 5433590 | 20241029202953_k1KK3 | KR0004 | 2024-10-31T12:22:23.411Z | 2024-11-03T14:23:56.346Z |
5426507 | 5426507 | 20241029195900_gppwY | KR0004 | 2024-10-31T12:10:09.703Z | 2024-11-03T14:23:54.987Z |
5426435 | 5426435 | 20241029194745_gyr9H | KR0004 | 2024-10-31T12:10:00.405Z | 2024-11-03T14:23:54.468Z |
5426357 | 5426357 | 20241029193928_muPiG | KR0004 | 2024-10-31T12:09:53.609Z | 2024-11-03T14:23:53.836Z |
5426355 | 5426355 | 20241029193921_ok9P2 | KR0004 | 2024-10-31T12:09:53.321Z | 2024-11-03T14:23:53.833Z |
5426302 | 5426302 | 20241029192840_qYprx | KR0004 | 2024-10-31T12:09:48.223Z | 2024-11-03T14:23:53.599Z |
5426255 | 5426255 | 20241029191744_FNh2q | KR0004 | 2024-10-31T12:09:44.153Z | 2024-11-03T14:23:53.129Z |
5426246 | 5426246 | 20241029191713_EY4aO | KR0004 | 2024-10-31T12:09:43.267Z | 2024-11-03T14:23:53.096Z |
5426228 | 5426228 | 20241029191547_xCvSg | KR0004 | 2024-10-31T12:09:41.672Z | 2024-11-03T14:23:52.555Z |
5426199 | 5426199 | 20241029191033_8wTnm | KR0004 | 2024-10-31T12:09:38.890Z | 2024-11-03T14:23:52.335Z |
5426086 | 5426086 | 20241029184012_0ZdMH | KR0004 | 2024-10-31T12:09:15.720Z | 2024-11-03T14:23:49.818Z |
5426083 | 5426083 | 20241029183945_J3Ow4 | KR0004 | 2024-10-31T12:09:15.227Z | 2024-11-03T14:23:49.724Z |
5425947 | 5425947 | 20241029181847_thfEk | KR0004 | 2024-10-31T12:09:00.219Z | 2024-11-03T14:23:48.607Z |
5425934 | 5425934 | 20241029181815_Q5hfC | KR0004 | 2024-10-31T12:08:59.202Z | 2024-11-03T14:23:48.561Z |
5425928 | 5425928 | 20241029181753_uovny | KR0004 | 2024-10-31T12:08:58.831Z | 2024-11-03T14:23:48.465Z |
5425844 | 5425844 | 20241029180307_6gY2W | KR0004 | 2024-10-31T12:08:50.756Z | 2024-11-03T14:23:46.861Z |
5425822 | 5425822 | 20241029180151_sUnMe | KR0004 | 2024-10-31T12:08:49.402Z | 2024-11-03T14:23:46.765Z |
5425778 | 5425778 | 20241029175447_Yrj3c | KR0004 | 2024-10-31T12:08:38.195Z | 2024-11-03T14:23:46.322Z |
5425597 | 5425597 | 20241029172039_M1ZIb | KR0004 | 2024-10-31T12:08:10.616Z | 2024-11-03T14:23:45.415Z |
5425533 | 5425533 | 20241029170711_QA3xV | KR0004 | 2024-10-31T12:08:03.662Z | 2024-11-03T14:23:44.613Z |
5425531 | 5425531 | 20241029170707_Y92v9 | KR0004 | 2024-10-31T12:08:03.291Z | 2024-11-03T14:23:44.604Z |
5425510 | 5425510 | 20241029170411_uW0WV | KR0004 | 2024-10-31T12:08:00.916Z | 2024-11-03T14:23:44.226Z |
5425417 | 5425417 | 20241029164235_lBBXt | KR0004 | 2024-10-31T12:07:37.172Z | 2024-11-03T14:23:42.632Z |
5425242 | 5425242 | 20241029161346_a80Ck | KR0004 | 2024-10-31T12:07:20.145Z | 2024-11-03T14:23:41.485Z |
5425191 | 5425191 | 20241029160822_CR4bO | KR0004 | 2024-10-31T12:07:08.938Z | 2024-11-03T14:23:41.159Z |
5425124 | 5425124 | 20241029155656_mqVkW | KR0004 | 2024-10-31T12:06:54.044Z | 2024-11-03T14:23:40.901Z |
5425119 | 5425119 | 20241029155625_WAmPD | KR0004 | 2024-10-31T12:06:53.493Z | 2024-11-03T14:23:40.898Z |
5425075 | 5425075 | 20241029154914_R7R21 | KR0004 | 2024-10-31T12:06:46.838Z | 2024-11-03T14:23:40.750Z |
5424916 | 5424916 | 20241029153230_F3Hye | KR0004 | 2024-10-31T12:06:29.707Z | 2024-11-03T14:23:39.772Z |
5424838 | 5424838 | 20241029152059_CyFpa | KR0004 | 2024-10-31T12:06:08.476Z | 2024-11-03T14:23:39.467Z |
5424686 | 5424686 | 20241029150042_KGmRV | KR0004 | 2024-10-31T12:05:51.117Z | 2024-11-03T14:23:38.554Z |
5424637 | 5424637 | 20241029145435_wfUj3 | KR0004 | 2024-10-31T12:05:38.917Z | 2024-11-03T14:23:38.328Z |
5424542 | 5424542 | 20241029144234_v4aDJ | KR0004 | 2024-10-31T12:05:20.763Z | 2024-11-03T14:23:38.052Z |
5424530 | 5424530 | 20241029144041_QVqCg | KR0004 | 2024-10-31T12:05:18.971Z | 2024-11-03T14:23:38.013Z |
5424521 | 5424521 | 20241029144022_0a3x0 | KR0004 | 2024-10-31T12:05:18.190Z | 2024-11-03T14:23:37.997Z |
5424419 | 5424419 | 20241029142044_HeMfk | KR0004 | 2024-10-31T12:05:01.479Z | 2024-11-03T14:23:36.596Z |
5424365 | 5424365 | 20241029140817_BYnAP | KR0004 | 2024-10-31T12:04:47.407Z | 2024-11-03T14:23:36.200Z |
5424245 | 5424245 | 20241029134631_0fF3g | KR0004 | 2024-10-31T12:04:23.382Z | 2024-11-03T14:23:35.671Z |
5424176 | 5424176 | 20241029133206_HZOsX | KR0004 | 2024-10-31T12:04:06.516Z | 2024-11-03T14:23:35.011Z |
5424086 | 5424086 | 20241029130244_PJdTV | KR0004 | 2024-10-31T12:03:45.461Z | 2024-11-03T14:23:34.226Z |
5423967 | 5423967 | 20241029123024_UUST2 | KR0004 | 2024-10-31T12:03:20.988Z | 2024-11-03T14:23:33.429Z |
5423921 | 5423921 | 20241029122407_wWVTv | KR0004 | 2024-10-31T12:03:13.645Z | 2024-11-03T14:23:32.975Z |
5423913 | 5423913 | 20241029122350_PfDyh | KR0004 | 2024-10-31T12:03:12.397Z | 2024-11-03T14:23:32.932Z |
5423803 | 5423803 | 20241029120400_IDBYu | KR0004 | 2024-10-31T12:02:51.224Z | 2024-11-03T14:23:31.813Z |
5423600 | 5423600 | 20241029110813_nURpf | KR0004 | 2024-10-31T12:02:07.148Z | 2024-11-03T14:23:28.843Z |
5423589 | 5423589 | 20241029110615_e52Cq | KR0004 | 2024-10-31T12:02:04.913Z | 2024-11-03T14:23:28.800Z |
5423506 | 5423506 | 20241029104127_Y6vgJ | KR0004 | 2024-10-31T12:01:40.717Z | 2024-11-03T14:23:28.188Z |
5418336 | 5418336 | 20241027202624_3B3gS | KR0004 | 2024-10-30T12:15:31.341Z | 2024-11-03T14:25:50.905Z |
5418027 | 5418027 | 20241027194205_3Ke2l | KR0004 | 2024-10-30T12:14:45.748Z | 2024-11-03T14:25:48.491Z |
5418016 | 5418016 | 20241027194058_ykOsS | KR0004 | 2024-10-30T12:14:45.186Z | 2024-11-03T14:25:48.471Z |
5417990 | 5417990 | 20241027193749_dcHIK | KR0004 | 2024-10-30T12:14:42.969Z | 2024-11-03T14:25:48.309Z |
5417988 | 5417988 | 20241027193742_6VgCz | KR0004 | 2024-10-30T12:14:42.790Z | 2024-11-03T14:25:48.308Z |
5417564 | 5417564 | 20241027184736_MInZ5 | KR0004 | 2024-10-30T12:13:52.107Z | 2024-11-03T14:25:45.485Z |
5417551 | 5417551 | 20241027184624_DVLs4 | KR0004 | 2024-10-30T12:13:50.314Z | 2024-11-03T14:25:45.472Z |
5417510 | 5417510 | 20241027183944_irW3z | KR0004 | 2024-10-30T12:13:45.658Z | 2024-11-03T14:25:45.361Z |
5417504 | 5417504 | 20241027183935_ImRu3 | KR0004 | 2024-10-30T12:13:45.092Z | 2024-11-03T14:25:45.291Z |
5417226 | 5417226 | 20241027175852_DbYS6 | KR0004 | 2024-10-30T12:13:23.458Z | 2024-11-03T14:25:44.371Z |
5417192 | 5417192 | 20241027175433_umveZ | KR0004 | 2024-10-30T12:13:19.488Z | 2024-11-03T14:25:44.328Z |
5417114 | 5417114 | 20241027174900_jblwa | KR0004 | 2024-10-30T12:12:59.120Z | 2024-11-03T14:25:44.153Z |
5417081 | 5417081 | 20241027174421_0XlYp | KR0004 | 2024-10-30T12:12:53.309Z | 2024-11-03T14:25:44.120Z |
5417012 | 5417012 | 20241027173454_WxZCc | KR0004 | 2024-10-30T12:12:43.964Z | 2024-11-03T14:25:43.819Z |
5416978 | 5416978 | 20241027173133_FwOMs | KR0004 | 2024-10-30T12:12:40.765Z | 2024-11-03T14:25:43.767Z |
5416976 | 5416976 | 20241027173130_UUwYC | KR0004 | 2024-10-30T12:12:40.578Z | 2024-11-03T14:25:43.758Z |
5416945 | 5416945 | 20241027172637_LNENr | KR0004 | 2024-10-30T12:12:37.881Z | 2024-11-03T14:25:43.623Z |
5416896 | 5416896 | 20241027171836_q3WyY | KR0004 | 2024-10-30T12:12:33.832Z | 2024-11-03T14:25:43.482Z |
5416809 | 5416809 | 20241027170005_POTGS | KR0004 | 2024-10-30T12:12:26.845Z | 2024-11-03T14:25:43.199Z |
5416779 | 5416779 | 20241027165402_qEiDW | KR0004 | 2024-10-30T12:12:24.208Z | 2024-11-03T14:25:43.094Z |
5400593 | 5400593 | 20241023152245_6MyYx | KR0004 | 2024-10-28T12:23:49.430Z | 2024-11-01T12:26:47.033Z |
5394546 | 5394546 | 20241025204921_SrBtV | KR0004 | 2024-10-28T12:14:53.857Z | 2024-11-03T14:27:21.552Z |
5394522 | 5394522 | 20241025204525_Qi992 | KR0004 | 2024-10-28T12:14:50.238Z | 2024-11-03T14:27:21.451Z |
5394514 | 5394514 | 20241025204339_iJNw0 | KR0004 | 2024-10-28T12:14:49.915Z | 2024-11-03T14:27:21.448Z |
5394450 | 5394450 | 20241025203732_q2fHA | KR0004 | 2024-10-28T12:14:42.269Z | 2024-11-03T14:27:21.255Z |
5394436 | 5394436 | 20241025203508_uD42F | KR0004 | 2024-10-28T12:14:40.248Z | 2024-11-03T14:27:21.213Z |
5394432 | 5394432 | 20241025203441_W3fV3 | KR0004 | 2024-10-28T12:14:39.119Z | 2024-11-03T14:27:21.195Z |
5394228 | 5394228 | 20241025200023_xP7B5 | KR0004 | 2024-10-28T12:14:14.204Z | 2024-11-03T14:27:20.412Z |
5394201 | 5394201 | 20241025195209_kM3Dz | KR0004 | 2024-10-28T12:14:10.437Z | 2024-11-03T14:27:20.282Z |
5394176 | 5394176 | 20241025194740_3BPZl | KR0004 | 2024-10-28T12:14:08.853Z | 2024-11-03T14:27:20.230Z |
5394150 | 5394150 | 20241025194220_qIq2K | KR0004 | 2024-10-28T12:14:06.995Z | 2024-11-03T14:27:20.065Z |
5394108 | 5394108 | 20241025193610_gxjeW | KR0004 | 2024-10-28T12:14:03.950Z | 2024-11-03T14:27:19.938Z |
5394090 | 5394090 | 20241025193519_telNl | KR0004 | 2024-10-28T12:14:03.389Z | 2024-11-03T14:27:19.860Z |
5394073 | 5394073 | 20241025193304_GQ3zi | KR0004 | 2024-10-28T12:14:02.025Z | 2024-11-03T14:27:19.809Z |
5394055 | 5394055 | 20241025193046_i1l0O | KR0004 | 2024-10-28T12:14:01.452Z | 2024-11-03T14:27:19.769Z |
5394021 | 5394021 | 20241025192538_miW29 | KR0004 | 2024-10-28T12:13:59.130Z | 2024-11-03T14:27:19.607Z |
5394019 | 5394019 | 20241025192518_S48dt | KR0004 | 2024-10-28T12:13:58.942Z | 2024-11-03T14:27:19.603Z |
5393992 | 5393992 | 20241025192247_XmQ0D | KR0004 | 2024-10-28T12:13:57.484Z | 2024-11-03T14:27:19.508Z |
5393933 | 5393933 | 20241025191624_QZcGp | KR0004 | 2024-10-28T12:13:53.801Z | 2024-11-03T14:27:19.092Z |
5393911 | 5393911 | 20241025191035_7vVOc | KR0004 | 2024-10-28T12:13:52.297Z | 2024-11-03T14:27:19.008Z |
5393853 | 5393853 | 20241025185832_T1OLx | KR0004 | 2024-10-28T12:13:40.371Z | 2024-11-03T14:27:18.669Z |
5393833 | 5393833 | 20241025185508_tw2YI | KR0004 | 2024-10-28T12:13:34.464Z | 2024-11-03T14:27:18.623Z |
5393824 | 5393824 | 20241025185255_myAVH | KR0004 | 2024-10-28T12:13:32.320Z | 2024-11-03T14:27:18.507Z |
5393813 | 5393813 | 20241025184854_NgxNV | KR0004 | 2024-10-28T12:13:26.917Z | 2024-11-03T14:27:18.405Z |
5393803 | 5393803 | 20241025184653_v4jFC | KR0004 | 2024-10-28T12:13:24.408Z | 2024-11-03T14:27:18.379Z |
5393745 | 5393745 | 20241025183741_1kbzU | KR0004 | 2024-10-28T12:13:11.233Z | 2024-11-03T14:27:17.874Z |
5393735 | 5393735 | 20241025183643_MX2kt | KR0004 | 2024-10-28T12:13:09.915Z | 2024-11-03T14:27:17.853Z |
5393485 | 5393485 | 20241025175035_8Ddhe | KR0004 | 2024-10-28T12:12:39.309Z | 2024-11-03T14:27:15.623Z |
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);