ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where cases = 5813 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Texas 10
- Indiana 9
- South Carolina 9
- Kentucky 8
- Oklahoma 7
- Pennsylvania 5
- South Dakota 5
- Ohio 4
- Tennessee 4
- Washington 4
- Wisconsin 4
- Florida 3
- Louisiana 3
- Alabama 2
- Colorado 2
- New York 2
- Puerto Rico 2
- Arkansas 1
- Georgia 1
- Illinois 1
- Michigan 1
- Minnesota 1
- Missouri 1
- Nevada 1
- New Mexico 1
- North Carolina 1
- Utah 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501141 | 2501141 | 2022-05-13 | McDonald | Missouri | 29119 | 5813 | 73 |
2495698 | 2495698 | 2022-05-11 | Austin | Texas | 48015 | 5813 | 73 |
2484371 | 2484371 | 2022-05-08 | Meade | Kentucky | 21163 | 5813 | 66 |
2481113 | 2481113 | 2022-05-07 | Meade | Kentucky | 21163 | 5813 | 66 |
2477855 | 2477855 | 2022-05-06 | Meade | Kentucky | 21163 | 5813 | 66 |
2474597 | 2474597 | 2022-05-05 | Meade | Kentucky | 21163 | 5813 | 66 |
2471340 | 2471340 | 2022-05-04 | Meade | Kentucky | 21163 | 5813 | 66 |
2468084 | 2468084 | 2022-05-03 | Meade | Kentucky | 21163 | 5813 | 66 |
2464829 | 2464829 | 2022-05-02 | Meade | Kentucky | 21163 | 5813 | 66 |
2449893 | 2449893 | 2022-04-27 | Barnwell | South Carolina | 45011 | 5813 | 102 |
2446636 | 2446636 | 2022-04-26 | Barnwell | South Carolina | 45011 | 5813 | 102 |
2443381 | 2443381 | 2022-04-25 | Barnwell | South Carolina | 45011 | 5813 | 102 |
2440125 | 2440125 | 2022-04-24 | Barnwell | South Carolina | 45011 | 5813 | 102 |
2436869 | 2436869 | 2022-04-23 | Barnwell | South Carolina | 45011 | 5813 | 102 |
2433613 | 2433613 | 2022-04-22 | Barnwell | South Carolina | 45011 | 5813 | 102 |
2430357 | 2430357 | 2022-04-21 | Barnwell | South Carolina | 45011 | 5813 | 102 |
2427101 | 2427101 | 2022-04-20 | Barnwell | South Carolina | 45011 | 5813 | 102 |
2423845 | 2423845 | 2022-04-19 | Barnwell | South Carolina | 45011 | 5813 | 102 |
2404236 | 2404236 | 2022-04-13 | Cayey | Puerto Rico | 72035 | 5813 | |
2354909 | 2354909 | 2022-03-29 | San Miguel | New Mexico | 35047 | 5813 | 55 |
2301785 | 2301785 | 2022-03-13 | Owen | Indiana | 18119 | 5813 | 114 |
2298533 | 2298533 | 2022-03-12 | Owen | Indiana | 18119 | 5813 | 114 |
2295281 | 2295281 | 2022-03-11 | Owen | Indiana | 18119 | 5813 | 114 |
2264151 | 2264151 | 2022-03-01 | Beckham | Oklahoma | 40009 | 5813 | 99 |
2260901 | 2260901 | 2022-02-28 | Beckham | Oklahoma | 40009 | 5813 | 99 |
2257650 | 2257650 | 2022-02-27 | Beckham | Oklahoma | 40009 | 5813 | 99 |
2254399 | 2254399 | 2022-02-26 | Beckham | Oklahoma | 40009 | 5813 | 99 |
2251148 | 2251148 | 2022-02-25 | Beckham | Oklahoma | 40009 | 5813 | 99 |
2246883 | 2246883 | 2022-02-24 | Grant | Louisiana | 22043 | 5813 | 86 |
2247897 | 2247897 | 2022-02-24 | Beckham | Oklahoma | 40009 | 5813 | 99 |
2248120 | 2248120 | 2022-02-24 | Manati | Puerto Rico | 72091 | 5813 | |
2244646 | 2244646 | 2022-02-23 | Beckham | Oklahoma | 40009 | 5813 | 99 |
2238468 | 2238468 | 2022-02-21 | Davison | South Dakota | 46035 | 5813 | 78 |
2235217 | 2235217 | 2022-02-20 | Davison | South Dakota | 46035 | 5813 | 78 |
2231966 | 2231966 | 2022-02-19 | Davison | South Dakota | 46035 | 5813 | 78 |
2228715 | 2228715 | 2022-02-18 | Davison | South Dakota | 46035 | 5813 | 78 |
2225464 | 2225464 | 2022-02-17 | Davison | South Dakota | 46035 | 5813 | 78 |
2177322 | 2177322 | 2022-02-02 | Mason | West Virginia | 54053 | 5813 | 78 |
2145212 | 2145212 | 2022-01-24 | Routt | Colorado | 8107 | 5813 | 24 |
2144319 | 2144319 | 2022-01-23 | Cass | Texas | 48067 | 5813 | 169 |
2061735 | 2061735 | 2021-12-29 | Mille Lacs | Minnesota | 27095 | 5813 | 93 |
2054515 | 2054515 | 2021-12-27 | Lee | Illinois | 17103 | 5813 | 107 |
2008859 | 2008859 | 2021-12-13 | Pickens | Georgia | 13227 | 5813 | 123 |
1929957 | 1929957 | 2021-11-18 | Washington | Texas | 48477 | 5813 | 132 |
1881081 | 1881081 | 2021-11-03 | Hill | Texas | 48217 | 5813 | 160 |
1859862 | 1859862 | 2021-10-28 | Bell | Kentucky | 21013 | 5813 | 94 |
1853501 | 1853501 | 2021-10-26 | Iberville | Louisiana | 22047 | 5813 | 125 |
1812442 | 1812442 | 2021-10-13 | Venango | Pennsylvania | 42121 | 5813 | 120 |
1808955 | 1808955 | 2021-10-12 | Fulton | Ohio | 39051 | 5813 | 92 |
1767822 | 1767822 | 2021-09-29 | Monroe | Wisconsin | 55081 | 5813 | 54 |
1741258 | 1741258 | 2021-09-21 | Weakley | Tennessee | 47183 | 5813 | 74 |
1738009 | 1738009 | 2021-09-20 | Weakley | Tennessee | 47183 | 5813 | 74 |
1727933 | 1727933 | 2021-09-17 | Huntingdon | Pennsylvania | 42061 | 5813 | 142 |
1683419 | 1683419 | 2021-09-04 | Chilton | Alabama | 1021 | 5813 | 121 |
1672957 | 1672957 | 2021-08-31 | Cocke | Tennessee | 47029 | 5813 | 104 |
1610799 | 1610799 | 2021-08-12 | Huron | Ohio | 39077 | 5813 | 122 |
1598880 | 1598880 | 2021-08-08 | Grant | Wisconsin | 55043 | 5813 | 95 |
1595631 | 1595631 | 2021-08-07 | Grant | Wisconsin | 55043 | 5813 | 95 |
1592382 | 1592382 | 2021-08-06 | Grant | Wisconsin | 55043 | 5813 | 95 |
1582184 | 1582184 | 2021-08-03 | Harrison | Texas | 48203 | 5813 | 112 |
1530591 | 1530591 | 2021-07-18 | Walla Walla | Washington | 53071 | 5813 | 71 |
1527344 | 1527344 | 2021-07-17 | Walla Walla | Washington | 53071 | 5813 | 71 |
1524097 | 1524097 | 2021-07-16 | Walla Walla | Washington | 53071 | 5813 | 71 |
1509179 | 1509179 | 2021-07-12 | St. Charles | Louisiana | 22089 | 5813 | 98 |
1430872 | 1430872 | 2021-06-18 | Noble | Indiana | 18113 | 5813 | 90 |
1426547 | 1426547 | 2021-06-16 | Albemarle | Virginia | 51003 | 5813 | 85 |
1312895 | 1312895 | 2021-05-12 | Iron | Utah | 49021 | 5813 | 32 |
1307473 | 1307473 | 2021-05-11 | Cass | Indiana | 18017 | 5813 | 107 |
1305785 | 1305785 | 2021-05-10 | Bradford | Pennsylvania | 42015 | 5813 | 89 |
1300987 | 1300987 | 2021-05-09 | Dearborn | Indiana | 18029 | 5813 | 81 |
1283553 | 1283553 | 2021-05-03 | Lamar | Texas | 48277 | 5813 | 155 |
1280306 | 1280306 | 2021-05-02 | Lamar | Texas | 48277 | 5813 | 155 |
1277059 | 1277059 | 2021-05-01 | Lamar | Texas | 48277 | 5813 | 155 |
1273812 | 1273812 | 2021-04-30 | Lamar | Texas | 48277 | 5813 | 155 |
1270565 | 1270565 | 2021-04-29 | Lamar | Texas | 48277 | 5813 | 155 |
1235599 | 1235599 | 2021-04-19 | Fremont | Colorado | 8043 | 5813 | 54 |
1227865 | 1227865 | 2021-04-16 | Carbon | Pennsylvania | 42025 | 5813 | 162 |
1168390 | 1168390 | 2021-03-29 | Clinton | Michigan | 26037 | 5813 | 75 |
1156030 | 1156030 | 2021-03-25 | Steuben | New York | 36101 | 5813 | 140 |
1128290 | 1128290 | 2021-03-17 | Crittenden | Arkansas | 5035 | 5813 | 94 |
1081348 | 1081348 | 2021-03-02 | Ontario | New York | 36069 | 5813 | 88 |
1057090 | 1057090 | 2021-02-23 | Flagler | Florida | 12035 | 5813 | 87 |
1039039 | 1039039 | 2021-02-17 | Carson City | Nevada | 32510 | 5813 | 111 |
1024646 | 1024646 | 2021-02-13 | Jackson | Florida | 12063 | 5813 | 138 |
1021770 | 1021770 | 2021-02-12 | Dubois | Indiana | 18037 | 5813 | 105 |
1023583 | 1023583 | 2021-02-12 | Carter | Tennessee | 47019 | 5813 | 147 |
1016649 | 1016649 | 2021-02-10 | Hancock | Ohio | 39063 | 5813 | 94 |
1007100 | 1007100 | 2021-02-07 | Clearfield | Pennsylvania | 42033 | 5813 | 110 |
999038 | 999038 | 2021-02-05 | Boone | Indiana | 18011 | 5813 | 88 |
939944 | 939944 | 2021-01-18 | Jackson | Alabama | 1071 | 5813 | 41 |
902914 | 902914 | 2021-01-06 | Henderson | North Carolina | 37089 | 5813 | 92 |
651445 | 651445 | 2020-10-21 | Clay | Florida | 12019 | 5813 | 117 |
614316 | 614316 | 2020-10-09 | Summit | Ohio | 39153 | 5813 | 258 |
541598 | 541598 | 2020-09-17 | Allen | Indiana | 18003 | 5813 | 208 |
89514 | 89514 | 2020-04-25 | King | Washington | 53033 | 5813 | 401 |
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);