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-04-12 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|
22290 | 22290 | 2021-04-12 | Alabama | 1 | 519071 | 10712 |
22291 | 22291 | 2021-04-12 | Alaska | 2 | 64655 | 300 |
22292 | 22292 | 2021-04-12 | Arizona | 4 | 850246 | 17086 |
22293 | 22293 | 2021-04-12 | Arkansas | 5 | 332222 | 5665 |
22294 | 22294 | 2021-04-12 | California | 6 | 3704295 | 60484 |
22295 | 22295 | 2021-04-12 | Colorado | 8 | 482471 | 6209 |
22296 | 22296 | 2021-04-12 | Connecticut | 9 | 324571 | 7957 |
22297 | 22297 | 2021-04-12 | Delaware | 10 | 98925 | 1581 |
22298 | 22298 | 2021-04-12 | District of Columbia | 11 | 45903 | 1084 |
22299 | 22299 | 2021-04-12 | Florida | 12 | 2125838 | 34055 |
22300 | 22300 | 2021-04-12 | Georgia | 13 | 1050915 | 18920 |
22301 | 22301 | 2021-04-12 | Guam | 66 | 8811 | 137 |
22302 | 22302 | 2021-04-12 | Hawaii | 15 | 31113 | 468 |
22303 | 22303 | 2021-04-12 | Idaho | 16 | 183840 | 2001 |
22304 | 22304 | 2021-04-12 | Illinois | 17 | 1285780 | 23809 |
22305 | 22305 | 2021-04-12 | Indiana | 18 | 703118 | 13151 |
22306 | 22306 | 2021-04-12 | Iowa | 19 | 357197 | 5857 |
22307 | 22307 | 2021-04-12 | Kansas | 20 | 306998 | 4930 |
22308 | 22308 | 2021-04-12 | Kentucky | 21 | 436825 | 6355 |
22309 | 22309 | 2021-04-12 | Louisiana | 22 | 449827 | 10241 |
22310 | 22310 | 2021-04-12 | Maine | 23 | 54256 | 751 |
22311 | 22311 | 2021-04-12 | Maryland | 24 | 427901 | 8470 |
22312 | 22312 | 2021-04-12 | Massachusetts | 25 | 661101 | 17406 |
22313 | 22313 | 2021-04-12 | Michigan | 26 | 829424 | 17566 |
22314 | 22314 | 2021-04-12 | Minnesota | 27 | 544124 | 7037 |
22315 | 22315 | 2021-04-12 | Mississippi | 28 | 307519 | 7096 |
22316 | 22316 | 2021-04-12 | Missouri | 29 | 596027 | 9010 |
22317 | 22317 | 2021-04-12 | Montana | 30 | 106360 | 1526 |
22318 | 22318 | 2021-04-12 | Nebraska | 31 | 214351 | 2332 |
22319 | 22319 | 2021-04-12 | Nevada | 32 | 308343 | 5332 |
22320 | 22320 | 2021-04-12 | New Hampshire | 33 | 89229 | 1257 |
22321 | 22321 | 2021-04-12 | New Jersey | 34 | 955966 | 24896 |
22322 | 22322 | 2021-04-12 | New Mexico | 35 | 193987 | 3981 |
22323 | 22323 | 2021-04-12 | New York | 36 | 1960567 | 50693 |
22324 | 22324 | 2021-04-12 | North Carolina | 37 | 936163 | 12320 |
22325 | 22325 | 2021-04-12 | North Dakota | 38 | 104839 | 1502 |
22326 | 22326 | 2021-04-12 | Northern Mariana Islands | 69 | 160 | 2 |
22327 | 22327 | 2021-04-12 | Ohio | 39 | 1041389 | 18827 |
22328 | 22328 | 2021-04-12 | Oklahoma | 40 | 443773 | 6669 |
22329 | 22329 | 2021-04-12 | Oregon | 41 | 170937 | 2455 |
22330 | 22330 | 2021-04-12 | Pennsylvania | 42 | 1080998 | 25460 |
22331 | 22331 | 2021-04-12 | Puerto Rico | 72 | 148914 | 2155 |
22332 | 22332 | 2021-04-12 | Rhode Island | 44 | 141097 | 2638 |
22333 | 22333 | 2021-04-12 | South Carolina | 45 | 563427 | 9276 |
22334 | 22334 | 2021-04-12 | South Dakota | 46 | 119892 | 1947 |
22335 | 22335 | 2021-04-12 | Tennessee | 47 | 810376 | 11914 |
22336 | 22336 | 2021-04-12 | Texas | 48 | 2828568 | 49393 |
22337 | 22337 | 2021-04-12 | Utah | 49 | 390350 | 2159 |
22338 | 22338 | 2021-04-12 | Vermont | 50 | 21291 | 233 |
22339 | 22339 | 2021-04-12 | Virgin Islands | 78 | 2998 | 26 |
22340 | 22340 | 2021-04-12 | Virginia | 51 | 636862 | 10486 |
22341 | 22341 | 2021-04-12 | Washington | 53 | 380554 | 5380 |
22342 | 22342 | 2021-04-12 | West Virginia | 54 | 146462 | 2745 |
22343 | 22343 | 2021-04-12 | Wisconsin | 55 | 646176 | 7384 |
22344 | 22344 | 2021-04-12 | Wyoming | 56 | 56988 | 701 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );