ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
372 rows where cases = 1365 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 58
- Kentucky 31
- Puerto Rico 23
- Iowa 21
- Missouri 21
- Virginia 20
- Alabama 16
- Georgia 15
- Minnesota 15
- Mississippi 14
- Indiana 11
- Michigan 9
- Ohio 9
- North Carolina 8
- Arkansas 7
- Colorado 7
- Illinois 7
- Montana 7
- South Dakota 7
- West Virginia 7
- Pennsylvania 5
- Florida 4
- Kansas 4
- Maine 4
- Nebraska 4
- New York 4
- Wisconsin 4
- Wyoming 4
- Connecticut 3
- Oklahoma 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2450271 | 2450271 | 2022-04-27 | Newton | Texas | 48351 | 1365 | 61 |
2447014 | 2447014 | 2022-04-26 | Newton | Texas | 48351 | 1365 | 61 |
2443759 | 2443759 | 2022-04-25 | Newton | Texas | 48351 | 1365 | 61 |
2440503 | 2440503 | 2022-04-24 | Newton | Texas | 48351 | 1365 | 61 |
2437247 | 2437247 | 2022-04-23 | Newton | Texas | 48351 | 1365 | 61 |
2433991 | 2433991 | 2022-04-22 | Newton | Texas | 48351 | 1365 | 61 |
2429624 | 2429624 | 2022-04-21 | Dawes | Nebraska | 31045 | 1365 | 21 |
2430735 | 2430735 | 2022-04-21 | Newton | Texas | 48351 | 1365 | 61 |
2427479 | 2427479 | 2022-04-20 | Newton | Texas | 48351 | 1365 | 61 |
2424223 | 2424223 | 2022-04-19 | Newton | Texas | 48351 | 1365 | 61 |
2420967 | 2420967 | 2022-04-18 | Newton | Texas | 48351 | 1365 | 61 |
2417711 | 2417711 | 2022-04-17 | Newton | Texas | 48351 | 1365 | 61 |
2414455 | 2414455 | 2022-04-16 | Newton | Texas | 48351 | 1365 | 61 |
2411199 | 2411199 | 2022-04-15 | Newton | Texas | 48351 | 1365 | 61 |
2407943 | 2407943 | 2022-04-14 | Newton | Texas | 48351 | 1365 | 61 |
2404687 | 2404687 | 2022-04-13 | Newton | Texas | 48351 | 1365 | 61 |
2401432 | 2401432 | 2022-04-12 | Newton | Texas | 48351 | 1365 | 61 |
2398177 | 2398177 | 2022-04-11 | Newton | Texas | 48351 | 1365 | 61 |
2394922 | 2394922 | 2022-04-10 | Newton | Texas | 48351 | 1365 | 61 |
2391666 | 2391666 | 2022-04-09 | Newton | Texas | 48351 | 1365 | 61 |
2388410 | 2388410 | 2022-04-08 | Newton | Texas | 48351 | 1365 | 61 |
2385155 | 2385155 | 2022-04-07 | Newton | Texas | 48351 | 1365 | 61 |
2381900 | 2381900 | 2022-04-06 | Newton | Texas | 48351 | 1365 | 61 |
2378195 | 2378195 | 2022-04-05 | Ceiba | Puerto Rico | 72037 | 1365 | |
2378645 | 2378645 | 2022-04-05 | Newton | Texas | 48351 | 1365 | 61 |
2374941 | 2374941 | 2022-04-04 | Ceiba | Puerto Rico | 72037 | 1365 | |
2375391 | 2375391 | 2022-04-04 | Newton | Texas | 48351 | 1365 | 61 |
2371689 | 2371689 | 2022-04-03 | Ceiba | Puerto Rico | 72037 | 1365 | |
2372139 | 2372139 | 2022-04-03 | Newton | Texas | 48351 | 1365 | 61 |
2368436 | 2368436 | 2022-04-02 | Ceiba | Puerto Rico | 72037 | 1365 | |
2368886 | 2368886 | 2022-04-02 | Newton | Texas | 48351 | 1365 | 61 |
2365633 | 2365633 | 2022-04-01 | Newton | Texas | 48351 | 1365 | 61 |
2362380 | 2362380 | 2022-03-31 | Newton | Texas | 48351 | 1365 | 61 |
2359126 | 2359126 | 2022-03-30 | Newton | Texas | 48351 | 1365 | 61 |
2355872 | 2355872 | 2022-03-29 | Newton | Texas | 48351 | 1365 | 61 |
2352619 | 2352619 | 2022-03-28 | Newton | Texas | 48351 | 1365 | 61 |
2349367 | 2349367 | 2022-03-27 | Newton | Texas | 48351 | 1365 | 61 |
2346114 | 2346114 | 2022-03-26 | Newton | Texas | 48351 | 1365 | 61 |
2266579 | 2266579 | 2022-03-02 | Big Stone | Minnesota | 27011 | 1365 | 8 |
2262404 | 2262404 | 2022-03-01 | Calhoun | Georgia | 13037 | 1365 | 22 |
2222257 | 2222257 | 2022-02-16 | Tripp | South Dakota | 46123 | 1365 | 23 |
2213861 | 2213861 | 2022-02-14 | Gallatin | Illinois | 17059 | 1365 | 14 |
2215744 | 2215744 | 2022-02-14 | Moody | South Dakota | 46101 | 1365 | 27 |
2176558 | 2176558 | 2022-02-02 | Guanica | Puerto Rico | 72055 | 1365 | |
2165745 | 2165745 | 2022-01-30 | Oscoda | Michigan | 26135 | 1365 | 53 |
2162490 | 2162490 | 2022-01-29 | Oscoda | Michigan | 26135 | 1365 | 53 |
2159235 | 2159235 | 2022-01-28 | Oscoda | Michigan | 26135 | 1365 | 53 |
2156040 | 2156040 | 2022-01-27 | Mahnomen | Minnesota | 27087 | 1365 | 17 |
2148854 | 2148854 | 2022-01-25 | Stark | Illinois | 17175 | 1365 | 31 |
2148095 | 2148095 | 2022-01-24 | Iron | Wisconsin | 55051 | 1365 | 44 |
2130203 | 2130203 | 2022-01-19 | Maries | Missouri | 29125 | 1365 | 27 |
2110447 | 2110447 | 2022-01-13 | Schoolcraft | Michigan | 26153 | 1365 | 9 |
2110647 | 2110647 | 2022-01-13 | Chariton | Missouri | 29041 | 1365 | 32 |
2107196 | 2107196 | 2022-01-12 | Schoolcraft | Michigan | 26153 | 1365 | 9 |
2104121 | 2104121 | 2022-01-11 | Wilkinson | Mississippi | 28157 | 1365 | 39 |
2099856 | 2099856 | 2022-01-10 | Lincoln | Georgia | 13181 | 1365 | 33 |
2086254 | 2086254 | 2022-01-05 | Pendleton | West Virginia | 54071 | 1365 | 16 |
2066625 | 2066625 | 2021-12-30 | Northumberland | Virginia | 51133 | 1365 | 39 |
2034847 | 2034847 | 2021-12-21 | Macon | Georgia | 13193 | 1365 | 46 |
2031597 | 2031597 | 2021-12-20 | Macon | Georgia | 13193 | 1365 | 46 |
2024234 | 2024234 | 2021-12-17 | Winkler | Texas | 48495 | 1365 | 32 |
2020983 | 2020983 | 2021-12-16 | Winkler | Texas | 48495 | 1365 | 32 |
2017732 | 2017732 | 2021-12-15 | Winkler | Texas | 48495 | 1365 | 32 |
2014482 | 2014482 | 2021-12-14 | Winkler | Texas | 48495 | 1365 | 32 |
2009370 | 2009370 | 2021-12-13 | Bracken | Kentucky | 21023 | 1365 | 19 |
2011231 | 2011231 | 2021-12-13 | Winkler | Texas | 48495 | 1365 | 32 |
2007980 | 2007980 | 2021-12-12 | Winkler | Texas | 48495 | 1365 | 32 |
2004729 | 2004729 | 2021-12-11 | Winkler | Texas | 48495 | 1365 | 32 |
1983465 | 1983465 | 2021-12-05 | Trimble | Kentucky | 21223 | 1365 | 23 |
1980215 | 1980215 | 2021-12-04 | Trimble | Kentucky | 21223 | 1365 | 23 |
1976965 | 1976965 | 2021-12-03 | Trimble | Kentucky | 21223 | 1365 | 23 |
1975307 | 1975307 | 2021-12-02 | Franklin | Texas | 48159 | 1365 | 37 |
1971296 | 1971296 | 2021-12-01 | Graham | North Carolina | 37075 | 1365 | 28 |
1959908 | 1959908 | 2021-11-28 | Yuma | Colorado | 8125 | 1365 | 18 |
1961025 | 1961025 | 2021-11-28 | Choctaw | Mississippi | 28019 | 1365 | 27 |
1956657 | 1956657 | 2021-11-27 | Yuma | Colorado | 8125 | 1365 | 18 |
1957774 | 1957774 | 2021-11-27 | Choctaw | Mississippi | 28019 | 1365 | 27 |
1953406 | 1953406 | 2021-11-26 | Yuma | Colorado | 8125 | 1365 | 18 |
1954523 | 1954523 | 2021-11-26 | Choctaw | Mississippi | 28019 | 1365 | 27 |
1950155 | 1950155 | 2021-11-25 | Yuma | Colorado | 8125 | 1365 | 18 |
1951272 | 1951272 | 2021-11-25 | Choctaw | Mississippi | 28019 | 1365 | 27 |
1951489 | 1951489 | 2021-11-25 | Madison | Montana | 30057 | 1365 | 18 |
1952798 | 1952798 | 2021-11-25 | Charlotte | Virginia | 51037 | 1365 | 28 |
1948021 | 1948021 | 2021-11-24 | Choctaw | Mississippi | 28019 | 1365 | 27 |
1948238 | 1948238 | 2021-11-24 | Madison | Montana | 30057 | 1365 | 18 |
1943118 | 1943118 | 2021-11-22 | Poquoson city | Virginia | 51735 | 1365 | 22 |
1920653 | 1920653 | 2021-11-16 | Sumter | Alabama | 1119 | 1365 | 40 |
1917403 | 1917403 | 2021-11-15 | Sumter | Alabama | 1119 | 1365 | 40 |
1919706 | 1919706 | 2021-11-15 | Guayama | Puerto Rico | 72057 | 1365 | |
1914153 | 1914153 | 2021-11-14 | Sumter | Alabama | 1119 | 1365 | 40 |
1916456 | 1916456 | 2021-11-14 | Guayama | Puerto Rico | 72057 | 1365 | |
1910903 | 1910903 | 2021-11-13 | Sumter | Alabama | 1119 | 1365 | 40 |
1905919 | 1905919 | 2021-11-11 | Oregon | Missouri | 29149 | 1365 | 11 |
1902670 | 1902670 | 2021-11-10 | Oregon | Missouri | 29149 | 1365 | 11 |
1895793 | 1895793 | 2021-11-08 | Piscataquis | Maine | 23021 | 1365 | 12 |
1897084 | 1897084 | 2021-11-08 | Grant | South Dakota | 46051 | 1365 | 45 |
1892543 | 1892543 | 2021-11-07 | Piscataquis | Maine | 23021 | 1365 | 12 |
1889293 | 1889293 | 2021-11-06 | Piscataquis | Maine | 23021 | 1365 | 12 |
1884550 | 1884550 | 2021-11-04 | Clarke | Virginia | 51043 | 1365 | 25 |
1878245 | 1878245 | 2021-11-02 | Tyler | West Virginia | 54095 | 1365 | 19 |
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);