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-11-08 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 |
---|---|---|---|---|---|---|
54327 | 54327 | 2022-11-08 | Alabama | 1 | 1534287 | 20558 |
54328 | 54328 | 2022-11-08 | Alaska | 2 | 298969 | 1369 |
54329 | 54329 | 2022-11-08 | American Samoa | 60 | 8257 | 34 |
54330 | 54330 | 2022-11-08 | Arizona | 4 | 2293015 | 31573 |
54331 | 54331 | 2022-11-08 | Arkansas | 5 | 962329 | 12522 |
54332 | 54332 | 2022-11-08 | California | 6 | 11389933 | 97050 |
54333 | 54333 | 2022-11-08 | Colorado | 8 | 1689838 | 13671 |
54334 | 54334 | 2022-11-08 | Connecticut | 9 | 916172 | 11477 |
54335 | 54335 | 2022-11-08 | Delaware | 10 | 314303 | 3147 |
54336 | 54336 | 2022-11-08 | District of Columbia | 11 | 170041 | 1397 |
54337 | 54337 | 2022-11-08 | Florida | 12 | 7172457 | 82541 |
54338 | 54338 | 2022-11-08 | Georgia | 13 | 2839500 | 39127 |
54339 | 54339 | 2022-11-08 | Guam | 66 | 59908 | 405 |
54340 | 54340 | 2022-11-08 | Hawaii | 15 | 354077 | 1708 |
54341 | 54341 | 2022-11-08 | Idaho | 16 | 501065 | 5228 |
54342 | 54342 | 2022-11-08 | Illinois | 17 | 3835468 | 40064 |
54343 | 54343 | 2022-11-08 | Indiana | 18 | 1942708 | 24950 |
54344 | 54344 | 2022-11-08 | Iowa | 19 | 864752 | 10207 |
54345 | 54345 | 2022-11-08 | Kansas | 20 | 890703 | 9645 |
54346 | 54346 | 2022-11-08 | Kentucky | 21 | 1624756 | 17363 |
54347 | 54347 | 2022-11-08 | Louisiana | 22 | 1463379 | 18193 |
54348 | 54348 | 2022-11-08 | Maine | 23 | 298906 | 2698 |
54349 | 54349 | 2022-11-08 | Maryland | 24 | 1273721 | 15593 |
54350 | 54350 | 2022-11-08 | Massachusetts | 25 | 2092838 | 22106 |
54351 | 54351 | 2022-11-08 | Michigan | 26 | 2897827 | 39407 |
54352 | 54352 | 2022-11-08 | Minnesota | 27 | 1691086 | 13873 |
54353 | 54353 | 2022-11-08 | Mississippi | 28 | 934401 | 12992 |
54354 | 54354 | 2022-11-08 | Missouri | 29 | 1694272 | 21921 |
54355 | 54355 | 2022-11-08 | Montana | 30 | 315677 | 3577 |
54356 | 54356 | 2022-11-08 | Nebraska | 31 | 536548 | 4562 |
54357 | 54357 | 2022-11-08 | Nevada | 32 | 854702 | 11570 |
54358 | 54358 | 2022-11-08 | New Hampshire | 33 | 358581 | 2776 |
54359 | 54359 | 2022-11-08 | New Jersey | 34 | 2810076 | 34949 |
54360 | 54360 | 2022-11-08 | New Mexico | 35 | 632738 | 8675 |
54361 | 54361 | 2022-11-08 | New York | 36 | 6274325 | 72619 |
54362 | 54362 | 2022-11-08 | North Carolina | 37 | 3246175 | 27244 |
54363 | 54363 | 2022-11-08 | North Dakota | 38 | 273779 | 2434 |
54364 | 54364 | 2022-11-08 | Northern Mariana Islands | 69 | 13212 | 41 |
54365 | 54365 | 2022-11-08 | Ohio | 39 | 3197300 | 40249 |
54366 | 54366 | 2022-11-08 | Oklahoma | 40 | 1211210 | 14992 |
54367 | 54367 | 2022-11-08 | Oregon | 41 | 910693 | 8726 |
54368 | 54368 | 2022-11-08 | Pennsylvania | 42 | 3318490 | 47840 |
54369 | 54369 | 2022-11-08 | Puerto Rico | 72 | 1022644 | 5280 |
54370 | 54370 | 2022-11-08 | Rhode Island | 44 | 433348 | 3705 |
54371 | 54371 | 2022-11-08 | South Carolina | 45 | 1729333 | 18660 |
54372 | 54372 | 2022-11-08 | South Dakota | 46 | 265019 | 3065 |
54373 | 54373 | 2022-11-08 | Tennessee | 47 | 2305487 | 27839 |
54374 | 54374 | 2022-11-08 | Texas | 48 | 7937273 | 91391 |
54375 | 54375 | 2022-11-08 | Utah | 49 | 1048168 | 5065 |
54376 | 54376 | 2022-11-08 | Vermont | 50 | 145409 | 754 |
54377 | 54377 | 2022-11-08 | Virgin Islands | 78 | 23413 | 124 |
54378 | 54378 | 2022-11-08 | Virginia | 51 | 2128552 | 22231 |
54379 | 54379 | 2022-11-08 | Washington | 53 | 1840128 | 14638 |
54380 | 54380 | 2022-11-08 | West Virginia | 54 | 609944 | 7536 |
54381 | 54381 | 2022-11-08 | Wisconsin | 55 | 1906153 | 15509 |
54382 | 54382 | 2022-11-08 | Wyoming | 56 | 179366 | 1917 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );