ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
362 rows where cases = 1318 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 67
- Georgia 18
- Texas 18
- Kentucky 16
- Mississippi 16
- Missouri 14
- New Mexico 13
- Virginia 13
- Idaho 12
- Puerto Rico 12
- Tennessee 11
- Arkansas 10
- Minnesota 10
- Wisconsin 10
- Kansas 9
- Michigan 9
- South Dakota 9
- Illinois 8
- Nebraska 8
- North Carolina 8
- Oregon 7
- Washington 6
- North Dakota 5
- Alabama 4
- Alaska 4
- California 4
- Louisiana 4
- Pennsylvania 4
- South Carolina 4
- Indiana 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501610 | 2501610 | 2022-05-13 | McHenry | North Dakota | 38049 | 1318 | 31 |
2422300 | 2422300 | 2022-04-19 | Taylor | Iowa | 19173 | 1318 | 22 |
2419044 | 2419044 | 2022-04-18 | Taylor | Iowa | 19173 | 1318 | 22 |
2415788 | 2415788 | 2022-04-17 | Taylor | Iowa | 19173 | 1318 | 22 |
2412532 | 2412532 | 2022-04-16 | Taylor | Iowa | 19173 | 1318 | 22 |
2409276 | 2409276 | 2022-04-15 | Taylor | Iowa | 19173 | 1318 | 22 |
2406020 | 2406020 | 2022-04-14 | Taylor | Iowa | 19173 | 1318 | 22 |
2402764 | 2402764 | 2022-04-13 | Taylor | Iowa | 19173 | 1318 | 22 |
2399510 | 2399510 | 2022-04-12 | Taylor | Iowa | 19173 | 1318 | 21 |
2396254 | 2396254 | 2022-04-11 | Taylor | Iowa | 19173 | 1318 | 21 |
2392999 | 2392999 | 2022-04-10 | Taylor | Iowa | 19173 | 1318 | 21 |
2389743 | 2389743 | 2022-04-09 | Taylor | Iowa | 19173 | 1318 | 21 |
2386487 | 2386487 | 2022-04-08 | Taylor | Iowa | 19173 | 1318 | 21 |
2383233 | 2383233 | 2022-04-07 | Taylor | Iowa | 19173 | 1318 | 21 |
2379978 | 2379978 | 2022-04-06 | Taylor | Iowa | 19173 | 1318 | 21 |
2376723 | 2376723 | 2022-04-05 | Taylor | Iowa | 19173 | 1318 | 21 |
2373471 | 2373471 | 2022-04-04 | Taylor | Iowa | 19173 | 1318 | 21 |
2370218 | 2370218 | 2022-04-03 | Taylor | Iowa | 19173 | 1318 | 21 |
2366965 | 2366965 | 2022-04-02 | Taylor | Iowa | 19173 | 1318 | 21 |
2363712 | 2363712 | 2022-04-01 | Taylor | Iowa | 19173 | 1318 | 21 |
2360458 | 2360458 | 2022-03-31 | Taylor | Iowa | 19173 | 1318 | 21 |
2357204 | 2357204 | 2022-03-30 | Taylor | Iowa | 19173 | 1318 | 21 |
2353951 | 2353951 | 2022-03-29 | Taylor | Iowa | 19173 | 1318 | 21 |
2350699 | 2350699 | 2022-03-28 | Taylor | Iowa | 19173 | 1318 | 21 |
2347446 | 2347446 | 2022-03-27 | Taylor | Iowa | 19173 | 1318 | 21 |
2344193 | 2344193 | 2022-03-26 | Taylor | Iowa | 19173 | 1318 | 21 |
2340940 | 2340940 | 2022-03-25 | Taylor | Iowa | 19173 | 1318 | 21 |
2337687 | 2337687 | 2022-03-24 | Taylor | Iowa | 19173 | 1318 | 21 |
2334433 | 2334433 | 2022-03-23 | Taylor | Iowa | 19173 | 1318 | 21 |
2331179 | 2331179 | 2022-03-22 | Taylor | Iowa | 19173 | 1318 | 21 |
2327927 | 2327927 | 2022-03-21 | Taylor | Iowa | 19173 | 1318 | 21 |
2324674 | 2324674 | 2022-03-20 | Taylor | Iowa | 19173 | 1318 | 21 |
2321420 | 2321420 | 2022-03-19 | Taylor | Iowa | 19173 | 1318 | 21 |
2318166 | 2318166 | 2022-03-18 | Taylor | Iowa | 19173 | 1318 | 21 |
2314913 | 2314913 | 2022-03-17 | Taylor | Iowa | 19173 | 1318 | 21 |
2311660 | 2311660 | 2022-03-16 | Taylor | Iowa | 19173 | 1318 | 21 |
2215479 | 2215479 | 2022-02-14 | Lake | Oregon | 41037 | 1318 | 23 |
2210956 | 2210956 | 2022-02-13 | Rooks | Kansas | 20163 | 1318 | 20 |
2212228 | 2212228 | 2022-02-13 | Lake | Oregon | 41037 | 1318 | 23 |
2207703 | 2207703 | 2022-02-12 | Rooks | Kansas | 20163 | 1318 | 20 |
2208975 | 2208975 | 2022-02-12 | Lake | Oregon | 41037 | 1318 | 23 |
2204450 | 2204450 | 2022-02-11 | Rooks | Kansas | 20163 | 1318 | 20 |
2205722 | 2205722 | 2022-02-11 | Lake | Oregon | 41037 | 1318 | 23 |
2201197 | 2201197 | 2022-02-10 | Rooks | Kansas | 20163 | 1318 | 20 |
2197943 | 2197943 | 2022-02-09 | Rooks | Kansas | 20163 | 1318 | 20 |
2196220 | 2196220 | 2022-02-08 | McCook | South Dakota | 46087 | 1318 | 30 |
2148988 | 2148988 | 2022-01-25 | Decatur | Iowa | 19053 | 1318 | 22 |
2150636 | 2150636 | 2022-01-25 | Brule | South Dakota | 46015 | 1318 | 18 |
2145736 | 2145736 | 2022-01-24 | Decatur | Iowa | 19053 | 1318 | 22 |
2142481 | 2142481 | 2022-01-23 | Decatur | Iowa | 19053 | 1318 | 22 |
2139226 | 2139226 | 2022-01-22 | Decatur | Iowa | 19053 | 1318 | 22 |
2135970 | 2135970 | 2022-01-21 | Decatur | Iowa | 19053 | 1318 | 22 |
2136742 | 2136742 | 2022-01-21 | Shannon | Missouri | 29203 | 1318 | 32 |
2132718 | 2132718 | 2022-01-20 | Decatur | Iowa | 19053 | 1318 | 22 |
2129465 | 2129465 | 2022-01-19 | Decatur | Iowa | 19053 | 1318 | 22 |
2127050 | 2127050 | 2022-01-18 | Stillwater | Montana | 30095 | 1318 | 29 |
2108545 | 2108545 | 2022-01-12 | Coleman | Texas | 48083 | 1318 | 59 |
2108984 | 2108984 | 2022-01-12 | Calhoun | West Virginia | 54013 | 1318 | 9 |
2097856 | 2097856 | 2022-01-09 | Merrick | Nebraska | 31121 | 1318 | 15 |
2094604 | 2094604 | 2022-01-08 | Merrick | Nebraska | 31121 | 1318 | 15 |
2091139 | 2091139 | 2022-01-07 | Chariton | Missouri | 29041 | 1318 | 32 |
2091352 | 2091352 | 2022-01-07 | Merrick | Nebraska | 31121 | 1318 | 15 |
2075087 | 2075087 | 2022-01-02 | Knox | Nebraska | 31107 | 1318 | 13 |
2071836 | 2071836 | 2022-01-01 | Knox | Nebraska | 31107 | 1318 | 13 |
2068585 | 2068585 | 2021-12-31 | Knox | Nebraska | 31107 | 1318 | 13 |
2065334 | 2065334 | 2021-12-30 | Knox | Nebraska | 31107 | 1318 | 13 |
2059950 | 2059950 | 2021-12-28 | Stephens | Texas | 48429 | 1318 | 37 |
2056357 | 2056357 | 2021-12-27 | Hutchinson | South Dakota | 46067 | 1318 | 29 |
2046453 | 2046453 | 2021-12-24 | Barceloneta | Puerto Rico | 72017 | 1318 | |
2043203 | 2043203 | 2021-12-23 | Barceloneta | Puerto Rico | 72017 | 1318 | |
2037774 | 2037774 | 2021-12-22 | Newton | Arkansas | 5101 | 1318 | 43 |
2032205 | 2032205 | 2021-12-20 | Nicholas | Kentucky | 21181 | 1318 | 27 |
2021186 | 2021186 | 2021-12-16 | Jefferson | Washington | 53031 | 1318 | 21 |
1929815 | 1929815 | 2021-11-18 | Hamilton | Texas | 48193 | 1318 | 29 |
1924873 | 1924873 | 2021-11-17 | Cumberland | Kentucky | 21057 | 1318 | 21 |
1926565 | 1926565 | 2021-11-17 | Hamilton | Texas | 48193 | 1318 | 29 |
1921624 | 1921624 | 2021-11-16 | Cumberland | Kentucky | 21057 | 1318 | 21 |
1923315 | 1923315 | 2021-11-16 | Hamilton | Texas | 48193 | 1318 | 29 |
1899537 | 1899537 | 2021-11-09 | Custer | Nebraska | 31041 | 1318 | 21 |
1873858 | 1873858 | 2021-11-01 | Benson | North Dakota | 38005 | 1318 | 20 |
1870609 | 1870609 | 2021-10-31 | Benson | North Dakota | 38005 | 1318 | 20 |
1858522 | 1858522 | 2021-10-27 | Orange | Vermont | 50017 | 1318 | 5 |
1848381 | 1848381 | 2021-10-24 | Turner | South Dakota | 46125 | 1318 | 61 |
1845131 | 1845131 | 2021-10-23 | Turner | South Dakota | 46125 | 1318 | 61 |
1840925 | 1840925 | 2021-10-22 | Monroe | Missouri | 29137 | 1318 | 13 |
1841881 | 1841881 | 2021-10-22 | Turner | South Dakota | 46125 | 1318 | 61 |
1836592 | 1836592 | 2021-10-21 | Macon | Georgia | 13193 | 1318 | 42 |
1838812 | 1838812 | 2021-10-21 | Franklin | Texas | 48159 | 1318 | 34 |
1833343 | 1833343 | 2021-10-20 | Macon | Georgia | 13193 | 1318 | 42 |
1835881 | 1835881 | 2021-10-20 | Poquoson city | Virginia | 51735 | 1318 | 19 |
1830094 | 1830094 | 2021-10-19 | Macon | Georgia | 13193 | 1318 | 41 |
1811520 | 1811520 | 2021-10-13 | Swift | Minnesota | 27151 | 1318 | 19 |
1790782 | 1790782 | 2021-10-07 | Nevada | Arkansas | 5099 | 1318 | 31 |
1779444 | 1779444 | 2021-10-03 | Colfax | New Mexico | 35007 | 1318 | 47 |
1776194 | 1776194 | 2021-10-02 | Colfax | New Mexico | 35007 | 1318 | 47 |
1772944 | 1772944 | 2021-10-01 | Colfax | New Mexico | 35007 | 1318 | 47 |
1768094 | 1768094 | 2021-09-30 | Plumas | California | 6063 | 1318 | 6 |
1769420 | 1769420 | 2021-09-30 | Iron | Missouri | 29093 | 1318 | 12 |
1746649 | 1746649 | 2021-09-23 | Carroll | Missouri | 29033 | 1318 | 26 |
1738297 | 1738297 | 2021-09-20 | Addison | Vermont | 50001 | 1318 | 8 |
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);