ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
178 rows where cases = 3456 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 15
- Ohio 14
- Texas 13
- Kentucky 12
- Iowa 10
- Tennessee 10
- Arkansas 8
- Florida 8
- Missouri 8
- West Virginia 7
- Wisconsin 6
- Kansas 5
- Minnesota 5
- Mississippi 5
- Puerto Rico 5
- Washington 5
- California 4
- New York 4
- North Carolina 4
- Connecticut 3
- Indiana 3
- Alabama 2
- Illinois 2
- Louisiana 2
- New Mexico 2
- Oklahoma 2
- Oregon 2
- Pennsylvania 2
- Virginia 2
- Arizona 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2417779 | 2417779 | 2022-04-17 | Wilbarger | Texas | 48487 | 3456 | 87 |
2414523 | 2414523 | 2022-04-16 | Wilbarger | Texas | 48487 | 3456 | 87 |
2411267 | 2411267 | 2022-04-15 | Wilbarger | Texas | 48487 | 3456 | 87 |
2408011 | 2408011 | 2022-04-14 | Wilbarger | Texas | 48487 | 3456 | 87 |
2404755 | 2404755 | 2022-04-13 | Wilbarger | Texas | 48487 | 3456 | 87 |
2376658 | 2376658 | 2022-04-05 | Clayton | Iowa | 19043 | 3456 | 72 |
2373406 | 2373406 | 2022-04-04 | Clayton | Iowa | 19043 | 3456 | 72 |
2370153 | 2370153 | 2022-04-03 | Clayton | Iowa | 19043 | 3456 | 72 |
2372423 | 2372423 | 2022-04-03 | Pacific | Washington | 53049 | 3456 | 57 |
2366900 | 2366900 | 2022-04-02 | Clayton | Iowa | 19043 | 3456 | 72 |
2369170 | 2369170 | 2022-04-02 | Pacific | Washington | 53049 | 3456 | 57 |
2363647 | 2363647 | 2022-04-01 | Clayton | Iowa | 19043 | 3456 | 72 |
2365917 | 2365917 | 2022-04-01 | Pacific | Washington | 53049 | 3456 | 57 |
2360393 | 2360393 | 2022-03-31 | Clayton | Iowa | 19043 | 3456 | 72 |
2357139 | 2357139 | 2022-03-30 | Clayton | Iowa | 19043 | 3456 | 72 |
2358997 | 2358997 | 2022-03-30 | Comanche | Texas | 48093 | 3456 | 78 |
2286160 | 2286160 | 2022-03-08 | Sibley | Minnesota | 27143 | 3456 | 23 |
2282908 | 2282908 | 2022-03-07 | Sibley | Minnesota | 27143 | 3456 | 23 |
2277344 | 2277344 | 2022-03-05 | Anasco | Puerto Rico | 72011 | 3456 | |
2264332 | 2264332 | 2022-03-01 | Aibonito | Puerto Rico | 72009 | 3456 | |
2261082 | 2261082 | 2022-02-28 | Aibonito | Puerto Rico | 72009 | 3456 | |
2256538 | 2256538 | 2022-02-27 | Green | Kentucky | 21087 | 3456 | 40 |
2257831 | 2257831 | 2022-02-27 | Aibonito | Puerto Rico | 72009 | 3456 | |
2253287 | 2253287 | 2022-02-26 | Green | Kentucky | 21087 | 3456 | 40 |
2250036 | 2250036 | 2022-02-25 | Green | Kentucky | 21087 | 3456 | 40 |
2239904 | 2239904 | 2022-02-22 | Menard | Illinois | 17129 | 3456 | 23 |
2220125 | 2220125 | 2022-02-16 | Bacon | Georgia | 13005 | 3456 | 70 |
2178511 | 2178511 | 2022-02-03 | Larue | Kentucky | 21123 | 3456 | 61 |
2170685 | 2170685 | 2022-01-31 | King William | Virginia | 51101 | 3456 | 27 |
2162781 | 2162781 | 2022-01-29 | Ste. Genevieve | Missouri | 29186 | 3456 | 35 |
2155006 | 2155006 | 2022-01-27 | Dixie | Florida | 12029 | 3456 | 52 |
2151753 | 2151753 | 2022-01-26 | Dixie | Florida | 12029 | 3456 | 52 |
2148501 | 2148501 | 2022-01-25 | Dixie | Florida | 12029 | 3456 | 52 |
2145249 | 2145249 | 2022-01-24 | Dixie | Florida | 12029 | 3456 | 52 |
2147895 | 2147895 | 2022-01-24 | Greene | Virginia | 51079 | 3456 | 48 |
2141994 | 2141994 | 2022-01-23 | Dixie | Florida | 12029 | 3456 | 52 |
2138739 | 2138739 | 2022-01-22 | Dixie | Florida | 12029 | 3456 | 52 |
2135483 | 2135483 | 2022-01-21 | Dixie | Florida | 12029 | 3456 | 52 |
2136341 | 2136341 | 2022-01-21 | Lincoln | Maine | 23015 | 3456 | 19 |
2135042 | 2135042 | 2022-01-20 | Taylor | West Virginia | 54091 | 3456 | 56 |
2128542 | 2128542 | 2022-01-18 | Wetzel | West Virginia | 54103 | 3456 | 68 |
2106498 | 2106498 | 2022-01-12 | De Witt | Illinois | 17039 | 3456 | 40 |
2096317 | 2096317 | 2022-01-09 | Colusa | California | 6011 | 3456 | 21 |
2093065 | 2093065 | 2022-01-08 | Colusa | California | 6011 | 3456 | 21 |
2089813 | 2089813 | 2022-01-07 | Colusa | California | 6011 | 3456 | 21 |
2081626 | 2081626 | 2022-01-04 | Washington | Nebraska | 31177 | 3456 | 30 |
2058126 | 2058126 | 2021-12-28 | Breckinridge | Kentucky | 21027 | 3456 | 51 |
2053733 | 2053733 | 2021-12-26 | Lincoln | West Virginia | 54043 | 3456 | 54 |
2050483 | 2050483 | 2021-12-25 | Lincoln | West Virginia | 54043 | 3456 | 54 |
2047233 | 2047233 | 2021-12-24 | Lincoln | West Virginia | 54043 | 3456 | 54 |
2043983 | 2043983 | 2021-12-23 | Lincoln | West Virginia | 54043 | 3456 | 54 |
2031604 | 2031604 | 2021-12-20 | Mitchell | Georgia | 13205 | 3456 | 102 |
2032720 | 2032720 | 2021-12-20 | Texas | Missouri | 29215 | 3456 | 69 |
2029384 | 2029384 | 2021-12-19 | Clinton | Missouri | 29049 | 3456 | 98 |
2029469 | 2029469 | 2021-12-19 | Texas | Missouri | 29215 | 3456 | 69 |
2010303 | 2010303 | 2021-12-13 | Greene | North Carolina | 37079 | 3456 | 56 |
1988954 | 1988954 | 2021-12-07 | La Paz | Arizona | 4012 | 3456 | 105 |
1990745 | 1990745 | 2021-12-07 | Seneca | New York | 36099 | 3456 | 70 |
1971182 | 1971182 | 2021-12-01 | Lincoln | New Mexico | 35027 | 3456 | 40 |
1963632 | 1963632 | 2021-11-29 | Sullivan | Indiana | 18153 | 3456 | 56 |
1966068 | 1966068 | 2021-11-29 | Taylor | Wisconsin | 55119 | 3456 | 48 |
1944337 | 1944337 | 2021-11-23 | Sumner | Kansas | 20191 | 3456 | 62 |
1941087 | 1941087 | 2021-11-22 | Sumner | Kansas | 20191 | 3456 | 62 |
1936993 | 1936993 | 2021-11-21 | Lawrence | Arkansas | 5075 | 3456 | 60 |
1940033 | 1940033 | 2021-11-21 | Langlade | Wisconsin | 55067 | 3456 | 59 |
1936783 | 1936783 | 2021-11-20 | Langlade | Wisconsin | 55067 | 3456 | 59 |
1933533 | 1933533 | 2021-11-19 | Langlade | Wisconsin | 55067 | 3456 | 59 |
1922843 | 1922843 | 2021-11-16 | Lincoln | Oregon | 41041 | 3456 | 49 |
1914569 | 1914569 | 2021-11-14 | Lamar | Georgia | 13171 | 3456 | 96 |
1911319 | 1911319 | 2021-11-13 | Lamar | Georgia | 13171 | 3456 | 96 |
1908070 | 1908070 | 2021-11-12 | Lamar | Georgia | 13171 | 3456 | 96 |
1848778 | 1848778 | 2021-10-24 | Washington | Vermont | 50023 | 3456 | 22 |
1836219 | 1836219 | 2021-10-21 | Arkansas | Arkansas | 5001 | 3456 | 59 |
1810517 | 1810517 | 2021-10-13 | Berrien | Georgia | 13019 | 3456 | 60 |
1799218 | 1799218 | 2021-10-09 | Holmes | Ohio | 39075 | 3456 | 112 |
1796611 | 1796611 | 2021-10-08 | Hutchinson | Texas | 48233 | 3456 | 85 |
1793520 | 1793520 | 2021-10-07 | Sevier | Utah | 49041 | 3456 | 16 |
1733619 | 1733619 | 2021-09-19 | Stone | Mississippi | 28131 | 3456 | 57 |
1730369 | 1730369 | 2021-09-18 | Stone | Mississippi | 28131 | 3456 | 57 |
1727119 | 1727119 | 2021-09-17 | Stone | Mississippi | 28131 | 3456 | 57 |
1721911 | 1721911 | 2021-09-15 | Limestone | Texas | 48293 | 3456 | 99 |
1716319 | 1716319 | 2021-09-14 | Cook | Georgia | 13075 | 3456 | 50 |
1699830 | 1699830 | 2021-09-09 | Sevier | Arkansas | 5133 | 3456 | 31 |
1654115 | 1654115 | 2021-08-25 | Lincoln | Wisconsin | 55069 | 3456 | 100 |
1636979 | 1636979 | 2021-08-20 | Jefferson | Pennsylvania | 42065 | 3456 | 99 |
1608846 | 1608846 | 2021-08-12 | Johnson | Arkansas | 5071 | 3456 | 40 |
1602352 | 1602352 | 2021-08-10 | Lincoln | Arkansas | 5079 | 3456 | 49 |
1596189 | 1596189 | 2021-08-08 | Madison | Georgia | 13195 | 3456 | 56 |
1592940 | 1592940 | 2021-08-07 | Madison | Georgia | 13195 | 3456 | 56 |
1589691 | 1589691 | 2021-08-06 | Madison | Georgia | 13195 | 3456 | 56 |
1582042 | 1582042 | 2021-08-03 | Marion | Tennessee | 47115 | 3456 | 50 |
1555339 | 1555339 | 2021-07-26 | Greene | New York | 36039 | 3456 | 79 |
1497002 | 1497002 | 2021-07-08 | Pasquotank | North Carolina | 37139 | 3456 | 85 |
1493853 | 1493853 | 2021-07-07 | Champaign | Ohio | 39021 | 3456 | 60 |
1490606 | 1490606 | 2021-07-06 | Champaign | Ohio | 39021 | 3456 | 60 |
1487359 | 1487359 | 2021-07-05 | Champaign | Ohio | 39021 | 3456 | 60 |
1484112 | 1484112 | 2021-07-04 | Champaign | Ohio | 39021 | 3456 | 60 |
1480866 | 1480866 | 2021-07-03 | Champaign | Ohio | 39021 | 3456 | 60 |
1477619 | 1477619 | 2021-07-02 | Champaign | Ohio | 39021 | 3456 | 60 |
1456606 | 1456606 | 2021-06-26 | Toombs | Georgia | 13279 | 3456 | 119 |
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);