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

783 rows where county = "Madison" and fips = 36053 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

  • 36053 · 783 ✖

county 1

  • Madison · 783 ✖
Link rowid date ▲ county state fips cases deaths
2501452 2501452 2022-05-13 Madison New York 36053 14319 127
2498194 2498194 2022-05-12 Madison New York 36053 14319 127
2494936 2494936 2022-05-11 Madison New York 36053 14290 127
2491678 2491678 2022-05-10 Madison New York 36053 14264 127
2488420 2488420 2022-05-09 Madison New York 36053 14245 127
2485163 2485163 2022-05-08 Madison New York 36053 14234 127
2481905 2481905 2022-05-07 Madison New York 36053 14213 127
2478647 2478647 2022-05-06 Madison New York 36053 14175 127
2475389 2475389 2022-05-05 Madison New York 36053 14148 127
2472132 2472132 2022-05-04 Madison New York 36053 14103 127
2468876 2468876 2022-05-03 Madison New York 36053 14067 127
2465620 2465620 2022-05-02 Madison New York 36053 14039 127
2462365 2462365 2022-05-01 Madison New York 36053 14033 127
2459109 2459109 2022-04-30 Madison New York 36053 14008 127
2455853 2455853 2022-04-29 Madison New York 36053 13978 127
2452597 2452597 2022-04-28 Madison New York 36053 13950 127
2449341 2449341 2022-04-27 Madison New York 36053 13908 127
2446084 2446084 2022-04-26 Madison New York 36053 13876 127
2442829 2442829 2022-04-25 Madison New York 36053 13844 127
2439573 2439573 2022-04-24 Madison New York 36053 13822 127
2436317 2436317 2022-04-23 Madison New York 36053 13806 126
2433061 2433061 2022-04-22 Madison New York 36053 13765 126
2429805 2429805 2022-04-21 Madison New York 36053 13726 126
2426549 2426549 2022-04-20 Madison New York 36053 13687 126
2423293 2423293 2022-04-19 Madison New York 36053 13647 126
2420036 2420036 2022-04-18 Madison New York 36053 13633 126
2416781 2416781 2022-04-17 Madison New York 36053 13615 126
2413525 2413525 2022-04-16 Madison New York 36053 13588 126
2410269 2410269 2022-04-15 Madison New York 36053 13557 126
2407013 2407013 2022-04-14 Madison New York 36053 13513 126
2403757 2403757 2022-04-13 Madison New York 36053 13470 126
2400502 2400502 2022-04-12 Madison New York 36053 13422 126
2397247 2397247 2022-04-11 Madison New York 36053 13397 126
2393992 2393992 2022-04-10 Madison New York 36053 13383 126
2390736 2390736 2022-04-09 Madison New York 36053 13361 126
2387480 2387480 2022-04-08 Madison New York 36053 13332 126
2384225 2384225 2022-04-07 Madison New York 36053 13292 126
2380970 2380970 2022-04-06 Madison New York 36053 13254 126
2377715 2377715 2022-04-05 Madison New York 36053 13208 126
2374462 2374462 2022-04-04 Madison New York 36053 13178 126
2371210 2371210 2022-04-03 Madison New York 36053 13157 126
2367957 2367957 2022-04-02 Madison New York 36053 13142 126
2364704 2364704 2022-04-01 Madison New York 36053 13120 126
2361450 2361450 2022-03-31 Madison New York 36053 13094 125
2358196 2358196 2022-03-30 Madison New York 36053 13057 125
2354942 2354942 2022-03-29 Madison New York 36053 13034 125
2351689 2351689 2022-03-28 Madison New York 36053 13017 125
2348437 2348437 2022-03-27 Madison New York 36053 13002 125
2345184 2345184 2022-03-26 Madison New York 36053 12986 125
2341931 2341931 2022-03-25 Madison New York 36053 12964 125
2338678 2338678 2022-03-24 Madison New York 36053 12936 125
2335424 2335424 2022-03-23 Madison New York 36053 12919 125
2332170 2332170 2022-03-22 Madison New York 36053 12877 125
2328917 2328917 2022-03-21 Madison New York 36053 12874 125
2325665 2325665 2022-03-20 Madison New York 36053 12871 125
2322412 2322412 2022-03-19 Madison New York 36053 12867 125
2319158 2319158 2022-03-18 Madison New York 36053 12856 125
2315904 2315904 2022-03-17 Madison New York 36053 12845 125
2312651 2312651 2022-03-16 Madison New York 36053 12823 125
2309398 2309398 2022-03-15 Madison New York 36053 12808 125
2306145 2306145 2022-03-14 Madison New York 36053 12799 125
2302894 2302894 2022-03-13 Madison New York 36053 12794 125
2299642 2299642 2022-03-12 Madison New York 36053 12787 125
2296390 2296390 2022-03-11 Madison New York 36053 12783 125
2293138 2293138 2022-03-10 Madison New York 36053 12771 125
2289886 2289886 2022-03-09 Madison New York 36053 12765 125
2286634 2286634 2022-03-08 Madison New York 36053 12761 125
2283382 2283382 2022-03-07 Madison New York 36053 12758 125
2280130 2280130 2022-03-06 Madison New York 36053 12752 125
2276877 2276877 2022-03-05 Madison New York 36053 12742 125
2273624 2273624 2022-03-04 Madison New York 36053 12717 125
2270371 2270371 2022-03-03 Madison New York 36053 12717 124
2267119 2267119 2022-03-02 Madison New York 36053 12713 124
2263867 2263867 2022-03-01 Madison New York 36053 12700 124
2260616 2260616 2022-02-28 Madison New York 36053 12693 124
2257365 2257365 2022-02-27 Madison New York 36053 12687 124
2254114 2254114 2022-02-26 Madison New York 36053 12683 124
2250863 2250863 2022-02-25 Madison New York 36053 12671 124
2247612 2247612 2022-02-24 Madison New York 36053 12658 124
2244361 2244361 2022-02-23 Madison New York 36053 12645 124
2241110 2241110 2022-02-22 Madison New York 36053 12633 124
2237859 2237859 2022-02-21 Madison New York 36053 12623 124
2234608 2234608 2022-02-20 Madison New York 36053 12614 124
2231357 2231357 2022-02-19 Madison New York 36053 12610 124
2228106 2228106 2022-02-18 Madison New York 36053 12586 124
2224855 2224855 2022-02-17 Madison New York 36053 12576 124
2221604 2221604 2022-02-16 Madison New York 36053 12545 124
2218353 2218353 2022-02-15 Madison New York 36053 12521 123
2215102 2215102 2022-02-14 Madison New York 36053 12509 123
2211851 2211851 2022-02-13 Madison New York 36053 12495 123
2208598 2208598 2022-02-12 Madison New York 36053 12485 123
2205345 2205345 2022-02-11 Madison New York 36053 12448 123
2202092 2202092 2022-02-10 Madison New York 36053 12423 123
2198838 2198838 2022-02-09 Madison New York 36053 12381 123
2195584 2195584 2022-02-08 Madison New York 36053 12344 123
2192330 2192330 2022-02-07 Madison New York 36053 12316 122
2189076 2189076 2022-02-06 Madison New York 36053 12300 122
2185823 2185823 2022-02-05 Madison New York 36053 12280 122
2182571 2182571 2022-02-04 Madison New York 36053 12233 121
2179319 2179319 2022-02-03 Madison New York 36053 12184 121

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