ny_times_us_states

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

22,564 rows sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

Link rowid date ▲ state fips cases deaths
22510 22510 2021-04-16 Alabama 1 521623 10739
22511 22511 2021-04-16 Alaska 2 65390 318
22512 22512 2021-04-16 Arizona 4 852584 17153
22513 22513 2021-04-16 Arkansas 5 333186 5692
22514 22514 2021-04-16 California 6 3714406 60883
22515 22515 2021-04-16 Colorado 8 490164 6326
22516 22516 2021-04-16 Connecticut 9 329062 7995
22517 22517 2021-04-16 Delaware 10 100322 1596
22518 22518 2021-04-16 District of Columbia 11 46449 1093
22519 22519 2021-04-16 Florida 12 2155736 34329
22520 22520 2021-04-16 Georgia 13 1057619 19107
22521 22521 2021-04-16 Guam 66 8828 137
22522 22522 2021-04-16 Hawaii 15 31510 471
22523 22523 2021-04-16 Idaho 16 184886 2018
22524 22524 2021-04-16 Illinois 17 1300047 23920
22525 22525 2021-04-16 Indiana 18 707932 13211
22526 22526 2021-04-16 Iowa 19 359260 5878
22527 22527 2021-04-16 Kansas 20 308124 4953
22528 22528 2021-04-16 Kentucky 21 439898 6415
22529 22529 2021-04-16 Louisiana 22 451955 10282
22530 22530 2021-04-16 Maine 23 56525 763
22531 22531 2021-04-16 Maryland 24 433545 8528
22532 22532 2021-04-16 Massachusetts 25 669282 17445
22533 22533 2021-04-16 Michigan 26 867166 17848
22534 22534 2021-04-16 Minnesota 27 552195 7073
22535 22535 2021-04-16 Mississippi 28 308737 7139
22536 22536 2021-04-16 Missouri 29 595499 9111
22537 22537 2021-04-16 Montana 30 107057 1538
22538 22538 2021-04-16 Nebraska 31 215986 2332
22539 22539 2021-04-16 Nevada 32 310239 5365
22540 22540 2021-04-16 New Hampshire 33 90910 1266
22541 22541 2021-04-16 New Jersey 34 971782 25094
22542 22542 2021-04-16 New Mexico 35 194868 4003
22543 22543 2021-04-16 New York 36 1984884 50965
22544 22544 2021-04-16 North Carolina 37 950078 12414
22545 22545 2021-04-16 North Dakota 38 105588 1509
22546 22546 2021-04-16 Northern Mariana Islands 69 162 2
22547 22547 2021-04-16 Ohio 39 1050112 18991
22548 22548 2021-04-16 Oklahoma 40 444863 6697
22549 22549 2021-04-16 Oregon 41 173707 2471
22550 22550 2021-04-16 Pennsylvania 42 1104166 25681
22551 22551 2021-04-16 Puerto Rico 72 154186 2194
22552 22552 2021-04-16 Rhode Island 44 144149 2647
22553 22553 2021-04-16 South Carolina 45 567277 9309
22554 22554 2021-04-16 South Dakota 46 120856 1952
22555 22555 2021-04-16 Tennessee 47 816148 11951
22556 22556 2021-04-16 Texas 48 2847550 49674
22557 22557 2021-04-16 Utah 49 392157 2164
22558 22558 2021-04-16 Vermont 50 21803 242
22559 22559 2021-04-16 Virgin Islands 78 3028 26
22560 22560 2021-04-16 Virginia 51 643220 10549
22561 22561 2021-04-16 Washington 53 385695 5427
22562 22562 2021-04-16 West Virginia 54 148071 2777
22563 22563 2021-04-16 Wisconsin 55 650291 7412
22564 22564 2021-04-16 Wyoming 56 57267 703
22455 22455 2021-04-15 Alabama 1 521201 10736
22456 22456 2021-04-15 Alaska 2 65201 318
22457 22457 2021-04-15 Arizona 4 851737 17123
22458 22458 2021-04-15 Arkansas 5 332949 5686
22459 22459 2021-04-15 California 6 3711581 60770
22460 22460 2021-04-15 Colorado 8 488151 6315
22461 22461 2021-04-15 Connecticut 9 328000 7990
22462 22462 2021-04-15 Delaware 10 99915 1595
22463 22463 2021-04-15 District of Columbia 11 46315 1090
22464 22464 2021-04-15 Florida 12 2148440 34237
22465 22465 2021-04-15 Georgia 13 1055997 19057
22466 22466 2021-04-15 Guam 66 8825 137
22467 22467 2021-04-15 Hawaii 15 31337 470
22468 22468 2021-04-15 Idaho 16 184661 2017
22469 22469 2021-04-15 Illinois 17 1296240 23896
22470 22470 2021-04-15 Indiana 18 706642 13194
22471 22471 2021-04-15 Iowa 19 358873 5871
22472 22472 2021-04-15 Kansas 20 307634 4944
22473 22473 2021-04-15 Kentucky 21 439200 6405
22474 22474 2021-04-15 Louisiana 22 451476 10273
22475 22475 2021-04-15 Maine 23 55953 758
22476 22476 2021-04-15 Maryland 24 431981 8512
22477 22477 2021-04-15 Massachusetts 25 667066 17432
22478 22478 2021-04-15 Michigan 26 857360 17806
22479 22479 2021-04-15 Minnesota 27 549908 7067
22480 22480 2021-04-15 Mississippi 28 308521 7127
22481 22481 2021-04-15 Missouri 29 594622 9106
22482 22482 2021-04-15 Montana 30 106936 1528
22483 22483 2021-04-15 Nebraska 31 215601 2329
22484 22484 2021-04-15 Nevada 32 309705 5359
22485 22485 2021-04-15 New Hampshire 33 90525 1264
22486 22486 2021-04-15 New Jersey 34 967401 25034
22487 22487 2021-04-15 New Mexico 35 194605 3999
22488 22488 2021-04-15 New York 36 1978594 50912
22489 22489 2021-04-15 North Carolina 37 947694 12385
22490 22490 2021-04-15 North Dakota 38 105411 1506
22491 22491 2021-04-15 Northern Mariana Islands 69 161 2
22492 22492 2021-04-15 Ohio 39 1048109 18917
22493 22493 2021-04-15 Oklahoma 40 444590 6697
22494 22494 2021-04-15 Oregon 41 172932 2467
22495 22495 2021-04-15 Pennsylvania 42 1098619 25623
22496 22496 2021-04-15 Puerto Rico 72 152551 2185
22497 22497 2021-04-15 Rhode Island 44 143740 2646
22498 22498 2021-04-15 South Carolina 45 566018 9307
22499 22499 2021-04-15 South Dakota 46 120613 1949

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_states] (
   [date] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);