ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where "date" is on date 2021-02-14 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Alabama 1
- Alaska 1
- Arizona 1
- Arkansas 1
- California 1
- Colorado 1
- Connecticut 1
- Delaware 1
- District of Columbia 1
- Florida 1
- Georgia 1
- Guam 1
- Hawaii 1
- Idaho 1
- Illinois 1
- Indiana 1
- Iowa 1
- Kansas 1
- Kentucky 1
- Louisiana 1
- Maine 1
- Maryland 1
- Massachusetts 1
- Michigan 1
- Minnesota 1
- Mississippi 1
- Missouri 1
- Montana 1
- Nebraska 1
- Nevada 1
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
19155 | 19155 | 2021-02-14 | Alabama | 1 | 480931 | 9242 |
19156 | 19156 | 2021-02-14 | Alaska | 2 | 56008 | 271 |
19157 | 19157 | 2021-02-14 | Arizona | 4 | 797537 | 14978 |
19158 | 19158 | 2021-02-14 | Arkansas | 5 | 313028 | 5265 |
19159 | 19159 | 2021-02-14 | California | 6 | 3485533 | 47055 |
19160 | 19160 | 2021-02-14 | Colorado | 8 | 415857 | 5921 |
19161 | 19161 | 2021-02-14 | Connecticut | 9 | 267337 | 7381 |
19162 | 19162 | 2021-02-14 | Delaware | 10 | 83003 | 1283 |
19163 | 19163 | 2021-02-14 | District of Columbia | 11 | 38918 | 979 |
19164 | 19164 | 2021-02-14 | Florida | 12 | 1827365 | 28778 |
19165 | 19165 | 2021-02-14 | Georgia | 13 | 940451 | 15397 |
19166 | 19166 | 2021-02-14 | Guam | 66 | 8664 | 131 |
19167 | 19167 | 2021-02-14 | Hawaii | 15 | 26772 | 423 |
19168 | 19168 | 2021-02-14 | Idaho | 16 | 167566 | 1805 |
19169 | 19169 | 2021-02-14 | Illinois | 17 | 1164743 | 22121 |
19170 | 19170 | 2021-02-14 | Indiana | 18 | 652060 | 12173 |
19171 | 19171 | 2021-02-14 | Iowa | 19 | 329258 | 5236 |
19172 | 19172 | 2021-02-14 | Kansas | 20 | 289225 | 4364 |
19173 | 19173 | 2021-02-14 | Kentucky | 21 | 392990 | 4447 |
19174 | 19174 | 2021-02-14 | Louisiana | 22 | 419891 | 9292 |
19175 | 19175 | 2021-02-14 | Maine | 23 | 42529 | 649 |
19176 | 19176 | 2021-02-14 | Maryland | 24 | 371163 | 7554 |
19177 | 19177 | 2021-02-14 | Massachusetts | 25 | 557777 | 15484 |
19178 | 19178 | 2021-02-14 | Michigan | 26 | 628199 | 16108 |
19179 | 19179 | 2021-02-14 | Minnesota | 27 | 473635 | 6444 |
19180 | 19180 | 2021-02-14 | Mississippi | 28 | 287436 | 6462 |
19181 | 19181 | 2021-02-14 | Missouri | 29 | 515507 | 7875 |
19182 | 19182 | 2021-02-14 | Montana | 30 | 97425 | 1328 |
19183 | 19183 | 2021-02-14 | Nebraska | 31 | 197658 | 2123 |
19184 | 19184 | 2021-02-14 | Nevada | 32 | 288483 | 4709 |
19185 | 19185 | 2021-02-14 | New Hampshire | 33 | 70785 | 1133 |
19186 | 19186 | 2021-02-14 | New Jersey | 34 | 745987 | 22454 |
19187 | 19187 | 2021-02-14 | New Mexico | 35 | 180571 | 3531 |
19188 | 19188 | 2021-02-14 | New York | 36 | 1540127 | 45431 |
19189 | 19189 | 2021-02-14 | North Carolina | 37 | 822542 | 10524 |
19190 | 19190 | 2021-02-14 | North Dakota | 38 | 98627 | 1461 |
19191 | 19191 | 2021-02-14 | Northern Mariana Islands | 69 | 134 | 2 |
19192 | 19192 | 2021-02-14 | Ohio | 39 | 939350 | 16346 |
19193 | 19193 | 2021-02-14 | Oklahoma | 40 | 413542 | 4024 |
19194 | 19194 | 2021-02-14 | Oregon | 41 | 150281 | 2137 |
19195 | 19195 | 2021-02-14 | Pennsylvania | 42 | 899474 | 23136 |
19196 | 19196 | 2021-02-14 | Puerto Rico | 72 | 131224 | 1919 |
19197 | 19197 | 2021-02-14 | Rhode Island | 44 | 120821 | 2290 |
19198 | 19198 | 2021-02-14 | South Carolina | 45 | 487293 | 7998 |
19199 | 19199 | 2021-02-14 | South Dakota | 46 | 110315 | 1844 |
19200 | 19200 | 2021-02-14 | Tennessee | 47 | 743266 | 10842 |
19201 | 19201 | 2021-02-14 | Texas | 48 | 2566191 | 41440 |
19202 | 19202 | 2021-02-14 | Utah | 49 | 361353 | 1794 |
19203 | 19203 | 2021-02-14 | Vermont | 50 | 13677 | 189 |
19204 | 19204 | 2021-02-14 | Virgin Islands | 78 | 2525 | 25 |
19205 | 19205 | 2021-02-14 | Virginia | 51 | 549999 | 7012 |
19206 | 19206 | 2021-02-14 | Washington | 53 | 331164 | 4739 |
19207 | 19207 | 2021-02-14 | West Virginia | 54 | 127588 | 2210 |
19208 | 19208 | 2021-02-14 | Wisconsin | 55 | 607213 | 6748 |
19209 | 19209 | 2021-02-14 | Wyoming | 56 | 53136 | 647 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );