ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,535 rows where county = "Pennington" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
76930 | 76930 | 2020-04-21 | Pennington | Minnesota | 27113 | 1 | 0 |
79715 | 79715 | 2020-04-22 | Pennington | Minnesota | 27113 | 1 | 0 |
82511 | 82511 | 2020-04-23 | Pennington | Minnesota | 27113 | 1 | 0 |
85315 | 85315 | 2020-04-24 | Pennington | Minnesota | 27113 | 1 | 0 |
88125 | 88125 | 2020-04-25 | Pennington | Minnesota | 27113 | 1 | 0 |
90941 | 90941 | 2020-04-26 | Pennington | Minnesota | 27113 | 1 | 0 |
93762 | 93762 | 2020-04-27 | Pennington | Minnesota | 27113 | 1 | 0 |
96597 | 96597 | 2020-04-28 | Pennington | Minnesota | 27113 | 1 | 0 |
99443 | 99443 | 2020-04-29 | Pennington | Minnesota | 27113 | 1 | 0 |
102295 | 102295 | 2020-04-30 | Pennington | Minnesota | 27113 | 1 | 0 |
105156 | 105156 | 2020-05-01 | Pennington | Minnesota | 27113 | 1 | 0 |
108021 | 108021 | 2020-05-02 | Pennington | Minnesota | 27113 | 1 | 0 |
110892 | 110892 | 2020-05-03 | Pennington | Minnesota | 27113 | 1 | 0 |
113771 | 113771 | 2020-05-04 | Pennington | Minnesota | 27113 | 1 | 0 |
116652 | 116652 | 2020-05-05 | Pennington | Minnesota | 27113 | 1 | 0 |
119612 | 119612 | 2020-05-06 | Pennington | Minnesota | 27113 | 1 | 0 |
122586 | 122586 | 2020-05-07 | Pennington | Minnesota | 27113 | 1 | 0 |
125568 | 125568 | 2020-05-08 | Pennington | Minnesota | 27113 | 1 | 0 |
128555 | 128555 | 2020-05-09 | Pennington | Minnesota | 27113 | 1 | 0 |
131545 | 131545 | 2020-05-10 | Pennington | Minnesota | 27113 | 1 | 0 |
134536 | 134536 | 2020-05-11 | Pennington | Minnesota | 27113 | 1 | 0 |
137526 | 137526 | 2020-05-12 | Pennington | Minnesota | 27113 | 1 | 0 |
140520 | 140520 | 2020-05-13 | Pennington | Minnesota | 27113 | 1 | 0 |
143515 | 143515 | 2020-05-14 | Pennington | Minnesota | 27113 | 1 | 0 |
146515 | 146515 | 2020-05-15 | Pennington | Minnesota | 27113 | 1 | 0 |
149520 | 149520 | 2020-05-16 | Pennington | Minnesota | 27113 | 1 | 0 |
152531 | 152531 | 2020-05-17 | Pennington | Minnesota | 27113 | 1 | 0 |
155545 | 155545 | 2020-05-18 | Pennington | Minnesota | 27113 | 2 | 0 |
158563 | 158563 | 2020-05-19 | Pennington | Minnesota | 27113 | 3 | 0 |
161589 | 161589 | 2020-05-20 | Pennington | Minnesota | 27113 | 3 | 0 |
164618 | 164618 | 2020-05-21 | Pennington | Minnesota | 27113 | 4 | 0 |
167654 | 167654 | 2020-05-22 | Pennington | Minnesota | 27113 | 6 | 0 |
170692 | 170692 | 2020-05-23 | Pennington | Minnesota | 27113 | 7 | 0 |
173734 | 173734 | 2020-05-24 | Pennington | Minnesota | 27113 | 7 | 0 |
176777 | 176777 | 2020-05-25 | Pennington | Minnesota | 27113 | 9 | 0 |
179821 | 179821 | 2020-05-26 | Pennington | Minnesota | 27113 | 14 | 0 |
182867 | 182867 | 2020-05-27 | Pennington | Minnesota | 27113 | 17 | 0 |
185922 | 185922 | 2020-05-28 | Pennington | Minnesota | 27113 | 17 | 0 |
188980 | 188980 | 2020-05-29 | Pennington | Minnesota | 27113 | 17 | 0 |
192044 | 192044 | 2020-05-30 | Pennington | Minnesota | 27113 | 17 | 0 |
195112 | 195112 | 2020-05-31 | Pennington | Minnesota | 27113 | 19 | 0 |
198183 | 198183 | 2020-06-01 | Pennington | Minnesota | 27113 | 19 | 0 |
201256 | 201256 | 2020-06-02 | Pennington | Minnesota | 27113 | 19 | 0 |
204333 | 204333 | 2020-06-03 | Pennington | Minnesota | 27113 | 21 | 0 |
207414 | 207414 | 2020-06-04 | Pennington | Minnesota | 27113 | 23 | 0 |
210495 | 210495 | 2020-06-05 | Pennington | Minnesota | 27113 | 30 | 0 |
213579 | 213579 | 2020-06-06 | Pennington | Minnesota | 27113 | 31 | 0 |
216667 | 216667 | 2020-06-07 | Pennington | Minnesota | 27113 | 34 | 0 |
219759 | 219759 | 2020-06-08 | Pennington | Minnesota | 27113 | 36 | 0 |
222854 | 222854 | 2020-06-09 | Pennington | Minnesota | 27113 | 37 | 0 |
225952 | 225952 | 2020-06-10 | Pennington | Minnesota | 27113 | 37 | 0 |
229054 | 229054 | 2020-06-11 | Pennington | Minnesota | 27113 | 37 | 0 |
232158 | 232158 | 2020-06-12 | Pennington | Minnesota | 27113 | 50 | 0 |
235264 | 235264 | 2020-06-13 | Pennington | Minnesota | 27113 | 50 | 0 |
238371 | 238371 | 2020-06-14 | Pennington | Minnesota | 27113 | 50 | 0 |
241480 | 241480 | 2020-06-15 | Pennington | Minnesota | 27113 | 51 | 0 |
244591 | 244591 | 2020-06-16 | Pennington | Minnesota | 27113 | 51 | 0 |
247704 | 247704 | 2020-06-17 | Pennington | Minnesota | 27113 | 51 | 0 |
250816 | 250816 | 2020-06-18 | Pennington | Minnesota | 27113 | 52 | 0 |
253931 | 253931 | 2020-06-19 | Pennington | Minnesota | 27113 | 50 | 0 |
257051 | 257051 | 2020-06-20 | Pennington | Minnesota | 27113 | 50 | 0 |
260177 | 260177 | 2020-06-21 | Pennington | Minnesota | 27113 | 50 | 0 |
263306 | 263306 | 2020-06-22 | Pennington | Minnesota | 27113 | 50 | 0 |
266432 | 266432 | 2020-06-23 | Pennington | Minnesota | 27113 | 50 | 0 |
269565 | 269565 | 2020-06-24 | Pennington | Minnesota | 27113 | 50 | 0 |
272702 | 272702 | 2020-06-25 | Pennington | Minnesota | 27113 | 50 | 0 |
275845 | 275845 | 2020-06-26 | Pennington | Minnesota | 27113 | 50 | 0 |
278993 | 278993 | 2020-06-27 | Pennington | Minnesota | 27113 | 50 | 0 |
282141 | 282141 | 2020-06-28 | Pennington | Minnesota | 27113 | 50 | 0 |
285286 | 285286 | 2020-06-29 | Pennington | Minnesota | 27113 | 50 | 0 |
288436 | 288436 | 2020-06-30 | Pennington | Minnesota | 27113 | 50 | 0 |
291587 | 291587 | 2020-07-01 | Pennington | Minnesota | 27113 | 51 | 0 |
294741 | 294741 | 2020-07-02 | Pennington | Minnesota | 27113 | 51 | 0 |
297899 | 297899 | 2020-07-03 | Pennington | Minnesota | 27113 | 50 | 0 |
301062 | 301062 | 2020-07-04 | Pennington | Minnesota | 27113 | 50 | 0 |
304226 | 304226 | 2020-07-05 | Pennington | Minnesota | 27113 | 51 | 0 |
307393 | 307393 | 2020-07-06 | Pennington | Minnesota | 27113 | 51 | 0 |
310561 | 310561 | 2020-07-07 | Pennington | Minnesota | 27113 | 52 | 0 |
313731 | 313731 | 2020-07-08 | Pennington | Minnesota | 27113 | 52 | 0 |
316905 | 316905 | 2020-07-09 | Pennington | Minnesota | 27113 | 53 | 0 |
320080 | 320080 | 2020-07-10 | Pennington | Minnesota | 27113 | 53 | 0 |
323259 | 323259 | 2020-07-11 | Pennington | Minnesota | 27113 | 53 | 0 |
326442 | 326442 | 2020-07-12 | Pennington | Minnesota | 27113 | 54 | 0 |
329628 | 329628 | 2020-07-13 | Pennington | Minnesota | 27113 | 54 | 0 |
332815 | 332815 | 2020-07-14 | Pennington | Minnesota | 27113 | 54 | 0 |
336008 | 336008 | 2020-07-15 | Pennington | Minnesota | 27113 | 55 | 0 |
339204 | 339204 | 2020-07-16 | Pennington | Minnesota | 27113 | 55 | 0 |
342400 | 342400 | 2020-07-17 | Pennington | Minnesota | 27113 | 58 | 0 |
345600 | 345600 | 2020-07-18 | Pennington | Minnesota | 27113 | 58 | 0 |
348801 | 348801 | 2020-07-19 | Pennington | Minnesota | 27113 | 60 | 0 |
352001 | 352001 | 2020-07-20 | Pennington | Minnesota | 27113 | 59 | 0 |
355203 | 355203 | 2020-07-21 | Pennington | Minnesota | 27113 | 60 | 0 |
358406 | 358406 | 2020-07-22 | Pennington | Minnesota | 27113 | 60 | 0 |
361611 | 361611 | 2020-07-23 | Pennington | Minnesota | 27113 | 60 | 1 |
364818 | 364818 | 2020-07-24 | Pennington | Minnesota | 27113 | 60 | 1 |
368026 | 368026 | 2020-07-25 | Pennington | Minnesota | 27113 | 62 | 1 |
371236 | 371236 | 2020-07-26 | Pennington | Minnesota | 27113 | 62 | 1 |
374448 | 374448 | 2020-07-27 | Pennington | Minnesota | 27113 | 63 | 1 |
377663 | 377663 | 2020-07-28 | Pennington | Minnesota | 27113 | 65 | 1 |
380880 | 380880 | 2020-07-29 | Pennington | Minnesota | 27113 | 65 | 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);