us-counties
Data source: Big Local News · About: big-local-datasette
570,096 rows sorted by county
This data as json, copyable, CSV (advanced)
| Link | rowid | date | county ▼ | state | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 280004 | 280004 | 2020-06-27 | Abbeville | South Carolina | 45001 | 103 | 0 |
| 283152 | 283152 | 2020-06-28 | Abbeville | South Carolina | 45001 | 103 | 0 |
| 286299 | 286299 | 2020-06-29 | Abbeville | South Carolina | 45001 | 106 | 0 |
| 289452 | 289452 | 2020-06-30 | Abbeville | South Carolina | 45001 | 113 | 0 |
| 292605 | 292605 | 2020-07-01 | Abbeville | South Carolina | 45001 | 113 | 0 |
| 295762 | 295762 | 2020-07-02 | Abbeville | South Carolina | 45001 | 119 | 0 |
| 298922 | 298922 | 2020-07-03 | Abbeville | South Carolina | 45001 | 118 | 0 |
| 302087 | 302087 | 2020-07-04 | Abbeville | South Carolina | 45001 | 119 | 0 |
| 305251 | 305251 | 2020-07-05 | Abbeville | South Carolina | 45001 | 124 | 0 |
| 308419 | 308419 | 2020-07-06 | Abbeville | South Carolina | 45001 | 135 | 0 |
| 311589 | 311589 | 2020-07-07 | Abbeville | South Carolina | 45001 | 134 | 1 |
| 314762 | 314762 | 2020-07-08 | Abbeville | South Carolina | 45001 | 137 | 1 |
| 317936 | 317936 | 2020-07-09 | Abbeville | South Carolina | 45001 | 138 | 1 |
| 321115 | 321115 | 2020-07-10 | Abbeville | South Carolina | 45001 | 141 | 1 |
| 324296 | 324296 | 2020-07-11 | Abbeville | South Carolina | 45001 | 150 | 1 |
| 327482 | 327482 | 2020-07-12 | Abbeville | South Carolina | 45001 | 153 | 1 |
| 330669 | 330669 | 2020-07-13 | Abbeville | South Carolina | 45001 | 157 | 1 |
| 333862 | 333862 | 2020-07-14 | Abbeville | South Carolina | 45001 | 162 | 1 |
| 337057 | 337057 | 2020-07-15 | Abbeville | South Carolina | 45001 | 165 | 1 |
| 340255 | 340255 | 2020-07-16 | Abbeville | South Carolina | 45001 | 170 | 2 |
| 343454 | 343454 | 2020-07-17 | Abbeville | South Carolina | 45001 | 176 | 2 |
| 346655 | 346655 | 2020-07-18 | Abbeville | South Carolina | 45001 | 185 | 2 |
| 349856 | 349856 | 2020-07-19 | Abbeville | South Carolina | 45001 | 190 | 2 |
| 353060 | 353060 | 2020-07-20 | Abbeville | South Carolina | 45001 | 242 | 2 |
| 356264 | 356264 | 2020-07-21 | Abbeville | South Carolina | 45001 | 246 | 2 |
| 359469 | 359469 | 2020-07-22 | Abbeville | South Carolina | 45001 | 249 | 2 |
| 362676 | 362676 | 2020-07-23 | Abbeville | South Carolina | 45001 | 255 | 2 |
| 365882 | 365882 | 2020-07-24 | Abbeville | South Carolina | 45001 | 260 | 2 |
| 369091 | 369091 | 2020-07-25 | Abbeville | South Carolina | 45001 | 264 | 4 |
| 372303 | 372303 | 2020-07-26 | Abbeville | South Carolina | 45001 | 270 | 4 |
| 375516 | 375516 | 2020-07-27 | Abbeville | South Carolina | 45001 | 272 | 4 |
| 378732 | 378732 | 2020-07-28 | Abbeville | South Carolina | 45001 | 269 | 6 |
| 381949 | 381949 | 2020-07-29 | Abbeville | South Carolina | 45001 | 279 | 6 |
| 385167 | 385167 | 2020-07-30 | Abbeville | South Carolina | 45001 | 285 | 7 |
| 388384 | 388384 | 2020-07-31 | Abbeville | South Carolina | 45001 | 282 | 7 |
| 391601 | 391601 | 2020-08-01 | Abbeville | South Carolina | 45001 | 288 | 7 |
| 394817 | 394817 | 2020-08-02 | Abbeville | South Carolina | 45001 | 290 | 7 |
| 398034 | 398034 | 2020-08-03 | Abbeville | South Carolina | 45001 | 298 | 7 |
| 401249 | 401249 | 2020-08-04 | Abbeville | South Carolina | 45001 | 301 | 8 |
| 404467 | 404467 | 2020-08-05 | Abbeville | South Carolina | 45001 | 304 | 8 |
| 407686 | 407686 | 2020-08-06 | Abbeville | South Carolina | 45001 | 313 | 8 |
| 410906 | 410906 | 2020-08-07 | Abbeville | South Carolina | 45001 | 321 | 8 |
| 414126 | 414126 | 2020-08-08 | Abbeville | South Carolina | 45001 | 325 | 8 |
| 417347 | 417347 | 2020-08-09 | Abbeville | South Carolina | 45001 | 335 | 9 |
| 420567 | 420567 | 2020-08-10 | Abbeville | South Carolina | 45001 | 335 | 9 |
| 423790 | 423790 | 2020-08-11 | Abbeville | South Carolina | 45001 | 346 | 9 |
| 427013 | 427013 | 2020-08-12 | Abbeville | South Carolina | 45001 | 354 | 9 |
| 430238 | 430238 | 2020-08-13 | Abbeville | South Carolina | 45001 | 355 | 8 |
| 433464 | 433464 | 2020-08-14 | Abbeville | South Carolina | 45001 | 353 | 8 |
| 436691 | 436691 | 2020-08-15 | Abbeville | South Carolina | 45001 | 360 | 8 |
| 439916 | 439916 | 2020-08-16 | Abbeville | South Carolina | 45001 | 362 | 8 |
| 443143 | 443143 | 2020-08-17 | Abbeville | South Carolina | 45001 | 363 | 8 |
| 446369 | 446369 | 2020-08-18 | Abbeville | South Carolina | 45001 | 366 | 8 |
| 449597 | 449597 | 2020-08-19 | Abbeville | South Carolina | 45001 | 371 | 8 |
| 452825 | 452825 | 2020-08-20 | Abbeville | South Carolina | 45001 | 376 | 8 |
| 456053 | 456053 | 2020-08-21 | Abbeville | South Carolina | 45001 | 381 | 10 |
| 459281 | 459281 | 2020-08-22 | Abbeville | South Carolina | 45001 | 385 | 10 |
| 462509 | 462509 | 2020-08-23 | Abbeville | South Carolina | 45001 | 390 | 10 |
| 465738 | 465738 | 2020-08-24 | Abbeville | South Carolina | 45001 | 392 | 10 |
| 468966 | 468966 | 2020-08-25 | Abbeville | South Carolina | 45001 | 388 | 10 |
| 472198 | 472198 | 2020-08-26 | Abbeville | South Carolina | 45001 | 393 | 10 |
| 475432 | 475432 | 2020-08-27 | Abbeville | South Carolina | 45001 | 394 | 10 |
| 478665 | 478665 | 2020-08-28 | Abbeville | South Carolina | 45001 | 404 | 10 |
| 481899 | 481899 | 2020-08-29 | Abbeville | South Carolina | 45001 | 406 | 10 |
| 485134 | 485134 | 2020-08-30 | Abbeville | South Carolina | 45001 | 415 | 10 |
| 488367 | 488367 | 2020-08-31 | Abbeville | South Carolina | 45001 | 418 | 10 |
| 491600 | 491600 | 2020-09-01 | Abbeville | South Carolina | 45001 | 434 | 10 |
| 494834 | 494834 | 2020-09-02 | Abbeville | South Carolina | 45001 | 439 | 10 |
| 498067 | 498067 | 2020-09-03 | Abbeville | South Carolina | 45001 | 450 | 10 |
| 501301 | 501301 | 2020-09-04 | Abbeville | South Carolina | 45001 | 463 | 10 |
| 504535 | 504535 | 2020-09-05 | Abbeville | South Carolina | 45001 | 462 | 11 |
| 507767 | 507767 | 2020-09-06 | Abbeville | South Carolina | 45001 | 464 | 11 |
| 511000 | 511000 | 2020-09-07 | Abbeville | South Carolina | 45001 | 469 | 11 |
| 514233 | 514233 | 2020-09-08 | Abbeville | South Carolina | 45001 | 467 | 11 |
| 517468 | 517468 | 2020-09-09 | Abbeville | South Carolina | 45001 | 467 | 11 |
| 520704 | 520704 | 2020-09-10 | Abbeville | South Carolina | 45001 | 469 | 12 |
| 523940 | 523940 | 2020-09-11 | Abbeville | South Carolina | 45001 | 478 | 12 |
| 527176 | 527176 | 2020-09-12 | Abbeville | South Carolina | 45001 | 488 | 12 |
| 530413 | 530413 | 2020-09-13 | Abbeville | South Carolina | 45001 | 491 | 12 |
| 533648 | 533648 | 2020-09-14 | Abbeville | South Carolina | 45001 | 492 | 12 |
| 536884 | 536884 | 2020-09-15 | Abbeville | South Carolina | 45001 | 498 | 12 |
| 540121 | 540121 | 2020-09-16 | Abbeville | South Carolina | 45001 | 500 | 12 |
| 543357 | 543357 | 2020-09-17 | Abbeville | South Carolina | 45001 | 515 | 12 |
| 546594 | 546594 | 2020-09-18 | Abbeville | South Carolina | 45001 | 530 | 12 |
| 549833 | 549833 | 2020-09-19 | Abbeville | South Carolina | 45001 | 530 | 12 |
| 553072 | 553072 | 2020-09-20 | Abbeville | South Carolina | 45001 | 531 | 12 |
| 556309 | 556309 | 2020-09-21 | Abbeville | South Carolina | 45001 | 532 | 12 |
| 559546 | 559546 | 2020-09-22 | Abbeville | South Carolina | 45001 | 538 | 11 |
| 562783 | 562783 | 2020-09-23 | Abbeville | South Carolina | 45001 | 548 | 12 |
| 566024 | 566024 | 2020-09-24 | Abbeville | South Carolina | 45001 | 553 | 12 |
| 569265 | 569265 | 2020-09-25 | Abbeville | South Carolina | 45001 | 569 | 12 |
| 7519 | 7519 | 2020-03-22 | Acadia | Louisiana | 22001 | 1 | 0 |
| 8682 | 8682 | 2020-03-23 | Acadia | Louisiana | 22001 | 1 | 0 |
| 9970 | 9970 | 2020-03-24 | Acadia | Louisiana | 22001 | 2 | 0 |
| 11374 | 11374 | 2020-03-25 | Acadia | Louisiana | 22001 | 2 | 0 |
| 12949 | 12949 | 2020-03-26 | Acadia | Louisiana | 22001 | 3 | 0 |
| 14656 | 14656 | 2020-03-27 | Acadia | Louisiana | 22001 | 8 | 1 |
| 16474 | 16474 | 2020-03-28 | Acadia | Louisiana | 22001 | 9 | 1 |
| 18386 | 18386 | 2020-03-29 | Acadia | Louisiana | 22001 | 9 | 1 |
| 20402 | 20402 | 2020-03-30 | Acadia | Louisiana | 22001 | 11 | 1 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );