⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

3,428 rows where county = "Adams" sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

county

  • Adams · 3,428
Link rowid date ▲ county state fips cases deaths
933743 2021-01-16 Adams Colorado 8001 44426 575
934056 2021-01-16 Adams Idaho 16003 302 3
934099 2021-01-16 Adams Illinois 17001 7329 117
934201 2021-01-16 Adams Indiana 18001 2945 36
934294 2021-01-16 Adams Iowa 19003 295 3
934913 2021-01-16 Adams Mississippi 28001 2032 70
935168 2021-01-16 Adams Nebraska 31001 2479 36
935502 2021-01-16 Adams North Dakota 38001 229 2
935558 2021-01-16 Adams Ohio 39001 1655 15
935760 2021-01-16 Adams Pennsylvania 42001 5749 123
936555 2021-01-16 Adams Washington 53001 1710 17
936649 2021-01-16 Adams Wisconsin 55001 1573 13
930498 2021-01-15 Adams Colorado 8001 44253 568
930811 2021-01-15 Adams Idaho 16003 302 3
930854 2021-01-15 Adams Illinois 17001 7314 114
930956 2021-01-15 Adams Indiana 18001 2936 36
931049 2021-01-15 Adams Iowa 19003 293 3
931668 2021-01-15 Adams Mississippi 28001 2016 66
931923 2021-01-15 Adams Nebraska 31001 2479 36
932257 2021-01-15 Adams North Dakota 38001 223 2
932313 2021-01-15 Adams Ohio 39001 1618 15
932515 2021-01-15 Adams Pennsylvania 42001 5690 122
933310 2021-01-15 Adams Washington 53001 1710 17
933404 2021-01-15 Adams Wisconsin 55001 1566 13
927253 2021-01-14 Adams Colorado 8001 44077 567
927566 2021-01-14 Adams Idaho 16003 295 3
927609 2021-01-14 Adams Illinois 17001 7266 108
927711 2021-01-14 Adams Indiana 18001 2917 36
927804 2021-01-14 Adams Iowa 19003 292 3
928423 2021-01-14 Adams Mississippi 28001 2000 65
928678 2021-01-14 Adams Nebraska 31001 2464 36
929012 2021-01-14 Adams North Dakota 38001 220 2
929068 2021-01-14 Adams Ohio 39001 1608 15
929270 2021-01-14 Adams Pennsylvania 42001 5642 120
930065 2021-01-14 Adams Washington 53001 1704 17
930159 2021-01-14 Adams Wisconsin 55001 1560 13
924007 2021-01-13 Adams Colorado 8001 43821 564
924320 2021-01-13 Adams Idaho 16003 291 3
924363 2021-01-13 Adams Illinois 17001 7215 100
924465 2021-01-13 Adams Indiana 18001 2903 36
924558 2021-01-13 Adams Iowa 19003 291 3
925177 2021-01-13 Adams Mississippi 28001 1993 65
925432 2021-01-13 Adams Nebraska 31001 2451 36
925767 2021-01-13 Adams North Dakota 38001 216 2
925823 2021-01-13 Adams Ohio 39001 1592 15
926025 2021-01-13 Adams Pennsylvania 42001 5508 116
926820 2021-01-13 Adams Washington 53001 1689 17
926914 2021-01-13 Adams Wisconsin 55001 1549 13
920762 2021-01-12 Adams Colorado 8001 43644 562
921075 2021-01-12 Adams Idaho 16003 290 3
921118 2021-01-12 Adams Illinois 17001 7192 99
921220 2021-01-12 Adams Indiana 18001 2876 36
921313 2021-01-12 Adams Iowa 19003 288 3
921932 2021-01-12 Adams Mississippi 28001 1981 65
922187 2021-01-12 Adams Nebraska 31001 2436 36
922521 2021-01-12 Adams North Dakota 38001 212 2
922577 2021-01-12 Adams Ohio 39001 1586 15
922779 2021-01-12 Adams Pennsylvania 42001 5434 115
923574 2021-01-12 Adams Washington 53001 1689 16
923668 2021-01-12 Adams Wisconsin 55001 1544 13
917517 2021-01-11 Adams Colorado 8001 43529 559
917830 2021-01-11 Adams Idaho 16003 290 3
917873 2021-01-11 Adams Illinois 17001 7115 98
917975 2021-01-11 Adams Indiana 18001 2867 36
918068 2021-01-11 Adams Iowa 19003 288 3
918687 2021-01-11 Adams Mississippi 28001 1960 65
918942 2021-01-11 Adams Nebraska 31001 2423 36
919276 2021-01-11 Adams North Dakota 38001 212 2
919332 2021-01-11 Adams Ohio 39001 1562 15
919534 2021-01-11 Adams Pennsylvania 42001 5401 114
920329 2021-01-11 Adams Washington 53001 1689 16
920423 2021-01-11 Adams Wisconsin 55001 1537 13
914272 2021-01-10 Adams Colorado 8001 43370 559
914585 2021-01-10 Adams Idaho 16003 287 3
914628 2021-01-10 Adams Illinois 17001 7062 97
914730 2021-01-10 Adams Indiana 18001 2854 36
914823 2021-01-10 Adams Iowa 19003 288 3
915442 2021-01-10 Adams Mississippi 28001 1945 64
915697 2021-01-10 Adams Nebraska 31001 2406 36
916031 2021-01-10 Adams North Dakota 38001 209 2
916087 2021-01-10 Adams Ohio 39001 1561 15
916289 2021-01-10 Adams Pennsylvania 42001 5341 112
917084 2021-01-10 Adams Washington 53001 1684 16
917178 2021-01-10 Adams Wisconsin 55001 1525 13
911027 2021-01-09 Adams Colorado 8001 43090 556
911340 2021-01-09 Adams Idaho 16003 287 3
911383 2021-01-09 Adams Illinois 17001 7045 97
911485 2021-01-09 Adams Indiana 18001 2830 36
911578 2021-01-09 Adams Iowa 19003 288 3
912197 2021-01-09 Adams Mississippi 28001 1924 64
912452 2021-01-09 Adams Nebraska 31001 2405 36
912786 2021-01-09 Adams North Dakota 38001 203 2
912842 2021-01-09 Adams Ohio 39001 1552 15
913044 2021-01-09 Adams Pennsylvania 42001 5230 111
913839 2021-01-09 Adams Washington 53001 1684 16
913933 2021-01-09 Adams Wisconsin 55001 1521 13
907782 2021-01-08 Adams Colorado 8001 42493 547
908095 2021-01-08 Adams Idaho 16003 284 3
908138 2021-01-08 Adams Illinois 17001 7011 96
908240 2021-01-08 Adams Indiana 18001 2803 36

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);