ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
304 rows where cases = 2046 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 33
- Iowa 20
- Missouri 18
- Arkansas 17
- Montana 13
- Georgia 12
- Mississippi 12
- Texas 11
- Kentucky 10
- Michigan 9
- Alaska 8
- Florida 8
- Kansas 8
- Oklahoma 8
- Vermont 8
- Virginia 8
- Alabama 7
- Illinois 7
- Nebraska 7
- South Dakota 7
- Ohio 6
- California 5
- Colorado 5
- Louisiana 5
- Washington 5
- North Dakota 4
- South Carolina 4
- Tennessee 4
- Utah 4
- Wisconsin 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498163 | 2498163 | 2022-05-12 | Sierra | New Mexico | 35051 | 2046 | 73 |
2489890 | 2489890 | 2022-05-10 | Southeast Fairbanks Census Area | Alaska | 2240 | 2046 | 20 |
2490672 | 2490672 | 2022-05-10 | Palo Alto | Iowa | 19147 | 2046 | 38 |
2486633 | 2486633 | 2022-05-09 | Southeast Fairbanks Census Area | Alaska | 2240 | 2046 | 20 |
2487415 | 2487415 | 2022-05-09 | Palo Alto | Iowa | 19147 | 2046 | 38 |
2483375 | 2483375 | 2022-05-08 | Southeast Fairbanks Census Area | Alaska | 2240 | 2046 | 20 |
2484157 | 2484157 | 2022-05-08 | Palo Alto | Iowa | 19147 | 2046 | 38 |
2480117 | 2480117 | 2022-05-07 | Southeast Fairbanks Census Area | Alaska | 2240 | 2046 | 20 |
2480899 | 2480899 | 2022-05-07 | Palo Alto | Iowa | 19147 | 2046 | 38 |
2476859 | 2476859 | 2022-05-06 | Southeast Fairbanks Census Area | Alaska | 2240 | 2046 | 20 |
2477641 | 2477641 | 2022-05-06 | Palo Alto | Iowa | 19147 | 2046 | 38 |
2473601 | 2473601 | 2022-05-05 | Southeast Fairbanks Census Area | Alaska | 2240 | 2046 | 20 |
2474383 | 2474383 | 2022-05-05 | Palo Alto | Iowa | 19147 | 2046 | 38 |
2470344 | 2470344 | 2022-05-04 | Southeast Fairbanks Census Area | Alaska | 2240 | 2046 | 20 |
2471126 | 2471126 | 2022-05-04 | Palo Alto | Iowa | 19147 | 2046 | 38 |
2471945 | 2471945 | 2022-05-04 | Cheyenne | Nebraska | 31033 | 2046 | 24 |
2468689 | 2468689 | 2022-05-03 | Cheyenne | Nebraska | 31033 | 2046 | 24 |
2417877 | 2417877 | 2022-04-17 | Falls Church city | Virginia | 51610 | 2046 | 16 |
2414621 | 2414621 | 2022-04-16 | Falls Church city | Virginia | 51610 | 2046 | 16 |
2411365 | 2411365 | 2022-04-15 | Falls Church city | Virginia | 51610 | 2046 | 16 |
2400247 | 2400247 | 2022-04-12 | Carbon | Montana | 30009 | 2046 | 28 |
2396992 | 2396992 | 2022-04-11 | Carbon | Montana | 30009 | 2046 | 28 |
2393737 | 2393737 | 2022-04-10 | Carbon | Montana | 30009 | 2046 | 28 |
2390481 | 2390481 | 2022-04-09 | Carbon | Montana | 30009 | 2046 | 28 |
2387225 | 2387225 | 2022-04-08 | Carbon | Montana | 30009 | 2046 | 28 |
2374207 | 2374207 | 2022-04-04 | Carbon | Montana | 30009 | 2046 | 28 |
2369346 | 2369346 | 2022-04-03 | Choctaw | Alabama | 1023 | 2046 | 36 |
2366093 | 2366093 | 2022-04-02 | Choctaw | Alabama | 1023 | 2046 | 36 |
2362840 | 2362840 | 2022-04-01 | Choctaw | Alabama | 1023 | 2046 | 36 |
2359586 | 2359586 | 2022-03-31 | Choctaw | Alabama | 1023 | 2046 | 36 |
2356332 | 2356332 | 2022-03-30 | Choctaw | Alabama | 1023 | 2046 | 36 |
2353853 | 2353853 | 2022-03-29 | Union | Indiana | 18161 | 2046 | 21 |
2350601 | 2350601 | 2022-03-28 | Union | Indiana | 18161 | 2046 | 21 |
2347348 | 2347348 | 2022-03-27 | Union | Indiana | 18161 | 2046 | 21 |
2344095 | 2344095 | 2022-03-26 | Union | Indiana | 18161 | 2046 | 21 |
2340842 | 2340842 | 2022-03-25 | Union | Indiana | 18161 | 2046 | 21 |
2337589 | 2337589 | 2022-03-24 | Union | Indiana | 18161 | 2046 | 21 |
2334335 | 2334335 | 2022-03-23 | Union | Indiana | 18161 | 2046 | 21 |
2331081 | 2331081 | 2022-03-22 | Union | Indiana | 18161 | 2046 | 21 |
2327829 | 2327829 | 2022-03-21 | Union | Indiana | 18161 | 2046 | 21 |
2324576 | 2324576 | 2022-03-20 | Union | Indiana | 18161 | 2046 | 21 |
2321322 | 2321322 | 2022-03-19 | Union | Indiana | 18161 | 2046 | 21 |
2318068 | 2318068 | 2022-03-18 | Union | Indiana | 18161 | 2046 | 21 |
2314815 | 2314815 | 2022-03-17 | Union | Indiana | 18161 | 2046 | 21 |
2311562 | 2311562 | 2022-03-16 | Union | Indiana | 18161 | 2046 | 21 |
2286133 | 2286133 | 2022-03-08 | Marshall | Minnesota | 27089 | 2046 | 23 |
2233526 | 2233526 | 2022-02-20 | Warren | Indiana | 18171 | 2046 | 25 |
2230275 | 2230275 | 2022-02-19 | Warren | Indiana | 18171 | 2046 | 25 |
2230799 | 2230799 | 2022-02-19 | Presque Isle | Michigan | 26141 | 2046 | 55 |
2227024 | 2227024 | 2022-02-18 | Warren | Indiana | 18171 | 2046 | 25 |
2227548 | 2227548 | 2022-02-18 | Presque Isle | Michigan | 26141 | 2046 | 55 |
2224297 | 2224297 | 2022-02-17 | Presque Isle | Michigan | 26141 | 2046 | 55 |
2226094 | 2226094 | 2022-02-17 | Gilmer | West Virginia | 54021 | 2046 | 18 |
2221046 | 2221046 | 2022-02-16 | Presque Isle | Michigan | 26141 | 2046 | 55 |
2206179 | 2206179 | 2022-02-11 | Franklin | Texas | 48159 | 2046 | 38 |
2195326 | 2195326 | 2022-02-08 | Beaverhead | Montana | 30001 | 2046 | 24 |
2177211 | 2177211 | 2022-02-02 | Northampton | Virginia | 51131 | 2046 | 52 |
2148714 | 2148714 | 2022-01-25 | Wilkinson | Georgia | 13319 | 2046 | 49 |
2130385 | 2130385 | 2022-01-19 | Red Willow | Nebraska | 31145 | 2046 | 18 |
2125917 | 2125917 | 2022-01-18 | Towns | Georgia | 13281 | 2046 | 90 |
2128467 | 2128467 | 2022-01-18 | Jefferson | Washington | 53031 | 2046 | 22 |
2122624 | 2122624 | 2022-01-17 | McIntosh | Georgia | 13191 | 2046 | 33 |
2124639 | 2124639 | 2022-01-17 | Lake | South Dakota | 46079 | 2046 | 26 |
2121387 | 2121387 | 2022-01-16 | Lake | South Dakota | 46079 | 2046 | 26 |
2118135 | 2118135 | 2022-01-15 | Lake | South Dakota | 46079 | 2046 | 26 |
2114884 | 2114884 | 2022-01-14 | Lake | South Dakota | 46079 | 2046 | 26 |
2104661 | 2104661 | 2022-01-11 | Mercer | North Dakota | 38057 | 2046 | 22 |
2081423 | 2081423 | 2022-01-04 | Linn | Missouri | 29115 | 2046 | 58 |
2076909 | 2076909 | 2022-01-03 | Prowers | Colorado | 8099 | 2046 | 43 |
2057323 | 2057323 | 2021-12-28 | Mono | California | 6051 | 2046 | 4 |
2041081 | 2041081 | 2021-12-23 | Plumas | California | 6063 | 2046 | 13 |
2024727 | 2024727 | 2021-12-18 | Bradley | Arkansas | 5011 | 2046 | 42 |
2018775 | 2018775 | 2021-12-16 | Menard | Illinois | 17129 | 2046 | 19 |
1995625 | 1995625 | 2021-12-09 | Gunnison | Colorado | 8051 | 2046 | 12 |
1996586 | 1996586 | 2021-12-09 | Dukes | Massachusetts | 25007 | 2046 | 0 |
1966902 | 1966902 | 2021-11-30 | Allamakee | Iowa | 19005 | 2046 | 55 |
1963650 | 1963650 | 2021-11-29 | Allamakee | Iowa | 19005 | 2046 | 55 |
1965324 | 1965324 | 2021-11-29 | Butte | South Dakota | 46019 | 2046 | 34 |
1960399 | 1960399 | 2021-11-28 | Allamakee | Iowa | 19005 | 2046 | 55 |
1961696 | 1961696 | 2021-11-28 | Harrison | Ohio | 39067 | 2046 | 52 |
1957148 | 1957148 | 2021-11-27 | Allamakee | Iowa | 19005 | 2046 | 55 |
1958382 | 1958382 | 2021-11-27 | McLean | North Dakota | 38055 | 2046 | 43 |
1953897 | 1953897 | 2021-11-26 | Allamakee | Iowa | 19005 | 2046 | 55 |
1950646 | 1950646 | 2021-11-25 | Allamakee | Iowa | 19005 | 2046 | 55 |
1947395 | 1947395 | 2021-11-24 | Allamakee | Iowa | 19005 | 2046 | 55 |
1948632 | 1948632 | 2021-11-24 | Mountrail | North Dakota | 38061 | 2046 | 29 |
1938337 | 1938337 | 2021-11-21 | Webster | Mississippi | 28155 | 2046 | 48 |
1935087 | 1935087 | 2021-11-20 | Webster | Mississippi | 28155 | 2046 | 48 |
1931837 | 1931837 | 2021-11-19 | Webster | Mississippi | 28155 | 2046 | 48 |
1928586 | 1928586 | 2021-11-18 | Webster | Mississippi | 28155 | 2046 | 48 |
1917941 | 1917941 | 2021-11-15 | Shoshone | Idaho | 16079 | 2046 | 61 |
1894882 | 1894882 | 2021-11-08 | Moffat | Colorado | 8081 | 2046 | 45 |
1892360 | 1892360 | 2021-11-07 | Breathitt | Kentucky | 21025 | 2046 | 30 |
1889110 | 1889110 | 2021-11-06 | Breathitt | Kentucky | 21025 | 2046 | 30 |
1885860 | 1885860 | 2021-11-05 | Breathitt | Kentucky | 21025 | 2046 | 30 |
1887196 | 1887196 | 2021-11-05 | Cayey | Puerto Rico | 72035 | 2046 | |
1873972 | 1873972 | 2021-11-01 | Noble | Ohio | 39121 | 2046 | 47 |
1855360 | 1855360 | 2021-10-26 | Martinsville city | Virginia | 51690 | 2046 | 89 |
1840934 | 1840934 | 2021-10-22 | Pemiscot | Missouri | 29155 | 2046 | 43 |
1831028 | 1831028 | 2021-10-19 | Amite | Mississippi | 28005 | 2046 | 55 |
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);