participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,653 rows where station_code = "KR003B" 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 |
---|---|---|---|---|---|
4670459 | 4670459 | 20240719162212_hqhG5 | KR003B | 2024-07-21T12:01:12.797Z | 2024-07-28T12:14:49.193Z |
4627095 | 4627095 | 20240711185301_ku3Sb | KR003B | 2024-07-14T12:07:51.794Z | 2024-07-20T12:13:12.881Z |
4575364 | 4575364 | 20240705164328_f6Gt2 | KR003B | 2024-07-08T12:09:05.516Z | 2024-07-13T12:13:00.426Z |
4574727 | 4574727 | 20240705152911_4HGb2 | KR003B | 2024-07-08T12:08:50.532Z | 2024-07-13T12:12:59.820Z |
4551589 | 4551589 | 20240703171733_XeLY5 | KR003B | 2024-07-05T12:07:12.571Z | 2024-07-11T12:14:45.157Z |
4517700 | 4517700 | 20240628144127_TNNM8 | KR003B | 2024-06-30T12:00:49.968Z | 2024-07-07T12:13:41.591Z |
4513057 | 4513057 | 20240627185205_eiKlR | KR003B | 2024-06-29T12:04:36.025Z | 2024-07-06T12:16:14.666Z |
4512915 | 4512915 | 20240627182112_q3VR9 | KR003B | 2024-06-29T12:04:26.534Z | 2024-07-06T12:16:14.521Z |
4512814 | 4512814 | 20240627180646_VvJ22 | KR003B | 2024-06-29T12:04:18.108Z | 2024-07-06T12:16:14.170Z |
4512404 | 4512404 | 20240627172139_KHSwl | KR003B | 2024-06-29T12:03:49.383Z | 2024-07-06T12:16:13.414Z |
4507478 | 4507478 | 20240626153108_rLbyz | KR003B | 2024-06-28T12:01:56.741Z | 2024-07-05T12:11:21.949Z |
4507216 | 4507216 | 20240627164527_eqiY3 | KR003B | 2024-06-28T12:01:12.313Z | 2024-07-06T12:16:12.379Z |
4502844 | 4502844 | 20240626133708_7Qojw | KR003B | 2024-06-27T12:00:56.426Z | 2024-07-05T12:11:20.143Z |
4502763 | 4502763 | 20240626132049_Y4mVL | KR003B | 2024-06-27T12:00:51.066Z | 2024-07-05T12:11:20.034Z |
4494494 | 4494494 | 20240623124426_3jcfP | KR003B | 2024-06-24T12:00:31.724Z | 2024-07-02T12:10:13.509Z |
4487638 | 4487638 | 20240619182502_TUWMM | KR003B | 2024-06-21T12:04:12.305Z | 2024-06-28T12:09:34.135Z |
4483039 | 4483039 | 20240618161032_a3X22 | KR003B | 2024-06-20T12:03:25.466Z | 2024-06-27T12:11:19.985Z |
4479593 | 4479593 | 20240616180008_23oZK | KR003B | 2024-06-19T12:09:37.364Z | 2024-06-24T12:11:42.449Z |
4463104 | 4463104 | 20240613183851_FlPM8 | KR003B | 2024-06-15T12:09:26.388Z | 2024-06-21T12:11:47.891Z |
4461897 | 4461897 | 20240613144617_sKWiy | KR003B | 2024-06-15T12:07:47.665Z | 2024-06-21T12:11:45.667Z |
4461758 | 4461758 | 20240613140050_9ie3J | KR003B | 2024-06-15T12:07:31.431Z | 2024-06-21T12:11:45.167Z |
4461670 | 4461670 | 20240613132241_MV3cJ | KR003B | 2024-06-15T12:07:21.233Z | 2024-06-21T12:11:44.769Z |
4427034 | 4427034 | 20240606185816_84vk8 | KR003B | 2024-06-08T12:03:54.711Z | 2024-06-15T12:16:48.934Z |
4426992 | 4426992 | 20240606184515_nnCNP | KR003B | 2024-06-08T12:03:52.328Z | 2024-06-15T12:16:48.857Z |
4426827 | 4426827 | 20240606182415_D4GYr | KR003B | 2024-06-08T12:03:43.974Z | 2024-06-15T12:16:48.687Z |
4426762 | 4426762 | 20240606181809_PPx4C | KR003B | 2024-06-08T12:03:38.430Z | 2024-06-15T12:16:48.328Z |
4425327 | 4425327 | 20240606150257_mf9G3 | KR003B | 2024-06-08T12:01:11.957Z | 2024-06-15T12:16:44.487Z |
4425297 | 4425297 | 20240606145833_6etH6 | KR003B | 2024-06-08T12:01:08.355Z | 2024-06-15T12:16:44.389Z |
4425187 | 4425187 | 20240606144612_1KjUn | KR003B | 2024-06-08T12:00:58.715Z | 2024-06-15T12:16:44.227Z |
4415281 | 4415281 | 20240604174225_SO9EO | KR003B | 2024-06-06T12:04:31.370Z | 2024-06-13T12:08:29.801Z |
4415249 | 4415249 | 20240604173656_1cSlY | KR003B | 2024-06-06T12:04:29.102Z | 2024-06-13T12:08:29.785Z |
4415177 | 4415177 | 20240604172427_NOe6v | KR003B | 2024-06-06T12:04:24.215Z | 2024-06-13T12:08:29.741Z |
4415033 | 4415033 | 20240604170141_Ve99g | KR003B | 2024-06-06T12:04:12.228Z | 2024-06-13T12:08:29.634Z |
4414974 | 4414974 | 20240604165234_QDAxO | KR003B | 2024-06-06T12:04:00.420Z | 2024-06-13T12:08:29.585Z |
4414834 | 4414834 | 20240604163553_dYZl8 | KR003B | 2024-06-06T12:03:47.188Z | 2024-06-13T12:08:29.502Z |
4414650 | 4414650 | 20240604161900_QWmAR | KR003B | 2024-06-06T12:03:36.710Z | 2024-06-13T12:08:29.339Z |
4414034 | 4414034 | 20240604151304_zPNwL | KR003B | 2024-06-06T12:02:41.146Z | 2024-06-13T12:08:28.933Z |
4413962 | 4413962 | 20240604150221_i8ZnG | KR003B | 2024-06-06T12:02:35.725Z | 2024-06-13T12:08:28.908Z |
4412896 | 4412896 | 20240604123806_a4gp3 | KR003B | 2024-06-06T12:00:48.550Z | 2024-06-13T12:08:28.197Z |
4411166 | 4411166 | 20240603184749_2vCc4 | KR003B | 2024-06-05T12:06:23.168Z | 2024-06-12T12:10:36.833Z |
4411082 | 4411082 | 20240603183633_BTcO6 | KR003B | 2024-06-05T12:06:17.199Z | 2024-06-12T12:10:36.599Z |
4410980 | 4410980 | 20240603182645_1sxQF | KR003B | 2024-06-05T12:06:12.159Z | 2024-06-12T12:10:36.273Z |
4410921 | 4410921 | 20240603182049_do3R3 | KR003B | 2024-06-05T12:06:08.462Z | 2024-06-12T12:10:36.174Z |
4410611 | 4410611 | 20240603173000_37YBg | KR003B | 2024-06-05T12:05:33.410Z | 2024-06-12T12:10:35.001Z |
4410315 | 4410315 | 20240603170016_1bOr1 | KR003B | 2024-06-05T12:05:10.350Z | 2024-06-12T12:10:34.466Z |
4410253 | 4410253 | 20240603165300_DUrRB | KR003B | 2024-06-05T12:05:02.598Z | 2024-06-12T12:10:34.423Z |
4410179 | 4410179 | 20240603164156_MtXe1 | KR003B | 2024-06-05T12:04:55.005Z | 2024-06-12T12:10:34.294Z |
4410133 | 4410133 | 20240603163831_o1sDc | KR003B | 2024-06-05T12:04:52.133Z | 2024-06-12T12:10:34.222Z |
4399999 | 4399999 | 20240601180350_QfYQZ | KR003B | 2024-06-03T12:04:56.492Z | 2024-06-10T12:06:45.529Z |
4399987 | 4399987 | 20240601180048_mNCZU | KR003B | 2024-06-03T12:04:52.616Z | 2024-06-10T12:06:45.520Z |
4392589 | 4392589 | 20240529155422_lXfG2 | KR003B | 2024-05-31T12:07:14.430Z | 2024-06-07T12:15:57.936Z |
4389216 | 4389216 | 20240528185513_suV1y | KR003B | 2024-05-30T12:05:11.582Z | 2024-06-06T12:14:26.670Z |
4388759 | 4388759 | 20240528161922_cBwxt | KR003B | 2024-05-30T12:04:17.621Z | 2024-06-06T12:14:25.294Z |
4385409 | 4385409 | 20240528153934_Vpzkx | KR003B | 2024-05-29T12:03:28.603Z | 2024-06-06T12:14:24.770Z |
4385327 | 4385327 | 20240528151120_nLHTL | KR003B | 2024-05-29T12:03:16.676Z | 2024-06-06T12:14:24.546Z |
4385299 | 4385299 | 20240528145926_PEe2S | KR003B | 2024-05-29T12:03:11.726Z | 2024-06-06T12:14:24.485Z |
4385231 | 4385231 | 20240528143542_NKI7v | KR003B | 2024-05-29T12:03:03.591Z | 2024-06-06T12:14:24.422Z |
4384956 | 4384956 | 20240528130447_gCATA | KR003B | 2024-05-29T12:02:40.127Z | 2024-06-06T12:14:23.780Z |
4377460 | 4377460 | 20240519184610_TG2RL | KR003B | 2024-05-27T12:12:09.013Z | 2024-05-27T12:12:09.013Z |
4377453 | 4377453 | 20240519184548_P74Ro | KR003B | 2024-05-27T12:12:08.820Z | 2024-05-27T12:12:08.820Z |
4377397 | 4377397 | 20240519181551_wC3Qg | KR003B | 2024-05-27T12:12:05.884Z | 2024-05-27T12:12:05.884Z |
4377305 | 4377305 | 20240519175057_q2nL4 | KR003B | 2024-05-27T12:12:03.407Z | 2024-05-27T12:12:03.407Z |
4377291 | 4377291 | 20240519174853_mg90K | KR003B | 2024-05-27T12:12:03.174Z | 2024-05-27T12:12:03.174Z |
4377247 | 4377247 | 20240519173715_8r7CX | KR003B | 2024-05-27T12:12:02.491Z | 2024-05-27T12:12:02.491Z |
4370294 | 4370294 | 20240518174724_rH1Dm | KR003B | 2024-05-26T12:09:09.993Z | 2024-05-26T12:09:53.481Z |
4370131 | 4370131 | 20240518173100_2S2jN | KR003B | 2024-05-26T12:08:58.453Z | 2024-05-26T12:09:53.438Z |
4369925 | 4369925 | 20240518165820_HEkdT | KR003B | 2024-05-26T12:08:41.971Z | 2024-05-26T12:09:53.388Z |
4369800 | 4369800 | 20240518163302_cguzh | KR003B | 2024-05-26T12:08:35.202Z | 2024-05-26T12:09:53.354Z |
4369644 | 4369644 | 20240518155854_Ip8VS | KR003B | 2024-05-26T12:08:28.703Z | 2024-05-26T12:09:53.318Z |
4369487 | 4369487 | 20240518152426_mySmf | KR003B | 2024-05-26T12:08:21.188Z | 2024-05-26T12:09:53.275Z |
4369476 | 4369476 | 20240518152058_h2yt2 | KR003B | 2024-05-26T12:08:20.941Z | 2024-05-26T12:09:53.274Z |
4366996 | 4366996 | 20240517185831_15Y50 | KR003B | 2024-05-26T12:03:46.403Z | 2024-05-26T12:09:52.570Z |
4366958 | 4366958 | 20240517185228_NAkA7 | KR003B | 2024-05-26T12:03:43.952Z | 2024-05-26T12:09:52.562Z |
4366928 | 4366928 | 20240517184744_nM1O6 | KR003B | 2024-05-26T12:03:41.867Z | 2024-05-26T12:09:52.555Z |
4363343 | 4363343 | 20240516142650_6VL0N | KR003B | 2024-05-25T12:06:46.675Z | 2024-05-25T12:06:46.675Z |
4346466 | 4346466 | 20240510172256_2y2RS | KR003B | 2024-05-20T12:04:38.147Z | 2024-05-22T12:10:33.117Z |
4345221 | 4345221 | 20240510160144_YjPdQ | KR003B | 2024-05-20T12:02:57.965Z | 2024-05-22T12:09:59.752Z |
4345191 | 4345191 | 20240510160003_XkykE | KR003B | 2024-05-20T12:02:54.771Z | 2024-05-22T12:09:59.219Z |
4345141 | 4345141 | 20240510155710_3HtFT | KR003B | 2024-05-20T12:02:52.719Z | 2024-05-22T12:09:58.523Z |
4344663 | 4344663 | 20240510152544_dw503 | KR003B | 2024-05-20T12:02:14.584Z | 2024-05-22T12:09:46.836Z |
4339417 | 4339417 | 20240509173521_fgp42 | KR003B | 2024-05-19T12:05:26.787Z | 2024-05-21T12:08:42.726Z |
4338771 | 4338771 | 20240509170926_Wy2WV | KR003B | 2024-05-19T12:04:40.154Z | 2024-05-21T12:08:27.315Z |
4337720 | 4337720 | 20240509161240_TFzJW | KR003B | 2024-05-19T12:02:45.506Z | 2024-05-21T12:07:49.170Z |
4337057 | 4337057 | 20240509154114_uah6O | KR003B | 2024-05-19T12:01:54.550Z | 2024-05-21T12:07:29.372Z |
4329709 | 4329709 | 20240508191129_eACQu | KR003B | 2024-05-17T12:08:58.120Z | 2024-05-19T12:14:26.205Z |
4329641 | 4329641 | 20240508190317_Q1qyq | KR003B | 2024-05-17T12:08:54.321Z | 2024-05-19T12:14:25.015Z |
4329554 | 4329554 | 20240508185203_3GZLn | KR003B | 2024-05-17T12:08:49.432Z | 2024-05-19T12:14:24.221Z |
4329430 | 4329430 | 20240508183756_SWrQV | KR003B | 2024-05-17T12:08:43.342Z | 2024-05-19T12:14:22.606Z |
4329292 | 4329292 | 20240508182728_359Kd | KR003B | 2024-05-17T12:08:34.212Z | 2024-05-19T12:14:18.157Z |
4329066 | 4329066 | 20240508181356_9vSB9 | KR003B | 2024-05-17T12:08:21.725Z | 2024-05-19T12:14:12.564Z |
4327427 | 4327427 | 20240508171742_1mv24 | KR003B | 2024-05-17T12:06:59.199Z | 2024-05-19T12:13:42.925Z |
4283315 | 4283315 | 20240503191038_Ku2cT | KR003B | 2024-05-06T12:11:33.608Z | 2024-05-12T12:18:59.288Z |
4283204 | 4283204 | 20240503190012_vp1qP | KR003B | 2024-05-06T12:11:20.920Z | 2024-05-12T12:18:55.351Z |
4282945 | 4282945 | 20240503183406_1dMs1 | KR003B | 2024-05-06T12:11:08.054Z | 2024-05-12T12:18:45.970Z |
4282842 | 4282842 | 20240503182623_pm06h | KR003B | 2024-05-06T12:10:59.314Z | 2024-05-12T12:18:41.073Z |
4282476 | 4282476 | 20240503180149_Q5z26 | KR003B | 2024-05-06T12:10:32.222Z | 2024-05-12T12:18:30.247Z |
4282429 | 4282429 | 20240503180114_a6NOX | KR003B | 2024-05-06T12:10:29.867Z | 2024-05-12T12:18:29.654Z |
4280707 | 4280707 | 20240503170219_f2GIy | KR003B | 2024-05-06T12:08:45.981Z | 2024-05-12T12:18:06.696Z |
4279752 | 4279752 | 20240503162041_9OOOQ | KR003B | 2024-05-06T12:07:33.970Z | 2024-05-12T12:17:55.303Z |
4278429 | 4278429 | 20240503151212_KTU9K | KR003B | 2024-05-06T12:05:28.099Z | 2024-05-12T12:17:24.814Z |
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);