ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
10,132 rows where county = "Carroll" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
614249 | 614249 | 2020-10-09 | Carroll | Ohio | 39019 | 171 | 7 |
614713 | 614713 | 2020-10-09 | Carroll | Tennessee | 47017 | 1024 | 24 |
615121 | 615121 | 2020-10-09 | Carroll | Virginia | 51035 | 523 | 25 |
609058 | 609058 | 2020-10-08 | Carroll | Arkansas | 5015 | 796 | 11 |
609352 | 609352 | 2020-10-08 | Carroll | Georgia | 13045 | 3362 | 70 |
609547 | 609547 | 2020-10-08 | Carroll | Illinois | 17015 | 259 | 6 |
609650 | 609650 | 2020-10-08 | Carroll | Indiana | 18015 | 292 | 13 |
609748 | 609748 | 2020-10-08 | Carroll | Iowa | 19027 | 859 | 5 |
609960 | 609960 | 2020-10-08 | Carroll | Kentucky | 21041 | 203 | 5 |
610148 | 610148 | 2020-10-08 | Carroll | Maryland | 24013 | 2046 | 126 |
610361 | 610361 | 2020-10-08 | Carroll | Mississippi | 28015 | 337 | 12 |
610452 | 610452 | 2020-10-08 | Carroll | Missouri | 29033 | 142 | 2 |
610720 | 610720 | 2020-10-08 | Carroll | New Hampshire | 33003 | 130 | 2 |
611008 | 611008 | 2020-10-08 | Carroll | Ohio | 39019 | 168 | 7 |
611472 | 611472 | 2020-10-08 | Carroll | Tennessee | 47017 | 1019 | 23 |
611880 | 611880 | 2020-10-08 | Carroll | Virginia | 51035 | 522 | 25 |
605815 | 605815 | 2020-10-07 | Carroll | Arkansas | 5015 | 775 | 11 |
606109 | 606109 | 2020-10-07 | Carroll | Georgia | 13045 | 3338 | 70 |
606304 | 606304 | 2020-10-07 | Carroll | Illinois | 17015 | 252 | 6 |
606407 | 606407 | 2020-10-07 | Carroll | Indiana | 18015 | 292 | 13 |
606505 | 606505 | 2020-10-07 | Carroll | Iowa | 19027 | 820 | 5 |
606718 | 606718 | 2020-10-07 | Carroll | Kentucky | 21041 | 203 | 5 |
606906 | 606906 | 2020-10-07 | Carroll | Maryland | 24013 | 2037 | 126 |
607119 | 607119 | 2020-10-07 | Carroll | Mississippi | 28015 | 336 | 12 |
607210 | 607210 | 2020-10-07 | Carroll | Missouri | 29033 | 141 | 2 |
607478 | 607478 | 2020-10-07 | Carroll | New Hampshire | 33003 | 130 | 2 |
607766 | 607766 | 2020-10-07 | Carroll | Ohio | 39019 | 164 | 7 |
608230 | 608230 | 2020-10-07 | Carroll | Tennessee | 47017 | 1004 | 23 |
608638 | 608638 | 2020-10-07 | Carroll | Virginia | 51035 | 517 | 25 |
602573 | 602573 | 2020-10-06 | Carroll | Arkansas | 5015 | 771 | 10 |
602867 | 602867 | 2020-10-06 | Carroll | Georgia | 13045 | 3321 | 70 |
603062 | 603062 | 2020-10-06 | Carroll | Illinois | 17015 | 251 | 6 |
603165 | 603165 | 2020-10-06 | Carroll | Indiana | 18015 | 289 | 13 |
603263 | 603263 | 2020-10-06 | Carroll | Iowa | 19027 | 797 | 5 |
603476 | 603476 | 2020-10-06 | Carroll | Kentucky | 21041 | 203 | 5 |
603663 | 603663 | 2020-10-06 | Carroll | Maryland | 24013 | 2025 | 126 |
603876 | 603876 | 2020-10-06 | Carroll | Mississippi | 28015 | 333 | 12 |
603967 | 603967 | 2020-10-06 | Carroll | Missouri | 29033 | 139 | 2 |
604235 | 604235 | 2020-10-06 | Carroll | New Hampshire | 33003 | 127 | 2 |
604523 | 604523 | 2020-10-06 | Carroll | Ohio | 39019 | 164 | 7 |
604987 | 604987 | 2020-10-06 | Carroll | Tennessee | 47017 | 997 | 21 |
605395 | 605395 | 2020-10-06 | Carroll | Virginia | 51035 | 516 | 24 |
599330 | 599330 | 2020-10-05 | Carroll | Arkansas | 5015 | 759 | 10 |
599624 | 599624 | 2020-10-05 | Carroll | Georgia | 13045 | 3311 | 70 |
599819 | 599819 | 2020-10-05 | Carroll | Illinois | 17015 | 245 | 6 |
599922 | 599922 | 2020-10-05 | Carroll | Indiana | 18015 | 289 | 13 |
600020 | 600020 | 2020-10-05 | Carroll | Iowa | 19027 | 775 | 5 |
600233 | 600233 | 2020-10-05 | Carroll | Kentucky | 21041 | 203 | 5 |
600421 | 600421 | 2020-10-05 | Carroll | Maryland | 24013 | 2011 | 126 |
600634 | 600634 | 2020-10-05 | Carroll | Mississippi | 28015 | 332 | 12 |
600725 | 600725 | 2020-10-05 | Carroll | Missouri | 29033 | 137 | 2 |
600993 | 600993 | 2020-10-05 | Carroll | New Hampshire | 33003 | 127 | 2 |
601281 | 601281 | 2020-10-05 | Carroll | Ohio | 39019 | 160 | 7 |
601745 | 601745 | 2020-10-05 | Carroll | Tennessee | 47017 | 992 | 21 |
602153 | 602153 | 2020-10-05 | Carroll | Virginia | 51035 | 514 | 24 |
596087 | 596087 | 2020-10-04 | Carroll | Arkansas | 5015 | 757 | 10 |
596381 | 596381 | 2020-10-04 | Carroll | Georgia | 13045 | 2874 | 70 |
596577 | 596577 | 2020-10-04 | Carroll | Illinois | 17015 | 243 | 6 |
596680 | 596680 | 2020-10-04 | Carroll | Indiana | 18015 | 288 | 13 |
596778 | 596778 | 2020-10-04 | Carroll | Iowa | 19027 | 767 | 5 |
596991 | 596991 | 2020-10-04 | Carroll | Kentucky | 21041 | 203 | 5 |
597178 | 597178 | 2020-10-04 | Carroll | Maryland | 24013 | 2006 | 126 |
597391 | 597391 | 2020-10-04 | Carroll | Mississippi | 28015 | 332 | 12 |
597482 | 597482 | 2020-10-04 | Carroll | Missouri | 29033 | 138 | 2 |
597749 | 597749 | 2020-10-04 | Carroll | New Hampshire | 33003 | 126 | 2 |
598038 | 598038 | 2020-10-04 | Carroll | Ohio | 39019 | 160 | 7 |
598502 | 598502 | 2020-10-04 | Carroll | Tennessee | 47017 | 974 | 20 |
598910 | 598910 | 2020-10-04 | Carroll | Virginia | 51035 | 511 | 24 |
592845 | 592845 | 2020-10-03 | Carroll | Arkansas | 5015 | 746 | 10 |
593139 | 593139 | 2020-10-03 | Carroll | Georgia | 13045 | 2862 | 69 |
593335 | 593335 | 2020-10-03 | Carroll | Illinois | 17015 | 242 | 6 |
593438 | 593438 | 2020-10-03 | Carroll | Indiana | 18015 | 287 | 13 |
593536 | 593536 | 2020-10-03 | Carroll | Iowa | 19027 | 745 | 5 |
593749 | 593749 | 2020-10-03 | Carroll | Kentucky | 21041 | 203 | 5 |
593937 | 593937 | 2020-10-03 | Carroll | Maryland | 24013 | 2003 | 126 |
594150 | 594150 | 2020-10-03 | Carroll | Mississippi | 28015 | 332 | 12 |
594241 | 594241 | 2020-10-03 | Carroll | Missouri | 29033 | 135 | 2 |
594507 | 594507 | 2020-10-03 | Carroll | New Hampshire | 33003 | 126 | 2 |
594795 | 594795 | 2020-10-03 | Carroll | Ohio | 39019 | 160 | 7 |
595259 | 595259 | 2020-10-03 | Carroll | Tennessee | 47017 | 962 | 20 |
595667 | 595667 | 2020-10-03 | Carroll | Virginia | 51035 | 510 | 24 |
589605 | 589605 | 2020-10-02 | Carroll | Arkansas | 5015 | 742 | 10 |
589899 | 589899 | 2020-10-02 | Carroll | Georgia | 13045 | 2840 | 69 |
590094 | 590094 | 2020-10-02 | Carroll | Illinois | 17015 | 243 | 6 |
590197 | 590197 | 2020-10-02 | Carroll | Indiana | 18015 | 286 | 13 |
590295 | 590295 | 2020-10-02 | Carroll | Iowa | 19027 | 739 | 5 |
590508 | 590508 | 2020-10-02 | Carroll | Kentucky | 21041 | 202 | 5 |
590696 | 590696 | 2020-10-02 | Carroll | Maryland | 24013 | 1990 | 126 |
590909 | 590909 | 2020-10-02 | Carroll | Mississippi | 28015 | 332 | 12 |
591000 | 591000 | 2020-10-02 | Carroll | Missouri | 29033 | 135 | 2 |
591266 | 591266 | 2020-10-02 | Carroll | New Hampshire | 33003 | 127 | 2 |
591554 | 591554 | 2020-10-02 | Carroll | Ohio | 39019 | 156 | 7 |
592018 | 592018 | 2020-10-02 | Carroll | Tennessee | 47017 | 941 | 20 |
592425 | 592425 | 2020-10-02 | Carroll | Virginia | 51035 | 507 | 24 |
586364 | 586364 | 2020-10-01 | Carroll | Arkansas | 5015 | 725 | 10 |
586658 | 586658 | 2020-10-01 | Carroll | Georgia | 13045 | 2819 | 68 |
586853 | 586853 | 2020-10-01 | Carroll | Illinois | 17015 | 242 | 6 |
586956 | 586956 | 2020-10-01 | Carroll | Indiana | 18015 | 285 | 13 |
587054 | 587054 | 2020-10-01 | Carroll | Iowa | 19027 | 715 | 5 |
587267 | 587267 | 2020-10-01 | Carroll | Kentucky | 21041 | 202 | 5 |
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);