ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,212 rows where county = "Adams" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 12
- Indiana 309
- Colorado 307
- Nebraska 301
- Pennsylvania 301
- Illinois 299
- Mississippi 299
- Washington 296
- Idaho 288
- Wisconsin 286
- Ohio 284
- Iowa 241
- North Dakota 169
fips 12
county 1
- Adams · 3,380 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920682 | 920682 | 2021-01-12 | Adams | Colorado | 8001 | 43644 | 562 |
920995 | 920995 | 2021-01-12 | Adams | Idaho | 16003 | 290 | 3 |
921038 | 921038 | 2021-01-12 | Adams | Illinois | 17001 | 7192 | 99 |
921140 | 921140 | 2021-01-12 | Adams | Indiana | 18001 | 2876 | 36 |
921233 | 921233 | 2021-01-12 | Adams | Iowa | 19003 | 288 | 3 |
921852 | 921852 | 2021-01-12 | Adams | Mississippi | 28001 | 1981 | 65 |
922107 | 922107 | 2021-01-12 | Adams | Nebraska | 31001 | 2436 | 36 |
922441 | 922441 | 2021-01-12 | Adams | North Dakota | 38001 | 212 | 2 |
922497 | 922497 | 2021-01-12 | Adams | Ohio | 39001 | 1586 | 15 |
922699 | 922699 | 2021-01-12 | Adams | Pennsylvania | 42001 | 5434 | 115 |
923494 | 923494 | 2021-01-12 | Adams | Washington | 53001 | 1689 | 16 |
923588 | 923588 | 2021-01-12 | Adams | Wisconsin | 55001 | 1544 | 13 |
917437 | 917437 | 2021-01-11 | Adams | Colorado | 8001 | 43529 | 559 |
917750 | 917750 | 2021-01-11 | Adams | Idaho | 16003 | 290 | 3 |
917793 | 917793 | 2021-01-11 | Adams | Illinois | 17001 | 7115 | 98 |
917895 | 917895 | 2021-01-11 | Adams | Indiana | 18001 | 2867 | 36 |
917988 | 917988 | 2021-01-11 | Adams | Iowa | 19003 | 288 | 3 |
918607 | 918607 | 2021-01-11 | Adams | Mississippi | 28001 | 1960 | 65 |
918862 | 918862 | 2021-01-11 | Adams | Nebraska | 31001 | 2423 | 36 |
919196 | 919196 | 2021-01-11 | Adams | North Dakota | 38001 | 212 | 2 |
919252 | 919252 | 2021-01-11 | Adams | Ohio | 39001 | 1562 | 15 |
919454 | 919454 | 2021-01-11 | Adams | Pennsylvania | 42001 | 5401 | 114 |
920249 | 920249 | 2021-01-11 | Adams | Washington | 53001 | 1689 | 16 |
920343 | 920343 | 2021-01-11 | Adams | Wisconsin | 55001 | 1537 | 13 |
914192 | 914192 | 2021-01-10 | Adams | Colorado | 8001 | 43370 | 559 |
914505 | 914505 | 2021-01-10 | Adams | Idaho | 16003 | 287 | 3 |
914548 | 914548 | 2021-01-10 | Adams | Illinois | 17001 | 7062 | 97 |
914650 | 914650 | 2021-01-10 | Adams | Indiana | 18001 | 2854 | 36 |
914743 | 914743 | 2021-01-10 | Adams | Iowa | 19003 | 288 | 3 |
915362 | 915362 | 2021-01-10 | Adams | Mississippi | 28001 | 1945 | 64 |
915617 | 915617 | 2021-01-10 | Adams | Nebraska | 31001 | 2406 | 36 |
915951 | 915951 | 2021-01-10 | Adams | North Dakota | 38001 | 209 | 2 |
916007 | 916007 | 2021-01-10 | Adams | Ohio | 39001 | 1561 | 15 |
916209 | 916209 | 2021-01-10 | Adams | Pennsylvania | 42001 | 5341 | 112 |
917004 | 917004 | 2021-01-10 | Adams | Washington | 53001 | 1684 | 16 |
917098 | 917098 | 2021-01-10 | Adams | Wisconsin | 55001 | 1525 | 13 |
910947 | 910947 | 2021-01-09 | Adams | Colorado | 8001 | 43090 | 556 |
911260 | 911260 | 2021-01-09 | Adams | Idaho | 16003 | 287 | 3 |
911303 | 911303 | 2021-01-09 | Adams | Illinois | 17001 | 7045 | 97 |
911405 | 911405 | 2021-01-09 | Adams | Indiana | 18001 | 2830 | 36 |
911498 | 911498 | 2021-01-09 | Adams | Iowa | 19003 | 288 | 3 |
912117 | 912117 | 2021-01-09 | Adams | Mississippi | 28001 | 1924 | 64 |
912372 | 912372 | 2021-01-09 | Adams | Nebraska | 31001 | 2405 | 36 |
912706 | 912706 | 2021-01-09 | Adams | North Dakota | 38001 | 203 | 2 |
912762 | 912762 | 2021-01-09 | Adams | Ohio | 39001 | 1552 | 15 |
912964 | 912964 | 2021-01-09 | Adams | Pennsylvania | 42001 | 5230 | 111 |
913759 | 913759 | 2021-01-09 | Adams | Washington | 53001 | 1684 | 16 |
913853 | 913853 | 2021-01-09 | Adams | Wisconsin | 55001 | 1521 | 13 |
907702 | 907702 | 2021-01-08 | Adams | Colorado | 8001 | 42493 | 547 |
908015 | 908015 | 2021-01-08 | Adams | Idaho | 16003 | 284 | 3 |
908058 | 908058 | 2021-01-08 | Adams | Illinois | 17001 | 7011 | 96 |
908160 | 908160 | 2021-01-08 | Adams | Indiana | 18001 | 2803 | 36 |
908253 | 908253 | 2021-01-08 | Adams | Iowa | 19003 | 285 | 3 |
908872 | 908872 | 2021-01-08 | Adams | Mississippi | 28001 | 1892 | 64 |
909127 | 909127 | 2021-01-08 | Adams | Nebraska | 31001 | 2396 | 36 |
909461 | 909461 | 2021-01-08 | Adams | North Dakota | 38001 | 198 | 2 |
909517 | 909517 | 2021-01-08 | Adams | Ohio | 39001 | 1531 | 15 |
909719 | 909719 | 2021-01-08 | Adams | Pennsylvania | 42001 | 5145 | 108 |
910514 | 910514 | 2021-01-08 | Adams | Washington | 53001 | 1675 | 16 |
910608 | 910608 | 2021-01-08 | Adams | Wisconsin | 55001 | 1515 | 13 |
904456 | 904456 | 2021-01-07 | Adams | Colorado | 8001 | 42493 | 547 |
904769 | 904769 | 2021-01-07 | Adams | Idaho | 16003 | 283 | 3 |
904812 | 904812 | 2021-01-07 | Adams | Illinois | 17001 | 6960 | 94 |
904914 | 904914 | 2021-01-07 | Adams | Indiana | 18001 | 2774 | 35 |
905007 | 905007 | 2021-01-07 | Adams | Iowa | 19003 | 281 | 3 |
905626 | 905626 | 2021-01-07 | Adams | Mississippi | 28001 | 1876 | 64 |
905881 | 905881 | 2021-01-07 | Adams | Nebraska | 31001 | 2389 | 36 |
906216 | 906216 | 2021-01-07 | Adams | North Dakota | 38001 | 195 | 2 |
906272 | 906272 | 2021-01-07 | Adams | Ohio | 39001 | 1502 | 14 |
906474 | 906474 | 2021-01-07 | Adams | Pennsylvania | 42001 | 5059 | 108 |
907269 | 907269 | 2021-01-07 | Adams | Washington | 53001 | 1669 | 16 |
907363 | 907363 | 2021-01-07 | Adams | Wisconsin | 55001 | 1498 | 13 |
901211 | 901211 | 2021-01-06 | Adams | Colorado | 8001 | 42170 | 543 |
901524 | 901524 | 2021-01-06 | Adams | Idaho | 16003 | 282 | 3 |
901567 | 901567 | 2021-01-06 | Adams | Illinois | 17001 | 6925 | 86 |
901669 | 901669 | 2021-01-06 | Adams | Indiana | 18001 | 2744 | 35 |
901762 | 901762 | 2021-01-06 | Adams | Iowa | 19003 | 275 | 3 |
902381 | 902381 | 2021-01-06 | Adams | Mississippi | 28001 | 1868 | 63 |
902636 | 902636 | 2021-01-06 | Adams | Nebraska | 31001 | 2362 | 36 |
902970 | 902970 | 2021-01-06 | Adams | North Dakota | 38001 | 193 | 2 |
903026 | 903026 | 2021-01-06 | Adams | Ohio | 39001 | 1466 | 14 |
903228 | 903228 | 2021-01-06 | Adams | Pennsylvania | 42001 | 4973 | 101 |
904023 | 904023 | 2021-01-06 | Adams | Washington | 53001 | 1656 | 16 |
904117 | 904117 | 2021-01-06 | Adams | Wisconsin | 55001 | 1489 | 13 |
897966 | 897966 | 2021-01-05 | Adams | Colorado | 8001 | 41785 | 537 |
898279 | 898279 | 2021-01-05 | Adams | Idaho | 16003 | 277 | 3 |
898322 | 898322 | 2021-01-05 | Adams | Illinois | 17001 | 6942 | 84 |
898424 | 898424 | 2021-01-05 | Adams | Indiana | 18001 | 2714 | 35 |
898517 | 898517 | 2021-01-05 | Adams | Iowa | 19003 | 272 | 2 |
899136 | 899136 | 2021-01-05 | Adams | Mississippi | 28001 | 1846 | 62 |
899391 | 899391 | 2021-01-05 | Adams | Nebraska | 31001 | 2341 | 36 |
899725 | 899725 | 2021-01-05 | Adams | North Dakota | 38001 | 192 | 2 |
899781 | 899781 | 2021-01-05 | Adams | Ohio | 39001 | 1446 | 14 |
899983 | 899983 | 2021-01-05 | Adams | Pennsylvania | 42001 | 4865 | 95 |
900778 | 900778 | 2021-01-05 | Adams | Washington | 53001 | 1647 | 16 |
900872 | 900872 | 2021-01-05 | Adams | Wisconsin | 55001 | 1461 | 13 |
894721 | 894721 | 2021-01-04 | Adams | Colorado | 8001 | 41506 | 536 |
895034 | 895034 | 2021-01-04 | Adams | Idaho | 16003 | 275 | 3 |
895077 | 895077 | 2021-01-04 | Adams | Illinois | 17001 | 6763 | 83 |
895179 | 895179 | 2021-01-04 | Adams | Indiana | 18001 | 2690 | 35 |
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]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);