ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 39099 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536525 | 536525 | 2020-09-15 | Mahoning | Ohio | 39099 | 2966 | 279 |
533289 | 533289 | 2020-09-14 | Mahoning | Ohio | 39099 | 2960 | 274 |
530054 | 530054 | 2020-09-13 | Mahoning | Ohio | 39099 | 2945 | 274 |
526817 | 526817 | 2020-09-12 | Mahoning | Ohio | 39099 | 2942 | 274 |
523581 | 523581 | 2020-09-11 | Mahoning | Ohio | 39099 | 2935 | 274 |
520345 | 520345 | 2020-09-10 | Mahoning | Ohio | 39099 | 2923 | 274 |
517109 | 517109 | 2020-09-09 | Mahoning | Ohio | 39099 | 2915 | 272 |
513874 | 513874 | 2020-09-08 | Mahoning | Ohio | 39099 | 2906 | 272 |
510641 | 510641 | 2020-09-07 | Mahoning | Ohio | 39099 | 2901 | 272 |
507408 | 507408 | 2020-09-06 | Mahoning | Ohio | 39099 | 2895 | 272 |
504176 | 504176 | 2020-09-05 | Mahoning | Ohio | 39099 | 2888 | 272 |
500942 | 500942 | 2020-09-04 | Mahoning | Ohio | 39099 | 2879 | 272 |
497708 | 497708 | 2020-09-03 | Mahoning | Ohio | 39099 | 2874 | 271 |
494475 | 494475 | 2020-09-02 | Mahoning | Ohio | 39099 | 2868 | 266 |
491241 | 491241 | 2020-09-01 | Mahoning | Ohio | 39099 | 2864 | 266 |
488008 | 488008 | 2020-08-31 | Mahoning | Ohio | 39099 | 2854 | 265 |
484775 | 484775 | 2020-08-30 | Mahoning | Ohio | 39099 | 2847 | 265 |
481540 | 481540 | 2020-08-29 | Mahoning | Ohio | 39099 | 2843 | 265 |
478306 | 478306 | 2020-08-28 | Mahoning | Ohio | 39099 | 2835 | 265 |
475073 | 475073 | 2020-08-27 | Mahoning | Ohio | 39099 | 2825 | 264 |
471839 | 471839 | 2020-08-26 | Mahoning | Ohio | 39099 | 2812 | 264 |
468607 | 468607 | 2020-08-25 | Mahoning | Ohio | 39099 | 2795 | 262 |
465379 | 465379 | 2020-08-24 | Mahoning | Ohio | 39099 | 2788 | 262 |
462150 | 462150 | 2020-08-23 | Mahoning | Ohio | 39099 | 2761 | 262 |
458922 | 458922 | 2020-08-22 | Mahoning | Ohio | 39099 | 2752 | 262 |
455694 | 455694 | 2020-08-21 | Mahoning | Ohio | 39099 | 2741 | 262 |
452466 | 452466 | 2020-08-20 | Mahoning | Ohio | 39099 | 2729 | 262 |
449238 | 449238 | 2020-08-19 | Mahoning | Ohio | 39099 | 2710 | 261 |
446010 | 446010 | 2020-08-18 | Mahoning | Ohio | 39099 | 2702 | 261 |
442784 | 442784 | 2020-08-17 | Mahoning | Ohio | 39099 | 2691 | 260 |
439557 | 439557 | 2020-08-16 | Mahoning | Ohio | 39099 | 2681 | 260 |
436332 | 436332 | 2020-08-15 | Mahoning | Ohio | 39099 | 2675 | 260 |
433106 | 433106 | 2020-08-14 | Mahoning | Ohio | 39099 | 2665 | 259 |
429880 | 429880 | 2020-08-13 | Mahoning | Ohio | 39099 | 2644 | 258 |
426655 | 426655 | 2020-08-12 | Mahoning | Ohio | 39099 | 2623 | 256 |
423432 | 423432 | 2020-08-11 | Mahoning | Ohio | 39099 | 2595 | 255 |
420209 | 420209 | 2020-08-10 | Mahoning | Ohio | 39099 | 2566 | 254 |
416989 | 416989 | 2020-08-09 | Mahoning | Ohio | 39099 | 2554 | 255 |
413768 | 413768 | 2020-08-08 | Mahoning | Ohio | 39099 | 2532 | 255 |
410548 | 410548 | 2020-08-07 | Mahoning | Ohio | 39099 | 2502 | 255 |
407328 | 407328 | 2020-08-06 | Mahoning | Ohio | 39099 | 2477 | 254 |
404109 | 404109 | 2020-08-05 | Mahoning | Ohio | 39099 | 2470 | 253 |
400891 | 400891 | 2020-08-04 | Mahoning | Ohio | 39099 | 2437 | 253 |
397676 | 397676 | 2020-08-03 | Mahoning | Ohio | 39099 | 2411 | 253 |
394459 | 394459 | 2020-08-02 | Mahoning | Ohio | 39099 | 2393 | 253 |
391243 | 391243 | 2020-08-01 | Mahoning | Ohio | 39099 | 2383 | 253 |
388026 | 388026 | 2020-07-31 | Mahoning | Ohio | 39099 | 2371 | 250 |
384809 | 384809 | 2020-07-30 | Mahoning | Ohio | 39099 | 2349 | 249 |
381591 | 381591 | 2020-07-29 | Mahoning | Ohio | 39099 | 2321 | 249 |
378374 | 378374 | 2020-07-28 | Mahoning | Ohio | 39099 | 2306 | 249 |
375157 | 375157 | 2020-07-27 | Mahoning | Ohio | 39099 | 2280 | 248 |
371945 | 371945 | 2020-07-26 | Mahoning | Ohio | 39099 | 2258 | 244 |
368733 | 368733 | 2020-07-25 | Mahoning | Ohio | 39099 | 2232 | 244 |
365524 | 365524 | 2020-07-24 | Mahoning | Ohio | 39099 | 2214 | 244 |
362318 | 362318 | 2020-07-23 | Mahoning | Ohio | 39099 | 2188 | 241 |
359112 | 359112 | 2020-07-22 | Mahoning | Ohio | 39099 | 2187 | 247 |
355908 | 355908 | 2020-07-21 | Mahoning | Ohio | 39099 | 2148 | 247 |
352705 | 352705 | 2020-07-20 | Mahoning | Ohio | 39099 | 2119 | 243 |
349502 | 349502 | 2020-07-19 | Mahoning | Ohio | 39099 | 2089 | 241 |
346301 | 346301 | 2020-07-18 | Mahoning | Ohio | 39099 | 2073 | 240 |
343102 | 343102 | 2020-07-17 | Mahoning | Ohio | 39099 | 2055 | 240 |
339904 | 339904 | 2020-07-16 | Mahoning | Ohio | 39099 | 2027 | 240 |
336708 | 336708 | 2020-07-15 | Mahoning | Ohio | 39099 | 2007 | 239 |
333514 | 333514 | 2020-07-14 | Mahoning | Ohio | 39099 | 1996 | 239 |
330322 | 330322 | 2020-07-13 | Mahoning | Ohio | 39099 | 1971 | 239 |
327135 | 327135 | 2020-07-12 | Mahoning | Ohio | 39099 | 1948 | 239 |
323950 | 323950 | 2020-07-11 | Mahoning | Ohio | 39099 | 1928 | 239 |
320770 | 320770 | 2020-07-10 | Mahoning | Ohio | 39099 | 1907 | 239 |
317593 | 317593 | 2020-07-09 | Mahoning | Ohio | 39099 | 1885 | 239 |
314420 | 314420 | 2020-07-08 | Mahoning | Ohio | 39099 | 1861 | 239 |
311248 | 311248 | 2020-07-07 | Mahoning | Ohio | 39099 | 1849 | 238 |
308079 | 308079 | 2020-07-06 | Mahoning | Ohio | 39099 | 1832 | 232 |
304912 | 304912 | 2020-07-05 | Mahoning | Ohio | 39099 | 1825 | 232 |
301749 | 301749 | 2020-07-04 | Mahoning | Ohio | 39099 | 1818 | 231 |
298586 | 298586 | 2020-07-03 | Mahoning | Ohio | 39099 | 1805 | 231 |
295426 | 295426 | 2020-07-02 | Mahoning | Ohio | 39099 | 1752 | 228 |
292271 | 292271 | 2020-07-01 | Mahoning | Ohio | 39099 | 1752 | 228 |
289119 | 289119 | 2020-06-30 | Mahoning | Ohio | 39099 | 1741 | 228 |
285969 | 285969 | 2020-06-29 | Mahoning | Ohio | 39099 | 1736 | 228 |
282824 | 282824 | 2020-06-28 | Mahoning | Ohio | 39099 | 1720 | 228 |
279678 | 279678 | 2020-06-27 | Mahoning | Ohio | 39099 | 1705 | 227 |
276530 | 276530 | 2020-06-26 | Mahoning | Ohio | 39099 | 1695 | 227 |
273383 | 273383 | 2020-06-25 | Mahoning | Ohio | 39099 | 1682 | 227 |
270244 | 270244 | 2020-06-24 | Mahoning | Ohio | 39099 | 1680 | 226 |
267110 | 267110 | 2020-06-23 | Mahoning | Ohio | 39099 | 1669 | 225 |
263982 | 263982 | 2020-06-22 | Mahoning | Ohio | 39099 | 1665 | 224 |
260854 | 260854 | 2020-06-21 | Mahoning | Ohio | 39099 | 1654 | 224 |
257727 | 257727 | 2020-06-20 | Mahoning | Ohio | 39099 | 1639 | 224 |
254602 | 254602 | 2020-06-19 | Mahoning | Ohio | 39099 | 1632 | 223 |
251487 | 251487 | 2020-06-18 | Mahoning | Ohio | 39099 | 1619 | 218 |
248372 | 248372 | 2020-06-17 | Mahoning | Ohio | 39099 | 1606 | 218 |
245259 | 245259 | 2020-06-16 | Mahoning | Ohio | 39099 | 1607 | 218 |
242147 | 242147 | 2020-06-15 | Mahoning | Ohio | 39099 | 1600 | 216 |
239038 | 239038 | 2020-06-14 | Mahoning | Ohio | 39099 | 1595 | 214 |
235930 | 235930 | 2020-06-13 | Mahoning | Ohio | 39099 | 1586 | 214 |
232825 | 232825 | 2020-06-12 | Mahoning | Ohio | 39099 | 1576 | 204 |
229720 | 229720 | 2020-06-11 | Mahoning | Ohio | 39099 | 1563 | 202 |
226616 | 226616 | 2020-06-10 | Mahoning | Ohio | 39099 | 1529 | 195 |
223516 | 223516 | 2020-06-09 | Mahoning | Ohio | 39099 | 1522 | 195 |
220421 | 220421 | 2020-06-08 | Mahoning | Ohio | 39099 | 1516 | 195 |
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);