ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
143 rows where cases = 3828 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 16
- Georgia 16
- Kentucky 10
- Iowa 9
- Oklahoma 7
- Texas 7
- Illinois 6
- Indiana 6
- Minnesota 6
- Tennessee 6
- Michigan 5
- Virginia 5
- Missouri 4
- Wisconsin 4
- Alabama 3
- North Carolina 3
- Oregon 3
- Pennsylvania 3
- Louisiana 2
- Mississippi 2
- Ohio 2
- South Dakota 2
- Vermont 2
- Washington 2
- Alaska 1
- Arkansas 1
- Colorado 1
- Idaho 1
- New Hampshire 1
- New Jersey 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502585 | 2502585 | 2022-05-13 | Manassas Park city | Virginia | 51685 | 3828 | 27 |
2382694 | 2382694 | 2022-04-07 | Hamilton | Florida | 12047 | 3828 | 55 |
2379439 | 2379439 | 2022-04-06 | Hamilton | Florida | 12047 | 3828 | 55 |
2376185 | 2376185 | 2022-04-05 | Hamilton | Florida | 12047 | 3828 | 55 |
2372933 | 2372933 | 2022-04-04 | Hamilton | Florida | 12047 | 3828 | 55 |
2369680 | 2369680 | 2022-04-03 | Hamilton | Florida | 12047 | 3828 | 55 |
2366427 | 2366427 | 2022-04-02 | Hamilton | Florida | 12047 | 3828 | 55 |
2363174 | 2363174 | 2022-04-01 | Hamilton | Florida | 12047 | 3828 | 55 |
2359920 | 2359920 | 2022-03-31 | Hamilton | Florida | 12047 | 3828 | 55 |
2356666 | 2356666 | 2022-03-30 | Hamilton | Florida | 12047 | 3828 | 55 |
2359242 | 2359242 | 2022-03-30 | Lamoille | Vermont | 50015 | 3828 | 17 |
2353413 | 2353413 | 2022-03-29 | Hamilton | Florida | 12047 | 3828 | 54 |
2350161 | 2350161 | 2022-03-28 | Hamilton | Florida | 12047 | 3828 | 54 |
2346908 | 2346908 | 2022-03-27 | Hamilton | Florida | 12047 | 3828 | 54 |
2343655 | 2343655 | 2022-03-26 | Hamilton | Florida | 12047 | 3828 | 54 |
2340402 | 2340402 | 2022-03-25 | Hamilton | Florida | 12047 | 3828 | 54 |
2336761 | 2336761 | 2022-03-23 | Richland | Wisconsin | 55103 | 3828 | 45 |
2331911 | 2331911 | 2022-03-22 | Wright | Missouri | 29229 | 3828 | 80 |
2247131 | 2247131 | 2022-02-24 | Redwood | Minnesota | 27127 | 3828 | 52 |
2243880 | 2243880 | 2022-02-23 | Redwood | Minnesota | 27127 | 3828 | 52 |
2244552 | 2244552 | 2022-02-23 | Unknown | Northern Mariana Islands | 3828 | 4 | |
2238763 | 2238763 | 2022-02-21 | Llano | Texas | 48299 | 3828 | 91 |
2222247 | 2222247 | 2022-02-16 | Oglala Lakota | South Dakota | 46102 | 3828 | 60 |
2216877 | 2216877 | 2022-02-15 | Banks | Georgia | 13011 | 3828 | 78 |
2194167 | 2194167 | 2022-02-08 | Greene | Georgia | 13133 | 3828 | 75 |
2117979 | 2117979 | 2022-01-15 | Camuy | Puerto Rico | 72027 | 3828 | |
2109743 | 2109743 | 2022-01-13 | Clay | Illinois | 17025 | 3828 | 65 |
2111390 | 2111390 | 2022-01-13 | Union | Oregon | 41061 | 3828 | 65 |
2099776 | 2099776 | 2022-01-10 | Berrien | Georgia | 13019 | 3828 | 72 |
2096801 | 2096801 | 2022-01-09 | Pike | Illinois | 17149 | 3828 | 62 |
2093549 | 2093549 | 2022-01-08 | Pike | Illinois | 17149 | 3828 | 62 |
2090297 | 2090297 | 2022-01-07 | Pike | Illinois | 17149 | 3828 | 62 |
2077101 | 2077101 | 2022-01-03 | McDuffie | Georgia | 13189 | 3828 | 79 |
2073850 | 2073850 | 2022-01-02 | McDuffie | Georgia | 13189 | 3828 | 79 |
2074373 | 2074373 | 2022-01-02 | Bourbon | Kentucky | 21017 | 3828 | 42 |
2070599 | 2070599 | 2022-01-01 | McDuffie | Georgia | 13189 | 3828 | 79 |
2071122 | 2071122 | 2022-01-01 | Bourbon | Kentucky | 21017 | 3828 | 42 |
2067348 | 2067348 | 2021-12-31 | McDuffie | Georgia | 13189 | 3828 | 79 |
2067871 | 2067871 | 2021-12-31 | Bourbon | Kentucky | 21017 | 3828 | 42 |
2064620 | 2064620 | 2021-12-30 | Bourbon | Kentucky | 21017 | 3828 | 42 |
2061370 | 2061370 | 2021-12-29 | Bourbon | Kentucky | 21017 | 3828 | 42 |
2063279 | 2063279 | 2021-12-29 | Orleans | Vermont | 50019 | 3828 | 29 |
2056907 | 2056907 | 2021-12-27 | Staunton city | Virginia | 51790 | 3828 | 86 |
2035173 | 2035173 | 2021-12-21 | Carroll | Iowa | 19027 | 3828 | 57 |
2035673 | 2035673 | 2021-12-21 | Osceola | Michigan | 26133 | 3828 | 55 |
2031923 | 2031923 | 2021-12-20 | Carroll | Iowa | 19027 | 3828 | 57 |
2032423 | 2032423 | 2021-12-20 | Osceola | Michigan | 26133 | 3828 | 55 |
2028672 | 2028672 | 2021-12-19 | Carroll | Iowa | 19027 | 3828 | 57 |
2025421 | 2025421 | 2021-12-18 | Carroll | Iowa | 19027 | 3828 | 57 |
2022170 | 2022170 | 2021-12-17 | Carroll | Iowa | 19027 | 3828 | 57 |
2018919 | 2018919 | 2021-12-16 | Carroll | Iowa | 19027 | 3828 | 57 |
2015669 | 2015669 | 2021-12-15 | Carroll | Iowa | 19027 | 3828 | 57 |
2014826 | 2014826 | 2021-12-14 | Vernon | Wisconsin | 55123 | 3828 | 71 |
1996405 | 1996405 | 2021-12-09 | Hart | Kentucky | 21099 | 3828 | 76 |
1991009 | 1991009 | 2021-12-07 | Beckham | Oklahoma | 40009 | 3828 | 78 |
1986329 | 1986329 | 2021-12-06 | Fountain | Indiana | 18045 | 3828 | 67 |
1987009 | 1987009 | 2021-12-06 | Wabasha | Minnesota | 27157 | 3828 | 10 |
1987758 | 1987758 | 2021-12-06 | Beckham | Oklahoma | 40009 | 3828 | 78 |
1984508 | 1984508 | 2021-12-05 | Beckham | Oklahoma | 40009 | 3828 | 78 |
1984906 | 1984906 | 2021-12-05 | Fentress | Tennessee | 47049 | 3828 | 71 |
1981258 | 1981258 | 2021-12-04 | Beckham | Oklahoma | 40009 | 3828 | 78 |
1981656 | 1981656 | 2021-12-04 | Fentress | Tennessee | 47049 | 3828 | 71 |
1978008 | 1978008 | 2021-12-03 | Beckham | Oklahoma | 40009 | 3828 | 78 |
1978406 | 1978406 | 2021-12-03 | Fentress | Tennessee | 47049 | 3828 | 71 |
1974758 | 1974758 | 2021-12-02 | Beckham | Oklahoma | 40009 | 3828 | 75 |
1971509 | 1971509 | 2021-12-01 | Beckham | Oklahoma | 40009 | 3828 | 75 |
1918425 | 1918425 | 2021-11-15 | McCreary | Kentucky | 21147 | 3828 | 59 |
1915175 | 1915175 | 2021-11-14 | McCreary | Kentucky | 21147 | 3828 | 59 |
1911925 | 1911925 | 2021-11-13 | McCreary | Kentucky | 21147 | 3828 | 59 |
1875018 | 1875018 | 2021-11-01 | Door | Wisconsin | 55029 | 3828 | 40 |
1812110 | 1812110 | 2021-10-13 | Transylvania | North Carolina | 37175 | 3828 | 48 |
1778074 | 1778074 | 2021-10-03 | Franklin | Georgia | 13119 | 3828 | 74 |
1774824 | 1774824 | 2021-10-02 | Franklin | Georgia | 13119 | 3828 | 74 |
1771574 | 1771574 | 2021-10-01 | Franklin | Georgia | 13119 | 3828 | 74 |
1761317 | 1761317 | 2021-09-27 | Lincoln | Wisconsin | 55069 | 3828 | 106 |
1746312 | 1746312 | 2021-09-23 | Union | Louisiana | 22111 | 3828 | 98 |
1738452 | 1738452 | 2021-09-20 | Clallam | Washington | 53009 | 3828 | 37 |
1718626 | 1718626 | 2021-09-14 | Hockley | Texas | 48219 | 3828 | 121 |
1713232 | 1713232 | 2021-09-13 | Latah | Idaho | 16057 | 3828 | 19 |
1697937 | 1697937 | 2021-09-08 | Dunklin | Missouri | 29069 | 3828 | 55 |
1669238 | 1669238 | 2021-08-30 | Champaign | Ohio | 39021 | 3828 | 60 |
1658925 | 1658925 | 2021-08-27 | Barry | Missouri | 29009 | 3828 | 55 |
1656493 | 1656493 | 2021-08-26 | Snyder | Pennsylvania | 42109 | 3828 | 87 |
1622396 | 1622396 | 2021-08-16 | Adams | Indiana | 18001 | 3828 | 57 |
1606239 | 1606239 | 2021-08-11 | Wabash | Indiana | 18169 | 3828 | 84 |
1588812 | 1588812 | 2021-08-05 | Upshur | Texas | 48459 | 3828 | 78 |
1583726 | 1583726 | 2021-08-04 | Calloway | Kentucky | 21035 | 3828 | 50 |
1541154 | 1541154 | 2021-07-22 | Montgomery | Illinois | 17135 | 3828 | 80 |
1538009 | 1538009 | 2021-07-21 | Putnam | Indiana | 18133 | 3828 | 62 |
1518159 | 1518159 | 2021-07-15 | Bryan | Georgia | 13029 | 3828 | 41 |
1510730 | 1510730 | 2021-07-12 | Grimes | Texas | 48185 | 3828 | 74 |
1401044 | 1401044 | 2021-06-09 | Independence | Arkansas | 5063 | 3828 | 124 |
1380495 | 1380495 | 2021-06-02 | Perry | Pennsylvania | 42099 | 3828 | 100 |
1377250 | 1377250 | 2021-06-01 | Perry | Pennsylvania | 42099 | 3828 | 100 |
1343805 | 1343805 | 2021-05-22 | Becker | Minnesota | 27005 | 3828 | 54 |
1319398 | 1319398 | 2021-05-14 | Sanpete | Utah | 49039 | 3828 | 22 |
1314009 | 1314009 | 2021-05-13 | Miami | Indiana | 18103 | 3828 | 68 |
1285821 | 1285821 | 2021-05-04 | Grafton | New Hampshire | 33009 | 3828 | 26 |
1207477 | 1207477 | 2021-04-10 | Morrison | Minnesota | 27097 | 3828 | 59 |
1181987 | 1181987 | 2021-04-02 | Livingston | New York | 36051 | 3828 | 58 |
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);