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 = "Warren" 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

  • Warren · 787 ✖
Link rowid date ▲ county state fips cases deaths
2501480 2501480 2022-05-13 Warren New York 36113 14739 129
2498222 2498222 2022-05-12 Warren New York 36113 14739 129
2494964 2494964 2022-05-11 Warren New York 36113 14693 129
2491706 2491706 2022-05-10 Warren New York 36113 14635 129
2488448 2488448 2022-05-09 Warren New York 36113 14616 129
2485191 2485191 2022-05-08 Warren New York 36113 14588 129
2481933 2481933 2022-05-07 Warren New York 36113 14541 128
2478675 2478675 2022-05-06 Warren New York 36113 14483 128
2475417 2475417 2022-05-05 Warren New York 36113 14433 128
2472160 2472160 2022-05-04 Warren New York 36113 14367 128
2468904 2468904 2022-05-03 Warren New York 36113 14333 128
2465648 2465648 2022-05-02 Warren New York 36113 14301 128
2462393 2462393 2022-05-01 Warren New York 36113 14270 128
2459137 2459137 2022-04-30 Warren New York 36113 14225 128
2455881 2455881 2022-04-29 Warren New York 36113 14180 128
2452625 2452625 2022-04-28 Warren New York 36113 14138 127
2449369 2449369 2022-04-27 Warren New York 36113 14094 127
2446112 2446112 2022-04-26 Warren New York 36113 14052 127
2442857 2442857 2022-04-25 Warren New York 36113 14034 127
2439601 2439601 2022-04-24 Warren New York 36113 14010 127
2436345 2436345 2022-04-23 Warren New York 36113 13980 127
2433089 2433089 2022-04-22 Warren New York 36113 13956 127
2429833 2429833 2022-04-21 Warren New York 36113 13928 127
2426577 2426577 2022-04-20 Warren New York 36113 13915 127
2423321 2423321 2022-04-19 Warren New York 36113 13896 127
2420064 2420064 2022-04-18 Warren New York 36113 13884 127
2416809 2416809 2022-04-17 Warren New York 36113 13875 127
2413553 2413553 2022-04-16 Warren New York 36113 13849 127
2410297 2410297 2022-04-15 Warren New York 36113 13835 127
2407041 2407041 2022-04-14 Warren New York 36113 13805 127
2403785 2403785 2022-04-13 Warren New York 36113 13762 127
2400530 2400530 2022-04-12 Warren New York 36113 13736 127
2397275 2397275 2022-04-11 Warren New York 36113 13722 127
2394020 2394020 2022-04-10 Warren New York 36113 13715 127
2390764 2390764 2022-04-09 Warren New York 36113 13705 127
2387508 2387508 2022-04-08 Warren New York 36113 13682 127
2384253 2384253 2022-04-07 Warren New York 36113 13659 125
2380998 2380998 2022-04-06 Warren New York 36113 13635 125
2377743 2377743 2022-04-05 Warren New York 36113 13617 125
2374490 2374490 2022-04-04 Warren New York 36113 13606 125
2371238 2371238 2022-04-03 Warren New York 36113 13600 125
2367985 2367985 2022-04-02 Warren New York 36113 13589 125
2364732 2364732 2022-04-01 Warren New York 36113 13574 125
2361478 2361478 2022-03-31 Warren New York 36113 13552 125
2358224 2358224 2022-03-30 Warren New York 36113 13541 125
2354970 2354970 2022-03-29 Warren New York 36113 13533 125
2351717 2351717 2022-03-28 Warren New York 36113 13520 125
2348465 2348465 2022-03-27 Warren New York 36113 13506 125
2345212 2345212 2022-03-26 Warren New York 36113 13492 125
2341959 2341959 2022-03-25 Warren New York 36113 13479 125
2338706 2338706 2022-03-24 Warren New York 36113 13463 125
2335452 2335452 2022-03-23 Warren New York 36113 13444 125
2332198 2332198 2022-03-22 Warren New York 36113 13432 125
2328945 2328945 2022-03-21 Warren New York 36113 13429 125
2325693 2325693 2022-03-20 Warren New York 36113 13424 125
2322440 2322440 2022-03-19 Warren New York 36113 13418 123
2319186 2319186 2022-03-18 Warren New York 36113 13413 123
2315932 2315932 2022-03-17 Warren New York 36113 13407 123
2312679 2312679 2022-03-16 Warren New York 36113 13398 123
2309426 2309426 2022-03-15 Warren New York 36113 13389 123
2306173 2306173 2022-03-14 Warren New York 36113 13386 123
2302922 2302922 2022-03-13 Warren New York 36113 13384 123
2299670 2299670 2022-03-12 Warren New York 36113 13373 123
2296418 2296418 2022-03-11 Warren New York 36113 13369 123
2293166 2293166 2022-03-10 Warren New York 36113 13355 123
2289914 2289914 2022-03-09 Warren New York 36113 13348 123
2286662 2286662 2022-03-08 Warren New York 36113 13337 122
2283410 2283410 2022-03-07 Warren New York 36113 13325 122
2280158 2280158 2022-03-06 Warren New York 36113 13322 122
2276905 2276905 2022-03-05 Warren New York 36113 13318 122
2273652 2273652 2022-03-04 Warren New York 36113 13293 122
2270399 2270399 2022-03-03 Warren New York 36113 13293 122
2267147 2267147 2022-03-02 Warren New York 36113 13275 122
2263895 2263895 2022-03-01 Warren New York 36113 13267 122
2260644 2260644 2022-02-28 Warren New York 36113 13261 122
2257393 2257393 2022-02-27 Warren New York 36113 13253 122
2254142 2254142 2022-02-26 Warren New York 36113 13244 121
2250891 2250891 2022-02-25 Warren New York 36113 13234 121
2247640 2247640 2022-02-24 Warren New York 36113 13227 121
2244389 2244389 2022-02-23 Warren New York 36113 13205 121
2241138 2241138 2022-02-22 Warren New York 36113 13190 121
2237887 2237887 2022-02-21 Warren New York 36113 13176 120
2234636 2234636 2022-02-20 Warren New York 36113 13162 120
2231385 2231385 2022-02-19 Warren New York 36113 13150 120
2228134 2228134 2022-02-18 Warren New York 36113 13134 120
2224883 2224883 2022-02-17 Warren New York 36113 13103 119
2221632 2221632 2022-02-16 Warren New York 36113 13078 119
2218381 2218381 2022-02-15 Warren New York 36113 13060 119
2215130 2215130 2022-02-14 Warren New York 36113 13042 117
2211879 2211879 2022-02-13 Warren New York 36113 13026 117
2208626 2208626 2022-02-12 Warren New York 36113 13010 117
2205373 2205373 2022-02-11 Warren New York 36113 12985 117
2202120 2202120 2022-02-10 Warren New York 36113 12954 117
2198866 2198866 2022-02-09 Warren New York 36113 12908 117
2195612 2195612 2022-02-08 Warren New York 36113 12886 117
2192358 2192358 2022-02-07 Warren New York 36113 12873 117
2189104 2189104 2022-02-06 Warren New York 36113 12847 117
2185851 2185851 2022-02-05 Warren New York 36113 12831 117
2182599 2182599 2022-02-04 Warren New York 36113 12788 117
2179347 2179347 2022-02-03 Warren New York 36113 12743 116

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