ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,428 rows where county = "Adams" sorted by date descending
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: date (date)
state
- Indiana 313
- Colorado 311
- Nebraska 305
- Pennsylvania 305
- Illinois 303
- Mississippi 303
- Washington 300
- Idaho 292
- Wisconsin 290
- Ohio 288
- Iowa 245
- North Dakota 173
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 |
Advanced export
JSON shape: default, array, newline-delimited
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]);