ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
162 rows where cases = 3428 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 17
- Texas 12
- Iowa 10
- Kansas 9
- Illinois 8
- Missouri 8
- Tennessee 7
- Puerto Rico 6
- Alabama 5
- Arkansas 5
- Michigan 5
- Oregon 5
- South Carolina 5
- West Virginia 5
- Wisconsin 5
- Indiana 4
- North Carolina 4
- Virginia 4
- Florida 3
- New Mexico 3
- New York 3
- Ohio 3
- Virgin Islands 3
- California 2
- Kentucky 2
- Louisiana 2
- Minnesota 2
- Mississippi 2
- Oklahoma 2
- Utah 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490205 | 2490205 | 2022-05-10 | Brooks | Georgia | 13027 | 3428 | 86 |
2486948 | 2486948 | 2022-05-09 | Brooks | Georgia | 13027 | 3428 | 86 |
2483690 | 2483690 | 2022-05-08 | Brooks | Georgia | 13027 | 3428 | 86 |
2480432 | 2480432 | 2022-05-07 | Brooks | Georgia | 13027 | 3428 | 86 |
2477174 | 2477174 | 2022-05-06 | Brooks | Georgia | 13027 | 3428 | 86 |
2473916 | 2473916 | 2022-05-05 | Brooks | Georgia | 13027 | 3428 | 86 |
2470659 | 2470659 | 2022-05-04 | Brooks | Georgia | 13027 | 3428 | 86 |
2448704 | 2448704 | 2022-04-27 | Nantucket | Massachusetts | 25019 | 3428 | 0 |
2436823 | 2436823 | 2022-04-23 | Loiza | Puerto Rico | 72087 | 3428 | |
2427083 | 2427083 | 2022-04-20 | Utuado | Puerto Rico | 72141 | 3428 | |
2399323 | 2399323 | 2022-04-12 | Washington | Illinois | 17189 | 3428 | 41 |
2399466 | 2399466 | 2022-04-12 | Harrison | Iowa | 19085 | 3428 | 94 |
2396210 | 2396210 | 2022-04-11 | Harrison | Iowa | 19085 | 3428 | 94 |
2392955 | 2392955 | 2022-04-10 | Harrison | Iowa | 19085 | 3428 | 94 |
2389699 | 2389699 | 2022-04-09 | Harrison | Iowa | 19085 | 3428 | 94 |
2386443 | 2386443 | 2022-04-08 | Harrison | Iowa | 19085 | 3428 | 94 |
2383189 | 2383189 | 2022-04-07 | Harrison | Iowa | 19085 | 3428 | 94 |
2379934 | 2379934 | 2022-04-06 | Harrison | Iowa | 19085 | 3428 | 94 |
2341950 | 2341950 | 2022-03-25 | Schuyler | New York | 36097 | 3428 | 25 |
2290411 | 2290411 | 2022-03-09 | San German | Puerto Rico | 72125 | 3428 | |
2222070 | 2222070 | 2022-02-16 | Aibonito | Puerto Rico | 72009 | 3428 | |
2218819 | 2218819 | 2022-02-15 | Aibonito | Puerto Rico | 72009 | 3428 | |
2215568 | 2215568 | 2022-02-14 | Aibonito | Puerto Rico | 72009 | 3428 | |
2194999 | 2194999 | 2022-02-08 | Leelanau | Michigan | 26089 | 3428 | 47 |
2195753 | 2195753 | 2022-02-08 | Ramsey | North Dakota | 38071 | 3428 | 51 |
2191745 | 2191745 | 2022-02-07 | Leelanau | Michigan | 26089 | 3428 | 47 |
2127387 | 2127387 | 2022-01-18 | Warren | North Carolina | 37185 | 3428 | 36 |
2124875 | 2124875 | 2022-01-17 | Houston | Texas | 48225 | 3428 | 91 |
2115151 | 2115151 | 2022-01-14 | Lee | Texas | 48287 | 3428 | 54 |
2110710 | 2110710 | 2022-01-13 | Pike | Missouri | 29163 | 3428 | 54 |
2107789 | 2107789 | 2022-01-12 | Avery | North Carolina | 37011 | 3428 | 39 |
2102606 | 2102606 | 2022-01-10 | Carbon | Wyoming | 56007 | 3428 | 47 |
2058535 | 2058535 | 2021-12-28 | Chickasaw | Mississippi | 28017 | 3428 | 73 |
2053738 | 2053738 | 2021-12-26 | McDowell | West Virginia | 54047 | 3428 | 56 |
2050488 | 2050488 | 2021-12-25 | McDowell | West Virginia | 54047 | 3428 | 56 |
2047238 | 2047238 | 2021-12-24 | McDowell | West Virginia | 54047 | 3428 | 56 |
2043988 | 2043988 | 2021-12-23 | McDowell | West Virginia | 54047 | 3428 | 56 |
2035998 | 2035998 | 2021-12-21 | Hill | Montana | 30041 | 3428 | 71 |
2015301 | 2015301 | 2021-12-15 | Elbert | Georgia | 13105 | 3428 | 92 |
1997615 | 1997615 | 2021-12-09 | Union | Oregon | 41061 | 3428 | 57 |
1992227 | 1992227 | 2021-12-08 | Columbia | Arkansas | 5027 | 3428 | 75 |
1994364 | 1994364 | 2021-12-08 | Union | Oregon | 41061 | 3428 | 57 |
1985456 | 1985456 | 2021-12-05 | Brooke | West Virginia | 54009 | 3428 | 78 |
1971969 | 1971969 | 2021-12-01 | Union | Tennessee | 47173 | 3428 | 50 |
1943057 | 1943057 | 2021-11-22 | Dinwiddie | Virginia | 51053 | 3428 | 59 |
1937339 | 1937339 | 2021-11-21 | Morgan | Georgia | 13211 | 3428 | 45 |
1939769 | 1939769 | 2021-11-21 | St. Croix | Virgin Islands | 78010 | 3428 | 35 |
1934089 | 1934089 | 2021-11-20 | Morgan | Georgia | 13211 | 3428 | 45 |
1936519 | 1936519 | 2021-11-20 | St. Croix | Virgin Islands | 78010 | 3428 | 35 |
1930837 | 1930837 | 2021-11-19 | Morgan | Georgia | 13211 | 3428 | 45 |
1933269 | 1933269 | 2021-11-19 | St. Croix | Virgin Islands | 78010 | 3428 | 35 |
1927031 | 1927031 | 2021-11-17 | Langlade | Wisconsin | 55067 | 3428 | 59 |
1905641 | 1905641 | 2021-11-11 | Mason | Michigan | 26105 | 3428 | 50 |
1902392 | 1902392 | 2021-11-10 | Mason | Michigan | 26105 | 3428 | 50 |
1876471 | 1876471 | 2021-11-02 | Martin | Minnesota | 27091 | 3428 | 39 |
1853623 | 1853623 | 2021-10-26 | Emmet | Michigan | 26047 | 3428 | 50 |
1797230 | 1797230 | 2021-10-09 | Arkansas | Arkansas | 5001 | 3428 | 56 |
1793981 | 1793981 | 2021-10-08 | Arkansas | Arkansas | 5001 | 3428 | 56 |
1793844 | 1793844 | 2021-10-07 | Waushara | Wisconsin | 55137 | 3428 | 48 |
1769839 | 1769839 | 2021-09-30 | Martin | North Carolina | 37117 | 3428 | 61 |
1771044 | 1771044 | 2021-09-30 | Door | Wisconsin | 55029 | 3428 | 38 |
1761530 | 1761530 | 2021-09-28 | Logan | Arkansas | 5083 | 3428 | 34 |
1746194 | 1746194 | 2021-09-23 | Johnson | Kentucky | 21115 | 3428 | 43 |
1725335 | 1725335 | 2021-09-16 | Caroline | Virginia | 51033 | 3428 | 43 |
1718920 | 1718920 | 2021-09-14 | Pulaski | Virginia | 51155 | 3428 | 75 |
1697618 | 1697618 | 2021-09-08 | Dorchester | Maryland | 24019 | 3428 | 68 |
1674394 | 1674394 | 2021-09-01 | Greene | Indiana | 18055 | 3428 | 90 |
1648306 | 1648306 | 2021-08-24 | Fayette | Illinois | 17051 | 3428 | 59 |
1629749 | 1629749 | 2021-08-18 | Miller | Missouri | 29131 | 3428 | 64 |
1622330 | 1622330 | 2021-08-16 | Iroquois | Illinois | 17075 | 3428 | 71 |
1552057 | 1552057 | 2021-07-25 | Luna | New Mexico | 35029 | 3428 | 92 |
1548810 | 1548810 | 2021-07-24 | Luna | New Mexico | 35029 | 3428 | 92 |
1545563 | 1545563 | 2021-07-23 | Luna | New Mexico | 35029 | 3428 | 92 |
1532608 | 1532608 | 2021-07-19 | Greene | New York | 36039 | 3428 | 79 |
1393234 | 1393234 | 2021-06-06 | Champaign | Ohio | 39021 | 3428 | 58 |
1349743 | 1349743 | 2021-05-24 | Ripley | Indiana | 18137 | 3428 | 70 |
1351214 | 1351214 | 2021-05-24 | Josephine | Oregon | 41033 | 3428 | 71 |
1346252 | 1346252 | 2021-05-23 | Toombs | Georgia | 13279 | 3428 | 113 |
1346496 | 1346496 | 2021-05-23 | Ripley | Indiana | 18137 | 3428 | 70 |
1343004 | 1343004 | 2021-05-22 | Toombs | Georgia | 13279 | 3428 | 113 |
1340780 | 1340780 | 2021-05-21 | Lawrence | Missouri | 29109 | 3428 | 83 |
1336907 | 1336907 | 2021-05-20 | Geary | Kansas | 20061 | 3428 | 40 |
1333660 | 1333660 | 2021-05-19 | Geary | Kansas | 20061 | 3428 | 40 |
1330015 | 1330015 | 2021-05-18 | Toombs | Georgia | 13279 | 3428 | 113 |
1329112 | 1329112 | 2021-05-17 | Wood | Texas | 48499 | 3428 | 128 |
1325866 | 1325866 | 2021-05-16 | Wood | Texas | 48499 | 3428 | 128 |
1322176 | 1322176 | 2021-05-15 | Clarendon | South Carolina | 45027 | 3428 | 113 |
1322620 | 1322620 | 2021-05-15 | Wood | Texas | 48499 | 3428 | 128 |
1319374 | 1319374 | 2021-05-14 | Wood | Texas | 48499 | 3428 | 128 |
1312436 | 1312436 | 2021-05-12 | Clarendon | South Carolina | 45027 | 3428 | 112 |
1261511 | 1261511 | 2021-04-27 | Lake | California | 6033 | 3428 | 43 |
1240162 | 1240162 | 2021-04-20 | Pulaski | Missouri | 29169 | 3428 | 51 |
1237582 | 1237582 | 2021-04-19 | Malheur | Oregon | 41045 | 3428 | 58 |
1232409 | 1232409 | 2021-04-18 | Baker | Florida | 12003 | 3428 | 60 |
1234335 | 1234335 | 2021-04-18 | Malheur | Oregon | 41045 | 3428 | 58 |
1230379 | 1230379 | 2021-04-17 | Howell | Missouri | 29091 | 3428 | 43 |
1225038 | 1225038 | 2021-04-15 | Fannin | Texas | 48147 | 3428 | 107 |
1206805 | 1206805 | 2021-04-10 | Adams | Indiana | 18001 | 3428 | 53 |
1199054 | 1199054 | 2021-04-07 | Fannin | Texas | 48147 | 3428 | 107 |
1189173 | 1189173 | 2021-04-04 | Hardeman | Tennessee | 47069 | 3428 | 63 |
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);