ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where cases = 6747 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Tennessee 9
- Texas 6
- Georgia 5
- Illinois 5
- Puerto Rico 5
- Virginia 5
- Pennsylvania 4
- Indiana 3
- Louisiana 3
- Alabama 2
- Kansas 2
- Ohio 2
- Idaho 1
- Maryland 1
- Minnesota 1
- Missouri 1
- New Jersey 1
- North Carolina 1
- Oklahoma 1
- Washington 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502530 | 2502530 | 2022-05-13 | Carroll | Virginia | 51035 | 6747 | 148 |
2490526 | 2490526 | 2022-05-10 | Fayette | Indiana | 18041 | 6747 | 146 |
2487269 | 2487269 | 2022-05-09 | Fayette | Indiana | 18041 | 6747 | 146 |
2449817 | 2449817 | 2022-04-27 | Canovanas | Puerto Rico | 72029 | 6747 | |
2446955 | 2446955 | 2022-04-26 | Hutchinson | Texas | 48233 | 6747 | 134 |
2443700 | 2443700 | 2022-04-25 | Hutchinson | Texas | 48233 | 6747 | 134 |
2440444 | 2440444 | 2022-04-24 | Hutchinson | Texas | 48233 | 6747 | 134 |
2437188 | 2437188 | 2022-04-23 | Hutchinson | Texas | 48233 | 6747 | 134 |
2433932 | 2433932 | 2022-04-22 | Hutchinson | Texas | 48233 | 6747 | 134 |
2414012 | 2414012 | 2022-04-16 | Dorado | Puerto Rico | 72051 | 6747 | |
2410756 | 2410756 | 2022-04-15 | Dorado | Puerto Rico | 72051 | 6747 | |
2407500 | 2407500 | 2022-04-14 | Dorado | Puerto Rico | 72051 | 6747 | |
2310085 | 2310085 | 2022-03-15 | Grainger | Tennessee | 47057 | 6747 | 103 |
2306832 | 2306832 | 2022-03-14 | Grainger | Tennessee | 47057 | 6747 | 103 |
2303581 | 2303581 | 2022-03-13 | Grainger | Tennessee | 47057 | 6747 | 103 |
2300329 | 2300329 | 2022-03-12 | Grainger | Tennessee | 47057 | 6747 | 103 |
2297077 | 2297077 | 2022-03-11 | Grainger | Tennessee | 47057 | 6747 | 103 |
2293825 | 2293825 | 2022-03-10 | Grainger | Tennessee | 47057 | 6747 | 103 |
2290573 | 2290573 | 2022-03-09 | Grainger | Tennessee | 47057 | 6747 | 103 |
2287911 | 2287911 | 2022-03-08 | Upshur | West Virginia | 54097 | 6747 | 85 |
2246259 | 2246259 | 2022-02-24 | Sumter | Georgia | 13261 | 6747 | 156 |
2195091 | 2195091 | 2022-02-08 | Nobles | Minnesota | 27105 | 6747 | 57 |
2105648 | 2105648 | 2022-01-11 | Petersburg city | Virginia | 51730 | 6747 | 109 |
2086962 | 2086962 | 2022-01-06 | Nez Perce | Idaho | 16069 | 6747 | 118 |
2086177 | 2086177 | 2022-01-05 | Wise | Virginia | 51195 | 6747 | 147 |
2065893 | 2065893 | 2021-12-30 | Clinton | Pennsylvania | 42035 | 6747 | 104 |
2035277 | 2035277 | 2021-12-21 | Cowley | Kansas | 20035 | 6747 | 133 |
2032027 | 2032027 | 2021-12-20 | Cowley | Kansas | 20035 | 6747 | 133 |
2021070 | 2021070 | 2021-12-16 | Danville city | Virginia | 51590 | 6747 | 204 |
1996866 | 1996866 | 2021-12-09 | Camden | Missouri | 29029 | 6747 | 148 |
1925922 | 1925922 | 2021-11-17 | Crawford | Ohio | 39033 | 6747 | 144 |
1896922 | 1896922 | 2021-11-08 | Venango | Pennsylvania | 42121 | 6747 | 145 |
1858864 | 1858864 | 2021-10-28 | Chilton | Alabama | 1021 | 6747 | 162 |
1826387 | 1826387 | 2021-10-18 | Escambia | Alabama | 1053 | 6747 | 127 |
1783238 | 1783238 | 2021-10-04 | Guaynabo | Puerto Rico | 72061 | 6747 | |
1765792 | 1765792 | 2021-09-29 | St. Bernard | Louisiana | 22087 | 6747 | 95 |
1753957 | 1753957 | 2021-09-25 | Union | Pennsylvania | 42119 | 6747 | 94 |
1747408 | 1747408 | 2021-09-23 | Bradford | Pennsylvania | 42015 | 6747 | 106 |
1690447 | 1690447 | 2021-09-06 | Ware | Georgia | 13299 | 6747 | 201 |
1690580 | 1690580 | 2021-09-06 | Ogle | Illinois | 17141 | 6747 | 92 |
1687197 | 1687197 | 2021-09-05 | Ware | Georgia | 13299 | 6747 | 201 |
1687330 | 1687330 | 2021-09-05 | Ogle | Illinois | 17141 | 6747 | 92 |
1683947 | 1683947 | 2021-09-04 | Ware | Georgia | 13299 | 6747 | 201 |
1684080 | 1684080 | 2021-09-04 | Ogle | Illinois | 17141 | 6747 | 92 |
1680696 | 1680696 | 2021-09-03 | Ware | Georgia | 13299 | 6747 | 201 |
1680829 | 1680829 | 2021-09-03 | Ogle | Illinois | 17141 | 6747 | 92 |
1533273 | 1533273 | 2021-07-19 | Bedford | Tennessee | 47003 | 6747 | 133 |
1442387 | 1442387 | 2021-06-21 | Carter | Tennessee | 47019 | 6747 | 158 |
1346328 | 1346328 | 2021-05-23 | Boone | Illinois | 17007 | 6747 | 87 |
1282854 | 1282854 | 2021-05-03 | Ashtabula | Ohio | 39007 | 6747 | 168 |
1213742 | 1213742 | 2021-04-12 | Iberia | Louisiana | 22045 | 6747 | 152 |
1029334 | 1029334 | 2021-02-14 | Cape May | New Jersey | 34009 | 6747 | 175 |
1020893 | 1020893 | 2021-02-11 | Thurston | Washington | 53067 | 6747 | 72 |
973066 | 973066 | 2021-01-28 | Bartholomew | Indiana | 18005 | 6747 | 107 |
912909 | 912909 | 2021-01-09 | Payne | Oklahoma | 40119 | 6747 | 33 |
566547 | 566547 | 2020-09-24 | Loudoun | Virginia | 51107 | 6747 | 124 |
556481 | 556481 | 2020-09-21 | Brazos | Texas | 48041 | 6747 | 62 |
546062 | 546062 | 2020-09-18 | Forsyth | North Carolina | 37067 | 6747 | 94 |
319835 | 319835 | 2020-07-10 | East Baton Rouge | Louisiana | 22033 | 6747 | 277 |
105001 | 105001 | 2020-05-01 | Prince George's | Maryland | 24033 | 6747 | 243 |
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);