participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
601 rows where station_code = "KR003E" 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 |
---|---|---|---|---|---|
4498593 | 4498593 | 20240625163331_rcklr | KR003E | 2024-06-26T12:00:54.460Z | 2024-07-04T12:08:45.430Z |
4463173 | 4463173 | 20240613185053_SBfeK | KR003E | 2024-06-15T12:09:31.439Z | 2024-06-21T12:11:48.091Z |
4415704 | 4415704 | 20240604184411_mIWEF | KR003E | 2024-06-06T12:05:12.437Z | 2024-06-13T12:08:30.210Z |
4413369 | 4413369 | 20240604134737_Szt5G | KR003E | 2024-06-06T12:01:35.622Z | 2024-06-13T12:08:28.490Z |
4411093 | 4411093 | 20240603183938_bh10t | KR003E | 2024-06-05T12:06:18.195Z | 2024-06-12T12:10:36.650Z |
4410742 | 4410742 | 20240603175351_siHmR | KR003E | 2024-06-05T12:05:45.570Z | 2024-06-12T12:10:35.306Z |
4410462 | 4410462 | 20240603171436_opwWF | KR003E | 2024-06-05T12:05:25.266Z | 2024-06-12T12:10:34.790Z |
4410077 | 4410077 | 20240603163311_kHmkT | KR003E | 2024-06-05T12:04:48.515Z | 2024-06-12T12:10:34.172Z |
4409821 | 4409821 | 20240603160327_Y30wv | KR003E | 2024-06-05T12:04:18.124Z | 2024-06-12T12:10:33.697Z |
4389083 | 4389083 | 20240528180146_JBiC4 | KR003E | 2024-05-30T12:04:48.504Z | 2024-06-06T12:14:26.139Z |
4385478 | 4385478 | 20240528154950_LwwBl | KR003E | 2024-05-29T12:03:33.788Z | 2024-06-06T12:14:24.943Z |
4385321 | 4385321 | 20240528151117_rU35l | KR003E | 2024-05-29T12:03:15.702Z | 2024-06-06T12:14:24.545Z |
4385145 | 4385145 | 20240528142343_BN7AU | KR003E | 2024-05-29T12:02:57.490Z | 2024-06-06T12:14:24.200Z |
4369891 | 4369891 | 20240518165209_mrNeJ | KR003E | 2024-05-26T12:08:40.389Z | 2024-05-26T12:09:53.380Z |
4346448 | 4346448 | 20240510172222_eFguW | KR003E | 2024-05-20T12:04:36.504Z | 2024-05-22T12:10:32.887Z |
4346334 | 4346334 | 20240510171726_hmQLw | KR003E | 2024-05-20T12:04:27.594Z | 2024-05-22T12:10:30.965Z |
4346209 | 4346209 | 20240510170924_nKHFN | KR003E | 2024-05-20T12:04:18.103Z | 2024-05-22T12:10:28.605Z |
4328567 | 4328567 | 20240508175602_1jw6s | KR003E | 2024-05-17T12:07:53.371Z | 2024-05-19T12:14:02.494Z |
4327385 | 4327385 | 20240508171705_FiBgF | KR003E | 2024-05-17T12:06:58.177Z | 2024-05-19T12:13:42.186Z |
4325991 | 4325991 | 20240508160853_1WusT | KR003E | 2024-05-17T12:05:09.715Z | 2024-05-19T12:13:15.766Z |
4325736 | 4325736 | 20240508155313_x6mCH | KR003E | 2024-05-17T12:04:50.144Z | 2024-05-19T12:13:10.900Z |
4282814 | 4282814 | 20240503182428_ALH9B | KR003E | 2024-05-06T12:10:57.188Z | 2024-05-12T12:18:40.069Z |
4095708 | 4095708 | 20240319193128_Y8OZV | KR003E | 2024-03-21T12:12:36.778Z | 2024-03-28T12:20:30.652Z |
4094395 | 4094395 | 20240319180109_7Bzkn | KR003E | 2024-03-21T12:07:18.986Z | 2024-03-28T12:20:23.928Z |
4070872 | 4070872 | 20240314200641_31WFx | KR003E | 2024-03-16T12:05:33.675Z | 2024-03-23T12:25:37.866Z |
4070822 | 4070822 | 20240314194901_tS7oI | KR003E | 2024-03-16T12:05:22.346Z | 2024-03-23T12:25:36.807Z |
4056926 | 4056926 | 20240309204546_SzMlo | KR003E | 2024-03-11T12:08:43.994Z | 2024-03-18T12:19:59.010Z |
4056836 | 4056836 | 20240309203517_SmsMg | KR003E | 2024-03-11T12:08:36.215Z | 2024-03-18T12:19:58.169Z |
4056823 | 4056823 | 20240309203436_h7mft | KR003E | 2024-03-11T12:08:35.704Z | 2024-03-18T12:19:58.038Z |
4056557 | 4056557 | 20240309195542_r6HXv | KR003E | 2024-03-11T12:08:21.366Z | 2024-03-18T12:19:55.548Z |
4056363 | 4056363 | 20240309192105_3zsLp | KR003E | 2024-03-11T12:08:02.558Z | 2024-03-18T12:19:53.411Z |
4056227 | 4056227 | 20240309185015_f1cyj | KR003E | 2024-03-11T12:07:43.594Z | 2024-03-18T12:19:52.174Z |
4056208 | 4056208 | 20240309184752_Yp6KC | KR003E | 2024-03-11T12:07:42.567Z | 2024-03-18T12:19:52.069Z |
4050978 | 4050978 | 20240308191339_QOzsN | KR003E | 2024-03-10T12:07:53.985Z | 2024-03-17T12:18:13.618Z |
4050795 | 4050795 | 20240308182711_99gSs | KR003E | 2024-03-10T12:07:34.335Z | 2024-03-17T12:18:11.990Z |
4044885 | 4044885 | 20240307194454_Hna0j | KR003E | 2024-03-09T14:06:42.254Z | 2024-03-16T12:21:28.385Z |
3985371 | 3985371 | 20240217194243_jgN82 | KR003E | 2024-02-19T14:05:28.365Z | 2024-02-26T14:16:33.005Z |
3975624 | 3975624 | 20240215203616_whQy0 | KR003E | 2024-02-17T14:05:16.158Z | 2024-02-24T14:23:18.766Z |
3943107 | 3943107 | 20240209190402_dhbur | KR003E | 2024-02-11T14:05:02.592Z | 2024-02-18T14:22:07.141Z |
3940971 | 3940971 | 20240209110003_m74yb | KR003E | 2024-02-10T14:12:55.103Z | 2024-02-17T14:26:30.531Z |
3896137 | 3896137 | 20240129145605_pNOwN | KR003E | 2024-01-30T14:07:22.796Z | 2024-02-06T14:21:02.826Z |
3895618 | 3895618 | 20240129120309_6DmYk | KR003E | 2024-01-30T14:06:06.576Z | 2024-02-06T14:20:56.810Z |
3884649 | 3884649 | 20240123212411_4EA1z | KR003E | 2024-01-26T14:03:50.937Z | 2024-02-01T14:17:50.415Z |
3883353 | 3883353 | 20240123203041_z10LJ | KR003E | 2024-01-25T14:10:56.073Z | 2024-01-31T14:18:46.331Z |
3882711 | 3882711 | 20240123210151_r9zkj | KR003E | 2024-01-25T14:09:35.919Z | 2024-02-01T14:17:49.089Z |
3882700 | 3882700 | 20240123205815_pEnQT | KR003E | 2024-01-25T14:09:35.029Z | 2024-02-01T14:17:49.000Z |
3882642 | 3882642 | 20240122205617_S86pB | KR003E | 2024-01-25T14:09:26.051Z | 2024-01-30T14:19:42.027Z |
3882612 | 3882612 | 20240122204743_Pguyq | KR003E | 2024-01-25T14:09:20.535Z | 2024-01-30T14:19:41.367Z |
3882510 | 3882510 | 20240122200658_IYkOl | KR003E | 2024-01-25T14:08:59.939Z | 2024-01-30T14:19:38.141Z |
3843823 | 3843823 | 20240116150318_2q6p2 | KR003E | 2024-01-19T14:11:19.899Z | 2024-01-25T14:22:12.444Z |
3837721 | 3837721 | 20240115211446_OkLIh | KR003E | 2024-01-18T14:14:46.744Z | 2024-01-24T14:19:16.866Z |
3837356 | 3837356 | 20240115204654_hiisr | KR003E | 2024-01-18T14:14:17.789Z | 2024-01-24T14:19:14.006Z |
3837131 | 3837131 | 20240115201949_QlEnu | KR003E | 2024-01-18T14:14:07.407Z | 2024-01-24T14:19:12.691Z |
3836655 | 3836655 | 20240115194309_oJqiu | KR003E | 2024-01-18T14:13:49.441Z | 2024-01-24T14:19:10.376Z |
3836191 | 3836191 | 20240115185840_abXjq | KR003E | 2024-01-18T14:13:15.188Z | 2024-01-24T14:19:07.287Z |
3835918 | 3835918 | 20240115183035_28dKp | KR003E | 2024-01-18T14:12:53.006Z | 2024-01-24T14:19:05.979Z |
3835157 | 3835157 | 20240115164723_3vXy5 | KR003E | 2024-01-18T14:11:47.949Z | 2024-01-24T14:19:01.482Z |
3835140 | 3835140 | 20240115164435_CnT9r | KR003E | 2024-01-18T14:11:46.785Z | 2024-01-24T14:19:01.396Z |
3835103 | 3835103 | 20240115162930_IjiLc | KR003E | 2024-01-18T14:11:41.102Z | 2024-01-24T14:19:01.154Z |
3835042 | 3835042 | 20240115161956_iKF4L | KR003E | 2024-01-18T14:11:34.139Z | 2024-01-24T14:19:00.912Z |
3834907 | 3834907 | 20240115154424_JRYQo | KR003E | 2024-01-18T14:11:13.315Z | 2024-01-24T14:19:00.571Z |
3834573 | 3834573 | 20240115150139_LV2cV | KR003E | 2024-01-18T14:10:49.045Z | 2024-01-24T14:18:58.814Z |
3834477 | 3834477 | 20240115144254_0Axac | KR003E | 2024-01-18T14:10:40.267Z | 2024-01-24T14:18:57.781Z |
3834360 | 3834360 | 20240115142606_Yfpe6 | KR003E | 2024-01-18T14:10:17.981Z | 2024-01-24T14:18:57.402Z |
3833842 | 3833842 | 20240115130123_rUvl3 | KR003E | 2024-01-18T14:09:13.392Z | 2024-01-24T14:18:54.086Z |
3833437 | 3833437 | 20240115121826_V5OhN | KR003E | 2024-01-18T14:08:25.802Z | 2024-01-24T14:18:50.822Z |
3830488 | 3830488 | 20240114204639_JcPGm | KR003E | 2024-01-17T14:13:38.330Z | 2024-01-23T14:25:21.325Z |
3830455 | 3830455 | 20240114203459_BlRWi | KR003E | 2024-01-17T14:13:36.497Z | 2024-01-23T14:25:20.919Z |
3830297 | 3830297 | 20240114200837_Fo85V | KR003E | 2024-01-17T14:13:27.089Z | 2024-01-23T14:25:19.670Z |
3830271 | 3830271 | 20240114200451_yeRxq | KR003E | 2024-01-17T14:13:23.371Z | 2024-01-23T14:25:19.355Z |
3822011 | 3822011 | 20240113212401_D2wfA | KR003E | 2024-01-16T14:13:42.527Z | 2024-01-22T14:23:16.949Z |
3822003 | 3822003 | 20240113212149_B3PXl | KR003E | 2024-01-16T14:13:41.645Z | 2024-01-22T14:23:16.754Z |
3821978 | 3821978 | 20240113211912_13pdR | KR003E | 2024-01-16T14:13:40.441Z | 2024-01-22T14:23:16.560Z |
3821963 | 3821963 | 20240113211354_e33bG | KR003E | 2024-01-16T14:13:39.847Z | 2024-01-22T14:23:16.457Z |
3821839 | 3821839 | 20240113205810_fazkX | KR003E | 2024-01-16T14:13:34.447Z | 2024-01-22T14:23:15.917Z |
3821827 | 3821827 | 20240113205715_sF4yJ | KR003E | 2024-01-16T14:13:33.904Z | 2024-01-22T14:23:15.752Z |
3821691 | 3821691 | 20240113203018_NPzhu | KR003E | 2024-01-16T14:13:27.072Z | 2024-01-22T14:23:14.488Z |
3821684 | 3821684 | 20240113202702_slv24 | KR003E | 2024-01-16T14:13:26.358Z | 2024-01-22T14:23:14.437Z |
3821654 | 3821654 | 20240113202534_KUN2r | KR003E | 2024-01-16T14:13:24.503Z | 2024-01-22T14:23:13.364Z |
3821617 | 3821617 | 20240113202210_vczbS | KR003E | 2024-01-16T14:13:22.497Z | 2024-01-22T14:23:13.091Z |
3821555 | 3821555 | 20240113201519_3IwvP | KR003E | 2024-01-16T14:13:19.244Z | 2024-01-22T14:23:12.774Z |
3821534 | 3821534 | 20240113201213_TPy4a | KR003E | 2024-01-16T14:13:17.314Z | 2024-01-22T14:23:12.452Z |
3821392 | 3821392 | 20240113195634_vqzuG | KR003E | 2024-01-16T14:12:59.736Z | 2024-01-22T14:23:11.232Z |
3821059 | 3821059 | 20240113191421_c3D0a | KR003E | 2024-01-16T14:12:33.019Z | 2024-01-22T14:23:09.087Z |
3820854 | 3820854 | 20240113184401_yPRZb | KR003E | 2024-01-16T14:12:16.948Z | 2024-01-22T14:23:07.557Z |
3820816 | 3820816 | 20240113183648_jk3sn | KR003E | 2024-01-16T14:12:10.128Z | 2024-01-22T14:23:06.717Z |
3820800 | 3820800 | 20240113183311_I2j1S | KR003E | 2024-01-16T14:12:07.187Z | 2024-01-22T14:23:06.052Z |
3820657 | 3820657 | 20240113181205_3YbYX | KR003E | 2024-01-16T14:11:51.745Z | 2024-01-22T14:23:04.290Z |
3820504 | 3820504 | 20240113175723_RHJ9S | KR003E | 2024-01-16T14:11:43.590Z | 2024-01-22T14:23:02.588Z |
3820360 | 3820360 | 20240113173351_mMoHd | KR003E | 2024-01-16T14:11:36.097Z | 2024-01-22T14:23:01.670Z |
3820177 | 3820177 | 20240113170702_E2WT7 | KR003E | 2024-01-16T14:11:16.381Z | 2024-01-22T14:22:59.687Z |
3820137 | 3820137 | 20240113170209_gemk9 | KR003E | 2024-01-16T14:11:12.369Z | 2024-01-22T14:22:59.315Z |
3820016 | 3820016 | 20240113164130_bIdOt | KR003E | 2024-01-16T14:10:53.238Z | 2024-01-22T14:22:57.754Z |
3819930 | 3819930 | 20240113160546_fkT4J | KR003E | 2024-01-16T14:10:44.041Z | 2024-01-22T14:22:56.737Z |
3819232 | 3819232 | 20240113144024_qaB7o | KR003E | 2024-01-16T14:09:44.021Z | 2024-01-22T14:22:51.598Z |
3819155 | 3819155 | 20240113143137_mBPSJ | KR003E | 2024-01-16T14:09:37.760Z | 2024-01-22T14:22:50.665Z |
3818933 | 3818933 | 20240113140037_K1XYz | KR003E | 2024-01-16T14:09:05.076Z | 2024-01-22T14:22:48.630Z |
3812906 | 3812906 | 20240112180355_9f06H | KR003E | 2024-01-15T14:12:26.640Z | 2024-01-21T14:27:51.844Z |
3812676 | 3812676 | 20240112172619_u4Bzc | KR003E | 2024-01-15T14:12:12.827Z | 2024-01-21T14:27:51.096Z |
3812620 | 3812620 | 20240112171604_umhNT | KR003E | 2024-01-15T14:12:10.741Z | 2024-01-21T14:27:50.956Z |
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);