ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Albany" and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636730 | 636730 | 2020-10-16 | Albany | New York | 36001 | 3383 | 124 |
633484 | 633484 | 2020-10-15 | Albany | New York | 36001 | 3369 | 124 |
630239 | 630239 | 2020-10-14 | Albany | New York | 36001 | 3343 | 124 |
626995 | 626995 | 2020-10-13 | Albany | New York | 36001 | 3324 | 124 |
623753 | 623753 | 2020-10-12 | Albany | New York | 36001 | 3304 | 124 |
620510 | 620510 | 2020-10-11 | Albany | New York | 36001 | 3293 | 124 |
617268 | 617268 | 2020-10-10 | Albany | New York | 36001 | 3280 | 124 |
614026 | 614026 | 2020-10-09 | Albany | New York | 36001 | 3268 | 123 |
610785 | 610785 | 2020-10-08 | Albany | New York | 36001 | 3251 | 123 |
607543 | 607543 | 2020-10-07 | Albany | New York | 36001 | 3233 | 123 |
604300 | 604300 | 2020-10-06 | Albany | New York | 36001 | 3218 | 123 |
601058 | 601058 | 2020-10-05 | Albany | New York | 36001 | 3201 | 123 |
597815 | 597815 | 2020-10-04 | Albany | New York | 36001 | 3190 | 123 |
594572 | 594572 | 2020-10-03 | Albany | New York | 36001 | 3175 | 123 |
591331 | 591331 | 2020-10-02 | Albany | New York | 36001 | 3153 | 123 |
588090 | 588090 | 2020-10-01 | Albany | New York | 36001 | 3133 | 123 |
584850 | 584850 | 2020-09-30 | Albany | New York | 36001 | 3120 | 123 |
581609 | 581609 | 2020-09-29 | Albany | New York | 36001 | 3116 | 123 |
578369 | 578369 | 2020-09-28 | Albany | New York | 36001 | 3104 | 123 |
575128 | 575128 | 2020-09-27 | Albany | New York | 36001 | 3095 | 123 |
571884 | 571884 | 2020-09-26 | Albany | New York | 36001 | 3082 | 123 |
568642 | 568642 | 2020-09-25 | Albany | New York | 36001 | 3063 | 123 |
565401 | 565401 | 2020-09-24 | Albany | New York | 36001 | 3053 | 123 |
562160 | 562160 | 2020-09-23 | Albany | New York | 36001 | 3043 | 123 |
558923 | 558923 | 2020-09-22 | Albany | New York | 36001 | 3037 | 123 |
555686 | 555686 | 2020-09-21 | Albany | New York | 36001 | 3024 | 123 |
552449 | 552449 | 2020-09-20 | Albany | New York | 36001 | 3016 | 123 |
549210 | 549210 | 2020-09-19 | Albany | New York | 36001 | 3006 | 123 |
545971 | 545971 | 2020-09-18 | Albany | New York | 36001 | 2979 | 123 |
542734 | 542734 | 2020-09-17 | Albany | New York | 36001 | 2969 | 123 |
539498 | 539498 | 2020-09-16 | Albany | New York | 36001 | 2948 | 123 |
536261 | 536261 | 2020-09-15 | Albany | New York | 36001 | 2936 | 123 |
533025 | 533025 | 2020-09-14 | Albany | New York | 36001 | 2921 | 123 |
529790 | 529790 | 2020-09-13 | Albany | New York | 36001 | 2915 | 123 |
526553 | 526553 | 2020-09-12 | Albany | New York | 36001 | 2896 | 123 |
523317 | 523317 | 2020-09-11 | Albany | New York | 36001 | 2882 | 122 |
520081 | 520081 | 2020-09-10 | Albany | New York | 36001 | 2859 | 122 |
516845 | 516845 | 2020-09-09 | Albany | New York | 36001 | 2846 | 122 |
513610 | 513610 | 2020-09-08 | Albany | New York | 36001 | 2840 | 122 |
510377 | 510377 | 2020-09-07 | Albany | New York | 36001 | 2833 | 122 |
507144 | 507144 | 2020-09-06 | Albany | New York | 36001 | 2831 | 122 |
503912 | 503912 | 2020-09-05 | Albany | New York | 36001 | 2823 | 122 |
500678 | 500678 | 2020-09-04 | Albany | New York | 36001 | 2819 | 122 |
497444 | 497444 | 2020-09-03 | Albany | New York | 36001 | 2802 | 122 |
494211 | 494211 | 2020-09-02 | Albany | New York | 36001 | 2791 | 122 |
490977 | 490977 | 2020-09-01 | Albany | New York | 36001 | 2786 | 122 |
487744 | 487744 | 2020-08-31 | Albany | New York | 36001 | 2770 | 122 |
484511 | 484511 | 2020-08-30 | Albany | New York | 36001 | 2764 | 122 |
481276 | 481276 | 2020-08-29 | Albany | New York | 36001 | 2754 | 122 |
478043 | 478043 | 2020-08-28 | Albany | New York | 36001 | 2746 | 121 |
474810 | 474810 | 2020-08-27 | Albany | New York | 36001 | 2736 | 121 |
471576 | 471576 | 2020-08-26 | Albany | New York | 36001 | 2718 | 120 |
468344 | 468344 | 2020-08-25 | Albany | New York | 36001 | 2711 | 120 |
465116 | 465116 | 2020-08-24 | Albany | New York | 36001 | 2701 | 120 |
461887 | 461887 | 2020-08-23 | Albany | New York | 36001 | 2699 | 120 |
458659 | 458659 | 2020-08-22 | Albany | New York | 36001 | 2693 | 120 |
455431 | 455431 | 2020-08-21 | Albany | New York | 36001 | 2691 | 120 |
452203 | 452203 | 2020-08-20 | Albany | New York | 36001 | 2684 | 120 |
448975 | 448975 | 2020-08-19 | Albany | New York | 36001 | 2675 | 119 |
445747 | 445747 | 2020-08-18 | Albany | New York | 36001 | 2661 | 119 |
442521 | 442521 | 2020-08-17 | Albany | New York | 36001 | 2657 | 119 |
439294 | 439294 | 2020-08-16 | Albany | New York | 36001 | 2654 | 118 |
436069 | 436069 | 2020-08-15 | Albany | New York | 36001 | 2643 | 118 |
432843 | 432843 | 2020-08-14 | Albany | New York | 36001 | 2639 | 118 |
429617 | 429617 | 2020-08-13 | Albany | New York | 36001 | 2636 | 118 |
426392 | 426392 | 2020-08-12 | Albany | New York | 36001 | 2624 | 117 |
423169 | 423169 | 2020-08-11 | Albany | New York | 36001 | 2614 | 117 |
419946 | 419946 | 2020-08-10 | Albany | New York | 36001 | 2600 | 116 |
416726 | 416726 | 2020-08-09 | Albany | New York | 36001 | 2595 | 116 |
413505 | 413505 | 2020-08-08 | Albany | New York | 36001 | 2581 | 116 |
410285 | 410285 | 2020-08-07 | Albany | New York | 36001 | 2573 | 116 |
407065 | 407065 | 2020-08-06 | Albany | New York | 36001 | 2565 | 116 |
403846 | 403846 | 2020-08-05 | Albany | New York | 36001 | 2556 | 170 |
400628 | 400628 | 2020-08-04 | Albany | New York | 36001 | 2543 | 170 |
397413 | 397413 | 2020-08-03 | Albany | New York | 36001 | 2531 | 170 |
394196 | 394196 | 2020-08-02 | Albany | New York | 36001 | 2521 | 170 |
390980 | 390980 | 2020-08-01 | Albany | New York | 36001 | 2515 | 170 |
387763 | 387763 | 2020-07-31 | Albany | New York | 36001 | 2503 | 169 |
384546 | 384546 | 2020-07-30 | Albany | New York | 36001 | 2493 | 169 |
381328 | 381328 | 2020-07-29 | Albany | New York | 36001 | 2480 | 168 |
378111 | 378111 | 2020-07-28 | Albany | New York | 36001 | 2468 | 167 |
374895 | 374895 | 2020-07-27 | Albany | New York | 36001 | 2453 | 166 |
371683 | 371683 | 2020-07-26 | Albany | New York | 36001 | 2451 | 166 |
368471 | 368471 | 2020-07-25 | Albany | New York | 36001 | 2438 | 166 |
365262 | 365262 | 2020-07-24 | Albany | New York | 36001 | 2426 | 166 |
362056 | 362056 | 2020-07-23 | Albany | New York | 36001 | 2401 | 166 |
358850 | 358850 | 2020-07-22 | Albany | New York | 36001 | 2369 | 166 |
355646 | 355646 | 2020-07-21 | Albany | New York | 36001 | 2351 | 165 |
352443 | 352443 | 2020-07-20 | Albany | New York | 36001 | 2322 | 164 |
349240 | 349240 | 2020-07-19 | Albany | New York | 36001 | 2318 | 164 |
346039 | 346039 | 2020-07-18 | Albany | New York | 36001 | 2315 | 163 |
342840 | 342840 | 2020-07-17 | Albany | New York | 36001 | 2310 | 162 |
339642 | 339642 | 2020-07-16 | Albany | New York | 36001 | 2290 | 161 |
336446 | 336446 | 2020-07-15 | Albany | New York | 36001 | 2280 | 161 |
333252 | 333252 | 2020-07-14 | Albany | New York | 36001 | 2247 | 161 |
330062 | 330062 | 2020-07-13 | Albany | New York | 36001 | 2225 | 161 |
326875 | 326875 | 2020-07-12 | Albany | New York | 36001 | 2219 | 161 |
323691 | 323691 | 2020-07-11 | Albany | New York | 36001 | 2208 | 161 |
320511 | 320511 | 2020-07-10 | Albany | New York | 36001 | 2190 | 161 |
317334 | 317334 | 2020-07-09 | Albany | New York | 36001 | 2183 | 161 |
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);