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-01-26 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- 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
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
18110 | 18110 | 2021-01-26 | Alabama | 1 | 445909 | 6896 |
18111 | 18111 | 2021-01-26 | Alaska | 2 | 53143 | 251 |
18112 | 18112 | 2021-01-26 | Arizona | 4 | 734613 | 12489 |
18113 | 18113 | 2021-01-26 | Arkansas | 5 | 287187 | 4690 |
18114 | 18114 | 2021-01-26 | California | 6 | 3234571 | 38222 |
18115 | 18115 | 2021-01-26 | Colorado | 8 | 390662 | 5617 |
18116 | 18116 | 2021-01-26 | Connecticut | 9 | 244899 | 6934 |
18117 | 18117 | 2021-01-26 | Delaware | 10 | 75490 | 1065 |
18118 | 18118 | 2021-01-26 | District of Columbia | 11 | 35700 | 888 |
18119 | 18119 | 2021-01-26 | Florida | 12 | 1667755 | 25672 |
18120 | 18120 | 2021-01-26 | Georgia | 13 | 855488 | 13065 |
18121 | 18121 | 2021-01-26 | Guam | 66 | 8535 | 130 |
18122 | 18122 | 2021-01-26 | Hawaii | 15 | 25272 | 398 |
18123 | 18123 | 2021-01-26 | Idaho | 16 | 160727 | 1691 |
18124 | 18124 | 2021-01-26 | Illinois | 17 | 1111028 | 20853 |
18125 | 18125 | 2021-01-26 | Indiana | 18 | 618037 | 9807 |
18126 | 18126 | 2021-01-26 | Iowa | 19 | 315002 | 4492 |
18127 | 18127 | 2021-01-26 | Kansas | 20 | 272303 | 3625 |
18128 | 18128 | 2021-01-26 | Kentucky | 21 | 354191 | 3769 |
18129 | 18129 | 2021-01-26 | Louisiana | 22 | 388562 | 8621 |
18130 | 18130 | 2021-01-26 | Maine | 23 | 37708 | 558 |
18131 | 18131 | 2021-01-26 | Maryland | 24 | 344839 | 6963 |
18132 | 18132 | 2021-01-26 | Massachusetts | 25 | 506183 | 14220 |
18133 | 18133 | 2021-01-26 | Michigan | 26 | 600175 | 15294 |
18134 | 18134 | 2021-01-26 | Minnesota | 27 | 456558 | 6174 |
18135 | 18135 | 2021-01-26 | Mississippi | 28 | 266598 | 5852 |
18136 | 18136 | 2021-01-26 | Missouri | 29 | 491544 | 7082 |
18137 | 18137 | 2021-01-26 | Montana | 30 | 92249 | 1186 |
18138 | 18138 | 2021-01-26 | Nebraska | 31 | 189151 | 1997 |
18139 | 18139 | 2021-01-26 | Nevada | 32 | 272942 | 4092 |
18140 | 18140 | 2021-01-26 | New Hampshire | 33 | 63172 | 994 |
18141 | 18141 | 2021-01-26 | New Jersey | 34 | 671727 | 21105 |
18142 | 18142 | 2021-01-26 | New Mexico | 35 | 170296 | 3173 |
18143 | 18143 | 2021-01-26 | New York | 36 | 1358964 | 42273 |
18144 | 18144 | 2021-01-26 | North Carolina | 37 | 728645 | 8839 |
18145 | 18145 | 2021-01-26 | North Dakota | 38 | 97031 | 1440 |
18146 | 18146 | 2021-01-26 | Northern Mariana Islands | 69 | 131 | 2 |
18147 | 18147 | 2021-01-26 | Ohio | 39 | 872918 | 10856 |
18148 | 18148 | 2021-01-26 | Oklahoma | 40 | 376424 | 3323 |
18149 | 18149 | 2021-01-26 | Oregon | 41 | 139355 | 1909 |
18150 | 18150 | 2021-01-26 | Pennsylvania | 42 | 818330 | 20883 |
18151 | 18151 | 2021-01-26 | Puerto Rico | 72 | 125684 | 1783 |
18152 | 18152 | 2021-01-26 | Rhode Island | 44 | 112396 | 2126 |
18153 | 18153 | 2021-01-26 | South Carolina | 45 | 423667 | 6578 |
18154 | 18154 | 2021-01-26 | South Dakota | 46 | 107380 | 1705 |
18155 | 18155 | 2021-01-26 | Tennessee | 47 | 699570 | 9078 |
18156 | 18156 | 2021-01-26 | Texas | 48 | 2288854 | 35544 |
18157 | 18157 | 2021-01-26 | Utah | 49 | 338675 | 1614 |
18158 | 18158 | 2021-01-26 | Vermont | 50 | 11285 | 171 |
18159 | 18159 | 2021-01-26 | Virgin Islands | 78 | 2373 | 24 |
18160 | 18160 | 2021-01-26 | Virginia | 51 | 483326 | 6174 |
18161 | 18161 | 2021-01-26 | Washington | 53 | 307880 | 4245 |
18162 | 18162 | 2021-01-26 | West Virginia | 54 | 116978 | 1928 |
18163 | 18163 | 2021-01-26 | Wisconsin | 55 | 584041 | 6268 |
18164 | 18164 | 2021-01-26 | Wyoming | 56 | 51152 | 596 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );