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-09-28 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 56
- 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
- Nevada 1
- New Hampshire 1
- New Jersey 1
- New Mexico 1
- New York 1
- North Carolina 1
- North Dakota 1
- Northern Mariana Islands 1
- Ohio 1
- Oklahoma 1
- Oregon 1
- Pennsylvania 1
- Puerto Rico 1
- Rhode Island 1
- South Carolina 1
- South Dakota 1
- Tennessee 1
- Texas 1
- Utah 1
- Vermont 1
- Virgin Islands 1
- Virginia 1
- Washington 1
- West Virginia 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|
52033 | 52033 | 2022-09-28 | American Samoa | 60 | 8244 | 34 |
52068 | 52068 | 2022-09-28 | Northern Mariana Islands | 69 | 13171 | 40 |
52081 | 52081 | 2022-09-28 | Virgin Islands | 78 | 23154 | 123 |
52043 | 52043 | 2022-09-28 | Guam | 66 | 59479 | 402 |
52080 | 52080 | 2022-09-28 | Vermont | 50 | 142443 | 719 |
52032 | 52032 | 2022-09-28 | Alaska | 2 | 296491 | 1321 |
52040 | 52040 | 2022-09-28 | District of Columbia | 11 | 168359 | 1383 |
52044 | 52044 | 2022-09-28 | Hawaii | 15 | 347333 | 1683 |
52086 | 52086 | 2022-09-28 | Wyoming | 56 | 176728 | 1894 |
52067 | 52067 | 2022-09-28 | North Dakota | 38 | 268307 | 2411 |
52052 | 52052 | 2022-09-28 | Maine | 23 | 289066 | 2577 |
52062 | 52062 | 2022-09-28 | New Hampshire | 33 | 349846 | 2703 |
52076 | 52076 | 2022-09-28 | South Dakota | 46 | 261371 | 3021 |
52039 | 52039 | 2022-09-28 | Delaware | 10 | 308252 | 3104 |
52059 | 52059 | 2022-09-28 | Montana | 30 | 309730 | 3518 |
52074 | 52074 | 2022-09-28 | Rhode Island | 44 | 423563 | 3667 |
52060 | 52060 | 2022-09-28 | Nebraska | 31 | 537089 | 4523 |
52079 | 52079 | 2022-09-28 | Utah | 49 | 1036814 | 5011 |
52073 | 52073 | 2022-09-28 | Puerto Rico | 72 | 985993 | 5129 |
52045 | 52045 | 2022-09-28 | Idaho | 16 | 495601 | 5174 |
52084 | 52084 | 2022-09-28 | West Virginia | 54 | 599770 | 7406 |
52071 | 52071 | 2022-09-28 | Oregon | 41 | 894776 | 8561 |
52064 | 52064 | 2022-09-28 | New Mexico | 35 | 618126 | 8565 |
52049 | 52049 | 2022-09-28 | Kansas | 20 | 878982 | 9555 |
52048 | 52048 | 2022-09-28 | Iowa | 19 | 855931 | 10077 |
52038 | 52038 | 2022-09-28 | Connecticut | 9 | 895390 | 11365 |
52061 | 52061 | 2022-09-28 | Nevada | 32 | 847175 | 11501 |
52035 | 52035 | 2022-09-28 | Arkansas | 5 | 950940 | 12131 |
52057 | 52057 | 2022-09-28 | Mississippi | 28 | 927465 | 12912 |
52037 | 52037 | 2022-09-28 | Colorado | 8 | 1659878 | 13499 |
52056 | 52056 | 2022-09-28 | Minnesota | 27 | 1658677 | 13613 |
52083 | 52083 | 2022-09-28 | Washington | 53 | 1813685 | 14344 |
52070 | 52070 | 2022-09-28 | Oklahoma | 40 | 1196540 | 14786 |
52085 | 52085 | 2022-09-28 | Wisconsin | 55 | 1864417 | 15256 |
52053 | 52053 | 2022-09-28 | Maryland | 24 | 1248592 | 15386 |
52050 | 52050 | 2022-09-28 | Kentucky | 21 | 1592745 | 16969 |
52051 | 52051 | 2022-09-28 | Louisiana | 22 | 1454450 | 18046 |
52075 | 52075 | 2022-09-28 | South Carolina | 45 | 1708074 | 18365 |
52031 | 52031 | 2022-09-28 | Alabama | 1 | 1521363 | 20419 |
52058 | 52058 | 2022-09-28 | Missouri | 29 | 1663876 | 21624 |
52054 | 52054 | 2022-09-28 | Massachusetts | 25 | 2040602 | 21646 |
52082 | 52082 | 2022-09-28 | Virginia | 51 | 2086021 | 21831 |
52047 | 52047 | 2022-09-28 | Indiana | 18 | 1921993 | 24708 |
52066 | 52066 | 2022-09-28 | North Carolina | 37 | 3198866 | 26535 |
52077 | 52077 | 2022-09-28 | Tennessee | 47 | 2278412 | 27486 |
52034 | 52034 | 2022-09-28 | Arizona | 4 | 2271560 | 31370 |
52063 | 52063 | 2022-09-28 | New Jersey | 34 | 2735732 | 34733 |
52055 | 52055 | 2022-09-28 | Michigan | 26 | 2836167 | 38624 |
52042 | 52042 | 2022-09-28 | Georgia | 13 | 2821158 | 38717 |
52046 | 52046 | 2022-09-28 | Illinois | 17 | 3764949 | 39666 |
52069 | 52069 | 2022-09-28 | Ohio | 39 | 3131645 | 39767 |
52072 | 52072 | 2022-09-28 | Pennsylvania | 42 | 3254503 | 47213 |
52065 | 52065 | 2022-09-28 | New York | 36 | 6097881 | 71008 |
52041 | 52041 | 2022-09-28 | Florida | 12 | 7116097 | 81308 |
52078 | 52078 | 2022-09-28 | Texas | 48 | 7876064 | 90967 |
52036 | 52036 | 2022-09-28 | California | 6 | 11236331 | 95864 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );