ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
310 rows where cases = 2001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 26
- Texas 24
- Iowa 22
- Oklahoma 17
- Tennessee 17
- Illinois 14
- Mississippi 13
- North Carolina 13
- Wisconsin 13
- Arkansas 12
- Georgia 11
- Indiana 11
- Puerto Rico 10
- Kentucky 9
- Idaho 8
- Louisiana 8
- Michigan 8
- Colorado 7
- Minnesota 6
- Montana 5
- New York 5
- Oregon 5
- West Virginia 5
- Alabama 4
- Ohio 4
- Pennsylvania 4
- Kansas 3
- Maryland 3
- Nevada 3
- New Mexico 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502718 | 2502718 | 2022-05-13 | Pendleton | West Virginia | 54071 | 2001 | 22 |
2502784 | 2502784 | 2022-05-13 | Pepin | Wisconsin | 55091 | 2001 | 18 |
2450436 | 2450436 | 2022-04-27 | Fairfax city | Virginia | 51600 | 2001 | 43 |
2427623 | 2427623 | 2022-04-20 | Buena Vista city | Virginia | 51530 | 2001 | 43 |
2423255 | 2423255 | 2022-04-19 | Quay | New Mexico | 35037 | 2001 | 51 |
2424367 | 2424367 | 2022-04-19 | Buena Vista city | Virginia | 51530 | 2001 | 43 |
2421111 | 2421111 | 2022-04-18 | Buena Vista city | Virginia | 51530 | 2001 | 43 |
2417855 | 2417855 | 2022-04-17 | Buena Vista city | Virginia | 51530 | 2001 | 43 |
2414599 | 2414599 | 2022-04-16 | Buena Vista city | Virginia | 51530 | 2001 | 43 |
2411343 | 2411343 | 2022-04-15 | Buena Vista city | Virginia | 51530 | 2001 | 43 |
2408087 | 2408087 | 2022-04-14 | Buena Vista city | Virginia | 51530 | 2001 | 43 |
2404831 | 2404831 | 2022-04-13 | Buena Vista city | Virginia | 51530 | 2001 | 43 |
2401576 | 2401576 | 2022-04-12 | Buena Vista city | Virginia | 51530 | 2001 | 43 |
2359664 | 2359664 | 2022-03-31 | Southeast Fairbanks Census Area | Alaska | 2240 | 2001 | 20 |
2356410 | 2356410 | 2022-03-30 | Southeast Fairbanks Census Area | Alaska | 2240 | 2001 | 20 |
2356016 | 2356016 | 2022-03-29 | Buena Vista city | Virginia | 51530 | 2001 | 42 |
2349511 | 2349511 | 2022-03-27 | Buena Vista city | Virginia | 51530 | 2001 | 42 |
2346258 | 2346258 | 2022-03-26 | Buena Vista city | Virginia | 51530 | 2001 | 42 |
2343005 | 2343005 | 2022-03-25 | Buena Vista city | Virginia | 51530 | 2001 | 42 |
2332862 | 2332862 | 2022-03-22 | Hancock | Tennessee | 47067 | 2001 | 34 |
2329609 | 2329609 | 2022-03-21 | Hancock | Tennessee | 47067 | 2001 | 34 |
2326357 | 2326357 | 2022-03-20 | Hancock | Tennessee | 47067 | 2001 | 34 |
2323104 | 2323104 | 2022-03-19 | Hancock | Tennessee | 47067 | 2001 | 34 |
2319850 | 2319850 | 2022-03-18 | Hancock | Tennessee | 47067 | 2001 | 34 |
2316596 | 2316596 | 2022-03-17 | Hancock | Tennessee | 47067 | 2001 | 34 |
2313143 | 2313143 | 2022-03-16 | Guayanilla | Puerto Rico | 72059 | 2001 | |
2313343 | 2313343 | 2022-03-16 | Hancock | Tennessee | 47067 | 2001 | 34 |
2308071 | 2308071 | 2022-03-15 | Wilcox | Georgia | 13315 | 2001 | 69 |
2270116 | 2270116 | 2022-03-03 | Blaine | Montana | 30005 | 2001 | 31 |
2236555 | 2236555 | 2022-02-21 | Boundary | Idaho | 16021 | 2001 | 56 |
2233304 | 2233304 | 2022-02-20 | Boundary | Idaho | 16021 | 2001 | 56 |
2230053 | 2230053 | 2022-02-19 | Boundary | Idaho | 16021 | 2001 | 56 |
2217923 | 2217923 | 2022-02-15 | Humphreys | Mississippi | 28053 | 2001 | 43 |
2196083 | 2196083 | 2022-02-08 | Jayuya | Puerto Rico | 72073 | 2001 | |
2192829 | 2192829 | 2022-02-07 | Jayuya | Puerto Rico | 72073 | 2001 | |
2178789 | 2178789 | 2022-02-03 | Clearwater | Minnesota | 27029 | 2001 | 29 |
2179105 | 2179105 | 2022-02-03 | Rosebud | Montana | 30087 | 2001 | 58 |
2149585 | 2149585 | 2022-01-25 | Benton | Mississippi | 28009 | 2001 | 43 |
2145377 | 2145377 | 2022-01-24 | Heard | Georgia | 13149 | 2001 | 43 |
2131893 | 2131893 | 2022-01-19 | Washakie | Wyoming | 56043 | 2001 | 41 |
2103906 | 2103906 | 2022-01-11 | Iron | Michigan | 26071 | 2001 | 73 |
2100655 | 2100655 | 2022-01-10 | Iron | Michigan | 26071 | 2001 | 73 |
2099079 | 2099079 | 2022-01-09 | Clarke | Virginia | 51043 | 2001 | 33 |
2095828 | 2095828 | 2022-01-08 | Clarke | Virginia | 51043 | 2001 | 33 |
2092576 | 2092576 | 2022-01-07 | Clarke | Virginia | 51043 | 2001 | 33 |
2059313 | 2059313 | 2021-12-28 | Noble | Oklahoma | 40103 | 2001 | 33 |
2056064 | 2056064 | 2021-12-27 | Noble | Oklahoma | 40103 | 2001 | 33 |
2052815 | 2052815 | 2021-12-26 | Noble | Oklahoma | 40103 | 2001 | 33 |
2047497 | 2047497 | 2021-12-25 | Fulton | Arkansas | 5049 | 2001 | 76 |
2049565 | 2049565 | 2021-12-25 | Noble | Oklahoma | 40103 | 2001 | 33 |
2046315 | 2046315 | 2021-12-24 | Noble | Oklahoma | 40103 | 2001 | 33 |
2043065 | 2043065 | 2021-12-23 | Noble | Oklahoma | 40103 | 2001 | 33 |
2039816 | 2039816 | 2021-12-22 | Noble | Oklahoma | 40103 | 2001 | 33 |
2031361 | 2031361 | 2021-12-20 | Archuleta | Colorado | 8007 | 2001 | 9 |
2026956 | 2026956 | 2021-12-18 | Cabo Rojo | Puerto Rico | 72023 | 2001 | |
1994795 | 1994795 | 2021-12-08 | Duval | Texas | 48131 | 2001 | 60 |
1989661 | 1989661 | 2021-12-07 | Calhoun | Iowa | 19025 | 2001 | 19 |
1986411 | 1986411 | 2021-12-06 | Calhoun | Iowa | 19025 | 2001 | 19 |
1986834 | 1986834 | 2021-12-06 | Dukes | Massachusetts | 25007 | 2001 | 0 |
1983161 | 1983161 | 2021-12-05 | Calhoun | Iowa | 19025 | 2001 | 19 |
1979911 | 1979911 | 2021-12-04 | Calhoun | Iowa | 19025 | 2001 | 19 |
1976661 | 1976661 | 2021-12-03 | Calhoun | Iowa | 19025 | 2001 | 19 |
1973412 | 1973412 | 2021-12-02 | Calhoun | Iowa | 19025 | 2001 | 19 |
1974986 | 1974986 | 2021-12-02 | Morovis | Puerto Rico | 72101 | 2001 | |
1970162 | 1970162 | 2021-12-01 | Calhoun | Iowa | 19025 | 2001 | 19 |
1938836 | 1938836 | 2021-11-21 | Swain | North Carolina | 37173 | 2001 | 28 |
1935586 | 1935586 | 2021-11-20 | Swain | North Carolina | 37173 | 2001 | 28 |
1932336 | 1932336 | 2021-11-19 | Swain | North Carolina | 37173 | 2001 | 28 |
1914375 | 1914375 | 2021-11-14 | Las Animas | Colorado | 8071 | 2001 | 24 |
1911125 | 1911125 | 2021-11-13 | Las Animas | Colorado | 8071 | 2001 | 24 |
1907876 | 1907876 | 2021-11-12 | Las Animas | Colorado | 8071 | 2001 | 24 |
1900040 | 1900040 | 2021-11-09 | Love | Oklahoma | 40085 | 2001 | 29 |
1896790 | 1896790 | 2021-11-08 | Love | Oklahoma | 40085 | 2001 | 29 |
1896914 | 1896914 | 2021-11-08 | Potter | Pennsylvania | 42105 | 2001 | 49 |
1893540 | 1893540 | 2021-11-07 | Love | Oklahoma | 40085 | 2001 | 29 |
1890290 | 1890290 | 2021-11-06 | Love | Oklahoma | 40085 | 2001 | 29 |
1887040 | 1887040 | 2021-11-05 | Love | Oklahoma | 40085 | 2001 | 29 |
1883790 | 1883790 | 2021-11-04 | Love | Oklahoma | 40085 | 2001 | 29 |
1880541 | 1880541 | 2021-11-03 | Love | Oklahoma | 40085 | 2001 | 29 |
1846871 | 1846871 | 2021-10-24 | Breathitt | Kentucky | 21025 | 2001 | 29 |
1843621 | 1843621 | 2021-10-23 | Breathitt | Kentucky | 21025 | 2001 | 29 |
1840371 | 1840371 | 2021-10-22 | Breathitt | Kentucky | 21025 | 2001 | 29 |
1809444 | 1809444 | 2021-10-12 | Lake | Tennessee | 47095 | 2001 | 31 |
1793989 | 1793989 | 2021-10-08 | Chicot | Arkansas | 5017 | 2001 | 44 |
1793656 | 1793656 | 2021-10-07 | Rockbridge | Virginia | 51163 | 2001 | 54 |
1787310 | 1787310 | 2021-10-05 | Lafayette | Wisconsin | 55065 | 2001 | 12 |
1773167 | 1773167 | 2021-10-01 | Ramsey | North Dakota | 38071 | 2001 | 33 |
1762235 | 1762235 | 2021-09-28 | Madison | Iowa | 19121 | 2001 | 20 |
1758987 | 1758987 | 2021-09-27 | Madison | Iowa | 19121 | 2001 | 20 |
1755544 | 1755544 | 2021-09-26 | Massac | Illinois | 17127 | 2001 | 47 |
1755739 | 1755739 | 2021-09-26 | Madison | Iowa | 19121 | 2001 | 20 |
1752296 | 1752296 | 2021-09-25 | Massac | Illinois | 17127 | 2001 | 47 |
1752491 | 1752491 | 2021-09-25 | Madison | Iowa | 19121 | 2001 | 20 |
1749047 | 1749047 | 2021-09-24 | Massac | Illinois | 17127 | 2001 | 47 |
1749242 | 1749242 | 2021-09-24 | Madison | Iowa | 19121 | 2001 | 20 |
1745796 | 1745796 | 2021-09-23 | Mason | Illinois | 17125 | 2001 | 52 |
1745992 | 1745992 | 2021-09-23 | Madison | Iowa | 19121 | 2001 | 20 |
1742743 | 1742743 | 2021-09-22 | Madison | Iowa | 19121 | 2001 | 20 |
1738398 | 1738398 | 2021-09-20 | New Kent | Virginia | 51127 | 2001 | 20 |
1728309 | 1728309 | 2021-09-17 | Comanche | Texas | 48093 | 2001 | 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);