ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,778 rows where date = "2020-03-27" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state >30
- Georgia 106
- Texas 105
- Indiana 69
- Mississippi 69
- Virginia 69
- Ohio 61
- North Carolina 60
- Tennessee 59
- Michigan 58
- Louisiana 55
- Alabama 53
- New York 53
- Missouri 52
- Florida 49
- Pennsylvania 49
- California 46
- Iowa 46
- Kentucky 46
- Arkansas 44
- Colorado 43
- Minnesota 41
- Wisconsin 41
- Illinois 40
- South Carolina 39
- Oklahoma 38
- Washington 35
- Kansas 32
- Oregon 24
- Maryland 22
- New Jersey 22
- …
fips >30
county >30
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
14026 | 14026 | 2020-03-27 | Autauga | Alabama | 1001 | 6 | 0 |
14027 | 14027 | 2020-03-27 | Baldwin | Alabama | 1003 | 5 | 0 |
14028 | 14028 | 2020-03-27 | Blount | Alabama | 1009 | 5 | 0 |
14029 | 14029 | 2020-03-27 | Bullock | Alabama | 1011 | 2 | 0 |
14030 | 14030 | 2020-03-27 | Butler | Alabama | 1013 | 1 | 0 |
14031 | 14031 | 2020-03-27 | Calhoun | Alabama | 1015 | 3 | 0 |
14032 | 14032 | 2020-03-27 | Chambers | Alabama | 1017 | 15 | 0 |
14033 | 14033 | 2020-03-27 | Cherokee | Alabama | 1019 | 1 | 0 |
14034 | 14034 | 2020-03-27 | Chilton | Alabama | 1021 | 7 | 0 |
14035 | 14035 | 2020-03-27 | Choctaw | Alabama | 1023 | 1 | 0 |
14036 | 14036 | 2020-03-27 | Clay | Alabama | 1027 | 1 | 0 |
14037 | 14037 | 2020-03-27 | Cleburne | Alabama | 1029 | 3 | 0 |
14038 | 14038 | 2020-03-27 | Colbert | Alabama | 1033 | 1 | 0 |
14039 | 14039 | 2020-03-27 | Coosa | Alabama | 1037 | 2 | 0 |
14040 | 14040 | 2020-03-27 | Covington | Alabama | 1039 | 2 | 0 |
14041 | 14041 | 2020-03-27 | Crenshaw | Alabama | 1041 | 1 | 0 |
14042 | 14042 | 2020-03-27 | Cullman | Alabama | 1043 | 7 | 0 |
14043 | 14043 | 2020-03-27 | Dallas | Alabama | 1047 | 2 | 0 |
14044 | 14044 | 2020-03-27 | DeKalb | Alabama | 1049 | 4 | 0 |
14045 | 14045 | 2020-03-27 | Elmore | Alabama | 1051 | 12 | 0 |
14046 | 14046 | 2020-03-27 | Escambia | Alabama | 1053 | 1 | 0 |
14047 | 14047 | 2020-03-27 | Etowah | Alabama | 1055 | 5 | 0 |
14048 | 14048 | 2020-03-27 | Franklin | Alabama | 1059 | 3 | 0 |
14049 | 14049 | 2020-03-27 | Greene | Alabama | 1063 | 1 | 0 |
14050 | 14050 | 2020-03-27 | Houston | Alabama | 1069 | 4 | 0 |
14051 | 14051 | 2020-03-27 | Jackson | Alabama | 1071 | 5 | 1 |
14052 | 14052 | 2020-03-27 | Jefferson | Alabama | 1073 | 179 | 0 |
14053 | 14053 | 2020-03-27 | Lamar | Alabama | 1075 | 1 | 0 |
14054 | 14054 | 2020-03-27 | Lauderdale | Alabama | 1077 | 11 | 1 |
14055 | 14055 | 2020-03-27 | Lawrence | Alabama | 1079 | 3 | 0 |
14056 | 14056 | 2020-03-27 | Lee | Alabama | 1081 | 53 | 0 |
14057 | 14057 | 2020-03-27 | Limestone | Alabama | 1083 | 16 | 0 |
14058 | 14058 | 2020-03-27 | Lowndes | Alabama | 1085 | 1 | 0 |
14059 | 14059 | 2020-03-27 | Madison | Alabama | 1089 | 61 | 1 |
14060 | 14060 | 2020-03-27 | Marengo | Alabama | 1091 | 2 | 0 |
14061 | 14061 | 2020-03-27 | Marion | Alabama | 1093 | 7 | 0 |
14062 | 14062 | 2020-03-27 | Marshall | Alabama | 1095 | 4 | 0 |
14063 | 14063 | 2020-03-27 | Mobile | Alabama | 1097 | 23 | 1 |
14064 | 14064 | 2020-03-27 | Montgomery | Alabama | 1101 | 18 | 0 |
14065 | 14065 | 2020-03-27 | Morgan | Alabama | 1103 | 13 | 0 |
14066 | 14066 | 2020-03-27 | Pickens | Alabama | 1107 | 1 | 0 |
14067 | 14067 | 2020-03-27 | Pike | Alabama | 1109 | 4 | 0 |
14068 | 14068 | 2020-03-27 | Randolph | Alabama | 1111 | 1 | 0 |
14069 | 14069 | 2020-03-27 | Russell | Alabama | 1113 | 1 | 0 |
14070 | 14070 | 2020-03-27 | Shelby | Alabama | 1117 | 70 | 0 |
14071 | 14071 | 2020-03-27 | St. Clair | Alabama | 1115 | 9 | 0 |
14072 | 14072 | 2020-03-27 | Talladega | Alabama | 1121 | 4 | 0 |
14073 | 14073 | 2020-03-27 | Tallapoosa | Alabama | 1123 | 5 | 0 |
14074 | 14074 | 2020-03-27 | Tuscaloosa | Alabama | 1125 | 22 | 0 |
14075 | 14075 | 2020-03-27 | Walker | Alabama | 1127 | 24 | 0 |
14076 | 14076 | 2020-03-27 | Washington | Alabama | 1129 | 2 | 0 |
14077 | 14077 | 2020-03-27 | Wilcox | Alabama | 1131 | 2 | 0 |
14078 | 14078 | 2020-03-27 | Winston | Alabama | 1133 | 2 | 0 |
14079 | 14079 | 2020-03-27 | Anchorage | Alaska | 2020 | 43 | 1 |
14080 | 14080 | 2020-03-27 | Fairbanks North Star Borough | Alaska | 2090 | 19 | 0 |
14081 | 14081 | 2020-03-27 | Juneau City and Borough | Alaska | 2110 | 4 | 0 |
14082 | 14082 | 2020-03-27 | Kenai Peninsula Borough | Alaska | 2122 | 5 | 0 |
14083 | 14083 | 2020-03-27 | Ketchikan Gateway Borough | Alaska | 2130 | 12 | 0 |
14084 | 14084 | 2020-03-27 | Matanuska-Susitna Borough | Alaska | 2170 | 2 | 0 |
14085 | 14085 | 2020-03-27 | Apache | Arizona | 4001 | 11 | 0 |
14086 | 14086 | 2020-03-27 | Cochise | Arizona | 4003 | 2 | 0 |
14087 | 14087 | 2020-03-27 | Coconino | Arizona | 4005 | 41 | 2 |
14088 | 14088 | 2020-03-27 | Graham | Arizona | 4009 | 4 | 0 |
14089 | 14089 | 2020-03-27 | La Paz | Arizona | 4012 | 2 | 0 |
14090 | 14090 | 2020-03-27 | Maricopa | Arizona | 4013 | 399 | 5 |
14091 | 14091 | 2020-03-27 | Mohave | Arizona | 4015 | 4 | 0 |
14092 | 14092 | 2020-03-27 | Navajo | Arizona | 4017 | 49 | 0 |
14093 | 14093 | 2020-03-27 | Pima | Arizona | 4019 | 102 | 4 |
14094 | 14094 | 2020-03-27 | Pinal | Arizona | 4021 | 36 | 0 |
14095 | 14095 | 2020-03-27 | Santa Cruz | Arizona | 4023 | 2 | 0 |
14096 | 14096 | 2020-03-27 | Unknown | Arizona | 0 | 4 | |
14097 | 14097 | 2020-03-27 | Yavapai | Arizona | 4025 | 9 | 0 |
14098 | 14098 | 2020-03-27 | Yuma | Arizona | 4027 | 4 | 0 |
14099 | 14099 | 2020-03-27 | Baxter | Arkansas | 5005 | 1 | 0 |
14100 | 14100 | 2020-03-27 | Benton | Arkansas | 5007 | 24 | 0 |
14101 | 14101 | 2020-03-27 | Boone | Arkansas | 5009 | 1 | 0 |
14102 | 14102 | 2020-03-27 | Bradley | Arkansas | 5011 | 4 | 0 |
14103 | 14103 | 2020-03-27 | Chicot | Arkansas | 5017 | 1 | 0 |
14104 | 14104 | 2020-03-27 | Clark | Arkansas | 5019 | 17 | 0 |
14105 | 14105 | 2020-03-27 | Cleburne | Arkansas | 5023 | 49 | 2 |
14106 | 14106 | 2020-03-27 | Cleveland | Arkansas | 5025 | 4 | 0 |
14107 | 14107 | 2020-03-27 | Columbia | Arkansas | 5027 | 1 | 0 |
14108 | 14108 | 2020-03-27 | Conway | Arkansas | 5029 | 2 | 0 |
14109 | 14109 | 2020-03-27 | Craighead | Arkansas | 5031 | 4 | 0 |
14110 | 14110 | 2020-03-27 | Crawford | Arkansas | 5033 | 1 | 0 |
14111 | 14111 | 2020-03-27 | Crittenden | Arkansas | 5035 | 12 | 0 |
14112 | 14112 | 2020-03-27 | Cross | Arkansas | 5037 | 1 | 0 |
14113 | 14113 | 2020-03-27 | Desha | Arkansas | 5041 | 2 | 0 |
14114 | 14114 | 2020-03-27 | Drew | Arkansas | 5043 | 2 | 0 |
14115 | 14115 | 2020-03-27 | Faulkner | Arkansas | 5045 | 28 | 0 |
14116 | 14116 | 2020-03-27 | Garland | Arkansas | 5051 | 20 | 0 |
14117 | 14117 | 2020-03-27 | Grant | Arkansas | 5053 | 3 | 0 |
14118 | 14118 | 2020-03-27 | Greene | Arkansas | 5055 | 3 | 0 |
14119 | 14119 | 2020-03-27 | Hot Spring | Arkansas | 5059 | 2 | 0 |
14120 | 14120 | 2020-03-27 | Howard | Arkansas | 5061 | 3 | 0 |
14121 | 14121 | 2020-03-27 | Independence | Arkansas | 5063 | 3 | 0 |
14122 | 14122 | 2020-03-27 | Jefferson | Arkansas | 5069 | 23 | 0 |
14123 | 14123 | 2020-03-27 | Lawrence | Arkansas | 5075 | 3 | 0 |
14124 | 14124 | 2020-03-27 | Lincoln | Arkansas | 5079 | 6 | 0 |
14125 | 14125 | 2020-03-27 | Lonoke | Arkansas | 5085 | 4 | 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);