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-27 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|
43407 | 43407 | 2022-04-27 | Alabama | 1 | 1300278 | 19559 |
43408 | 43408 | 2022-04-27 | Alaska | 2 | 251388 | 1212 |
43409 | 43409 | 2022-04-27 | American Samoa | 60 | 5517 | 12 |
43410 | 43410 | 2022-04-27 | Arizona | 4 | 2021524 | 29951 |
43411 | 43411 | 2022-04-27 | Arkansas | 5 | 835408 | 11377 |
43412 | 43412 | 2022-04-27 | California | 6 | 9214424 | 90237 |
43413 | 43413 | 2022-04-27 | Colorado | 8 | 1385903 | 12356 |
43414 | 43414 | 2022-04-27 | Connecticut | 9 | 755971 | 10838 |
43415 | 43415 | 2022-04-27 | Delaware | 10 | 261958 | 2906 |
43416 | 43416 | 2022-04-27 | District of Columbia | 11 | 141943 | 1340 |
43417 | 43417 | 2022-04-27 | Florida | 12 | 5916354 | 73897 |
43418 | 43418 | 2022-04-27 | Georgia | 13 | 2445476 | 36349 |
43419 | 43419 | 2022-04-27 | Guam | 66 | 49036 | 355 |
43420 | 43420 | 2022-04-27 | Hawaii | 15 | 241955 | 1415 |
43421 | 43421 | 2022-04-27 | Idaho | 16 | 445921 | 4926 |
43422 | 43422 | 2022-04-27 | Illinois | 17 | 3133795 | 37881 |
43423 | 43423 | 2022-04-27 | Indiana | 18 | 1700774 | 23552 |
43424 | 43424 | 2022-04-27 | Iowa | 19 | 763072 | 9529 |
43425 | 43425 | 2022-04-27 | Kansas | 20 | 774680 | 8597 |
43426 | 43426 | 2022-04-27 | Kentucky | 21 | 1336202 | 15415 |
43427 | 43427 | 2022-04-27 | Louisiana | 22 | 1237321 | 17240 |
43428 | 43428 | 2022-04-27 | Maine | 23 | 243128 | 2282 |
43429 | 43429 | 2022-04-27 | Maryland | 24 | 1029016 | 14441 |
43430 | 43430 | 2022-04-27 | Massachusetts | 25 | 1749776 | 20247 |
43431 | 43431 | 2022-04-27 | Michigan | 26 | 2420092 | 35961 |
43432 | 43432 | 2022-04-27 | Minnesota | 27 | 1449209 | 12769 |
43433 | 43433 | 2022-04-27 | Mississippi | 28 | 797249 | 12439 |
43434 | 43434 | 2022-04-27 | Missouri | 29 | 1432998 | 20199 |
43435 | 43435 | 2022-04-27 | Montana | 30 | 274028 | 3354 |
43436 | 43436 | 2022-04-27 | Nebraska | 31 | 479685 | 4197 |
43437 | 43437 | 2022-04-27 | Nevada | 32 | 718437 | 10752 |
43438 | 43438 | 2022-04-27 | New Hampshire | 33 | 309193 | 2478 |
43439 | 43439 | 2022-04-27 | New Jersey | 34 | 2252045 | 33419 |
43440 | 43440 | 2022-04-27 | New Mexico | 35 | 521823 | 7465 |
43441 | 43441 | 2022-04-27 | New York | 36 | 5126231 | 67625 |
43442 | 43442 | 2022-04-27 | North Carolina | 37 | 2660970 | 23415 |
43443 | 43443 | 2022-04-27 | North Dakota | 38 | 240914 | 2310 |
43444 | 43444 | 2022-04-27 | Northern Mariana Islands | 69 | 11263 | 34 |
43445 | 43445 | 2022-04-27 | Ohio | 39 | 2688327 | 38360 |
43446 | 43446 | 2022-04-27 | Oklahoma | 40 | 1039952 | 14219 |
43447 | 43447 | 2022-04-27 | Oregon | 41 | 718630 | 7499 |
43448 | 43448 | 2022-04-27 | Pennsylvania | 42 | 2812954 | 44629 |
43449 | 43449 | 2022-04-27 | Puerto Rico | 72 | 556041 | 4195 |
43450 | 43450 | 2022-04-27 | Rhode Island | 44 | 370262 | 3538 |
43451 | 43451 | 2022-04-27 | South Carolina | 45 | 1472093 | 17734 |
43452 | 43452 | 2022-04-27 | South Dakota | 46 | 237812 | 2912 |
43453 | 43453 | 2022-04-27 | Tennessee | 47 | 1980088 | 25880 |
43454 | 43454 | 2022-04-27 | Texas | 48 | 6744065 | 88250 |
43455 | 43455 | 2022-04-27 | Utah | 49 | 930785 | 4740 |
43456 | 43456 | 2022-04-27 | Vermont | 50 | 123062 | 630 |
43457 | 43457 | 2022-04-27 | Virgin Islands | 78 | 16260 | 111 |
43458 | 43458 | 2022-04-27 | Virginia | 51 | 1697577 | 20202 |
43459 | 43459 | 2022-04-27 | Washington | 53 | 1493877 | 12735 |
43460 | 43460 | 2022-04-27 | West Virginia | 54 | 500697 | 6851 |
43461 | 43461 | 2022-04-27 | Wisconsin | 55 | 1607318 | 14411 |
43462 | 43462 | 2022-04-27 | Wyoming | 56 | 156550 | 1812 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );