ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where cases = 4350 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Carolina 12
- Ohio 9
- Tennessee 8
- Virginia 8
- Georgia 6
- Illinois 6
- Minnesota 6
- Texas 5
- Mississippi 4
- Missouri 4
- New York 4
- Arkansas 3
- Florida 3
- Indiana 3
- Kentucky 3
- Wisconsin 3
- Iowa 2
- Kansas 2
- Louisiana 2
- Colorado 1
- Idaho 1
- Maine 1
- Michigan 1
- New Hampshire 1
- North Dakota 1
- Pennsylvania 1
- Puerto Rico 1
- South Carolina 1
- South Dakota 1
- Utah 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491804 | 2491804 | 2022-05-10 | Warren | North Carolina | 37185 | 4350 | 45 |
2488546 | 2488546 | 2022-05-09 | Warren | North Carolina | 37185 | 4350 | 45 |
2485289 | 2485289 | 2022-05-08 | Warren | North Carolina | 37185 | 4350 | 45 |
2482031 | 2482031 | 2022-05-07 | Warren | North Carolina | 37185 | 4350 | 45 |
2478773 | 2478773 | 2022-05-06 | Warren | North Carolina | 37185 | 4350 | 45 |
2475515 | 2475515 | 2022-05-05 | Warren | North Carolina | 37185 | 4350 | 45 |
2472258 | 2472258 | 2022-05-04 | Warren | North Carolina | 37185 | 4350 | 45 |
2268189 | 2268189 | 2022-03-02 | Bristol city | Virginia | 51520 | 4350 | 71 |
2264830 | 2264830 | 2022-03-01 | Shelby | Texas | 48419 | 4350 | 126 |
2257404 | 2257404 | 2022-02-27 | Avery | North Carolina | 37011 | 4350 | 41 |
2254153 | 2254153 | 2022-02-26 | Avery | North Carolina | 37011 | 4350 | 41 |
2250902 | 2250902 | 2022-02-25 | Avery | North Carolina | 37011 | 4350 | 41 |
2240140 | 2240140 | 2022-02-22 | Bourbon | Kansas | 20011 | 4350 | 46 |
2236889 | 2236889 | 2022-02-21 | Bourbon | Kansas | 20011 | 4350 | 46 |
2189957 | 2189957 | 2022-02-06 | Jones | Texas | 48253 | 4350 | 86 |
2155860 | 2155860 | 2022-01-27 | Franklin | Maine | 23007 | 4350 | 46 |
2105248 | 2105248 | 2022-01-11 | Wayne | Tennessee | 47181 | 4350 | 47 |
2101997 | 2101997 | 2022-01-10 | Wayne | Tennessee | 47181 | 4350 | 47 |
2098746 | 2098746 | 2022-01-09 | Wayne | Tennessee | 47181 | 4350 | 47 |
2094412 | 2094412 | 2022-01-08 | Henry | Missouri | 29083 | 4350 | 67 |
2095494 | 2095494 | 2022-01-08 | Wayne | Tennessee | 47181 | 4350 | 47 |
2092242 | 2092242 | 2022-01-07 | Wayne | Tennessee | 47181 | 4350 | 47 |
2088990 | 2088990 | 2022-01-06 | Wayne | Tennessee | 47181 | 4350 | 47 |
2085739 | 2085739 | 2022-01-05 | Wayne | Tennessee | 47181 | 4350 | 47 |
2081429 | 2081429 | 2022-01-04 | McDonald | Missouri | 29119 | 4350 | 64 |
2081658 | 2081658 | 2022-01-04 | Unknown | New Hampshire | 4350 | 23 | |
2082487 | 2082487 | 2022-01-04 | Wayne | Tennessee | 47181 | 4350 | 47 |
2078949 | 2078949 | 2022-01-03 | Aguadilla | Puerto Rico | 72005 | 4350 | |
2033593 | 2033593 | 2021-12-20 | Davison | South Dakota | 46035 | 4350 | 72 |
2005625 | 2005625 | 2021-12-12 | Sumter | Georgia | 13261 | 4350 | 140 |
2002374 | 2002374 | 2021-12-11 | Sumter | Georgia | 13261 | 4350 | 140 |
1999124 | 1999124 | 2021-12-10 | Sumter | Georgia | 13261 | 4350 | 140 |
1986105 | 1986105 | 2021-12-06 | Pierce | Georgia | 13229 | 4350 | 106 |
1943929 | 1943929 | 2021-11-23 | Jerome | Idaho | 16053 | 4350 | 53 |
1920712 | 1920712 | 2021-11-16 | Carroll | Arkansas | 5015 | 4350 | 75 |
1882391 | 1882391 | 2021-11-04 | Wells | Indiana | 18179 | 4350 | 92 |
1849781 | 1849781 | 2021-10-25 | Perry | Illinois | 17145 | 4350 | 84 |
1850149 | 1850149 | 2021-10-25 | Grant | Kentucky | 21081 | 4350 | 38 |
1851234 | 1851234 | 2021-10-25 | Pike | Ohio | 39131 | 4350 | 67 |
1826101 | 1826101 | 2021-10-17 | Isle of Wight | Virginia | 51093 | 4350 | 83 |
1822852 | 1822852 | 2021-10-16 | Isle of Wight | Virginia | 51093 | 4350 | 83 |
1819603 | 1819603 | 2021-10-15 | Isle of Wight | Virginia | 51093 | 4350 | 83 |
1814451 | 1814451 | 2021-10-14 | Mercer | Kentucky | 21167 | 4350 | 72 |
1793797 | 1793797 | 2021-10-07 | Green | Wisconsin | 55045 | 4350 | 28 |
1762857 | 1762857 | 2021-09-28 | Simpson | Mississippi | 28127 | 4350 | 114 |
1735671 | 1735671 | 2021-09-20 | Logan | Colorado | 8075 | 4350 | 72 |
1714101 | 1714101 | 2021-09-13 | Leflore | Mississippi | 28083 | 4350 | 138 |
1691288 | 1691288 | 2021-09-06 | Nobles | Minnesota | 27105 | 4350 | 50 |
1688038 | 1688038 | 2021-09-05 | Nobles | Minnesota | 27105 | 4350 | 50 |
1684788 | 1684788 | 2021-09-04 | Nobles | Minnesota | 27105 | 4350 | 50 |
1686518 | 1686518 | 2021-09-04 | Fayette | West Virginia | 54019 | 4350 | 93 |
1681537 | 1681537 | 2021-09-03 | Nobles | Minnesota | 27105 | 4350 | 50 |
1630254 | 1630254 | 2021-08-18 | Brown | Ohio | 39015 | 4350 | 63 |
1630263 | 1630263 | 2021-08-18 | Crawford | Ohio | 39033 | 4350 | 112 |
1607912 | 1607912 | 2021-08-11 | Williamsburg | South Carolina | 45089 | 4350 | 107 |
1549110 | 1549110 | 2021-07-24 | Putnam | Ohio | 39137 | 4350 | 104 |
1525828 | 1525828 | 2021-07-17 | Phelps | Missouri | 29161 | 4350 | 137 |
1523865 | 1523865 | 2021-07-16 | Washington | Texas | 48477 | 4350 | 96 |
1517869 | 1517869 | 2021-07-15 | Boone | Arkansas | 5009 | 4350 | 80 |
1517167 | 1517167 | 2021-07-14 | Cherokee | Texas | 48073 | 4350 | 148 |
1482929 | 1482929 | 2021-07-04 | Wapello | Iowa | 19179 | 4350 | 122 |
1438502 | 1438502 | 2021-06-20 | Tompkins | New York | 36109 | 4350 | 52 |
1435255 | 1435255 | 2021-06-19 | Tompkins | New York | 36109 | 4350 | 52 |
1432008 | 1432008 | 2021-06-18 | Tompkins | New York | 36109 | 4350 | 52 |
1412699 | 1412699 | 2021-06-12 | Ashland | Ohio | 39005 | 4350 | 97 |
1409454 | 1409454 | 2021-06-11 | Ashland | Ohio | 39005 | 4350 | 97 |
1331349 | 1331349 | 2021-05-18 | Fulton | New York | 36035 | 4350 | 91 |
1307096 | 1307096 | 2021-05-11 | DeSoto | Florida | 12027 | 4350 | 93 |
1294442 | 1294442 | 2021-05-07 | Monroe | Illinois | 17133 | 4350 | 93 |
1294509 | 1294509 | 2021-05-07 | Harrison | Indiana | 18061 | 4350 | 74 |
1291196 | 1291196 | 2021-05-06 | Monroe | Illinois | 17133 | 4350 | 92 |
1289391 | 1289391 | 2021-05-05 | Madison | Ohio | 39097 | 4350 | 61 |
1262488 | 1262488 | 2021-04-27 | Washington | Louisiana | 22117 | 4350 | 129 |
1262769 | 1262769 | 2021-04-27 | Marshall | Mississippi | 28093 | 4350 | 103 |
1239329 | 1239329 | 2021-04-20 | Lawrence | Indiana | 18093 | 4350 | 121 |
1217193 | 1217193 | 2021-04-13 | Douglas | Minnesota | 27041 | 4350 | 70 |
1194260 | 1194260 | 2021-04-06 | Lincoln | Louisiana | 22061 | 4350 | 91 |
1196075 | 1196075 | 2021-04-06 | Fauquier | Virginia | 51061 | 4350 | 62 |
1169052 | 1169052 | 2021-03-29 | Chatham | North Carolina | 37037 | 4350 | 86 |
1165257 | 1165257 | 2021-03-28 | Mower | Minnesota | 27099 | 4350 | 31 |
1115571 | 1115571 | 2021-03-13 | Baldwin | Georgia | 13009 | 4350 | 117 |
1111734 | 1111734 | 2021-03-11 | Washington | Virginia | 51191 | 4350 | 101 |
1105785 | 1105785 | 2021-03-10 | Hendry | Florida | 12051 | 4350 | 75 |
1081464 | 1081464 | 2021-03-02 | Vance | North Carolina | 37181 | 4350 | 81 |
1073634 | 1073634 | 2021-02-28 | Macoupin | Illinois | 17117 | 4350 | 108 |
1050205 | 1050205 | 2021-02-20 | Monroe | Wisconsin | 55081 | 4350 | 32 |
999840 | 999840 | 2021-02-05 | Callaway | Missouri | 29027 | 4350 | 37 |
973000 | 973000 | 2021-01-28 | Jackson | Illinois | 17077 | 4350 | 70 |
964740 | 964740 | 2021-01-25 | Mercer | Ohio | 39107 | 4350 | 89 |
911802 | 911802 | 2021-01-09 | Pulaski | Kentucky | 21199 | 4350 | 65 |
909535 | 909535 | 2021-01-08 | Darke | Ohio | 39037 | 4350 | 86 |
891595 | 891595 | 2021-01-03 | Monroe | Florida | 12087 | 4350 | 35 |
888597 | 888597 | 2021-01-02 | Coles | Illinois | 17029 | 4350 | 75 |
875140 | 875140 | 2020-12-29 | Greene | Arkansas | 5055 | 4350 | 51 |
845724 | 845724 | 2020-12-19 | Grant | Wisconsin | 55043 | 4350 | 81 |
830036 | 830036 | 2020-12-15 | Jackson | Georgia | 13157 | 4350 | 65 |
812125 | 812125 | 2020-12-09 | Morton | North Dakota | 38059 | 4350 | 73 |
658479 | 658479 | 2020-10-23 | Scott | Iowa | 19163 | 4350 | 38 |
649143 | 649143 | 2020-10-20 | Ingham | Michigan | 26065 | 4350 | 61 |
649312 | 649312 | 2020-10-20 | Jackson | Mississippi | 28059 | 4350 | 81 |
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);