ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
124 rows where cases = 4287 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 14
- Missouri 11
- Illinois 9
- Texas 9
- North Carolina 8
- Kansas 7
- Tennessee 7
- South Dakota 6
- Indiana 4
- Louisiana 4
- Ohio 4
- Virginia 4
- West Virginia 4
- Iowa 3
- Michigan 3
- Mississippi 3
- Oregon 3
- Pennsylvania 3
- Georgia 2
- Idaho 2
- Kentucky 2
- North Dakota 2
- Alabama 1
- Arkansas 1
- Delaware 1
- Florida 1
- Maryland 1
- New Mexico 1
- Puerto Rico 1
- Utah 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2483895 | 2483895 | 2022-05-08 | Carroll | Illinois | 17015 | 4287 | 49 |
2480637 | 2480637 | 2022-05-07 | Carroll | Illinois | 17015 | 4287 | 49 |
2477379 | 2477379 | 2022-05-06 | Carroll | Illinois | 17015 | 4287 | 49 |
2466881 | 2466881 | 2022-05-02 | Morgan | West Virginia | 54065 | 4287 | 69 |
2304174 | 2304174 | 2022-03-13 | Wetzel | West Virginia | 54103 | 4287 | 81 |
2300922 | 2300922 | 2022-03-12 | Wetzel | West Virginia | 54103 | 4287 | 81 |
2297670 | 2297670 | 2022-03-11 | Wetzel | West Virginia | 54103 | 4287 | 81 |
2287529 | 2287529 | 2022-03-08 | Lamb | Texas | 48279 | 4287 | 122 |
2280754 | 2280754 | 2022-03-06 | Hughes | South Dakota | 46065 | 4287 | 58 |
2277501 | 2277501 | 2022-03-05 | Hughes | South Dakota | 46065 | 4287 | 58 |
2274248 | 2274248 | 2022-03-04 | Hughes | South Dakota | 46065 | 4287 | 58 |
2246344 | 2246344 | 2022-02-24 | Bond | Illinois | 17005 | 4287 | 35 |
2238929 | 2238929 | 2022-02-21 | Bristol city | Virginia | 51520 | 4287 | 67 |
2219869 | 2219869 | 2022-02-16 | Grant | Arkansas | 5053 | 4287 | 56 |
2167151 | 2167151 | 2022-01-30 | Gonzales | Texas | 48177 | 4287 | 92 |
2142794 | 2142794 | 2022-01-23 | Concordia | Louisiana | 22029 | 4287 | 81 |
2139539 | 2139539 | 2022-01-22 | Concordia | Louisiana | 22029 | 4287 | 81 |
2136283 | 2136283 | 2022-01-21 | Concordia | Louisiana | 22029 | 4287 | 81 |
2118939 | 2118939 | 2022-01-16 | Randolph | Alabama | 1111 | 4287 | 69 |
2119663 | 2119663 | 2022-01-16 | Starke | Indiana | 18149 | 4287 | 89 |
2116411 | 2116411 | 2022-01-15 | Starke | Indiana | 18149 | 4287 | 89 |
2113160 | 2113160 | 2022-01-14 | Starke | Indiana | 18149 | 4287 | 89 |
2106496 | 2106496 | 2022-01-12 | Crawford | Illinois | 17033 | 4287 | 53 |
2105418 | 2105418 | 2022-01-11 | Milam | Texas | 48331 | 4287 | 92 |
2098504 | 2098504 | 2022-01-09 | Manati | Puerto Rico | 72091 | 4287 | |
2055360 | 2055360 | 2021-12-27 | Adair | Missouri | 29001 | 4287 | 48 |
2052110 | 2052110 | 2021-12-26 | Adair | Missouri | 29001 | 4287 | 48 |
2048860 | 2048860 | 2021-12-25 | Adair | Missouri | 29001 | 4287 | 48 |
2045610 | 2045610 | 2021-12-24 | Adair | Missouri | 29001 | 4287 | 48 |
2042360 | 2042360 | 2021-12-23 | Adair | Missouri | 29001 | 4287 | 48 |
2039111 | 2039111 | 2021-12-22 | Adair | Missouri | 29001 | 4287 | 48 |
2017339 | 2017339 | 2021-12-15 | Davison | South Dakota | 46035 | 4287 | 71 |
2013793 | 2013793 | 2021-12-14 | Jackson | Oklahoma | 40065 | 4287 | 89 |
2008952 | 2008952 | 2021-12-13 | Payette | Idaho | 16075 | 4287 | 72 |
2010542 | 2010542 | 2021-12-13 | Jackson | Oklahoma | 40065 | 4287 | 89 |
2007291 | 2007291 | 2021-12-12 | Jackson | Oklahoma | 40065 | 4287 | 89 |
2004040 | 2004040 | 2021-12-11 | Jackson | Oklahoma | 40065 | 4287 | 89 |
2000789 | 2000789 | 2021-12-10 | Jackson | Oklahoma | 40065 | 4287 | 89 |
2001358 | 2001358 | 2021-12-10 | Karnes | Texas | 48255 | 4287 | 58 |
1997539 | 1997539 | 2021-12-09 | Jackson | Oklahoma | 40065 | 4287 | 89 |
1994288 | 1994288 | 2021-12-08 | Jackson | Oklahoma | 40065 | 4287 | 89 |
1991462 | 1991462 | 2021-12-07 | Smith | Tennessee | 47159 | 4287 | 55 |
1973095 | 1973095 | 2021-12-02 | Monroe | Georgia | 13207 | 4287 | 153 |
1970814 | 1970814 | 2021-12-01 | Marion | Mississippi | 28091 | 4287 | 112 |
1965774 | 1965774 | 2021-11-29 | Washington | Vermont | 50023 | 4287 | 28 |
1882181 | 1882181 | 2021-11-04 | Jerome | Idaho | 16053 | 4287 | 52 |
1844109 | 1844109 | 2021-10-23 | Barry | Missouri | 29009 | 4287 | 60 |
1837539 | 1837539 | 2021-10-21 | Covington | Mississippi | 28031 | 4287 | 94 |
1821915 | 1821915 | 2021-10-16 | Stutsman | North Dakota | 38093 | 4287 | 85 |
1720189 | 1720189 | 2021-09-15 | Harlan | Kentucky | 21095 | 4287 | 101 |
1691365 | 1691365 | 2021-09-06 | Leflore | Mississippi | 28083 | 4287 | 137 |
1653494 | 1653494 | 2021-08-25 | Henderson | Tennessee | 47077 | 4287 | 80 |
1650005 | 1650005 | 2021-08-24 | Venango | Pennsylvania | 42121 | 4287 | 105 |
1650247 | 1650247 | 2021-08-24 | Henderson | Tennessee | 47077 | 4287 | 80 |
1625568 | 1625568 | 2021-08-17 | Fulton | Illinois | 17057 | 4287 | 69 |
1597021 | 1597021 | 2021-08-08 | Sanilac | Michigan | 26151 | 4287 | 126 |
1593772 | 1593772 | 2021-08-07 | Sanilac | Michigan | 26151 | 4287 | 126 |
1590523 | 1590523 | 2021-08-06 | Sanilac | Michigan | 26151 | 4287 | 126 |
1578454 | 1578454 | 2021-08-02 | Josephine | Oregon | 41033 | 4287 | 75 |
1574964 | 1574964 | 2021-08-01 | Yadkin | North Carolina | 37197 | 4287 | 56 |
1571716 | 1571716 | 2021-07-31 | Yadkin | North Carolina | 37197 | 4287 | 56 |
1568468 | 1568468 | 2021-07-30 | Yadkin | North Carolina | 37197 | 4287 | 56 |
1552848 | 1552848 | 2021-07-25 | Weakley | Tennessee | 47183 | 4287 | 69 |
1549601 | 1549601 | 2021-07-24 | Weakley | Tennessee | 47183 | 4287 | 69 |
1546354 | 1546354 | 2021-07-23 | Weakley | Tennessee | 47183 | 4287 | 69 |
1519332 | 1519332 | 2021-07-15 | Phelps | Missouri | 29161 | 4287 | 137 |
1491399 | 1491399 | 2021-07-06 | Wharton | Texas | 48481 | 4287 | 118 |
1488152 | 1488152 | 2021-07-05 | Wharton | Texas | 48481 | 4287 | 118 |
1484905 | 1484905 | 2021-07-04 | Wharton | Texas | 48481 | 4287 | 118 |
1473884 | 1473884 | 2021-07-01 | Platte | Missouri | 29165 | 4287 | 49 |
1377128 | 1377128 | 2021-06-01 | Logan | Oklahoma | 40083 | 4287 | 64 |
1373882 | 1373882 | 2021-05-31 | Logan | Oklahoma | 40083 | 4287 | 64 |
1370637 | 1370637 | 2021-05-30 | Logan | Oklahoma | 40083 | 4287 | 64 |
1365959 | 1365959 | 2021-05-29 | Montgomery | Indiana | 18107 | 4287 | 91 |
1367391 | 1367391 | 2021-05-29 | Logan | Oklahoma | 40083 | 4287 | 64 |
1364145 | 1364145 | 2021-05-28 | Logan | Oklahoma | 40083 | 4287 | 64 |
1360899 | 1360899 | 2021-05-27 | Logan | Oklahoma | 40083 | 4287 | 64 |
1357542 | 1357542 | 2021-05-26 | Defiance | Ohio | 39039 | 4287 | 97 |
1357653 | 1357653 | 2021-05-26 | Logan | Oklahoma | 40083 | 4287 | 64 |
1330438 | 1330438 | 2021-05-18 | Lyon | Kansas | 20111 | 4287 | 85 |
1327191 | 1327191 | 2021-05-17 | Lyon | Kansas | 20111 | 4287 | 85 |
1323945 | 1323945 | 2021-05-16 | Lyon | Kansas | 20111 | 4287 | 85 |
1320699 | 1320699 | 2021-05-15 | Lyon | Kansas | 20111 | 4287 | 85 |
1317452 | 1317452 | 2021-05-14 | Lyon | Kansas | 20111 | 4287 | 85 |
1308889 | 1308889 | 2021-05-11 | Putnam | Ohio | 39137 | 4287 | 100 |
1297907 | 1297907 | 2021-05-08 | Wapello | Iowa | 19179 | 4287 | 122 |
1300060 | 1300060 | 2021-05-08 | Shenandoah | Virginia | 51171 | 4287 | 131 |
1294661 | 1294661 | 2021-05-07 | Wapello | Iowa | 19179 | 4287 | 122 |
1269750 | 1269750 | 2021-04-29 | Haywood | North Carolina | 37087 | 4287 | 95 |
1260329 | 1260329 | 2021-04-26 | Bedford | Pennsylvania | 42009 | 4287 | 131 |
1209046 | 1209046 | 2021-04-10 | Campbell | Virginia | 51031 | 4287 | 82 |
1193736 | 1193736 | 2021-04-06 | Franklin | Illinois | 17055 | 4287 | 82 |
1191039 | 1191039 | 2021-04-05 | Washington | Louisiana | 22117 | 4287 | 127 |
1109337 | 1109337 | 2021-03-11 | Livingston | Illinois | 17105 | 4287 | 91 |
1109549 | 1109549 | 2021-03-11 | Muscatine | Iowa | 19139 | 4287 | 93 |
1085765 | 1085765 | 2021-03-03 | Washington | Virginia | 51191 | 4287 | 98 |
1053162 | 1053162 | 2021-02-21 | Wasatch | Utah | 49051 | 4287 | 19 |
1048844 | 1048844 | 2021-02-20 | Otero | New Mexico | 35035 | 4287 | 54 |
974418 | 974418 | 2021-01-28 | Williams | North Dakota | 38105 | 4287 | 35 |
974635 | 974635 | 2021-01-28 | Carbon | Pennsylvania | 42025 | 4287 | 122 |
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);