ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
86 rows where cases = 6440 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- North Carolina 10
- Florida 8
- Mississippi 8
- Kentucky 7
- Minnesota 7
- Arkansas 5
- California 4
- Indiana 3
- Kansas 3
- Louisiana 3
- Michigan 3
- Pennsylvania 3
- Virginia 3
- Idaho 2
- Maine 2
- Nebraska 2
- South Carolina 2
- Texas 2
- Alabama 1
- Georgia 1
- Illinois 1
- Iowa 1
- Maryland 1
- Missouri 1
- New Hampshire 1
- New York 1
- Ohio 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502639 | 2502639 | 2022-05-13 | Winchester city | Virginia | 51840 | 6440 | 80 |
2491716 | 2491716 | 2022-05-10 | Ashe | North Carolina | 37009 | 6440 | 78 |
2488458 | 2488458 | 2022-05-09 | Ashe | North Carolina | 37009 | 6440 | 78 |
2485201 | 2485201 | 2022-05-08 | Ashe | North Carolina | 37009 | 6440 | 78 |
2481943 | 2481943 | 2022-05-07 | Ashe | North Carolina | 37009 | 6440 | 78 |
2478685 | 2478685 | 2022-05-06 | Ashe | North Carolina | 37009 | 6440 | 78 |
2475427 | 2475427 | 2022-05-05 | Ashe | North Carolina | 37009 | 6440 | 78 |
2472170 | 2472170 | 2022-05-04 | Ashe | North Carolina | 37009 | 6440 | 78 |
2442113 | 2442113 | 2022-04-25 | Plaquemines | Louisiana | 22075 | 6440 | 45 |
2385726 | 2385726 | 2022-04-08 | Cleburne | Arkansas | 5023 | 6440 | 128 |
2382471 | 2382471 | 2022-04-07 | Cleburne | Arkansas | 5023 | 6440 | 128 |
2379216 | 2379216 | 2022-04-06 | Cleburne | Arkansas | 5023 | 6440 | 128 |
2375962 | 2375962 | 2022-04-05 | Cleburne | Arkansas | 5023 | 6440 | 128 |
2372710 | 2372710 | 2022-04-04 | Cleburne | Arkansas | 5023 | 6440 | 128 |
2315397 | 2315397 | 2022-03-17 | Le Sueur | Minnesota | 27079 | 6440 | 49 |
2312144 | 2312144 | 2022-03-16 | Le Sueur | Minnesota | 27079 | 6440 | 49 |
2289685 | 2289685 | 2022-03-09 | Adams | Nebraska | 31001 | 6440 | 70 |
2255690 | 2255690 | 2022-02-27 | Glenn | California | 6021 | 6440 | 63 |
2252439 | 2252439 | 2022-02-26 | Glenn | California | 6021 | 6440 | 63 |
2249188 | 2249188 | 2022-02-25 | Glenn | California | 6021 | 6440 | 63 |
2245937 | 2245937 | 2022-02-24 | Glenn | California | 6021 | 6440 | 62 |
2237322 | 2237322 | 2022-02-21 | Brown | Minnesota | 27015 | 6440 | 74 |
2233637 | 2233637 | 2022-02-20 | Barton | Kansas | 20009 | 6440 | 86 |
2234071 | 2234071 | 2022-02-20 | Brown | Minnesota | 27015 | 6440 | 74 |
2230386 | 2230386 | 2022-02-19 | Barton | Kansas | 20009 | 6440 | 86 |
2230676 | 2230676 | 2022-02-19 | Hancock | Maine | 23009 | 6440 | 76 |
2230820 | 2230820 | 2022-02-19 | Brown | Minnesota | 27015 | 6440 | 74 |
2227135 | 2227135 | 2022-02-18 | Barton | Kansas | 20009 | 6440 | 86 |
2227569 | 2227569 | 2022-02-18 | Brown | Minnesota | 27015 | 6440 | 74 |
2223986 | 2223986 | 2022-02-17 | Allen | Kentucky | 21003 | 6440 | 92 |
2202004 | 2202004 | 2022-02-10 | Coos | New Hampshire | 33007 | 6440 | 95 |
2202941 | 2202941 | 2022-02-10 | Hale | Texas | 48189 | 6440 | 230 |
2177899 | 2177899 | 2022-02-03 | Gilmer | Georgia | 13123 | 6440 | 153 |
2180395 | 2180395 | 2022-02-03 | Caroline | Virginia | 51033 | 6440 | 63 |
2159456 | 2159456 | 2022-01-28 | Dunklin | Missouri | 29069 | 6440 | 93 |
2149534 | 2149534 | 2022-01-25 | Lyon | Minnesota | 27083 | 6440 | 70 |
2064809 | 2064809 | 2021-12-30 | Somerset | Maine | 23025 | 6440 | 72 |
2052893 | 2052893 | 2021-12-26 | Clarion | Pennsylvania | 42031 | 6440 | 169 |
2024640 | 2024640 | 2021-12-18 | Franklin | Alabama | 1059 | 6440 | 109 |
2017142 | 2017142 | 2021-12-15 | Clinton | Pennsylvania | 42035 | 6440 | 98 |
1973307 | 1973307 | 2021-12-02 | Woodford | Illinois | 17203 | 6440 | 105 |
1973701 | 1973701 | 2021-12-02 | Perry | Kentucky | 21193 | 6440 | 120 |
1961021 | 1961021 | 2021-11-28 | Bolivar | Mississippi | 28011 | 6440 | 151 |
1957770 | 1957770 | 2021-11-27 | Bolivar | Mississippi | 28011 | 6440 | 151 |
1954519 | 1954519 | 2021-11-26 | Bolivar | Mississippi | 28011 | 6440 | 151 |
1951268 | 1951268 | 2021-11-25 | Bolivar | Mississippi | 28011 | 6440 | 151 |
1948017 | 1948017 | 2021-11-24 | Bolivar | Mississippi | 28011 | 6440 | 151 |
1944766 | 1944766 | 2021-11-23 | Bolivar | Mississippi | 28011 | 6440 | 151 |
1927481 | 1927481 | 2021-11-18 | Wakulla | Florida | 12129 | 6440 | 104 |
1924231 | 1924231 | 2021-11-17 | Wakulla | Florida | 12129 | 6440 | 104 |
1920982 | 1920982 | 2021-11-16 | Wakulla | Florida | 12129 | 6440 | 104 |
1917732 | 1917732 | 2021-11-15 | Wakulla | Florida | 12129 | 6440 | 104 |
1914482 | 1914482 | 2021-11-14 | Wakulla | Florida | 12129 | 6440 | 104 |
1911232 | 1911232 | 2021-11-13 | Wakulla | Florida | 12129 | 6440 | 104 |
1907983 | 1907983 | 2021-11-12 | Wakulla | Florida | 12129 | 6440 | 104 |
1808337 | 1808337 | 2021-10-12 | Panola | Mississippi | 28107 | 6440 | 130 |
1791804 | 1791804 | 2021-10-07 | Webster | Louisiana | 22119 | 6440 | 144 |
1648440 | 1648440 | 2021-08-24 | Noble | Indiana | 18113 | 6440 | 96 |
1578636 | 1578636 | 2021-08-02 | Cherokee | South Carolina | 45021 | 6440 | 159 |
1552504 | 1552504 | 2021-07-25 | Carbon | Pennsylvania | 42025 | 6440 | 176 |
1441778 | 1441778 | 2021-06-21 | Columbus | North Carolina | 37047 | 6440 | 152 |
1372962 | 1372962 | 2021-05-31 | Grand Traverse | Michigan | 26055 | 6440 | 96 |
1369717 | 1369717 | 2021-05-30 | Grand Traverse | Michigan | 26055 | 6440 | 96 |
1366471 | 1366471 | 2021-05-29 | Grand Traverse | Michigan | 26055 | 6440 | 96 |
1325126 | 1325126 | 2021-05-16 | Scioto | Ohio | 39145 | 6440 | 102 |
1267538 | 1267538 | 2021-04-28 | Harrisonburg city | Virginia | 51660 | 6440 | 94 |
1144735 | 1144735 | 2021-03-22 | Flagler | Florida | 12035 | 6440 | 93 |
1142174 | 1142174 | 2021-03-21 | Christian | Kentucky | 21047 | 6440 | 92 |
1138928 | 1138928 | 2021-03-20 | Christian | Kentucky | 21047 | 6440 | 92 |
1135682 | 1135682 | 2021-03-19 | Christian | Kentucky | 21047 | 6440 | 91 |
1132435 | 1132435 | 2021-03-18 | Christian | Kentucky | 21047 | 6440 | 89 |
1119626 | 1119626 | 2021-03-14 | Allegany | Maryland | 24001 | 6440 | 201 |
1096287 | 1096287 | 2021-03-07 | Madison | Idaho | 16065 | 6440 | 22 |
1093041 | 1093041 | 2021-03-06 | Madison | Idaho | 16065 | 6440 | 22 |
1077240 | 1077240 | 2021-03-01 | Bullitt | Kentucky | 21029 | 6440 | 48 |
1078076 | 1078076 | 2021-03-01 | Chemung | New York | 36015 | 6440 | 130 |
1052900 | 1052900 | 2021-02-21 | Bowie | Texas | 48037 | 6440 | 171 |
967842 | 967842 | 2021-01-26 | Orange | North Carolina | 37135 | 6440 | 80 |
951355 | 951355 | 2021-01-21 | Hall | Nebraska | 31079 | 6440 | 104 |
937452 | 937452 | 2021-01-17 | Warrick | Indiana | 18173 | 6440 | 92 |
906158 | 906158 | 2021-01-07 | Harnett | North Carolina | 37085 | 6440 | 100 |
781760 | 781760 | 2020-11-30 | Pottawattamie | Iowa | 19155 | 6440 | 70 |
779086 | 779086 | 2020-11-29 | Jackson | Mississippi | 28059 | 6440 | 124 |
708674 | 708674 | 2020-11-07 | Berkeley | South Carolina | 45015 | 6440 | 96 |
583710 | 583710 | 2020-09-30 | Allen | Indiana | 18003 | 6440 | 216 |
393496 | 393496 | 2020-08-02 | Calcasieu | Louisiana | 22019 | 6440 | 127 |
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);