participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,272 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 |
---|---|---|---|---|---|
5501549 | 5501549 | 20241107141356_unUHk | KR0036 | 2024-11-09T14:10:00.271Z | 2024-11-09T14:16:27.755Z |
5501495 | 5501495 | 20241107133538_wlLxw | KR0036 | 2024-11-09T14:09:54.969Z | 2024-11-09T14:16:27.727Z |
5501482 | 5501482 | 20241107132642_smPu3 | KR0036 | 2024-11-09T14:09:54.036Z | 2024-11-09T14:16:27.723Z |
5501464 | 5501464 | 20241107131734_KV8r3 | KR0036 | 2024-11-09T14:09:47.480Z | 2024-11-09T14:16:27.712Z |
5501429 | 5501429 | 20241107130432_2SQ24 | KR0036 | 2024-11-09T14:09:36.898Z | 2024-11-09T14:16:27.697Z |
5501402 | 5501402 | 20241107125043_VkYP8 | KR0036 | 2024-11-09T14:09:29.126Z | 2024-11-09T14:16:27.680Z |
5501381 | 5501381 | 20241107124052_f3l14 | KR0036 | 2024-11-09T14:09:18.960Z | 2024-11-09T14:16:27.664Z |
5501371 | 5501371 | 20241107124006_CW2Ey | KR0036 | 2024-11-09T14:09:17.926Z | 2024-11-09T14:16:27.663Z |
5501363 | 5501363 | 20241107123512_Ezm8R | KR0036 | 2024-11-09T14:09:15.975Z | 2024-11-09T14:16:27.658Z |
5501353 | 5501353 | 20241107122906_XYJ3F | KR0036 | 2024-11-09T14:09:14.593Z | 2024-11-09T14:16:27.649Z |
5501171 | 5501171 | 20241108204742_50Bcp | KR0036 | 2024-11-09T14:07:47.508Z | 2024-11-09T14:07:47.508Z |
5488430 | 5488430 | 20241105144020_f5nXq | KR0036 | 2024-11-07T14:09:52.962Z | 2024-11-09T14:19:28.330Z |
5488394 | 5488394 | 20241105142549_Xb8pv | KR0036 | 2024-11-07T14:09:48.946Z | 2024-11-09T14:19:27.396Z |
5488382 | 5488382 | 20241105142026_HWsaS | KR0036 | 2024-11-07T14:09:47.848Z | 2024-11-09T14:19:27.229Z |
5488360 | 5488360 | 20241105140529_hl2Sg | KR0036 | 2024-11-07T14:09:44.407Z | 2024-11-09T14:19:26.049Z |
5488307 | 5488307 | 20241105131316_f6zE6 | KR0036 | 2024-11-07T14:09:33.062Z | 2024-11-09T14:19:24.491Z |
5488301 | 5488301 | 20241105130905_Wbend | KR0036 | 2024-11-07T14:09:28.980Z | 2024-11-09T14:19:24.345Z |
5488289 | 5488289 | 20241105130153_NnLNw | KR0036 | 2024-11-07T14:09:26.631Z | 2024-11-09T14:19:24.189Z |
5488279 | 5488279 | 20241105125810_ttjL3 | KR0036 | 2024-11-07T14:09:24.877Z | 2024-11-09T14:19:24.108Z |
5488263 | 5488263 | 20241105123242_jPUik | KR0036 | 2024-11-07T14:09:19.238Z | 2024-11-09T14:19:23.066Z |
5488244 | 5488244 | 20241105122123_zqVg2 | KR0036 | 2024-11-07T14:09:16.512Z | 2024-11-09T14:19:22.516Z |
5488231 | 5488231 | 20241105120910_22kNZ | KR0036 | 2024-11-07T14:09:12.638Z | 2024-11-09T14:19:21.138Z |
5488167 | 5488167 | 20241105105126_D4Ux2 | KR0036 | 2024-11-07T14:08:42.416Z | 2024-11-09T14:19:13.021Z |
5488161 | 5488161 | 20241105104804_8HOE6 | KR0036 | 2024-11-07T14:08:41.574Z | 2024-11-09T14:19:12.800Z |
5486970 | 5486970 | 20241106141304_Zheyy | KR0036 | 2024-11-07T14:04:32.057Z | 2024-11-09T14:17:03.412Z |
5486836 | 5486836 | 20241106133942_BHwDB | KR0036 | 2024-11-07T14:04:13.528Z | 2024-11-09T14:16:59.639Z |
5486670 | 5486670 | 20241106124809_KJHbQ | KR0036 | 2024-11-07T14:03:44.021Z | 2024-11-09T14:16:53.687Z |
5486453 | 5486453 | 20241106114242_fYAO5 | KR0036 | 2024-11-07T14:03:01.155Z | 2024-11-09T14:16:46.825Z |
5486209 | 5486209 | 20241106100456_rutIY | KR0036 | 2024-11-07T14:02:14.136Z | 2024-11-09T14:16:39.835Z |
5481677 | 5481677 | 20241104191431_9F9yn | KR0036 | 2024-11-06T14:11:18.387Z | 2024-11-09T14:20:49.345Z |
5481302 | 5481302 | 20241104164738_15Vg2 | KR0036 | 2024-11-06T14:09:57.134Z | 2024-11-09T14:20:43.802Z |
5481073 | 5481073 | 20241104133211_ZBeom | KR0036 | 2024-11-06T14:08:55.572Z | 2024-11-09T14:20:36.266Z |
5480953 | 5480953 | 20241104111135_5uutW | KR0036 | 2024-11-06T14:08:02.437Z | 2024-11-09T14:20:29.452Z |
5480945 | 5480945 | 20241104105222_1f0wW | KR0036 | 2024-11-06T14:07:52.795Z | 2024-11-09T14:20:28.770Z |
5480942 | 5480942 | 20241104104959_ar1EN | KR0036 | 2024-11-06T14:07:50.899Z | 2024-11-09T14:20:28.637Z |
5473574 | 5473574 | 20241103143444_lMALA | KR0036 | 2024-11-05T14:09:07.902Z | 2024-11-09T14:21:39.638Z |
5467337 | 5467337 | 20241102204639_TV0IX | KR0036 | 2024-11-04T14:11:18.950Z | 2024-11-09T14:22:54.130Z |
5466278 | 5466278 | 20241102170130_KDHYI | KR0036 | 2024-11-04T14:08:32.095Z | 2024-11-09T14:22:50.042Z |
5466222 | 5466222 | 20241102165338_u12zA | KR0036 | 2024-11-04T14:08:17.965Z | 2024-11-09T14:22:49.927Z |
5466126 | 5466126 | 20241102162825_rtCJ2 | KR0036 | 2024-11-04T14:08:04.346Z | 2024-11-09T14:22:49.609Z |
5466092 | 5466092 | 20241102161802_klTg2 | KR0036 | 2024-11-04T14:07:59.744Z | 2024-11-09T14:22:49.529Z |
5466055 | 5466055 | 20241102160947_Jq1HZ | KR0036 | 2024-11-04T14:07:56.784Z | 2024-11-09T14:22:49.475Z |
5465948 | 5465948 | 20241102153315_Iwut6 | KR0036 | 2024-11-04T14:07:31.615Z | 2024-11-09T14:22:48.998Z |
5465924 | 5465924 | 20241102152423_fYeyN | KR0036 | 2024-11-04T14:07:26.087Z | 2024-11-09T14:22:48.828Z |
5465911 | 5465911 | 20241102151542_wQQ0v | KR0036 | 2024-11-04T14:07:22.239Z | 2024-11-09T14:22:48.567Z |
5465854 | 5465854 | 20241102145518_5WPS3 | KR0036 | 2024-11-04T14:07:13.952Z | 2024-11-09T14:22:48.289Z |
5465849 | 5465849 | 20241102144955_F8ByR | KR0036 | 2024-11-04T14:07:12.353Z | 2024-11-09T14:22:48.219Z |
5465766 | 5465766 | 20241102135259_tzE2n | KR0036 | 2024-11-04T14:06:38.248Z | 2024-11-09T14:22:47.161Z |
5465730 | 5465730 | 20241102133003_hD9sV | KR0036 | 2024-11-04T14:06:30.822Z | 2024-11-09T14:22:46.662Z |
5465722 | 5465722 | 20241102132912_tz2VK | KR0036 | 2024-11-04T14:06:29.768Z | 2024-11-09T14:22:46.655Z |
5465696 | 5465696 | 20241102131447_T0wrd | KR0036 | 2024-11-04T14:06:16.260Z | 2024-11-09T14:22:46.421Z |
5465691 | 5465691 | 20241102130957_gC1UE | KR0036 | 2024-11-04T14:06:14.856Z | 2024-11-09T14:22:46.341Z |
5465638 | 5465638 | 20241102123849_W3jsE | KR0036 | 2024-11-04T14:06:01.792Z | 2024-11-09T14:22:45.859Z |
5465635 | 5465635 | 20241102123715_XpXyb | KR0036 | 2024-11-04T14:06:01.117Z | 2024-11-09T14:22:45.816Z |
5465617 | 5465617 | 20241102122410_Pq17o | KR0036 | 2024-11-04T14:05:56.889Z | 2024-11-09T14:22:45.612Z |
5465569 | 5465569 | 20241102113533_EiLWQ | KR0036 | 2024-11-04T14:05:28.608Z | 2024-11-09T14:22:44.202Z |
5465564 | 5465564 | 20241102113320_2UU7r | KR0036 | 2024-11-04T14:05:27.618Z | 2024-11-09T14:22:44.075Z |
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 |
5428215 | 5428215 | 20241028163823_MG6Dw | KR0036 | 2024-10-31T12:14:46.922Z | 2024-11-06T14:27:13.069Z |
5428174 | 5428174 | 20241028163414_A2dHE | KR0036 | 2024-10-31T12:14:42.122Z | 2024-11-06T14:27:13.021Z |
5428144 | 5428144 | 20241028163032_WQ1mc | KR0036 | 2024-10-31T12:14:38.035Z | 2024-11-06T14:27:13.004Z |
5428135 | 5428135 | 20241028162732_hWViK | KR0036 | 2024-10-31T12:14:36.775Z | 2024-11-06T14:27:12.997Z |
5428057 | 5428057 | 20241028161626_43uYP | KR0036 | 2024-10-31T12:14:29.906Z | 2024-11-06T14:27:12.940Z |
5428034 | 5428034 | 20241028161442_yk8yT | KR0036 | 2024-10-31T12:14:28.544Z | 2024-11-06T14:27:12.920Z |
5428012 | 5428012 | 20241028161227_SQyJT | KR0036 | 2024-10-31T12:14:26.211Z | 2024-11-06T14:27:12.901Z |
5428008 | 5428008 | 20241028161204_dpvLQ | KR0036 | 2024-10-31T12:14:25.754Z | 2024-11-06T14:27:12.900Z |
5427966 | 5427966 | 20241028160600_cDpAJ | KR0036 | 2024-10-31T12:14:19.891Z | 2024-11-06T14:27:12.861Z |
5427740 | 5427740 | 20241028153925_8IKfa | KR0036 | 2024-10-31T12:13:53.796Z | 2024-11-06T14:27:12.422Z |
5427718 | 5427718 | 20241028153717_zWb09 | KR0036 | 2024-10-31T12:13:52.652Z | 2024-11-06T14:27:12.410Z |
5426575 | 5426575 | 20241028132907_vNHL1 | KR0036 | 2024-10-31T12:12:14.183Z | 2024-11-06T14:27:10.413Z |
5426534 | 5426534 | 20241029200545_yZndc | KR0036 | 2024-10-31T12:10:15.468Z | 2024-11-07T14:26:39.837Z |
5425168 | 5425168 | 20241029160353_2tIfZ | KR0036 | 2024-10-31T12:07:01.795Z | 2024-11-07T14:26:33.897Z |
5425063 | 5425063 | 20241029154653_hbTvE | KR0036 | 2024-10-31T12:06:45.491Z | 2024-11-07T14:26:33.597Z |
5424995 | 5424995 | 20241029153903_VQ1Ro | KR0036 | 2024-10-31T12:06:38.730Z | 2024-11-07T14:26:33.418Z |
5422227 | 5422227 | 20241028123359_EiZky | KR0036 | 2024-10-30T12:20:23.987Z | 2024-11-06T14:27:09.649Z |
5417057 | 5417057 | 20241027173935_l6Ocr | KR0036 | 2024-10-30T12:12:49.864Z | 2024-11-05T14:27:06.312Z |
5416686 | 5416686 | 20241027163655_byAzj | KR0036 | 2024-10-30T12:12:10.398Z | 2024-11-05T14:27:05.157Z |
5416602 | 5416602 | 20241027161733_8LH8A | KR0036 | 2024-10-30T12:11:51.660Z | 2024-11-05T14:27:05.068Z |
5416528 | 5416528 | 20241027160510_TgJXq | KR0036 | 2024-10-30T12:11:42.657Z | 2024-11-05T14:27:04.950Z |
5416375 | 5416375 | 20241027154630_ni24J | KR0036 | 2024-10-30T12:11:31.349Z | 2024-11-05T14:27:04.798Z |
5415662 | 5415662 | 20241027142203_DfbN2 | KR0036 | 2024-10-30T12:10:16.734Z | 2024-11-05T14:27:03.871Z |
5415640 | 5415640 | 20241027142105_8O0wv | KR0036 | 2024-10-30T12:10:10.695Z | 2024-11-05T14:27:03.820Z |
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);