ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 23019 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 161 ✖
- 6 82
- 0 57
- 2 37
- 5 37
- 89 24
- 87 21
- 106 20
- 1 19
- 325 18
- 7 17
- 90 15
- 93 14
- 85 12
- 94 12
- 76 11
- 321 11
- 192 10
- 315 10
- 14 8
- 15 8
- 88 8
- 95 8
- 99 7
- 101 7
- 172 7
- 206 7
- 308 7
- 331 7
- 111 6
- 112 6
- 185 6
- 202 6
- 205 6
- 319 6
- 4 5
- 18 5
- 97 5
- 100 5
- 114 5
- 136 5
- 271 5
- 323 5
- 326 5
- 20 4
- 27 4
- 72 4
- 91 4
- 105 4
- 142 4
- 163 4
- 197 4
- 218 4
- 225 4
- 241 4
- 255 4
- 264 4
- 293 4
- 320 4
- 3 3
- 16 3
- 21 3
- 56 3
- 58 3
- 63 3
- 120 3
- 127 3
- 141 3
- 174 3
- 214 3
- 236 3
- 237 3
- 248 3
- 17 2
- 24 2
- 45 2
- 70 2
- 73 2
- 96 2
- 98 2
- 104 2
- 107 2
- 126 2
- 194 2
- 215 2
- 245 2
- 251 2
- 9 1
- 12 1
- 13 1
- 22 1
- 30 1
- 32 1
- 35 1
- 37 1
- 47 1
- 49 1
- 53 1
- 54 1
- 55 1
- 57 1
- 67 1
- 71 1
- 74 1
- 82 1
- 102 1
- 108 1
- 109 1
- 113 1
- 115 1
- 117 1
- 119 1
- 123 1
- 125 1
- 132 1
- 135 1
- 147 1
- 159 1
- 160 1
- 164 1
- 166 1
- 168 1
- 170 1
- 181 1
- 184 1
- 189 1
- 190 1
- 191 1
- 196 1
- 203 1
- 204 1
- 207 1
- 208 1
- 209 1
- 213 1
- 217 1
- 221 1
- 222 1
- 224 1
- 229 1
- 232 1
- 234 1
- 235 1
- 239 1
- 246 1
- 254 1
- 257 1
- 258 1
- 261 1
- 267 1
- 268 1
- 273 1
- 275 1
- 281 1
- 286 1
- 295 1
- 304 1
- 311 1
- 314 1
- 322 1
- 328 1
- 329 1
state 1
- Maine 787
fips 1
- 23019 · 787 ✖
county 1
- Penobscot 787
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4011 | 4011 | 2020-03-18 | Penobscot | Maine | 23019 | 1 | 0 |
4713 | 4713 | 2020-03-19 | Penobscot | Maine | 23019 | 1 | 0 |
5531 | 5531 | 2020-03-20 | Penobscot | Maine | 23019 | 2 | 0 |
6486 | 6486 | 2020-03-21 | Penobscot | Maine | 23019 | 2 | 0 |
7561 | 7561 | 2020-03-22 | Penobscot | Maine | 23019 | 2 | 0 |
8731 | 8731 | 2020-03-23 | Penobscot | Maine | 23019 | 3 | 0 |
10020 | 10020 | 2020-03-24 | Penobscot | Maine | 23019 | 4 | 0 |
11429 | 11429 | 2020-03-25 | Penobscot | Maine | 23019 | 4 | 0 |
13010 | 13010 | 2020-03-26 | Penobscot | Maine | 23019 | 5 | 0 |
14718 | 14718 | 2020-03-27 | Penobscot | Maine | 23019 | 6 | 0 |
16538 | 16538 | 2020-03-28 | Penobscot | Maine | 23019 | 10 | 0 |
18452 | 18452 | 2020-03-29 | Penobscot | Maine | 23019 | 11 | 0 |
20468 | 20468 | 2020-03-30 | Penobscot | Maine | 23019 | 12 | 0 |
22577 | 22577 | 2020-03-31 | Penobscot | Maine | 23019 | 12 | 0 |
24754 | 24754 | 2020-04-01 | Penobscot | Maine | 23019 | 13 | 0 |
27005 | 27005 | 2020-04-02 | Penobscot | Maine | 23019 | 16 | 0 |
29323 | 29323 | 2020-04-03 | Penobscot | Maine | 23019 | 20 | 0 |
31701 | 31701 | 2020-04-04 | Penobscot | Maine | 23019 | 22 | 0 |
34126 | 34126 | 2020-04-05 | Penobscot | Maine | 23019 | 22 | 0 |
36585 | 36585 | 2020-04-06 | Penobscot | Maine | 23019 | 25 | 0 |
39093 | 39093 | 2020-04-07 | Penobscot | Maine | 23019 | 31 | 0 |
41645 | 41645 | 2020-04-08 | Penobscot | Maine | 23019 | 31 | 0 |
44221 | 44221 | 2020-04-09 | Penobscot | Maine | 23019 | 31 | 0 |
46829 | 46829 | 2020-04-10 | Penobscot | Maine | 23019 | 33 | 0 |
49471 | 49471 | 2020-04-11 | Penobscot | Maine | 23019 | 34 | 0 |
52141 | 52141 | 2020-04-12 | Penobscot | Maine | 23019 | 34 | 0 |
54822 | 54822 | 2020-04-13 | Penobscot | Maine | 23019 | 34 | 0 |
57520 | 57520 | 2020-04-14 | Penobscot | Maine | 23019 | 34 | 0 |
60228 | 60228 | 2020-04-15 | Penobscot | Maine | 23019 | 36 | 0 |
62949 | 62949 | 2020-04-16 | Penobscot | Maine | 23019 | 37 | 0 |
65688 | 65688 | 2020-04-17 | Penobscot | Maine | 23019 | 40 | 0 |
68437 | 68437 | 2020-04-18 | Penobscot | Maine | 23019 | 41 | 0 |
71200 | 71200 | 2020-04-19 | Penobscot | Maine | 23019 | 43 | 0 |
73972 | 73972 | 2020-04-20 | Penobscot | Maine | 23019 | 44 | 0 |
76752 | 76752 | 2020-04-21 | Penobscot | Maine | 23019 | 46 | 0 |
79538 | 79538 | 2020-04-22 | Penobscot | Maine | 23019 | 47 | 0 |
82334 | 82334 | 2020-04-23 | Penobscot | Maine | 23019 | 49 | 0 |
85138 | 85138 | 2020-04-24 | Penobscot | Maine | 23019 | 50 | 0 |
87947 | 87947 | 2020-04-25 | Penobscot | Maine | 23019 | 52 | 0 |
90763 | 90763 | 2020-04-26 | Penobscot | Maine | 23019 | 53 | 0 |
93584 | 93584 | 2020-04-27 | Penobscot | Maine | 23019 | 55 | 0 |
96419 | 96419 | 2020-04-28 | Penobscot | Maine | 23019 | 57 | 0 |
99265 | 99265 | 2020-04-29 | Penobscot | Maine | 23019 | 59 | 0 |
102117 | 102117 | 2020-04-30 | Penobscot | Maine | 23019 | 78 | 0 |
104978 | 104978 | 2020-05-01 | Penobscot | Maine | 23019 | 79 | 0 |
107842 | 107842 | 2020-05-02 | Penobscot | Maine | 23019 | 82 | 0 |
110714 | 110714 | 2020-05-03 | Penobscot | Maine | 23019 | 84 | 0 |
113591 | 113591 | 2020-05-04 | Penobscot | Maine | 23019 | 85 | 0 |
116473 | 116473 | 2020-05-05 | Penobscot | Maine | 23019 | 85 | 0 |
119434 | 119434 | 2020-05-06 | Penobscot | Maine | 23019 | 87 | 0 |
122405 | 122405 | 2020-05-07 | Penobscot | Maine | 23019 | 89 | 0 |
125387 | 125387 | 2020-05-08 | Penobscot | Maine | 23019 | 89 | 0 |
128374 | 128374 | 2020-05-09 | Penobscot | Maine | 23019 | 89 | 0 |
131364 | 131364 | 2020-05-10 | Penobscot | Maine | 23019 | 90 | 0 |
134355 | 134355 | 2020-05-11 | Penobscot | Maine | 23019 | 90 | 0 |
137345 | 137345 | 2020-05-12 | Penobscot | Maine | 23019 | 90 | 0 |
140339 | 140339 | 2020-05-13 | Penobscot | Maine | 23019 | 90 | 0 |
143334 | 143334 | 2020-05-14 | Penobscot | Maine | 23019 | 91 | 1 |
146334 | 146334 | 2020-05-15 | Penobscot | Maine | 23019 | 91 | 1 |
149339 | 149339 | 2020-05-16 | Penobscot | Maine | 23019 | 93 | 1 |
152350 | 152350 | 2020-05-17 | Penobscot | Maine | 23019 | 93 | 1 |
155364 | 155364 | 2020-05-18 | Penobscot | Maine | 23019 | 93 | 1 |
158382 | 158382 | 2020-05-19 | Penobscot | Maine | 23019 | 94 | 1 |
161408 | 161408 | 2020-05-20 | Penobscot | Maine | 23019 | 95 | 1 |
164437 | 164437 | 2020-05-21 | Penobscot | Maine | 23019 | 98 | 1 |
167473 | 167473 | 2020-05-22 | Penobscot | Maine | 23019 | 98 | 1 |
170511 | 170511 | 2020-05-23 | Penobscot | Maine | 23019 | 98 | 1 |
173552 | 173552 | 2020-05-24 | Penobscot | Maine | 23019 | 98 | 1 |
176596 | 176596 | 2020-05-25 | Penobscot | Maine | 23019 | 99 | 1 |
179640 | 179640 | 2020-05-26 | Penobscot | Maine | 23019 | 99 | 1 |
182685 | 182685 | 2020-05-27 | Penobscot | Maine | 23019 | 99 | 1 |
185740 | 185740 | 2020-05-28 | Penobscot | Maine | 23019 | 100 | 1 |
188798 | 188798 | 2020-05-29 | Penobscot | Maine | 23019 | 100 | 1 |
191862 | 191862 | 2020-05-30 | Penobscot | Maine | 23019 | 100 | 1 |
194930 | 194930 | 2020-05-31 | Penobscot | Maine | 23019 | 100 | 1 |
198001 | 198001 | 2020-06-01 | Penobscot | Maine | 23019 | 100 | 1 |
201073 | 201073 | 2020-06-02 | Penobscot | Maine | 23019 | 100 | 2 |
204150 | 204150 | 2020-06-03 | Penobscot | Maine | 23019 | 100 | 2 |
207231 | 207231 | 2020-06-04 | Penobscot | Maine | 23019 | 100 | 2 |
210312 | 210312 | 2020-06-05 | Penobscot | Maine | 23019 | 101 | 2 |
213397 | 213397 | 2020-06-06 | Penobscot | Maine | 23019 | 101 | 2 |
216484 | 216484 | 2020-06-07 | Penobscot | Maine | 23019 | 101 | 2 |
219576 | 219576 | 2020-06-08 | Penobscot | Maine | 23019 | 101 | 2 |
222671 | 222671 | 2020-06-09 | Penobscot | Maine | 23019 | 101 | 2 |
225767 | 225767 | 2020-06-10 | Penobscot | Maine | 23019 | 101 | 2 |
228869 | 228869 | 2020-06-11 | Penobscot | Maine | 23019 | 101 | 2 |
231973 | 231973 | 2020-06-12 | Penobscot | Maine | 23019 | 102 | 2 |
235078 | 235078 | 2020-06-13 | Penobscot | Maine | 23019 | 102 | 2 |
238185 | 238185 | 2020-06-14 | Penobscot | Maine | 23019 | 102 | 2 |
241294 | 241294 | 2020-06-15 | Penobscot | Maine | 23019 | 102 | 2 |
244405 | 244405 | 2020-06-16 | Penobscot | Maine | 23019 | 101 | 2 |
247518 | 247518 | 2020-06-17 | Penobscot | Maine | 23019 | 101 | 2 |
250630 | 250630 | 2020-06-18 | Penobscot | Maine | 23019 | 101 | 2 |
253745 | 253745 | 2020-06-19 | Penobscot | Maine | 23019 | 102 | 2 |
256865 | 256865 | 2020-06-20 | Penobscot | Maine | 23019 | 102 | 2 |
259991 | 259991 | 2020-06-21 | Penobscot | Maine | 23019 | 102 | 2 |
263120 | 263120 | 2020-06-22 | Penobscot | Maine | 23019 | 103 | 2 |
266247 | 266247 | 2020-06-23 | Penobscot | Maine | 23019 | 104 | 2 |
269380 | 269380 | 2020-06-24 | Penobscot | Maine | 23019 | 104 | 2 |
272516 | 272516 | 2020-06-25 | Penobscot | Maine | 23019 | 105 | 2 |
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);