ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
706 rows where deaths = 285 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 134
- Alabama 39
- Virginia 38
- Georgia 28
- Louisiana 26
- Pennsylvania 25
- Texas 25
- Indiana 24
- Kentucky 24
- Ohio 22
- Illinois 21
- Idaho 20
- North Carolina 20
- California 18
- Tennessee 18
- Michigan 17
- Wisconsin 17
- Missouri 16
- Oklahoma 16
- Maine 13
- Montana 13
- Massachusetts 12
- Oregon 12
- Kansas 11
- Arkansas 10
- Mississippi 10
- South Carolina 10
- Minnesota 9
- Colorado 8
- New York 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500764 | 2500764 | 2022-05-13 | Androscoggin | Maine | 23001 | 23257 | 285 |
2497506 | 2497506 | 2022-05-12 | Androscoggin | Maine | 23001 | 23208 | 285 |
2494248 | 2494248 | 2022-05-11 | Androscoggin | Maine | 23001 | 23169 | 285 |
2496050 | 2496050 | 2022-05-11 | Hanover | Virginia | 51085 | 22319 | 285 |
2490990 | 2490990 | 2022-05-10 | Androscoggin | Maine | 23001 | 23123 | 285 |
2492792 | 2492792 | 2022-05-10 | Hanover | Virginia | 51085 | 22273 | 285 |
2487733 | 2487733 | 2022-05-09 | Androscoggin | Maine | 23001 | 23086 | 285 |
2489534 | 2489534 | 2022-05-09 | Hanover | Virginia | 51085 | 22228 | 285 |
2484389 | 2484389 | 2022-05-08 | Pulaski | Kentucky | 21199 | 18132 | 285 |
2484475 | 2484475 | 2022-05-08 | Androscoggin | Maine | 23001 | 23061 | 285 |
2486277 | 2486277 | 2022-05-08 | Hanover | Virginia | 51085 | 22160 | 285 |
2481131 | 2481131 | 2022-05-07 | Pulaski | Kentucky | 21199 | 18132 | 285 |
2481217 | 2481217 | 2022-05-07 | Androscoggin | Maine | 23001 | 23061 | 285 |
2483019 | 2483019 | 2022-05-07 | Hanover | Virginia | 51085 | 22160 | 285 |
2477873 | 2477873 | 2022-05-06 | Pulaski | Kentucky | 21199 | 18132 | 285 |
2477959 | 2477959 | 2022-05-06 | Androscoggin | Maine | 23001 | 23004 | 285 |
2479761 | 2479761 | 2022-05-06 | Hanover | Virginia | 51085 | 22160 | 285 |
2474615 | 2474615 | 2022-05-05 | Pulaski | Kentucky | 21199 | 18132 | 285 |
2474701 | 2474701 | 2022-05-05 | Androscoggin | Maine | 23001 | 22958 | 285 |
2471358 | 2471358 | 2022-05-04 | Pulaski | Kentucky | 21199 | 18132 | 285 |
2468102 | 2468102 | 2022-05-03 | Pulaski | Kentucky | 21199 | 18132 | 285 |
2464847 | 2464847 | 2022-05-02 | Pulaski | Kentucky | 21199 | 18132 | 285 |
2464949 | 2464949 | 2022-05-02 | York | Maine | 23031 | 40686 | 285 |
2461693 | 2461693 | 2022-05-01 | York | Maine | 23031 | 40572 | 285 |
2458437 | 2458437 | 2022-04-30 | York | Maine | 23031 | 40572 | 285 |
2428495 | 2428495 | 2022-04-21 | Bonneville | Idaho | 16019 | 30837 | 285 |
2425239 | 2425239 | 2022-04-20 | Bonneville | Idaho | 16019 | 30837 | 285 |
2421983 | 2421983 | 2022-04-19 | Bonneville | Idaho | 16019 | 30830 | 285 |
2418727 | 2418727 | 2022-04-18 | Bonneville | Idaho | 16019 | 30830 | 285 |
2415471 | 2415471 | 2022-04-17 | Bonneville | Idaho | 16019 | 30825 | 285 |
2412215 | 2412215 | 2022-04-16 | Bonneville | Idaho | 16019 | 30825 | 285 |
2408959 | 2408959 | 2022-04-15 | Bonneville | Idaho | 16019 | 30825 | 285 |
2405703 | 2405703 | 2022-04-14 | Bonneville | Idaho | 16019 | 30824 | 285 |
2402448 | 2402448 | 2022-04-13 | Bonneville | Idaho | 16019 | 30822 | 285 |
2399193 | 2399193 | 2022-04-12 | Bonneville | Idaho | 16019 | 30820 | 285 |
2395938 | 2395938 | 2022-04-11 | Bonneville | Idaho | 16019 | 30820 | 285 |
2381274 | 2381274 | 2022-04-06 | Garfield | Oklahoma | 40047 | 15167 | 285 |
2378019 | 2378019 | 2022-04-05 | Garfield | Oklahoma | 40047 | 15167 | 285 |
2374765 | 2374765 | 2022-04-04 | Garfield | Oklahoma | 40047 | 15167 | 285 |
2371513 | 2371513 | 2022-04-03 | Garfield | Oklahoma | 40047 | 15167 | 285 |
2368260 | 2368260 | 2022-04-02 | Garfield | Oklahoma | 40047 | 15167 | 285 |
2365007 | 2365007 | 2022-04-01 | Garfield | Oklahoma | 40047 | 15167 | 285 |
2365707 | 2365707 | 2022-04-01 | Wood | Texas | 48499 | 7995 | 285 |
2361754 | 2361754 | 2022-03-31 | Garfield | Oklahoma | 40047 | 15167 | 285 |
2362454 | 2362454 | 2022-03-31 | Wood | Texas | 48499 | 7995 | 285 |
2359369 | 2359369 | 2022-03-30 | Spotsylvania | Virginia | 51177 | 26620 | 285 |
2356115 | 2356115 | 2022-03-29 | Spotsylvania | Virginia | 51177 | 26587 | 285 |
2352862 | 2352862 | 2022-03-28 | Spotsylvania | Virginia | 51177 | 26585 | 285 |
2340241 | 2340241 | 2022-03-25 | White | Arkansas | 5145 | 22032 | 285 |
2336988 | 2336988 | 2022-03-24 | White | Arkansas | 5145 | 22028 | 285 |
2337563 | 2337563 | 2022-03-24 | Morgan | Indiana | 18109 | 16461 | 285 |
2328643 | 2328643 | 2022-03-21 | St. Francois | Missouri | 29187 | 19018 | 285 |
2325391 | 2325391 | 2022-03-20 | St. Francois | Missouri | 29187 | 19015 | 285 |
2322137 | 2322137 | 2022-03-19 | St. Francois | Missouri | 29187 | 19015 | 285 |
2318883 | 2318883 | 2022-03-18 | St. Francois | Missouri | 29187 | 19015 | 285 |
2315630 | 2315630 | 2022-03-17 | St. Francois | Missouri | 29187 | 19006 | 285 |
2312377 | 2312377 | 2022-03-16 | St. Francois | Missouri | 29187 | 18999 | 285 |
2309124 | 2309124 | 2022-03-15 | St. Francois | Missouri | 29187 | 18988 | 285 |
2293545 | 2293545 | 2022-03-10 | Carbon | Pennsylvania | 42025 | 15775 | 285 |
2288612 | 2288612 | 2022-03-09 | Twin Falls | Idaho | 16083 | 22655 | 285 |
2290293 | 2290293 | 2022-03-09 | Carbon | Pennsylvania | 42025 | 15772 | 285 |
2269225 | 2269225 | 2022-03-03 | Floyd | Indiana | 18043 | 18796 | 285 |
2271547 | 2271547 | 2022-03-03 | Suffolk city | Virginia | 51800 | 18527 | 285 |
2267216 | 2267216 | 2022-03-02 | Nash | North Carolina | 37127 | 26901 | 285 |
2268295 | 2268295 | 2022-03-02 | Suffolk city | Virginia | 51800 | 18521 | 285 |
2263119 | 2263119 | 2022-03-01 | Ascension | Louisiana | 22005 | 34654 | 285 |
2263964 | 2263964 | 2022-03-01 | Nash | North Carolina | 37127 | 26866 | 285 |
2265042 | 2265042 | 2022-03-01 | Suffolk city | Virginia | 51800 | 18512 | 285 |
2259868 | 2259868 | 2022-02-28 | Ascension | Louisiana | 22005 | 34654 | 285 |
2260713 | 2260713 | 2022-02-28 | Nash | North Carolina | 37127 | 26832 | 285 |
2256617 | 2256617 | 2022-02-27 | Ascension | Louisiana | 22005 | 34654 | 285 |
2256942 | 2256942 | 2022-02-27 | Jones | Mississippi | 28067 | 21082 | 285 |
2257462 | 2257462 | 2022-02-27 | Nash | North Carolina | 37127 | 26810 | 285 |
2258707 | 2258707 | 2022-02-27 | Sheboygan | Wisconsin | 55117 | 32177 | 285 |
2253366 | 2253366 | 2022-02-26 | Ascension | Louisiana | 22005 | 34654 | 285 |
2253691 | 2253691 | 2022-02-26 | Jones | Mississippi | 28067 | 21082 | 285 |
2254095 | 2254095 | 2022-02-26 | Chautauqua | New York | 36013 | 23297 | 285 |
2254211 | 2254211 | 2022-02-26 | Nash | North Carolina | 37127 | 26810 | 285 |
2255456 | 2255456 | 2022-02-26 | Sheboygan | Wisconsin | 55117 | 32177 | 285 |
2250115 | 2250115 | 2022-02-25 | Ascension | Louisiana | 22005 | 34654 | 285 |
2250440 | 2250440 | 2022-02-25 | Jones | Mississippi | 28067 | 21082 | 285 |
2250960 | 2250960 | 2022-02-25 | Nash | North Carolina | 37127 | 26810 | 285 |
2252205 | 2252205 | 2022-02-25 | Sheboygan | Wisconsin | 55117 | 32177 | 285 |
2246864 | 2246864 | 2022-02-24 | Ascension | Louisiana | 22005 | 34647 | 285 |
2247709 | 2247709 | 2022-02-24 | Nash | North Carolina | 37127 | 26797 | 285 |
2247874 | 2247874 | 2022-02-24 | Ross | Ohio | 39141 | 19058 | 285 |
2243613 | 2243613 | 2022-02-23 | Ascension | Louisiana | 22005 | 34627 | 285 |
2244623 | 2244623 | 2022-02-23 | Ross | Ohio | 39141 | 19048 | 285 |
2240362 | 2240362 | 2022-02-22 | Ascension | Louisiana | 22005 | 34618 | 285 |
2241372 | 2241372 | 2022-02-22 | Ross | Ohio | 39141 | 19025 | 285 |
2233858 | 2233858 | 2022-02-20 | Acadia | Louisiana | 22001 | 15732 | 285 |
2230607 | 2230607 | 2022-02-19 | Acadia | Louisiana | 22001 | 15732 | 285 |
2227356 | 2227356 | 2022-02-18 | Acadia | Louisiana | 22001 | 15732 | 285 |
2224105 | 2224105 | 2022-02-17 | Acadia | Louisiana | 22001 | 15719 | 285 |
2224439 | 2224439 | 2022-02-17 | Lee | Mississippi | 28081 | 26245 | 285 |
2220854 | 2220854 | 2022-02-16 | Acadia | Louisiana | 22001 | 15712 | 285 |
2216798 | 2216798 | 2022-02-15 | Windham | Connecticut | 9015 | 25179 | 285 |
2215334 | 2215334 | 2022-02-14 | Jefferson | Ohio | 39081 | 14443 | 285 |
2212083 | 2212083 | 2022-02-13 | Jefferson | Ohio | 39081 | 14434 | 285 |
2208830 | 2208830 | 2022-02-12 | Jefferson | Ohio | 39081 | 14415 | 285 |
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);