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-03-24 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 |
---|---|---|---|---|---|---|
21245 | 21245 | 2021-03-24 | Alabama | 1 | 512711 | 10487 |
21246 | 21246 | 2021-03-24 | Alaska | 2 | 61411 | 298 |
21247 | 21247 | 2021-03-24 | Arizona | 4 | 837849 | 16842 |
21248 | 21248 | 2021-03-24 | Arkansas | 5 | 329177 | 5560 |
21249 | 21249 | 2021-03-24 | California | 6 | 3650958 | 58187 |
21250 | 21250 | 2021-03-24 | Colorado | 8 | 456069 | 6158 |
21251 | 21251 | 2021-03-24 | Connecticut | 9 | 302022 | 7852 |
21252 | 21252 | 2021-03-24 | Delaware | 10 | 92819 | 1535 |
21253 | 21253 | 2021-03-24 | District of Columbia | 11 | 43595 | 1053 |
21254 | 21254 | 2021-03-24 | Florida | 12 | 2021648 | 32849 |
21255 | 21255 | 2021-03-24 | Georgia | 13 | 1024530 | 18091 |
21256 | 21256 | 2021-03-24 | Guam | 66 | 8758 | 135 |
21257 | 21257 | 2021-03-24 | Hawaii | 15 | 29005 | 454 |
21258 | 21258 | 2021-03-24 | Idaho | 16 | 178663 | 1955 |
21259 | 21259 | 2021-03-24 | Illinois | 17 | 1231154 | 23408 |
21260 | 21260 | 2021-03-24 | Indiana | 18 | 683330 | 12975 |
21261 | 21261 | 2021-03-24 | Iowa | 19 | 347590 | 5689 |
21262 | 21262 | 2021-03-24 | Kansas | 20 | 303234 | 4881 |
21263 | 21263 | 2021-03-24 | Kentucky | 21 | 426210 | 5911 |
21264 | 21264 | 2021-03-24 | Louisiana | 22 | 442221 | 10056 |
21265 | 21265 | 2021-03-24 | Maine | 23 | 48972 | 731 |
21266 | 21266 | 2021-03-24 | Maryland | 24 | 402785 | 8214 |
21267 | 21267 | 2021-03-24 | Massachusetts | 25 | 619816 | 16970 |
21268 | 21268 | 2021-03-24 | Michigan | 26 | 705335 | 16940 |
21269 | 21269 | 2021-03-24 | Minnesota | 27 | 508609 | 6866 |
21270 | 21270 | 2021-03-24 | Mississippi | 28 | 303625 | 6981 |
21271 | 21271 | 2021-03-24 | Missouri | 29 | 584084 | 8892 |
21272 | 21272 | 2021-03-24 | Montana | 30 | 103796 | 1431 |
21273 | 21273 | 2021-03-24 | Nebraska | 31 | 207634 | 2273 |
21274 | 21274 | 2021-03-24 | Nevada | 32 | 301749 | 5203 |
21275 | 21275 | 2021-03-24 | New Hampshire | 33 | 81521 | 1228 |
21276 | 21276 | 2021-03-24 | New Jersey | 34 | 877936 | 24293 |
21277 | 21277 | 2021-03-24 | New Mexico | 35 | 190275 | 3911 |
21278 | 21278 | 2021-03-24 | New York | 36 | 1814919 | 49231 |
21279 | 21279 | 2021-03-24 | North Carolina | 37 | 902610 | 11975 |
21280 | 21280 | 2021-03-24 | North Dakota | 38 | 102032 | 1495 |
21281 | 21281 | 2021-03-24 | Northern Mariana Islands | 69 | 158 | 2 |
21282 | 21282 | 2021-03-24 | Ohio | 39 | 1004670 | 18382 |
21283 | 21283 | 2021-03-24 | Oklahoma | 40 | 436135 | 4850 |
21284 | 21284 | 2021-03-24 | Oregon | 41 | 162461 | 2380 |
21285 | 21285 | 2021-03-24 | Pennsylvania | 42 | 1001913 | 24934 |
21286 | 21286 | 2021-03-24 | Puerto Rico | 72 | 138503 | 2100 |
21287 | 21287 | 2021-03-24 | Rhode Island | 44 | 134807 | 2606 |
21288 | 21288 | 2021-03-24 | South Carolina | 45 | 543925 | 9055 |
21289 | 21289 | 2021-03-24 | South Dakota | 46 | 116370 | 1924 |
21290 | 21290 | 2021-03-24 | Tennessee | 47 | 789976 | 11687 |
21291 | 21291 | 2021-03-24 | Texas | 48 | 2762762 | 47864 |
21292 | 21292 | 2021-03-24 | Utah | 49 | 382791 | 2082 |
21293 | 21293 | 2021-03-24 | Vermont | 50 | 18028 | 222 |
21294 | 21294 | 2021-03-24 | Virgin Islands | 78 | 2876 | 25 |
21295 | 21295 | 2021-03-24 | Virginia | 51 | 608704 | 10143 |
21296 | 21296 | 2021-03-24 | Washington | 53 | 360203 | 5250 |
21297 | 21297 | 2021-03-24 | West Virginia | 54 | 138818 | 2619 |
21298 | 21298 | 2021-03-24 | Wisconsin | 55 | 631508 | 7264 |
21299 | 21299 | 2021-03-24 | Wyoming | 56 | 55887 | 695 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );