ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where "date" is on date 2021-11-04 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Alabama 1
- Alaska 1
- American Samoa 1
- Arizona 1
- Arkansas 1
- California 1
- Colorado 1
- Connecticut 1
- Delaware 1
- District of Columbia 1
- Florida 1
- Georgia 1
- Guam 1
- Hawaii 1
- Idaho 1
- Illinois 1
- Indiana 1
- Iowa 1
- Kansas 1
- Kentucky 1
- Louisiana 1
- Maine 1
- Maryland 1
- Massachusetts 1
- Michigan 1
- Minnesota 1
- Mississippi 1
- Missouri 1
- Montana 1
- Nebraska 1
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
33663 | 33663 | 2021-11-04 | Alabama | 1 | 834582 | 15734 |
33664 | 33664 | 2021-11-04 | Alaska | 2 | 140319 | 722 |
33665 | 33665 | 2021-11-04 | American Samoa | 60 | 4 | 0 |
33666 | 33666 | 2021-11-04 | Arizona | 4 | 1179072 | 21290 |
33667 | 33667 | 2021-11-04 | Arkansas | 5 | 514967 | 8452 |
33668 | 33668 | 2021-11-04 | California | 6 | 4951490 | 72560 |
33669 | 33669 | 2021-11-04 | Colorado | 8 | 760541 | 8543 |
33670 | 33670 | 2021-11-04 | Connecticut | 9 | 404649 | 8776 |
33671 | 33671 | 2021-11-04 | Delaware | 10 | 145056 | 2101 |
33672 | 33672 | 2021-11-04 | District of Columbia | 11 | 64708 | 1193 |
33673 | 33673 | 2021-11-04 | Florida | 12 | 3656010 | 59670 |
33674 | 33674 | 2021-11-04 | Georgia | 13 | 1604539 | 28345 |
33675 | 33675 | 2021-11-04 | Guam | 66 | 19476 | 249 |
33676 | 33676 | 2021-11-04 | Hawaii | 15 | 81960 | 929 |
33677 | 33677 | 2021-11-04 | Idaho | 16 | 295202 | 3630 |
33678 | 33678 | 2021-11-04 | Illinois | 17 | 1715452 | 28803 |
33679 | 33679 | 2021-11-04 | Indiana | 18 | 1031553 | 16859 |
33680 | 33680 | 2021-11-04 | Iowa | 19 | 491463 | 7069 |
33681 | 33681 | 2021-11-04 | Kansas | 20 | 439267 | 6477 |
33682 | 33682 | 2021-11-04 | Kentucky | 21 | 755251 | 9962 |
33683 | 33683 | 2021-11-04 | Louisiana | 22 | 761311 | 14597 |
33684 | 33684 | 2021-11-04 | Maine | 23 | 106473 | 1197 |
33685 | 33685 | 2021-11-04 | Maryland | 24 | 563927 | 10939 |
33686 | 33686 | 2021-11-04 | Massachusetts | 25 | 859713 | 19069 |
33687 | 33687 | 2021-11-04 | Michigan | 26 | 1295049 | 23855 |
33688 | 33688 | 2021-11-04 | Minnesota | 27 | 811778 | 8917 |
33689 | 33689 | 2021-11-04 | Mississippi | 28 | 506042 | 10134 |
33690 | 33690 | 2021-11-04 | Missouri | 29 | 876603 | 12916 |
33691 | 33691 | 2021-11-04 | Montana | 30 | 179965 | 2405 |
33692 | 33692 | 2021-11-04 | Nebraska | 31 | 288257 | 2988 |
33693 | 33693 | 2021-11-04 | Nevada | 32 | 454319 | 7692 |
33694 | 33694 | 2021-11-04 | New Hampshire | 33 | 138511 | 1592 |
33695 | 33695 | 2021-11-04 | New Jersey | 34 | 1203755 | 28011 |
33696 | 33696 | 2021-11-04 | New Mexico | 35 | 281282 | 5103 |
33697 | 33697 | 2021-11-04 | New York | 36 | 2575181 | 56144 |
33698 | 33698 | 2021-11-04 | North Carolina | 37 | 1489294 | 18228 |
33699 | 33699 | 2021-11-04 | North Dakota | 38 | 150503 | 1820 |
33700 | 33700 | 2021-11-04 | Northern Mariana Islands | 69 | 312 | 3 |
33701 | 33701 | 2021-11-04 | Ohio | 39 | 1560695 | 24763 |
33702 | 33702 | 2021-11-04 | Oklahoma | 40 | 647633 | 10879 |
33703 | 33703 | 2021-11-04 | Oregon | 41 | 371001 | 4543 |
33704 | 33704 | 2021-11-04 | Pennsylvania | 42 | 1580346 | 31783 |
33705 | 33705 | 2021-11-04 | Puerto Rico | 72 | 218770 | 3239 |
33706 | 33706 | 2021-11-04 | Rhode Island | 44 | 180809 | 2881 |
33707 | 33707 | 2021-11-04 | South Carolina | 45 | 901314 | 13832 |
33708 | 33708 | 2021-11-04 | South Dakota | 46 | 156564 | 2260 |
33709 | 33709 | 2021-11-04 | Tennessee | 47 | 1256710 | 16345 |
33710 | 33710 | 2021-11-04 | Texas | 48 | 4246805 | 71987 |
33711 | 33711 | 2021-11-04 | Utah | 49 | 558845 | 3276 |
33712 | 33712 | 2021-11-04 | Vermont | 50 | 41254 | 380 |
33713 | 33713 | 2021-11-04 | Virgin Islands | 78 | 7260 | 83 |
33714 | 33714 | 2021-11-04 | Virginia | 51 | 932173 | 14089 |
33715 | 33715 | 2021-11-04 | Washington | 53 | 738602 | 8822 |
33716 | 33716 | 2021-11-04 | West Virginia | 54 | 275396 | 4511 |
33717 | 33717 | 2021-11-04 | Wisconsin | 55 | 896589 | 9523 |
33718 | 33718 | 2021-11-04 | Wyoming | 56 | 104940 | 1243 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );