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 181
- Colorado 179
- Nebraska 174
- Pennsylvania 174
- Mississippi 172
- Illinois 171
- Washington 169
- Idaho 160
- Wisconsin 159
- Ohio 157
- Iowa 114
- North Dakota 42
fips 12
county 1
- Adams · 1,852 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
509335 | 509335 | 2020-09-07 | Adams | Iowa | 19003 | 23 | 0 |
509953 | 509953 | 2020-09-07 | Adams | Mississippi | 28001 | 828 | 32 |
510206 | 510206 | 2020-09-07 | Adams | Nebraska | 31001 | 430 | 11 |
510535 | 510535 | 2020-09-07 | Adams | North Dakota | 38001 | 9 | 0 |
510592 | 510592 | 2020-09-07 | Adams | Ohio | 39001 | 96 | 4 |
510793 | 510793 | 2020-09-07 | Adams | Pennsylvania | 42001 | 711 | 24 |
511584 | 511584 | 2020-09-07 | Adams | Washington | 53001 | 704 | 8 |
511679 | 511679 | 2020-09-07 | Adams | Wisconsin | 55001 | 160 | 3 |
505553 | 505553 | 2020-09-06 | Adams | Colorado | 8001 | 7860 | 208 |
505864 | 505864 | 2020-09-06 | Adams | Idaho | 16003 | 25 | 1 |
505907 | 505907 | 2020-09-06 | Adams | Illinois | 17001 | 817 | 10 |
506010 | 506010 | 2020-09-06 | Adams | Indiana | 18001 | 196 | 4 |
506103 | 506103 | 2020-09-06 | Adams | Iowa | 19003 | 23 | 0 |
506720 | 506720 | 2020-09-06 | Adams | Mississippi | 28001 | 823 | 32 |
506973 | 506973 | 2020-09-06 | Adams | Nebraska | 31001 | 430 | 11 |
507302 | 507302 | 2020-09-06 | Adams | North Dakota | 38001 | 9 | 0 |
507359 | 507359 | 2020-09-06 | Adams | Ohio | 39001 | 96 | 4 |
507560 | 507560 | 2020-09-06 | Adams | Pennsylvania | 42001 | 708 | 23 |
508351 | 508351 | 2020-09-06 | Adams | Washington | 53001 | 704 | 8 |
508446 | 508446 | 2020-09-06 | Adams | Wisconsin | 55001 | 157 | 3 |
502319 | 502319 | 2020-09-05 | Adams | Colorado | 8001 | 7834 | 208 |
502630 | 502630 | 2020-09-05 | Adams | Idaho | 16003 | 25 | 1 |
502673 | 502673 | 2020-09-05 | Adams | Illinois | 17001 | 812 | 10 |
502776 | 502776 | 2020-09-05 | Adams | Indiana | 18001 | 195 | 4 |
502869 | 502869 | 2020-09-05 | Adams | Iowa | 19003 | 23 | 0 |
503487 | 503487 | 2020-09-05 | Adams | Mississippi | 28001 | 820 | 32 |
503740 | 503740 | 2020-09-05 | Adams | Nebraska | 31001 | 429 | 11 |
504070 | 504070 | 2020-09-05 | Adams | North Dakota | 38001 | 7 | 0 |
504127 | 504127 | 2020-09-05 | Adams | Ohio | 39001 | 95 | 4 |
504328 | 504328 | 2020-09-05 | Adams | Pennsylvania | 42001 | 706 | 23 |
505119 | 505119 | 2020-09-05 | Adams | Washington | 53001 | 671 | 8 |
505214 | 505214 | 2020-09-05 | Adams | Wisconsin | 55001 | 150 | 3 |
499085 | 499085 | 2020-09-04 | Adams | Colorado | 8001 | 7778 | 206 |
499396 | 499396 | 2020-09-04 | Adams | Idaho | 16003 | 25 | 1 |
499439 | 499439 | 2020-09-04 | Adams | Illinois | 17001 | 805 | 9 |
499542 | 499542 | 2020-09-04 | Adams | Indiana | 18001 | 193 | 4 |
499635 | 499635 | 2020-09-04 | Adams | Iowa | 19003 | 23 | 0 |
500253 | 500253 | 2020-09-04 | Adams | Mississippi | 28001 | 809 | 32 |
500506 | 500506 | 2020-09-04 | Adams | Nebraska | 31001 | 429 | 11 |
500836 | 500836 | 2020-09-04 | Adams | North Dakota | 38001 | 6 | 0 |
500893 | 500893 | 2020-09-04 | Adams | Ohio | 39001 | 95 | 4 |
501094 | 501094 | 2020-09-04 | Adams | Pennsylvania | 42001 | 697 | 23 |
501885 | 501885 | 2020-09-04 | Adams | Washington | 53001 | 671 | 8 |
501980 | 501980 | 2020-09-04 | Adams | Wisconsin | 55001 | 145 | 3 |
495852 | 495852 | 2020-09-03 | Adams | Colorado | 8001 | 7731 | 200 |
496163 | 496163 | 2020-09-03 | Adams | Idaho | 16003 | 25 | 0 |
496206 | 496206 | 2020-09-03 | Adams | Illinois | 17001 | 795 | 9 |
496309 | 496309 | 2020-09-03 | Adams | Indiana | 18001 | 193 | 3 |
496402 | 496402 | 2020-09-03 | Adams | Iowa | 19003 | 23 | 0 |
497019 | 497019 | 2020-09-03 | Adams | Mississippi | 28001 | 800 | 32 |
497272 | 497272 | 2020-09-03 | Adams | Nebraska | 31001 | 428 | 11 |
497602 | 497602 | 2020-09-03 | Adams | North Dakota | 38001 | 5 | 0 |
497659 | 497659 | 2020-09-03 | Adams | Ohio | 39001 | 95 | 4 |
497860 | 497860 | 2020-09-03 | Adams | Pennsylvania | 42001 | 686 | 23 |
498651 | 498651 | 2020-09-03 | Adams | Washington | 53001 | 664 | 8 |
498746 | 498746 | 2020-09-03 | Adams | Wisconsin | 55001 | 134 | 3 |
492618 | 492618 | 2020-09-02 | Adams | Colorado | 8001 | 7689 | 198 |
492929 | 492929 | 2020-09-02 | Adams | Idaho | 16003 | 25 | 0 |
492972 | 492972 | 2020-09-02 | Adams | Illinois | 17001 | 786 | 9 |
493075 | 493075 | 2020-09-02 | Adams | Indiana | 18001 | 191 | 3 |
493168 | 493168 | 2020-09-02 | Adams | Iowa | 19003 | 22 | 0 |
493786 | 493786 | 2020-09-02 | Adams | Mississippi | 28001 | 797 | 32 |
494039 | 494039 | 2020-09-02 | Adams | Nebraska | 31001 | 419 | 11 |
494369 | 494369 | 2020-09-02 | Adams | North Dakota | 38001 | 4 | 0 |
494426 | 494426 | 2020-09-02 | Adams | Ohio | 39001 | 94 | 4 |
494627 | 494627 | 2020-09-02 | Adams | Pennsylvania | 42001 | 680 | 23 |
495418 | 495418 | 2020-09-02 | Adams | Washington | 53001 | 641 | 8 |
495513 | 495513 | 2020-09-02 | Adams | Wisconsin | 55001 | 121 | 3 |
489385 | 489385 | 2020-09-01 | Adams | Colorado | 8001 | 7647 | 197 |
489696 | 489696 | 2020-09-01 | Adams | Idaho | 16003 | 25 | 0 |
489739 | 489739 | 2020-09-01 | Adams | Illinois | 17001 | 786 | 9 |
489842 | 489842 | 2020-09-01 | Adams | Indiana | 18001 | 191 | 3 |
489935 | 489935 | 2020-09-01 | Adams | Iowa | 19003 | 22 | 0 |
490552 | 490552 | 2020-09-01 | Adams | Mississippi | 28001 | 791 | 32 |
490805 | 490805 | 2020-09-01 | Adams | Nebraska | 31001 | 416 | 11 |
491135 | 491135 | 2020-09-01 | Adams | North Dakota | 38001 | 4 | 0 |
491192 | 491192 | 2020-09-01 | Adams | Ohio | 39001 | 93 | 4 |
491393 | 491393 | 2020-09-01 | Adams | Pennsylvania | 42001 | 648 | 23 |
492184 | 492184 | 2020-09-01 | Adams | Washington | 53001 | 635 | 7 |
492279 | 492279 | 2020-09-01 | Adams | Wisconsin | 55001 | 121 | 3 |
486152 | 486152 | 2020-08-31 | Adams | Colorado | 8001 | 7579 | 197 |
486463 | 486463 | 2020-08-31 | Adams | Idaho | 16003 | 25 | 0 |
486506 | 486506 | 2020-08-31 | Adams | Illinois | 17001 | 771 | 7 |
486609 | 486609 | 2020-08-31 | Adams | Indiana | 18001 | 188 | 3 |
486702 | 486702 | 2020-08-31 | Adams | Iowa | 19003 | 22 | 0 |
487319 | 487319 | 2020-08-31 | Adams | Mississippi | 28001 | 791 | 32 |
487572 | 487572 | 2020-08-31 | Adams | Nebraska | 31001 | 410 | 11 |
487902 | 487902 | 2020-08-31 | Adams | North Dakota | 38001 | 4 | 0 |
487959 | 487959 | 2020-08-31 | Adams | Ohio | 39001 | 93 | 4 |
488160 | 488160 | 2020-08-31 | Adams | Pennsylvania | 42001 | 642 | 23 |
488951 | 488951 | 2020-08-31 | Adams | Washington | 53001 | 634 | 7 |
489046 | 489046 | 2020-08-31 | Adams | Wisconsin | 55001 | 116 | 3 |
482917 | 482917 | 2020-08-30 | Adams | Colorado | 8001 | 7541 | 197 |
483228 | 483228 | 2020-08-30 | Adams | Idaho | 16003 | 25 | 0 |
483271 | 483271 | 2020-08-30 | Adams | Illinois | 17001 | 769 | 7 |
483374 | 483374 | 2020-08-30 | Adams | Indiana | 18001 | 185 | 3 |
483467 | 483467 | 2020-08-30 | Adams | Iowa | 19003 | 22 | 0 |
484085 | 484085 | 2020-08-30 | Adams | Mississippi | 28001 | 790 | 31 |
484338 | 484338 | 2020-08-30 | Adams | Nebraska | 31001 | 403 | 11 |
484669 | 484669 | 2020-08-30 | Adams | North Dakota | 38001 | 4 | 0 |
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);