ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 36111 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 213 ✖
- 49 49
- 84 40
- 257 39
- 258 35
- 360 33
- 363 22
- 0 21
- 47 19
- 81 17
- 82 16
- 2 14
- 87 14
- 251 14
- 287 13
- 233 12
- 361 12
- 286 11
- 359 11
- 241 10
- 3 9
- 83 9
- 239 8
- 276 7
- 226 6
- 236 6
- 249 6
- 268 6
- 271 6
- 275 6
- 45 5
- 86 5
- 93 5
- 94 5
- 228 5
- 250 5
- 260 5
- 270 5
- 4 4
- 220 4
- 252 4
- 254 4
- 256 4
- 273 4
- 278 4
- 280 4
- 312 4
- 316 4
- 354 4
- 43 3
- 44 3
- 85 3
- 90 3
- 262 3
- 263 3
- 264 3
- 274 3
- 283 3
- 288 3
- 293 3
- 305 3
- 309 3
- 314 3
- 326 3
- 329 3
- 1 2
- 5 2
- 12 2
- 37 2
- 89 2
- 108 2
- 116 2
- 118 2
- 135 2
- 136 2
- 140 2
- 151 2
- 175 2
- 199 2
- 205 2
- 212 2
- 218 2
- 221 2
- 224 2
- 227 2
- 234 2
- 237 2
- 247 2
- 255 2
- 259 2
- 265 2
- 267 2
- 277 2
- 290 2
- 291 2
- 294 2
- 298 2
- 299 2
- 302 2
- 313 2
- 317 2
- 323 2
- 340 2
- 344 2
- 348 2
- 350 2
- 352 2
- 353 2
- 356 2
- 357 2
- 6 1
- 7 1
- 9 1
- 10 1
- 11 1
- 26 1
- 27 1
- 28 1
- 29 1
- 30 1
- 32 1
- 35 1
- 39 1
- 41 1
- 42 1
- 46 1
- 88 1
- 92 1
- 95 1
- 100 1
- 103 1
- 104 1
- 111 1
- 114 1
- 120 1
- 125 1
- 129 1
- 131 1
- 132 1
- 134 1
- 138 1
- 139 1
- 141 1
- 143 1
- 145 1
- 146 1
- 149 1
- 154 1
- 158 1
- 165 1
- 167 1
- 170 1
- 179 1
- 183 1
- 186 1
- 189 1
- 191 1
- 192 1
- 196 1
- 200 1
- 202 1
- 204 1
- 207 1
- 208 1
- 209 1
- 210 1
- 211 1
- 213 1
- 214 1
- 215 1
- 217 1
- 223 1
- 229 1
- 230 1
- 231 1
- 232 1
- 235 1
- 238 1
- 240 1
- 243 1
- 244 1
- 245 1
- 246 1
- 248 1
- 261 1
- 272 1
- 282 1
- 284 1
- 292 1
- 295 1
- 296 1
- 297 1
- 303 1
- 304 1
- 306 1
- 308 1
- 310 1
- 311 1
- 315 1
- 319 1
- 320 1
- 324 1
- 331 1
- 333 1
- 334 1
- 341 1
- 343 1
- 346 1
- 347 1
- 349 1
- 355 1
- 362 1
- 364 1
- 365 1
state 1
- New York 797
fips 1
- 36111 · 797 ✖
county 1
- Ulster 797
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
825 | 825 | 2020-03-08 | Ulster | New York | 36111 | 1 | 0 |
952 | 952 | 2020-03-09 | Ulster | New York | 36111 | 1 | 0 |
1103 | 1103 | 2020-03-10 | Ulster | New York | 36111 | 1 | 0 |
1290 | 1290 | 2020-03-11 | Ulster | New York | 36111 | 2 | 0 |
1527 | 1527 | 2020-03-12 | Ulster | New York | 36111 | 4 | 0 |
1821 | 1821 | 2020-03-13 | Ulster | New York | 36111 | 5 | 0 |
2172 | 2172 | 2020-03-14 | Ulster | New York | 36111 | 5 | 0 |
2584 | 2584 | 2020-03-15 | Ulster | New York | 36111 | 5 | 0 |
3045 | 3045 | 2020-03-16 | Ulster | New York | 36111 | 7 | 0 |
3563 | 3563 | 2020-03-17 | Ulster | New York | 36111 | 8 | 0 |
4164 | 4164 | 2020-03-18 | Ulster | New York | 36111 | 9 | 0 |
4894 | 4894 | 2020-03-19 | Ulster | New York | 36111 | 12 | 0 |
5745 | 5745 | 2020-03-20 | Ulster | New York | 36111 | 12 | 0 |
6740 | 6740 | 2020-03-21 | Ulster | New York | 36111 | 18 | 0 |
7836 | 7836 | 2020-03-22 | Ulster | New York | 36111 | 26 | 0 |
9036 | 9036 | 2020-03-23 | Ulster | New York | 36111 | 35 | 0 |
10344 | 10344 | 2020-03-24 | Ulster | New York | 36111 | 47 | 0 |
11780 | 11780 | 2020-03-25 | Ulster | New York | 36111 | 65 | 0 |
13383 | 13383 | 2020-03-26 | Ulster | New York | 36111 | 89 | 0 |
15117 | 15117 | 2020-03-27 | Ulster | New York | 36111 | 98 | 0 |
16948 | 16948 | 2020-03-28 | Ulster | New York | 36111 | 128 | 0 |
18873 | 18873 | 2020-03-29 | Ulster | New York | 36111 | 179 | 1 |
20912 | 20912 | 2020-03-30 | Ulster | New York | 36111 | 207 | 1 |
23036 | 23036 | 2020-03-31 | Ulster | New York | 36111 | 215 | 3 |
25230 | 25230 | 2020-04-01 | Ulster | New York | 36111 | 222 | 3 |
27490 | 27490 | 2020-04-02 | Ulster | New York | 36111 | 243 | 3 |
29814 | 29814 | 2020-04-03 | Ulster | New York | 36111 | 243 | 3 |
32200 | 32200 | 2020-04-04 | Ulster | New York | 36111 | 318 | 4 |
34631 | 34631 | 2020-04-05 | Ulster | New York | 36111 | 358 | 4 |
37101 | 37101 | 2020-04-06 | Ulster | New York | 36111 | 382 | 4 |
39616 | 39616 | 2020-04-07 | Ulster | New York | 36111 | 402 | 5 |
42173 | 42173 | 2020-04-08 | Ulster | New York | 36111 | 422 | 2 |
44756 | 44756 | 2020-04-09 | Ulster | New York | 36111 | 460 | 2 |
47369 | 47369 | 2020-04-10 | Ulster | New York | 36111 | 530 | 2 |
50024 | 50024 | 2020-04-11 | Ulster | New York | 36111 | 589 | 2 |
52697 | 52697 | 2020-04-12 | Ulster | New York | 36111 | 612 | 2 |
55380 | 55380 | 2020-04-13 | Ulster | New York | 36111 | 630 | 2 |
58080 | 58080 | 2020-04-14 | Ulster | New York | 36111 | 690 | 2 |
60794 | 60794 | 2020-04-15 | Ulster | New York | 36111 | 733 | 2 |
63520 | 63520 | 2020-04-16 | Ulster | New York | 36111 | 761 | 2 |
66262 | 66262 | 2020-04-17 | Ulster | New York | 36111 | 788 | 2 |
69019 | 69019 | 2020-04-18 | Ulster | New York | 36111 | 820 | 2 |
71786 | 71786 | 2020-04-19 | Ulster | New York | 36111 | 854 | 2 |
74561 | 74561 | 2020-04-20 | Ulster | New York | 36111 | 877 | 2 |
77342 | 77342 | 2020-04-21 | Ulster | New York | 36111 | 893 | 2 |
80131 | 80131 | 2020-04-22 | Ulster | New York | 36111 | 913 | 3 |
82930 | 82930 | 2020-04-23 | Ulster | New York | 36111 | 942 | 3 |
85734 | 85734 | 2020-04-24 | Ulster | New York | 36111 | 976 | 3 |
88546 | 88546 | 2020-04-25 | Ulster | New York | 36111 | 1166 | 3 |
91361 | 91361 | 2020-04-26 | Ulster | New York | 36111 | 1190 | 3 |
94186 | 94186 | 2020-04-27 | Ulster | New York | 36111 | 1219 | 4 |
97022 | 97022 | 2020-04-28 | Ulster | New York | 36111 | 1230 | 5 |
99869 | 99869 | 2020-04-29 | Ulster | New York | 36111 | 1252 | 6 |
102722 | 102722 | 2020-04-30 | Ulster | New York | 36111 | 1279 | 7 |
105584 | 105584 | 2020-05-01 | Ulster | New York | 36111 | 1298 | 9 |
108451 | 108451 | 2020-05-02 | Ulster | New York | 36111 | 1327 | 10 |
111324 | 111324 | 2020-05-03 | Ulster | New York | 36111 | 1341 | 11 |
114205 | 114205 | 2020-05-04 | Ulster | New York | 36111 | 1354 | 12 |
117085 | 117085 | 2020-05-05 | Ulster | New York | 36111 | 1357 | 12 |
120046 | 120046 | 2020-05-06 | Ulster | New York | 36111 | 1383 | 26 |
123021 | 123021 | 2020-05-07 | Ulster | New York | 36111 | 1416 | 27 |
126004 | 126004 | 2020-05-08 | Ulster | New York | 36111 | 1429 | 28 |
128993 | 128993 | 2020-05-09 | Ulster | New York | 36111 | 1440 | 29 |
131982 | 131982 | 2020-05-10 | Ulster | New York | 36111 | 1450 | 30 |
134973 | 134973 | 2020-05-11 | Ulster | New York | 36111 | 1454 | 32 |
137963 | 137963 | 2020-05-12 | Ulster | New York | 36111 | 1465 | 35 |
140959 | 140959 | 2020-05-13 | Ulster | New York | 36111 | 1481 | 37 |
143954 | 143954 | 2020-05-14 | Ulster | New York | 36111 | 1495 | 37 |
146955 | 146955 | 2020-05-15 | Ulster | New York | 36111 | 1511 | 39 |
149962 | 149962 | 2020-05-16 | Ulster | New York | 36111 | 1537 | 41 |
152972 | 152972 | 2020-05-17 | Ulster | New York | 36111 | 1552 | 42 |
155989 | 155989 | 2020-05-18 | Ulster | New York | 36111 | 1557 | 43 |
159007 | 159007 | 2020-05-19 | Ulster | New York | 36111 | 1565 | 43 |
162034 | 162034 | 2020-05-20 | Ulster | New York | 36111 | 1571 | 43 |
165063 | 165063 | 2020-05-21 | Ulster | New York | 36111 | 1584 | 44 |
168098 | 168098 | 2020-05-22 | Ulster | New York | 36111 | 1595 | 44 |
171137 | 171137 | 2020-05-23 | Ulster | New York | 36111 | 1606 | 44 |
174179 | 174179 | 2020-05-24 | Ulster | New York | 36111 | 1617 | 45 |
177223 | 177223 | 2020-05-25 | Ulster | New York | 36111 | 1632 | 45 |
180266 | 180266 | 2020-05-26 | Ulster | New York | 36111 | 1638 | 45 |
183314 | 183314 | 2020-05-27 | Ulster | New York | 36111 | 1645 | 45 |
186371 | 186371 | 2020-05-28 | Ulster | New York | 36111 | 1658 | 45 |
189431 | 189431 | 2020-05-29 | Ulster | New York | 36111 | 1663 | 46 |
192495 | 192495 | 2020-05-30 | Ulster | New York | 36111 | 1678 | 47 |
195565 | 195565 | 2020-05-31 | Ulster | New York | 36111 | 1685 | 47 |
198638 | 198638 | 2020-06-01 | Ulster | New York | 36111 | 1691 | 47 |
201712 | 201712 | 2020-06-02 | Ulster | New York | 36111 | 1696 | 47 |
204789 | 204789 | 2020-06-03 | Ulster | New York | 36111 | 1701 | 47 |
207870 | 207870 | 2020-06-04 | Ulster | New York | 36111 | 1704 | 47 |
210952 | 210952 | 2020-06-05 | Ulster | New York | 36111 | 1711 | 47 |
214036 | 214036 | 2020-06-06 | Ulster | New York | 36111 | 1714 | 47 |
217126 | 217126 | 2020-06-07 | Ulster | New York | 36111 | 1718 | 47 |
220218 | 220218 | 2020-06-08 | Ulster | New York | 36111 | 1721 | 47 |
223312 | 223312 | 2020-06-09 | Ulster | New York | 36111 | 1724 | 47 |
226412 | 226412 | 2020-06-10 | Ulster | New York | 36111 | 1726 | 47 |
229516 | 229516 | 2020-06-11 | Ulster | New York | 36111 | 1729 | 47 |
232621 | 232621 | 2020-06-12 | Ulster | New York | 36111 | 1734 | 47 |
235726 | 235726 | 2020-06-13 | Ulster | New York | 36111 | 1739 | 47 |
238834 | 238834 | 2020-06-14 | Ulster | New York | 36111 | 1741 | 47 |
241943 | 241943 | 2020-06-15 | Ulster | New York | 36111 | 1741 | 47 |
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);