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

793 rows where fips = 36001 and state = "New York" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • New York · 793 ✖

fips 1

  • 36001 · 793 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501428 2501428 2022-05-13 Albany New York 36001 63461 523
2498170 2498170 2022-05-12 Albany New York 36001 63461 523
2494912 2494912 2022-05-11 Albany New York 36001 63241 522
2491654 2491654 2022-05-10 Albany New York 36001 63093 522
2488396 2488396 2022-05-09 Albany New York 36001 62981 522
2485139 2485139 2022-05-08 Albany New York 36001 62869 522
2481881 2481881 2022-05-07 Albany New York 36001 62740 521
2478623 2478623 2022-05-06 Albany New York 36001 62542 521
2475365 2475365 2022-05-05 Albany New York 36001 62332 521
2472108 2472108 2022-05-04 Albany New York 36001 62094 520
2468852 2468852 2022-05-03 Albany New York 36001 61935 520
2465596 2465596 2022-05-02 Albany New York 36001 61815 520
2462341 2462341 2022-05-01 Albany New York 36001 61737 520
2459085 2459085 2022-04-30 Albany New York 36001 61597 520
2455829 2455829 2022-04-29 Albany New York 36001 61449 520
2452573 2452573 2022-04-28 Albany New York 36001 61276 518
2449317 2449317 2022-04-27 Albany New York 36001 61114 518
2446060 2446060 2022-04-26 Albany New York 36001 60977 518
2442805 2442805 2022-04-25 Albany New York 36001 60876 518
2439549 2439549 2022-04-24 Albany New York 36001 60769 516
2436293 2436293 2022-04-23 Albany New York 36001 60645 516
2433037 2433037 2022-04-22 Albany New York 36001 60516 516
2429781 2429781 2022-04-21 Albany New York 36001 60388 516
2426525 2426525 2022-04-20 Albany New York 36001 60247 515
2423269 2423269 2022-04-19 Albany New York 36001 60129 512
2420012 2420012 2022-04-18 Albany New York 36001 60066 510
2416757 2416757 2022-04-17 Albany New York 36001 60012 510
2413501 2413501 2022-04-16 Albany New York 36001 59912 510
2410245 2410245 2022-04-15 Albany New York 36001 59804 510
2406989 2406989 2022-04-14 Albany New York 36001 59676 510
2403733 2403733 2022-04-13 Albany New York 36001 59559 510
2400478 2400478 2022-04-12 Albany New York 36001 59499 510
2397223 2397223 2022-04-11 Albany New York 36001 59457 510
2393968 2393968 2022-04-10 Albany New York 36001 59401 510
2390712 2390712 2022-04-09 Albany New York 36001 59329 510
2387456 2387456 2022-04-08 Albany New York 36001 59260 510
2384201 2384201 2022-04-07 Albany New York 36001 59192 510
2380946 2380946 2022-04-06 Albany New York 36001 59106 510
2377691 2377691 2022-04-05 Albany New York 36001 59049 509
2374438 2374438 2022-04-04 Albany New York 36001 59004 509
2371186 2371186 2022-04-03 Albany New York 36001 58966 509
2367933 2367933 2022-04-02 Albany New York 36001 58934 509
2364680 2364680 2022-04-01 Albany New York 36001 58895 509
2361426 2361426 2022-03-31 Albany New York 36001 58835 509
2358172 2358172 2022-03-30 Albany New York 36001 58783 509
2354918 2354918 2022-03-29 Albany New York 36001 58745 509
2351665 2351665 2022-03-28 Albany New York 36001 58719 509
2348413 2348413 2022-03-27 Albany New York 36001 58691 509
2345160 2345160 2022-03-26 Albany New York 36001 58663 508
2341907 2341907 2022-03-25 Albany New York 36001 58625 507
2338654 2338654 2022-03-24 Albany New York 36001 58593 507
2335400 2335400 2022-03-23 Albany New York 36001 58551 507
2332146 2332146 2022-03-22 Albany New York 36001 58501 507
2328893 2328893 2022-03-21 Albany New York 36001 58482 507
2325641 2325641 2022-03-20 Albany New York 36001 58466 507
2322388 2322388 2022-03-19 Albany New York 36001 58442 507
2319134 2319134 2022-03-18 Albany New York 36001 58415 507
2315880 2315880 2022-03-17 Albany New York 36001 58381 507
2312627 2312627 2022-03-16 Albany New York 36001 58357 507
2309374 2309374 2022-03-15 Albany New York 36001 58324 507
2306121 2306121 2022-03-14 Albany New York 36001 58307 507
2302870 2302870 2022-03-13 Albany New York 36001 58299 507
2299618 2299618 2022-03-12 Albany New York 36001 58269 504
2296366 2296366 2022-03-11 Albany New York 36001 58247 504
2293114 2293114 2022-03-10 Albany New York 36001 58222 504
2289862 2289862 2022-03-09 Albany New York 36001 58199 504
2286610 2286610 2022-03-08 Albany New York 36001 58162 503
2283358 2283358 2022-03-07 Albany New York 36001 58143 503
2280106 2280106 2022-03-06 Albany New York 36001 58130 502
2276853 2276853 2022-03-05 Albany New York 36001 58101 502
2273600 2273600 2022-03-04 Albany New York 36001 58018 502
2270347 2270347 2022-03-03 Albany New York 36001 58018 502
2267095 2267095 2022-03-02 Albany New York 36001 57983 502
2263843 2263843 2022-03-01 Albany New York 36001 57952 502
2260592 2260592 2022-02-28 Albany New York 36001 57922 502
2257341 2257341 2022-02-27 Albany New York 36001 57904 502
2254090 2254090 2022-02-26 Albany New York 36001 57886 502
2250839 2250839 2022-02-25 Albany New York 36001 57848 502
2247588 2247588 2022-02-24 Albany New York 36001 57817 501
2244337 2244337 2022-02-23 Albany New York 36001 57777 501
2241086 2241086 2022-02-22 Albany New York 36001 57743 501
2237835 2237835 2022-02-21 Albany New York 36001 57715 501
2234584 2234584 2022-02-20 Albany New York 36001 57686 500
2231333 2231333 2022-02-19 Albany New York 36001 57649 498
2228082 2228082 2022-02-18 Albany New York 36001 57575 498
2224831 2224831 2022-02-17 Albany New York 36001 57516 498
2221580 2221580 2022-02-16 Albany New York 36001 57454 498
2218329 2218329 2022-02-15 Albany New York 36001 57381 498
2215078 2215078 2022-02-14 Albany New York 36001 57334 497
2211827 2211827 2022-02-13 Albany New York 36001 57292 496
2208574 2208574 2022-02-12 Albany New York 36001 57236 493
2205321 2205321 2022-02-11 Albany New York 36001 57166 493
2202068 2202068 2022-02-10 Albany New York 36001 57086 491
2198814 2198814 2022-02-09 Albany New York 36001 56961 490
2195560 2195560 2022-02-08 Albany New York 36001 56818 490
2192306 2192306 2022-02-07 Albany New York 36001 56760 490
2189052 2189052 2022-02-06 Albany New York 36001 56701 488
2185799 2185799 2022-02-05 Albany New York 36001 56325 486
2182547 2182547 2022-02-04 Albany New York 36001 56197 485
2179295 2179295 2022-02-03 Albany New York 36001 56072 485

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