ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where cases = 5923 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Indiana 9
- New Hampshire 7
- Arkansas 6
- Georgia 6
- Alabama 5
- Minnesota 5
- Illinois 4
- Colorado 3
- Kansas 3
- North Carolina 3
- Ohio 3
- Texas 3
- Missouri 2
- New York 2
- Pennsylvania 2
- Washington 2
- Arizona 1
- California 1
- Florida 1
- Idaho 1
- Kentucky 1
- Louisiana 1
- Maryland 1
- Michigan 1
- Mississippi 1
- New Jersey 1
- Puerto Rico 1
- South Dakota 1
- Tennessee 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469381 | 2469381 | 2022-05-03 | Las Piedras | Puerto Rico | 72085 | 5923 | |
2373962 | 2373962 | 2022-04-04 | Meeker | Minnesota | 27093 | 5923 | 75 |
2370709 | 2370709 | 2022-04-03 | Meeker | Minnesota | 27093 | 5923 | 75 |
2367456 | 2367456 | 2022-04-02 | Meeker | Minnesota | 27093 | 5923 | 75 |
2364203 | 2364203 | 2022-04-01 | Meeker | Minnesota | 27093 | 5923 | 75 |
2360949 | 2360949 | 2022-03-31 | Meeker | Minnesota | 27093 | 5923 | 75 |
2330472 | 2330472 | 2022-03-22 | Sevier | Arkansas | 5133 | 5923 | 72 |
2327220 | 2327220 | 2022-03-21 | Sevier | Arkansas | 5133 | 5923 | 72 |
2323967 | 2323967 | 2022-03-20 | Sevier | Arkansas | 5133 | 5923 | 72 |
2281770 | 2281770 | 2022-03-07 | Delta | Colorado | 8029 | 5923 | 130 |
2239525 | 2239525 | 2022-02-22 | Montezuma | Colorado | 8083 | 5923 | 66 |
2236131 | 2236131 | 2022-02-21 | Jackson | Arkansas | 5067 | 5923 | 53 |
2199713 | 2199713 | 2022-02-09 | Jasper | Texas | 48241 | 5923 | 172 |
2134039 | 2134039 | 2022-01-20 | Van Wert | Ohio | 39161 | 5923 | 121 |
2122868 | 2122868 | 2022-01-17 | Greene | Indiana | 18055 | 5923 | 116 |
2102672 | 2102672 | 2022-01-11 | Marion | Alabama | 1093 | 5923 | 132 |
2075341 | 2075341 | 2022-01-02 | Person | North Carolina | 37145 | 5923 | 94 |
2072090 | 2072090 | 2022-01-01 | Person | North Carolina | 37145 | 5923 | 94 |
2068839 | 2068839 | 2021-12-31 | Person | North Carolina | 37145 | 5923 | 94 |
2033977 | 2033977 | 2021-12-20 | Washington | Texas | 48477 | 5923 | 135 |
2028821 | 2028821 | 2021-12-19 | Montgomery | Kansas | 20125 | 5923 | 123 |
2025570 | 2025570 | 2021-12-18 | Montgomery | Kansas | 20125 | 5923 | 123 |
2022319 | 2022319 | 2021-12-17 | Montgomery | Kansas | 20125 | 5923 | 123 |
1997210 | 1997210 | 2021-12-09 | Chenango | New York | 36017 | 5923 | 98 |
1973744 | 1973744 | 2021-12-02 | Evangeline | Louisiana | 22039 | 5923 | 142 |
1884959 | 1884959 | 2021-11-05 | Baxter | Arkansas | 5005 | 5923 | 181 |
1872266 | 1872266 | 2021-11-01 | Chattahoochee | Georgia | 13053 | 5923 | 19 |
1869017 | 1869017 | 2021-10-31 | Chattahoochee | Georgia | 13053 | 5923 | 19 |
1870387 | 1870387 | 2021-10-31 | Grafton | New Hampshire | 33009 | 5923 | 30 |
1865768 | 1865768 | 2021-10-30 | Chattahoochee | Georgia | 13053 | 5923 | 19 |
1867138 | 1867138 | 2021-10-30 | Grafton | New Hampshire | 33009 | 5923 | 30 |
1862519 | 1862519 | 2021-10-29 | Chattahoochee | Georgia | 13053 | 5923 | 19 |
1863889 | 1863889 | 2021-10-29 | Grafton | New Hampshire | 33009 | 5923 | 30 |
1860640 | 1860640 | 2021-10-28 | Grafton | New Hampshire | 33009 | 5923 | 30 |
1857391 | 1857391 | 2021-10-27 | Grafton | New Hampshire | 33009 | 5923 | 30 |
1853046 | 1853046 | 2021-10-26 | Stephenson | Illinois | 17177 | 5923 | 113 |
1854142 | 1854142 | 2021-10-26 | Grafton | New Hampshire | 33009 | 5923 | 30 |
1850893 | 1850893 | 2021-10-25 | Grafton | New Hampshire | 33009 | 5923 | 30 |
1840939 | 1840939 | 2021-10-22 | Platte | Missouri | 29165 | 5923 | 61 |
1810709 | 1810709 | 2021-10-13 | Nez Perce | Idaho | 16069 | 5923 | 92 |
1773908 | 1773908 | 2021-10-01 | Matagorda | Texas | 48321 | 5923 | 145 |
1732877 | 1732877 | 2021-09-19 | Huntington | Indiana | 18069 | 5923 | 93 |
1729627 | 1729627 | 2021-09-18 | Huntington | Indiana | 18069 | 5923 | 93 |
1726377 | 1726377 | 2021-09-17 | Huntington | Indiana | 18069 | 5923 | 93 |
1719343 | 1719343 | 2021-09-15 | Lake | California | 6033 | 5923 | 83 |
1701789 | 1701789 | 2021-09-09 | Seneca | Ohio | 39147 | 5923 | 135 |
1702122 | 1702122 | 2021-09-09 | Brown | South Dakota | 46013 | 5923 | 95 |
1696416 | 1696416 | 2021-09-08 | Chilton | Alabama | 1021 | 5923 | 123 |
1696467 | 1696467 | 2021-09-08 | Tallapoosa | Alabama | 1123 | 5923 | 163 |
1674668 | 1674668 | 2021-09-01 | Barren | Kentucky | 21009 | 5923 | 109 |
1624591 | 1624591 | 2021-08-16 | Summit | Utah | 49043 | 5923 | 15 |
1559004 | 1559004 | 2021-07-27 | Columbia | Pennsylvania | 42037 | 5923 | 136 |
1489272 | 1489272 | 2021-07-06 | Henry | Indiana | 18065 | 5923 | 113 |
1486008 | 1486008 | 2021-07-05 | Dearborn | Indiana | 18029 | 5923 | 81 |
1482762 | 1482762 | 2021-07-04 | Dearborn | Indiana | 18029 | 5923 | 81 |
1479515 | 1479515 | 2021-07-03 | Dearborn | Indiana | 18029 | 5923 | 81 |
1476269 | 1476269 | 2021-07-02 | Dearborn | Indiana | 18029 | 5923 | 81 |
1469215 | 1469215 | 2021-06-30 | Mississippi | Arkansas | 5093 | 5923 | 110 |
1395704 | 1395704 | 2021-06-07 | Marquette | Michigan | 26103 | 5923 | 63 |
1394250 | 1394250 | 2021-06-06 | Skagit | Washington | 53057 | 5923 | 74 |
1391005 | 1391005 | 2021-06-05 | Skagit | Washington | 53057 | 5923 | 74 |
1339860 | 1339860 | 2021-05-21 | Grundy | Illinois | 17063 | 5923 | 80 |
1170892 | 1170892 | 2021-03-30 | Spalding | Georgia | 13255 | 5923 | 179 |
1172268 | 1172268 | 2021-03-30 | St. Lawrence | New York | 36089 | 5923 | 94 |
1168579 | 1168579 | 2021-03-29 | Lafayette | Mississippi | 28071 | 5923 | 116 |
1073582 | 1073582 | 2021-02-28 | Boone | Illinois | 17007 | 5923 | 83 |
1047710 | 1047710 | 2021-02-20 | Whiteside | Illinois | 17195 | 5923 | 187 |
998866 | 998866 | 2021-02-05 | Walker | Georgia | 13295 | 5923 | 72 |
916556 | 916556 | 2021-01-10 | Tipton | Tennessee | 47167 | 5923 | 60 |
876213 | 876213 | 2020-12-29 | Charles | Maryland | 24017 | 5923 | 120 |
842593 | 842593 | 2020-12-19 | Limestone | Alabama | 1083 | 5923 | 52 |
816913 | 816913 | 2020-12-11 | Charlotte | Florida | 12015 | 5923 | 208 |
781173 | 781173 | 2020-11-30 | Mesa | Colorado | 8077 | 5923 | 59 |
766183 | 766183 | 2020-11-25 | Cole | Missouri | 29051 | 5923 | 49 |
721369 | 721369 | 2020-11-11 | Warren | Ohio | 39165 | 5923 | 72 |
625256 | 625256 | 2020-10-13 | Navajo | Arizona | 4017 | 5923 | 236 |
566858 | 566858 | 2020-09-25 | Shelby | Alabama | 1117 | 5923 | 49 |
417175 | 417175 | 2020-08-09 | Lancaster | Pennsylvania | 42071 | 5923 | 411 |
167997 | 167997 | 2020-05-22 | Camden | New Jersey | 34007 | 5923 | 299 |
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);