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-07-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 |
---|---|---|---|---|---|---|
48223 | 48223 | 2022-07-22 | Alabama | 1 | 1407699 | 19872 |
48224 | 48224 | 2022-07-22 | Alaska | 2 | 279532 | 1270 |
48225 | 48225 | 2022-07-22 | American Samoa | 60 | 7471 | 33 |
48226 | 48226 | 2022-07-22 | Arizona | 4 | 2179180 | 30698 |
48227 | 48227 | 2022-07-22 | Arkansas | 5 | 894005 | 11666 |
48228 | 48228 | 2022-07-22 | California | 6 | 10578770 | 93325 |
48229 | 48229 | 2022-07-22 | Colorado | 8 | 1591319 | 13142 |
48230 | 48230 | 2022-07-22 | Connecticut | 9 | 847255 | 11093 |
48231 | 48231 | 2022-07-22 | Delaware | 10 | 291619 | 3021 |
48232 | 48232 | 2022-07-22 | District of Columbia | 11 | 161169 | 1363 |
48233 | 48233 | 2022-07-22 | Florida | 12 | 6716112 | 77098 |
48234 | 48234 | 2022-07-22 | Georgia | 13 | 2644433 | 37407 |
48235 | 48235 | 2022-07-22 | Guam | 66 | 55132 | 378 |
48236 | 48236 | 2022-07-22 | Hawaii | 15 | 313805 | 1545 |
48237 | 48237 | 2022-07-22 | Idaho | 16 | 475471 | 5020 |
48238 | 48238 | 2022-07-22 | Illinois | 17 | 3534504 | 38812 |
48239 | 48239 | 2022-07-22 | Indiana | 18 | 1813158 | 24030 |
48240 | 48240 | 2022-07-22 | Iowa | 19 | 811227 | 9759 |
48241 | 48241 | 2022-07-22 | Kansas | 20 | 828190 | 8986 |
48242 | 48242 | 2022-07-22 | Kentucky | 21 | 1451160 | 16293 |
48243 | 48243 | 2022-07-22 | Louisiana | 22 | 1363543 | 17516 |
48244 | 48244 | 2022-07-22 | Maine | 23 | 274285 | 2464 |
48245 | 48245 | 2022-07-22 | Maryland | 24 | 1168190 | 14912 |
48246 | 48246 | 2022-07-22 | Massachusetts | 25 | 1955844 | 21127 |
48247 | 48247 | 2022-07-22 | Michigan | 26 | 2652659 | 37291 |
48248 | 48248 | 2022-07-22 | Minnesota | 27 | 1580508 | 13242 |
48249 | 48249 | 2022-07-22 | Mississippi | 28 | 866040 | 12603 |
48250 | 48250 | 2022-07-22 | Missouri | 29 | 1568710 | 21063 |
48251 | 48251 | 2022-07-22 | Montana | 30 | 294636 | 3467 |
48252 | 48252 | 2022-07-22 | Nebraska | 31 | 511738 | 4363 |
48253 | 48253 | 2022-07-22 | Nevada | 32 | 798140 | 11200 |
48254 | 48254 | 2022-07-22 | New Hampshire | 33 | 336445 | 2618 |
48255 | 48255 | 2022-07-22 | New Jersey | 34 | 2565176 | 34206 |
48256 | 48256 | 2022-07-22 | New Mexico | 35 | 584404 | 8193 |
48257 | 48257 | 2022-07-22 | New York | 36 | 5752964 | 69408 |
48258 | 48258 | 2022-07-22 | North Carolina | 37 | 2949622 | 25445 |
48259 | 48259 | 2022-07-22 | North Dakota | 38 | 255476 | 2351 |
48260 | 48260 | 2022-07-22 | Northern Mariana Islands | 69 | 12720 | 35 |
48261 | 48261 | 2022-07-22 | Ohio | 39 | 2918366 | 38981 |
48262 | 48262 | 2022-07-22 | Oklahoma | 40 | 1108553 | 14555 |
48263 | 48263 | 2022-07-22 | Oregon | 41 | 842352 | 8022 |
48264 | 48264 | 2022-07-22 | Pennsylvania | 42 | 3061287 | 46062 |
48265 | 48265 | 2022-07-22 | Puerto Rico | 72 | 863999 | 4718 |
48266 | 48266 | 2022-07-22 | Rhode Island | 44 | 408532 | 3626 |
48267 | 48267 | 2022-07-22 | South Carolina | 45 | 1587503 | 18132 |
48268 | 48268 | 2022-07-22 | South Dakota | 46 | 248788 | 2947 |
48269 | 48269 | 2022-07-22 | Tennessee | 47 | 2126280 | 26664 |
48270 | 48270 | 2022-07-22 | Texas | 48 | 7362382 | 89268 |
48271 | 48271 | 2022-07-22 | Utah | 49 | 1004684 | 4884 |
48272 | 48272 | 2022-07-22 | Vermont | 50 | 137264 | 689 |
48273 | 48273 | 2022-07-22 | Virgin Islands | 78 | 21540 | 120 |
48274 | 48274 | 2022-07-22 | Virginia | 51 | 1933366 | 20867 |
48275 | 48275 | 2022-07-22 | Washington | 53 | 1720821 | 13572 |
48276 | 48276 | 2022-07-22 | West Virginia | 54 | 548777 | 7121 |
48277 | 48277 | 2022-07-22 | Wisconsin | 55 | 1763638 | 14880 |
48278 | 48278 | 2022-07-22 | Wyoming | 56 | 168678 | 1850 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );