participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,112 rows where station_code = "KR0002" 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 |
---|---|---|---|---|---|
5556157 | 5556157 | 20241119202359_uKkn7 | KR0002 | 2024-11-20T14:07:29.801Z | 2024-11-21T14:18:53.498Z |
5556153 | 5556153 | 20241119202335_SFtK0 | KR0002 | 2024-11-20T14:07:28.930Z | 2024-11-21T14:18:53.497Z |
5556126 | 5556126 | 20241119201350_oi1we | KR0002 | 2024-11-20T14:07:22.712Z | 2024-11-21T14:18:53.488Z |
5556118 | 5556118 | 20241119201257_pLKXp | KR0002 | 2024-11-20T14:07:21.993Z | 2024-11-21T14:18:53.487Z |
5556074 | 5556074 | 20241119194431_904iW | KR0002 | 2024-11-20T14:07:18.301Z | 2024-11-21T14:18:53.467Z |
5556069 | 5556069 | 20241119194420_5K9IR | KR0002 | 2024-11-20T14:07:17.518Z | 2024-11-21T14:18:53.466Z |
5556033 | 5556033 | 20241119191816_gC63Z | KR0002 | 2024-11-20T14:07:14.191Z | 2024-11-21T14:18:53.447Z |
5555983 | 5555983 | 20241119184928_yx4q8 | KR0002 | 2024-11-20T14:07:11.019Z | 2024-11-21T14:18:53.423Z |
5555965 | 5555965 | 20241119183032_xTg1n | KR0002 | 2024-11-20T14:07:09.201Z | 2024-11-21T14:18:53.414Z |
5552367 | 5552367 | 20241118210629_080uo | KR0002 | 2024-11-19T14:06:27.350Z | 2024-11-21T14:20:23.493Z |
5552324 | 5552324 | 20241118203643_IbNiP | KR0002 | 2024-11-19T14:06:22.215Z | 2024-11-21T14:20:22.020Z |
5552309 | 5552309 | 20241118202553_mlUtQ | KR0002 | 2024-11-19T14:06:20.279Z | 2024-11-21T14:20:20.632Z |
5552305 | 5552305 | 20241118202517_33cmF | KR0002 | 2024-11-19T14:06:19.980Z | 2024-11-21T14:20:20.401Z |
5552300 | 5552300 | 20241118202256_mu9ZQ | KR0002 | 2024-11-19T14:06:19.271Z | 2024-11-21T14:20:20.393Z |
5552272 | 5552272 | 20241118201019_MpSAH | KR0002 | 2024-11-19T14:06:13.817Z | 2024-11-21T14:20:19.939Z |
5552269 | 5552269 | 20241118200832_NZ2N0 | KR0002 | 2024-11-19T14:06:13.260Z | 2024-11-21T14:20:19.906Z |
5552200 | 5552200 | 20241118191644_zm2Bb | KR0002 | 2024-11-19T14:06:07.646Z | 2024-11-21T14:20:18.160Z |
5552162 | 5552162 | 20241118184255_bBoNT | KR0002 | 2024-11-19T14:06:04.712Z | 2024-11-21T14:20:16.916Z |
5552139 | 5552139 | 20241118183112_mUvIV | KR0002 | 2024-11-19T14:06:02.723Z | 2024-11-21T14:20:16.412Z |
5552021 | 5552021 | 20241118172219_7MPqF | KR0002 | 2024-11-19T14:05:55.765Z | 2024-11-21T14:20:11.601Z |
5551982 | 5551982 | 20241118164527_AKyzD | KR0002 | 2024-11-19T14:05:52.155Z | 2024-11-21T14:20:09.548Z |
5551974 | 5551974 | 20241118164155_jadL0 | KR0002 | 2024-11-19T14:05:51.704Z | 2024-11-21T14:20:09.307Z |
5550123 | 5550123 | 20241118093447_T6JIN | KR0002 | 2024-11-19T14:01:36.400Z | 2024-11-21T14:19:06.167Z |
5547956 | 5547956 | 20241117204610_ZOOil | KR0002 | 2024-11-18T14:06:51.607Z | 2024-11-21T14:21:57.983Z |
5547896 | 5547896 | 20241117202813_BI6Lb | KR0002 | 2024-11-18T14:06:48.580Z | 2024-11-21T14:21:56.482Z |
5547886 | 5547886 | 20241117202435_yWkWY | KR0002 | 2024-11-18T14:06:48.079Z | 2024-11-21T14:21:56.234Z |
5547802 | 5547802 | 20241117195058_tiHmC | KR0002 | 2024-11-18T14:06:38.853Z | 2024-11-21T14:21:53.500Z |
5547778 | 5547778 | 20241117194452_tJM9K | KR0002 | 2024-11-18T14:06:32.107Z | 2024-11-21T14:21:53.056Z |
5547701 | 5547701 | 20241117191307_WSpJW | KR0002 | 2024-11-18T14:06:18.609Z | 2024-11-21T14:21:50.645Z |
5547652 | 5547652 | 20241117185135_zLZpn | KR0002 | 2024-11-18T14:06:11.848Z | 2024-11-21T14:21:48.850Z |
5547610 | 5547610 | 20241117183411_vJI35 | KR0002 | 2024-11-18T14:06:07.933Z | 2024-11-21T14:21:47.563Z |
5547597 | 5547597 | 20241117182048_N9jze | KR0002 | 2024-11-18T14:06:07.110Z | 2024-11-21T14:21:46.530Z |
5547438 | 5547438 | 20241117164443_EdPeR | KR0002 | 2024-11-18T14:05:51.977Z | 2024-11-21T14:21:41.153Z |
5547374 | 5547374 | 20241117155123_mKeKj | KR0002 | 2024-11-18T14:05:36.383Z | 2024-11-21T14:21:39.786Z |
5537196 | 5537196 | 20241112205647_UTHN8 | KR0002 | 2024-11-14T14:11:17.437Z | 2024-11-21T14:26:09.638Z |
5537166 | 5537166 | 20241112204259_3fA2f | KR0002 | 2024-11-14T14:11:10.448Z | 2024-11-21T14:26:09.442Z |
5537131 | 5537131 | 20241112203414_2MnhP | KR0002 | 2024-11-14T14:11:06.908Z | 2024-11-21T14:26:09.164Z |
5537125 | 5537125 | 20241112203314_Mfm1o | KR0002 | 2024-11-14T14:11:05.999Z | 2024-11-21T14:26:09.139Z |
5537077 | 5537077 | 20241112202140_bQbYg | KR0002 | 2024-11-14T14:10:59.398Z | 2024-11-21T14:26:08.691Z |
5537073 | 5537073 | 20241112202057_BMi32 | KR0002 | 2024-11-14T14:10:59.071Z | 2024-11-21T14:26:08.671Z |
5536992 | 5536992 | 20241112200115_bgBpA | KR0002 | 2024-11-14T14:10:49.213Z | 2024-11-21T14:26:07.733Z |
5536944 | 5536944 | 20241112194658_07BOA | KR0002 | 2024-11-14T14:10:45.960Z | 2024-11-21T14:26:07.304Z |
5536906 | 5536906 | 20241112193857_rNukN | KR0002 | 2024-11-14T14:10:40.317Z | 2024-11-21T14:26:06.879Z |
5536878 | 5536878 | 20241112193503_JMAAp | KR0002 | 2024-11-14T14:10:39.204Z | 2024-11-21T14:26:06.681Z |
5536823 | 5536823 | 20241112192119_truFa | KR0002 | 2024-11-14T14:10:35.605Z | 2024-11-21T14:26:06.020Z |
5536668 | 5536668 | 20241112185119_VM79y | KR0002 | 2024-11-14T14:10:26.695Z | 2024-11-21T14:26:04.385Z |
5536565 | 5536565 | 20241112183104_cqCIx | KR0002 | 2024-11-14T14:10:19.738Z | 2024-11-21T14:26:03.288Z |
5536499 | 5536499 | 20241112181754_hlo7C | KR0002 | 2024-11-14T14:10:05.658Z | 2024-11-21T14:26:01.452Z |
5536425 | 5536425 | 20241112175841_P9s1u | KR0002 | 2024-11-14T14:09:53.767Z | 2024-11-21T14:26:00.862Z |
5536419 | 5536419 | 20241112175830_l7mvN | KR0002 | 2024-11-14T14:09:53.296Z | 2024-11-21T14:26:00.841Z |
5536324 | 5536324 | 20241112172743_JAoxv | KR0002 | 2024-11-14T14:09:37.683Z | 2024-11-21T14:26:00.084Z |
5536291 | 5536291 | 20241112171449_9f3LS | KR0002 | 2024-11-14T14:09:34.087Z | 2024-11-21T14:25:59.786Z |
5536261 | 5536261 | 20241112165543_LoH1g | KR0002 | 2024-11-14T14:09:28.785Z | 2024-11-21T14:25:59.485Z |
5536173 | 5536173 | 20241112160412_G2bCI | KR0002 | 2024-11-14T14:09:17.109Z | 2024-11-21T14:25:57.231Z |
5536160 | 5536160 | 20241112155811_6um0S | KR0002 | 2024-11-14T14:09:16.494Z | 2024-11-21T14:25:57.114Z |
5535833 | 5535833 | 20241112143608_3EGTm | KR0002 | 2024-11-14T14:08:53.333Z | 2024-11-21T14:25:53.703Z |
5535824 | 5535824 | 20241112143411_m4ArX | KR0002 | 2024-11-14T14:08:52.720Z | 2024-11-21T14:25:53.696Z |
5535653 | 5535653 | 20241112133024_x7yqR | KR0002 | 2024-11-14T14:08:16.722Z | 2024-11-21T14:25:50.874Z |
5535591 | 5535591 | 20241112125456_WFOVr | KR0002 | 2024-11-14T14:08:09.220Z | 2024-11-21T14:25:50.383Z |
5535572 | 5535572 | 20241112125243_3UBWB | KR0002 | 2024-11-14T14:08:08.175Z | 2024-11-21T14:25:50.209Z |
5535472 | 5535472 | 20241112123503_GgDob | KR0002 | 2024-11-14T14:07:58.948Z | 2024-11-21T14:25:48.565Z |
5527334 | 5527334 | 20241111152345_7vy5q | KR0002 | 2024-11-13T14:07:51.655Z | 2024-11-20T14:25:07.020Z |
5508409 | 5508409 | 20241109171923_8sNnZ | KR0002 | 2024-11-10T14:07:45.758Z | 2024-11-18T14:26:22.234Z |
5508374 | 5508374 | 20241109165022_BbhY6 | KR0002 | 2024-11-10T14:07:36.451Z | 2024-11-18T14:26:21.833Z |
5508332 | 5508332 | 20241109162610_xHQhX | KR0002 | 2024-11-10T14:07:28.445Z | 2024-11-18T14:26:21.421Z |
5508304 | 5508304 | 20241109155904_3Yglv | KR0002 | 2024-11-10T14:07:25.526Z | 2024-11-18T14:26:21.041Z |
5508293 | 5508293 | 20241109155415_v81fP | KR0002 | 2024-11-10T14:07:24.371Z | 2024-11-18T14:26:20.953Z |
5508242 | 5508242 | 20241109152130_UXKzf | KR0002 | 2024-11-10T14:07:18.399Z | 2024-11-18T14:26:20.269Z |
5508237 | 5508237 | 20241109152044_H6PuN | KR0002 | 2024-11-10T14:07:18.095Z | 2024-11-18T14:26:20.247Z |
5508234 | 5508234 | 20241109151924_8E3B2 | KR0002 | 2024-11-10T14:07:17.715Z | 2024-11-18T14:26:20.204Z |
5508225 | 5508225 | 20241109151606_haMRH | KR0002 | 2024-11-10T14:07:16.891Z | 2024-11-18T14:26:20.161Z |
5508215 | 5508215 | 20241109151518_GRuse | KR0002 | 2024-11-10T14:07:16.369Z | 2024-11-18T14:26:20.124Z |
5508201 | 5508201 | 20241109151306_LOXwr | KR0002 | 2024-11-10T14:07:15.216Z | 2024-11-18T14:26:19.944Z |
5508145 | 5508145 | 20241109144532_Yzo5T | KR0002 | 2024-11-10T14:07:09.326Z | 2024-11-18T14:26:19.366Z |
5508129 | 5508129 | 20241109144109_Fv8y1 | KR0002 | 2024-11-10T14:07:07.406Z | 2024-11-18T14:26:19.157Z |
5508107 | 5508107 | 20241109143019_vetWm | KR0002 | 2024-11-10T14:07:04.643Z | 2024-11-18T14:26:18.966Z |
5508075 | 5508075 | 20241109141522_3xvXB | KR0002 | 2024-11-10T14:06:51.800Z | 2024-11-18T14:26:18.619Z |
5508058 | 5508058 | 20241109135830_EGo1d | KR0002 | 2024-11-10T14:06:46.890Z | 2024-11-18T14:26:18.249Z |
5508047 | 5508047 | 20241109135126_UWoqB | KR0002 | 2024-11-10T14:06:44.188Z | 2024-11-18T14:26:18.085Z |
5508015 | 5508015 | 20241109134325_SxUqX | KR0002 | 2024-11-10T14:06:39.544Z | 2024-11-18T14:26:18.042Z |
5508008 | 5508008 | 20241109133746_vYF3m | KR0002 | 2024-11-10T14:06:38.752Z | 2024-11-18T14:26:17.972Z |
5507806 | 5507806 | 20241109122957_w3p3e | KR0002 | 2024-11-10T14:06:14.396Z | 2024-11-18T14:26:14.815Z |
5507779 | 5507779 | 20241109122520_533GA | KR0002 | 2024-11-10T14:06:09.228Z | 2024-11-18T14:26:14.660Z |
5507484 | 5507484 | 20241109113717_miCoD | KR0002 | 2024-11-10T14:05:24.226Z | 2024-11-18T14:26:11.194Z |
5507020 | 5507020 | 20241109101527_2OhOr | KR0002 | 2024-11-10T14:04:04.859Z | 2024-11-18T14:26:06.014Z |
5503134 | 5503134 | 20241107204559_SQr1O | KR0002 | 2024-11-09T14:12:26.872Z | 2024-11-16T14:28:03.541Z |
5503082 | 5503082 | 20241107203901_2Dj3F | KR0002 | 2024-11-09T14:12:23.786Z | 2024-11-16T14:28:02.469Z |
5503078 | 5503078 | 20241107203900_AtJa0 | KR0002 | 2024-11-09T14:12:23.575Z | 2024-11-16T14:28:02.451Z |
5503062 | 5503062 | 20241107203750_ykueX | KR0002 | 2024-11-09T14:12:22.707Z | 2024-11-16T14:28:02.421Z |
5503011 | 5503011 | 20241107202749_UIsr6 | KR0002 | 2024-11-09T14:12:18.700Z | 2024-11-16T14:28:01.823Z |
5503006 | 5503006 | 20241107202703_wd3eV | KR0002 | 2024-11-09T14:12:18.610Z | 2024-11-16T14:28:01.821Z |
5502976 | 5502976 | 20241107202344_ErhkF | KR0002 | 2024-11-09T14:12:16.604Z | 2024-11-16T14:28:01.659Z |
5502947 | 5502947 | 20241107201605_GSm3e | KR0002 | 2024-11-09T14:12:14.376Z | 2024-11-16T14:28:00.884Z |
5502944 | 5502944 | 20241107201602_bGB3L | KR0002 | 2024-11-09T14:12:14.216Z | 2024-11-16T14:28:00.874Z |
5502818 | 5502818 | 20241107194930_WZY79 | KR0002 | 2024-11-09T14:12:04.951Z | 2024-11-16T14:27:59.710Z |
5502809 | 5502809 | 20241107194900_9Fivi | KR0002 | 2024-11-09T14:12:04.494Z | 2024-11-16T14:27:59.677Z |
5502748 | 5502748 | 20241107194035_1klyM | KR0002 | 2024-11-09T14:12:01.366Z | 2024-11-16T14:27:59.207Z |
5502719 | 5502719 | 20241107193711_30Ngn | KR0002 | 2024-11-09T14:11:59.627Z | 2024-11-16T14:27:58.905Z |
5502648 | 5502648 | 20241107192657_l2d2R | KR0002 | 2024-11-09T14:11:54.665Z | 2024-11-16T14:27:58.231Z |
5502644 | 5502644 | 20241107192600_Z8c3h | KR0002 | 2024-11-09T14:11:54.164Z | 2024-11-16T14:27:58.222Z |
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);