ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
94 rows where cases = 3878 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 10
- Texas 9
- Kansas 7
- Indiana 6
- Minnesota 6
- Ohio 4
- Illinois 3
- Maine 3
- Mississippi 3
- Missouri 3
- North Carolina 3
- Oregon 3
- Pennsylvania 3
- Puerto Rico 3
- South Dakota 3
- Arkansas 2
- Maryland 2
- New York 2
- Utah 2
- Virginia 2
- California 1
- Colorado 1
- Florida 1
- Idaho 1
- Kentucky 1
- Louisiana 1
- Michigan 1
- Nebraska 1
- New Hampshire 1
- New Mexico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2459944 | 2459944 | 2022-04-30 | Freestone | Texas | 48161 | 3878 | 82 |
2456688 | 2456688 | 2022-04-29 | Freestone | Texas | 48161 | 3878 | 82 |
2453432 | 2453432 | 2022-04-28 | Freestone | Texas | 48161 | 3878 | 82 |
2450176 | 2450176 | 2022-04-27 | Freestone | Texas | 48161 | 3878 | 82 |
2401548 | 2401548 | 2022-04-12 | Lamoille | Vermont | 50015 | 3878 | 17 |
2324730 | 2324730 | 2022-03-20 | Jackson | Kansas | 20085 | 3878 | 29 |
2321476 | 2321476 | 2022-03-19 | Jackson | Kansas | 20085 | 3878 | 29 |
2318222 | 2318222 | 2022-03-18 | Jackson | Kansas | 20085 | 3878 | 29 |
2314969 | 2314969 | 2022-03-17 | Jackson | Kansas | 20085 | 3878 | 29 |
2311716 | 2311716 | 2022-03-16 | Jackson | Kansas | 20085 | 3878 | 29 |
2308463 | 2308463 | 2022-03-15 | Jackson | Kansas | 20085 | 3878 | 28 |
2305212 | 2305212 | 2022-03-14 | Jackson | Kansas | 20085 | 3878 | 28 |
2288674 | 2288674 | 2022-03-09 | Mason | Illinois | 17125 | 3878 | 61 |
2274089 | 2274089 | 2022-03-04 | Aguas Buenas | Puerto Rico | 72007 | 3878 | |
2270836 | 2270836 | 2022-03-03 | Aguas Buenas | Puerto Rico | 72007 | 3878 | |
2222713 | 2222713 | 2022-02-16 | Greene | Virginia | 51079 | 3878 | 57 |
2194839 | 2194839 | 2022-02-08 | Bienville | Louisiana | 22013 | 3878 | 103 |
2185521 | 2185521 | 2022-02-05 | Morgan | Missouri | 29141 | 3878 | 93 |
2169116 | 2169116 | 2022-01-31 | Clarke | Mississippi | 28023 | 3878 | 96 |
2026150 | 2026150 | 2021-12-18 | Henry | Missouri | 29083 | 3878 | 65 |
1986063 | 1986063 | 2021-12-06 | Haralson | Georgia | 13143 | 3878 | 130 |
1960104 | 1960104 | 2021-11-28 | Pike | Georgia | 13231 | 3878 | 71 |
1956853 | 1956853 | 2021-11-27 | Pike | Georgia | 13231 | 3878 | 71 |
1953602 | 1953602 | 2021-11-26 | Pike | Georgia | 13231 | 3878 | 71 |
1950351 | 1950351 | 2021-11-25 | Pike | Georgia | 13231 | 3878 | 71 |
1947100 | 1947100 | 2021-11-24 | Pike | Georgia | 13231 | 3878 | 71 |
1929993 | 1929993 | 2021-11-18 | Sevier | Utah | 49041 | 3878 | 18 |
1914863 | 1914863 | 2021-11-14 | Posey | Indiana | 18129 | 3878 | 44 |
1911613 | 1911613 | 2021-11-13 | Posey | Indiana | 18129 | 3878 | 44 |
1908364 | 1908364 | 2021-11-12 | Posey | Indiana | 18129 | 3878 | 44 |
1884765 | 1884765 | 2021-11-04 | Door | Wisconsin | 55029 | 3878 | 41 |
1856826 | 1856826 | 2021-10-27 | Queen Anne's | Maryland | 24035 | 3878 | 72 |
1838530 | 1838530 | 2021-10-21 | Barnwell | South Carolina | 45011 | 3878 | 83 |
1816071 | 1816071 | 2021-10-14 | Frio | Texas | 48163 | 3878 | 66 |
1793548 | 1793548 | 2021-10-07 | Accomack | Virginia | 51001 | 3878 | 73 |
1756260 | 1756260 | 2021-09-26 | Nicollet | Minnesota | 27103 | 3878 | 48 |
1753012 | 1753012 | 2021-09-25 | Nicollet | Minnesota | 27103 | 3878 | 48 |
1749764 | 1749764 | 2021-09-24 | Nicollet | Minnesota | 27103 | 3878 | 48 |
1742611 | 1742611 | 2021-09-22 | Fayette | Indiana | 18041 | 3878 | 80 |
1709543 | 1709543 | 2021-09-12 | Jackson | Arkansas | 5067 | 3878 | 41 |
1679000 | 1679000 | 2021-09-02 | Guernsey | Ohio | 39059 | 3878 | 54 |
1670865 | 1670865 | 2021-08-31 | Gilmer | Georgia | 13123 | 3878 | 95 |
1668361 | 1668361 | 2021-08-30 | Oxford | Maine | 23017 | 3878 | 71 |
1665114 | 1665114 | 2021-08-29 | Oxford | Maine | 23017 | 3878 | 71 |
1661866 | 1661866 | 2021-08-28 | Oxford | Maine | 23017 | 3878 | 71 |
1633555 | 1633555 | 2021-08-19 | Ottawa | Ohio | 39123 | 3878 | 82 |
1629737 | 1629737 | 2021-08-18 | Lafayette | Missouri | 29107 | 3878 | 61 |
1623668 | 1623668 | 2021-08-16 | Person | North Carolina | 37145 | 3878 | 76 |
1578105 | 1578105 | 2021-08-02 | Tioga | New York | 36107 | 3878 | 63 |
1555309 | 1555309 | 2021-07-26 | Rio Arriba | New Mexico | 35039 | 3878 | 81 |
1552944 | 1552944 | 2021-07-25 | Grimes | Texas | 48185 | 3878 | 74 |
1549697 | 1549697 | 2021-07-24 | Grimes | Texas | 48185 | 3878 | 74 |
1496358 | 1496358 | 2021-07-08 | Becker | Minnesota | 27005 | 3878 | 56 |
1439994 | 1439994 | 2021-06-21 | Independence | Arkansas | 5063 | 3878 | 124 |
1427607 | 1427607 | 2021-06-17 | Jasper | Indiana | 18073 | 3878 | 56 |
1396192 | 1396192 | 2021-06-07 | Cheshire | New Hampshire | 33005 | 3878 | 35 |
1373945 | 1373945 | 2021-05-31 | Polk | Oregon | 41053 | 3878 | 53 |
1273376 | 1273376 | 2021-04-30 | Wayne | Pennsylvania | 42127 | 3878 | 77 |
1265350 | 1265350 | 2021-04-28 | Whitley | Indiana | 18183 | 3878 | 39 |
1249676 | 1249676 | 2021-04-23 | Isanti | Minnesota | 27059 | 3878 | 60 |
1239058 | 1239058 | 2021-04-20 | Liberty | Georgia | 13179 | 3878 | 62 |
1229119 | 1229119 | 2021-04-17 | Logan | Colorado | 8075 | 3878 | 65 |
1223713 | 1223713 | 2021-04-15 | McLeod | Minnesota | 27085 | 3878 | 54 |
1216255 | 1216255 | 2021-04-13 | Camden | Georgia | 13039 | 3878 | 32 |
1189077 | 1189077 | 2021-04-04 | Brookings | South Dakota | 46011 | 3878 | 37 |
1189435 | 1189435 | 2021-04-04 | Rusk | Texas | 48401 | 3878 | 105 |
1185613 | 1185613 | 2021-04-03 | Linn | Oregon | 41043 | 3878 | 60 |
1185830 | 1185830 | 2021-04-03 | Brookings | South Dakota | 46011 | 3878 | 37 |
1172273 | 1172273 | 2021-03-30 | Tompkins | New York | 36109 | 3878 | 49 |
1146659 | 1146659 | 2021-03-22 | Yamhill | Oregon | 41071 | 3878 | 70 |
1120691 | 1120691 | 2021-03-14 | Bedford | Pennsylvania | 42009 | 3878 | 129 |
1111083 | 1111083 | 2021-03-11 | Toa Baja | Puerto Rico | 72137 | 3878 | |
1100686 | 1100686 | 2021-03-08 | Platte | Nebraska | 31141 | 3878 | 47 |
1072479 | 1072479 | 2021-02-27 | Jim Wells | Texas | 48249 | 3878 | 82 |
1051364 | 1051364 | 2021-02-21 | Scott | Kentucky | 21209 | 3878 | 26 |
1049121 | 1049121 | 2021-02-20 | Madison | Ohio | 39097 | 3878 | 47 |
1033259 | 1033259 | 2021-02-15 | Codington | South Dakota | 46029 | 3878 | 76 |
1021689 | 1021689 | 2021-02-12 | Jefferson | Illinois | 17081 | 3878 | 114 |
1022509 | 1022509 | 2021-02-12 | Marshall | Mississippi | 28093 | 3878 | 90 |
1016027 | 1016027 | 2021-02-10 | Pearl River | Mississippi | 28109 | 3878 | 121 |
999609 | 999609 | 2021-02-05 | Isabella | Michigan | 26073 | 3878 | 70 |
997212 | 997212 | 2021-02-04 | Putnam | Ohio | 39137 | 3878 | 77 |
961959 | 961959 | 2021-01-24 | Lincoln | Tennessee | 47103 | 3878 | 47 |
917754 | 917754 | 2021-01-11 | Bingham | Idaho | 16011 | 3878 | 53 |
906406 | 906406 | 2021-01-07 | McClain | Oklahoma | 40087 | 3878 | 29 |
820443 | 820443 | 2020-12-12 | Clinton | Illinois | 17027 | 3878 | 72 |
777996 | 777996 | 2020-11-29 | Jackson | Florida | 12063 | 3878 | 90 |
773098 | 773098 | 2020-11-27 | Harnett | North Carolina | 37085 | 3878 | 77 |
711467 | 711467 | 2020-11-08 | Onslow | North Carolina | 37133 | 3878 | 33 |
624808 | 624808 | 2020-10-12 | Washington | Utah | 49053 | 3878 | 38 |
470285 | 470285 | 2020-08-26 | Whitfield | Georgia | 13313 | 3878 | 49 |
401089 | 401089 | 2020-08-04 | Northampton | Pennsylvania | 42095 | 3878 | 290 |
306218 | 306218 | 2020-07-06 | Contra Costa | California | 6013 | 3878 | 85 |
131374 | 131374 | 2020-05-10 | Baltimore | Maryland | 24005 | 3878 | 191 |
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);