ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 55009 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
334547 | 334547 | 2020-07-14 | Brown | Wisconsin | 55009 | 3305 | 44 |
331354 | 331354 | 2020-07-13 | Brown | Wisconsin | 55009 | 3229 | 44 |
328168 | 328168 | 2020-07-12 | Brown | Wisconsin | 55009 | 3228 | 44 |
324982 | 324982 | 2020-07-11 | Brown | Wisconsin | 55009 | 3197 | 44 |
321801 | 321801 | 2020-07-10 | Brown | Wisconsin | 55009 | 3144 | 44 |
318622 | 318622 | 2020-07-09 | Brown | Wisconsin | 55009 | 3123 | 43 |
315449 | 315449 | 2020-07-08 | Brown | Wisconsin | 55009 | 3087 | 42 |
312274 | 312274 | 2020-07-07 | Brown | Wisconsin | 55009 | 3072 | 42 |
309105 | 309105 | 2020-07-06 | Brown | Wisconsin | 55009 | 3049 | 42 |
305936 | 305936 | 2020-07-05 | Brown | Wisconsin | 55009 | 3018 | 42 |
302772 | 302772 | 2020-07-04 | Brown | Wisconsin | 55009 | 2997 | 42 |
299608 | 299608 | 2020-07-03 | Brown | Wisconsin | 55009 | 2968 | 42 |
296446 | 296446 | 2020-07-02 | Brown | Wisconsin | 55009 | 2937 | 42 |
293291 | 293291 | 2020-07-01 | Brown | Wisconsin | 55009 | 2916 | 42 |
290138 | 290138 | 2020-06-30 | Brown | Wisconsin | 55009 | 2873 | 42 |
286988 | 286988 | 2020-06-29 | Brown | Wisconsin | 55009 | 2825 | 42 |
283842 | 283842 | 2020-06-28 | Brown | Wisconsin | 55009 | 2826 | 42 |
280696 | 280696 | 2020-06-27 | Brown | Wisconsin | 55009 | 2777 | 42 |
277548 | 277548 | 2020-06-26 | Brown | Wisconsin | 55009 | 2738 | 41 |
274400 | 274400 | 2020-06-25 | Brown | Wisconsin | 55009 | 2698 | 42 |
271260 | 271260 | 2020-06-24 | Brown | Wisconsin | 55009 | 2661 | 40 |
268126 | 268126 | 2020-06-23 | Brown | Wisconsin | 55009 | 2620 | 39 |
264997 | 264997 | 2020-06-22 | Brown | Wisconsin | 55009 | 2581 | 39 |
261868 | 261868 | 2020-06-21 | Brown | Wisconsin | 55009 | 2580 | 39 |
258741 | 258741 | 2020-06-20 | Brown | Wisconsin | 55009 | 2572 | 39 |
255614 | 255614 | 2020-06-19 | Brown | Wisconsin | 55009 | 2538 | 39 |
252495 | 252495 | 2020-06-18 | Brown | Wisconsin | 55009 | 2520 | 39 |
249380 | 249380 | 2020-06-17 | Brown | Wisconsin | 55009 | 2507 | 39 |
246268 | 246268 | 2020-06-16 | Brown | Wisconsin | 55009 | 2492 | 39 |
243155 | 243155 | 2020-06-15 | Brown | Wisconsin | 55009 | 2469 | 38 |
240044 | 240044 | 2020-06-14 | Brown | Wisconsin | 55009 | 2469 | 38 |
236936 | 236936 | 2020-06-13 | Brown | Wisconsin | 55009 | 2458 | 38 |
233829 | 233829 | 2020-06-12 | Brown | Wisconsin | 55009 | 2442 | 38 |
230724 | 230724 | 2020-06-11 | Brown | Wisconsin | 55009 | 2421 | 38 |
227620 | 227620 | 2020-06-10 | Brown | Wisconsin | 55009 | 2405 | 38 |
224520 | 224520 | 2020-06-09 | Brown | Wisconsin | 55009 | 2399 | 38 |
221424 | 221424 | 2020-06-08 | Brown | Wisconsin | 55009 | 2377 | 38 |
218332 | 218332 | 2020-06-07 | Brown | Wisconsin | 55009 | 2377 | 38 |
215242 | 215242 | 2020-06-06 | Brown | Wisconsin | 55009 | 2374 | 38 |
212155 | 212155 | 2020-06-05 | Brown | Wisconsin | 55009 | 2369 | 38 |
209070 | 209070 | 2020-06-04 | Brown | Wisconsin | 55009 | 2361 | 38 |
205988 | 205988 | 2020-06-03 | Brown | Wisconsin | 55009 | 2350 | 37 |
202909 | 202909 | 2020-06-02 | Brown | Wisconsin | 55009 | 2334 | 37 |
199833 | 199833 | 2020-06-01 | Brown | Wisconsin | 55009 | 2320 | 37 |
196760 | 196760 | 2020-05-31 | Brown | Wisconsin | 55009 | 2319 | 37 |
193690 | 193690 | 2020-05-30 | Brown | Wisconsin | 55009 | 2318 | 37 |
190624 | 190624 | 2020-05-29 | Brown | Wisconsin | 55009 | 2308 | 35 |
187560 | 187560 | 2020-05-28 | Brown | Wisconsin | 55009 | 2300 | 34 |
184503 | 184503 | 2020-05-27 | Brown | Wisconsin | 55009 | 2285 | 33 |
181452 | 181452 | 2020-05-26 | Brown | Wisconsin | 55009 | 2249 | 32 |
178408 | 178408 | 2020-05-25 | Brown | Wisconsin | 55009 | 2249 | 32 |
175363 | 175363 | 2020-05-24 | Brown | Wisconsin | 55009 | 2243 | 32 |
172320 | 172320 | 2020-05-23 | Brown | Wisconsin | 55009 | 2238 | 32 |
169279 | 169279 | 2020-05-22 | Brown | Wisconsin | 55009 | 2204 | 31 |
166243 | 166243 | 2020-05-21 | Brown | Wisconsin | 55009 | 2177 | 29 |
163214 | 163214 | 2020-05-20 | Brown | Wisconsin | 55009 | 2135 | 29 |
160186 | 160186 | 2020-05-19 | Brown | Wisconsin | 55009 | 2118 | 26 |
157162 | 157162 | 2020-05-18 | Brown | Wisconsin | 55009 | 2102 | 23 |
154146 | 154146 | 2020-05-17 | Brown | Wisconsin | 55009 | 2096 | 22 |
151134 | 151134 | 2020-05-16 | Brown | Wisconsin | 55009 | 2070 | 22 |
148125 | 148125 | 2020-05-15 | Brown | Wisconsin | 55009 | 2034 | 21 |
145122 | 145122 | 2020-05-14 | Brown | Wisconsin | 55009 | 1999 | 21 |
142125 | 142125 | 2020-05-13 | Brown | Wisconsin | 55009 | 1982 | 20 |
139129 | 139129 | 2020-05-12 | Brown | Wisconsin | 55009 | 1958 | 20 |
136138 | 136138 | 2020-05-11 | Brown | Wisconsin | 55009 | 1924 | 18 |
133148 | 133148 | 2020-05-10 | Brown | Wisconsin | 55009 | 1897 | 18 |
130158 | 130158 | 2020-05-09 | Brown | Wisconsin | 55009 | 1834 | 18 |
127168 | 127168 | 2020-05-08 | Brown | Wisconsin | 55009 | 1777 | 13 |
124183 | 124183 | 2020-05-07 | Brown | Wisconsin | 55009 | 1706 | 12 |
121203 | 121203 | 2020-05-06 | Brown | Wisconsin | 55009 | 1653 | 11 |
118238 | 118238 | 2020-05-05 | Brown | Wisconsin | 55009 | 1545 | 9 |
115279 | 115279 | 2020-05-04 | Brown | Wisconsin | 55009 | 1448 | 6 |
112396 | 112396 | 2020-05-03 | Brown | Wisconsin | 55009 | 1358 | 6 |
109521 | 109521 | 2020-05-02 | Brown | Wisconsin | 55009 | 1272 | 6 |
106652 | 106652 | 2020-05-01 | Brown | Wisconsin | 55009 | 1175 | 5 |
103788 | 103788 | 2020-04-30 | Brown | Wisconsin | 55009 | 1057 | 3 |
100933 | 100933 | 2020-04-29 | Brown | Wisconsin | 55009 | 971 | 3 |
98083 | 98083 | 2020-04-28 | Brown | Wisconsin | 55009 | 920 | 3 |
95238 | 95238 | 2020-04-27 | Brown | Wisconsin | 55009 | 853 | 2 |
92408 | 92408 | 2020-04-26 | Brown | Wisconsin | 55009 | 776 | 2 |
89590 | 89590 | 2020-04-25 | Brown | Wisconsin | 55009 | 720 | 2 |
86774 | 86774 | 2020-04-24 | Brown | Wisconsin | 55009 | 605 | 2 |
83967 | 83967 | 2020-04-23 | Brown | Wisconsin | 55009 | 455 | 2 |
81166 | 81166 | 2020-04-22 | Brown | Wisconsin | 55009 | 402 | 2 |
78373 | 78373 | 2020-04-21 | Brown | Wisconsin | 55009 | 314 | 2 |
75590 | 75590 | 2020-04-20 | Brown | Wisconsin | 55009 | 285 | 1 |
72814 | 72814 | 2020-04-19 | Brown | Wisconsin | 55009 | 215 | 1 |
70045 | 70045 | 2020-04-18 | Brown | Wisconsin | 55009 | 204 | 1 |
67283 | 67283 | 2020-04-17 | Brown | Wisconsin | 55009 | 180 | 1 |
64535 | 64535 | 2020-04-16 | Brown | Wisconsin | 55009 | 139 | 1 |
61802 | 61802 | 2020-04-15 | Brown | Wisconsin | 55009 | 114 | 1 |
59083 | 59083 | 2020-04-14 | Brown | Wisconsin | 55009 | 97 | 1 |
56376 | 56376 | 2020-04-13 | Brown | Wisconsin | 55009 | 77 | 1 |
53686 | 53686 | 2020-04-12 | Brown | Wisconsin | 55009 | 68 | 1 |
51009 | 51009 | 2020-04-11 | Brown | Wisconsin | 55009 | 60 | 1 |
48349 | 48349 | 2020-04-10 | Brown | Wisconsin | 55009 | 55 | 1 |
45721 | 45721 | 2020-04-09 | Brown | Wisconsin | 55009 | 50 | 1 |
43124 | 43124 | 2020-04-08 | Brown | Wisconsin | 55009 | 47 | 0 |
40552 | 40552 | 2020-04-07 | Brown | Wisconsin | 55009 | 41 | 0 |
38011 | 38011 | 2020-04-06 | Brown | Wisconsin | 55009 | 39 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
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);