ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Freeborn" and state = "Minnesota" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
24886 | 24886 | 2020-04-01 | Freeborn | Minnesota | 27047 | 2 | 0 |
27139 | 27139 | 2020-04-02 | Freeborn | Minnesota | 27047 | 5 | 0 |
29458 | 29458 | 2020-04-03 | Freeborn | Minnesota | 27047 | 7 | 0 |
31836 | 31836 | 2020-04-04 | Freeborn | Minnesota | 27047 | 10 | 0 |
34261 | 34261 | 2020-04-05 | Freeborn | Minnesota | 27047 | 10 | 0 |
36721 | 36721 | 2020-04-06 | Freeborn | Minnesota | 27047 | 11 | 0 |
39230 | 39230 | 2020-04-07 | Freeborn | Minnesota | 27047 | 14 | 0 |
41783 | 41783 | 2020-04-08 | Freeborn | Minnesota | 27047 | 17 | 0 |
44359 | 44359 | 2020-04-09 | Freeborn | Minnesota | 27047 | 20 | 0 |
46968 | 46968 | 2020-04-10 | Freeborn | Minnesota | 27047 | 21 | 0 |
49613 | 49613 | 2020-04-11 | Freeborn | Minnesota | 27047 | 22 | 0 |
52283 | 52283 | 2020-04-12 | Freeborn | Minnesota | 27047 | 24 | 0 |
54965 | 54965 | 2020-04-13 | Freeborn | Minnesota | 27047 | 24 | 0 |
57663 | 57663 | 2020-04-14 | Freeborn | Minnesota | 27047 | 27 | 0 |
60373 | 60373 | 2020-04-15 | Freeborn | Minnesota | 27047 | 27 | 0 |
65834 | 65834 | 2020-04-17 | Freeborn | Minnesota | 27047 | 28 | 0 |
63095 | 63095 | 2020-04-16 | Freeborn | Minnesota | 27047 | 29 | 0 |
68585 | 68585 | 2020-04-18 | Freeborn | Minnesota | 27047 | 31 | 0 |
74122 | 74122 | 2020-04-20 | Freeborn | Minnesota | 27047 | 33 | 0 |
76902 | 76902 | 2020-04-21 | Freeborn | Minnesota | 27047 | 33 | 0 |
79687 | 79687 | 2020-04-22 | Freeborn | Minnesota | 27047 | 33 | 0 |
82483 | 82483 | 2020-04-23 | Freeborn | Minnesota | 27047 | 33 | 0 |
85287 | 85287 | 2020-04-24 | Freeborn | Minnesota | 27047 | 33 | 0 |
88097 | 88097 | 2020-04-25 | Freeborn | Minnesota | 27047 | 33 | 0 |
90913 | 90913 | 2020-04-26 | Freeborn | Minnesota | 27047 | 33 | 0 |
93734 | 93734 | 2020-04-27 | Freeborn | Minnesota | 27047 | 33 | 0 |
71349 | 71349 | 2020-04-19 | Freeborn | Minnesota | 27047 | 34 | 0 |
96569 | 96569 | 2020-04-28 | Freeborn | Minnesota | 27047 | 34 | 0 |
99415 | 99415 | 2020-04-29 | Freeborn | Minnesota | 27047 | 34 | 0 |
102267 | 102267 | 2020-04-30 | Freeborn | Minnesota | 27047 | 34 | 0 |
105127 | 105127 | 2020-05-01 | Freeborn | Minnesota | 27047 | 35 | 0 |
107991 | 107991 | 2020-05-02 | Freeborn | Minnesota | 27047 | 35 | 0 |
110862 | 110862 | 2020-05-03 | Freeborn | Minnesota | 27047 | 35 | 0 |
113741 | 113741 | 2020-05-04 | Freeborn | Minnesota | 27047 | 36 | 0 |
116622 | 116622 | 2020-05-05 | Freeborn | Minnesota | 27047 | 37 | 0 |
119582 | 119582 | 2020-05-06 | Freeborn | Minnesota | 27047 | 38 | 0 |
122555 | 122555 | 2020-05-07 | Freeborn | Minnesota | 27047 | 39 | 0 |
125537 | 125537 | 2020-05-08 | Freeborn | Minnesota | 27047 | 41 | 0 |
128524 | 128524 | 2020-05-09 | Freeborn | Minnesota | 27047 | 43 | 0 |
131514 | 131514 | 2020-05-10 | Freeborn | Minnesota | 27047 | 44 | 0 |
134505 | 134505 | 2020-05-11 | Freeborn | Minnesota | 27047 | 46 | 0 |
137495 | 137495 | 2020-05-12 | Freeborn | Minnesota | 27047 | 46 | 0 |
140489 | 140489 | 2020-05-13 | Freeborn | Minnesota | 27047 | 46 | 0 |
143484 | 143484 | 2020-05-14 | Freeborn | Minnesota | 27047 | 52 | 0 |
146484 | 146484 | 2020-05-15 | Freeborn | Minnesota | 27047 | 55 | 0 |
149489 | 149489 | 2020-05-16 | Freeborn | Minnesota | 27047 | 61 | 0 |
152500 | 152500 | 2020-05-17 | Freeborn | Minnesota | 27047 | 61 | 0 |
155514 | 155514 | 2020-05-18 | Freeborn | Minnesota | 27047 | 61 | 0 |
158532 | 158532 | 2020-05-19 | Freeborn | Minnesota | 27047 | 63 | 0 |
161558 | 161558 | 2020-05-20 | Freeborn | Minnesota | 27047 | 67 | 0 |
164587 | 164587 | 2020-05-21 | Freeborn | Minnesota | 27047 | 73 | 0 |
167623 | 167623 | 2020-05-22 | Freeborn | Minnesota | 27047 | 76 | 0 |
170660 | 170660 | 2020-05-23 | Freeborn | Minnesota | 27047 | 82 | 0 |
173702 | 173702 | 2020-05-24 | Freeborn | Minnesota | 27047 | 84 | 0 |
176745 | 176745 | 2020-05-25 | Freeborn | Minnesota | 27047 | 93 | 0 |
179789 | 179789 | 2020-05-26 | Freeborn | Minnesota | 27047 | 97 | 0 |
182835 | 182835 | 2020-05-27 | Freeborn | Minnesota | 27047 | 97 | 0 |
185890 | 185890 | 2020-05-28 | Freeborn | Minnesota | 27047 | 102 | 0 |
188948 | 188948 | 2020-05-29 | Freeborn | Minnesota | 27047 | 108 | 0 |
192012 | 192012 | 2020-05-30 | Freeborn | Minnesota | 27047 | 115 | 0 |
195080 | 195080 | 2020-05-31 | Freeborn | Minnesota | 27047 | 117 | 0 |
198151 | 198151 | 2020-06-01 | Freeborn | Minnesota | 27047 | 125 | 0 |
201224 | 201224 | 2020-06-02 | Freeborn | Minnesota | 27047 | 130 | 0 |
204301 | 204301 | 2020-06-03 | Freeborn | Minnesota | 27047 | 130 | 0 |
207382 | 207382 | 2020-06-04 | Freeborn | Minnesota | 27047 | 142 | 0 |
210463 | 210463 | 2020-06-05 | Freeborn | Minnesota | 27047 | 159 | 0 |
213547 | 213547 | 2020-06-06 | Freeborn | Minnesota | 27047 | 170 | 0 |
216635 | 216635 | 2020-06-07 | Freeborn | Minnesota | 27047 | 177 | 0 |
219727 | 219727 | 2020-06-08 | Freeborn | Minnesota | 27047 | 185 | 0 |
222822 | 222822 | 2020-06-09 | Freeborn | Minnesota | 27047 | 188 | 0 |
225920 | 225920 | 2020-06-10 | Freeborn | Minnesota | 27047 | 197 | 0 |
229022 | 229022 | 2020-06-11 | Freeborn | Minnesota | 27047 | 200 | 0 |
232126 | 232126 | 2020-06-12 | Freeborn | Minnesota | 27047 | 217 | 0 |
235232 | 235232 | 2020-06-13 | Freeborn | Minnesota | 27047 | 218 | 0 |
241448 | 241448 | 2020-06-15 | Freeborn | Minnesota | 27047 | 220 | 0 |
238339 | 238339 | 2020-06-14 | Freeborn | Minnesota | 27047 | 221 | 0 |
244559 | 244559 | 2020-06-16 | Freeborn | Minnesota | 27047 | 222 | 0 |
247672 | 247672 | 2020-06-17 | Freeborn | Minnesota | 27047 | 235 | 0 |
250784 | 250784 | 2020-06-18 | Freeborn | Minnesota | 27047 | 240 | 0 |
253899 | 253899 | 2020-06-19 | Freeborn | Minnesota | 27047 | 243 | 0 |
257019 | 257019 | 2020-06-20 | Freeborn | Minnesota | 27047 | 245 | 0 |
260145 | 260145 | 2020-06-21 | Freeborn | Minnesota | 27047 | 251 | 0 |
263274 | 263274 | 2020-06-22 | Freeborn | Minnesota | 27047 | 258 | 0 |
266400 | 266400 | 2020-06-23 | Freeborn | Minnesota | 27047 | 259 | 0 |
269533 | 269533 | 2020-06-24 | Freeborn | Minnesota | 27047 | 259 | 0 |
272670 | 272670 | 2020-06-25 | Freeborn | Minnesota | 27047 | 262 | 0 |
275813 | 275813 | 2020-06-26 | Freeborn | Minnesota | 27047 | 265 | 0 |
278961 | 278961 | 2020-06-27 | Freeborn | Minnesota | 27047 | 271 | 0 |
282109 | 282109 | 2020-06-28 | Freeborn | Minnesota | 27047 | 280 | 0 |
288404 | 288404 | 2020-06-30 | Freeborn | Minnesota | 27047 | 281 | 0 |
285254 | 285254 | 2020-06-29 | Freeborn | Minnesota | 27047 | 282 | 0 |
291555 | 291555 | 2020-07-01 | Freeborn | Minnesota | 27047 | 286 | 0 |
294709 | 294709 | 2020-07-02 | Freeborn | Minnesota | 27047 | 289 | 0 |
297867 | 297867 | 2020-07-03 | Freeborn | Minnesota | 27047 | 290 | 0 |
301030 | 301030 | 2020-07-04 | Freeborn | Minnesota | 27047 | 290 | 0 |
304194 | 304194 | 2020-07-05 | Freeborn | Minnesota | 27047 | 292 | 0 |
307361 | 307361 | 2020-07-06 | Freeborn | Minnesota | 27047 | 292 | 0 |
310529 | 310529 | 2020-07-07 | Freeborn | Minnesota | 27047 | 297 | 0 |
313699 | 313699 | 2020-07-08 | Freeborn | Minnesota | 27047 | 298 | 0 |
316873 | 316873 | 2020-07-09 | Freeborn | Minnesota | 27047 | 302 | 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);