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 2022-02-20 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 56
- 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
- Nevada 1
- New Hampshire 1
- New Jersey 1
- New Mexico 1
- New York 1
- North Carolina 1
- North Dakota 1
- Northern Mariana Islands 1
- Ohio 1
- Oklahoma 1
- Oregon 1
- Pennsylvania 1
- Puerto Rico 1
- Rhode Island 1
- South Carolina 1
- South Dakota 1
- Tennessee 1
- Texas 1
- Utah 1
- Vermont 1
- Virgin Islands 1
- Virginia 1
- Washington 1
- West Virginia 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
39711 | 39711 | 2022-02-20 | Alabama | 1 | 1273092 | 17933 |
39712 | 39712 | 2022-02-20 | Alaska | 2 | 234541 | 1108 |
39713 | 39713 | 2022-02-20 | American Samoa | 60 | 57 | 0 |
39714 | 39714 | 2022-02-20 | Arizona | 4 | 1967702 | 27622 |
39715 | 39715 | 2022-02-20 | Arkansas | 5 | 814728 | 10292 |
39716 | 39716 | 2022-02-20 | California | 6 | 8891601 | 84089 |
39717 | 39717 | 2022-02-20 | Colorado | 8 | 1307537 | 11915 |
39718 | 39718 | 2022-02-20 | Connecticut | 9 | 719327 | 10357 |
39719 | 39719 | 2022-02-20 | Delaware | 10 | 255096 | 2695 |
39720 | 39720 | 2022-02-20 | District of Columbia | 11 | 133697 | 1314 |
39721 | 39721 | 2022-02-20 | Florida | 12 | 5780682 | 68902 |
39722 | 39722 | 2022-02-20 | Georgia | 13 | 2381751 | 33411 |
39723 | 39723 | 2022-02-20 | Guam | 66 | 43513 | 317 |
39724 | 39724 | 2022-02-20 | Hawaii | 15 | 228735 | 1301 |
39725 | 39725 | 2022-02-20 | Idaho | 16 | 414604 | 4678 |
39726 | 39726 | 2022-02-20 | Illinois | 17 | 3019048 | 36360 |
39727 | 39727 | 2022-02-20 | Indiana | 18 | 1678232 | 22529 |
39728 | 39728 | 2022-02-20 | Iowa | 19 | 745530 | 8948 |
39729 | 39729 | 2022-02-20 | Kansas | 20 | 762769 | 7928 |
39730 | 39730 | 2022-02-20 | Kentucky | 21 | 1270713 | 13609 |
39731 | 39731 | 2022-02-20 | Louisiana | 22 | 1219464 | 16400 |
39732 | 39732 | 2022-02-20 | Maine | 23 | 218367 | 1960 |
39733 | 39733 | 2022-02-20 | Maryland | 24 | 998398 | 14011 |
39734 | 39734 | 2022-02-20 | Massachusetts | 25 | 1661206 | 23109 |
39735 | 39735 | 2022-02-20 | Michigan | 26 | 2337531 | 33960 |
39736 | 39736 | 2022-02-20 | Minnesota | 27 | 1404832 | 12131 |
39737 | 39737 | 2022-02-20 | Mississippi | 28 | 785528 | 11836 |
39738 | 39738 | 2022-02-20 | Missouri | 29 | 1404551 | 18599 |
39739 | 39739 | 2022-02-20 | Montana | 30 | 262221 | 3107 |
39740 | 39740 | 2022-02-20 | Nebraska | 31 | 452601 | 3883 |
39741 | 39741 | 2022-02-20 | Nevada | 32 | 677345 | 9508 |
39742 | 39742 | 2022-02-20 | New Hampshire | 33 | 293697 | 2333 |
39743 | 39743 | 2022-02-20 | New Jersey | 34 | 2158100 | 32701 |
39744 | 39744 | 2022-02-20 | New Mexico | 35 | 507323 | 6777 |
39745 | 39745 | 2022-02-20 | New York | 36 | 4890443 | 66349 |
39746 | 39746 | 2022-02-20 | North Carolina | 37 | 2560860 | 22158 |
39747 | 39747 | 2022-02-20 | North Dakota | 38 | 236897 | 2221 |
39748 | 39748 | 2022-02-20 | Northern Mariana Islands | 69 | 8644 | 26 |
39749 | 39749 | 2022-02-20 | Ohio | 39 | 2644828 | 35493 |
39750 | 39750 | 2022-02-20 | Oklahoma | 40 | 1013287 | 12767 |
39751 | 39751 | 2022-02-20 | Oregon | 41 | 685953 | 6456 |
39752 | 39752 | 2022-02-20 | Pennsylvania | 42 | 2744145 | 42789 |
39753 | 39753 | 2022-02-20 | Puerto Rico | 72 | 505335 | 4082 |
39754 | 39754 | 2022-02-20 | Rhode Island | 44 | 354045 | 3397 |
39755 | 39755 | 2022-02-20 | South Carolina | 45 | 1449637 | 16533 |
39756 | 39756 | 2022-02-20 | South Dakota | 46 | 234961 | 2772 |
39757 | 39757 | 2022-02-20 | Tennessee | 47 | 1942537 | 23695 |
39758 | 39758 | 2022-02-20 | Texas | 48 | 6523978 | 83842 |
39759 | 39759 | 2022-02-20 | Utah | 49 | 918402 | 4359 |
39760 | 39760 | 2022-02-20 | Vermont | 50 | 110679 | 583 |
39761 | 39761 | 2022-02-20 | Virgin Islands | 78 | 15255 | 108 |
39762 | 39762 | 2022-02-20 | Virginia | 51 | 1622685 | 18016 |
39763 | 39763 | 2022-02-20 | Washington | 53 | 1410803 | 11706 |
39764 | 39764 | 2022-02-20 | West Virginia | 54 | 481818 | 6162 |
39765 | 39765 | 2022-02-20 | Wisconsin | 55 | 1564600 | 13068 |
39766 | 39766 | 2022-02-20 | Wyoming | 56 | 154082 | 1689 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );