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 2021-09-23 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|
31311 | 31311 | 2021-09-23 | Alabama | 1 | 781915 | 13798 |
31312 | 31312 | 2021-09-23 | Alaska | 2 | 105110 | 471 |
31313 | 31313 | 2021-09-23 | American Samoa | 60 | 1 | 0 |
31314 | 31314 | 2021-09-23 | Arizona | 4 | 1075876 | 19727 |
31315 | 31315 | 2021-09-23 | Arkansas | 5 | 489856 | 7548 |
31316 | 31316 | 2021-09-23 | California | 6 | 4687178 | 68532 |
31317 | 31317 | 2021-09-23 | Colorado | 8 | 662451 | 7634 |
31318 | 31318 | 2021-09-23 | Connecticut | 9 | 387263 | 8483 |
31319 | 31319 | 2021-09-23 | Delaware | 10 | 129874 | 1942 |
31320 | 31320 | 2021-09-23 | District of Columbia | 11 | 60018 | 1172 |
31321 | 31321 | 2021-09-23 | Florida | 12 | 3531465 | 53105 |
31322 | 31322 | 2021-09-23 | Georgia | 13 | 1519511 | 24498 |
31323 | 31323 | 2021-09-23 | Guam | 66 | 15067 | 185 |
31324 | 31324 | 2021-09-23 | Hawaii | 15 | 74606 | 735 |
31325 | 31325 | 2021-09-23 | Idaho | 16 | 248152 | 2721 |
31326 | 31326 | 2021-09-23 | Illinois | 17 | 1613862 | 27398 |
31327 | 31327 | 2021-09-23 | Indiana | 18 | 948099 | 15343 |
31328 | 31328 | 2021-09-23 | Iowa | 19 | 441183 | 6482 |
31329 | 31329 | 2021-09-23 | Kansas | 20 | 403026 | 5947 |
31330 | 31330 | 2021-09-23 | Kentucky | 21 | 675004 | 8545 |
31331 | 31331 | 2021-09-23 | Louisiana | 22 | 733522 | 13702 |
31332 | 31332 | 2021-09-23 | Maine | 23 | 85872 | 1009 |
31333 | 31333 | 2021-09-23 | Maryland | 24 | 523988 | 10348 |
31334 | 31334 | 2021-09-23 | Massachusetts | 25 | 800909 | 18527 |
31335 | 31335 | 2021-09-23 | Michigan | 26 | 1123783 | 22112 |
31336 | 31336 | 2021-09-23 | Minnesota | 27 | 694413 | 8142 |
31337 | 31337 | 2021-09-23 | Mississippi | 28 | 481397 | 9395 |
31338 | 31338 | 2021-09-23 | Missouri | 29 | 825376 | 11999 |
31339 | 31339 | 2021-09-23 | Montana | 30 | 145145 | 1930 |
31340 | 31340 | 2021-09-23 | Nebraska | 31 | 261763 | 2648 |
31341 | 31341 | 2021-09-23 | Nevada | 32 | 415424 | 6983 |
31342 | 31342 | 2021-09-23 | New Hampshire | 33 | 116710 | 1469 |
31343 | 31343 | 2021-09-23 | New Jersey | 34 | 1141619 | 27288 |
31344 | 31344 | 2021-09-23 | New Mexico | 35 | 248075 | 4737 |
31345 | 31345 | 2021-09-23 | New York | 36 | 2389735 | 54641 |
31346 | 31346 | 2021-09-23 | North Carolina | 37 | 1365428 | 16036 |
31347 | 31347 | 2021-09-23 | North Dakota | 38 | 127945 | 1628 |
31348 | 31348 | 2021-09-23 | Northern Mariana Islands | 69 | 265 | 2 |
31349 | 31349 | 2021-09-23 | Ohio | 39 | 1373275 | 21596 |
31350 | 31350 | 2021-09-23 | Oklahoma | 40 | 603161 | 8715 |
31351 | 31351 | 2021-09-23 | Oregon | 41 | 318915 | 3661 |
31352 | 31352 | 2021-09-23 | Pennsylvania | 42 | 1397755 | 29030 |
31353 | 31353 | 2021-09-23 | Puerto Rico | 72 | 213365 | 3109 |
31354 | 31354 | 2021-09-23 | Rhode Island | 44 | 170293 | 2820 |
31355 | 31355 | 2021-09-23 | South Carolina | 45 | 838079 | 11957 |
31356 | 31356 | 2021-09-23 | South Dakota | 46 | 142330 | 2115 |
31357 | 31357 | 2021-09-23 | Tennessee | 47 | 1176400 | 14623 |
31358 | 31358 | 2021-09-23 | Texas | 48 | 3982646 | 63608 |
31359 | 31359 | 2021-09-23 | Utah | 49 | 499120 | 2860 |
31360 | 31360 | 2021-09-23 | Vermont | 50 | 32368 | 301 |
31361 | 31361 | 2021-09-23 | Virgin Islands | 78 | 6557 | 69 |
31362 | 31362 | 2021-09-23 | Virginia | 51 | 846979 | 12463 |
31363 | 31363 | 2021-09-23 | Washington | 53 | 640094 | 7487 |
31364 | 31364 | 2021-09-23 | West Virginia | 54 | 228983 | 3492 |
31365 | 31365 | 2021-09-23 | Wisconsin | 55 | 790787 | 8775 |
31366 | 31366 | 2021-09-23 | Wyoming | 56 | 87351 | 955 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );