ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
253 rows where cases = 1996 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 24
- Georgia 17
- Kentucky 15
- Florida 11
- Virginia 11
- West Virginia 11
- Arkansas 10
- Montana 9
- Puerto Rico 9
- Texas 9
- Wisconsin 9
- Illinois 8
- Minnesota 8
- Missouri 8
- Pennsylvania 7
- Louisiana 6
- Mississippi 6
- North Carolina 6
- Colorado 5
- Michigan 5
- New York 5
- Ohio 5
- Indiana 4
- New Mexico 4
- Oklahoma 4
- Wyoming 4
- Alabama 3
- Idaho 3
- Kansas 3
- Nebraska 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501619 | 2501619 | 2022-05-13 | Pembina | North Dakota | 38067 | 1996 | 16 |
2496268 | 2496268 | 2022-05-11 | Pepin | Wisconsin | 55091 | 1996 | 18 |
2490324 | 2490324 | 2022-05-10 | Taylor | Georgia | 13269 | 1996 | 54 |
2487067 | 2487067 | 2022-05-09 | Taylor | Georgia | 13269 | 1996 | 54 |
2483809 | 2483809 | 2022-05-08 | Taylor | Georgia | 13269 | 1996 | 54 |
2480551 | 2480551 | 2022-05-07 | Taylor | Georgia | 13269 | 1996 | 54 |
2477293 | 2477293 | 2022-05-06 | Taylor | Georgia | 13269 | 1996 | 54 |
2474035 | 2474035 | 2022-05-05 | Taylor | Georgia | 13269 | 1996 | 54 |
2470778 | 2470778 | 2022-05-04 | Taylor | Georgia | 13269 | 1996 | 54 |
2380932 | 2380932 | 2022-04-06 | Quay | New Mexico | 35037 | 1996 | 50 |
2382066 | 2382066 | 2022-04-06 | Falls Church city | Virginia | 51610 | 1996 | 16 |
2377677 | 2377677 | 2022-04-05 | Quay | New Mexico | 35037 | 1996 | 50 |
2374424 | 2374424 | 2022-04-04 | Quay | New Mexico | 35037 | 1996 | 50 |
2293630 | 2293630 | 2022-03-10 | Guayanilla | Puerto Rico | 72059 | 1996 | |
2284648 | 2284648 | 2022-03-07 | Pocahontas | West Virginia | 54075 | 1996 | 27 |
2278804 | 2278804 | 2022-03-06 | Wilcox | Georgia | 13315 | 1996 | 68 |
2275551 | 2275551 | 2022-03-05 | Wilcox | Georgia | 13315 | 1996 | 68 |
2272298 | 2272298 | 2022-03-04 | Wilcox | Georgia | 13315 | 1996 | 68 |
2269046 | 2269046 | 2022-03-03 | Wilcox | Georgia | 13315 | 1996 | 68 |
2240603 | 2240603 | 2022-02-22 | Lake | Minnesota | 27075 | 1996 | 28 |
2236480 | 2236480 | 2022-02-21 | Montgomery | Georgia | 13209 | 1996 | 49 |
2179868 | 2179868 | 2022-02-03 | Allendale | South Carolina | 45005 | 1996 | 23 |
2170839 | 2170839 | 2022-01-31 | Tyler | West Virginia | 54095 | 1996 | 27 |
2166093 | 2166093 | 2022-01-30 | Sanders | Montana | 30089 | 1996 | 42 |
2162838 | 2162838 | 2022-01-29 | Sanders | Montana | 30089 | 1996 | 42 |
2159583 | 2159583 | 2022-01-28 | Sanders | Montana | 30089 | 1996 | 42 |
2155304 | 2155304 | 2022-01-27 | Hamilton | Illinois | 17065 | 1996 | 29 |
2157004 | 2157004 | 2022-01-27 | Adjuntas | Puerto Rico | 72001 | 1996 | |
2130267 | 2130267 | 2022-01-19 | Dawson | Montana | 30021 | 1996 | 53 |
2106128 | 2106128 | 2022-01-12 | Bent | Colorado | 8011 | 1996 | 44 |
2100962 | 2100962 | 2022-01-10 | Ralls | Missouri | 29173 | 1996 | 19 |
2101012 | 2101012 | 2022-01-10 | Jefferson | Montana | 30043 | 1996 | 22 |
2086061 | 2086061 | 2022-01-05 | Brunswick | Virginia | 51025 | 1996 | 36 |
2081900 | 2081900 | 2022-01-04 | Mercer | North Dakota | 38057 | 1996 | 22 |
2074726 | 2074726 | 2022-01-02 | Koochiching | Minnesota | 27071 | 1996 | 29 |
2071475 | 2071475 | 2022-01-01 | Koochiching | Minnesota | 27071 | 1996 | 29 |
2068224 | 2068224 | 2021-12-31 | Koochiching | Minnesota | 27071 | 1996 | 29 |
2064973 | 2064973 | 2021-12-30 | Koochiching | Minnesota | 27071 | 1996 | 29 |
2053755 | 2053755 | 2021-12-26 | Roane | West Virginia | 54087 | 1996 | 27 |
2050505 | 2050505 | 2021-12-25 | Roane | West Virginia | 54087 | 1996 | 27 |
2047255 | 2047255 | 2021-12-24 | Roane | West Virginia | 54087 | 1996 | 27 |
2044005 | 2044005 | 2021-12-23 | Roane | West Virginia | 54087 | 1996 | 27 |
2028110 | 2028110 | 2021-12-19 | Archuleta | Colorado | 8007 | 1996 | 8 |
2024859 | 2024859 | 2021-12-18 | Archuleta | Colorado | 8007 | 1996 | 8 |
2021608 | 2021608 | 2021-12-17 | Archuleta | Colorado | 8007 | 1996 | 8 |
1997609 | 1997609 | 2021-12-09 | Morrow | Oregon | 41049 | 1996 | 25 |
1975657 | 1975657 | 2021-12-02 | Westmoreland | Virginia | 51193 | 1996 | 38 |
1948980 | 1948980 | 2021-11-24 | Morovis | Puerto Rico | 72101 | 1996 | |
1944418 | 1944418 | 2021-11-23 | Lyon | Kentucky | 21143 | 1996 | 26 |
1944633 | 1944633 | 2021-11-23 | Leelanau | Michigan | 26089 | 1996 | 30 |
1945729 | 1945729 | 2021-11-23 | Morovis | Puerto Rico | 72101 | 1996 | |
1941382 | 1941382 | 2021-11-22 | Leelanau | Michigan | 26089 | 1996 | 30 |
1942478 | 1942478 | 2021-11-22 | Morovis | Puerto Rico | 72101 | 1996 | |
1939228 | 1939228 | 2021-11-21 | Morovis | Puerto Rico | 72101 | 1996 | |
1935978 | 1935978 | 2021-11-20 | Morovis | Puerto Rico | 72101 | 1996 | |
1925433 | 1925433 | 2021-11-17 | Ripley | Missouri | 29181 | 1996 | 25 |
1898660 | 1898660 | 2021-11-09 | Cherokee | Iowa | 19035 | 1996 | 45 |
1895410 | 1895410 | 2021-11-08 | Cherokee | Iowa | 19035 | 1996 | 45 |
1892160 | 1892160 | 2021-11-07 | Cherokee | Iowa | 19035 | 1996 | 45 |
1888910 | 1888910 | 2021-11-06 | Cherokee | Iowa | 19035 | 1996 | 45 |
1885660 | 1885660 | 2021-11-05 | Cherokee | Iowa | 19035 | 1996 | 45 |
1882411 | 1882411 | 2021-11-04 | Cherokee | Iowa | 19035 | 1996 | 45 |
1879162 | 1879162 | 2021-11-03 | Cherokee | Iowa | 19035 | 1996 | 45 |
1870258 | 1870258 | 2021-10-31 | Roosevelt | Montana | 30085 | 1996 | 59 |
1867009 | 1867009 | 2021-10-30 | Roosevelt | Montana | 30085 | 1996 | 59 |
1863760 | 1863760 | 2021-10-29 | Roosevelt | Montana | 30085 | 1996 | 59 |
1849084 | 1849084 | 2021-10-24 | Big Horn | Wyoming | 56003 | 1996 | 50 |
1845834 | 1845834 | 2021-10-23 | Big Horn | Wyoming | 56003 | 1996 | 50 |
1842584 | 1842584 | 2021-10-22 | Big Horn | Wyoming | 56003 | 1996 | 50 |
1837122 | 1837122 | 2021-10-21 | Breathitt | Kentucky | 21025 | 1996 | 28 |
1816765 | 1816765 | 2021-10-15 | Little River | Arkansas | 5081 | 1996 | 71 |
1814501 | 1814501 | 2021-10-14 | Claiborne | Louisiana | 22027 | 1996 | 63 |
1811252 | 1811252 | 2021-10-13 | Claiborne | Louisiana | 22027 | 1996 | 62 |
1793851 | 1793851 | 2021-10-07 | Converse | Wyoming | 56009 | 1996 | 30 |
1784019 | 1784019 | 2021-10-04 | Taylor | West Virginia | 54091 | 1996 | 34 |
1776493 | 1776493 | 2021-10-02 | Monroe | Ohio | 39111 | 1996 | 50 |
1768912 | 1768912 | 2021-09-30 | Fleming | Kentucky | 21069 | 1996 | 29 |
1766045 | 1766045 | 2021-09-29 | Amite | Mississippi | 28005 | 1996 | 52 |
1755910 | 1755910 | 2021-09-26 | Clinton | Kentucky | 21053 | 1996 | 33 |
1752662 | 1752662 | 2021-09-25 | Clinton | Kentucky | 21053 | 1996 | 33 |
1735570 | 1735570 | 2021-09-20 | Van Buren | Arkansas | 5141 | 1996 | 36 |
1736779 | 1736779 | 2021-09-20 | Redwood | Minnesota | 27127 | 1996 | 42 |
1720706 | 1720706 | 2021-09-15 | Mississippi | Missouri | 29133 | 1996 | 33 |
1710043 | 1710043 | 2021-09-12 | Jo Daviess | Illinois | 17085 | 1996 | 27 |
1706796 | 1706796 | 2021-09-11 | Jo Daviess | Illinois | 17085 | 1996 | 27 |
1703548 | 1703548 | 2021-09-10 | Jo Daviess | Illinois | 17085 | 1996 | 27 |
1689651 | 1689651 | 2021-09-05 | King George | Virginia | 51099 | 1996 | 21 |
1686401 | 1686401 | 2021-09-04 | King George | Virginia | 51099 | 1996 | 21 |
1683150 | 1683150 | 2021-09-03 | King George | Virginia | 51099 | 1996 | 21 |
1659781 | 1659781 | 2021-08-27 | Fajardo | Puerto Rico | 72053 | 1996 | |
1616722 | 1616722 | 2021-08-14 | Dallas | Missouri | 29059 | 1996 | 37 |
1611596 | 1611596 | 2021-08-12 | San Juan | Utah | 49037 | 1996 | 37 |
1606063 | 1606063 | 2021-08-11 | Clark | Illinois | 17023 | 1996 | 42 |
1606797 | 1606797 | 2021-08-11 | Dodge | Minnesota | 27039 | 1996 | 3 |
1603306 | 1603306 | 2021-08-10 | Russell | Kentucky | 21207 | 1996 | 48 |
1600057 | 1600057 | 2021-08-09 | Russell | Kentucky | 21207 | 1996 | 48 |
1582850 | 1582850 | 2021-08-04 | Izard | Arkansas | 5065 | 1996 | 46 |
1533890 | 1533890 | 2021-07-19 | Upshur | West Virginia | 54097 | 1996 | 34 |
1529567 | 1529567 | 2021-07-18 | Carroll | Ohio | 39019 | 1996 | 49 |
1526320 | 1526320 | 2021-07-17 | Carroll | Ohio | 39019 | 1996 | 49 |
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);