ny_times_us_states

⚠️ 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

12,719 rows sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

Link rowid date ▲ state fips cases deaths
12665 12665 2020-10-19 Alabama 1 173485 2789
12666 12666 2020-10-19 Alaska 2 12138 63
12667 12667 2020-10-19 Arizona 4 231933 5830
12668 12668 2020-10-19 Arkansas 5 99597 1714
12669 12669 2020-10-19 California 6 882665 16987
12670 12670 2020-10-19 Colorado 8 86727 2207
12671 12671 2020-10-19 Connecticut 9 64021 4554
12672 12672 2020-10-19 Delaware 10 23196 666
12673 12673 2020-10-19 District of Columbia 11 16395 641
12674 12674 2020-10-19 Florida 12 756719 16020
12675 12675 2020-10-19 Georgia 13 326814 7479
12676 12676 2020-10-19 Guam 66 4725 67
12677 12677 2020-10-19 Hawaii 15 14218 186
12678 12678 2020-10-19 Idaho 16 54123 535
12679 12679 2020-10-19 Illinois 17 352449 9520
12680 12680 2020-10-19 Indiana 18 151588 3960
12681 12681 2020-10-19 Iowa 19 108114 1548
12682 12682 2020-10-19 Kansas 20 74616 872
12683 12683 2020-10-19 Kentucky 21 90443 1381
12684 12684 2020-10-19 Louisiana 22 179070 5766
12685 12685 2020-10-19 Maine 23 5962 146
12686 12686 2020-10-19 Maryland 24 136643 4041
12687 12687 2020-10-19 Massachusetts 25 144488 9753
12688 12688 2020-10-19 Michigan 26 164055 7364
12689 12689 2020-10-19 Minnesota 27 124492 2292
12690 12690 2020-10-19 Mississippi 28 110592 3171
12691 12691 2020-10-19 Missouri 29 164249 2660
12692 12692 2020-10-19 Montana 30 23503 242
12693 12693 2020-10-19 Nebraska 31 58817 568
12694 12694 2020-10-19 Nevada 32 90978 1714
12695 12695 2020-10-19 New Hampshire 33 9746 468
12696 12696 2020-10-19 New Jersey 34 222994 16214
12697 12697 2020-10-19 New Mexico 35 37302 935
12698 12698 2020-10-19 New York 36 490015 32990
12699 12699 2020-10-19 North Carolina 37 247551 3969
12700 12700 2020-10-19 North Dakota 38 32642 413
12701 12701 2020-10-19 Northern Mariana Islands 69 86 2
12702 12702 2020-10-19 Ohio 39 183624 5075
12703 12703 2020-10-19 Oklahoma 40 108073 1173
12704 12704 2020-10-19 Oregon 41 39799 630
12705 12705 2020-10-19 Pennsylvania 42 188442 8562
12706 12706 2020-10-19 Puerto Rico 72 57950 768
12707 12707 2020-10-19 Rhode Island 44 28347 1159
12708 12708 2020-10-19 South Carolina 45 164609 3661
12709 12709 2020-10-19 South Dakota 46 33836 323
12710 12710 2020-10-19 Tennessee 47 228267 2896
12711 12711 2020-10-19 Texas 48 873556 17564
12712 12712 2020-10-19 Utah 49 95562 547
12713 12713 2020-10-19 Vermont 50 1946 58
12714 12714 2020-10-19 Virgin Islands 78 1335 21
12715 12715 2020-10-19 Virginia 51 166828 3457
12716 12716 2020-10-19 Washington 53 103323 2357
12717 12717 2020-10-19 West Virginia 54 20293 399
12718 12718 2020-10-19 Wisconsin 55 183177 1624
12719 12719 2020-10-19 Wyoming 56 9311 57
12610 12610 2020-10-18 Alabama 1 172626 2788
12611 12611 2020-10-18 Alaska 2 11934 63
12612 12612 2020-10-18 Arizona 4 231149 5827
12613 12613 2020-10-18 Arkansas 5 99066 1704
12614 12614 2020-10-18 California 6 878394 16979
12615 12615 2020-10-18 Colorado 8 85803 2199
12616 12616 2020-10-18 Connecticut 9 62830 4542
12617 12617 2020-10-18 Delaware 10 23093 665
12618 12618 2020-10-18 District of Columbia 11 16370 641
12619 12619 2020-10-18 Florida 12 755012 15966
12620 12620 2020-10-18 Georgia 13 326080 7460
12621 12621 2020-10-18 Guam 66 4507 64
12622 12622 2020-10-18 Hawaii 15 14183 186
12623 12623 2020-10-18 Idaho 16 53092 532
12624 12624 2020-10-18 Illinois 17 348870 9491
12625 12625 2020-10-18 Indiana 18 150005 3937
12626 12626 2020-10-18 Iowa 19 107334 1532
12627 12627 2020-10-18 Kansas 20 72722 859
12628 12628 2020-10-18 Kentucky 21 89538 1372
12629 12629 2020-10-18 Louisiana 22 178869 5750
12630 12630 2020-10-18 Maine 23 5939 146
12631 12631 2020-10-18 Maryland 24 136149 4037
12632 12632 2020-10-18 Massachusetts 25 143660 9737
12633 12633 2020-10-18 Michigan 26 159337 7323
12634 12634 2020-10-18 Minnesota 27 122865 2287
12635 12635 2020-10-18 Mississippi 28 110239 3171
12636 12636 2020-10-18 Missouri 29 162156 2648
12637 12637 2020-10-18 Montana 30 22821 241
12638 12638 2020-10-18 Nebraska 31 58068 557
12639 12639 2020-10-18 Nevada 32 90374 1711
12640 12640 2020-10-18 New Hampshire 33 9694 467
12641 12641 2020-10-18 New Jersey 34 221802 16211
12642 12642 2020-10-18 New Mexico 35 36788 934
12643 12643 2020-10-18 New York 36 489016 32972
12644 12644 2020-10-18 North Carolina 37 246116 3961
12645 12645 2020-10-18 North Dakota 38 31983 409
12646 12646 2020-10-18 Northern Mariana Islands 69 86 2
12647 12647 2020-10-18 Ohio 39 181787 5067
12648 12648 2020-10-18 Oklahoma 40 107299 1171
12649 12649 2020-10-18 Oregon 41 39532 622
12650 12650 2020-10-18 Pennsylvania 42 186772 8555
12651 12651 2020-10-18 Puerto Rico 72 57293 766
12652 12652 2020-10-18 Rhode Island 44 27691 1152
12653 12653 2020-10-18 South Carolina 45 163990 3650
12654 12654 2020-10-18 South Dakota 46 33269 323

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
);
Powered by Datasette · Query took 197.725ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette