ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where cases = 14737 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 12
- Florida 14
- Georgia 6
- North Carolina 5
- Ohio 3
- Arizona 2
- Maryland 2
- South Carolina 2
- Alabama 1
- Connecticut 1
- Kentucky 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2460901 | 2460901 | 2022-05-01 | Catoosa | Georgia | 13047 | 14737 | 164 |
2457645 | 2457645 | 2022-04-30 | Catoosa | Georgia | 13047 | 14737 | 164 |
2454389 | 2454389 | 2022-04-29 | Catoosa | Georgia | 13047 | 14737 | 164 |
2451133 | 2451133 | 2022-04-28 | Catoosa | Georgia | 13047 | 14737 | 164 |
2447877 | 2447877 | 2022-04-27 | Catoosa | Georgia | 13047 | 14737 | 164 |
2382702 | 2382702 | 2022-04-07 | Jackson | Florida | 12063 | 14737 | 276 |
2379447 | 2379447 | 2022-04-06 | Jackson | Florida | 12063 | 14737 | 276 |
2376193 | 2376193 | 2022-04-05 | Jackson | Florida | 12063 | 14737 | 275 |
2372941 | 2372941 | 2022-04-04 | Jackson | Florida | 12063 | 14737 | 275 |
2369688 | 2369688 | 2022-04-03 | Jackson | Florida | 12063 | 14737 | 275 |
2366435 | 2366435 | 2022-04-02 | Jackson | Florida | 12063 | 14737 | 275 |
2363182 | 2363182 | 2022-04-01 | Jackson | Florida | 12063 | 14737 | 275 |
2359928 | 2359928 | 2022-03-31 | Jackson | Florida | 12063 | 14737 | 275 |
2356674 | 2356674 | 2022-03-30 | Jackson | Florida | 12063 | 14737 | 275 |
2353421 | 2353421 | 2022-03-29 | Jackson | Florida | 12063 | 14737 | 274 |
2350169 | 2350169 | 2022-03-28 | Jackson | Florida | 12063 | 14737 | 274 |
2346916 | 2346916 | 2022-03-27 | Jackson | Florida | 12063 | 14737 | 274 |
2343663 | 2343663 | 2022-03-26 | Jackson | Florida | 12063 | 14737 | 274 |
2340410 | 2340410 | 2022-03-25 | Jackson | Florida | 12063 | 14737 | 274 |
2206760 | 2206760 | 2022-02-12 | Jackson | Alabama | 1071 | 14737 | 215 |
2176155 | 2176155 | 2022-02-02 | Lenoir | North Carolina | 37107 | 14737 | 184 |
2172879 | 2172879 | 2022-02-01 | Duplin | North Carolina | 37061 | 14737 | 207 |
2173882 | 2173882 | 2022-02-01 | Bedford | Virginia | 51019 | 14737 | 184 |
2166393 | 2166393 | 2022-01-30 | Lee | North Carolina | 37105 | 14737 | 129 |
2163138 | 2163138 | 2022-01-29 | Lee | North Carolina | 37105 | 14737 | 129 |
2159883 | 2159883 | 2022-01-28 | Lee | North Carolina | 37105 | 14737 | 129 |
1921806 | 1921806 | 2021-11-16 | Charles | Maryland | 24017 | 14737 | 264 |
1923048 | 1923048 | 2021-11-16 | Orangeburg | South Carolina | 45075 | 14737 | 336 |
1838229 | 1838229 | 2021-10-21 | Muskingum | Ohio | 39119 | 14737 | 185 |
1548205 | 1548205 | 2021-07-24 | Washington | Maryland | 24043 | 14737 | 334 |
1509022 | 1509022 | 2021-07-12 | Boone | Kentucky | 21015 | 14737 | 154 |
1358673 | 1358673 | 2021-05-26 | Sheboygan | Wisconsin | 55117 | 14737 | 155 |
1240668 | 1240668 | 2021-04-20 | Greene | Ohio | 39057 | 14737 | 236 |
1206520 | 1206520 | 2021-04-10 | Clarke | Georgia | 13059 | 14737 | 140 |
971196 | 971196 | 2021-01-27 | Delaware | Ohio | 39041 | 14737 | 81 |
933527 | 933527 | 2021-01-16 | Yavapai | Arizona | 4025 | 14737 | 325 |
930282 | 930282 | 2021-01-15 | Yavapai | Arizona | 4025 | 14737 | 308 |
932590 | 932590 | 2021-01-15 | Anderson | South Carolina | 45007 | 14737 | 319 |
580077 | 580077 | 2020-09-29 | Hartford | Connecticut | 9003 | 14737 | 1436 |
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);