ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where cases = 6464 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Mississippi 18
- Oklahoma 14
- California 10
- North Carolina 5
- Missouri 4
- Arkansas 3
- Indiana 3
- Kentucky 3
- Pennsylvania 3
- Virginia 3
- Alabama 2
- Georgia 2
- Illinois 2
- Maryland 2
- Michigan 2
- Minnesota 2
- New York 2
- Ohio 2
- West Virginia 2
- Louisiana 1
- Montana 1
- Puerto Rico 1
- South Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501979 | 2501979 | 2022-05-13 | San Lorenzo | Puerto Rico | 72129 | 6464 | |
2489923 | 2489923 | 2022-05-10 | Cleburne | Arkansas | 5023 | 6464 | 128 |
2486666 | 2486666 | 2022-05-09 | Cleburne | Arkansas | 5023 | 6464 | 128 |
2483408 | 2483408 | 2022-05-08 | Cleburne | Arkansas | 5023 | 6464 | 128 |
2461919 | 2461919 | 2022-05-01 | Coahoma | Mississippi | 28027 | 6464 | 126 |
2458663 | 2458663 | 2022-04-30 | Coahoma | Mississippi | 28027 | 6464 | 126 |
2455407 | 2455407 | 2022-04-29 | Coahoma | Mississippi | 28027 | 6464 | 126 |
2452151 | 2452151 | 2022-04-28 | Coahoma | Mississippi | 28027 | 6464 | 126 |
2448895 | 2448895 | 2022-04-27 | Coahoma | Mississippi | 28027 | 6464 | 126 |
2445639 | 2445639 | 2022-04-26 | Coahoma | Mississippi | 28027 | 6464 | 126 |
2442383 | 2442383 | 2022-04-25 | Coahoma | Mississippi | 28027 | 6464 | 126 |
2439127 | 2439127 | 2022-04-24 | Coahoma | Mississippi | 28027 | 6464 | 126 |
2435871 | 2435871 | 2022-04-23 | Coahoma | Mississippi | 28027 | 6464 | 126 |
2432615 | 2432615 | 2022-04-22 | Coahoma | Mississippi | 28027 | 6464 | 126 |
2429359 | 2429359 | 2022-04-21 | Coahoma | Mississippi | 28027 | 6464 | 126 |
2426103 | 2426103 | 2022-04-20 | Coahoma | Mississippi | 28027 | 6464 | 126 |
2422847 | 2422847 | 2022-04-19 | Coahoma | Mississippi | 28027 | 6464 | 126 |
2419591 | 2419591 | 2022-04-18 | Coahoma | Mississippi | 28027 | 6464 | 126 |
2399248 | 2399248 | 2022-04-12 | Douglas | Illinois | 17041 | 6464 | 61 |
2377207 | 2377207 | 2022-04-05 | Le Sueur | Minnesota | 27079 | 6464 | 51 |
2372996 | 2372996 | 2022-04-04 | Butts | Georgia | 13035 | 6464 | 152 |
2278454 | 2278454 | 2022-03-06 | Glenn | California | 6021 | 6464 | 63 |
2275201 | 2275201 | 2022-03-05 | Glenn | California | 6021 | 6464 | 63 |
2271948 | 2271948 | 2022-03-04 | Glenn | California | 6021 | 6464 | 63 |
2240876 | 2240876 | 2022-02-22 | Lake | Montana | 30047 | 6464 | 97 |
2241423 | 2241423 | 2022-02-22 | Jackson | Oklahoma | 40065 | 6464 | 94 |
2238172 | 2238172 | 2022-02-21 | Jackson | Oklahoma | 40065 | 6464 | 94 |
2234836 | 2234836 | 2022-02-20 | Hocking | Ohio | 39073 | 6464 | 111 |
2234921 | 2234921 | 2022-02-20 | Jackson | Oklahoma | 40065 | 6464 | 94 |
2231670 | 2231670 | 2022-02-19 | Jackson | Oklahoma | 40065 | 6464 | 94 |
2228419 | 2228419 | 2022-02-18 | Jackson | Oklahoma | 40065 | 6464 | 94 |
2225168 | 2225168 | 2022-02-17 | Jackson | Oklahoma | 40065 | 6464 | 94 |
2221917 | 2221917 | 2022-02-16 | Jackson | Oklahoma | 40065 | 6464 | 94 |
2165519 | 2165519 | 2022-01-30 | Mercer | Kentucky | 21167 | 6464 | 95 |
2162264 | 2162264 | 2022-01-29 | Mercer | Kentucky | 21167 | 6464 | 95 |
2159009 | 2159009 | 2022-01-28 | Mercer | Kentucky | 21167 | 6464 | 95 |
2149596 | 2149596 | 2022-01-25 | Covington | Mississippi | 28031 | 6464 | 98 |
2151296 | 2151296 | 2022-01-25 | Mingo | West Virginia | 54059 | 6464 | 103 |
2133274 | 2133274 | 2022-01-20 | Nicollet | Minnesota | 27103 | 6464 | 63 |
2123719 | 2123719 | 2022-01-17 | Polk | Missouri | 29167 | 6464 | 83 |
2120467 | 2120467 | 2022-01-16 | Polk | Missouri | 29167 | 6464 | 83 |
2117215 | 2117215 | 2022-01-15 | Polk | Missouri | 29167 | 6464 | 83 |
2078716 | 2078716 | 2022-01-03 | Jackson | Ohio | 39079 | 6464 | 110 |
2060168 | 2060168 | 2021-12-28 | Wise | Virginia | 51195 | 6464 | 145 |
2003714 | 2003714 | 2021-12-11 | Cortland | New York | 36023 | 6464 | 89 |
1919244 | 1919244 | 2021-11-15 | Warren | New York | 36113 | 6464 | 89 |
1873785 | 1873785 | 2021-11-01 | Davie | North Carolina | 37059 | 6464 | 76 |
1874890 | 1874890 | 2021-11-01 | Shenandoah | Virginia | 51171 | 6464 | 161 |
1763585 | 1763585 | 2021-09-28 | Osage | Oklahoma | 40113 | 6464 | 109 |
1760336 | 1760336 | 2021-09-27 | Osage | Oklahoma | 40113 | 6464 | 109 |
1756371 | 1756371 | 2021-09-26 | Warren | Mississippi | 28149 | 6464 | 164 |
1757088 | 1757088 | 2021-09-26 | Osage | Oklahoma | 40113 | 6464 | 109 |
1753123 | 1753123 | 2021-09-25 | Warren | Mississippi | 28149 | 6464 | 164 |
1753840 | 1753840 | 2021-09-25 | Osage | Oklahoma | 40113 | 6464 | 109 |
1749875 | 1749875 | 2021-09-24 | Warren | Mississippi | 28149 | 6464 | 164 |
1750592 | 1750592 | 2021-09-24 | Osage | Oklahoma | 40113 | 6464 | 109 |
1747342 | 1747342 | 2021-09-23 | Osage | Oklahoma | 40113 | 6464 | 109 |
1744093 | 1744093 | 2021-09-22 | Osage | Oklahoma | 40113 | 6464 | 109 |
1655753 | 1655753 | 2021-08-26 | Pettis | Missouri | 29159 | 6464 | 87 |
1619198 | 1619198 | 2021-08-15 | Marshall | Indiana | 18099 | 6464 | 119 |
1615950 | 1615950 | 2021-08-14 | Marshall | Indiana | 18099 | 6464 | 119 |
1612701 | 1612701 | 2021-08-13 | Marshall | Indiana | 18099 | 6464 | 119 |
1605318 | 1605318 | 2021-08-10 | Harrison | West Virginia | 54033 | 6464 | 82 |
1580628 | 1580628 | 2021-08-03 | St. Martin | Louisiana | 22099 | 6464 | 123 |
1575238 | 1575238 | 2021-08-01 | Carbon | Pennsylvania | 42025 | 6464 | 176 |
1555770 | 1555770 | 2021-07-26 | Indiana | Pennsylvania | 42063 | 6464 | 179 |
1529431 | 1529431 | 2021-07-18 | Duplin | North Carolina | 37061 | 6464 | 142 |
1526184 | 1526184 | 2021-07-17 | Duplin | North Carolina | 37061 | 6464 | 142 |
1522937 | 1522937 | 2021-07-16 | Duplin | North Carolina | 37061 | 6464 | 142 |
1511278 | 1511278 | 2021-07-13 | Colbert | Alabama | 1033 | 6464 | 140 |
1508031 | 1508031 | 2021-07-12 | Colbert | Alabama | 1033 | 6464 | 140 |
1427111 | 1427111 | 2021-06-17 | Yuba | California | 6115 | 6464 | 51 |
1423866 | 1423866 | 2021-06-16 | Yuba | California | 6115 | 6464 | 51 |
1420618 | 1420618 | 2021-06-15 | Yuba | California | 6115 | 6464 | 50 |
1392434 | 1392434 | 2021-06-06 | Grand Traverse | Michigan | 26055 | 6464 | 97 |
1389189 | 1389189 | 2021-06-05 | Grand Traverse | Michigan | 26055 | 6464 | 97 |
1180816 | 1180816 | 2021-04-02 | Whiteside | Illinois | 17195 | 6464 | 201 |
1148847 | 1148847 | 2021-03-23 | Allegany | Maryland | 24001 | 6464 | 202 |
1145600 | 1145600 | 2021-03-22 | Allegany | Maryland | 24001 | 6464 | 202 |
900729 | 900729 | 2021-01-05 | Newport News city | Virginia | 51700 | 6464 | 72 |
774824 | 774824 | 2020-11-28 | Columbia | Georgia | 13073 | 6464 | 77 |
711918 | 711918 | 2020-11-08 | Berkeley | South Carolina | 45015 | 6464 | 96 |
528157 | 528157 | 2020-09-13 | Marin | California | 6041 | 6464 | 99 |
442610 | 442610 | 2020-08-17 | Durham | North Carolina | 37063 | 6464 | 81 |
172615 | 172615 | 2020-05-24 | Riverside | California | 6065 | 6464 | 299 |
169574 | 169574 | 2020-05-23 | Riverside | California | 6065 | 6464 | 298 |
171526 | 171526 | 2020-05-23 | Montgomery | Pennsylvania | 42091 | 6464 | 633 |
166537 | 166537 | 2020-05-22 | Riverside | California | 6065 | 6464 | 290 |
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);