ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
107 rows where "date" is on date 2020-04-16 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Adair 1
- Allen 1
- Anderson 1
- Ballard 1
- Barren 1
- Bath 1
- Boone 1
- Bourbon 1
- Boyd 1
- Boyle 1
- Bracken 1
- Breathitt 1
- Breckinridge 1
- Bullitt 1
- Butler 1
- Caldwell 1
- Calloway 1
- Campbell 1
- Carroll 1
- Carter 1
- Casey 1
- Christian 1
- Clark 1
- Clinton 1
- Crittenden 1
- Cumberland 1
- Daviess 1
- Edmonson 1
- Fayette 1
- Fleming 1
- …
state 1
- Kentucky · 107 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
62768 | 62768 | 2020-04-16 | Adair | Kentucky | 21001 | 46 | 3 |
62769 | 62769 | 2020-04-16 | Allen | Kentucky | 21003 | 3 | 0 |
62770 | 62770 | 2020-04-16 | Anderson | Kentucky | 21005 | 5 | 1 |
62771 | 62771 | 2020-04-16 | Ballard | Kentucky | 21007 | 4 | 0 |
62772 | 62772 | 2020-04-16 | Barren | Kentucky | 21009 | 7 | 0 |
62773 | 62773 | 2020-04-16 | Bath | Kentucky | 21011 | 3 | 0 |
62774 | 62774 | 2020-04-16 | Boone | Kentucky | 21015 | 67 | 2 |
62775 | 62775 | 2020-04-16 | Bourbon | Kentucky | 21017 | 7 | 1 |
62776 | 62776 | 2020-04-16 | Boyd | Kentucky | 21019 | 27 | 2 |
62777 | 62777 | 2020-04-16 | Boyle | Kentucky | 21021 | 13 | 0 |
62778 | 62778 | 2020-04-16 | Bracken | Kentucky | 21023 | 7 | 0 |
62779 | 62779 | 2020-04-16 | Breathitt | Kentucky | 21025 | 3 | 0 |
62780 | 62780 | 2020-04-16 | Breckinridge | Kentucky | 21027 | 4 | 0 |
62781 | 62781 | 2020-04-16 | Bullitt | Kentucky | 21029 | 32 | 2 |
62782 | 62782 | 2020-04-16 | Butler | Kentucky | 21031 | 52 | 3 |
62783 | 62783 | 2020-04-16 | Caldwell | Kentucky | 21033 | 10 | 0 |
62784 | 62784 | 2020-04-16 | Calloway | Kentucky | 21035 | 22 | 1 |
62785 | 62785 | 2020-04-16 | Campbell | Kentucky | 21037 | 53 | 5 |
62786 | 62786 | 2020-04-16 | Carroll | Kentucky | 21041 | 2 | 0 |
62787 | 62787 | 2020-04-16 | Carter | Kentucky | 21043 | 5 | 0 |
62788 | 62788 | 2020-04-16 | Casey | Kentucky | 21045 | 1 | 0 |
62789 | 62789 | 2020-04-16 | Christian | Kentucky | 21047 | 73 | 3 |
62790 | 62790 | 2020-04-16 | Clark | Kentucky | 21049 | 18 | 0 |
62791 | 62791 | 2020-04-16 | Clinton | Kentucky | 21053 | 2 | 0 |
62792 | 62792 | 2020-04-16 | Crittenden | Kentucky | 21055 | 3 | 0 |
62793 | 62793 | 2020-04-16 | Cumberland | Kentucky | 21057 | 2 | 0 |
62794 | 62794 | 2020-04-16 | Daviess | Kentucky | 21059 | 106 | 3 |
62795 | 62795 | 2020-04-16 | Edmonson | Kentucky | 21061 | 7 | 0 |
62796 | 62796 | 2020-04-16 | Fayette | Kentucky | 21067 | 213 | 7 |
62797 | 62797 | 2020-04-16 | Fleming | Kentucky | 21069 | 2 | 0 |
62798 | 62798 | 2020-04-16 | Floyd | Kentucky | 21071 | 4 | 0 |
62799 | 62799 | 2020-04-16 | Franklin | Kentucky | 21073 | 11 | 0 |
62800 | 62800 | 2020-04-16 | Gallatin | Kentucky | 21077 | 1 | 0 |
62801 | 62801 | 2020-04-16 | Garrard | Kentucky | 21079 | 3 | 0 |
62802 | 62802 | 2020-04-16 | Grant | Kentucky | 21081 | 16 | 1 |
62803 | 62803 | 2020-04-16 | Graves | Kentucky | 21083 | 24 | 1 |
62804 | 62804 | 2020-04-16 | Grayson | Kentucky | 21085 | 6 | 0 |
62805 | 62805 | 2020-04-16 | Green | Kentucky | 21087 | 1 | 0 |
62806 | 62806 | 2020-04-16 | Greenup | Kentucky | 21089 | 11 | 0 |
62807 | 62807 | 2020-04-16 | Hancock | Kentucky | 21091 | 6 | 0 |
62808 | 62808 | 2020-04-16 | Hardin | Kentucky | 21093 | 27 | 0 |
62809 | 62809 | 2020-04-16 | Harrison | Kentucky | 21097 | 16 | 0 |
62810 | 62810 | 2020-04-16 | Hart | Kentucky | 21099 | 1 | 0 |
62811 | 62811 | 2020-04-16 | Henderson | Kentucky | 21101 | 28 | 0 |
62812 | 62812 | 2020-04-16 | Henry | Kentucky | 21103 | 3 | 0 |
62813 | 62813 | 2020-04-16 | Hopkins | Kentucky | 21107 | 111 | 10 |
62814 | 62814 | 2020-04-16 | Jackson | Kentucky | 21109 | 37 | 2 |
62815 | 62815 | 2020-04-16 | Jefferson | Kentucky | 21111 | 600 | 56 |
62816 | 62816 | 2020-04-16 | Jessamine | Kentucky | 21113 | 30 | 0 |
62817 | 62817 | 2020-04-16 | Johnson | Kentucky | 21115 | 1 | 0 |
62818 | 62818 | 2020-04-16 | Kenton | Kentucky | 21117 | 112 | 10 |
62819 | 62819 | 2020-04-16 | Knott | Kentucky | 21119 | 1 | 0 |
62820 | 62820 | 2020-04-16 | Knox | Kentucky | 21121 | 3 | 0 |
62821 | 62821 | 2020-04-16 | Larue | Kentucky | 21123 | 4 | 0 |
62822 | 62822 | 2020-04-16 | Laurel | Kentucky | 21125 | 12 | 2 |
62823 | 62823 | 2020-04-16 | Lawrence | Kentucky | 21127 | 1 | 0 |
62824 | 62824 | 2020-04-16 | Leslie | Kentucky | 21131 | 2 | 0 |
62825 | 62825 | 2020-04-16 | Letcher | Kentucky | 21133 | 1 | 0 |
62826 | 62826 | 2020-04-16 | Lewis | Kentucky | 21135 | 2 | 0 |
62827 | 62827 | 2020-04-16 | Lincoln | Kentucky | 21137 | 3 | 1 |
62828 | 62828 | 2020-04-16 | Livingston | Kentucky | 21139 | 1 | 0 |
62829 | 62829 | 2020-04-16 | Logan | Kentucky | 21141 | 8 | 0 |
62830 | 62830 | 2020-04-16 | Lyon | Kentucky | 21143 | 13 | 2 |
62831 | 62831 | 2020-04-16 | Madison | Kentucky | 21151 | 21 | 1 |
62832 | 62832 | 2020-04-16 | Marion | Kentucky | 21155 | 12 | 0 |
62833 | 62833 | 2020-04-16 | Marshall | Kentucky | 21157 | 12 | 0 |
62834 | 62834 | 2020-04-16 | Martin | Kentucky | 21159 | 2 | 0 |
62835 | 62835 | 2020-04-16 | Mason | Kentucky | 21161 | 6 | 0 |
62836 | 62836 | 2020-04-16 | McCracken | Kentucky | 21145 | 28 | 2 |
62837 | 62837 | 2020-04-16 | McCreary | Kentucky | 21147 | 9 | 0 |
62838 | 62838 | 2020-04-16 | McLean | Kentucky | 21149 | 6 | 0 |
62839 | 62839 | 2020-04-16 | Meade | Kentucky | 21163 | 2 | 1 |
62840 | 62840 | 2020-04-16 | Menifee | Kentucky | 21165 | 3 | 0 |
62841 | 62841 | 2020-04-16 | Mercer | Kentucky | 21167 | 9 | 0 |
62842 | 62842 | 2020-04-16 | Monroe | Kentucky | 21171 | 3 | 0 |
62843 | 62843 | 2020-04-16 | Montgomery | Kentucky | 21173 | 9 | 0 |
62844 | 62844 | 2020-04-16 | Morgan | Kentucky | 21175 | 1 | 0 |
62845 | 62845 | 2020-04-16 | Muhlenberg | Kentucky | 21177 | 55 | 2 |
62846 | 62846 | 2020-04-16 | Nelson | Kentucky | 21179 | 14 | 0 |
62847 | 62847 | 2020-04-16 | Nicholas | Kentucky | 21181 | 1 | 0 |
62848 | 62848 | 2020-04-16 | Ohio | Kentucky | 21183 | 11 | 0 |
62849 | 62849 | 2020-04-16 | Oldham | Kentucky | 21185 | 22 | 0 |
62850 | 62850 | 2020-04-16 | Owsley | Kentucky | 21189 | 2 | 0 |
62851 | 62851 | 2020-04-16 | Pendleton | Kentucky | 21191 | 5 | 0 |
62852 | 62852 | 2020-04-16 | Perry | Kentucky | 21193 | 4 | 0 |
62853 | 62853 | 2020-04-16 | Pike | Kentucky | 21195 | 6 | 1 |
62854 | 62854 | 2020-04-16 | Powell | Kentucky | 21197 | 1 | 0 |
62855 | 62855 | 2020-04-16 | Pulaski | Kentucky | 21199 | 33 | 2 |
62856 | 62856 | 2020-04-16 | Rockcastle | Kentucky | 21203 | 11 | 0 |
62857 | 62857 | 2020-04-16 | Rowan | Kentucky | 21205 | 1 | 0 |
62858 | 62858 | 2020-04-16 | Russell | Kentucky | 21207 | 12 | 0 |
62859 | 62859 | 2020-04-16 | Scott | Kentucky | 21209 | 27 | 0 |
62860 | 62860 | 2020-04-16 | Shelby | Kentucky | 21211 | 21 | 2 |
62861 | 62861 | 2020-04-16 | Simpson | Kentucky | 21213 | 19 | 2 |
62862 | 62862 | 2020-04-16 | Spencer | Kentucky | 21215 | 8 | 0 |
62863 | 62863 | 2020-04-16 | Taylor | Kentucky | 21217 | 4 | 0 |
62864 | 62864 | 2020-04-16 | Todd | Kentucky | 21219 | 10 | 0 |
62865 | 62865 | 2020-04-16 | Trigg | Kentucky | 21221 | 4 | 0 |
62866 | 62866 | 2020-04-16 | Trimble | Kentucky | 21223 | 1 | 0 |
62867 | 62867 | 2020-04-16 | Union | Kentucky | 21225 | 6 | 0 |
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);