participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,799 rows where station_code = "KR0024" 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 |
---|---|---|---|---|---|
6120395 | 6120395 | 20250219180319_cIuB2 | KR0024 | 2025-02-20T14:21:22.268Z | 2025-02-20T14:21:37.439Z |
6120317 | 6120317 | 20250219174753_FVd1g | KR0024 | 2025-02-20T14:21:08.659Z | 2025-02-20T14:21:37.422Z |
6120234 | 6120234 | 20250219172444_7RMsv | KR0024 | 2025-02-20T14:21:01.074Z | 2025-02-20T14:21:37.404Z |
6120198 | 6120198 | 20250219170731_h8H2l | KR0024 | 2025-02-20T14:20:56.454Z | 2025-02-20T14:21:37.394Z |
6119979 | 6119979 | 20250219162818_jcHup | KR0024 | 2025-02-20T14:20:21.027Z | 2025-02-20T14:21:37.351Z |
6119628 | 6119628 | 20250219154034_WPSSi | KR0024 | 2025-02-20T14:19:28.061Z | 2025-02-20T14:21:37.281Z |
6119578 | 6119578 | 20250219153111_XE3xH | KR0024 | 2025-02-20T14:19:21.426Z | 2025-02-20T14:21:37.269Z |
6119470 | 6119470 | 20250219150218_I1i8E | KR0024 | 2025-02-20T14:19:07.061Z | 2025-02-20T14:21:37.239Z |
6119436 | 6119436 | 20250219145704_6CPyr | KR0024 | 2025-02-20T14:18:57.833Z | 2025-02-20T14:21:37.233Z |
6119285 | 6119285 | 20250219143040_LRKds | KR0024 | 2025-02-20T14:18:30.173Z | 2025-02-20T14:21:37.128Z |
6118037 | 6118037 | 20250219104036_4iePb | KR0024 | 2025-02-20T14:14:39.445Z | 2025-02-20T14:21:36.856Z |
6115018 | 6115018 | 20250219204907_dVsBG | KR0024 | 2025-02-20T14:02:19.659Z | 2025-02-20T14:02:19.659Z |
6114963 | 6114963 | 20250219203424_GcQ4a | KR0024 | 2025-02-20T14:02:09.923Z | 2025-02-20T14:02:09.923Z |
6114951 | 6114951 | 20250219203121_87Zlj | KR0024 | 2025-02-20T14:02:07.791Z | 2025-02-20T14:02:07.791Z |
6114902 | 6114902 | 20250219202419_rshkH | KR0024 | 2025-02-20T14:02:02.373Z | 2025-02-20T14:02:02.373Z |
6114865 | 6114865 | 20250219201340_2GgIo | KR0024 | 2025-02-20T14:01:50.191Z | 2025-02-20T14:01:50.191Z |
6114712 | 6114712 | 20250219192207_fq9CD | KR0024 | 2025-02-20T14:01:08.653Z | 2025-02-20T14:01:08.653Z |
6114366 | 6114366 | 20250217140539_L4aKD | KR0024 | 2025-02-19T14:19:52.777Z | 2025-02-20T14:32:46.367Z |
6114308 | 6114308 | 20250218181505_znsKC | KR0024 | 2025-02-19T14:15:06.297Z | 2025-02-20T14:29:18.424Z |
6114261 | 6114261 | 20250218175851_J8mn3 | KR0024 | 2025-02-19T14:14:52.759Z | 2025-02-20T14:29:10.004Z |
6114029 | 6114029 | 20250218164128_xblZF | KR0024 | 2025-02-19T14:14:21.666Z | 2025-02-20T14:28:50.919Z |
6113497 | 6113497 | 20250218145408_gh5Po | KR0024 | 2025-02-19T14:13:07.490Z | 2025-02-20T14:28:08.904Z |
6113402 | 6113402 | 20250218143938_GyLtl | KR0024 | 2025-02-19T14:12:56.955Z | 2025-02-20T14:28:02.133Z |
6113361 | 6113361 | 20250218142826_Fao55 | KR0024 | 2025-02-19T14:12:52.539Z | 2025-02-20T14:27:58.503Z |
6110252 | 6110252 | 20250218210558_O4Vjh | KR0024 | 2025-02-19T14:01:17.956Z | 2025-02-20T14:21:33.589Z |
6109991 | 6109991 | 20250218193450_fJrE9 | KR0024 | 2025-02-19T14:00:48.429Z | 2025-02-20T14:21:33.152Z |
6109937 | 6109937 | 20250218190237_IXSOy | KR0024 | 2025-02-19T14:00:40.359Z | 2025-02-20T14:21:33.020Z |
6109903 | 6109903 | 20250218184302_dPCvX | KR0024 | 2025-02-19T14:00:29.084Z | 2025-02-20T14:21:32.803Z |
6109427 | 6109427 | 20250217151411_1K6cS | KR0024 | 2025-02-18T14:10:32.843Z | 2025-02-20T14:32:59.280Z |
6109348 | 6109348 | 20250217143444_BOOqp | KR0024 | 2025-02-18T14:10:20.129Z | 2025-02-20T14:32:51.964Z |
6109221 | 6109221 | 20250217131137_Wczbi | KR0024 | 2025-02-18T14:09:45.269Z | 2025-02-20T14:32:37.124Z |
6107262 | 6107262 | 20250217205904_1buld | KR0024 | 2025-02-18T14:00:51.996Z | 2025-02-20T14:22:42.526Z |
6107157 | 6107157 | 20250217202336_DFb9h | KR0024 | 2025-02-18T14:00:35.500Z | 2025-02-20T14:22:25.910Z |
6107085 | 6107085 | 20250217191205_DeU7E | KR0024 | 2025-02-18T14:00:18.703Z | 2025-02-20T14:21:51.205Z |
6107083 | 6107083 | 20250217190818_HPkOO | KR0024 | 2025-02-18T14:00:18.053Z | 2025-02-20T14:21:50.482Z |
6104626 | 6104626 | 20250216205717_6ZwA2 | KR0024 | 2025-02-17T14:01:01.252Z | 2025-02-20T14:29:58.839Z |
6104565 | 6104565 | 20250216203932_didru | KR0024 | 2025-02-17T14:00:48.148Z | 2025-02-20T14:29:50.148Z |
6104497 | 6104497 | 20250216200515_7aSzl | KR0024 | 2025-02-17T14:00:40.605Z | 2025-02-20T14:29:45.018Z |
6103947 | 6103947 | 20250215151426_BXhwT | KR0024 | 2025-02-16T14:05:56.009Z | 2025-02-20T14:38:23.064Z |
6102155 | 6102155 | 20250214141900_eh0Ec | KR0024 | 2025-02-15T14:04:43.078Z | 2025-02-20T14:40:15.978Z |
6101215 | 6101215 | 20250213192059_RfOPW | KR0024 | 2025-02-14T14:05:07.195Z | 2025-02-20T14:42:57.652Z |
6100774 | 6100774 | 20250213125236_j8k6T | KR0024 | 2025-02-14T14:03:21.028Z | 2025-02-20T14:42:20.790Z |
6100231 | 6100231 | 20250213205236_v08Lh | KR0024 | 2025-02-14T14:00:44.586Z | 2025-02-20T14:39:08.071Z |
6100201 | 6100201 | 20250213200807_P4kTn | KR0024 | 2025-02-14T14:00:32.521Z | 2025-02-20T14:39:04.806Z |
6100188 | 6100188 | 20250213200127_K8ZVV | KR0024 | 2025-02-14T14:00:28.384Z | 2025-02-20T14:39:02.481Z |
6100019 | 6100019 | 20250212191144_F24rF | KR0024 | 2025-02-13T14:05:05.904Z | 2025-02-20T14:44:24.496Z |
6100004 | 6100004 | 20250212190819_2kUK8 | KR0024 | 2025-02-13T14:05:04.171Z | 2025-02-20T14:44:23.926Z |
6099937 | 6099937 | 20250212165509_KYzAI | KR0024 | 2025-02-13T14:04:45.745Z | 2025-02-20T14:44:18.522Z |
6099234 | 6099234 | 20250212212301_8Uhei | KR0024 | 2025-02-13T14:00:34.644Z | 2025-02-20T14:41:26.138Z |
6099223 | 6099223 | 20250212210958_5oj2W | KR0024 | 2025-02-13T14:00:32.322Z | 2025-02-20T14:41:25.288Z |
6099170 | 6099170 | 20250212202214_JoWT5 | KR0024 | 2025-02-13T14:00:19.694Z | 2025-02-20T14:41:20.146Z |
6099149 | 6099149 | 20250212195447_iTuhY | KR0024 | 2025-02-13T14:00:13.229Z | 2025-02-20T14:41:17.388Z |
6097981 | 6097981 | 20250211103637_2LNK8 | KR0024 | 2025-02-12T14:04:32.244Z | 2025-02-19T14:32:21.584Z |
6096919 | 6096919 | 20250210182550_lU2oO | KR0024 | 2025-02-11T14:04:51.759Z | 2025-02-18T14:28:24.816Z |
6096702 | 6096702 | 20250210155703_gLVrn | KR0024 | 2025-02-11T14:04:07.838Z | 2025-02-18T14:28:13.025Z |
6095751 | 6095751 | 20250210204254_fTjAw | KR0024 | 2025-02-11T14:00:17.134Z | 2025-02-19T14:31:42.692Z |
6095749 | 6095749 | 20250210204020_dsTFQ | KR0024 | 2025-02-11T14:00:16.724Z | 2025-02-19T14:31:42.448Z |
6095392 | 6095392 | 20250208203429_wqinM | KR0024 | 2025-02-10T14:15:36.906Z | 2025-02-16T14:23:11.195Z |
6095388 | 6095388 | 20250208203237_n6gWJ | KR0024 | 2025-02-10T14:15:36.255Z | 2025-02-16T14:23:10.980Z |
6095061 | 6095061 | 20250208190001_NtC9l | KR0024 | 2025-02-10T14:14:54.076Z | 2025-02-16T14:22:48.054Z |
6095010 | 6095010 | 20250208184322_VqdrS | KR0024 | 2025-02-10T14:14:37.959Z | 2025-02-16T14:22:46.603Z |
6094961 | 6094961 | 20250208182217_vPKdM | KR0024 | 2025-02-10T14:14:30.348Z | 2025-02-16T14:22:44.946Z |
6094937 | 6094937 | 20250208181928_24wOE | KR0024 | 2025-02-10T14:14:28.075Z | 2025-02-16T14:22:44.239Z |
6094849 | 6094849 | 20250208174625_eBahm | KR0024 | 2025-02-10T14:14:13.422Z | 2025-02-16T14:22:40.790Z |
6094743 | 6094743 | 20250208164155_44PJE | KR0024 | 2025-02-10T14:13:52.559Z | 2025-02-16T14:22:36.537Z |
6094727 | 6094727 | 20250208163436_JlQHw | KR0024 | 2025-02-10T14:13:50.123Z | 2025-02-16T14:22:35.571Z |
6094650 | 6094650 | 20250208154438_Qa7vR | KR0024 | 2025-02-10T14:13:24.314Z | 2025-02-16T14:22:12.277Z |
6094438 | 6094438 | 20250208133334_503am | KR0024 | 2025-02-10T14:12:09.055Z | 2025-02-16T14:21:35.413Z |
6094322 | 6094322 | 20250209202756_SwTnh | KR0024 | 2025-02-10T14:08:12.153Z | 2025-02-17T14:26:01.194Z |
6094302 | 6094302 | 20250209202228_Ljme4 | KR0024 | 2025-02-10T14:08:10.662Z | 2025-02-17T14:25:59.521Z |
6094290 | 6094290 | 20250209201035_y3M2d | KR0024 | 2025-02-10T14:08:09.195Z | 2025-02-17T14:25:53.535Z |
6094288 | 6094288 | 20250209200959_pCwK1 | KR0024 | 2025-02-10T14:08:07.958Z | 2025-02-17T14:25:53.398Z |
6094286 | 6094286 | 20250209200235_3w367 | KR0024 | 2025-02-10T14:08:07.404Z | 2025-02-17T14:25:52.919Z |
6094279 | 6094279 | 20250209195826_wYP4q | KR0024 | 2025-02-10T14:08:06.682Z | 2025-02-17T14:25:52.164Z |
6094271 | 6094271 | 20250209195217_k1UoX | KR0024 | 2025-02-10T14:08:05.428Z | 2025-02-17T14:25:51.232Z |
6094229 | 6094229 | 20250209192125_ER1XA | KR0024 | 2025-02-10T14:08:01.244Z | 2025-02-17T14:25:46.460Z |
6094224 | 6094224 | 20250209191248_cJExV | KR0024 | 2025-02-10T14:07:59.474Z | 2025-02-17T14:25:45.345Z |
6094171 | 6094171 | 20250209181250_3IkC8 | KR0024 | 2025-02-10T14:07:41.250Z | 2025-02-17T14:25:40.639Z |
6094148 | 6094148 | 20250209174123_syqWx | KR0024 | 2025-02-10T14:07:36.711Z | 2025-02-17T14:25:38.031Z |
6094131 | 6094131 | 20250209172351_UHi9P | KR0024 | 2025-02-10T14:07:31.728Z | 2025-02-17T14:25:37.068Z |
6093860 | 6093860 | 20250209135557_Pdpf2 | KR0024 | 2025-02-10T14:06:33.809Z | 2025-02-17T14:25:10.727Z |
6092748 | 6092748 | 20250208213249_Wz33v | KR0024 | 2025-02-10T14:00:44.543Z | 2025-02-17T14:23:42.072Z |
6092718 | 6092718 | 20250208211914_P3M4h | KR0024 | 2025-02-10T14:00:37.107Z | 2025-02-17T14:23:40.577Z |
6092634 | 6092634 | 20250209211829_aD3AP | KR0024 | 2025-02-10T14:00:21.267Z | 2025-02-18T14:27:11.158Z |
6092598 | 6092598 | 20250209205237_jwJSP | KR0024 | 2025-02-10T14:00:14.620Z | 2025-02-18T14:27:07.656Z |
6092579 | 6092579 | 20250209204039_si2FD | KR0024 | 2025-02-10T14:00:10.818Z | 2025-02-18T14:27:05.304Z |
6092404 | 6092404 | 20250207205416_4KZHY | KR0024 | 2025-02-09T14:17:21.414Z | 2025-02-15T14:31:28.172Z |
6092362 | 6092362 | 20250207204159_HQW3a | KR0024 | 2025-02-09T14:17:17.816Z | 2025-02-15T14:31:26.302Z |
6092348 | 6092348 | 20250207203600_7Zx2U | KR0024 | 2025-02-09T14:17:13.794Z | 2025-02-15T14:31:25.004Z |
6092279 | 6092279 | 20250207201844_CR7BG | KR0024 | 2025-02-09T14:17:07.704Z | 2025-02-15T14:31:22.131Z |
6091963 | 6091963 | 20250207184314_4PDlt | KR0024 | 2025-02-09T14:16:23.921Z | 2025-02-15T14:30:58.197Z |
6091913 | 6091913 | 20250207182013_Lw3l7 | KR0024 | 2025-02-09T14:16:03.490Z | 2025-02-15T14:30:53.957Z |
6091890 | 6091890 | 20250207181546_oub2W | KR0024 | 2025-02-09T14:15:56.531Z | 2025-02-15T14:30:51.400Z |
6091864 | 6091864 | 20250207181212_q9wSg | KR0024 | 2025-02-09T14:15:51.024Z | 2025-02-15T14:30:45.442Z |
6091356 | 6091356 | 20250207144056_WpOU2 | KR0024 | 2025-02-09T14:13:58.455Z | 2025-02-15T14:29:41.438Z |
6083206 | 6083206 | 20250204213718_ui63U | KR0024 | 2025-02-07T14:41:57.413Z | 2025-02-12T14:50:45.002Z |
6082923 | 6082923 | 20250204205609_BnU9l | KR0024 | 2025-02-07T14:41:45.534Z | 2025-02-12T14:50:29.496Z |
6082276 | 6082276 | 20250204192502_IWZgi | KR0024 | 2025-02-07T14:41:14.957Z | 2025-02-12T14:49:49.208Z |
6081874 | 6081874 | 20250204180958_HC3QS | KR0024 | 2025-02-07T14:40:46.787Z | 2025-02-12T14:49:16.872Z |
6080364 | 6080364 | 20250204144036_Yfw76 | KR0024 | 2025-02-07T14:39:30.636Z | 2025-02-12T14:47:49.516Z |
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);