ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 7033 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- North Carolina 6
- Minnesota 5
- Texas 5
- Mississippi 4
- Virginia 4
- Arkansas 3
- Indiana 3
- New Jersey 2
- Alabama 1
- Arizona 1
- Colorado 1
- Georgia 1
- Missouri 1
- Montana 1
- New Hampshire 1
- New York 1
- Pennsylvania 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2427485 | 2427485 | 2022-04-20 | Palo Pinto | Texas | 48363 | 7033 | 154 |
2398358 | 2398358 | 2022-04-11 | Halifax | Virginia | 51083 | 7033 | 155 |
2380751 | 2380751 | 2022-04-06 | Ravalli | Montana | 30081 | 7033 | 141 |
2351185 | 2351185 | 2022-03-28 | Lyon | Minnesota | 27083 | 7033 | 72 |
2347932 | 2347932 | 2022-03-27 | Lyon | Minnesota | 27083 | 7033 | 72 |
2344679 | 2344679 | 2022-03-26 | Lyon | Minnesota | 27083 | 7033 | 72 |
2341426 | 2341426 | 2022-03-25 | Lyon | Minnesota | 27083 | 7033 | 72 |
2256214 | 2256214 | 2022-02-27 | Decatur | Indiana | 18031 | 7033 | 141 |
2252963 | 2252963 | 2022-02-26 | Decatur | Indiana | 18031 | 7033 | 141 |
2249712 | 2249712 | 2022-02-25 | Decatur | Indiana | 18031 | 7033 | 141 |
2217856 | 2217856 | 2022-02-15 | Mille Lacs | Minnesota | 27095 | 7033 | 106 |
2200702 | 2200702 | 2022-02-10 | Lumpkin | Georgia | 13187 | 7033 | 118 |
2180438 | 2180438 | 2022-02-03 | Isle of Wight | Virginia | 51093 | 7033 | 93 |
2111085 | 2111085 | 2022-01-13 | Jackson | North Carolina | 37099 | 7033 | 80 |
2085416 | 2085416 | 2022-01-05 | Jefferson | Pennsylvania | 42065 | 7033 | 186 |
2034084 | 2034084 | 2021-12-20 | Franklin | Virginia | 51067 | 7033 | 120 |
1988994 | 1988994 | 2021-12-07 | Independence | Arkansas | 5063 | 7033 | 161 |
1983825 | 1983825 | 2021-12-05 | Pontotoc | Mississippi | 28115 | 7033 | 110 |
1980575 | 1980575 | 2021-12-04 | Pontotoc | Mississippi | 28115 | 7033 | 110 |
1977325 | 1977325 | 2021-12-03 | Pontotoc | Mississippi | 28115 | 7033 | 110 |
1964360 | 1964360 | 2021-11-29 | Butler | Missouri | 29023 | 7033 | 126 |
1964635 | 1964635 | 2021-11-29 | Cheshire | New Hampshire | 33005 | 7033 | 56 |
1917400 | 1917400 | 2021-11-15 | Russell | Alabama | 1113 | 7033 | 63 |
1898098 | 1898098 | 2021-11-09 | Broomfield | Colorado | 8014 | 7033 | 84 |
1806367 | 1806367 | 2021-10-11 | Jim Wells | Texas | 48249 | 7033 | 169 |
1803117 | 1803117 | 2021-10-10 | Jim Wells | Texas | 48249 | 7033 | 169 |
1767498 | 1767498 | 2021-09-29 | Wilson | Texas | 48493 | 7033 | 114 |
1746626 | 1746626 | 2021-09-23 | Washington | Mississippi | 28151 | 7033 | 150 |
1722068 | 1722068 | 2021-09-15 | Albemarle | Virginia | 51003 | 7033 | 89 |
1426966 | 1426966 | 2021-06-17 | Gila | Arizona | 4007 | 7033 | 229 |
1393102 | 1393102 | 2021-06-06 | Franklin | North Carolina | 37069 | 7033 | 51 |
1389857 | 1389857 | 2021-06-05 | Franklin | North Carolina | 37069 | 7033 | 51 |
1386612 | 1386612 | 2021-06-04 | Franklin | North Carolina | 37069 | 7033 | 51 |
1383367 | 1383367 | 2021-06-03 | Franklin | North Carolina | 37069 | 7033 | 51 |
1245200 | 1245200 | 2021-04-22 | Crawford | Arkansas | 5033 | 7033 | 119 |
1214451 | 1214451 | 2021-04-12 | Chemung | New York | 36015 | 7033 | 133 |
1108309 | 1108309 | 2021-03-10 | Wise | Texas | 48497 | 7033 | 113 |
1040705 | 1040705 | 2021-02-18 | White | Arkansas | 5145 | 7033 | 104 |
854083 | 854083 | 2020-12-22 | Cumberland | New Jersey | 34011 | 7033 | 205 |
773056 | 773056 | 2020-11-27 | Alamance | North Carolina | 37001 | 7033 | 97 |
204695 | 204695 | 2020-06-03 | Mercer | New Jersey | 34021 | 7033 | 485 |
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);