ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 55015 and state = "Wisconsin" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
5143 | 5143 | 2020-03-19 | Calumet | Wisconsin | 55015 | 1 | 0 |
6049 | 6049 | 2020-03-20 | Calumet | Wisconsin | 55015 | 1 | 0 |
7082 | 7082 | 2020-03-21 | Calumet | Wisconsin | 55015 | 1 | 0 |
8220 | 8220 | 2020-03-22 | Calumet | Wisconsin | 55015 | 1 | 0 |
9445 | 9445 | 2020-03-23 | Calumet | Wisconsin | 55015 | 1 | 0 |
10799 | 10799 | 2020-03-24 | Calumet | Wisconsin | 55015 | 1 | 0 |
12326 | 12326 | 2020-03-25 | Calumet | Wisconsin | 55015 | 1 | 0 |
13979 | 13979 | 2020-03-26 | Calumet | Wisconsin | 55015 | 1 | 0 |
15751 | 15751 | 2020-03-27 | Calumet | Wisconsin | 55015 | 1 | 0 |
17631 | 17631 | 2020-03-28 | Calumet | Wisconsin | 55015 | 1 | 0 |
19600 | 19600 | 2020-03-29 | Calumet | Wisconsin | 55015 | 1 | 0 |
21669 | 21669 | 2020-03-30 | Calumet | Wisconsin | 55015 | 1 | 0 |
23821 | 23821 | 2020-03-31 | Calumet | Wisconsin | 55015 | 1 | 0 |
26040 | 26040 | 2020-04-01 | Calumet | Wisconsin | 55015 | 2 | 0 |
28333 | 28333 | 2020-04-02 | Calumet | Wisconsin | 55015 | 3 | 0 |
30688 | 30688 | 2020-04-03 | Calumet | Wisconsin | 55015 | 3 | 0 |
33089 | 33089 | 2020-04-04 | Calumet | Wisconsin | 55015 | 3 | 0 |
35527 | 35527 | 2020-04-05 | Calumet | Wisconsin | 55015 | 4 | 0 |
38013 | 38013 | 2020-04-06 | Calumet | Wisconsin | 55015 | 4 | 0 |
40554 | 40554 | 2020-04-07 | Calumet | Wisconsin | 55015 | 4 | 0 |
43126 | 43126 | 2020-04-08 | Calumet | Wisconsin | 55015 | 4 | 0 |
45723 | 45723 | 2020-04-09 | Calumet | Wisconsin | 55015 | 4 | 0 |
48351 | 48351 | 2020-04-10 | Calumet | Wisconsin | 55015 | 4 | 0 |
51011 | 51011 | 2020-04-11 | Calumet | Wisconsin | 55015 | 4 | 0 |
53688 | 53688 | 2020-04-12 | Calumet | Wisconsin | 55015 | 4 | 0 |
56378 | 56378 | 2020-04-13 | Calumet | Wisconsin | 55015 | 5 | 0 |
59085 | 59085 | 2020-04-14 | Calumet | Wisconsin | 55015 | 5 | 0 |
61804 | 61804 | 2020-04-15 | Calumet | Wisconsin | 55015 | 5 | 0 |
64537 | 64537 | 2020-04-16 | Calumet | Wisconsin | 55015 | 5 | 0 |
67285 | 67285 | 2020-04-17 | Calumet | Wisconsin | 55015 | 5 | 0 |
70047 | 70047 | 2020-04-18 | Calumet | Wisconsin | 55015 | 5 | 0 |
72816 | 72816 | 2020-04-19 | Calumet | Wisconsin | 55015 | 6 | 0 |
75592 | 75592 | 2020-04-20 | Calumet | Wisconsin | 55015 | 6 | 0 |
78375 | 78375 | 2020-04-21 | Calumet | Wisconsin | 55015 | 6 | 0 |
81168 | 81168 | 2020-04-22 | Calumet | Wisconsin | 55015 | 6 | 0 |
83969 | 83969 | 2020-04-23 | Calumet | Wisconsin | 55015 | 6 | 0 |
86776 | 86776 | 2020-04-24 | Calumet | Wisconsin | 55015 | 7 | 0 |
89592 | 89592 | 2020-04-25 | Calumet | Wisconsin | 55015 | 7 | 0 |
92410 | 92410 | 2020-04-26 | Calumet | Wisconsin | 55015 | 7 | 0 |
95240 | 95240 | 2020-04-27 | Calumet | Wisconsin | 55015 | 9 | 0 |
98085 | 98085 | 2020-04-28 | Calumet | Wisconsin | 55015 | 10 | 0 |
100935 | 100935 | 2020-04-29 | Calumet | Wisconsin | 55015 | 12 | 0 |
103790 | 103790 | 2020-04-30 | Calumet | Wisconsin | 55015 | 13 | 0 |
106654 | 106654 | 2020-05-01 | Calumet | Wisconsin | 55015 | 14 | 0 |
109523 | 109523 | 2020-05-02 | Calumet | Wisconsin | 55015 | 16 | 0 |
112398 | 112398 | 2020-05-03 | Calumet | Wisconsin | 55015 | 18 | 0 |
115281 | 115281 | 2020-05-04 | Calumet | Wisconsin | 55015 | 19 | 0 |
118240 | 118240 | 2020-05-05 | Calumet | Wisconsin | 55015 | 20 | 0 |
121205 | 121205 | 2020-05-06 | Calumet | Wisconsin | 55015 | 20 | 0 |
124185 | 124185 | 2020-05-07 | Calumet | Wisconsin | 55015 | 22 | 0 |
127170 | 127170 | 2020-05-08 | Calumet | Wisconsin | 55015 | 34 | 0 |
130160 | 130160 | 2020-05-09 | Calumet | Wisconsin | 55015 | 35 | 0 |
133150 | 133150 | 2020-05-10 | Calumet | Wisconsin | 55015 | 40 | 1 |
136140 | 136140 | 2020-05-11 | Calumet | Wisconsin | 55015 | 41 | 1 |
139131 | 139131 | 2020-05-12 | Calumet | Wisconsin | 55015 | 43 | 1 |
142127 | 142127 | 2020-05-13 | Calumet | Wisconsin | 55015 | 44 | 1 |
145125 | 145125 | 2020-05-14 | Calumet | Wisconsin | 55015 | 46 | 1 |
148128 | 148128 | 2020-05-15 | Calumet | Wisconsin | 55015 | 55 | 1 |
151137 | 151137 | 2020-05-16 | Calumet | Wisconsin | 55015 | 56 | 1 |
154149 | 154149 | 2020-05-17 | Calumet | Wisconsin | 55015 | 57 | 1 |
157165 | 157165 | 2020-05-18 | Calumet | Wisconsin | 55015 | 58 | 1 |
160189 | 160189 | 2020-05-19 | Calumet | Wisconsin | 55015 | 58 | 1 |
163217 | 163217 | 2020-05-20 | Calumet | Wisconsin | 55015 | 60 | 1 |
166246 | 166246 | 2020-05-21 | Calumet | Wisconsin | 55015 | 61 | 1 |
169282 | 169282 | 2020-05-22 | Calumet | Wisconsin | 55015 | 67 | 1 |
172323 | 172323 | 2020-05-23 | Calumet | Wisconsin | 55015 | 69 | 1 |
175366 | 175366 | 2020-05-24 | Calumet | Wisconsin | 55015 | 69 | 1 |
178411 | 178411 | 2020-05-25 | Calumet | Wisconsin | 55015 | 70 | 1 |
181455 | 181455 | 2020-05-26 | Calumet | Wisconsin | 55015 | 73 | 1 |
184506 | 184506 | 2020-05-27 | Calumet | Wisconsin | 55015 | 74 | 1 |
187563 | 187563 | 2020-05-28 | Calumet | Wisconsin | 55015 | 74 | 1 |
190627 | 190627 | 2020-05-29 | Calumet | Wisconsin | 55015 | 75 | 1 |
193693 | 193693 | 2020-05-30 | Calumet | Wisconsin | 55015 | 76 | 1 |
196763 | 196763 | 2020-05-31 | Calumet | Wisconsin | 55015 | 76 | 1 |
199836 | 199836 | 2020-06-01 | Calumet | Wisconsin | 55015 | 77 | 1 |
202912 | 202912 | 2020-06-02 | Calumet | Wisconsin | 55015 | 78 | 1 |
205991 | 205991 | 2020-06-03 | Calumet | Wisconsin | 55015 | 79 | 1 |
209073 | 209073 | 2020-06-04 | Calumet | Wisconsin | 55015 | 79 | 1 |
212158 | 212158 | 2020-06-05 | Calumet | Wisconsin | 55015 | 79 | 1 |
215245 | 215245 | 2020-06-06 | Calumet | Wisconsin | 55015 | 79 | 1 |
218335 | 218335 | 2020-06-07 | Calumet | Wisconsin | 55015 | 80 | 1 |
221427 | 221427 | 2020-06-08 | Calumet | Wisconsin | 55015 | 81 | 1 |
224523 | 224523 | 2020-06-09 | Calumet | Wisconsin | 55015 | 81 | 1 |
227623 | 227623 | 2020-06-10 | Calumet | Wisconsin | 55015 | 81 | 2 |
230727 | 230727 | 2020-06-11 | Calumet | Wisconsin | 55015 | 83 | 2 |
233832 | 233832 | 2020-06-12 | Calumet | Wisconsin | 55015 | 84 | 2 |
236939 | 236939 | 2020-06-13 | Calumet | Wisconsin | 55015 | 86 | 2 |
240047 | 240047 | 2020-06-14 | Calumet | Wisconsin | 55015 | 86 | 2 |
243158 | 243158 | 2020-06-15 | Calumet | Wisconsin | 55015 | 86 | 2 |
246271 | 246271 | 2020-06-16 | Calumet | Wisconsin | 55015 | 87 | 2 |
249383 | 249383 | 2020-06-17 | Calumet | Wisconsin | 55015 | 88 | 2 |
252498 | 252498 | 2020-06-18 | Calumet | Wisconsin | 55015 | 90 | 2 |
255617 | 255617 | 2020-06-19 | Calumet | Wisconsin | 55015 | 90 | 2 |
258744 | 258744 | 2020-06-20 | Calumet | Wisconsin | 55015 | 90 | 2 |
261871 | 261871 | 2020-06-21 | Calumet | Wisconsin | 55015 | 92 | 2 |
265000 | 265000 | 2020-06-22 | Calumet | Wisconsin | 55015 | 92 | 2 |
268129 | 268129 | 2020-06-23 | Calumet | Wisconsin | 55015 | 92 | 2 |
271263 | 271263 | 2020-06-24 | Calumet | Wisconsin | 55015 | 92 | 2 |
274403 | 274403 | 2020-06-25 | Calumet | Wisconsin | 55015 | 94 | 2 |
277551 | 277551 | 2020-06-26 | Calumet | Wisconsin | 55015 | 96 | 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);