ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Kalamazoo" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
291487 | 291487 | 2020-07-01 | Kalamazoo | Michigan | 26077 | 1089 | 68 |
294641 | 294641 | 2020-07-02 | Kalamazoo | Michigan | 26077 | 1093 | 68 |
297799 | 297799 | 2020-07-03 | Kalamazoo | Michigan | 26077 | 1103 | 68 |
300961 | 300961 | 2020-07-04 | Kalamazoo | Michigan | 26077 | 1108 | 68 |
304125 | 304125 | 2020-07-05 | Kalamazoo | Michigan | 26077 | 1110 | 68 |
307292 | 307292 | 2020-07-06 | Kalamazoo | Michigan | 26077 | 1112 | 68 |
310460 | 310460 | 2020-07-07 | Kalamazoo | Michigan | 26077 | 1131 | 68 |
313630 | 313630 | 2020-07-08 | Kalamazoo | Michigan | 26077 | 1156 | 69 |
316804 | 316804 | 2020-07-09 | Kalamazoo | Michigan | 26077 | 1172 | 70 |
319979 | 319979 | 2020-07-10 | Kalamazoo | Michigan | 26077 | 1194 | 70 |
323158 | 323158 | 2020-07-11 | Kalamazoo | Michigan | 26077 | 1216 | 70 |
326341 | 326341 | 2020-07-12 | Kalamazoo | Michigan | 26077 | 1234 | 70 |
329527 | 329527 | 2020-07-13 | Kalamazoo | Michigan | 26077 | 1237 | 70 |
332714 | 332714 | 2020-07-14 | Kalamazoo | Michigan | 26077 | 1252 | 71 |
335907 | 335907 | 2020-07-15 | Kalamazoo | Michigan | 26077 | 1268 | 71 |
339103 | 339103 | 2020-07-16 | Kalamazoo | Michigan | 26077 | 1277 | 72 |
342299 | 342299 | 2020-07-17 | Kalamazoo | Michigan | 26077 | 1299 | 72 |
345499 | 345499 | 2020-07-18 | Kalamazoo | Michigan | 26077 | 1316 | 72 |
348700 | 348700 | 2020-07-19 | Kalamazoo | Michigan | 26077 | 1327 | 73 |
351900 | 351900 | 2020-07-20 | Kalamazoo | Michigan | 26077 | 1348 | 74 |
355102 | 355102 | 2020-07-21 | Kalamazoo | Michigan | 26077 | 1351 | 74 |
358305 | 358305 | 2020-07-22 | Kalamazoo | Michigan | 26077 | 1370 | 74 |
361510 | 361510 | 2020-07-23 | Kalamazoo | Michigan | 26077 | 1391 | 74 |
364717 | 364717 | 2020-07-24 | Kalamazoo | Michigan | 26077 | 1397 | 74 |
367924 | 367924 | 2020-07-25 | Kalamazoo | Michigan | 26077 | 1411 | 76 |
371134 | 371134 | 2020-07-26 | Kalamazoo | Michigan | 26077 | 1441 | 76 |
374346 | 374346 | 2020-07-27 | Kalamazoo | Michigan | 26077 | 1449 | 78 |
377561 | 377561 | 2020-07-28 | Kalamazoo | Michigan | 26077 | 1455 | 78 |
380778 | 380778 | 2020-07-29 | Kalamazoo | Michigan | 26077 | 1469 | 78 |
383995 | 383995 | 2020-07-30 | Kalamazoo | Michigan | 26077 | 1489 | 78 |
387213 | 387213 | 2020-07-31 | Kalamazoo | Michigan | 26077 | 1522 | 80 |
390430 | 390430 | 2020-08-01 | Kalamazoo | Michigan | 26077 | 1541 | 81 |
393647 | 393647 | 2020-08-02 | Kalamazoo | Michigan | 26077 | 1546 | 81 |
396863 | 396863 | 2020-08-03 | Kalamazoo | Michigan | 26077 | 1560 | 82 |
400077 | 400077 | 2020-08-04 | Kalamazoo | Michigan | 26077 | 1568 | 82 |
403294 | 403294 | 2020-08-05 | Kalamazoo | Michigan | 26077 | 1588 | 82 |
406512 | 406512 | 2020-08-06 | Kalamazoo | Michigan | 26077 | 1601 | 83 |
409732 | 409732 | 2020-08-07 | Kalamazoo | Michigan | 26077 | 1618 | 83 |
412952 | 412952 | 2020-08-08 | Kalamazoo | Michigan | 26077 | 1631 | 83 |
416172 | 416172 | 2020-08-09 | Kalamazoo | Michigan | 26077 | 1639 | 83 |
419393 | 419393 | 2020-08-10 | Kalamazoo | Michigan | 26077 | 1648 | 83 |
422615 | 422615 | 2020-08-11 | Kalamazoo | Michigan | 26077 | 1655 | 83 |
425837 | 425837 | 2020-08-12 | Kalamazoo | Michigan | 26077 | 1686 | 83 |
429061 | 429061 | 2020-08-13 | Kalamazoo | Michigan | 26077 | 1700 | 83 |
432288 | 432288 | 2020-08-14 | Kalamazoo | Michigan | 26077 | 1705 | 84 |
435514 | 435514 | 2020-08-15 | Kalamazoo | Michigan | 26077 | 1728 | 84 |
438739 | 438739 | 2020-08-16 | Kalamazoo | Michigan | 26077 | 1746 | 85 |
441966 | 441966 | 2020-08-17 | Kalamazoo | Michigan | 26077 | 1754 | 86 |
445192 | 445192 | 2020-08-18 | Kalamazoo | Michigan | 26077 | 1766 | 86 |
448418 | 448418 | 2020-08-19 | Kalamazoo | Michigan | 26077 | 1779 | 87 |
451646 | 451646 | 2020-08-20 | Kalamazoo | Michigan | 26077 | 1784 | 86 |
454874 | 454874 | 2020-08-21 | Kalamazoo | Michigan | 26077 | 1784 | 86 |
458102 | 458102 | 2020-08-22 | Kalamazoo | Michigan | 26077 | 1809 | 86 |
461329 | 461329 | 2020-08-23 | Kalamazoo | Michigan | 26077 | 1828 | 86 |
464560 | 464560 | 2020-08-24 | Kalamazoo | Michigan | 26077 | 1844 | 86 |
467789 | 467789 | 2020-08-25 | Kalamazoo | Michigan | 26077 | 1857 | 86 |
471019 | 471019 | 2020-08-26 | Kalamazoo | Michigan | 26077 | 1864 | 87 |
474251 | 474251 | 2020-08-27 | Kalamazoo | Michigan | 26077 | 1890 | 87 |
477484 | 477484 | 2020-08-28 | Kalamazoo | Michigan | 26077 | 1912 | 87 |
480716 | 480716 | 2020-08-29 | Kalamazoo | Michigan | 26077 | 1924 | 88 |
483951 | 483951 | 2020-08-30 | Kalamazoo | Michigan | 26077 | 1935 | 88 |
487185 | 487185 | 2020-08-31 | Kalamazoo | Michigan | 26077 | 1942 | 88 |
490418 | 490418 | 2020-09-01 | Kalamazoo | Michigan | 26077 | 1965 | 88 |
493652 | 493652 | 2020-09-02 | Kalamazoo | Michigan | 26077 | 1979 | 88 |
496885 | 496885 | 2020-09-03 | Kalamazoo | Michigan | 26077 | 1995 | 88 |
500119 | 500119 | 2020-09-04 | Kalamazoo | Michigan | 26077 | 2037 | 88 |
503353 | 503353 | 2020-09-05 | Kalamazoo | Michigan | 26077 | 2069 | 89 |
506586 | 506586 | 2020-09-06 | Kalamazoo | Michigan | 26077 | 2069 | 89 |
509819 | 509819 | 2020-09-07 | Kalamazoo | Michigan | 26077 | 2091 | 89 |
513051 | 513051 | 2020-09-08 | Kalamazoo | Michigan | 26077 | 2095 | 89 |
516285 | 516285 | 2020-09-09 | Kalamazoo | Michigan | 26077 | 2141 | 90 |
519520 | 519520 | 2020-09-10 | Kalamazoo | Michigan | 26077 | 2190 | 91 |
522757 | 522757 | 2020-09-11 | Kalamazoo | Michigan | 26077 | 2239 | 91 |
525993 | 525993 | 2020-09-12 | Kalamazoo | Michigan | 26077 | 2276 | 91 |
529229 | 529229 | 2020-09-13 | Kalamazoo | Michigan | 26077 | 2276 | 91 |
532465 | 532465 | 2020-09-14 | Kalamazoo | Michigan | 26077 | 2326 | 91 |
535700 | 535700 | 2020-09-15 | Kalamazoo | Michigan | 26077 | 2352 | 91 |
538937 | 538937 | 2020-09-16 | Kalamazoo | Michigan | 26077 | 2411 | 91 |
542173 | 542173 | 2020-09-17 | Kalamazoo | Michigan | 26077 | 2473 | 92 |
545410 | 545410 | 2020-09-18 | Kalamazoo | Michigan | 26077 | 2534 | 91 |
548648 | 548648 | 2020-09-19 | Kalamazoo | Michigan | 26077 | 2580 | 91 |
551887 | 551887 | 2020-09-20 | Kalamazoo | Michigan | 26077 | 2580 | 91 |
555125 | 555125 | 2020-09-21 | Kalamazoo | Michigan | 26077 | 2616 | 91 |
558362 | 558362 | 2020-09-22 | Kalamazoo | Michigan | 26077 | 2661 | 91 |
561599 | 561599 | 2020-09-23 | Kalamazoo | Michigan | 26077 | 2707 | 92 |
564839 | 564839 | 2020-09-24 | Kalamazoo | Michigan | 26077 | 2763 | 93 |
568079 | 568079 | 2020-09-25 | Kalamazoo | Michigan | 26077 | 2833 | 93 |
571321 | 571321 | 2020-09-26 | Kalamazoo | Michigan | 26077 | 2888 | 93 |
574564 | 574564 | 2020-09-27 | Kalamazoo | Michigan | 26077 | 2888 | 93 |
577805 | 577805 | 2020-09-28 | Kalamazoo | Michigan | 26077 | 2944 | 94 |
581046 | 581046 | 2020-09-29 | Kalamazoo | Michigan | 26077 | 2999 | 94 |
584287 | 584287 | 2020-09-30 | Kalamazoo | Michigan | 26077 | 3053 | 96 |
587527 | 587527 | 2020-10-01 | Kalamazoo | Michigan | 26077 | 3100 | 96 |
590768 | 590768 | 2020-10-02 | Kalamazoo | Michigan | 26077 | 3156 | 96 |
594009 | 594009 | 2020-10-03 | Kalamazoo | Michigan | 26077 | 3223 | 96 |
597250 | 597250 | 2020-10-04 | Kalamazoo | Michigan | 26077 | 3223 | 96 |
600493 | 600493 | 2020-10-05 | Kalamazoo | Michigan | 26077 | 3262 | 96 |
603735 | 603735 | 2020-10-06 | Kalamazoo | Michigan | 26077 | 3336 | 96 |
606978 | 606978 | 2020-10-07 | Kalamazoo | Michigan | 26077 | 3406 | 96 |
610220 | 610220 | 2020-10-08 | Kalamazoo | Michigan | 26077 | 3483 | 96 |
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);