ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Brown" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
389065 | 389065 | 2020-07-31 | Brown | Wisconsin | 55009 | 3919 | 51 |
385848 | 385848 | 2020-07-30 | Brown | Wisconsin | 55009 | 3896 | 50 |
382630 | 382630 | 2020-07-29 | Brown | Wisconsin | 55009 | 3855 | 50 |
379413 | 379413 | 2020-07-28 | Brown | Wisconsin | 55009 | 3822 | 50 |
376197 | 376197 | 2020-07-27 | Brown | Wisconsin | 55009 | 3768 | 50 |
372983 | 372983 | 2020-07-26 | Brown | Wisconsin | 55009 | 3766 | 50 |
369771 | 369771 | 2020-07-25 | Brown | Wisconsin | 55009 | 3735 | 50 |
366561 | 366561 | 2020-07-24 | Brown | Wisconsin | 55009 | 3688 | 49 |
363354 | 363354 | 2020-07-23 | Brown | Wisconsin | 55009 | 3667 | 49 |
360148 | 360148 | 2020-07-22 | Brown | Wisconsin | 55009 | 3629 | 47 |
356943 | 356943 | 2020-07-21 | Brown | Wisconsin | 55009 | 3596 | 46 |
353740 | 353740 | 2020-07-20 | Brown | Wisconsin | 55009 | 3510 | 46 |
350538 | 350538 | 2020-07-19 | Brown | Wisconsin | 55009 | 3507 | 46 |
347337 | 347337 | 2020-07-18 | Brown | Wisconsin | 55009 | 3462 | 46 |
344137 | 344137 | 2020-07-17 | Brown | Wisconsin | 55009 | 3407 | 45 |
340938 | 340938 | 2020-07-16 | Brown | Wisconsin | 55009 | 3393 | 44 |
337742 | 337742 | 2020-07-15 | Brown | Wisconsin | 55009 | 3348 | 44 |
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 |
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);