ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where cases = 4023 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Iowa 13
- Alabama 6
- Georgia 6
- Illinois 6
- Texas 6
- Virginia 5
- Arkansas 4
- Indiana 4
- Louisiana 4
- Pennsylvania 4
- West Virginia 4
- Wisconsin 4
- Michigan 3
- Minnesota 3
- Mississippi 3
- California 2
- Kansas 2
- Kentucky 2
- Missouri 2
- New Hampshire 2
- New York 2
- Oregon 2
- Puerto Rico 2
- South Carolina 2
- Utah 2
- Maine 1
- Maryland 1
- Montana 1
- Nevada 1
- North Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2445033 | 2445033 | 2022-04-26 | Delaware | Iowa | 19055 | 4023 | 68 |
2441777 | 2441777 | 2022-04-25 | Delaware | Iowa | 19055 | 4023 | 68 |
2438521 | 2438521 | 2022-04-24 | Delaware | Iowa | 19055 | 4023 | 68 |
2435265 | 2435265 | 2022-04-23 | Delaware | Iowa | 19055 | 4023 | 68 |
2432009 | 2432009 | 2022-04-22 | Delaware | Iowa | 19055 | 4023 | 68 |
2428753 | 2428753 | 2022-04-21 | Delaware | Iowa | 19055 | 4023 | 68 |
2425497 | 2425497 | 2022-04-20 | Delaware | Iowa | 19055 | 4023 | 68 |
2427014 | 2427014 | 2022-04-20 | Aguas Buenas | Puerto Rico | 72007 | 4023 | |
2356965 | 2356965 | 2022-03-30 | Jo Daviess | Illinois | 17085 | 4023 | 38 |
2274632 | 2274632 | 2022-03-04 | Zavala | Texas | 48507 | 4023 | 67 |
2228529 | 2228529 | 2022-02-18 | Fulton | Pennsylvania | 42057 | 4023 | 64 |
2224631 | 2224631 | 2022-02-17 | Park | Montana | 30067 | 4023 | 33 |
2221228 | 2221228 | 2022-02-16 | Yalobusha | Mississippi | 28161 | 4023 | 51 |
2193363 | 2193363 | 2022-02-07 | Unknown | Utah | 4023 | 68 | |
2190357 | 2190357 | 2022-02-06 | Wetzel | West Virginia | 54103 | 4023 | 71 |
2155749 | 2155749 | 2022-01-27 | Mason | Kentucky | 21161 | 4023 | 89 |
2147749 | 2147749 | 2022-01-24 | Shelby | Texas | 48419 | 4023 | 117 |
2121708 | 2121708 | 2022-01-16 | Robertson | Texas | 48395 | 4023 | 68 |
2110319 | 2110319 | 2022-01-13 | Franklin | Maine | 23007 | 4023 | 45 |
2108114 | 2108114 | 2022-01-12 | Crook | Oregon | 41013 | 4023 | 62 |
2099313 | 2099313 | 2022-01-09 | Langlade | Wisconsin | 55067 | 4023 | 66 |
2096062 | 2096062 | 2022-01-08 | Langlade | Wisconsin | 55067 | 4023 | 66 |
2092810 | 2092810 | 2022-01-07 | Langlade | Wisconsin | 55067 | 4023 | 66 |
2079661 | 2079661 | 2022-01-03 | Staunton city | Virginia | 51790 | 4023 | 88 |
2060109 | 2060109 | 2021-12-28 | Louisa | Virginia | 51109 | 4023 | 54 |
2032273 | 2032273 | 2021-12-20 | Pointe Coupee | Louisiana | 22077 | 4023 | 85 |
2011512 | 2011512 | 2021-12-13 | Wyoming | West Virginia | 54109 | 4023 | 75 |
1998255 | 1998255 | 2021-12-09 | Sevier | Utah | 49041 | 4023 | 19 |
1988704 | 1988704 | 2021-12-06 | Boone | West Virginia | 54005 | 4023 | 62 |
1945130 | 1945130 | 2021-11-23 | Coos | New Hampshire | 33007 | 4023 | 70 |
1927841 | 1927841 | 2021-11-18 | LaGrange | Indiana | 18087 | 4023 | 91 |
1925453 | 1925453 | 2021-11-17 | Washington | Missouri | 29221 | 4023 | 70 |
1892607 | 1892607 | 2021-11-07 | Clare | Michigan | 26035 | 4023 | 106 |
1889357 | 1889357 | 2021-11-06 | Clare | Michigan | 26035 | 4023 | 106 |
1886107 | 1886107 | 2021-11-05 | Clare | Michigan | 26035 | 4023 | 106 |
1819727 | 1819727 | 2021-10-15 | Hancock | West Virginia | 54029 | 4023 | 108 |
1768591 | 1768591 | 2021-09-30 | Clay | Indiana | 18021 | 4023 | 58 |
1743663 | 1743663 | 2021-09-22 | Nye | Nevada | 32023 | 4023 | 126 |
1713149 | 1713149 | 2021-09-13 | Pierce | Georgia | 13229 | 4023 | 79 |
1702935 | 1702935 | 2021-09-10 | Geneva | Alabama | 1061 | 4023 | 97 |
1695463 | 1695463 | 2021-09-07 | McKean | Pennsylvania | 42083 | 4023 | 76 |
1656425 | 1656425 | 2021-08-26 | Malheur | Oregon | 41045 | 4023 | 66 |
1633862 | 1633862 | 2021-08-19 | Clarendon | South Carolina | 45027 | 4023 | 114 |
1530857 | 1530857 | 2021-07-19 | Baxter | Arkansas | 5005 | 4023 | 111 |
1515161 | 1515161 | 2021-07-14 | Logan | Illinois | 17107 | 4023 | 77 |
1457688 | 1457688 | 2021-06-26 | Webster | Missouri | 29225 | 4023 | 56 |
1449614 | 1449614 | 2021-06-24 | Escambia | Alabama | 1053 | 4023 | 80 |
1446369 | 1446369 | 2021-06-23 | Escambia | Alabama | 1053 | 4023 | 80 |
1425935 | 1425935 | 2021-06-16 | Pike | Pennsylvania | 42103 | 4023 | 54 |
1413585 | 1413585 | 2021-06-12 | Charlottesville city | Virginia | 51540 | 4023 | 57 |
1410340 | 1410340 | 2021-06-11 | Charlottesville city | Virginia | 51540 | 4023 | 57 |
1394820 | 1394820 | 2021-06-07 | Camden | Georgia | 13039 | 4023 | 38 |
1391575 | 1391575 | 2021-06-06 | Camden | Georgia | 13039 | 4023 | 38 |
1375808 | 1375808 | 2021-06-01 | Plymouth | Iowa | 19149 | 4023 | 80 |
1372563 | 1372563 | 2021-05-31 | Plymouth | Iowa | 19149 | 4023 | 80 |
1369318 | 1369318 | 2021-05-30 | Plymouth | Iowa | 19149 | 4023 | 80 |
1363739 | 1363739 | 2021-05-28 | Grafton | New Hampshire | 33009 | 4023 | 26 |
1359338 | 1359338 | 2021-05-27 | Fulton | Illinois | 17057 | 4023 | 67 |
1359579 | 1359579 | 2021-05-27 | Plymouth | Iowa | 19149 | 4023 | 80 |
1352846 | 1352846 | 2021-05-25 | Fulton | Illinois | 17057 | 4023 | 67 |
1350300 | 1350300 | 2021-05-24 | Beltrami | Minnesota | 27007 | 4023 | 59 |
1347054 | 1347054 | 2021-05-23 | Beltrami | Minnesota | 27007 | 4023 | 59 |
1313434 | 1313434 | 2021-05-13 | Union | Arkansas | 5139 | 4023 | 114 |
1306823 | 1306823 | 2021-05-11 | Tallapoosa | Alabama | 1123 | 4023 | 152 |
1294273 | 1294273 | 2021-05-07 | Oconee | Georgia | 13219 | 4023 | 72 |
1270664 | 1270664 | 2021-04-29 | Washington | Texas | 48477 | 4023 | 92 |
1249699 | 1249699 | 2021-04-23 | Nobles | Minnesota | 27105 | 4023 | 48 |
1242981 | 1242981 | 2021-04-21 | Natchitoches | Louisiana | 22069 | 4023 | 85 |
1194595 | 1194595 | 2021-04-06 | Union | Mississippi | 28145 | 4023 | 75 |
1182517 | 1182517 | 2021-04-02 | Toa Baja | Puerto Rico | 72137 | 4023 | |
1167973 | 1167973 | 2021-03-29 | Jasper | Iowa | 19099 | 4023 | 69 |
1158063 | 1158063 | 2021-03-26 | Randolph | Illinois | 17157 | 4023 | 88 |
1131429 | 1131429 | 2021-03-18 | Covington | Alabama | 1039 | 4023 | 109 |
1105468 | 1105468 | 2021-03-10 | Franklin | Alabama | 1059 | 4023 | 81 |
1083601 | 1083601 | 2021-03-03 | Wapello | Iowa | 19179 | 4023 | 108 |
1045235 | 1045235 | 2021-02-19 | Pearl River | Mississippi | 28109 | 4023 | 126 |
1023696 | 1023696 | 2021-02-12 | Burnet | Texas | 48053 | 4023 | 51 |
1008602 | 1008602 | 2021-02-08 | Unknown | Georgia | 4023 | 9 | |
1008720 | 1008720 | 2021-02-08 | Livingston | Illinois | 17105 | 4023 | 81 |
992372 | 992372 | 2021-02-03 | Unknown | Georgia | 4023 | 9 | |
986094 | 986094 | 2021-02-01 | Lawrence | Indiana | 18093 | 4023 | 86 |
974261 | 974261 | 2021-01-28 | Wayne | New York | 36117 | 4023 | 58 |
947498 | 947498 | 2021-01-20 | Pike | Kentucky | 21195 | 4023 | 38 |
906139 | 906139 | 2021-01-07 | Columbus | North Carolina | 37047 | 4023 | 87 |
883770 | 883770 | 2020-12-31 | Clearfield | Pennsylvania | 42033 | 4023 | 50 |
875155 | 875155 | 2020-12-29 | Lonoke | Arkansas | 5085 | 4023 | 77 |
867704 | 867704 | 2020-12-26 | Greenwood | South Carolina | 45047 | 4023 | 92 |
842708 | 842708 | 2020-12-19 | Mississippi | Arkansas | 5093 | 4023 | 90 |
807822 | 807822 | 2020-12-08 | Riley | Kansas | 20161 | 4023 | 16 |
804577 | 804577 | 2020-12-07 | Riley | Kansas | 20161 | 4023 | 16 |
803566 | 803566 | 2020-12-06 | Shawano | Wisconsin | 55115 | 4023 | 55 |
791413 | 791413 | 2020-12-03 | Wayne | Indiana | 18177 | 4023 | 95 |
780651 | 780651 | 2020-11-29 | Newport News city | Virginia | 51700 | 4023 | 55 |
651330 | 651330 | 2020-10-21 | Placer | California | 6061 | 4023 | 55 |
652241 | 652241 | 2020-10-21 | Bossier | Louisiana | 22015 | 4023 | 117 |
520112 | 520112 | 2020-09-10 | Onondaga | New York | 36067 | 4023 | 179 |
517829 | 517829 | 2020-09-09 | Smith | Texas | 48423 | 4023 | 78 |
309416 | 309416 | 2020-07-07 | San Francisco | California | 6075 | 4023 | 50 |
222613 | 222613 | 2020-06-09 | East Baton Rouge | Louisiana | 22033 | 4023 | 252 |
96442 | 96442 | 2020-04-28 | Montgomery | Maryland | 24031 | 4023 | 221 |
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);