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-22 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|
39823 | 39823 | 2022-02-22 | Alabama | 1 | 1274123 | 17938 |
39824 | 39824 | 2022-02-22 | Alaska | 2 | 234541 | 1108 |
39825 | 39825 | 2022-02-22 | American Samoa | 60 | 57 | 0 |
39826 | 39826 | 2022-02-22 | Arizona | 4 | 1970442 | 27751 |
39827 | 39827 | 2022-02-22 | Arkansas | 5 | 816168 | 10305 |
39828 | 39828 | 2022-02-22 | California | 6 | 8921012 | 84437 |
39829 | 39829 | 2022-02-22 | Colorado | 8 | 1312380 | 11939 |
39830 | 39830 | 2022-02-22 | Connecticut | 9 | 720956 | 10374 |
39831 | 39831 | 2022-02-22 | Delaware | 10 | 255287 | 2702 |
39832 | 39832 | 2022-02-22 | District of Columbia | 11 | 134066 | 1315 |
39833 | 39833 | 2022-02-22 | Florida | 12 | 5790325 | 68955 |
39834 | 39834 | 2022-02-22 | Georgia | 13 | 2386839 | 33630 |
39835 | 39835 | 2022-02-22 | Guam | 66 | 44180 | 319 |
39836 | 39836 | 2022-02-22 | Hawaii | 15 | 229083 | 1301 |
39837 | 39837 | 2022-02-22 | Idaho | 16 | 416961 | 4705 |
39838 | 39838 | 2022-02-22 | Illinois | 17 | 3025329 | 36516 |
39839 | 39839 | 2022-02-22 | Indiana | 18 | 1681685 | 22629 |
39840 | 39840 | 2022-02-22 | Iowa | 19 | 746825 | 8948 |
39841 | 39841 | 2022-02-22 | Kansas | 20 | 763772 | 7941 |
39842 | 39842 | 2022-02-22 | Kentucky | 21 | 1278796 | 13706 |
39843 | 39843 | 2022-02-22 | Louisiana | 22 | 1223067 | 16518 |
39844 | 39844 | 2022-02-22 | Maine | 23 | 221406 | 1960 |
39845 | 39845 | 2022-02-22 | Maryland | 24 | 999151 | 14049 |
39846 | 39846 | 2022-02-22 | Massachusetts | 25 | 1665586 | 23157 |
39847 | 39847 | 2022-02-22 | Michigan | 26 | 2337531 | 33960 |
39848 | 39848 | 2022-02-22 | Minnesota | 27 | 1406824 | 12163 |
39849 | 39849 | 2022-02-22 | Mississippi | 28 | 787396 | 11858 |
39850 | 39850 | 2022-02-22 | Missouri | 29 | 1407975 | 18622 |
39851 | 39851 | 2022-02-22 | Montana | 30 | 263855 | 3129 |
39852 | 39852 | 2022-02-22 | Nebraska | 31 | 453165 | 3901 |
39853 | 39853 | 2022-02-22 | Nevada | 32 | 678401 | 9554 |
39854 | 39854 | 2022-02-22 | New Hampshire | 33 | 293697 | 2333 |
39855 | 39855 | 2022-02-22 | New Jersey | 34 | 2160023 | 32743 |
39856 | 39856 | 2022-02-22 | New Mexico | 35 | 509178 | 6823 |
39857 | 39857 | 2022-02-22 | New York | 36 | 4895859 | 66485 |
39858 | 39858 | 2022-02-22 | North Carolina | 37 | 2572953 | 22306 |
39859 | 39859 | 2022-02-22 | North Dakota | 38 | 237139 | 2221 |
39860 | 39860 | 2022-02-22 | Northern Mariana Islands | 69 | 8882 | 27 |
39861 | 39861 | 2022-02-22 | Ohio | 39 | 2647048 | 36267 |
39862 | 39862 | 2022-02-22 | Oklahoma | 40 | 1015935 | 12767 |
39863 | 39863 | 2022-02-22 | Oregon | 41 | 689325 | 6485 |
39864 | 39864 | 2022-02-22 | Pennsylvania | 42 | 2746745 | 42789 |
39865 | 39865 | 2022-02-22 | Puerto Rico | 72 | 505551 | 4086 |
39866 | 39866 | 2022-02-22 | Rhode Island | 44 | 354817 | 3404 |
39867 | 39867 | 2022-02-22 | South Carolina | 45 | 1455967 | 16600 |
39868 | 39868 | 2022-02-22 | South Dakota | 46 | 235116 | 2779 |
39869 | 39869 | 2022-02-22 | Tennessee | 47 | 1947423 | 23741 |
39870 | 39870 | 2022-02-22 | Texas | 48 | 6535366 | 84080 |
39871 | 39871 | 2022-02-22 | Utah | 49 | 920472 | 4372 |
39872 | 39872 | 2022-02-22 | Vermont | 50 | 111319 | 587 |
39873 | 39873 | 2022-02-22 | Virgin Islands | 78 | 15255 | 108 |
39874 | 39874 | 2022-02-22 | Virginia | 51 | 1630796 | 18230 |
39875 | 39875 | 2022-02-22 | Washington | 53 | 1412745 | 11712 |
39876 | 39876 | 2022-02-22 | West Virginia | 54 | 485498 | 6219 |
39877 | 39877 | 2022-02-22 | Wisconsin | 55 | 1567927 | 13108 |
39878 | 39878 | 2022-02-22 | Wyoming | 56 | 154549 | 1718 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );