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 |
---|---|---|---|---|---|---|---|
280900 | 280900 | 2020-06-28 | Carroll | Arkansas | 5015 | 166 | 5 |
281190 | 281190 | 2020-06-28 | Carroll | Georgia | 13045 | 673 | 39 |
281380 | 281380 | 2020-06-28 | Carroll | Illinois | 17015 | 21 | 2 |
281482 | 281482 | 2020-06-28 | Carroll | Indiana | 18015 | 107 | 2 |
281580 | 281580 | 2020-06-28 | Carroll | Iowa | 19027 | 79 | 1 |
281782 | 281782 | 2020-06-28 | Carroll | Kentucky | 21041 | 37 | 0 |
281969 | 281969 | 2020-06-28 | Carroll | Maryland | 24013 | 1107 | 111 |
282180 | 282180 | 2020-06-28 | Carroll | Mississippi | 28015 | 147 | 11 |
282271 | 282271 | 2020-06-28 | Carroll | Missouri | 29033 | 11 | 0 |
282503 | 282503 | 2020-06-28 | Carroll | New Hampshire | 33003 | 54 | 0 |
282784 | 282784 | 2020-06-28 | Carroll | Ohio | 39019 | 48 | 3 |
283237 | 283237 | 2020-06-28 | Carroll | Tennessee | 47017 | 38 | 1 |
283634 | 283634 | 2020-06-28 | Carroll | Virginia | 51035 | 206 | 8 |
277753 | 277753 | 2020-06-27 | Carroll | Arkansas | 5015 | 161 | 5 |
278043 | 278043 | 2020-06-27 | Carroll | Georgia | 13045 | 669 | 39 |
278232 | 278232 | 2020-06-27 | Carroll | Illinois | 17015 | 21 | 2 |
278334 | 278334 | 2020-06-27 | Carroll | Indiana | 18015 | 107 | 2 |
278432 | 278432 | 2020-06-27 | Carroll | Iowa | 19027 | 76 | 1 |
278634 | 278634 | 2020-06-27 | Carroll | Kentucky | 21041 | 37 | 0 |
278821 | 278821 | 2020-06-27 | Carroll | Maryland | 24013 | 1106 | 110 |
279032 | 279032 | 2020-06-27 | Carroll | Mississippi | 28015 | 147 | 11 |
279123 | 279123 | 2020-06-27 | Carroll | Missouri | 29033 | 11 | 0 |
279356 | 279356 | 2020-06-27 | Carroll | New Hampshire | 33003 | 53 | 0 |
279638 | 279638 | 2020-06-27 | Carroll | Ohio | 39019 | 47 | 3 |
280091 | 280091 | 2020-06-27 | Carroll | Tennessee | 47017 | 38 | 1 |
280488 | 280488 | 2020-06-27 | Carroll | Virginia | 51035 | 203 | 8 |
274605 | 274605 | 2020-06-26 | Carroll | Arkansas | 5015 | 158 | 4 |
274895 | 274895 | 2020-06-26 | Carroll | Georgia | 13045 | 658 | 39 |
275084 | 275084 | 2020-06-26 | Carroll | Illinois | 17015 | 21 | 2 |
275186 | 275186 | 2020-06-26 | Carroll | Indiana | 18015 | 109 | 2 |
275284 | 275284 | 2020-06-26 | Carroll | Iowa | 19027 | 73 | 1 |
275486 | 275486 | 2020-06-26 | Carroll | Kentucky | 21041 | 35 | 0 |
275673 | 275673 | 2020-06-26 | Carroll | Maryland | 24013 | 1106 | 110 |
275884 | 275884 | 2020-06-26 | Carroll | Mississippi | 28015 | 145 | 11 |
275975 | 275975 | 2020-06-26 | Carroll | Missouri | 29033 | 11 | 0 |
276208 | 276208 | 2020-06-26 | Carroll | New Hampshire | 33003 | 53 | 0 |
276490 | 276490 | 2020-06-26 | Carroll | Ohio | 39019 | 46 | 3 |
276943 | 276943 | 2020-06-26 | Carroll | Tennessee | 47017 | 36 | 1 |
277340 | 277340 | 2020-06-26 | Carroll | Virginia | 51035 | 198 | 6 |
271465 | 271465 | 2020-06-25 | Carroll | Arkansas | 5015 | 149 | 4 |
271755 | 271755 | 2020-06-25 | Carroll | Georgia | 13045 | 651 | 39 |
271942 | 271942 | 2020-06-25 | Carroll | Illinois | 17015 | 21 | 2 |
272044 | 272044 | 2020-06-25 | Carroll | Indiana | 18015 | 104 | 2 |
272142 | 272142 | 2020-06-25 | Carroll | Iowa | 19027 | 73 | 1 |
272343 | 272343 | 2020-06-25 | Carroll | Kentucky | 21041 | 30 | 0 |
272530 | 272530 | 2020-06-25 | Carroll | Maryland | 24013 | 1103 | 109 |
272741 | 272741 | 2020-06-25 | Carroll | Mississippi | 28015 | 141 | 11 |
272832 | 272832 | 2020-06-25 | Carroll | Missouri | 29033 | 11 | 0 |
273063 | 273063 | 2020-06-25 | Carroll | New Hampshire | 33003 | 53 | 0 |
273343 | 273343 | 2020-06-25 | Carroll | Ohio | 39019 | 46 | 3 |
273796 | 273796 | 2020-06-25 | Carroll | Tennessee | 47017 | 36 | 1 |
274192 | 274192 | 2020-06-25 | Carroll | Virginia | 51035 | 200 | 6 |
268330 | 268330 | 2020-06-24 | Carroll | Arkansas | 5015 | 141 | 4 |
268619 | 268619 | 2020-06-24 | Carroll | Georgia | 13045 | 650 | 39 |
268805 | 268805 | 2020-06-24 | Carroll | Illinois | 17015 | 21 | 2 |
268907 | 268907 | 2020-06-24 | Carroll | Indiana | 18015 | 103 | 2 |
269005 | 269005 | 2020-06-24 | Carroll | Iowa | 19027 | 71 | 1 |
269207 | 269207 | 2020-06-24 | Carroll | Kentucky | 21041 | 30 | 0 |
269393 | 269393 | 2020-06-24 | Carroll | Maryland | 24013 | 1084 | 109 |
269604 | 269604 | 2020-06-24 | Carroll | Mississippi | 28015 | 138 | 11 |
269694 | 269694 | 2020-06-24 | Carroll | Missouri | 29033 | 11 | 0 |
269924 | 269924 | 2020-06-24 | Carroll | New Hampshire | 33003 | 52 | 0 |
270204 | 270204 | 2020-06-24 | Carroll | Ohio | 39019 | 43 | 3 |
270657 | 270657 | 2020-06-24 | Carroll | Tennessee | 47017 | 36 | 1 |
271052 | 271052 | 2020-06-24 | Carroll | Virginia | 51035 | 196 | 6 |
265200 | 265200 | 2020-06-23 | Carroll | Arkansas | 5015 | 136 | 4 |
265489 | 265489 | 2020-06-23 | Carroll | Georgia | 13045 | 646 | 39 |
265675 | 265675 | 2020-06-23 | Carroll | Illinois | 17015 | 19 | 2 |
265777 | 265777 | 2020-06-23 | Carroll | Indiana | 18015 | 103 | 2 |
265875 | 265875 | 2020-06-23 | Carroll | Iowa | 19027 | 69 | 1 |
266074 | 266074 | 2020-06-23 | Carroll | Kentucky | 21041 | 30 | 0 |
266260 | 266260 | 2020-06-23 | Carroll | Maryland | 24013 | 1063 | 109 |
266471 | 266471 | 2020-06-23 | Carroll | Mississippi | 28015 | 135 | 11 |
266561 | 266561 | 2020-06-23 | Carroll | Missouri | 29033 | 11 | 0 |
266789 | 266789 | 2020-06-23 | Carroll | New Hampshire | 33003 | 52 | 0 |
267070 | 267070 | 2020-06-23 | Carroll | Ohio | 39019 | 42 | 3 |
267523 | 267523 | 2020-06-23 | Carroll | Tennessee | 47017 | 36 | 1 |
267918 | 267918 | 2020-06-23 | Carroll | Virginia | 51035 | 193 | 5 |
262072 | 262072 | 2020-06-22 | Carroll | Arkansas | 5015 | 136 | 4 |
262361 | 262361 | 2020-06-22 | Carroll | Georgia | 13045 | 635 | 39 |
262547 | 262547 | 2020-06-22 | Carroll | Illinois | 17015 | 19 | 2 |
262649 | 262649 | 2020-06-22 | Carroll | Indiana | 18015 | 103 | 2 |
262747 | 262747 | 2020-06-22 | Carroll | Iowa | 19027 | 69 | 1 |
262947 | 262947 | 2020-06-22 | Carroll | Kentucky | 21041 | 29 | 0 |
263134 | 263134 | 2020-06-22 | Carroll | Maryland | 24013 | 1033 | 109 |
263345 | 263345 | 2020-06-22 | Carroll | Mississippi | 28015 | 133 | 11 |
263435 | 263435 | 2020-06-22 | Carroll | Missouri | 29033 | 11 | 0 |
263662 | 263662 | 2020-06-22 | Carroll | New Hampshire | 33003 | 52 | 0 |
263942 | 263942 | 2020-06-22 | Carroll | Ohio | 39019 | 42 | 3 |
264395 | 264395 | 2020-06-22 | Carroll | Tennessee | 47017 | 36 | 1 |
264789 | 264789 | 2020-06-22 | Carroll | Virginia | 51035 | 189 | 5 |
258945 | 258945 | 2020-06-21 | Carroll | Arkansas | 5015 | 129 | 4 |
259234 | 259234 | 2020-06-21 | Carroll | Georgia | 13045 | 625 | 39 |
259420 | 259420 | 2020-06-21 | Carroll | Illinois | 17015 | 19 | 2 |
259522 | 259522 | 2020-06-21 | Carroll | Indiana | 18015 | 103 | 2 |
259620 | 259620 | 2020-06-21 | Carroll | Iowa | 19027 | 70 | 1 |
259818 | 259818 | 2020-06-21 | Carroll | Kentucky | 21041 | 29 | 0 |
260005 | 260005 | 2020-06-21 | Carroll | Maryland | 24013 | 1032 | 109 |
260216 | 260216 | 2020-06-21 | Carroll | Mississippi | 28015 | 122 | 11 |
260307 | 260307 | 2020-06-21 | Carroll | Missouri | 29033 | 11 | 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);