us-counties
Data source: Big Local News · About: big-local-datasette
570,096 rows sorted by fips
This data as json, copyable, CSV (advanced)
| Link | rowid | date | county | state | fips ▼ | cases | deaths |
|---|---|---|---|---|---|---|---|
| 293416 | 293416 | 2020-07-02 | Autauga | Alabama | 1001 | 561 | 13 |
| 296572 | 296572 | 2020-07-03 | Autauga | Alabama | 1001 | 568 | 13 |
| 299735 | 299735 | 2020-07-04 | Autauga | Alabama | 1001 | 591 | 13 |
| 302900 | 302900 | 2020-07-05 | Autauga | Alabama | 1001 | 615 | 13 |
| 306065 | 306065 | 2020-07-06 | Autauga | Alabama | 1001 | 618 | 13 |
| 309235 | 309235 | 2020-07-07 | Autauga | Alabama | 1001 | 644 | 13 |
| 312405 | 312405 | 2020-07-08 | Autauga | Alabama | 1001 | 651 | 13 |
| 315581 | 315581 | 2020-07-09 | Autauga | Alabama | 1001 | 661 | 14 |
| 318755 | 318755 | 2020-07-10 | Autauga | Alabama | 1001 | 670 | 15 |
| 321935 | 321935 | 2020-07-11 | Autauga | Alabama | 1001 | 684 | 15 |
| 325117 | 325117 | 2020-07-12 | Autauga | Alabama | 1001 | 706 | 16 |
| 328304 | 328304 | 2020-07-13 | Autauga | Alabama | 1001 | 728 | 16 |
| 331491 | 331491 | 2020-07-14 | Autauga | Alabama | 1001 | 746 | 18 |
| 334685 | 334685 | 2020-07-15 | Autauga | Alabama | 1001 | 756 | 19 |
| 337881 | 337881 | 2020-07-16 | Autauga | Alabama | 1001 | 780 | 20 |
| 341078 | 341078 | 2020-07-17 | Autauga | Alabama | 1001 | 789 | 21 |
| 344278 | 344278 | 2020-07-18 | Autauga | Alabama | 1001 | 827 | 21 |
| 347479 | 347479 | 2020-07-19 | Autauga | Alabama | 1001 | 842 | 21 |
| 350681 | 350681 | 2020-07-20 | Autauga | Alabama | 1001 | 857 | 21 |
| 353884 | 353884 | 2020-07-21 | Autauga | Alabama | 1001 | 865 | 21 |
| 357088 | 357088 | 2020-07-22 | Autauga | Alabama | 1001 | 886 | 21 |
| 360294 | 360294 | 2020-07-23 | Autauga | Alabama | 1001 | 905 | 21 |
| 363501 | 363501 | 2020-07-24 | Autauga | Alabama | 1001 | 921 | 21 |
| 366708 | 366708 | 2020-07-25 | Autauga | Alabama | 1001 | 932 | 21 |
| 369918 | 369918 | 2020-07-26 | Autauga | Alabama | 1001 | 942 | 21 |
| 373130 | 373130 | 2020-07-27 | Autauga | Alabama | 1001 | 965 | 21 |
| 376344 | 376344 | 2020-07-28 | Autauga | Alabama | 1001 | 974 | 21 |
| 379560 | 379560 | 2020-07-29 | Autauga | Alabama | 1001 | 987 | 21 |
| 382777 | 382777 | 2020-07-30 | Autauga | Alabama | 1001 | 1002 | 21 |
| 385995 | 385995 | 2020-07-31 | Autauga | Alabama | 1001 | 1015 | 21 |
| 389212 | 389212 | 2020-08-01 | Autauga | Alabama | 1001 | 1030 | 21 |
| 392429 | 392429 | 2020-08-02 | Autauga | Alabama | 1001 | 1052 | 21 |
| 395645 | 395645 | 2020-08-03 | Autauga | Alabama | 1001 | 1066 | 21 |
| 398861 | 398861 | 2020-08-04 | Autauga | Alabama | 1001 | 1073 | 21 |
| 402077 | 402077 | 2020-08-05 | Autauga | Alabama | 1001 | 1073 | 22 |
| 405295 | 405295 | 2020-08-06 | Autauga | Alabama | 1001 | 1096 | 22 |
| 408515 | 408515 | 2020-08-07 | Autauga | Alabama | 1001 | 1113 | 22 |
| 411734 | 411734 | 2020-08-08 | Autauga | Alabama | 1001 | 1134 | 22 |
| 414954 | 414954 | 2020-08-09 | Autauga | Alabama | 1001 | 1217 | 22 |
| 418175 | 418175 | 2020-08-10 | Autauga | Alabama | 1001 | 1222 | 22 |
| 421396 | 421396 | 2020-08-11 | Autauga | Alabama | 1001 | 1215 | 23 |
| 424617 | 424617 | 2020-08-12 | Autauga | Alabama | 1001 | 1241 | 23 |
| 427841 | 427841 | 2020-08-13 | Autauga | Alabama | 1001 | 1250 | 23 |
| 431069 | 431069 | 2020-08-14 | Autauga | Alabama | 1001 | 1252 | 23 |
| 434294 | 434294 | 2020-08-15 | Autauga | Alabama | 1001 | 1262 | 23 |
| 437520 | 437520 | 2020-08-16 | Autauga | Alabama | 1001 | 1273 | 23 |
| 440746 | 440746 | 2020-08-17 | Autauga | Alabama | 1001 | 1274 | 23 |
| 443972 | 443972 | 2020-08-18 | Autauga | Alabama | 1001 | 1291 | 23 |
| 447199 | 447199 | 2020-08-19 | Autauga | Alabama | 1001 | 1298 | 23 |
| 450427 | 450427 | 2020-08-20 | Autauga | Alabama | 1001 | 1298 | 23 |
| 453655 | 453655 | 2020-08-21 | Autauga | Alabama | 1001 | 1313 | 23 |
| 456883 | 456883 | 2020-08-22 | Autauga | Alabama | 1001 | 1322 | 23 |
| 460110 | 460110 | 2020-08-23 | Autauga | Alabama | 1001 | 1324 | 23 |
| 463339 | 463339 | 2020-08-24 | Autauga | Alabama | 1001 | 1351 | 23 |
| 466568 | 466568 | 2020-08-25 | Autauga | Alabama | 1001 | 1355 | 23 |
| 469797 | 469797 | 2020-08-26 | Autauga | Alabama | 1001 | 1366 | 23 |
| 473029 | 473029 | 2020-08-27 | Autauga | Alabama | 1001 | 1377 | 23 |
| 476262 | 476262 | 2020-08-28 | Autauga | Alabama | 1001 | 1389 | 23 |
| 479495 | 479495 | 2020-08-29 | Autauga | Alabama | 1001 | 1400 | 23 |
| 482729 | 482729 | 2020-08-30 | Autauga | Alabama | 1001 | 1438 | 23 |
| 485964 | 485964 | 2020-08-31 | Autauga | Alabama | 1001 | 1442 | 23 |
| 489197 | 489197 | 2020-09-01 | Autauga | Alabama | 1001 | 1453 | 24 |
| 492430 | 492430 | 2020-09-02 | Autauga | Alabama | 1001 | 1452 | 24 |
| 495664 | 495664 | 2020-09-03 | Autauga | Alabama | 1001 | 1466 | 24 |
| 498897 | 498897 | 2020-09-04 | Autauga | Alabama | 1001 | 1475 | 24 |
| 502131 | 502131 | 2020-09-05 | Autauga | Alabama | 1001 | 1492 | 24 |
| 505365 | 505365 | 2020-09-06 | Autauga | Alabama | 1001 | 1498 | 24 |
| 508597 | 508597 | 2020-09-07 | Autauga | Alabama | 1001 | 1504 | 24 |
| 511830 | 511830 | 2020-09-08 | Autauga | Alabama | 1001 | 1508 | 24 |
| 515063 | 515063 | 2020-09-09 | Autauga | Alabama | 1001 | 1522 | 24 |
| 518298 | 518298 | 2020-09-10 | Autauga | Alabama | 1001 | 1544 | 24 |
| 521535 | 521535 | 2020-09-11 | Autauga | Alabama | 1001 | 1551 | 24 |
| 524771 | 524771 | 2020-09-12 | Autauga | Alabama | 1001 | 1565 | 24 |
| 528007 | 528007 | 2020-09-13 | Autauga | Alabama | 1001 | 1576 | 24 |
| 531244 | 531244 | 2020-09-14 | Autauga | Alabama | 1001 | 1585 | 24 |
| 534479 | 534479 | 2020-09-15 | Autauga | Alabama | 1001 | 1601 | 24 |
| 537715 | 537715 | 2020-09-16 | Autauga | Alabama | 1001 | 1619 | 24 |
| 540952 | 540952 | 2020-09-17 | Autauga | Alabama | 1001 | 1624 | 24 |
| 544188 | 544188 | 2020-09-18 | Autauga | Alabama | 1001 | 1664 | 24 |
| 547425 | 547425 | 2020-09-19 | Autauga | Alabama | 1001 | 1673 | 24 |
| 550664 | 550664 | 2020-09-20 | Autauga | Alabama | 1001 | 1690 | 24 |
| 553903 | 553903 | 2020-09-21 | Autauga | Alabama | 1001 | 1691 | 24 |
| 557140 | 557140 | 2020-09-22 | Autauga | Alabama | 1001 | 1714 | 25 |
| 560376 | 560376 | 2020-09-23 | Autauga | Alabama | 1001 | 1715 | 25 |
| 563615 | 563615 | 2020-09-24 | Autauga | Alabama | 1001 | 1738 | 25 |
| 566856 | 566856 | 2020-09-25 | Autauga | Alabama | 1001 | 1757 | 25 |
| 1935 | 1935 | 2020-03-14 | Baldwin | Alabama | 1003 | 1 | 0 |
| 2310 | 2310 | 2020-03-15 | Baldwin | Alabama | 1003 | 1 | 0 |
| 2739 | 2739 | 2020-03-16 | Baldwin | Alabama | 1003 | 1 | 0 |
| 3215 | 3215 | 2020-03-17 | Baldwin | Alabama | 1003 | 1 | 0 |
| 3761 | 3761 | 2020-03-18 | Baldwin | Alabama | 1003 | 1 | 0 |
| 4401 | 4401 | 2020-03-19 | Baldwin | Alabama | 1003 | 1 | 0 |
| 5167 | 5167 | 2020-03-20 | Baldwin | Alabama | 1003 | 2 | 0 |
| 6083 | 6083 | 2020-03-21 | Baldwin | Alabama | 1003 | 2 | 0 |
| 7117 | 7117 | 2020-03-22 | Baldwin | Alabama | 1003 | 2 | 0 |
| 8255 | 8255 | 2020-03-23 | Baldwin | Alabama | 1003 | 3 | 0 |
| 9482 | 9482 | 2020-03-24 | Baldwin | Alabama | 1003 | 4 | 0 |
| 10837 | 10837 | 2020-03-25 | Baldwin | Alabama | 1003 | 4 | 0 |
| 12369 | 12369 | 2020-03-26 | Baldwin | Alabama | 1003 | 5 | 0 |
| 14027 | 14027 | 2020-03-27 | Baldwin | Alabama | 1003 | 5 | 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 );