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

  • Jefferson · 787 ✖
Link rowid date ▲ county state fips cases deaths
2501449 2501449 2022-05-13 Jefferson New York 36045 21422 138
2498191 2498191 2022-05-12 Jefferson New York 36045 21422 138
2494933 2494933 2022-05-11 Jefferson New York 36045 21358 137
2491675 2491675 2022-05-10 Jefferson New York 36045 21305 137
2488417 2488417 2022-05-09 Jefferson New York 36045 21244 137
2485160 2485160 2022-05-08 Jefferson New York 36045 21218 137
2481902 2481902 2022-05-07 Jefferson New York 36045 21184 137
2478644 2478644 2022-05-06 Jefferson New York 36045 21128 137
2475386 2475386 2022-05-05 Jefferson New York 36045 21074 137
2472129 2472129 2022-05-04 Jefferson New York 36045 21020 137
2468873 2468873 2022-05-03 Jefferson New York 36045 20968 137
2465617 2465617 2022-05-02 Jefferson New York 36045 20925 137
2462362 2462362 2022-05-01 Jefferson New York 36045 20894 137
2459106 2459106 2022-04-30 Jefferson New York 36045 20855 137
2455850 2455850 2022-04-29 Jefferson New York 36045 20806 137
2452594 2452594 2022-04-28 Jefferson New York 36045 20760 137
2449338 2449338 2022-04-27 Jefferson New York 36045 20708 137
2446081 2446081 2022-04-26 Jefferson New York 36045 20665 137
2442826 2442826 2022-04-25 Jefferson New York 36045 20628 137
2439570 2439570 2022-04-24 Jefferson New York 36045 20608 137
2436314 2436314 2022-04-23 Jefferson New York 36045 20581 137
2433058 2433058 2022-04-22 Jefferson New York 36045 20532 137
2429802 2429802 2022-04-21 Jefferson New York 36045 20480 137
2426546 2426546 2022-04-20 Jefferson New York 36045 20441 137
2423290 2423290 2022-04-19 Jefferson New York 36045 20403 137
2420033 2420033 2022-04-18 Jefferson New York 36045 20361 137
2416778 2416778 2022-04-17 Jefferson New York 36045 20348 137
2413522 2413522 2022-04-16 Jefferson New York 36045 20331 137
2410266 2410266 2022-04-15 Jefferson New York 36045 20300 137
2407010 2407010 2022-04-14 Jefferson New York 36045 20279 137
2403754 2403754 2022-04-13 Jefferson New York 36045 20253 137
2400499 2400499 2022-04-12 Jefferson New York 36045 20220 136
2397244 2397244 2022-04-11 Jefferson New York 36045 20195 136
2393989 2393989 2022-04-10 Jefferson New York 36045 20184 136
2390733 2390733 2022-04-09 Jefferson New York 36045 20166 136
2387477 2387477 2022-04-08 Jefferson New York 36045 20143 136
2384222 2384222 2022-04-07 Jefferson New York 36045 20116 136
2380967 2380967 2022-04-06 Jefferson New York 36045 20087 136
2377712 2377712 2022-04-05 Jefferson New York 36045 20067 136
2374459 2374459 2022-04-04 Jefferson New York 36045 20047 135
2371207 2371207 2022-04-03 Jefferson New York 36045 20039 135
2367954 2367954 2022-04-02 Jefferson New York 36045 20025 135
2364701 2364701 2022-04-01 Jefferson New York 36045 20013 135
2361447 2361447 2022-03-31 Jefferson New York 36045 19995 135
2358193 2358193 2022-03-30 Jefferson New York 36045 19973 135
2354939 2354939 2022-03-29 Jefferson New York 36045 19951 135
2351686 2351686 2022-03-28 Jefferson New York 36045 19941 135
2348434 2348434 2022-03-27 Jefferson New York 36045 19932 134
2345181 2345181 2022-03-26 Jefferson New York 36045 19927 134
2341928 2341928 2022-03-25 Jefferson New York 36045 19913 134
2338675 2338675 2022-03-24 Jefferson New York 36045 19902 134
2335421 2335421 2022-03-23 Jefferson New York 36045 19888 134
2332167 2332167 2022-03-22 Jefferson New York 36045 19866 134
2328914 2328914 2022-03-21 Jefferson New York 36045 19857 133
2325662 2325662 2022-03-20 Jefferson New York 36045 19851 132
2322409 2322409 2022-03-19 Jefferson New York 36045 19838 131
2319155 2319155 2022-03-18 Jefferson New York 36045 19818 131
2315901 2315901 2022-03-17 Jefferson New York 36045 19807 131
2312648 2312648 2022-03-16 Jefferson New York 36045 19799 131
2309395 2309395 2022-03-15 Jefferson New York 36045 19776 131
2306142 2306142 2022-03-14 Jefferson New York 36045 19759 131
2302891 2302891 2022-03-13 Jefferson New York 36045 19752 131
2299639 2299639 2022-03-12 Jefferson New York 36045 19741 131
2296387 2296387 2022-03-11 Jefferson New York 36045 19725 131
2293135 2293135 2022-03-10 Jefferson New York 36045 19710 131
2289883 2289883 2022-03-09 Jefferson New York 36045 19694 131
2286631 2286631 2022-03-08 Jefferson New York 36045 19683 131
2283379 2283379 2022-03-07 Jefferson New York 36045 19672 130
2280127 2280127 2022-03-06 Jefferson New York 36045 19663 130
2276874 2276874 2022-03-05 Jefferson New York 36045 19652 130
2273621 2273621 2022-03-04 Jefferson New York 36045 19623 130
2270368 2270368 2022-03-03 Jefferson New York 36045 19623 130
2267116 2267116 2022-03-02 Jefferson New York 36045 19614 130
2263864 2263864 2022-03-01 Jefferson New York 36045 19600 130
2260613 2260613 2022-02-28 Jefferson New York 36045 19591 130
2257362 2257362 2022-02-27 Jefferson New York 36045 19583 130
2254111 2254111 2022-02-26 Jefferson New York 36045 19576 130
2250860 2250860 2022-02-25 Jefferson New York 36045 19558 129
2247609 2247609 2022-02-24 Jefferson New York 36045 19545 129
2244358 2244358 2022-02-23 Jefferson New York 36045 19517 129
2241107 2241107 2022-02-22 Jefferson New York 36045 19500 129
2237856 2237856 2022-02-21 Jefferson New York 36045 19488 129
2234605 2234605 2022-02-20 Jefferson New York 36045 19474 129
2231354 2231354 2022-02-19 Jefferson New York 36045 19446 129
2228103 2228103 2022-02-18 Jefferson New York 36045 19415 129
2224852 2224852 2022-02-17 Jefferson New York 36045 19387 129
2221601 2221601 2022-02-16 Jefferson New York 36045 19348 128
2218350 2218350 2022-02-15 Jefferson New York 36045 19303 128
2215099 2215099 2022-02-14 Jefferson New York 36045 19289 128
2211848 2211848 2022-02-13 Jefferson New York 36045 19264 128
2208595 2208595 2022-02-12 Jefferson New York 36045 19231 128
2205342 2205342 2022-02-11 Jefferson New York 36045 19189 128
2202089 2202089 2022-02-10 Jefferson New York 36045 19132 128
2198835 2198835 2022-02-09 Jefferson New York 36045 19066 126
2195581 2195581 2022-02-08 Jefferson New York 36045 19009 126
2192327 2192327 2022-02-07 Jefferson New York 36045 18948 126
2189073 2189073 2022-02-06 Jefferson New York 36045 18904 126
2185820 2185820 2022-02-05 Jefferson New York 36045 18861 126
2182568 2182568 2022-02-04 Jefferson New York 36045 18788 126
2179316 2179316 2022-02-03 Jefferson New York 36045 18722 126

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