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-11-05 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|
54159 | 54159 | 2022-11-05 | Alabama | 1 | 1534287 | 20558 |
54160 | 54160 | 2022-11-05 | Alaska | 2 | 298845 | 1369 |
54161 | 54161 | 2022-11-05 | American Samoa | 60 | 8257 | 34 |
54162 | 54162 | 2022-11-05 | Arizona | 4 | 2293015 | 31573 |
54163 | 54163 | 2022-11-05 | Arkansas | 5 | 961287 | 12519 |
54164 | 54164 | 2022-11-05 | California | 6 | 11385477 | 97025 |
54165 | 54165 | 2022-11-05 | Colorado | 8 | 1686535 | 13653 |
54166 | 54166 | 2022-11-05 | Connecticut | 9 | 914850 | 11478 |
54167 | 54167 | 2022-11-05 | Delaware | 10 | 313913 | 3147 |
54168 | 54168 | 2022-11-05 | District of Columbia | 11 | 170041 | 1397 |
54169 | 54169 | 2022-11-05 | Florida | 12 | 7172457 | 82541 |
54170 | 54170 | 2022-11-05 | Georgia | 13 | 2839500 | 39127 |
54171 | 54171 | 2022-11-05 | Guam | 66 | 59804 | 404 |
54172 | 54172 | 2022-11-05 | Hawaii | 15 | 354077 | 1708 |
54173 | 54173 | 2022-11-05 | Idaho | 16 | 501043 | 5228 |
54174 | 54174 | 2022-11-05 | Illinois | 17 | 3830714 | 40058 |
54175 | 54175 | 2022-11-05 | Indiana | 18 | 1942708 | 24950 |
54176 | 54176 | 2022-11-05 | Iowa | 19 | 864752 | 10207 |
54177 | 54177 | 2022-11-05 | Kansas | 20 | 890703 | 9645 |
54178 | 54178 | 2022-11-05 | Kentucky | 21 | 1618948 | 17322 |
54179 | 54179 | 2022-11-05 | Louisiana | 22 | 1463379 | 18193 |
54180 | 54180 | 2022-11-05 | Maine | 23 | 298571 | 2679 |
54181 | 54181 | 2022-11-05 | Maryland | 24 | 1272849 | 15592 |
54182 | 54182 | 2022-11-05 | Massachusetts | 25 | 2092838 | 22106 |
54183 | 54183 | 2022-11-05 | Michigan | 26 | 2897827 | 39407 |
54184 | 54184 | 2022-11-05 | Minnesota | 27 | 1691086 | 13873 |
54185 | 54185 | 2022-11-05 | Mississippi | 28 | 934401 | 12992 |
54186 | 54186 | 2022-11-05 | Missouri | 29 | 1690568 | 21869 |
54187 | 54187 | 2022-11-05 | Montana | 30 | 315584 | 3577 |
54188 | 54188 | 2022-11-05 | Nebraska | 31 | 536296 | 4562 |
54189 | 54189 | 2022-11-05 | Nevada | 32 | 854702 | 11570 |
54190 | 54190 | 2022-11-05 | New Hampshire | 33 | 357999 | 2769 |
54191 | 54191 | 2022-11-05 | New Jersey | 34 | 2805871 | 34942 |
54192 | 54192 | 2022-11-05 | New Mexico | 35 | 630704 | 8666 |
54193 | 54193 | 2022-11-05 | New York | 36 | 6260856 | 72537 |
54194 | 54194 | 2022-11-05 | North Carolina | 37 | 3246175 | 27244 |
54195 | 54195 | 2022-11-05 | North Dakota | 38 | 273779 | 2434 |
54196 | 54196 | 2022-11-05 | Northern Mariana Islands | 69 | 13212 | 41 |
54197 | 54197 | 2022-11-05 | Ohio | 39 | 3197300 | 40249 |
54198 | 54198 | 2022-11-05 | Oklahoma | 40 | 1211210 | 14992 |
54199 | 54199 | 2022-11-05 | Oregon | 41 | 910693 | 8726 |
54200 | 54200 | 2022-11-05 | Pennsylvania | 42 | 3317854 | 47840 |
54201 | 54201 | 2022-11-05 | Puerto Rico | 72 | 1020681 | 5276 |
54202 | 54202 | 2022-11-05 | Rhode Island | 44 | 433348 | 3705 |
54203 | 54203 | 2022-11-05 | South Carolina | 45 | 1725160 | 18633 |
54204 | 54204 | 2022-11-05 | South Dakota | 46 | 265019 | 3065 |
54205 | 54205 | 2022-11-05 | Tennessee | 47 | 2305487 | 27839 |
54206 | 54206 | 2022-11-05 | Texas | 48 | 7932946 | 91376 |
54207 | 54207 | 2022-11-05 | Utah | 49 | 1048168 | 5065 |
54208 | 54208 | 2022-11-05 | Vermont | 50 | 145409 | 754 |
54209 | 54209 | 2022-11-05 | Virgin Islands | 78 | 23388 | 124 |
54210 | 54210 | 2022-11-05 | Virginia | 51 | 2124932 | 22222 |
54211 | 54211 | 2022-11-05 | Washington | 53 | 1839300 | 14630 |
54212 | 54212 | 2022-11-05 | West Virginia | 54 | 609356 | 7534 |
54213 | 54213 | 2022-11-05 | Wisconsin | 55 | 1902612 | 15492 |
54214 | 54214 | 2022-11-05 | Wyoming | 56 | 178866 | 1914 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );