ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
195 rows where cases = 2470 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 15
- Georgia 14
- Virginia 12
- Florida 11
- Indiana 11
- Kentucky 11
- Mississippi 10
- Missouri 10
- Iowa 9
- Idaho 8
- Alabama 7
- Arkansas 7
- Ohio 7
- Wisconsin 7
- Louisiana 6
- North Carolina 6
- Kansas 5
- Illinois 4
- Michigan 4
- Puerto Rico 4
- Minnesota 3
- New Mexico 3
- Pennsylvania 3
- Tennessee 3
- Colorado 2
- Washington 2
- Alaska 1
- Arizona 1
- Hawaii 1
- Maryland 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501164 | 2501164 | 2022-05-13 | Ralls | Missouri | 29173 | 2470 | 28 |
2463381 | 2463381 | 2022-05-01 | Emery | Utah | 49015 | 2470 | 28 |
2421138 | 2421138 | 2022-04-18 | Franklin city | Virginia | 51620 | 2470 | 54 |
2395071 | 2395071 | 2022-04-10 | Charlotte | Virginia | 51037 | 2470 | 45 |
2391815 | 2391815 | 2022-04-09 | Charlotte | Virginia | 51037 | 2470 | 45 |
2388559 | 2388559 | 2022-04-08 | Charlotte | Virginia | 51037 | 2470 | 45 |
2347610 | 2347610 | 2022-03-27 | Hancock | Kentucky | 21091 | 2470 | 23 |
2344357 | 2344357 | 2022-03-26 | Hancock | Kentucky | 21091 | 2470 | 23 |
2341104 | 2341104 | 2022-03-25 | Hancock | Kentucky | 21091 | 2470 | 23 |
2337851 | 2337851 | 2022-03-24 | Hancock | Kentucky | 21091 | 2470 | 23 |
2334597 | 2334597 | 2022-03-23 | Hancock | Kentucky | 21091 | 2470 | 23 |
2331343 | 2331343 | 2022-03-22 | Hancock | Kentucky | 21091 | 2470 | 23 |
2328091 | 2328091 | 2022-03-21 | Hancock | Kentucky | 21091 | 2470 | 23 |
2310613 | 2310613 | 2022-03-15 | Pend Oreille | Washington | 53051 | 2470 | 36 |
2304981 | 2304981 | 2022-03-14 | Benton | Indiana | 18007 | 2470 | 21 |
2307360 | 2307360 | 2022-03-14 | Pend Oreille | Washington | 53051 | 2470 | 36 |
2301729 | 2301729 | 2022-03-13 | Benton | Indiana | 18007 | 2470 | 21 |
2298477 | 2298477 | 2022-03-12 | Benton | Indiana | 18007 | 2470 | 21 |
2295225 | 2295225 | 2022-03-11 | Benton | Indiana | 18007 | 2470 | 21 |
2256093 | 2256093 | 2022-02-27 | Valley | Idaho | 16085 | 2470 | 16 |
2252842 | 2252842 | 2022-02-26 | Valley | Idaho | 16085 | 2470 | 16 |
2254595 | 2254595 | 2022-02-26 | Ciales | Puerto Rico | 72039 | 2470 | |
2249591 | 2249591 | 2022-02-25 | Valley | Idaho | 16085 | 2470 | 16 |
2240069 | 2240069 | 2022-02-22 | Franklin | Iowa | 19069 | 2470 | 40 |
2236818 | 2236818 | 2022-02-21 | Franklin | Iowa | 19069 | 2470 | 40 |
2233567 | 2233567 | 2022-02-20 | Franklin | Iowa | 19069 | 2470 | 40 |
2230316 | 2230316 | 2022-02-19 | Franklin | Iowa | 19069 | 2470 | 40 |
2227065 | 2227065 | 2022-02-18 | Franklin | Iowa | 19069 | 2470 | 40 |
2223814 | 2223814 | 2022-02-17 | Franklin | Iowa | 19069 | 2470 | 40 |
2220563 | 2220563 | 2022-02-16 | Franklin | Iowa | 19069 | 2470 | 40 |
2210695 | 2210695 | 2022-02-13 | Crawford | Indiana | 18025 | 2470 | 35 |
2207442 | 2207442 | 2022-02-12 | Crawford | Indiana | 18025 | 2470 | 35 |
2204189 | 2204189 | 2022-02-11 | Crawford | Indiana | 18025 | 2470 | 35 |
2189178 | 2189178 | 2022-02-06 | Pamlico | North Carolina | 37137 | 2470 | 27 |
2185925 | 2185925 | 2022-02-05 | Pamlico | North Carolina | 37137 | 2470 | 27 |
2182673 | 2182673 | 2022-02-04 | Pamlico | North Carolina | 37137 | 2470 | 27 |
2177980 | 2177980 | 2022-02-03 | Turner | Georgia | 13287 | 2470 | 50 |
2168449 | 2168449 | 2022-01-31 | Newton | Indiana | 18111 | 2470 | 64 |
2166253 | 2166253 | 2022-01-30 | Colfax | New Mexico | 35007 | 2470 | 59 |
2162998 | 2162998 | 2022-01-29 | Colfax | New Mexico | 35007 | 2470 | 59 |
2159743 | 2159743 | 2022-01-28 | Colfax | New Mexico | 35007 | 2470 | 59 |
2142097 | 2142097 | 2022-01-23 | Early | Georgia | 13099 | 2470 | 58 |
2138842 | 2138842 | 2022-01-22 | Early | Georgia | 13099 | 2470 | 58 |
2135586 | 2135586 | 2022-01-21 | Early | Georgia | 13099 | 2470 | 58 |
2125507 | 2125507 | 2022-01-18 | Chicot | Arkansas | 5017 | 2470 | 49 |
2114791 | 2114791 | 2022-01-14 | Villalba | Puerto Rico | 72149 | 2470 | |
2115074 | 2115074 | 2022-01-14 | Eastland | Texas | 48133 | 2470 | 91 |
2110706 | 2110706 | 2022-01-13 | Pemiscot | Missouri | 29155 | 2470 | 60 |
2111822 | 2111822 | 2022-01-13 | Eastland | Texas | 48133 | 2470 | 91 |
2004174 | 2004174 | 2021-12-11 | Potter | Pennsylvania | 42105 | 2470 | 70 |
1988543 | 1988543 | 2021-12-06 | Bristol city | Virginia | 51520 | 2470 | 50 |
1978250 | 1978250 | 2021-12-03 | San Lorenzo | Puerto Rico | 72129 | 2470 | |
1963109 | 1963109 | 2021-11-29 | Crowley | Colorado | 8025 | 2470 | 26 |
1917260 | 1917260 | 2021-11-14 | Crawford | Wisconsin | 55023 | 2470 | 23 |
1914010 | 1914010 | 2021-11-13 | Crawford | Wisconsin | 55023 | 2470 | 23 |
1910760 | 1910760 | 2021-11-12 | Crawford | Wisconsin | 55023 | 2470 | 23 |
1892738 | 1892738 | 2021-11-07 | Renville | Minnesota | 27129 | 2470 | 51 |
1889488 | 1889488 | 2021-11-06 | Renville | Minnesota | 27129 | 2470 | 51 |
1886238 | 1886238 | 2021-11-05 | Renville | Minnesota | 27129 | 2470 | 51 |
1881951 | 1881951 | 2021-11-04 | Jefferson | Florida | 12065 | 2470 | 36 |
1878702 | 1878702 | 2021-11-03 | Jefferson | Florida | 12065 | 2470 | 36 |
1875453 | 1875453 | 2021-11-02 | Jefferson | Florida | 12065 | 2470 | 36 |
1872204 | 1872204 | 2021-11-01 | Jefferson | Florida | 12065 | 2470 | 36 |
1868955 | 1868955 | 2021-10-31 | Jefferson | Florida | 12065 | 2470 | 36 |
1865706 | 1865706 | 2021-10-30 | Jefferson | Florida | 12065 | 2470 | 36 |
1862457 | 1862457 | 2021-10-29 | Jefferson | Florida | 12065 | 2470 | 36 |
1864458 | 1864458 | 2021-10-29 | Corozal | Puerto Rico | 72047 | 2470 | |
1839511 | 1839511 | 2021-10-22 | Madison | Arkansas | 5087 | 2470 | 38 |
1838886 | 1838886 | 2021-10-21 | Madison | Texas | 48313 | 2470 | 43 |
1826375 | 1826375 | 2021-10-18 | Cleburne | Alabama | 1029 | 2470 | 58 |
1823126 | 1823126 | 2021-10-17 | Cleburne | Alabama | 1029 | 2470 | 58 |
1780295 | 1780295 | 2021-10-03 | Colorado | Texas | 48089 | 2470 | 51 |
1764152 | 1764152 | 2021-09-28 | Llano | Texas | 48299 | 2470 | 66 |
1726853 | 1726853 | 2021-09-17 | Garrett | Maryland | 24023 | 2470 | 69 |
1722179 | 1722179 | 2021-09-15 | Scott | Virginia | 51169 | 2470 | 67 |
1709795 | 1709795 | 2021-09-12 | Banks | Georgia | 13011 | 2470 | 51 |
1706548 | 1706548 | 2021-09-11 | Banks | Georgia | 13011 | 2470 | 51 |
1703300 | 1703300 | 2021-09-10 | Banks | Georgia | 13011 | 2470 | 51 |
1696482 | 1696482 | 2021-09-08 | Juneau City and Borough | Alaska | 2110 | 2470 | 3 |
1658922 | 1658922 | 2021-08-27 | Andrew | Missouri | 29003 | 2470 | 23 |
1644564 | 1644564 | 2021-08-23 | Drew | Arkansas | 5043 | 2470 | 51 |
1642250 | 1642250 | 2021-08-22 | Letcher | Kentucky | 21133 | 2470 | 49 |
1639000 | 1639000 | 2021-08-21 | Letcher | Kentucky | 21133 | 2470 | 49 |
1635750 | 1635750 | 2021-08-20 | Letcher | Kentucky | 21133 | 2470 | 49 |
1631875 | 1631875 | 2021-08-19 | Elbert | Georgia | 13105 | 2470 | 74 |
1622282 | 1622282 | 2021-08-16 | Minidoka | Idaho | 16067 | 2470 | 34 |
1589213 | 1589213 | 2021-08-06 | Butler | Alabama | 1013 | 2470 | 72 |
1580109 | 1580109 | 2021-08-03 | Lawrence | Illinois | 17101 | 2470 | 36 |
1582454 | 1582454 | 2021-08-03 | Lee | Virginia | 51105 | 2470 | 48 |
1582676 | 1582676 | 2021-08-03 | Vilas | Wisconsin | 55125 | 2470 | 45 |
1579204 | 1579204 | 2021-08-02 | Lee | Virginia | 51105 | 2470 | 48 |
1517878 | 1517878 | 2021-07-15 | Columbia | Arkansas | 5027 | 2470 | 58 |
1488697 | 1488697 | 2021-07-06 | Ouachita | Arkansas | 5103 | 2470 | 63 |
1485450 | 1485450 | 2021-07-05 | Ouachita | Arkansas | 5103 | 2470 | 63 |
1459768 | 1459768 | 2021-06-27 | Fannin | Georgia | 13111 | 2470 | 73 |
1410043 | 1410043 | 2021-06-11 | Calhoun | Texas | 48057 | 2470 | 25 |
1403042 | 1403042 | 2021-06-09 | Van Wert | Ohio | 39161 | 2470 | 64 |
1399797 | 1399797 | 2021-06-08 | Van Wert | Ohio | 39161 | 2470 | 64 |
1372855 | 1372855 | 2021-05-31 | Richland | Louisiana | 22083 | 2470 | 56 |
1369610 | 1369610 | 2021-05-30 | Richland | Louisiana | 22083 | 2470 | 56 |
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);