ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Ottawa" and state = "Michigan" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
266362 | 266362 | 2020-06-23 | Ottawa | Michigan | 26139 | 984 | 51 |
269495 | 269495 | 2020-06-24 | Ottawa | Michigan | 26139 | 988 | 51 |
272632 | 272632 | 2020-06-25 | Ottawa | Michigan | 26139 | 996 | 51 |
275775 | 275775 | 2020-06-26 | Ottawa | Michigan | 26139 | 1010 | 51 |
278923 | 278923 | 2020-06-27 | Ottawa | Michigan | 26139 | 1020 | 51 |
282071 | 282071 | 2020-06-28 | Ottawa | Michigan | 26139 | 1023 | 51 |
285216 | 285216 | 2020-06-29 | Ottawa | Michigan | 26139 | 1026 | 51 |
288366 | 288366 | 2020-06-30 | Ottawa | Michigan | 26139 | 1048 | 51 |
291517 | 291517 | 2020-07-01 | Ottawa | Michigan | 26139 | 1064 | 51 |
294671 | 294671 | 2020-07-02 | Ottawa | Michigan | 26139 | 1081 | 51 |
297829 | 297829 | 2020-07-03 | Ottawa | Michigan | 26139 | 1096 | 51 |
300992 | 300992 | 2020-07-04 | Ottawa | Michigan | 26139 | 1116 | 51 |
304156 | 304156 | 2020-07-05 | Ottawa | Michigan | 26139 | 1138 | 51 |
307323 | 307323 | 2020-07-06 | Ottawa | Michigan | 26139 | 1148 | 51 |
310491 | 310491 | 2020-07-07 | Ottawa | Michigan | 26139 | 1171 | 52 |
313661 | 313661 | 2020-07-08 | Ottawa | Michigan | 26139 | 1196 | 52 |
316835 | 316835 | 2020-07-09 | Ottawa | Michigan | 26139 | 1220 | 52 |
320010 | 320010 | 2020-07-10 | Ottawa | Michigan | 26139 | 1250 | 52 |
323189 | 323189 | 2020-07-11 | Ottawa | Michigan | 26139 | 1291 | 52 |
326372 | 326372 | 2020-07-12 | Ottawa | Michigan | 26139 | 1306 | 52 |
329558 | 329558 | 2020-07-13 | Ottawa | Michigan | 26139 | 1314 | 53 |
332745 | 332745 | 2020-07-14 | Ottawa | Michigan | 26139 | 1357 | 53 |
335938 | 335938 | 2020-07-15 | Ottawa | Michigan | 26139 | 1381 | 53 |
339134 | 339134 | 2020-07-16 | Ottawa | Michigan | 26139 | 1400 | 53 |
342330 | 342330 | 2020-07-17 | Ottawa | Michigan | 26139 | 1424 | 53 |
345530 | 345530 | 2020-07-18 | Ottawa | Michigan | 26139 | 1443 | 53 |
348731 | 348731 | 2020-07-19 | Ottawa | Michigan | 26139 | 1473 | 53 |
351931 | 351931 | 2020-07-20 | Ottawa | Michigan | 26139 | 1498 | 53 |
355133 | 355133 | 2020-07-21 | Ottawa | Michigan | 26139 | 1531 | 53 |
358336 | 358336 | 2020-07-22 | Ottawa | Michigan | 26139 | 1547 | 53 |
361541 | 361541 | 2020-07-23 | Ottawa | Michigan | 26139 | 1568 | 53 |
364748 | 364748 | 2020-07-24 | Ottawa | Michigan | 26139 | 1578 | 53 |
367955 | 367955 | 2020-07-25 | Ottawa | Michigan | 26139 | 1583 | 53 |
371165 | 371165 | 2020-07-26 | Ottawa | Michigan | 26139 | 1612 | 53 |
374377 | 374377 | 2020-07-27 | Ottawa | Michigan | 26139 | 1622 | 53 |
377592 | 377592 | 2020-07-28 | Ottawa | Michigan | 26139 | 1638 | 54 |
380809 | 380809 | 2020-07-29 | Ottawa | Michigan | 26139 | 1656 | 54 |
384026 | 384026 | 2020-07-30 | Ottawa | Michigan | 26139 | 1669 | 54 |
387244 | 387244 | 2020-07-31 | Ottawa | Michigan | 26139 | 1686 | 54 |
390461 | 390461 | 2020-08-01 | Ottawa | Michigan | 26139 | 1739 | 54 |
393678 | 393678 | 2020-08-02 | Ottawa | Michigan | 26139 | 1747 | 54 |
396894 | 396894 | 2020-08-03 | Ottawa | Michigan | 26139 | 1757 | 54 |
400108 | 400108 | 2020-08-04 | Ottawa | Michigan | 26139 | 1759 | 54 |
403325 | 403325 | 2020-08-05 | Ottawa | Michigan | 26139 | 1782 | 55 |
406543 | 406543 | 2020-08-06 | Ottawa | Michigan | 26139 | 1792 | 55 |
409763 | 409763 | 2020-08-07 | Ottawa | Michigan | 26139 | 1803 | 56 |
412983 | 412983 | 2020-08-08 | Ottawa | Michigan | 26139 | 1813 | 56 |
416203 | 416203 | 2020-08-09 | Ottawa | Michigan | 26139 | 1845 | 56 |
419424 | 419424 | 2020-08-10 | Ottawa | Michigan | 26139 | 1853 | 56 |
422646 | 422646 | 2020-08-11 | Ottawa | Michigan | 26139 | 1860 | 56 |
425868 | 425868 | 2020-08-12 | Ottawa | Michigan | 26139 | 1874 | 58 |
429092 | 429092 | 2020-08-13 | Ottawa | Michigan | 26139 | 1884 | 59 |
432319 | 432319 | 2020-08-14 | Ottawa | Michigan | 26139 | 1903 | 59 |
435545 | 435545 | 2020-08-15 | Ottawa | Michigan | 26139 | 1921 | 59 |
438770 | 438770 | 2020-08-16 | Ottawa | Michigan | 26139 | 1937 | 59 |
441997 | 441997 | 2020-08-17 | Ottawa | Michigan | 26139 | 1942 | 59 |
445223 | 445223 | 2020-08-18 | Ottawa | Michigan | 26139 | 1955 | 59 |
448449 | 448449 | 2020-08-19 | Ottawa | Michigan | 26139 | 1970 | 60 |
451677 | 451677 | 2020-08-20 | Ottawa | Michigan | 26139 | 1978 | 61 |
454905 | 454905 | 2020-08-21 | Ottawa | Michigan | 26139 | 1979 | 62 |
458133 | 458133 | 2020-08-22 | Ottawa | Michigan | 26139 | 1988 | 63 |
461360 | 461360 | 2020-08-23 | Ottawa | Michigan | 26139 | 2009 | 63 |
464591 | 464591 | 2020-08-24 | Ottawa | Michigan | 26139 | 2014 | 63 |
467820 | 467820 | 2020-08-25 | Ottawa | Michigan | 26139 | 2021 | 63 |
471050 | 471050 | 2020-08-26 | Ottawa | Michigan | 26139 | 2038 | 63 |
474282 | 474282 | 2020-08-27 | Ottawa | Michigan | 26139 | 2058 | 63 |
477515 | 477515 | 2020-08-28 | Ottawa | Michigan | 26139 | 2087 | 63 |
480747 | 480747 | 2020-08-29 | Ottawa | Michigan | 26139 | 2104 | 64 |
483982 | 483982 | 2020-08-30 | Ottawa | Michigan | 26139 | 2133 | 63 |
487216 | 487216 | 2020-08-31 | Ottawa | Michigan | 26139 | 2177 | 63 |
490449 | 490449 | 2020-09-01 | Ottawa | Michigan | 26139 | 2245 | 63 |
493683 | 493683 | 2020-09-02 | Ottawa | Michigan | 26139 | 2300 | 63 |
496916 | 496916 | 2020-09-03 | Ottawa | Michigan | 26139 | 2362 | 63 |
500150 | 500150 | 2020-09-04 | Ottawa | Michigan | 26139 | 2440 | 64 |
503384 | 503384 | 2020-09-05 | Ottawa | Michigan | 26139 | 2526 | 64 |
506617 | 506617 | 2020-09-06 | Ottawa | Michigan | 26139 | 2558 | 64 |
509850 | 509850 | 2020-09-07 | Ottawa | Michigan | 26139 | 2582 | 64 |
513082 | 513082 | 2020-09-08 | Ottawa | Michigan | 26139 | 2641 | 64 |
516316 | 516316 | 2020-09-09 | Ottawa | Michigan | 26139 | 2695 | 64 |
519551 | 519551 | 2020-09-10 | Ottawa | Michigan | 26139 | 2754 | 64 |
522788 | 522788 | 2020-09-11 | Ottawa | Michigan | 26139 | 2870 | 64 |
526024 | 526024 | 2020-09-12 | Ottawa | Michigan | 26139 | 2898 | 65 |
529260 | 529260 | 2020-09-13 | Ottawa | Michigan | 26139 | 2934 | 65 |
532496 | 532496 | 2020-09-14 | Ottawa | Michigan | 26139 | 2968 | 65 |
535731 | 535731 | 2020-09-15 | Ottawa | Michigan | 26139 | 3019 | 65 |
538968 | 538968 | 2020-09-16 | Ottawa | Michigan | 26139 | 3058 | 67 |
542204 | 542204 | 2020-09-17 | Ottawa | Michigan | 26139 | 3100 | 65 |
545441 | 545441 | 2020-09-18 | Ottawa | Michigan | 26139 | 3142 | 65 |
548679 | 548679 | 2020-09-19 | Ottawa | Michigan | 26139 | 3162 | 65 |
551918 | 551918 | 2020-09-20 | Ottawa | Michigan | 26139 | 3187 | 66 |
555156 | 555156 | 2020-09-21 | Ottawa | Michigan | 26139 | 3233 | 66 |
558393 | 558393 | 2020-09-22 | Ottawa | Michigan | 26139 | 3272 | 66 |
561630 | 561630 | 2020-09-23 | Ottawa | Michigan | 26139 | 3316 | 66 |
564870 | 564870 | 2020-09-24 | Ottawa | Michigan | 26139 | 3354 | 66 |
568110 | 568110 | 2020-09-25 | Ottawa | Michigan | 26139 | 3383 | 66 |
571352 | 571352 | 2020-09-26 | Ottawa | Michigan | 26139 | 3409 | 66 |
574595 | 574595 | 2020-09-27 | Ottawa | Michigan | 26139 | 3436 | 66 |
577836 | 577836 | 2020-09-28 | Ottawa | Michigan | 26139 | 3474 | 66 |
581077 | 581077 | 2020-09-29 | Ottawa | Michigan | 26139 | 3498 | 66 |
584318 | 584318 | 2020-09-30 | Ottawa | Michigan | 26139 | 3533 | 66 |
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);