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-07-27 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|
28120 | 28120 | 2021-07-27 | Alabama | 1 | 574737 | 11492 |
28121 | 28121 | 2021-07-27 | Alaska | 2 | 73757 | 367 |
28122 | 28122 | 2021-07-27 | Arizona | 4 | 920084 | 18183 |
28123 | 28123 | 2021-07-27 | Arkansas | 5 | 378023 | 6087 |
28124 | 28124 | 2021-07-27 | California | 6 | 4004981 | 64296 |
28125 | 28125 | 2021-07-27 | Colorado | 8 | 574601 | 7079 |
28126 | 28126 | 2021-07-27 | Connecticut | 9 | 353114 | 8288 |
28127 | 28127 | 2021-07-27 | Delaware | 10 | 110943 | 1698 |
28128 | 28128 | 2021-07-27 | District of Columbia | 11 | 50160 | 1146 |
28129 | 28129 | 2021-07-27 | Florida | 12 | 2518296 | 38748 |
28130 | 28130 | 2021-07-27 | Georgia | 13 | 1141877 | 20946 |
28131 | 28131 | 2021-07-27 | Guam | 66 | 9483 | 144 |
28132 | 28132 | 2021-07-27 | Hawaii | 15 | 39304 | 526 |
28133 | 28133 | 2021-07-27 | Idaho | 16 | 199236 | 2190 |
28134 | 28134 | 2021-07-27 | Illinois | 17 | 1417560 | 25886 |
28135 | 28135 | 2021-07-27 | Indiana | 18 | 770770 | 13980 |
28136 | 28136 | 2021-07-27 | Iowa | 19 | 377886 | 6170 |
28137 | 28137 | 2021-07-27 | Kansas | 20 | 330018 | 5282 |
28138 | 28138 | 2021-07-27 | Kentucky | 21 | 478795 | 7366 |
28139 | 28139 | 2021-07-27 | Louisiana | 22 | 527253 | 10934 |
28140 | 28140 | 2021-07-27 | Maine | 23 | 70076 | 898 |
28141 | 28141 | 2021-07-27 | Maryland | 24 | 466733 | 9810 |
28142 | 28142 | 2021-07-27 | Massachusetts | 25 | 717284 | 18065 |
28143 | 28143 | 2021-07-27 | Michigan | 26 | 1006941 | 21150 |
28144 | 28144 | 2021-07-27 | Minnesota | 27 | 610932 | 7749 |
28145 | 28145 | 2021-07-27 | Mississippi | 28 | 338079 | 7523 |
28146 | 28146 | 2021-07-27 | Missouri | 29 | 683116 | 10251 |
28147 | 28147 | 2021-07-27 | Montana | 30 | 115776 | 1699 |
28148 | 28148 | 2021-07-27 | Nebraska | 31 | 227561 | 2547 |
28149 | 28149 | 2021-07-27 | Nevada | 32 | 352567 | 5854 |
28150 | 28150 | 2021-07-27 | New Hampshire | 33 | 100398 | 1386 |
28151 | 28151 | 2021-07-27 | New Jersey | 34 | 1035027 | 26586 |
28152 | 28152 | 2021-07-27 | New Mexico | 35 | 209356 | 4404 |
28153 | 28153 | 2021-07-27 | New York | 36 | 2138250 | 53236 |
28154 | 28154 | 2021-07-27 | North Carolina | 37 | 1040149 | 13600 |
28155 | 28155 | 2021-07-27 | North Dakota | 38 | 111362 | 1569 |
28156 | 28156 | 2021-07-27 | Northern Mariana Islands | 69 | 190 | 2 |
28157 | 28157 | 2021-07-27 | Ohio | 39 | 1123964 | 20490 |
28158 | 28158 | 2021-07-27 | Oklahoma | 40 | 475578 | 7454 |
28159 | 28159 | 2021-07-27 | Oregon | 41 | 216875 | 2872 |
28160 | 28160 | 2021-07-27 | Pennsylvania | 42 | 1226157 | 27831 |
28161 | 28161 | 2021-07-27 | Puerto Rico | 72 | 177936 | 2569 |
28162 | 28162 | 2021-07-27 | Rhode Island | 44 | 153802 | 2739 |
28163 | 28163 | 2021-07-27 | South Carolina | 45 | 611594 | 9883 |
28164 | 28164 | 2021-07-27 | South Dakota | 46 | 124948 | 2041 |
28165 | 28165 | 2021-07-27 | Tennessee | 47 | 872825 | 12616 |
28166 | 28166 | 2021-07-27 | Texas | 48 | 3088278 | 53210 |
28167 | 28167 | 2021-07-27 | Utah | 49 | 429372 | 2441 |
28168 | 28168 | 2021-07-27 | Vermont | 50 | 24760 | 259 |
28169 | 28169 | 2021-07-27 | Virgin Islands | 78 | 4375 | 35 |
28170 | 28170 | 2021-07-27 | Virginia | 51 | 691018 | 11515 |
28171 | 28171 | 2021-07-27 | Washington | 53 | 471529 | 6141 |
28172 | 28172 | 2021-07-27 | West Virginia | 54 | 166297 | 2936 |
28173 | 28173 | 2021-07-27 | Wisconsin | 55 | 684331 | 8261 |
28174 | 28174 | 2021-07-27 | Wyoming | 56 | 64623 | 776 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );