ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where cases = 3856 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 10
- North Carolina 8
- Virginia 8
- Arkansas 7
- Kentucky 5
- Ohio 5
- Indiana 4
- Pennsylvania 4
- Texas 4
- Alabama 3
- Georgia 3
- Iowa 3
- Louisiana 3
- Maryland 3
- Minnesota 3
- Missouri 3
- Nevada 3
- California 2
- Florida 2
- Mississippi 2
- Nebraska 2
- Tennessee 2
- Michigan 1
- Montana 1
- New Hampshire 1
- New York 1
- Oklahoma 1
- Oregon 1
- Puerto Rico 1
- South Dakota 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2330958 | 2330958 | 2022-03-22 | Massac | Illinois | 17127 | 3856 | 69 |
2327706 | 2327706 | 2022-03-21 | Massac | Illinois | 17127 | 3856 | 69 |
2324453 | 2324453 | 2022-03-20 | Massac | Illinois | 17127 | 3856 | 70 |
2321199 | 2321199 | 2022-03-19 | Massac | Illinois | 17127 | 3856 | 70 |
2317945 | 2317945 | 2022-03-18 | Massac | Illinois | 17127 | 3856 | 70 |
2311439 | 2311439 | 2022-03-16 | Massac | Illinois | 17127 | 3856 | 69 |
2287538 | 2287538 | 2022-03-08 | Llano | Texas | 48299 | 3856 | 97 |
2268642 | 2268642 | 2022-03-03 | Izard | Arkansas | 5065 | 3856 | 65 |
2265389 | 2265389 | 2022-03-02 | Izard | Arkansas | 5065 | 3856 | 65 |
2266637 | 2266637 | 2022-03-02 | Redwood | Minnesota | 27127 | 3856 | 53 |
2262138 | 2262138 | 2022-03-01 | Izard | Arkansas | 5065 | 3856 | 65 |
2258898 | 2258898 | 2022-02-28 | Madison | Arkansas | 5087 | 3856 | 59 |
2220750 | 2220750 | 2022-02-16 | Caldwell | Kentucky | 21033 | 3856 | 58 |
2214264 | 2214264 | 2022-02-14 | Estill | Kentucky | 21065 | 3856 | 41 |
2128361 | 2128361 | 2022-01-18 | Fluvanna | Virginia | 51065 | 3856 | 33 |
2081088 | 2081088 | 2022-01-04 | Somerset | Maryland | 24039 | 3856 | 58 |
2078362 | 2078362 | 2022-01-03 | Saunders | Nebraska | 31155 | 3856 | 23 |
2060978 | 2060978 | 2021-12-29 | Crawford | Illinois | 17033 | 3856 | 51 |
2059360 | 2059360 | 2021-12-28 | Lincoln | Oregon | 41041 | 3856 | 58 |
2037154 | 2037154 | 2021-12-21 | Milam | Texas | 48331 | 3856 | 91 |
1986245 | 1986245 | 2021-12-06 | Jersey | Illinois | 17083 | 3856 | 74 |
1966790 | 1966790 | 2021-11-30 | Shelby | Illinois | 17173 | 3856 | 56 |
1963045 | 1963045 | 2021-11-29 | Del Norte | California | 6015 | 3856 | 42 |
1943806 | 1943806 | 2021-11-23 | Haralson | Georgia | 13143 | 3856 | 125 |
1906912 | 1906912 | 2021-11-11 | Haywood | Tennessee | 47075 | 3856 | 77 |
1903663 | 1903663 | 2021-11-10 | Haywood | Tennessee | 47075 | 3856 | 77 |
1870510 | 1870510 | 2021-10-31 | Anson | North Carolina | 37007 | 3856 | 80 |
1867261 | 1867261 | 2021-10-30 | Anson | North Carolina | 37007 | 3856 | 80 |
1864012 | 1864012 | 2021-10-29 | Anson | North Carolina | 37007 | 3856 | 80 |
1861830 | 1861830 | 2021-10-28 | Gloucester | Virginia | 51073 | 3856 | 75 |
1850212 | 1850212 | 2021-10-25 | Russell | Kentucky | 21207 | 3856 | 61 |
1830354 | 1830354 | 2021-10-19 | Jennings | Indiana | 18079 | 3856 | 62 |
1831281 | 1831281 | 2021-10-19 | Adams | Nebraska | 31001 | 3856 | 54 |
1793002 | 1793002 | 2021-10-07 | Mayaguez | Puerto Rico | 72097 | 3856 | |
1766190 | 1766190 | 2021-09-29 | McDonald | Missouri | 29119 | 3856 | 54 |
1759514 | 1759514 | 2021-09-27 | Pine | Minnesota | 27115 | 3856 | 27 |
1739730 | 1739730 | 2021-09-21 | Ohio | Kentucky | 21183 | 3856 | 68 |
1738429 | 1738429 | 2021-09-20 | Smyth | Virginia | 51173 | 3856 | 99 |
1711175 | 1711175 | 2021-09-12 | Nye | Nevada | 32023 | 3856 | 124 |
1707928 | 1707928 | 2021-09-11 | Nye | Nevada | 32023 | 3856 | 124 |
1704681 | 1704681 | 2021-09-10 | Nye | Nevada | 32023 | 3856 | 124 |
1698330 | 1698330 | 2021-09-08 | Cherokee | North Carolina | 37039 | 3856 | 54 |
1691369 | 1691369 | 2021-09-06 | Marion | Mississippi | 28091 | 3856 | 94 |
1623814 | 1623814 | 2021-08-16 | Ottawa | Ohio | 39123 | 3856 | 82 |
1609926 | 1609926 | 2021-08-12 | Worcester | Maryland | 24047 | 3856 | 106 |
1598754 | 1598754 | 2021-08-08 | Tazewell | Virginia | 51185 | 3856 | 76 |
1595505 | 1595505 | 2021-08-07 | Tazewell | Virginia | 51185 | 3856 | 76 |
1592256 | 1592256 | 2021-08-06 | Tazewell | Virginia | 51185 | 3856 | 76 |
1588264 | 1588264 | 2021-08-05 | McKean | Pennsylvania | 42083 | 3856 | 75 |
1566643 | 1566643 | 2021-07-30 | St. Francis | Arkansas | 5123 | 3856 | 46 |
1540297 | 1540297 | 2021-07-21 | York | Virginia | 51199 | 3856 | 59 |
1540306 | 1540306 | 2021-07-21 | Douglas | Washington | 53017 | 3856 | 23 |
1510327 | 1510327 | 2021-07-12 | Perry | Pennsylvania | 42099 | 3856 | 101 |
1507080 | 1507080 | 2021-07-11 | Perry | Pennsylvania | 42099 | 3856 | 101 |
1486140 | 1486140 | 2021-07-05 | Lee | Iowa | 19111 | 3856 | 57 |
1482894 | 1482894 | 2021-07-04 | Lee | Iowa | 19111 | 3856 | 57 |
1479647 | 1479647 | 2021-07-03 | Lee | Iowa | 19111 | 3856 | 57 |
1441978 | 1441978 | 2021-06-21 | Preble | Ohio | 39135 | 3856 | 105 |
1438733 | 1438733 | 2021-06-20 | Preble | Ohio | 39135 | 3856 | 105 |
1393150 | 1393150 | 2021-06-06 | Scotland | North Carolina | 37165 | 3856 | 87 |
1389905 | 1389905 | 2021-06-05 | Scotland | North Carolina | 37165 | 3856 | 87 |
1386003 | 1386003 | 2021-06-04 | Becker | Minnesota | 27005 | 3856 | 55 |
1386660 | 1386660 | 2021-06-04 | Scotland | North Carolina | 37165 | 3856 | 87 |
1333489 | 1333489 | 2021-05-19 | Miami | Indiana | 18103 | 3856 | 69 |
1327818 | 1327818 | 2021-05-17 | Phelps | Missouri | 29161 | 3856 | 130 |
1324572 | 1324572 | 2021-05-16 | Phelps | Missouri | 29161 | 3856 | 130 |
1262582 | 1262582 | 2021-04-27 | Huron | Michigan | 26063 | 3856 | 72 |
1259842 | 1259842 | 2021-04-26 | Belknap | New Hampshire | 33001 | 3856 | 98 |
1216214 | 1216214 | 2021-04-13 | Okeechobee | Florida | 12093 | 3856 | 87 |
1194978 | 1194978 | 2021-04-06 | Livingston | New York | 36051 | 3856 | 58 |
1162713 | 1162713 | 2021-03-27 | Defiance | Ohio | 39039 | 3856 | 94 |
1157411 | 1157411 | 2021-03-26 | Escambia | Alabama | 1053 | 3856 | 74 |
1155345 | 1155345 | 2021-03-25 | Calvert | Maryland | 24009 | 3856 | 74 |
1150682 | 1150682 | 2021-03-23 | Shenandoah | Virginia | 51171 | 3856 | 127 |
1132113 | 1132113 | 2021-03-18 | Woodford | Illinois | 17203 | 3856 | 73 |
1125096 | 1125096 | 2021-03-16 | Union | Arkansas | 5139 | 3856 | 105 |
1126576 | 1126576 | 2021-03-16 | Silver Bow | Montana | 30093 | 3856 | 81 |
1119588 | 1119588 | 2021-03-14 | St. Bernard | Louisiana | 22087 | 3856 | 47 |
1110951 | 1110951 | 2021-03-11 | Bedford | Pennsylvania | 42009 | 3856 | 129 |
1073696 | 1073696 | 2021-02-28 | DeKalb | Indiana | 18033 | 3856 | 82 |
1054631 | 1054631 | 2021-02-22 | Avoyelles | Louisiana | 22009 | 3856 | 117 |
1055411 | 1055411 | 2021-02-22 | Alexander | North Carolina | 37003 | 3856 | 72 |
1048066 | 1048066 | 2021-02-20 | Hopkins | Kentucky | 21107 | 3856 | 128 |
1034051 | 1034051 | 2021-02-16 | Covington | Alabama | 1039 | 3856 | 97 |
1023521 | 1023521 | 2021-02-12 | Codington | South Dakota | 46029 | 3856 | 76 |
1009537 | 1009537 | 2021-02-08 | Pearl River | Mississippi | 28109 | 3856 | 117 |
999044 | 999044 | 2021-02-05 | Clinton | Indiana | 18023 | 3856 | 54 |
997730 | 997730 | 2021-02-04 | Brown | Texas | 48049 | 3856 | 115 |
907962 | 907962 | 2021-01-08 | Polk | Georgia | 13233 | 3856 | 48 |
893388 | 893388 | 2021-01-03 | Cherokee | Oklahoma | 40021 | 3856 | 18 |
870599 | 870599 | 2020-12-27 | Geauga | Ohio | 39055 | 3856 | 51 |
855516 | 855516 | 2020-12-22 | Fremont | Wyoming | 56013 | 3856 | 57 |
839254 | 839254 | 2020-12-17 | Oconto | Wisconsin | 55083 | 3856 | 39 |
800764 | 800764 | 2020-12-06 | Bulloch | Georgia | 13031 | 3856 | 56 |
745246 | 745246 | 2020-11-19 | St. Clair | Alabama | 1115 | 3856 | 55 |
729289 | 729289 | 2020-11-14 | Citrus | Florida | 12017 | 3856 | 146 |
586421 | 586421 | 2020-10-01 | Sebastian | Arkansas | 5131 | 3856 | 61 |
501523 | 501523 | 2020-09-04 | Ellis | Texas | 48139 | 3856 | 60 |
496765 | 496765 | 2020-09-03 | Rapides | Louisiana | 22079 | 3856 | 135 |
287298 | 287298 | 2020-06-30 | San Joaquin | California | 6077 | 3856 | 52 |
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);