ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where cases = 4822 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Georgia 14
- Louisiana 8
- Alabama 6
- Colorado 5
- Illinois 5
- Michigan 5
- New York 5
- North Carolina 5
- Texas 5
- West Virginia 5
- Arkansas 4
- Indiana 4
- Kentucky 4
- California 3
- Missouri 3
- Ohio 3
- Tennessee 3
- Virginia 3
- Wisconsin 3
- Idaho 2
- Pennsylvania 2
- Florida 1
- Minnesota 1
- New Mexico 1
- North Dakota 1
- Oregon 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473676 | 2473676 | 2022-05-05 | Phillips | Arkansas | 5107 | 4822 | 99 |
2473778 | 2473778 | 2022-05-05 | Elbert | Colorado | 8039 | 4822 | 40 |
2476620 | 2476620 | 2022-05-05 | Barbour | West Virginia | 54001 | 4822 | 73 |
2301634 | 2301634 | 2022-03-13 | Clark | Illinois | 17023 | 4822 | 60 |
2298382 | 2298382 | 2022-03-12 | Clark | Illinois | 17023 | 4822 | 60 |
2295130 | 2295130 | 2022-03-11 | Clark | Illinois | 17023 | 4822 | 60 |
2281985 | 2281985 | 2022-03-07 | Lamar | Georgia | 13171 | 4822 | 111 |
2262529 | 2262529 | 2022-03-01 | Union | Georgia | 13291 | 4822 | 145 |
2255956 | 2255956 | 2022-02-27 | Hart | Georgia | 13147 | 4822 | 85 |
2252705 | 2252705 | 2022-02-26 | Hart | Georgia | 13147 | 4822 | 85 |
2249454 | 2249454 | 2022-02-25 | Hart | Georgia | 13147 | 4822 | 85 |
2246203 | 2246203 | 2022-02-24 | Hart | Georgia | 13147 | 4822 | 84 |
2248771 | 2248771 | 2022-02-24 | Radford city | Virginia | 51750 | 4822 | 46 |
2220813 | 2220813 | 2022-02-16 | McCreary | Kentucky | 21147 | 4822 | 73 |
2167698 | 2167698 | 2022-01-31 | Cherokee | Alabama | 1019 | 4822 | 69 |
2164925 | 2164925 | 2022-01-30 | Mitchell | Georgia | 13205 | 4822 | 104 |
2161670 | 2161670 | 2022-01-29 | Mitchell | Georgia | 13205 | 4822 | 104 |
2158414 | 2158414 | 2022-01-28 | Mitchell | Georgia | 13205 | 4822 | 104 |
2141820 | 2141820 | 2022-01-23 | Ouachita | Arkansas | 5103 | 4822 | 92 |
2133218 | 2133218 | 2022-01-20 | Unknown | Michigan | 4822 | 21 | |
2124288 | 2124288 | 2022-01-17 | Wyandot | Ohio | 39175 | 4822 | 89 |
2086567 | 2086567 | 2022-01-06 | Glenn | California | 6021 | 4822 | 54 |
2086630 | 2086630 | 2022-01-06 | Delta | Colorado | 8029 | 4822 | 123 |
2063293 | 2063293 | 2021-12-29 | Amherst | Virginia | 51009 | 4822 | 63 |
2036330 | 2036330 | 2021-12-21 | Montgomery | North Carolina | 37123 | 4822 | 110 |
2018695 | 2018695 | 2021-12-16 | Latah | Idaho | 16057 | 4822 | 41 |
2009480 | 2009480 | 2021-12-13 | Allen | Louisiana | 22003 | 4822 | 118 |
2010502 | 2010502 | 2021-12-13 | Van Wert | Ohio | 39161 | 4822 | 98 |
1960737 | 1960737 | 2021-11-28 | De Soto | Louisiana | 22031 | 4822 | 113 |
1957486 | 1957486 | 2021-11-27 | De Soto | Louisiana | 22031 | 4822 | 113 |
1954235 | 1954235 | 2021-11-26 | De Soto | Louisiana | 22031 | 4822 | 113 |
1950984 | 1950984 | 2021-11-25 | De Soto | Louisiana | 22031 | 4822 | 113 |
1947733 | 1947733 | 2021-11-24 | De Soto | Louisiana | 22031 | 4822 | 113 |
1944482 | 1944482 | 2021-11-23 | De Soto | Louisiana | 22031 | 4822 | 113 |
1924277 | 1924277 | 2021-11-17 | Decatur | Georgia | 13087 | 4822 | 103 |
1923400 | 1923400 | 2021-11-16 | Palo Pinto | Texas | 48363 | 4822 | 120 |
1917356 | 1917356 | 2021-11-15 | Clarke | Alabama | 1025 | 4822 | 86 |
1914106 | 1914106 | 2021-11-14 | Clarke | Alabama | 1025 | 4822 | 86 |
1910856 | 1910856 | 2021-11-13 | Clarke | Alabama | 1025 | 4822 | 86 |
1905064 | 1905064 | 2021-11-11 | Daviess | Indiana | 18027 | 4822 | 118 |
1899728 | 1899728 | 2021-11-09 | Orleans | New York | 36073 | 4822 | 93 |
1882114 | 1882114 | 2021-11-04 | Stephens | Georgia | 13257 | 4822 | 110 |
1882641 | 1882641 | 2021-11-04 | Grayson | Kentucky | 21085 | 4822 | 93 |
1868905 | 1868905 | 2021-10-31 | Summit | Colorado | 8117 | 4822 | 11 |
1865656 | 1865656 | 2021-10-30 | Summit | Colorado | 8117 | 4822 | 11 |
1862407 | 1862407 | 2021-10-29 | Summit | Colorado | 8117 | 4822 | 11 |
1841434 | 1841434 | 2021-10-22 | Coshocton | Ohio | 39031 | 4822 | 83 |
1806891 | 1806891 | 2021-10-12 | Dallas | Alabama | 1047 | 4822 | 195 |
1779483 | 1779483 | 2021-10-03 | Columbia | New York | 36021 | 4822 | 110 |
1760802 | 1760802 | 2021-09-27 | Cooke | Texas | 48097 | 4822 | 86 |
1757554 | 1757554 | 2021-09-26 | Cooke | Texas | 48097 | 4822 | 86 |
1754306 | 1754306 | 2021-09-25 | Cooke | Texas | 48097 | 4822 | 86 |
1740221 | 1740221 | 2021-09-21 | Pulaski | Missouri | 29169 | 4822 | 69 |
1605593 | 1605593 | 2021-08-11 | Independence | Arkansas | 5063 | 4822 | 131 |
1597286 | 1597286 | 2021-08-08 | Platte | Missouri | 29165 | 4822 | 53 |
1598827 | 1598827 | 2021-08-08 | Marion | West Virginia | 54049 | 4822 | 55 |
1595578 | 1595578 | 2021-08-07 | Marion | West Virginia | 54049 | 4822 | 55 |
1592329 | 1592329 | 2021-08-06 | Marion | West Virginia | 54049 | 4822 | 55 |
1579514 | 1579514 | 2021-08-03 | Russell | Alabama | 1113 | 4822 | 43 |
1573076 | 1573076 | 2021-08-01 | Boone | Arkansas | 5009 | 4822 | 84 |
1540355 | 1540355 | 2021-07-21 | Jefferson | West Virginia | 54037 | 4822 | 60 |
1532654 | 1532654 | 2021-07-19 | Beaufort | North Carolina | 37013 | 4822 | 103 |
1508764 | 1508764 | 2021-07-12 | Lawrence | Indiana | 18093 | 4822 | 128 |
1474565 | 1474565 | 2021-07-01 | Yamhill | Oregon | 41071 | 4822 | 79 |
1400856 | 1400856 | 2021-06-08 | Polk | Wisconsin | 55095 | 4822 | 61 |
1376888 | 1376888 | 2021-06-01 | Hoke | North Carolina | 37093 | 4822 | 56 |
1360059 | 1360059 | 2021-05-27 | Goodhue | Minnesota | 27049 | 4822 | 72 |
1318550 | 1318550 | 2021-05-14 | Stark | North Dakota | 38089 | 4822 | 51 |
1303436 | 1303436 | 2021-05-09 | Douglas | Wisconsin | 55031 | 4822 | 54 |
1300189 | 1300189 | 2021-05-08 | Douglas | Wisconsin | 55031 | 4822 | 54 |
1257108 | 1257108 | 2021-04-25 | Huntingdon | Pennsylvania | 42061 | 4822 | 128 |
1233175 | 1233175 | 2021-04-18 | Nelson | Kentucky | 21179 | 4822 | 51 |
1229927 | 1229927 | 2021-04-17 | Nelson | Kentucky | 21179 | 4822 | 51 |
1209989 | 1209989 | 2021-04-11 | Jackson | Illinois | 17077 | 4822 | 74 |
1195659 | 1195659 | 2021-04-06 | Fayette | Tennessee | 47047 | 4822 | 77 |
1182903 | 1182903 | 2021-04-02 | Medina | Texas | 48325 | 4822 | 103 |
1134504 | 1134504 | 2021-03-18 | Walla Walla | Washington | 53071 | 4822 | 64 |
1130099 | 1130099 | 2021-03-17 | Edgecombe | North Carolina | 37065 | 4822 | 100 |
1100493 | 1100493 | 2021-03-08 | Johnson | Missouri | 29101 | 4822 | 45 |
1087855 | 1087855 | 2021-03-04 | Sullivan | New York | 36105 | 4822 | 60 |
1006119 | 1006119 | 2021-02-07 | Midland | Michigan | 26111 | 4822 | 61 |
1002873 | 1002873 | 2021-02-06 | Midland | Michigan | 26111 | 4822 | 61 |
995731 | 995731 | 2021-02-04 | Knox | Illinois | 17095 | 4822 | 150 |
997026 | 997026 | 2021-02-04 | Granville | North Carolina | 37077 | 4822 | 74 |
992295 | 992295 | 2021-02-03 | Habersham | Georgia | 13137 | 4822 | 125 |
919470 | 919470 | 2021-01-11 | Clearfield | Pennsylvania | 42033 | 4822 | 57 |
913277 | 913277 | 2021-01-09 | Lawrence | Tennessee | 47099 | 4822 | 66 |
900248 | 900248 | 2021-01-05 | Bedford | Tennessee | 47003 | 4822 | 69 |
872106 | 872106 | 2020-12-28 | Highlands | Florida | 12055 | 4822 | 199 |
836766 | 836766 | 2020-12-17 | Bartholomew | Indiana | 18005 | 4822 | 82 |
791181 | 791181 | 2020-12-03 | Bannock | Idaho | 16005 | 4822 | 35 |
745941 | 745941 | 2020-11-19 | Monroe | Indiana | 18105 | 4822 | 47 |
747032 | 747032 | 2020-11-19 | Albany | New York | 36001 | 4822 | 136 |
726127 | 726127 | 2020-11-13 | Carroll | Georgia | 13045 | 4822 | 90 |
695110 | 695110 | 2020-11-03 | McKinley | New Mexico | 35031 | 4822 | 262 |
662159 | 662159 | 2020-10-24 | Ottawa | Michigan | 26139 | 4822 | 72 |
631844 | 631844 | 2020-10-15 | Madera | California | 6039 | 4822 | 73 |
629567 | 629567 | 2020-10-14 | Tangipahoa | Louisiana | 22105 | 4822 | 122 |
573045 | 573045 | 2020-09-26 | Norfolk city | Virginia | 51710 | 4822 | 78 |
400653 | 400653 | 2020-08-04 | Monroe | New York | 36055 | 4822 | 269 |
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);