ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where cases = 5628 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Oklahoma 10
- Missouri 6
- Georgia 5
- Illinois 5
- Kansas 5
- Alaska 4
- Ohio 4
- Puerto Rico 4
- Texas 4
- Virginia 4
- West Virginia 4
- Wisconsin 4
- Colorado 3
- Tennessee 3
- Washington 3
- California 2
- Florida 2
- Mississippi 2
- New York 2
- North Carolina 2
- South Dakota 2
- Utah 2
- Wyoming 2
- Arkansas 1
- Indiana 1
- Kentucky 1
- Maryland 1
- Minnesota 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2453852 | 2453852 | 2022-04-28 | McDowell | West Virginia | 54047 | 5628 | 75 |
2450596 | 2450596 | 2022-04-27 | McDowell | West Virginia | 54047 | 5628 | 75 |
2392404 | 2392404 | 2022-04-10 | Morgan | Colorado | 8087 | 5628 | 135 |
2389148 | 2389148 | 2022-04-09 | Morgan | Colorado | 8087 | 5628 | 135 |
2385893 | 2385893 | 2022-04-08 | Morgan | Colorado | 8087 | 5628 | 135 |
2339560 | 2339560 | 2022-03-24 | Karnes | Texas | 48255 | 5628 | 68 |
2294514 | 2294514 | 2022-03-10 | Uinta | Wyoming | 56041 | 5628 | 37 |
2291196 | 2291196 | 2022-03-09 | Jackson | Wisconsin | 55053 | 5628 | 41 |
2291262 | 2291262 | 2022-03-09 | Uinta | Wyoming | 56041 | 5628 | 37 |
2287944 | 2287944 | 2022-03-08 | Jackson | Wisconsin | 55053 | 5628 | 41 |
2267631 | 2267631 | 2022-03-02 | Moca | Puerto Rico | 72099 | 5628 | |
2210433 | 2210433 | 2022-02-13 | Grady | Georgia | 13131 | 5628 | 103 |
2207180 | 2207180 | 2022-02-12 | Grady | Georgia | 13131 | 5628 | 103 |
2203927 | 2203927 | 2022-02-11 | Grady | Georgia | 13131 | 5628 | 103 |
2144059 | 2144059 | 2022-01-23 | San Sebastian | Puerto Rico | 72131 | 5628 | |
2110055 | 2110055 | 2022-01-13 | Franklin | Kansas | 20059 | 5628 | 67 |
2106804 | 2106804 | 2022-01-12 | Franklin | Kansas | 20059 | 5628 | 67 |
2090842 | 2090842 | 2022-01-07 | Queen Anne's | Maryland | 24035 | 5628 | 86 |
2052165 | 2052165 | 2021-12-26 | Lafayette | Missouri | 29107 | 5628 | 91 |
2052836 | 2052836 | 2021-12-26 | Unknown | Oklahoma | 5628 | 2 | |
2048915 | 2048915 | 2021-12-25 | Lafayette | Missouri | 29107 | 5628 | 91 |
2049586 | 2049586 | 2021-12-25 | Unknown | Oklahoma | 5628 | 2 | |
2045665 | 2045665 | 2021-12-24 | Lafayette | Missouri | 29107 | 5628 | 91 |
2046336 | 2046336 | 2021-12-24 | Unknown | Oklahoma | 5628 | 2 | |
2042415 | 2042415 | 2021-12-23 | Lafayette | Missouri | 29107 | 5628 | 91 |
2042983 | 2042983 | 2021-12-23 | Morrow | Ohio | 39117 | 5628 | 69 |
2020088 | 2020088 | 2021-12-16 | Person | North Carolina | 37145 | 5628 | 91 |
2012263 | 2012263 | 2021-12-14 | Logan | Illinois | 17107 | 5628 | 90 |
1997924 | 1997924 | 2021-12-09 | Henry | Tennessee | 47079 | 5628 | 96 |
1998306 | 1998306 | 2021-12-09 | Charlottesville city | Virginia | 51540 | 5628 | 62 |
1994008 | 1994008 | 2021-12-08 | Wyoming | New York | 36121 | 5628 | 71 |
1994673 | 1994673 | 2021-12-08 | Henry | Tennessee | 47079 | 5628 | 96 |
1974457 | 1974457 | 2021-12-02 | Chenango | New York | 36017 | 5628 | 97 |
1963863 | 1963863 | 2021-11-29 | Boyle | Kentucky | 21021 | 5628 | 94 |
1869515 | 1869515 | 2021-10-31 | Cowley | Kansas | 20035 | 5628 | 127 |
1866266 | 1866266 | 2021-10-30 | Cowley | Kansas | 20035 | 5628 | 127 |
1863017 | 1863017 | 2021-10-29 | Cowley | Kansas | 20035 | 5628 | 127 |
1858753 | 1858753 | 2021-10-27 | Wayne | West Virginia | 54099 | 5628 | 78 |
1854745 | 1854745 | 2021-10-26 | Ponce | Puerto Rico | 72113 | 5628 | |
1851496 | 1851496 | 2021-10-25 | Ponce | Puerto Rico | 72113 | 5628 | |
1826431 | 1826431 | 2021-10-18 | Bethel Census Area | Alaska | 2050 | 5628 | 25 |
1823182 | 1823182 | 2021-10-17 | Bethel Census Area | Alaska | 2050 | 5628 | 25 |
1819933 | 1819933 | 2021-10-16 | Bethel Census Area | Alaska | 2050 | 5628 | 25 |
1816684 | 1816684 | 2021-10-15 | Bethel Census Area | Alaska | 2050 | 5628 | 25 |
1815353 | 1815353 | 2021-10-14 | Scotland | North Carolina | 37165 | 5628 | 106 |
1803231 | 1803231 | 2021-10-10 | Washington | Texas | 48477 | 5628 | 122 |
1799982 | 1799982 | 2021-10-09 | Washington | Texas | 48477 | 5628 | 122 |
1779713 | 1779713 | 2021-10-03 | Fulton | Ohio | 39051 | 5628 | 87 |
1745087 | 1745087 | 2021-09-22 | Pierce | Wisconsin | 55093 | 5628 | 44 |
1727774 | 1727774 | 2021-09-17 | Shelby | Ohio | 39149 | 5628 | 101 |
1723043 | 1723043 | 2021-09-16 | Livingston | Illinois | 17105 | 5628 | 106 |
1710025 | 1710025 | 2021-09-12 | Effingham | Illinois | 17049 | 5628 | 91 |
1706778 | 1706778 | 2021-09-11 | Effingham | Illinois | 17049 | 5628 | 91 |
1703530 | 1703530 | 2021-09-10 | Effingham | Illinois | 17049 | 5628 | 91 |
1684988 | 1684988 | 2021-09-04 | Phelps | Missouri | 29161 | 5628 | 165 |
1675130 | 1675130 | 2021-09-01 | Panola | Mississippi | 28107 | 5628 | 115 |
1666992 | 1666992 | 2021-08-29 | Grays Harbor | Washington | 53027 | 5628 | 87 |
1663744 | 1663744 | 2021-08-28 | Grays Harbor | Washington | 53027 | 5628 | 87 |
1660496 | 1660496 | 2021-08-27 | Grays Harbor | Washington | 53027 | 5628 | 87 |
1611837 | 1611837 | 2021-08-12 | Putnam | West Virginia | 54079 | 5628 | 96 |
1472076 | 1472076 | 2021-06-30 | Pittsylvania | Virginia | 51143 | 5628 | 83 |
1452485 | 1452485 | 2021-06-24 | Summit | Utah | 49043 | 5628 | 13 |
1377404 | 1377404 | 2021-06-01 | Brown | South Dakota | 46013 | 5628 | 93 |
1374158 | 1374158 | 2021-05-31 | Brown | South Dakota | 46013 | 5628 | 93 |
1329964 | 1329964 | 2021-05-18 | Laurens | Georgia | 13175 | 5628 | 169 |
1331646 | 1331646 | 2021-05-18 | Cherokee | Oklahoma | 40021 | 5628 | 74 |
1328399 | 1328399 | 2021-05-17 | Cherokee | Oklahoma | 40021 | 5628 | 74 |
1325153 | 1325153 | 2021-05-16 | Cherokee | Oklahoma | 40021 | 5628 | 74 |
1321907 | 1321907 | 2021-05-15 | Cherokee | Oklahoma | 40021 | 5628 | 74 |
1318661 | 1318661 | 2021-05-14 | Cherokee | Oklahoma | 40021 | 5628 | 74 |
1315413 | 1315413 | 2021-05-13 | Cherokee | Oklahoma | 40021 | 5628 | 74 |
1312167 | 1312167 | 2021-05-12 | Cherokee | Oklahoma | 40021 | 5628 | 74 |
1264896 | 1264896 | 2021-04-28 | Gadsden | Florida | 12039 | 5628 | 93 |
1253707 | 1253707 | 2021-04-24 | Union | Ohio | 39159 | 5628 | 47 |
1233640 | 1233640 | 2021-04-18 | Lincoln | Missouri | 29113 | 5628 | 40 |
1187330 | 1187330 | 2021-04-04 | Dearborn | Indiana | 18029 | 5628 | 76 |
1036965 | 1036965 | 2021-02-16 | Bedford | Virginia | 51019 | 5628 | 44 |
1025743 | 1025743 | 2021-02-13 | Lafayette | Mississippi | 28071 | 5628 | 110 |
1008443 | 1008443 | 2021-02-08 | Putnam | Florida | 12107 | 5628 | 106 |
980212 | 980212 | 2021-01-30 | Kandiyohi | Minnesota | 27067 | 5628 | 73 |
972873 | 972873 | 2021-01-28 | Rockdale | Georgia | 13247 | 5628 | 111 |
952544 | 952544 | 2021-01-21 | Tooele | Utah | 49045 | 5628 | 19 |
942449 | 942449 | 2021-01-18 | Coffee | Tennessee | 47031 | 5628 | 82 |
839220 | 839220 | 2020-12-17 | Chippewa | Wisconsin | 55017 | 5628 | 65 |
716112 | 716112 | 2020-11-10 | Craighead | Arkansas | 5031 | 5628 | 58 |
540598 | 540598 | 2020-09-16 | Chesterfield | Virginia | 51041 | 5628 | 89 |
424773 | 424773 | 2020-08-12 | Monterey | California | 6053 | 5628 | 39 |
363671 | 363671 | 2020-07-24 | Santa Barbara | California | 6083 | 5628 | 32 |
89205 | 89205 | 2020-04-25 | Harris | Texas | 48201 | 5628 | 89 |
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);