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 2020-12-25 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 |
---|---|---|---|---|---|---|
16350 | 16350 | 2020-12-25 | Alabama | 1 | 342426 | 4680 |
16351 | 16351 | 2020-12-25 | Alaska | 2 | 44876 | 191 |
16352 | 16352 | 2020-12-25 | Arizona | 4 | 486993 | 8409 |
16353 | 16353 | 2020-12-25 | Arkansas | 5 | 213267 | 3438 |
16354 | 16354 | 2020-12-25 | California | 6 | 2064763 | 23964 |
16355 | 16355 | 2020-12-25 | Colorado | 8 | 323329 | 4631 |
16356 | 16356 | 2020-12-25 | Connecticut | 9 | 172743 | 5791 |
16357 | 16357 | 2020-12-25 | Delaware | 10 | 53653 | 891 |
16358 | 16358 | 2020-12-25 | District of Columbia | 11 | 27436 | 756 |
16359 | 16359 | 2020-12-25 | Florida | 12 | 1247538 | 20994 |
16360 | 16360 | 2020-12-25 | Georgia | 13 | 603246 | 10303 |
16361 | 16361 | 2020-12-25 | Guam | 66 | 8237 | 122 |
16362 | 16362 | 2020-12-25 | Hawaii | 15 | 20861 | 283 |
16363 | 16363 | 2020-12-25 | Idaho | 16 | 135383 | 1353 |
16364 | 16364 | 2020-12-25 | Illinois | 17 | 932427 | 17155 |
16365 | 16365 | 2020-12-25 | Indiana | 18 | 491125 | 7770 |
16366 | 16366 | 2020-12-25 | Iowa | 19 | 274266 | 3744 |
16367 | 16367 | 2020-12-25 | Kansas | 20 | 213076 | 2507 |
16368 | 16368 | 2020-12-25 | Kentucky | 21 | 253824 | 2782 |
16369 | 16369 | 2020-12-25 | Louisiana | 22 | 296499 | 7272 |
16370 | 16370 | 2020-12-25 | Maine | 23 | 21547 | 319 |
16371 | 16371 | 2020-12-25 | Maryland | 24 | 263326 | 5659 |
16372 | 16372 | 2020-12-25 | Massachusetts | 25 | 341925 | 11963 |
16373 | 16373 | 2020-12-25 | Michigan | 26 | 507687 | 12406 |
16374 | 16374 | 2020-12-25 | Minnesota | 27 | 404462 | 5109 |
16375 | 16375 | 2020-12-25 | Mississippi | 28 | 204178 | 4562 |
16376 | 16376 | 2020-12-25 | Missouri | 29 | 400714 | 5633 |
16377 | 16377 | 2020-12-25 | Montana | 30 | 79066 | 918 |
16378 | 16378 | 2020-12-25 | Nebraska | 31 | 161960 | 1594 |
16379 | 16379 | 2020-12-25 | Nevada | 32 | 214077 | 2943 |
16380 | 16380 | 2020-12-25 | New Hampshire | 33 | 38902 | 690 |
16381 | 16381 | 2020-12-25 | New Jersey | 34 | 456847 | 18595 |
16382 | 16382 | 2020-12-25 | New Mexico | 35 | 136622 | 2309 |
16383 | 16383 | 2020-12-25 | New York | 36 | 909123 | 36739 |
16384 | 16384 | 2020-12-25 | North Carolina | 37 | 498005 | 6420 |
16385 | 16385 | 2020-12-25 | North Dakota | 38 | 91229 | 1271 |
16386 | 16386 | 2020-12-25 | Northern Mariana Islands | 69 | 118 | 2 |
16387 | 16387 | 2020-12-25 | Ohio | 39 | 653650 | 8456 |
16388 | 16388 | 2020-12-25 | Oklahoma | 40 | 272553 | 2328 |
16389 | 16389 | 2020-12-25 | Oregon | 41 | 107833 | 1431 |
16390 | 16390 | 2020-12-25 | Pennsylvania | 42 | 602605 | 14892 |
16391 | 16391 | 2020-12-25 | Puerto Rico | 72 | 105039 | 1432 |
16392 | 16392 | 2020-12-25 | Rhode Island | 44 | 82066 | 1704 |
16393 | 16393 | 2020-12-25 | South Carolina | 45 | 285028 | 5043 |
16394 | 16394 | 2020-12-25 | South Dakota | 46 | 96546 | 1430 |
16395 | 16395 | 2020-12-25 | Tennessee | 47 | 541267 | 6367 |
16396 | 16396 | 2020-12-25 | Texas | 48 | 1661619 | 27042 |
16397 | 16397 | 2020-12-25 | Utah | 49 | 260589 | 1205 |
16398 | 16398 | 2020-12-25 | Vermont | 50 | 6781 | 120 |
16399 | 16399 | 2020-12-25 | Virgin Islands | 78 | 1979 | 23 |
16400 | 16400 | 2020-12-25 | Virginia | 51 | 327993 | 4820 |
16401 | 16401 | 2020-12-25 | Washington | 53 | 237689 | 3268 |
16402 | 16402 | 2020-12-25 | West Virginia | 54 | 78836 | 1247 |
16403 | 16403 | 2020-12-25 | Wisconsin | 55 | 505345 | 5028 |
16404 | 16404 | 2020-12-25 | Wyoming | 56 | 42664 | 373 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );