ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Litchfield" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 199 ✖
- 298 73
- 138 32
- 139 31
- 141 20
- 297 20
- 0 18
- 143 15
- 299 14
- 137 13
- 135 11
- 284 11
- 454 11
- 136 10
- 140 10
- 294 10
- 456 10
- 452 9
- 282 8
- 283 8
- 316 8
- 287 7
- 313 7
- 326 7
- 455 7
- 457 7
- 134 6
- 281 6
- 293 6
- 300 6
- 301 6
- 331 6
- 334 6
- 354 6
- 363 6
- 371 6
- 448 6
- 259 5
- 270 5
- 307 5
- 335 5
- 388 5
- 425 5
- 434 5
- 443 5
- 453 5
- 458 5
- 121 4
- 146 4
- 149 4
- 156 4
- 160 4
- 186 4
- 214 4
- 239 4
- 245 4
- 246 4
- 292 4
- 295 4
- 303 4
- 322 4
- 327 4
- 329 4
- 332 4
- 344 4
- 349 4
- 379 4
- 430 4
- 1 3
- 115 3
- 133 3
- 144 3
- 145 3
- 148 3
- 161 3
- 174 3
- 205 3
- 244 3
- 254 3
- 267 3
- 278 3
- 289 3
- 291 3
- 302 3
- 323 3
- 328 3
- 339 3
- 347 3
- 378 3
- 381 3
- 401 3
- 412 3
- 420 3
- 432 3
- 450 3
- 460 3
- 462 3
- 24 2
- 48 2
- 89 2
- 110 2
- 116 2
- 130 2
- 155 2
- 170 2
- 212 2
- 222 2
- 225 2
- 229 2
- 232 2
- 235 2
- 258 2
- 264 2
- 269 2
- 272 2
- 286 2
- 320 2
- 395 2
- 402 2
- 426 2
- 441 2
- 459 2
- 461 2
- 2 1
- 4 1
- 5 1
- 6 1
- 8 1
- 9 1
- 12 1
- 13 1
- 16 1
- 20 1
- 29 1
- 35 1
- 44 1
- 46 1
- 58 1
- 59 1
- 63 1
- 66 1
- 69 1
- 73 1
- 74 1
- 75 1
- 76 1
- 79 1
- 80 1
- 86 1
- 94 1
- 95 1
- 100 1
- 103 1
- 104 1
- 105 1
- 107 1
- 109 1
- 117 1
- 122 1
- 126 1
- 128 1
- 129 1
- 131 1
- 142 1
- 150 1
- 166 1
- 167 1
- 179 1
- 181 1
- 182 1
- 194 1
- 195 1
- 197 1
- 202 1
- 213 1
- 224 1
- 241 1
- 243 1
- 250 1
- 251 1
- 252 1
- 253 1
- 263 1
- 265 1
- 274 1
- 275 1
- 279 1
- 280 1
- 285 1
- 288 1
- 290 1
- 296 1
- 305 1
- 311 1
- 359 1
- 366 1
- 375 1
- 410 1
- 411 1
- 413 1
state 1
- Connecticut 793
fips 1
- 9005 793
county 1
- Litchfield · 793 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499886 | 2499886 | 2022-05-13 | Litchfield | Connecticut | 9005 | 33423 | 461 |
2496628 | 2496628 | 2022-05-12 | Litchfield | Connecticut | 9005 | 33325 | 462 |
2493370 | 2493370 | 2022-05-11 | Litchfield | Connecticut | 9005 | 33257 | 462 |
2490112 | 2490112 | 2022-05-10 | Litchfield | Connecticut | 9005 | 33166 | 462 |
2486855 | 2486855 | 2022-05-09 | Litchfield | Connecticut | 9005 | 33071 | 461 |
2483597 | 2483597 | 2022-05-08 | Litchfield | Connecticut | 9005 | 32899 | 460 |
2480339 | 2480339 | 2022-05-07 | Litchfield | Connecticut | 9005 | 32899 | 460 |
2477081 | 2477081 | 2022-05-06 | Litchfield | Connecticut | 9005 | 32899 | 460 |
2473823 | 2473823 | 2022-05-05 | Litchfield | Connecticut | 9005 | 32854 | 459 |
2470566 | 2470566 | 2022-05-04 | Litchfield | Connecticut | 9005 | 32799 | 459 |
2467310 | 2467310 | 2022-05-03 | Litchfield | Connecticut | 9005 | 32744 | 458 |
2464055 | 2464055 | 2022-05-02 | Litchfield | Connecticut | 9005 | 32649 | 458 |
2460799 | 2460799 | 2022-05-01 | Litchfield | Connecticut | 9005 | 32588 | 458 |
2457543 | 2457543 | 2022-04-30 | Litchfield | Connecticut | 9005 | 32588 | 458 |
2454287 | 2454287 | 2022-04-29 | Litchfield | Connecticut | 9005 | 32588 | 458 |
2451031 | 2451031 | 2022-04-28 | Litchfield | Connecticut | 9005 | 32550 | 457 |
2447775 | 2447775 | 2022-04-27 | Litchfield | Connecticut | 9005 | 32485 | 457 |
2444519 | 2444519 | 2022-04-26 | Litchfield | Connecticut | 9005 | 32454 | 457 |
2441263 | 2441263 | 2022-04-25 | Litchfield | Connecticut | 9005 | 32425 | 457 |
2438007 | 2438007 | 2022-04-24 | Litchfield | Connecticut | 9005 | 32317 | 457 |
2434751 | 2434751 | 2022-04-23 | Litchfield | Connecticut | 9005 | 32317 | 457 |
2431495 | 2431495 | 2022-04-22 | Litchfield | Connecticut | 9005 | 32317 | 457 |
2428239 | 2428239 | 2022-04-21 | Litchfield | Connecticut | 9005 | 32254 | 456 |
2424983 | 2424983 | 2022-04-20 | Litchfield | Connecticut | 9005 | 32219 | 456 |
2421727 | 2421727 | 2022-04-19 | Litchfield | Connecticut | 9005 | 32172 | 456 |
2418471 | 2418471 | 2022-04-18 | Litchfield | Connecticut | 9005 | 32105 | 456 |
2415215 | 2415215 | 2022-04-17 | Litchfield | Connecticut | 9005 | 32023 | 456 |
2411959 | 2411959 | 2022-04-16 | Litchfield | Connecticut | 9005 | 32023 | 456 |
2408703 | 2408703 | 2022-04-15 | Litchfield | Connecticut | 9005 | 32023 | 456 |
2405447 | 2405447 | 2022-04-14 | Litchfield | Connecticut | 9005 | 31978 | 456 |
2402192 | 2402192 | 2022-04-13 | Litchfield | Connecticut | 9005 | 31962 | 456 |
2398937 | 2398937 | 2022-04-12 | Litchfield | Connecticut | 9005 | 31929 | 456 |
2395682 | 2395682 | 2022-04-11 | Litchfield | Connecticut | 9005 | 31891 | 455 |
2392426 | 2392426 | 2022-04-10 | Litchfield | Connecticut | 9005 | 31806 | 455 |
2389170 | 2389170 | 2022-04-09 | Litchfield | Connecticut | 9005 | 31806 | 455 |
2385915 | 2385915 | 2022-04-08 | Litchfield | Connecticut | 9005 | 31806 | 455 |
2382660 | 2382660 | 2022-04-07 | Litchfield | Connecticut | 9005 | 31771 | 455 |
2379405 | 2379405 | 2022-04-06 | Litchfield | Connecticut | 9005 | 31758 | 455 |
2376151 | 2376151 | 2022-04-05 | Litchfield | Connecticut | 9005 | 31739 | 455 |
2372899 | 2372899 | 2022-04-04 | Litchfield | Connecticut | 9005 | 31731 | 454 |
2369646 | 2369646 | 2022-04-03 | Litchfield | Connecticut | 9005 | 31641 | 454 |
2366393 | 2366393 | 2022-04-02 | Litchfield | Connecticut | 9005 | 31641 | 454 |
2363140 | 2363140 | 2022-04-01 | Litchfield | Connecticut | 9005 | 31641 | 454 |
2359886 | 2359886 | 2022-03-31 | Litchfield | Connecticut | 9005 | 31625 | 454 |
2356632 | 2356632 | 2022-03-30 | Litchfield | Connecticut | 9005 | 31612 | 454 |
2353379 | 2353379 | 2022-03-29 | Litchfield | Connecticut | 9005 | 31589 | 454 |
2350127 | 2350127 | 2022-03-28 | Litchfield | Connecticut | 9005 | 31579 | 454 |
2346874 | 2346874 | 2022-03-27 | Litchfield | Connecticut | 9005 | 31521 | 454 |
2343621 | 2343621 | 2022-03-26 | Litchfield | Connecticut | 9005 | 31521 | 454 |
2340368 | 2340368 | 2022-03-25 | Litchfield | Connecticut | 9005 | 31521 | 454 |
2337115 | 2337115 | 2022-03-24 | Litchfield | Connecticut | 9005 | 31509 | 453 |
2333861 | 2333861 | 2022-03-23 | Litchfield | Connecticut | 9005 | 31498 | 453 |
2330607 | 2330607 | 2022-03-22 | Litchfield | Connecticut | 9005 | 31484 | 453 |
2327355 | 2327355 | 2022-03-21 | Litchfield | Connecticut | 9005 | 31467 | 452 |
2324102 | 2324102 | 2022-03-20 | Litchfield | Connecticut | 9005 | 31446 | 452 |
2320848 | 2320848 | 2022-03-19 | Litchfield | Connecticut | 9005 | 31446 | 452 |
2317594 | 2317594 | 2022-03-18 | Litchfield | Connecticut | 9005 | 31446 | 452 |
2314341 | 2314341 | 2022-03-17 | Litchfield | Connecticut | 9005 | 31436 | 453 |
2311088 | 2311088 | 2022-03-16 | Litchfield | Connecticut | 9005 | 31433 | 453 |
2307835 | 2307835 | 2022-03-15 | Litchfield | Connecticut | 9005 | 31408 | 452 |
2304584 | 2304584 | 2022-03-14 | Litchfield | Connecticut | 9005 | 31394 | 452 |
2301332 | 2301332 | 2022-03-13 | Litchfield | Connecticut | 9005 | 31336 | 452 |
2298080 | 2298080 | 2022-03-12 | Litchfield | Connecticut | 9005 | 31336 | 452 |
2294828 | 2294828 | 2022-03-11 | Litchfield | Connecticut | 9005 | 31336 | 452 |
2291576 | 2291576 | 2022-03-10 | Litchfield | Connecticut | 9005 | 31333 | 450 |
2288324 | 2288324 | 2022-03-09 | Litchfield | Connecticut | 9005 | 31324 | 450 |
2285073 | 2285073 | 2022-03-08 | Litchfield | Connecticut | 9005 | 31313 | 450 |
2281821 | 2281821 | 2022-03-07 | Litchfield | Connecticut | 9005 | 31306 | 448 |
2278568 | 2278568 | 2022-03-06 | Litchfield | Connecticut | 9005 | 31284 | 448 |
2275315 | 2275315 | 2022-03-05 | Litchfield | Connecticut | 9005 | 31284 | 448 |
2272062 | 2272062 | 2022-03-04 | Litchfield | Connecticut | 9005 | 31284 | 448 |
2268810 | 2268810 | 2022-03-03 | Litchfield | Connecticut | 9005 | 31275 | 448 |
2265557 | 2265557 | 2022-03-02 | Litchfield | Connecticut | 9005 | 31267 | 448 |
2262306 | 2262306 | 2022-03-01 | Litchfield | Connecticut | 9005 | 31243 | 443 |
2259055 | 2259055 | 2022-02-28 | Litchfield | Connecticut | 9005 | 31238 | 443 |
2255804 | 2255804 | 2022-02-27 | Litchfield | Connecticut | 9005 | 31207 | 443 |
2252553 | 2252553 | 2022-02-26 | Litchfield | Connecticut | 9005 | 31207 | 443 |
2249302 | 2249302 | 2022-02-25 | Litchfield | Connecticut | 9005 | 31207 | 443 |
2246051 | 2246051 | 2022-02-24 | Litchfield | Connecticut | 9005 | 31184 | 441 |
2242800 | 2242800 | 2022-02-23 | Litchfield | Connecticut | 9005 | 31169 | 441 |
2239549 | 2239549 | 2022-02-22 | Litchfield | Connecticut | 9005 | 31136 | 434 |
2236298 | 2236298 | 2022-02-21 | Litchfield | Connecticut | 9005 | 31115 | 434 |
2233047 | 2233047 | 2022-02-20 | Litchfield | Connecticut | 9005 | 31050 | 434 |
2229796 | 2229796 | 2022-02-19 | Litchfield | Connecticut | 9005 | 31050 | 434 |
2226545 | 2226545 | 2022-02-18 | Litchfield | Connecticut | 9005 | 31050 | 434 |
2223294 | 2223294 | 2022-02-17 | Litchfield | Connecticut | 9005 | 30988 | 432 |
2220043 | 2220043 | 2022-02-16 | Litchfield | Connecticut | 9005 | 30969 | 432 |
2216792 | 2216792 | 2022-02-15 | Litchfield | Connecticut | 9005 | 30746 | 432 |
2213541 | 2213541 | 2022-02-14 | Litchfield | Connecticut | 9005 | 30623 | 430 |
2210289 | 2210289 | 2022-02-13 | Litchfield | Connecticut | 9005 | 30562 | 430 |
2207036 | 2207036 | 2022-02-12 | Litchfield | Connecticut | 9005 | 30562 | 430 |
2203783 | 2203783 | 2022-02-11 | Litchfield | Connecticut | 9005 | 30562 | 430 |
2200530 | 2200530 | 2022-02-10 | Litchfield | Connecticut | 9005 | 30525 | 426 |
2197276 | 2197276 | 2022-02-09 | Litchfield | Connecticut | 9005 | 30474 | 426 |
2194022 | 2194022 | 2022-02-08 | Litchfield | Connecticut | 9005 | 30411 | 425 |
2190768 | 2190768 | 2022-02-07 | Litchfield | Connecticut | 9005 | 30349 | 425 |
2187515 | 2187515 | 2022-02-06 | Litchfield | Connecticut | 9005 | 30248 | 425 |
2184262 | 2184262 | 2022-02-05 | Litchfield | Connecticut | 9005 | 30248 | 425 |
2181010 | 2181010 | 2022-02-04 | Litchfield | Connecticut | 9005 | 30248 | 425 |
2177759 | 2177759 | 2022-02-03 | Litchfield | Connecticut | 9005 | 30193 | 420 |
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);