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

789 rows where fips = 36069 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 36069 · 789 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501460 2501460 2022-05-13 Ontario New York 36069 21586 180
2498202 2498202 2022-05-12 Ontario New York 36069 21586 180
2494944 2494944 2022-05-11 Ontario New York 36069 21538 180
2491686 2491686 2022-05-10 Ontario New York 36069 21496 180
2488428 2488428 2022-05-09 Ontario New York 36069 21472 179
2485171 2485171 2022-05-08 Ontario New York 36069 21442 179
2481913 2481913 2022-05-07 Ontario New York 36069 21397 179
2478655 2478655 2022-05-06 Ontario New York 36069 21348 178
2475397 2475397 2022-05-05 Ontario New York 36069 21295 178
2472140 2472140 2022-05-04 Ontario New York 36069 21228 178
2468884 2468884 2022-05-03 Ontario New York 36069 21158 178
2465628 2465628 2022-05-02 Ontario New York 36069 21130 178
2462373 2462373 2022-05-01 Ontario New York 36069 21105 178
2459117 2459117 2022-04-30 Ontario New York 36069 21062 178
2455861 2455861 2022-04-29 Ontario New York 36069 21014 178
2452605 2452605 2022-04-28 Ontario New York 36069 20965 178
2449349 2449349 2022-04-27 Ontario New York 36069 20899 178
2446092 2446092 2022-04-26 Ontario New York 36069 20839 177
2442837 2442837 2022-04-25 Ontario New York 36069 20810 176
2439581 2439581 2022-04-24 Ontario New York 36069 20769 176
2436325 2436325 2022-04-23 Ontario New York 36069 20694 176
2433069 2433069 2022-04-22 Ontario New York 36069 20671 176
2429813 2429813 2022-04-21 Ontario New York 36069 20616 176
2426557 2426557 2022-04-20 Ontario New York 36069 20547 176
2423301 2423301 2022-04-19 Ontario New York 36069 20479 176
2420044 2420044 2022-04-18 Ontario New York 36069 20452 176
2416789 2416789 2022-04-17 Ontario New York 36069 20412 176
2413533 2413533 2022-04-16 Ontario New York 36069 20361 176
2410277 2410277 2022-04-15 Ontario New York 36069 20312 176
2407021 2407021 2022-04-14 Ontario New York 36069 20262 176
2403765 2403765 2022-04-13 Ontario New York 36069 20211 176
2400510 2400510 2022-04-12 Ontario New York 36069 20163 176
2397255 2397255 2022-04-11 Ontario New York 36069 20149 176
2394000 2394000 2022-04-10 Ontario New York 36069 20123 175
2390744 2390744 2022-04-09 Ontario New York 36069 20105 175
2387488 2387488 2022-04-08 Ontario New York 36069 20074 175
2384233 2384233 2022-04-07 Ontario New York 36069 20044 175
2380978 2380978 2022-04-06 Ontario New York 36069 20009 175
2377723 2377723 2022-04-05 Ontario New York 36069 19965 175
2374470 2374470 2022-04-04 Ontario New York 36069 19951 175
2371218 2371218 2022-04-03 Ontario New York 36069 19930 175
2367965 2367965 2022-04-02 Ontario New York 36069 19907 175
2364712 2364712 2022-04-01 Ontario New York 36069 19885 175
2361458 2361458 2022-03-31 Ontario New York 36069 19862 175
2358204 2358204 2022-03-30 Ontario New York 36069 19846 175
2354950 2354950 2022-03-29 Ontario New York 36069 19821 175
2351697 2351697 2022-03-28 Ontario New York 36069 19815 175
2348445 2348445 2022-03-27 Ontario New York 36069 19801 175
2345192 2345192 2022-03-26 Ontario New York 36069 19787 175
2341939 2341939 2022-03-25 Ontario New York 36069 19769 175
2338686 2338686 2022-03-24 Ontario New York 36069 19752 175
2335432 2335432 2022-03-23 Ontario New York 36069 19732 175
2332178 2332178 2022-03-22 Ontario New York 36069 19701 174
2328925 2328925 2022-03-21 Ontario New York 36069 19695 174
2325673 2325673 2022-03-20 Ontario New York 36069 19691 173
2322420 2322420 2022-03-19 Ontario New York 36069 19683 173
2319166 2319166 2022-03-18 Ontario New York 36069 19671 173
2315912 2315912 2022-03-17 Ontario New York 36069 19662 173
2312659 2312659 2022-03-16 Ontario New York 36069 19650 173
2309406 2309406 2022-03-15 Ontario New York 36069 19632 173
2306153 2306153 2022-03-14 Ontario New York 36069 19622 173
2302902 2302902 2022-03-13 Ontario New York 36069 19619 173
2299650 2299650 2022-03-12 Ontario New York 36069 19605 172
2296398 2296398 2022-03-11 Ontario New York 36069 19598 172
2293146 2293146 2022-03-10 Ontario New York 36069 19567 172
2289894 2289894 2022-03-09 Ontario New York 36069 19564 172
2286642 2286642 2022-03-08 Ontario New York 36069 19554 172
2283390 2283390 2022-03-07 Ontario New York 36069 19550 172
2280138 2280138 2022-03-06 Ontario New York 36069 19540 172
2276885 2276885 2022-03-05 Ontario New York 36069 19535 172
2273632 2273632 2022-03-04 Ontario New York 36069 19509 171
2270379 2270379 2022-03-03 Ontario New York 36069 19509 171
2267127 2267127 2022-03-02 Ontario New York 36069 19489 171
2263875 2263875 2022-03-01 Ontario New York 36069 19467 171
2260624 2260624 2022-02-28 Ontario New York 36069 19461 170
2257373 2257373 2022-02-27 Ontario New York 36069 19444 170
2254122 2254122 2022-02-26 Ontario New York 36069 19433 170
2250871 2250871 2022-02-25 Ontario New York 36069 19423 170
2247620 2247620 2022-02-24 Ontario New York 36069 19394 170
2244369 2244369 2022-02-23 Ontario New York 36069 19383 170
2241118 2241118 2022-02-22 Ontario New York 36069 19359 170
2237867 2237867 2022-02-21 Ontario New York 36069 19353 170
2234616 2234616 2022-02-20 Ontario New York 36069 19335 170
2231365 2231365 2022-02-19 Ontario New York 36069 19314 170
2228114 2228114 2022-02-18 Ontario New York 36069 19290 170
2224863 2224863 2022-02-17 Ontario New York 36069 19251 170
2221612 2221612 2022-02-16 Ontario New York 36069 19220 170
2218361 2218361 2022-02-15 Ontario New York 36069 19188 170
2215110 2215110 2022-02-14 Ontario New York 36069 19177 169
2211859 2211859 2022-02-13 Ontario New York 36069 19153 169
2208606 2208606 2022-02-12 Ontario New York 36069 19129 169
2205353 2205353 2022-02-11 Ontario New York 36069 19089 169
2202100 2202100 2022-02-10 Ontario New York 36069 19057 168
2198846 2198846 2022-02-09 Ontario New York 36069 19016 167
2195592 2195592 2022-02-08 Ontario New York 36069 18963 167
2192338 2192338 2022-02-07 Ontario New York 36069 18937 166
2189084 2189084 2022-02-06 Ontario New York 36069 18906 166
2185831 2185831 2022-02-05 Ontario New York 36069 18873 166
2182579 2182579 2022-02-04 Ontario New York 36069 18824 166
2179327 2179327 2022-02-03 Ontario New York 36069 18758 166

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