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-03-12 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 |
---|---|---|---|---|---|---|
40831 | 40831 | 2022-03-12 | Alabama | 1 | 1288999 | 18832 |
40832 | 40832 | 2022-03-12 | Alaska | 2 | 241845 | 1165 |
40833 | 40833 | 2022-03-12 | American Samoa | 60 | 433 | 0 |
40834 | 40834 | 2022-03-12 | Arizona | 4 | 1987318 | 28097 |
40835 | 40835 | 2022-03-12 | Arkansas | 5 | 826201 | 10892 |
40836 | 40836 | 2022-03-12 | California | 6 | 9035301 | 87386 |
40837 | 40837 | 2022-03-12 | Colorado | 8 | 1330917 | 12085 |
40838 | 40838 | 2022-03-12 | Connecticut | 9 | 729697 | 10648 |
40839 | 40839 | 2022-03-12 | Delaware | 10 | 258116 | 2807 |
40840 | 40840 | 2022-03-12 | District of Columbia | 11 | 135223 | 1326 |
40841 | 40841 | 2022-03-12 | Florida | 12 | 5824728 | 71860 |
40842 | 40842 | 2022-03-12 | Georgia | 13 | 2406374 | 34804 |
40843 | 40843 | 2022-03-12 | Guam | 66 | 47212 | 338 |
40844 | 40844 | 2022-03-12 | Hawaii | 15 | 231844 | 1351 |
40845 | 40845 | 2022-03-12 | Idaho | 16 | 438022 | 4823 |
40846 | 40846 | 2022-03-12 | Illinois | 17 | 3051272 | 37310 |
40847 | 40847 | 2022-03-12 | Indiana | 18 | 1690675 | 23164 |
40848 | 40848 | 2022-03-12 | Iowa | 19 | 756778 | 9262 |
40849 | 40849 | 2022-03-12 | Kansas | 20 | 769730 | 8035 |
40850 | 40850 | 2022-03-12 | Kentucky | 21 | 1300545 | 14199 |
40851 | 40851 | 2022-03-12 | Louisiana | 22 | 1229653 | 16887 |
40852 | 40852 | 2022-03-12 | Maine | 23 | 232293 | 2145 |
40853 | 40853 | 2022-03-12 | Maryland | 24 | 1006697 | 14249 |
40854 | 40854 | 2022-03-12 | Massachusetts | 25 | 1680673 | 23751 |
40855 | 40855 | 2022-03-12 | Michigan | 26 | 2366110 | 35149 |
40856 | 40856 | 2022-03-12 | Minnesota | 27 | 1422069 | 12464 |
40857 | 40857 | 2022-03-12 | Mississippi | 28 | 792560 | 12255 |
40858 | 40858 | 2022-03-12 | Missouri | 29 | 1419783 | 19545 |
40859 | 40859 | 2022-03-12 | Montana | 30 | 271883 | 3224 |
40860 | 40860 | 2022-03-12 | Nebraska | 31 | 476844 | 4026 |
40861 | 40861 | 2022-03-12 | Nevada | 32 | 688054 | 9922 |
40862 | 40862 | 2022-03-12 | New Hampshire | 33 | 300185 | 2415 |
40863 | 40863 | 2022-03-12 | New Jersey | 34 | 2180793 | 33087 |
40864 | 40864 | 2022-03-12 | New Mexico | 35 | 515164 | 7052 |
40865 | 40865 | 2022-03-12 | New York | 36 | 4928980 | 67027 |
40866 | 40866 | 2022-03-12 | North Carolina | 37 | 2610385 | 22932 |
40867 | 40867 | 2022-03-12 | North Dakota | 38 | 239189 | 2273 |
40868 | 40868 | 2022-03-12 | Northern Mariana Islands | 69 | 10379 | 30 |
40869 | 40869 | 2022-03-12 | Ohio | 39 | 2663518 | 37410 |
40870 | 40870 | 2022-03-12 | Oklahoma | 40 | 1027663 | 13514 |
40871 | 40871 | 2022-03-12 | Oregon | 41 | 699362 | 6869 |
40872 | 40872 | 2022-03-12 | Pennsylvania | 42 | 2769336 | 43834 |
40873 | 40873 | 2022-03-12 | Puerto Rico | 72 | 509383 | 4150 |
40874 | 40874 | 2022-03-12 | Rhode Island | 44 | 357802 | 3421 |
40875 | 40875 | 2022-03-12 | South Carolina | 45 | 1465127 | 17372 |
40876 | 40876 | 2022-03-12 | South Dakota | 46 | 236602 | 2853 |
40877 | 40877 | 2022-03-12 | Tennessee | 47 | 1967109 | 24780 |
40878 | 40878 | 2022-03-12 | Texas | 48 | 6612985 | 86455 |
40879 | 40879 | 2022-03-12 | Utah | 49 | 925712 | 4539 |
40880 | 40880 | 2022-03-12 | Vermont | 50 | 113948 | 608 |
40881 | 40881 | 2022-03-12 | Virgin Islands | 78 | 15556 | 109 |
40882 | 40882 | 2022-03-12 | Virginia | 51 | 1653212 | 19212 |
40883 | 40883 | 2022-03-12 | Washington | 53 | 1438770 | 12263 |
40884 | 40884 | 2022-03-12 | West Virginia | 54 | 494875 | 6550 |
40885 | 40885 | 2022-03-12 | Wisconsin | 55 | 1577890 | 13713 |
40886 | 40886 | 2022-03-12 | Wyoming | 56 | 155744 | 1749 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );