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 2020-11-22 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 |
---|---|---|---|---|---|---|
14535 | 14535 | 2020-11-22 | Alabama | 1 | 232506 | 3457 |
14536 | 14536 | 2020-11-22 | Alaska | 2 | 27629 | 97 |
14537 | 14537 | 2020-11-22 | Arizona | 4 | 299698 | 6464 |
14538 | 14538 | 2020-11-22 | Arkansas | 5 | 145173 | 2357 |
14539 | 14539 | 2020-11-22 | California | 6 | 1118673 | 18726 |
14540 | 14540 | 2020-11-22 | Colorado | 8 | 199296 | 2811 |
14541 | 14541 | 2020-11-22 | Connecticut | 9 | 101469 | 4828 |
14542 | 14542 | 2020-11-22 | Delaware | 10 | 31808 | 748 |
14543 | 14543 | 2020-11-22 | District of Columbia | 11 | 20151 | 670 |
14544 | 14544 | 2020-11-22 | Florida | 12 | 938406 | 17990 |
14545 | 14545 | 2020-11-22 | Georgia | 13 | 432954 | 8955 |
14546 | 14546 | 2020-11-22 | Guam | 66 | 7518 | 107 |
14547 | 14547 | 2020-11-22 | Hawaii | 15 | 17302 | 231 |
14548 | 14548 | 2020-11-22 | Idaho | 16 | 91935 | 852 |
14549 | 14549 | 2020-11-22 | Illinois | 17 | 657402 | 12064 |
14550 | 14550 | 2020-11-22 | Indiana | 18 | 298021 | 5305 |
14551 | 14551 | 2020-11-22 | Iowa | 19 | 211664 | 2202 |
14552 | 14552 | 2020-11-22 | Kansas | 20 | 137530 | 1410 |
14553 | 14553 | 2020-11-22 | Kentucky | 21 | 161222 | 1887 |
14554 | 14554 | 2020-11-22 | Louisiana | 22 | 220192 | 6260 |
14555 | 14555 | 2020-11-22 | Maine | 23 | 10359 | 176 |
14556 | 14556 | 2020-11-22 | Maryland | 24 | 182482 | 4434 |
14557 | 14557 | 2020-11-22 | Massachusetts | 25 | 206850 | 10512 |
14558 | 14558 | 2020-11-22 | Michigan | 26 | 328833 | 8874 |
14559 | 14559 | 2020-11-22 | Minnesota | 27 | 270213 | 3297 |
14560 | 14560 | 2020-11-22 | Mississippi | 28 | 143180 | 3676 |
14561 | 14561 | 2020-11-22 | Missouri | 29 | 283756 | 3688 |
14562 | 14562 | 2020-11-22 | Montana | 30 | 55680 | 607 |
14563 | 14563 | 2020-11-22 | Nebraska | 31 | 114061 | 937 |
14564 | 14564 | 2020-11-22 | Nevada | 32 | 134761 | 2022 |
14565 | 14565 | 2020-11-22 | New Hampshire | 33 | 17598 | 512 |
14566 | 14566 | 2020-11-22 | New Jersey | 34 | 307819 | 16761 |
14567 | 14567 | 2020-11-22 | New Mexico | 35 | 81896 | 1385 |
14568 | 14568 | 2020-11-22 | New York | 36 | 600967 | 33767 |
14569 | 14569 | 2020-11-22 | North Carolina | 37 | 336983 | 5062 |
14570 | 14570 | 2020-11-22 | North Dakota | 38 | 72689 | 846 |
14571 | 14571 | 2020-11-22 | Northern Mariana Islands | 69 | 104 | 2 |
14572 | 14572 | 2020-11-22 | Ohio | 39 | 351419 | 5996 |
14573 | 14573 | 2020-11-22 | Oklahoma | 40 | 174330 | 1634 |
14574 | 14574 | 2020-11-22 | Oregon | 41 | 65170 | 822 |
14575 | 14575 | 2020-11-22 | Pennsylvania | 42 | 313788 | 9901 |
14576 | 14576 | 2020-11-22 | Puerto Rico | 72 | 81074 | 1017 |
14577 | 14577 | 2020-11-22 | Rhode Island | 44 | 48001 | 1294 |
14578 | 14578 | 2020-11-22 | South Carolina | 45 | 206295 | 4283 |
14579 | 14579 | 2020-11-22 | South Dakota | 46 | 73065 | 819 |
14580 | 14580 | 2020-11-22 | Tennessee | 47 | 333853 | 4218 |
14581 | 14581 | 2020-11-22 | Texas | 48 | 1172761 | 21083 |
14582 | 14582 | 2020-11-22 | Utah | 49 | 177176 | 793 |
14583 | 14583 | 2020-11-22 | Vermont | 50 | 3629 | 63 |
14584 | 14584 | 2020-11-22 | Virgin Islands | 78 | 1504 | 23 |
14585 | 14585 | 2020-11-22 | Virginia | 51 | 217796 | 3938 |
14586 | 14586 | 2020-11-22 | Washington | 53 | 149703 | 2738 |
14587 | 14587 | 2020-11-22 | West Virginia | 54 | 40478 | 662 |
14588 | 14588 | 2020-11-22 | Wisconsin | 55 | 376238 | 3162 |
14589 | 14589 | 2020-11-22 | Wyoming | 56 | 28169 | 176 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );