ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
85 rows where cases = 6845 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Georgia 10
- Michigan 7
- Oklahoma 7
- Virginia 7
- Texas 6
- Indiana 5
- Louisiana 4
- Mississippi 4
- North Carolina 4
- Illinois 3
- Kansas 3
- New Mexico 3
- Arkansas 2
- Minnesota 2
- Missouri 2
- New York 2
- Ohio 2
- Puerto Rico 2
- Tennessee 2
- Kentucky 1
- Maryland 1
- Nevada 1
- New Jersey 1
- Pennsylvania 1
- South Carolina 1
- South Dakota 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500094 | 2500094 | 2022-05-13 | Sumter | Georgia | 13261 | 6845 | 170 |
2496836 | 2496836 | 2022-05-12 | Sumter | Georgia | 13261 | 6845 | 170 |
2493578 | 2493578 | 2022-05-11 | Sumter | Georgia | 13261 | 6845 | 170 |
2490320 | 2490320 | 2022-05-10 | Sumter | Georgia | 13261 | 6845 | 169 |
2487063 | 2487063 | 2022-05-09 | Sumter | Georgia | 13261 | 6845 | 169 |
2356507 | 2356507 | 2022-03-30 | Yell | Arkansas | 5149 | 6845 | 104 |
2347358 | 2347358 | 2022-03-27 | White | Indiana | 18181 | 6845 | 93 |
2344105 | 2344105 | 2022-03-26 | White | Indiana | 18181 | 6845 | 93 |
2340852 | 2340852 | 2022-03-25 | White | Indiana | 18181 | 6845 | 93 |
2334705 | 2334705 | 2022-03-23 | Morehouse | Louisiana | 22067 | 6845 | 133 |
2265971 | 2265971 | 2022-03-02 | Fayette | Indiana | 18041 | 6845 | 144 |
2265013 | 2265013 | 2022-03-01 | Orange | Virginia | 51137 | 6845 | 85 |
2237164 | 2237164 | 2022-02-21 | Union | Louisiana | 22111 | 6845 | 125 |
2224363 | 2224363 | 2022-02-17 | Nobles | Minnesota | 27105 | 6845 | 58 |
2215566 | 2215566 | 2022-02-14 | Aguadilla | Puerto Rico | 72005 | 6845 | |
2215740 | 2215740 | 2022-02-14 | Meade | South Dakota | 46093 | 6845 | 59 |
2212315 | 2212315 | 2022-02-13 | Aguadilla | Puerto Rico | 72005 | 6845 | |
2194196 | 2194196 | 2022-02-08 | Madison | Georgia | 13195 | 6845 | 86 |
2173135 | 2173135 | 2022-02-01 | Lincoln | Oklahoma | 40081 | 6845 | 119 |
2169883 | 2169883 | 2022-01-31 | Lincoln | Oklahoma | 40081 | 6845 | 119 |
2166628 | 2166628 | 2022-01-30 | Lincoln | Oklahoma | 40081 | 6845 | 119 |
2163373 | 2163373 | 2022-01-29 | Lincoln | Oklahoma | 40081 | 6845 | 119 |
2160118 | 2160118 | 2022-01-28 | Lincoln | Oklahoma | 40081 | 6845 | 119 |
2156863 | 2156863 | 2022-01-27 | Lincoln | Oklahoma | 40081 | 6845 | 119 |
2153610 | 2153610 | 2022-01-26 | Lincoln | Oklahoma | 40081 | 6845 | 119 |
2142613 | 2142613 | 2022-01-23 | McPherson | Kansas | 20113 | 6845 | 112 |
2139358 | 2139358 | 2022-01-22 | McPherson | Kansas | 20113 | 6845 | 112 |
2136102 | 2136102 | 2022-01-21 | McPherson | Kansas | 20113 | 6845 | 112 |
2130966 | 2130966 | 2022-01-19 | Susquehanna | Pennsylvania | 42115 | 6845 | 96 |
2099183 | 2099183 | 2022-01-09 | Wise | Virginia | 51195 | 6845 | 147 |
2095932 | 2095932 | 2022-01-08 | Wise | Virginia | 51195 | 6845 | 147 |
2092680 | 2092680 | 2022-01-07 | Wise | Virginia | 51195 | 6845 | 147 |
2006370 | 2006370 | 2021-12-12 | Delta | Michigan | 26041 | 6845 | 129 |
2003119 | 2003119 | 2021-12-11 | Delta | Michigan | 26041 | 6845 | 129 |
1999869 | 1999869 | 2021-12-10 | Delta | Michigan | 26041 | 6845 | 129 |
1996823 | 1996823 | 2021-12-09 | Panola | Mississippi | 28107 | 6845 | 136 |
1941584 | 1941584 | 2021-11-22 | Warren | Mississippi | 28149 | 6845 | 178 |
1938744 | 1938744 | 2021-11-21 | Warren | New York | 36113 | 6845 | 91 |
1938844 | 1938844 | 2021-11-21 | Watauga | North Carolina | 37189 | 6845 | 40 |
1935594 | 1935594 | 2021-11-20 | Watauga | North Carolina | 37189 | 6845 | 40 |
1932344 | 1932344 | 2021-11-19 | Watauga | North Carolina | 37189 | 6845 | 40 |
1929163 | 1929163 | 2021-11-18 | Brown | Ohio | 39015 | 6845 | 109 |
1920006 | 1920006 | 2021-11-15 | Cherokee | Texas | 48073 | 6845 | 227 |
1916756 | 1916756 | 2021-11-14 | Cherokee | Texas | 48073 | 6845 | 227 |
1913506 | 1913506 | 2021-11-13 | Cherokee | Texas | 48073 | 6845 | 227 |
1910256 | 1910256 | 2021-11-12 | Cherokee | Texas | 48073 | 6845 | 227 |
1907007 | 1907007 | 2021-11-11 | Cherokee | Texas | 48073 | 6845 | 226 |
1854423 | 1854423 | 2021-10-26 | Auglaize | Ohio | 39011 | 6845 | 99 |
1814531 | 1814531 | 2021-10-14 | St. Bernard | Louisiana | 22087 | 6845 | 97 |
1811154 | 1811154 | 2021-10-13 | Floyd | Kentucky | 21071 | 6845 | 109 |
1807525 | 1807525 | 2021-10-12 | Macoupin | Illinois | 17117 | 6845 | 133 |
1762972 | 1762972 | 2021-09-28 | Scott | Missouri | 29201 | 6845 | 110 |
1736856 | 1736856 | 2021-09-20 | Oktibbeha | Mississippi | 28105 | 6845 | 118 |
1719048 | 1719048 | 2021-09-14 | Barron | Wisconsin | 55005 | 6845 | 86 |
1701575 | 1701575 | 2021-09-09 | Carteret | North Carolina | 37031 | 6845 | 58 |
1653862 | 1653862 | 2021-08-25 | Augusta | Virginia | 51015 | 6845 | 84 |
1581013 | 1581013 | 2021-08-03 | Lincoln | Missouri | 29113 | 6845 | 53 |
1537652 | 1537652 | 2021-07-21 | Catoosa | Georgia | 13047 | 6845 | 76 |
1508772 | 1508772 | 2021-07-12 | Morgan | Indiana | 18109 | 6845 | 147 |
1496373 | 1496373 | 2021-07-08 | Crow Wing | Minnesota | 27035 | 6845 | 97 |
1469662 | 1469662 | 2021-06-30 | Boone | Illinois | 17007 | 6845 | 90 |
1466417 | 1466417 | 2021-06-29 | Boone | Illinois | 17007 | 6845 | 90 |
1339634 | 1339634 | 2021-05-21 | Bulloch | Georgia | 13031 | 6845 | 116 |
1324815 | 1324815 | 2021-05-16 | Eddy | New Mexico | 35015 | 6845 | 129 |
1321569 | 1321569 | 2021-05-15 | Eddy | New Mexico | 35015 | 6845 | 129 |
1318323 | 1318323 | 2021-05-14 | Eddy | New Mexico | 35015 | 6845 | 129 |
1309309 | 1309309 | 2021-05-11 | Dickson | Tennessee | 47043 | 6845 | 113 |
1247616 | 1247616 | 2021-04-22 | Coffee | Tennessee | 47031 | 6845 | 121 |
1233346 | 1233346 | 2021-04-18 | Clinton | Michigan | 26037 | 6845 | 79 |
1230098 | 1230098 | 2021-04-17 | Clinton | Michigan | 26037 | 6845 | 79 |
1109221 | 1109221 | 2021-03-11 | Walker | Georgia | 13295 | 6845 | 80 |
1106664 | 1106664 | 2021-03-10 | Wicomico | Maryland | 24045 | 6845 | 145 |
1095825 | 1095825 | 2021-03-07 | Crawford | Arkansas | 5033 | 6845 | 103 |
1088632 | 1088632 | 2021-03-04 | Coryell | Texas | 48099 | 6845 | 78 |
1039071 | 1039071 | 2021-02-17 | Cape May | New Jersey | 34009 | 6845 | 175 |
1024053 | 1024053 | 2021-02-12 | Montgomery | Virginia | 51121 | 6845 | 68 |
937914 | 937914 | 2021-01-17 | Bay | Michigan | 26017 | 6845 | 236 |
934669 | 934669 | 2021-01-16 | Bay | Michigan | 26017 | 6845 | 236 |
858458 | 858458 | 2020-12-23 | Alexandria city | Virginia | 51510 | 6845 | 85 |
847672 | 847672 | 2020-12-20 | Niagara | New York | 36063 | 6845 | 156 |
833243 | 833243 | 2020-12-16 | Coweta | Georgia | 13077 | 6845 | 78 |
801801 | 801801 | 2020-12-06 | Jackson | Mississippi | 28059 | 6845 | 131 |
652270 | 652270 | 2020-10-21 | Ouachita | Louisiana | 22073 | 6845 | 160 |
365866 | 365866 | 2020-07-24 | Richland | South Carolina | 45079 | 6845 | 124 |
201584 | 201584 | 2020-06-02 | Clark | Nevada | 32003 | 6845 | 346 |
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);