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 |
---|---|---|---|---|---|---|---|
2451744 | 2451744 | 2022-04-28 | Carroll | Kentucky | 21041 | 3500 | 45 |
2451932 | 2451932 | 2022-04-28 | Carroll | Maryland | 24013 | 21696 | 401 |
2452145 | 2452145 | 2022-04-28 | Carroll | Mississippi | 28015 | 2558 | 53 |
2452237 | 2452237 | 2022-04-28 | Carroll | Missouri | 29033 | 2226 | 44 |
2452507 | 2452507 | 2022-04-28 | Carroll | New Hampshire | 33003 | 9586 | 61 |
2452798 | 2452798 | 2022-04-28 | Carroll | Ohio | 39019 | 5269 | 126 |
2453264 | 2453264 | 2022-04-28 | Carroll | Tennessee | 47017 | 8963 | 156 |
2453674 | 2453674 | 2022-04-28 | Carroll | Virginia | 51035 | 6689 | 147 |
2447582 | 2447582 | 2022-04-27 | Carroll | Arkansas | 5015 | 6115 | 102 |
2447876 | 2447876 | 2022-04-27 | Carroll | Georgia | 13045 | 23804 | 457 |
2448073 | 2448073 | 2022-04-27 | Carroll | Illinois | 17015 | 4268 | 49 |
2448176 | 2448176 | 2022-04-27 | Carroll | Indiana | 18015 | 4241 | 68 |
2448275 | 2448275 | 2022-04-27 | Carroll | Iowa | 19027 | 4943 | 65 |
2448488 | 2448488 | 2022-04-27 | Carroll | Kentucky | 21041 | 3500 | 45 |
2448676 | 2448676 | 2022-04-27 | Carroll | Maryland | 24013 | 21668 | 401 |
2448889 | 2448889 | 2022-04-27 | Carroll | Mississippi | 28015 | 2558 | 53 |
2448981 | 2448981 | 2022-04-27 | Carroll | Missouri | 29033 | 2226 | 44 |
2449251 | 2449251 | 2022-04-27 | Carroll | New Hampshire | 33003 | 9572 | 61 |
2449542 | 2449542 | 2022-04-27 | Carroll | Ohio | 39019 | 5260 | 126 |
2450008 | 2450008 | 2022-04-27 | Carroll | Tennessee | 47017 | 8963 | 156 |
2450418 | 2450418 | 2022-04-27 | Carroll | Virginia | 51035 | 6689 | 147 |
2444326 | 2444326 | 2022-04-26 | Carroll | Arkansas | 5015 | 6112 | 102 |
2444620 | 2444620 | 2022-04-26 | Carroll | Georgia | 13045 | 23785 | 456 |
2444817 | 2444817 | 2022-04-26 | Carroll | Illinois | 17015 | 4263 | 49 |
2444920 | 2444920 | 2022-04-26 | Carroll | Indiana | 18015 | 4238 | 68 |
2445019 | 2445019 | 2022-04-26 | Carroll | Iowa | 19027 | 4936 | 65 |
2445232 | 2445232 | 2022-04-26 | Carroll | Kentucky | 21041 | 3500 | 45 |
2445420 | 2445420 | 2022-04-26 | Carroll | Maryland | 24013 | 21656 | 400 |
2445633 | 2445633 | 2022-04-26 | Carroll | Mississippi | 28015 | 2558 | 53 |
2445724 | 2445724 | 2022-04-26 | Carroll | Missouri | 29033 | 2226 | 44 |
2445994 | 2445994 | 2022-04-26 | Carroll | New Hampshire | 33003 | 9557 | 61 |
2446285 | 2446285 | 2022-04-26 | Carroll | Ohio | 39019 | 5260 | 126 |
2446751 | 2446751 | 2022-04-26 | Carroll | Tennessee | 47017 | 8957 | 156 |
2447161 | 2447161 | 2022-04-26 | Carroll | Virginia | 51035 | 6688 | 147 |
2441070 | 2441070 | 2022-04-25 | Carroll | Arkansas | 5015 | 6109 | 102 |
2441364 | 2441364 | 2022-04-25 | Carroll | Georgia | 13045 | 23785 | 456 |
2441561 | 2441561 | 2022-04-25 | Carroll | Illinois | 17015 | 4255 | 49 |
2441664 | 2441664 | 2022-04-25 | Carroll | Indiana | 18015 | 4238 | 68 |
2441763 | 2441763 | 2022-04-25 | Carroll | Iowa | 19027 | 4936 | 65 |
2441976 | 2441976 | 2022-04-25 | Carroll | Kentucky | 21041 | 3500 | 45 |
2442164 | 2442164 | 2022-04-25 | Carroll | Maryland | 24013 | 21624 | 400 |
2442377 | 2442377 | 2022-04-25 | Carroll | Mississippi | 28015 | 2558 | 53 |
2442469 | 2442469 | 2022-04-25 | Carroll | Missouri | 29033 | 2226 | 44 |
2442739 | 2442739 | 2022-04-25 | Carroll | New Hampshire | 33003 | 9554 | 60 |
2443030 | 2443030 | 2022-04-25 | Carroll | Ohio | 39019 | 5260 | 126 |
2443496 | 2443496 | 2022-04-25 | Carroll | Tennessee | 47017 | 8957 | 156 |
2443906 | 2443906 | 2022-04-25 | Carroll | Virginia | 51035 | 6687 | 146 |
2437814 | 2437814 | 2022-04-24 | Carroll | Arkansas | 5015 | 6108 | 102 |
2438108 | 2438108 | 2022-04-24 | Carroll | Georgia | 13045 | 23785 | 456 |
2438305 | 2438305 | 2022-04-24 | Carroll | Illinois | 17015 | 4252 | 49 |
2438408 | 2438408 | 2022-04-24 | Carroll | Indiana | 18015 | 4228 | 68 |
2438507 | 2438507 | 2022-04-24 | Carroll | Iowa | 19027 | 4936 | 65 |
2438720 | 2438720 | 2022-04-24 | Carroll | Kentucky | 21041 | 3497 | 44 |
2438908 | 2438908 | 2022-04-24 | Carroll | Maryland | 24013 | 21603 | 400 |
2439121 | 2439121 | 2022-04-24 | Carroll | Mississippi | 28015 | 2558 | 53 |
2439213 | 2439213 | 2022-04-24 | Carroll | Missouri | 29033 | 2226 | 44 |
2439483 | 2439483 | 2022-04-24 | Carroll | New Hampshire | 33003 | 9493 | 60 |
2439774 | 2439774 | 2022-04-24 | Carroll | Ohio | 39019 | 5260 | 126 |
2440240 | 2440240 | 2022-04-24 | Carroll | Tennessee | 47017 | 8957 | 156 |
2440650 | 2440650 | 2022-04-24 | Carroll | Virginia | 51035 | 6679 | 146 |
2434558 | 2434558 | 2022-04-23 | Carroll | Arkansas | 5015 | 6108 | 102 |
2434852 | 2434852 | 2022-04-23 | Carroll | Georgia | 13045 | 23785 | 456 |
2435049 | 2435049 | 2022-04-23 | Carroll | Illinois | 17015 | 4252 | 49 |
2435152 | 2435152 | 2022-04-23 | Carroll | Indiana | 18015 | 4228 | 68 |
2435251 | 2435251 | 2022-04-23 | Carroll | Iowa | 19027 | 4936 | 65 |
2435464 | 2435464 | 2022-04-23 | Carroll | Kentucky | 21041 | 3497 | 44 |
2435652 | 2435652 | 2022-04-23 | Carroll | Maryland | 24013 | 21603 | 400 |
2435865 | 2435865 | 2022-04-23 | Carroll | Mississippi | 28015 | 2558 | 53 |
2435957 | 2435957 | 2022-04-23 | Carroll | Missouri | 29033 | 2226 | 44 |
2436227 | 2436227 | 2022-04-23 | Carroll | New Hampshire | 33003 | 9493 | 60 |
2436518 | 2436518 | 2022-04-23 | Carroll | Ohio | 39019 | 5260 | 126 |
2436984 | 2436984 | 2022-04-23 | Carroll | Tennessee | 47017 | 8957 | 156 |
2437394 | 2437394 | 2022-04-23 | Carroll | Virginia | 51035 | 6679 | 146 |
2431302 | 2431302 | 2022-04-22 | Carroll | Arkansas | 5015 | 6107 | 102 |
2431596 | 2431596 | 2022-04-22 | Carroll | Georgia | 13045 | 23785 | 456 |
2431793 | 2431793 | 2022-04-22 | Carroll | Illinois | 17015 | 4252 | 49 |
2431896 | 2431896 | 2022-04-22 | Carroll | Indiana | 18015 | 4228 | 68 |
2431995 | 2431995 | 2022-04-22 | Carroll | Iowa | 19027 | 4936 | 65 |
2432208 | 2432208 | 2022-04-22 | Carroll | Kentucky | 21041 | 3497 | 44 |
2432396 | 2432396 | 2022-04-22 | Carroll | Maryland | 24013 | 21603 | 400 |
2432609 | 2432609 | 2022-04-22 | Carroll | Mississippi | 28015 | 2558 | 53 |
2432701 | 2432701 | 2022-04-22 | Carroll | Missouri | 29033 | 2226 | 44 |
2432971 | 2432971 | 2022-04-22 | Carroll | New Hampshire | 33003 | 9493 | 60 |
2433262 | 2433262 | 2022-04-22 | Carroll | Ohio | 39019 | 5260 | 126 |
2433728 | 2433728 | 2022-04-22 | Carroll | Tennessee | 47017 | 8957 | 156 |
2434138 | 2434138 | 2022-04-22 | Carroll | Virginia | 51035 | 6679 | 146 |
2428046 | 2428046 | 2022-04-21 | Carroll | Arkansas | 5015 | 6106 | 102 |
2428340 | 2428340 | 2022-04-21 | Carroll | Georgia | 13045 | 23785 | 456 |
2428537 | 2428537 | 2022-04-21 | Carroll | Illinois | 17015 | 4250 | 49 |
2428640 | 2428640 | 2022-04-21 | Carroll | Indiana | 18015 | 4227 | 68 |
2428739 | 2428739 | 2022-04-21 | Carroll | Iowa | 19027 | 4936 | 65 |
2428952 | 2428952 | 2022-04-21 | Carroll | Kentucky | 21041 | 3497 | 44 |
2429140 | 2429140 | 2022-04-21 | Carroll | Maryland | 24013 | 21570 | 400 |
2429353 | 2429353 | 2022-04-21 | Carroll | Mississippi | 28015 | 2558 | 53 |
2429445 | 2429445 | 2022-04-21 | Carroll | Missouri | 29033 | 2226 | 44 |
2429715 | 2429715 | 2022-04-21 | Carroll | New Hampshire | 33003 | 9473 | 60 |
2430006 | 2430006 | 2022-04-21 | Carroll | Ohio | 39019 | 5260 | 126 |
2430472 | 2430472 | 2022-04-21 | Carroll | Tennessee | 47017 | 8957 | 156 |
2430882 | 2430882 | 2022-04-21 | Carroll | Virginia | 51035 | 6674 | 146 |
2424790 | 2424790 | 2022-04-20 | Carroll | Arkansas | 5015 | 6106 | 102 |
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);