participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,129 rows where station_code = "KR0037" 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 |
---|---|---|---|---|---|
5494682 | 5494682 | 20241106164943_5xfTZ | KR0037 | 2024-11-08T14:08:20.278Z | 2024-11-08T14:14:34.564Z |
5494657 | 5494657 | 20241106163859_ubruo | KR0037 | 2024-11-08T14:08:15.323Z | 2024-11-08T14:14:34.554Z |
5494645 | 5494645 | 20241106163522_egktw | KR0037 | 2024-11-08T14:08:13.070Z | 2024-11-08T14:14:34.548Z |
5494619 | 5494619 | 20241106162130_R1nSO | KR0037 | 2024-11-08T14:08:03.670Z | 2024-11-08T14:14:34.537Z |
5488985 | 5488985 | 20241105173051_ZVOl1 | KR0037 | 2024-11-07T14:11:08.070Z | 2024-11-08T14:15:51.477Z |
5488858 | 5488858 | 20241105170701_t2FPP | KR0037 | 2024-11-07T14:10:43.556Z | 2024-11-08T14:15:48.566Z |
5488805 | 5488805 | 20241105165558_GsOfi | KR0037 | 2024-11-07T14:10:38.216Z | 2024-11-08T14:15:47.678Z |
5488750 | 5488750 | 20241105164525_phCoX | KR0037 | 2024-11-07T14:10:34.248Z | 2024-11-08T14:15:46.912Z |
5488691 | 5488691 | 20241105162327_Lq60Y | KR0037 | 2024-11-07T14:10:29.106Z | 2024-11-08T14:15:44.235Z |
5488619 | 5488619 | 20241105155844_PAi33 | KR0037 | 2024-11-07T14:10:22.611Z | 2024-11-08T14:15:41.317Z |
5488616 | 5488616 | 20241105155749_ch33t | KR0037 | 2024-11-07T14:10:22.280Z | 2024-11-08T14:15:41.270Z |
5488600 | 5488600 | 20241105155505_2DVsD | KR0037 | 2024-11-07T14:10:21.686Z | 2024-11-08T14:15:41.002Z |
5488581 | 5488581 | 20241105154901_Bk3Gz | KR0037 | 2024-11-07T14:10:20.865Z | 2024-11-08T14:15:40.717Z |
5488469 | 5488469 | 20241105150604_zVQ6W | KR0037 | 2024-11-07T14:09:57.300Z | 2024-11-08T14:15:36.724Z |
5488466 | 5488466 | 20241105150504_1dLij | KR0037 | 2024-11-07T14:09:56.975Z | 2024-11-08T14:15:36.687Z |
5488395 | 5488395 | 20241105142549_Xb8pv | KR0037 | 2024-11-07T14:09:48.946Z | 2024-11-08T14:15:33.073Z |
5487630 | 5487630 | 20241106173744_s3Q1V | KR0037 | 2024-11-07T14:06:21.184Z | 2024-11-08T14:14:34.627Z |
5487607 | 5487607 | 20241106173024_ohD2B | KR0037 | 2024-11-07T14:06:18.467Z | 2024-11-08T14:14:34.617Z |
5487557 | 5487557 | 20241106171025_V8P8x | KR0037 | 2024-11-07T14:06:13.060Z | 2024-11-08T14:14:34.589Z |
5487521 | 5487521 | 20241106165142_rMa82 | KR0037 | 2024-11-07T14:06:08.485Z | 2024-11-08T14:14:34.566Z |
5487479 | 5487479 | 20241106163501_jov6T | KR0037 | 2024-11-07T14:05:59.661Z | 2024-11-08T14:14:34.548Z |
5487450 | 5487450 | 20241106161844_32INy | KR0037 | 2024-11-07T14:05:49.416Z | 2024-11-08T14:14:34.536Z |
5487443 | 5487443 | 20241106161623_iyEXV | KR0037 | 2024-11-07T14:05:47.880Z | 2024-11-08T14:14:34.534Z |
5487226 | 5487226 | 20241106151811_oHOXf | KR0037 | 2024-11-07T14:05:13.491Z | 2024-11-08T14:14:34.457Z |
5487215 | 5487215 | 20241106151641_wTYkQ | KR0037 | 2024-11-07T14:05:11.799Z | 2024-11-08T14:14:34.454Z |
5487185 | 5487185 | 20241106151027_rkkp7 | KR0037 | 2024-11-07T14:05:07.831Z | 2024-11-08T14:14:34.447Z |
5487158 | 5487158 | 20241106145954_eF1os | KR0037 | 2024-11-07T14:05:03.689Z | 2024-11-08T14:14:34.434Z |
5486997 | 5486997 | 20241106141723_FJw6I | KR0037 | 2024-11-07T14:04:34.555Z | 2024-11-08T14:14:34.387Z |
5475431 | 5475431 | 20241103200518_NbiWP | KR0037 | 2024-11-05T14:13:31.864Z | 2024-11-08T14:19:39.763Z |
5473571 | 5473571 | 20241103143335_7k2OF | KR0037 | 2024-11-05T14:09:07.529Z | 2024-11-08T14:19:17.816Z |
5473491 | 5473491 | 20241103142331_V2igN | KR0037 | 2024-11-05T14:08:59.845Z | 2024-11-08T14:19:17.132Z |
5466813 | 5466813 | 20241102190247_7blr9 | KR0037 | 2024-11-04T14:09:53.210Z | 2024-11-08T14:20:49.437Z |
5466740 | 5466740 | 20241102184400_scpz9 | KR0037 | 2024-11-04T14:09:40.141Z | 2024-11-08T14:20:49.102Z |
5466608 | 5466608 | 20241102181632_KfxO2 | KR0037 | 2024-11-04T14:09:24.883Z | 2024-11-08T14:20:47.765Z |
5466479 | 5466479 | 20241102174929_tQR2W | KR0037 | 2024-11-04T14:08:57.363Z | 2024-11-08T14:20:45.981Z |
5466369 | 5466369 | 20241102172420_buOuI | KR0037 | 2024-11-04T14:08:42.673Z | 2024-11-08T14:20:44.841Z |
5466355 | 5466355 | 20241102172130_BXgvu | KR0037 | 2024-11-04T14:08:41.403Z | 2024-11-08T14:20:44.809Z |
5466295 | 5466295 | 20241102170549_E9Gv5 | KR0037 | 2024-11-04T14:08:33.886Z | 2024-11-08T14:20:44.260Z |
5466250 | 5466250 | 20241102165736_az34H | KR0037 | 2024-11-04T14:08:26.541Z | 2024-11-08T14:20:43.811Z |
5466223 | 5466223 | 20241102165338_u12zA | KR0037 | 2024-11-04T14:08:17.965Z | 2024-11-08T14:20:43.470Z |
5466141 | 5466141 | 20241102163347_7wQaF | KR0037 | 2024-11-04T14:08:05.348Z | 2024-11-08T14:20:43.074Z |
5466033 | 5466033 | 20241102160451_XNAbN | KR0037 | 2024-11-04T14:07:54.369Z | 2024-11-08T14:20:42.351Z |
5465913 | 5465913 | 20241102151555_QhBZb | KR0037 | 2024-11-04T14:07:22.621Z | 2024-11-08T14:20:40.772Z |
5465883 | 5465883 | 20241102150605_m5vvc | KR0037 | 2024-11-04T14:07:17.386Z | 2024-11-08T14:20:40.057Z |
5465760 | 5465760 | 20241102135051_tRwCG | KR0037 | 2024-11-04T14:06:37.672Z | 2024-11-08T14:20:38.223Z |
5461577 | 5461577 | 20241101200424_bBCXE | KR0037 | 2024-11-03T14:15:56.648Z | 2024-11-08T14:21:44.097Z |
5449312 | 5449312 | 20241031151815_kyyfY | KR0037 | 2024-11-02T12:12:29.225Z | 2024-11-08T14:22:18.885Z |
5448554 | 5448554 | 20241031134602_VikD1 | KR0037 | 2024-11-02T12:11:05.093Z | 2024-11-08T14:22:16.762Z |
5448539 | 5448539 | 20241031134407_pxce2 | KR0037 | 2024-11-02T12:11:02.290Z | 2024-11-08T14:22:16.684Z |
5438660 | 5438660 | 20241030174807_qvw2J | KR0037 | 2024-11-01T12:12:14.573Z | 2024-11-08T14:23:00.501Z |
5438484 | 5438484 | 20241030172400_8jxuC | KR0037 | 2024-11-01T12:11:46.514Z | 2024-11-08T14:23:00.010Z |
5438465 | 5438465 | 20241030172251_4nPdX | KR0037 | 2024-11-01T12:11:44.916Z | 2024-11-08T14:23:00.003Z |
5438348 | 5438348 | 20241030170727_GtYcl | KR0037 | 2024-11-01T12:11:34.693Z | 2024-11-08T14:22:59.875Z |
5438261 | 5438261 | 20241030165132_3lM3z | KR0037 | 2024-11-01T12:11:25.879Z | 2024-11-08T14:22:59.225Z |
5438212 | 5438212 | 20241030164051_EPAL8 | KR0037 | 2024-11-01T12:11:19.480Z | 2024-11-08T14:22:59.196Z |
5438181 | 5438181 | 20241030163420_CO3O6 | KR0037 | 2024-11-01T12:11:08.528Z | 2024-11-08T14:22:58.889Z |
5438144 | 5438144 | 20241030162917_p4gu3 | KR0037 | 2024-11-01T12:11:05.061Z | 2024-11-08T14:22:58.865Z |
5438059 | 5438059 | 20241030161755_WROqW | KR0037 | 2024-11-01T12:10:55.302Z | 2024-11-08T14:22:58.770Z |
5438047 | 5438047 | 20241030161719_7MAox | KR0037 | 2024-11-01T12:10:54.607Z | 2024-11-08T14:22:58.755Z |
5437995 | 5437995 | 20241030161153_SP3x0 | KR0037 | 2024-11-01T12:10:50.239Z | 2024-11-08T14:22:58.578Z |
5437549 | 5437549 | 20241030151901_9SuJ8 | KR0037 | 2024-11-01T12:09:58.828Z | 2024-11-08T14:22:57.517Z |
5437487 | 5437487 | 20241030151239_VnfjP | KR0037 | 2024-11-01T12:09:51.424Z | 2024-11-08T14:22:57.256Z |
5433679 | 5433679 | 20241029204712_Pfyj6 | KR0037 | 2024-10-31T12:22:27.335Z | 2024-11-07T14:26:40.780Z |
5433646 | 5433646 | 20241029203604_s6ZH7 | KR0037 | 2024-10-31T12:22:25.837Z | 2024-11-07T14:26:40.473Z |
5429879 | 5429879 | 20241028201755_p3OpY | KR0037 | 2024-10-31T12:17:10.691Z | 2024-11-06T14:27:17.947Z |
5429579 | 5429579 | 20241028193905_QIUul | KR0037 | 2024-10-31T12:16:47.417Z | 2024-11-06T14:27:16.628Z |
5429241 | 5429241 | 20241028190346_i0E8z | KR0037 | 2024-10-31T12:16:16.084Z | 2024-11-06T14:27:15.588Z |
5429183 | 5429183 | 20241028185726_oZY0K | KR0037 | 2024-10-31T12:16:08.993Z | 2024-11-06T14:27:15.496Z |
5428802 | 5428802 | 20241028180819_8j3oC | KR0037 | 2024-10-31T12:15:31.877Z | 2024-11-06T14:27:14.405Z |
5428702 | 5428702 | 20241028175553_dWBqC | KR0037 | 2024-10-31T12:15:25.389Z | 2024-11-06T14:27:14.292Z |
5428518 | 5428518 | 20241028172613_IrjE7 | KR0037 | 2024-10-31T12:15:13.641Z | 2024-11-06T14:27:13.827Z |
5428466 | 5428466 | 20241028171850_qELg7 | KR0037 | 2024-10-31T12:15:11.053Z | 2024-11-06T14:27:13.768Z |
5427719 | 5427719 | 20241028153717_zWb09 | KR0037 | 2024-10-31T12:13:52.652Z | 2024-11-06T14:27:12.410Z |
5426502 | 5426502 | 20241029195749_SP2t2 | KR0037 | 2024-10-31T12:10:08.827Z | 2024-11-07T14:26:39.535Z |
5426008 | 5426008 | 20241029182718_rwdQv | KR0037 | 2024-10-31T12:09:05.277Z | 2024-11-07T14:26:37.016Z |
5425601 | 5425601 | 20241029172039_M1ZIb | KR0037 | 2024-10-31T12:08:10.616Z | 2024-11-07T14:26:35.242Z |
5425581 | 5425581 | 20241029171712_ewdWM | KR0037 | 2024-10-31T12:08:08.640Z | 2024-11-07T14:26:35.187Z |
5425334 | 5425334 | 20241029162818_htjgd | KR0037 | 2024-10-31T12:07:29.665Z | 2024-11-07T14:26:34.223Z |
5425169 | 5425169 | 20241029160353_2tIfZ | KR0037 | 2024-10-31T12:07:01.795Z | 2024-11-07T14:26:33.897Z |
5425085 | 5425085 | 20241029155045_GR63V | KR0037 | 2024-10-31T12:06:48.145Z | 2024-11-07T14:26:33.719Z |
5425029 | 5425029 | 20241029154309_3fJEx | KR0037 | 2024-10-31T12:06:41.511Z | 2024-11-07T14:26:33.509Z |
5424996 | 5424996 | 20241029153903_VQ1Ro | KR0037 | 2024-10-31T12:06:38.750Z | 2024-11-07T14:26:33.418Z |
5424973 | 5424973 | 20241029153726_ZVY64 | KR0037 | 2024-10-31T12:06:36.321Z | 2024-11-07T14:26:33.394Z |
5424901 | 5424901 | 20241029153009_M1DL5 | KR0037 | 2024-10-31T12:06:26.513Z | 2024-11-07T14:26:33.253Z |
5424123 | 5424123 | 20241029131744_WRREo | KR0037 | 2024-10-31T12:03:50.612Z | 2024-11-07T14:26:30.327Z |
5416783 | 5416783 | 20241027165508_sK6E3 | KR0037 | 2024-10-30T12:12:24.709Z | 2024-11-05T14:27:05.447Z |
5416687 | 5416687 | 20241027163655_byAzj | KR0037 | 2024-10-30T12:12:10.398Z | 2024-11-05T14:27:05.158Z |
5416620 | 5416620 | 20241027161953_a7se2 | KR0037 | 2024-10-30T12:11:54.845Z | 2024-11-05T14:27:05.074Z |
5393837 | 5393837 | 20241025185508_tw2YI | KR0037 | 2024-10-28T12:13:34.465Z | 2024-11-03T14:27:18.623Z |
5393666 | 5393666 | 20241025182843_CbrIJ | KR0037 | 2024-10-28T12:12:58.361Z | 2024-11-03T14:27:17.363Z |
5393246 | 5393246 | 20241025164217_WsivS | KR0037 | 2024-10-28T12:11:48.558Z | 2024-11-03T14:27:14.439Z |
5393039 | 5393039 | 20241025145427_NuGkk | KR0037 | 2024-10-28T12:11:23.707Z | 2024-11-03T14:27:13.551Z |
5392277 | 5392277 | 20241026154441_64wir | KR0037 | 2024-10-28T12:07:37.926Z | 2024-11-04T14:28:38.024Z |
5392217 | 5392217 | 20241026153035_FDCLQ | KR0037 | 2024-10-28T12:07:20.744Z | 2024-11-04T14:28:37.528Z |
5392138 | 5392138 | 20241026151721_lL8wC | KR0037 | 2024-10-28T12:07:13.230Z | 2024-11-04T14:28:37.381Z |
5389063 | 5389063 | 20241023160642_i0bLc | KR0037 | 2024-10-27T12:24:00.397Z | 2024-11-01T12:26:47.402Z |
5384673 | 5384673 | 20241024203654_8YFbS | KR0037 | 2024-10-27T12:17:26.173Z | 2024-11-02T12:28:27.591Z |
5383754 | 5383754 | 20241024185616_iib3Y | KR0037 | 2024-10-27T12:16:07.162Z | 2024-11-02T12:28:26.272Z |
5383616 | 5383616 | 20241024183834_vLzns | KR0037 | 2024-10-27T12:15:53.050Z | 2024-11-02T12:28:26.087Z |
5383539 | 5383539 | 20241024183142_QAsl3 | KR0037 | 2024-10-27T12:15:42.748Z | 2024-11-02T12:28:25.741Z |
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);