ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
98 rows where cases = 5750 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Indiana 11
- Missouri 11
- Texas 10
- Illinois 9
- Wisconsin 8
- Pennsylvania 5
- Puerto Rico 5
- Idaho 4
- North Carolina 4
- California 3
- Kansas 3
- New York 3
- Ohio 3
- Georgia 2
- Michigan 2
- Tennessee 2
- Arizona 1
- Arkansas 1
- Colorado 1
- Iowa 1
- Kentucky 1
- Louisiana 1
- Massachusetts 1
- Minnesota 1
- Oregon 1
- Utah 1
- Vermont 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497859 | 2497859 | 2022-05-12 | Henry | Missouri | 29083 | 5750 | 86 |
2494601 | 2494601 | 2022-05-11 | Henry | Missouri | 29083 | 5750 | 86 |
2491343 | 2491343 | 2022-05-10 | Henry | Missouri | 29083 | 5750 | 86 |
2488085 | 2488085 | 2022-05-09 | Henry | Missouri | 29083 | 5750 | 86 |
2484828 | 2484828 | 2022-05-08 | Henry | Missouri | 29083 | 5750 | 86 |
2481570 | 2481570 | 2022-05-07 | Henry | Missouri | 29083 | 5750 | 86 |
2478312 | 2478312 | 2022-05-06 | Henry | Missouri | 29083 | 5750 | 86 |
2476430 | 2476430 | 2022-05-05 | Caledonia | Vermont | 50005 | 5750 | 25 |
2427367 | 2427367 | 2022-04-20 | Dimmit | Texas | 48127 | 5750 | 51 |
2424111 | 2424111 | 2022-04-19 | Dimmit | Texas | 48127 | 5750 | 51 |
2420855 | 2420855 | 2022-04-18 | Dimmit | Texas | 48127 | 5750 | 51 |
2401384 | 2401384 | 2022-04-12 | Karnes | Texas | 48255 | 5750 | 70 |
2301585 | 2301585 | 2022-03-13 | Blaine | Idaho | 16013 | 5750 | 30 |
2298333 | 2298333 | 2022-03-12 | Blaine | Idaho | 16013 | 5750 | 30 |
2295081 | 2295081 | 2022-03-11 | Blaine | Idaho | 16013 | 5750 | 30 |
2292870 | 2292870 | 2022-03-10 | Stone | Missouri | 29209 | 5750 | 117 |
2289618 | 2289618 | 2022-03-09 | Stone | Missouri | 29209 | 5750 | 117 |
2263887 | 2263887 | 2022-03-01 | Seneca | New York | 36099 | 5750 | 89 |
2237046 | 2237046 | 2022-02-21 | Johnson | Kentucky | 21115 | 5750 | 88 |
2205853 | 2205853 | 2022-02-11 | Manati | Puerto Rico | 72091 | 5750 | |
2197252 | 2197252 | 2022-02-09 | Montezuma | Colorado | 8083 | 5750 | 62 |
2193644 | 2193644 | 2022-02-07 | Kewaunee | Wisconsin | 55061 | 5750 | 55 |
2176159 | 2176159 | 2022-02-02 | Martin | North Carolina | 37117 | 5750 | 80 |
2168272 | 2168272 | 2022-01-31 | Jefferson | Idaho | 16051 | 5750 | 56 |
2160326 | 2160326 | 2022-01-28 | San Sebastian | Puerto Rico | 72131 | 5750 | |
2130046 | 2130046 | 2022-01-19 | Todd | Minnesota | 27153 | 5750 | 54 |
2051265 | 2051265 | 2021-12-26 | Lee | Illinois | 17103 | 5750 | 106 |
2048015 | 2048015 | 2021-12-25 | Lee | Illinois | 17103 | 5750 | 106 |
2044765 | 2044765 | 2021-12-24 | Lee | Illinois | 17103 | 5750 | 106 |
2041516 | 2041516 | 2021-12-23 | Lee | Illinois | 17103 | 5750 | 106 |
2016443 | 2016443 | 2021-12-15 | Pulaski | Missouri | 29169 | 5750 | 97 |
1971743 | 1971743 | 2021-12-01 | Ponce | Puerto Rico | 72113 | 5750 | |
1900247 | 1900247 | 2021-11-09 | Toa Alta | Puerto Rico | 72135 | 5750 | |
1896997 | 1896997 | 2021-11-08 | Toa Alta | Puerto Rico | 72135 | 5750 | |
1869381 | 1869381 | 2021-10-31 | Steuben | Indiana | 18151 | 5750 | 79 |
1869397 | 1869397 | 2021-10-31 | Whitley | Indiana | 18183 | 5750 | 57 |
1866132 | 1866132 | 2021-10-30 | Steuben | Indiana | 18151 | 5750 | 79 |
1866148 | 1866148 | 2021-10-30 | Whitley | Indiana | 18183 | 5750 | 57 |
1862883 | 1862883 | 2021-10-29 | Steuben | Indiana | 18151 | 5750 | 79 |
1862899 | 1862899 | 2021-10-29 | Whitley | Indiana | 18183 | 5750 | 57 |
1854485 | 1854485 | 2021-10-26 | Preble | Ohio | 39135 | 5750 | 125 |
1810230 | 1810230 | 2021-10-13 | Baxter | Arkansas | 5005 | 5750 | 174 |
1810807 | 1810807 | 2021-10-13 | Stephenson | Illinois | 17177 | 5750 | 111 |
1786128 | 1786128 | 2021-10-05 | Yadkin | North Carolina | 37197 | 5750 | 70 |
1765169 | 1765169 | 2021-09-29 | Wayne | Georgia | 13305 | 5750 | 152 |
1721435 | 1721435 | 2021-09-15 | Huntingdon | Pennsylvania | 42061 | 5750 | 142 |
1698713 | 1698713 | 2021-09-08 | Mifflin | Pennsylvania | 42087 | 5750 | 183 |
1696368 | 1696368 | 2021-09-07 | Shawano | Wisconsin | 55115 | 5750 | 85 |
1693120 | 1693120 | 2021-09-06 | Shawano | Wisconsin | 55115 | 5750 | 85 |
1623238 | 1623238 | 2021-08-16 | Johnson | Missouri | 29101 | 5750 | 61 |
1602301 | 1602301 | 2021-08-10 | Graham | Arizona | 4009 | 5750 | 88 |
1597805 | 1597805 | 2021-08-08 | Huron | Ohio | 39077 | 5750 | 122 |
1444350 | 1444350 | 2021-06-22 | Branch | Michigan | 26023 | 5750 | 120 |
1441030 | 1441030 | 2021-06-21 | Vermilion | Louisiana | 22113 | 5750 | 125 |
1432762 | 1432762 | 2021-06-18 | Caldwell | Texas | 48055 | 5750 | 99 |
1429516 | 1429516 | 2021-06-17 | Caldwell | Texas | 48055 | 5750 | 99 |
1417056 | 1417056 | 2021-06-13 | Grant | Wisconsin | 55043 | 5750 | 93 |
1413810 | 1413810 | 2021-06-12 | Grant | Wisconsin | 55043 | 5750 | 93 |
1410565 | 1410565 | 2021-06-11 | Grant | Wisconsin | 55043 | 5750 | 93 |
1407320 | 1407320 | 2021-06-10 | Grant | Wisconsin | 55043 | 5750 | 93 |
1375698 | 1375698 | 2021-06-01 | Noble | Indiana | 18113 | 5750 | 88 |
1372453 | 1372453 | 2021-05-31 | Noble | Indiana | 18113 | 5750 | 88 |
1369208 | 1369208 | 2021-05-30 | Noble | Indiana | 18113 | 5750 | 88 |
1328521 | 1328521 | 2021-05-17 | Columbia | Pennsylvania | 42037 | 5750 | 133 |
1325133 | 1325133 | 2021-05-16 | Union | Ohio | 39159 | 5750 | 48 |
1319615 | 1319615 | 2021-05-14 | Harrison | West Virginia | 54033 | 5750 | 77 |
1309483 | 1309483 | 2021-05-11 | Hardin | Texas | 48199 | 5750 | 111 |
1301155 | 1301155 | 2021-05-09 | Warren | Iowa | 19181 | 5750 | 88 |
1301192 | 1301192 | 2021-05-09 | Ford | Kansas | 20057 | 5750 | 75 |
1297945 | 1297945 | 2021-05-08 | Ford | Kansas | 20057 | 5750 | 75 |
1294699 | 1294699 | 2021-05-07 | Ford | Kansas | 20057 | 5750 | 75 |
1279809 | 1279809 | 2021-05-02 | Armstrong | Pennsylvania | 42005 | 5750 | 131 |
1274212 | 1274212 | 2021-04-30 | Columbia | Wisconsin | 55021 | 5750 | 69 |
1259381 | 1259381 | 2021-04-26 | St. Joseph | Michigan | 26149 | 5750 | 93 |
1240537 | 1240537 | 2021-04-20 | Lenoir | North Carolina | 37107 | 5750 | 110 |
1229507 | 1229507 | 2021-04-17 | Ogle | Illinois | 17141 | 5750 | 86 |
1226363 | 1226363 | 2021-04-16 | Shelby | Indiana | 18145 | 5750 | 105 |
1166644 | 1166644 | 2021-03-28 | Lamar | Texas | 48277 | 5750 | 152 |
1163396 | 1163396 | 2021-03-27 | Lamar | Texas | 48277 | 5750 | 152 |
1160147 | 1160147 | 2021-03-26 | Lamar | Texas | 48277 | 5750 | 152 |
1073222 | 1073222 | 2021-02-28 | Yuba | California | 6115 | 5750 | 37 |
1069976 | 1069976 | 2021-02-27 | Yuba | California | 6115 | 5750 | 37 |
1066731 | 1066731 | 2021-02-26 | Yuba | California | 6115 | 5750 | 37 |
1068365 | 1068365 | 2021-02-26 | Ontario | New York | 36069 | 5750 | 88 |
1033370 | 1033370 | 2021-02-15 | McMinn | Tennessee | 47107 | 5750 | 88 |
1008766 | 1008766 | 2021-02-08 | Whiteside | Illinois | 17195 | 5750 | 182 |
992441 | 992441 | 2021-02-03 | Boone | Illinois | 17007 | 5750 | 85 |
986053 | 986053 | 2021-02-01 | Boone | Indiana | 18011 | 5750 | 74 |
965525 | 965525 | 2021-01-25 | Tooele | Utah | 49045 | 5750 | 20 |
915830 | 915830 | 2021-01-10 | Putnam | New York | 36079 | 5750 | 68 |
895704 | 895704 | 2021-01-04 | Barnstable | Massachusetts | 25001 | 5750 | 253 |
890239 | 890239 | 2021-01-02 | Umatilla | Oregon | 41059 | 5750 | 57 |
876948 | 876948 | 2020-12-29 | Harnett | North Carolina | 37085 | 5750 | 89 |
794296 | 794296 | 2020-12-04 | Coweta | Georgia | 13077 | 5750 | 74 |
621644 | 621644 | 2020-10-11 | Henrico | Virginia | 51087 | 5750 | 221 |
567500 | 567500 | 2020-09-25 | Winnebago | Illinois | 17201 | 5750 | 153 |
340056 | 340056 | 2020-07-16 | Allegheny | Pennsylvania | 42003 | 5750 | 205 |
205408 | 205408 | 2020-06-03 | Davidson | Tennessee | 47037 | 5750 | 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);