ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
119 rows where cases = 4104 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 15
- Texas 11
- Georgia 9
- North Carolina 8
- Missouri 7
- Arkansas 6
- Mississippi 6
- Virginia 5
- Michigan 4
- Montana 4
- Pennsylvania 4
- South Carolina 4
- Alabama 3
- Indiana 3
- Minnesota 3
- Ohio 3
- Tennessee 3
- West Virginia 3
- Kentucky 2
- Nebraska 2
- New York 2
- Oklahoma 2
- California 1
- Illinois 1
- Kansas 1
- New Hampshire 1
- New Mexico 1
- North Dakota 1
- Oregon 1
- Puerto Rico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499300 | 2499300 | 2022-05-12 | Giles | Virginia | 51071 | 4104 | 50 |
2466392 | 2466392 | 2022-05-02 | Bosque | Texas | 48035 | 4104 | 70 |
2463137 | 2463137 | 2022-05-01 | Bosque | Texas | 48035 | 4104 | 70 |
2459881 | 2459881 | 2022-04-30 | Bosque | Texas | 48035 | 4104 | 70 |
2456625 | 2456625 | 2022-04-29 | Bosque | Texas | 48035 | 4104 | 70 |
2453369 | 2453369 | 2022-04-28 | Bosque | Texas | 48035 | 4104 | 70 |
2421537 | 2421537 | 2022-04-19 | Clay | Arkansas | 5021 | 4104 | 93 |
2418281 | 2418281 | 2022-04-18 | Clay | Arkansas | 5021 | 4104 | 93 |
2392518 | 2392518 | 2022-04-10 | Brantley | Georgia | 13025 | 4104 | 107 |
2389262 | 2389262 | 2022-04-09 | Brantley | Georgia | 13025 | 4104 | 107 |
2386007 | 2386007 | 2022-04-08 | Brantley | Georgia | 13025 | 4104 | 107 |
2280184 | 2280184 | 2022-03-06 | Chowan | North Carolina | 37041 | 4104 | 54 |
2276931 | 2276931 | 2022-03-05 | Chowan | North Carolina | 37041 | 4104 | 54 |
2273678 | 2273678 | 2022-03-04 | Chowan | North Carolina | 37041 | 4104 | 54 |
2256998 | 2256998 | 2022-02-27 | Benton | Missouri | 29015 | 4104 | 90 |
2253747 | 2253747 | 2022-02-26 | Benton | Missouri | 29015 | 4104 | 90 |
2250496 | 2250496 | 2022-02-25 | Benton | Missouri | 29015 | 4104 | 90 |
2248872 | 2248872 | 2022-02-24 | Monroe | West Virginia | 54063 | 4104 | 39 |
2225888 | 2225888 | 2022-02-17 | Unknown | Utah | 4104 | 72 | |
2201646 | 2201646 | 2022-02-10 | Clarke | Mississippi | 28023 | 4104 | 101 |
2167826 | 2167826 | 2022-01-31 | Grant | Arkansas | 5053 | 4104 | 53 |
2164017 | 2164017 | 2022-01-29 | Shelby | Texas | 48419 | 4104 | 117 |
2099850 | 2099850 | 2022-01-10 | Jones | Georgia | 13169 | 4104 | 99 |
2099994 | 2099994 | 2022-01-10 | Crawford | Illinois | 17033 | 4104 | 52 |
2054866 | 2054866 | 2021-12-27 | Anderson | Kentucky | 21005 | 4104 | 57 |
2055387 | 2055387 | 2021-12-27 | Crawford | Missouri | 29055 | 4104 | 78 |
2034267 | 2034267 | 2021-12-20 | Wyoming | West Virginia | 54109 | 4104 | 76 |
2030281 | 2030281 | 2021-12-19 | Abbeville | South Carolina | 45001 | 4104 | 53 |
2027030 | 2027030 | 2021-12-18 | Abbeville | South Carolina | 45001 | 4104 | 53 |
2023779 | 2023779 | 2021-12-17 | Abbeville | South Carolina | 45001 | 4104 | 53 |
2016768 | 2016768 | 2021-12-15 | Anson | North Carolina | 37007 | 4104 | 84 |
2010040 | 2010040 | 2021-12-13 | Cass | Nebraska | 31025 | 4104 | 23 |
2005228 | 2005228 | 2021-12-12 | Cleburne | Arkansas | 5023 | 4104 | 95 |
1988620 | 1988620 | 2021-12-06 | Orange | Virginia | 51137 | 4104 | 63 |
1952830 | 1952830 | 2021-11-25 | Halifax | Virginia | 51083 | 4104 | 113 |
1883052 | 1883052 | 2021-11-04 | Leake | Mississippi | 28079 | 4104 | 89 |
1879803 | 1879803 | 2021-11-03 | Leake | Mississippi | 28079 | 4104 | 89 |
1876554 | 1876554 | 2021-11-02 | Leake | Mississippi | 28079 | 4104 | 89 |
1823631 | 1823631 | 2021-10-17 | Sumter | Georgia | 13261 | 4104 | 128 |
1825200 | 1825200 | 2021-10-17 | Gallia | Ohio | 39053 | 4104 | 65 |
1820382 | 1820382 | 2021-10-16 | Sumter | Georgia | 13261 | 4104 | 128 |
1817133 | 1817133 | 2021-10-15 | Sumter | Georgia | 13261 | 4104 | 128 |
1803761 | 1803761 | 2021-10-11 | Jackson | Arkansas | 5067 | 4104 | 42 |
1779678 | 1779678 | 2021-10-03 | Stutsman | North Dakota | 38093 | 4104 | 82 |
1700038 | 1700038 | 2021-09-09 | Taylor | Florida | 12123 | 4104 | 48 |
1696789 | 1696789 | 2021-09-08 | Taylor | Florida | 12123 | 4104 | 48 |
1693541 | 1693541 | 2021-09-07 | Taylor | Florida | 12123 | 4104 | 48 |
1690292 | 1690292 | 2021-09-06 | Taylor | Florida | 12123 | 4104 | 48 |
1687042 | 1687042 | 2021-09-05 | Taylor | Florida | 12123 | 4104 | 48 |
1683792 | 1683792 | 2021-09-04 | Taylor | Florida | 12123 | 4104 | 48 |
1680541 | 1680541 | 2021-09-03 | Taylor | Florida | 12123 | 4104 | 48 |
1675048 | 1675048 | 2021-09-01 | Polk | Minnesota | 27119 | 4104 | 75 |
1671490 | 1671490 | 2021-08-31 | Marshall | Kentucky | 21157 | 4104 | 68 |
1631759 | 1631759 | 2021-08-19 | Bradford | Florida | 12007 | 4104 | 58 |
1628512 | 1628512 | 2021-08-18 | Bradford | Florida | 12007 | 4104 | 58 |
1625265 | 1625265 | 2021-08-17 | Bradford | Florida | 12007 | 4104 | 58 |
1622018 | 1622018 | 2021-08-16 | Bradford | Florida | 12007 | 4104 | 58 |
1618771 | 1618771 | 2021-08-15 | Bradford | Florida | 12007 | 4104 | 58 |
1621011 | 1621011 | 2021-08-15 | Henderson | Tennessee | 47077 | 4104 | 79 |
1615523 | 1615523 | 2021-08-14 | Bradford | Florida | 12007 | 4104 | 58 |
1617763 | 1617763 | 2021-08-14 | Henderson | Tennessee | 47077 | 4104 | 79 |
1612274 | 1612274 | 2021-08-13 | Bradford | Florida | 12007 | 4104 | 58 |
1614515 | 1614515 | 2021-08-13 | Henderson | Tennessee | 47077 | 4104 | 79 |
1574948 | 1574948 | 2021-08-01 | Scotland | North Carolina | 37165 | 4104 | 89 |
1571700 | 1571700 | 2021-07-31 | Scotland | North Carolina | 37165 | 4104 | 89 |
1568452 | 1568452 | 2021-07-30 | Scotland | North Carolina | 37165 | 4104 | 89 |
1562038 | 1562038 | 2021-07-28 | Brown | Ohio | 39015 | 4104 | 62 |
1542342 | 1542342 | 2021-07-22 | Columbia | New York | 36021 | 4104 | 104 |
1539094 | 1539094 | 2021-07-21 | Columbia | New York | 36021 | 4104 | 104 |
1534729 | 1534729 | 2021-07-20 | Huntington | Indiana | 18069 | 4104 | 83 |
1519992 | 1519992 | 2021-07-15 | Douglas | Oregon | 41019 | 4104 | 85 |
1493246 | 1493246 | 2021-07-07 | Neshoba | Mississippi | 28099 | 4104 | 180 |
1416270 | 1416270 | 2021-06-13 | Ponce | Puerto Rico | 72113 | 4104 | |
1377264 | 1377264 | 2021-06-01 | Wayne | Pennsylvania | 42127 | 4104 | 80 |
1374018 | 1374018 | 2021-05-31 | Wayne | Pennsylvania | 42127 | 4104 | 80 |
1370773 | 1370773 | 2021-05-30 | Wayne | Pennsylvania | 42127 | 4104 | 80 |
1366981 | 1366981 | 2021-05-29 | Belknap | New Hampshire | 33001 | 4104 | 100 |
1353876 | 1353876 | 2021-05-25 | Silver Bow | Montana | 30093 | 4104 | 86 |
1350481 | 1350481 | 2021-05-24 | Camden | Missouri | 29029 | 4104 | 87 |
1350630 | 1350630 | 2021-05-24 | Silver Bow | Montana | 30093 | 4104 | 86 |
1347235 | 1347235 | 2021-05-23 | Camden | Missouri | 29029 | 4104 | 87 |
1347384 | 1347384 | 2021-05-23 | Silver Bow | Montana | 30093 | 4104 | 86 |
1344136 | 1344136 | 2021-05-22 | Silver Bow | Montana | 30093 | 4104 | 86 |
1334667 | 1334667 | 2021-05-19 | Davie | North Carolina | 37059 | 4104 | 37 |
1296638 | 1296638 | 2021-05-07 | Wharton | Texas | 48481 | 4104 | 115 |
1272365 | 1272365 | 2021-04-30 | Sanilac | Michigan | 26151 | 4104 | 103 |
1267822 | 1267822 | 2021-04-29 | Covington | Alabama | 1039 | 4104 | 116 |
1268043 | 1268043 | 2021-04-29 | Tuolumne | California | 6109 | 4104 | 65 |
1264575 | 1264575 | 2021-04-28 | Covington | Alabama | 1039 | 4104 | 116 |
1259801 | 1259801 | 2021-04-26 | Platte | Nebraska | 31141 | 4104 | 48 |
1215841 | 1215841 | 2021-04-12 | Sweetwater | Wyoming | 56037 | 4104 | 37 |
1207683 | 1207683 | 2021-04-10 | Platte | Missouri | 29165 | 4104 | 46 |
1195803 | 1195803 | 2021-04-06 | Erath | Texas | 48143 | 4104 | 67 |
1187368 | 1187368 | 2021-04-04 | Montgomery | Indiana | 18107 | 4104 | 87 |
1184121 | 1184121 | 2021-04-03 | Montgomery | Indiana | 18107 | 4104 | 87 |
1133512 | 1133512 | 2021-03-18 | Knox | Ohio | 39083 | 4104 | 107 |
1124101 | 1124101 | 2021-03-15 | Dillon | South Carolina | 45033 | 4104 | 81 |
1105135 | 1105135 | 2021-03-09 | Campbell | Virginia | 51031 | 4104 | 73 |
1042813 | 1042813 | 2021-02-18 | Huntingdon | Pennsylvania | 42061 | 4104 | 119 |
1043169 | 1043169 | 2021-02-18 | Burnet | Texas | 48053 | 4104 | 51 |
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);