ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where date = "2020-12-13" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
824076 | 824076 | 2020-12-13 | Adair | Kentucky | 21001 | 1174 | 39 |
824077 | 824077 | 2020-12-13 | Allen | Kentucky | 21003 | 903 | 16 |
824078 | 824078 | 2020-12-13 | Anderson | Kentucky | 21005 | 712 | 1 |
824079 | 824079 | 2020-12-13 | Ballard | Kentucky | 21007 | 200 | 2 |
824080 | 824080 | 2020-12-13 | Barren | Kentucky | 21009 | 2290 | 35 |
824081 | 824081 | 2020-12-13 | Bath | Kentucky | 21011 | 386 | 1 |
824082 | 824082 | 2020-12-13 | Bell | Kentucky | 21013 | 1515 | 21 |
824083 | 824083 | 2020-12-13 | Boone | Kentucky | 21015 | 6376 | 35 |
824084 | 824084 | 2020-12-13 | Bourbon | Kentucky | 21017 | 705 | 1 |
824085 | 824085 | 2020-12-13 | Boyd | Kentucky | 21019 | 2550 | 28 |
824086 | 824086 | 2020-12-13 | Boyle | Kentucky | 21021 | 1526 | 0 |
824087 | 824087 | 2020-12-13 | Bracken | Kentucky | 21023 | 224 | 3 |
824088 | 824088 | 2020-12-13 | Breathitt | Kentucky | 21025 | 460 | 3 |
824089 | 824089 | 2020-12-13 | Breckinridge | Kentucky | 21027 | 531 | 4 |
824090 | 824090 | 2020-12-13 | Bullitt | Kentucky | 21029 | 3581 | 25 |
824091 | 824091 | 2020-12-13 | Butler | Kentucky | 21031 | 675 | 16 |
824092 | 824092 | 2020-12-13 | Caldwell | Kentucky | 21033 | 792 | 12 |
824093 | 824093 | 2020-12-13 | Calloway | Kentucky | 21035 | 2069 | 17 |
824094 | 824094 | 2020-12-13 | Campbell | Kentucky | 21037 | 3874 | 24 |
824095 | 824095 | 2020-12-13 | Carlisle | Kentucky | 21039 | 254 | 1 |
824096 | 824096 | 2020-12-13 | Carroll | Kentucky | 21041 | 443 | 6 |
824097 | 824097 | 2020-12-13 | Carter | Kentucky | 21043 | 1004 | 5 |
824098 | 824098 | 2020-12-13 | Casey | Kentucky | 21045 | 789 | 23 |
824099 | 824099 | 2020-12-13 | Christian | Kentucky | 21047 | 3500 | 52 |
824100 | 824100 | 2020-12-13 | Clark | Kentucky | 21049 | 1205 | 13 |
824101 | 824101 | 2020-12-13 | Clay | Kentucky | 21051 | 1231 | 8 |
824102 | 824102 | 2020-12-13 | Clinton | Kentucky | 21053 | 654 | 16 |
824103 | 824103 | 2020-12-13 | Crittenden | Kentucky | 21055 | 304 | 3 |
824104 | 824104 | 2020-12-13 | Cumberland | Kentucky | 21057 | 361 | 3 |
824105 | 824105 | 2020-12-13 | Daviess | Kentucky | 21059 | 4588 | 71 |
824106 | 824106 | 2020-12-13 | Edmonson | Kentucky | 21061 | 467 | 13 |
824107 | 824107 | 2020-12-13 | Elliott | Kentucky | 21063 | 720 | 1 |
824108 | 824108 | 2020-12-13 | Estill | Kentucky | 21065 | 563 | 0 |
824109 | 824109 | 2020-12-13 | Fayette | Kentucky | 21067 | 20682 | 143 |
824110 | 824110 | 2020-12-13 | Fleming | Kentucky | 21069 | 530 | 1 |
824111 | 824111 | 2020-12-13 | Floyd | Kentucky | 21071 | 1543 | 9 |
824112 | 824112 | 2020-12-13 | Franklin | Kentucky | 21073 | 1809 | 17 |
824113 | 824113 | 2020-12-13 | Fulton | Kentucky | 21075 | 327 | 4 |
824114 | 824114 | 2020-12-13 | Gallatin | Kentucky | 21077 | 385 | 9 |
824115 | 824115 | 2020-12-13 | Garrard | Kentucky | 21079 | 794 | 4 |
824116 | 824116 | 2020-12-13 | Grant | Kentucky | 21081 | 1042 | 6 |
824117 | 824117 | 2020-12-13 | Graves | Kentucky | 21083 | 2205 | 40 |
824118 | 824118 | 2020-12-13 | Grayson | Kentucky | 21085 | 1102 | 25 |
824119 | 824119 | 2020-12-13 | Green | Kentucky | 21087 | 696 | 10 |
824120 | 824120 | 2020-12-13 | Greenup | Kentucky | 21089 | 1855 | 17 |
824121 | 824121 | 2020-12-13 | Hancock | Kentucky | 21091 | 364 | 12 |
824122 | 824122 | 2020-12-13 | Hardin | Kentucky | 21093 | 5178 | 38 |
824123 | 824123 | 2020-12-13 | Harlan | Kentucky | 21095 | 1222 | 16 |
824124 | 824124 | 2020-12-13 | Harrison | Kentucky | 21097 | 597 | 1 |
824125 | 824125 | 2020-12-13 | Hart | Kentucky | 21099 | 1114 | 5 |
824126 | 824126 | 2020-12-13 | Henderson | Kentucky | 21101 | 2491 | 47 |
824127 | 824127 | 2020-12-13 | Henry | Kentucky | 21103 | 667 | 3 |
824128 | 824128 | 2020-12-13 | Hickman | Kentucky | 21105 | 204 | 3 |
824129 | 824129 | 2020-12-13 | Hopkins | Kentucky | 21107 | 2211 | 77 |
824130 | 824130 | 2020-12-13 | Jackson | Kentucky | 21109 | 735 | 18 |
824131 | 824131 | 2020-12-13 | Jefferson | Kentucky | 21111 | 45564 | 578 |
824132 | 824132 | 2020-12-13 | Jessamine | Kentucky | 21113 | 2282 | 38 |
824133 | 824133 | 2020-12-13 | Johnson | Kentucky | 21115 | 973 | 11 |
824134 | 824134 | 2020-12-13 | Kenton | Kentucky | 21117 | 7277 | 65 |
824135 | 824135 | 2020-12-13 | Knott | Kentucky | 21119 | 650 | 9 |
824136 | 824136 | 2020-12-13 | Knox | Kentucky | 21121 | 1461 | 10 |
824137 | 824137 | 2020-12-13 | Larue | Kentucky | 21123 | 698 | 2 |
824138 | 824138 | 2020-12-13 | Laurel | Kentucky | 21125 | 2982 | 12 |
824139 | 824139 | 2020-12-13 | Lawrence | Kentucky | 21127 | 557 | 3 |
824140 | 824140 | 2020-12-13 | Lee | Kentucky | 21129 | 997 | 17 |
824141 | 824141 | 2020-12-13 | Leslie | Kentucky | 21131 | 381 | 1 |
824142 | 824142 | 2020-12-13 | Letcher | Kentucky | 21133 | 706 | 2 |
824143 | 824143 | 2020-12-13 | Lewis | Kentucky | 21135 | 638 | 22 |
824144 | 824144 | 2020-12-13 | Lincoln | Kentucky | 21137 | 1092 | 20 |
824145 | 824145 | 2020-12-13 | Livingston | Kentucky | 21139 | 410 | 4 |
824146 | 824146 | 2020-12-13 | Logan | Kentucky | 21141 | 1425 | 36 |
824147 | 824147 | 2020-12-13 | Lyon | Kentucky | 21143 | 256 | 5 |
824148 | 824148 | 2020-12-13 | Madison | Kentucky | 21151 | 4843 | 20 |
824149 | 824149 | 2020-12-13 | Magoffin | Kentucky | 21153 | 646 | 1 |
824150 | 824150 | 2020-12-13 | Marion | Kentucky | 21155 | 1328 | 14 |
824151 | 824151 | 2020-12-13 | Marshall | Kentucky | 21157 | 1216 | 18 |
824152 | 824152 | 2020-12-13 | Martin | Kentucky | 21159 | 550 | 10 |
824153 | 824153 | 2020-12-13 | Mason | Kentucky | 21161 | 743 | 5 |
824154 | 824154 | 2020-12-13 | McCracken | Kentucky | 21145 | 3751 | 31 |
824155 | 824155 | 2020-12-13 | McCreary | Kentucky | 21147 | 847 | 2 |
824156 | 824156 | 2020-12-13 | McLean | Kentucky | 21149 | 477 | 20 |
824157 | 824157 | 2020-12-13 | Meade | Kentucky | 21163 | 918 | 4 |
824158 | 824158 | 2020-12-13 | Menifee | Kentucky | 21165 | 148 | 1 |
824159 | 824159 | 2020-12-13 | Mercer | Kentucky | 21167 | 1038 | 6 |
824160 | 824160 | 2020-12-13 | Metcalfe | Kentucky | 21169 | 510 | 7 |
824161 | 824161 | 2020-12-13 | Monroe | Kentucky | 21171 | 837 | 18 |
824162 | 824162 | 2020-12-13 | Montgomery | Kentucky | 21173 | 1185 | 12 |
824163 | 824163 | 2020-12-13 | Morgan | Kentucky | 21175 | 413 | 0 |
824164 | 824164 | 2020-12-13 | Muhlenberg | Kentucky | 21177 | 1655 | 30 |
824165 | 824165 | 2020-12-13 | Nelson | Kentucky | 21179 | 2511 | 12 |
824166 | 824166 | 2020-12-13 | Nicholas | Kentucky | 21181 | 204 | 3 |
824167 | 824167 | 2020-12-13 | Ohio | Kentucky | 21183 | 1299 | 24 |
824168 | 824168 | 2020-12-13 | Oldham | Kentucky | 21185 | 3065 | 39 |
824169 | 824169 | 2020-12-13 | Owen | Kentucky | 21187 | 312 | 3 |
824170 | 824170 | 2020-12-13 | Owsley | Kentucky | 21189 | 263 | 4 |
824171 | 824171 | 2020-12-13 | Pendleton | Kentucky | 21191 | 510 | 1 |
824172 | 824172 | 2020-12-13 | Perry | Kentucky | 21193 | 1338 | 11 |
824173 | 824173 | 2020-12-13 | Pike | Kentucky | 21195 | 2270 | 30 |
824174 | 824174 | 2020-12-13 | Powell | Kentucky | 21197 | 592 | 0 |
824175 | 824175 | 2020-12-13 | Pulaski | Kentucky | 21199 | 2988 | 39 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);