Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
This data as json, CSV (advanced)
Suggested facets: date (date)
| Link | rowid | date ▲ | county | state | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 291811 | 291811 | 2020-07-03 | Morgan | Alabama | 1103 | 1060 | 5 |
| 292044 | 292044 | 2020-07-03 | Morgan | Colorado | 8087 | 654 | 46 |
| 292248 | 292248 | 2020-07-03 | Morgan | Georgia | 13211 | 64 | 0 |
| 292419 | 292419 | 2020-07-03 | Morgan | Illinois | 17137 | 130 | 3 |
| 292508 | 292508 | 2020-07-03 | Morgan | Indiana | 18109 | 336 | 35 |
| 292829 | 292829 | 2020-07-03 | Morgan | Kentucky | 21175 | 9 | 0 |
| 293307 | 293307 | 2020-07-03 | Morgan | Missouri | 29141 | 15 | 0 |
| 293817 | 293817 | 2020-07-03 | Morgan | Ohio | 39115 | 11 | 0 |
| 294202 | 294202 | 2020-07-03 | Morgan | Tennessee | 47129 | 25 | 1 |
| 294492 | 294492 | 2020-07-03 | Morgan | Utah | 49029 | 24 | 0 |
| 294724 | 294724 | 2020-07-03 | Morgan | West Virginia | 54065 | 20 | 0 |
| 288735 | 288735 | 2020-07-02 | Morgan | Alabama | 1103 | 1032 | 3 |
| 288967 | 288967 | 2020-07-02 | Morgan | Colorado | 8087 | 654 | 46 |
| 289171 | 289171 | 2020-07-02 | Morgan | Georgia | 13211 | 54 | 0 |
| 289341 | 289341 | 2020-07-02 | Morgan | Illinois | 17137 | 129 | 3 |
| 289429 | 289429 | 2020-07-02 | Morgan | Indiana | 18109 | 333 | 34 |
| 289750 | 289750 | 2020-07-02 | Morgan | Kentucky | 21175 | 8 | 0 |
| 290228 | 290228 | 2020-07-02 | Morgan | Missouri | 29141 | 14 | 0 |
| 290736 | 290736 | 2020-07-02 | Morgan | Ohio | 39115 | 9 | 0 |
| 291121 | 291121 | 2020-07-02 | Morgan | Tennessee | 47129 | 24 | 1 |
| 291409 | 291409 | 2020-07-02 | Morgan | Utah | 49029 | 23 | 0 |
| 291641 | 291641 | 2020-07-02 | Morgan | West Virginia | 54065 | 20 | 0 |
| 285661 | 285661 | 2020-07-01 | Morgan | Alabama | 1103 | 993 | 3 |
| 285892 | 285892 | 2020-07-01 | Morgan | Colorado | 8087 | 653 | 46 |
| 286096 | 286096 | 2020-07-01 | Morgan | Georgia | 13211 | 52 | 0 |
| 286266 | 286266 | 2020-07-01 | Morgan | Illinois | 17137 | 128 | 3 |
| 286354 | 286354 | 2020-07-01 | Morgan | Indiana | 18109 | 330 | 34 |
| 286675 | 286675 | 2020-07-01 | Morgan | Kentucky | 21175 | 8 | 0 |
| 287153 | 287153 | 2020-07-01 | Morgan | Missouri | 29141 | 14 | 0 |
| 287660 | 287660 | 2020-07-01 | Morgan | Ohio | 39115 | 9 | 0 |
| 288044 | 288044 | 2020-07-01 | Morgan | Tennessee | 47129 | 24 | 1 |
| 288333 | 288333 | 2020-07-01 | Morgan | Utah | 49029 | 22 | 0 |
| 288565 | 288565 | 2020-07-01 | Morgan | West Virginia | 54065 | 20 | 0 |
| 282588 | 282588 | 2020-06-30 | Morgan | Alabama | 1103 | 966 | 3 |
| 282819 | 282819 | 2020-06-30 | Morgan | Colorado | 8087 | 652 | 46 |
| 283023 | 283023 | 2020-06-30 | Morgan | Georgia | 13211 | 52 | 0 |
| 283194 | 283194 | 2020-06-30 | Morgan | Illinois | 17137 | 128 | 3 |
| 283282 | 283282 | 2020-06-30 | Morgan | Indiana | 18109 | 328 | 34 |
| 283604 | 283604 | 2020-06-30 | Morgan | Kentucky | 21175 | 8 | 0 |
| 284081 | 284081 | 2020-06-30 | Morgan | Missouri | 29141 | 14 | 0 |
| 284587 | 284587 | 2020-06-30 | Morgan | Ohio | 39115 | 9 | 0 |
| 284971 | 284971 | 2020-06-30 | Morgan | Tennessee | 47129 | 24 | 1 |
| 285259 | 285259 | 2020-06-30 | Morgan | Utah | 49029 | 22 | 0 |
| 285491 | 285491 | 2020-06-30 | Morgan | West Virginia | 54065 | 20 | 0 |
| 279519 | 279519 | 2020-06-29 | Morgan | Alabama | 1103 | 948 | 3 |
| 279750 | 279750 | 2020-06-29 | Morgan | Colorado | 8087 | 652 | 46 |
| 279954 | 279954 | 2020-06-29 | Morgan | Georgia | 13211 | 49 | 0 |
| 280122 | 280122 | 2020-06-29 | Morgan | Illinois | 17137 | 127 | 3 |
| 280210 | 280210 | 2020-06-29 | Morgan | Indiana | 18109 | 326 | 34 |
| 280532 | 280532 | 2020-06-29 | Morgan | Kentucky | 21175 | 8 | 0 |
| 281008 | 281008 | 2020-06-29 | Morgan | Missouri | 29141 | 13 | 0 |
| 281514 | 281514 | 2020-06-29 | Morgan | Ohio | 39115 | 7 | 0 |
| 281897 | 281897 | 2020-06-29 | Morgan | Tennessee | 47129 | 23 | 1 |
| 282186 | 282186 | 2020-06-29 | Morgan | Utah | 49029 | 19 | 0 |
| 282418 | 282418 | 2020-06-29 | Morgan | West Virginia | 54065 | 20 | 0 |
| 276451 | 276451 | 2020-06-28 | Morgan | Alabama | 1103 | 925 | 3 |
| 276682 | 276682 | 2020-06-28 | Morgan | Colorado | 8087 | 652 | 46 |
| 276886 | 276886 | 2020-06-28 | Morgan | Georgia | 13211 | 49 | 0 |
| 277055 | 277055 | 2020-06-28 | Morgan | Illinois | 17137 | 126 | 3 |
| 277143 | 277143 | 2020-06-28 | Morgan | Indiana | 18109 | 324 | 34 |
| 277463 | 277463 | 2020-06-28 | Morgan | Kentucky | 21175 | 8 | 0 |
| 277940 | 277940 | 2020-06-28 | Morgan | Missouri | 29141 | 13 | 0 |
| 278446 | 278446 | 2020-06-28 | Morgan | Ohio | 39115 | 7 | 0 |
| 278829 | 278829 | 2020-06-28 | Morgan | Tennessee | 47129 | 23 | 1 |
| 279117 | 279117 | 2020-06-28 | Morgan | Utah | 49029 | 18 | 0 |
| 279349 | 279349 | 2020-06-28 | Morgan | West Virginia | 54065 | 20 | 0 |
| 273382 | 273382 | 2020-06-27 | Morgan | Alabama | 1103 | 916 | 3 |
| 273613 | 273613 | 2020-06-27 | Morgan | Colorado | 8087 | 651 | 46 |
| 273817 | 273817 | 2020-06-27 | Morgan | Georgia | 13211 | 46 | 0 |
| 273985 | 273985 | 2020-06-27 | Morgan | Illinois | 17137 | 126 | 3 |
| 274073 | 274073 | 2020-06-27 | Morgan | Indiana | 18109 | 323 | 34 |
| 274393 | 274393 | 2020-06-27 | Morgan | Kentucky | 21175 | 8 | 0 |
| 274870 | 274870 | 2020-06-27 | Morgan | Missouri | 29141 | 13 | 0 |
| 275378 | 275378 | 2020-06-27 | Morgan | Ohio | 39115 | 7 | 0 |
| 275761 | 275761 | 2020-06-27 | Morgan | Tennessee | 47129 | 23 | 1 |
| 276049 | 276049 | 2020-06-27 | Morgan | Utah | 49029 | 18 | 0 |
| 276281 | 276281 | 2020-06-27 | Morgan | West Virginia | 54065 | 20 | 0 |
| 270313 | 270313 | 2020-06-26 | Morgan | Alabama | 1103 | 895 | 3 |
| 270544 | 270544 | 2020-06-26 | Morgan | Colorado | 8087 | 650 | 46 |
| 270748 | 270748 | 2020-06-26 | Morgan | Georgia | 13211 | 46 | 0 |
| 270916 | 270916 | 2020-06-26 | Morgan | Illinois | 17137 | 124 | 3 |
| 271004 | 271004 | 2020-06-26 | Morgan | Indiana | 18109 | 319 | 34 |
| 271324 | 271324 | 2020-06-26 | Morgan | Kentucky | 21175 | 8 | 0 |
| 271801 | 271801 | 2020-06-26 | Morgan | Missouri | 29141 | 13 | 0 |
| 272309 | 272309 | 2020-06-26 | Morgan | Ohio | 39115 | 7 | 0 |
| 272692 | 272692 | 2020-06-26 | Morgan | Tennessee | 47129 | 23 | 1 |
| 272980 | 272980 | 2020-06-26 | Morgan | Utah | 49029 | 18 | 0 |
| 273212 | 273212 | 2020-06-26 | Morgan | West Virginia | 54065 | 20 | 0 |
| 267252 | 267252 | 2020-06-25 | Morgan | Alabama | 1103 | 866 | 2 |
| 267483 | 267483 | 2020-06-25 | Morgan | Colorado | 8087 | 649 | 46 |
| 267687 | 267687 | 2020-06-25 | Morgan | Georgia | 13211 | 46 | 0 |
| 267853 | 267853 | 2020-06-25 | Morgan | Illinois | 17137 | 123 | 3 |
| 267941 | 267941 | 2020-06-25 | Morgan | Indiana | 18109 | 318 | 33 |
| 268260 | 268260 | 2020-06-25 | Morgan | Kentucky | 21175 | 8 | 0 |
| 268737 | 268737 | 2020-06-25 | Morgan | Missouri | 29141 | 13 | 0 |
| 269241 | 269241 | 2020-06-25 | Morgan | Ohio | 39115 | 6 | 0 |
| 269624 | 269624 | 2020-06-25 | Morgan | Tennessee | 47129 | 22 | 1 |
| 269911 | 269911 | 2020-06-25 | Morgan | Utah | 49029 | 17 | 0 |
| 270143 | 270143 | 2020-06-25 | Morgan | West Virginia | 54065 | 20 | 0 |
| 264197 | 264197 | 2020-06-24 | Morgan | Alabama | 1103 | 825 | 2 |
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );