ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
107 rows where cases = 4930 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 17
- Alabama 6
- Georgia 6
- Michigan 6
- Indiana 5
- Kentucky 5
- Nebraska 5
- South Carolina 5
- Virginia 5
- Louisiana 4
- Missouri 4
- Washington 4
- Maine 3
- Mississippi 3
- Ohio 3
- Puerto Rico 3
- Vermont 3
- California 2
- Minnesota 2
- New York 2
- North Carolina 2
- Arkansas 1
- Colorado 1
- Florida 1
- Hawaii 1
- Illinois 1
- North Dakota 1
- Oklahoma 1
- Oregon 1
- Pennsylvania 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475929 | 2475929 | 2022-05-05 | Yauco | Puerto Rico | 72153 | 4930 | |
2420957 | 2420957 | 2022-04-18 | Milam | Texas | 48331 | 4930 | 101 |
2421084 | 2421084 | 2022-04-18 | Orange | Vermont | 50017 | 4930 | 14 |
2353468 | 2353468 | 2022-03-29 | Berrien | Georgia | 13019 | 4930 | 82 |
2350216 | 2350216 | 2022-03-28 | Berrien | Georgia | 13019 | 4930 | 82 |
2325370 | 2325370 | 2022-03-20 | Perry | Missouri | 29157 | 4930 | 44 |
2322116 | 2322116 | 2022-03-19 | Perry | Missouri | 29157 | 4930 | 44 |
2318862 | 2318862 | 2022-03-18 | Perry | Missouri | 29157 | 4930 | 44 |
2307299 | 2307299 | 2022-03-14 | Powhatan | Virginia | 51145 | 4930 | 55 |
2293611 | 2293611 | 2022-03-10 | Cabo Rojo | Puerto Rico | 72023 | 4930 | |
2259938 | 2259938 | 2022-02-28 | Lincoln | Maine | 23015 | 4930 | 29 |
2256687 | 2256687 | 2022-02-27 | Lincoln | Maine | 23015 | 4930 | 29 |
2256803 | 2256803 | 2022-02-27 | Osceola | Michigan | 26133 | 4930 | 77 |
2253552 | 2253552 | 2022-02-26 | Osceola | Michigan | 26133 | 4930 | 77 |
2250301 | 2250301 | 2022-02-25 | Osceola | Michigan | 26133 | 4930 | 77 |
2221993 | 2221993 | 2022-02-16 | Union | Oregon | 41061 | 4930 | 71 |
2190465 | 2190465 | 2022-02-07 | Cherokee | Alabama | 1019 | 4930 | 70 |
2166128 | 2166128 | 2022-01-30 | Dawson | Nebraska | 31047 | 4930 | 41 |
2162873 | 2162873 | 2022-01-29 | Dawson | Nebraska | 31047 | 4930 | 41 |
2159618 | 2159618 | 2022-01-28 | Dawson | Nebraska | 31047 | 4930 | 41 |
2152069 | 2152069 | 2022-01-26 | Lawrence | Illinois | 17101 | 4930 | 49 |
2143124 | 2143124 | 2022-01-23 | Newton | Mississippi | 28101 | 4930 | 86 |
2139869 | 2139869 | 2022-01-22 | Newton | Mississippi | 28101 | 4930 | 86 |
2136613 | 2136613 | 2022-01-21 | Newton | Mississippi | 28101 | 4930 | 86 |
2084789 | 2084789 | 2022-01-05 | Adams | Nebraska | 31001 | 4930 | 56 |
2076438 | 2076438 | 2022-01-02 | Island | Washington | 53029 | 4930 | 56 |
2073187 | 2073187 | 2022-01-01 | Island | Washington | 53029 | 4930 | 56 |
2069936 | 2069936 | 2021-12-31 | Island | Washington | 53029 | 4930 | 56 |
2063622 | 2063622 | 2021-12-30 | Clarke | Alabama | 1025 | 4930 | 88 |
2066685 | 2066685 | 2021-12-30 | Island | Washington | 53029 | 4930 | 56 |
2056785 | 2056785 | 2021-12-27 | Windsor | Vermont | 50027 | 4930 | 42 |
2042990 | 2042990 | 2021-12-23 | Pike | Ohio | 39131 | 4930 | 80 |
2037652 | 2037652 | 2021-12-22 | Lawrence | Alabama | 1079 | 4930 | 134 |
2037278 | 2037278 | 2021-12-21 | Franklin | Vermont | 50011 | 4930 | 55 |
1984803 | 1984803 | 2021-12-05 | Marlboro | South Carolina | 45069 | 4930 | 83 |
1981553 | 1981553 | 2021-12-04 | Marlboro | South Carolina | 45069 | 4930 | 83 |
1978303 | 1978303 | 2021-12-03 | Marlboro | South Carolina | 45069 | 4930 | 83 |
1917627 | 1917627 | 2021-11-15 | Logan | Colorado | 8075 | 4930 | 87 |
1791694 | 1791694 | 2021-10-07 | Logan | Kentucky | 21141 | 4930 | 79 |
1768925 | 1768925 | 2021-09-30 | Harlan | Kentucky | 21095 | 4930 | 116 |
1765368 | 1765368 | 2021-09-29 | Jasper | Indiana | 18073 | 4930 | 68 |
1721014 | 1721014 | 2021-09-15 | Montgomery | New York | 36057 | 4930 | 133 |
1693166 | 1693166 | 2021-09-07 | Chambers | Alabama | 1017 | 4930 | 127 |
1664665 | 1664665 | 2021-08-29 | Knox | Indiana | 18083 | 4930 | 92 |
1661417 | 1661417 | 2021-08-28 | Knox | Indiana | 18083 | 4930 | 92 |
1658169 | 1658169 | 2021-08-27 | Knox | Indiana | 18083 | 4930 | 92 |
1609179 | 1609179 | 2021-08-12 | Liberty | Georgia | 13179 | 4930 | 72 |
1602618 | 1602618 | 2021-08-10 | Chattahoochee | Georgia | 13053 | 4930 | 17 |
1604150 | 1604150 | 2021-08-10 | Haywood | North Carolina | 37087 | 4930 | 100 |
1543730 | 1543730 | 2021-07-22 | Sweetwater | Wyoming | 56037 | 4930 | 43 |
1536392 | 1536392 | 2021-07-20 | Toa Baja | Puerto Rico | 72137 | 4930 | |
1502078 | 1502078 | 2021-07-10 | Maui | Hawaii | 15009 | 4930 | 57 |
1490963 | 1490963 | 2021-07-06 | Chesterfield | South Carolina | 45025 | 4930 | 108 |
1487716 | 1487716 | 2021-07-05 | Chesterfield | South Carolina | 45025 | 4930 | 108 |
1443120 | 1443120 | 2021-06-22 | Dale | Alabama | 1045 | 4930 | 116 |
1439875 | 1439875 | 2021-06-21 | Dale | Alabama | 1045 | 4930 | 116 |
1415054 | 1415054 | 2021-06-13 | St. Mary | Louisiana | 22101 | 4930 | 141 |
1411809 | 1411809 | 2021-06-12 | St. Mary | Louisiana | 22101 | 4930 | 141 |
1408564 | 1408564 | 2021-06-11 | St. Mary | Louisiana | 22101 | 4930 | 141 |
1397135 | 1397135 | 2021-06-07 | Harrison | Texas | 48203 | 4930 | 110 |
1393888 | 1393888 | 2021-06-06 | Harrison | Texas | 48203 | 4930 | 110 |
1387398 | 1387398 | 2021-06-04 | Harrison | Texas | 48203 | 4930 | 110 |
1379235 | 1379235 | 2021-06-02 | Henderson | Kentucky | 21101 | 4930 | 78 |
1329290 | 1329290 | 2021-05-17 | Washington | Virginia | 51191 | 4930 | 110 |
1323521 | 1323521 | 2021-05-16 | Tift | Georgia | 13277 | 4930 | 126 |
1326044 | 1326044 | 2021-05-16 | Washington | Virginia | 51191 | 4930 | 110 |
1294880 | 1294880 | 2021-05-07 | Scott | Kentucky | 21209 | 4930 | 33 |
1288401 | 1288401 | 2021-05-05 | Whitley | Kentucky | 21235 | 4930 | 55 |
1268040 | 1268040 | 2021-04-29 | Tehama | California | 6103 | 4930 | 53 |
1244612 | 1244612 | 2021-04-21 | Medina | Texas | 48325 | 4930 | 103 |
1233952 | 1233952 | 2021-04-18 | Herkimer | New York | 36043 | 4930 | 107 |
1171647 | 1171647 | 2021-03-30 | Grand Traverse | Michigan | 26055 | 4930 | 77 |
1149788 | 1149788 | 2021-03-23 | Washington | Ohio | 39167 | 4930 | 104 |
1119805 | 1119805 | 2021-03-14 | Otter Tail | Minnesota | 27111 | 4930 | 71 |
1106625 | 1106625 | 2021-03-10 | Androscoggin | Maine | 23001 | 4930 | 57 |
1104914 | 1104914 | 2021-03-09 | Hardin | Texas | 48199 | 4930 | 97 |
1101668 | 1101668 | 2021-03-08 | Hardin | Texas | 48199 | 4930 | 96 |
1098422 | 1098422 | 2021-03-07 | Hardin | Texas | 48199 | 4930 | 96 |
1095174 | 1095174 | 2021-03-06 | Hardin | Texas | 48199 | 4930 | 96 |
1091928 | 1091928 | 2021-03-05 | Hardin | Texas | 48199 | 4930 | 96 |
1088682 | 1088682 | 2021-03-04 | Hardin | Texas | 48199 | 4930 | 95 |
1075188 | 1075188 | 2021-02-28 | Pontotoc | Oklahoma | 40123 | 4930 | 47 |
1058785 | 1058785 | 2021-02-23 | Morton | North Dakota | 38059 | 4930 | 94 |
1051582 | 1051582 | 2021-02-21 | Van Buren | Michigan | 26159 | 4930 | 95 |
1048335 | 1048335 | 2021-02-20 | Van Buren | Michigan | 26159 | 4930 | 95 |
1026432 | 1026432 | 2021-02-13 | Union | Ohio | 39159 | 4930 | 48 |
1022727 | 1022727 | 2021-02-12 | Buffalo | Nebraska | 31019 | 4930 | 54 |
1013941 | 1013941 | 2021-02-09 | Atascosa | Texas | 48013 | 4930 | 118 |
1005581 | 1005581 | 2021-02-07 | Noble | Indiana | 18113 | 4930 | 75 |
874798 | 874798 | 2020-12-28 | Stafford | Virginia | 51179 | 4930 | 23 |
839442 | 839442 | 2020-12-18 | Garland | Arkansas | 5051 | 4930 | 134 |
797447 | 797447 | 2020-12-05 | Columbia | Florida | 12023 | 4930 | 99 |
784377 | 784377 | 2020-12-01 | Yolo | California | 6113 | 4930 | 77 |
785664 | 785664 | 2020-12-01 | Franklin | Missouri | 29071 | 4930 | 83 |
787333 | 787333 | 2020-12-01 | Portage | Wisconsin | 55097 | 4930 | 39 |
780356 | 780356 | 2020-11-29 | Gregg | Texas | 48183 | 4930 | 108 |
777110 | 777110 | 2020-11-28 | Gregg | Texas | 48183 | 4930 | 108 |
773865 | 773865 | 2020-11-27 | Gregg | Texas | 48183 | 4930 | 108 |
770620 | 770620 | 2020-11-26 | Gregg | Texas | 48183 | 4930 | 108 |
767374 | 767374 | 2020-11-25 | Gregg | Texas | 48183 | 4930 | 108 |
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);