us-counties
Data source: Big Local News · About: big-local-datasette
570,096 rows
This data as json, copyable, CSV (advanced)
| Link | rowid ▼ | date | county | state | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 301 | 301 | 2020-02-25 | Orange | California | 6059 | 1 | 0 |
| 302 | 302 | 2020-02-25 | Sacramento | California | 6067 | 1 | 0 |
| 303 | 303 | 2020-02-25 | San Diego | California | 6073 | 1 | 0 |
| 304 | 304 | 2020-02-25 | San Francisco | California | 6075 | 3 | 0 |
| 305 | 305 | 2020-02-25 | Santa Clara | California | 6085 | 2 | 0 |
| 306 | 306 | 2020-02-25 | Solano | California | 6095 | 1 | 0 |
| 307 | 307 | 2020-02-25 | Cook | Illinois | 17031 | 2 | 0 |
| 308 | 308 | 2020-02-25 | Suffolk | Massachusetts | 25025 | 1 | 0 |
| 309 | 309 | 2020-02-25 | Douglas | Nebraska | 31055 | 13 | 0 |
| 310 | 310 | 2020-02-25 | Bexar | Texas | 48029 | 10 | 0 |
| 311 | 311 | 2020-02-25 | Salt Lake | Utah | 49035 | 1 | 0 |
| 312 | 312 | 2020-02-25 | Snohomish | Washington | 53061 | 1 | 0 |
| 313 | 313 | 2020-02-25 | Spokane | Washington | 53063 | 4 | 0 |
| 314 | 314 | 2020-02-25 | Dane | Wisconsin | 55025 | 1 | 0 |
| 315 | 315 | 2020-02-26 | Maricopa | Arizona | 4013 | 1 | 0 |
| 316 | 316 | 2020-02-26 | Humboldt | California | 6023 | 1 | 0 |
| 317 | 317 | 2020-02-26 | Los Angeles | California | 6037 | 1 | 0 |
| 318 | 318 | 2020-02-26 | Marin | California | 6041 | 1 | 0 |
| 319 | 319 | 2020-02-26 | Napa | California | 6055 | 1 | 0 |
| 320 | 320 | 2020-02-26 | Orange | California | 6059 | 1 | 0 |
| 321 | 321 | 2020-02-26 | Sacramento | California | 6067 | 3 | 0 |
| 322 | 322 | 2020-02-26 | San Diego | California | 6073 | 1 | 0 |
| 323 | 323 | 2020-02-26 | San Francisco | California | 6075 | 3 | 0 |
| 324 | 324 | 2020-02-26 | Santa Clara | California | 6085 | 2 | 0 |
| 325 | 325 | 2020-02-26 | Solano | California | 6095 | 11 | 0 |
| 326 | 326 | 2020-02-26 | Sonoma | California | 6097 | 1 | 0 |
| 327 | 327 | 2020-02-26 | Cook | Illinois | 17031 | 2 | 0 |
| 328 | 328 | 2020-02-26 | Suffolk | Massachusetts | 25025 | 1 | 0 |
| 329 | 329 | 2020-02-26 | Douglas | Nebraska | 31055 | 13 | 0 |
| 330 | 330 | 2020-02-26 | Bexar | Texas | 48029 | 10 | 0 |
| 331 | 331 | 2020-02-26 | Salt Lake | Utah | 49035 | 1 | 0 |
| 332 | 332 | 2020-02-26 | Snohomish | Washington | 53061 | 1 | 0 |
| 333 | 333 | 2020-02-26 | Spokane | Washington | 53063 | 4 | 0 |
| 334 | 334 | 2020-02-26 | Dane | Wisconsin | 55025 | 1 | 0 |
| 335 | 335 | 2020-02-27 | Maricopa | Arizona | 4013 | 1 | 0 |
| 336 | 336 | 2020-02-27 | Humboldt | California | 6023 | 1 | 0 |
| 337 | 337 | 2020-02-27 | Los Angeles | California | 6037 | 1 | 0 |
| 338 | 338 | 2020-02-27 | Marin | California | 6041 | 1 | 0 |
| 339 | 339 | 2020-02-27 | Napa | California | 6055 | 1 | 0 |
| 340 | 340 | 2020-02-27 | Orange | California | 6059 | 1 | 0 |
| 341 | 341 | 2020-02-27 | Sacramento | California | 6067 | 3 | 0 |
| 342 | 342 | 2020-02-27 | San Diego | California | 6073 | 1 | 0 |
| 343 | 343 | 2020-02-27 | San Francisco | California | 6075 | 3 | 0 |
| 344 | 344 | 2020-02-27 | Santa Clara | California | 6085 | 2 | 0 |
| 345 | 345 | 2020-02-27 | Solano | California | 6095 | 11 | 0 |
| 346 | 346 | 2020-02-27 | Sonoma | California | 6097 | 1 | 0 |
| 347 | 347 | 2020-02-27 | Cook | Illinois | 17031 | 2 | 0 |
| 348 | 348 | 2020-02-27 | Suffolk | Massachusetts | 25025 | 1 | 0 |
| 349 | 349 | 2020-02-27 | Douglas | Nebraska | 31055 | 13 | 0 |
| 350 | 350 | 2020-02-27 | Bexar | Texas | 48029 | 10 | 0 |
| 351 | 351 | 2020-02-27 | Salt Lake | Utah | 49035 | 1 | 0 |
| 352 | 352 | 2020-02-27 | Snohomish | Washington | 53061 | 1 | 0 |
| 353 | 353 | 2020-02-27 | Spokane | Washington | 53063 | 4 | 0 |
| 354 | 354 | 2020-02-27 | Dane | Wisconsin | 55025 | 1 | 0 |
| 355 | 355 | 2020-02-28 | Maricopa | Arizona | 4013 | 1 | 0 |
| 356 | 356 | 2020-02-28 | Humboldt | California | 6023 | 1 | 0 |
| 357 | 357 | 2020-02-28 | Los Angeles | California | 6037 | 1 | 0 |
| 358 | 358 | 2020-02-28 | Marin | California | 6041 | 1 | 0 |
| 359 | 359 | 2020-02-28 | Napa | California | 6055 | 1 | 0 |
| 360 | 360 | 2020-02-28 | Orange | California | 6059 | 1 | 0 |
| 361 | 361 | 2020-02-28 | Sacramento | California | 6067 | 3 | 0 |
| 362 | 362 | 2020-02-28 | San Diego | California | 6073 | 1 | 0 |
| 363 | 363 | 2020-02-28 | San Francisco | California | 6075 | 3 | 0 |
| 364 | 364 | 2020-02-28 | Santa Clara | California | 6085 | 3 | 0 |
| 365 | 365 | 2020-02-28 | Solano | California | 6095 | 11 | 0 |
| 366 | 366 | 2020-02-28 | Sonoma | California | 6097 | 1 | 0 |
| 367 | 367 | 2020-02-28 | Cook | Illinois | 17031 | 2 | 0 |
| 368 | 368 | 2020-02-28 | Suffolk | Massachusetts | 25025 | 1 | 0 |
| 369 | 369 | 2020-02-28 | Douglas | Nebraska | 31055 | 13 | 0 |
| 370 | 370 | 2020-02-28 | Washington | Oregon | 41067 | 1 | 0 |
| 371 | 371 | 2020-02-28 | Bexar | Texas | 48029 | 11 | 0 |
| 372 | 372 | 2020-02-28 | Salt Lake | Utah | 49035 | 1 | 0 |
| 373 | 373 | 2020-02-28 | King | Washington | 53033 | 1 | 0 |
| 374 | 374 | 2020-02-28 | Snohomish | Washington | 53061 | 2 | 0 |
| 375 | 375 | 2020-02-28 | Spokane | Washington | 53063 | 4 | 0 |
| 376 | 376 | 2020-02-28 | Dane | Wisconsin | 55025 | 1 | 0 |
| 377 | 377 | 2020-02-29 | Maricopa | Arizona | 4013 | 1 | 0 |
| 378 | 378 | 2020-02-29 | Humboldt | California | 6023 | 1 | 0 |
| 379 | 379 | 2020-02-29 | Los Angeles | California | 6037 | 1 | 0 |
| 380 | 380 | 2020-02-29 | Marin | California | 6041 | 1 | 0 |
| 381 | 381 | 2020-02-29 | Napa | California | 6055 | 1 | 0 |
| 382 | 382 | 2020-02-29 | Orange | California | 6059 | 1 | 0 |
| 383 | 383 | 2020-02-29 | Sacramento | California | 6067 | 3 | 0 |
| 384 | 384 | 2020-02-29 | San Diego | California | 6073 | 1 | 0 |
| 385 | 385 | 2020-02-29 | San Francisco | California | 6075 | 3 | 0 |
| 386 | 386 | 2020-02-29 | Santa Clara | California | 6085 | 4 | 0 |
| 387 | 387 | 2020-02-29 | Solano | California | 6095 | 11 | 0 |
| 388 | 388 | 2020-02-29 | Sonoma | California | 6097 | 1 | 0 |
| 389 | 389 | 2020-02-29 | Cook | Illinois | 17031 | 3 | 0 |
| 390 | 390 | 2020-02-29 | Suffolk | Massachusetts | 25025 | 1 | 0 |
| 391 | 391 | 2020-02-29 | Douglas | Nebraska | 31055 | 13 | 0 |
| 392 | 392 | 2020-02-29 | Washington | Oregon | 41067 | 1 | 0 |
| 393 | 393 | 2020-02-29 | Bexar | Texas | 48029 | 11 | 0 |
| 394 | 394 | 2020-02-29 | Salt Lake | Utah | 49035 | 1 | 0 |
| 395 | 395 | 2020-02-29 | King | Washington | 53033 | 4 | 1 |
| 396 | 396 | 2020-02-29 | Snohomish | Washington | 53061 | 2 | 0 |
| 397 | 397 | 2020-02-29 | Spokane | Washington | 53063 | 4 | 0 |
| 398 | 398 | 2020-02-29 | Dane | Wisconsin | 55025 | 1 | 0 |
| 399 | 399 | 2020-03-01 | Maricopa | Arizona | 4013 | 1 | 0 |
| 400 | 400 | 2020-03-01 | Alameda | California | 6001 | 1 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );