ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49 rows where cases = 5545 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Kentucky 8
- Michigan 3
- Tennessee 3
- Virginia 3
- Wisconsin 3
- Idaho 2
- Louisiana 2
- Maryland 2
- Minnesota 2
- New York 2
- Ohio 2
- Pennsylvania 2
- Texas 2
- Alabama 1
- Arizona 1
- Florida 1
- Georgia 1
- Indiana 1
- Iowa 1
- Maine 1
- Montana 1
- North Carolina 1
- North Dakota 1
- Puerto Rico 1
- South Carolina 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2422827 | 2422827 | 2022-04-19 | Waseca | Minnesota | 27161 | 5545 | 39 |
2328268 | 2328268 | 2022-03-21 | Talbot | Maryland | 24041 | 5545 | 86 |
2313533 | 2313533 | 2022-03-16 | Karnes | Texas | 48255 | 5545 | 68 |
2307293 | 2307293 | 2022-03-14 | Page | Virginia | 51139 | 5545 | 118 |
2269063 | 2269063 | 2022-03-03 | Blaine | Idaho | 16013 | 5545 | 30 |
2269083 | 2269083 | 2022-03-03 | Jerome | Idaho | 16053 | 5545 | 64 |
2269768 | 2269768 | 2022-03-03 | Gladwin | Michigan | 26051 | 5545 | 110 |
2266515 | 2266515 | 2022-03-02 | Gladwin | Michigan | 26051 | 5545 | 110 |
2134267 | 2134267 | 2022-01-20 | Juncos | Puerto Rico | 72077 | 5545 | |
2114526 | 2114526 | 2022-01-14 | Van Wert | Ohio | 39161 | 5545 | 120 |
2097169 | 2097169 | 2022-01-09 | Grayson | Kentucky | 21085 | 5545 | 109 |
2093917 | 2093917 | 2022-01-08 | Grayson | Kentucky | 21085 | 5545 | 109 |
2090665 | 2090665 | 2022-01-07 | Grayson | Kentucky | 21085 | 5545 | 109 |
1960626 | 1960626 | 2021-11-28 | Clark | Kentucky | 21049 | 5545 | 44 |
1957375 | 1957375 | 2021-11-27 | Clark | Kentucky | 21049 | 5545 | 44 |
1954124 | 1954124 | 2021-11-26 | Clark | Kentucky | 21049 | 5545 | 44 |
1950873 | 1950873 | 2021-11-25 | Clark | Kentucky | 21049 | 5545 | 44 |
1947622 | 1947622 | 2021-11-24 | Clark | Kentucky | 21049 | 5545 | 44 |
1942677 | 1942677 | 2021-11-22 | Macon | Tennessee | 47111 | 5545 | 94 |
1691968 | 1691968 | 2021-09-06 | Williams | North Dakota | 38105 | 5545 | 42 |
1685705 | 1685705 | 2021-09-04 | Huntingdon | Pennsylvania | 42061 | 5545 | 139 |
1675764 | 1675764 | 2021-09-01 | Knox | Ohio | 39083 | 5545 | 117 |
1673610 | 1673610 | 2021-08-31 | Oconto | Wisconsin | 55083 | 5545 | 74 |
1536717 | 1536717 | 2021-07-20 | Harrison | Texas | 48203 | 5545 | 112 |
1531915 | 1531915 | 2021-07-19 | St. Mary | Louisiana | 22101 | 5545 | 147 |
1520305 | 1520305 | 2021-07-15 | Dyer | Tennessee | 47045 | 5545 | 108 |
1456890 | 1456890 | 2021-06-26 | Cerro Gordo | Iowa | 19033 | 5545 | 97 |
1353395 | 1353395 | 2021-05-25 | Vermilion | Louisiana | 22113 | 5545 | 121 |
1311261 | 1311261 | 2021-05-12 | Branch | Michigan | 26023 | 5545 | 119 |
1289228 | 1289228 | 2021-05-05 | Halifax | North Carolina | 37083 | 5545 | 110 |
1278303 | 1278303 | 2021-05-02 | Noble | Indiana | 18113 | 5545 | 86 |
1264655 | 1264655 | 2021-04-28 | Graham | Arizona | 4009 | 5545 | 77 |
1204076 | 1204076 | 2021-04-09 | St. Mary's | Maryland | 24037 | 5545 | 123 |
1169693 | 1169693 | 2021-03-29 | Hawkins | Tennessee | 47073 | 5545 | 103 |
1152741 | 1152741 | 2021-03-24 | Cayuga | New York | 36011 | 5545 | 90 |
1117602 | 1117602 | 2021-03-13 | Cherokee | South Carolina | 45021 | 5545 | 141 |
1087853 | 1087853 | 2021-03-04 | Steuben | New York | 36101 | 5545 | 138 |
1089167 | 1089167 | 2021-03-04 | Sauk | Wisconsin | 55111 | 5545 | 48 |
995459 | 995459 | 2021-02-04 | Putnam | Florida | 12107 | 5545 | 103 |
983431 | 983431 | 2021-01-31 | Blue Earth | Minnesota | 27013 | 5545 | 33 |
949398 | 949398 | 2021-01-20 | Lynchburg city | Virginia | 51680 | 5545 | 62 |
941546 | 941546 | 2021-01-18 | Lewis and Clark | Montana | 30049 | 5545 | 49 |
926743 | 926743 | 2021-01-13 | Chelan | Washington | 53007 | 5545 | 41 |
868275 | 868275 | 2020-12-26 | Newport News city | Virginia | 51700 | 5545 | 66 |
840494 | 840494 | 2020-12-18 | Cumberland | Maine | 23005 | 5545 | 82 |
832857 | 832857 | 2020-12-16 | Limestone | Alabama | 1083 | 5545 | 50 |
693246 | 693246 | 2020-11-02 | Sheboygan | Wisconsin | 55117 | 5545 | 32 |
685850 | 685850 | 2020-10-31 | Luzerne | Pennsylvania | 42079 | 5545 | 206 |
531604 | 531604 | 2020-09-14 | Cherokee | Georgia | 13057 | 5545 | 87 |
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);