ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69 rows where cases = 5496 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Iowa 8
- Indiana 6
- North Carolina 6
- Ohio 5
- Colorado 4
- New York 4
- Texas 4
- Virginia 3
- Arizona 2
- Georgia 2
- Kansas 2
- Michigan 2
- Minnesota 2
- Missouri 2
- Pennsylvania 2
- South Carolina 2
- Wisconsin 2
- Florida 1
- Maine 1
- Massachusetts 1
- Mississippi 1
- Montana 1
- Nebraska 1
- New Mexico 1
- Oklahoma 1
- Oregon 1
- Puerto Rico 1
- South Dakota 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2459600 | 2459600 | 2022-04-30 | Guayama | Puerto Rico | 72057 | 5496 | |
2422222 | 2422222 | 2022-04-19 | Bremer | Iowa | 19017 | 5496 | 82 |
2418966 | 2418966 | 2022-04-18 | Bremer | Iowa | 19017 | 5496 | 82 |
2415710 | 2415710 | 2022-04-17 | Bremer | Iowa | 19017 | 5496 | 82 |
2412454 | 2412454 | 2022-04-16 | Bremer | Iowa | 19017 | 5496 | 82 |
2409198 | 2409198 | 2022-04-15 | Bremer | Iowa | 19017 | 5496 | 82 |
2405942 | 2405942 | 2022-04-14 | Bremer | Iowa | 19017 | 5496 | 82 |
2402686 | 2402686 | 2022-04-13 | Bremer | Iowa | 19017 | 5496 | 82 |
2380504 | 2380504 | 2022-04-06 | Waseca | Minnesota | 27161 | 5496 | 39 |
2349395 | 2349395 | 2022-03-27 | San Jacinto | Texas | 48407 | 5496 | 100 |
2281026 | 2281026 | 2022-03-06 | Lampasas | Texas | 48281 | 5496 | 87 |
2277773 | 2277773 | 2022-03-05 | Lampasas | Texas | 48281 | 5496 | 87 |
2185490 | 2185490 | 2022-02-05 | Henry | Missouri | 29083 | 5496 | 74 |
2145661 | 2145661 | 2022-01-24 | LaGrange | Indiana | 18087 | 5496 | 99 |
2124007 | 2124007 | 2022-01-17 | Lewis | New York | 36049 | 5496 | 43 |
2104057 | 2104057 | 2022-01-11 | Copiah | Mississippi | 28029 | 5496 | 95 |
2078575 | 2078575 | 2022-01-03 | Macon | North Carolina | 37113 | 5496 | 87 |
2058766 | 2058766 | 2021-12-28 | Ravalli | Montana | 30081 | 5496 | 128 |
2060131 | 2060131 | 2021-12-28 | Petersburg city | Virginia | 51730 | 5496 | 109 |
2057044 | 2057044 | 2021-12-27 | Juneau | Wisconsin | 55057 | 5496 | 50 |
2036690 | 2036690 | 2021-12-21 | Warren | Pennsylvania | 42123 | 5496 | 174 |
2005410 | 2005410 | 2021-12-12 | Summit | Colorado | 8117 | 5496 | 12 |
2002159 | 2002159 | 2021-12-11 | Summit | Colorado | 8117 | 5496 | 12 |
1998909 | 1998909 | 2021-12-10 | Summit | Colorado | 8117 | 5496 | 12 |
1900296 | 1900296 | 2021-11-09 | Marion | South Carolina | 45067 | 5496 | 140 |
1880478 | 1880478 | 2021-11-03 | Putnam | Ohio | 39137 | 5496 | 112 |
1880496 | 1880496 | 2021-11-03 | Williams | Ohio | 39171 | 5496 | 92 |
1807146 | 1807146 | 2021-10-12 | La Plata | Colorado | 8067 | 5496 | 52 |
1808597 | 1808597 | 2021-10-12 | Madison | Nebraska | 31119 | 5496 | 45 |
1749997 | 1749997 | 2021-09-24 | Webster | Missouri | 29225 | 5496 | 86 |
1742632 | 1742632 | 2021-09-22 | Knox | Indiana | 18083 | 5496 | 104 |
1740641 | 1740641 | 2021-09-21 | Yadkin | North Carolina | 37197 | 5496 | 65 |
1679666 | 1679666 | 2021-09-02 | Kerr | Texas | 48265 | 5496 | 105 |
1610563 | 1610563 | 2021-08-12 | Genesee | New York | 36037 | 5496 | 124 |
1605909 | 1605909 | 2021-08-11 | Habersham | Georgia | 13137 | 5496 | 166 |
1565050 | 1565050 | 2021-07-29 | Otero | New Mexico | 35035 | 5496 | 86 |
1463823 | 1463823 | 2021-06-28 | Cass | Michigan | 26027 | 5496 | 77 |
1412885 | 1412885 | 2021-06-12 | Linn | Oregon | 41043 | 5496 | 79 |
1362768 | 1362768 | 2021-05-28 | Cerro Gordo | Iowa | 19033 | 5496 | 89 |
1364053 | 1364053 | 2021-05-28 | Huron | Ohio | 39077 | 5496 | 121 |
1298870 | 1298870 | 2021-05-08 | Cattaraugus | New York | 36009 | 5496 | 86 |
1288478 | 1288478 | 2021-05-05 | Penobscot | Maine | 23019 | 5496 | 90 |
1287056 | 1287056 | 2021-05-04 | Pittsylvania | Virginia | 51143 | 5496 | 78 |
1283810 | 1283810 | 2021-05-03 | Pittsylvania | Virginia | 51143 | 5496 | 78 |
1226883 | 1226883 | 2021-04-16 | Marquette | Michigan | 26103 | 5496 | 58 |
1152833 | 1152833 | 2021-03-24 | Granville | North Carolina | 37077 | 5496 | 77 |
1120583 | 1120583 | 2021-03-14 | Cherokee | Oklahoma | 40021 | 5496 | 44 |
1112683 | 1112683 | 2021-03-12 | Marshall | Indiana | 18099 | 5496 | 107 |
1071625 | 1071625 | 2021-02-27 | Steuben | New York | 36101 | 5496 | 137 |
1066448 | 1066448 | 2021-02-25 | Sauk | Wisconsin | 55111 | 5496 | 45 |
1054280 | 1054280 | 2021-02-22 | Shelby | Indiana | 18145 | 5496 | 100 |
1012237 | 1012237 | 2021-02-09 | Ford | Kansas | 20057 | 5496 | 10 |
1008991 | 1008991 | 2021-02-08 | Ford | Kansas | 20057 | 5496 | 10 |
973596 | 973596 | 2021-01-28 | Hampshire | Massachusetts | 25015 | 5496 | 231 |
974493 | 974493 | 2021-01-28 | Scioto | Ohio | 39145 | 5496 | 65 |
967204 | 967204 | 2021-01-26 | Blue Earth | Minnesota | 27013 | 5496 | 33 |
956489 | 956489 | 2021-01-23 | Jackson | Florida | 12063 | 5496 | 128 |
888712 | 888712 | 2021-01-02 | Grant | Indiana | 18053 | 5496 | 105 |
886685 | 886685 | 2021-01-01 | Henderson | North Carolina | 37089 | 5496 | 92 |
883440 | 883440 | 2020-12-31 | Henderson | North Carolina | 37089 | 5496 | 92 |
880195 | 880195 | 2020-12-30 | Henderson | North Carolina | 37089 | 5496 | 92 |
852395 | 852395 | 2020-12-22 | Santa Cruz | Arizona | 4023 | 5496 | 87 |
847871 | 847871 | 2020-12-20 | Columbiana | Ohio | 39029 | 5496 | 116 |
802646 | 802646 | 2020-12-06 | Franklin | Pennsylvania | 42055 | 5496 | 134 |
781600 | 781600 | 2020-11-30 | Clark | Indiana | 18019 | 5496 | 85 |
559497 | 559497 | 2020-09-22 | Beaufort | South Carolina | 45013 | 5496 | 81 |
501340 | 501340 | 2020-09-04 | Minnehaha | South Dakota | 46099 | 5496 | 71 |
463387 | 463387 | 2020-08-24 | Navajo | Arizona | 4017 | 5496 | 216 |
259272 | 259272 | 2020-06-21 | Fulton | Georgia | 13121 | 5496 | 304 |
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);