participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,475 rows where station_code = "KR001G" 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 |
---|---|---|---|---|---|
4963038 | 4963038 | 20240811193846_Pvw2P | KR001G | 2024-09-04T12:05:07.538Z | 2024-09-06T12:04:15.756Z |
4963012 | 4963012 | 20240811193728_VqDim | KR001G | 2024-09-04T12:05:06.359Z | 2024-09-06T12:04:15.000Z |
4962928 | 4962928 | 20240811193230_e54uq | KR001G | 2024-09-04T12:04:59.905Z | 2024-09-06T12:04:11.631Z |
4962847 | 4962847 | 20240811192742_3xoy0 | KR001G | 2024-09-04T12:04:55.426Z | 2024-09-06T12:04:08.487Z |
4962837 | 4962837 | 20240811192639_iq39N | KR001G | 2024-09-04T12:04:54.984Z | 2024-09-06T12:04:08.222Z |
4962820 | 4962820 | 20240811192551_pDlLW | KR001G | 2024-09-04T12:04:54.499Z | 2024-09-06T12:04:07.790Z |
4962801 | 4962801 | 20240811192418_rUoAd | KR001G | 2024-09-04T12:04:53.218Z | 2024-09-06T12:04:03.743Z |
4962728 | 4962728 | 20240811191919_q3yga | KR001G | 2024-09-04T12:04:49.017Z | 2024-09-06T12:04:00.051Z |
4962646 | 4962646 | 20240811191417_mUVJI | KR001G | 2024-09-04T12:04:45.156Z | 2024-09-06T12:03:54.683Z |
4962600 | 4962600 | 20240811191139_ab83S | KR001G | 2024-09-04T12:04:43.196Z | 2024-09-06T12:03:53.193Z |
4962544 | 4962544 | 20240811190720_Ar0Bg | KR001G | 2024-09-04T12:04:38.238Z | 2024-09-06T12:03:50.685Z |
4962445 | 4962445 | 20240811185800_TB0zf | KR001G | 2024-09-04T12:04:30.996Z | 2024-09-06T12:03:46.607Z |
4962338 | 4962338 | 20240811184955_jPdhX | KR001G | 2024-09-04T12:04:26.005Z | 2024-09-06T12:03:42.664Z |
4962294 | 4962294 | 20240811184658_kFUDO | KR001G | 2024-09-04T12:04:24.203Z | 2024-09-06T12:03:40.313Z |
4962281 | 4962281 | 20240811184618_UKP3O | KR001G | 2024-09-04T12:04:23.800Z | 2024-09-06T12:03:38.957Z |
4962271 | 4962271 | 20240811184529_vKJKJ | KR001G | 2024-09-04T12:04:23.363Z | 2024-09-06T12:03:37.899Z |
4962195 | 4962195 | 20240811184116_Dmsz2 | KR001G | 2024-09-04T12:04:20.705Z | 2024-09-06T12:03:33.177Z |
4962101 | 4962101 | 20240811183548_hBCQ2 | KR001G | 2024-09-04T12:04:16.471Z | 2024-09-06T12:03:29.557Z |
4962084 | 4962084 | 20240811183403_5UkY5 | KR001G | 2024-09-04T12:04:15.489Z | 2024-09-06T12:03:27.660Z |
4962068 | 4962068 | 20240811183328_7Swy3 | KR001G | 2024-09-04T12:04:14.730Z | 2024-09-06T12:03:26.678Z |
4962061 | 4962061 | 20240811183310_mNLw2 | KR001G | 2024-09-04T12:04:14.400Z | 2024-09-06T12:03:26.283Z |
4961977 | 4961977 | 20240811182116_KDAKB | KR001G | 2024-09-04T12:04:06.487Z | 2024-09-06T12:03:22.316Z |
4961955 | 4961955 | 20240811182017_5XgG1 | KR001G | 2024-09-04T12:04:05.734Z | 2024-09-06T12:03:21.729Z |
4961947 | 4961947 | 20240811181952_FWTFq | KR001G | 2024-09-04T12:04:05.375Z | 2024-09-06T12:03:21.481Z |
4961927 | 4961927 | 20240811181808_3IjaI | KR001G | 2024-09-04T12:04:04.479Z | 2024-09-06T12:03:20.836Z |
4961862 | 4961862 | 20240811181115_UniBQ | KR001G | 2024-09-04T12:03:59.376Z | 2024-09-06T12:03:17.921Z |
4961793 | 4961793 | 20240811180440_Z6f8R | KR001G | 2024-09-04T12:03:56.029Z | 2024-09-06T12:03:15.259Z |
4961658 | 4961658 | 20240811175420_3KJNQ | KR001G | 2024-09-04T12:03:49.112Z | 2024-09-06T12:03:09.004Z |
4961559 | 4961559 | 20240811174750_rrFGL | KR001G | 2024-09-04T12:03:45.304Z | 2024-09-06T12:03:05.170Z |
4961430 | 4961430 | 20240811174058_m2M15 | KR001G | 2024-09-04T12:03:38.274Z | 2024-09-06T12:02:57.914Z |
4961356 | 4961356 | 20240811173338_P4EyK | KR001G | 2024-09-04T12:03:33.033Z | 2024-09-06T12:02:53.532Z |
4961323 | 4961323 | 20240811173059_tfKoV | KR001G | 2024-09-04T12:03:29.879Z | 2024-09-06T12:02:52.111Z |
4961248 | 4961248 | 20240811172648_CMXgl | KR001G | 2024-09-04T12:03:24.731Z | 2024-09-06T12:02:49.169Z |
4961240 | 4961240 | 20240811172602_7dP2N | KR001G | 2024-09-04T12:03:24.213Z | 2024-09-06T12:02:48.748Z |
4961162 | 4961162 | 20240811172039_2jzmZ | KR001G | 2024-09-04T12:03:20.696Z | 2024-09-06T12:02:45.847Z |
4961096 | 4961096 | 20240811171701_tkw6r | KR001G | 2024-09-04T12:03:17.245Z | 2024-09-06T12:02:43.633Z |
4961034 | 4961034 | 20240811171226_cRPGJ | KR001G | 2024-09-04T12:03:13.150Z | 2024-09-06T12:02:40.436Z |
4960959 | 4960959 | 20240811170604_6ul1n | KR001G | 2024-09-04T12:03:08.074Z | 2024-09-06T12:02:37.113Z |
4960932 | 4960932 | 20240811170336_8E3ZT | KR001G | 2024-09-04T12:03:06.562Z | 2024-09-06T12:02:33.863Z |
4960798 | 4960798 | 20240811164900_Z9NYv | KR001G | 2024-09-04T12:02:55.537Z | 2024-09-06T12:02:26.884Z |
4960492 | 4960492 | 20240811162827_MOUPY | KR001G | 2024-09-04T12:02:36.415Z | 2024-09-06T12:02:13.370Z |
4959343 | 4959343 | 20240811145444_xG2c4 | KR001G | 2024-09-04T12:01:26.672Z | 2024-09-06T12:01:12.192Z |
4959231 | 4959231 | 20240811122135_ORli2 | KR001G | 2024-09-03T12:23:11.271Z | 2024-09-06T12:32:37.485Z |
4951991 | 4951991 | 20240811145146_WiM2V | KR001G | 2024-09-03T12:01:42.089Z | 2024-09-06T12:01:10.125Z |
4951882 | 4951882 | 20240811144116_bs1dL | KR001G | 2024-09-03T12:01:32.545Z | 2024-09-06T12:01:03.796Z |
4951874 | 4951874 | 20240811144106_WvwWv | KR001G | 2024-09-03T12:01:31.582Z | 2024-09-06T12:01:03.259Z |
4951590 | 4951590 | 20240811140355_zwxeO | KR001G | 2024-09-03T12:01:10.606Z | 2024-09-06T12:00:49.099Z |
4951517 | 4951517 | 20240811135801_yAbpF | KR001G | 2024-09-03T12:01:06.771Z | 2024-09-06T12:00:47.110Z |
4935084 | 4935084 | 20240810193604_Q3e9v | KR001G | 2024-09-01T12:06:04.107Z | 2024-09-06T12:20:26.977Z |
4934991 | 4934991 | 20240810192548_NJf5J | KR001G | 2024-09-01T12:05:59.792Z | 2024-09-06T12:20:25.085Z |
4934987 | 4934987 | 20240810192530_hciXB | KR001G | 2024-09-01T12:05:59.561Z | 2024-09-06T12:20:24.961Z |
4934817 | 4934817 | 20240810190727_3pA3e | KR001G | 2024-09-01T12:05:50.498Z | 2024-09-06T12:20:21.159Z |
4934797 | 4934797 | 20240810190435_ntim3 | KR001G | 2024-09-01T12:05:47.688Z | 2024-09-06T12:20:20.801Z |
4934685 | 4934685 | 20240810184817_2J1Mp | KR001G | 2024-09-01T12:05:38.835Z | 2024-09-06T12:20:17.835Z |
4934629 | 4934629 | 20240810184049_bYAA7 | KR001G | 2024-09-01T12:05:35.931Z | 2024-09-06T12:20:16.794Z |
4934620 | 4934620 | 20240810183948_zx5pm | KR001G | 2024-09-01T12:05:35.540Z | 2024-09-06T12:20:16.628Z |
4934561 | 4934561 | 20240810183132_D5LV0 | KR001G | 2024-09-01T12:05:31.390Z | 2024-09-06T12:20:14.923Z |
4934550 | 4934550 | 20240810182919_TLvKy | KR001G | 2024-09-01T12:05:30.570Z | 2024-09-06T12:20:14.660Z |
4934528 | 4934528 | 20240810182632_0fZpR | KR001G | 2024-09-01T12:05:29.172Z | 2024-09-06T12:20:14.102Z |
4934524 | 4934524 | 20240810182632_RK0hK | KR001G | 2024-09-01T12:05:29.024Z | 2024-09-06T12:20:14.084Z |
4934498 | 4934498 | 20240810182336_r6PMX | KR001G | 2024-09-01T12:05:27.109Z | 2024-09-06T12:20:13.168Z |
4934200 | 4934200 | 20240810175313_22BAN | KR001G | 2024-09-01T12:05:02.170Z | 2024-09-06T12:20:02.088Z |
4934113 | 4934113 | 20240810174647_EZEuB | KR001G | 2024-09-01T12:04:57.812Z | 2024-09-06T12:19:58.711Z |
4933917 | 4933917 | 20240810173251_ZKyd9 | KR001G | 2024-09-01T12:04:46.105Z | 2024-09-06T12:19:41.797Z |
4933799 | 4933799 | 20240810172756_ViyQr | KR001G | 2024-09-01T12:04:39.098Z | 2024-09-06T12:19:36.121Z |
4932617 | 4932617 | 20240810160914_SMiqN | KR001G | 2024-09-01T12:03:29.761Z | 2024-09-06T12:18:43.357Z |
4924891 | 4924891 | 20240810142001_dKJCk | KR001G | 2024-08-31T12:02:40.291Z | 2024-09-06T12:17:15.117Z |
4924816 | 4924816 | 20240810141423_WyPxG | KR001G | 2024-08-31T12:02:34.258Z | 2024-09-06T12:17:13.041Z |
4911058 | 4911058 | 20240809191839_hH3je | KR001G | 2024-08-29T12:06:56.275Z | 2024-09-02T12:21:15.805Z |
4911010 | 4911010 | 20240809191209_4vAPy | KR001G | 2024-08-29T12:06:52.881Z | 2024-09-02T12:21:14.103Z |
4910856 | 4910856 | 20240809184947_67zLY | KR001G | 2024-08-29T12:06:43.073Z | 2024-09-02T12:21:09.280Z |
4910774 | 4910774 | 20240809183956_ct4je | KR001G | 2024-08-29T12:06:38.695Z | 2024-09-02T12:21:06.663Z |
4910751 | 4910751 | 20240809183709_wh0xI | KR001G | 2024-08-29T12:06:37.080Z | 2024-09-02T12:21:05.711Z |
4910060 | 4910060 | 20240809173854_OzfIG | KR001G | 2024-08-29T12:05:46.594Z | 2024-09-02T12:20:29.817Z |
4909883 | 4909883 | 20240809172727_LAlKQ | KR001G | 2024-08-29T12:05:37.614Z | 2024-09-02T12:20:25.890Z |
4909798 | 4909798 | 20240809172224_zdUiE | KR001G | 2024-08-29T12:05:31.713Z | 2024-09-02T12:20:23.320Z |
4909792 | 4909792 | 20240809172144_yk7oL | KR001G | 2024-08-29T12:05:31.194Z | 2024-09-02T12:20:22.980Z |
4909291 | 4909291 | 20240809164814_8vGH3 | KR001G | 2024-08-29T12:04:57.875Z | 2024-09-02T12:19:52.681Z |
4909243 | 4909243 | 20240809164223_CM7M2 | KR001G | 2024-08-29T12:04:55.132Z | 2024-09-02T12:19:50.835Z |
4909197 | 4909197 | 20240809163922_4seBg | KR001G | 2024-08-29T12:04:52.392Z | 2024-09-02T12:19:49.069Z |
4908640 | 4908640 | 20240809155227_xoKbW | KR001G | 2024-08-29T12:04:18.240Z | 2024-09-02T12:19:19.603Z |
4908163 | 4908163 | 20240809151901_YTcwA | KR001G | 2024-08-29T12:03:48.352Z | 2024-09-02T12:19:03.859Z |
4907953 | 4907953 | 20240809150603_7U9ry | KR001G | 2024-08-29T12:03:34.357Z | 2024-09-02T12:18:48.978Z |
4907575 | 4907575 | 20240809143115_20xfa | KR001G | 2024-08-29T12:03:10.610Z | 2024-09-02T12:18:34.342Z |
4906877 | 4906877 | 20240809132219_Vz2Mo | KR001G | 2024-08-29T12:02:22.524Z | 2024-09-02T12:18:00.728Z |
4896876 | 4896876 | 20240807163453_Gvuzb | KR001G | 2024-08-28T12:14:50.406Z | 2024-08-28T12:14:50.406Z |
4896807 | 4896807 | 20240807162417_H46Lm | KR001G | 2024-08-28T12:14:47.405Z | 2024-08-28T12:14:47.405Z |
4895309 | 4895309 | 20240807115752_HTv6g | KR001G | 2024-08-28T12:13:16.079Z | 2024-08-28T12:13:16.079Z |
4889088 | 4889088 | 20240808194622_2KXtv | KR001G | 2024-08-28T12:05:36.409Z | 2024-08-30T12:18:50.888Z |
4889060 | 4889060 | 20240808193955_yvOud | KR001G | 2024-08-28T12:05:34.042Z | 2024-08-30T12:18:49.429Z |
4888945 | 4888945 | 20240808192311_X9y08 | KR001G | 2024-08-28T12:05:20.948Z | 2024-08-30T12:18:44.273Z |
4888453 | 4888453 | 20240808175725_crygK | KR001G | 2024-08-28T12:04:40.482Z | 2024-08-30T12:18:12.825Z |
4887591 | 4887591 | 20240808162600_jOzzU | KR001G | 2024-08-28T12:03:36.076Z | 2024-08-30T12:17:33.450Z |
4871021 | 4871021 | 20240806184422_bNIr5 | KR001G | 2024-08-19T12:08:27.741Z | 2024-08-27T12:09:14.774Z |
4870318 | 4870318 | 20240806175627_YynLT | KR001G | 2024-08-19T12:07:48.474Z | 2024-08-27T12:08:42.877Z |
4869722 | 4869722 | 20240806172816_ey0Wl | KR001G | 2024-08-19T12:07:16.519Z | 2024-08-27T12:08:16.195Z |
4869710 | 4869710 | 20240806172750_6h7Co | KR001G | 2024-08-19T12:07:16.026Z | 2024-08-27T12:08:15.759Z |
4867733 | 4867733 | 20240806170059_smPpP | KR001G | 2024-08-18T12:08:55.693Z | 2024-08-27T12:07:50.902Z |
4867701 | 4867701 | 20240806165917_WEaLK | KR001G | 2024-08-18T12:08:54.564Z | 2024-08-27T12:07:49.721Z |
4866609 | 4866609 | 20240806155804_pNp90 | KR001G | 2024-08-18T12:07:44.560Z | 2024-08-27T12:07:03.324Z |
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);