ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

89 rows where date = "2022-01-05" and state = "Ohio" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Ohio · 89 ✖
Link rowid date ▲ county state fips cases deaths
2085181 2085181 2022-01-05 Adams Ohio 39001 5143 118
2085182 2085182 2022-01-05 Allen Ohio 39003 21514 372
2085183 2085183 2022-01-05 Ashland Ohio 39005 9668 166
2085184 2085184 2022-01-05 Ashtabula Ohio 39007 16185 311
2085185 2085185 2022-01-05 Athens Ohio 39009 9385 104
2085186 2085186 2022-01-05 Auglaize Ohio 39011 8962 135
2085187 2085187 2022-01-05 Belmont Ohio 39013 11842 246
2085188 2085188 2022-01-05 Brown Ohio 39015 8282 134
2085189 2085189 2022-01-05 Butler Ohio 39017 66888 897
2085190 2085190 2022-01-05 Carroll Ohio 39019 4397 97
2085191 2085191 2022-01-05 Champaign Ohio 39021 6781 103
2085192 2085192 2022-01-05 Clark Ohio 39023 26112 416
2085193 2085193 2022-01-05 Clermont Ohio 39025 37024 410
2085194 2085194 2022-01-05 Clinton Ohio 39027 7615 115
2085195 2085195 2022-01-05 Columbiana Ohio 39029 19736 384
2085196 2085196 2022-01-05 Coshocton Ohio 39031 6283 131
2085197 2085197 2022-01-05 Crawford Ohio 39033 8777 165
2085198 2085198 2022-01-05 Cuyahoga Ohio 39035 239466 2864
2085199 2085199 2022-01-05 Darke Ohio 39037 9571 192
2085200 2085200 2022-01-05 Defiance Ohio 39039 8229 129
2085201 2085201 2022-01-05 Delaware Ohio 39041 33042 198
2085202 2085202 2022-01-05 Erie Ohio 39043 15970 219
2085203 2085203 2022-01-05 Fairfield Ohio 39045 29302 317
2085204 2085204 2022-01-05 Fayette Ohio 39047 5804 80
2085205 2085205 2022-01-05 Franklin Ohio 39049 221852 1966
2085206 2085206 2022-01-05 Fulton Ohio 39051 8295 140
2085207 2085207 2022-01-05 Gallia Ohio 39053 5305 85
2085208 2085208 2022-01-05 Geauga Ohio 39055 14094 207
2085209 2085209 2022-01-05 Greene Ohio 39057 27838 405
2085210 2085210 2022-01-05 Guernsey Ohio 39059 8045 103
2085211 2085211 2022-01-05 Hamilton Ohio 39061 139752 1653
2085212 2085212 2022-01-05 Hancock Ohio 39063 13356 215
2085213 2085213 2022-01-05 Hardin Ohio 39065 5580 123
2085214 2085214 2022-01-05 Harrison Ohio 39067 2527 60
2085215 2085215 2022-01-05 Henry Ohio 39069 4961 90
2085216 2085216 2022-01-05 Highland Ohio 39071 7908 137
2085217 2085217 2022-01-05 Hocking Ohio 39073 4899 98
2085218 2085218 2022-01-05 Holmes Ohio 39075 4417 157
2085219 2085219 2022-01-05 Huron Ohio 39077 11881 175
2085220 2085220 2022-01-05 Jackson Ohio 39079 6603 110
2085221 2085221 2022-01-05 Jefferson Ohio 39081 11331 251
2085222 2085222 2022-01-05 Knox Ohio 39083 10224 190
2085223 2085223 2022-01-05 Lake Ohio 39085 43293 557
2085224 2085224 2022-01-05 Lawrence Ohio 39087 12133 183
2085225 2085225 2022-01-05 Licking Ohio 39089 32282 376
2085226 2085226 2022-01-05 Logan Ohio 39091 8037 135
2085227 2085227 2022-01-05 Lorain Ohio 39093 56956 735
2085228 2085228 2022-01-05 Lucas Ohio 39095 75943 1114
2085229 2085229 2022-01-05 Madison Ohio 39097 7486 102
2085230 2085230 2022-01-05 Mahoning Ohio 39099 43776 876
2085231 2085231 2022-01-05 Marion Ohio 39101 15412 218
2085232 2085232 2022-01-05 Medina Ohio 39103 33713 401
2085233 2085233 2022-01-05 Meigs Ohio 39105 3376 67
2085234 2085234 2022-01-05 Mercer Ohio 39107 7648 110
2085235 2085235 2022-01-05 Miami Ohio 39109 20061 377
2085236 2085236 2022-01-05 Monroe Ohio 39111 2678 67
2085237 2085237 2022-01-05 Montgomery Ohio 39113 94079 1528
2085238 2085238 2022-01-05 Morgan Ohio 39115 2491 47
2085239 2085239 2022-01-05 Morrow Ohio 39117 6170 74
2085240 2085240 2022-01-05 Muskingum Ohio 39119 19185 232
2085241 2085241 2022-01-05 Noble Ohio 39121 2495 50
2085242 2085242 2022-01-05 Ottawa Ohio 39123 6799 114
2085243 2085243 2022-01-05 Paulding Ohio 39125 3671 61
2085244 2085244 2022-01-05 Perry Ohio 39127 6448 94
2085245 2085245 2022-01-05 Pickaway Ohio 39129 13844 168
2085246 2085246 2022-01-05 Pike Ohio 39131 5279 82
2085247 2085247 2022-01-05 Portage Ohio 39133 28517 335
2085248 2085248 2022-01-05 Preble Ohio 39135 7241 154
2085249 2085249 2022-01-05 Putnam Ohio 39137 6888 132
2085250 2085250 2022-01-05 Richland Ohio 39139 25149 398
2085251 2085251 2022-01-05 Ross Ohio 39141 13837 242
2085252 2085252 2022-01-05 Sandusky Ohio 39143 11124 193
2085253 2085253 2022-01-05 Scioto Ohio 39145 14379 197
2085254 2085254 2022-01-05 Seneca Ohio 39147 10238 192
2085255 2085255 2022-01-05 Shelby Ohio 39149 8499 151
2085256 2085256 2022-01-05 Stark Ohio 39151 66609 1326
2085257 2085257 2022-01-05 Summit Ohio 39153 96399 1316
2085258 2085258 2022-01-05 Trumbull Ohio 39155 33822 705
2085259 2085259 2022-01-05 Tuscarawas Ohio 39157 17019 406
2085260 2085260 2022-01-05 Union Ohio 39159 11329 81
2085261 2085261 2022-01-05 Unknown Ohio   0 7
2085262 2085262 2022-01-05 Van Wert Ohio 39161 5189 112
2085263 2085263 2022-01-05 Vinton Ohio 39163 2145 43
2085264 2085264 2022-01-05 Warren Ohio 39165 42393 453
2085265 2085265 2022-01-05 Washington Ohio 39167 9596 168
2085266 2085266 2022-01-05 Wayne Ohio 39169 18989 336
2085267 2085267 2022-01-05 Williams Ohio 39171 7265 127
2085268 2085268 2022-01-05 Wood Ohio 39173 23800 281
2085269 2085269 2022-01-05 Wyandot Ohio 39175 4296 83

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);