ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 27103 and state = "Minnesota" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3476 | 3476 | 2020-03-17 | Nicollet | Minnesota | 27103 | 1 | 0 |
4059 | 4059 | 2020-03-18 | Nicollet | Minnesota | 27103 | 2 | 0 |
4770 | 4770 | 2020-03-19 | Nicollet | Minnesota | 27103 | 2 | 0 |
5592 | 5592 | 2020-03-20 | Nicollet | Minnesota | 27103 | 2 | 0 |
6562 | 6562 | 2020-03-21 | Nicollet | Minnesota | 27103 | 2 | 0 |
7644 | 7644 | 2020-03-22 | Nicollet | Minnesota | 27103 | 3 | 0 |
8823 | 8823 | 2020-03-23 | Nicollet | Minnesota | 27103 | 3 | 0 |
10118 | 10118 | 2020-03-24 | Nicollet | Minnesota | 27103 | 3 | 0 |
11536 | 11536 | 2020-03-25 | Nicollet | Minnesota | 27103 | 3 | 0 |
13125 | 13125 | 2020-03-26 | Nicollet | Minnesota | 27103 | 3 | 0 |
14841 | 14841 | 2020-03-27 | Nicollet | Minnesota | 27103 | 3 | 0 |
16663 | 16663 | 2020-03-28 | Nicollet | Minnesota | 27103 | 3 | 0 |
18582 | 18582 | 2020-03-29 | Nicollet | Minnesota | 27103 | 3 | 0 |
20604 | 20604 | 2020-03-30 | Nicollet | Minnesota | 27103 | 3 | 0 |
22719 | 22719 | 2020-03-31 | Nicollet | Minnesota | 27103 | 3 | 0 |
24901 | 24901 | 2020-04-01 | Nicollet | Minnesota | 27103 | 3 | 0 |
27155 | 27155 | 2020-04-02 | Nicollet | Minnesota | 27103 | 3 | 0 |
29474 | 29474 | 2020-04-03 | Nicollet | Minnesota | 27103 | 3 | 0 |
31853 | 31853 | 2020-04-04 | Nicollet | Minnesota | 27103 | 4 | 0 |
34279 | 34279 | 2020-04-05 | Nicollet | Minnesota | 27103 | 4 | 0 |
36740 | 36740 | 2020-04-06 | Nicollet | Minnesota | 27103 | 4 | 0 |
39249 | 39249 | 2020-04-07 | Nicollet | Minnesota | 27103 | 4 | 0 |
41802 | 41802 | 2020-04-08 | Nicollet | Minnesota | 27103 | 5 | 0 |
44378 | 44378 | 2020-04-09 | Nicollet | Minnesota | 27103 | 5 | 0 |
46987 | 46987 | 2020-04-10 | Nicollet | Minnesota | 27103 | 6 | 0 |
49632 | 49632 | 2020-04-11 | Nicollet | Minnesota | 27103 | 6 | 1 |
52302 | 52302 | 2020-04-12 | Nicollet | Minnesota | 27103 | 6 | 1 |
54984 | 54984 | 2020-04-13 | Nicollet | Minnesota | 27103 | 6 | 1 |
57682 | 57682 | 2020-04-14 | Nicollet | Minnesota | 27103 | 7 | 1 |
60392 | 60392 | 2020-04-15 | Nicollet | Minnesota | 27103 | 7 | 1 |
63115 | 63115 | 2020-04-16 | Nicollet | Minnesota | 27103 | 7 | 1 |
65854 | 65854 | 2020-04-17 | Nicollet | Minnesota | 27103 | 7 | 2 |
68606 | 68606 | 2020-04-18 | Nicollet | Minnesota | 27103 | 7 | 2 |
71372 | 71372 | 2020-04-19 | Nicollet | Minnesota | 27103 | 7 | 2 |
74145 | 74145 | 2020-04-20 | Nicollet | Minnesota | 27103 | 7 | 2 |
76925 | 76925 | 2020-04-21 | Nicollet | Minnesota | 27103 | 7 | 2 |
79710 | 79710 | 2020-04-22 | Nicollet | Minnesota | 27103 | 8 | 2 |
82506 | 82506 | 2020-04-23 | Nicollet | Minnesota | 27103 | 8 | 2 |
85310 | 85310 | 2020-04-24 | Nicollet | Minnesota | 27103 | 8 | 2 |
88120 | 88120 | 2020-04-25 | Nicollet | Minnesota | 27103 | 9 | 2 |
90936 | 90936 | 2020-04-26 | Nicollet | Minnesota | 27103 | 9 | 2 |
93757 | 93757 | 2020-04-27 | Nicollet | Minnesota | 27103 | 9 | 2 |
96592 | 96592 | 2020-04-28 | Nicollet | Minnesota | 27103 | 9 | 2 |
99438 | 99438 | 2020-04-29 | Nicollet | Minnesota | 27103 | 9 | 2 |
102290 | 102290 | 2020-04-30 | Nicollet | Minnesota | 27103 | 11 | 2 |
105151 | 105151 | 2020-05-01 | Nicollet | Minnesota | 27103 | 13 | 2 |
108016 | 108016 | 2020-05-02 | Nicollet | Minnesota | 27103 | 15 | 2 |
110887 | 110887 | 2020-05-03 | Nicollet | Minnesota | 27103 | 15 | 2 |
113766 | 113766 | 2020-05-04 | Nicollet | Minnesota | 27103 | 16 | 2 |
116647 | 116647 | 2020-05-05 | Nicollet | Minnesota | 27103 | 16 | 2 |
119607 | 119607 | 2020-05-06 | Nicollet | Minnesota | 27103 | 17 | 2 |
122581 | 122581 | 2020-05-07 | Nicollet | Minnesota | 27103 | 18 | 2 |
125563 | 125563 | 2020-05-08 | Nicollet | Minnesota | 27103 | 18 | 2 |
128550 | 128550 | 2020-05-09 | Nicollet | Minnesota | 27103 | 21 | 2 |
131540 | 131540 | 2020-05-10 | Nicollet | Minnesota | 27103 | 21 | 2 |
134531 | 134531 | 2020-05-11 | Nicollet | Minnesota | 27103 | 21 | 2 |
137521 | 137521 | 2020-05-12 | Nicollet | Minnesota | 27103 | 22 | 2 |
140515 | 140515 | 2020-05-13 | Nicollet | Minnesota | 27103 | 22 | 2 |
143510 | 143510 | 2020-05-14 | Nicollet | Minnesota | 27103 | 23 | 2 |
146510 | 146510 | 2020-05-15 | Nicollet | Minnesota | 27103 | 28 | 2 |
149515 | 149515 | 2020-05-16 | Nicollet | Minnesota | 27103 | 33 | 2 |
152526 | 152526 | 2020-05-17 | Nicollet | Minnesota | 27103 | 37 | 3 |
155540 | 155540 | 2020-05-18 | Nicollet | Minnesota | 27103 | 39 | 3 |
158558 | 158558 | 2020-05-19 | Nicollet | Minnesota | 27103 | 43 | 3 |
161584 | 161584 | 2020-05-20 | Nicollet | Minnesota | 27103 | 44 | 3 |
164613 | 164613 | 2020-05-21 | Nicollet | Minnesota | 27103 | 51 | 3 |
167649 | 167649 | 2020-05-22 | Nicollet | Minnesota | 27103 | 63 | 3 |
170687 | 170687 | 2020-05-23 | Nicollet | Minnesota | 27103 | 64 | 3 |
173729 | 173729 | 2020-05-24 | Nicollet | Minnesota | 27103 | 68 | 3 |
176772 | 176772 | 2020-05-25 | Nicollet | Minnesota | 27103 | 69 | 5 |
179816 | 179816 | 2020-05-26 | Nicollet | Minnesota | 27103 | 71 | 6 |
182862 | 182862 | 2020-05-27 | Nicollet | Minnesota | 27103 | 74 | 7 |
185917 | 185917 | 2020-05-28 | Nicollet | Minnesota | 27103 | 82 | 7 |
188975 | 188975 | 2020-05-29 | Nicollet | Minnesota | 27103 | 83 | 9 |
192039 | 192039 | 2020-05-30 | Nicollet | Minnesota | 27103 | 86 | 10 |
195107 | 195107 | 2020-05-31 | Nicollet | Minnesota | 27103 | 87 | 10 |
198178 | 198178 | 2020-06-01 | Nicollet | Minnesota | 27103 | 88 | 10 |
201251 | 201251 | 2020-06-02 | Nicollet | Minnesota | 27103 | 88 | 10 |
204328 | 204328 | 2020-06-03 | Nicollet | Minnesota | 27103 | 88 | 10 |
207409 | 207409 | 2020-06-04 | Nicollet | Minnesota | 27103 | 88 | 11 |
210490 | 210490 | 2020-06-05 | Nicollet | Minnesota | 27103 | 88 | 11 |
213574 | 213574 | 2020-06-06 | Nicollet | Minnesota | 27103 | 89 | 11 |
216662 | 216662 | 2020-06-07 | Nicollet | Minnesota | 27103 | 89 | 11 |
219754 | 219754 | 2020-06-08 | Nicollet | Minnesota | 27103 | 90 | 11 |
222849 | 222849 | 2020-06-09 | Nicollet | Minnesota | 27103 | 91 | 11 |
225947 | 225947 | 2020-06-10 | Nicollet | Minnesota | 27103 | 93 | 11 |
229049 | 229049 | 2020-06-11 | Nicollet | Minnesota | 27103 | 93 | 11 |
232153 | 232153 | 2020-06-12 | Nicollet | Minnesota | 27103 | 95 | 11 |
235259 | 235259 | 2020-06-13 | Nicollet | Minnesota | 27103 | 95 | 11 |
238366 | 238366 | 2020-06-14 | Nicollet | Minnesota | 27103 | 95 | 11 |
241475 | 241475 | 2020-06-15 | Nicollet | Minnesota | 27103 | 95 | 11 |
244586 | 244586 | 2020-06-16 | Nicollet | Minnesota | 27103 | 95 | 11 |
247699 | 247699 | 2020-06-17 | Nicollet | Minnesota | 27103 | 95 | 11 |
250811 | 250811 | 2020-06-18 | Nicollet | Minnesota | 27103 | 98 | 12 |
253926 | 253926 | 2020-06-19 | Nicollet | Minnesota | 27103 | 105 | 12 |
257046 | 257046 | 2020-06-20 | Nicollet | Minnesota | 27103 | 107 | 12 |
260172 | 260172 | 2020-06-21 | Nicollet | Minnesota | 27103 | 108 | 12 |
263301 | 263301 | 2020-06-22 | Nicollet | Minnesota | 27103 | 109 | 12 |
266427 | 266427 | 2020-06-23 | Nicollet | Minnesota | 27103 | 109 | 12 |
269560 | 269560 | 2020-06-24 | Nicollet | Minnesota | 27103 | 112 | 12 |
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);