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-04-02 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 |
---|---|---|---|---|---|---|
42007 | 42007 | 2022-04-02 | Alabama | 1 | 1295468 | 19313 |
42008 | 42008 | 2022-04-02 | Alaska | 2 | 246144 | 1192 |
42009 | 42009 | 2022-04-02 | American Samoa | 60 | 3756 | 0 |
42010 | 42010 | 2022-04-02 | Arizona | 4 | 2007180 | 29268 |
42011 | 42011 | 2022-04-02 | Arkansas | 5 | 833090 | 11251 |
42012 | 42012 | 2022-04-02 | California | 6 | 9108202 | 89076 |
42013 | 42013 | 2022-04-02 | Colorado | 8 | 1352688 | 12175 |
42014 | 42014 | 2022-04-02 | Connecticut | 9 | 737276 | 10779 |
42015 | 42015 | 2022-04-02 | Delaware | 10 | 259848 | 2870 |
42016 | 42016 | 2022-04-02 | District of Columbia | 11 | 136886 | 1333 |
42017 | 42017 | 2022-04-02 | Florida | 12 | 5853175 | 73290 |
42018 | 42018 | 2022-04-02 | Georgia | 13 | 2430374 | 35636 |
42019 | 42019 | 2022-04-02 | Guam | 66 | 48234 | 347 |
42020 | 42020 | 2022-04-02 | Hawaii | 15 | 234659 | 1376 |
42021 | 42021 | 2022-04-02 | Idaho | 16 | 444298 | 4879 |
42022 | 42022 | 2022-04-02 | Illinois | 17 | 3075243 | 37684 |
42023 | 42023 | 2022-04-02 | Indiana | 18 | 1691470 | 23429 |
42024 | 42024 | 2022-04-02 | Iowa | 19 | 759048 | 9445 |
42025 | 42025 | 2022-04-02 | Kansas | 20 | 771200 | 8413 |
42026 | 42026 | 2022-04-02 | Kentucky | 21 | 1322805 | 14917 |
42027 | 42027 | 2022-04-02 | Louisiana | 22 | 1232513 | 17138 |
42028 | 42028 | 2022-04-02 | Maine | 23 | 236258 | 2202 |
42029 | 42029 | 2022-04-02 | Maryland | 24 | 1012621 | 14347 |
42030 | 42030 | 2022-04-02 | Massachusetts | 25 | 1700361 | 20115 |
42031 | 42031 | 2022-04-02 | Michigan | 26 | 2383197 | 35666 |
42032 | 42032 | 2022-04-02 | Minnesota | 27 | 1430319 | 12640 |
42033 | 42033 | 2022-04-02 | Mississippi | 28 | 794721 | 12399 |
42034 | 42034 | 2022-04-02 | Missouri | 29 | 1428277 | 20168 |
42035 | 42035 | 2022-04-02 | Montana | 30 | 272865 | 3249 |
42036 | 42036 | 2022-04-02 | Nebraska | 31 | 477724 | 4162 |
42037 | 42037 | 2022-04-02 | Nevada | 32 | 713505 | 10125 |
42038 | 42038 | 2022-04-02 | New Hampshire | 33 | 302678 | 2452 |
42039 | 42039 | 2022-04-02 | New Jersey | 34 | 2202817 | 33246 |
42040 | 42040 | 2022-04-02 | New Mexico | 35 | 517951 | 7281 |
42041 | 42041 | 2022-04-02 | New York | 36 | 4985141 | 67334 |
42042 | 42042 | 2022-04-02 | North Carolina | 37 | 2632182 | 23225 |
42043 | 42043 | 2022-04-02 | North Dakota | 38 | 239863 | 2279 |
42044 | 42044 | 2022-04-02 | Northern Mariana Islands | 69 | 11153 | 33 |
42045 | 42045 | 2022-04-02 | Ohio | 39 | 2672801 | 38042 |
42046 | 42046 | 2022-04-02 | Oklahoma | 40 | 1034439 | 14010 |
42047 | 42047 | 2022-04-02 | Oregon | 41 | 704515 | 7147 |
42048 | 42048 | 2022-04-02 | Pennsylvania | 42 | 2782827 | 44313 |
42049 | 42049 | 2022-04-02 | Puerto Rico | 72 | 515224 | 4170 |
42050 | 42050 | 2022-04-02 | Rhode Island | 44 | 361508 | 3522 |
42051 | 42051 | 2022-04-02 | South Carolina | 45 | 1468140 | 17591 |
42052 | 42052 | 2022-04-02 | South Dakota | 46 | 237109 | 2883 |
42053 | 42053 | 2022-04-02 | Tennessee | 47 | 1972565 | 25361 |
42054 | 42054 | 2022-04-02 | Texas | 48 | 6686081 | 87580 |
42055 | 42055 | 2022-04-02 | Utah | 49 | 928148 | 4714 |
42056 | 42056 | 2022-04-02 | Vermont | 50 | 116800 | 617 |
42057 | 42057 | 2022-04-02 | Virgin Islands | 78 | 15656 | 111 |
42058 | 42058 | 2022-04-02 | Virginia | 51 | 1669750 | 19714 |
42059 | 42059 | 2022-04-02 | Washington | 53 | 1457235 | 12566 |
42060 | 42060 | 2022-04-02 | West Virginia | 54 | 497864 | 6835 |
42061 | 42061 | 2022-04-02 | Wisconsin | 55 | 1585996 | 14317 |
42062 | 42062 | 2022-04-02 | Wyoming | 56 | 156167 | 1791 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );