ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
47 rows where cases = 7217 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Georgia 8
- Virginia 5
- Kansas 4
- Michigan 4
- Ohio 4
- Mississippi 3
- Nevada 3
- North Carolina 2
- California 1
- Florida 1
- Illinois 1
- Indiana 1
- Kentucky 1
- Maryland 1
- Minnesota 1
- New Mexico 1
- New York 1
- Puerto Rico 1
- South Carolina 1
- Tennessee 1
- Texas 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502564 | 2502564 | 2022-05-13 | Halifax | Virginia | 51083 | 7217 | 159 |
2448103 | 2448103 | 2022-04-27 | Iroquois | Illinois | 17075 | 7217 | 117 |
2396747 | 2396747 | 2022-04-11 | Mille Lacs | Minnesota | 27095 | 7217 | 114 |
2392598 | 2392598 | 2022-04-10 | Lumpkin | Georgia | 13187 | 7217 | 131 |
2389342 | 2389342 | 2022-04-09 | Lumpkin | Georgia | 13187 | 7217 | 131 |
2386087 | 2386087 | 2022-04-08 | Lumpkin | Georgia | 13187 | 7217 | 131 |
2382832 | 2382832 | 2022-04-07 | Lumpkin | Georgia | 13187 | 7217 | 131 |
2356755 | 2356755 | 2022-03-30 | Decatur | Georgia | 13087 | 7217 | 127 |
2353502 | 2353502 | 2022-03-29 | Decatur | Georgia | 13087 | 7217 | 127 |
2356100 | 2356100 | 2022-03-29 | Pulaski | Virginia | 51155 | 7217 | 135 |
2350250 | 2350250 | 2022-03-28 | Decatur | Georgia | 13087 | 7217 | 127 |
2352847 | 2352847 | 2022-03-28 | Pulaski | Virginia | 51155 | 7217 | 135 |
2284644 | 2284644 | 2022-03-07 | Nicholas | West Virginia | 54067 | 7217 | 91 |
2224467 | 2224467 | 2022-02-17 | Tate | Mississippi | 28137 | 7217 | 138 |
2198409 | 2198409 | 2022-02-09 | Itawamba | Mississippi | 28057 | 7217 | 133 |
2166202 | 2166202 | 2022-01-30 | Douglas | Nevada | 32005 | 7217 | 79 |
2162947 | 2162947 | 2022-01-29 | Douglas | Nevada | 32005 | 7217 | 79 |
2159692 | 2159692 | 2022-01-28 | Douglas | Nevada | 32005 | 7217 | 79 |
2104758 | 2104758 | 2022-01-11 | Putnam | Ohio | 39137 | 7217 | 133 |
2062267 | 2062267 | 2021-12-29 | Alexander | North Carolina | 37003 | 7217 | 119 |
1997351 | 1997351 | 2021-12-09 | Vance | North Carolina | 37181 | 7217 | 104 |
1986360 | 1986360 | 2021-12-06 | Montgomery | Indiana | 18107 | 7217 | 125 |
1984422 | 1984422 | 2021-12-05 | Brown | Ohio | 39015 | 7217 | 116 |
1889952 | 1889952 | 2021-11-06 | Clinton | New York | 36019 | 7217 | 43 |
1879391 | 1879391 | 2021-11-03 | Graves | Kentucky | 21083 | 7217 | 125 |
1855846 | 1855846 | 2021-10-27 | Tuolumne | California | 6109 | 7217 | 121 |
1854785 | 1854785 | 2021-10-26 | Chesterfield | South Carolina | 45025 | 7217 | 144 |
1854891 | 1854891 | 2021-10-26 | Campbell | Tennessee | 47013 | 7217 | 80 |
1789475 | 1789475 | 2021-10-06 | Knox | Ohio | 39083 | 7217 | 128 |
1691180 | 1691180 | 2021-09-06 | Gratiot | Michigan | 26057 | 7217 | 127 |
1687930 | 1687930 | 2021-09-05 | Gratiot | Michigan | 26057 | 7217 | 127 |
1684680 | 1684680 | 2021-09-04 | Gratiot | Michigan | 26057 | 7217 | 127 |
1681429 | 1681429 | 2021-09-03 | Gratiot | Michigan | 26057 | 7217 | 127 |
1613151 | 1613151 | 2021-08-13 | Allegany | Maryland | 24001 | 7217 | 214 |
1464412 | 1464412 | 2021-06-28 | Valencia | New Mexico | 35061 | 7217 | 119 |
1318844 | 1318844 | 2021-05-14 | Caguas | Puerto Rico | 72025 | 7217 | |
1221966 | 1221966 | 2021-04-14 | Wise | Texas | 48497 | 7217 | 118 |
1086864 | 1086864 | 2021-03-04 | Butler | Kansas | 20015 | 7217 | 76 |
1083618 | 1083618 | 2021-03-03 | Butler | Kansas | 20015 | 7217 | 76 |
1080902 | 1080902 | 2021-03-02 | Forrest | Mississippi | 28035 | 7217 | 138 |
1030560 | 1030560 | 2021-02-14 | Portsmouth city | Virginia | 51740 | 7217 | 108 |
1001942 | 1001942 | 2021-02-06 | Nassau | Florida | 12089 | 7217 | 97 |
955015 | 955015 | 2021-01-22 | Pickaway | Ohio | 39129 | 7217 | 50 |
905183 | 905183 | 2021-01-07 | Reno | Kansas | 20155 | 7217 | 106 |
901938 | 901938 | 2021-01-06 | Reno | Kansas | 20155 | 7217 | 105 |
859189 | 859189 | 2020-12-24 | Carroll | Georgia | 13045 | 7217 | 114 |
621656 | 621656 | 2020-10-11 | Loudoun | Virginia | 51107 | 7217 | 128 |
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);