ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where cases = 6073 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Texas 18
- Kentucky 12
- North Carolina 10
- Rhode Island 7
- Arkansas 6
- California 6
- Idaho 4
- South Carolina 4
- Tennessee 4
- Virginia 4
- Indiana 3
- Missouri 3
- Vermont 3
- West Virginia 3
- Florida 2
- Georgia 2
- Illinois 2
- New York 2
- Alabama 1
- Colorado 1
- Louisiana 1
- Mississippi 1
- New Jersey 1
- Ohio 1
- Puerto Rico 1
- Virgin Islands 1
- Washington 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2451304 | 2451304 | 2022-04-28 | Jerome | Idaho | 16053 | 6073 | 65 |
2448048 | 2448048 | 2022-04-27 | Jerome | Idaho | 16053 | 6073 | 65 |
2444792 | 2444792 | 2022-04-26 | Jerome | Idaho | 16053 | 6073 | 65 |
2446175 | 2446175 | 2022-04-26 | Martin | North Carolina | 37117 | 6073 | 89 |
2441536 | 2441536 | 2022-04-25 | Jerome | Idaho | 16053 | 6073 | 65 |
2442920 | 2442920 | 2022-04-25 | Martin | North Carolina | 37117 | 6073 | 89 |
2439664 | 2439664 | 2022-04-24 | Martin | North Carolina | 37117 | 6073 | 89 |
2436408 | 2436408 | 2022-04-23 | Martin | North Carolina | 37117 | 6073 | 89 |
2433152 | 2433152 | 2022-04-22 | Martin | North Carolina | 37117 | 6073 | 89 |
2429896 | 2429896 | 2022-04-21 | Martin | North Carolina | 37117 | 6073 | 89 |
2426640 | 2426640 | 2022-04-20 | Martin | North Carolina | 37117 | 6073 | 89 |
2416023 | 2416023 | 2022-04-17 | Wayne | Kentucky | 21231 | 6073 | 90 |
2412767 | 2412767 | 2022-04-16 | Wayne | Kentucky | 21231 | 6073 | 90 |
2409511 | 2409511 | 2022-04-15 | Wayne | Kentucky | 21231 | 6073 | 90 |
2406255 | 2406255 | 2022-04-14 | Wayne | Kentucky | 21231 | 6073 | 90 |
2402999 | 2402999 | 2022-04-13 | Wayne | Kentucky | 21231 | 6073 | 90 |
2399745 | 2399745 | 2022-04-12 | Wayne | Kentucky | 21231 | 6073 | 90 |
2395833 | 2395833 | 2022-04-11 | Harris | Georgia | 13145 | 6073 | 112 |
2396489 | 2396489 | 2022-04-11 | Wayne | Kentucky | 21231 | 6073 | 90 |
2349960 | 2349960 | 2022-03-28 | Jackson | Arkansas | 5067 | 6073 | 60 |
2346707 | 2346707 | 2022-03-27 | Jackson | Arkansas | 5067 | 6073 | 60 |
2343454 | 2343454 | 2022-03-26 | Jackson | Arkansas | 5067 | 6073 | 60 |
2326193 | 2326193 | 2022-03-20 | San Sebastian | Puerto Rico | 72131 | 6073 | |
2303942 | 2303942 | 2022-03-13 | Orleans | Vermont | 50019 | 6073 | 37 |
2300690 | 2300690 | 2022-03-12 | Orleans | Vermont | 50019 | 6073 | 37 |
2297438 | 2297438 | 2022-03-11 | Orleans | Vermont | 50019 | 6073 | 37 |
2259794 | 2259794 | 2022-02-28 | Harrison | Kentucky | 21097 | 6073 | 62 |
2216780 | 2216780 | 2022-02-15 | Routt | Colorado | 8107 | 6073 | 24 |
2213848 | 2213848 | 2022-02-14 | Crawford | Illinois | 17033 | 6073 | 55 |
2191912 | 2191912 | 2022-02-07 | Leake | Mississippi | 28079 | 6073 | 105 |
2183848 | 2183848 | 2022-02-04 | Upshur | West Virginia | 54097 | 6073 | 77 |
2132610 | 2132610 | 2022-01-20 | Clay | Indiana | 18021 | 6073 | 77 |
2123178 | 2123178 | 2022-01-17 | Grant | Kentucky | 21081 | 6073 | 46 |
2119926 | 2119926 | 2022-01-16 | Grant | Kentucky | 21081 | 6073 | 46 |
2116674 | 2116674 | 2022-01-15 | Grant | Kentucky | 21081 | 6073 | 46 |
2113423 | 2113423 | 2022-01-14 | Grant | Kentucky | 21081 | 6073 | 46 |
2102303 | 2102303 | 2022-01-10 | St. Thomas | Virgin Islands | 78030 | 6073 | 46 |
2087923 | 2087923 | 2022-01-06 | Lafayette | Missouri | 29107 | 6073 | 95 |
2062928 | 2062928 | 2021-12-29 | Henderson | Tennessee | 47077 | 6073 | 118 |
2063311 | 2063311 | 2021-12-29 | Charlottesville city | Virginia | 51540 | 6073 | 63 |
1982251 | 1982251 | 2021-12-04 | Wayne | West Virginia | 54099 | 6073 | 91 |
1964710 | 1964710 | 2021-11-29 | Cortland | New York | 36023 | 6073 | 89 |
1938993 | 1938993 | 2021-11-21 | Williams | Ohio | 39171 | 6073 | 97 |
1877510 | 1877510 | 2021-11-02 | Bristol | Rhode Island | 44001 | 6073 | 149 |
1874261 | 1874261 | 2021-11-01 | Bristol | Rhode Island | 44001 | 6073 | 149 |
1871012 | 1871012 | 2021-10-31 | Bristol | Rhode Island | 44001 | 6073 | 149 |
1867763 | 1867763 | 2021-10-30 | Bristol | Rhode Island | 44001 | 6073 | 149 |
1864514 | 1864514 | 2021-10-29 | Bristol | Rhode Island | 44001 | 6073 | 149 |
1861265 | 1861265 | 2021-10-28 | Bristol | Rhode Island | 44001 | 6073 | 149 |
1858016 | 1858016 | 2021-10-27 | Bristol | Rhode Island | 44001 | 6073 | 149 |
1853483 | 1853483 | 2021-10-26 | Beauregard | Louisiana | 22011 | 6073 | 123 |
1784239 | 1784239 | 2021-10-05 | Boone | Arkansas | 5009 | 6073 | 114 |
1786820 | 1786820 | 2021-10-05 | Erath | Texas | 48143 | 6073 | 93 |
1770304 | 1770304 | 2021-09-30 | Chester | South Carolina | 45023 | 6073 | 100 |
1757638 | 1757638 | 2021-09-26 | Kerr | Texas | 48265 | 6073 | 115 |
1754390 | 1754390 | 2021-09-25 | Kerr | Texas | 48265 | 6073 | 115 |
1751142 | 1751142 | 2021-09-24 | Kerr | Texas | 48265 | 6073 | 113 |
1746647 | 1746647 | 2021-09-23 | Camden | Missouri | 29029 | 6073 | 119 |
1747893 | 1747893 | 2021-09-23 | Kerr | Texas | 48265 | 6073 | 111 |
1667057 | 1667057 | 2021-08-29 | Putnam | West Virginia | 54079 | 6073 | 99 |
1601881 | 1601881 | 2021-08-09 | Albemarle | Virginia | 51003 | 6073 | 85 |
1585644 | 1585644 | 2021-08-04 | Augusta | Virginia | 51015 | 6073 | 80 |
1518466 | 1518466 | 2021-07-15 | Cass | Indiana | 18017 | 6073 | 113 |
1491265 | 1491265 | 2021-07-06 | Henderson | Texas | 48213 | 6073 | 194 |
1488018 | 1488018 | 2021-07-05 | Henderson | Texas | 48213 | 6073 | 194 |
1484771 | 1484771 | 2021-07-04 | Henderson | Texas | 48213 | 6073 | 194 |
1481525 | 1481525 | 2021-07-03 | Henderson | Texas | 48213 | 6073 | 194 |
1478278 | 1478278 | 2021-07-02 | Henderson | Texas | 48213 | 6073 | 194 |
1388141 | 1388141 | 2021-06-05 | San Benito | California | 6069 | 6073 | 63 |
1384896 | 1384896 | 2021-06-04 | San Benito | California | 6069 | 6073 | 63 |
1381650 | 1381650 | 2021-06-03 | San Benito | California | 6069 | 6073 | 63 |
1378405 | 1378405 | 2021-06-02 | San Benito | California | 6069 | 6073 | 63 |
1370314 | 1370314 | 2021-05-30 | Jefferson | New York | 36045 | 6073 | 68 |
1360665 | 1360665 | 2021-05-27 | Lee | North Carolina | 37105 | 6073 | 79 |
1355684 | 1355684 | 2021-05-26 | San Benito | California | 6069 | 6073 | 63 |
1354024 | 1354024 | 2021-05-25 | Salem | New Jersey | 34033 | 6073 | 185 |
1321295 | 1321295 | 2021-05-15 | Joplin | Missouri | 6073 | 106 | |
1245211 | 1245211 | 2021-04-22 | Greene | Arkansas | 5055 | 6073 | 75 |
1241964 | 1241964 | 2021-04-21 | Greene | Arkansas | 5055 | 6073 | 75 |
1237904 | 1237904 | 2021-04-19 | Jefferson | Tennessee | 47089 | 6073 | 121 |
1212842 | 1212842 | 2021-04-12 | Yuba | California | 6115 | 6073 | 43 |
1169847 | 1169847 | 2021-03-29 | Hale | Texas | 48189 | 6073 | 153 |
1166599 | 1166599 | 2021-03-28 | Hale | Texas | 48189 | 6073 | 153 |
1161236 | 1161236 | 2021-03-27 | Boone | Illinois | 17007 | 6073 | 83 |
1163351 | 1163351 | 2021-03-27 | Hale | Texas | 48189 | 6073 | 153 |
1160102 | 1160102 | 2021-03-26 | Hale | Texas | 48189 | 6073 | 153 |
1149571 | 1149571 | 2021-03-23 | Columbus | North Carolina | 37047 | 6073 | 147 |
1146925 | 1146925 | 2021-03-22 | Bedford | Tennessee | 47003 | 6073 | 123 |
1101569 | 1101569 | 2021-03-08 | Anderson | Texas | 48001 | 6073 | 109 |
1098323 | 1098323 | 2021-03-07 | Anderson | Texas | 48001 | 6073 | 109 |
1095075 | 1095075 | 2021-03-06 | Anderson | Texas | 48001 | 6073 | 109 |
1063951 | 1063951 | 2021-02-25 | Boone | Indiana | 18011 | 6073 | 93 |
1049448 | 1049448 | 2021-02-20 | Georgetown | South Carolina | 45043 | 6073 | 132 |
965657 | 965657 | 2021-01-25 | Roanoke | Virginia | 51161 | 6073 | 75 |
852639 | 852639 | 2020-12-22 | Indian River | Florida | 12061 | 6073 | 154 |
807276 | 807276 | 2020-12-08 | Coweta | Georgia | 13077 | 6073 | 76 |
810081 | 810081 | 2020-12-08 | Laramie | Wyoming | 56021 | 6073 | 33 |
780259 | 780259 | 2020-11-29 | Washington | Tennessee | 47179 | 6073 | 106 |
693659 | 693659 | 2020-11-03 | Santa Rosa | Florida | 12113 | 6073 | 88 |
688787 | 688787 | 2020-11-01 | Union | North Carolina | 37179 | 6073 | 65 |
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);