ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
217 rows where cases = 2456 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 17
- Texas 15
- Puerto Rico 12
- Virginia 12
- Kentucky 11
- North Carolina 11
- Iowa 10
- Mississippi 9
- Ohio 9
- Tennessee 9
- Florida 8
- Missouri 8
- New Mexico 8
- Illinois 6
- Minnesota 6
- Idaho 5
- Indiana 5
- Nebraska 5
- Kansas 4
- Louisiana 4
- Montana 4
- Oregon 4
- South Carolina 4
- Alabama 3
- Arkansas 3
- Michigan 3
- New York 3
- Wisconsin 3
- Pennsylvania 2
- South Dakota 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500494 | 2500494 | 2022-05-13 | Doniphan | Kansas | 20043 | 2456 | 34 |
2365205 | 2365205 | 2022-04-01 | Lajas | Puerto Rico | 72079 | 2456 | |
2356021 | 2356021 | 2022-03-29 | Charlotte | Virginia | 51037 | 2456 | 46 |
2326172 | 2326172 | 2022-03-20 | Luquillo | Puerto Rico | 72089 | 2456 | |
2322919 | 2322919 | 2022-03-19 | Luquillo | Puerto Rico | 72089 | 2456 | |
2310499 | 2310499 | 2022-03-15 | Franklin city | Virginia | 51620 | 2456 | 51 |
2307127 | 2307127 | 2022-03-14 | Trinity | Texas | 48455 | 2456 | 72 |
2307246 | 2307246 | 2022-03-14 | Franklin city | Virginia | 51620 | 2456 | 51 |
2303876 | 2303876 | 2022-03-13 | Trinity | Texas | 48455 | 2456 | 72 |
2300624 | 2300624 | 2022-03-12 | Trinity | Texas | 48455 | 2456 | 72 |
2279826 | 2279826 | 2022-03-06 | Montgomery | Missouri | 29139 | 2456 | 54 |
2276573 | 2276573 | 2022-03-05 | Montgomery | Missouri | 29139 | 2456 | 54 |
2273320 | 2273320 | 2022-03-04 | Montgomery | Missouri | 29139 | 2456 | 54 |
2260370 | 2260370 | 2022-02-28 | Deer Lodge | Montana | 30023 | 2456 | 29 |
2246448 | 2246448 | 2022-02-24 | Benton | Indiana | 18007 | 2456 | 21 |
2243197 | 2243197 | 2022-02-23 | Benton | Indiana | 18007 | 2456 | 21 |
2231838 | 2231838 | 2022-02-19 | Ciales | Puerto Rico | 72039 | 2456 | |
2221147 | 2221147 | 2022-02-16 | Yellow Medicine | Minnesota | 27173 | 2456 | 28 |
2215872 | 2215872 | 2022-02-14 | Blanco | Texas | 48031 | 2456 | 32 |
2216118 | 2216118 | 2022-02-14 | Emery | Utah | 49015 | 2456 | 25 |
2189034 | 2189034 | 2022-02-06 | Los Alamos | New Mexico | 35028 | 2456 | 12 |
2185781 | 2185781 | 2022-02-05 | Los Alamos | New Mexico | 35028 | 2456 | 12 |
2182529 | 2182529 | 2022-02-04 | Los Alamos | New Mexico | 35028 | 2456 | 12 |
2131535 | 2131535 | 2022-01-19 | Juab | Utah | 49023 | 2456 | 21 |
2128476 | 2128476 | 2022-01-18 | Pacific | Washington | 53049 | 2456 | 43 |
2110622 | 2110622 | 2022-01-13 | Webster | Mississippi | 28155 | 2456 | 51 |
2099525 | 2099525 | 2022-01-10 | Lee | Arkansas | 5077 | 2456 | 55 |
2080335 | 2080335 | 2022-01-04 | Jasper | Georgia | 13159 | 2456 | 60 |
2057293 | 2057293 | 2021-12-28 | Van Buren | Arkansas | 5141 | 2456 | 45 |
2058434 | 2058434 | 2021-12-28 | Unknown | Michigan | 2456 | 26 | |
2038017 | 2038017 | 2021-12-22 | Brooks | Georgia | 13027 | 2456 | 74 |
2034767 | 2034767 | 2021-12-21 | Brooks | Georgia | 13027 | 2456 | 73 |
2035220 | 2035220 | 2021-12-21 | Madison | Iowa | 19121 | 2456 | 25 |
2036206 | 2036206 | 2021-12-21 | Socorro | New Mexico | 35053 | 2456 | 67 |
2031517 | 2031517 | 2021-12-20 | Brooks | Georgia | 13027 | 2456 | 73 |
2031970 | 2031970 | 2021-12-20 | Madison | Iowa | 19121 | 2456 | 25 |
2028719 | 2028719 | 2021-12-19 | Madison | Iowa | 19121 | 2456 | 25 |
2025468 | 2025468 | 2021-12-18 | Madison | Iowa | 19121 | 2456 | 25 |
2022217 | 2022217 | 2021-12-17 | Madison | Iowa | 19121 | 2456 | 25 |
2018966 | 2018966 | 2021-12-16 | Madison | Iowa | 19121 | 2456 | 25 |
2015716 | 2015716 | 2021-12-15 | Madison | Iowa | 19121 | 2456 | 25 |
2012270 | 2012270 | 2021-12-14 | Massac | Illinois | 17127 | 2456 | 59 |
1990411 | 1990411 | 2021-12-07 | Macon | Missouri | 29121 | 2456 | 34 |
1991236 | 1991236 | 2021-12-07 | Moca | Puerto Rico | 72099 | 2456 | |
1987582 | 1987582 | 2021-12-06 | Polk | North Carolina | 37149 | 2456 | 49 |
1987985 | 1987985 | 2021-12-06 | Moca | Puerto Rico | 72099 | 2456 | |
1970120 | 1970120 | 2021-12-01 | Pike | Indiana | 18125 | 2456 | 45 |
1960716 | 1960716 | 2021-11-28 | Washington | Kentucky | 21229 | 2456 | 48 |
1961598 | 1961598 | 2021-11-28 | Warren | North Carolina | 37185 | 2456 | 33 |
1957465 | 1957465 | 2021-11-27 | Washington | Kentucky | 21229 | 2456 | 48 |
1958347 | 1958347 | 2021-11-27 | Warren | North Carolina | 37185 | 2456 | 33 |
1954214 | 1954214 | 2021-11-26 | Washington | Kentucky | 21229 | 2456 | 48 |
1955096 | 1955096 | 2021-11-26 | Warren | North Carolina | 37185 | 2456 | 33 |
1950963 | 1950963 | 2021-11-25 | Washington | Kentucky | 21229 | 2456 | 48 |
1951231 | 1951231 | 2021-11-25 | Pennington | Minnesota | 27113 | 2456 | 29 |
1951845 | 1951845 | 2021-11-25 | Warren | North Carolina | 37185 | 2456 | 33 |
1952181 | 1952181 | 2021-11-25 | Aguada | Puerto Rico | 72003 | 2456 | |
1947712 | 1947712 | 2021-11-24 | Washington | Kentucky | 21229 | 2456 | 48 |
1947980 | 1947980 | 2021-11-24 | Pennington | Minnesota | 27113 | 2456 | 29 |
1948594 | 1948594 | 2021-11-24 | Warren | North Carolina | 37185 | 2456 | 33 |
1948930 | 1948930 | 2021-11-24 | Aguada | Puerto Rico | 72003 | 2456 | |
1941598 | 1941598 | 2021-11-22 | Bates | Missouri | 29013 | 2456 | 56 |
1900396 | 1900396 | 2021-11-09 | Decatur | Tennessee | 47039 | 2456 | 44 |
1867214 | 1867214 | 2021-10-30 | Essex | New York | 36031 | 2456 | 35 |
1859208 | 1859208 | 2021-10-28 | Jefferson | Florida | 12065 | 2456 | 36 |
1855959 | 1855959 | 2021-10-27 | Jefferson | Florida | 12065 | 2456 | 36 |
1852710 | 1852710 | 2021-10-26 | Jefferson | Florida | 12065 | 2456 | 36 |
1849461 | 1849461 | 2021-10-25 | Jefferson | Florida | 12065 | 2456 | 36 |
1846211 | 1846211 | 2021-10-24 | Jefferson | Florida | 12065 | 2456 | 36 |
1842961 | 1842961 | 2021-10-23 | Jefferson | Florida | 12065 | 2456 | 36 |
1839711 | 1839711 | 2021-10-22 | Jefferson | Florida | 12065 | 2456 | 36 |
1836736 | 1836736 | 2021-10-21 | Ford | Illinois | 17053 | 2456 | 67 |
1805456 | 1805456 | 2021-10-11 | San Miguel | New Mexico | 35047 | 2456 | 21 |
1802207 | 1802207 | 2021-10-10 | San Miguel | New Mexico | 35047 | 2456 | 21 |
1798958 | 1798958 | 2021-10-09 | San Miguel | New Mexico | 35047 | 2456 | 21 |
1795709 | 1795709 | 2021-10-08 | San Miguel | New Mexico | 35047 | 2456 | 21 |
1795984 | 1795984 | 2021-10-08 | Meigs | Ohio | 39105 | 2456 | 45 |
1773795 | 1773795 | 2021-10-01 | Colorado | Texas | 48089 | 2456 | 50 |
1758734 | 1758734 | 2021-09-27 | Bond | Illinois | 17005 | 2456 | 29 |
1758904 | 1758904 | 2021-09-27 | Rush | Indiana | 18139 | 2456 | 30 |
1757655 | 1757655 | 2021-09-26 | Llano | Texas | 48299 | 2456 | 66 |
1754407 | 1754407 | 2021-09-25 | Llano | Texas | 48299 | 2456 | 66 |
1747397 | 1747397 | 2021-09-23 | Wasco | Oregon | 41065 | 2456 | 39 |
1743500 | 1743500 | 2021-09-22 | Wright | Missouri | 29229 | 2456 | 46 |
1719750 | 1719750 | 2021-09-15 | Cass | Illinois | 17017 | 2456 | 37 |
1717897 | 1717897 | 2021-09-14 | Yancey | North Carolina | 37199 | 2456 | 28 |
1688099 | 1688099 | 2021-09-05 | Holmes | Mississippi | 28051 | 2456 | 81 |
1684849 | 1684849 | 2021-09-04 | Holmes | Mississippi | 28051 | 2456 | 81 |
1681598 | 1681598 | 2021-09-03 | Holmes | Mississippi | 28051 | 2456 | 81 |
1669780 | 1669780 | 2021-08-30 | Unicoi | Tennessee | 47171 | 2456 | 54 |
1665841 | 1665841 | 2021-08-29 | Caswell | North Carolina | 37033 | 2456 | 31 |
1662593 | 1662593 | 2021-08-28 | Caswell | North Carolina | 37033 | 2456 | 31 |
1659345 | 1659345 | 2021-08-27 | Caswell | North Carolina | 37033 | 2456 | 31 |
1644200 | 1644200 | 2021-08-22 | Orange | Virginia | 51137 | 2456 | 40 |
1640950 | 1640950 | 2021-08-21 | Orange | Virginia | 51137 | 2456 | 40 |
1637700 | 1637700 | 2021-08-20 | Orange | Virginia | 51137 | 2456 | 40 |
1623600 | 1623600 | 2021-08-16 | Ashe | North Carolina | 37009 | 2456 | 45 |
1609820 | 1609820 | 2021-08-12 | Woodford | Kentucky | 21239 | 2456 | 22 |
1597113 | 1597113 | 2021-08-08 | Waseca | Minnesota | 27161 | 2456 | 23 |
1593864 | 1593864 | 2021-08-07 | Waseca | Minnesota | 27161 | 2456 | 23 |
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);