ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
288 rows where cases = 2212 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 25
- Virginia 19
- Iowa 17
- Oklahoma 17
- Kentucky 16
- North Carolina 15
- Mississippi 14
- Georgia 13
- Kansas 12
- Missouri 11
- Colorado 10
- Alabama 9
- Arkansas 9
- Florida 9
- Louisiana 8
- Tennessee 7
- Illinois 6
- Indiana 6
- Ohio 6
- West Virginia 6
- Idaho 5
- Puerto Rico 5
- Washington 5
- New Mexico 4
- Wisconsin 4
- Minnesota 3
- Nebraska 3
- North Dakota 3
- Pennsylvania 3
- Utah 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498953 | 2498953 | 2022-05-12 | Archer | Texas | 48009 | 2212 | 28 |
2490667 | 2490667 | 2022-05-10 | Montgomery | Iowa | 19137 | 2212 | 55 |
2487410 | 2487410 | 2022-05-09 | Montgomery | Iowa | 19137 | 2212 | 55 |
2484152 | 2484152 | 2022-05-08 | Montgomery | Iowa | 19137 | 2212 | 55 |
2480894 | 2480894 | 2022-05-07 | Montgomery | Iowa | 19137 | 2212 | 55 |
2477636 | 2477636 | 2022-05-06 | Montgomery | Iowa | 19137 | 2212 | 55 |
2474378 | 2474378 | 2022-05-05 | Montgomery | Iowa | 19137 | 2212 | 55 |
2471121 | 2471121 | 2022-05-04 | Montgomery | Iowa | 19137 | 2212 | 55 |
2461603 | 2461603 | 2022-05-01 | Trimble | Kentucky | 21223 | 2212 | 39 |
2458347 | 2458347 | 2022-04-30 | Trimble | Kentucky | 21223 | 2212 | 39 |
2455091 | 2455091 | 2022-04-29 | Trimble | Kentucky | 21223 | 2212 | 39 |
2451835 | 2451835 | 2022-04-28 | Trimble | Kentucky | 21223 | 2212 | 39 |
2448579 | 2448579 | 2022-04-27 | Trimble | Kentucky | 21223 | 2212 | 39 |
2445323 | 2445323 | 2022-04-26 | Trimble | Kentucky | 21223 | 2212 | 39 |
2447296 | 2447296 | 2022-04-26 | Lincoln | Washington | 53043 | 2212 | 28 |
2442067 | 2442067 | 2022-04-25 | Trimble | Kentucky | 21223 | 2212 | 39 |
2444040 | 2444040 | 2022-04-25 | Lincoln | Washington | 53043 | 2212 | 28 |
2423378 | 2423378 | 2022-04-19 | Jones | North Carolina | 37103 | 2212 | 38 |
2420121 | 2420121 | 2022-04-18 | Jones | North Carolina | 37103 | 2212 | 38 |
2416866 | 2416866 | 2022-04-17 | Jones | North Carolina | 37103 | 2212 | 38 |
2413610 | 2413610 | 2022-04-16 | Jones | North Carolina | 37103 | 2212 | 38 |
2410354 | 2410354 | 2022-04-15 | Jones | North Carolina | 37103 | 2212 | 38 |
2407098 | 2407098 | 2022-04-14 | Jones | North Carolina | 37103 | 2212 | 38 |
2403842 | 2403842 | 2022-04-13 | Jones | North Carolina | 37103 | 2212 | 38 |
2292176 | 2292176 | 2022-03-10 | Cloud | Kansas | 20029 | 2212 | 36 |
2288924 | 2288924 | 2022-03-09 | Cloud | Kansas | 20029 | 2212 | 36 |
2274147 | 2274147 | 2022-03-04 | Sabana Grande | Puerto Rico | 72121 | 2212 | |
2259777 | 2259777 | 2022-02-28 | Elliott | Kentucky | 21063 | 2212 | 16 |
2257007 | 2257007 | 2022-02-27 | Carroll | Missouri | 29033 | 2212 | 42 |
2253756 | 2253756 | 2022-02-26 | Carroll | Missouri | 29033 | 2212 | 42 |
2250505 | 2250505 | 2022-02-25 | Carroll | Missouri | 29033 | 2212 | 42 |
2242058 | 2242058 | 2022-02-22 | Red River | Texas | 48387 | 2212 | 64 |
2236289 | 2236289 | 2022-02-21 | San Miguel | Colorado | 8113 | 2212 | 7 |
2235701 | 2235701 | 2022-02-20 | Essex | Virginia | 51057 | 2212 | 26 |
2232450 | 2232450 | 2022-02-19 | Essex | Virginia | 51057 | 2212 | 26 |
2229199 | 2229199 | 2022-02-18 | Essex | Virginia | 51057 | 2212 | 26 |
2216232 | 2216232 | 2022-02-14 | Lunenburg | Virginia | 51111 | 2212 | 27 |
2203595 | 2203595 | 2022-02-11 | Cleveland | Arkansas | 5025 | 2212 | 33 |
2203329 | 2203329 | 2022-02-10 | Clay | West Virginia | 54015 | 2212 | 32 |
2195941 | 2195941 | 2022-02-08 | Woods | Oklahoma | 40151 | 2212 | 30 |
2191005 | 2191005 | 2022-02-07 | Wilkes | Georgia | 13317 | 2212 | 44 |
2192687 | 2192687 | 2022-02-07 | Woods | Oklahoma | 40151 | 2212 | 30 |
2189433 | 2189433 | 2022-02-06 | Woods | Oklahoma | 40151 | 2212 | 30 |
2186180 | 2186180 | 2022-02-05 | Woods | Oklahoma | 40151 | 2212 | 30 |
2182928 | 2182928 | 2022-02-04 | Woods | Oklahoma | 40151 | 2212 | 30 |
2179676 | 2179676 | 2022-02-03 | Woods | Oklahoma | 40151 | 2212 | 30 |
2176425 | 2176425 | 2022-02-02 | Woods | Oklahoma | 40151 | 2212 | 30 |
2148059 | 2148059 | 2022-01-24 | Summers | West Virginia | 54089 | 2212 | 43 |
2131496 | 2131496 | 2022-01-19 | Trinity | Texas | 48455 | 2212 | 65 |
2127575 | 2127575 | 2022-01-18 | Johnston | Oklahoma | 40069 | 2212 | 49 |
2122434 | 2122434 | 2022-01-17 | Rio Grande | Colorado | 8105 | 2212 | 41 |
2124323 | 2124323 | 2022-01-17 | Johnston | Oklahoma | 40069 | 2212 | 49 |
2121071 | 2121071 | 2022-01-16 | Johnston | Oklahoma | 40069 | 2212 | 49 |
2117819 | 2117819 | 2022-01-15 | Johnston | Oklahoma | 40069 | 2212 | 49 |
2114568 | 2114568 | 2022-01-14 | Johnston | Oklahoma | 40069 | 2212 | 49 |
2111316 | 2111316 | 2022-01-13 | Johnston | Oklahoma | 40069 | 2212 | 49 |
2108064 | 2108064 | 2022-01-12 | Johnston | Oklahoma | 40069 | 2212 | 49 |
2097642 | 2097642 | 2022-01-09 | Cedar | Missouri | 29039 | 2212 | 42 |
2086009 | 2086009 | 2022-01-05 | Juab | Utah | 49023 | 2212 | 21 |
2082757 | 2082757 | 2022-01-04 | Juab | Utah | 49023 | 2212 | 21 |
2079505 | 2079505 | 2022-01-03 | Juab | Utah | 49023 | 2212 | 21 |
2073960 | 2073960 | 2022-01-02 | Shoshone | Idaho | 16079 | 2212 | 67 |
2076071 | 2076071 | 2022-01-02 | Gaines | Texas | 48165 | 2212 | 68 |
2070709 | 2070709 | 2022-01-01 | Shoshone | Idaho | 16079 | 2212 | 67 |
2072820 | 2072820 | 2022-01-01 | Gaines | Texas | 48165 | 2212 | 68 |
2067458 | 2067458 | 2021-12-31 | Shoshone | Idaho | 16079 | 2212 | 67 |
2069569 | 2069569 | 2021-12-31 | Gaines | Texas | 48165 | 2212 | 68 |
2064207 | 2064207 | 2021-12-30 | Shoshone | Idaho | 16079 | 2212 | 67 |
2066318 | 2066318 | 2021-12-30 | Gaines | Texas | 48165 | 2212 | 68 |
2063068 | 2063068 | 2021-12-29 | Gaines | Texas | 48165 | 2212 | 68 |
2059818 | 2059818 | 2021-12-28 | Gaines | Texas | 48165 | 2212 | 68 |
2052457 | 2052457 | 2021-12-26 | Torrance | New Mexico | 35057 | 2212 | 33 |
2049207 | 2049207 | 2021-12-25 | Torrance | New Mexico | 35057 | 2212 | 33 |
2045957 | 2045957 | 2021-12-24 | Torrance | New Mexico | 35057 | 2212 | 33 |
2042707 | 2042707 | 2021-12-23 | Torrance | New Mexico | 35057 | 2212 | 33 |
2035595 | 2035595 | 2021-12-21 | Dukes | Massachusetts | 25007 | 2212 | 0 |
1993557 | 1993557 | 2021-12-08 | Lawrence | Mississippi | 28077 | 2212 | 42 |
1994328 | 1994328 | 2021-12-08 | Unknown | Oklahoma | 2212 | 2 | |
1991463 | 1991463 | 2021-12-07 | Stewart | Tennessee | 47161 | 2212 | 38 |
1982501 | 1982501 | 2021-12-05 | Lee | Arkansas | 5077 | 2212 | 52 |
1985330 | 1985330 | 2021-12-05 | Goochland | Virginia | 51075 | 2212 | 31 |
1982080 | 1982080 | 2021-12-04 | Goochland | Virginia | 51075 | 2212 | 31 |
1978830 | 1978830 | 2021-12-03 | Goochland | Virginia | 51075 | 2212 | 31 |
1973941 | 1973941 | 2021-12-02 | Chippewa | Minnesota | 27023 | 2212 | 42 |
1942972 | 1942972 | 2021-11-22 | Zapata | Texas | 48505 | 2212 | 45 |
1943226 | 1943226 | 2021-11-22 | Monroe | West Virginia | 54063 | 2212 | 26 |
1939722 | 1939722 | 2021-11-21 | Zapata | Texas | 48505 | 2212 | 45 |
1936472 | 1936472 | 2021-11-20 | Zapata | Texas | 48505 | 2212 | 45 |
1924504 | 1924504 | 2021-11-17 | Mason | Illinois | 17125 | 2212 | 54 |
1924510 | 1924510 | 2021-11-17 | Mercer | Illinois | 17131 | 2212 | 37 |
1923183 | 1923183 | 2021-11-16 | Meigs | Tennessee | 47121 | 2212 | 30 |
1886405 | 1886405 | 2021-11-05 | Macon | Missouri | 29121 | 2212 | 19 |
1881779 | 1881779 | 2021-11-04 | Van Buren | Arkansas | 5141 | 2212 | 43 |
1884707 | 1884707 | 2021-11-04 | Grant | West Virginia | 54023 | 2212 | 33 |
1875956 | 1875956 | 2021-11-02 | Madison | Iowa | 19121 | 2212 | 25 |
1872707 | 1872707 | 2021-11-01 | Madison | Iowa | 19121 | 2212 | 25 |
1873286 | 1873286 | 2021-11-01 | Greene | Mississippi | 28041 | 2212 | 49 |
1869458 | 1869458 | 2021-10-31 | Madison | Iowa | 19121 | 2212 | 25 |
1870037 | 1870037 | 2021-10-31 | Greene | Mississippi | 28041 | 2212 | 49 |
1866209 | 1866209 | 2021-10-30 | Madison | Iowa | 19121 | 2212 | 25 |
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);