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

Suggested facets: date (date)

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