ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

1,573 rows where county = "Albany" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 2

fips 2

county 1

  • Albany · 1,573 ✖
Link rowid date ▲ county state fips cases deaths
2501428 2501428 2022-05-13 Albany New York 36001 63461 523
2502810 2502810 2022-05-13 Albany Wyoming 56001 9934 49
2498170 2498170 2022-05-12 Albany New York 36001 63461 523
2499552 2499552 2022-05-12 Albany Wyoming 56001 9934 49
2494912 2494912 2022-05-11 Albany New York 36001 63241 522
2496294 2496294 2022-05-11 Albany Wyoming 56001 9934 49
2491654 2491654 2022-05-10 Albany New York 36001 63093 522
2493036 2493036 2022-05-10 Albany Wyoming 56001 9934 49
2488396 2488396 2022-05-09 Albany New York 36001 62981 522
2489778 2489778 2022-05-09 Albany Wyoming 56001 9914 49
2485139 2485139 2022-05-08 Albany New York 36001 62869 522
2486521 2486521 2022-05-08 Albany Wyoming 56001 9914 49
2481881 2481881 2022-05-07 Albany New York 36001 62740 521
2483263 2483263 2022-05-07 Albany Wyoming 56001 9914 49
2478623 2478623 2022-05-06 Albany New York 36001 62542 521
2480005 2480005 2022-05-06 Albany Wyoming 56001 9914 49
2475365 2475365 2022-05-05 Albany New York 36001 62332 521
2476747 2476747 2022-05-05 Albany Wyoming 56001 9914 49
2472108 2472108 2022-05-04 Albany New York 36001 62094 520
2473489 2473489 2022-05-04 Albany Wyoming 56001 9914 49
2468852 2468852 2022-05-03 Albany New York 36001 61935 520
2470232 2470232 2022-05-03 Albany Wyoming 56001 9914 49
2465596 2465596 2022-05-02 Albany New York 36001 61815 520
2466976 2466976 2022-05-02 Albany Wyoming 56001 9905 48
2462341 2462341 2022-05-01 Albany New York 36001 61737 520
2463721 2463721 2022-05-01 Albany Wyoming 56001 9905 48
2459085 2459085 2022-04-30 Albany New York 36001 61597 520
2460465 2460465 2022-04-30 Albany Wyoming 56001 9905 48
2455829 2455829 2022-04-29 Albany New York 36001 61449 520
2457209 2457209 2022-04-29 Albany Wyoming 56001 9905 48
2452573 2452573 2022-04-28 Albany New York 36001 61276 518
2453953 2453953 2022-04-28 Albany Wyoming 56001 9905 48
2449317 2449317 2022-04-27 Albany New York 36001 61114 518
2450697 2450697 2022-04-27 Albany Wyoming 56001 9905 48
2446060 2446060 2022-04-26 Albany New York 36001 60977 518
2447441 2447441 2022-04-26 Albany Wyoming 56001 9905 48
2442805 2442805 2022-04-25 Albany New York 36001 60876 518
2444185 2444185 2022-04-25 Albany Wyoming 56001 9894 48
2439549 2439549 2022-04-24 Albany New York 36001 60769 516
2440929 2440929 2022-04-24 Albany Wyoming 56001 9894 48
2436293 2436293 2022-04-23 Albany New York 36001 60645 516
2437673 2437673 2022-04-23 Albany Wyoming 56001 9894 48
2433037 2433037 2022-04-22 Albany New York 36001 60516 516
2434417 2434417 2022-04-22 Albany Wyoming 56001 9894 48
2429781 2429781 2022-04-21 Albany New York 36001 60388 516
2431161 2431161 2022-04-21 Albany Wyoming 56001 9894 48
2426525 2426525 2022-04-20 Albany New York 36001 60247 515
2427905 2427905 2022-04-20 Albany Wyoming 56001 9894 48
2423269 2423269 2022-04-19 Albany New York 36001 60129 512
2424649 2424649 2022-04-19 Albany Wyoming 56001 9894 48
2420012 2420012 2022-04-18 Albany New York 36001 60066 510
2421393 2421393 2022-04-18 Albany Wyoming 56001 9880 48
2416757 2416757 2022-04-17 Albany New York 36001 60012 510
2418137 2418137 2022-04-17 Albany Wyoming 56001 9880 48
2413501 2413501 2022-04-16 Albany New York 36001 59912 510
2414881 2414881 2022-04-16 Albany Wyoming 56001 9880 48
2410245 2410245 2022-04-15 Albany New York 36001 59804 510
2411625 2411625 2022-04-15 Albany Wyoming 56001 9880 48
2406989 2406989 2022-04-14 Albany New York 36001 59676 510
2408369 2408369 2022-04-14 Albany Wyoming 56001 9880 48
2403733 2403733 2022-04-13 Albany New York 36001 59559 510
2405113 2405113 2022-04-13 Albany Wyoming 56001 9880 48
2400478 2400478 2022-04-12 Albany New York 36001 59499 510
2401858 2401858 2022-04-12 Albany Wyoming 56001 9880 48
2397223 2397223 2022-04-11 Albany New York 36001 59457 510
2398603 2398603 2022-04-11 Albany Wyoming 56001 9885 48
2393968 2393968 2022-04-10 Albany New York 36001 59401 510
2395348 2395348 2022-04-10 Albany Wyoming 56001 9885 48
2390712 2390712 2022-04-09 Albany New York 36001 59329 510
2392092 2392092 2022-04-09 Albany Wyoming 56001 9885 48
2387456 2387456 2022-04-08 Albany New York 36001 59260 510
2388836 2388836 2022-04-08 Albany Wyoming 56001 9885 48
2384201 2384201 2022-04-07 Albany New York 36001 59192 510
2385581 2385581 2022-04-07 Albany Wyoming 56001 9883 48
2380946 2380946 2022-04-06 Albany New York 36001 59106 510
2382326 2382326 2022-04-06 Albany Wyoming 56001 9883 48
2377691 2377691 2022-04-05 Albany New York 36001 59049 509
2379071 2379071 2022-04-05 Albany Wyoming 56001 9883 48
2374438 2374438 2022-04-04 Albany New York 36001 59004 509
2375817 2375817 2022-04-04 Albany Wyoming 56001 9878 48
2371186 2371186 2022-04-03 Albany New York 36001 58966 509
2372565 2372565 2022-04-03 Albany Wyoming 56001 9878 48
2367933 2367933 2022-04-02 Albany New York 36001 58934 509
2369312 2369312 2022-04-02 Albany Wyoming 56001 9878 48
2364680 2364680 2022-04-01 Albany New York 36001 58895 509
2366059 2366059 2022-04-01 Albany Wyoming 56001 9878 48
2361426 2361426 2022-03-31 Albany New York 36001 58835 509
2362806 2362806 2022-03-31 Albany Wyoming 56001 9873 48
2358172 2358172 2022-03-30 Albany New York 36001 58783 509
2359552 2359552 2022-03-30 Albany Wyoming 56001 9873 48
2354918 2354918 2022-03-29 Albany New York 36001 58745 509
2356298 2356298 2022-03-29 Albany Wyoming 56001 9873 48
2351665 2351665 2022-03-28 Albany New York 36001 58719 509
2353045 2353045 2022-03-28 Albany Wyoming 56001 9869 48
2348413 2348413 2022-03-27 Albany New York 36001 58691 509
2349793 2349793 2022-03-27 Albany Wyoming 56001 9869 48
2345160 2345160 2022-03-26 Albany New York 36001 58663 508
2346540 2346540 2022-03-26 Albany Wyoming 56001 9869 48
2341907 2341907 2022-03-25 Albany New York 36001 58625 507
2343287 2343287 2022-03-25 Albany Wyoming 56001 9869 48

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);