participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,296 rows where station_code = "KR0036" 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 |
---|---|---|---|---|---|
5559206 | 5559206 | 20241120093747_8vsF3 | KR0036 | 2024-11-21T14:05:36.466Z | 2024-11-22T14:19:21.386Z |
5554782 | 5554782 | 20241119103727_ZjQ2R | KR0036 | 2024-11-20T14:03:16.973Z | 2024-11-22T14:19:51.392Z |
5552345 | 5552345 | 20241118205130_ULxF3 | KR0036 | 2024-11-19T14:06:24.363Z | 2024-11-22T14:22:16.996Z |
5552273 | 5552273 | 20241118201019_MpSAH | KR0036 | 2024-11-19T14:06:13.817Z | 2024-11-22T14:22:16.462Z |
5552248 | 5552248 | 20241118194833_rvVc1 | KR0036 | 2024-11-19T14:06:10.295Z | 2024-11-22T14:22:16.093Z |
5547908 | 5547908 | 20241117202930_0nbcj | KR0036 | 2024-11-18T14:06:48.920Z | 2024-11-22T14:22:45.484Z |
5547902 | 5547902 | 20241117202813_BI6Lb | KR0036 | 2024-11-18T14:06:48.580Z | 2024-11-22T14:22:45.483Z |
5547738 | 5547738 | 20241117192502_2eOfr | KR0036 | 2024-11-18T14:06:24.331Z | 2024-11-22T14:22:43.181Z |
5534833 | 5534833 | 20241113201009_UqsJO | KR0036 | 2024-11-14T14:05:32.661Z | 2024-11-22T14:24:17.089Z |
5527337 | 5527337 | 20241111152345_7vy5q | KR0036 | 2024-11-13T14:07:51.655Z | 2024-11-20T14:25:07.020Z |
5522704 | 5522704 | 20241110210525_rzpcC | KR0036 | 2024-11-12T14:13:58.907Z | 2024-11-19T14:22:05.359Z |
5522691 | 5522691 | 20241110210330_1h5f0 | KR0036 | 2024-11-12T14:13:58.005Z | 2024-11-19T14:22:05.322Z |
5521221 | 5521221 | 20241110163043_nL8ko | KR0036 | 2024-11-12T14:10:38.403Z | 2024-11-19T14:21:50.468Z |
5521215 | 5521215 | 20241110162815_i1WGX | KR0036 | 2024-11-12T14:10:38.106Z | 2024-11-19T14:21:50.430Z |
5508376 | 5508376 | 20241109165022_BbhY6 | KR0036 | 2024-11-10T14:07:36.451Z | 2024-11-18T14:26:21.833Z |
5508343 | 5508343 | 20241109163022_EapJb | KR0036 | 2024-11-10T14:07:29.686Z | 2024-11-18T14:26:21.518Z |
5508270 | 5508270 | 20241109154348_9CSfZ | KR0036 | 2024-11-10T14:07:21.684Z | 2024-11-18T14:26:20.649Z |
5508218 | 5508218 | 20241109151518_GRuse | KR0036 | 2024-11-10T14:07:16.370Z | 2024-11-18T14:26:20.124Z |
5508170 | 5508170 | 20241109145205_GgSf5 | KR0036 | 2024-11-10T14:07:11.644Z | 2024-11-18T14:26:19.664Z |
5508164 | 5508164 | 20241109145056_wlgA2 | KR0036 | 2024-11-10T14:07:11.425Z | 2024-11-18T14:26:19.627Z |
5508110 | 5508110 | 20241109143019_vetWm | KR0036 | 2024-11-10T14:07:04.643Z | 2024-11-18T14:26:18.966Z |
5507489 | 5507489 | 20241109113717_miCoD | KR0036 | 2024-11-10T14:05:24.226Z | 2024-11-18T14:26:11.194Z |
5507112 | 5507112 | 20241109103035_N2Yic | KR0036 | 2024-11-10T14:04:16.436Z | 2024-11-18T14:26:07.062Z |
5507025 | 5507025 | 20241109101527_2OhOr | KR0036 | 2024-11-10T14:04:04.875Z | 2024-11-18T14:26:06.014Z |
5501549 | 5501549 | 20241107141356_unUHk | KR0036 | 2024-11-09T14:10:00.271Z | 2024-11-16T14:27:42.542Z |
5501495 | 5501495 | 20241107133538_wlLxw | KR0036 | 2024-11-09T14:09:54.969Z | 2024-11-16T14:27:40.932Z |
5501482 | 5501482 | 20241107132642_smPu3 | KR0036 | 2024-11-09T14:09:54.036Z | 2024-11-16T14:27:40.780Z |
5501464 | 5501464 | 20241107131734_KV8r3 | KR0036 | 2024-11-09T14:09:47.480Z | 2024-11-16T14:27:40.028Z |
5501429 | 5501429 | 20241107130432_2SQ24 | KR0036 | 2024-11-09T14:09:36.898Z | 2024-11-16T14:27:39.109Z |
5501402 | 5501402 | 20241107125043_VkYP8 | KR0036 | 2024-11-09T14:09:29.126Z | 2024-11-16T14:27:37.802Z |
5501381 | 5501381 | 20241107124052_f3l14 | KR0036 | 2024-11-09T14:09:18.960Z | 2024-11-16T14:27:36.347Z |
5501371 | 5501371 | 20241107124006_CW2Ey | KR0036 | 2024-11-09T14:09:17.926Z | 2024-11-16T14:27:36.332Z |
5501363 | 5501363 | 20241107123512_Ezm8R | KR0036 | 2024-11-09T14:09:15.975Z | 2024-11-16T14:27:36.033Z |
5501353 | 5501353 | 20241107122906_XYJ3F | KR0036 | 2024-11-09T14:09:14.593Z | 2024-11-16T14:27:35.559Z |
5501171 | 5501171 | 20241108204742_50Bcp | KR0036 | 2024-11-09T14:07:47.508Z | 2024-11-17T14:23:37.103Z |
5488430 | 5488430 | 20241105144020_f5nXq | KR0036 | 2024-11-07T14:09:52.962Z | 2024-11-14T14:23:05.529Z |
5488394 | 5488394 | 20241105142549_Xb8pv | KR0036 | 2024-11-07T14:09:48.946Z | 2024-11-14T14:23:05.370Z |
5488382 | 5488382 | 20241105142026_HWsaS | KR0036 | 2024-11-07T14:09:47.848Z | 2024-11-14T14:23:05.339Z |
5488360 | 5488360 | 20241105140529_hl2Sg | KR0036 | 2024-11-07T14:09:44.407Z | 2024-11-14T14:23:04.955Z |
5488307 | 5488307 | 20241105131316_f6zE6 | KR0036 | 2024-11-07T14:09:33.062Z | 2024-11-14T14:23:04.435Z |
5488301 | 5488301 | 20241105130905_Wbend | KR0036 | 2024-11-07T14:09:28.980Z | 2024-11-14T14:23:04.380Z |
5488289 | 5488289 | 20241105130153_NnLNw | KR0036 | 2024-11-07T14:09:26.631Z | 2024-11-14T14:23:04.335Z |
5488279 | 5488279 | 20241105125810_ttjL3 | KR0036 | 2024-11-07T14:09:24.877Z | 2024-11-14T14:23:04.299Z |
5488263 | 5488263 | 20241105123242_jPUik | KR0036 | 2024-11-07T14:09:19.238Z | 2024-11-14T14:23:03.935Z |
5488244 | 5488244 | 20241105122123_zqVg2 | KR0036 | 2024-11-07T14:09:16.512Z | 2024-11-14T14:23:03.761Z |
5488231 | 5488231 | 20241105120910_22kNZ | KR0036 | 2024-11-07T14:09:12.638Z | 2024-11-14T14:23:03.164Z |
5488167 | 5488167 | 20241105105126_D4Ux2 | KR0036 | 2024-11-07T14:08:42.416Z | 2024-11-14T14:23:00.822Z |
5488161 | 5488161 | 20241105104804_8HOE6 | KR0036 | 2024-11-07T14:08:41.574Z | 2024-11-14T14:23:00.780Z |
5486970 | 5486970 | 20241106141304_Zheyy | KR0036 | 2024-11-07T14:04:32.057Z | 2024-11-15T14:24:36.304Z |
5486836 | 5486836 | 20241106133942_BHwDB | KR0036 | 2024-11-07T14:04:13.528Z | 2024-11-15T14:24:35.186Z |
5486670 | 5486670 | 20241106124809_KJHbQ | KR0036 | 2024-11-07T14:03:44.021Z | 2024-11-15T14:24:32.973Z |
5486453 | 5486453 | 20241106114242_fYAO5 | KR0036 | 2024-11-07T14:03:01.155Z | 2024-11-15T14:24:30.238Z |
5486209 | 5486209 | 20241106100456_rutIY | KR0036 | 2024-11-07T14:02:14.136Z | 2024-11-15T14:24:27.484Z |
5481677 | 5481677 | 20241104191431_9F9yn | KR0036 | 2024-11-06T14:11:18.387Z | 2024-11-13T14:27:31.511Z |
5481302 | 5481302 | 20241104164738_15Vg2 | KR0036 | 2024-11-06T14:09:57.134Z | 2024-11-13T14:27:26.972Z |
5481073 | 5481073 | 20241104133211_ZBeom | KR0036 | 2024-11-06T14:08:55.572Z | 2024-11-13T14:27:25.661Z |
5480953 | 5480953 | 20241104111135_5uutW | KR0036 | 2024-11-06T14:08:02.437Z | 2024-11-13T14:27:23.950Z |
5480945 | 5480945 | 20241104105222_1f0wW | KR0036 | 2024-11-06T14:07:52.795Z | 2024-11-13T14:27:23.751Z |
5480942 | 5480942 | 20241104104959_ar1EN | KR0036 | 2024-11-06T14:07:50.899Z | 2024-11-13T14:27:23.716Z |
5473574 | 5473574 | 20241103143444_lMALA | KR0036 | 2024-11-05T14:09:07.902Z | 2024-11-12T14:27:49.716Z |
5467337 | 5467337 | 20241102204639_TV0IX | KR0036 | 2024-11-04T14:11:18.950Z | 2024-11-11T14:22:46.280Z |
5466278 | 5466278 | 20241102170130_KDHYI | KR0036 | 2024-11-04T14:08:32.095Z | 2024-11-11T14:22:40.099Z |
5466222 | 5466222 | 20241102165338_u12zA | KR0036 | 2024-11-04T14:08:17.965Z | 2024-11-11T14:22:39.920Z |
5466126 | 5466126 | 20241102162825_rtCJ2 | KR0036 | 2024-11-04T14:08:04.346Z | 2024-11-11T14:22:39.225Z |
5466092 | 5466092 | 20241102161802_klTg2 | KR0036 | 2024-11-04T14:07:59.744Z | 2024-11-11T14:22:38.872Z |
5466055 | 5466055 | 20241102160947_Jq1HZ | KR0036 | 2024-11-04T14:07:56.784Z | 2024-11-11T14:22:38.691Z |
5465948 | 5465948 | 20241102153315_Iwut6 | KR0036 | 2024-11-04T14:07:31.615Z | 2024-11-11T14:22:37.129Z |
5465924 | 5465924 | 20241102152423_fYeyN | KR0036 | 2024-11-04T14:07:26.087Z | 2024-11-11T14:22:36.794Z |
5465911 | 5465911 | 20241102151542_wQQ0v | KR0036 | 2024-11-04T14:07:22.239Z | 2024-11-11T14:22:36.268Z |
5465854 | 5465854 | 20241102145518_5WPS3 | KR0036 | 2024-11-04T14:07:13.952Z | 2024-11-11T14:22:35.724Z |
5465849 | 5465849 | 20241102144955_F8ByR | KR0036 | 2024-11-04T14:07:12.353Z | 2024-11-11T14:22:35.580Z |
5465766 | 5465766 | 20241102135259_tzE2n | KR0036 | 2024-11-04T14:06:38.248Z | 2024-11-11T14:22:33.755Z |
5465730 | 5465730 | 20241102133003_hD9sV | KR0036 | 2024-11-04T14:06:30.822Z | 2024-11-11T14:22:32.774Z |
5465722 | 5465722 | 20241102132912_tz2VK | KR0036 | 2024-11-04T14:06:29.768Z | 2024-11-11T14:22:32.725Z |
5465696 | 5465696 | 20241102131447_T0wrd | KR0036 | 2024-11-04T14:06:16.260Z | 2024-11-11T14:22:32.371Z |
5465691 | 5465691 | 20241102130957_gC1UE | KR0036 | 2024-11-04T14:06:14.856Z | 2024-11-11T14:22:32.333Z |
5465638 | 5465638 | 20241102123849_W3jsE | KR0036 | 2024-11-04T14:06:01.792Z | 2024-11-11T14:22:31.834Z |
5465635 | 5465635 | 20241102123715_XpXyb | KR0036 | 2024-11-04T14:06:01.117Z | 2024-11-11T14:22:31.787Z |
5465617 | 5465617 | 20241102122410_Pq17o | KR0036 | 2024-11-04T14:05:56.889Z | 2024-11-11T14:22:31.432Z |
5465569 | 5465569 | 20241102113533_EiLWQ | KR0036 | 2024-11-04T14:05:28.608Z | 2024-11-11T14:22:29.450Z |
5465564 | 5465564 | 20241102113320_2UU7r | KR0036 | 2024-11-04T14:05:27.618Z | 2024-11-11T14:22:29.369Z |
5449864 | 5449864 | 20241031170130_6cQV1 | KR0036 | 2024-11-02T12:13:52.069Z | 2024-11-09T14:24:12.265Z |
5449441 | 5449441 | 20241031153554_moDJY | KR0036 | 2024-11-02T12:12:53.732Z | 2024-11-09T14:24:10.439Z |
5449267 | 5449267 | 20241031151358_EiE8B | KR0036 | 2024-11-02T12:12:22.388Z | 2024-11-09T14:24:10.035Z |
5449080 | 5449080 | 20241031145010_oNGVq | KR0036 | 2024-11-02T12:12:03.557Z | 2024-11-09T14:24:09.379Z |
5448712 | 5448712 | 20241031141003_2UOgP | KR0036 | 2024-11-02T12:11:21.486Z | 2024-11-09T14:24:07.114Z |
5448637 | 5448637 | 20241031135948_rfsCb | KR0036 | 2024-11-02T12:11:13.676Z | 2024-11-09T14:24:06.850Z |
5448553 | 5448553 | 20241031134602_VikD1 | KR0036 | 2024-11-02T12:11:05.093Z | 2024-11-09T14:24:06.407Z |
5439888 | 5439888 | 20241030204450_P5BIE | KR0036 | 2024-11-01T12:14:35.738Z | 2024-11-08T14:23:05.984Z |
5437366 | 5437366 | 20241030145952_lmmK3 | KR0036 | 2024-11-01T12:09:28.026Z | 2024-11-08T14:22:57.085Z |
5436598 | 5436598 | 20241030132608_IBmrR | KR0036 | 2024-11-01T12:07:56.483Z | 2024-11-08T14:22:54.490Z |
5436271 | 5436271 | 20241030124407_JhTRQ | KR0036 | 2024-11-01T12:07:12.517Z | 2024-11-08T14:22:53.635Z |
5436019 | 5436019 | 20241030122201_P34ym | KR0036 | 2024-11-01T12:06:34.197Z | 2024-11-08T14:22:52.462Z |
5435884 | 5435884 | 20241030120725_uXrNw | KR0036 | 2024-11-01T12:06:18.332Z | 2024-11-08T14:22:52.088Z |
5435477 | 5435477 | 20241030113251_s790O | KR0036 | 2024-11-01T12:05:14.550Z | 2024-11-08T14:22:50.775Z |
5434952 | 5434952 | 20241030102939_X30de | KR0036 | 2024-11-01T12:03:50.465Z | 2024-11-08T14:22:48.786Z |
5433688 | 5433688 | 20241029205311_4iMoI | KR0036 | 2024-10-31T12:22:27.723Z | 2024-11-07T14:26:40.815Z |
5430041 | 5430041 | 20241028205135_XiDte | KR0036 | 2024-10-31T12:17:27.774Z | 2024-11-06T14:27:18.422Z |
5429911 | 5429911 | 20241028202252_d3fgn | KR0036 | 2024-10-31T12:17:12.607Z | 2024-11-06T14:27:18.068Z |
5428386 | 5428386 | 20241028170237_pYXM5 | KR0036 | 2024-10-31T12:15:06.459Z | 2024-11-06T14:27:13.377Z |
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);