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

33,214 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
33159 33159 2021-10-26 Alabama 1 821255 15424
33160 33160 2021-10-26 Alaska 2 134802 696
33161 33161 2021-10-26 American Samoa 60 1 0
33162 33162 2021-10-26 Arizona 4 1150432 20967
33163 33163 2021-10-26 Arkansas 5 510908 8306
33164 33164 2021-10-26 California 6 4890036 71800
33165 33165 2021-10-26 Colorado 8 734192 8293
33166 33166 2021-10-26 Connecticut 9 401379 8752
33167 33167 2021-10-26 Delaware 10 142707 2068
33168 33168 2021-10-26 District of Columbia 11 63919 1187
33169 33169 2021-10-26 Florida 12 3641304 58933
33170 33170 2021-10-26 Georgia 13 1593323 27725
33171 33171 2021-10-26 Guam 66 18792 231
33172 33172 2021-10-26 Hawaii 15 80876 885
33173 33173 2021-10-26 Idaho 16 287743 3474
33174 33174 2021-10-26 Illinois 17 1693530 28517
33175 33175 2021-10-26 Indiana 18 1016155 16567
33176 33176 2021-10-26 Iowa 19 481207 6848
33177 33177 2021-10-26 Kansas 20 431264 6268
33178 33178 2021-10-26 Kentucky 21 744278 9767
33179 33179 2021-10-26 Louisiana 22 756969 14496
33180 33180 2021-10-26 Maine 23 101849 1147
33181 33181 2021-10-26 Maryland 24 557423 10827
33182 33182 2021-10-26 Massachusetts 25 847512 18956
33183 33183 2021-10-26 Michigan 26 1253227 23342
33184 33184 2021-10-26 Minnesota 27 779873 8705
33185 33185 2021-10-26 Mississippi 28 503322 10057
33186 33186 2021-10-26 Missouri 29 866899 12725
33187 33187 2021-10-26 Montana 30 173296 2305
33188 33188 2021-10-26 Nebraska 31 281689 2755
33189 33189 2021-10-26 Nevada 32 447897 7577
33190 33190 2021-10-26 New Hampshire 33 132441 1543
33191 33191 2021-10-26 New Jersey 34 1191912 27896
33192 33192 2021-10-26 New Mexico 35 271898 5014
33193 33193 2021-10-26 New York 36 2538935 55840
33194 33194 2021-10-26 North Carolina 37 1472579 17906
33195 33195 2021-10-26 North Dakota 38 145779 1770
33196 33196 2021-10-26 Northern Mariana Islands 69 291 3
33197 33197 2021-10-26 Ohio 39 1527976 24164
33198 33198 2021-10-26 Oklahoma 40 641497 10540
33199 33199 2021-10-26 Oregon 41 361240 4318
33200 33200 2021-10-26 Pennsylvania 42 1544463 31055
33201 33201 2021-10-26 Puerto Rico 72 217837 3223
33202 33202 2021-10-26 Rhode Island 44 178646 2876
33203 33203 2021-10-26 South Carolina 45 894221 13565
33204 33204 2021-10-26 South Dakota 46 153321 2228
33205 33205 2021-10-26 Tennessee 47 1247192 16109
33206 33206 2021-10-26 Texas 48 4212519 70815
33207 33207 2021-10-26 Utah 49 544253 3159
33208 33208 2021-10-26 Vermont 50 39072 356
33209 33209 2021-10-26 Virgin Islands 78 7145 80
33210 33210 2021-10-26 Virginia 51 919999 13793
33211 33211 2021-10-26 Washington 53 720311 8572
33212 33212 2021-10-26 West Virginia 54 268112 4316
33213 33213 2021-10-26 Wisconsin 55 875162 9344
33214 33214 2021-10-26 Wyoming 56 101424 1174
33103 33103 2021-10-25 Alabama 1 820312 15407
33104 33104 2021-10-25 Alaska 2 134059 685
33105 33105 2021-10-25 American Samoa 60 1 0
33106 33106 2021-10-25 Arizona 4 1149982 20866
33107 33107 2021-10-25 Arkansas 5 510406 8292
33108 33108 2021-10-25 California 6 4872707 71639
33109 33109 2021-10-25 Colorado 8 731603 8273
33110 33110 2021-10-25 Connecticut 9 401125 8739
33111 33111 2021-10-25 Delaware 10 142600 2064
33112 33112 2021-10-25 District of Columbia 11 63879 1186
33113 33113 2021-10-25 Florida 12 3639280 58933
33114 33114 2021-10-25 Georgia 13 1592167 27631
33115 33115 2021-10-25 Guam 66 18640 228
33116 33116 2021-10-25 Hawaii 15 80807 885
33117 33117 2021-10-25 Idaho 16 286399 3429
33118 33118 2021-10-25 Illinois 17 1691341 28477
33119 33119 2021-10-25 Indiana 18 1014742 16524
33120 33120 2021-10-25 Iowa 19 479153 6848
33121 33121 2021-10-25 Kansas 20 431258 6268
33122 33122 2021-10-25 Kentucky 21 742856 9741
33123 33123 2021-10-25 Louisiana 22 756509 14480
33124 33124 2021-10-25 Maine 23 100967 1122
33125 33125 2021-10-25 Maryland 24 556826 10811
33126 33126 2021-10-25 Massachusetts 25 846044 18931
33127 33127 2021-10-25 Michigan 26 1253227 23342
33128 33128 2021-10-25 Minnesota 27 773351 8683
33129 33129 2021-10-25 Mississippi 28 501652 10024
33130 33130 2021-10-25 Missouri 29 865878 12673
33131 33131 2021-10-25 Montana 30 172170 2260
33132 33132 2021-10-25 Nebraska 31 280836 2755
33133 33133 2021-10-25 Nevada 32 447173 7547
33134 33134 2021-10-25 New Hampshire 33 132441 1543
33135 33135 2021-10-25 New Jersey 34 1190439 27863
33136 33136 2021-10-25 New Mexico 35 271212 5004
33137 33137 2021-10-25 New York 36 2536439 55806
33138 33138 2021-10-25 North Carolina 37 1471333 17885
33139 33139 2021-10-25 North Dakota 38 145038 1753
33140 33140 2021-10-25 Northern Mariana Islands 69 291 3
33141 33141 2021-10-25 Ohio 39 1524169 23955
33142 33142 2021-10-25 Oklahoma 40 639720 10540
33143 33143 2021-10-25 Oregon 41 359733 4295
33144 33144 2021-10-25 Pennsylvania 42 1540721 30976
33145 33145 2021-10-25 Puerto Rico 72 217818 3221
33146 33146 2021-10-25 Rhode Island 44 178461 2874

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
);