ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Anoka" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387260 | 387260 | 2020-07-31 | Anoka | Minnesota | 27003 | 3245 | 112 |
384042 | 384042 | 2020-07-30 | Anoka | Minnesota | 27003 | 3190 | 112 |
380825 | 380825 | 2020-07-29 | Anoka | Minnesota | 27003 | 3130 | 112 |
377608 | 377608 | 2020-07-28 | Anoka | Minnesota | 27003 | 3083 | 112 |
374393 | 374393 | 2020-07-27 | Anoka | Minnesota | 27003 | 3050 | 112 |
371181 | 371181 | 2020-07-26 | Anoka | Minnesota | 27003 | 3010 | 111 |
367971 | 367971 | 2020-07-25 | Anoka | Minnesota | 27003 | 2950 | 111 |
364764 | 364764 | 2020-07-24 | Anoka | Minnesota | 27003 | 2903 | 111 |
361557 | 361557 | 2020-07-23 | Anoka | Minnesota | 27003 | 2848 | 111 |
358352 | 358352 | 2020-07-22 | Anoka | Minnesota | 27003 | 2790 | 110 |
355149 | 355149 | 2020-07-21 | Anoka | Minnesota | 27003 | 2752 | 110 |
351947 | 351947 | 2020-07-20 | Anoka | Minnesota | 27003 | 2678 | 110 |
348747 | 348747 | 2020-07-19 | Anoka | Minnesota | 27003 | 2667 | 110 |
345546 | 345546 | 2020-07-18 | Anoka | Minnesota | 27003 | 2604 | 109 |
342346 | 342346 | 2020-07-17 | Anoka | Minnesota | 27003 | 2572 | 109 |
339150 | 339150 | 2020-07-16 | Anoka | Minnesota | 27003 | 2534 | 108 |
335954 | 335954 | 2020-07-15 | Anoka | Minnesota | 27003 | 2510 | 115 |
332761 | 332761 | 2020-07-14 | Anoka | Minnesota | 27003 | 2477 | 114 |
329574 | 329574 | 2020-07-13 | Anoka | Minnesota | 27003 | 2458 | 111 |
326388 | 326388 | 2020-07-12 | Anoka | Minnesota | 27003 | 2422 | 111 |
323205 | 323205 | 2020-07-11 | Anoka | Minnesota | 27003 | 2393 | 111 |
320026 | 320026 | 2020-07-10 | Anoka | Minnesota | 27003 | 2360 | 111 |
316851 | 316851 | 2020-07-09 | Anoka | Minnesota | 27003 | 2328 | 111 |
313677 | 313677 | 2020-07-08 | Anoka | Minnesota | 27003 | 2293 | 110 |
310507 | 310507 | 2020-07-07 | Anoka | Minnesota | 27003 | 2266 | 109 |
307339 | 307339 | 2020-07-06 | Anoka | Minnesota | 27003 | 2241 | 109 |
304172 | 304172 | 2020-07-05 | Anoka | Minnesota | 27003 | 2200 | 109 |
301008 | 301008 | 2020-07-04 | Anoka | Minnesota | 27003 | 2180 | 107 |
297845 | 297845 | 2020-07-03 | Anoka | Minnesota | 27003 | 2180 | 107 |
294687 | 294687 | 2020-07-02 | Anoka | Minnesota | 27003 | 2155 | 107 |
291533 | 291533 | 2020-07-01 | Anoka | Minnesota | 27003 | 2124 | 107 |
288382 | 288382 | 2020-06-30 | Anoka | Minnesota | 27003 | 2097 | 107 |
285232 | 285232 | 2020-06-29 | Anoka | Minnesota | 27003 | 2076 | 107 |
282087 | 282087 | 2020-06-28 | Anoka | Minnesota | 27003 | 2053 | 106 |
278939 | 278939 | 2020-06-27 | Anoka | Minnesota | 27003 | 2020 | 105 |
275791 | 275791 | 2020-06-26 | Anoka | Minnesota | 27003 | 1990 | 103 |
272648 | 272648 | 2020-06-25 | Anoka | Minnesota | 27003 | 1961 | 103 |
269511 | 269511 | 2020-06-24 | Anoka | Minnesota | 27003 | 1940 | 103 |
266378 | 266378 | 2020-06-23 | Anoka | Minnesota | 27003 | 1919 | 103 |
263252 | 263252 | 2020-06-22 | Anoka | Minnesota | 27003 | 1910 | 103 |
260123 | 260123 | 2020-06-21 | Anoka | Minnesota | 27003 | 1894 | 102 |
256997 | 256997 | 2020-06-20 | Anoka | Minnesota | 27003 | 1867 | 99 |
253877 | 253877 | 2020-06-19 | Anoka | Minnesota | 27003 | 1836 | 96 |
250762 | 250762 | 2020-06-18 | Anoka | Minnesota | 27003 | 1810 | 94 |
247650 | 247650 | 2020-06-17 | Anoka | Minnesota | 27003 | 1786 | 91 |
244537 | 244537 | 2020-06-16 | Anoka | Minnesota | 27003 | 1770 | 90 |
241426 | 241426 | 2020-06-15 | Anoka | Minnesota | 27003 | 1760 | 90 |
238317 | 238317 | 2020-06-14 | Anoka | Minnesota | 27003 | 1742 | 88 |
235210 | 235210 | 2020-06-13 | Anoka | Minnesota | 27003 | 1716 | 88 |
232105 | 232105 | 2020-06-12 | Anoka | Minnesota | 27003 | 1691 | 88 |
229001 | 229001 | 2020-06-11 | Anoka | Minnesota | 27003 | 1674 | 88 |
225899 | 225899 | 2020-06-10 | Anoka | Minnesota | 27003 | 1654 | 87 |
222801 | 222801 | 2020-06-09 | Anoka | Minnesota | 27003 | 1627 | 85 |
219706 | 219706 | 2020-06-08 | Anoka | Minnesota | 27003 | 1616 | 84 |
216614 | 216614 | 2020-06-07 | Anoka | Minnesota | 27003 | 1585 | 82 |
213526 | 213526 | 2020-06-06 | Anoka | Minnesota | 27003 | 1555 | 81 |
210442 | 210442 | 2020-06-05 | Anoka | Minnesota | 27003 | 1527 | 79 |
207361 | 207361 | 2020-06-04 | Anoka | Minnesota | 27003 | 1488 | 78 |
204280 | 204280 | 2020-06-03 | Anoka | Minnesota | 27003 | 1470 | 73 |
201203 | 201203 | 2020-06-02 | Anoka | Minnesota | 27003 | 1441 | 71 |
198130 | 198130 | 2020-06-01 | Anoka | Minnesota | 27003 | 1429 | 70 |
195059 | 195059 | 2020-05-31 | Anoka | Minnesota | 27003 | 1399 | 70 |
191991 | 191991 | 2020-05-30 | Anoka | Minnesota | 27003 | 1363 | 70 |
188927 | 188927 | 2020-05-29 | Anoka | Minnesota | 27003 | 1324 | 67 |
185869 | 185869 | 2020-05-28 | Anoka | Minnesota | 27003 | 1289 | 63 |
182814 | 182814 | 2020-05-27 | Anoka | Minnesota | 27003 | 1262 | 59 |
179768 | 179768 | 2020-05-26 | Anoka | Minnesota | 27003 | 1241 | 56 |
176724 | 176724 | 2020-05-25 | Anoka | Minnesota | 27003 | 1210 | 56 |
173681 | 173681 | 2020-05-24 | Anoka | Minnesota | 27003 | 1164 | 55 |
170639 | 170639 | 2020-05-23 | Anoka | Minnesota | 27003 | 1092 | 55 |
167602 | 167602 | 2020-05-22 | Anoka | Minnesota | 27003 | 1044 | 53 |
164566 | 164566 | 2020-05-21 | Anoka | Minnesota | 27003 | 995 | 49 |
161537 | 161537 | 2020-05-20 | Anoka | Minnesota | 27003 | 955 | 45 |
158511 | 158511 | 2020-05-19 | Anoka | Minnesota | 27003 | 919 | 42 |
155493 | 155493 | 2020-05-18 | Anoka | Minnesota | 27003 | 869 | 42 |
152479 | 152479 | 2020-05-17 | Anoka | Minnesota | 27003 | 821 | 40 |
149468 | 149468 | 2020-05-16 | Anoka | Minnesota | 27003 | 770 | 40 |
146463 | 146463 | 2020-05-15 | Anoka | Minnesota | 27003 | 726 | 38 |
143463 | 143463 | 2020-05-14 | Anoka | Minnesota | 27003 | 678 | 35 |
140468 | 140468 | 2020-05-13 | Anoka | Minnesota | 27003 | 613 | 31 |
137474 | 137474 | 2020-05-12 | Anoka | Minnesota | 27003 | 613 | 31 |
134484 | 134484 | 2020-05-11 | Anoka | Minnesota | 27003 | 571 | 29 |
131493 | 131493 | 2020-05-10 | Anoka | Minnesota | 27003 | 549 | 29 |
128503 | 128503 | 2020-05-09 | Anoka | Minnesota | 27003 | 518 | 29 |
125516 | 125516 | 2020-05-08 | Anoka | Minnesota | 27003 | 477 | 27 |
122534 | 122534 | 2020-05-07 | Anoka | Minnesota | 27003 | 426 | 27 |
119561 | 119561 | 2020-05-06 | Anoka | Minnesota | 27003 | 382 | 24 |
116601 | 116601 | 2020-05-05 | Anoka | Minnesota | 27003 | 344 | 20 |
113720 | 113720 | 2020-05-04 | Anoka | Minnesota | 27003 | 299 | 17 |
110841 | 110841 | 2020-05-03 | Anoka | Minnesota | 27003 | 281 | 17 |
107970 | 107970 | 2020-05-02 | Anoka | Minnesota | 27003 | 260 | 14 |
105106 | 105106 | 2020-05-01 | Anoka | Minnesota | 27003 | 231 | 11 |
102246 | 102246 | 2020-04-30 | Anoka | Minnesota | 27003 | 212 | 10 |
99394 | 99394 | 2020-04-29 | Anoka | Minnesota | 27003 | 196 | 8 |
96548 | 96548 | 2020-04-28 | Anoka | Minnesota | 27003 | 186 | 8 |
93713 | 93713 | 2020-04-27 | Anoka | Minnesota | 27003 | 168 | 5 |
90892 | 90892 | 2020-04-26 | Anoka | Minnesota | 27003 | 165 | 5 |
88076 | 88076 | 2020-04-25 | Anoka | Minnesota | 27003 | 150 | 3 |
85266 | 85266 | 2020-04-24 | Anoka | Minnesota | 27003 | 142 | 3 |
82462 | 82462 | 2020-04-23 | Anoka | Minnesota | 27003 | 131 | 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);