ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
200 rows where deaths = 802 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Florida 118
- Texas 11
- Pennsylvania 10
- Oklahoma 7
- South Carolina 6
- Alabama 5
- Colorado 5
- Illinois 5
- Ohio 5
- New York 4
- Georgia 3
- Minnesota 3
- New Jersey 3
- Arkansas 2
- Maryland 2
- Massachusetts 2
- North Carolina 2
- California 1
- Louisiana 1
- Michigan 1
- Missouri 1
- New Mexico 1
- Tennessee 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499871 | 2499871 | 2022-05-13 | Pueblo | Colorado | 8101 | 47690 | 802 |
2496613 | 2496613 | 2022-05-12 | Pueblo | Colorado | 8101 | 47647 | 802 |
2498200 | 2498200 | 2022-05-12 | Oneida | New York | 36065 | 58360 | 802 |
2404051 | 2404051 | 2022-04-13 | Cleveland | Oklahoma | 40027 | 79158 | 802 |
2400796 | 2400796 | 2022-04-12 | Cleveland | Oklahoma | 40027 | 79158 | 802 |
2397541 | 2397541 | 2022-04-11 | Cleveland | Oklahoma | 40027 | 79158 | 802 |
2394286 | 2394286 | 2022-04-10 | Cleveland | Oklahoma | 40027 | 79158 | 802 |
2391030 | 2391030 | 2022-04-09 | Cleveland | Oklahoma | 40027 | 79158 | 802 |
2387774 | 2387774 | 2022-04-08 | Cleveland | Oklahoma | 40027 | 79158 | 802 |
2384519 | 2384519 | 2022-04-07 | Cleveland | Oklahoma | 40027 | 79158 | 802 |
2360071 | 2360071 | 2022-03-31 | Muscogee | Georgia | 13215 | 38088 | 802 |
2352869 | 2352869 | 2022-03-28 | Virginia Beach city | Virginia | 51810 | 88962 | 802 |
2333875 | 2333875 | 2022-03-23 | Bay | Florida | 12005 | 45557 | 802 |
2330621 | 2330621 | 2022-03-22 | Bay | Florida | 12005 | 45557 | 802 |
2327369 | 2327369 | 2022-03-21 | Bay | Florida | 12005 | 45557 | 802 |
2324116 | 2324116 | 2022-03-20 | Bay | Florida | 12005 | 45557 | 802 |
2320862 | 2320862 | 2022-03-19 | Bay | Florida | 12005 | 45557 | 802 |
2317608 | 2317608 | 2022-03-18 | Bay | Florida | 12005 | 45557 | 802 |
2314355 | 2314355 | 2022-03-17 | Bay | Florida | 12005 | 45557 | 802 |
2311102 | 2311102 | 2022-03-16 | Bay | Florida | 12005 | 45557 | 802 |
2251740 | 2251740 | 2022-02-25 | Jefferson | Texas | 48245 | 43663 | 802 |
2236402 | 2236402 | 2022-02-21 | Chatham | Georgia | 13051 | 61233 | 802 |
2178106 | 2178106 | 2022-02-03 | Madison | Illinois | 17119 | 67788 | 802 |
2174853 | 2174853 | 2022-02-02 | Madison | Illinois | 17119 | 67788 | 802 |
2099425 | 2099425 | 2022-01-10 | Montgomery | Alabama | 1101 | 43660 | 802 |
2101176 | 2101176 | 2022-01-10 | Gloucester | New Jersey | 34015 | 57887 | 802 |
2096174 | 2096174 | 2022-01-09 | Montgomery | Alabama | 1101 | 43360 | 802 |
2092922 | 2092922 | 2022-01-08 | Montgomery | Alabama | 1101 | 42763 | 802 |
2089670 | 2089670 | 2022-01-07 | Montgomery | Alabama | 1101 | 42212 | 802 |
2062247 | 2062247 | 2021-12-29 | Rockland | New York | 36087 | 63822 | 802 |
2014030 | 2014030 | 2021-12-14 | Anderson | South Carolina | 45007 | 38442 | 802 |
1987483 | 1987483 | 2021-12-06 | Orange | New York | 36071 | 63624 | 802 |
1935473 | 1935473 | 2021-11-20 | Onondaga | New York | 36067 | 57449 | 802 |
1900159 | 1900159 | 2021-11-09 | Northampton | Pennsylvania | 42095 | 45441 | 802 |
1865683 | 1865683 | 2021-10-30 | Citrus | Florida | 12017 | 20392 | 802 |
1862434 | 1862434 | 2021-10-29 | Citrus | Florida | 12017 | 20392 | 802 |
1859185 | 1859185 | 2021-10-28 | Citrus | Florida | 12017 | 20328 | 802 |
1855936 | 1855936 | 2021-10-27 | Citrus | Florida | 12017 | 20328 | 802 |
1852687 | 1852687 | 2021-10-26 | Citrus | Florida | 12017 | 20328 | 802 |
1849438 | 1849438 | 2021-10-25 | Citrus | Florida | 12017 | 20328 | 802 |
1795420 | 1795420 | 2021-10-08 | Kansas City | Missouri | 61971 | 802 | |
1767069 | 1767069 | 2021-09-29 | Horry | South Carolina | 45051 | 59459 | 802 |
1713019 | 1713019 | 2021-09-13 | Pasco | Florida | 12101 | 72254 | 802 |
1709772 | 1709772 | 2021-09-12 | Pasco | Florida | 12101 | 72254 | 802 |
1706525 | 1706525 | 2021-09-11 | Pasco | Florida | 12101 | 72254 | 802 |
1703277 | 1703277 | 2021-09-10 | Pasco | Florida | 12101 | 72254 | 802 |
1700027 | 1700027 | 2021-09-09 | Pasco | Florida | 12101 | 68963 | 802 |
1696778 | 1696778 | 2021-09-08 | Pasco | Florida | 12101 | 68963 | 802 |
1698402 | 1698402 | 2021-09-08 | Wake | North Carolina | 37183 | 115237 | 802 |
1693530 | 1693530 | 2021-09-07 | Pasco | Florida | 12101 | 68963 | 802 |
1690281 | 1690281 | 2021-09-06 | Pasco | Florida | 12101 | 68963 | 802 |
1687031 | 1687031 | 2021-09-05 | Pasco | Florida | 12101 | 68963 | 802 |
1683781 | 1683781 | 2021-09-04 | Pasco | Florida | 12101 | 68963 | 802 |
1680530 | 1680530 | 2021-09-03 | Pasco | Florida | 12101 | 68963 | 802 |
1677154 | 1677154 | 2021-09-02 | Adams | Colorado | 8001 | 67977 | 802 |
1677282 | 1677282 | 2021-09-02 | Pasco | Florida | 12101 | 65142 | 802 |
1679238 | 1679238 | 2021-09-02 | Westmoreland | Pennsylvania | 42129 | 36940 | 802 |
1674035 | 1674035 | 2021-09-01 | Pasco | Florida | 12101 | 65142 | 802 |
1670584 | 1670584 | 2021-08-31 | Pulaski | Arkansas | 5119 | 54063 | 802 |
1670787 | 1670787 | 2021-08-31 | Pasco | Florida | 12101 | 65142 | 802 |
1667337 | 1667337 | 2021-08-30 | Pulaski | Arkansas | 5119 | 53852 | 802 |
1667540 | 1667540 | 2021-08-30 | Pasco | Florida | 12101 | 65142 | 802 |
1664293 | 1664293 | 2021-08-29 | Pasco | Florida | 12101 | 65142 | 802 |
1661045 | 1661045 | 2021-08-28 | Pasco | Florida | 12101 | 65142 | 802 |
1657797 | 1657797 | 2021-08-27 | Pasco | Florida | 12101 | 65142 | 802 |
1654549 | 1654549 | 2021-08-26 | Pasco | Florida | 12101 | 60753 | 802 |
1651302 | 1651302 | 2021-08-25 | Pasco | Florida | 12101 | 60753 | 802 |
1648053 | 1648053 | 2021-08-24 | Pasco | Florida | 12101 | 60753 | 802 |
1644805 | 1644805 | 2021-08-23 | Pasco | Florida | 12101 | 60753 | 802 |
1641555 | 1641555 | 2021-08-22 | Pasco | Florida | 12101 | 60753 | 802 |
1638305 | 1638305 | 2021-08-21 | Pasco | Florida | 12101 | 60753 | 802 |
1635055 | 1635055 | 2021-08-20 | Pasco | Florida | 12101 | 60753 | 802 |
1631806 | 1631806 | 2021-08-19 | Pasco | Florida | 12101 | 56511 | 802 |
1628559 | 1628559 | 2021-08-18 | Pasco | Florida | 12101 | 56511 | 802 |
1625312 | 1625312 | 2021-08-17 | Pasco | Florida | 12101 | 56511 | 802 |
1627624 | 1627624 | 2021-08-17 | Denton | Texas | 48121 | 84629 | 802 |
1622065 | 1622065 | 2021-08-16 | Pasco | Florida | 12101 | 56511 | 802 |
1618818 | 1618818 | 2021-08-15 | Pasco | Florida | 12101 | 56511 | 802 |
1615570 | 1615570 | 2021-08-14 | Pasco | Florida | 12101 | 56511 | 802 |
1612321 | 1612321 | 2021-08-13 | Pasco | Florida | 12101 | 56511 | 802 |
1609073 | 1609073 | 2021-08-12 | Pasco | Florida | 12101 | 52639 | 802 |
1605824 | 1605824 | 2021-08-11 | Pasco | Florida | 12101 | 52639 | 802 |
1602575 | 1602575 | 2021-08-10 | Pasco | Florida | 12101 | 52639 | 802 |
1599326 | 1599326 | 2021-08-09 | Pasco | Florida | 12101 | 52639 | 802 |
1596077 | 1596077 | 2021-08-08 | Pasco | Florida | 12101 | 52639 | 802 |
1592828 | 1592828 | 2021-08-07 | Pasco | Florida | 12101 | 52639 | 802 |
1589579 | 1589579 | 2021-08-06 | Pasco | Florida | 12101 | 52639 | 802 |
1586330 | 1586330 | 2021-08-05 | Pasco | Florida | 12101 | 49233 | 802 |
1583080 | 1583080 | 2021-08-04 | Pasco | Florida | 12101 | 49233 | 802 |
1579830 | 1579830 | 2021-08-03 | Pasco | Florida | 12101 | 49233 | 802 |
1576582 | 1576582 | 2021-08-02 | Pasco | Florida | 12101 | 49233 | 802 |
1573334 | 1573334 | 2021-08-01 | Pasco | Florida | 12101 | 49233 | 802 |
1570086 | 1570086 | 2021-07-31 | Pasco | Florida | 12101 | 49233 | 802 |
1566838 | 1566838 | 2021-07-30 | Pasco | Florida | 12101 | 49233 | 802 |
1563590 | 1563590 | 2021-07-29 | Pasco | Florida | 12101 | 46341 | 802 |
1560342 | 1560342 | 2021-07-28 | Pasco | Florida | 12101 | 46341 | 802 |
1557095 | 1557095 | 2021-07-27 | Pasco | Florida | 12101 | 46341 | 802 |
1553848 | 1553848 | 2021-07-26 | Pasco | Florida | 12101 | 46341 | 802 |
1550601 | 1550601 | 2021-07-25 | Pasco | Florida | 12101 | 46341 | 802 |
1547354 | 1547354 | 2021-07-24 | Pasco | Florida | 12101 | 46341 | 802 |
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);