participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
661 rows where station_code = "KR002N" 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 |
---|---|---|---|---|---|
5438816 | 5438816 | 20241030180955_kV6kb | KR002N | 2024-11-01T12:12:28.970Z | 2024-11-03T14:22:44.474Z |
5438483 | 5438483 | 20241030172400_8jxuC | KR002N | 2024-11-01T12:11:46.514Z | 2024-11-03T14:22:42.977Z |
5438415 | 5438415 | 20241030171525_meMpz | KR002N | 2024-11-01T12:11:40.793Z | 2024-11-03T14:22:42.769Z |
5361705 | 5361705 | 20241023183846_oXgf8 | KR002N | 2024-10-25T12:13:14.722Z | 2024-11-01T12:26:50.485Z |
5361648 | 5361648 | 20241023183303_GYkh6 | KR002N | 2024-10-25T12:13:04.515Z | 2024-11-01T12:26:50.404Z |
5359368 | 5359368 | 20241023132036_QseRs | KR002N | 2024-10-25T12:08:28.262Z | 2024-11-01T12:26:45.499Z |
5322930 | 5322930 | 20241019192213_tAwkX | KR002N | 2024-10-20T12:03:33.510Z | 2024-10-28T12:26:42.187Z |
5322897 | 5322897 | 20241019182231_lK3w2 | KR002N | 2024-10-20T12:03:28.402Z | 2024-10-28T12:26:41.630Z |
5322893 | 5322893 | 20241019181947_QcDWK | KR002N | 2024-10-20T12:03:27.758Z | 2024-10-28T12:26:41.577Z |
5322888 | 5322888 | 20241019181250_DVdap | KR002N | 2024-10-20T12:03:26.915Z | 2024-10-28T12:26:41.555Z |
5299920 | 5299920 | 20241012194831_B6U2U | KR002N | 2024-10-14T12:13:17.995Z | 2024-10-21T12:23:45.029Z |
5299800 | 5299800 | 20241012193230_583FB | KR002N | 2024-10-14T12:13:09.693Z | 2024-10-21T12:23:43.800Z |
5299692 | 5299692 | 20241012192115_X0sDt | KR002N | 2024-10-14T12:12:54.059Z | 2024-10-21T12:23:43.122Z |
5299146 | 5299146 | 20241012181016_7yaGY | KR002N | 2024-10-14T12:11:57.780Z | 2024-10-21T12:23:34.941Z |
5298921 | 5298921 | 20241012173435_TivEY | KR002N | 2024-10-14T12:11:18.683Z | 2024-10-21T12:23:32.743Z |
5298504 | 5298504 | 20241012162656_hA8gF | KR002N | 2024-10-14T12:10:28.904Z | 2024-10-21T12:23:27.639Z |
5298428 | 5298428 | 20241012161934_yiVf2 | KR002N | 2024-10-14T12:10:19.992Z | 2024-10-21T12:23:27.450Z |
5298338 | 5298338 | 20241012161113_jOuzw | KR002N | 2024-10-14T12:10:12.183Z | 2024-10-21T12:23:26.726Z |
5297867 | 5297867 | 20241012144902_ihXK2 | KR002N | 2024-10-14T12:09:16.047Z | 2024-10-21T12:23:23.216Z |
5297817 | 5297817 | 20241012144141_VAj12 | KR002N | 2024-10-14T12:09:12.915Z | 2024-10-21T12:23:23.034Z |
5297320 | 5297320 | 20241012124510_Csb0W | KR002N | 2024-10-14T12:08:07.914Z | 2024-10-21T12:23:16.859Z |
5232863 | 5232863 | 20241004182753_lACyQ | KR002N | 2024-10-06T12:12:30.819Z | 2024-10-13T12:26:19.873Z |
5232692 | 5232692 | 20241004175007_1zPIY | KR002N | 2024-10-06T12:12:12.667Z | 2024-10-13T12:26:19.591Z |
5232623 | 5232623 | 20241004173018_rsi5g | KR002N | 2024-10-06T12:12:08.242Z | 2024-10-13T12:26:19.480Z |
5232574 | 5232574 | 20241004171831_DWEQz | KR002N | 2024-10-06T12:12:04.999Z | 2024-10-13T12:26:19.404Z |
5232160 | 5232160 | 20241004162329_Kh9jz | KR002N | 2024-10-06T12:11:27.618Z | 2024-10-13T12:26:18.872Z |
5231584 | 5231584 | 20241004145458_In3YP | KR002N | 2024-10-06T12:10:32.275Z | 2024-10-13T12:26:18.017Z |
5231428 | 5231428 | 20241004143106_GS63M | KR002N | 2024-10-06T12:10:21.299Z | 2024-10-13T12:26:17.875Z |
5224303 | 5224303 | 20241003202303_XoTf6 | KR002N | 2024-10-05T12:18:23.383Z | 2024-10-12T12:25:07.973Z |
5224153 | 5224153 | 20241003200934_lrlQE | KR002N | 2024-10-05T12:18:13.156Z | 2024-10-12T12:25:07.654Z |
5224034 | 5224034 | 20241003200038_dKmje | KR002N | 2024-10-05T12:18:07.934Z | 2024-10-12T12:25:07.210Z |
5224011 | 5224011 | 20241003195804_P3yH2 | KR002N | 2024-10-05T12:18:06.535Z | 2024-10-12T12:25:07.165Z |
5223931 | 5223931 | 20241003195000_XQnO7 | KR002N | 2024-10-05T12:17:58.382Z | 2024-10-12T12:25:07.132Z |
5223742 | 5223742 | 20241003192616_2uGz8 | KR002N | 2024-10-05T12:17:29.499Z | 2024-10-12T12:25:06.926Z |
5223679 | 5223679 | 20241003191958_Hw5us | KR002N | 2024-10-05T12:17:25.324Z | 2024-10-12T12:25:06.897Z |
5223306 | 5223306 | 20241003172308_Eo4Q2 | KR002N | 2024-10-05T12:16:45.679Z | 2024-10-12T12:25:05.324Z |
5209546 | 5209546 | 20241001153852_239Wh | KR002N | 2024-10-03T12:13:29.793Z | 2024-10-10T12:24:43.167Z |
5209528 | 5209528 | 20241001153020_IGAj0 | KR002N | 2024-10-03T12:13:28.558Z | 2024-10-10T12:24:43.113Z |
5209479 | 5209479 | 20241001151333_2vb1W | KR002N | 2024-10-03T12:13:21.854Z | 2024-10-10T12:24:43.057Z |
5209382 | 5209382 | 20241001140539_TKO8B | KR002N | 2024-10-03T12:12:59.319Z | 2024-10-10T12:24:42.812Z |
5209378 | 5209378 | 20241001140456_RQ0Qb | KR002N | 2024-10-03T12:12:58.858Z | 2024-10-10T12:24:42.801Z |
5209092 | 5209092 | 20241002201904_1WTKI | KR002N | 2024-10-03T12:09:52.193Z | 2024-10-11T12:23:32.340Z |
5209054 | 5209054 | 20241002194354_bEvof | KR002N | 2024-10-03T12:09:47.105Z | 2024-10-11T12:23:31.752Z |
5209043 | 5209043 | 20241002194121_ufTG7 | KR002N | 2024-10-03T12:09:46.207Z | 2024-10-11T12:23:31.708Z |
5208941 | 5208941 | 20241002182959_2enLW | KR002N | 2024-10-03T12:09:35.106Z | 2024-10-11T12:23:30.856Z |
5208931 | 5208931 | 20241002182410_UT38f | KR002N | 2024-10-03T12:09:34.553Z | 2024-10-11T12:23:30.707Z |
5208917 | 5208917 | 20241002181559_DUcEa | KR002N | 2024-10-03T12:09:33.136Z | 2024-10-11T12:23:30.685Z |
5208900 | 5208900 | 20241002180411_YN3Od | KR002N | 2024-10-03T12:09:31.846Z | 2024-10-11T12:23:30.671Z |
5208887 | 5208887 | 20241002175830_Jb7B0 | KR002N | 2024-10-03T12:09:30.351Z | 2024-10-11T12:23:30.647Z |
5208830 | 5208830 | 20241002173443_vOUMd | KR002N | 2024-10-03T12:09:21.132Z | 2024-10-11T12:23:30.562Z |
5208825 | 5208825 | 20241002173315_Z579T | KR002N | 2024-10-03T12:09:20.908Z | 2024-10-11T12:23:30.559Z |
5208555 | 5208555 | 20241002141131_6f3Th | KR002N | 2024-10-03T12:08:36.479Z | 2024-10-11T12:23:29.991Z |
5208527 | 5208527 | 20241002134529_p3Ah6 | KR002N | 2024-10-03T12:08:28.699Z | 2024-10-11T12:23:29.750Z |
5208480 | 5208480 | 20241002132104_qkxFb | KR002N | 2024-10-03T12:08:21.084Z | 2024-10-11T12:23:29.636Z |
5208458 | 5208458 | 20241002124259_2Kd2A | KR002N | 2024-10-03T12:08:16.735Z | 2024-10-11T12:23:29.566Z |
5208448 | 5208448 | 20241002123522_kG36h | KR002N | 2024-10-03T12:08:15.643Z | 2024-10-11T12:23:29.540Z |
5173311 | 5173311 | 20240927143859_BpE7V | KR002N | 2024-09-28T12:12:08.577Z | 2024-10-05T12:28:55.378Z |
5167681 | 5167681 | 20240926142113_CvsV3 | KR002N | 2024-09-27T12:05:31.488Z | 2024-10-04T12:25:29.048Z |
5149799 | 5149799 | 20240922193937_SjGti | KR002N | 2024-09-23T12:08:57.706Z | 2024-09-30T12:22:50.154Z |
5149778 | 5149778 | 20240922191736_Rqelp | KR002N | 2024-09-23T12:08:56.592Z | 2024-09-30T12:22:49.995Z |
5149775 | 5149775 | 20240922191631_t9o3p | KR002N | 2024-09-23T12:08:56.407Z | 2024-09-30T12:22:49.994Z |
5131412 | 5131412 | 20240915193855_48AMa | KR002N | 2024-09-19T12:15:01.759Z | 2024-09-24T12:15:33.392Z |
5131353 | 5131353 | 20240915192409_ggZtR | KR002N | 2024-09-19T12:14:58.408Z | 2024-09-24T12:15:32.802Z |
5131338 | 5131338 | 20240915191839_gX4tF | KR002N | 2024-09-19T12:14:57.180Z | 2024-09-24T12:15:32.586Z |
5131321 | 5131321 | 20240915191553_ubghr | KR002N | 2024-09-19T12:14:56.045Z | 2024-09-24T12:15:32.478Z |
5131309 | 5131309 | 20240915191354_3gpBR | KR002N | 2024-09-19T12:14:55.076Z | 2024-09-24T12:15:32.426Z |
5124078 | 5124078 | 20240914144716_31nZt | KR002N | 2024-09-18T12:12:05.563Z | 2024-09-22T12:18:13.049Z |
5124034 | 5124034 | 20240914140437_Sf922 | KR002N | 2024-09-18T12:12:03.942Z | 2024-09-22T12:18:12.847Z |
5050736 | 5050736 | 20240907160317_K9409 | KR002N | 2024-09-13T12:13:45.478Z | 2024-09-16T12:20:58.395Z |
5050326 | 5050326 | 20240907151006_qGmkx | KR002N | 2024-09-13T12:13:24.686Z | 2024-09-16T12:20:57.049Z |
5045423 | 5045423 | 20240908170230_FSLxm | KR002N | 2024-09-13T12:04:07.884Z | 2024-09-17T12:18:56.481Z |
5045290 | 5045290 | 20240908164911_1cIsX | KR002N | 2024-09-13T12:03:51.824Z | 2024-09-17T12:18:56.334Z |
5045041 | 5045041 | 20240908160940_eJSUO | KR002N | 2024-09-13T12:03:27.081Z | 2024-09-17T12:18:55.645Z |
5044932 | 5044932 | 20240908155706_ubJT8 | KR002N | 2024-09-13T12:03:14.026Z | 2024-09-17T12:18:55.439Z |
5044515 | 5044515 | 20240908150833_nuz47 | KR002N | 2024-09-13T12:02:18.463Z | 2024-09-17T12:18:54.580Z |
5044183 | 5044183 | 20240908142257_lyg6f | KR002N | 2024-09-13T12:01:37.574Z | 2024-09-17T12:18:53.639Z |
4888727 | 4888727 | 20240808183604_bLVe0 | KR002N | 2024-08-28T12:05:02.172Z | 2024-08-30T12:18:35.204Z |
4888485 | 4888485 | 20240808180039_klmE2 | KR002N | 2024-08-28T12:04:42.781Z | 2024-08-30T12:18:14.912Z |
4870527 | 4870527 | 20240806180323_8iSEx | KR002N | 2024-08-19T12:07:55.763Z | 2024-08-27T12:08:49.177Z |
4870336 | 4870336 | 20240806175710_CnQIU | KR002N | 2024-08-19T12:07:48.931Z | 2024-08-27T12:08:43.310Z |
4869420 | 4869420 | 20240806171741_uqq5B | KR002N | 2024-08-19T12:07:08.060Z | 2024-08-27T12:08:08.283Z |
4869160 | 4869160 | 20240806170404_wUz77 | KR002N | 2024-08-19T12:06:51.763Z | 2024-08-27T12:07:59.410Z |
4867482 | 4867482 | 20240806164700_Wgi2k | KR002N | 2024-08-18T12:08:46.660Z | 2024-08-27T12:07:39.349Z |
4866493 | 4866493 | 20240806155302_e2kQg | KR002N | 2024-08-18T12:07:40.907Z | 2024-08-27T12:06:59.249Z |
4828518 | 4828518 | 20240804175316_Nd6Iy | KR002N | 2024-08-15T12:07:08.444Z | 2024-08-17T12:28:08.657Z |
4828453 | 4828453 | 20240804174905_p9ZXh | KR002N | 2024-08-15T12:06:59.700Z | 2024-08-17T12:28:05.140Z |
4828246 | 4828246 | 20240804173622_ANj5N | KR002N | 2024-08-15T12:06:44.343Z | 2024-08-17T12:27:56.030Z |
4827958 | 4827958 | 20240804171310_BJXHQ | KR002N | 2024-08-15T12:06:22.107Z | 2024-08-17T12:27:42.012Z |
4768367 | 4768367 | 20240731171700_Xe1P9 | KR002N | 2024-08-06T12:09:56.051Z | 2024-08-10T12:20:06.311Z |
4767181 | 4767181 | 20240731143514_Ncyhz | KR002N | 2024-08-06T12:09:01.962Z | 2024-08-10T12:19:40.191Z |
4689323 | 4689323 | 20240724182924_3AQSa | KR002N | 2024-07-26T12:11:29.433Z | 2024-08-01T12:12:08.830Z |
4689309 | 4689309 | 20240724182430_3FUSg | KR002N | 2024-07-26T12:11:27.824Z | 2024-08-01T12:12:08.806Z |
4689289 | 4689289 | 20240724181830_TtnXA | KR002N | 2024-07-26T12:11:24.371Z | 2024-08-01T12:12:08.748Z |
4689211 | 4689211 | 20240724180315_g9lKZ | KR002N | 2024-07-26T12:11:20.756Z | 2024-08-01T12:12:08.682Z |
4510553 | 4510553 | 20240627121451_prrLR | KR002N | 2024-06-28T12:04:46.013Z | 2024-07-05T12:11:33.662Z |
4461924 | 4461924 | 20240613145555_twcnE | KR002N | 2024-06-15T12:07:50.015Z | 2024-06-21T12:11:45.711Z |
4461547 | 4461547 | 20240613122946_C7HPV | KR002N | 2024-06-15T12:07:08.114Z | 2024-06-21T12:11:44.414Z |
4412894 | 4412894 | 20240604123806_a4gp3 | KR002N | 2024-06-06T12:00:48.550Z | 2024-06-13T12:08:28.197Z |
4411079 | 4411079 | 20240603183633_BTcO6 | KR002N | 2024-06-05T12:06:17.199Z | 2024-06-12T12:10:36.599Z |
4410977 | 4410977 | 20240603182645_1sxQF | KR002N | 2024-06-05T12:06:12.159Z | 2024-06-12T12:10:36.273Z |
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);