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 304
- Colorado 302
- Nebraska 297
- Pennsylvania 297
- Mississippi 295
- Illinois 294
- Washington 292
- Idaho 283
- Wisconsin 282
- Ohio 280
- Iowa 237
- North Dakota 165
fips 12
county 1
- Adams · 3,328 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
895272 | 895272 | 2021-01-04 | Adams | Iowa | 19003 | 272 | 2 |
895891 | 895891 | 2021-01-04 | Adams | Mississippi | 28001 | 1830 | 60 |
896146 | 896146 | 2021-01-04 | Adams | Nebraska | 31001 | 2318 | 36 |
896480 | 896480 | 2021-01-04 | Adams | North Dakota | 38001 | 192 | 2 |
896536 | 896536 | 2021-01-04 | Adams | Ohio | 39001 | 1423 | 14 |
896738 | 896738 | 2021-01-04 | Adams | Pennsylvania | 42001 | 4786 | 92 |
897533 | 897533 | 2021-01-04 | Adams | Washington | 53001 | 1643 | 16 |
897627 | 897627 | 2021-01-04 | Adams | Wisconsin | 55001 | 1452 | 13 |
891474 | 891474 | 2021-01-03 | Adams | Colorado | 8001 | 41102 | 535 |
891787 | 891787 | 2021-01-03 | Adams | Idaho | 16003 | 267 | 3 |
891830 | 891830 | 2021-01-03 | Adams | Illinois | 17001 | 6616 | 83 |
891932 | 891932 | 2021-01-03 | Adams | Indiana | 18001 | 2659 | 35 |
892025 | 892025 | 2021-01-03 | Adams | Iowa | 19003 | 271 | 2 |
892644 | 892644 | 2021-01-03 | Adams | Mississippi | 28001 | 1821 | 60 |
892899 | 892899 | 2021-01-03 | Adams | Nebraska | 31001 | 2306 | 36 |
893234 | 893234 | 2021-01-03 | Adams | North Dakota | 38001 | 190 | 2 |
893290 | 893290 | 2021-01-03 | Adams | Ohio | 39001 | 1410 | 14 |
893492 | 893492 | 2021-01-03 | Adams | Pennsylvania | 42001 | 4768 | 91 |
894287 | 894287 | 2021-01-03 | Adams | Washington | 53001 | 1643 | 16 |
894381 | 894381 | 2021-01-03 | Adams | Wisconsin | 55001 | 1445 | 13 |
888227 | 888227 | 2021-01-02 | Adams | Colorado | 8001 | 40904 | 535 |
888540 | 888540 | 2021-01-02 | Adams | Idaho | 16003 | 265 | 3 |
888583 | 888583 | 2021-01-02 | Adams | Illinois | 17001 | 6628 | 83 |
888686 | 888686 | 2021-01-02 | Adams | Indiana | 18001 | 2657 | 35 |
888779 | 888779 | 2021-01-02 | Adams | Iowa | 19003 | 269 | 2 |
889398 | 889398 | 2021-01-02 | Adams | Mississippi | 28001 | 1812 | 58 |
889653 | 889653 | 2021-01-02 | Adams | Nebraska | 31001 | 2300 | 36 |
889988 | 889988 | 2021-01-02 | Adams | North Dakota | 38001 | 190 | 2 |
890044 | 890044 | 2021-01-02 | Adams | Ohio | 39001 | 1395 | 14 |
890246 | 890246 | 2021-01-02 | Adams | Pennsylvania | 42001 | 4701 | 90 |
891041 | 891041 | 2021-01-02 | Adams | Washington | 53001 | 1627 | 16 |
891135 | 891135 | 2021-01-02 | Adams | Wisconsin | 55001 | 1438 | 13 |
884982 | 884982 | 2021-01-01 | Adams | Colorado | 8001 | 40696 | 533 |
885295 | 885295 | 2021-01-01 | Adams | Idaho | 16003 | 261 | 3 |
885338 | 885338 | 2021-01-01 | Adams | Illinois | 17001 | 6582 | 82 |
885440 | 885440 | 2021-01-01 | Adams | Indiana | 18001 | 2646 | 35 |
885533 | 885533 | 2021-01-01 | Adams | Iowa | 19003 | 266 | 2 |
886152 | 886152 | 2021-01-01 | Adams | Mississippi | 28001 | 1807 | 58 |
886407 | 886407 | 2021-01-01 | Adams | Nebraska | 31001 | 2297 | 36 |
886741 | 886741 | 2021-01-01 | Adams | North Dakota | 38001 | 190 | 2 |
886797 | 886797 | 2021-01-01 | Adams | Ohio | 39001 | 1367 | 14 |
886999 | 886999 | 2021-01-01 | Adams | Pennsylvania | 42001 | 4649 | 90 |
887794 | 887794 | 2021-01-01 | Adams | Washington | 53001 | 1627 | 16 |
887888 | 887888 | 2021-01-01 | Adams | Wisconsin | 55001 | 1430 | 13 |
881737 | 881737 | 2020-12-31 | Adams | Colorado | 8001 | 40344 | 529 |
882050 | 882050 | 2020-12-31 | Adams | Idaho | 16003 | 261 | 3 |
882093 | 882093 | 2020-12-31 | Adams | Illinois | 17001 | 6582 | 82 |
882195 | 882195 | 2020-12-31 | Adams | Indiana | 18001 | 2616 | 34 |
882288 | 882288 | 2020-12-31 | Adams | Iowa | 19003 | 266 | 2 |
882907 | 882907 | 2020-12-31 | Adams | Mississippi | 28001 | 1801 | 58 |
883162 | 883162 | 2020-12-31 | Adams | Nebraska | 31001 | 2285 | 36 |
883496 | 883496 | 2020-12-31 | Adams | North Dakota | 38001 | 190 | 2 |
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);