ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57,238 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Washington 644
- Illinois 640
- California 639
- Arizona 638
- Massachusetts 632
- Wisconsin 629
- Texas 622
- Nebraska 616
- Utah 609
- Oregon 605
- Florida 603
- New York 603
- Rhode Island 603
- Georgia 602
- New Hampshire 602
- North Carolina 601
- New Jersey 600
- Tennessee 600
- Colorado 599
- Maryland 599
- Nevada 599
- South Carolina 599
- Hawaii 598
- Indiana 598
- Kentucky 598
- Minnesota 598
- Oklahoma 598
- Pennsylvania 598
- Vermont 598
- Virginia 598
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
33147 | 33147 | 2021-10-25 | South Carolina | 45 | 893626 | 13559 |
33148 | 33148 | 2021-10-25 | South Dakota | 46 | 152603 | 2220 |
33149 | 33149 | 2021-10-25 | Tennessee | 47 | 1243433 | 16025 |
33150 | 33150 | 2021-10-25 | Texas | 48 | 4207000 | 70665 |
33151 | 33151 | 2021-10-25 | Utah | 49 | 542639 | 3149 |
33152 | 33152 | 2021-10-25 | Vermont | 50 | 38982 | 351 |
33153 | 33153 | 2021-10-25 | Virgin Islands | 78 | 7145 | 80 |
33154 | 33154 | 2021-10-25 | Virginia | 51 | 918700 | 13745 |
33155 | 33155 | 2021-10-25 | Washington | 53 | 718388 | 8531 |
33156 | 33156 | 2021-10-25 | West Virginia | 54 | 267398 | 4292 |
33157 | 33157 | 2021-10-25 | Wisconsin | 55 | 872164 | 9299 |
33158 | 33158 | 2021-10-25 | Wyoming | 56 | 101083 | 1149 |
33047 | 33047 | 2021-10-24 | Alabama | 1 | 820011 | 15407 |
33048 | 33048 | 2021-10-24 | Alaska | 2 | 132393 | 680 |
33049 | 33049 | 2021-10-24 | American Samoa | 60 | 4 | 0 |
33050 | 33050 | 2021-10-24 | Arizona | 4 | 1149824 | 20867 |
33051 | 33051 | 2021-10-24 | Arkansas | 5 | 510245 | 8281 |
33052 | 33052 | 2021-10-24 | California | 6 | 4869133 | 71528 |
33053 | 33053 | 2021-10-24 | Colorado | 8 | 725448 | 8220 |
33054 | 33054 | 2021-10-24 | Connecticut | 9 | 400226 | 8739 |
33055 | 33055 | 2021-10-24 | Delaware | 10 | 142354 | 2064 |
33056 | 33056 | 2021-10-24 | District of Columbia | 11 | 63588 | 1186 |
33057 | 33057 | 2021-10-24 | Florida | 12 | 3635126 | 58803 |
33058 | 33058 | 2021-10-24 | Georgia | 13 | 1589477 | 27513 |
33059 | 33059 | 2021-10-24 | Guam | 66 | 18441 | 228 |
33060 | 33060 | 2021-10-24 | Hawaii | 15 | 80722 | 885 |
33061 | 33061 | 2021-10-24 | Idaho | 16 | 285310 | 3414 |
33062 | 33062 | 2021-10-24 | Illinois | 17 | 1686159 | 28414 |
33063 | 33063 | 2021-10-24 | Indiana | 18 | 1011223 | 16470 |
33064 | 33064 | 2021-10-24 | Iowa | 19 | 479153 | 6848 |
33065 | 33065 | 2021-10-24 | Kansas | 20 | 429760 | 6238 |
33066 | 33066 | 2021-10-24 | Kentucky | 21 | 740355 | 9666 |
33067 | 33067 | 2021-10-24 | Louisiana | 22 | 755631 | 14462 |
33068 | 33068 | 2021-10-24 | Maine | 23 | 100967 | 1122 |
33069 | 33069 | 2021-10-24 | Maryland | 24 | 556314 | 10806 |
33070 | 33070 | 2021-10-24 | Massachusetts | 25 | 842652 | 18911 |
33071 | 33071 | 2021-10-24 | Michigan | 26 | 1244670 | 23286 |
33072 | 33072 | 2021-10-24 | Minnesota | 27 | 770370 | 8661 |
33073 | 33073 | 2021-10-24 | Mississippi | 28 | 501097 | 9990 |
33074 | 33074 | 2021-10-24 | Missouri | 29 | 865148 | 12672 |
33075 | 33075 | 2021-10-24 | Montana | 30 | 170756 | 2247 |
33076 | 33076 | 2021-10-24 | Nebraska | 31 | 279799 | 2938 |
33077 | 33077 | 2021-10-24 | Nevada | 32 | 445677 | 7523 |
33078 | 33078 | 2021-10-24 | New Hampshire | 33 | 131790 | 1543 |
33079 | 33079 | 2021-10-24 | New Jersey | 34 | 1189496 | 27851 |
33080 | 33080 | 2021-10-24 | New Mexico | 35 | 268891 | 4989 |
33081 | 33081 | 2021-10-24 | New York | 36 | 2531418 | 55756 |
33082 | 33082 | 2021-10-24 | North Carolina | 37 | 1465671 | 17783 |
33083 | 33083 | 2021-10-24 | North Dakota | 38 | 144783 | 1753 |
33084 | 33084 | 2021-10-24 | Northern Mariana Islands | 69 | 290 | 3 |
33085 | 33085 | 2021-10-24 | Ohio | 39 | 1521844 | 23955 |
33086 | 33086 | 2021-10-24 | Oklahoma | 40 | 638957 | 10540 |
33087 | 33087 | 2021-10-24 | Oregon | 41 | 357526 | 4284 |
33088 | 33088 | 2021-10-24 | Pennsylvania | 42 | 1538296 | 30972 |
33089 | 33089 | 2021-10-24 | Puerto Rico | 72 | 217762 | 3221 |
33090 | 33090 | 2021-10-24 | Rhode Island | 44 | 177998 | 2872 |
33091 | 33091 | 2021-10-24 | South Carolina | 45 | 891072 | 13472 |
33092 | 33092 | 2021-10-24 | South Dakota | 46 | 152308 | 2218 |
33093 | 33093 | 2021-10-24 | Tennessee | 47 | 1243433 | 16025 |
33094 | 33094 | 2021-10-24 | Texas | 48 | 4202609 | 70593 |
33095 | 33095 | 2021-10-24 | Utah | 49 | 539002 | 3128 |
33096 | 33096 | 2021-10-24 | Vermont | 50 | 38843 | 351 |
33097 | 33097 | 2021-10-24 | Virgin Islands | 78 | 7126 | 78 |
33098 | 33098 | 2021-10-24 | Virginia | 51 | 914755 | 13668 |
33099 | 33099 | 2021-10-24 | Washington | 53 | 713073 | 8501 |
33100 | 33100 | 2021-10-24 | West Virginia | 54 | 266521 | 4263 |
33101 | 33101 | 2021-10-24 | Wisconsin | 55 | 867697 | 9259 |
33102 | 33102 | 2021-10-24 | Wyoming | 56 | 100174 | 1149 |
32991 | 32991 | 2021-10-23 | Alabama | 1 | 819597 | 15406 |
32992 | 32992 | 2021-10-23 | Alaska | 2 | 132393 | 680 |
32993 | 32993 | 2021-10-23 | American Samoa | 60 | 4 | 0 |
32994 | 32994 | 2021-10-23 | Arizona | 4 | 1148341 | 20856 |
32995 | 32995 | 2021-10-23 | Arkansas | 5 | 509999 | 8267 |
32996 | 32996 | 2021-10-23 | California | 6 | 4868220 | 71519 |
32997 | 32997 | 2021-10-23 | Colorado | 8 | 724716 | 8218 |
32998 | 32998 | 2021-10-23 | Connecticut | 9 | 400226 | 8739 |
32999 | 32999 | 2021-10-23 | Delaware | 10 | 142058 | 2064 |
33000 | 33000 | 2021-10-23 | District of Columbia | 11 | 63588 | 1186 |
33001 | 33001 | 2021-10-23 | Florida | 12 | 3635126 | 58803 |
33002 | 33002 | 2021-10-23 | Georgia | 13 | 1589477 | 27513 |
33003 | 33003 | 2021-10-23 | Guam | 66 | 18441 | 228 |
33004 | 33004 | 2021-10-23 | Hawaii | 15 | 80569 | 882 |
33005 | 33005 | 2021-10-23 | Idaho | 16 | 285069 | 3414 |
33006 | 33006 | 2021-10-23 | Illinois | 17 | 1686159 | 28414 |
33007 | 33007 | 2021-10-23 | Indiana | 18 | 1011223 | 16470 |
33008 | 33008 | 2021-10-23 | Iowa | 19 | 479153 | 6848 |
33009 | 33009 | 2021-10-23 | Kansas | 20 | 429760 | 6238 |
33010 | 33010 | 2021-10-23 | Kentucky | 21 | 740355 | 9666 |
33011 | 33011 | 2021-10-23 | Louisiana | 22 | 755631 | 14462 |
33012 | 33012 | 2021-10-23 | Maine | 23 | 100967 | 1122 |
33013 | 33013 | 2021-10-23 | Maryland | 24 | 555597 | 10796 |
33014 | 33014 | 2021-10-23 | Massachusetts | 25 | 842652 | 18911 |
33015 | 33015 | 2021-10-23 | Michigan | 26 | 1244670 | 23286 |
33016 | 33016 | 2021-10-23 | Minnesota | 27 | 770370 | 8661 |
33017 | 33017 | 2021-10-23 | Mississippi | 28 | 501097 | 9990 |
33018 | 33018 | 2021-10-23 | Missouri | 29 | 864637 | 12672 |
33019 | 33019 | 2021-10-23 | Montana | 30 | 170756 | 2247 |
33020 | 33020 | 2021-10-23 | Nebraska | 31 | 279799 | 2938 |
33021 | 33021 | 2021-10-23 | Nevada | 32 | 445677 | 7523 |
33022 | 33022 | 2021-10-23 | New Hampshire | 33 | 131790 | 1543 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );