ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
703 rows where county = "Alger" and state = "Michigan" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
225816 | 225816 | 2020-06-10 | Alger | Michigan | 26003 | 1 | 0 |
228918 | 228918 | 2020-06-11 | Alger | Michigan | 26003 | 1 | 0 |
232022 | 232022 | 2020-06-12 | Alger | Michigan | 26003 | 1 | 0 |
235127 | 235127 | 2020-06-13 | Alger | Michigan | 26003 | 1 | 0 |
238234 | 238234 | 2020-06-14 | Alger | Michigan | 26003 | 1 | 0 |
241343 | 241343 | 2020-06-15 | Alger | Michigan | 26003 | 1 | 0 |
244454 | 244454 | 2020-06-16 | Alger | Michigan | 26003 | 1 | 0 |
247567 | 247567 | 2020-06-17 | Alger | Michigan | 26003 | 2 | 0 |
250679 | 250679 | 2020-06-18 | Alger | Michigan | 26003 | 2 | 0 |
253794 | 253794 | 2020-06-19 | Alger | Michigan | 26003 | 2 | 0 |
256914 | 256914 | 2020-06-20 | Alger | Michigan | 26003 | 2 | 0 |
260040 | 260040 | 2020-06-21 | Alger | Michigan | 26003 | 2 | 0 |
263169 | 263169 | 2020-06-22 | Alger | Michigan | 26003 | 2 | 0 |
266295 | 266295 | 2020-06-23 | Alger | Michigan | 26003 | 2 | 0 |
269428 | 269428 | 2020-06-24 | Alger | Michigan | 26003 | 2 | 0 |
272565 | 272565 | 2020-06-25 | Alger | Michigan | 26003 | 2 | 0 |
275708 | 275708 | 2020-06-26 | Alger | Michigan | 26003 | 2 | 0 |
278856 | 278856 | 2020-06-27 | Alger | Michigan | 26003 | 3 | 0 |
282004 | 282004 | 2020-06-28 | Alger | Michigan | 26003 | 3 | 0 |
285149 | 285149 | 2020-06-29 | Alger | Michigan | 26003 | 3 | 0 |
288299 | 288299 | 2020-06-30 | Alger | Michigan | 26003 | 3 | 0 |
291450 | 291450 | 2020-07-01 | Alger | Michigan | 26003 | 4 | 0 |
294604 | 294604 | 2020-07-02 | Alger | Michigan | 26003 | 4 | 0 |
297762 | 297762 | 2020-07-03 | Alger | Michigan | 26003 | 4 | 0 |
300924 | 300924 | 2020-07-04 | Alger | Michigan | 26003 | 4 | 0 |
304088 | 304088 | 2020-07-05 | Alger | Michigan | 26003 | 4 | 0 |
307255 | 307255 | 2020-07-06 | Alger | Michigan | 26003 | 4 | 0 |
310423 | 310423 | 2020-07-07 | Alger | Michigan | 26003 | 4 | 0 |
313593 | 313593 | 2020-07-08 | Alger | Michigan | 26003 | 4 | 0 |
316767 | 316767 | 2020-07-09 | Alger | Michigan | 26003 | 4 | 0 |
319942 | 319942 | 2020-07-10 | Alger | Michigan | 26003 | 4 | 0 |
323121 | 323121 | 2020-07-11 | Alger | Michigan | 26003 | 4 | 0 |
326304 | 326304 | 2020-07-12 | Alger | Michigan | 26003 | 4 | 0 |
329490 | 329490 | 2020-07-13 | Alger | Michigan | 26003 | 4 | 0 |
332677 | 332677 | 2020-07-14 | Alger | Michigan | 26003 | 4 | 0 |
335870 | 335870 | 2020-07-15 | Alger | Michigan | 26003 | 5 | 0 |
339066 | 339066 | 2020-07-16 | Alger | Michigan | 26003 | 4 | 0 |
342262 | 342262 | 2020-07-17 | Alger | Michigan | 26003 | 4 | 0 |
345462 | 345462 | 2020-07-18 | Alger | Michigan | 26003 | 4 | 0 |
348663 | 348663 | 2020-07-19 | Alger | Michigan | 26003 | 4 | 0 |
351863 | 351863 | 2020-07-20 | Alger | Michigan | 26003 | 4 | 0 |
355065 | 355065 | 2020-07-21 | Alger | Michigan | 26003 | 4 | 0 |
358268 | 358268 | 2020-07-22 | Alger | Michigan | 26003 | 4 | 0 |
361473 | 361473 | 2020-07-23 | Alger | Michigan | 26003 | 5 | 0 |
364680 | 364680 | 2020-07-24 | Alger | Michigan | 26003 | 5 | 0 |
367887 | 367887 | 2020-07-25 | Alger | Michigan | 26003 | 5 | 0 |
371097 | 371097 | 2020-07-26 | Alger | Michigan | 26003 | 5 | 0 |
374309 | 374309 | 2020-07-27 | Alger | Michigan | 26003 | 5 | 0 |
377524 | 377524 | 2020-07-28 | Alger | Michigan | 26003 | 5 | 0 |
380741 | 380741 | 2020-07-29 | Alger | Michigan | 26003 | 5 | 0 |
383958 | 383958 | 2020-07-30 | Alger | Michigan | 26003 | 6 | 0 |
387176 | 387176 | 2020-07-31 | Alger | Michigan | 26003 | 8 | 0 |
390393 | 390393 | 2020-08-01 | Alger | Michigan | 26003 | 8 | 0 |
393610 | 393610 | 2020-08-02 | Alger | Michigan | 26003 | 8 | 0 |
396826 | 396826 | 2020-08-03 | Alger | Michigan | 26003 | 9 | 0 |
400040 | 400040 | 2020-08-04 | Alger | Michigan | 26003 | 8 | 0 |
403257 | 403257 | 2020-08-05 | Alger | Michigan | 26003 | 8 | 0 |
406475 | 406475 | 2020-08-06 | Alger | Michigan | 26003 | 8 | 0 |
409695 | 409695 | 2020-08-07 | Alger | Michigan | 26003 | 9 | 0 |
412915 | 412915 | 2020-08-08 | Alger | Michigan | 26003 | 11 | 0 |
416135 | 416135 | 2020-08-09 | Alger | Michigan | 26003 | 11 | 0 |
419356 | 419356 | 2020-08-10 | Alger | Michigan | 26003 | 11 | 0 |
422578 | 422578 | 2020-08-11 | Alger | Michigan | 26003 | 12 | 0 |
425800 | 425800 | 2020-08-12 | Alger | Michigan | 26003 | 15 | 0 |
429024 | 429024 | 2020-08-13 | Alger | Michigan | 26003 | 15 | 0 |
432251 | 432251 | 2020-08-14 | Alger | Michigan | 26003 | 17 | 0 |
435477 | 435477 | 2020-08-15 | Alger | Michigan | 26003 | 17 | 0 |
438702 | 438702 | 2020-08-16 | Alger | Michigan | 26003 | 17 | 0 |
441929 | 441929 | 2020-08-17 | Alger | Michigan | 26003 | 17 | 0 |
445155 | 445155 | 2020-08-18 | Alger | Michigan | 26003 | 17 | 0 |
448381 | 448381 | 2020-08-19 | Alger | Michigan | 26003 | 17 | 0 |
451609 | 451609 | 2020-08-20 | Alger | Michigan | 26003 | 18 | 0 |
454837 | 454837 | 2020-08-21 | Alger | Michigan | 26003 | 18 | 0 |
458065 | 458065 | 2020-08-22 | Alger | Michigan | 26003 | 18 | 0 |
461292 | 461292 | 2020-08-23 | Alger | Michigan | 26003 | 18 | 0 |
464523 | 464523 | 2020-08-24 | Alger | Michigan | 26003 | 17 | 0 |
467752 | 467752 | 2020-08-25 | Alger | Michigan | 26003 | 17 | 0 |
470982 | 470982 | 2020-08-26 | Alger | Michigan | 26003 | 17 | 0 |
474214 | 474214 | 2020-08-27 | Alger | Michigan | 26003 | 17 | 0 |
477447 | 477447 | 2020-08-28 | Alger | Michigan | 26003 | 17 | 0 |
480679 | 480679 | 2020-08-29 | Alger | Michigan | 26003 | 17 | 0 |
483914 | 483914 | 2020-08-30 | Alger | Michigan | 26003 | 17 | 0 |
487148 | 487148 | 2020-08-31 | Alger | Michigan | 26003 | 17 | 0 |
490381 | 490381 | 2020-09-01 | Alger | Michigan | 26003 | 17 | 0 |
493615 | 493615 | 2020-09-02 | Alger | Michigan | 26003 | 17 | 0 |
496848 | 496848 | 2020-09-03 | Alger | Michigan | 26003 | 17 | 0 |
500082 | 500082 | 2020-09-04 | Alger | Michigan | 26003 | 18 | 0 |
503316 | 503316 | 2020-09-05 | Alger | Michigan | 26003 | 17 | 0 |
506549 | 506549 | 2020-09-06 | Alger | Michigan | 26003 | 17 | 0 |
509782 | 509782 | 2020-09-07 | Alger | Michigan | 26003 | 17 | 0 |
513014 | 513014 | 2020-09-08 | Alger | Michigan | 26003 | 17 | 0 |
516248 | 516248 | 2020-09-09 | Alger | Michigan | 26003 | 17 | 0 |
519483 | 519483 | 2020-09-10 | Alger | Michigan | 26003 | 17 | 0 |
522720 | 522720 | 2020-09-11 | Alger | Michigan | 26003 | 17 | 0 |
525956 | 525956 | 2020-09-12 | Alger | Michigan | 26003 | 17 | 0 |
529192 | 529192 | 2020-09-13 | Alger | Michigan | 26003 | 17 | 0 |
532428 | 532428 | 2020-09-14 | Alger | Michigan | 26003 | 17 | 0 |
535663 | 535663 | 2020-09-15 | Alger | Michigan | 26003 | 17 | 0 |
538900 | 538900 | 2020-09-16 | Alger | Michigan | 26003 | 17 | 0 |
542136 | 542136 | 2020-09-17 | Alger | Michigan | 26003 | 17 | 0 |
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);