ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
233 rows where cases = 2261 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 32
- Kentucky 17
- Mississippi 15
- Arkansas 13
- Texas 12
- Missouri 11
- West Virginia 11
- Georgia 10
- Virginia 10
- North Carolina 9
- Indiana 8
- Kansas 8
- California 6
- Idaho 6
- Alabama 5
- Illinois 5
- Louisiana 4
- Montana 4
- Ohio 4
- Puerto Rico 4
- Utah 4
- Colorado 3
- Michigan 3
- Pennsylvania 3
- Wisconsin 3
- Florida 2
- Maryland 2
- Minnesota 2
- North Dakota 2
- Oklahoma 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2461419 | 2461419 | 2022-05-01 | Grant | Kansas | 20067 | 2261 | 36 |
2458163 | 2458163 | 2022-04-30 | Grant | Kansas | 20067 | 2261 | 36 |
2454907 | 2454907 | 2022-04-29 | Grant | Kansas | 20067 | 2261 | 36 |
2451651 | 2451651 | 2022-04-28 | Grant | Kansas | 20067 | 2261 | 36 |
2448395 | 2448395 | 2022-04-27 | Grant | Kansas | 20067 | 2261 | 36 |
2445139 | 2445139 | 2022-04-26 | Grant | Kansas | 20067 | 2261 | 36 |
2440072 | 2440072 | 2022-04-24 | Jayuya | Puerto Rico | 72073 | 2261 | |
2440666 | 2440666 | 2022-04-24 | Essex | Virginia | 51057 | 2261 | 33 |
2440852 | 2440852 | 2022-04-24 | Webster | West Virginia | 54101 | 2261 | 33 |
2437410 | 2437410 | 2022-04-23 | Essex | Virginia | 51057 | 2261 | 33 |
2437596 | 2437596 | 2022-04-23 | Webster | West Virginia | 54101 | 2261 | 33 |
2431307 | 2431307 | 2022-04-22 | Cleveland | Arkansas | 5025 | 2261 | 36 |
2434154 | 2434154 | 2022-04-22 | Essex | Virginia | 51057 | 2261 | 33 |
2434340 | 2434340 | 2022-04-22 | Webster | West Virginia | 54101 | 2261 | 33 |
2428051 | 2428051 | 2022-04-21 | Cleveland | Arkansas | 5025 | 2261 | 36 |
2431084 | 2431084 | 2022-04-21 | Webster | West Virginia | 54101 | 2261 | 33 |
2424795 | 2424795 | 2022-04-20 | Cleveland | Arkansas | 5025 | 2261 | 36 |
2427828 | 2427828 | 2022-04-20 | Webster | West Virginia | 54101 | 2261 | 33 |
2421539 | 2421539 | 2022-04-19 | Cleveland | Arkansas | 5025 | 2261 | 36 |
2424572 | 2424572 | 2022-04-19 | Webster | West Virginia | 54101 | 2261 | 33 |
2369637 | 2369637 | 2022-04-03 | San Miguel | Colorado | 8113 | 2261 | 8 |
2356623 | 2356623 | 2022-03-30 | San Miguel | Colorado | 8113 | 2261 | 8 |
2356073 | 2356073 | 2022-03-29 | Madison | Virginia | 51113 | 2261 | 37 |
2330772 | 2330772 | 2022-03-22 | Lanier | Georgia | 13173 | 2261 | 22 |
2327520 | 2327520 | 2022-03-21 | Lanier | Georgia | 13173 | 2261 | 22 |
2303912 | 2303912 | 2022-03-13 | Grand | Utah | 49019 | 2261 | 6 |
2300660 | 2300660 | 2022-03-12 | Grand | Utah | 49019 | 2261 | 6 |
2297408 | 2297408 | 2022-03-11 | Grand | Utah | 49019 | 2261 | 6 |
2290675 | 2290675 | 2022-03-09 | Castro | Texas | 48069 | 2261 | 46 |
2283453 | 2283453 | 2022-03-07 | Graham | North Carolina | 37075 | 2261 | 30 |
2284330 | 2284330 | 2022-03-07 | Red River | Texas | 48387 | 2261 | 64 |
2278832 | 2278832 | 2022-03-06 | Clearwater | Idaho | 16035 | 2261 | 31 |
2278851 | 2278851 | 2022-03-06 | Owyhee | Idaho | 16073 | 2261 | 52 |
2275579 | 2275579 | 2022-03-05 | Clearwater | Idaho | 16035 | 2261 | 31 |
2275598 | 2275598 | 2022-03-05 | Owyhee | Idaho | 16073 | 2261 | 52 |
2272326 | 2272326 | 2022-03-04 | Clearwater | Idaho | 16035 | 2261 | 31 |
2272345 | 2272345 | 2022-03-04 | Owyhee | Idaho | 16073 | 2261 | 52 |
2264805 | 2264805 | 2022-03-01 | Parmer | Texas | 48369 | 2261 | 51 |
2258917 | 2258917 | 2022-02-28 | Scott | Arkansas | 5127 | 2261 | 38 |
2255666 | 2255666 | 2022-02-27 | Scott | Arkansas | 5127 | 2261 | 38 |
2252415 | 2252415 | 2022-02-26 | Scott | Arkansas | 5127 | 2261 | 38 |
2251817 | 2251817 | 2022-02-25 | Runnels | Texas | 48399 | 2261 | 62 |
2226091 | 2226091 | 2022-02-17 | Clay | West Virginia | 54015 | 2261 | 35 |
2201001 | 2201001 | 2022-02-10 | Switzerland | Indiana | 18155 | 2261 | 16 |
2196969 | 2196969 | 2022-02-09 | Bullock | Alabama | 1011 | 2261 | 49 |
2194546 | 2194546 | 2022-02-08 | Guthrie | Iowa | 19077 | 2261 | 42 |
2191292 | 2191292 | 2022-02-07 | Guthrie | Iowa | 19077 | 2261 | 42 |
2187733 | 2187733 | 2022-02-06 | Towns | Georgia | 13281 | 2261 | 95 |
2188039 | 2188039 | 2022-02-06 | Guthrie | Iowa | 19077 | 2261 | 42 |
2188299 | 2188299 | 2022-02-06 | Owen | Kentucky | 21187 | 2261 | 30 |
2184480 | 2184480 | 2022-02-05 | Towns | Georgia | 13281 | 2261 | 95 |
2184786 | 2184786 | 2022-02-05 | Guthrie | Iowa | 19077 | 2261 | 42 |
2185046 | 2185046 | 2022-02-05 | Owen | Kentucky | 21187 | 2261 | 30 |
2181228 | 2181228 | 2022-02-04 | Towns | Georgia | 13281 | 2261 | 95 |
2181534 | 2181534 | 2022-02-04 | Guthrie | Iowa | 19077 | 2261 | 42 |
2181794 | 2181794 | 2022-02-04 | Owen | Kentucky | 21187 | 2261 | 30 |
2178283 | 2178283 | 2022-02-03 | Guthrie | Iowa | 19077 | 2261 | 42 |
2175030 | 2175030 | 2022-02-02 | Guthrie | Iowa | 19077 | 2261 | 42 |
2148996 | 2148996 | 2022-01-25 | Franklin | Iowa | 19069 | 2261 | 36 |
2145744 | 2145744 | 2022-01-24 | Franklin | Iowa | 19069 | 2261 | 36 |
2142489 | 2142489 | 2022-01-23 | Franklin | Iowa | 19069 | 2261 | 36 |
2139234 | 2139234 | 2022-01-22 | Franklin | Iowa | 19069 | 2261 | 36 |
2140757 | 2140757 | 2022-01-22 | Ciales | Puerto Rico | 72039 | 2261 | |
2135978 | 2135978 | 2022-01-21 | Franklin | Iowa | 19069 | 2261 | 36 |
2132726 | 2132726 | 2022-01-20 | Franklin | Iowa | 19069 | 2261 | 36 |
2129473 | 2129473 | 2022-01-19 | Franklin | Iowa | 19069 | 2261 | 36 |
2128619 | 2128619 | 2022-01-18 | Big Horn | Wyoming | 56003 | 2261 | 60 |
2123639 | 2123639 | 2022-01-17 | Barton | Missouri | 29011 | 2261 | 42 |
2120387 | 2120387 | 2022-01-16 | Barton | Missouri | 29011 | 2261 | 42 |
2117135 | 2117135 | 2022-01-15 | Barton | Missouri | 29011 | 2261 | 42 |
2107786 | 2107786 | 2022-01-12 | Alleghany | North Carolina | 37005 | 2261 | 10 |
2104316 | 2104316 | 2022-01-11 | Colfax | Nebraska | 31037 | 2261 | 24 |
2104864 | 2104864 | 2022-01-11 | Curry | Oregon | 41015 | 2261 | 40 |
2101850 | 2101850 | 2022-01-10 | Charles Mix | South Dakota | 46023 | 2261 | 32 |
2096244 | 2096244 | 2022-01-09 | Chicot | Arkansas | 5017 | 2261 | 49 |
2092992 | 2092992 | 2022-01-08 | Chicot | Arkansas | 5017 | 2261 | 49 |
2087841 | 2087841 | 2022-01-06 | Perry | Mississippi | 28111 | 2261 | 57 |
2085125 | 2085125 | 2022-01-05 | Barnes | North Dakota | 38003 | 2261 | 40 |
2054331 | 2054331 | 2021-12-27 | Jasper | Georgia | 13159 | 2261 | 60 |
2052048 | 2052048 | 2021-12-26 | Greene | Mississippi | 28041 | 2261 | 50 |
2048798 | 2048798 | 2021-12-25 | Greene | Mississippi | 28041 | 2261 | 50 |
2045548 | 2045548 | 2021-12-24 | Greene | Mississippi | 28041 | 2261 | 50 |
2042298 | 2042298 | 2021-12-23 | Greene | Mississippi | 28041 | 2261 | 50 |
2039049 | 2039049 | 2021-12-22 | Greene | Mississippi | 28041 | 2261 | 50 |
2020206 | 2020206 | 2021-12-16 | Harrison | Ohio | 39067 | 2261 | 54 |
2017769 | 2017769 | 2021-12-15 | Addison | Vermont | 50001 | 2261 | 10 |
1998360 | 1998360 | 2021-12-09 | Martinsville city | Virginia | 51690 | 2261 | 94 |
1989713 | 1989713 | 2021-12-07 | Mills | Iowa | 19129 | 2261 | 30 |
1986463 | 1986463 | 2021-12-06 | Mills | Iowa | 19129 | 2261 | 30 |
1983213 | 1983213 | 2021-12-05 | Mills | Iowa | 19129 | 2261 | 30 |
1979963 | 1979963 | 2021-12-04 | Mills | Iowa | 19129 | 2261 | 30 |
1976713 | 1976713 | 2021-12-03 | Mills | Iowa | 19129 | 2261 | 30 |
1973102 | 1973102 | 2021-12-02 | Oglethorpe | Georgia | 13221 | 2261 | 43 |
1973464 | 1973464 | 2021-12-02 | Mills | Iowa | 19129 | 2261 | 30 |
1975733 | 1975733 | 2021-12-02 | Monroe | West Virginia | 54063 | 2261 | 27 |
1970214 | 1970214 | 2021-12-01 | Mills | Iowa | 19129 | 2261 | 30 |
1964195 | 1964195 | 2021-11-29 | Cottonwood | Minnesota | 27033 | 2261 | 32 |
1944012 | 1944012 | 2021-11-23 | Mercer | Illinois | 17131 | 2261 | 37 |
1938501 | 1938501 | 2021-11-21 | Roosevelt | Montana | 30085 | 2261 | 60 |
1935251 | 1935251 | 2021-11-20 | Roosevelt | Montana | 30085 | 2261 | 60 |
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);