ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where "date" is on date 2021-07-19 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 55
- Alabama 1
- Alaska 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
- Nevada 1
- New Hampshire 1
- New Jersey 1
- New Mexico 1
- New York 1
- North Carolina 1
- North Dakota 1
- Northern Mariana Islands 1
- Ohio 1
- Oklahoma 1
- Oregon 1
- Pennsylvania 1
- Puerto Rico 1
- Rhode Island 1
- South Carolina 1
- South Dakota 1
- Tennessee 1
- Texas 1
- Utah 1
- Vermont 1
- Virgin Islands 1
- Virginia 1
- Washington 1
- West Virginia 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
27680 | 27680 | 2021-07-19 | Alabama | 1 | 560920 | 11443 |
27681 | 27681 | 2021-07-19 | Alaska | 2 | 72281 | 364 |
27682 | 27682 | 2021-07-19 | Arizona | 4 | 909282 | 18117 |
27683 | 27683 | 2021-07-19 | Arkansas | 5 | 365132 | 6007 |
27684 | 27684 | 2021-07-19 | California | 6 | 3945211 | 64127 |
27685 | 27685 | 2021-07-19 | Colorado | 8 | 569860 | 7040 |
27686 | 27686 | 2021-07-19 | Connecticut | 9 | 351084 | 8282 |
27687 | 27687 | 2021-07-19 | Delaware | 10 | 110423 | 1697 |
27688 | 27688 | 2021-07-19 | District of Columbia | 11 | 49793 | 1146 |
27689 | 27689 | 2021-07-19 | Florida | 12 | 2406809 | 38395 |
27690 | 27690 | 2021-07-19 | Georgia | 13 | 1124350 | 20868 |
27691 | 27691 | 2021-07-19 | Guam | 66 | 9447 | 144 |
27692 | 27692 | 2021-07-19 | Hawaii | 15 | 37839 | 520 |
27693 | 27693 | 2021-07-19 | Idaho | 16 | 197289 | 2178 |
27694 | 27694 | 2021-07-19 | Illinois | 17 | 1406608 | 25841 |
27695 | 27695 | 2021-07-19 | Indiana | 18 | 764833 | 13952 |
27696 | 27696 | 2021-07-19 | Iowa | 19 | 375726 | 6158 |
27697 | 27697 | 2021-07-19 | Kansas | 20 | 325544 | 5234 |
27698 | 27698 | 2021-07-19 | Kentucky | 21 | 471546 | 7344 |
27699 | 27699 | 2021-07-19 | Louisiana | 22 | 499932 | 10841 |
27700 | 27700 | 2021-07-19 | Maine | 23 | 69474 | 882 |
27701 | 27701 | 2021-07-19 | Maryland | 24 | 464553 | 9782 |
27702 | 27702 | 2021-07-19 | Massachusetts | 25 | 713037 | 18024 |
27703 | 27703 | 2021-07-19 | Michigan | 26 | 1002059 | 21096 |
27704 | 27704 | 2021-07-19 | Minnesota | 27 | 607877 | 7731 |
27705 | 27705 | 2021-07-19 | Mississippi | 28 | 329130 | 7468 |
27706 | 27706 | 2021-07-19 | Missouri | 29 | 663552 | 10116 |
27707 | 27707 | 2021-07-19 | Montana | 30 | 114851 | 1692 |
27708 | 27708 | 2021-07-19 | Nebraska | 31 | 226167 | 2541 |
27709 | 27709 | 2021-07-19 | Nevada | 32 | 345163 | 5761 |
27710 | 27710 | 2021-07-19 | New Hampshire | 33 | 99966 | 1382 |
27711 | 27711 | 2021-07-19 | New Jersey | 34 | 1029243 | 26545 |
27712 | 27712 | 2021-07-19 | New Mexico | 35 | 207566 | 4385 |
27713 | 27713 | 2021-07-19 | New York | 36 | 2125663 | 53195 |
27714 | 27714 | 2021-07-19 | North Carolina | 37 | 1026982 | 13551 |
27715 | 27715 | 2021-07-19 | North Dakota | 38 | 111050 | 1568 |
27716 | 27716 | 2021-07-19 | Northern Mariana Islands | 69 | 188 | 2 |
27717 | 27717 | 2021-07-19 | Ohio | 39 | 1117769 | 20437 |
27718 | 27718 | 2021-07-19 | Oklahoma | 40 | 466733 | 7417 |
27719 | 27719 | 2021-07-19 | Oregon | 41 | 212755 | 2857 |
27720 | 27720 | 2021-07-19 | Pennsylvania | 42 | 1221350 | 27795 |
27721 | 27721 | 2021-07-19 | Puerto Rico | 72 | 175520 | 2561 |
27722 | 27722 | 2021-07-19 | Rhode Island | 44 | 153103 | 2737 |
27723 | 27723 | 2021-07-19 | South Carolina | 45 | 603641 | 9857 |
27724 | 27724 | 2021-07-19 | South Dakota | 46 | 124750 | 2040 |
27725 | 27725 | 2021-07-19 | Tennessee | 47 | 862341 | 12548 |
27726 | 27726 | 2021-07-19 | Texas | 48 | 3037688 | 52966 |
27727 | 27727 | 2021-07-19 | Utah | 49 | 424242 | 2416 |
27728 | 27728 | 2021-07-19 | Vermont | 50 | 24579 | 259 |
27729 | 27729 | 2021-07-19 | Virgin Islands | 78 | 4186 | 32 |
27730 | 27730 | 2021-07-19 | Virginia | 51 | 685485 | 11483 |
27731 | 27731 | 2021-07-19 | Washington | 53 | 463232 | 6096 |
27732 | 27732 | 2021-07-19 | West Virginia | 54 | 165177 | 2919 |
27733 | 27733 | 2021-07-19 | Wisconsin | 55 | 680456 | 8212 |
27734 | 27734 | 2021-07-19 | Wyoming | 56 | 63709 | 760 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );