ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where cases = 10223 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- Missouri 8
- Mississippi 6
- North Carolina 4
- New Jersey 2
- Ohio 2
- Tennessee 2
- Alaska 1
- Arkansas 1
- Georgia 1
- Illinois 1
- Indiana 1
- Maine 1
- Michigan 1
- Nevada 1
- Pennsylvania 1
- Texas 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2461981 | 2461981 | 2022-05-01 | Warren | Mississippi | 28149 | 10223 | 202 |
2458725 | 2458725 | 2022-04-30 | Warren | Mississippi | 28149 | 10223 | 202 |
2455469 | 2455469 | 2022-04-29 | Warren | Mississippi | 28149 | 10223 | 202 |
2452213 | 2452213 | 2022-04-28 | Warren | Mississippi | 28149 | 10223 | 202 |
2448957 | 2448957 | 2022-04-27 | Warren | Mississippi | 28149 | 10223 | 202 |
2445700 | 2445700 | 2022-04-26 | Warren | Mississippi | 28149 | 10223 | 202 |
2430984 | 2430984 | 2022-04-21 | Tazewell | Virginia | 51185 | 10223 | 171 |
2427466 | 2427466 | 2022-04-20 | Medina | Texas | 48325 | 10223 | 197 |
2395983 | 2395983 | 2022-04-11 | Christian | Illinois | 17021 | 10223 | 129 |
2192232 | 2192232 | 2022-02-07 | Lyon | Nevada | 32019 | 10223 | 156 |
2173041 | 2173041 | 2022-02-01 | Highland | Ohio | 39071 | 10223 | 156 |
2146485 | 2146485 | 2022-01-24 | Newton | Missouri | 29145 | 10223 | 177 |
2009067 | 2009067 | 2021-12-13 | Boone | Indiana | 18011 | 10223 | 134 |
1984288 | 1984288 | 2021-12-05 | Duplin | North Carolina | 37061 | 10223 | 198 |
1981038 | 1981038 | 2021-12-04 | Duplin | North Carolina | 37061 | 10223 | 198 |
1977788 | 1977788 | 2021-12-03 | Duplin | North Carolina | 37061 | 10223 | 198 |
1907733 | 1907733 | 2021-11-12 | Greene | Arkansas | 5055 | 10223 | 124 |
1799251 | 1799251 | 2021-10-09 | Ross | Ohio | 39141 | 10223 | 188 |
1712721 | 1712721 | 2021-09-13 | Fairbanks North Star Borough | Alaska | 2090 | 10223 | 51 |
1636947 | 1636947 | 2021-08-20 | Adams | Pennsylvania | 42001 | 10223 | 190 |
1607264 | 1607264 | 2021-08-11 | Warren | New Jersey | 34041 | 10223 | 242 |
1535907 | 1535907 | 2021-07-20 | Burke | North Carolina | 37023 | 10223 | 164 |
1392684 | 1392684 | 2021-06-06 | Clay | Missouri | 29047 | 10223 | 169 |
1389439 | 1389439 | 2021-06-05 | Clay | Missouri | 29047 | 10223 | 169 |
1386194 | 1386194 | 2021-06-04 | Clay | Missouri | 29047 | 10223 | 169 |
1382949 | 1382949 | 2021-06-03 | Clay | Missouri | 29047 | 10223 | 169 |
1165388 | 1165388 | 2021-03-28 | Buchanan | Missouri | 29021 | 10223 | 179 |
1162140 | 1162140 | 2021-03-27 | Buchanan | Missouri | 29021 | 10223 | 179 |
1158892 | 1158892 | 2021-03-26 | Buchanan | Missouri | 29021 | 10223 | 179 |
1142352 | 1142352 | 2021-03-21 | York | Maine | 23031 | 10223 | 125 |
1054795 | 1054795 | 2021-02-22 | Livingston | Michigan | 26093 | 10223 | 139 |
1031197 | 1031197 | 2021-02-15 | Carroll | Georgia | 13045 | 10223 | 190 |
887353 | 887353 | 2021-01-01 | Washington | Tennessee | 47179 | 10223 | 165 |
884108 | 884108 | 2020-12-31 | Washington | Tennessee | 47179 | 10223 | 165 |
604248 | 604248 | 2020-10-06 | Camden | New Jersey | 34007 | 10223 | 612 |
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);