ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where "date" is on date 2020-03-25 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 |
---|---|---|---|---|---|---|
1228 | 1228 | 2020-03-25 | Alabama | 1 | 386 | 1 |
1229 | 1229 | 2020-03-25 | Alaska | 2 | 59 | 0 |
1230 | 1230 | 2020-03-25 | Arizona | 4 | 402 | 6 |
1231 | 1231 | 2020-03-25 | Arkansas | 5 | 307 | 2 |
1232 | 1232 | 2020-03-25 | California | 6 | 3183 | 68 |
1233 | 1233 | 2020-03-25 | Colorado | 8 | 1086 | 19 |
1234 | 1234 | 2020-03-25 | Connecticut | 9 | 875 | 19 |
1235 | 1235 | 2020-03-25 | Delaware | 10 | 119 | 0 |
1236 | 1236 | 2020-03-25 | District of Columbia | 11 | 183 | 2 |
1237 | 1237 | 2020-03-25 | Florida | 12 | 1971 | 23 |
1238 | 1238 | 2020-03-25 | Georgia | 13 | 1385 | 47 |
1239 | 1239 | 2020-03-25 | Guam | 66 | 32 | 1 |
1240 | 1240 | 2020-03-25 | Hawaii | 15 | 95 | 0 |
1241 | 1241 | 2020-03-25 | Idaho | 16 | 123 | 0 |
1242 | 1242 | 2020-03-25 | Illinois | 17 | 1874 | 21 |
1243 | 1243 | 2020-03-25 | Indiana | 18 | 484 | 19 |
1244 | 1244 | 2020-03-25 | Iowa | 19 | 147 | 1 |
1245 | 1245 | 2020-03-25 | Kansas | 20 | 134 | 3 |
1246 | 1246 | 2020-03-25 | Kentucky | 21 | 198 | 5 |
1247 | 1247 | 2020-03-25 | Louisiana | 22 | 1795 | 65 |
1248 | 1248 | 2020-03-25 | Maine | 23 | 142 | 0 |
1249 | 1249 | 2020-03-25 | Maryland | 24 | 423 | 4 |
1250 | 1250 | 2020-03-25 | Massachusetts | 25 | 1838 | 15 |
1251 | 1251 | 2020-03-25 | Michigan | 26 | 2293 | 43 |
1252 | 1252 | 2020-03-25 | Minnesota | 27 | 289 | 1 |
1253 | 1253 | 2020-03-25 | Mississippi | 28 | 376 | 5 |
1254 | 1254 | 2020-03-25 | Missouri | 29 | 384 | 8 |
1255 | 1255 | 2020-03-25 | Montana | 30 | 65 | 0 |
1256 | 1256 | 2020-03-25 | Nebraska | 31 | 84 | 0 |
1257 | 1257 | 2020-03-25 | Nevada | 32 | 405 | 10 |
1258 | 1258 | 2020-03-25 | New Hampshire | 33 | 137 | 1 |
1259 | 1259 | 2020-03-25 | New Jersey | 34 | 4402 | 62 |
1260 | 1260 | 2020-03-25 | New Mexico | 35 | 113 | 1 |
1261 | 1261 | 2020-03-25 | New York | 36 | 33117 | 381 |
1262 | 1262 | 2020-03-25 | North Carolina | 37 | 562 | 1 |
1263 | 1263 | 2020-03-25 | North Dakota | 38 | 45 | 0 |
1264 | 1264 | 2020-03-25 | Ohio | 39 | 707 | 11 |
1265 | 1265 | 2020-03-25 | Oklahoma | 40 | 164 | 5 |
1266 | 1266 | 2020-03-25 | Oregon | 41 | 266 | 10 |
1267 | 1267 | 2020-03-25 | Pennsylvania | 42 | 1151 | 12 |
1268 | 1268 | 2020-03-25 | Puerto Rico | 72 | 51 | 2 |
1269 | 1269 | 2020-03-25 | Rhode Island | 44 | 132 | 0 |
1270 | 1270 | 2020-03-25 | South Carolina | 45 | 425 | 8 |
1271 | 1271 | 2020-03-25 | South Dakota | 46 | 41 | 1 |
1272 | 1272 | 2020-03-25 | Tennessee | 47 | 806 | 3 |
1273 | 1273 | 2020-03-25 | Texas | 48 | 1132 | 13 |
1274 | 1274 | 2020-03-25 | Utah | 49 | 346 | 1 |
1275 | 1275 | 2020-03-25 | Vermont | 50 | 123 | 8 |
1276 | 1276 | 2020-03-25 | Virgin Islands | 78 | 17 | 0 |
1277 | 1277 | 2020-03-25 | Virginia | 51 | 390 | 9 |
1278 | 1278 | 2020-03-25 | Washington | 53 | 2585 | 130 |
1279 | 1279 | 2020-03-25 | West Virginia | 54 | 51 | 0 |
1280 | 1280 | 2020-03-25 | Wisconsin | 55 | 623 | 7 |
1281 | 1281 | 2020-03-25 | Wyoming | 56 | 49 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );