ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
147 rows where cases = 4136 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Carolina 19
- Kentucky 15
- Oklahoma 10
- Colorado 8
- Minnesota 8
- Iowa 7
- Virginia 6
- Arkansas 5
- Nebraska 5
- New York 5
- Texas 5
- Alabama 4
- Indiana 4
- Louisiana 4
- Puerto Rico 4
- West Virginia 4
- Georgia 3
- California 2
- Florida 2
- Illinois 2
- Michigan 2
- Missouri 2
- New Hampshire 2
- Ohio 2
- Pennsylvania 2
- South Dakota 2
- Tennessee 2
- Utah 2
- Wisconsin 2
- Connecticut 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2446138 | 2446138 | 2022-04-26 | Chowan | North Carolina | 37041 | 4136 | 56 |
2442883 | 2442883 | 2022-04-25 | Chowan | North Carolina | 37041 | 4136 | 56 |
2439627 | 2439627 | 2022-04-24 | Chowan | North Carolina | 37041 | 4136 | 56 |
2436371 | 2436371 | 2022-04-23 | Chowan | North Carolina | 37041 | 4136 | 56 |
2433115 | 2433115 | 2022-04-22 | Chowan | North Carolina | 37041 | 4136 | 56 |
2429859 | 2429859 | 2022-04-21 | Chowan | North Carolina | 37041 | 4136 | 56 |
2426603 | 2426603 | 2022-04-20 | Chowan | North Carolina | 37041 | 4136 | 56 |
2376652 | 2376652 | 2022-04-05 | Cedar | Iowa | 19031 | 4136 | 35 |
2373400 | 2373400 | 2022-04-04 | Cedar | Iowa | 19031 | 4136 | 35 |
2370147 | 2370147 | 2022-04-03 | Cedar | Iowa | 19031 | 4136 | 35 |
2370353 | 2370353 | 2022-04-03 | Caldwell | Kentucky | 21033 | 4136 | 59 |
2366894 | 2366894 | 2022-04-02 | Cedar | Iowa | 19031 | 4136 | 35 |
2367100 | 2367100 | 2022-04-02 | Caldwell | Kentucky | 21033 | 4136 | 59 |
2363641 | 2363641 | 2022-04-01 | Cedar | Iowa | 19031 | 4136 | 35 |
2363847 | 2363847 | 2022-04-01 | Caldwell | Kentucky | 21033 | 4136 | 59 |
2360387 | 2360387 | 2022-03-31 | Cedar | Iowa | 19031 | 4136 | 35 |
2360593 | 2360593 | 2022-03-31 | Caldwell | Kentucky | 21033 | 4136 | 59 |
2357133 | 2357133 | 2022-03-30 | Cedar | Iowa | 19031 | 4136 | 35 |
2357339 | 2357339 | 2022-03-30 | Caldwell | Kentucky | 21033 | 4136 | 59 |
2354086 | 2354086 | 2022-03-29 | Caldwell | Kentucky | 21033 | 4136 | 59 |
2350834 | 2350834 | 2022-03-28 | Caldwell | Kentucky | 21033 | 4136 | 59 |
2347581 | 2347581 | 2022-03-27 | Caldwell | Kentucky | 21033 | 4136 | 59 |
2344328 | 2344328 | 2022-03-26 | Caldwell | Kentucky | 21033 | 4136 | 59 |
2341075 | 2341075 | 2022-03-25 | Caldwell | Kentucky | 21033 | 4136 | 59 |
2337822 | 2337822 | 2022-03-24 | Caldwell | Kentucky | 21033 | 4136 | 59 |
2334568 | 2334568 | 2022-03-23 | Caldwell | Kentucky | 21033 | 4136 | 59 |
2331314 | 2331314 | 2022-03-22 | Caldwell | Kentucky | 21033 | 4136 | 59 |
2328062 | 2328062 | 2022-03-21 | Caldwell | Kentucky | 21033 | 4136 | 59 |
2301424 | 2301424 | 2022-03-13 | Brantley | Georgia | 13025 | 4136 | 103 |
2298172 | 2298172 | 2022-03-12 | Brantley | Georgia | 13025 | 4136 | 103 |
2294920 | 2294920 | 2022-03-11 | Brantley | Georgia | 13025 | 4136 | 103 |
2233026 | 2233026 | 2022-02-20 | Otero | Colorado | 8089 | 4136 | 125 |
2229775 | 2229775 | 2022-02-19 | Otero | Colorado | 8089 | 4136 | 125 |
2226524 | 2226524 | 2022-02-18 | Otero | Colorado | 8089 | 4136 | 125 |
2196123 | 2196123 | 2022-02-08 | Yabucoa | Puerto Rico | 72151 | 4136 | |
2191705 | 2191705 | 2022-02-07 | Antrim | Michigan | 26009 | 4136 | 55 |
2169084 | 2169084 | 2022-01-31 | Roseau | Minnesota | 27135 | 4136 | 40 |
2153177 | 2153177 | 2022-01-26 | Washington | Nebraska | 31177 | 4136 | 31 |
2148304 | 2148304 | 2022-01-25 | Hempstead | Arkansas | 5057 | 4136 | 51 |
2144044 | 2144044 | 2022-01-23 | Morovis | Puerto Rico | 72101 | 4136 | |
2062584 | 2062584 | 2021-12-29 | Unknown | Oklahoma | 4136 | 2 | |
2028149 | 2028149 | 2021-12-19 | Montezuma | Colorado | 8083 | 4136 | 51 |
2024898 | 2024898 | 2021-12-18 | Montezuma | Colorado | 8083 | 4136 | 51 |
2021647 | 2021647 | 2021-12-17 | Montezuma | Colorado | 8083 | 4136 | 51 |
2018231 | 2018231 | 2021-12-16 | Cleburne | Arkansas | 5023 | 4136 | 97 |
2021212 | 2021212 | 2021-12-16 | Boone | West Virginia | 54005 | 4136 | 62 |
2017984 | 2017984 | 2021-12-15 | Mason | West Virginia | 54053 | 4136 | 64 |
2014586 | 2014586 | 2021-12-14 | Gloucester | Virginia | 51073 | 4136 | 82 |
1923710 | 1923710 | 2021-11-16 | Jackson | West Virginia | 54035 | 4136 | 88 |
1861142 | 1861142 | 2021-10-28 | Elk | Pennsylvania | 42047 | 4136 | 56 |
1814161 | 1814161 | 2021-10-14 | White | Indiana | 18181 | 4136 | 63 |
1815973 | 1815973 | 2021-10-14 | Smith | Tennessee | 47159 | 4136 | 50 |
1764824 | 1764824 | 2021-09-29 | Glenn | California | 6021 | 4136 | 37 |
1744647 | 1744647 | 2021-09-22 | Kleberg | Texas | 48273 | 4136 | 121 |
1721065 | 1721065 | 2021-09-15 | Cherokee | North Carolina | 37039 | 4136 | 55 |
1693764 | 1693764 | 2021-09-07 | Bureau | Illinois | 17011 | 4136 | 99 |
1633289 | 1633289 | 2021-08-19 | Cortland | New York | 36023 | 4136 | 65 |
1630139 | 1630139 | 2021-08-18 | Jackson | North Carolina | 37099 | 4136 | 56 |
1619844 | 1619844 | 2021-08-15 | Steele | Minnesota | 27147 | 4136 | 19 |
1616596 | 1616596 | 2021-08-14 | Steele | Minnesota | 27147 | 4136 | 19 |
1613348 | 1613348 | 2021-08-13 | Steele | Minnesota | 27147 | 4136 | 19 |
1605100 | 1605100 | 2021-08-10 | Sanpete | Utah | 49039 | 4136 | 25 |
1597084 | 1597084 | 2021-08-08 | Nobles | Minnesota | 27105 | 4136 | 50 |
1598655 | 1598655 | 2021-08-08 | Charlottesville city | Virginia | 51540 | 4136 | 58 |
1593835 | 1593835 | 2021-08-07 | Nobles | Minnesota | 27105 | 4136 | 50 |
1595406 | 1595406 | 2021-08-07 | Charlottesville city | Virginia | 51540 | 4136 | 58 |
1590586 | 1590586 | 2021-08-06 | Nobles | Minnesota | 27105 | 4136 | 50 |
1592157 | 1592157 | 2021-08-06 | Charlottesville city | Virginia | 51540 | 4136 | 58 |
1565002 | 1565002 | 2021-07-29 | Grafton | New Hampshire | 33009 | 4136 | 29 |
1565462 | 1565462 | 2021-07-29 | Josephine | Oregon | 41033 | 4136 | 75 |
1488715 | 1488715 | 2021-07-06 | Union | Arkansas | 5139 | 4136 | 115 |
1485468 | 1485468 | 2021-07-05 | Union | Arkansas | 5139 | 4136 | 115 |
1487290 | 1487290 | 2021-07-05 | Yadkin | North Carolina | 37197 | 4136 | 55 |
1484044 | 1484044 | 2021-07-04 | Yadkin | North Carolina | 37197 | 4136 | 55 |
1484429 | 1484429 | 2021-07-04 | Ponce | Puerto Rico | 72113 | 4136 | |
1480798 | 1480798 | 2021-07-03 | Yadkin | North Carolina | 37197 | 4136 | 55 |
1481183 | 1481183 | 2021-07-03 | Ponce | Puerto Rico | 72113 | 4136 | |
1477551 | 1477551 | 2021-07-02 | Yadkin | North Carolina | 37197 | 4136 | 55 |
1474305 | 1474305 | 2021-07-01 | Yadkin | North Carolina | 37197 | 4136 | 55 |
1471059 | 1471059 | 2021-06-30 | Yadkin | North Carolina | 37197 | 4136 | 55 |
1466091 | 1466091 | 2021-06-29 | La Plata | Colorado | 8067 | 4136 | 41 |
1467814 | 1467814 | 2021-06-29 | Yadkin | North Carolina | 37197 | 4136 | 55 |
1464569 | 1464569 | 2021-06-28 | Yadkin | North Carolina | 37197 | 4136 | 55 |
1426929 | 1426929 | 2021-06-17 | Tallapoosa | Alabama | 1123 | 4136 | 155 |
1423683 | 1423683 | 2021-06-16 | Tallapoosa | Alabama | 1123 | 4136 | 155 |
1422700 | 1422700 | 2021-06-15 | Wayne | Pennsylvania | 42127 | 4136 | 82 |
1418788 | 1418788 | 2021-06-14 | Silver Bow | Montana | 30093 | 4136 | 86 |
1402681 | 1402681 | 2021-06-09 | Belknap | New Hampshire | 33001 | 4136 | 100 |
1392855 | 1392855 | 2021-06-06 | Dakota | Nebraska | 31043 | 4136 | 82 |
1389610 | 1389610 | 2021-06-05 | Dakota | Nebraska | 31043 | 4136 | 82 |
1386365 | 1386365 | 2021-06-04 | Dakota | Nebraska | 31043 | 4136 | 82 |
1383120 | 1383120 | 2021-06-03 | Dakota | Nebraska | 31043 | 4136 | 82 |
1379694 | 1379694 | 2021-06-02 | Camden | Missouri | 29029 | 4136 | 88 |
1377154 | 1377154 | 2021-06-01 | Sequoyah | Oklahoma | 40135 | 4136 | 56 |
1373908 | 1373908 | 2021-05-31 | Sequoyah | Oklahoma | 40135 | 4136 | 56 |
1370663 | 1370663 | 2021-05-30 | Sequoyah | Oklahoma | 40135 | 4136 | 56 |
1367417 | 1367417 | 2021-05-29 | Sequoyah | Oklahoma | 40135 | 4136 | 56 |
1364171 | 1364171 | 2021-05-28 | Sequoyah | Oklahoma | 40135 | 4136 | 56 |
1360925 | 1360925 | 2021-05-27 | Sequoyah | Oklahoma | 40135 | 4136 | 56 |
1361570 | 1361570 | 2021-05-27 | Washington | Texas | 48477 | 4136 | 93 |
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);