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-11 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 |
---|---|---|---|---|---|---|
13930 | 13930 | 2020-11-11 | Alabama | 1 | 208637 | 3201 |
13931 | 13931 | 2020-11-11 | Alaska | 2 | 21211 | 90 |
13932 | 13932 | 2020-11-11 | Arizona | 4 | 265195 | 6228 |
13933 | 13933 | 2020-11-11 | Arkansas | 5 | 126197 | 2126 |
13934 | 13934 | 2020-11-11 | California | 6 | 999516 | 18109 |
13935 | 13935 | 2020-11-11 | Colorado | 8 | 143553 | 2481 |
13936 | 13936 | 2020-11-11 | Connecticut | 9 | 84741 | 4716 |
13937 | 13937 | 2020-11-11 | Delaware | 10 | 27342 | 724 |
13938 | 13938 | 2020-11-11 | District of Columbia | 11 | 18379 | 657 |
13939 | 13939 | 2020-11-11 | Florida | 12 | 858004 | 17299 |
13940 | 13940 | 2020-11-11 | Georgia | 13 | 398769 | 8582 |
13941 | 13941 | 2020-11-11 | Guam | 66 | 6724 | 92 |
13942 | 13942 | 2020-11-11 | Hawaii | 15 | 16309 | 221 |
13943 | 13943 | 2020-11-11 | Idaho | 16 | 77536 | 738 |
13944 | 13944 | 2020-11-11 | Illinois | 17 | 525072 | 10805 |
13945 | 13945 | 2020-11-11 | Indiana | 18 | 226935 | 4762 |
13946 | 13946 | 2020-11-11 | Iowa | 19 | 168457 | 1927 |
13947 | 13947 | 2020-11-11 | Kansas | 20 | 110977 | 1215 |
13948 | 13948 | 2020-11-11 | Kentucky | 21 | 130308 | 1689 |
13949 | 13949 | 2020-11-11 | Louisiana | 22 | 194702 | 6058 |
13950 | 13950 | 2020-11-11 | Maine | 23 | 8202 | 158 |
13951 | 13951 | 2020-11-11 | Maryland | 24 | 158836 | 4249 |
13952 | 13952 | 2020-11-11 | Massachusetts | 25 | 177541 | 10222 |
13953 | 13953 | 2020-11-11 | Michigan | 26 | 251499 | 8137 |
13954 | 13954 | 2020-11-11 | Minnesota | 27 | 194626 | 2810 |
13955 | 13955 | 2020-11-11 | Mississippi | 28 | 129394 | 3497 |
13956 | 13956 | 2020-11-11 | Missouri | 29 | 230003 | 3411 |
13957 | 13957 | 2020-11-11 | Montana | 30 | 42132 | 475 |
13958 | 13958 | 2020-11-11 | Nebraska | 31 | 89977 | 745 |
13959 | 13959 | 2020-11-11 | Nevada | 32 | 113856 | 1877 |
13960 | 13960 | 2020-11-11 | New Hampshire | 33 | 13148 | 492 |
13961 | 13961 | 2020-11-11 | New Jersey | 34 | 265295 | 16476 |
13962 | 13962 | 2020-11-11 | New Mexico | 35 | 59034 | 1158 |
13963 | 13963 | 2020-11-11 | New York | 36 | 545718 | 33398 |
13964 | 13964 | 2020-11-11 | North Carolina | 37 | 300725 | 4723 |
13965 | 13965 | 2020-11-11 | North Dakota | 38 | 57378 | 691 |
13966 | 13966 | 2020-11-11 | Northern Mariana Islands | 69 | 100 | 2 |
13967 | 13967 | 2020-11-11 | Ohio | 39 | 267356 | 5623 |
13968 | 13968 | 2020-11-11 | Oklahoma | 40 | 142334 | 1470 |
13969 | 13969 | 2020-11-11 | Oregon | 41 | 52770 | 746 |
13970 | 13970 | 2020-11-11 | Pennsylvania | 42 | 248144 | 9217 |
13971 | 13971 | 2020-11-11 | Puerto Rico | 72 | 72735 | 901 |
13972 | 13972 | 2020-11-11 | Rhode Island | 44 | 39776 | 1243 |
13973 | 13973 | 2020-11-11 | South Carolina | 45 | 188995 | 4076 |
13974 | 13974 | 2020-11-11 | South Dakota | 46 | 58696 | 567 |
13975 | 13975 | 2020-11-11 | Tennessee | 47 | 288311 | 3727 |
13976 | 13976 | 2020-11-11 | Texas | 48 | 1051071 | 19544 |
13977 | 13977 | 2020-11-11 | Utah | 49 | 139815 | 678 |
13978 | 13978 | 2020-11-11 | Vermont | 50 | 2535 | 59 |
13979 | 13979 | 2020-11-11 | Virgin Islands | 78 | 1413 | 23 |
13980 | 13980 | 2020-11-11 | Virginia | 51 | 196506 | 3741 |
13981 | 13981 | 2020-11-11 | Washington | 53 | 126886 | 2595 |
13982 | 13982 | 2020-11-11 | West Virginia | 54 | 30201 | 553 |
13983 | 13983 | 2020-11-11 | Wisconsin | 55 | 301349 | 2562 |
13984 | 13984 | 2020-11-11 | Wyoming | 56 | 19374 | 127 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );