ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 39153 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536552 | 536552 | 2020-09-15 | Summit | Ohio | 39153 | 4912 | 244 |
533316 | 533316 | 2020-09-14 | Summit | Ohio | 39153 | 4894 | 244 |
530081 | 530081 | 2020-09-13 | Summit | Ohio | 39153 | 4861 | 244 |
526844 | 526844 | 2020-09-12 | Summit | Ohio | 39153 | 4844 | 244 |
523608 | 523608 | 2020-09-11 | Summit | Ohio | 39153 | 4814 | 244 |
520372 | 520372 | 2020-09-10 | Summit | Ohio | 39153 | 4785 | 240 |
517136 | 517136 | 2020-09-09 | Summit | Ohio | 39153 | 4764 | 240 |
513901 | 513901 | 2020-09-08 | Summit | Ohio | 39153 | 4725 | 239 |
510668 | 510668 | 2020-09-07 | Summit | Ohio | 39153 | 4694 | 236 |
507435 | 507435 | 2020-09-06 | Summit | Ohio | 39153 | 4667 | 236 |
504203 | 504203 | 2020-09-05 | Summit | Ohio | 39153 | 4639 | 236 |
500969 | 500969 | 2020-09-04 | Summit | Ohio | 39153 | 4615 | 236 |
497735 | 497735 | 2020-09-03 | Summit | Ohio | 39153 | 4582 | 235 |
494502 | 494502 | 2020-09-02 | Summit | Ohio | 39153 | 4542 | 235 |
491268 | 491268 | 2020-09-01 | Summit | Ohio | 39153 | 4505 | 236 |
488035 | 488035 | 2020-08-31 | Summit | Ohio | 39153 | 4471 | 236 |
484802 | 484802 | 2020-08-30 | Summit | Ohio | 39153 | 4418 | 236 |
481567 | 481567 | 2020-08-29 | Summit | Ohio | 39153 | 4376 | 236 |
478333 | 478333 | 2020-08-28 | Summit | Ohio | 39153 | 4318 | 235 |
475100 | 475100 | 2020-08-27 | Summit | Ohio | 39153 | 4281 | 234 |
471866 | 471866 | 2020-08-26 | Summit | Ohio | 39153 | 4256 | 233 |
468634 | 468634 | 2020-08-25 | Summit | Ohio | 39153 | 4219 | 232 |
465406 | 465406 | 2020-08-24 | Summit | Ohio | 39153 | 4188 | 232 |
462177 | 462177 | 2020-08-23 | Summit | Ohio | 39153 | 4146 | 232 |
458949 | 458949 | 2020-08-22 | Summit | Ohio | 39153 | 4122 | 232 |
455721 | 455721 | 2020-08-21 | Summit | Ohio | 39153 | 3980 | 231 |
452493 | 452493 | 2020-08-20 | Summit | Ohio | 39153 | 3937 | 231 |
449265 | 449265 | 2020-08-19 | Summit | Ohio | 39153 | 3874 | 231 |
446037 | 446037 | 2020-08-18 | Summit | Ohio | 39153 | 3846 | 228 |
442811 | 442811 | 2020-08-17 | Summit | Ohio | 39153 | 3818 | 228 |
439584 | 439584 | 2020-08-16 | Summit | Ohio | 39153 | 3788 | 228 |
436359 | 436359 | 2020-08-15 | Summit | Ohio | 39153 | 3779 | 228 |
433133 | 433133 | 2020-08-14 | Summit | Ohio | 39153 | 3749 | 225 |
429907 | 429907 | 2020-08-13 | Summit | Ohio | 39153 | 3712 | 224 |
426682 | 426682 | 2020-08-12 | Summit | Ohio | 39153 | 3667 | 224 |
423459 | 423459 | 2020-08-11 | Summit | Ohio | 39153 | 3614 | 223 |
420236 | 420236 | 2020-08-10 | Summit | Ohio | 39153 | 3573 | 223 |
417016 | 417016 | 2020-08-09 | Summit | Ohio | 39153 | 3555 | 222 |
413795 | 413795 | 2020-08-08 | Summit | Ohio | 39153 | 3523 | 222 |
410575 | 410575 | 2020-08-07 | Summit | Ohio | 39153 | 3486 | 220 |
407355 | 407355 | 2020-08-06 | Summit | Ohio | 39153 | 3433 | 218 |
404136 | 404136 | 2020-08-05 | Summit | Ohio | 39153 | 3399 | 218 |
400918 | 400918 | 2020-08-04 | Summit | Ohio | 39153 | 3338 | 217 |
397703 | 397703 | 2020-08-03 | Summit | Ohio | 39153 | 3294 | 217 |
394486 | 394486 | 2020-08-02 | Summit | Ohio | 39153 | 3248 | 217 |
391270 | 391270 | 2020-08-01 | Summit | Ohio | 39153 | 3212 | 217 |
388053 | 388053 | 2020-07-31 | Summit | Ohio | 39153 | 3188 | 216 |
384836 | 384836 | 2020-07-30 | Summit | Ohio | 39153 | 3131 | 216 |
381618 | 381618 | 2020-07-29 | Summit | Ohio | 39153 | 3067 | 216 |
378401 | 378401 | 2020-07-28 | Summit | Ohio | 39153 | 3011 | 216 |
375184 | 375184 | 2020-07-27 | Summit | Ohio | 39153 | 2951 | 214 |
371972 | 371972 | 2020-07-26 | Summit | Ohio | 39153 | 2914 | 212 |
368760 | 368760 | 2020-07-25 | Summit | Ohio | 39153 | 2879 | 212 |
365551 | 365551 | 2020-07-24 | Summit | Ohio | 39153 | 2827 | 212 |
362345 | 362345 | 2020-07-23 | Summit | Ohio | 39153 | 2771 | 212 |
359139 | 359139 | 2020-07-22 | Summit | Ohio | 39153 | 2712 | 212 |
355935 | 355935 | 2020-07-21 | Summit | Ohio | 39153 | 2667 | 211 |
352732 | 352732 | 2020-07-20 | Summit | Ohio | 39153 | 2638 | 211 |
349529 | 349529 | 2020-07-19 | Summit | Ohio | 39153 | 2597 | 211 |
346328 | 346328 | 2020-07-18 | Summit | Ohio | 39153 | 2570 | 211 |
343129 | 343129 | 2020-07-17 | Summit | Ohio | 39153 | 2538 | 211 |
339931 | 339931 | 2020-07-16 | Summit | Ohio | 39153 | 2499 | 211 |
336735 | 336735 | 2020-07-15 | Summit | Ohio | 39153 | 2459 | 209 |
333541 | 333541 | 2020-07-14 | Summit | Ohio | 39153 | 2420 | 209 |
330349 | 330349 | 2020-07-13 | Summit | Ohio | 39153 | 2382 | 209 |
327162 | 327162 | 2020-07-12 | Summit | Ohio | 39153 | 2351 | 209 |
323977 | 323977 | 2020-07-11 | Summit | Ohio | 39153 | 2327 | 209 |
320797 | 320797 | 2020-07-10 | Summit | Ohio | 39153 | 2299 | 209 |
317620 | 317620 | 2020-07-09 | Summit | Ohio | 39153 | 2269 | 209 |
314447 | 314447 | 2020-07-08 | Summit | Ohio | 39153 | 2241 | 207 |
311275 | 311275 | 2020-07-07 | Summit | Ohio | 39153 | 2175 | 207 |
308106 | 308106 | 2020-07-06 | Summit | Ohio | 39153 | 2143 | 206 |
304939 | 304939 | 2020-07-05 | Summit | Ohio | 39153 | 2131 | 206 |
301776 | 301776 | 2020-07-04 | Summit | Ohio | 39153 | 2110 | 206 |
298613 | 298613 | 2020-07-03 | Summit | Ohio | 39153 | 2079 | 206 |
295453 | 295453 | 2020-07-02 | Summit | Ohio | 39153 | 1969 | 206 |
292298 | 292298 | 2020-07-01 | Summit | Ohio | 39153 | 1969 | 206 |
289146 | 289146 | 2020-06-30 | Summit | Ohio | 39153 | 1953 | 205 |
285996 | 285996 | 2020-06-29 | Summit | Ohio | 39153 | 1920 | 204 |
282851 | 282851 | 2020-06-28 | Summit | Ohio | 39153 | 1896 | 202 |
279705 | 279705 | 2020-06-27 | Summit | Ohio | 39153 | 1884 | 202 |
276557 | 276557 | 2020-06-26 | Summit | Ohio | 39153 | 1863 | 202 |
273410 | 273410 | 2020-06-25 | Summit | Ohio | 39153 | 1839 | 202 |
270271 | 270271 | 2020-06-24 | Summit | Ohio | 39153 | 1809 | 202 |
267137 | 267137 | 2020-06-23 | Summit | Ohio | 39153 | 1796 | 202 |
264009 | 264009 | 2020-06-22 | Summit | Ohio | 39153 | 1780 | 202 |
260881 | 260881 | 2020-06-21 | Summit | Ohio | 39153 | 1756 | 201 |
257754 | 257754 | 2020-06-20 | Summit | Ohio | 39153 | 1743 | 201 |
254629 | 254629 | 2020-06-19 | Summit | Ohio | 39153 | 1735 | 199 |
251514 | 251514 | 2020-06-18 | Summit | Ohio | 39153 | 1722 | 196 |
248399 | 248399 | 2020-06-17 | Summit | Ohio | 39153 | 1712 | 195 |
245286 | 245286 | 2020-06-16 | Summit | Ohio | 39153 | 1706 | 196 |
242174 | 242174 | 2020-06-15 | Summit | Ohio | 39153 | 1675 | 194 |
239065 | 239065 | 2020-06-14 | Summit | Ohio | 39153 | 1666 | 192 |
235957 | 235957 | 2020-06-13 | Summit | Ohio | 39153 | 1655 | 192 |
232852 | 232852 | 2020-06-12 | Summit | Ohio | 39153 | 1638 | 190 |
229747 | 229747 | 2020-06-11 | Summit | Ohio | 39153 | 1623 | 188 |
226643 | 226643 | 2020-06-10 | Summit | Ohio | 39153 | 1621 | 187 |
223543 | 223543 | 2020-06-09 | Summit | Ohio | 39153 | 1592 | 185 |
220448 | 220448 | 2020-06-08 | Summit | Ohio | 39153 | 1571 | 184 |
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);