ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,883 rows where date = "2020-03-28" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state >30
- Georgia 112
- Texas 110
- Indiana 75
- Virginia 75
- Mississippi 72
- Tennessee 67
- Ohio 66
- North Carolina 63
- Michigan 59
- Louisiana 57
- Kentucky 56
- Pennsylvania 56
- New York 55
- Alabama 54
- Missouri 54
- Florida 50
- Iowa 50
- California 47
- Arkansas 45
- Colorado 45
- Illinois 44
- Wisconsin 42
- Minnesota 41
- Oklahoma 40
- South Carolina 40
- Washington 35
- Kansas 33
- Oregon 24
- South Dakota 23
- Maryland 22
- …
fips >30
county >30
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
15804 | 15804 | 2020-03-28 | Autauga | Alabama | 1001 | 6 | 0 |
15805 | 15805 | 2020-03-28 | Baldwin | Alabama | 1003 | 10 | 0 |
15806 | 15806 | 2020-03-28 | Blount | Alabama | 1009 | 5 | 0 |
15807 | 15807 | 2020-03-28 | Bullock | Alabama | 1011 | 3 | 0 |
15808 | 15808 | 2020-03-28 | Butler | Alabama | 1013 | 1 | 0 |
15809 | 15809 | 2020-03-28 | Calhoun | Alabama | 1015 | 3 | 0 |
15810 | 15810 | 2020-03-28 | Chambers | Alabama | 1017 | 17 | 0 |
15811 | 15811 | 2020-03-28 | Cherokee | Alabama | 1019 | 1 | 0 |
15812 | 15812 | 2020-03-28 | Chilton | Alabama | 1021 | 7 | 0 |
15813 | 15813 | 2020-03-28 | Choctaw | Alabama | 1023 | 1 | 0 |
15814 | 15814 | 2020-03-28 | Clay | Alabama | 1027 | 2 | 0 |
15815 | 15815 | 2020-03-28 | Cleburne | Alabama | 1029 | 4 | 0 |
15816 | 15816 | 2020-03-28 | Colbert | Alabama | 1033 | 1 | 0 |
15817 | 15817 | 2020-03-28 | Coosa | Alabama | 1037 | 2 | 0 |
15818 | 15818 | 2020-03-28 | Covington | Alabama | 1039 | 2 | 0 |
15819 | 15819 | 2020-03-28 | Crenshaw | Alabama | 1041 | 1 | 0 |
15820 | 15820 | 2020-03-28 | Cullman | Alabama | 1043 | 7 | 0 |
15821 | 15821 | 2020-03-28 | Dallas | Alabama | 1047 | 2 | 0 |
15822 | 15822 | 2020-03-28 | DeKalb | Alabama | 1049 | 4 | 0 |
15823 | 15823 | 2020-03-28 | Elmore | Alabama | 1051 | 13 | 0 |
15824 | 15824 | 2020-03-28 | Escambia | Alabama | 1053 | 1 | 0 |
15825 | 15825 | 2020-03-28 | Etowah | Alabama | 1055 | 6 | 0 |
15826 | 15826 | 2020-03-28 | Franklin | Alabama | 1059 | 3 | 0 |
15827 | 15827 | 2020-03-28 | Greene | Alabama | 1063 | 3 | 0 |
15828 | 15828 | 2020-03-28 | Houston | Alabama | 1069 | 4 | 0 |
15829 | 15829 | 2020-03-28 | Jackson | Alabama | 1071 | 5 | 1 |
15830 | 15830 | 2020-03-28 | Jefferson | Alabama | 1073 | 214 | 0 |
15831 | 15831 | 2020-03-28 | Lamar | Alabama | 1075 | 1 | 0 |
15832 | 15832 | 2020-03-28 | Lauderdale | Alabama | 1077 | 13 | 1 |
15833 | 15833 | 2020-03-28 | Lawrence | Alabama | 1079 | 3 | 0 |
15834 | 15834 | 2020-03-28 | Lee | Alabama | 1081 | 56 | 0 |
15835 | 15835 | 2020-03-28 | Limestone | Alabama | 1083 | 16 | 0 |
15836 | 15836 | 2020-03-28 | Lowndes | Alabama | 1085 | 1 | 0 |
15837 | 15837 | 2020-03-28 | Madison | Alabama | 1089 | 62 | 1 |
15838 | 15838 | 2020-03-28 | Marengo | Alabama | 1091 | 3 | 0 |
15839 | 15839 | 2020-03-28 | Marion | Alabama | 1093 | 9 | 0 |
15840 | 15840 | 2020-03-28 | Marshall | Alabama | 1095 | 4 | 0 |
15841 | 15841 | 2020-03-28 | Mobile | Alabama | 1097 | 34 | 1 |
15842 | 15842 | 2020-03-28 | Monroe | Alabama | 1099 | 1 | 0 |
15843 | 15843 | 2020-03-28 | Montgomery | Alabama | 1101 | 18 | 0 |
15844 | 15844 | 2020-03-28 | Morgan | Alabama | 1103 | 15 | 0 |
15845 | 15845 | 2020-03-28 | Pickens | Alabama | 1107 | 1 | 0 |
15846 | 15846 | 2020-03-28 | Pike | Alabama | 1109 | 4 | 0 |
15847 | 15847 | 2020-03-28 | Randolph | Alabama | 1111 | 2 | 0 |
15848 | 15848 | 2020-03-28 | Russell | Alabama | 1113 | 1 | 0 |
15849 | 15849 | 2020-03-28 | Shelby | Alabama | 1117 | 72 | 0 |
15850 | 15850 | 2020-03-28 | St. Clair | Alabama | 1115 | 10 | 0 |
15851 | 15851 | 2020-03-28 | Talladega | Alabama | 1121 | 4 | 0 |
15852 | 15852 | 2020-03-28 | Tallapoosa | Alabama | 1123 | 5 | 0 |
15853 | 15853 | 2020-03-28 | Tuscaloosa | Alabama | 1125 | 23 | 0 |
15854 | 15854 | 2020-03-28 | Walker | Alabama | 1127 | 28 | 0 |
15855 | 15855 | 2020-03-28 | Washington | Alabama | 1129 | 2 | 0 |
15856 | 15856 | 2020-03-28 | Wilcox | Alabama | 1131 | 2 | 0 |
15857 | 15857 | 2020-03-28 | Winston | Alabama | 1133 | 2 | 0 |
15858 | 15858 | 2020-03-28 | Anchorage | Alaska | 2020 | 54 | 1 |
15859 | 15859 | 2020-03-28 | Fairbanks North Star Borough | Alaska | 2090 | 23 | 0 |
15860 | 15860 | 2020-03-28 | Juneau City and Borough | Alaska | 2110 | 4 | 0 |
15861 | 15861 | 2020-03-28 | Kenai Peninsula Borough | Alaska | 2122 | 7 | 0 |
15862 | 15862 | 2020-03-28 | Ketchikan Gateway Borough | Alaska | 2130 | 12 | 0 |
15863 | 15863 | 2020-03-28 | Matanuska-Susitna Borough | Alaska | 2170 | 2 | 0 |
15864 | 15864 | 2020-03-28 | Apache | Arizona | 4001 | 13 | 0 |
15865 | 15865 | 2020-03-28 | Cochise | Arizona | 4003 | 3 | 0 |
15866 | 15866 | 2020-03-28 | Coconino | Arizona | 4005 | 56 | 2 |
15867 | 15867 | 2020-03-28 | Gila | Arizona | 4007 | 1 | 0 |
15868 | 15868 | 2020-03-28 | Graham | Arizona | 4009 | 2 | 0 |
15869 | 15869 | 2020-03-28 | La Paz | Arizona | 4012 | 2 | 0 |
15870 | 15870 | 2020-03-28 | Maricopa | Arizona | 4013 | 454 | 5 |
15871 | 15871 | 2020-03-28 | Mohave | Arizona | 4015 | 5 | 0 |
15872 | 15872 | 2020-03-28 | Navajo | Arizona | 4017 | 57 | 0 |
15873 | 15873 | 2020-03-28 | Pima | Arizona | 4019 | 120 | 5 |
15874 | 15874 | 2020-03-28 | Pinal | Arizona | 4021 | 41 | 0 |
15875 | 15875 | 2020-03-28 | Santa Cruz | Arizona | 4023 | 2 | 0 |
15876 | 15876 | 2020-03-28 | Unknown | Arizona | 0 | 3 | |
15877 | 15877 | 2020-03-28 | Yavapai | Arizona | 4025 | 13 | 0 |
15878 | 15878 | 2020-03-28 | Yuma | Arizona | 4027 | 4 | 0 |
15879 | 15879 | 2020-03-28 | Baxter | Arkansas | 5005 | 1 | 0 |
15880 | 15880 | 2020-03-28 | Benton | Arkansas | 5007 | 29 | 0 |
15881 | 15881 | 2020-03-28 | Boone | Arkansas | 5009 | 1 | 0 |
15882 | 15882 | 2020-03-28 | Bradley | Arkansas | 5011 | 4 | 0 |
15883 | 15883 | 2020-03-28 | Chicot | Arkansas | 5017 | 1 | 0 |
15884 | 15884 | 2020-03-28 | Clark | Arkansas | 5019 | 18 | 0 |
15885 | 15885 | 2020-03-28 | Cleburne | Arkansas | 5023 | 50 | 2 |
15886 | 15886 | 2020-03-28 | Cleveland | Arkansas | 5025 | 5 | 0 |
15887 | 15887 | 2020-03-28 | Columbia | Arkansas | 5027 | 1 | 0 |
15888 | 15888 | 2020-03-28 | Conway | Arkansas | 5029 | 2 | 1 |
15889 | 15889 | 2020-03-28 | Craighead | Arkansas | 5031 | 4 | 0 |
15890 | 15890 | 2020-03-28 | Crawford | Arkansas | 5033 | 1 | 0 |
15891 | 15891 | 2020-03-28 | Crittenden | Arkansas | 5035 | 15 | 0 |
15892 | 15892 | 2020-03-28 | Cross | Arkansas | 5037 | 2 | 0 |
15893 | 15893 | 2020-03-28 | Desha | Arkansas | 5041 | 2 | 0 |
15894 | 15894 | 2020-03-28 | Drew | Arkansas | 5043 | 2 | 0 |
15895 | 15895 | 2020-03-28 | Faulkner | Arkansas | 5045 | 29 | 0 |
15896 | 15896 | 2020-03-28 | Garland | Arkansas | 5051 | 20 | 0 |
15897 | 15897 | 2020-03-28 | Grant | Arkansas | 5053 | 3 | 0 |
15898 | 15898 | 2020-03-28 | Greene | Arkansas | 5055 | 3 | 0 |
15899 | 15899 | 2020-03-28 | Hot Spring | Arkansas | 5059 | 1 | 0 |
15900 | 15900 | 2020-03-28 | Howard | Arkansas | 5061 | 3 | 0 |
15901 | 15901 | 2020-03-28 | Independence | Arkansas | 5063 | 3 | 0 |
15902 | 15902 | 2020-03-28 | Jefferson | Arkansas | 5069 | 25 | 0 |
15903 | 15903 | 2020-03-28 | Johnson | Arkansas | 5071 | 1 | 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);