ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 36091 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 204 ✖
- 15 81
- 168 67
- 5 60
- 3 24
- 17 24
- 0 22
- 1 21
- 4 20
- 164 13
- 191 13
- 318 13
- 323 12
- 329 12
- 166 11
- 167 11
- 330 11
- 145 10
- 325 9
- 141 8
- 154 8
- 19 7
- 21 7
- 151 7
- 180 7
- 160 6
- 173 6
- 313 6
- 2 5
- 149 5
- 170 5
- 177 5
- 184 5
- 208 5
- 259 5
- 24 4
- 48 4
- 157 4
- 193 4
- 218 4
- 220 4
- 267 4
- 299 4
- 331 4
- 20 3
- 22 3
- 29 3
- 155 3
- 159 3
- 165 3
- 172 3
- 174 3
- 197 3
- 212 3
- 228 3
- 289 3
- 297 3
- 317 3
- 319 3
- 327 3
- 333 3
- 26 2
- 28 2
- 38 2
- 120 2
- 127 2
- 129 2
- 143 2
- 156 2
- 158 2
- 161 2
- 163 2
- 176 2
- 185 2
- 186 2
- 194 2
- 195 2
- 196 2
- 198 2
- 205 2
- 210 2
- 211 2
- 214 2
- 222 2
- 225 2
- 258 2
- 268 2
- 277 2
- 280 2
- 310 2
- 314 2
- 315 2
- 320 2
- 322 2
- 326 2
- 332 2
- 335 2
- 18 1
- 23 1
- 25 1
- 27 1
- 30 1
- 32 1
- 34 1
- 35 1
- 36 1
- 40 1
- 43 1
- 44 1
- 49 1
- 51 1
- 52 1
- 53 1
- 59 1
- 62 1
- 65 1
- 69 1
- 76 1
- 78 1
- 79 1
- 80 1
- 82 1
- 83 1
- 84 1
- 86 1
- 89 1
- 95 1
- 101 1
- 108 1
- 110 1
- 113 1
- 116 1
- 118 1
- 121 1
- 124 1
- 125 1
- 132 1
- 137 1
- 138 1
- 140 1
- 146 1
- 148 1
- 150 1
- 152 1
- 153 1
- 169 1
- 175 1
- 178 1
- 179 1
- 181 1
- 182 1
- 187 1
- 199 1
- 200 1
- 201 1
- 202 1
- 204 1
- 206 1
- 207 1
- 209 1
- 213 1
- 215 1
- 216 1
- 217 1
- 223 1
- 224 1
- 227 1
- 229 1
- 231 1
- 234 1
- 236 1
- 239 1
- 240 1
- 243 1
- 244 1
- 246 1
- 248 1
- 249 1
- 251 1
- 253 1
- 257 1
- 260 1
- 263 1
- 265 1
- 266 1
- 271 1
- 275 1
- 278 1
- 281 1
- 285 1
- 286 1
- 288 1
- 291 1
- 292 1
- 293 1
- 295 1
- 296 1
- 301 1
- 304 1
- 306 1
- 307 1
- 309 1
- 321 1
- 324 1
- 328 1
state 1
- New York 798
fips 1
- 36091 · 798 ✖
county 1
- Saratoga 798
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
718 | 718 | 2020-03-07 | Saratoga | New York | 36091 | 2 | 0 |
823 | 823 | 2020-03-08 | Saratoga | New York | 36091 | 2 | 0 |
950 | 950 | 2020-03-09 | Saratoga | New York | 36091 | 2 | 0 |
1101 | 1101 | 2020-03-10 | Saratoga | New York | 36091 | 2 | 0 |
1288 | 1288 | 2020-03-11 | Saratoga | New York | 36091 | 2 | 0 |
1525 | 1525 | 2020-03-12 | Saratoga | New York | 36091 | 3 | 0 |
1818 | 1818 | 2020-03-13 | Saratoga | New York | 36091 | 3 | 0 |
2167 | 2167 | 2020-03-14 | Saratoga | New York | 36091 | 3 | 0 |
2579 | 2579 | 2020-03-15 | Saratoga | New York | 36091 | 3 | 0 |
3040 | 3040 | 2020-03-16 | Saratoga | New York | 36091 | 5 | 0 |
3557 | 3557 | 2020-03-17 | Saratoga | New York | 36091 | 9 | 0 |
4158 | 4158 | 2020-03-18 | Saratoga | New York | 36091 | 14 | 0 |
4887 | 4887 | 2020-03-19 | Saratoga | New York | 36091 | 14 | 0 |
5738 | 5738 | 2020-03-20 | Saratoga | New York | 36091 | 24 | 0 |
6732 | 6732 | 2020-03-21 | Saratoga | New York | 36091 | 35 | 0 |
7827 | 7827 | 2020-03-22 | Saratoga | New York | 36091 | 41 | 0 |
9027 | 9027 | 2020-03-23 | Saratoga | New York | 36091 | 53 | 0 |
10335 | 10335 | 2020-03-24 | Saratoga | New York | 36091 | 60 | 0 |
11771 | 11771 | 2020-03-25 | Saratoga | New York | 36091 | 64 | 0 |
13374 | 13374 | 2020-03-26 | Saratoga | New York | 36091 | 73 | 0 |
15108 | 15108 | 2020-03-27 | Saratoga | New York | 36091 | 82 | 0 |
16938 | 16938 | 2020-03-28 | Saratoga | New York | 36091 | 96 | 0 |
18863 | 18863 | 2020-03-29 | Saratoga | New York | 36091 | 102 | 1 |
20902 | 20902 | 2020-03-30 | Saratoga | New York | 36091 | 105 | 1 |
23025 | 23025 | 2020-03-31 | Saratoga | New York | 36091 | 108 | 1 |
25219 | 25219 | 2020-04-01 | Saratoga | New York | 36091 | 122 | 1 |
27479 | 27479 | 2020-04-02 | Saratoga | New York | 36091 | 132 | 1 |
29803 | 29803 | 2020-04-03 | Saratoga | New York | 36091 | 132 | 1 |
32189 | 32189 | 2020-04-04 | Saratoga | New York | 36091 | 141 | 1 |
34620 | 34620 | 2020-04-05 | Saratoga | New York | 36091 | 148 | 1 |
37090 | 37090 | 2020-04-06 | Saratoga | New York | 36091 | 153 | 1 |
39605 | 39605 | 2020-04-07 | Saratoga | New York | 36091 | 163 | 3 |
42162 | 42162 | 2020-04-08 | Saratoga | New York | 36091 | 167 | 1 |
44745 | 44745 | 2020-04-09 | Saratoga | New York | 36091 | 172 | 1 |
47358 | 47358 | 2020-04-10 | Saratoga | New York | 36091 | 182 | 1 |
50013 | 50013 | 2020-04-11 | Saratoga | New York | 36091 | 187 | 1 |
52686 | 52686 | 2020-04-12 | Saratoga | New York | 36091 | 196 | 1 |
55369 | 55369 | 2020-04-13 | Saratoga | New York | 36091 | 201 | 1 |
58069 | 58069 | 2020-04-14 | Saratoga | New York | 36091 | 224 | 1 |
60783 | 60783 | 2020-04-15 | Saratoga | New York | 36091 | 227 | 1 |
63509 | 63509 | 2020-04-16 | Saratoga | New York | 36091 | 231 | 1 |
66251 | 66251 | 2020-04-17 | Saratoga | New York | 36091 | 236 | 1 |
69008 | 69008 | 2020-04-18 | Saratoga | New York | 36091 | 244 | 1 |
71775 | 71775 | 2020-04-19 | Saratoga | New York | 36091 | 251 | 1 |
74550 | 74550 | 2020-04-20 | Saratoga | New York | 36091 | 254 | 2 |
77331 | 77331 | 2020-04-21 | Saratoga | New York | 36091 | 257 | 2 |
80120 | 80120 | 2020-04-22 | Saratoga | New York | 36091 | 264 | 2 |
82919 | 82919 | 2020-04-23 | Saratoga | New York | 36091 | 265 | 2 |
85723 | 85723 | 2020-04-24 | Saratoga | New York | 36091 | 278 | 2 |
88535 | 88535 | 2020-04-25 | Saratoga | New York | 36091 | 320 | 3 |
91350 | 91350 | 2020-04-26 | Saratoga | New York | 36091 | 330 | 3 |
94175 | 94175 | 2020-04-27 | Saratoga | New York | 36091 | 336 | 3 |
97011 | 97011 | 2020-04-28 | Saratoga | New York | 36091 | 343 | 3 |
99858 | 99858 | 2020-04-29 | Saratoga | New York | 36091 | 346 | 3 |
102711 | 102711 | 2020-04-30 | Saratoga | New York | 36091 | 354 | 3 |
105573 | 105573 | 2020-05-01 | Saratoga | New York | 36091 | 358 | 3 |
108440 | 108440 | 2020-05-02 | Saratoga | New York | 36091 | 361 | 3 |
111313 | 111313 | 2020-05-03 | Saratoga | New York | 36091 | 363 | 3 |
114194 | 114194 | 2020-05-04 | Saratoga | New York | 36091 | 367 | 3 |
117074 | 117074 | 2020-05-05 | Saratoga | New York | 36091 | 368 | 3 |
120035 | 120035 | 2020-05-06 | Saratoga | New York | 36091 | 371 | 3 |
123010 | 123010 | 2020-05-07 | Saratoga | New York | 36091 | 374 | 3 |
125993 | 125993 | 2020-05-08 | Saratoga | New York | 36091 | 388 | 3 |
128982 | 128982 | 2020-05-09 | Saratoga | New York | 36091 | 399 | 3 |
131971 | 131971 | 2020-05-10 | Saratoga | New York | 36091 | 402 | 3 |
134962 | 134962 | 2020-05-11 | Saratoga | New York | 36091 | 403 | 3 |
137952 | 137952 | 2020-05-12 | Saratoga | New York | 36091 | 407 | 3 |
140948 | 140948 | 2020-05-13 | Saratoga | New York | 36091 | 410 | 3 |
143943 | 143943 | 2020-05-14 | Saratoga | New York | 36091 | 415 | 3 |
146944 | 146944 | 2020-05-15 | Saratoga | New York | 36091 | 421 | 3 |
149951 | 149951 | 2020-05-16 | Saratoga | New York | 36091 | 423 | 3 |
152961 | 152961 | 2020-05-17 | Saratoga | New York | 36091 | 428 | 3 |
155978 | 155978 | 2020-05-18 | Saratoga | New York | 36091 | 434 | 4 |
158996 | 158996 | 2020-05-19 | Saratoga | New York | 36091 | 436 | 4 |
162023 | 162023 | 2020-05-20 | Saratoga | New York | 36091 | 438 | 4 |
165052 | 165052 | 2020-05-21 | Saratoga | New York | 36091 | 440 | 4 |
168087 | 168087 | 2020-05-22 | Saratoga | New York | 36091 | 448 | 4 |
171126 | 171126 | 2020-05-23 | Saratoga | New York | 36091 | 452 | 4 |
174168 | 174168 | 2020-05-24 | Saratoga | New York | 36091 | 456 | 4 |
177212 | 177212 | 2020-05-25 | Saratoga | New York | 36091 | 461 | 4 |
180255 | 180255 | 2020-05-26 | Saratoga | New York | 36091 | 463 | 4 |
183303 | 183303 | 2020-05-27 | Saratoga | New York | 36091 | 465 | 4 |
186360 | 186360 | 2020-05-28 | Saratoga | New York | 36091 | 468 | 4 |
189420 | 189420 | 2020-05-29 | Saratoga | New York | 36091 | 473 | 4 |
192484 | 192484 | 2020-05-30 | Saratoga | New York | 36091 | 477 | 4 |
195554 | 195554 | 2020-05-31 | Saratoga | New York | 36091 | 480 | 4 |
198627 | 198627 | 2020-06-01 | Saratoga | New York | 36091 | 483 | 4 |
201701 | 201701 | 2020-06-02 | Saratoga | New York | 36091 | 484 | 4 |
204778 | 204778 | 2020-06-03 | Saratoga | New York | 36091 | 489 | 4 |
207859 | 207859 | 2020-06-04 | Saratoga | New York | 36091 | 493 | 4 |
210941 | 210941 | 2020-06-05 | Saratoga | New York | 36091 | 496 | 4 |
214025 | 214025 | 2020-06-06 | Saratoga | New York | 36091 | 501 | 4 |
217115 | 217115 | 2020-06-07 | Saratoga | New York | 36091 | 502 | 5 |
220207 | 220207 | 2020-06-08 | Saratoga | New York | 36091 | 504 | 5 |
223301 | 223301 | 2020-06-09 | Saratoga | New York | 36091 | 511 | 5 |
226401 | 226401 | 2020-06-10 | Saratoga | New York | 36091 | 511 | 5 |
229505 | 229505 | 2020-06-11 | Saratoga | New York | 36091 | 513 | 5 |
232610 | 232610 | 2020-06-12 | Saratoga | New York | 36091 | 514 | 5 |
235715 | 235715 | 2020-06-13 | Saratoga | New York | 36091 | 514 | 5 |
238823 | 238823 | 2020-06-14 | Saratoga | New York | 36091 | 515 | 5 |
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);