ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 27025 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5585 | 5585 | 2020-03-20 | Chisago | Minnesota | 27025 | 1 | 0 |
6553 | 6553 | 2020-03-21 | Chisago | Minnesota | 27025 | 1 | 0 |
7634 | 7634 | 2020-03-22 | Chisago | Minnesota | 27025 | 1 | 0 |
8812 | 8812 | 2020-03-23 | Chisago | Minnesota | 27025 | 2 | 0 |
10107 | 10107 | 2020-03-24 | Chisago | Minnesota | 27025 | 2 | 0 |
11524 | 11524 | 2020-03-25 | Chisago | Minnesota | 27025 | 2 | 0 |
13112 | 13112 | 2020-03-26 | Chisago | Minnesota | 27025 | 2 | 0 |
14825 | 14825 | 2020-03-27 | Chisago | Minnesota | 27025 | 2 | 0 |
16646 | 16646 | 2020-03-28 | Chisago | Minnesota | 27025 | 2 | 0 |
18562 | 18562 | 2020-03-29 | Chisago | Minnesota | 27025 | 2 | 0 |
20582 | 20582 | 2020-03-30 | Chisago | Minnesota | 27025 | 3 | 0 |
22696 | 22696 | 2020-03-31 | Chisago | Minnesota | 27025 | 3 | 0 |
24876 | 24876 | 2020-04-01 | Chisago | Minnesota | 27025 | 3 | 0 |
27129 | 27129 | 2020-04-02 | Chisago | Minnesota | 27025 | 3 | 0 |
29448 | 29448 | 2020-04-03 | Chisago | Minnesota | 27025 | 4 | 1 |
31826 | 31826 | 2020-04-04 | Chisago | Minnesota | 27025 | 4 | 1 |
34251 | 34251 | 2020-04-05 | Chisago | Minnesota | 27025 | 4 | 1 |
36711 | 36711 | 2020-04-06 | Chisago | Minnesota | 27025 | 5 | 1 |
39220 | 39220 | 2020-04-07 | Chisago | Minnesota | 27025 | 5 | 1 |
41773 | 41773 | 2020-04-08 | Chisago | Minnesota | 27025 | 5 | 1 |
44349 | 44349 | 2020-04-09 | Chisago | Minnesota | 27025 | 5 | 1 |
46958 | 46958 | 2020-04-10 | Chisago | Minnesota | 27025 | 6 | 1 |
49603 | 49603 | 2020-04-11 | Chisago | Minnesota | 27025 | 6 | 1 |
52273 | 52273 | 2020-04-12 | Chisago | Minnesota | 27025 | 7 | 1 |
54955 | 54955 | 2020-04-13 | Chisago | Minnesota | 27025 | 7 | 1 |
57653 | 57653 | 2020-04-14 | Chisago | Minnesota | 27025 | 7 | 1 |
60363 | 60363 | 2020-04-15 | Chisago | Minnesota | 27025 | 7 | 1 |
63085 | 63085 | 2020-04-16 | Chisago | Minnesota | 27025 | 7 | 1 |
65824 | 65824 | 2020-04-17 | Chisago | Minnesota | 27025 | 7 | 1 |
68575 | 68575 | 2020-04-18 | Chisago | Minnesota | 27025 | 7 | 1 |
71339 | 71339 | 2020-04-19 | Chisago | Minnesota | 27025 | 7 | 1 |
74112 | 74112 | 2020-04-20 | Chisago | Minnesota | 27025 | 7 | 1 |
76892 | 76892 | 2020-04-21 | Chisago | Minnesota | 27025 | 7 | 1 |
79677 | 79677 | 2020-04-22 | Chisago | Minnesota | 27025 | 7 | 1 |
82473 | 82473 | 2020-04-23 | Chisago | Minnesota | 27025 | 7 | 1 |
85277 | 85277 | 2020-04-24 | Chisago | Minnesota | 27025 | 7 | 1 |
88087 | 88087 | 2020-04-25 | Chisago | Minnesota | 27025 | 7 | 1 |
90903 | 90903 | 2020-04-26 | Chisago | Minnesota | 27025 | 7 | 1 |
93724 | 93724 | 2020-04-27 | Chisago | Minnesota | 27025 | 7 | 1 |
96559 | 96559 | 2020-04-28 | Chisago | Minnesota | 27025 | 9 | 1 |
99405 | 99405 | 2020-04-29 | Chisago | Minnesota | 27025 | 10 | 1 |
102257 | 102257 | 2020-04-30 | Chisago | Minnesota | 27025 | 11 | 1 |
105117 | 105117 | 2020-05-01 | Chisago | Minnesota | 27025 | 12 | 1 |
107981 | 107981 | 2020-05-02 | Chisago | Minnesota | 27025 | 13 | 1 |
110852 | 110852 | 2020-05-03 | Chisago | Minnesota | 27025 | 13 | 1 |
113731 | 113731 | 2020-05-04 | Chisago | Minnesota | 27025 | 13 | 1 |
116612 | 116612 | 2020-05-05 | Chisago | Minnesota | 27025 | 13 | 1 |
119572 | 119572 | 2020-05-06 | Chisago | Minnesota | 27025 | 14 | 1 |
122545 | 122545 | 2020-05-07 | Chisago | Minnesota | 27025 | 14 | 1 |
125527 | 125527 | 2020-05-08 | Chisago | Minnesota | 27025 | 18 | 1 |
128514 | 128514 | 2020-05-09 | Chisago | Minnesota | 27025 | 19 | 1 |
131504 | 131504 | 2020-05-10 | Chisago | Minnesota | 27025 | 20 | 1 |
134495 | 134495 | 2020-05-11 | Chisago | Minnesota | 27025 | 20 | 1 |
137485 | 137485 | 2020-05-12 | Chisago | Minnesota | 27025 | 23 | 1 |
140479 | 140479 | 2020-05-13 | Chisago | Minnesota | 27025 | 23 | 1 |
143474 | 143474 | 2020-05-14 | Chisago | Minnesota | 27025 | 25 | 1 |
146474 | 146474 | 2020-05-15 | Chisago | Minnesota | 27025 | 27 | 1 |
149479 | 149479 | 2020-05-16 | Chisago | Minnesota | 27025 | 30 | 1 |
152490 | 152490 | 2020-05-17 | Chisago | Minnesota | 27025 | 34 | 1 |
155504 | 155504 | 2020-05-18 | Chisago | Minnesota | 27025 | 37 | 1 |
158522 | 158522 | 2020-05-19 | Chisago | Minnesota | 27025 | 38 | 1 |
161548 | 161548 | 2020-05-20 | Chisago | Minnesota | 27025 | 38 | 1 |
164577 | 164577 | 2020-05-21 | Chisago | Minnesota | 27025 | 39 | 1 |
167613 | 167613 | 2020-05-22 | Chisago | Minnesota | 27025 | 41 | 1 |
170650 | 170650 | 2020-05-23 | Chisago | Minnesota | 27025 | 44 | 1 |
173692 | 173692 | 2020-05-24 | Chisago | Minnesota | 27025 | 48 | 1 |
176735 | 176735 | 2020-05-25 | Chisago | Minnesota | 27025 | 48 | 1 |
179779 | 179779 | 2020-05-26 | Chisago | Minnesota | 27025 | 49 | 1 |
182825 | 182825 | 2020-05-27 | Chisago | Minnesota | 27025 | 50 | 1 |
185880 | 185880 | 2020-05-28 | Chisago | Minnesota | 27025 | 54 | 1 |
188938 | 188938 | 2020-05-29 | Chisago | Minnesota | 27025 | 60 | 1 |
192002 | 192002 | 2020-05-30 | Chisago | Minnesota | 27025 | 61 | 1 |
195070 | 195070 | 2020-05-31 | Chisago | Minnesota | 27025 | 61 | 1 |
198141 | 198141 | 2020-06-01 | Chisago | Minnesota | 27025 | 62 | 1 |
201214 | 201214 | 2020-06-02 | Chisago | Minnesota | 27025 | 62 | 1 |
204291 | 204291 | 2020-06-03 | Chisago | Minnesota | 27025 | 64 | 1 |
207372 | 207372 | 2020-06-04 | Chisago | Minnesota | 27025 | 64 | 1 |
210453 | 210453 | 2020-06-05 | Chisago | Minnesota | 27025 | 69 | 1 |
213537 | 213537 | 2020-06-06 | Chisago | Minnesota | 27025 | 70 | 1 |
216625 | 216625 | 2020-06-07 | Chisago | Minnesota | 27025 | 70 | 1 |
219717 | 219717 | 2020-06-08 | Chisago | Minnesota | 27025 | 70 | 1 |
222812 | 222812 | 2020-06-09 | Chisago | Minnesota | 27025 | 70 | 1 |
225910 | 225910 | 2020-06-10 | Chisago | Minnesota | 27025 | 73 | 1 |
229012 | 229012 | 2020-06-11 | Chisago | Minnesota | 27025 | 74 | 1 |
232116 | 232116 | 2020-06-12 | Chisago | Minnesota | 27025 | 77 | 1 |
235221 | 235221 | 2020-06-13 | Chisago | Minnesota | 27025 | 78 | 1 |
238328 | 238328 | 2020-06-14 | Chisago | Minnesota | 27025 | 78 | 1 |
241437 | 241437 | 2020-06-15 | Chisago | Minnesota | 27025 | 80 | 1 |
244548 | 244548 | 2020-06-16 | Chisago | Minnesota | 27025 | 80 | 1 |
247661 | 247661 | 2020-06-17 | Chisago | Minnesota | 27025 | 81 | 1 |
250773 | 250773 | 2020-06-18 | Chisago | Minnesota | 27025 | 81 | 1 |
253888 | 253888 | 2020-06-19 | Chisago | Minnesota | 27025 | 82 | 1 |
257008 | 257008 | 2020-06-20 | Chisago | Minnesota | 27025 | 83 | 1 |
260134 | 260134 | 2020-06-21 | Chisago | Minnesota | 27025 | 87 | 1 |
263263 | 263263 | 2020-06-22 | Chisago | Minnesota | 27025 | 87 | 1 |
266389 | 266389 | 2020-06-23 | Chisago | Minnesota | 27025 | 87 | 1 |
269522 | 269522 | 2020-06-24 | Chisago | Minnesota | 27025 | 87 | 1 |
272659 | 272659 | 2020-06-25 | Chisago | Minnesota | 27025 | 88 | 1 |
275802 | 275802 | 2020-06-26 | Chisago | Minnesota | 27025 | 90 | 1 |
278950 | 278950 | 2020-06-27 | Chisago | Minnesota | 27025 | 90 | 1 |
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);