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-20 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 |
---|---|---|---|---|---|---|
19485 | 19485 | 2021-02-20 | Alabama | 1 | 485986 | 9590 |
19486 | 19486 | 2021-02-20 | Alaska | 2 | 56979 | 278 |
19487 | 19487 | 2021-02-20 | Arizona | 4 | 807163 | 15480 |
19488 | 19488 | 2021-02-20 | Arkansas | 5 | 315230 | 5348 |
19489 | 19489 | 2021-02-20 | California | 6 | 3527411 | 49111 |
19490 | 19490 | 2021-02-20 | Colorado | 8 | 422240 | 5984 |
19491 | 19491 | 2021-02-20 | Connecticut | 9 | 273101 | 7523 |
19492 | 19492 | 2021-02-20 | Delaware | 10 | 84531 | 1366 |
19493 | 19493 | 2021-02-20 | District of Columbia | 11 | 39553 | 994 |
19494 | 19494 | 2021-02-20 | Florida | 12 | 1863699 | 29812 |
19495 | 19495 | 2021-02-20 | Georgia | 13 | 958998 | 16233 |
19496 | 19496 | 2021-02-20 | Guam | 66 | 8685 | 131 |
19497 | 19497 | 2021-02-20 | Hawaii | 15 | 27011 | 427 |
19498 | 19498 | 2021-02-20 | Idaho | 16 | 169229 | 1829 |
19499 | 19499 | 2021-02-20 | Illinois | 17 | 1175781 | 22426 |
19500 | 19500 | 2021-02-20 | Indiana | 18 | 657848 | 12336 |
19501 | 19501 | 2021-02-20 | Iowa | 19 | 332225 | 5336 |
19502 | 19502 | 2021-02-20 | Kansas | 20 | 294010 | 4614 |
19503 | 19503 | 2021-02-20 | Kentucky | 21 | 400011 | 4585 |
19504 | 19504 | 2021-02-20 | Louisiana | 22 | 422287 | 9440 |
19505 | 19505 | 2021-02-20 | Maine | 23 | 43367 | 658 |
19506 | 19506 | 2021-02-20 | Maryland | 24 | 375919 | 7697 |
19507 | 19507 | 2021-02-20 | Massachusetts | 25 | 567764 | 15779 |
19508 | 19508 | 2021-02-20 | Michigan | 26 | 635359 | 16332 |
19509 | 19509 | 2021-02-20 | Minnesota | 27 | 478225 | 6491 |
19510 | 19510 | 2021-02-20 | Mississippi | 28 | 290242 | 6553 |
19511 | 19511 | 2021-02-20 | Missouri | 29 | 519922 | 8151 |
19512 | 19512 | 2021-02-20 | Montana | 30 | 98681 | 1342 |
19513 | 19513 | 2021-02-20 | Nebraska | 31 | 199162 | 2169 |
19514 | 19514 | 2021-02-20 | Nevada | 32 | 290742 | 4870 |
19515 | 19515 | 2021-02-20 | New Hampshire | 33 | 73161 | 1153 |
19516 | 19516 | 2021-02-20 | New Jersey | 34 | 764374 | 22834 |
19517 | 19517 | 2021-02-20 | New Mexico | 35 | 182475 | 3612 |
19518 | 19518 | 2021-02-20 | New York | 36 | 1585692 | 46233 |
19519 | 19519 | 2021-02-20 | North Carolina | 37 | 841315 | 10930 |
19520 | 19520 | 2021-02-20 | North Dakota | 38 | 99258 | 1467 |
19521 | 19521 | 2021-02-20 | Northern Mariana Islands | 69 | 135 | 2 |
19522 | 19522 | 2021-02-20 | Ohio | 39 | 952306 | 16749 |
19523 | 19523 | 2021-02-20 | Oklahoma | 40 | 418318 | 4155 |
19524 | 19524 | 2021-02-20 | Oregon | 41 | 152711 | 2159 |
19525 | 19525 | 2021-02-20 | Pennsylvania | 42 | 916378 | 23615 |
19526 | 19526 | 2021-02-20 | Puerto Rico | 72 | 132450 | 1957 |
19527 | 19527 | 2021-02-20 | Rhode Island | 44 | 123145 | 2376 |
19528 | 19528 | 2021-02-20 | South Carolina | 45 | 501277 | 8256 |
19529 | 19529 | 2021-02-20 | South Dakota | 46 | 111165 | 1859 |
19530 | 19530 | 2021-02-20 | Tennessee | 47 | 750628 | 11022 |
19531 | 19531 | 2021-02-20 | Texas | 48 | 2590989 | 42202 |
19532 | 19532 | 2021-02-20 | Utah | 49 | 366091 | 1842 |
19533 | 19533 | 2021-02-20 | Vermont | 50 | 14359 | 196 |
19534 | 19534 | 2021-02-20 | Virgin Islands | 78 | 2575 | 25 |
19535 | 19535 | 2021-02-20 | Virginia | 51 | 561812 | 7197 |
19536 | 19536 | 2021-02-20 | Washington | 53 | 336819 | 4886 |
19537 | 19537 | 2021-02-20 | West Virginia | 54 | 129364 | 2254 |
19538 | 19538 | 2021-02-20 | Wisconsin | 55 | 611789 | 6875 |
19539 | 19539 | 2021-02-20 | Wyoming | 56 | 53683 | 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 );