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-10-06 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 |
---|---|---|---|---|---|---|
52479 | 52479 | 2022-10-06 | Alabama | 1 | 1525724 | 20473 |
52480 | 52480 | 2022-10-06 | Alaska | 2 | 297176 | 1350 |
52481 | 52481 | 2022-10-06 | American Samoa | 60 | 8244 | 34 |
52482 | 52482 | 2022-10-06 | Arizona | 4 | 2275235 | 31406 |
52483 | 52483 | 2022-10-06 | Arkansas | 5 | 953327 | 12252 |
52484 | 52484 | 2022-10-06 | California | 6 | 11289060 | 96240 |
52485 | 52485 | 2022-10-06 | Colorado | 8 | 1665527 | 13536 |
52486 | 52486 | 2022-10-06 | Connecticut | 9 | 900500 | 11385 |
52487 | 52487 | 2022-10-06 | Delaware | 10 | 309804 | 3112 |
52488 | 52488 | 2022-10-06 | District of Columbia | 11 | 168660 | 1392 |
52489 | 52489 | 2022-10-06 | Florida | 12 | 7127263 | 81606 |
52490 | 52490 | 2022-10-06 | Georgia | 13 | 2825163 | 38808 |
52491 | 52491 | 2022-10-06 | Guam | 66 | 59560 | 402 |
52492 | 52492 | 2022-10-06 | Hawaii | 15 | 348570 | 1691 |
52493 | 52493 | 2022-10-06 | Idaho | 16 | 496729 | 5188 |
52494 | 52494 | 2022-10-06 | Illinois | 17 | 3778439 | 39760 |
52495 | 52495 | 2022-10-06 | Indiana | 18 | 1925645 | 24748 |
52496 | 52496 | 2022-10-06 | Iowa | 19 | 857944 | 10097 |
52497 | 52497 | 2022-10-06 | Kansas | 20 | 880639 | 9579 |
52498 | 52498 | 2022-10-06 | Kentucky | 21 | 1601441 | 17030 |
52499 | 52499 | 2022-10-06 | Louisiana | 22 | 1457052 | 18097 |
52500 | 52500 | 2022-10-06 | Maine | 23 | 291277 | 2596 |
52501 | 52501 | 2022-10-06 | Maryland | 24 | 1254152 | 15419 |
52502 | 52502 | 2022-10-06 | Massachusetts | 25 | 2060884 | 21771 |
52503 | 52503 | 2022-10-06 | Michigan | 26 | 2849047 | 38767 |
52504 | 52504 | 2022-10-06 | Minnesota | 27 | 1670765 | 13695 |
52505 | 52505 | 2022-10-06 | Mississippi | 28 | 929079 | 12928 |
52506 | 52506 | 2022-10-06 | Missouri | 29 | 1669853 | 21697 |
52507 | 52507 | 2022-10-06 | Montana | 30 | 310997 | 3522 |
52508 | 52508 | 2022-10-06 | Nebraska | 31 | 538339 | 4548 |
52509 | 52509 | 2022-10-06 | Nevada | 32 | 848615 | 11516 |
52510 | 52510 | 2022-10-06 | New Hampshire | 33 | 351439 | 2708 |
52511 | 52511 | 2022-10-06 | New Jersey | 34 | 2752708 | 34773 |
52512 | 52512 | 2022-10-06 | New Mexico | 35 | 620060 | 8592 |
52513 | 52513 | 2022-10-06 | New York | 36 | 6134586 | 71224 |
52514 | 52514 | 2022-10-06 | North Carolina | 37 | 3210837 | 26862 |
52515 | 52515 | 2022-10-06 | North Dakota | 38 | 269306 | 2422 |
52516 | 52516 | 2022-10-06 | Northern Mariana Islands | 69 | 13171 | 40 |
52517 | 52517 | 2022-10-06 | Ohio | 39 | 3153743 | 39950 |
52518 | 52518 | 2022-10-06 | Oklahoma | 40 | 1199697 | 14884 |
52519 | 52519 | 2022-10-06 | Oregon | 41 | 899013 | 8590 |
52520 | 52520 | 2022-10-06 | Pennsylvania | 42 | 3266934 | 47323 |
52521 | 52521 | 2022-10-06 | Puerto Rico | 72 | 994339 | 5174 |
52522 | 52522 | 2022-10-06 | Rhode Island | 44 | 427242 | 3674 |
52523 | 52523 | 2022-10-06 | South Carolina | 45 | 1712281 | 18390 |
52524 | 52524 | 2022-10-06 | South Dakota | 46 | 262213 | 3033 |
52525 | 52525 | 2022-10-06 | Tennessee | 47 | 2284861 | 27623 |
52526 | 52526 | 2022-10-06 | Texas | 48 | 7892359 | 91089 |
52527 | 52527 | 2022-10-06 | Utah | 49 | 1040427 | 5028 |
52528 | 52528 | 2022-10-06 | Vermont | 50 | 143049 | 728 |
52529 | 52529 | 2022-10-06 | Virgin Islands | 78 | 23202 | 123 |
52530 | 52530 | 2022-10-06 | Virginia | 51 | 2095256 | 21950 |
52531 | 52531 | 2022-10-06 | Washington | 53 | 1821309 | 14422 |
52532 | 52532 | 2022-10-06 | West Virginia | 54 | 602173 | 7445 |
52533 | 52533 | 2022-10-06 | Wisconsin | 55 | 1872550 | 15298 |
52534 | 52534 | 2022-10-06 | Wyoming | 56 | 177165 | 1899 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );