ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Stearns" and fips = 27145 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 |
---|---|---|---|---|---|---|---|
1491 | 1491 | 2020-03-12 | Stearns | Minnesota | 27145 | 2 | 0 |
1774 | 1774 | 2020-03-13 | Stearns | Minnesota | 27145 | 2 | 0 |
2119 | 2119 | 2020-03-14 | Stearns | Minnesota | 27145 | 3 | 0 |
2523 | 2523 | 2020-03-15 | Stearns | Minnesota | 27145 | 3 | 0 |
2975 | 2975 | 2020-03-16 | Stearns | Minnesota | 27145 | 3 | 0 |
3480 | 3480 | 2020-03-17 | Stearns | Minnesota | 27145 | 3 | 0 |
4064 | 4064 | 2020-03-18 | Stearns | Minnesota | 27145 | 3 | 0 |
4776 | 4776 | 2020-03-19 | Stearns | Minnesota | 27145 | 4 | 0 |
5598 | 5598 | 2020-03-20 | Stearns | Minnesota | 27145 | 4 | 0 |
6569 | 6569 | 2020-03-21 | Stearns | Minnesota | 27145 | 4 | 0 |
7651 | 7651 | 2020-03-22 | Stearns | Minnesota | 27145 | 4 | 0 |
8831 | 8831 | 2020-03-23 | Stearns | Minnesota | 27145 | 5 | 0 |
10126 | 10126 | 2020-03-24 | Stearns | Minnesota | 27145 | 5 | 0 |
11544 | 11544 | 2020-03-25 | Stearns | Minnesota | 27145 | 5 | 0 |
13134 | 13134 | 2020-03-26 | Stearns | Minnesota | 27145 | 5 | 0 |
14850 | 14850 | 2020-03-27 | Stearns | Minnesota | 27145 | 5 | 0 |
16672 | 16672 | 2020-03-28 | Stearns | Minnesota | 27145 | 5 | 0 |
18592 | 18592 | 2020-03-29 | Stearns | Minnesota | 27145 | 5 | 0 |
20614 | 20614 | 2020-03-30 | Stearns | Minnesota | 27145 | 5 | 0 |
22729 | 22729 | 2020-03-31 | Stearns | Minnesota | 27145 | 5 | 0 |
24911 | 24911 | 2020-04-01 | Stearns | Minnesota | 27145 | 5 | 0 |
27165 | 27165 | 2020-04-02 | Stearns | Minnesota | 27145 | 5 | 0 |
29484 | 29484 | 2020-04-03 | Stearns | Minnesota | 27145 | 5 | 0 |
31864 | 31864 | 2020-04-04 | Stearns | Minnesota | 27145 | 6 | 0 |
34291 | 34291 | 2020-04-05 | Stearns | Minnesota | 27145 | 6 | 0 |
36753 | 36753 | 2020-04-06 | Stearns | Minnesota | 27145 | 6 | 0 |
39263 | 39263 | 2020-04-07 | Stearns | Minnesota | 27145 | 6 | 0 |
41817 | 41817 | 2020-04-08 | Stearns | Minnesota | 27145 | 7 | 0 |
44393 | 44393 | 2020-04-09 | Stearns | Minnesota | 27145 | 7 | 0 |
47003 | 47003 | 2020-04-10 | Stearns | Minnesota | 27145 | 7 | 0 |
49648 | 49648 | 2020-04-11 | Stearns | Minnesota | 27145 | 7 | 0 |
52320 | 52320 | 2020-04-12 | Stearns | Minnesota | 27145 | 7 | 0 |
55002 | 55002 | 2020-04-13 | Stearns | Minnesota | 27145 | 7 | 0 |
57700 | 57700 | 2020-04-14 | Stearns | Minnesota | 27145 | 7 | 0 |
60411 | 60411 | 2020-04-15 | Stearns | Minnesota | 27145 | 7 | 0 |
63134 | 63134 | 2020-04-16 | Stearns | Minnesota | 27145 | 11 | 0 |
65873 | 65873 | 2020-04-17 | Stearns | Minnesota | 27145 | 14 | 0 |
68625 | 68625 | 2020-04-18 | Stearns | Minnesota | 27145 | 16 | 0 |
71391 | 71391 | 2020-04-19 | Stearns | Minnesota | 27145 | 16 | 0 |
74164 | 74164 | 2020-04-20 | Stearns | Minnesota | 27145 | 17 | 0 |
76945 | 76945 | 2020-04-21 | Stearns | Minnesota | 27145 | 18 | 0 |
79730 | 79730 | 2020-04-22 | Stearns | Minnesota | 27145 | 20 | 0 |
82526 | 82526 | 2020-04-23 | Stearns | Minnesota | 27145 | 25 | 0 |
85330 | 85330 | 2020-04-24 | Stearns | Minnesota | 27145 | 33 | 0 |
88140 | 88140 | 2020-04-25 | Stearns | Minnesota | 27145 | 38 | 0 |
90956 | 90956 | 2020-04-26 | Stearns | Minnesota | 27145 | 38 | 0 |
93777 | 93777 | 2020-04-27 | Stearns | Minnesota | 27145 | 55 | 0 |
96612 | 96612 | 2020-04-28 | Stearns | Minnesota | 27145 | 86 | 0 |
99458 | 99458 | 2020-04-29 | Stearns | Minnesota | 27145 | 166 | 0 |
102310 | 102310 | 2020-04-30 | Stearns | Minnesota | 27145 | 267 | 0 |
105171 | 105171 | 2020-05-01 | Stearns | Minnesota | 27145 | 435 | 0 |
108036 | 108036 | 2020-05-02 | Stearns | Minnesota | 27145 | 531 | 0 |
110907 | 110907 | 2020-05-03 | Stearns | Minnesota | 27145 | 589 | 0 |
113786 | 113786 | 2020-05-04 | Stearns | Minnesota | 27145 | 728 | 2 |
116668 | 116668 | 2020-05-05 | Stearns | Minnesota | 27145 | 815 | 2 |
119628 | 119628 | 2020-05-06 | Stearns | Minnesota | 27145 | 975 | 3 |
122602 | 122602 | 2020-05-07 | Stearns | Minnesota | 27145 | 1161 | 4 |
125584 | 125584 | 2020-05-08 | Stearns | Minnesota | 27145 | 1274 | 4 |
128571 | 128571 | 2020-05-09 | Stearns | Minnesota | 27145 | 1348 | 5 |
131561 | 131561 | 2020-05-10 | Stearns | Minnesota | 27145 | 1405 | 5 |
134552 | 134552 | 2020-05-11 | Stearns | Minnesota | 27145 | 1443 | 6 |
137542 | 137542 | 2020-05-12 | Stearns | Minnesota | 27145 | 1512 | 6 |
140536 | 140536 | 2020-05-13 | Stearns | Minnesota | 27145 | 1512 | 6 |
143531 | 143531 | 2020-05-14 | Stearns | Minnesota | 27145 | 1609 | 9 |
146531 | 146531 | 2020-05-15 | Stearns | Minnesota | 27145 | 1641 | 9 |
149536 | 149536 | 2020-05-16 | Stearns | Minnesota | 27145 | 1675 | 10 |
152547 | 152547 | 2020-05-17 | Stearns | Minnesota | 27145 | 1713 | 10 |
155561 | 155561 | 2020-05-18 | Stearns | Minnesota | 27145 | 1740 | 10 |
158579 | 158579 | 2020-05-19 | Stearns | Minnesota | 27145 | 1782 | 10 |
161605 | 161605 | 2020-05-20 | Stearns | Minnesota | 27145 | 1831 | 11 |
164634 | 164634 | 2020-05-21 | Stearns | Minnesota | 27145 | 1853 | 11 |
167670 | 167670 | 2020-05-22 | Stearns | Minnesota | 27145 | 1881 | 12 |
170708 | 170708 | 2020-05-23 | Stearns | Minnesota | 27145 | 1918 | 12 |
173750 | 173750 | 2020-05-24 | Stearns | Minnesota | 27145 | 1923 | 12 |
176793 | 176793 | 2020-05-25 | Stearns | Minnesota | 27145 | 1950 | 12 |
179837 | 179837 | 2020-05-26 | Stearns | Minnesota | 27145 | 1959 | 12 |
182883 | 182883 | 2020-05-27 | Stearns | Minnesota | 27145 | 1984 | 12 |
185938 | 185938 | 2020-05-28 | Stearns | Minnesota | 27145 | 1995 | 12 |
188996 | 188996 | 2020-05-29 | Stearns | Minnesota | 27145 | 2001 | 13 |
192060 | 192060 | 2020-05-30 | Stearns | Minnesota | 27145 | 2014 | 13 |
195128 | 195128 | 2020-05-31 | Stearns | Minnesota | 27145 | 2021 | 13 |
198199 | 198199 | 2020-06-01 | Stearns | Minnesota | 27145 | 2030 | 13 |
201272 | 201272 | 2020-06-02 | Stearns | Minnesota | 27145 | 2042 | 13 |
204349 | 204349 | 2020-06-03 | Stearns | Minnesota | 27145 | 2047 | 14 |
207430 | 207430 | 2020-06-04 | Stearns | Minnesota | 27145 | 2050 | 14 |
210511 | 210511 | 2020-06-05 | Stearns | Minnesota | 27145 | 2056 | 14 |
213595 | 213595 | 2020-06-06 | Stearns | Minnesota | 27145 | 2063 | 15 |
216683 | 216683 | 2020-06-07 | Stearns | Minnesota | 27145 | 2070 | 16 |
219775 | 219775 | 2020-06-08 | Stearns | Minnesota | 27145 | 2071 | 16 |
222870 | 222870 | 2020-06-09 | Stearns | Minnesota | 27145 | 2076 | 17 |
225968 | 225968 | 2020-06-10 | Stearns | Minnesota | 27145 | 2081 | 17 |
229070 | 229070 | 2020-06-11 | Stearns | Minnesota | 27145 | 2088 | 17 |
232174 | 232174 | 2020-06-12 | Stearns | Minnesota | 27145 | 2096 | 17 |
235280 | 235280 | 2020-06-13 | Stearns | Minnesota | 27145 | 2100 | 18 |
238387 | 238387 | 2020-06-14 | Stearns | Minnesota | 27145 | 2107 | 19 |
241496 | 241496 | 2020-06-15 | Stearns | Minnesota | 27145 | 2108 | 19 |
244607 | 244607 | 2020-06-16 | Stearns | Minnesota | 27145 | 2109 | 19 |
247720 | 247720 | 2020-06-17 | Stearns | Minnesota | 27145 | 2111 | 19 |
250832 | 250832 | 2020-06-18 | Stearns | Minnesota | 27145 | 2122 | 19 |
253947 | 253947 | 2020-06-19 | Stearns | Minnesota | 27145 | 2126 | 19 |
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);