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-12-19 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|
36183 | 36183 | 2021-12-19 | Alabama | 1 | 857844 | 16353 |
36184 | 36184 | 2021-12-19 | Alaska | 2 | 153629 | 922 |
36185 | 36185 | 2021-12-19 | American Samoa | 60 | 10 | 0 |
36186 | 36186 | 2021-12-19 | Arizona | 4 | 1336806 | 23519 |
36187 | 36187 | 2021-12-19 | Arkansas | 5 | 543648 | 8956 |
36188 | 36188 | 2021-12-19 | California | 6 | 5208847 | 75927 |
36189 | 36189 | 2021-12-19 | Colorado | 8 | 871986 | 10075 |
36190 | 36190 | 2021-12-19 | Connecticut | 9 | 455566 | 9002 |
36191 | 36191 | 2021-12-19 | Delaware | 10 | 165621 | 2242 |
36192 | 36192 | 2021-12-19 | District of Columbia | 11 | 71219 | 1206 |
36193 | 36193 | 2021-12-19 | Florida | 12 | 3748148 | 62220 |
36194 | 36194 | 2021-12-19 | Georgia | 13 | 1657350 | 29862 |
36195 | 36195 | 2021-12-19 | Guam | 66 | 20341 | 271 |
36196 | 36196 | 2021-12-19 | Hawaii | 15 | 89675 | 1069 |
36197 | 36197 | 2021-12-19 | Idaho | 16 | 313994 | 4068 |
36198 | 36198 | 2021-12-19 | Illinois | 17 | 1949484 | 30202 |
36199 | 36199 | 2021-12-19 | Indiana | 18 | 1185226 | 18385 |
36200 | 36200 | 2021-12-19 | Iowa | 19 | 557029 | 7680 |
36201 | 36201 | 2021-12-19 | Kansas | 20 | 498771 | 6937 |
36202 | 36202 | 2021-12-19 | Kentucky | 21 | 830282 | 11805 |
36203 | 36203 | 2021-12-19 | Louisiana | 22 | 780668 | 14924 |
36204 | 36204 | 2021-12-19 | Maine | 23 | 136401 | 1441 |
36205 | 36205 | 2021-12-19 | Maryland | 24 | 592912 | 11255 |
36206 | 36206 | 2021-12-19 | Massachusetts | 25 | 1005470 | 19829 |
36207 | 36207 | 2021-12-19 | Michigan | 26 | 1611085 | 27705 |
36208 | 36208 | 2021-12-19 | Minnesota | 27 | 979407 | 10235 |
36209 | 36209 | 2021-12-19 | Mississippi | 28 | 522455 | 10354 |
36210 | 36210 | 2021-12-19 | Missouri | 29 | 976201 | 15880 |
36211 | 36211 | 2021-12-19 | Montana | 30 | 194970 | 2878 |
36212 | 36212 | 2021-12-19 | Nebraska | 31 | 326431 | 3298 |
36213 | 36213 | 2021-12-19 | Nevada | 32 | 483286 | 8278 |
36214 | 36214 | 2021-12-19 | New Hampshire | 33 | 183056 | 1836 |
36215 | 36215 | 2021-12-19 | New Jersey | 34 | 1345717 | 28714 |
36216 | 36216 | 2021-12-19 | New Mexico | 35 | 336790 | 5579 |
36217 | 36217 | 2021-12-19 | New York | 36 | 2956489 | 58097 |
36218 | 36218 | 2021-12-19 | North Carolina | 37 | 1589442 | 19131 |
36219 | 36219 | 2021-12-19 | North Dakota | 38 | 169478 | 2023 |
36220 | 36220 | 2021-12-19 | Northern Mariana Islands | 69 | 2422 | 8 |
36221 | 36221 | 2021-12-19 | Ohio | 39 | 1847140 | 28028 |
36222 | 36222 | 2021-12-19 | Oklahoma | 40 | 685906 | 11435 |
36223 | 36223 | 2021-12-19 | Oregon | 41 | 405292 | 5531 |
36224 | 36224 | 2021-12-19 | Pennsylvania | 42 | 1890259 | 35398 |
36225 | 36225 | 2021-12-19 | Puerto Rico | 72 | 229482 | 3285 |
36226 | 36226 | 2021-12-19 | Rhode Island | 44 | 208753 | 2992 |
36227 | 36227 | 2021-12-19 | South Carolina | 45 | 936207 | 14461 |
36228 | 36228 | 2021-12-19 | South Dakota | 46 | 173655 | 2433 |
36229 | 36229 | 2021-12-19 | Tennessee | 47 | 1318411 | 17828 |
36230 | 36230 | 2021-12-19 | Texas | 48 | 4424558 | 75392 |
36231 | 36231 | 2021-12-19 | Utah | 49 | 617840 | 3704 |
36232 | 36232 | 2021-12-19 | Vermont | 50 | 58695 | 452 |
36233 | 36233 | 2021-12-19 | Virgin Islands | 78 | 7640 | 88 |
36234 | 36234 | 2021-12-19 | Virginia | 51 | 1013390 | 15083 |
36235 | 36235 | 2021-12-19 | Washington | 53 | 803098 | 9725 |
36236 | 36236 | 2021-12-19 | West Virginia | 54 | 314791 | 5164 |
36237 | 36237 | 2021-12-19 | Wisconsin | 55 | 1054307 | 10667 |
36238 | 36238 | 2021-12-19 | Wyoming | 56 | 113584 | 1502 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );