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-10-04 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 |
---|---|---|---|---|---|---|
52367 | 52367 | 2022-10-04 | Alabama | 1 | 1524549 | 20423 |
52368 | 52368 | 2022-10-04 | Alaska | 2 | 296491 | 1321 |
52369 | 52369 | 2022-10-04 | American Samoa | 60 | 8244 | 34 |
52370 | 52370 | 2022-10-04 | Arizona | 4 | 2271560 | 31370 |
52371 | 52371 | 2022-10-04 | Arkansas | 5 | 952469 | 12213 |
52372 | 52372 | 2022-10-04 | California | 6 | 11267236 | 96119 |
52373 | 52373 | 2022-10-04 | Colorado | 8 | 1664007 | 13522 |
52374 | 52374 | 2022-10-04 | Connecticut | 9 | 899205 | 11385 |
52375 | 52375 | 2022-10-04 | Delaware | 10 | 309265 | 3112 |
52376 | 52376 | 2022-10-04 | District of Columbia | 11 | 168614 | 1392 |
52377 | 52377 | 2022-10-04 | Florida | 12 | 7123858 | 81464 |
52378 | 52378 | 2022-10-04 | Georgia | 13 | 2821158 | 38717 |
52379 | 52379 | 2022-10-04 | Guam | 66 | 59560 | 402 |
52380 | 52380 | 2022-10-04 | Hawaii | 15 | 347333 | 1683 |
52381 | 52381 | 2022-10-04 | Idaho | 16 | 496268 | 5184 |
52382 | 52382 | 2022-10-04 | Illinois | 17 | 3774122 | 39732 |
52383 | 52383 | 2022-10-04 | Indiana | 18 | 1921993 | 24708 |
52384 | 52384 | 2022-10-04 | Iowa | 19 | 857128 | 10077 |
52385 | 52385 | 2022-10-04 | Kansas | 20 | 879019 | 9555 |
52386 | 52386 | 2022-10-04 | Kentucky | 21 | 1601168 | 17030 |
52387 | 52387 | 2022-10-04 | Louisiana | 22 | 1456295 | 18079 |
52388 | 52388 | 2022-10-04 | Maine | 23 | 290616 | 2584 |
52389 | 52389 | 2022-10-04 | Maryland | 24 | 1252630 | 15412 |
52390 | 52390 | 2022-10-04 | Massachusetts | 25 | 2050942 | 21706 |
52391 | 52391 | 2022-10-04 | Michigan | 26 | 2840530 | 38716 |
52392 | 52392 | 2022-10-04 | Minnesota | 27 | 1664797 | 13651 |
52393 | 52393 | 2022-10-04 | Mississippi | 28 | 929079 | 12928 |
52394 | 52394 | 2022-10-04 | Missouri | 29 | 1669267 | 21695 |
52395 | 52395 | 2022-10-04 | Montana | 30 | 310997 | 3522 |
52396 | 52396 | 2022-10-04 | Nebraska | 31 | 537466 | 4542 |
52397 | 52397 | 2022-10-04 | Nevada | 32 | 847877 | 11509 |
52398 | 52398 | 2022-10-04 | New Hampshire | 33 | 351047 | 2708 |
52399 | 52399 | 2022-10-04 | New Jersey | 34 | 2748202 | 34759 |
52400 | 52400 | 2022-10-04 | New Mexico | 35 | 619479 | 8578 |
52401 | 52401 | 2022-10-04 | New York | 36 | 6125135 | 71167 |
52402 | 52402 | 2022-10-04 | North Carolina | 37 | 3198866 | 26535 |
52403 | 52403 | 2022-10-04 | North Dakota | 38 | 269306 | 2422 |
52404 | 52404 | 2022-10-04 | Northern Mariana Islands | 69 | 13171 | 40 |
52405 | 52405 | 2022-10-04 | Ohio | 39 | 3143746 | 39856 |
52406 | 52406 | 2022-10-04 | Oklahoma | 40 | 1199697 | 14805 |
52407 | 52407 | 2022-10-04 | Oregon | 41 | 894776 | 8561 |
52408 | 52408 | 2022-10-04 | Pennsylvania | 42 | 3254818 | 47213 |
52409 | 52409 | 2022-10-04 | Puerto Rico | 72 | 992662 | 5157 |
52410 | 52410 | 2022-10-04 | Rhode Island | 44 | 425461 | 3669 |
52411 | 52411 | 2022-10-04 | South Carolina | 45 | 1712281 | 18390 |
52412 | 52412 | 2022-10-04 | South Dakota | 46 | 261371 | 3021 |
52413 | 52413 | 2022-10-04 | Tennessee | 47 | 2283147 | 27595 |
52414 | 52414 | 2022-10-04 | Texas | 48 | 7888580 | 91044 |
52415 | 52415 | 2022-10-04 | Utah | 49 | 1038696 | 5021 |
52416 | 52416 | 2022-10-04 | Vermont | 50 | 142443 | 719 |
52417 | 52417 | 2022-10-04 | Virgin Islands | 78 | 23187 | 123 |
52418 | 52418 | 2022-10-04 | Virginia | 51 | 2092383 | 21911 |
52419 | 52419 | 2022-10-04 | Washington | 53 | 1819383 | 14385 |
52420 | 52420 | 2022-10-04 | West Virginia | 54 | 601520 | 7436 |
52421 | 52421 | 2022-10-04 | Wisconsin | 55 | 1870016 | 15272 |
52422 | 52422 | 2022-10-04 | Wyoming | 56 | 177165 | 1899 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );