ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
94 rows where cases = 5808 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Kentucky 10
- Minnesota 9
- Tennessee 8
- Florida 7
- Texas 6
- Michigan 5
- North Carolina 5
- Ohio 5
- Arkansas 4
- Mississippi 4
- Virginia 4
- Idaho 3
- Illinois 3
- Indiana 3
- Pennsylvania 3
- California 2
- Georgia 2
- Kansas 2
- Arizona 1
- Louisiana 1
- Maryland 1
- Missouri 1
- Nevada 1
- New York 1
- Oregon 1
- Puerto Rico 1
- South Dakota 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2485638 | 2485638 | 2022-05-08 | Camuy | Puerto Rico | 72027 | 5808 | |
2479409 | 2479409 | 2022-05-06 | Austin | Texas | 48015 | 5808 | 73 |
2461573 | 2461573 | 2022-05-01 | Meade | Kentucky | 21163 | 5808 | 66 |
2458317 | 2458317 | 2022-04-30 | Meade | Kentucky | 21163 | 5808 | 66 |
2455061 | 2455061 | 2022-04-29 | Meade | Kentucky | 21163 | 5808 | 66 |
2451805 | 2451805 | 2022-04-28 | Meade | Kentucky | 21163 | 5808 | 66 |
2448549 | 2448549 | 2022-04-27 | Meade | Kentucky | 21163 | 5808 | 66 |
2445293 | 2445293 | 2022-04-26 | Meade | Kentucky | 21163 | 5808 | 66 |
2442037 | 2442037 | 2022-04-25 | Meade | Kentucky | 21163 | 5808 | 66 |
2375297 | 2375297 | 2022-04-04 | Frio | Texas | 48163 | 5808 | 93 |
2372045 | 2372045 | 2022-04-03 | Frio | Texas | 48163 | 5808 | 93 |
2301605 | 2301605 | 2022-03-13 | Jerome | Idaho | 16053 | 5808 | 64 |
2298353 | 2298353 | 2022-03-12 | Jerome | Idaho | 16053 | 5808 | 64 |
2295101 | 2295101 | 2022-03-11 | Jerome | Idaho | 16053 | 5808 | 64 |
2282274 | 2282274 | 2022-03-07 | Owen | Indiana | 18119 | 5808 | 114 |
2222213 | 2222213 | 2022-02-16 | Davison | South Dakota | 46035 | 5808 | 78 |
2207934 | 2207934 | 2022-02-12 | Caroline | Maryland | 24011 | 5808 | 77 |
2194761 | 2194761 | 2022-02-08 | Harrison | Kentucky | 21097 | 5808 | 58 |
2191949 | 2191949 | 2022-02-07 | Wayne | Mississippi | 28153 | 5808 | 79 |
2165741 | 2165741 | 2022-01-30 | Oceana | Michigan | 26127 | 5808 | 87 |
2162486 | 2162486 | 2022-01-29 | Oceana | Michigan | 26127 | 5808 | 87 |
2159231 | 2159231 | 2022-01-28 | Oceana | Michigan | 26127 | 5808 | 87 |
2133356 | 2133356 | 2022-01-20 | Marion | Mississippi | 28091 | 5808 | 122 |
2100745 | 2100745 | 2022-01-10 | Lyon | Minnesota | 27083 | 5808 | 68 |
2037314 | 2037314 | 2021-12-21 | Charlottesville city | Virginia | 51540 | 5808 | 62 |
1997960 | 1997960 | 2021-12-09 | Scott | Tennessee | 47151 | 5808 | 69 |
1994709 | 1994709 | 2021-12-08 | Scott | Tennessee | 47151 | 5808 | 69 |
1977925 | 1977925 | 2021-12-03 | Champaign | Ohio | 39021 | 5808 | 87 |
1961907 | 1961907 | 2021-11-28 | McKean | Pennsylvania | 42083 | 5808 | 104 |
1923457 | 1923457 | 2021-11-16 | Washington | Texas | 48477 | 5808 | 132 |
1905260 | 1905260 | 2021-11-11 | Cowley | Kansas | 20035 | 5808 | 127 |
1902010 | 1902010 | 2021-11-10 | Cowley | Kansas | 20035 | 5808 | 127 |
1902206 | 1902206 | 2021-11-10 | Taylor | Kentucky | 21217 | 5808 | 87 |
1879128 | 1879128 | 2021-11-03 | Steuben | Indiana | 18151 | 5808 | 80 |
1875279 | 1875279 | 2021-11-02 | Union | Arkansas | 5139 | 5808 | 139 |
1831011 | 1831011 | 2021-10-19 | Steele | Minnesota | 27147 | 5808 | 25 |
1824485 | 1824485 | 2021-10-17 | McLeod | Minnesota | 27085 | 5808 | 68 |
1821236 | 1821236 | 2021-10-16 | McLeod | Minnesota | 27085 | 5808 | 68 |
1817987 | 1817987 | 2021-10-15 | McLeod | Minnesota | 27085 | 5808 | 68 |
1784666 | 1784666 | 2021-10-05 | Wayne | Georgia | 13305 | 5808 | 158 |
1744668 | 1744668 | 2021-09-22 | Matagorda | Texas | 48321 | 5808 | 143 |
1730952 | 1730952 | 2021-09-18 | Ashland | Ohio | 39005 | 5808 | 112 |
1711992 | 1711992 | 2021-09-12 | Obion | Tennessee | 47131 | 5808 | 101 |
1708745 | 1708745 | 2021-09-11 | Obion | Tennessee | 47131 | 5808 | 101 |
1705498 | 1705498 | 2021-09-10 | Obion | Tennessee | 47131 | 5808 | 101 |
1693795 | 1693795 | 2021-09-07 | Henry | Illinois | 17073 | 5808 | 100 |
1650429 | 1650429 | 2021-08-24 | Jim Wells | Texas | 48249 | 5808 | 121 |
1606556 | 1606556 | 2021-08-11 | Scott | Kentucky | 21209 | 5808 | 36 |
1602400 | 1602400 | 2021-08-10 | Humboldt | California | 6023 | 5808 | 57 |
1588060 | 1588060 | 2021-08-05 | Jefferson | Ohio | 39081 | 5808 | 162 |
1581308 | 1581308 | 2021-08-03 | Cattaraugus | New York | 36009 | 5808 | 93 |
1537744 | 1537744 | 2021-07-21 | Polk | Georgia | 13233 | 5808 | 100 |
1535161 | 1535161 | 2021-07-20 | St. Martin | Louisiana | 22099 | 5808 | 120 |
1490784 | 1490784 | 2021-07-06 | Linn | Oregon | 41043 | 5808 | 81 |
1453037 | 1453037 | 2021-06-25 | Lassen | California | 6035 | 5808 | 25 |
1449928 | 1449928 | 2021-06-24 | Gadsden | Florida | 12039 | 5808 | 99 |
1446683 | 1446683 | 2021-06-23 | Gadsden | Florida | 12039 | 5808 | 99 |
1443438 | 1443438 | 2021-06-22 | Gadsden | Florida | 12039 | 5808 | 99 |
1440193 | 1440193 | 2021-06-21 | Gadsden | Florida | 12039 | 5808 | 99 |
1436946 | 1436946 | 2021-06-20 | Gadsden | Florida | 12039 | 5808 | 99 |
1433699 | 1433699 | 2021-06-19 | Gadsden | Florida | 12039 | 5808 | 99 |
1430453 | 1430453 | 2021-06-18 | Gadsden | Florida | 12039 | 5808 | 99 |
1416809 | 1416809 | 2021-06-13 | Albemarle | Virginia | 51003 | 5808 | 84 |
1397337 | 1397337 | 2021-06-07 | Albemarle | Virginia | 51003 | 5808 | 83 |
1379514 | 1379514 | 2021-06-02 | Benton | Minnesota | 27009 | 5808 | 97 |
1376269 | 1376269 | 2021-06-01 | Benton | Minnesota | 27009 | 5808 | 97 |
1373023 | 1373023 | 2021-05-31 | Benton | Minnesota | 27009 | 5808 | 97 |
1369778 | 1369778 | 2021-05-30 | Benton | Minnesota | 27009 | 5808 | 97 |
1324243 | 1324243 | 2021-05-16 | Barry | Michigan | 26015 | 5808 | 65 |
1320997 | 1320997 | 2021-05-15 | Barry | Michigan | 26015 | 5808 | 65 |
1300980 | 1300980 | 2021-05-09 | Cass | Indiana | 18017 | 5808 | 107 |
1279098 | 1279098 | 2021-05-02 | Lincoln | Missouri | 29113 | 5808 | 41 |
1280132 | 1280132 | 2021-05-02 | Monroe | Tennessee | 47123 | 5808 | 95 |
1276885 | 1276885 | 2021-05-01 | Monroe | Tennessee | 47123 | 5808 | 95 |
1273638 | 1273638 | 2021-04-30 | Monroe | Tennessee | 47123 | 5808 | 95 |
1254971 | 1254971 | 2021-04-25 | Mississippi | Arkansas | 5093 | 5808 | 107 |
1256757 | 1256757 | 2021-04-25 | Granville | North Carolina | 37077 | 5808 | 80 |
1253510 | 1253510 | 2021-04-24 | Granville | North Carolina | 37077 | 5808 | 80 |
1250263 | 1250263 | 2021-04-23 | Granville | North Carolina | 37077 | 5808 | 80 |
1237289 | 1237289 | 2021-04-19 | Lee | North Carolina | 37105 | 5808 | 76 |
1113380 | 1113380 | 2021-03-12 | Lafayette | Mississippi | 28071 | 5808 | 114 |
1066625 | 1066625 | 2021-02-26 | Greene | Arkansas | 5055 | 5808 | 75 |
1035794 | 1035794 | 2021-02-16 | Carson City | Nevada | 32510 | 5808 | 110 |
1011917 | 1011917 | 2021-02-09 | Boone | Illinois | 17007 | 5808 | 86 |
949773 | 949773 | 2021-01-21 | Crawford | Arkansas | 5033 | 5808 | 79 |
942928 | 942928 | 2021-01-18 | Portsmouth city | Virginia | 51740 | 5808 | 94 |
934870 | 934870 | 2021-01-16 | Lauderdale | Mississippi | 28075 | 5808 | 180 |
932254 | 932254 | 2021-01-15 | Erie | Ohio | 39043 | 5808 | 117 |
877306 | 877306 | 2020-12-29 | Mercer | Pennsylvania | 42085 | 5808 | 129 |
818851 | 818851 | 2020-12-11 | Blair | Pennsylvania | 42013 | 5808 | 100 |
779730 | 779730 | 2020-11-29 | Greene | Ohio | 39057 | 5808 | 71 |
765310 | 765310 | 2020-11-25 | LaSalle | Illinois | 17099 | 5808 | 130 |
761521 | 761521 | 2020-11-24 | Mohave | Arizona | 4015 | 5808 | 251 |
679017 | 679017 | 2020-10-29 | Johnston | North Carolina | 37101 | 5808 | 66 |
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);