ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
426 rows where cases = 1034 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 33
- Georgia 25
- Iowa 21
- Virginia 21
- Kentucky 20
- South Dakota 20
- Tennessee 20
- Missouri 19
- North Carolina 15
- Mississippi 14
- Kansas 12
- Oklahoma 12
- Colorado 11
- North Dakota 11
- Puerto Rico 11
- Arkansas 10
- Ohio 10
- Illinois 9
- Indiana 9
- Louisiana 9
- Nebraska 9
- Alabama 8
- Idaho 7
- Minnesota 7
- Pennsylvania 7
- Washington 7
- Wisconsin 7
- Vermont 6
- West Virginia 6
- Alaska 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2472439 | 2472439 | 2022-05-04 | Grant | Oklahoma | 40053 | 1034 | 16 |
2469183 | 2469183 | 2022-05-03 | Grant | Oklahoma | 40053 | 1034 | 16 |
2465927 | 2465927 | 2022-05-02 | Grant | Oklahoma | 40053 | 1034 | 16 |
2462672 | 2462672 | 2022-05-01 | Grant | Oklahoma | 40053 | 1034 | 16 |
2459416 | 2459416 | 2022-04-30 | Grant | Oklahoma | 40053 | 1034 | 16 |
2456160 | 2456160 | 2022-04-29 | Grant | Oklahoma | 40053 | 1034 | 16 |
2452904 | 2452904 | 2022-04-28 | Grant | Oklahoma | 40053 | 1034 | 16 |
2419568 | 2419568 | 2022-04-18 | Unknown | Minnesota | 1034 | 250 | |
2395037 | 2395037 | 2022-04-10 | Grand Isle | Vermont | 50013 | 1034 | 5 |
2391781 | 2391781 | 2022-04-09 | Grand Isle | Vermont | 50013 | 1034 | 5 |
2388525 | 2388525 | 2022-04-08 | Grand Isle | Vermont | 50013 | 1034 | 5 |
2375511 | 2375511 | 2022-04-04 | Unknown | Vermont | 1034 | 2 | |
2338824 | 2338824 | 2022-03-24 | Dunn | North Dakota | 38025 | 1034 | 8 |
2335570 | 2335570 | 2022-03-23 | Dunn | North Dakota | 38025 | 1034 | 8 |
2332316 | 2332316 | 2022-03-22 | Dunn | North Dakota | 38025 | 1034 | 8 |
2329063 | 2329063 | 2022-03-21 | Dunn | North Dakota | 38025 | 1034 | 8 |
2325811 | 2325811 | 2022-03-20 | Dunn | North Dakota | 38025 | 1034 | 8 |
2322558 | 2322558 | 2022-03-19 | Dunn | North Dakota | 38025 | 1034 | 8 |
2319304 | 2319304 | 2022-03-18 | Dunn | North Dakota | 38025 | 1034 | 8 |
2305635 | 2305635 | 2022-03-14 | Kittson | Minnesota | 27069 | 1034 | 27 |
2303505 | 2303505 | 2022-03-13 | Deuel | South Dakota | 46039 | 1034 | 12 |
2300253 | 2300253 | 2022-03-12 | Deuel | South Dakota | 46039 | 1034 | 12 |
2297001 | 2297001 | 2022-03-11 | Deuel | South Dakota | 46039 | 1034 | 12 |
2293749 | 2293749 | 2022-03-10 | Deuel | South Dakota | 46039 | 1034 | 12 |
2290497 | 2290497 | 2022-03-09 | Deuel | South Dakota | 46039 | 1034 | 12 |
2287245 | 2287245 | 2022-03-08 | Deuel | South Dakota | 46039 | 1034 | 12 |
2283993 | 2283993 | 2022-03-07 | Deuel | South Dakota | 46039 | 1034 | 12 |
2278563 | 2278563 | 2022-03-06 | Washington | Colorado | 8121 | 1034 | 26 |
2280741 | 2280741 | 2022-03-06 | Deuel | South Dakota | 46039 | 1034 | 12 |
2275310 | 2275310 | 2022-03-05 | Washington | Colorado | 8121 | 1034 | 26 |
2277488 | 2277488 | 2022-03-05 | Deuel | South Dakota | 46039 | 1034 | 12 |
2272057 | 2272057 | 2022-03-04 | Washington | Colorado | 8121 | 1034 | 26 |
2274235 | 2274235 | 2022-03-04 | Deuel | South Dakota | 46039 | 1034 | 12 |
2257165 | 2257165 | 2022-02-27 | Antelope | Nebraska | 31003 | 1034 | 13 |
2253914 | 2253914 | 2022-02-26 | Antelope | Nebraska | 31003 | 1034 | 13 |
2250663 | 2250663 | 2022-02-25 | Antelope | Nebraska | 31003 | 1034 | 13 |
2247412 | 2247412 | 2022-02-24 | Antelope | Nebraska | 31003 | 1034 | 13 |
2240910 | 2240910 | 2022-02-22 | Antelope | Nebraska | 31003 | 1034 | 13 |
2237659 | 2237659 | 2022-02-21 | Antelope | Nebraska | 31003 | 1034 | 13 |
2229063 | 2229063 | 2022-02-18 | San Augustine | Texas | 48405 | 1034 | 40 |
2224633 | 2224633 | 2022-02-17 | Phillips | Montana | 30071 | 1034 | 28 |
2221273 | 2221273 | 2022-02-16 | Holt | Missouri | 29087 | 1034 | 26 |
2213866 | 2213866 | 2022-02-14 | Hardin | Illinois | 17069 | 1034 | 18 |
2208766 | 2208766 | 2022-02-12 | Pierce | North Dakota | 38069 | 1034 | 31 |
2196191 | 2196191 | 2022-02-08 | Corson | South Dakota | 46031 | 1034 | 16 |
2170655 | 2170655 | 2022-01-31 | Emporia city | Virginia | 51595 | 1034 | 46 |
2165022 | 2165022 | 2022-01-30 | Lewis | Idaho | 16061 | 1034 | 25 |
2161767 | 2161767 | 2022-01-29 | Lewis | Idaho | 16061 | 1034 | 25 |
2156370 | 2156370 | 2022-01-27 | Fillmore | Nebraska | 31059 | 1034 | 13 |
2145550 | 2145550 | 2022-01-24 | Henderson | Illinois | 17071 | 1034 | 24 |
2145592 | 2145592 | 2022-01-24 | Putnam | Illinois | 17155 | 1034 | 8 |
2107559 | 2107559 | 2022-01-12 | Burt | Nebraska | 31021 | 1034 | 14 |
2107703 | 2107703 | 2022-01-12 | Guadalupe | New Mexico | 35019 | 1034 | 15 |
2102699 | 2102699 | 2022-01-11 | Dillingham Census Area | Alaska | 2070 | 1034 | 10 |
2099448 | 2099448 | 2022-01-10 | Dillingham Census Area | Alaska | 2070 | 1034 | 10 |
2100994 | 2100994 | 2022-01-10 | Broadwater | Montana | 30007 | 1034 | 17 |
2095704 | 2095704 | 2022-01-08 | San Saba | Texas | 48411 | 1034 | 29 |
2087330 | 2087330 | 2022-01-06 | Morris | Kansas | 20127 | 1034 | 23 |
2088882 | 2088882 | 2022-01-06 | Moody | South Dakota | 46101 | 1034 | 25 |
2084078 | 2084078 | 2022-01-05 | Morris | Kansas | 20127 | 1034 | 23 |
2077100 | 2077100 | 2022-01-03 | Marion | Georgia | 13197 | 1034 | 41 |
2073849 | 2073849 | 2022-01-02 | Marion | Georgia | 13197 | 1034 | 41 |
2076255 | 2076255 | 2022-01-02 | Kane | Utah | 49025 | 1034 | 12 |
2070598 | 2070598 | 2022-01-01 | Marion | Georgia | 13197 | 1034 | 41 |
2073004 | 2073004 | 2022-01-01 | Kane | Utah | 49025 | 1034 | 12 |
2067347 | 2067347 | 2021-12-31 | Marion | Georgia | 13197 | 1034 | 41 |
2069753 | 2069753 | 2021-12-31 | Kane | Utah | 49025 | 1034 | 12 |
2038123 | 2038123 | 2021-12-22 | Randolph | Georgia | 13243 | 1034 | 44 |
2040083 | 2040083 | 2021-12-22 | Brule | South Dakota | 46015 | 1034 | 15 |
2034873 | 2034873 | 2021-12-21 | Randolph | Georgia | 13243 | 1034 | 44 |
2028853 | 2028853 | 2021-12-19 | Stevens | Kansas | 20189 | 1034 | 17 |
2025602 | 2025602 | 2021-12-18 | Stevens | Kansas | 20189 | 1034 | 17 |
2022351 | 2022351 | 2021-12-17 | Stevens | Kansas | 20189 | 1034 | 17 |
2019193 | 2019193 | 2021-12-16 | Menifee | Kentucky | 21165 | 1034 | 25 |
1994146 | 1994146 | 2021-12-08 | Ransom | North Dakota | 38073 | 1034 | 22 |
1994611 | 1994611 | 2021-12-08 | McCook | South Dakota | 46087 | 1034 | 28 |
1989847 | 1989847 | 2021-12-07 | Wabaunsee | Kansas | 20197 | 1034 | 19 |
1986597 | 1986597 | 2021-12-06 | Wabaunsee | Kansas | 20197 | 1034 | 19 |
1970449 | 1970449 | 2021-12-01 | Owsley | Kentucky | 21189 | 1034 | 21 |
1967199 | 1967199 | 2021-11-30 | Owsley | Kentucky | 21189 | 1034 | 21 |
1949005 | 1949005 | 2021-11-24 | Villalba | Puerto Rico | 72149 | 1034 | |
1942773 | 1942773 | 2021-11-22 | Crosby | Texas | 48107 | 1034 | 37 |
1939523 | 1939523 | 2021-11-21 | Crosby | Texas | 48107 | 1034 | 37 |
1936273 | 1936273 | 2021-11-20 | Crosby | Texas | 48107 | 1034 | 37 |
1933023 | 1933023 | 2021-11-19 | Crosby | Texas | 48107 | 1034 | 37 |
1929341 | 1929341 | 2021-11-18 | Lake | Oregon | 41037 | 1034 | 15 |
1912364 | 1912364 | 2021-11-13 | Clark | Missouri | 29045 | 1034 | 12 |
1874369 | 1874369 | 2021-11-01 | Spink | South Dakota | 46115 | 1034 | 27 |
1866880 | 1866880 | 2021-10-30 | Daviess | Missouri | 29061 | 1034 | 14 |
1835354 | 1835354 | 2021-10-20 | Hutchinson | South Dakota | 46067 | 1034 | 28 |
1826986 | 1826986 | 2021-10-18 | Edwards | Illinois | 17047 | 1034 | 19 |
1797019 | 1797019 | 2021-10-08 | Webster | West Virginia | 54101 | 1034 | 16 |
1790310 | 1790310 | 2021-10-06 | Bland | Virginia | 51021 | 1034 | 14 |
1787118 | 1787118 | 2021-10-05 | Lancaster | Virginia | 51103 | 1034 | 21 |
1783869 | 1783869 | 2021-10-04 | Lancaster | Virginia | 51103 | 1034 | 21 |
1780272 | 1780272 | 2021-10-03 | Brewster | Texas | 48043 | 1034 | 19 |
1767761 | 1767761 | 2021-09-29 | Pendleton | West Virginia | 54071 | 1034 | 12 |
1743361 | 1743361 | 2021-09-22 | Quitman | Mississippi | 28119 | 1034 | 26 |
1741837 | 1741837 | 2021-09-21 | Pepin | Wisconsin | 55091 | 1034 | 7 |
1735475 | 1735475 | 2021-09-20 | Sitka City and Borough | Alaska | 2220 | 1034 | 3 |
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);