ny_times_us_counties

Table actions
⚠️ 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

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

state

fips

county

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