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

787 rows where county = "Washington" 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 · 787 ✖

fips 1

county 1

  • Washington · 787 ✖
Link rowid date ▲ county state fips cases deaths
2501481 2501481 2022-05-13 Washington New York 36115 12875 115
2498223 2498223 2022-05-12 Washington New York 36115 12875 115
2494965 2494965 2022-05-11 Washington New York 36115 12823 115
2491707 2491707 2022-05-10 Washington New York 36115 12783 115
2488449 2488449 2022-05-09 Washington New York 36115 12746 114
2485192 2485192 2022-05-08 Washington New York 36115 12718 114
2481934 2481934 2022-05-07 Washington New York 36115 12702 114
2478676 2478676 2022-05-06 Washington New York 36115 12662 114
2475418 2475418 2022-05-05 Washington New York 36115 12635 113
2472161 2472161 2022-05-04 Washington New York 36115 12588 113
2468905 2468905 2022-05-03 Washington New York 36115 12547 113
2465649 2465649 2022-05-02 Washington New York 36115 12524 113
2462394 2462394 2022-05-01 Washington New York 36115 12502 113
2459138 2459138 2022-04-30 Washington New York 36115 12481 113
2455882 2455882 2022-04-29 Washington New York 36115 12443 113
2452626 2452626 2022-04-28 Washington New York 36115 12415 113
2449370 2449370 2022-04-27 Washington New York 36115 12371 113
2446113 2446113 2022-04-26 Washington New York 36115 12347 113
2442858 2442858 2022-04-25 Washington New York 36115 12331 113
2439602 2439602 2022-04-24 Washington New York 36115 12326 113
2436346 2436346 2022-04-23 Washington New York 36115 12290 113
2433090 2433090 2022-04-22 Washington New York 36115 12269 113
2429834 2429834 2022-04-21 Washington New York 36115 12247 113
2426578 2426578 2022-04-20 Washington New York 36115 12231 113
2423322 2423322 2022-04-19 Washington New York 36115 12218 113
2420065 2420065 2022-04-18 Washington New York 36115 12211 113
2416810 2416810 2022-04-17 Washington New York 36115 12202 113
2413554 2413554 2022-04-16 Washington New York 36115 12187 113
2410298 2410298 2022-04-15 Washington New York 36115 12179 113
2407042 2407042 2022-04-14 Washington New York 36115 12165 113
2403786 2403786 2022-04-13 Washington New York 36115 12147 113
2400531 2400531 2022-04-12 Washington New York 36115 12134 113
2397276 2397276 2022-04-11 Washington New York 36115 12129 113
2394021 2394021 2022-04-10 Washington New York 36115 12123 113
2390765 2390765 2022-04-09 Washington New York 36115 12112 113
2387509 2387509 2022-04-08 Washington New York 36115 12104 113
2384254 2384254 2022-04-07 Washington New York 36115 12092 113
2380999 2380999 2022-04-06 Washington New York 36115 12082 113
2377744 2377744 2022-04-05 Washington New York 36115 12078 113
2374491 2374491 2022-04-04 Washington New York 36115 12070 113
2371239 2371239 2022-04-03 Washington New York 36115 12066 113
2367986 2367986 2022-04-02 Washington New York 36115 12055 113
2364733 2364733 2022-04-01 Washington New York 36115 12047 113
2361479 2361479 2022-03-31 Washington New York 36115 12035 113
2358225 2358225 2022-03-30 Washington New York 36115 12026 113
2354971 2354971 2022-03-29 Washington New York 36115 12020 113
2351718 2351718 2022-03-28 Washington New York 36115 12019 113
2348466 2348466 2022-03-27 Washington New York 36115 12016 113
2345213 2345213 2022-03-26 Washington New York 36115 12008 113
2341960 2341960 2022-03-25 Washington New York 36115 12004 113
2338707 2338707 2022-03-24 Washington New York 36115 11997 113
2335453 2335453 2022-03-23 Washington New York 36115 11994 113
2332199 2332199 2022-03-22 Washington New York 36115 11972 113
2328946 2328946 2022-03-21 Washington New York 36115 11972 113
2325694 2325694 2022-03-20 Washington New York 36115 11971 113
2322441 2322441 2022-03-19 Washington New York 36115 11968 113
2319187 2319187 2022-03-18 Washington New York 36115 11961 113
2315933 2315933 2022-03-17 Washington New York 36115 11949 113
2312680 2312680 2022-03-16 Washington New York 36115 11942 113
2309427 2309427 2022-03-15 Washington New York 36115 11933 113
2306174 2306174 2022-03-14 Washington New York 36115 11932 113
2302923 2302923 2022-03-13 Washington New York 36115 11931 113
2299671 2299671 2022-03-12 Washington New York 36115 11925 113
2296419 2296419 2022-03-11 Washington New York 36115 11917 113
2293167 2293167 2022-03-10 Washington New York 36115 11905 113
2289915 2289915 2022-03-09 Washington New York 36115 11903 113
2286663 2286663 2022-03-08 Washington New York 36115 11893 113
2283411 2283411 2022-03-07 Washington New York 36115 11890 113
2280159 2280159 2022-03-06 Washington New York 36115 11882 113
2276906 2276906 2022-03-05 Washington New York 36115 11875 113
2273653 2273653 2022-03-04 Washington New York 36115 11860 113
2270400 2270400 2022-03-03 Washington New York 36115 11860 113
2267148 2267148 2022-03-02 Washington New York 36115 11851 113
2263896 2263896 2022-03-01 Washington New York 36115 11843 113
2260645 2260645 2022-02-28 Washington New York 36115 11840 112
2257394 2257394 2022-02-27 Washington New York 36115 11832 112
2254143 2254143 2022-02-26 Washington New York 36115 11824 112
2250892 2250892 2022-02-25 Washington New York 36115 11813 112
2247641 2247641 2022-02-24 Washington New York 36115 11801 112
2244390 2244390 2022-02-23 Washington New York 36115 11788 112
2241139 2241139 2022-02-22 Washington New York 36115 11775 111
2237888 2237888 2022-02-21 Washington New York 36115 11768 111
2234637 2234637 2022-02-20 Washington New York 36115 11761 111
2231386 2231386 2022-02-19 Washington New York 36115 11745 111
2228135 2228135 2022-02-18 Washington New York 36115 11734 111
2224884 2224884 2022-02-17 Washington New York 36115 11715 111
2221633 2221633 2022-02-16 Washington New York 36115 11687 111
2218382 2218382 2022-02-15 Washington New York 36115 11673 111
2215131 2215131 2022-02-14 Washington New York 36115 11662 111
2211880 2211880 2022-02-13 Washington New York 36115 11650 111
2208627 2208627 2022-02-12 Washington New York 36115 11638 110
2205374 2205374 2022-02-11 Washington New York 36115 11616 110
2202121 2202121 2022-02-10 Washington New York 36115 11592 110
2198867 2198867 2022-02-09 Washington New York 36115 11553 108
2195613 2195613 2022-02-08 Washington New York 36115 11530 108
2192359 2192359 2022-02-07 Washington New York 36115 11512 108
2189105 2189105 2022-02-06 Washington New York 36115 11491 108
2185852 2185852 2022-02-05 Washington New York 36115 11467 108
2182600 2182600 2022-02-04 Washington New York 36115 11434 108
2179348 2179348 2022-02-03 Washington New York 36115 11388 107

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