ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
83 rows where cases = 5069 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Texas 10
- Indiana 8
- Georgia 7
- North Carolina 7
- Missouri 6
- Kentucky 5
- Ohio 5
- Mississippi 3
- North Dakota 3
- Virginia 3
- Wisconsin 3
- Alabama 2
- Arkansas 2
- Florida 2
- Illinois 2
- Louisiana 2
- Minnesota 2
- Colorado 1
- Iowa 1
- Michigan 1
- New Mexico 1
- New York 1
- Oklahoma 1
- Pennsylvania 1
- Puerto Rico 1
- Tennessee 1
- West Virginia 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2358286 | 2358286 | 2022-03-30 | Madison | North Carolina | 37115 | 5069 | 79 |
2316805 | 2316805 | 2022-03-17 | Limestone | Texas | 48293 | 5069 | 124 |
2265358 | 2265358 | 2022-03-02 | Ashley | Arkansas | 5003 | 5069 | 61 |
2239683 | 2239683 | 2022-02-22 | Fannin | Georgia | 13111 | 5069 | 135 |
2239862 | 2239862 | 2022-02-22 | Edgar | Illinois | 17045 | 5069 | 77 |
2198074 | 2198074 | 2022-02-09 | Spencer | Kentucky | 21215 | 5069 | 48 |
2156017 | 2156017 | 2022-01-27 | Dodge | Minnesota | 27039 | 5069 | 14 |
2129414 | 2129414 | 2022-01-19 | Randolph | Indiana | 18135 | 5069 | 131 |
2091718 | 2091718 | 2022-01-07 | Henry | Ohio | 39069 | 5069 | 90 |
2081014 | 2081014 | 2022-01-04 | Jefferson Davis | Louisiana | 22053 | 5069 | 133 |
2051344 | 2051344 | 2021-12-26 | Greene | Indiana | 18055 | 5069 | 110 |
2048094 | 2048094 | 2021-12-25 | Greene | Indiana | 18055 | 5069 | 110 |
2044844 | 2044844 | 2021-12-24 | Greene | Indiana | 18055 | 5069 | 110 |
2041595 | 2041595 | 2021-12-23 | Greene | Indiana | 18055 | 5069 | 110 |
2038345 | 2038345 | 2021-12-22 | Greene | Indiana | 18055 | 5069 | 110 |
1991982 | 1991982 | 2021-12-07 | Mingo | West Virginia | 54059 | 5069 | 91 |
1982837 | 1982837 | 2021-12-05 | Madison | Georgia | 13195 | 5069 | 80 |
1979587 | 1979587 | 2021-12-04 | Madison | Georgia | 13195 | 5069 | 80 |
1976337 | 1976337 | 2021-12-03 | Madison | Georgia | 13195 | 5069 | 80 |
1973647 | 1973647 | 2021-12-02 | Grayson | Kentucky | 21085 | 5069 | 100 |
1965551 | 1965551 | 2021-11-29 | Fannin | Texas | 48147 | 5069 | 153 |
1946044 | 1946044 | 2021-11-23 | Fannin | Texas | 48147 | 5069 | 153 |
1923897 | 1923897 | 2021-11-17 | Pike | Alabama | 1109 | 5069 | 108 |
1920365 | 1920365 | 2021-11-15 | Petersburg city | Virginia | 51730 | 5069 | 103 |
1902476 | 1902476 | 2021-11-10 | Nobles | Minnesota | 27105 | 5069 | 53 |
1862051 | 1862051 | 2021-10-28 | Oneida | Wisconsin | 55085 | 5069 | 91 |
1847835 | 1847835 | 2021-10-24 | Person | North Carolina | 37145 | 5069 | 87 |
1844585 | 1844585 | 2021-10-23 | Person | North Carolina | 37145 | 5069 | 87 |
1841335 | 1841335 | 2021-10-22 | Person | North Carolina | 37145 | 5069 | 87 |
1838781 | 1838781 | 2021-10-21 | Cooke | Texas | 48097 | 5069 | 99 |
1824139 | 1824139 | 2021-10-17 | Clay | Kentucky | 21051 | 5069 | 56 |
1820890 | 1820890 | 2021-10-16 | Clay | Kentucky | 21051 | 5069 | 56 |
1817641 | 1817641 | 2021-10-15 | Clay | Kentucky | 21051 | 5069 | 56 |
1796587 | 1796587 | 2021-10-08 | Grimes | Texas | 48185 | 5069 | 98 |
1788926 | 1788926 | 2021-10-06 | Lawrence | Missouri | 29109 | 5069 | 104 |
1775937 | 1775937 | 2021-10-02 | Marion | Missouri | 29127 | 5069 | 58 |
1767577 | 1767577 | 2021-09-29 | Charlottesville city | Virginia | 51540 | 5069 | 57 |
1725026 | 1725026 | 2021-09-16 | Bee | Texas | 48025 | 5069 | 96 |
1656907 | 1656907 | 2021-08-26 | Hill | Texas | 48217 | 5069 | 116 |
1645973 | 1645973 | 2021-08-23 | Howell | Missouri | 29091 | 5069 | 58 |
1647658 | 1647658 | 2021-08-23 | Albany | Wyoming | 56001 | 5069 | 19 |
1643297 | 1643297 | 2021-08-22 | Mercer | Ohio | 39107 | 5069 | 86 |
1640035 | 1640035 | 2021-08-21 | Knox | Ohio | 39083 | 5069 | 115 |
1633013 | 1633013 | 2021-08-19 | Platte | Missouri | 29165 | 5069 | 53 |
1614705 | 1614705 | 2021-08-13 | Kerr | Texas | 48265 | 5069 | 96 |
1605404 | 1605404 | 2021-08-10 | Pierce | Wisconsin | 55093 | 5069 | 44 |
1597125 | 1597125 | 2021-08-08 | Bolivar | Mississippi | 28011 | 5069 | 134 |
1593876 | 1593876 | 2021-08-07 | Bolivar | Mississippi | 28011 | 5069 | 134 |
1590627 | 1590627 | 2021-08-06 | Bolivar | Mississippi | 28011 | 5069 | 134 |
1588359 | 1588359 | 2021-08-05 | Toa Baja | Puerto Rico | 72137 | 5069 | |
1561968 | 1561968 | 2021-07-28 | Watauga | North Carolina | 37189 | 5069 | 33 |
1559666 | 1559666 | 2021-07-27 | Campbell | Virginia | 51031 | 5069 | 103 |
1555532 | 1555532 | 2021-07-26 | Williams | North Dakota | 38105 | 5069 | 40 |
1552285 | 1552285 | 2021-07-25 | Williams | North Dakota | 38105 | 5069 | 40 |
1552294 | 1552294 | 2021-07-25 | Auglaize | Ohio | 39011 | 5069 | 87 |
1549047 | 1549047 | 2021-07-24 | Auglaize | Ohio | 39011 | 5069 | 87 |
1428376 | 1428376 | 2021-06-17 | Callaway | Missouri | 29027 | 5069 | 51 |
1372432 | 1372432 | 2021-05-31 | Jackson | Indiana | 18071 | 5069 | 75 |
1369187 | 1369187 | 2021-05-30 | Jackson | Indiana | 18071 | 5069 | 75 |
1358657 | 1358657 | 2021-05-26 | Oconto | Wisconsin | 55083 | 5069 | 65 |
1331319 | 1331319 | 2021-05-18 | Otero | New Mexico | 35035 | 5069 | 75 |
1302135 | 1302135 | 2021-05-09 | Herkimer | New York | 36043 | 5069 | 107 |
1257121 | 1257121 | 2021-04-25 | Mifflin | Pennsylvania | 42087 | 5069 | 176 |
1251707 | 1251707 | 2021-04-24 | Hot Spring | Arkansas | 5059 | 5069 | 71 |
1221647 | 1221647 | 2021-04-14 | Franklin | Tennessee | 47051 | 5069 | 88 |
1214632 | 1214632 | 2021-04-12 | Morton | North Dakota | 38059 | 5069 | 98 |
1181696 | 1181696 | 2021-04-02 | Pettis | Missouri | 29159 | 5069 | 78 |
1141797 | 1141797 | 2021-03-21 | Knox | Illinois | 17095 | 5069 | 164 |
1135115 | 1135115 | 2021-03-19 | Habersham | Georgia | 13137 | 5069 | 147 |
1122488 | 1122488 | 2021-03-15 | Clinton | Iowa | 19045 | 5069 | 87 |
1123615 | 1123615 | 2021-03-15 | Halifax | North Carolina | 37083 | 5069 | 102 |
1104387 | 1104387 | 2021-03-09 | McClain | Oklahoma | 40087 | 5069 | 52 |
1006778 | 1006778 | 2021-02-07 | Lee | North Carolina | 37105 | 5069 | 65 |
965267 | 965267 | 2021-01-25 | Bowie | Texas | 48037 | 5069 | 150 |
962022 | 962022 | 2021-01-24 | Bowie | Texas | 48037 | 5069 | 150 |
875066 | 875066 | 2020-12-29 | Walker | Alabama | 1127 | 5069 | 136 |
736600 | 736600 | 2020-11-16 | Livingston | Louisiana | 22063 | 5069 | 87 |
690465 | 690465 | 2020-11-02 | Columbia | Georgia | 13073 | 5069 | 66 |
408723 | 408723 | 2020-08-07 | El Paso | Colorado | 8041 | 5069 | 138 |
389517 | 389517 | 2020-08-01 | Marion | Florida | 12083 | 5069 | 61 |
373398 | 373398 | 2020-07-27 | Brevard | Florida | 12009 | 5069 | 65 |
231254 | 231254 | 2020-06-12 | Fulton | Georgia | 13121 | 5069 | 280 |
27118 | 27118 | 2020-04-02 | Wayne | Michigan | 26163 | 5069 | 194 |
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);