ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where "date" is on date 2021-08-30 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 55
- Alabama 1
- Alaska 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 |
---|---|---|---|---|---|---|
29990 | 29990 | 2021-08-30 | Alabama | 1 | 694523 | 12222 |
29991 | 29991 | 2021-08-30 | Alaska | 2 | 87203 | 421 |
29992 | 29992 | 2021-08-30 | Arizona | 4 | 1011101 | 18787 |
29993 | 29993 | 2021-08-30 | Arkansas | 5 | 450265 | 6912 |
29994 | 29994 | 2021-08-30 | California | 6 | 4437703 | 65793 |
29995 | 29995 | 2021-08-30 | Colorado | 8 | 616979 | 7307 |
29996 | 29996 | 2021-08-30 | Connecticut | 9 | 372069 | 8358 |
29997 | 29997 | 2021-08-30 | Delaware | 10 | 119620 | 1877 |
29998 | 29998 | 2021-08-30 | District of Columbia | 11 | 55253 | 1159 |
29999 | 29999 | 2021-08-30 | Florida | 12 | 3231846 | 44553 |
30000 | 30000 | 2021-08-30 | Georgia | 13 | 1361867 | 21911 |
30001 | 30001 | 2021-08-30 | Guam | 66 | 11322 | 146 |
30002 | 30002 | 2021-08-30 | Hawaii | 15 | 60808 | 586 |
30003 | 30003 | 2021-08-30 | Idaho | 16 | 220248 | 2333 |
30004 | 30004 | 2021-08-30 | Illinois | 17 | 1522546 | 26472 |
30005 | 30005 | 2021-08-30 | Indiana | 18 | 858395 | 14419 |
30006 | 30006 | 2021-08-30 | Iowa | 19 | 402725 | 6268 |
30007 | 30007 | 2021-08-30 | Kansas | 20 | 370060 | 5583 |
30008 | 30008 | 2021-08-30 | Kentucky | 21 | 575024 | 7796 |
30009 | 30009 | 2021-08-30 | Louisiana | 22 | 679796 | 12359 |
30010 | 30010 | 2021-08-30 | Maine | 23 | 75381 | 930 |
30011 | 30011 | 2021-08-30 | Maryland | 24 | 496147 | 10004 |
30012 | 30012 | 2021-08-30 | Massachusetts | 25 | 758094 | 18229 |
30013 | 30013 | 2021-08-30 | Michigan | 26 | 1058585 | 21534 |
30014 | 30014 | 2021-08-30 | Minnesota | 27 | 646187 | 7898 |
30015 | 30015 | 2021-08-30 | Mississippi | 28 | 435611 | 8361 |
30016 | 30016 | 2021-08-30 | Missouri | 29 | 773082 | 11138 |
30017 | 30017 | 2021-08-30 | Montana | 30 | 126452 | 1787 |
30018 | 30018 | 2021-08-30 | Nebraska | 31 | 243118 | 2587 |
30019 | 30019 | 2021-08-30 | Nevada | 32 | 389358 | 6479 |
30020 | 30020 | 2021-08-30 | New Hampshire | 33 | 107474 | 1416 |
30021 | 30021 | 2021-08-30 | New Jersey | 34 | 1089838 | 26864 |
30022 | 30022 | 2021-08-30 | New Mexico | 35 | 231785 | 4514 |
30023 | 30023 | 2021-08-30 | New York | 36 | 2272334 | 53823 |
30024 | 30024 | 2021-08-30 | North Carolina | 37 | 1209923 | 14428 |
30025 | 30025 | 2021-08-30 | North Dakota | 38 | 117009 | 1592 |
30026 | 30026 | 2021-08-30 | Northern Mariana Islands | 69 | 241 | 2 |
30027 | 30027 | 2021-08-30 | Ohio | 39 | 1214986 | 20799 |
30028 | 30028 | 2021-08-30 | Oklahoma | 40 | 550239 | 7812 |
30029 | 30029 | 2021-08-30 | Oregon | 41 | 273896 | 3170 |
30030 | 30030 | 2021-08-30 | Pennsylvania | 42 | 1297119 | 28214 |
30031 | 30031 | 2021-08-30 | Puerto Rico | 72 | 203832 | 2832 |
30032 | 30032 | 2021-08-30 | Rhode Island | 44 | 162325 | 2769 |
30033 | 30033 | 2021-08-30 | South Carolina | 45 | 730685 | 10562 |
30034 | 30034 | 2021-08-30 | South Dakota | 46 | 131239 | 2067 |
30035 | 30035 | 2021-08-30 | Tennessee | 47 | 1023395 | 13322 |
30036 | 30036 | 2021-08-30 | Texas | 48 | 3582287 | 56975 |
30037 | 30037 | 2021-08-30 | Utah | 49 | 463284 | 2628 |
30038 | 30038 | 2021-08-30 | Vermont | 50 | 28044 | 275 |
30039 | 30039 | 2021-08-30 | Virgin Islands | 78 | 5760 | 53 |
30040 | 30040 | 2021-08-30 | Virginia | 51 | 762948 | 11810 |
30041 | 30041 | 2021-08-30 | Washington | 53 | 561423 | 6591 |
30042 | 30042 | 2021-08-30 | West Virginia | 54 | 188660 | 3074 |
30043 | 30043 | 2021-08-30 | Wisconsin | 55 | 731529 | 8445 |
30044 | 30044 | 2021-08-30 | Wyoming | 56 | 74756 | 835 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );