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

786 rows where county = "Wayne" 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 · 786 ✖

fips 1

county 1

  • Wayne · 786 ✖
Link rowid date ▲ county state fips cases deaths
2501482 2501482 2022-05-13 Wayne New York 36117 18503 179
2498224 2498224 2022-05-12 Wayne New York 36117 18503 179
2494966 2494966 2022-05-11 Wayne New York 36117 18451 179
2491708 2491708 2022-05-10 Wayne New York 36117 18419 178
2488450 2488450 2022-05-09 Wayne New York 36117 18402 178
2485193 2485193 2022-05-08 Wayne New York 36117 18370 177
2481935 2481935 2022-05-07 Wayne New York 36117 18288 175
2478677 2478677 2022-05-06 Wayne New York 36117 18261 175
2475419 2475419 2022-05-05 Wayne New York 36117 18219 175
2472162 2472162 2022-05-04 Wayne New York 36117 18179 174
2468906 2468906 2022-05-03 Wayne New York 36117 18129 174
2465650 2465650 2022-05-02 Wayne New York 36117 18112 174
2462395 2462395 2022-05-01 Wayne New York 36117 18096 174
2459139 2459139 2022-04-30 Wayne New York 36117 18062 174
2455883 2455883 2022-04-29 Wayne New York 36117 18025 174
2452627 2452627 2022-04-28 Wayne New York 36117 17971 174
2449371 2449371 2022-04-27 Wayne New York 36117 17910 174
2446114 2446114 2022-04-26 Wayne New York 36117 17870 174
2442859 2442859 2022-04-25 Wayne New York 36117 17851 174
2439603 2439603 2022-04-24 Wayne New York 36117 17817 174
2436347 2436347 2022-04-23 Wayne New York 36117 17752 173
2433091 2433091 2022-04-22 Wayne New York 36117 17737 173
2429835 2429835 2022-04-21 Wayne New York 36117 17704 173
2426579 2426579 2022-04-20 Wayne New York 36117 17664 173
2423323 2423323 2022-04-19 Wayne New York 36117 17607 173
2420066 2420066 2022-04-18 Wayne New York 36117 17590 173
2416811 2416811 2022-04-17 Wayne New York 36117 17574 173
2413555 2413555 2022-04-16 Wayne New York 36117 17543 173
2410299 2410299 2022-04-15 Wayne New York 36117 17519 173
2407043 2407043 2022-04-14 Wayne New York 36117 17491 173
2403787 2403787 2022-04-13 Wayne New York 36117 17460 173
2400532 2400532 2022-04-12 Wayne New York 36117 17425 173
2397277 2397277 2022-04-11 Wayne New York 36117 17404 173
2394022 2394022 2022-04-10 Wayne New York 36117 17385 173
2390766 2390766 2022-04-09 Wayne New York 36117 17367 173
2387510 2387510 2022-04-08 Wayne New York 36117 17346 173
2384255 2384255 2022-04-07 Wayne New York 36117 17307 172
2381000 2381000 2022-04-06 Wayne New York 36117 17275 172
2377745 2377745 2022-04-05 Wayne New York 36117 17250 171
2374492 2374492 2022-04-04 Wayne New York 36117 17234 171
2371240 2371240 2022-04-03 Wayne New York 36117 17218 171
2367987 2367987 2022-04-02 Wayne New York 36117 17201 171
2364734 2364734 2022-04-01 Wayne New York 36117 17180 171
2361480 2361480 2022-03-31 Wayne New York 36117 17155 171
2358226 2358226 2022-03-30 Wayne New York 36117 17142 171
2354972 2354972 2022-03-29 Wayne New York 36117 17125 171
2351719 2351719 2022-03-28 Wayne New York 36117 17117 171
2348467 2348467 2022-03-27 Wayne New York 36117 17108 170
2345214 2345214 2022-03-26 Wayne New York 36117 17100 170
2341961 2341961 2022-03-25 Wayne New York 36117 17094 170
2338708 2338708 2022-03-24 Wayne New York 36117 17084 170
2335454 2335454 2022-03-23 Wayne New York 36117 17070 170
2332200 2332200 2022-03-22 Wayne New York 36117 17051 170
2328947 2328947 2022-03-21 Wayne New York 36117 17049 170
2325695 2325695 2022-03-20 Wayne New York 36117 17048 170
2322442 2322442 2022-03-19 Wayne New York 36117 17046 170
2319188 2319188 2022-03-18 Wayne New York 36117 17039 170
2315934 2315934 2022-03-17 Wayne New York 36117 17032 170
2312681 2312681 2022-03-16 Wayne New York 36117 17021 170
2309428 2309428 2022-03-15 Wayne New York 36117 17006 170
2306175 2306175 2022-03-14 Wayne New York 36117 17004 170
2302924 2302924 2022-03-13 Wayne New York 36117 16999 170
2299672 2299672 2022-03-12 Wayne New York 36117 16989 168
2296420 2296420 2022-03-11 Wayne New York 36117 16982 168
2293168 2293168 2022-03-10 Wayne New York 36117 16955 168
2289916 2289916 2022-03-09 Wayne New York 36117 16952 168
2286664 2286664 2022-03-08 Wayne New York 36117 16944 168
2283412 2283412 2022-03-07 Wayne New York 36117 16936 168
2280160 2280160 2022-03-06 Wayne New York 36117 16930 168
2276907 2276907 2022-03-05 Wayne New York 36117 16917 168
2273654 2273654 2022-03-04 Wayne New York 36117 16903 168
2270401 2270401 2022-03-03 Wayne New York 36117 16903 168
2267149 2267149 2022-03-02 Wayne New York 36117 16894 168
2263897 2263897 2022-03-01 Wayne New York 36117 16887 167
2260646 2260646 2022-02-28 Wayne New York 36117 16883 167
2257395 2257395 2022-02-27 Wayne New York 36117 16875 167
2254144 2254144 2022-02-26 Wayne New York 36117 16865 167
2250893 2250893 2022-02-25 Wayne New York 36117 16849 167
2247642 2247642 2022-02-24 Wayne New York 36117 16834 166
2244391 2244391 2022-02-23 Wayne New York 36117 16823 166
2241140 2241140 2022-02-22 Wayne New York 36117 16811 166
2237889 2237889 2022-02-21 Wayne New York 36117 16804 166
2234638 2234638 2022-02-20 Wayne New York 36117 16794 166
2231387 2231387 2022-02-19 Wayne New York 36117 16785 164
2228136 2228136 2022-02-18 Wayne New York 36117 16768 164
2224885 2224885 2022-02-17 Wayne New York 36117 16748 164
2221634 2221634 2022-02-16 Wayne New York 36117 16711 164
2218383 2218383 2022-02-15 Wayne New York 36117 16689 164
2215132 2215132 2022-02-14 Wayne New York 36117 16676 164
2211881 2211881 2022-02-13 Wayne New York 36117 16663 163
2208628 2208628 2022-02-12 Wayne New York 36117 16646 163
2205375 2205375 2022-02-11 Wayne New York 36117 16610 163
2202122 2202122 2022-02-10 Wayne New York 36117 16571 162
2198868 2198868 2022-02-09 Wayne New York 36117 16530 161
2195614 2195614 2022-02-08 Wayne New York 36117 16498 161
2192360 2192360 2022-02-07 Wayne New York 36117 16465 160
2189106 2189106 2022-02-06 Wayne New York 36117 16425 160
2185853 2185853 2022-02-05 Wayne New York 36117 16402 160
2182601 2182601 2022-02-04 Wayne New York 36117 16363 159
2179349 2179349 2022-02-03 Wayne New York 36117 16306 159

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