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-08-03 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 |
---|---|---|---|---|---|---|
28505 | 28505 | 2021-08-03 | Alabama | 1 | 592417 | 11542 |
28506 | 28506 | 2021-08-03 | Alaska | 2 | 75892 | 374 |
28507 | 28507 | 2021-08-03 | Arizona | 4 | 933361 | 18282 |
28508 | 28508 | 2021-08-03 | Arkansas | 5 | 391623 | 6215 |
28509 | 28509 | 2021-08-03 | California | 6 | 4073891 | 64533 |
28510 | 28510 | 2021-08-03 | Colorado | 8 | 581450 | 7113 |
28511 | 28511 | 2021-08-03 | Connecticut | 9 | 356164 | 8292 |
28512 | 28512 | 2021-08-03 | Delaware | 10 | 111762 | 1833 |
28513 | 28513 | 2021-08-03 | District of Columbia | 11 | 50800 | 1149 |
28514 | 28514 | 2021-08-03 | Florida | 12 | 2641696 | 39179 |
28515 | 28515 | 2021-08-03 | Georgia | 13 | 1168207 | 21022 |
28516 | 28516 | 2021-08-03 | Guam | 66 | 9562 | 144 |
28517 | 28517 | 2021-08-03 | Hawaii | 15 | 41815 | 535 |
28518 | 28518 | 2021-08-03 | Idaho | 16 | 202113 | 2210 |
28519 | 28519 | 2021-08-03 | Illinois | 17 | 1431494 | 25940 |
28520 | 28520 | 2021-08-03 | Indiana | 18 | 779048 | 14025 |
28521 | 28521 | 2021-08-03 | Iowa | 19 | 381110 | 6183 |
28522 | 28522 | 2021-08-03 | Kansas | 20 | 335924 | 5299 |
28523 | 28523 | 2021-08-03 | Kentucky | 21 | 488907 | 7406 |
28524 | 28524 | 2021-08-03 | Louisiana | 22 | 557540 | 11085 |
28525 | 28525 | 2021-08-03 | Maine | 23 | 70718 | 900 |
28526 | 28526 | 2021-08-03 | Maryland | 24 | 470130 | 9835 |
28527 | 28527 | 2021-08-03 | Massachusetts | 25 | 722986 | 18086 |
28528 | 28528 | 2021-08-03 | Michigan | 26 | 1012554 | 21202 |
28529 | 28529 | 2021-08-03 | Minnesota | 27 | 615083 | 7771 |
28530 | 28530 | 2021-08-03 | Mississippi | 28 | 350070 | 7590 |
28531 | 28531 | 2021-08-03 | Missouri | 29 | 701784 | 10403 |
28532 | 28532 | 2021-08-03 | Montana | 30 | 117146 | 1716 |
28533 | 28533 | 2021-08-03 | Nebraska | 31 | 229443 | 2552 |
28534 | 28534 | 2021-08-03 | Nevada | 32 | 360147 | 5929 |
28535 | 28535 | 2021-08-03 | New Hampshire | 33 | 101155 | 1388 |
28536 | 28536 | 2021-08-03 | New Jersey | 34 | 1042472 | 26614 |
28537 | 28537 | 2021-08-03 | New Mexico | 35 | 211970 | 4417 |
28538 | 28538 | 2021-08-03 | New York | 36 | 2156305 | 53294 |
28539 | 28539 | 2021-08-03 | North Carolina | 37 | 1060143 | 13695 |
28540 | 28540 | 2021-08-03 | North Dakota | 38 | 111868 | 1571 |
28541 | 28541 | 2021-08-03 | Northern Mariana Islands | 69 | 198 | 2 |
28542 | 28542 | 2021-08-03 | Ohio | 39 | 1132798 | 20530 |
28543 | 28543 | 2021-08-03 | Oklahoma | 40 | 487178 | 7485 |
28544 | 28544 | 2021-08-03 | Oregon | 41 | 223364 | 2899 |
28545 | 28545 | 2021-08-03 | Pennsylvania | 42 | 1233461 | 27868 |
28546 | 28546 | 2021-08-03 | Puerto Rico | 72 | 181435 | 2585 |
28547 | 28547 | 2021-08-03 | Rhode Island | 44 | 154985 | 2740 |
28548 | 28548 | 2021-08-03 | South Carolina | 45 | 626038 | 9917 |
28549 | 28549 | 2021-08-03 | South Dakota | 46 | 125216 | 2043 |
28550 | 28550 | 2021-08-03 | Tennessee | 47 | 888787 | 12680 |
28551 | 28551 | 2021-08-03 | Texas | 48 | 3164075 | 53514 |
28552 | 28552 | 2021-08-03 | Utah | 49 | 435511 | 2471 |
28553 | 28553 | 2021-08-03 | Vermont | 50 | 25077 | 260 |
28554 | 28554 | 2021-08-03 | Virgin Islands | 78 | 4663 | 39 |
28555 | 28555 | 2021-08-03 | Virginia | 51 | 699342 | 11536 |
28556 | 28556 | 2021-08-03 | Washington | 53 | 482341 | 6177 |
28557 | 28557 | 2021-08-03 | West Virginia | 54 | 167948 | 2954 |
28558 | 28558 | 2021-08-03 | Wisconsin | 55 | 691068 | 8299 |
28559 | 28559 | 2021-08-03 | Wyoming | 56 | 65704 | 786 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );