ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
173 rows where cases = 2821 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 23
- Mississippi 14
- Louisiana 11
- Kentucky 9
- Arkansas 7
- Georgia 7
- Illinois 7
- Kansas 7
- Ohio 7
- Alabama 6
- Indiana 6
- Virginia 6
- Maine 5
- Missouri 5
- Minnesota 4
- North Carolina 4
- Pennsylvania 4
- South Carolina 4
- Tennessee 4
- West Virginia 4
- California 3
- Maryland 3
- Puerto Rico 3
- Florida 2
- Iowa 2
- Michigan 2
- Oklahoma 2
- Washington 2
- Arizona 1
- Colorado 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2485652 | 2485652 | 2022-05-08 | Florida | Puerto Rico | 72054 | 2821 | |
2482394 | 2482394 | 2022-05-07 | Florida | Puerto Rico | 72054 | 2821 | |
2451671 | 2451671 | 2022-04-28 | Linn | Kansas | 20107 | 2821 | 28 |
2448415 | 2448415 | 2022-04-27 | Linn | Kansas | 20107 | 2821 | 28 |
2445159 | 2445159 | 2022-04-26 | Linn | Kansas | 20107 | 2821 | 28 |
2446905 | 2446905 | 2022-04-26 | Eastland | Texas | 48133 | 2821 | 113 |
2441903 | 2441903 | 2022-04-25 | Linn | Kansas | 20107 | 2821 | 28 |
2443650 | 2443650 | 2022-04-25 | Eastland | Texas | 48133 | 2821 | 113 |
2438647 | 2438647 | 2022-04-24 | Linn | Kansas | 20107 | 2821 | 28 |
2440394 | 2440394 | 2022-04-24 | Eastland | Texas | 48133 | 2821 | 113 |
2435391 | 2435391 | 2022-04-23 | Linn | Kansas | 20107 | 2821 | 28 |
2437138 | 2437138 | 2022-04-23 | Eastland | Texas | 48133 | 2821 | 113 |
2432135 | 2432135 | 2022-04-22 | Linn | Kansas | 20107 | 2821 | 28 |
2433882 | 2433882 | 2022-04-22 | Eastland | Texas | 48133 | 2821 | 113 |
2430626 | 2430626 | 2022-04-21 | Eastland | Texas | 48133 | 2821 | 113 |
2427370 | 2427370 | 2022-04-20 | Eastland | Texas | 48133 | 2821 | 113 |
2424114 | 2424114 | 2022-04-19 | Eastland | Texas | 48133 | 2821 | 113 |
2420858 | 2420858 | 2022-04-18 | Eastland | Texas | 48133 | 2821 | 113 |
2398239 | 2398239 | 2022-04-11 | Ward | Texas | 48475 | 2821 | 43 |
2394984 | 2394984 | 2022-04-10 | Ward | Texas | 48475 | 2821 | 43 |
2287760 | 2287760 | 2022-03-08 | Lexington city | Virginia | 51678 | 2821 | 39 |
2279442 | 2279442 | 2022-03-06 | West Feliciana | Louisiana | 22125 | 2821 | 43 |
2276189 | 2276189 | 2022-03-05 | West Feliciana | Louisiana | 22125 | 2821 | 43 |
2272936 | 2272936 | 2022-03-04 | West Feliciana | Louisiana | 22125 | 2821 | 43 |
2269684 | 2269684 | 2022-03-03 | West Feliciana | Louisiana | 22125 | 2821 | 43 |
2265494 | 2265494 | 2022-03-02 | Archuleta | Colorado | 8007 | 2821 | 14 |
2266431 | 2266431 | 2022-03-02 | West Feliciana | Louisiana | 22125 | 2821 | 43 |
2219749 | 2219749 | 2022-02-16 | Conecuh | Alabama | 1035 | 2821 | 63 |
2217929 | 2217929 | 2022-02-15 | Jefferson Davis | Mississippi | 28065 | 2821 | 49 |
2200368 | 2200368 | 2022-02-10 | Lee | Arkansas | 5077 | 2821 | 55 |
2137467 | 2137467 | 2022-01-21 | Potter | Pennsylvania | 42105 | 2821 | 81 |
2126500 | 2126500 | 2022-01-18 | Trigg | Kentucky | 21221 | 2821 | 32 |
2126772 | 2126772 | 2022-01-18 | Pennington | Minnesota | 27113 | 2821 | 34 |
2128061 | 2128061 | 2022-01-18 | Comanche | Texas | 48093 | 2821 | 69 |
2121929 | 2121929 | 2022-01-16 | Southampton | Virginia | 51175 | 2821 | 75 |
2118677 | 2118677 | 2022-01-15 | Southampton | Virginia | 51175 | 2821 | 75 |
2115425 | 2115425 | 2022-01-14 | Southampton | Virginia | 51175 | 2821 | 75 |
2062008 | 2062008 | 2021-12-29 | Park | Montana | 30067 | 2821 | 31 |
2058260 | 2058260 | 2021-12-28 | LaSalle | Louisiana | 22059 | 2821 | 46 |
2051232 | 2051232 | 2021-12-26 | De Witt | Illinois | 17039 | 2821 | 39 |
2047982 | 2047982 | 2021-12-25 | De Witt | Illinois | 17039 | 2821 | 39 |
2044732 | 2044732 | 2021-12-24 | De Witt | Illinois | 17039 | 2821 | 39 |
2041483 | 2041483 | 2021-12-23 | De Witt | Illinois | 17039 | 2821 | 39 |
2035561 | 2035561 | 2021-12-21 | Sagadahoc | Maine | 23023 | 2821 | 18 |
2019723 | 2019723 | 2021-12-16 | Wright | Missouri | 29229 | 2821 | 66 |
1973749 | 1973749 | 2021-12-02 | Jackson | Louisiana | 22049 | 2821 | 64 |
1973993 | 1973993 | 2021-12-02 | Redwood | Minnesota | 27127 | 2821 | 45 |
1970140 | 1970140 | 2021-12-01 | Vermillion | Indiana | 18165 | 2821 | 58 |
1968147 | 1968147 | 2021-11-30 | Richland | North Dakota | 38077 | 2821 | 21 |
1960801 | 1960801 | 2021-11-28 | Waldo | Maine | 23027 | 2821 | 36 |
1957550 | 1957550 | 2021-11-27 | Waldo | Maine | 23027 | 2821 | 36 |
1954299 | 1954299 | 2021-11-26 | Waldo | Maine | 23027 | 2821 | 36 |
1951048 | 1951048 | 2021-11-25 | Waldo | Maine | 23027 | 2821 | 36 |
1925101 | 1925101 | 2021-11-17 | Charlevoix | Michigan | 26029 | 2821 | 41 |
1910694 | 1910694 | 2021-11-12 | Barbour | West Virginia | 54001 | 2821 | 46 |
1871519 | 1871519 | 2021-10-31 | Orleans | Vermont | 50019 | 2821 | 14 |
1819739 | 1819739 | 2021-10-15 | McDowell | West Virginia | 54047 | 2821 | 44 |
1773894 | 1773894 | 2021-10-01 | Lee | Texas | 48287 | 2821 | 48 |
1756308 | 1756308 | 2021-09-26 | Clarke | Mississippi | 28023 | 2821 | 90 |
1753060 | 1753060 | 2021-09-25 | Clarke | Mississippi | 28023 | 2821 | 90 |
1749812 | 1749812 | 2021-09-24 | Clarke | Mississippi | 28023 | 2821 | 90 |
1733562 | 1733562 | 2021-09-19 | Chickasaw | Mississippi | 28017 | 2821 | 64 |
1730312 | 1730312 | 2021-09-18 | Chickasaw | Mississippi | 28017 | 2821 | 64 |
1727062 | 1727062 | 2021-09-17 | Chickasaw | Mississippi | 28017 | 2821 | 64 |
1709267 | 1709267 | 2021-09-11 | Jackson | West Virginia | 54035 | 2821 | 64 |
1699846 | 1699846 | 2021-09-09 | Colusa | California | 6011 | 2821 | 18 |
1669488 | 1669488 | 2021-08-30 | Susquehanna | Pennsylvania | 42115 | 2821 | 62 |
1656262 | 1656262 | 2021-08-26 | Gallia | Ohio | 39053 | 2821 | 51 |
1648080 | 1648080 | 2021-08-24 | Berrien | Georgia | 13019 | 2821 | 51 |
1643546 | 1643546 | 2021-08-22 | Gurabo | Puerto Rico | 72063 | 2821 | |
1631436 | 1631436 | 2021-08-19 | Barbour | Alabama | 1005 | 2821 | 65 |
1619467 | 1619467 | 2021-08-15 | Carter | Kentucky | 21043 | 2821 | 37 |
1620866 | 1620866 | 2021-08-15 | Barnwell | South Carolina | 45011 | 2821 | 58 |
1616219 | 1616219 | 2021-08-14 | Carter | Kentucky | 21043 | 2821 | 37 |
1617618 | 1617618 | 2021-08-14 | Barnwell | South Carolina | 45011 | 2821 | 58 |
1612970 | 1612970 | 2021-08-13 | Carter | Kentucky | 21043 | 2821 | 37 |
1614370 | 1614370 | 2021-08-13 | Barnwell | South Carolina | 45011 | 2821 | 58 |
1606198 | 1606198 | 2021-08-11 | LaGrange | Indiana | 18087 | 2821 | 75 |
1606492 | 1606492 | 2021-08-11 | Grant | Kentucky | 21081 | 2821 | 25 |
1579237 | 1579237 | 2021-08-02 | Pulaski | Virginia | 51155 | 2821 | 69 |
1563666 | 1563666 | 2021-07-29 | Franklin | Georgia | 13119 | 2821 | 57 |
1511096 | 1511096 | 2021-07-12 | Okanogan | Washington | 53047 | 2821 | 43 |
1506370 | 1506370 | 2021-07-11 | Stone | Missouri | 29209 | 2821 | 49 |
1461190 | 1461190 | 2021-06-27 | Lewis | New York | 36049 | 2821 | 36 |
1423798 | 1423798 | 2021-06-16 | Sevier | Arkansas | 5133 | 2821 | 24 |
1420550 | 1420550 | 2021-06-15 | Sevier | Arkansas | 5133 | 2821 | 24 |
1417305 | 1417305 | 2021-06-14 | Sevier | Arkansas | 5133 | 2821 | 24 |
1397775 | 1397775 | 2021-06-08 | Carroll | Arkansas | 5015 | 2821 | 46 |
1365035 | 1365035 | 2021-05-28 | Mason | Washington | 53045 | 2821 | 33 |
1356599 | 1356599 | 2021-05-26 | De Soto | Louisiana | 22031 | 2821 | 78 |
1350182 | 1350182 | 2021-05-24 | Dorchester | Maryland | 24019 | 2821 | 51 |
1346936 | 1346936 | 2021-05-23 | Dorchester | Maryland | 24019 | 2821 | 51 |
1336712 | 1336712 | 2021-05-20 | Greene | Indiana | 18055 | 2821 | 89 |
1333465 | 1333465 | 2021-05-19 | Greene | Indiana | 18055 | 2821 | 89 |
1330563 | 1330563 | 2021-05-18 | Marshall | Kentucky | 21157 | 2821 | 57 |
1317904 | 1317904 | 2021-05-14 | Todd | Minnesota | 27153 | 2821 | 32 |
1301316 | 1301316 | 2021-05-09 | Harlan | Kentucky | 21095 | 2821 | 83 |
1298069 | 1298069 | 2021-05-08 | Harlan | Kentucky | 21095 | 2821 | 83 |
1296700 | 1296700 | 2021-05-07 | Accomack | Virginia | 51001 | 2821 | 41 |
1292815 | 1292815 | 2021-05-06 | Elk | Pennsylvania | 42047 | 2821 | 38 |
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);