ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
117 rows where cases = 3304 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 8
- Texas 8
- Missouri 7
- Michigan 6
- Minnesota 6
- North Carolina 6
- Wisconsin 6
- South Carolina 5
- Georgia 4
- Mississippi 4
- New York 4
- Tennessee 4
- Virginia 4
- Arkansas 3
- California 3
- Illinois 3
- South Dakota 3
- Washington 3
- Indiana 2
- Kentucky 2
- Louisiana 2
- Montana 2
- New Jersey 2
- Ohio 2
- Oregon 2
- Pennsylvania 2
- Puerto Rico 2
- West Virginia 2
- Alabama 1
- Colorado 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449281 | 2449281 | 2022-04-27 | Unknown | New Jersey | 3304 | 0 | |
2440858 | 2440858 | 2022-04-24 | Ashland | Wisconsin | 55003 | 3304 | 36 |
2437602 | 2437602 | 2022-04-23 | Ashland | Wisconsin | 55003 | 3304 | 36 |
2434346 | 2434346 | 2022-04-22 | Ashland | Wisconsin | 55003 | 3304 | 36 |
2408300 | 2408300 | 2022-04-14 | Bayfield | Wisconsin | 55007 | 3304 | 40 |
2341872 | 2341872 | 2022-03-25 | Unknown | New Jersey | 3304 | 0 | |
2290996 | 2290996 | 2022-03-09 | Greensville | Virginia | 51081 | 3304 | 37 |
2274444 | 2274444 | 2022-03-04 | Duval | Texas | 48131 | 3304 | 68 |
2270033 | 2270033 | 2022-03-03 | Gasconade | Missouri | 29073 | 3304 | 94 |
2247796 | 2247796 | 2022-02-24 | Walsh | North Dakota | 38099 | 3304 | 34 |
2191554 | 2191554 | 2022-02-07 | Pendleton | Kentucky | 21191 | 3304 | 33 |
2189627 | 2189627 | 2022-02-06 | Bamberg | South Carolina | 45009 | 3304 | 68 |
2186374 | 2186374 | 2022-02-05 | Bamberg | South Carolina | 45009 | 3304 | 68 |
2183122 | 2183122 | 2022-02-04 | Bamberg | South Carolina | 45009 | 3304 | 68 |
2148018 | 2148018 | 2022-01-24 | Braxton | West Virginia | 54007 | 3304 | 33 |
2139930 | 2139930 | 2022-01-22 | Dallas | Missouri | 29059 | 3304 | 64 |
2099629 | 2099629 | 2022-01-10 | Chaffee | Colorado | 8015 | 3304 | 38 |
2074657 | 2074657 | 2022-01-02 | Manistee | Michigan | 26101 | 3304 | 64 |
2071406 | 2071406 | 2022-01-01 | Manistee | Michigan | 26101 | 3304 | 64 |
2068155 | 2068155 | 2021-12-31 | Manistee | Michigan | 26101 | 3304 | 64 |
2064904 | 2064904 | 2021-12-30 | Manistee | Michigan | 26101 | 3304 | 64 |
2061654 | 2061654 | 2021-12-29 | Manistee | Michigan | 26101 | 3304 | 64 |
2057091 | 2057091 | 2021-12-27 | Carbon | Wyoming | 56007 | 3304 | 46 |
2040975 | 2040975 | 2021-12-23 | Ashley | Arkansas | 5003 | 3304 | 53 |
1939495 | 1939495 | 2021-11-21 | Burleson | Texas | 48051 | 3304 | 60 |
1936245 | 1936245 | 2021-11-20 | Burleson | Texas | 48051 | 3304 | 60 |
1922172 | 1922172 | 2021-11-16 | Perry | Missouri | 29157 | 3304 | 33 |
1906605 | 1906605 | 2021-11-11 | Union | Oregon | 41061 | 3304 | 50 |
1903356 | 1903356 | 2021-11-10 | Union | Oregon | 41061 | 3304 | 50 |
1896231 | 1896231 | 2021-11-08 | Hill | Montana | 30041 | 3304 | 64 |
1868749 | 1868749 | 2021-10-31 | Lawrence | Arkansas | 5075 | 3304 | 57 |
1852978 | 1852978 | 2021-10-26 | Douglas | Illinois | 17041 | 3304 | 43 |
1835877 | 1835877 | 2021-10-20 | Page | Virginia | 51139 | 3304 | 74 |
1823161 | 1823161 | 2021-10-17 | Monroe | Alabama | 1099 | 3304 | 62 |
1777295 | 1777295 | 2021-10-02 | Rutland | Vermont | 50021 | 3304 | 26 |
1769064 | 1769064 | 2021-09-30 | Aroostook | Maine | 23003 | 3304 | 73 |
1766497 | 1766497 | 2021-09-29 | Lewis | New York | 36049 | 3304 | 36 |
1761166 | 1761166 | 2021-09-27 | Russell | Virginia | 51167 | 3304 | 48 |
1734665 | 1734665 | 2021-09-19 | Yankton | South Dakota | 46135 | 3304 | 35 |
1731415 | 1731415 | 2021-09-18 | Yankton | South Dakota | 46135 | 3304 | 35 |
1728165 | 1728165 | 2021-09-17 | Yankton | South Dakota | 46135 | 3304 | 35 |
1721497 | 1721497 | 2021-09-15 | Dorado | Puerto Rico | 72051 | 3304 | |
1722116 | 1722116 | 2021-09-15 | Gloucester | Virginia | 51073 | 3304 | 54 |
1718249 | 1718249 | 2021-09-14 | Dorado | Puerto Rico | 72051 | 3304 | |
1699776 | 1699776 | 2021-09-09 | Cleburne | Arkansas | 5023 | 3304 | 85 |
1700089 | 1700089 | 2021-09-09 | Dodge | Georgia | 13091 | 3304 | 113 |
1688095 | 1688095 | 2021-09-05 | Grenada | Mississippi | 28043 | 3304 | 96 |
1684845 | 1684845 | 2021-09-04 | Grenada | Mississippi | 28043 | 3304 | 96 |
1681594 | 1681594 | 2021-09-03 | Grenada | Mississippi | 28043 | 3304 | 96 |
1665529 | 1665529 | 2021-08-29 | Washington | Missouri | 29221 | 3304 | 56 |
1652053 | 1652053 | 2021-08-25 | Assumption | Louisiana | 22007 | 3304 | 43 |
1588418 | 1588418 | 2021-08-05 | Union | South Carolina | 45087 | 3304 | 82 |
1555128 | 1555128 | 2021-07-26 | Ravalli | Montana | 30081 | 3304 | 51 |
1536142 | 1536142 | 2021-07-20 | Adair | Oklahoma | 40001 | 3304 | 45 |
1532894 | 1532894 | 2021-07-19 | Adair | Oklahoma | 40001 | 3304 | 45 |
1529647 | 1529647 | 2021-07-18 | Adair | Oklahoma | 40001 | 3304 | 45 |
1526400 | 1526400 | 2021-07-17 | Adair | Oklahoma | 40001 | 3304 | 45 |
1523153 | 1523153 | 2021-07-16 | Adair | Oklahoma | 40001 | 3304 | 45 |
1518239 | 1518239 | 2021-07-15 | Madison | Georgia | 13195 | 3304 | 56 |
1519905 | 1519905 | 2021-07-15 | Adair | Oklahoma | 40001 | 3304 | 45 |
1516657 | 1516657 | 2021-07-14 | Adair | Oklahoma | 40001 | 3304 | 45 |
1492335 | 1492335 | 2021-07-07 | Hawaii | Hawaii | 15001 | 3304 | 55 |
1376316 | 1376316 | 2021-06-01 | Nicollet | Minnesota | 27103 | 3304 | 44 |
1373070 | 1373070 | 2021-05-31 | Nicollet | Minnesota | 27103 | 3304 | 44 |
1369825 | 1369825 | 2021-05-30 | Nicollet | Minnesota | 27103 | 3304 | 44 |
1359274 | 1359274 | 2021-05-27 | Bonner | Idaho | 16017 | 3304 | 43 |
1354512 | 1354512 | 2021-05-25 | Jefferson | Pennsylvania | 42065 | 3304 | 98 |
1327790 | 1327790 | 2021-05-17 | Laclede | Missouri | 29105 | 3304 | 68 |
1329420 | 1329420 | 2021-05-17 | Juneau | Wisconsin | 55057 | 3304 | 28 |
1309513 | 1309513 | 2021-05-11 | Kendall | Texas | 48259 | 3304 | 72 |
1302234 | 1302234 | 2021-05-09 | Montgomery | North Carolina | 37123 | 3304 | 93 |
1298986 | 1298986 | 2021-05-08 | Montgomery | North Carolina | 37123 | 3304 | 93 |
1295740 | 1295740 | 2021-05-07 | Montgomery | North Carolina | 37123 | 3304 | 93 |
1292599 | 1292599 | 2021-05-06 | Champaign | Ohio | 39021 | 3304 | 58 |
1266038 | 1266038 | 2021-04-28 | Tate | Mississippi | 28137 | 3304 | 84 |
1248195 | 1248195 | 2021-04-22 | Marshall | West Virginia | 54051 | 3304 | 77 |
1214494 | 1214494 | 2021-04-12 | Tioga | New York | 36107 | 3304 | 58 |
1197418 | 1197418 | 2021-04-07 | Knox | Kentucky | 21121 | 3304 | 32 |
1197673 | 1197673 | 2021-04-07 | Sanilac | Michigan | 26151 | 3304 | 87 |
1192289 | 1192289 | 2021-04-05 | Clarendon | South Carolina | 45027 | 3304 | 107 |
1142507 | 1142507 | 2021-03-21 | Itasca | Minnesota | 27061 | 3304 | 51 |
1123526 | 1123526 | 2021-03-15 | Cortland | New York | 36023 | 3304 | 60 |
1092857 | 1092857 | 2021-03-06 | Bryan | Georgia | 13029 | 3304 | 35 |
1070338 | 1070338 | 2021-02-27 | Bureau | Illinois | 17011 | 3304 | 86 |
1063896 | 1063896 | 2021-02-25 | Logan | Illinois | 17107 | 3304 | 66 |
1065803 | 1065803 | 2021-02-25 | Hardin | Tennessee | 47071 | 3304 | 62 |
1056600 | 1056600 | 2021-02-22 | Whitman | Washington | 53075 | 3304 | 43 |
1043140 | 1043140 | 2021-02-18 | White | Tennessee | 47185 | 3304 | 64 |
1029355 | 1029355 | 2021-02-14 | Cibola | New Mexico | 35006 | 3304 | 103 |
982595 | 982595 | 2021-01-31 | Oconee | Georgia | 13219 | 3304 | 49 |
971978 | 971978 | 2021-01-27 | Wharton | Texas | 48481 | 3304 | 88 |
965482 | 965482 | 2021-01-25 | Van Zandt | Texas | 48467 | 3304 | 82 |
962237 | 962237 | 2021-01-24 | Van Zandt | Texas | 48467 | 3304 | 82 |
958992 | 958992 | 2021-01-23 | Van Zandt | Texas | 48467 | 3304 | 82 |
945134 | 945134 | 2021-01-19 | Richmond | North Carolina | 37153 | 3304 | 59 |
936904 | 936904 | 2021-01-17 | Tuolumne | California | 6109 | 3304 | 38 |
933659 | 933659 | 2021-01-16 | Tuolumne | California | 6109 | 3304 | 38 |
930414 | 930414 | 2021-01-15 | Tuolumne | California | 6109 | 3304 | 38 |
893166 | 893166 | 2021-01-03 | Edgecombe | North Carolina | 37065 | 3304 | 82 |
879623 | 879623 | 2020-12-30 | Mower | Minnesota | 27099 | 3304 | 25 |
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);