us-states
Data source: Big Local News · About: big-local-datasette
11,399 rows sorted by cases descending
This data as json, copyable, CSV (advanced)
Suggested facets: date (date)
| Link | rowid | date | state | fips | cases ▲ | deaths |
|---|---|---|---|---|---|---|
| 11349 | 11349 | 2020-09-25 | California | 6 | 805733 | 15533 |
| 11294 | 11294 | 2020-09-24 | California | 6 | 801671 | 15389 |
| 11239 | 11239 | 2020-09-23 | California | 6 | 798350 | 15313 |
| 11184 | 11184 | 2020-09-22 | California | 6 | 795077 | 15209 |
| 11129 | 11129 | 2020-09-21 | California | 6 | 792217 | 15069 |
| 11074 | 11074 | 2020-09-20 | California | 6 | 788077 | 15018 |
| 11019 | 11019 | 2020-09-19 | California | 6 | 785076 | 15023 |
| 10964 | 10964 | 2020-09-18 | California | 6 | 781436 | 14912 |
| 10909 | 10909 | 2020-09-17 | California | 6 | 776944 | 14807 |
| 10854 | 10854 | 2020-09-16 | California | 6 | 773318 | 14716 |
| 10799 | 10799 | 2020-09-15 | California | 6 | 769917 | 14606 |
| 10744 | 10744 | 2020-09-14 | California | 6 | 767062 | 14458 |
| 10689 | 10689 | 2020-09-13 | California | 6 | 763389 | 14386 |
| 11391 | 11391 | 2020-09-25 | Texas | 48 | 761644 | 15637 |
| 10634 | 10634 | 2020-09-12 | California | 6 | 760581 | 14333 |
| 11336 | 11336 | 2020-09-24 | Texas | 48 | 758379 | 15587 |
| 10579 | 10579 | 2020-09-11 | California | 6 | 757125 | 14265 |
| 11281 | 11281 | 2020-09-23 | Texas | 48 | 753551 | 15455 |
| 10524 | 10524 | 2020-09-10 | California | 6 | 753017 | 14094 |
| 10469 | 10469 | 2020-09-09 | California | 6 | 749196 | 13990 |
| 11226 | 11226 | 2020-09-22 | Texas | 48 | 749069 | 15322 |
| 10414 | 10414 | 2020-09-08 | California | 6 | 746113 | 13843 |
| 11171 | 11171 | 2020-09-21 | Texas | 48 | 744736 | 15212 |
| 10359 | 10359 | 2020-09-07 | California | 6 | 742689 | 13763 |
| 10304 | 10304 | 2020-09-06 | California | 6 | 740233 | 13730 |
| 10249 | 10249 | 2020-09-05 | California | 6 | 737073 | 13708 |
| 10194 | 10194 | 2020-09-04 | California | 6 | 732691 | 13644 |
| 10139 | 10139 | 2020-09-03 | California | 6 | 727398 | 13497 |
| 11116 | 11116 | 2020-09-20 | Texas | 48 | 722460 | 15159 |
| 10084 | 10084 | 2020-09-02 | California | 6 | 722035 | 13330 |
| 11061 | 11061 | 2020-09-19 | Texas | 48 | 716914 | 15124 |
| 10029 | 10029 | 2020-09-01 | California | 6 | 716628 | 13149 |
| 11006 | 11006 | 2020-09-18 | Texas | 48 | 713652 | 15037 |
| 9974 | 9974 | 2020-08-31 | California | 6 | 712541 | 13020 |
| 10951 | 10951 | 2020-09-17 | Texas | 48 | 710423 | 14909 |
| 9919 | 9919 | 2020-08-30 | California | 6 | 706589 | 12939 |
| 10896 | 10896 | 2020-09-16 | Texas | 48 | 706034 | 14803 |
| 9864 | 9864 | 2020-08-29 | California | 6 | 702499 | 12906 |
| 10841 | 10841 | 2020-09-15 | Texas | 48 | 701509 | 14661 |
| 9809 | 9809 | 2020-08-28 | California | 6 | 698389 | 12836 |
| 11354 | 11354 | 2020-09-25 | Florida | 12 | 695879 | 13914 |
| 10786 | 10786 | 2020-09-14 | Texas | 48 | 694547 | 14508 |
| 11299 | 11299 | 2020-09-24 | Florida | 12 | 693032 | 13794 |
| 9754 | 9754 | 2020-08-27 | California | 6 | 692962 | 12696 |
| 11244 | 11244 | 2020-09-23 | Florida | 12 | 690491 | 13617 |
| 10731 | 10731 | 2020-09-13 | Texas | 48 | 689941 | 14458 |
| 11189 | 11189 | 2020-09-22 | Florida | 12 | 687901 | 13415 |
| 9699 | 9699 | 2020-08-26 | California | 6 | 687612 | 12547 |
| 10676 | 10676 | 2020-09-12 | Texas | 48 | 685921 | 14384 |
| 11134 | 11134 | 2020-09-21 | Florida | 12 | 685431 | 13316 |
| 11079 | 11079 | 2020-09-20 | Florida | 12 | 683746 | 13295 |
| 10621 | 10621 | 2020-09-11 | Texas | 48 | 683295 | 14279 |
| 9644 | 9644 | 2020-08-25 | California | 6 | 682320 | 12409 |
| 11024 | 11024 | 2020-09-19 | Florida | 12 | 681225 | 13286 |
| 10566 | 10566 | 2020-09-10 | Texas | 48 | 677888 | 13998 |
| 10969 | 10969 | 2020-09-18 | Florida | 12 | 677652 | 13224 |
| 9589 | 9589 | 2020-08-24 | California | 6 | 676236 | 12250 |
| 10511 | 10511 | 2020-09-09 | Texas | 48 | 675149 | 13986 |
| 10914 | 10914 | 2020-09-17 | Florida | 12 | 674448 | 13085 |
| 10859 | 10859 | 2020-09-16 | Florida | 12 | 671193 | 12938 |
| 10456 | 10456 | 2020-09-08 | Texas | 48 | 670427 | 13855 |
| 9534 | 9534 | 2020-08-23 | California | 6 | 669944 | 12152 |
| 10804 | 10804 | 2020-09-15 | Florida | 12 | 668838 | 12786 |
| 10401 | 10401 | 2020-09-07 | Texas | 48 | 666209 | 13781 |
| 10749 | 10749 | 2020-09-14 | Florida | 12 | 665722 | 12641 |
| 10346 | 10346 | 2020-09-06 | Texas | 48 | 665338 | 13739 |
| 9479 | 9479 | 2020-08-22 | California | 6 | 665325 | 12137 |
| 10694 | 10694 | 2020-09-13 | Florida | 12 | 663986 | 12607 |
| 10291 | 10291 | 2020-09-05 | Texas | 48 | 663246 | 13660 |
| 10639 | 10639 | 2020-09-12 | Florida | 12 | 661563 | 12599 |
| 9424 | 9424 | 2020-08-21 | California | 6 | 659991 | 11984 |
| 10236 | 10236 | 2020-09-04 | Texas | 48 | 658789 | 13516 |
| 10584 | 10584 | 2020-09-11 | Florida | 12 | 658373 | 12501 |
| 10529 | 10529 | 2020-09-10 | Florida | 12 | 654723 | 12325 |
| 9369 | 9369 | 2020-08-20 | California | 6 | 653401 | 11801 |
| 10181 | 10181 | 2020-09-03 | Texas | 48 | 653321 | 13387 |
| 10474 | 10474 | 2020-09-09 | Florida | 12 | 652140 | 12114 |
| 10419 | 10419 | 2020-09-08 | Florida | 12 | 650084 | 11914 |
| 10126 | 10126 | 2020-09-02 | Texas | 48 | 649844 | 13185 |
| 10364 | 10364 | 2020-09-07 | Florida | 12 | 648261 | 11870 |
| 9314 | 9314 | 2020-08-19 | California | 6 | 646742 | 11686 |
| 10309 | 10309 | 2020-09-06 | Florida | 12 | 646423 | 11848 |
| 10071 | 10071 | 2020-09-01 | Texas | 48 | 645534 | 13004 |
| 10254 | 10254 | 2020-09-05 | Florida | 12 | 643859 | 11810 |
| 9259 | 9259 | 2020-08-18 | California | 6 | 640499 | 11523 |
| 10016 | 10016 | 2020-08-31 | Texas | 48 | 640317 | 12857 |
| 10199 | 10199 | 2020-09-04 | Florida | 12 | 640203 | 11749 |
| 10144 | 10144 | 2020-09-03 | Florida | 12 | 637005 | 11649 |
| 9961 | 9961 | 2020-08-30 | Texas | 48 | 636547 | 12807 |
| 9204 | 9204 | 2020-08-17 | California | 6 | 634991 | 11334 |
| 9906 | 9906 | 2020-08-29 | Texas | 48 | 633834 | 12733 |
| 10089 | 10089 | 2020-09-02 | Florida | 12 | 633434 | 11500 |
| 10034 | 10034 | 2020-09-01 | Florida | 12 | 631032 | 11373 |
| 9149 | 9149 | 2020-08-16 | California | 6 | 628508 | 11245 |
| 9851 | 9851 | 2020-08-28 | Texas | 48 | 628492 | 12615 |
| 9796 | 9796 | 2020-08-27 | Texas | 48 | 623647 | 12444 |
| 9979 | 9979 | 2020-08-31 | Florida | 12 | 623463 | 11186 |
| 9094 | 9094 | 2020-08-15 | California | 6 | 621981 | 11229 |
| 9924 | 9924 | 2020-08-30 | Florida | 12 | 621578 | 11118 |
| 9741 | 9741 | 2020-08-26 | Texas | 48 | 619836 | 12212 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );