ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,412 rows where county = "Calhoun" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 11
- South Carolina 137
- Alabama 135
- Michigan 133
- Mississippi 129
- Georgia 128
- Texas 128
- Florida 123
- Illinois 118
- West Virginia 97
- Iowa 92
- Arkansas 29
fips 11
county 1
- Calhoun · 1,249 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386266 | 386266 | 2020-07-31 | Calhoun | Florida | 12013 | 281 | 7 |
386346 | 386346 | 2020-07-31 | Calhoun | Georgia | 13037 | 189 | 6 |
386541 | 386541 | 2020-07-31 | Calhoun | Illinois | 17013 | 6 | 0 |
386742 | 386742 | 2020-07-31 | Calhoun | Iowa | 19025 | 81 | 2 |
387187 | 387187 | 2020-07-31 | Calhoun | Michigan | 26025 | 728 | 41 |
387353 | 387353 | 2020-07-31 | Calhoun | Mississippi | 28013 | 366 | 8 |
388337 | 388337 | 2020-07-31 | Calhoun | South Carolina | 45017 | 295 | 7 |
388563 | 388563 | 2020-07-31 | Calhoun | Texas | 48057 | 453 | 3 |
389012 | 389012 | 2020-07-31 | Calhoun | West Virginia | 54013 | 6 | 0 |
382729 | 382729 | 2020-07-30 | Calhoun | Alabama | 1015 | 1336 | 8 |
382837 | 382837 | 2020-07-30 | Calhoun | Arkansas | 5013 | 12 | 0 |
383048 | 383048 | 2020-07-30 | Calhoun | Florida | 12013 | 278 | 7 |
383128 | 383128 | 2020-07-30 | Calhoun | Georgia | 13037 | 185 | 6 |
383323 | 383323 | 2020-07-30 | Calhoun | Illinois | 17013 | 6 | 0 |
383524 | 383524 | 2020-07-30 | Calhoun | Iowa | 19025 | 81 | 2 |
383969 | 383969 | 2020-07-30 | Calhoun | Michigan | 26025 | 717 | 41 |
384135 | 384135 | 2020-07-30 | Calhoun | Mississippi | 28013 | 364 | 8 |
385120 | 385120 | 2020-07-30 | Calhoun | South Carolina | 45017 | 284 | 6 |
385346 | 385346 | 2020-07-30 | Calhoun | Texas | 48057 | 453 | 3 |
385795 | 385795 | 2020-07-30 | Calhoun | West Virginia | 54013 | 6 | 0 |
379512 | 379512 | 2020-07-29 | Calhoun | Alabama | 1015 | 1292 | 6 |
379620 | 379620 | 2020-07-29 | Calhoun | Arkansas | 5013 | 10 | 0 |
379831 | 379831 | 2020-07-29 | Calhoun | Florida | 12013 | 271 | 7 |
379911 | 379911 | 2020-07-29 | Calhoun | Georgia | 13037 | 183 | 6 |
380106 | 380106 | 2020-07-29 | Calhoun | Illinois | 17013 | 6 | 0 |
380307 | 380307 | 2020-07-29 | Calhoun | Iowa | 19025 | 78 | 2 |
380752 | 380752 | 2020-07-29 | Calhoun | Michigan | 26025 | 708 | 41 |
380918 | 380918 | 2020-07-29 | Calhoun | Mississippi | 28013 | 355 | 8 |
381902 | 381902 | 2020-07-29 | Calhoun | South Carolina | 45017 | 280 | 6 |
382128 | 382128 | 2020-07-29 | Calhoun | Texas | 48057 | 439 | 4 |
382577 | 382577 | 2020-07-29 | Calhoun | West Virginia | 54013 | 6 | 0 |
376296 | 376296 | 2020-07-28 | Calhoun | Alabama | 1015 | 1244 | 6 |
376404 | 376404 | 2020-07-28 | Calhoun | Arkansas | 5013 | 10 | 0 |
376614 | 376614 | 2020-07-28 | Calhoun | Florida | 12013 | 265 | 7 |
376694 | 376694 | 2020-07-28 | Calhoun | Georgia | 13037 | 182 | 6 |
376889 | 376889 | 2020-07-28 | Calhoun | Illinois | 17013 | 6 | 0 |
377090 | 377090 | 2020-07-28 | Calhoun | Iowa | 19025 | 76 | 2 |
377535 | 377535 | 2020-07-28 | Calhoun | Michigan | 26025 | 705 | 40 |
377701 | 377701 | 2020-07-28 | Calhoun | Mississippi | 28013 | 345 | 8 |
378685 | 378685 | 2020-07-28 | Calhoun | South Carolina | 45017 | 281 | 6 |
378911 | 378911 | 2020-07-28 | Calhoun | Texas | 48057 | 432 | 3 |
379360 | 379360 | 2020-07-28 | Calhoun | West Virginia | 54013 | 6 | 0 |
373082 | 373082 | 2020-07-27 | Calhoun | Alabama | 1015 | 1194 | 6 |
373190 | 373190 | 2020-07-27 | Calhoun | Arkansas | 5013 | 9 | 0 |
373400 | 373400 | 2020-07-27 | Calhoun | Florida | 12013 | 261 | 7 |
373480 | 373480 | 2020-07-27 | Calhoun | Georgia | 13037 | 182 | 6 |
373674 | 373674 | 2020-07-27 | Calhoun | Illinois | 17013 | 6 | 0 |
373875 | 373875 | 2020-07-27 | Calhoun | Iowa | 19025 | 75 | 2 |
374320 | 374320 | 2020-07-27 | Calhoun | Michigan | 26025 | 699 | 39 |
374486 | 374486 | 2020-07-27 | Calhoun | Mississippi | 28013 | 342 | 8 |
375469 | 375469 | 2020-07-27 | Calhoun | South Carolina | 45017 | 272 | 4 |
375695 | 375695 | 2020-07-27 | Calhoun | Texas | 48057 | 393 | 3 |
376144 | 376144 | 2020-07-27 | Calhoun | West Virginia | 54013 | 6 | 0 |
369870 | 369870 | 2020-07-26 | Calhoun | Alabama | 1015 | 1113 | 6 |
369978 | 369978 | 2020-07-26 | Calhoun | Arkansas | 5013 | 10 | 0 |
370188 | 370188 | 2020-07-26 | Calhoun | Florida | 12013 | 254 | 7 |
370268 | 370268 | 2020-07-26 | Calhoun | Georgia | 13037 | 181 | 6 |
370462 | 370462 | 2020-07-26 | Calhoun | Illinois | 17013 | 6 | 0 |
370663 | 370663 | 2020-07-26 | Calhoun | Iowa | 19025 | 73 | 2 |
371108 | 371108 | 2020-07-26 | Calhoun | Michigan | 26025 | 694 | 39 |
371274 | 371274 | 2020-07-26 | Calhoun | Mississippi | 28013 | 339 | 8 |
372256 | 372256 | 2020-07-26 | Calhoun | South Carolina | 45017 | 276 | 4 |
372482 | 372482 | 2020-07-26 | Calhoun | Texas | 48057 | 393 | 3 |
372930 | 372930 | 2020-07-26 | Calhoun | West Virginia | 54013 | 5 | 0 |
366660 | 366660 | 2020-07-25 | Calhoun | Alabama | 1015 | 1062 | 6 |
366768 | 366768 | 2020-07-25 | Calhoun | Arkansas | 5013 | 10 | 0 |
366978 | 366978 | 2020-07-25 | Calhoun | Florida | 12013 | 247 | 7 |
367058 | 367058 | 2020-07-25 | Calhoun | Georgia | 13037 | 180 | 6 |
367252 | 367252 | 2020-07-25 | Calhoun | Illinois | 17013 | 5 | 0 |
367453 | 367453 | 2020-07-25 | Calhoun | Iowa | 19025 | 72 | 2 |
367898 | 367898 | 2020-07-25 | Calhoun | Michigan | 26025 | 688 | 39 |
368064 | 368064 | 2020-07-25 | Calhoun | Mississippi | 28013 | 335 | 8 |
369044 | 369044 | 2020-07-25 | Calhoun | South Carolina | 45017 | 259 | 3 |
369270 | 369270 | 2020-07-25 | Calhoun | Texas | 48057 | 393 | 3 |
369718 | 369718 | 2020-07-25 | Calhoun | West Virginia | 54013 | 5 | 0 |
363453 | 363453 | 2020-07-24 | Calhoun | Alabama | 1015 | 999 | 6 |
363561 | 363561 | 2020-07-24 | Calhoun | Arkansas | 5013 | 8 | 0 |
363771 | 363771 | 2020-07-24 | Calhoun | Florida | 12013 | 242 | 7 |
363851 | 363851 | 2020-07-24 | Calhoun | Georgia | 13037 | 179 | 6 |
364045 | 364045 | 2020-07-24 | Calhoun | Illinois | 17013 | 5 | 0 |
364246 | 364246 | 2020-07-24 | Calhoun | Iowa | 19025 | 72 | 2 |
364691 | 364691 | 2020-07-24 | Calhoun | Michigan | 26025 | 685 | 39 |
364856 | 364856 | 2020-07-24 | Calhoun | Mississippi | 28013 | 326 | 5 |
365835 | 365835 | 2020-07-24 | Calhoun | South Carolina | 45017 | 253 | 3 |
366061 | 366061 | 2020-07-24 | Calhoun | Texas | 48057 | 373 | 3 |
366509 | 366509 | 2020-07-24 | Calhoun | West Virginia | 54013 | 5 | 0 |
360247 | 360247 | 2020-07-23 | Calhoun | Alabama | 1015 | 934 | 6 |
360354 | 360354 | 2020-07-23 | Calhoun | Arkansas | 5013 | 8 | 0 |
360564 | 360564 | 2020-07-23 | Calhoun | Florida | 12013 | 232 | 7 |
360644 | 360644 | 2020-07-23 | Calhoun | Georgia | 13037 | 177 | 6 |
360838 | 360838 | 2020-07-23 | Calhoun | Illinois | 17013 | 4 | 0 |
361039 | 361039 | 2020-07-23 | Calhoun | Iowa | 19025 | 72 | 2 |
361484 | 361484 | 2020-07-23 | Calhoun | Michigan | 26025 | 680 | 39 |
361649 | 361649 | 2020-07-23 | Calhoun | Mississippi | 28013 | 315 | 5 |
362629 | 362629 | 2020-07-23 | Calhoun | South Carolina | 45017 | 243 | 3 |
362855 | 362855 | 2020-07-23 | Calhoun | Texas | 48057 | 322 | 3 |
363302 | 363302 | 2020-07-23 | Calhoun | West Virginia | 54013 | 5 | 0 |
357042 | 357042 | 2020-07-22 | Calhoun | Alabama | 1015 | 891 | 6 |
357149 | 357149 | 2020-07-22 | Calhoun | Arkansas | 5013 | 8 | 0 |
357359 | 357359 | 2020-07-22 | Calhoun | Florida | 12013 | 230 | 7 |
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);