ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Beltrami" and state = "Minnesota" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
14819 | 14819 | 2020-03-27 | Beltrami | Minnesota | 27007 | 1 | 0 |
16640 | 16640 | 2020-03-28 | Beltrami | Minnesota | 27007 | 2 | 0 |
18556 | 18556 | 2020-03-29 | Beltrami | Minnesota | 27007 | 2 | 0 |
20576 | 20576 | 2020-03-30 | Beltrami | Minnesota | 27007 | 3 | 0 |
22688 | 22688 | 2020-03-31 | Beltrami | Minnesota | 27007 | 4 | 0 |
24868 | 24868 | 2020-04-01 | Beltrami | Minnesota | 27007 | 4 | 0 |
27121 | 27121 | 2020-04-02 | Beltrami | Minnesota | 27007 | 4 | 0 |
29440 | 29440 | 2020-04-03 | Beltrami | Minnesota | 27007 | 4 | 0 |
31818 | 31818 | 2020-04-04 | Beltrami | Minnesota | 27007 | 5 | 0 |
34243 | 34243 | 2020-04-05 | Beltrami | Minnesota | 27007 | 6 | 0 |
36703 | 36703 | 2020-04-06 | Beltrami | Minnesota | 27007 | 6 | 0 |
39212 | 39212 | 2020-04-07 | Beltrami | Minnesota | 27007 | 6 | 0 |
41765 | 41765 | 2020-04-08 | Beltrami | Minnesota | 27007 | 6 | 0 |
44341 | 44341 | 2020-04-09 | Beltrami | Minnesota | 27007 | 5 | 0 |
46950 | 46950 | 2020-04-10 | Beltrami | Minnesota | 27007 | 5 | 0 |
49595 | 49595 | 2020-04-11 | Beltrami | Minnesota | 27007 | 5 | 0 |
52265 | 52265 | 2020-04-12 | Beltrami | Minnesota | 27007 | 5 | 0 |
54947 | 54947 | 2020-04-13 | Beltrami | Minnesota | 27007 | 5 | 0 |
57645 | 57645 | 2020-04-14 | Beltrami | Minnesota | 27007 | 5 | 0 |
60355 | 60355 | 2020-04-15 | Beltrami | Minnesota | 27007 | 5 | 0 |
63077 | 63077 | 2020-04-16 | Beltrami | Minnesota | 27007 | 5 | 0 |
65816 | 65816 | 2020-04-17 | Beltrami | Minnesota | 27007 | 5 | 0 |
68567 | 68567 | 2020-04-18 | Beltrami | Minnesota | 27007 | 5 | 0 |
71331 | 71331 | 2020-04-19 | Beltrami | Minnesota | 27007 | 5 | 0 |
74103 | 74103 | 2020-04-20 | Beltrami | Minnesota | 27007 | 5 | 0 |
76883 | 76883 | 2020-04-21 | Beltrami | Minnesota | 27007 | 5 | 0 |
79668 | 79668 | 2020-04-22 | Beltrami | Minnesota | 27007 | 6 | 0 |
82464 | 82464 | 2020-04-23 | Beltrami | Minnesota | 27007 | 6 | 0 |
85268 | 85268 | 2020-04-24 | Beltrami | Minnesota | 27007 | 6 | 0 |
88078 | 88078 | 2020-04-25 | Beltrami | Minnesota | 27007 | 6 | 0 |
90894 | 90894 | 2020-04-26 | Beltrami | Minnesota | 27007 | 6 | 0 |
93715 | 93715 | 2020-04-27 | Beltrami | Minnesota | 27007 | 6 | 0 |
96550 | 96550 | 2020-04-28 | Beltrami | Minnesota | 27007 | 6 | 0 |
99396 | 99396 | 2020-04-29 | Beltrami | Minnesota | 27007 | 6 | 0 |
102248 | 102248 | 2020-04-30 | Beltrami | Minnesota | 27007 | 6 | 0 |
105108 | 105108 | 2020-05-01 | Beltrami | Minnesota | 27007 | 6 | 0 |
107972 | 107972 | 2020-05-02 | Beltrami | Minnesota | 27007 | 6 | 0 |
110843 | 110843 | 2020-05-03 | Beltrami | Minnesota | 27007 | 6 | 0 |
113722 | 113722 | 2020-05-04 | Beltrami | Minnesota | 27007 | 6 | 0 |
116603 | 116603 | 2020-05-05 | Beltrami | Minnesota | 27007 | 6 | 0 |
119563 | 119563 | 2020-05-06 | Beltrami | Minnesota | 27007 | 6 | 0 |
122536 | 122536 | 2020-05-07 | Beltrami | Minnesota | 27007 | 6 | 0 |
125518 | 125518 | 2020-05-08 | Beltrami | Minnesota | 27007 | 6 | 0 |
128505 | 128505 | 2020-05-09 | Beltrami | Minnesota | 27007 | 6 | 0 |
131495 | 131495 | 2020-05-10 | Beltrami | Minnesota | 27007 | 6 | 0 |
134486 | 134486 | 2020-05-11 | Beltrami | Minnesota | 27007 | 6 | 0 |
137476 | 137476 | 2020-05-12 | Beltrami | Minnesota | 27007 | 6 | 0 |
140470 | 140470 | 2020-05-13 | Beltrami | Minnesota | 27007 | 6 | 0 |
143465 | 143465 | 2020-05-14 | Beltrami | Minnesota | 27007 | 8 | 0 |
146465 | 146465 | 2020-05-15 | Beltrami | Minnesota | 27007 | 9 | 0 |
149470 | 149470 | 2020-05-16 | Beltrami | Minnesota | 27007 | 9 | 0 |
152481 | 152481 | 2020-05-17 | Beltrami | Minnesota | 27007 | 9 | 0 |
155495 | 155495 | 2020-05-18 | Beltrami | Minnesota | 27007 | 9 | 0 |
158513 | 158513 | 2020-05-19 | Beltrami | Minnesota | 27007 | 9 | 0 |
161539 | 161539 | 2020-05-20 | Beltrami | Minnesota | 27007 | 9 | 0 |
164568 | 164568 | 2020-05-21 | Beltrami | Minnesota | 27007 | 9 | 0 |
167604 | 167604 | 2020-05-22 | Beltrami | Minnesota | 27007 | 10 | 0 |
170641 | 170641 | 2020-05-23 | Beltrami | Minnesota | 27007 | 12 | 0 |
173683 | 173683 | 2020-05-24 | Beltrami | Minnesota | 27007 | 12 | 0 |
176726 | 176726 | 2020-05-25 | Beltrami | Minnesota | 27007 | 12 | 0 |
179770 | 179770 | 2020-05-26 | Beltrami | Minnesota | 27007 | 12 | 0 |
182816 | 182816 | 2020-05-27 | Beltrami | Minnesota | 27007 | 13 | 0 |
185871 | 185871 | 2020-05-28 | Beltrami | Minnesota | 27007 | 14 | 0 |
188929 | 188929 | 2020-05-29 | Beltrami | Minnesota | 27007 | 14 | 0 |
191993 | 191993 | 2020-05-30 | Beltrami | Minnesota | 27007 | 14 | 0 |
195061 | 195061 | 2020-05-31 | Beltrami | Minnesota | 27007 | 15 | 0 |
198132 | 198132 | 2020-06-01 | Beltrami | Minnesota | 27007 | 15 | 0 |
201205 | 201205 | 2020-06-02 | Beltrami | Minnesota | 27007 | 16 | 0 |
204282 | 204282 | 2020-06-03 | Beltrami | Minnesota | 27007 | 18 | 0 |
207363 | 207363 | 2020-06-04 | Beltrami | Minnesota | 27007 | 18 | 0 |
210444 | 210444 | 2020-06-05 | Beltrami | Minnesota | 27007 | 18 | 0 |
213528 | 213528 | 2020-06-06 | Beltrami | Minnesota | 27007 | 20 | 0 |
216616 | 216616 | 2020-06-07 | Beltrami | Minnesota | 27007 | 21 | 0 |
219708 | 219708 | 2020-06-08 | Beltrami | Minnesota | 27007 | 21 | 0 |
222803 | 222803 | 2020-06-09 | Beltrami | Minnesota | 27007 | 21 | 0 |
225901 | 225901 | 2020-06-10 | Beltrami | Minnesota | 27007 | 21 | 0 |
229003 | 229003 | 2020-06-11 | Beltrami | Minnesota | 27007 | 21 | 0 |
232107 | 232107 | 2020-06-12 | Beltrami | Minnesota | 27007 | 21 | 0 |
235212 | 235212 | 2020-06-13 | Beltrami | Minnesota | 27007 | 21 | 0 |
238319 | 238319 | 2020-06-14 | Beltrami | Minnesota | 27007 | 23 | 0 |
241428 | 241428 | 2020-06-15 | Beltrami | Minnesota | 27007 | 23 | 0 |
244539 | 244539 | 2020-06-16 | Beltrami | Minnesota | 27007 | 23 | 0 |
247652 | 247652 | 2020-06-17 | Beltrami | Minnesota | 27007 | 23 | 0 |
250764 | 250764 | 2020-06-18 | Beltrami | Minnesota | 27007 | 23 | 0 |
253879 | 253879 | 2020-06-19 | Beltrami | Minnesota | 27007 | 23 | 0 |
256999 | 256999 | 2020-06-20 | Beltrami | Minnesota | 27007 | 24 | 0 |
260125 | 260125 | 2020-06-21 | Beltrami | Minnesota | 27007 | 25 | 0 |
263254 | 263254 | 2020-06-22 | Beltrami | Minnesota | 27007 | 25 | 0 |
266380 | 266380 | 2020-06-23 | Beltrami | Minnesota | 27007 | 25 | 0 |
269513 | 269513 | 2020-06-24 | Beltrami | Minnesota | 27007 | 27 | 0 |
272650 | 272650 | 2020-06-25 | Beltrami | Minnesota | 27007 | 27 | 0 |
275793 | 275793 | 2020-06-26 | Beltrami | Minnesota | 27007 | 27 | 0 |
278941 | 278941 | 2020-06-27 | Beltrami | Minnesota | 27007 | 27 | 0 |
282089 | 282089 | 2020-06-28 | Beltrami | Minnesota | 27007 | 27 | 0 |
285234 | 285234 | 2020-06-29 | Beltrami | Minnesota | 27007 | 27 | 0 |
288384 | 288384 | 2020-06-30 | Beltrami | Minnesota | 27007 | 27 | 0 |
291535 | 291535 | 2020-07-01 | Beltrami | Minnesota | 27007 | 28 | 0 |
294689 | 294689 | 2020-07-02 | Beltrami | Minnesota | 27007 | 29 | 0 |
297847 | 297847 | 2020-07-03 | Beltrami | Minnesota | 27007 | 29 | 0 |
301010 | 301010 | 2020-07-04 | Beltrami | Minnesota | 27007 | 29 | 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);