ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
194 rows where cases = 2914 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Arkansas 23
- Kentucky 14
- Michigan 14
- Iowa 9
- Tennessee 9
- Oklahoma 8
- West Virginia 8
- Indiana 7
- Illinois 6
- Missouri 6
- Ohio 6
- Texas 6
- Virginia 6
- Washington 6
- Mississippi 5
- South Dakota 5
- Wisconsin 5
- Florida 4
- Georgia 4
- Minnesota 4
- Pennsylvania 4
- Puerto Rico 4
- Colorado 3
- Idaho 3
- Oregon 3
- Wyoming 3
- Alabama 2
- California 2
- Kansas 2
- Louisiana 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493307 | 2493307 | 2022-05-11 | Archuleta | Colorado | 8007 | 2914 | 16 |
2470434 | 2470434 | 2022-05-04 | Stone | Arkansas | 5137 | 2914 | 68 |
2467178 | 2467178 | 2022-05-03 | Stone | Arkansas | 5137 | 2914 | 68 |
2463923 | 2463923 | 2022-05-02 | Stone | Arkansas | 5137 | 2914 | 68 |
2460667 | 2460667 | 2022-05-01 | Stone | Arkansas | 5137 | 2914 | 68 |
2457411 | 2457411 | 2022-04-30 | Stone | Arkansas | 5137 | 2914 | 68 |
2454155 | 2454155 | 2022-04-29 | Stone | Arkansas | 5137 | 2914 | 68 |
2450899 | 2450899 | 2022-04-28 | Stone | Arkansas | 5137 | 2914 | 68 |
2447643 | 2447643 | 2022-04-27 | Stone | Arkansas | 5137 | 2914 | 68 |
2444387 | 2444387 | 2022-04-26 | Stone | Arkansas | 5137 | 2914 | 68 |
2445510 | 2445510 | 2022-04-26 | Missaukee | Michigan | 26113 | 2914 | 60 |
2441131 | 2441131 | 2022-04-25 | Stone | Arkansas | 5137 | 2914 | 67 |
2442254 | 2442254 | 2022-04-25 | Missaukee | Michigan | 26113 | 2914 | 60 |
2437875 | 2437875 | 2022-04-24 | Stone | Arkansas | 5137 | 2914 | 67 |
2438998 | 2438998 | 2022-04-24 | Missaukee | Michigan | 26113 | 2914 | 60 |
2434619 | 2434619 | 2022-04-23 | Stone | Arkansas | 5137 | 2914 | 67 |
2435742 | 2435742 | 2022-04-23 | Missaukee | Michigan | 26113 | 2914 | 60 |
2436801 | 2436801 | 2022-04-23 | Comerio | Puerto Rico | 72045 | 2914 | |
2431363 | 2431363 | 2022-04-22 | Stone | Arkansas | 5137 | 2914 | 67 |
2432486 | 2432486 | 2022-04-22 | Missaukee | Michigan | 26113 | 2914 | 60 |
2428107 | 2428107 | 2022-04-21 | Stone | Arkansas | 5137 | 2914 | 67 |
2429230 | 2429230 | 2022-04-21 | Missaukee | Michigan | 26113 | 2914 | 60 |
2424851 | 2424851 | 2022-04-20 | Stone | Arkansas | 5137 | 2914 | 67 |
2425974 | 2425974 | 2022-04-20 | Missaukee | Michigan | 26113 | 2914 | 60 |
2421595 | 2421595 | 2022-04-19 | Stone | Arkansas | 5137 | 2914 | 67 |
2317109 | 2317109 | 2022-03-17 | Jefferson | Washington | 53031 | 2914 | 28 |
2313856 | 2313856 | 2022-03-16 | Jefferson | Washington | 53031 | 2914 | 28 |
2264469 | 2264469 | 2022-03-01 | Charles Mix | South Dakota | 46023 | 2914 | 33 |
2228644 | 2228644 | 2022-02-18 | Villalba | Puerto Rico | 72149 | 2914 | |
2205480 | 2205480 | 2022-02-11 | Barnes | North Dakota | 38003 | 2914 | 46 |
2193826 | 2193826 | 2022-02-08 | Bradley | Arkansas | 5011 | 2914 | 43 |
2193928 | 2193928 | 2022-02-08 | Plumas | California | 6063 | 2914 | 13 |
2164061 | 2164061 | 2022-01-29 | Zapata | Texas | 48505 | 2914 | 47 |
2143780 | 2143780 | 2022-01-23 | Morgan | Ohio | 39115 | 2914 | 48 |
2132166 | 2132166 | 2022-01-20 | Gunnison | Colorado | 8051 | 2914 | 13 |
2113583 | 2113583 | 2022-01-14 | Washington | Maine | 23029 | 2914 | 42 |
2084676 | 2084676 | 2022-01-05 | Livingston | Missouri | 29117 | 2914 | 81 |
2086016 | 2086016 | 2022-01-05 | San Juan | Utah | 49037 | 2914 | 46 |
2061035 | 2061035 | 2021-12-29 | Piatt | Illinois | 17147 | 2914 | 22 |
2054976 | 2054976 | 2021-12-27 | Union | Kentucky | 21225 | 2914 | 46 |
2034991 | 2034991 | 2021-12-21 | Ford | Illinois | 17053 | 2914 | 67 |
2017396 | 2017396 | 2021-12-15 | Cannon | Tennessee | 47015 | 2914 | 45 |
2014347 | 2014347 | 2021-12-14 | Houston | Texas | 48225 | 2914 | 88 |
1996407 | 1996407 | 2021-12-09 | Henry | Kentucky | 21103 | 2914 | 35 |
1989681 | 1989681 | 2021-12-07 | Fayette | Iowa | 19065 | 2914 | 56 |
1986431 | 1986431 | 2021-12-06 | Fayette | Iowa | 19065 | 2914 | 56 |
1983181 | 1983181 | 2021-12-05 | Fayette | Iowa | 19065 | 2914 | 56 |
1983600 | 1983600 | 2021-12-05 | Antrim | Michigan | 26009 | 2914 | 43 |
1979931 | 1979931 | 2021-12-04 | Fayette | Iowa | 19065 | 2914 | 56 |
1980350 | 1980350 | 2021-12-04 | Antrim | Michigan | 26009 | 2914 | 43 |
1976681 | 1976681 | 2021-12-03 | Fayette | Iowa | 19065 | 2914 | 56 |
1977100 | 1977100 | 2021-12-03 | Antrim | Michigan | 26009 | 2914 | 43 |
1973279 | 1973279 | 2021-12-02 | Pike | Illinois | 17149 | 2914 | 61 |
1973432 | 1973432 | 2021-12-02 | Fayette | Iowa | 19065 | 2914 | 56 |
1970182 | 1970182 | 2021-12-01 | Fayette | Iowa | 19065 | 2914 | 56 |
1921229 | 1921229 | 2021-11-16 | Hancock | Illinois | 17067 | 2914 | 45 |
1922793 | 1922793 | 2021-11-16 | McIntosh | Oklahoma | 40091 | 2914 | 94 |
1919544 | 1919544 | 2021-11-15 | McIntosh | Oklahoma | 40091 | 2914 | 94 |
1916294 | 1916294 | 2021-11-14 | McIntosh | Oklahoma | 40091 | 2914 | 94 |
1913044 | 1913044 | 2021-11-13 | McIntosh | Oklahoma | 40091 | 2914 | 94 |
1909486 | 1909486 | 2021-11-12 | Seneca | New York | 36099 | 2914 | 65 |
1909794 | 1909794 | 2021-11-12 | McIntosh | Oklahoma | 40091 | 2914 | 94 |
1906545 | 1906545 | 2021-11-11 | McIntosh | Oklahoma | 40091 | 2914 | 94 |
1907407 | 1907407 | 2021-11-11 | Asotin | Washington | 53003 | 2914 | 50 |
1903296 | 1903296 | 2021-11-10 | McIntosh | Oklahoma | 40091 | 2914 | 94 |
1904158 | 1904158 | 2021-11-10 | Asotin | Washington | 53003 | 2914 | 50 |
1892435 | 1892435 | 2021-11-07 | Morgan | Kentucky | 21175 | 2914 | 10 |
1889185 | 1889185 | 2021-11-06 | Morgan | Kentucky | 21175 | 2914 | 10 |
1885935 | 1885935 | 2021-11-05 | Morgan | Kentucky | 21175 | 2914 | 10 |
1872592 | 1872592 | 2021-11-01 | Jay | Indiana | 18075 | 2914 | 52 |
1848351 | 1848351 | 2021-10-24 | Hughes | South Dakota | 46065 | 2914 | 44 |
1845101 | 1845101 | 2021-10-23 | Hughes | South Dakota | 46065 | 2914 | 44 |
1841851 | 1841851 | 2021-10-22 | Hughes | South Dakota | 46065 | 2914 | 44 |
1831198 | 1831198 | 2021-10-19 | Ray | Missouri | 29177 | 2914 | 50 |
1829129 | 1829129 | 2021-10-18 | Lee | Texas | 48287 | 2914 | 49 |
1813836 | 1813836 | 2021-10-14 | Jeff Davis | Georgia | 13161 | 2914 | 56 |
1803585 | 1803585 | 2021-10-10 | Vilas | Wisconsin | 55125 | 2914 | 50 |
1800336 | 1800336 | 2021-10-09 | Vilas | Wisconsin | 55125 | 2914 | 50 |
1797087 | 1797087 | 2021-10-08 | Vilas | Wisconsin | 55125 | 2914 | 50 |
1785740 | 1785740 | 2021-10-05 | Big Horn | Montana | 30003 | 2914 | 81 |
1768467 | 1768467 | 2021-09-30 | Minidoka | Idaho | 16067 | 2914 | 39 |
1725671 | 1725671 | 2021-09-17 | Henry | Alabama | 1067 | 2914 | 55 |
1716510 | 1716510 | 2021-09-14 | Crawford | Illinois | 17033 | 2914 | 46 |
1716975 | 1716975 | 2021-09-14 | Meade | Kentucky | 21163 | 2914 | 30 |
1715015 | 1715015 | 2021-09-13 | Juncos | Puerto Rico | 72077 | 2914 | |
1712393 | 1712393 | 2021-09-12 | Lee | Virginia | 51105 | 2914 | 50 |
1709146 | 1709146 | 2021-09-11 | Lee | Virginia | 51105 | 2914 | 50 |
1705899 | 1705899 | 2021-09-10 | Lee | Virginia | 51105 | 2914 | 50 |
1698772 | 1698772 | 2021-09-08 | Humacao | Puerto Rico | 72069 | 2914 | |
1669228 | 1669228 | 2021-08-30 | Adams | Ohio | 39001 | 2914 | 60 |
1666015 | 1666015 | 2021-08-29 | Henry | Ohio | 39069 | 2914 | 68 |
1667165 | 1667165 | 2021-08-29 | Uinta | Wyoming | 56041 | 2914 | 14 |
1663917 | 1663917 | 2021-08-28 | Uinta | Wyoming | 56041 | 2914 | 14 |
1660669 | 1660669 | 2021-08-27 | Uinta | Wyoming | 56041 | 2914 | 14 |
1653004 | 1653004 | 2021-08-25 | Coshocton | Ohio | 39031 | 2914 | 63 |
1630895 | 1630895 | 2021-08-18 | Gillespie | Texas | 48171 | 2914 | 56 |
1626031 | 1626031 | 2021-08-17 | Ohio | Kentucky | 21183 | 2914 | 57 |
1618607 | 1618607 | 2021-08-15 | Ouachita | Arkansas | 5103 | 2914 | 67 |
1621557 | 1621557 | 2021-08-15 | Hancock | West Virginia | 54029 | 2914 | 90 |
1618309 | 1618309 | 2021-08-14 | Hancock | West Virginia | 54029 | 2914 | 90 |
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);