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-03-05 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 55
- 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
- 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 |
---|---|---|---|---|---|---|
20200 | 20200 | 2021-03-05 | Alabama | 1 | 498887 | 10122 |
20201 | 20201 | 2021-03-05 | Alaska | 2 | 58870 | 292 |
20202 | 20202 | 2021-03-05 | Arizona | 4 | 823384 | 16272 |
20203 | 20203 | 2021-03-05 | Arkansas | 5 | 324326 | 5283 |
20204 | 20204 | 2021-03-05 | California | 6 | 3592812 | 53838 |
20205 | 20205 | 2021-03-05 | Colorado | 8 | 436848 | 6075 |
20206 | 20206 | 2021-03-05 | Connecticut | 9 | 285330 | 7704 |
20207 | 20207 | 2021-03-05 | Delaware | 10 | 87874 | 1453 |
20208 | 20208 | 2021-03-05 | District of Columbia | 11 | 41122 | 1027 |
20209 | 20209 | 2021-03-05 | Florida | 12 | 1936199 | 31521 |
20210 | 20210 | 2021-03-05 | Georgia | 13 | 994416 | 17260 |
20211 | 20211 | 2021-03-05 | Guam | 66 | 8716 | 132 |
20212 | 20212 | 2021-03-05 | Hawaii | 15 | 27693 | 440 |
20213 | 20213 | 2021-03-05 | Idaho | 16 | 172929 | 1880 |
20214 | 20214 | 2021-03-05 | Illinois | 17 | 1198242 | 22946 |
20215 | 20215 | 2021-03-05 | Indiana | 18 | 668520 | 12697 |
20216 | 20216 | 2021-03-05 | Iowa | 19 | 339121 | 5549 |
20217 | 20217 | 2021-03-05 | Kansas | 20 | 298897 | 4812 |
20218 | 20218 | 2021-03-05 | Kentucky | 21 | 412863 | 4912 |
20219 | 20219 | 2021-03-05 | Louisiana | 22 | 433045 | 9716 |
20220 | 20220 | 2021-03-05 | Maine | 23 | 45452 | 704 |
20221 | 20221 | 2021-03-05 | Maryland | 24 | 385860 | 7930 |
20222 | 20222 | 2021-03-05 | Massachusetts | 25 | 588209 | 16322 |
20223 | 20223 | 2021-03-05 | Michigan | 26 | 653447 | 16591 |
20224 | 20224 | 2021-03-05 | Minnesota | 27 | 488238 | 6602 |
20225 | 20225 | 2021-03-05 | Mississippi | 28 | 296745 | 6783 |
20226 | 20226 | 2021-03-05 | Missouri | 29 | 527396 | 8599 |
20227 | 20227 | 2021-03-05 | Montana | 30 | 100798 | 1381 |
20228 | 20228 | 2021-03-05 | Nebraska | 31 | 202871 | 2222 |
20229 | 20229 | 2021-03-05 | Nevada | 32 | 295558 | 5024 |
20230 | 20230 | 2021-03-05 | New Hampshire | 33 | 76422 | 1178 |
20231 | 20231 | 2021-03-05 | New Jersey | 34 | 806367 | 23521 |
20232 | 20232 | 2021-03-05 | New Mexico | 35 | 186460 | 3789 |
20233 | 20233 | 2021-03-05 | New York | 36 | 1679124 | 47672 |
20234 | 20234 | 2021-03-05 | North Carolina | 37 | 871407 | 11475 |
20235 | 20235 | 2021-03-05 | North Dakota | 38 | 100308 | 1478 |
20236 | 20236 | 2021-03-05 | Northern Mariana Islands | 69 | 144 | 2 |
20237 | 20237 | 2021-03-05 | Ohio | 39 | 976230 | 17502 |
20238 | 20238 | 2021-03-05 | Oklahoma | 40 | 427558 | 4534 |
20239 | 20239 | 2021-03-05 | Oregon | 41 | 156985 | 2301 |
20240 | 20240 | 2021-03-05 | Pennsylvania | 42 | 949223 | 24311 |
20241 | 20241 | 2021-03-05 | Puerto Rico | 72 | 134681 | 2056 |
20242 | 20242 | 2021-03-05 | Rhode Island | 44 | 128121 | 2541 |
20243 | 20243 | 2021-03-05 | South Carolina | 45 | 523258 | 8699 |
20244 | 20244 | 2021-03-05 | South Dakota | 46 | 113229 | 1896 |
20245 | 20245 | 2021-03-05 | Tennessee | 47 | 767073 | 11439 |
20246 | 20246 | 2021-03-05 | Texas | 48 | 2686191 | 45195 |
20247 | 20247 | 2021-03-05 | Utah | 49 | 373924 | 1970 |
20248 | 20248 | 2021-03-05 | Vermont | 50 | 15819 | 207 |
20249 | 20249 | 2021-03-05 | Virgin Islands | 78 | 2714 | 25 |
20250 | 20250 | 2021-03-05 | Virginia | 51 | 583060 | 9428 |
20251 | 20251 | 2021-03-05 | Washington | 53 | 346733 | 5104 |
20252 | 20252 | 2021-03-05 | West Virginia | 54 | 132964 | 2318 |
20253 | 20253 | 2021-03-05 | Wisconsin | 55 | 620663 | 7099 |
20254 | 20254 | 2021-03-05 | Wyoming | 56 | 54764 | 682 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );