ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,456 rows where cases = 30 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state >30
- Texas 286
- Nebraska 214
- Kansas 163
- North Dakota 160
- Virginia 139
- Washington 135
- Missouri 131
- Kentucky 124
- Ohio 111
- Georgia 106
- Oklahoma 104
- Puerto Rico 99
- Iowa 98
- Minnesota 98
- Tennessee 83
- North Carolina 82
- Illinois 81
- Michigan 76
- Arkansas 74
- Indiana 70
- Mississippi 70
- Colorado 62
- Alaska 61
- Montana 60
- South Dakota 58
- West Virginia 57
- Pennsylvania 56
- Oregon 53
- Idaho 51
- Alabama 49
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2439547 | 2439547 | 2022-04-24 | Unknown | New Mexico | 30 | 0 | |
2436291 | 2436291 | 2022-04-23 | Unknown | New Mexico | 30 | 0 | |
2433035 | 2433035 | 2022-04-22 | Unknown | New Mexico | 30 | 0 | |
2355125 | 2355125 | 2022-03-29 | Unknown | North Dakota | 30 | 47 | |
2257166 | 2257166 | 2022-02-27 | Arthur | Nebraska | 31005 | 30 | 1 |
2253915 | 2253915 | 2022-02-26 | Arthur | Nebraska | 31005 | 30 | 1 |
2250664 | 2250664 | 2022-02-25 | Arthur | Nebraska | 31005 | 30 | 1 |
2247413 | 2247413 | 2022-02-24 | Arthur | Nebraska | 31005 | 30 | 1 |
2244162 | 2244162 | 2022-02-23 | Arthur | Nebraska | 31005 | 30 | 1 |
2240911 | 2240911 | 2022-02-22 | Arthur | Nebraska | 31005 | 30 | 1 |
2237660 | 2237660 | 2022-02-21 | Arthur | Nebraska | 31005 | 30 | 1 |
2234409 | 2234409 | 2022-02-20 | Arthur | Nebraska | 31005 | 30 | 1 |
2231158 | 2231158 | 2022-02-19 | Arthur | Nebraska | 31005 | 30 | 1 |
2227907 | 2227907 | 2022-02-18 | Arthur | Nebraska | 31005 | 30 | 1 |
2224656 | 2224656 | 2022-02-17 | Arthur | Nebraska | 31005 | 30 | 1 |
2221405 | 2221405 | 2022-02-16 | Arthur | Nebraska | 31005 | 30 | 1 |
2218154 | 2218154 | 2022-02-15 | Arthur | Nebraska | 31005 | 30 | 1 |
2214903 | 2214903 | 2022-02-14 | Arthur | Nebraska | 31005 | 30 | 1 |
2211651 | 2211651 | 2022-02-13 | Arthur | Nebraska | 31005 | 30 | 1 |
2208398 | 2208398 | 2022-02-12 | Arthur | Nebraska | 31005 | 30 | 1 |
2205145 | 2205145 | 2022-02-11 | Arthur | Nebraska | 31005 | 30 | 1 |
2201892 | 2201892 | 2022-02-10 | Arthur | Nebraska | 31005 | 30 | 1 |
2198638 | 2198638 | 2022-02-09 | Arthur | Nebraska | 31005 | 30 | 1 |
2195384 | 2195384 | 2022-02-08 | Arthur | Nebraska | 31005 | 30 | 1 |
2192130 | 2192130 | 2022-02-07 | Arthur | Nebraska | 31005 | 30 | 1 |
2188877 | 2188877 | 2022-02-06 | Arthur | Nebraska | 31005 | 30 | 1 |
2185624 | 2185624 | 2022-02-05 | Arthur | Nebraska | 31005 | 30 | 1 |
2182372 | 2182372 | 2022-02-04 | Arthur | Nebraska | 31005 | 30 | 1 |
2179120 | 2179120 | 2022-02-03 | Arthur | Nebraska | 31005 | 30 | 1 |
2175868 | 2175868 | 2022-02-02 | Arthur | Nebraska | 31005 | 30 | 1 |
2172615 | 2172615 | 2022-02-01 | Arthur | Nebraska | 31005 | 30 | 1 |
2169362 | 2169362 | 2022-01-31 | Arthur | Nebraska | 31005 | 30 | 1 |
2166107 | 2166107 | 2022-01-30 | Arthur | Nebraska | 31005 | 30 | 1 |
2162852 | 2162852 | 2022-01-29 | Arthur | Nebraska | 31005 | 30 | 1 |
2159597 | 2159597 | 2022-01-28 | Arthur | Nebraska | 31005 | 30 | 1 |
2156343 | 2156343 | 2022-01-27 | Arthur | Nebraska | 31005 | 30 | 1 |
2153090 | 2153090 | 2022-01-26 | Arthur | Nebraska | 31005 | 30 | 1 |
2149838 | 2149838 | 2022-01-25 | Arthur | Nebraska | 31005 | 30 | 1 |
2146586 | 2146586 | 2022-01-24 | Arthur | Nebraska | 31005 | 30 | 1 |
2143331 | 2143331 | 2022-01-23 | Arthur | Nebraska | 31005 | 30 | 1 |
2140076 | 2140076 | 2022-01-22 | Arthur | Nebraska | 31005 | 30 | 1 |
2136820 | 2136820 | 2022-01-21 | Arthur | Nebraska | 31005 | 30 | 1 |
2133568 | 2133568 | 2022-01-20 | Arthur | Nebraska | 31005 | 30 | 1 |
2130315 | 2130315 | 2022-01-19 | Arthur | Nebraska | 31005 | 30 | 1 |
2127061 | 2127061 | 2022-01-18 | Arthur | Nebraska | 31005 | 30 | 1 |
2111890 | 2111890 | 2022-01-13 | King | Texas | 48269 | 30 | 0 |
2108638 | 2108638 | 2022-01-12 | King | Texas | 48269 | 30 | 0 |
2105387 | 2105387 | 2022-01-11 | King | Texas | 48269 | 30 | 0 |
2102136 | 2102136 | 2022-01-10 | King | Texas | 48269 | 30 | 0 |
2003055 | 2003055 | 2021-12-11 | Unknown | Maine | 30 | 0 | |
1826032 | 1826032 | 2021-10-17 | Unknown | Vermont | 30 | 0 | |
1733812 | 1733812 | 2021-09-19 | Banner | Nebraska | 31007 | 30 | 0 |
1730562 | 1730562 | 2021-09-18 | Banner | Nebraska | 31007 | 30 | 0 |
1727312 | 1727312 | 2021-09-17 | Banner | Nebraska | 31007 | 30 | 0 |
1724063 | 1724063 | 2021-09-16 | Banner | Nebraska | 31007 | 30 | 0 |
1720814 | 1720814 | 2021-09-15 | Banner | Nebraska | 31007 | 30 | 0 |
1717566 | 1717566 | 2021-09-14 | Banner | Nebraska | 31007 | 30 | 0 |
1714318 | 1714318 | 2021-09-13 | Banner | Nebraska | 31007 | 30 | 0 |
1711072 | 1711072 | 2021-09-12 | Banner | Nebraska | 31007 | 30 | 0 |
1707825 | 1707825 | 2021-09-11 | Banner | Nebraska | 31007 | 30 | 0 |
1704578 | 1704578 | 2021-09-10 | Banner | Nebraska | 31007 | 30 | 0 |
1701328 | 1701328 | 2021-09-09 | Banner | Nebraska | 31007 | 30 | 0 |
1698079 | 1698079 | 2021-09-08 | Banner | Nebraska | 31007 | 30 | 0 |
1694831 | 1694831 | 2021-09-07 | Banner | Nebraska | 31007 | 30 | 0 |
1691582 | 1691582 | 2021-09-06 | Banner | Nebraska | 31007 | 30 | 0 |
1688332 | 1688332 | 2021-09-05 | Banner | Nebraska | 31007 | 30 | 0 |
1685082 | 1685082 | 2021-09-04 | Banner | Nebraska | 31007 | 30 | 0 |
1681831 | 1681831 | 2021-09-03 | Banner | Nebraska | 31007 | 30 | 0 |
1678583 | 1678583 | 2021-09-02 | Banner | Nebraska | 31007 | 30 | 0 |
1675335 | 1675335 | 2021-09-01 | Banner | Nebraska | 31007 | 30 | 0 |
1672087 | 1672087 | 2021-08-31 | Banner | Nebraska | 31007 | 30 | 0 |
1668840 | 1668840 | 2021-08-30 | Banner | Nebraska | 31007 | 30 | 0 |
1665593 | 1665593 | 2021-08-29 | Banner | Nebraska | 31007 | 30 | 0 |
1662345 | 1662345 | 2021-08-28 | Banner | Nebraska | 31007 | 30 | 0 |
1659097 | 1659097 | 2021-08-27 | Banner | Nebraska | 31007 | 30 | 0 |
1655848 | 1655848 | 2021-08-26 | Banner | Nebraska | 31007 | 30 | 0 |
1652601 | 1652601 | 2021-08-25 | Banner | Nebraska | 31007 | 30 | 0 |
1649353 | 1649353 | 2021-08-24 | Banner | Nebraska | 31007 | 30 | 0 |
1646104 | 1646104 | 2021-08-23 | Banner | Nebraska | 31007 | 30 | 0 |
1642855 | 1642855 | 2021-08-22 | Banner | Nebraska | 31007 | 30 | 0 |
1639605 | 1639605 | 2021-08-21 | Banner | Nebraska | 31007 | 30 | 0 |
1636355 | 1636355 | 2021-08-20 | Banner | Nebraska | 31007 | 30 | 0 |
1633105 | 1633105 | 2021-08-19 | Banner | Nebraska | 31007 | 30 | 0 |
1629858 | 1629858 | 2021-08-18 | Banner | Nebraska | 31007 | 30 | 0 |
1626611 | 1626611 | 2021-08-17 | Banner | Nebraska | 31007 | 30 | 0 |
1623364 | 1623364 | 2021-08-16 | Banner | Nebraska | 31007 | 30 | 0 |
1620117 | 1620117 | 2021-08-15 | Banner | Nebraska | 31007 | 30 | 0 |
1616869 | 1616869 | 2021-08-14 | Banner | Nebraska | 31007 | 30 | 0 |
1613621 | 1613621 | 2021-08-13 | Banner | Nebraska | 31007 | 30 | 0 |
1610372 | 1610372 | 2021-08-12 | Banner | Nebraska | 31007 | 30 | 0 |
1607124 | 1607124 | 2021-08-11 | Banner | Nebraska | 31007 | 30 | 0 |
1603875 | 1603875 | 2021-08-10 | Banner | Nebraska | 31007 | 30 | 0 |
1600626 | 1600626 | 2021-08-09 | Banner | Nebraska | 31007 | 30 | 0 |
1597378 | 1597378 | 2021-08-08 | Banner | Nebraska | 31007 | 30 | 0 |
1594129 | 1594129 | 2021-08-07 | Banner | Nebraska | 31007 | 30 | 0 |
1590880 | 1590880 | 2021-08-06 | Banner | Nebraska | 31007 | 30 | 0 |
1587631 | 1587631 | 2021-08-05 | Banner | Nebraska | 31007 | 30 | 0 |
1584380 | 1584380 | 2021-08-04 | Banner | Nebraska | 31007 | 30 | 0 |
1581131 | 1581131 | 2021-08-03 | Banner | Nebraska | 31007 | 30 | 0 |
1577882 | 1577882 | 2021-08-02 | Banner | Nebraska | 31007 | 30 | 0 |
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);