ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
129 rows where cases = 4206 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 12
- Kentucky 11
- Illinois 9
- Texas 9
- Georgia 8
- Minnesota 7
- North Carolina 7
- Virginia 7
- Indiana 6
- Mississippi 6
- Iowa 5
- Arkansas 4
- New Hampshire 4
- Missouri 3
- New York 3
- Pennsylvania 3
- Utah 3
- Wisconsin 3
- Alabama 2
- Oregon 2
- Washington 2
- California 1
- Colorado 1
- Florida 1
- Idaho 1
- Louisiana 1
- Maryland 1
- Montana 1
- New Mexico 1
- North Dakota 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2377248 | 2377248 | 2022-04-05 | Wadena | Minnesota | 27159 | 4206 | 54 |
2373996 | 2373996 | 2022-04-04 | Wadena | Minnesota | 27159 | 4206 | 54 |
2370743 | 2370743 | 2022-04-03 | Wadena | Minnesota | 27159 | 4206 | 54 |
2367490 | 2367490 | 2022-04-02 | Wadena | Minnesota | 27159 | 4206 | 54 |
2364237 | 2364237 | 2022-04-01 | Wadena | Minnesota | 27159 | 4206 | 54 |
2333203 | 2333203 | 2022-03-22 | Unknown | Utah | 4206 | 82 | |
2328193 | 2328193 | 2022-03-21 | LaSalle | Louisiana | 22059 | 4206 | 56 |
2310141 | 2310141 | 2022-03-15 | Trousdale | Tennessee | 47169 | 4206 | 45 |
2306888 | 2306888 | 2022-03-14 | Trousdale | Tennessee | 47169 | 4206 | 45 |
2303637 | 2303637 | 2022-03-13 | Trousdale | Tennessee | 47169 | 4206 | 45 |
2300385 | 2300385 | 2022-03-12 | Trousdale | Tennessee | 47169 | 4206 | 45 |
2297133 | 2297133 | 2022-03-11 | Trousdale | Tennessee | 47169 | 4206 | 45 |
2293881 | 2293881 | 2022-03-10 | Trousdale | Tennessee | 47169 | 4206 | 45 |
2290629 | 2290629 | 2022-03-09 | Trousdale | Tennessee | 47169 | 4206 | 45 |
2291181 | 2291181 | 2022-03-09 | Crawford | Wisconsin | 55023 | 4206 | 28 |
2282937 | 2282937 | 2022-03-07 | Clarke | Mississippi | 28023 | 4206 | 106 |
2278866 | 2278866 | 2022-03-06 | Carroll | Illinois | 17015 | 4206 | 48 |
2275613 | 2275613 | 2022-03-05 | Carroll | Illinois | 17015 | 4206 | 48 |
2272360 | 2272360 | 2022-03-04 | Carroll | Illinois | 17015 | 4206 | 48 |
2262707 | 2262707 | 2022-03-01 | Carroll | Indiana | 18015 | 4206 | 64 |
2187745 | 2187745 | 2022-02-06 | Washington | Georgia | 13303 | 4206 | 131 |
2184492 | 2184492 | 2022-02-05 | Washington | Georgia | 13303 | 4206 | 131 |
2181240 | 2181240 | 2022-02-04 | Washington | Georgia | 13303 | 4206 | 131 |
2179681 | 2179681 | 2022-02-03 | Clatsop | Oregon | 41007 | 4206 | 38 |
2180391 | 2180391 | 2022-02-03 | Buchanan | Virginia | 51027 | 4206 | 91 |
2109603 | 2109603 | 2022-01-13 | Jones | Georgia | 13169 | 4206 | 99 |
2103974 | 2103974 | 2022-01-11 | Dodge | Minnesota | 27039 | 4206 | 14 |
2100427 | 2100427 | 2022-01-10 | Hart | Kentucky | 21099 | 4206 | 85 |
2074090 | 2074090 | 2022-01-02 | Fountain | Indiana | 18045 | 4206 | 76 |
2070839 | 2070839 | 2022-01-01 | Fountain | Indiana | 18045 | 4206 | 76 |
2067588 | 2067588 | 2021-12-31 | Fountain | Indiana | 18045 | 4206 | 76 |
2064337 | 2064337 | 2021-12-30 | Fountain | Indiana | 18045 | 4206 | 76 |
2054038 | 2054038 | 2021-12-27 | Sevier | Arkansas | 5133 | 4206 | 63 |
2050788 | 2050788 | 2021-12-26 | Sevier | Arkansas | 5133 | 4206 | 63 |
2014230 | 2014230 | 2021-12-14 | Wayne | Tennessee | 47181 | 4206 | 41 |
1967324 | 1967324 | 2021-11-30 | Queen Anne's | Maryland | 24035 | 4206 | 75 |
1962529 | 1962529 | 2021-11-28 | Accomack | Virginia | 51001 | 4206 | 80 |
1959278 | 1959278 | 2021-11-27 | Accomack | Virginia | 51001 | 4206 | 80 |
1956027 | 1956027 | 2021-11-26 | Accomack | Virginia | 51001 | 4206 | 80 |
1926166 | 1926166 | 2021-11-17 | Susquehanna | Pennsylvania | 42115 | 4206 | 71 |
1855538 | 1855538 | 2021-10-26 | Juneau | Wisconsin | 55057 | 4206 | 35 |
1814826 | 1814826 | 2021-10-14 | Marion | Mississippi | 28091 | 4206 | 107 |
1805669 | 1805669 | 2021-10-11 | Stutsman | North Dakota | 38093 | 4206 | 82 |
1792103 | 1792103 | 2021-10-07 | Sunflower | Mississippi | 28133 | 4206 | 104 |
1792123 | 1792123 | 2021-10-07 | Barry | Missouri | 29009 | 4206 | 60 |
1789652 | 1789652 | 2021-10-06 | Clarion | Pennsylvania | 42031 | 4206 | 109 |
1761881 | 1761881 | 2021-09-28 | Pierce | Georgia | 13229 | 4206 | 86 |
1761221 | 1761221 | 2021-09-27 | Stevens | Washington | 53065 | 4206 | 62 |
1740871 | 1740871 | 2021-09-21 | Coos | Oregon | 41011 | 4206 | 69 |
1737355 | 1737355 | 2021-09-20 | Montgomery | North Carolina | 37123 | 4206 | 105 |
1725586 | 1725586 | 2021-09-16 | Oneida | Wisconsin | 55085 | 4206 | 83 |
1701551 | 1701551 | 2021-09-09 | Tioga | New York | 36107 | 4206 | 65 |
1675497 | 1675497 | 2021-09-01 | Rio Arriba | New Mexico | 35039 | 4206 | 82 |
1664927 | 1664927 | 2021-08-29 | Bell | Kentucky | 21013 | 4206 | 62 |
1661679 | 1661679 | 2021-08-28 | Bell | Kentucky | 21013 | 4206 | 62 |
1658431 | 1658431 | 2021-08-27 | Bell | Kentucky | 21013 | 4206 | 62 |
1648698 | 1648698 | 2021-08-24 | Calloway | Kentucky | 21035 | 4206 | 53 |
1646214 | 1646214 | 2021-08-23 | Cheshire | New Hampshire | 33005 | 4206 | 36 |
1624759 | 1624759 | 2021-08-16 | Douglas | Washington | 53017 | 4206 | 23 |
1596766 | 1596766 | 2021-08-08 | Knox | Kentucky | 21121 | 4206 | 47 |
1597490 | 1597490 | 2021-08-08 | Grafton | New Hampshire | 33009 | 4206 | 29 |
1597692 | 1597692 | 2021-08-08 | Scotland | North Carolina | 37165 | 4206 | 91 |
1593517 | 1593517 | 2021-08-07 | Knox | Kentucky | 21121 | 4206 | 47 |
1594241 | 1594241 | 2021-08-07 | Grafton | New Hampshire | 33009 | 4206 | 29 |
1594443 | 1594443 | 2021-08-07 | Scotland | North Carolina | 37165 | 4206 | 91 |
1590268 | 1590268 | 2021-08-06 | Knox | Kentucky | 21121 | 4206 | 47 |
1590992 | 1590992 | 2021-08-06 | Grafton | New Hampshire | 33009 | 4206 | 29 |
1591194 | 1591194 | 2021-08-06 | Scotland | North Carolina | 37165 | 4206 | 91 |
1581118 | 1581118 | 2021-08-03 | Silver Bow | Montana | 30093 | 4206 | 86 |
1575289 | 1575289 | 2021-08-01 | Wayne | Pennsylvania | 42127 | 4206 | 84 |
1530886 | 1530886 | 2021-07-19 | Independence | Arkansas | 5063 | 4206 | 127 |
1515159 | 1515159 | 2021-07-14 | Lee | Illinois | 17103 | 4206 | 93 |
1508292 | 1508292 | 2021-07-12 | La Plata | Colorado | 8067 | 4206 | 41 |
1509475 | 1509475 | 2021-07-12 | Monroe | Mississippi | 28095 | 4206 | 136 |
1509947 | 1509947 | 2021-07-12 | Davie | North Carolina | 37059 | 4206 | 40 |
1505447 | 1505447 | 2021-07-11 | Randolph | Illinois | 17157 | 4206 | 93 |
1502201 | 1502201 | 2021-07-10 | Randolph | Illinois | 17157 | 4206 | 93 |
1498955 | 1498955 | 2021-07-09 | Randolph | Illinois | 17157 | 4206 | 93 |
1423863 | 1423863 | 2021-06-16 | Tuolumne | California | 6109 | 4206 | 71 |
1411483 | 1411483 | 2021-06-12 | Jasper | Iowa | 19099 | 4206 | 72 |
1408238 | 1408238 | 2021-06-11 | Jasper | Iowa | 19099 | 4206 | 72 |
1404992 | 1404992 | 2021-06-10 | Jasper | Iowa | 19099 | 4206 | 72 |
1401747 | 1401747 | 2021-06-09 | Jasper | Iowa | 19099 | 4206 | 72 |
1400275 | 1400275 | 2021-06-08 | Weakley | Tennessee | 47183 | 4206 | 67 |
1386255 | 1386255 | 2021-06-04 | Platte | Missouri | 29165 | 4206 | 47 |
1377797 | 1377797 | 2021-06-01 | Waller | Texas | 48473 | 4206 | 49 |
1374551 | 1374551 | 2021-05-31 | Waller | Texas | 48473 | 4206 | 49 |
1371306 | 1371306 | 2021-05-30 | Waller | Texas | 48473 | 4206 | 49 |
1368060 | 1368060 | 2021-05-29 | Waller | Texas | 48473 | 4206 | 49 |
1355483 | 1355483 | 2021-05-26 | Covington | Alabama | 1039 | 4206 | 119 |
1334241 | 1334241 | 2021-05-19 | Butler | Missouri | 29023 | 4206 | 48 |
1327282 | 1327282 | 2021-05-17 | Graves | Kentucky | 21083 | 4206 | 93 |
1324866 | 1324866 | 2021-05-16 | Montgomery | New York | 36057 | 4206 | 123 |
1325577 | 1325577 | 2021-05-16 | Marshall | Tennessee | 47117 | 4206 | 58 |
1322331 | 1322331 | 2021-05-15 | Marshall | Tennessee | 47117 | 4206 | 58 |
1319085 | 1319085 | 2021-05-14 | Marshall | Tennessee | 47117 | 4206 | 58 |
1315913 | 1315913 | 2021-05-13 | Cherokee | Texas | 48073 | 4206 | 140 |
1306646 | 1306646 | 2021-05-10 | Ohio | West Virginia | 54069 | 4206 | 84 |
1264533 | 1264533 | 2021-04-27 | Albany | Wyoming | 56001 | 4206 | 11 |
1254315 | 1254315 | 2021-04-24 | Jim Wells | Texas | 48249 | 4206 | 100 |
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);