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-06 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 |
---|---|---|---|---|---|---|
54215 | 54215 | 2022-11-06 | Alabama | 1 | 1534287 | 20558 |
54216 | 54216 | 2022-11-06 | Alaska | 2 | 298845 | 1369 |
54217 | 54217 | 2022-11-06 | American Samoa | 60 | 8257 | 34 |
54218 | 54218 | 2022-11-06 | Arizona | 4 | 2293015 | 31573 |
54219 | 54219 | 2022-11-06 | Arkansas | 5 | 961765 | 12521 |
54220 | 54220 | 2022-11-06 | California | 6 | 11385477 | 97025 |
54221 | 54221 | 2022-11-06 | Colorado | 8 | 1686535 | 13653 |
54222 | 54222 | 2022-11-06 | Connecticut | 9 | 915594 | 11478 |
54223 | 54223 | 2022-11-06 | Delaware | 10 | 313913 | 3147 |
54224 | 54224 | 2022-11-06 | District of Columbia | 11 | 170041 | 1397 |
54225 | 54225 | 2022-11-06 | Florida | 12 | 7172457 | 82541 |
54226 | 54226 | 2022-11-06 | Georgia | 13 | 2839500 | 39127 |
54227 | 54227 | 2022-11-06 | Guam | 66 | 59804 | 404 |
54228 | 54228 | 2022-11-06 | Hawaii | 15 | 354077 | 1708 |
54229 | 54229 | 2022-11-06 | Idaho | 16 | 501043 | 5228 |
54230 | 54230 | 2022-11-06 | Illinois | 17 | 3830714 | 40058 |
54231 | 54231 | 2022-11-06 | Indiana | 18 | 1942708 | 24950 |
54232 | 54232 | 2022-11-06 | Iowa | 19 | 864752 | 10207 |
54233 | 54233 | 2022-11-06 | Kansas | 20 | 890703 | 9645 |
54234 | 54234 | 2022-11-06 | Kentucky | 21 | 1618948 | 17322 |
54235 | 54235 | 2022-11-06 | Louisiana | 22 | 1463379 | 18193 |
54236 | 54236 | 2022-11-06 | Maine | 23 | 298571 | 2679 |
54237 | 54237 | 2022-11-06 | Maryland | 24 | 1272849 | 15592 |
54238 | 54238 | 2022-11-06 | Massachusetts | 25 | 2092838 | 22106 |
54239 | 54239 | 2022-11-06 | Michigan | 26 | 2897827 | 39407 |
54240 | 54240 | 2022-11-06 | Minnesota | 27 | 1691086 | 13873 |
54241 | 54241 | 2022-11-06 | Mississippi | 28 | 934401 | 12992 |
54242 | 54242 | 2022-11-06 | Missouri | 29 | 1690568 | 21869 |
54243 | 54243 | 2022-11-06 | Montana | 30 | 315584 | 3577 |
54244 | 54244 | 2022-11-06 | Nebraska | 31 | 536296 | 4562 |
54245 | 54245 | 2022-11-06 | Nevada | 32 | 854702 | 11570 |
54246 | 54246 | 2022-11-06 | New Hampshire | 33 | 357999 | 2769 |
54247 | 54247 | 2022-11-06 | New Jersey | 34 | 2808399 | 34942 |
54248 | 54248 | 2022-11-06 | New Mexico | 35 | 630704 | 8666 |
54249 | 54249 | 2022-11-06 | New York | 36 | 6262784 | 72537 |
54250 | 54250 | 2022-11-06 | North Carolina | 37 | 3246175 | 27244 |
54251 | 54251 | 2022-11-06 | North Dakota | 38 | 273779 | 2434 |
54252 | 54252 | 2022-11-06 | Northern Mariana Islands | 69 | 13212 | 41 |
54253 | 54253 | 2022-11-06 | Ohio | 39 | 3197300 | 40249 |
54254 | 54254 | 2022-11-06 | Oklahoma | 40 | 1211210 | 14992 |
54255 | 54255 | 2022-11-06 | Oregon | 41 | 910693 | 8726 |
54256 | 54256 | 2022-11-06 | Pennsylvania | 42 | 3317854 | 47840 |
54257 | 54257 | 2022-11-06 | Puerto Rico | 72 | 1021642 | 5279 |
54258 | 54258 | 2022-11-06 | Rhode Island | 44 | 433348 | 3705 |
54259 | 54259 | 2022-11-06 | South Carolina | 45 | 1725160 | 18633 |
54260 | 54260 | 2022-11-06 | South Dakota | 46 | 265019 | 3065 |
54261 | 54261 | 2022-11-06 | Tennessee | 47 | 2305487 | 27839 |
54262 | 54262 | 2022-11-06 | Texas | 48 | 7932946 | 91376 |
54263 | 54263 | 2022-11-06 | Utah | 49 | 1048168 | 5065 |
54264 | 54264 | 2022-11-06 | Vermont | 50 | 145409 | 754 |
54265 | 54265 | 2022-11-06 | Virgin Islands | 78 | 23388 | 124 |
54266 | 54266 | 2022-11-06 | Virginia | 51 | 2124932 | 22222 |
54267 | 54267 | 2022-11-06 | Washington | 53 | 1839300 | 14630 |
54268 | 54268 | 2022-11-06 | West Virginia | 54 | 609356 | 7534 |
54269 | 54269 | 2022-11-06 | Wisconsin | 55 | 1902612 | 15492 |
54270 | 54270 | 2022-11-06 | 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 );