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-07 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 |
---|---|---|---|---|---|---|
52535 | 52535 | 2022-10-07 | Alabama | 1 | 1526381 | 20473 |
52536 | 52536 | 2022-10-07 | Alaska | 2 | 297176 | 1350 |
52537 | 52537 | 2022-10-07 | American Samoa | 60 | 8244 | 34 |
52538 | 52538 | 2022-10-07 | Arizona | 4 | 2275235 | 31406 |
52539 | 52539 | 2022-10-07 | Arkansas | 5 | 953681 | 12276 |
52540 | 52540 | 2022-10-07 | California | 6 | 11290889 | 96242 |
52541 | 52541 | 2022-10-07 | Colorado | 8 | 1666305 | 13536 |
52542 | 52542 | 2022-10-07 | Connecticut | 9 | 901180 | 11385 |
52543 | 52543 | 2022-10-07 | Delaware | 10 | 309804 | 3112 |
52544 | 52544 | 2022-10-07 | District of Columbia | 11 | 168678 | 1392 |
52545 | 52545 | 2022-10-07 | Florida | 12 | 7129245 | 81661 |
52546 | 52546 | 2022-10-07 | Georgia | 13 | 2825163 | 38808 |
52547 | 52547 | 2022-10-07 | Guam | 66 | 59600 | 402 |
52548 | 52548 | 2022-10-07 | Hawaii | 15 | 348570 | 1691 |
52549 | 52549 | 2022-10-07 | Idaho | 16 | 497106 | 5190 |
52550 | 52550 | 2022-10-07 | Illinois | 17 | 3780353 | 39777 |
52551 | 52551 | 2022-10-07 | Indiana | 18 | 1925645 | 24748 |
52552 | 52552 | 2022-10-07 | Iowa | 19 | 857944 | 10097 |
52553 | 52553 | 2022-10-07 | Kansas | 20 | 880649 | 9590 |
52554 | 52554 | 2022-10-07 | Kentucky | 21 | 1601560 | 17030 |
52555 | 52555 | 2022-10-07 | Louisiana | 22 | 1457349 | 18102 |
52556 | 52556 | 2022-10-07 | Maine | 23 | 291596 | 2606 |
52557 | 52557 | 2022-10-07 | Maryland | 24 | 1254937 | 15423 |
52558 | 52558 | 2022-10-07 | Massachusetts | 25 | 2060884 | 21771 |
52559 | 52559 | 2022-10-07 | Michigan | 26 | 2849047 | 38767 |
52560 | 52560 | 2022-10-07 | Minnesota | 27 | 1670765 | 13695 |
52561 | 52561 | 2022-10-07 | Mississippi | 28 | 929079 | 12928 |
52562 | 52562 | 2022-10-07 | Missouri | 29 | 1673325 | 21719 |
52563 | 52563 | 2022-10-07 | Montana | 30 | 311995 | 3555 |
52564 | 52564 | 2022-10-07 | Nebraska | 31 | 538494 | 4551 |
52565 | 52565 | 2022-10-07 | Nevada | 32 | 848770 | 11521 |
52566 | 52566 | 2022-10-07 | New Hampshire | 33 | 351929 | 2709 |
52567 | 52567 | 2022-10-07 | New Jersey | 34 | 2755010 | 34779 |
52568 | 52568 | 2022-10-07 | New Mexico | 35 | 620306 | 8597 |
52569 | 52569 | 2022-10-07 | New York | 36 | 6139022 | 71257 |
52570 | 52570 | 2022-10-07 | North Carolina | 37 | 3210837 | 26862 |
52571 | 52571 | 2022-10-07 | North Dakota | 38 | 270288 | 2422 |
52572 | 52572 | 2022-10-07 | Northern Mariana Islands | 69 | 13171 | 40 |
52573 | 52573 | 2022-10-07 | Ohio | 39 | 3153743 | 39950 |
52574 | 52574 | 2022-10-07 | Oklahoma | 40 | 1200650 | 14884 |
52575 | 52575 | 2022-10-07 | Oregon | 41 | 899013 | 8590 |
52576 | 52576 | 2022-10-07 | Pennsylvania | 42 | 3266934 | 47323 |
52577 | 52577 | 2022-10-07 | Puerto Rico | 72 | 995128 | 5175 |
52578 | 52578 | 2022-10-07 | Rhode Island | 44 | 427242 | 3674 |
52579 | 52579 | 2022-10-07 | South Carolina | 45 | 1712281 | 18390 |
52580 | 52580 | 2022-10-07 | South Dakota | 46 | 262213 | 3033 |
52581 | 52581 | 2022-10-07 | Tennessee | 47 | 2285845 | 27627 |
52582 | 52582 | 2022-10-07 | Texas | 48 | 7896377 | 91124 |
52583 | 52583 | 2022-10-07 | Utah | 49 | 1040427 | 5028 |
52584 | 52584 | 2022-10-07 | Vermont | 50 | 143049 | 728 |
52585 | 52585 | 2022-10-07 | Virgin Islands | 78 | 23207 | 123 |
52586 | 52586 | 2022-10-07 | Virginia | 51 | 2096696 | 21970 |
52587 | 52587 | 2022-10-07 | Washington | 53 | 1822887 | 14431 |
52588 | 52588 | 2022-10-07 | West Virginia | 54 | 602461 | 7450 |
52589 | 52589 | 2022-10-07 | Wisconsin | 55 | 1873754 | 15303 |
52590 | 52590 | 2022-10-07 | 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 );