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-02-17 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 |
---|---|---|---|---|---|---|
19320 | 19320 | 2021-02-17 | Alabama | 1 | 483167 | 9346 |
19321 | 19321 | 2021-02-17 | Alaska | 2 | 56559 | 277 |
19322 | 19322 | 2021-02-17 | Arizona | 4 | 801741 | 15084 |
19323 | 19323 | 2021-02-17 | Arkansas | 5 | 314192 | 5313 |
19324 | 19324 | 2021-02-17 | California | 6 | 3505610 | 47902 |
19325 | 19325 | 2021-02-17 | Colorado | 8 | 418822 | 5945 |
19326 | 19326 | 2021-02-17 | Connecticut | 9 | 271356 | 7476 |
19327 | 19327 | 2021-02-17 | Delaware | 10 | 83581 | 1316 |
19328 | 19328 | 2021-02-17 | District of Columbia | 11 | 39180 | 985 |
19329 | 19329 | 2021-02-17 | Florida | 12 | 1844619 | 29310 |
19330 | 19330 | 2021-02-17 | Georgia | 13 | 948719 | 15779 |
19331 | 19331 | 2021-02-17 | Guam | 66 | 8672 | 131 |
19332 | 19332 | 2021-02-17 | Hawaii | 15 | 26846 | 424 |
19333 | 19333 | 2021-02-17 | Idaho | 16 | 168503 | 1819 |
19334 | 19334 | 2021-02-17 | Illinois | 17 | 1169747 | 22224 |
19335 | 19335 | 2021-02-17 | Indiana | 18 | 654636 | 12250 |
19336 | 19336 | 2021-02-17 | Iowa | 19 | 330906 | 5306 |
19337 | 19337 | 2021-02-17 | Kansas | 20 | 291868 | 4521 |
19338 | 19338 | 2021-02-17 | Kentucky | 21 | 395766 | 4511 |
19339 | 19339 | 2021-02-17 | Louisiana | 22 | 421018 | 9391 |
19340 | 19340 | 2021-02-17 | Maine | 23 | 42872 | 654 |
19341 | 19341 | 2021-02-17 | Maryland | 24 | 373161 | 7630 |
19342 | 19342 | 2021-02-17 | Massachusetts | 25 | 561936 | 15623 |
19343 | 19343 | 2021-02-17 | Michigan | 26 | 631932 | 16151 |
19344 | 19344 | 2021-02-17 | Minnesota | 27 | 475447 | 6458 |
19345 | 19345 | 2021-02-17 | Mississippi | 28 | 289398 | 6524 |
19346 | 19346 | 2021-02-17 | Missouri | 29 | 517798 | 7929 |
19347 | 19347 | 2021-02-17 | Montana | 30 | 97995 | 1335 |
19348 | 19348 | 2021-02-17 | Nebraska | 31 | 198215 | 2146 |
19349 | 19349 | 2021-02-17 | Nevada | 32 | 289465 | 4776 |
19350 | 19350 | 2021-02-17 | New Hampshire | 33 | 71965 | 1148 |
19351 | 19351 | 2021-02-17 | New Jersey | 34 | 755174 | 22589 |
19352 | 19352 | 2021-02-17 | New Mexico | 35 | 181332 | 3564 |
19353 | 19353 | 2021-02-17 | New York | 36 | 1559299 | 45807 |
19354 | 19354 | 2021-02-17 | North Carolina | 37 | 830932 | 10712 |
19355 | 19355 | 2021-02-17 | North Dakota | 38 | 98931 | 1461 |
19356 | 19356 | 2021-02-17 | Northern Mariana Islands | 69 | 135 | 2 |
19357 | 19357 | 2021-02-17 | Ohio | 39 | 945107 | 16513 |
19358 | 19358 | 2021-02-17 | Oklahoma | 40 | 415858 | 4089 |
19359 | 19359 | 2021-02-17 | Oregon | 41 | 151257 | 2149 |
19360 | 19360 | 2021-02-17 | Pennsylvania | 42 | 907736 | 23360 |
19361 | 19361 | 2021-02-17 | Puerto Rico | 72 | 132043 | 1930 |
19362 | 19362 | 2021-02-17 | Rhode Island | 44 | 122440 | 2352 |
19363 | 19363 | 2021-02-17 | South Carolina | 45 | 492369 | 8117 |
19364 | 19364 | 2021-02-17 | South Dakota | 46 | 110685 | 1844 |
19365 | 19365 | 2021-02-17 | Tennessee | 47 | 747117 | 10892 |
19366 | 19366 | 2021-02-17 | Texas | 48 | 2577230 | 41650 |
19367 | 19367 | 2021-02-17 | Utah | 49 | 363306 | 1806 |
19368 | 19368 | 2021-02-17 | Vermont | 50 | 13996 | 191 |
19369 | 19369 | 2021-02-17 | Virgin Islands | 78 | 2545 | 25 |
19370 | 19370 | 2021-02-17 | Virginia | 51 | 555592 | 7075 |
19371 | 19371 | 2021-02-17 | Washington | 53 | 334284 | 4824 |
19372 | 19372 | 2021-02-17 | West Virginia | 54 | 128405 | 2225 |
19373 | 19373 | 2021-02-17 | Wisconsin | 55 | 609192 | 6803 |
19374 | 19374 | 2021-02-17 | Wyoming | 56 | 53450 | 662 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );