participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,893 rows where station_code = "KR001H" 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 |
|---|---|---|---|---|---|
| 8689657 | 8689657 | 20251205191712_wCqF1 | KR001H | 2025-12-06T14:09:21.844Z | 2025-12-06T14:09:21.844Z |
| 8686839 | 8686839 | 20251203210011_Vt2HD | KR001H | 2025-12-05T14:12:55.589Z | 2025-12-06T14:22:09.608Z |
| 8686137 | 8686137 | 20251203185005_TwbeI | KR001H | 2025-12-05T14:11:07.796Z | 2025-12-06T14:21:31.719Z |
| 8673417 | 8673417 | 20251201185955_42sWW | KR001H | 2025-12-03T14:18:47.896Z | 2025-12-06T14:33:07.423Z |
| 8673309 | 8673309 | 20251201182101_Xhkua | KR001H | 2025-12-03T14:18:14.883Z | 2025-12-06T14:32:58.069Z |
| 8673302 | 8673302 | 20251201181930_ayPPp | KR001H | 2025-12-03T14:18:13.855Z | 2025-12-06T14:32:57.860Z |
| 8663599 | 8663599 | 20251130210727_2CpuU | KR001H | 2025-12-02T14:18:33.056Z | 2025-12-06T14:40:04.636Z |
| 8663529 | 8663529 | 20251130205640_hs7m7 | KR001H | 2025-12-02T14:18:24.581Z | 2025-12-06T14:40:02.180Z |
| 8663515 | 8663515 | 20251130205400_xttLT | KR001H | 2025-12-02T14:18:23.867Z | 2025-12-06T14:40:02.080Z |
| 8663482 | 8663482 | 20251130204935_segf3 | KR001H | 2025-12-02T14:18:21.484Z | 2025-12-06T14:40:01.530Z |
| 8663405 | 8663405 | 20251130204352_lE5bK | KR001H | 2025-12-02T14:18:15.177Z | 2025-12-06T14:40:00.257Z |
| 8663302 | 8663302 | 20251130202841_PcngH | KR001H | 2025-12-02T14:17:57.246Z | 2025-12-06T14:39:57.704Z |
| 8663161 | 8663161 | 20251130201725_Qh3tn | KR001H | 2025-12-02T14:17:34.129Z | 2025-12-06T14:39:54.857Z |
| 8662875 | 8662875 | 20251130194241_dApIu | KR001H | 2025-12-02T14:16:54.354Z | 2025-12-06T14:39:33.988Z |
| 8662851 | 8662851 | 20251130193955_bqqCb | KR001H | 2025-12-02T14:16:51.726Z | 2025-12-06T14:39:33.381Z |
| 8662789 | 8662789 | 20251130193211_CdPZJ | KR001H | 2025-12-02T14:16:43.236Z | 2025-12-06T14:39:30.147Z |
| 8662534 | 8662534 | 20251130190706_BNdiv | KR001H | 2025-12-02T14:15:50.900Z | 2025-12-06T14:39:21.815Z |
| 8662404 | 8662404 | 20251130184501_FNMgf | KR001H | 2025-12-02T14:15:22.947Z | 2025-12-06T14:39:17.215Z |
| 8662232 | 8662232 | 20251130182115_2v0DR | KR001H | 2025-12-02T14:14:45.438Z | 2025-12-06T14:38:56.619Z |
| 8662024 | 8662024 | 20251130174526_n2fWp | KR001H | 2025-12-02T14:14:01.029Z | 2025-12-06T14:38:47.288Z |
| 8661924 | 8661924 | 20251130173232_3beiD | KR001H | 2025-12-02T14:13:37.727Z | 2025-12-06T14:38:42.135Z |
| 8661775 | 8661775 | 20251130171109_b1ORt | KR001H | 2025-12-02T14:13:00.434Z | 2025-12-06T14:38:30.097Z |
| 8660902 | 8660902 | 20251130141010_0lVAB | KR001H | 2025-12-02T14:09:38.315Z | 2025-12-06T14:37:29.237Z |
| 8659201 | 8659201 | 20251130094820_YHzD5 | KR001H | 2025-12-02T14:02:55.798Z | 2025-12-06T14:36:10.811Z |
| 8659051 | 8659051 | 20251130092619_JzNpg | KR001H | 2025-12-02T14:02:22.902Z | 2025-12-06T14:36:04.176Z |
| 8650677 | 8650677 | 20251129210516_XOWs9 | KR001H | 2025-12-01T14:16:53.022Z | 2025-12-06T14:46:31.681Z |
| 8650661 | 8650661 | 20251129210301_5756G | KR001H | 2025-12-01T14:16:50.919Z | 2025-12-06T14:46:31.393Z |
| 8650508 | 8650508 | 20251129203343_IxDjH | KR001H | 2025-12-01T14:16:21.034Z | 2025-12-06T14:45:59.057Z |
| 8650367 | 8650367 | 20251129200219_koigX | KR001H | 2025-12-01T14:15:54.748Z | 2025-12-06T14:45:54.983Z |
| 8650304 | 8650304 | 20251129195147_fMogC | KR001H | 2025-12-01T14:15:45.631Z | 2025-12-06T14:45:53.811Z |
| 8650079 | 8650079 | 20251129191904_i1yex | KR001H | 2025-12-01T14:15:01.517Z | 2025-12-06T14:45:47.561Z |
| 8649957 | 8649957 | 20251129185734_cLL5f | KR001H | 2025-12-01T14:14:34.427Z | 2025-12-06T14:45:44.010Z |
| 8649939 | 8649939 | 20251129185423_y2cWp | KR001H | 2025-12-01T14:14:30.509Z | 2025-12-06T14:45:43.390Z |
| 8649785 | 8649785 | 20251129182519_2daWq | KR001H | 2025-12-01T14:13:56.776Z | 2025-12-06T14:45:39.521Z |
| 8649762 | 8649762 | 20251129182115_EWvao | KR001H | 2025-12-01T14:13:52.823Z | 2025-12-06T14:45:38.879Z |
| 8649563 | 8649563 | 20251129174813_Ih7V9 | KR001H | 2025-12-01T14:13:04.788Z | 2025-12-06T14:45:33.103Z |
| 8649334 | 8649334 | 20251129170835_x00Og | KR001H | 2025-12-01T14:12:03.352Z | 2025-12-06T14:44:56.366Z |
| 8649298 | 8649298 | 20251129170026_9cvcP | KR001H | 2025-12-01T14:11:56.540Z | 2025-12-06T14:44:54.989Z |
| 8649284 | 8649284 | 20251129165935_j3Spg | KR001H | 2025-12-01T14:11:53.591Z | 2025-12-06T14:44:54.363Z |
| 8649261 | 8649261 | 20251129165319_Vns7P | KR001H | 2025-12-01T14:11:48.854Z | 2025-12-06T14:44:53.983Z |
| 8649252 | 8649252 | 20251129165111_pKbGO | KR001H | 2025-12-01T14:11:46.941Z | 2025-12-06T14:44:53.709Z |
| 8649204 | 8649204 | 20251129163655_0BWAE | KR001H | 2025-12-01T14:11:26.556Z | 2025-12-06T14:44:51.252Z |
| 8649113 | 8649113 | 20251129161532_7LIdP | KR001H | 2025-12-01T14:10:58.865Z | 2025-12-06T14:44:49.064Z |
| 8649070 | 8649070 | 20251129160135_ZvdVF | KR001H | 2025-12-01T14:10:48.256Z | 2025-12-06T14:44:47.707Z |
| 8648942 | 8648942 | 20251129152237_CKMZV | KR001H | 2025-12-01T14:10:01.213Z | 2025-12-06T14:44:42.027Z |
| 8645297 | 8645297 | 20251128211419_tOk3v | KR001H | 2025-11-30T14:23:32.577Z | 2025-12-06T14:54:53.041Z |
| 8645147 | 8645147 | 20251128204353_cxPrr | KR001H | 2025-11-30T14:23:09.981Z | 2025-12-06T14:54:51.070Z |
| 8644900 | 8644900 | 20251128201337_gxOQm | KR001H | 2025-11-30T14:22:51.123Z | 2025-12-06T14:54:48.768Z |
| 8644862 | 8644862 | 20251128200732_k8krq | KR001H | 2025-11-30T14:22:48.579Z | 2025-12-06T14:54:48.320Z |
| 8644842 | 8644842 | 20251128200410_1j7ee | KR001H | 2025-11-30T14:22:46.996Z | 2025-12-06T14:54:48.053Z |
| 8643683 | 8643683 | 20251128181447_l9fUB | KR001H | 2025-11-30T14:20:33.286Z | 2025-12-06T14:54:03.969Z |
| 8643599 | 8643599 | 20251128180837_icNYv | KR001H | 2025-11-30T14:20:15.748Z | 2025-12-06T14:53:52.064Z |
| 8643570 | 8643570 | 20251128180705_K2WwD | KR001H | 2025-11-30T14:20:13.712Z | 2025-12-06T14:53:51.469Z |
| 8643464 | 8643464 | 20251128175950_v0Jc2 | KR001H | 2025-11-30T14:20:03.341Z | 2025-12-06T14:53:49.840Z |
| 8643198 | 8643198 | 20251128173234_NBhUW | KR001H | 2025-11-30T14:19:27.239Z | 2025-12-06T14:53:43.047Z |
| 8643053 | 8643053 | 20251128171608_2ubj3 | KR001H | 2025-11-30T14:19:16.567Z | 2025-12-06T14:53:39.948Z |
| 8643015 | 8643015 | 20251128171215_GyAPo | KR001H | 2025-11-30T14:19:13.332Z | 2025-12-06T14:53:39.433Z |
| 8642899 | 8642899 | 20251128170142_xZm0X | KR001H | 2025-11-30T14:18:57.539Z | 2025-12-06T14:53:37.718Z |
| 8642829 | 8642829 | 20251128165350_12BjO | KR001H | 2025-11-30T14:18:41.872Z | 2025-12-06T14:53:36.754Z |
| 8642606 | 8642606 | 20251128163113_B1Wpy | KR001H | 2025-11-30T14:18:21.670Z | 2025-12-06T14:53:34.053Z |
| 8642364 | 8642364 | 20251128155826_XfLPD | KR001H | 2025-11-30T14:17:50.622Z | 2025-12-06T14:53:30.790Z |
| 8641598 | 8641598 | 20251128150111_iRIev | KR001H | 2025-11-30T14:16:34.698Z | 2025-12-06T14:52:40.015Z |
| 8641522 | 8641522 | 20251128145832_ZZNgP | KR001H | 2025-11-30T14:16:30.517Z | 2025-12-06T14:52:38.368Z |
| 8640889 | 8640889 | 20251128123659_wTfhQ | KR001H | 2025-11-30T14:11:55.178Z | 2025-12-06T14:51:41.694Z |
| 8640859 | 8640859 | 20251128120742_Ya4ux | KR001H | 2025-11-30T14:11:13.335Z | 2025-12-06T14:51:31.392Z |
| 8640752 | 8640752 | 20251128103708_Eh41g | KR001H | 2025-11-30T14:10:18.077Z | 2025-12-06T14:51:14.477Z |
| 8632423 | 8632423 | 20251127210516_SIv82 | KR001H | 2025-11-29T14:17:27.928Z | 2025-12-06T15:01:17.214Z |
| 8632114 | 8632114 | 20251127203300_pXIM5 | KR001H | 2025-11-29T14:17:01.266Z | 2025-12-06T15:00:53.260Z |
| 8631989 | 8631989 | 20251127201747_yzgO0 | KR001H | 2025-11-29T14:16:38.731Z | 2025-12-06T15:00:49.033Z |
| 8631960 | 8631960 | 20251127201659_Cep1O | KR001H | 2025-11-29T14:16:36.578Z | 2025-12-06T15:00:47.863Z |
| 8631797 | 8631797 | 20251127200155_mPlzb | KR001H | 2025-11-29T14:16:24.753Z | 2025-12-06T15:00:42.248Z |
| 8631782 | 8631782 | 20251127200040_07u4c | KR001H | 2025-11-29T14:16:23.172Z | 2025-12-06T15:00:41.703Z |
| 8631729 | 8631729 | 20251127195524_PkvQy | KR001H | 2025-11-29T14:16:17.837Z | 2025-12-06T15:00:39.142Z |
| 8631569 | 8631569 | 20251127192716_P7dEk | KR001H | 2025-11-29T14:15:46.322Z | 2025-12-06T15:00:20.808Z |
| 8631173 | 8631173 | 20251127182759_sKICk | KR001H | 2025-11-29T14:14:45.062Z | 2025-12-06T14:59:56.950Z |
| 8631051 | 8631051 | 20251127180811_ebW2C | KR001H | 2025-11-29T14:14:28.869Z | 2025-12-06T14:59:50.740Z |
| 8631035 | 8631035 | 20251127180648_bGWLZ | KR001H | 2025-11-29T14:14:27.448Z | 2025-12-06T14:59:50.531Z |
| 8630831 | 8630831 | 20251127173334_6Fm6B | KR001H | 2025-11-29T14:13:50.689Z | 2025-12-06T14:59:34.812Z |
| 8630723 | 8630723 | 20251127171022_qUDNs | KR001H | 2025-11-29T14:13:36.737Z | 2025-12-06T14:59:22.667Z |
| 8630679 | 8630679 | 20251127170518_Z23pv | KR001H | 2025-11-29T14:13:27.385Z | 2025-12-06T14:59:16.966Z |
| 8630599 | 8630599 | 20251127165048_MRsb2 | KR001H | 2025-11-29T14:13:04.481Z | 2025-12-06T14:59:13.896Z |
| 8630387 | 8630387 | 20251127160423_2rDeL | KR001H | 2025-11-29T14:12:29.246Z | 2025-12-06T14:59:02.849Z |
| 8630273 | 8630273 | 20251127153317_Jjdor | KR001H | 2025-11-29T14:12:12.165Z | 2025-12-06T14:59:01.337Z |
| 8630262 | 8630262 | 20251127153108_yomXQ | KR001H | 2025-11-29T14:12:11.831Z | 2025-12-06T14:59:01.280Z |
| 8630172 | 8630172 | 20251127145950_N5fUD | KR001H | 2025-11-29T14:11:59.336Z | 2025-12-06T14:58:59.468Z |
| 8622588 | 8622588 | 20251126200917_1HOwj | KR001H | 2025-11-28T14:19:26.009Z | 2025-12-05T15:03:03.725Z |
| 8622239 | 8622239 | 20251126182154_FYeL2 | KR001H | 2025-11-28T14:18:12.491Z | 2025-12-05T15:02:53.958Z |
| 8622218 | 8622218 | 20251126181724_Wc02X | KR001H | 2025-11-28T14:18:09.669Z | 2025-12-05T15:02:53.708Z |
| 8622180 | 8622180 | 20251126180725_Der8m | KR001H | 2025-11-28T14:18:04.309Z | 2025-12-05T15:02:53.258Z |
| 8621864 | 8621864 | 20251126164732_3qf9E | KR001H | 2025-11-28T14:16:54.912Z | 2025-12-05T15:02:48.719Z |
| 8621850 | 8621850 | 20251126164512_JubGO | KR001H | 2025-11-28T14:16:53.629Z | 2025-12-05T15:02:48.633Z |
| 8621823 | 8621823 | 20251126163835_2OPe1 | KR001H | 2025-11-28T14:16:49.850Z | 2025-12-05T15:02:48.283Z |
| 8621767 | 8621767 | 20251126162202_TR1dh | KR001H | 2025-11-28T14:16:31.465Z | 2025-12-05T15:02:47.652Z |
| 8621746 | 8621746 | 20251126162014_hFoya | KR001H | 2025-11-28T14:16:30.496Z | 2025-12-05T15:02:47.517Z |
| 8621707 | 8621707 | 20251126161034_48zty | KR001H | 2025-11-28T14:16:25.685Z | 2025-12-05T15:02:47.123Z |
| 8621653 | 8621653 | 20251126155748_7NN4h | KR001H | 2025-11-28T14:16:19.806Z | 2025-12-05T15:02:46.377Z |
| 8621573 | 8621573 | 20251126154211_Ko7HV | KR001H | 2025-11-28T14:16:02.996Z | 2025-12-05T15:02:45.470Z |
| 8620345 | 8620345 | 20251126121903_zDiFa | KR001H | 2025-11-28T14:12:29.738Z | 2025-12-05T15:01:54.262Z |
| 8607616 | 8607616 | 20251125210656_cZ96o | KR001H | 2025-11-27T14:14:02.793Z | 2025-12-04T15:07:05.043Z |
| 8607483 | 8607483 | 20251125205341_V3J3N | KR001H | 2025-11-27T14:13:49.468Z | 2025-12-04T15:07:02.685Z |
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);