ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
144 rows where cases = 3406 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- New York 15
- Georgia 14
- Arkansas 11
- Illinois 6
- Virginia 6
- California 5
- Kentucky 5
- Michigan 5
- Missouri 5
- Wisconsin 5
- Colorado 4
- Iowa 4
- Pennsylvania 4
- South Carolina 4
- Tennessee 4
- Texas 4
- Washington 4
- Alabama 3
- Indiana 3
- Minnesota 3
- Nebraska 3
- North Carolina 3
- Oklahoma 3
- West Virginia 3
- Kansas 2
- Maine 2
- Mississippi 2
- Ohio 2
- Puerto Rico 2
- Florida 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496588 | 2496588 | 2022-05-12 | Gunnison | Colorado | 8051 | 3406 | 14 |
2346956 | 2346956 | 2022-03-27 | Bacon | Georgia | 13005 | 3406 | 69 |
2343703 | 2343703 | 2022-03-26 | Bacon | Georgia | 13005 | 3406 | 69 |
2340450 | 2340450 | 2022-03-25 | Bacon | Georgia | 13005 | 3406 | 69 |
2326189 | 2326189 | 2022-03-20 | Salinas | Puerto Rico | 72123 | 3406 | |
2315262 | 2315262 | 2022-03-17 | Dukes | Massachusetts | 25007 | 3406 | 0 |
2293689 | 2293689 | 2022-03-10 | Bamberg | South Carolina | 45009 | 3406 | 74 |
2290437 | 2290437 | 2022-03-09 | Bamberg | South Carolina | 45009 | 3406 | 74 |
2285166 | 2285166 | 2022-03-08 | Brooks | Georgia | 13027 | 3406 | 82 |
2287185 | 2287185 | 2022-03-08 | Bamberg | South Carolina | 45009 | 3406 | 74 |
2281914 | 2281914 | 2022-03-07 | Brooks | Georgia | 13027 | 3406 | 82 |
2278661 | 2278661 | 2022-03-06 | Brooks | Georgia | 13027 | 3406 | 82 |
2275408 | 2275408 | 2022-03-05 | Brooks | Georgia | 13027 | 3406 | 82 |
2272155 | 2272155 | 2022-03-04 | Brooks | Georgia | 13027 | 3406 | 82 |
2255763 | 2255763 | 2022-02-27 | Grand | Colorado | 8049 | 3406 | 23 |
2256590 | 2256590 | 2022-02-27 | Pendleton | Kentucky | 21191 | 3406 | 33 |
2252512 | 2252512 | 2022-02-26 | Grand | Colorado | 8049 | 3406 | 23 |
2253339 | 2253339 | 2022-02-26 | Pendleton | Kentucky | 21191 | 3406 | 33 |
2249261 | 2249261 | 2022-02-25 | Grand | Colorado | 8049 | 3406 | 23 |
2250088 | 2250088 | 2022-02-25 | Pendleton | Kentucky | 21191 | 3406 | 33 |
2241635 | 2241635 | 2022-02-22 | San German | Puerto Rico | 72125 | 3406 | |
2198001 | 2198001 | 2022-02-09 | Fleming | Kentucky | 21069 | 3406 | 44 |
2188908 | 2188908 | 2022-02-06 | Gage | Nebraska | 31067 | 3406 | 37 |
2185655 | 2185655 | 2022-02-05 | Gage | Nebraska | 31067 | 3406 | 37 |
2182403 | 2182403 | 2022-02-04 | Gage | Nebraska | 31067 | 3406 | 37 |
2157860 | 2157860 | 2022-01-27 | Lafayette | Wisconsin | 55065 | 3406 | 19 |
2152184 | 2152184 | 2022-01-26 | Pike | Indiana | 18125 | 3406 | 47 |
2148797 | 2148797 | 2022-01-25 | Greene | Illinois | 17061 | 3406 | 55 |
2142303 | 2142303 | 2022-01-23 | Johnson | Illinois | 17087 | 3406 | 43 |
2143272 | 2143272 | 2022-01-23 | Wright | Missouri | 29229 | 3406 | 71 |
2139048 | 2139048 | 2022-01-22 | Johnson | Illinois | 17087 | 3406 | 43 |
2135792 | 2135792 | 2022-01-21 | Johnson | Illinois | 17087 | 3406 | 43 |
2122532 | 2122532 | 2022-01-17 | Banks | Georgia | 13011 | 3406 | 73 |
2112245 | 2112245 | 2022-01-13 | Hardy | West Virginia | 54031 | 3406 | 41 |
2099080 | 2099080 | 2022-01-09 | Colonial Heights city | Virginia | 51570 | 3406 | 71 |
2095829 | 2095829 | 2022-01-08 | Colonial Heights city | Virginia | 51570 | 3406 | 71 |
2092577 | 2092577 | 2022-01-07 | Colonial Heights city | Virginia | 51570 | 3406 | 71 |
2083310 | 2083310 | 2022-01-05 | Colusa | California | 6011 | 3406 | 21 |
2032950 | 2032950 | 2021-12-20 | Roosevelt | New Mexico | 35041 | 3406 | 77 |
2019299 | 2019299 | 2021-12-16 | Franklin | Maine | 23007 | 3406 | 39 |
2013216 | 2013216 | 2021-12-14 | Vernon | Missouri | 29217 | 3406 | 83 |
2014181 | 2014181 | 2021-12-14 | Humphreys | Tennessee | 47085 | 3406 | 50 |
1996613 | 1996613 | 2021-12-09 | Cheboygan | Michigan | 26031 | 3406 | 78 |
1997686 | 1997686 | 2021-12-09 | Wyoming | Pennsylvania | 42131 | 3406 | 70 |
1993362 | 1993362 | 2021-12-08 | Cheboygan | Michigan | 26031 | 3406 | 78 |
1993738 | 1993738 | 2021-12-08 | Hill | Montana | 30041 | 3406 | 71 |
1973045 | 1973045 | 2021-12-02 | Elbert | Georgia | 13105 | 3406 | 91 |
1964297 | 1964297 | 2021-11-29 | Jasper | Mississippi | 28061 | 3406 | 66 |
1962819 | 1962819 | 2021-11-28 | Vilas | Wisconsin | 55125 | 3406 | 60 |
1959568 | 1959568 | 2021-11-27 | Vilas | Wisconsin | 55125 | 3406 | 60 |
1956317 | 1956317 | 2021-11-26 | Vilas | Wisconsin | 55125 | 3406 | 60 |
1931535 | 1931535 | 2021-11-19 | Hancock | Maine | 23009 | 3406 | 53 |
1897891 | 1897891 | 2021-11-09 | Marengo | Alabama | 1091 | 3406 | 93 |
1895248 | 1895248 | 2021-11-08 | Lawrence | Illinois | 17101 | 3406 | 44 |
1881366 | 1881366 | 2021-11-03 | Page | Virginia | 51139 | 3406 | 78 |
1816497 | 1816497 | 2021-10-14 | Nicholas | West Virginia | 54067 | 3406 | 38 |
1761769 | 1761769 | 2021-09-28 | Appling | Georgia | 13001 | 3406 | 87 |
1764317 | 1764317 | 2021-09-28 | Botetourt | Virginia | 51023 | 3406 | 40 |
1755416 | 1755416 | 2021-09-26 | Union | Georgia | 13291 | 3406 | 102 |
1752168 | 1752168 | 2021-09-25 | Union | Georgia | 13291 | 3406 | 102 |
1752229 | 1752229 | 2021-09-25 | Payette | Idaho | 16075 | 3406 | 48 |
1748537 | 1748537 | 2021-09-24 | Logan | Arkansas | 5083 | 3406 | 34 |
1748919 | 1748919 | 2021-09-24 | Union | Georgia | 13291 | 3406 | 102 |
1740224 | 1740224 | 2021-09-21 | Randolph | Missouri | 29175 | 3406 | 36 |
1673022 | 1673022 | 2021-08-31 | Smith | Tennessee | 47159 | 3406 | 41 |
1630946 | 1630946 | 2021-08-18 | Kleberg | Texas | 48273 | 3406 | 97 |
1623069 | 1623069 | 2021-08-16 | Nicollet | Minnesota | 27103 | 3406 | 45 |
1603764 | 1603764 | 2021-08-10 | McDonald | Missouri | 29119 | 3406 | 43 |
1588860 | 1588860 | 2021-08-05 | Uintah | Utah | 49047 | 3406 | 30 |
1561116 | 1561116 | 2021-07-28 | Jefferson Davis | Louisiana | 22053 | 3406 | 99 |
1517584 | 1517584 | 2021-07-14 | Kittitas | Washington | 53037 | 3406 | 37 |
1509484 | 1509484 | 2021-07-12 | Pike | Mississippi | 28113 | 3406 | 111 |
1494349 | 1494349 | 2021-07-07 | Henry | Tennessee | 47079 | 3406 | 76 |
1490399 | 1490399 | 2021-07-06 | Greene | New York | 36039 | 3406 | 79 |
1487152 | 1487152 | 2021-07-05 | Greene | New York | 36039 | 3406 | 79 |
1483906 | 1483906 | 2021-07-04 | Greene | New York | 36039 | 3406 | 79 |
1480660 | 1480660 | 2021-07-03 | Greene | New York | 36039 | 3406 | 79 |
1477413 | 1477413 | 2021-07-02 | Greene | New York | 36039 | 3406 | 79 |
1474167 | 1474167 | 2021-07-01 | Greene | New York | 36039 | 3406 | 79 |
1470921 | 1470921 | 2021-06-30 | Greene | New York | 36039 | 3406 | 79 |
1467676 | 1467676 | 2021-06-29 | Greene | New York | 36039 | 3406 | 79 |
1464431 | 1464431 | 2021-06-28 | Greene | New York | 36039 | 3406 | 79 |
1461186 | 1461186 | 2021-06-27 | Greene | New York | 36039 | 3406 | 79 |
1457941 | 1457941 | 2021-06-26 | Greene | New York | 36039 | 3406 | 79 |
1454696 | 1454696 | 2021-06-25 | Greene | New York | 36039 | 3406 | 79 |
1451451 | 1451451 | 2021-06-24 | Greene | New York | 36039 | 3406 | 79 |
1357436 | 1357436 | 2021-05-26 | Pasquotank | North Carolina | 37139 | 3406 | 83 |
1331463 | 1331463 | 2021-05-18 | Person | North Carolina | 37145 | 3406 | 69 |
1320520 | 1320520 | 2021-05-15 | Ripley | Indiana | 18137 | 3406 | 70 |
1311560 | 1311560 | 2021-05-12 | Lawrence | Missouri | 29109 | 3406 | 82 |
1298370 | 1298370 | 2021-05-08 | Freeborn | Minnesota | 27047 | 3406 | 29 |
1290389 | 1290389 | 2021-05-05 | Fayette | West Virginia | 54019 | 3406 | 75 |
1243609 | 1243609 | 2021-04-21 | Cheshire | New Hampshire | 33005 | 3406 | 33 |
1229039 | 1229039 | 2021-04-17 | Lake | California | 6033 | 3406 | 43 |
1182444 | 1182444 | 2021-04-02 | Wayne | Pennsylvania | 42127 | 3406 | 71 |
1177056 | 1177056 | 2021-04-01 | Yell | Arkansas | 5149 | 3406 | 64 |
1173809 | 1173809 | 2021-03-31 | Yell | Arkansas | 5149 | 3406 | 64 |
1175480 | 1175480 | 2021-03-31 | Cortland | New York | 36023 | 3406 | 60 |
1170562 | 1170562 | 2021-03-30 | Yell | Arkansas | 5149 | 3406 | 64 |
1167314 | 1167314 | 2021-03-29 | Yell | Arkansas | 5149 | 3406 | 64 |
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);