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

5,129 rows sorted by date descending

View and edit SQL

Suggested facets: date (date)

Link rowid date ▲ state fips cases deaths
5075 2020-06-03 Alabama 1 18851 653
5076 2020-06-03 Alaska 2 516 8
5077 2020-06-03 Arizona 4 22245 983
5078 2020-06-03 Arkansas 5 8067 142
5079 2020-06-03 California 6 120407 4422
5080 2020-06-03 Colorado 8 27046 1494
5081 2020-06-03 Connecticut 9 43091 3989
5082 2020-06-03 Delaware 10 9712 375
5083 2020-06-03 District of Columbia 11 9016 473
5084 2020-06-03 Florida 12 58756 2565
5085 2020-06-03 Georgia 13 46711 2092
5086 2020-06-03 Guam 66 1146 6
5087 2020-06-03 Hawaii 15 643 17
5088 2020-06-03 Idaho 16 2990 83
5089 2020-06-03 Illinois 17 124279 5665
5090 2020-06-03 Indiana 18 36609 2207
5091 2020-06-03 Iowa 19 20376 574
5092 2020-06-03 Kansas 20 10281 227
5093 2020-06-03 Kentucky 21 10485 458
5094 2020-06-03 Louisiana 22 41244 2870
5095 2020-06-03 Maine 23 2418 95
5096 2020-06-03 Maryland 24 55617 2641
5097 2020-06-03 Massachusetts 25 101592 7152
5098 2020-06-03 Michigan 26 58990 5579
5099 2020-06-03 Minnesota 27 25881 1097
5100 2020-06-03 Mississippi 28 16322 782
5101 2020-06-03 Missouri 29 14020 801
5102 2020-06-03 Montana 30 525 17
5103 2020-06-03 Nebraska 31 14866 189
5104 2020-06-03 Nevada 32 8950 429
5105 2020-06-03 New Hampshire 33 4795 265
5106 2020-06-03 New Jersey 34 162068 11880
5107 2020-06-03 New Mexico 35 8140 375
5108 2020-06-03 New York 36 378924 29918
5109 2020-06-03 North Carolina 37 31013 971
5110 2020-06-03 North Dakota 38 2682 69
5111 2020-06-03 Northern Mariana Islands 69 24 2
5112 2020-06-03 Ohio 39 36792 2299
5113 2020-06-03 Oklahoma 40 6805 341
5114 2020-06-03 Oregon 41 4399 159
5115 2020-06-03 Pennsylvania 42 77871 5742
5116 2020-06-03 Puerto Rico 72 4023 140
5117 2020-06-03 Rhode Island 44 15219 742
5118 2020-06-03 South Carolina 45 12651 518
5119 2020-06-03 South Dakota 46 5162 62
5120 2020-06-03 Tennessee 47 25024 386
5121 2020-06-03 Texas 48 69546 1766
5122 2020-06-03 Utah 49 10558 117
5123 2020-06-03 Vermont 50 990 55
5124 2020-06-03 Virgin Islands 78 70 6
5125 2020-06-03 Virginia 51 46905 1428
5126 2020-06-03 Washington 53 23500 1145
5127 2020-06-03 West Virginia 54 2077 78
5128 2020-06-03 Wisconsin 55 19614 618
5129 2020-06-03 Wyoming 56 915 17
5020 2020-06-02 Alabama 1 18771 653
5021 2020-06-02 Alaska 2 497 8
5022 2020-06-02 Arizona 4 21250 943
5023 2020-06-02 Arkansas 5 7818 136
5024 2020-06-02 California 6 118081 4360
5025 2020-06-02 Colorado 8 26774 1474
5026 2020-06-02 Connecticut 9 42979 3972
5027 2020-06-02 Delaware 10 9685 373
5028 2020-06-02 District of Columbia 11 8886 470
5029 2020-06-02 Florida 12 57439 2529
5030 2020-06-02 Georgia 13 46063 2070
5031 2020-06-02 Guam 66 1146 6
5032 2020-06-02 Hawaii 15 643 17
5033 2020-06-02 Idaho 16 2935 83
5034 2020-06-02 Illinois 17 123244 5567
5035 2020-06-02 Indiana 18 36129 2197
5036 2020-06-02 Iowa 19 20017 564
5037 2020-06-02 Kansas 20 10143 227
5038 2020-06-02 Kentucky 21 10287 451
5039 2020-06-02 Louisiana 22 40857 2835
5040 2020-06-02 Maine 23 2377 94
5041 2020-06-02 Maryland 24 54831 2597
5042 2020-06-02 Massachusetts 25 101163 7085
5043 2020-06-02 Michigan 26 58680 5562
5044 2020-06-02 Minnesota 27 25518 1082
5045 2020-06-02 Mississippi 28 16020 767
5046 2020-06-02 Missouri 29 13822 797
5047 2020-06-02 Montana 30 523 17
5048 2020-06-02 Nebraska 31 14611 187
5049 2020-06-02 Nevada 32 8858 420
5050 2020-06-02 New Hampshire 33 4749 256
5051 2020-06-02 New Jersey 34 161545 11770
5052 2020-06-02 New Mexico 35 8024 367
5053 2020-06-02 New York 36 377881 29847
5054 2020-06-02 North Carolina 37 30052 950
5055 2020-06-02 North Dakota 38 2649 68
5056 2020-06-02 Northern Mariana Islands 69 23 2
5057 2020-06-02 Ohio 39 36350 2258
5058 2020-06-02 Oklahoma 40 6692 339
5059 2020-06-02 Oregon 41 4335 157
5060 2020-06-02 Pennsylvania 42 77315 5670
5061 2020-06-02 Puerto Rico 72 3935 138
5062 2020-06-02 Rhode Island 44 15112 732
5063 2020-06-02 South Carolina 45 12415 501
5064 2020-06-02 South Dakota 46 5067 62

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 85.093ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette