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

769 rows where county = "Florence" and state = "Wisconsin" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • Wisconsin · 769 ✖

fips 1

county 1

  • Florence · 769 ✖
Link rowid date ▲ county state fips cases deaths
2502756 2502756 2022-05-13 Florence Wisconsin 55037 1093 17
2499498 2499498 2022-05-12 Florence Wisconsin 55037 1091 17
2496240 2496240 2022-05-11 Florence Wisconsin 55037 1090 17
2492982 2492982 2022-05-10 Florence Wisconsin 55037 1090 17
2489724 2489724 2022-05-09 Florence Wisconsin 55037 1089 16
2486467 2486467 2022-05-08 Florence Wisconsin 55037 1088 16
2483209 2483209 2022-05-07 Florence Wisconsin 55037 1088 16
2479951 2479951 2022-05-06 Florence Wisconsin 55037 1088 16
2476693 2476693 2022-05-05 Florence Wisconsin 55037 1088 16
2473435 2473435 2022-05-04 Florence Wisconsin 55037 1086 16
2470178 2470178 2022-05-03 Florence Wisconsin 55037 1086 16
2466922 2466922 2022-05-02 Florence Wisconsin 55037 1086 16
2463667 2463667 2022-05-01 Florence Wisconsin 55037 1086 16
2460411 2460411 2022-04-30 Florence Wisconsin 55037 1086 16
2457155 2457155 2022-04-29 Florence Wisconsin 55037 1086 16
2453899 2453899 2022-04-28 Florence Wisconsin 55037 1086 16
2450643 2450643 2022-04-27 Florence Wisconsin 55037 1085 16
2447387 2447387 2022-04-26 Florence Wisconsin 55037 1084 16
2444131 2444131 2022-04-25 Florence Wisconsin 55037 1084 16
2440875 2440875 2022-04-24 Florence Wisconsin 55037 1083 16
2437619 2437619 2022-04-23 Florence Wisconsin 55037 1083 16
2434363 2434363 2022-04-22 Florence Wisconsin 55037 1083 16
2431107 2431107 2022-04-21 Florence Wisconsin 55037 1081 16
2427851 2427851 2022-04-20 Florence Wisconsin 55037 1081 16
2424595 2424595 2022-04-19 Florence Wisconsin 55037 1081 16
2421339 2421339 2022-04-18 Florence Wisconsin 55037 1081 16
2418083 2418083 2022-04-17 Florence Wisconsin 55037 1081 16
2414827 2414827 2022-04-16 Florence Wisconsin 55037 1081 16
2411571 2411571 2022-04-15 Florence Wisconsin 55037 1081 16
2408315 2408315 2022-04-14 Florence Wisconsin 55037 1081 16
2405059 2405059 2022-04-13 Florence Wisconsin 55037 1081 16
2401804 2401804 2022-04-12 Florence Wisconsin 55037 1082 16
2398549 2398549 2022-04-11 Florence Wisconsin 55037 1082 16
2395294 2395294 2022-04-10 Florence Wisconsin 55037 1082 16
2392038 2392038 2022-04-09 Florence Wisconsin 55037 1082 16
2388782 2388782 2022-04-08 Florence Wisconsin 55037 1082 16
2385527 2385527 2022-04-07 Florence Wisconsin 55037 1082 16
2382272 2382272 2022-04-06 Florence Wisconsin 55037 1083 16
2379017 2379017 2022-04-05 Florence Wisconsin 55037 1081 16
2375763 2375763 2022-04-04 Florence Wisconsin 55037 1081 16
2372511 2372511 2022-04-03 Florence Wisconsin 55037 1081 16
2369258 2369258 2022-04-02 Florence Wisconsin 55037 1081 16
2366005 2366005 2022-04-01 Florence Wisconsin 55037 1081 16
2362752 2362752 2022-03-31 Florence Wisconsin 55037 1081 16
2359498 2359498 2022-03-30 Florence Wisconsin 55037 1081 16
2356244 2356244 2022-03-29 Florence Wisconsin 55037 1079 16
2352991 2352991 2022-03-28 Florence Wisconsin 55037 1079 16
2349739 2349739 2022-03-27 Florence Wisconsin 55037 1078 16
2346486 2346486 2022-03-26 Florence Wisconsin 55037 1078 16
2343233 2343233 2022-03-25 Florence Wisconsin 55037 1078 16
2339980 2339980 2022-03-24 Florence Wisconsin 55037 1078 16
2336727 2336727 2022-03-23 Florence Wisconsin 55037 1078 16
2333473 2333473 2022-03-22 Florence Wisconsin 55037 1078 16
2330219 2330219 2022-03-21 Florence Wisconsin 55037 1077 16
2326967 2326967 2022-03-20 Florence Wisconsin 55037 1077 16
2323714 2323714 2022-03-19 Florence Wisconsin 55037 1077 16
2320460 2320460 2022-03-18 Florence Wisconsin 55037 1077 16
2317206 2317206 2022-03-17 Florence Wisconsin 55037 1076 16
2313953 2313953 2022-03-16 Florence Wisconsin 55037 1076 16
2310700 2310700 2022-03-15 Florence Wisconsin 55037 1076 16
2307447 2307447 2022-03-14 Florence Wisconsin 55037 1076 16
2304196 2304196 2022-03-13 Florence Wisconsin 55037 1077 16
2300944 2300944 2022-03-12 Florence Wisconsin 55037 1077 16
2297692 2297692 2022-03-11 Florence Wisconsin 55037 1077 16
2294440 2294440 2022-03-10 Florence Wisconsin 55037 1077 15
2291188 2291188 2022-03-09 Florence Wisconsin 55037 1076 15
2287936 2287936 2022-03-08 Florence Wisconsin 55037 1076 15
2284684 2284684 2022-03-07 Florence Wisconsin 55037 1075 15
2281432 2281432 2022-03-06 Florence Wisconsin 55037 1075 15
2278179 2278179 2022-03-05 Florence Wisconsin 55037 1075 15
2274926 2274926 2022-03-04 Florence Wisconsin 55037 1075 15
2271673 2271673 2022-03-03 Florence Wisconsin 55037 1075 15
2268421 2268421 2022-03-02 Florence Wisconsin 55037 1075 15
2265168 2265168 2022-03-01 Florence Wisconsin 55037 1074 15
2261918 2261918 2022-02-28 Florence Wisconsin 55037 1074 15
2258667 2258667 2022-02-27 Florence Wisconsin 55037 1073 15
2255416 2255416 2022-02-26 Florence Wisconsin 55037 1073 15
2252165 2252165 2022-02-25 Florence Wisconsin 55037 1073 15
2248914 2248914 2022-02-24 Florence Wisconsin 55037 1073 15
2245663 2245663 2022-02-23 Florence Wisconsin 55037 1072 15
2242412 2242412 2022-02-22 Florence Wisconsin 55037 1068 15
2239161 2239161 2022-02-21 Florence Wisconsin 55037 1068 15
2235910 2235910 2022-02-20 Florence Wisconsin 55037 1067 15
2232659 2232659 2022-02-19 Florence Wisconsin 55037 1067 15
2229408 2229408 2022-02-18 Florence Wisconsin 55037 1067 15
2226157 2226157 2022-02-17 Florence Wisconsin 55037 1066 15
2222906 2222906 2022-02-16 Florence Wisconsin 55037 1063 15
2219655 2219655 2022-02-15 Florence Wisconsin 55037 1062 15
2216405 2216405 2022-02-14 Florence Wisconsin 55037 1060 15
2213154 2213154 2022-02-13 Florence Wisconsin 55037 1057 15
2209901 2209901 2022-02-12 Florence Wisconsin 55037 1057 15
2206648 2206648 2022-02-11 Florence Wisconsin 55037 1057 15
2203395 2203395 2022-02-10 Florence Wisconsin 55037 1054 15
2200141 2200141 2022-02-09 Florence Wisconsin 55037 1043 15
2196887 2196887 2022-02-08 Florence Wisconsin 55037 1041 15
2193632 2193632 2022-02-07 Florence Wisconsin 55037 1036 15
2190379 2190379 2022-02-06 Florence Wisconsin 55037 1033 15
2187126 2187126 2022-02-05 Florence Wisconsin 55037 1033 15
2183873 2183873 2022-02-04 Florence Wisconsin 55037 1033 15
2180621 2180621 2022-02-03 Florence Wisconsin 55037 1029 15

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