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-08-09 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 |
---|---|---|---|---|---|---|
49231 | 49231 | 2022-08-09 | Alabama | 1 | 1436458 | 19974 |
49232 | 49232 | 2022-08-09 | Alaska | 2 | 285126 | 1270 |
49233 | 49233 | 2022-08-09 | American Samoa | 60 | 7952 | 33 |
49234 | 49234 | 2022-08-09 | Arizona | 4 | 2211463 | 30842 |
49235 | 49235 | 2022-08-09 | Arkansas | 5 | 912287 | 11775 |
49236 | 49236 | 2022-08-09 | California | 6 | 10853402 | 94034 |
49237 | 49237 | 2022-08-09 | Colorado | 8 | 1616063 | 13260 |
49238 | 49238 | 2022-08-09 | Connecticut | 9 | 861453 | 11160 |
49239 | 49239 | 2022-08-09 | Delaware | 10 | 297180 | 3028 |
49240 | 49240 | 2022-08-09 | District of Columbia | 11 | 163915 | 1369 |
49241 | 49241 | 2022-08-09 | Florida | 12 | 6884224 | 78251 |
49242 | 49242 | 2022-08-09 | Georgia | 13 | 2699110 | 37640 |
49243 | 49243 | 2022-08-09 | Guam | 66 | 57195 | 385 |
49244 | 49244 | 2022-08-09 | Hawaii | 15 | 321378 | 1589 |
49245 | 49245 | 2022-08-09 | Idaho | 16 | 482382 | 5059 |
49246 | 49246 | 2022-08-09 | Illinois | 17 | 3614588 | 39037 |
49247 | 49247 | 2022-08-09 | Indiana | 18 | 1847824 | 24189 |
49248 | 49248 | 2022-08-09 | Iowa | 19 | 826445 | 9817 |
49249 | 49249 | 2022-08-09 | Kansas | 20 | 842609 | 8993 |
49250 | 49250 | 2022-08-09 | Kentucky | 21 | 1503888 | 16464 |
49251 | 49251 | 2022-08-09 | Louisiana | 22 | 1394995 | 17671 |
49252 | 49252 | 2022-08-09 | Maine | 23 | 277897 | 2493 |
49253 | 49253 | 2022-08-09 | Maryland | 24 | 1196004 | 15030 |
49254 | 49254 | 2022-08-09 | Massachusetts | 25 | 1977503 | 21224 |
49255 | 49255 | 2022-08-09 | Michigan | 26 | 2700889 | 37628 |
49256 | 49256 | 2022-08-09 | Minnesota | 27 | 1601006 | 13320 |
49257 | 49257 | 2022-08-09 | Mississippi | 28 | 887134 | 12701 |
49258 | 49258 | 2022-08-09 | Missouri | 29 | 1595870 | 21192 |
49259 | 49259 | 2022-08-09 | Montana | 30 | 299090 | 3481 |
49260 | 49260 | 2022-08-09 | Nebraska | 31 | 521060 | 4373 |
49261 | 49261 | 2022-08-09 | Nevada | 32 | 832229 | 11262 |
49262 | 49262 | 2022-08-09 | New Hampshire | 33 | 340378 | 2636 |
49263 | 49263 | 2022-08-09 | New Jersey | 34 | 2624713 | 34346 |
49264 | 49264 | 2022-08-09 | New Mexico | 35 | 598960 | 8299 |
49265 | 49265 | 2022-08-09 | New York | 36 | 5868484 | 69877 |
49266 | 49266 | 2022-08-09 | North Carolina | 37 | 3016843 | 25697 |
49267 | 49267 | 2022-08-09 | North Dakota | 38 | 259741 | 2372 |
49268 | 49268 | 2022-08-09 | Northern Mariana Islands | 69 | 12866 | 38 |
49269 | 49269 | 2022-08-09 | Ohio | 39 | 2976027 | 39133 |
49270 | 49270 | 2022-08-09 | Oklahoma | 40 | 1140513 | 14593 |
49271 | 49271 | 2022-08-09 | Oregon | 41 | 861994 | 8240 |
49272 | 49272 | 2022-08-09 | Pennsylvania | 42 | 3119129 | 46315 |
49273 | 49273 | 2022-08-09 | Puerto Rico | 72 | 910067 | 4812 |
49274 | 49274 | 2022-08-09 | Rhode Island | 44 | 412477 | 3632 |
49275 | 49275 | 2022-08-09 | South Carolina | 45 | 1637108 | 18215 |
49276 | 49276 | 2022-08-09 | South Dakota | 46 | 251860 | 2963 |
49277 | 49277 | 2022-08-09 | Tennessee | 47 | 2170734 | 26851 |
49278 | 49278 | 2022-08-09 | Texas | 48 | 7552874 | 89753 |
49279 | 49279 | 2022-08-09 | Utah | 49 | 1015707 | 4928 |
49280 | 49280 | 2022-08-09 | Vermont | 50 | 138145 | 693 |
49281 | 49281 | 2022-08-09 | Virgin Islands | 78 | 22026 | 122 |
49282 | 49282 | 2022-08-09 | Virginia | 51 | 1984528 | 21085 |
49283 | 49283 | 2022-08-09 | Washington | 53 | 1750806 | 13772 |
49284 | 49284 | 2022-08-09 | West Virginia | 54 | 564323 | 7192 |
49285 | 49285 | 2022-08-09 | Wisconsin | 55 | 1796953 | 14960 |
49286 | 49286 | 2022-08-09 | Wyoming | 56 | 172473 | 1865 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );