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 2021-11-20 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 |
---|---|---|---|---|---|---|
34559 | 34559 | 2021-11-20 | Alabama | 1 | 842636 | 16073 |
34560 | 34560 | 2021-11-20 | Alaska | 2 | 147120 | 838 |
34561 | 34561 | 2021-11-20 | American Samoa | 60 | 5 | 0 |
34562 | 34562 | 2021-11-20 | Arizona | 4 | 1238249 | 21939 |
34563 | 34563 | 2021-11-20 | Arkansas | 5 | 523866 | 8612 |
34564 | 34564 | 2021-11-20 | California | 6 | 5038985 | 73927 |
34565 | 34565 | 2021-11-20 | Colorado | 8 | 808315 | 9059 |
34566 | 34566 | 2021-11-20 | Connecticut | 9 | 412918 | 8850 |
34567 | 34567 | 2021-11-20 | Delaware | 10 | 150046 | 2159 |
34568 | 34568 | 2021-11-20 | District of Columbia | 11 | 66028 | 1196 |
34569 | 34569 | 2021-11-20 | Florida | 12 | 3679548 | 61081 |
34570 | 34570 | 2021-11-20 | Georgia | 13 | 1620185 | 29057 |
34571 | 34571 | 2021-11-20 | Guam | 66 | 20030 | 263 |
34572 | 34572 | 2021-11-20 | Hawaii | 15 | 83896 | 999 |
34573 | 34573 | 2021-11-20 | Idaho | 16 | 303322 | 3847 |
34574 | 34574 | 2021-11-20 | Illinois | 17 | 1769267 | 29157 |
34575 | 34575 | 2021-11-20 | Indiana | 18 | 1073046 | 17247 |
34576 | 34576 | 2021-11-20 | Iowa | 19 | 513637 | 7268 |
34577 | 34577 | 2021-11-20 | Kansas | 20 | 456759 | 6668 |
34578 | 34578 | 2021-11-20 | Kentucky | 21 | 774878 | 10674 |
34579 | 34579 | 2021-11-20 | Louisiana | 22 | 767330 | 14749 |
34580 | 34580 | 2021-11-20 | Maine | 23 | 115857 | 1271 |
34581 | 34581 | 2021-11-20 | Maryland | 24 | 577246 | 11111 |
34582 | 34582 | 2021-11-20 | Massachusetts | 25 | 890733 | 19268 |
34583 | 34583 | 2021-11-20 | Michigan | 26 | 1405810 | 24814 |
34584 | 34584 | 2021-11-20 | Minnesota | 27 | 871327 | 9279 |
34585 | 34585 | 2021-11-20 | Mississippi | 28 | 510748 | 10229 |
34586 | 34586 | 2021-11-20 | Missouri | 29 | 906343 | 15411 |
34587 | 34587 | 2021-11-20 | Montana | 30 | 188217 | 2554 |
34588 | 34588 | 2021-11-20 | Nebraska | 31 | 301436 | 3108 |
34589 | 34589 | 2021-11-20 | Nevada | 32 | 464633 | 7918 |
34590 | 34590 | 2021-11-20 | New Hampshire | 33 | 150813 | 1662 |
34591 | 34591 | 2021-11-20 | New Jersey | 34 | 1230366 | 28250 |
34592 | 34592 | 2021-11-20 | New Mexico | 35 | 301937 | 5265 |
34593 | 34593 | 2021-11-20 | New York | 36 | 2664344 | 56681 |
34594 | 34594 | 2021-11-20 | North Carolina | 37 | 1517098 | 18617 |
34595 | 34595 | 2021-11-20 | North Dakota | 38 | 158375 | 1889 |
34596 | 34596 | 2021-11-20 | Northern Mariana Islands | 69 | 438 | 3 |
34597 | 34597 | 2021-11-20 | Ohio | 39 | 1639070 | 26063 |
34598 | 34598 | 2021-11-20 | Oklahoma | 40 | 658600 | 10879 |
34599 | 34599 | 2021-11-20 | Oregon | 41 | 384062 | 4914 |
34600 | 34600 | 2021-11-20 | Pennsylvania | 42 | 1680752 | 32911 |
34601 | 34601 | 2021-11-20 | Puerto Rico | 72 | 220936 | 3261 |
34602 | 34602 | 2021-11-20 | Rhode Island | 44 | 186387 | 2906 |
34603 | 34603 | 2021-11-20 | South Carolina | 45 | 911624 | 14096 |
34604 | 34604 | 2021-11-20 | South Dakota | 46 | 162375 | 2305 |
34605 | 34605 | 2021-11-20 | Tennessee | 47 | 1274480 | 16689 |
34606 | 34606 | 2021-11-20 | Texas | 48 | 4298114 | 73664 |
34607 | 34607 | 2021-11-20 | Utah | 49 | 583054 | 3428 |
34608 | 34608 | 2021-11-20 | Vermont | 50 | 46896 | 404 |
34609 | 34609 | 2021-11-20 | Virgin Islands | 78 | 7439 | 85 |
34610 | 34610 | 2021-11-20 | Virginia | 51 | 953460 | 14492 |
34611 | 34611 | 2021-11-20 | Washington | 53 | 764791 | 9157 |
34612 | 34612 | 2021-11-20 | West Virginia | 54 | 288247 | 4726 |
34613 | 34613 | 2021-11-20 | Wisconsin | 55 | 945854 | 9816 |
34614 | 34614 | 2021-11-20 | Wyoming | 56 | 109318 | 1347 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );