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

790 rows where fips = 36079 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 · 790 ✖

fips 1

  • 36079 · 790 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501465 2501465 2022-05-13 Putnam New York 36079 24875 125
2498207 2498207 2022-05-12 Putnam New York 36079 24875 125
2494949 2494949 2022-05-11 Putnam New York 36079 24801 125
2491691 2491691 2022-05-10 Putnam New York 36079 24746 125
2488433 2488433 2022-05-09 Putnam New York 36079 24725 125
2485176 2485176 2022-05-08 Putnam New York 36079 24685 124
2481918 2481918 2022-05-07 Putnam New York 36079 24650 124
2478660 2478660 2022-05-06 Putnam New York 36079 24592 124
2475402 2475402 2022-05-05 Putnam New York 36079 24546 123
2472145 2472145 2022-05-04 Putnam New York 36079 24485 122
2468889 2468889 2022-05-03 Putnam New York 36079 24433 122
2465633 2465633 2022-05-02 Putnam New York 36079 24401 122
2462378 2462378 2022-05-01 Putnam New York 36079 24375 122
2459122 2459122 2022-04-30 Putnam New York 36079 24343 122
2455866 2455866 2022-04-29 Putnam New York 36079 24300 122
2452610 2452610 2022-04-28 Putnam New York 36079 24267 122
2449354 2449354 2022-04-27 Putnam New York 36079 24224 122
2446097 2446097 2022-04-26 Putnam New York 36079 24188 122
2442842 2442842 2022-04-25 Putnam New York 36079 24164 122
2439586 2439586 2022-04-24 Putnam New York 36079 24141 122
2436330 2436330 2022-04-23 Putnam New York 36079 24117 122
2433074 2433074 2022-04-22 Putnam New York 36079 24085 122
2429818 2429818 2022-04-21 Putnam New York 36079 24056 122
2426562 2426562 2022-04-20 Putnam New York 36079 24027 122
2423306 2423306 2022-04-19 Putnam New York 36079 24003 122
2420049 2420049 2022-04-18 Putnam New York 36079 23981 121
2416794 2416794 2022-04-17 Putnam New York 36079 23955 121
2413538 2413538 2022-04-16 Putnam New York 36079 23925 121
2410282 2410282 2022-04-15 Putnam New York 36079 23898 121
2407026 2407026 2022-04-14 Putnam New York 36079 23876 121
2403770 2403770 2022-04-13 Putnam New York 36079 23840 121
2400515 2400515 2022-04-12 Putnam New York 36079 23805 121
2397260 2397260 2022-04-11 Putnam New York 36079 23793 121
2394005 2394005 2022-04-10 Putnam New York 36079 23778 121
2390749 2390749 2022-04-09 Putnam New York 36079 23758 121
2387493 2387493 2022-04-08 Putnam New York 36079 23736 121
2384238 2384238 2022-04-07 Putnam New York 36079 23713 121
2380983 2380983 2022-04-06 Putnam New York 36079 23687 121
2377728 2377728 2022-04-05 Putnam New York 36079 23649 121
2374475 2374475 2022-04-04 Putnam New York 36079 23628 121
2371223 2371223 2022-04-03 Putnam New York 36079 23620 121
2367970 2367970 2022-04-02 Putnam New York 36079 23603 121
2364717 2364717 2022-04-01 Putnam New York 36079 23592 121
2361463 2361463 2022-03-31 Putnam New York 36079 23568 121
2358209 2358209 2022-03-30 Putnam New York 36079 23550 121
2354955 2354955 2022-03-29 Putnam New York 36079 23530 121
2351702 2351702 2022-03-28 Putnam New York 36079 23516 121
2348450 2348450 2022-03-27 Putnam New York 36079 23505 121
2345197 2345197 2022-03-26 Putnam New York 36079 23494 121
2341944 2341944 2022-03-25 Putnam New York 36079 23482 121
2338691 2338691 2022-03-24 Putnam New York 36079 23473 121
2335437 2335437 2022-03-23 Putnam New York 36079 23464 121
2332183 2332183 2022-03-22 Putnam New York 36079 23438 121
2328930 2328930 2022-03-21 Putnam New York 36079 23437 121
2325678 2325678 2022-03-20 Putnam New York 36079 23436 121
2322425 2322425 2022-03-19 Putnam New York 36079 23434 121
2319171 2319171 2022-03-18 Putnam New York 36079 23416 121
2315917 2315917 2022-03-17 Putnam New York 36079 23413 121
2312664 2312664 2022-03-16 Putnam New York 36079 23407 121
2309411 2309411 2022-03-15 Putnam New York 36079 23389 121
2306158 2306158 2022-03-14 Putnam New York 36079 23385 121
2302907 2302907 2022-03-13 Putnam New York 36079 23383 121
2299655 2299655 2022-03-12 Putnam New York 36079 23374 121
2296403 2296403 2022-03-11 Putnam New York 36079 23369 121
2293151 2293151 2022-03-10 Putnam New York 36079 23360 121
2289899 2289899 2022-03-09 Putnam New York 36079 23360 121
2286647 2286647 2022-03-08 Putnam New York 36079 23351 121
2283395 2283395 2022-03-07 Putnam New York 36079 23348 121
2280143 2280143 2022-03-06 Putnam New York 36079 23343 121
2276890 2276890 2022-03-05 Putnam New York 36079 23336 121
2273637 2273637 2022-03-04 Putnam New York 36079 23320 121
2270384 2270384 2022-03-03 Putnam New York 36079 23320 121
2267132 2267132 2022-03-02 Putnam New York 36079 23315 121
2263880 2263880 2022-03-01 Putnam New York 36079 23307 121
2260629 2260629 2022-02-28 Putnam New York 36079 23302 121
2257378 2257378 2022-02-27 Putnam New York 36079 23294 121
2254127 2254127 2022-02-26 Putnam New York 36079 23289 121
2250876 2250876 2022-02-25 Putnam New York 36079 23281 121
2247625 2247625 2022-02-24 Putnam New York 36079 23268 121
2244374 2244374 2022-02-23 Putnam New York 36079 23259 121
2241123 2241123 2022-02-22 Putnam New York 36079 23250 121
2237872 2237872 2022-02-21 Putnam New York 36079 23245 121
2234621 2234621 2022-02-20 Putnam New York 36079 23238 121
2231370 2231370 2022-02-19 Putnam New York 36079 23229 121
2228119 2228119 2022-02-18 Putnam New York 36079 23206 121
2224868 2224868 2022-02-17 Putnam New York 36079 23163 121
2221617 2221617 2022-02-16 Putnam New York 36079 23154 121
2218366 2218366 2022-02-15 Putnam New York 36079 23140 121
2215115 2215115 2022-02-14 Putnam New York 36079 23131 121
2211864 2211864 2022-02-13 Putnam New York 36079 23121 121
2208611 2208611 2022-02-12 Putnam New York 36079 23114 121
2205358 2205358 2022-02-11 Putnam New York 36079 23097 121
2202105 2202105 2022-02-10 Putnam New York 36079 23080 121
2198851 2198851 2022-02-09 Putnam New York 36079 23059 121
2195597 2195597 2022-02-08 Putnam New York 36079 23019 120
2192343 2192343 2022-02-07 Putnam New York 36079 22993 120
2189089 2189089 2022-02-06 Putnam New York 36079 22978 120
2185836 2185836 2022-02-05 Putnam New York 36079 22958 119
2182584 2182584 2022-02-04 Putnam New York 36079 22932 119
2179332 2179332 2022-02-03 Putnam New York 36079 22912 118

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