ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Ingham" and state = "Michigan" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
256945 | 256945 | 2020-06-20 | Ingham | Michigan | 26065 | 837 | 29 |
260071 | 260071 | 2020-06-21 | Ingham | Michigan | 26065 | 845 | 29 |
263200 | 263200 | 2020-06-22 | Ingham | Michigan | 26065 | 859 | 29 |
266326 | 266326 | 2020-06-23 | Ingham | Michigan | 26065 | 867 | 29 |
269459 | 269459 | 2020-06-24 | Ingham | Michigan | 26065 | 896 | 29 |
272596 | 272596 | 2020-06-25 | Ingham | Michigan | 26065 | 916 | 29 |
275739 | 275739 | 2020-06-26 | Ingham | Michigan | 26065 | 954 | 29 |
278887 | 278887 | 2020-06-27 | Ingham | Michigan | 26065 | 980 | 29 |
282035 | 282035 | 2020-06-28 | Ingham | Michigan | 26065 | 992 | 29 |
285180 | 285180 | 2020-06-29 | Ingham | Michigan | 26065 | 1002 | 29 |
288330 | 288330 | 2020-06-30 | Ingham | Michigan | 26065 | 1019 | 29 |
291481 | 291481 | 2020-07-01 | Ingham | Michigan | 26065 | 1042 | 29 |
294635 | 294635 | 2020-07-02 | Ingham | Michigan | 26065 | 1054 | 29 |
297793 | 297793 | 2020-07-03 | Ingham | Michigan | 26065 | 1070 | 29 |
300955 | 300955 | 2020-07-04 | Ingham | Michigan | 26065 | 1085 | 29 |
304119 | 304119 | 2020-07-05 | Ingham | Michigan | 26065 | 1092 | 29 |
307286 | 307286 | 2020-07-06 | Ingham | Michigan | 26065 | 1095 | 29 |
310454 | 310454 | 2020-07-07 | Ingham | Michigan | 26065 | 1114 | 29 |
313624 | 313624 | 2020-07-08 | Ingham | Michigan | 26065 | 1129 | 29 |
316798 | 316798 | 2020-07-09 | Ingham | Michigan | 26065 | 1142 | 30 |
319973 | 319973 | 2020-07-10 | Ingham | Michigan | 26065 | 1153 | 30 |
323152 | 323152 | 2020-07-11 | Ingham | Michigan | 26065 | 1163 | 30 |
326335 | 326335 | 2020-07-12 | Ingham | Michigan | 26065 | 1174 | 30 |
329521 | 329521 | 2020-07-13 | Ingham | Michigan | 26065 | 1187 | 29 |
332708 | 332708 | 2020-07-14 | Ingham | Michigan | 26065 | 1207 | 29 |
335901 | 335901 | 2020-07-15 | Ingham | Michigan | 26065 | 1210 | 29 |
339097 | 339097 | 2020-07-16 | Ingham | Michigan | 26065 | 1242 | 29 |
342293 | 342293 | 2020-07-17 | Ingham | Michigan | 26065 | 1257 | 29 |
345493 | 345493 | 2020-07-18 | Ingham | Michigan | 26065 | 1265 | 29 |
348694 | 348694 | 2020-07-19 | Ingham | Michigan | 26065 | 1287 | 29 |
351894 | 351894 | 2020-07-20 | Ingham | Michigan | 26065 | 1286 | 29 |
355096 | 355096 | 2020-07-21 | Ingham | Michigan | 26065 | 1301 | 29 |
358299 | 358299 | 2020-07-22 | Ingham | Michigan | 26065 | 1308 | 29 |
361504 | 361504 | 2020-07-23 | Ingham | Michigan | 26065 | 1318 | 29 |
364711 | 364711 | 2020-07-24 | Ingham | Michigan | 26065 | 1336 | 29 |
367918 | 367918 | 2020-07-25 | Ingham | Michigan | 26065 | 1341 | 29 |
371128 | 371128 | 2020-07-26 | Ingham | Michigan | 26065 | 1387 | 29 |
374340 | 374340 | 2020-07-27 | Ingham | Michigan | 26065 | 1398 | 29 |
377555 | 377555 | 2020-07-28 | Ingham | Michigan | 26065 | 1415 | 30 |
380772 | 380772 | 2020-07-29 | Ingham | Michigan | 26065 | 1430 | 30 |
383989 | 383989 | 2020-07-30 | Ingham | Michigan | 26065 | 1438 | 31 |
387207 | 387207 | 2020-07-31 | Ingham | Michigan | 26065 | 1459 | 30 |
390424 | 390424 | 2020-08-01 | Ingham | Michigan | 26065 | 1473 | 30 |
393641 | 393641 | 2020-08-02 | Ingham | Michigan | 26065 | 1482 | 30 |
396857 | 396857 | 2020-08-03 | Ingham | Michigan | 26065 | 1493 | 34 |
400071 | 400071 | 2020-08-04 | Ingham | Michigan | 26065 | 1500 | 30 |
403288 | 403288 | 2020-08-05 | Ingham | Michigan | 26065 | 1503 | 30 |
406506 | 406506 | 2020-08-06 | Ingham | Michigan | 26065 | 1520 | 30 |
409726 | 409726 | 2020-08-07 | Ingham | Michigan | 26065 | 1536 | 30 |
412946 | 412946 | 2020-08-08 | Ingham | Michigan | 26065 | 1541 | 30 |
416166 | 416166 | 2020-08-09 | Ingham | Michigan | 26065 | 1551 | 30 |
419387 | 419387 | 2020-08-10 | Ingham | Michigan | 26065 | 1554 | 31 |
422609 | 422609 | 2020-08-11 | Ingham | Michigan | 26065 | 1558 | 31 |
425831 | 425831 | 2020-08-12 | Ingham | Michigan | 26065 | 1570 | 32 |
429055 | 429055 | 2020-08-13 | Ingham | Michigan | 26065 | 1588 | 32 |
432282 | 432282 | 2020-08-14 | Ingham | Michigan | 26065 | 1597 | 32 |
435508 | 435508 | 2020-08-15 | Ingham | Michigan | 26065 | 1610 | 33 |
438733 | 438733 | 2020-08-16 | Ingham | Michigan | 26065 | 1624 | 33 |
441960 | 441960 | 2020-08-17 | Ingham | Michigan | 26065 | 1641 | 33 |
445186 | 445186 | 2020-08-18 | Ingham | Michigan | 26065 | 1640 | 33 |
448412 | 448412 | 2020-08-19 | Ingham | Michigan | 26065 | 1652 | 35 |
451640 | 451640 | 2020-08-20 | Ingham | Michigan | 26065 | 1661 | 36 |
454868 | 454868 | 2020-08-21 | Ingham | Michigan | 26065 | 1661 | 36 |
458096 | 458096 | 2020-08-22 | Ingham | Michigan | 26065 | 1679 | 36 |
461323 | 461323 | 2020-08-23 | Ingham | Michigan | 26065 | 1691 | 36 |
464554 | 464554 | 2020-08-24 | Ingham | Michigan | 26065 | 1705 | 36 |
467783 | 467783 | 2020-08-25 | Ingham | Michigan | 26065 | 1714 | 37 |
471013 | 471013 | 2020-08-26 | Ingham | Michigan | 26065 | 1742 | 38 |
474245 | 474245 | 2020-08-27 | Ingham | Michigan | 26065 | 1735 | 37 |
477478 | 477478 | 2020-08-28 | Ingham | Michigan | 26065 | 1749 | 38 |
480710 | 480710 | 2020-08-29 | Ingham | Michigan | 26065 | 1766 | 39 |
483945 | 483945 | 2020-08-30 | Ingham | Michigan | 26065 | 1772 | 39 |
487179 | 487179 | 2020-08-31 | Ingham | Michigan | 26065 | 1783 | 41 |
490412 | 490412 | 2020-09-01 | Ingham | Michigan | 26065 | 1796 | 40 |
493646 | 493646 | 2020-09-02 | Ingham | Michigan | 26065 | 1814 | 40 |
496879 | 496879 | 2020-09-03 | Ingham | Michigan | 26065 | 1840 | 40 |
500113 | 500113 | 2020-09-04 | Ingham | Michigan | 26065 | 1889 | 40 |
503347 | 503347 | 2020-09-05 | Ingham | Michigan | 26065 | 1958 | 40 |
506580 | 506580 | 2020-09-06 | Ingham | Michigan | 26065 | 1958 | 40 |
509813 | 509813 | 2020-09-07 | Ingham | Michigan | 26065 | 2037 | 40 |
513045 | 513045 | 2020-09-08 | Ingham | Michigan | 26065 | 2066 | 40 |
516279 | 516279 | 2020-09-09 | Ingham | Michigan | 26065 | 2170 | 41 |
519514 | 519514 | 2020-09-10 | Ingham | Michigan | 26065 | 2296 | 42 |
522751 | 522751 | 2020-09-11 | Ingham | Michigan | 26065 | 2424 | 42 |
525987 | 525987 | 2020-09-12 | Ingham | Michigan | 26065 | 2525 | 42 |
529223 | 529223 | 2020-09-13 | Ingham | Michigan | 26065 | 2525 | 42 |
532459 | 532459 | 2020-09-14 | Ingham | Michigan | 26065 | 2655 | 43 |
535694 | 535694 | 2020-09-15 | Ingham | Michigan | 26065 | 2758 | 43 |
538931 | 538931 | 2020-09-16 | Ingham | Michigan | 26065 | 2887 | 43 |
542167 | 542167 | 2020-09-17 | Ingham | Michigan | 26065 | 3012 | 44 |
545404 | 545404 | 2020-09-18 | Ingham | Michigan | 26065 | 3091 | 45 |
548642 | 548642 | 2020-09-19 | Ingham | Michigan | 26065 | 3158 | 45 |
551881 | 551881 | 2020-09-20 | Ingham | Michigan | 26065 | 3158 | 45 |
555119 | 555119 | 2020-09-21 | Ingham | Michigan | 26065 | 3242 | 47 |
558356 | 558356 | 2020-09-22 | Ingham | Michigan | 26065 | 3297 | 47 |
561593 | 561593 | 2020-09-23 | Ingham | Michigan | 26065 | 3362 | 47 |
564833 | 564833 | 2020-09-24 | Ingham | Michigan | 26065 | 3406 | 47 |
568073 | 568073 | 2020-09-25 | Ingham | Michigan | 26065 | 3462 | 47 |
571315 | 571315 | 2020-09-26 | Ingham | Michigan | 26065 | 3506 | 47 |
574558 | 574558 | 2020-09-27 | Ingham | Michigan | 26065 | 3506 | 47 |
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);