ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
119 rows where cases = 3598 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 11
- Texas 10
- Louisiana 9
- Georgia 7
- Minnesota 7
- Missouri 6
- South Carolina 5
- Alabama 4
- Colorado 4
- Kentucky 4
- Michigan 4
- Nebraska 4
- Ohio 4
- Arkansas 3
- Illinois 3
- New York 3
- North Carolina 3
- South Dakota 3
- Tennessee 3
- Maryland 2
- Oregon 2
- Puerto Rico 2
- Washington 2
- West Virginia 2
- California 1
- Florida 1
- Idaho 1
- Indiana 1
- Mississippi 1
- New Jersey 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496227 | 2496227 | 2022-05-11 | Buffalo | Wisconsin | 55011 | 3598 | 12 |
2462195 | 2462195 | 2022-05-01 | Gage | Nebraska | 31067 | 3598 | 44 |
2458939 | 2458939 | 2022-04-30 | Gage | Nebraska | 31067 | 3598 | 44 |
2455683 | 2455683 | 2022-04-29 | Gage | Nebraska | 31067 | 3598 | 44 |
2445594 | 2445594 | 2022-04-26 | Pennington | Minnesota | 27113 | 3598 | 41 |
2421697 | 2421697 | 2022-04-19 | Las Animas | Colorado | 8071 | 3598 | 40 |
2418441 | 2418441 | 2022-04-18 | Las Animas | Colorado | 8071 | 3598 | 40 |
2362214 | 2362214 | 2022-03-31 | Bandera | Texas | 48019 | 3598 | 75 |
2351376 | 2351376 | 2022-03-28 | Madison | Missouri | 29123 | 3598 | 57 |
2349586 | 2349586 | 2022-03-27 | Patrick | Virginia | 51141 | 3598 | 91 |
2346333 | 2346333 | 2022-03-26 | Patrick | Virginia | 51141 | 3598 | 91 |
2343080 | 2343080 | 2022-03-25 | Patrick | Virginia | 51141 | 3598 | 91 |
2339827 | 2339827 | 2022-03-24 | Patrick | Virginia | 51141 | 3598 | 91 |
2270058 | 2270058 | 2022-03-03 | Macon | Missouri | 29121 | 3598 | 49 |
2266333 | 2266333 | 2022-03-02 | Monroe | Kentucky | 21171 | 3598 | 74 |
2259509 | 2259509 | 2022-02-28 | Parke | Indiana | 18121 | 3598 | 48 |
2247132 | 2247132 | 2022-02-24 | Renville | Minnesota | 27129 | 3598 | 55 |
2242526 | 2242526 | 2022-02-23 | Lamar | Alabama | 1075 | 3598 | 63 |
2177175 | 2177175 | 2022-02-02 | Goochland | Virginia | 51075 | 3598 | 37 |
2150809 | 2150809 | 2022-01-25 | Bosque | Texas | 48035 | 3598 | 60 |
2134664 | 2134664 | 2022-01-20 | Lee | Texas | 48287 | 3598 | 55 |
2122018 | 2122018 | 2022-01-16 | Morgan | West Virginia | 54065 | 3598 | 57 |
2114497 | 2114497 | 2022-01-14 | Meigs | Ohio | 39105 | 3598 | 71 |
2109764 | 2109764 | 2022-01-13 | Hancock | Illinois | 17067 | 3598 | 50 |
2106055 | 2106055 | 2022-01-12 | Sharp | Arkansas | 5135 | 3598 | 82 |
2108237 | 2108237 | 2022-01-12 | Fajardo | Puerto Rico | 72053 | 3598 | |
2086245 | 2086245 | 2022-01-05 | McDowell | West Virginia | 54047 | 3598 | 56 |
2082126 | 2082126 | 2022-01-04 | Union | Oregon | 41061 | 3598 | 64 |
2064001 | 2064001 | 2021-12-30 | Appling | Georgia | 13001 | 3598 | 108 |
2034837 | 2034837 | 2021-12-21 | Jones | Georgia | 13169 | 3598 | 99 |
1981816 | 1981816 | 2021-12-04 | Gonzales | Texas | 48177 | 3598 | 85 |
1967450 | 1967450 | 2021-11-30 | Dodge | Minnesota | 27039 | 3598 | 11 |
1941097 | 1941097 | 2021-11-22 | Adair | Kentucky | 21001 | 3598 | 83 |
1904633 | 1904633 | 2021-11-11 | Montezuma | Colorado | 8083 | 3598 | 41 |
1848910 | 1848910 | 2021-10-24 | Waynesboro city | Virginia | 51820 | 3598 | 44 |
1845660 | 1845660 | 2021-10-23 | Waynesboro city | Virginia | 51820 | 3598 | 44 |
1840944 | 1840944 | 2021-10-22 | Randolph | Missouri | 29175 | 3598 | 36 |
1842410 | 1842410 | 2021-10-22 | Waynesboro city | Virginia | 51820 | 3598 | 44 |
1833294 | 1833294 | 2021-10-20 | Dodge | Georgia | 13091 | 3598 | 123 |
1834822 | 1834822 | 2021-10-20 | Martin | North Carolina | 37117 | 3598 | 69 |
1789305 | 1789305 | 2021-10-06 | Dare | North Carolina | 37055 | 3598 | 12 |
1787180 | 1787180 | 2021-10-05 | Winchester city | Virginia | 51840 | 3598 | 51 |
1778890 | 1778890 | 2021-10-03 | Dickinson | Michigan | 26043 | 3598 | 75 |
1775640 | 1775640 | 2021-10-02 | Dickinson | Michigan | 26043 | 3598 | 75 |
1772390 | 1772390 | 2021-10-01 | Dickinson | Michigan | 26043 | 3598 | 75 |
1753134 | 1753134 | 2021-09-25 | Audrain | Missouri | 29007 | 3598 | 63 |
1699150 | 1699150 | 2021-09-08 | Jasper | Texas | 48241 | 3598 | 113 |
1695659 | 1695659 | 2021-09-07 | Lawrence | South Dakota | 46081 | 3598 | 50 |
1691068 | 1691068 | 2021-09-06 | Pointe Coupee | Louisiana | 22077 | 3598 | 80 |
1687818 | 1687818 | 2021-09-05 | Pointe Coupee | Louisiana | 22077 | 3598 | 80 |
1684568 | 1684568 | 2021-09-04 | Pointe Coupee | Louisiana | 22077 | 3598 | 80 |
1681317 | 1681317 | 2021-09-03 | Pointe Coupee | Louisiana | 22077 | 3598 | 80 |
1665523 | 1665523 | 2021-08-29 | Stone | Missouri | 29209 | 3598 | 62 |
1643047 | 1643047 | 2021-08-22 | Greene | New York | 36039 | 3598 | 81 |
1621747 | 1621747 | 2021-08-16 | Pike | Alabama | 1109 | 3598 | 80 |
1617268 | 1617268 | 2021-08-14 | Champaign | Ohio | 39021 | 3598 | 60 |
1610750 | 1610750 | 2021-08-12 | Stutsman | North Dakota | 38093 | 3598 | 82 |
1603291 | 1603291 | 2021-08-10 | Muhlenberg | Kentucky | 21177 | 3598 | 70 |
1600801 | 1600801 | 2021-08-09 | Allegany | New York | 36003 | 3598 | 87 |
1581275 | 1581275 | 2021-08-03 | Cibola | New Mexico | 35006 | 3598 | 128 |
1561425 | 1561425 | 2021-07-28 | Leflore | Mississippi | 28083 | 3598 | 125 |
1534004 | 1534004 | 2021-07-20 | Clarke | Alabama | 1025 | 3598 | 62 |
1536440 | 1536440 | 2021-07-20 | Marion | South Carolina | 45067 | 3598 | 108 |
1441946 | 1441946 | 2021-06-21 | Highland | Ohio | 39071 | 3598 | 65 |
1438701 | 1438701 | 2021-06-20 | Highland | Ohio | 39071 | 3598 | 65 |
1438849 | 1438849 | 2021-06-20 | Josephine | Oregon | 41033 | 3598 | 72 |
1390773 | 1390773 | 2021-06-05 | Uvalde | Texas | 48463 | 3598 | 73 |
1387528 | 1387528 | 2021-06-04 | Uvalde | Texas | 48463 | 3598 | 73 |
1377500 | 1377500 | 2021-06-01 | Hardin | Tennessee | 47071 | 3598 | 68 |
1326249 | 1326249 | 2021-05-17 | Chambers | Alabama | 1017 | 3598 | 123 |
1308128 | 1308128 | 2021-05-11 | Lyon | Minnesota | 27083 | 3598 | 50 |
1304882 | 1304882 | 2021-05-10 | Lyon | Minnesota | 27083 | 3598 | 50 |
1300810 | 1300810 | 2021-05-09 | Wayne | Georgia | 13305 | 3598 | 88 |
1297563 | 1297563 | 2021-05-08 | Wayne | Georgia | 13305 | 3598 | 88 |
1298247 | 1298247 | 2021-05-08 | Worcester | Maryland | 24047 | 3598 | 98 |
1286466 | 1286466 | 2021-05-04 | Colleton | South Carolina | 45029 | 3598 | 126 |
1270338 | 1270338 | 2021-04-29 | Carroll | Tennessee | 47017 | 3598 | 83 |
1234473 | 1234473 | 2021-04-18 | Ponce | Puerto Rico | 72113 | 3598 | |
1219747 | 1219747 | 2021-04-14 | Logan | Illinois | 17107 | 3598 | 69 |
1220480 | 1220480 | 2021-04-14 | Polk | Minnesota | 27119 | 3598 | 66 |
1212423 | 1212423 | 2021-04-11 | Grays Harbor | Washington | 53027 | 3598 | 58 |
1209174 | 1209174 | 2021-04-10 | Grays Harbor | Washington | 53027 | 3598 | 58 |
1205873 | 1205873 | 2021-04-09 | Petersburg city | Virginia | 51730 | 3598 | 79 |
1152059 | 1152059 | 2021-03-24 | St. John the Baptist | Louisiana | 22095 | 3598 | 136 |
1150315 | 1150315 | 2021-03-23 | Cooke | Texas | 48097 | 3598 | 65 |
1076759 | 1076759 | 2021-03-01 | Unknown | Georgia | 3598 | 12 | |
1052248 | 1052248 | 2021-02-21 | Stokes | North Carolina | 37169 | 3598 | 64 |
1052685 | 1052685 | 2021-02-21 | Chester | South Carolina | 45023 | 3598 | 64 |
1031037 | 1031037 | 2021-02-15 | Broomfield | Colorado | 8014 | 3598 | 73 |
1033244 | 1033244 | 2021-02-15 | Williamsburg | South Carolina | 45089 | 3598 | 84 |
1030507 | 1030507 | 2021-02-14 | Franklin | Virginia | 51067 | 3598 | 42 |
1027115 | 1027115 | 2021-02-13 | Rusk | Texas | 48401 | 3598 | 88 |
995298 | 995298 | 2021-02-04 | Nevada | California | 6057 | 3598 | 74 |
970467 | 970467 | 2021-01-27 | Goodhue | Minnesota | 27049 | 3598 | 64 |
957683 | 957683 | 2021-01-23 | Johnson | Missouri | 29101 | 3598 | 34 |
942817 | 942817 | 2021-01-18 | Chittenden | Vermont | 50007 | 3598 | 78 |
934598 | 934598 | 2021-01-16 | Washington | Louisiana | 22117 | 3598 | 99 |
931353 | 931353 | 2021-01-15 | Washington | Louisiana | 22117 | 3598 | 99 |
919414 | 919414 | 2021-01-11 | Washington | Oklahoma | 40147 | 3598 | 66 |
841904 | 841904 | 2020-12-18 | Roane | Tennessee | 47145 | 3598 | 44 |
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);