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 |
---|---|---|---|---|---|---|---|
299815 | 299815 | 2020-07-04 | Carroll | Arkansas | 5015 | 187 | 5 |
300105 | 300105 | 2020-07-04 | Carroll | Georgia | 13045 | 813 | 40 |
300297 | 300297 | 2020-07-04 | Carroll | Illinois | 17015 | 22 | 2 |
300400 | 300400 | 2020-07-04 | Carroll | Indiana | 18015 | 110 | 2 |
300498 | 300498 | 2020-07-04 | Carroll | Iowa | 19027 | 96 | 1 |
300701 | 300701 | 2020-07-04 | Carroll | Kentucky | 21041 | 42 | 1 |
300889 | 300889 | 2020-07-04 | Carroll | Maryland | 24013 | 1158 | 114 |
301101 | 301101 | 2020-07-04 | Carroll | Mississippi | 28015 | 164 | 11 |
301192 | 301192 | 2020-07-04 | Carroll | Missouri | 29033 | 16 | 0 |
301428 | 301428 | 2020-07-04 | Carroll | New Hampshire | 33003 | 61 | 0 |
301709 | 301709 | 2020-07-04 | Carroll | Ohio | 39019 | 58 | 3 |
302165 | 302165 | 2020-07-04 | Carroll | Tennessee | 47017 | 48 | 1 |
302564 | 302564 | 2020-07-04 | Carroll | Virginia | 51035 | 227 | 9 |
296653 | 296653 | 2020-07-03 | Carroll | Arkansas | 5015 | 187 | 5 |
296943 | 296943 | 2020-07-03 | Carroll | Georgia | 13045 | 770 | 40 |
297135 | 297135 | 2020-07-03 | Carroll | Illinois | 17015 | 22 | 2 |
297238 | 297238 | 2020-07-03 | Carroll | Indiana | 18015 | 110 | 2 |
297336 | 297336 | 2020-07-03 | Carroll | Iowa | 19027 | 93 | 1 |
297539 | 297539 | 2020-07-03 | Carroll | Kentucky | 21041 | 42 | 1 |
297727 | 297727 | 2020-07-03 | Carroll | Maryland | 24013 | 1157 | 112 |
297938 | 297938 | 2020-07-03 | Carroll | Mississippi | 28015 | 164 | 11 |
298029 | 298029 | 2020-07-03 | Carroll | Missouri | 29033 | 14 | 0 |
298265 | 298265 | 2020-07-03 | Carroll | New Hampshire | 33003 | 61 | 0 |
298546 | 298546 | 2020-07-03 | Carroll | Ohio | 39019 | 58 | 3 |
299001 | 299001 | 2020-07-03 | Carroll | Tennessee | 47017 | 44 | 1 |
299400 | 299400 | 2020-07-03 | Carroll | Virginia | 51035 | 225 | 9 |
293497 | 293497 | 2020-07-02 | Carroll | Arkansas | 5015 | 172 | 5 |
293787 | 293787 | 2020-07-02 | Carroll | Georgia | 13045 | 741 | 40 |
293978 | 293978 | 2020-07-02 | Carroll | Illinois | 17015 | 21 | 2 |
294080 | 294080 | 2020-07-02 | Carroll | Indiana | 18015 | 109 | 2 |
294178 | 294178 | 2020-07-02 | Carroll | Iowa | 19027 | 91 | 1 |
294381 | 294381 | 2020-07-02 | Carroll | Kentucky | 21041 | 37 | 1 |
294569 | 294569 | 2020-07-02 | Carroll | Maryland | 24013 | 1151 | 112 |
294780 | 294780 | 2020-07-02 | Carroll | Mississippi | 28015 | 161 | 11 |
294871 | 294871 | 2020-07-02 | Carroll | Missouri | 29033 | 12 | 0 |
295105 | 295105 | 2020-07-02 | Carroll | New Hampshire | 33003 | 61 | 0 |
295386 | 295386 | 2020-07-02 | Carroll | Ohio | 39019 | 51 | 3 |
295841 | 295841 | 2020-07-02 | Carroll | Tennessee | 47017 | 40 | 1 |
296238 | 296238 | 2020-07-02 | Carroll | Virginia | 51035 | 224 | 8 |
290343 | 290343 | 2020-07-01 | Carroll | Arkansas | 5015 | 168 | 5 |
290633 | 290633 | 2020-07-01 | Carroll | Georgia | 13045 | 730 | 39 |
290824 | 290824 | 2020-07-01 | Carroll | Illinois | 17015 | 21 | 2 |
290926 | 290926 | 2020-07-01 | Carroll | Indiana | 18015 | 109 | 2 |
291024 | 291024 | 2020-07-01 | Carroll | Iowa | 19027 | 87 | 1 |
291227 | 291227 | 2020-07-01 | Carroll | Kentucky | 21041 | 37 | 0 |
291415 | 291415 | 2020-07-01 | Carroll | Maryland | 24013 | 1138 | 112 |
291626 | 291626 | 2020-07-01 | Carroll | Mississippi | 28015 | 160 | 11 |
291717 | 291717 | 2020-07-01 | Carroll | Missouri | 29033 | 12 | 0 |
291950 | 291950 | 2020-07-01 | Carroll | New Hampshire | 33003 | 54 | 0 |
292231 | 292231 | 2020-07-01 | Carroll | Ohio | 39019 | 51 | 3 |
292685 | 292685 | 2020-07-01 | Carroll | Tennessee | 47017 | 39 | 1 |
293083 | 293083 | 2020-07-01 | Carroll | Virginia | 51035 | 221 | 8 |
287192 | 287192 | 2020-06-30 | Carroll | Arkansas | 5015 | 168 | 5 |
287482 | 287482 | 2020-06-30 | Carroll | Georgia | 13045 | 704 | 39 |
287674 | 287674 | 2020-06-30 | Carroll | Illinois | 17015 | 21 | 2 |
287776 | 287776 | 2020-06-30 | Carroll | Indiana | 18015 | 108 | 2 |
287874 | 287874 | 2020-06-30 | Carroll | Iowa | 19027 | 83 | 1 |
288077 | 288077 | 2020-06-30 | Carroll | Kentucky | 21041 | 37 | 0 |
288264 | 288264 | 2020-06-30 | Carroll | Maryland | 24013 | 1119 | 112 |
288475 | 288475 | 2020-06-30 | Carroll | Mississippi | 28015 | 157 | 11 |
288566 | 288566 | 2020-06-30 | Carroll | Missouri | 29033 | 11 | 0 |
288798 | 288798 | 2020-06-30 | Carroll | New Hampshire | 33003 | 54 | 0 |
289079 | 289079 | 2020-06-30 | Carroll | Ohio | 39019 | 51 | 3 |
289533 | 289533 | 2020-06-30 | Carroll | Tennessee | 47017 | 39 | 1 |
289930 | 289930 | 2020-06-30 | Carroll | Virginia | 51035 | 214 | 8 |
284046 | 284046 | 2020-06-29 | Carroll | Arkansas | 5015 | 169 | 5 |
284336 | 284336 | 2020-06-29 | Carroll | Georgia | 13045 | 678 | 39 |
284525 | 284525 | 2020-06-29 | Carroll | Illinois | 17015 | 21 | 2 |
284627 | 284627 | 2020-06-29 | Carroll | Indiana | 18015 | 107 | 2 |
284725 | 284725 | 2020-06-29 | Carroll | Iowa | 19027 | 82 | 1 |
284928 | 284928 | 2020-06-29 | Carroll | Kentucky | 21041 | 37 | 0 |
285114 | 285114 | 2020-06-29 | Carroll | Maryland | 24013 | 1116 | 112 |
285325 | 285325 | 2020-06-29 | Carroll | Mississippi | 28015 | 149 | 11 |
285416 | 285416 | 2020-06-29 | Carroll | Missouri | 29033 | 11 | 0 |
285648 | 285648 | 2020-06-29 | Carroll | New Hampshire | 33003 | 54 | 0 |
285929 | 285929 | 2020-06-29 | Carroll | Ohio | 39019 | 50 | 3 |
286382 | 286382 | 2020-06-29 | Carroll | Tennessee | 47017 | 39 | 1 |
286780 | 286780 | 2020-06-29 | Carroll | Virginia | 51035 | 209 | 8 |
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 |
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);