ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
109 rows where cases = 4805 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 9
- Michigan 9
- Missouri 8
- Ohio 8
- Alaska 7
- Texas 6
- Georgia 5
- Illinois 4
- Louisiana 4
- Maine 4
- New York 4
- Wisconsin 4
- South Carolina 3
- Wyoming 3
- Alabama 2
- Arkansas 2
- California 2
- Florida 2
- Indiana 2
- Kentucky 2
- Maryland 2
- Massachusetts 2
- Minnesota 2
- North Carolina 2
- Pennsylvania 2
- Virginia 2
- Iowa 1
- Mississippi 1
- Montana 1
- New Jersey 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489885 | 2489885 | 2022-05-10 | Northwest Arctic Borough | Alaska | 2188 | 4805 | 13 |
2486628 | 2486628 | 2022-05-09 | Northwest Arctic Borough | Alaska | 2188 | 4805 | 13 |
2483370 | 2483370 | 2022-05-08 | Northwest Arctic Borough | Alaska | 2188 | 4805 | 13 |
2480112 | 2480112 | 2022-05-07 | Northwest Arctic Borough | Alaska | 2188 | 4805 | 13 |
2476854 | 2476854 | 2022-05-06 | Northwest Arctic Borough | Alaska | 2188 | 4805 | 13 |
2473596 | 2473596 | 2022-05-05 | Northwest Arctic Borough | Alaska | 2188 | 4805 | 13 |
2474430 | 2474430 | 2022-05-05 | Dickinson | Kansas | 20041 | 4805 | 78 |
2470339 | 2470339 | 2022-05-04 | Northwest Arctic Borough | Alaska | 2188 | 4805 | 13 |
2471173 | 2471173 | 2022-05-04 | Dickinson | Kansas | 20041 | 4805 | 78 |
2467917 | 2467917 | 2022-05-03 | Dickinson | Kansas | 20041 | 4805 | 78 |
2464662 | 2464662 | 2022-05-02 | Dickinson | Kansas | 20041 | 4805 | 78 |
2461406 | 2461406 | 2022-05-01 | Dickinson | Kansas | 20041 | 4805 | 78 |
2458150 | 2458150 | 2022-04-30 | Dickinson | Kansas | 20041 | 4805 | 78 |
2454894 | 2454894 | 2022-04-29 | Dickinson | Kansas | 20041 | 4805 | 78 |
2422696 | 2422696 | 2022-04-19 | Iosco | Michigan | 26069 | 4805 | 141 |
2419440 | 2419440 | 2022-04-18 | Iosco | Michigan | 26069 | 4805 | 141 |
2416184 | 2416184 | 2022-04-17 | Iosco | Michigan | 26069 | 4805 | 141 |
2417595 | 2417595 | 2022-04-17 | Deaf Smith | Texas | 48117 | 4805 | 112 |
2412928 | 2412928 | 2022-04-16 | Iosco | Michigan | 26069 | 4805 | 141 |
2414339 | 2414339 | 2022-04-16 | Deaf Smith | Texas | 48117 | 4805 | 112 |
2409672 | 2409672 | 2022-04-15 | Iosco | Michigan | 26069 | 4805 | 141 |
2411083 | 2411083 | 2022-04-15 | Deaf Smith | Texas | 48117 | 4805 | 112 |
2406416 | 2406416 | 2022-04-14 | Iosco | Michigan | 26069 | 4805 | 141 |
2407827 | 2407827 | 2022-04-14 | Deaf Smith | Texas | 48117 | 4805 | 112 |
2403160 | 2403160 | 2022-04-13 | Iosco | Michigan | 26069 | 4805 | 141 |
2404571 | 2404571 | 2022-04-13 | Deaf Smith | Texas | 48117 | 4805 | 112 |
2333941 | 2333941 | 2022-03-23 | Appling | Georgia | 13001 | 4805 | 122 |
2304238 | 2304238 | 2022-03-13 | Taylor | Wisconsin | 55119 | 4805 | 68 |
2300986 | 2300986 | 2022-03-12 | Taylor | Wisconsin | 55119 | 4805 | 68 |
2297734 | 2297734 | 2022-03-11 | Taylor | Wisconsin | 55119 | 4805 | 68 |
2269112 | 2269112 | 2022-03-03 | Clark | Illinois | 17023 | 4805 | 60 |
2237565 | 2237565 | 2022-02-21 | Perry | Missouri | 29157 | 4805 | 44 |
2234314 | 2234314 | 2022-02-20 | Perry | Missouri | 29157 | 4805 | 44 |
2231063 | 2231063 | 2022-02-19 | Perry | Missouri | 29157 | 4805 | 44 |
2227812 | 2227812 | 2022-02-18 | Perry | Missouri | 29157 | 4805 | 44 |
2190607 | 2190607 | 2022-02-07 | Lincoln | Arkansas | 5079 | 4805 | 60 |
2192028 | 2192028 | 2022-02-07 | New Madrid | Missouri | 29143 | 4805 | 73 |
2144036 | 2144036 | 2022-01-23 | Las Piedras | Puerto Rico | 72085 | 4805 | |
2126579 | 2126579 | 2022-01-18 | Hancock | Maine | 23009 | 4805 | 68 |
2123327 | 2123327 | 2022-01-17 | Hancock | Maine | 23009 | 4805 | 68 |
2120075 | 2120075 | 2022-01-16 | Hancock | Maine | 23009 | 4805 | 68 |
2116823 | 2116823 | 2022-01-15 | Hancock | Maine | 23009 | 4805 | 68 |
2035895 | 2035895 | 2021-12-21 | Dunklin | Missouri | 29069 | 4805 | 93 |
2023424 | 2023424 | 2021-12-17 | Adams | Ohio | 39001 | 4805 | 113 |
2018853 | 2018853 | 2021-12-16 | Jennings | Indiana | 18079 | 4805 | 71 |
2019566 | 2019566 | 2021-12-16 | Leflore | Mississippi | 28083 | 4805 | 144 |
2012323 | 2012323 | 2021-12-14 | Clay | Indiana | 18021 | 4805 | 64 |
2007251 | 2007251 | 2021-12-12 | Van Wert | Ohio | 39161 | 4805 | 98 |
1994029 | 1994029 | 2021-12-08 | Cherokee | North Carolina | 37039 | 4805 | 79 |
1969162 | 1969162 | 2021-11-30 | Wythe | Virginia | 51197 | 4805 | 111 |
1943952 | 1943952 | 2021-11-23 | Bureau | Illinois | 17011 | 4805 | 110 |
1882581 | 1882581 | 2021-11-04 | Seward | Kansas | 20175 | 4805 | 49 |
1879332 | 1879332 | 2021-11-03 | Seward | Kansas | 20175 | 4805 | 49 |
1863958 | 1863958 | 2021-10-29 | Chenango | New York | 36017 | 4805 | 88 |
1860755 | 1860755 | 2021-10-28 | Washington | New York | 36115 | 4805 | 69 |
1851557 | 1851557 | 2021-10-25 | Marlboro | South Carolina | 45069 | 4805 | 80 |
1788042 | 1788042 | 2021-10-06 | Montgomery | Illinois | 17135 | 4805 | 84 |
1776233 | 1776233 | 2021-10-02 | Columbia | New York | 36021 | 4805 | 110 |
1716081 | 1716081 | 2021-09-14 | Amador | California | 6005 | 4805 | 56 |
1698502 | 1698502 | 2021-09-08 | Highland | Ohio | 39071 | 4805 | 72 |
1685479 | 1685479 | 2021-09-04 | Brown | Ohio | 39015 | 4805 | 65 |
1662535 | 1662535 | 2021-08-28 | Fulton | New York | 36035 | 4805 | 94 |
1605481 | 1605481 | 2021-08-11 | Franklin | Alabama | 1059 | 4805 | 81 |
1596886 | 1596886 | 2021-08-08 | Webster | Louisiana | 22119 | 4805 | 119 |
1593637 | 1593637 | 2021-08-07 | Webster | Louisiana | 22119 | 4805 | 119 |
1590388 | 1590388 | 2021-08-06 | Webster | Louisiana | 22119 | 4805 | 119 |
1585935 | 1585935 | 2021-08-04 | Albany | Wyoming | 56001 | 4805 | 18 |
1549116 | 1549116 | 2021-07-24 | Shelby | Ohio | 39149 | 4805 | 97 |
1527938 | 1527938 | 2021-07-18 | Effingham | Georgia | 13103 | 4805 | 74 |
1524691 | 1524691 | 2021-07-17 | Effingham | Georgia | 13103 | 4805 | 74 |
1521443 | 1521443 | 2021-07-16 | Effingham | Georgia | 13103 | 4805 | 74 |
1495025 | 1495025 | 2021-07-07 | Sweetwater | Wyoming | 56037 | 4805 | 40 |
1382535 | 1382535 | 2021-06-03 | Shelby | Kentucky | 21211 | 4805 | 78 |
1381383 | 1381383 | 2021-06-02 | Polk | Wisconsin | 55095 | 4805 | 60 |
1373239 | 1373239 | 2021-05-31 | Johnson | Missouri | 29101 | 4805 | 56 |
1369994 | 1369994 | 2021-05-30 | Johnson | Missouri | 29101 | 4805 | 56 |
1365891 | 1365891 | 2021-05-29 | Stephenson | Illinois | 17177 | 4805 | 104 |
1350274 | 1350274 | 2021-05-24 | Newaygo | Michigan | 26123 | 4805 | 66 |
1333081 | 1333081 | 2021-05-19 | Hendry | Florida | 12051 | 4805 | 84 |
1311058 | 1311058 | 2021-05-12 | Henderson | Kentucky | 21101 | 4805 | 75 |
1267280 | 1267280 | 2021-04-28 | Harrison | Texas | 48203 | 4805 | 106 |
1267606 | 1267606 | 2021-04-28 | Washington | Virginia | 51191 | 4805 | 106 |
1260127 | 1260127 | 2021-04-26 | Auglaize | Ohio | 39011 | 4805 | 83 |
1250614 | 1250614 | 2021-04-23 | Huntingdon | Pennsylvania | 42061 | 4805 | 128 |
1238559 | 1238559 | 2021-04-19 | Campbell | Wyoming | 56005 | 4805 | 60 |
1165946 | 1165946 | 2021-03-28 | Athens | Ohio | 39009 | 4805 | 52 |
1136938 | 1136938 | 2021-03-19 | Columbia | Pennsylvania | 42037 | 4805 | 125 |
1049079 | 1049079 | 2021-02-20 | Belmont | Ohio | 39013 | 4805 | 85 |
1016376 | 1016376 | 2021-02-10 | Curry | New Mexico | 35009 | 4805 | 63 |
1005711 | 1005711 | 2021-02-07 | Webster | Iowa | 19187 | 4805 | 83 |
999653 | 999653 | 2021-02-05 | Van Buren | Michigan | 26159 | 4805 | 94 |
993780 | 993780 | 2021-02-03 | Granville | North Carolina | 37077 | 4805 | 74 |
929162 | 929162 | 2021-01-14 | Deschutes | Oregon | 41017 | 4805 | 32 |
879885 | 879885 | 2020-12-30 | Lewis and Clark | Montana | 30049 | 4805 | 38 |
863250 | 863250 | 2020-12-25 | Barnstable | Massachusetts | 25001 | 4805 | 226 |
860005 | 860005 | 2020-12-24 | Barnstable | Massachusetts | 25001 | 4805 | 226 |
852482 | 852482 | 2020-12-22 | El Dorado | California | 6017 | 4805 | 10 |
810132 | 810132 | 2020-12-09 | Lauderdale | Alabama | 1077 | 4805 | 57 |
808058 | 808058 | 2020-12-08 | Charles | Maryland | 24017 | 4805 | 106 |
706692 | 706692 | 2020-11-07 | Douglas | Georgia | 13097 | 4805 | 82 |
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);