ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
80 rows where cases = 5086 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Louisiana 9
- Texas 8
- Georgia 6
- Wisconsin 5
- Alabama 4
- Mississippi 4
- North Carolina 4
- Washington 4
- Indiana 3
- Kentucky 3
- New Mexico 3
- Oregon 3
- Illinois 2
- Minnesota 2
- Missouri 2
- Ohio 2
- Tennessee 2
- Wyoming 2
- Arizona 1
- Arkansas 1
- Colorado 1
- Iowa 1
- Michigan 1
- Nevada 1
- New Jersey 1
- New York 1
- Oklahoma 1
- Pennsylvania 1
- South Carolina 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2413985 | 2413985 | 2022-04-16 | Wyoming | Pennsylvania | 42131 | 5086 | 105 |
2380231 | 2380231 | 2022-04-06 | Concordia | Louisiana | 22029 | 5086 | 89 |
2303285 | 2303285 | 2022-03-13 | Wasco | Oregon | 41065 | 5086 | 57 |
2300033 | 2300033 | 2022-03-12 | Wasco | Oregon | 41065 | 5086 | 57 |
2296781 | 2296781 | 2022-03-11 | Wasco | Oregon | 41065 | 5086 | 57 |
2262004 | 2262004 | 2022-03-01 | Cherokee | Alabama | 1019 | 5086 | 78 |
2221654 | 2221654 | 2022-02-16 | Caswell | North Carolina | 37033 | 5086 | 40 |
2201328 | 2201328 | 2022-02-10 | Spencer | Kentucky | 21215 | 5086 | 48 |
2163815 | 2163815 | 2022-01-29 | Austin | Texas | 48015 | 5086 | 60 |
2097554 | 2097554 | 2022-01-09 | Coahoma | Mississippi | 28027 | 5086 | 114 |
2094302 | 2094302 | 2022-01-08 | Coahoma | Mississippi | 28027 | 5086 | 114 |
2091050 | 2091050 | 2022-01-07 | Coahoma | Mississippi | 28027 | 5086 | 114 |
2028345 | 2028345 | 2021-12-19 | Lumpkin | Georgia | 13187 | 5086 | 110 |
2028657 | 2028657 | 2021-12-19 | White | Indiana | 18181 | 5086 | 75 |
2025094 | 2025094 | 2021-12-18 | Lumpkin | Georgia | 13187 | 5086 | 110 |
2025406 | 2025406 | 2021-12-18 | White | Indiana | 18181 | 5086 | 75 |
2021843 | 2021843 | 2021-12-17 | Lumpkin | Georgia | 13187 | 5086 | 110 |
2022155 | 2022155 | 2021-12-17 | White | Indiana | 18181 | 5086 | 75 |
2008842 | 2008842 | 2021-12-13 | Madison | Georgia | 13195 | 5086 | 81 |
1997131 | 1997131 | 2021-12-09 | Nye | Nevada | 32023 | 5086 | 172 |
1925804 | 1925804 | 2021-11-17 | Macon | North Carolina | 37113 | 5086 | 75 |
1918779 | 1918779 | 2021-11-15 | George | Mississippi | 28039 | 5086 | 80 |
1907424 | 1907424 | 2021-11-11 | Kittitas | Washington | 53037 | 5086 | 55 |
1904175 | 1904175 | 2021-11-10 | Kittitas | Washington | 53037 | 5086 | 55 |
1890174 | 1890174 | 2021-11-06 | Coshocton | Ohio | 39031 | 5086 | 94 |
1858359 | 1858359 | 2021-10-27 | Kendall | Texas | 48259 | 5086 | 99 |
1855110 | 1855110 | 2021-10-26 | Kendall | Texas | 48259 | 5086 | 98 |
1834246 | 1834246 | 2021-10-20 | Polk | Minnesota | 27119 | 5086 | 77 |
1834834 | 1834834 | 2021-10-20 | Pasquotank | North Carolina | 37139 | 5086 | 101 |
1830637 | 1830637 | 2021-10-19 | Clay | Kentucky | 21051 | 5086 | 56 |
1821446 | 1821446 | 2021-10-16 | Polk | Missouri | 29167 | 5086 | 52 |
1713174 | 1713174 | 2021-09-13 | Toombs | Georgia | 13279 | 5086 | 140 |
1704973 | 1704973 | 2021-09-10 | Brown | Ohio | 39015 | 5086 | 67 |
1621703 | 1621703 | 2021-08-16 | Chilton | Alabama | 1021 | 5086 | 117 |
1619626 | 1619626 | 2021-08-15 | Webster | Louisiana | 22119 | 5086 | 119 |
1621645 | 1621645 | 2021-08-15 | Pierce | Wisconsin | 55093 | 5086 | 44 |
1616378 | 1616378 | 2021-08-14 | Webster | Louisiana | 22119 | 5086 | 119 |
1618397 | 1618397 | 2021-08-14 | Pierce | Wisconsin | 55093 | 5086 | 44 |
1613129 | 1613129 | 2021-08-13 | Webster | Louisiana | 22119 | 5086 | 119 |
1615149 | 1615149 | 2021-08-13 | Pierce | Wisconsin | 55093 | 5086 | 44 |
1561149 | 1561149 | 2021-07-28 | Washington | Louisiana | 22117 | 5086 | 139 |
1534518 | 1534518 | 2021-07-20 | Tift | Georgia | 13277 | 5086 | 132 |
1400850 | 1400850 | 2021-06-08 | Oconto | Wisconsin | 55083 | 5086 | 68 |
1397637 | 1397637 | 2021-06-07 | Campbell | Wyoming | 56005 | 5086 | 60 |
1379289 | 1379289 | 2021-06-02 | Scott | Kentucky | 21209 | 5086 | 36 |
1377723 | 1377723 | 2021-06-01 | Medina | Texas | 48325 | 5086 | 105 |
1374477 | 1374477 | 2021-05-31 | Medina | Texas | 48325 | 5086 | 105 |
1371232 | 1371232 | 2021-05-30 | Medina | Texas | 48325 | 5086 | 105 |
1367986 | 1367986 | 2021-05-29 | Medina | Texas | 48325 | 5086 | 105 |
1361159 | 1361159 | 2021-05-27 | Newberry | South Carolina | 45071 | 5086 | 106 |
1306608 | 1306608 | 2021-05-10 | Walla Walla | Washington | 53071 | 5086 | 65 |
1256633 | 1256633 | 2021-04-25 | Curry | New Mexico | 35009 | 5086 | 74 |
1253386 | 1253386 | 2021-04-24 | Curry | New Mexico | 35009 | 5086 | 74 |
1250139 | 1250139 | 2021-04-23 | Curry | New Mexico | 35009 | 5086 | 74 |
1239469 | 1239469 | 2021-04-20 | Webster | Iowa | 19187 | 5086 | 91 |
1237885 | 1237885 | 2021-04-19 | Franklin | Tennessee | 47051 | 5086 | 88 |
1217016 | 1217016 | 2021-04-13 | St. Martin | Louisiana | 22099 | 5086 | 115 |
1202672 | 1202672 | 2021-04-08 | Cowlitz | Washington | 53015 | 5086 | 77 |
1196340 | 1196340 | 2021-04-06 | Fremont | Wyoming | 56013 | 5086 | 82 |
1186243 | 1186243 | 2021-04-03 | Box Elder | Utah | 49003 | 5086 | 50 |
1158705 | 1158705 | 2021-03-26 | St. Joseph | Michigan | 26149 | 5086 | 89 |
1151538 | 1151538 | 2021-03-24 | Knox | Illinois | 17095 | 5086 | 164 |
1119762 | 1119762 | 2021-03-14 | Chisago | Minnesota | 27025 | 5086 | 47 |
1081653 | 1081653 | 2021-03-02 | Kay | Oklahoma | 40071 | 5086 | 81 |
1039214 | 1039214 | 2021-02-17 | Franklin | North Carolina | 37069 | 5086 | 42 |
1004837 | 1004837 | 2021-02-07 | Coffee | Alabama | 1031 | 5086 | 78 |
978951 | 978951 | 2021-01-30 | Graham | Arizona | 4009 | 5086 | 65 |
927081 | 927081 | 2021-01-14 | Lonoke | Arkansas | 5085 | 5086 | 95 |
912554 | 912554 | 2021-01-09 | Chemung | New York | 36015 | 5086 | 102 |
858087 | 858087 | 2020-12-23 | Greene | Tennessee | 47059 | 5086 | 88 |
858156 | 858156 | 2020-12-23 | Angelina | Texas | 48005 | 5086 | 135 |
804203 | 804203 | 2020-12-07 | Adams | Illinois | 17001 | 5086 | 57 |
801507 | 801507 | 2020-12-06 | Lafourche | Louisiana | 22057 | 5086 | 142 |
677006 | 677006 | 2020-10-28 | Marathon | Wisconsin | 55073 | 5086 | 57 |
524989 | 524989 | 2020-09-12 | Jefferson | Colorado | 8059 | 5086 | 245 |
455189 | 455189 | 2020-08-21 | St. Charles | Missouri | 29183 | 5086 | 105 |
412844 | 412844 | 2020-08-08 | St. Tammany | Louisiana | 22103 | 5086 | 211 |
409624 | 409624 | 2020-08-07 | St. Tammany | Louisiana | 22103 | 5086 | 211 |
328308 | 328308 | 2020-07-13 | Mobile | Alabama | 1097 | 5086 | 145 |
80043 | 80043 | 2020-04-22 | Monmouth | New Jersey | 34025 | 5086 | 251 |
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);