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 2022-04-23 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 |
---|---|---|---|---|---|---|
43183 | 43183 | 2022-04-23 | Alabama | 1 | 1299137 | 19541 |
43184 | 43184 | 2022-04-23 | Alaska | 2 | 249901 | 1209 |
43185 | 43185 | 2022-04-23 | American Samoa | 60 | 5517 | 12 |
43186 | 43186 | 2022-04-23 | Arizona | 4 | 2019174 | 29852 |
43187 | 43187 | 2022-04-23 | Arkansas | 5 | 834946 | 11369 |
43188 | 43188 | 2022-04-23 | California | 6 | 9191757 | 90090 |
43189 | 43189 | 2022-04-23 | Colorado | 8 | 1381445 | 12293 |
43190 | 43190 | 2022-04-23 | Connecticut | 9 | 751810 | 10834 |
43191 | 43191 | 2022-04-23 | Delaware | 10 | 261399 | 2905 |
43192 | 43192 | 2022-04-23 | District of Columbia | 11 | 141355 | 1335 |
43193 | 43193 | 2022-04-23 | Florida | 12 | 5899188 | 73830 |
43194 | 43194 | 2022-04-23 | Georgia | 13 | 2439765 | 36217 |
43195 | 43195 | 2022-04-23 | Guam | 66 | 48895 | 355 |
43196 | 43196 | 2022-04-23 | Hawaii | 15 | 238763 | 1404 |
43197 | 43197 | 2022-04-23 | Idaho | 16 | 445646 | 4925 |
43198 | 43198 | 2022-04-23 | Illinois | 17 | 3119711 | 37859 |
43199 | 43199 | 2022-04-23 | Indiana | 18 | 1696759 | 23535 |
43200 | 43200 | 2022-04-23 | Iowa | 19 | 762036 | 9510 |
43201 | 43201 | 2022-04-23 | Kansas | 20 | 774680 | 8597 |
43202 | 43202 | 2022-04-23 | Kentucky | 21 | 1333378 | 15322 |
43203 | 43203 | 2022-04-23 | Louisiana | 22 | 1236111 | 17223 |
43204 | 43204 | 2022-04-23 | Maine | 23 | 242033 | 2280 |
43205 | 43205 | 2022-04-23 | Maryland | 24 | 1025184 | 14422 |
43206 | 43206 | 2022-04-23 | Massachusetts | 25 | 1738231 | 20222 |
43207 | 43207 | 2022-04-23 | Michigan | 26 | 2411464 | 35935 |
43208 | 43208 | 2022-04-23 | Minnesota | 27 | 1444119 | 12752 |
43209 | 43209 | 2022-04-23 | Mississippi | 28 | 796840 | 12436 |
43210 | 43210 | 2022-04-23 | Missouri | 29 | 1431774 | 20192 |
43211 | 43211 | 2022-04-23 | Montana | 30 | 273733 | 3262 |
43212 | 43212 | 2022-04-23 | Nebraska | 31 | 479181 | 4197 |
43213 | 43213 | 2022-04-23 | Nevada | 32 | 717368 | 10728 |
43214 | 43214 | 2022-04-23 | New Hampshire | 33 | 307528 | 2475 |
43215 | 43215 | 2022-04-23 | New Jersey | 34 | 2243235 | 33379 |
43216 | 43216 | 2022-04-23 | New Mexico | 35 | 521018 | 7444 |
43217 | 43217 | 2022-04-23 | New York | 36 | 5100177 | 67561 |
43218 | 43218 | 2022-04-23 | North Carolina | 37 | 2649561 | 23373 |
43219 | 43219 | 2022-04-23 | North Dakota | 38 | 240713 | 2308 |
43220 | 43220 | 2022-04-23 | Northern Mariana Islands | 69 | 11221 | 34 |
43221 | 43221 | 2022-04-23 | Ohio | 39 | 2688327 | 38360 |
43222 | 43222 | 2022-04-23 | Oklahoma | 40 | 1039415 | 14219 |
43223 | 43223 | 2022-04-23 | Oregon | 41 | 714346 | 7478 |
43224 | 43224 | 2022-04-23 | Pennsylvania | 42 | 2806984 | 44602 |
43225 | 43225 | 2022-04-23 | Puerto Rico | 72 | 546188 | 4190 |
43226 | 43226 | 2022-04-23 | Rhode Island | 44 | 368246 | 3532 |
43227 | 43227 | 2022-04-23 | South Carolina | 45 | 1472093 | 17734 |
43228 | 43228 | 2022-04-23 | South Dakota | 46 | 237535 | 2901 |
43229 | 43229 | 2022-04-23 | Tennessee | 47 | 1978688 | 25872 |
43230 | 43230 | 2022-04-23 | Texas | 48 | 6736643 | 88206 |
43231 | 43231 | 2022-04-23 | Utah | 49 | 930785 | 4740 |
43232 | 43232 | 2022-04-23 | Vermont | 50 | 121534 | 629 |
43233 | 43233 | 2022-04-23 | Virgin Islands | 78 | 16091 | 111 |
43234 | 43234 | 2022-04-23 | Virginia | 51 | 1691268 | 20149 |
43235 | 43235 | 2022-04-23 | Washington | 53 | 1484441 | 12708 |
43236 | 43236 | 2022-04-23 | West Virginia | 54 | 499796 | 6823 |
43237 | 43237 | 2022-04-23 | Wisconsin | 55 | 1601656 | 14403 |
43238 | 43238 | 2022-04-23 | Wyoming | 56 | 156392 | 1807 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );