ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
97 rows where cases = 4596 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Florida 9
- Georgia 9
- Mississippi 9
- Pennsylvania 8
- Wisconsin 8
- Virginia 5
- North Carolina 4
- Oregon 4
- West Virginia 4
- Michigan 3
- Puerto Rico 3
- South Carolina 3
- South Dakota 3
- Alabama 2
- Arizona 2
- Arkansas 2
- Illinois 2
- Indiana 2
- Iowa 2
- Tennessee 2
- Texas 2
- California 1
- Kansas 1
- Kentucky 1
- Louisiana 1
- Minnesota 1
- New Mexico 1
- New York 1
- Ohio 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502046 | 2502046 | 2022-05-13 | Beadle | South Dakota | 46005 | 4596 | 60 |
2498788 | 2498788 | 2022-05-12 | Beadle | South Dakota | 46005 | 4596 | 60 |
2495530 | 2495530 | 2022-05-11 | Beadle | South Dakota | 46005 | 4596 | 60 |
2492119 | 2492119 | 2022-05-10 | Montour | Pennsylvania | 42093 | 4596 | 93 |
2488861 | 2488861 | 2022-05-09 | Montour | Pennsylvania | 42093 | 4596 | 93 |
2485604 | 2485604 | 2022-05-08 | Montour | Pennsylvania | 42093 | 4596 | 93 |
2486505 | 2486505 | 2022-05-08 | Sawyer | Wisconsin | 55113 | 4596 | 62 |
2482346 | 2482346 | 2022-05-07 | Montour | Pennsylvania | 42093 | 4596 | 93 |
2483247 | 2483247 | 2022-05-07 | Sawyer | Wisconsin | 55113 | 4596 | 62 |
2479088 | 2479088 | 2022-05-06 | Montour | Pennsylvania | 42093 | 4596 | 93 |
2479989 | 2479989 | 2022-05-06 | Sawyer | Wisconsin | 55113 | 4596 | 62 |
2475830 | 2475830 | 2022-05-05 | Montour | Pennsylvania | 42093 | 4596 | 93 |
2472573 | 2472573 | 2022-05-04 | Montour | Pennsylvania | 42093 | 4596 | 93 |
2453534 | 2453534 | 2022-04-28 | Panola | Texas | 48365 | 4596 | 129 |
2371571 | 2371571 | 2022-04-03 | Clatsop | Oregon | 41007 | 4596 | 47 |
2368318 | 2368318 | 2022-04-02 | Clatsop | Oregon | 41007 | 4596 | 47 |
2365065 | 2365065 | 2022-04-01 | Clatsop | Oregon | 41007 | 4596 | 47 |
2355455 | 2355455 | 2022-03-29 | Morovis | Puerto Rico | 72101 | 4596 | |
2352202 | 2352202 | 2022-03-28 | Morovis | Puerto Rico | 72101 | 4596 | |
2271655 | 2271655 | 2022-03-03 | Adams | Wisconsin | 55001 | 4596 | 53 |
2240588 | 2240588 | 2022-02-22 | Fillmore | Minnesota | 27045 | 4596 | 22 |
2210528 | 2210528 | 2022-02-13 | Worth | Georgia | 13321 | 4596 | 105 |
2207275 | 2207275 | 2022-02-12 | Worth | Georgia | 13321 | 4596 | 105 |
2204022 | 2204022 | 2022-02-11 | Worth | Georgia | 13321 | 4596 | 105 |
2171106 | 2171106 | 2022-02-01 | Phillips | Arkansas | 5107 | 4596 | 84 |
2109633 | 2109633 | 2022-01-13 | Pike | Georgia | 13231 | 4596 | 74 |
2017992 | 2017992 | 2021-12-15 | Nicholas | West Virginia | 54067 | 4596 | 71 |
1971756 | 1971756 | 2021-12-01 | Trujillo Alto | Puerto Rico | 72139 | 4596 | |
1955187 | 1955187 | 2021-11-26 | Gallia | Ohio | 39053 | 4596 | 78 |
1904730 | 1904730 | 2021-11-11 | Taylor | Florida | 12123 | 4596 | 80 |
1901480 | 1901480 | 2021-11-10 | Taylor | Florida | 12123 | 4596 | 80 |
1898230 | 1898230 | 2021-11-09 | Taylor | Florida | 12123 | 4596 | 80 |
1900905 | 1900905 | 2021-11-09 | Wythe | Virginia | 51197 | 4596 | 103 |
1894980 | 1894980 | 2021-11-08 | Taylor | Florida | 12123 | 4596 | 80 |
1891730 | 1891730 | 2021-11-07 | Taylor | Florida | 12123 | 4596 | 79 |
1888480 | 1888480 | 2021-11-06 | Taylor | Florida | 12123 | 4596 | 79 |
1885230 | 1885230 | 2021-11-05 | Taylor | Florida | 12123 | 4596 | 79 |
1875138 | 1875138 | 2021-11-02 | Lawrence | Alabama | 1079 | 4596 | 118 |
1867675 | 1867675 | 2021-10-30 | Tioga | Pennsylvania | 42117 | 4596 | 130 |
1858733 | 1858733 | 2021-10-27 | Mingo | West Virginia | 54059 | 4596 | 81 |
1824556 | 1824556 | 2021-10-17 | Itawamba | Mississippi | 28057 | 4596 | 104 |
1821307 | 1821307 | 2021-10-16 | Itawamba | Mississippi | 28057 | 4596 | 104 |
1818058 | 1818058 | 2021-10-15 | Itawamba | Mississippi | 28057 | 4596 | 104 |
1813552 | 1813552 | 2021-10-14 | Yell | Arkansas | 5149 | 4596 | 77 |
1801825 | 1801825 | 2021-10-10 | Leflore | Mississippi | 28083 | 4596 | 142 |
1798576 | 1798576 | 2021-10-09 | Leflore | Mississippi | 28083 | 4596 | 142 |
1795327 | 1795327 | 2021-10-08 | Leflore | Mississippi | 28083 | 4596 | 142 |
1768999 | 1768999 | 2021-09-30 | Allen | Louisiana | 22003 | 4596 | 107 |
1732683 | 1732683 | 2021-09-19 | White | Georgia | 13311 | 4596 | 110 |
1729433 | 1729433 | 2021-09-18 | White | Georgia | 13311 | 4596 | 110 |
1726183 | 1726183 | 2021-09-17 | White | Georgia | 13311 | 4596 | 110 |
1702657 | 1702657 | 2021-09-09 | Manassas city | Virginia | 51683 | 4596 | 49 |
1633435 | 1633435 | 2021-08-19 | Yadkin | North Carolina | 37197 | 4596 | 57 |
1539109 | 1539109 | 2021-07-21 | Madison | New York | 36053 | 4596 | 89 |
1377734 | 1377734 | 2021-06-01 | Nacogdoches | Texas | 48347 | 4596 | 171 |
1354479 | 1354479 | 2021-05-25 | Yamhill | Oregon | 41071 | 4596 | 76 |
1338518 | 1338518 | 2021-05-20 | Cheatham | Tennessee | 47021 | 4596 | 56 |
1324461 | 1324461 | 2021-05-16 | Panola | Mississippi | 28107 | 4596 | 107 |
1321215 | 1321215 | 2021-05-15 | Panola | Mississippi | 28107 | 4596 | 107 |
1317969 | 1317969 | 2021-05-14 | Panola | Mississippi | 28107 | 4596 | 107 |
1296964 | 1296964 | 2021-05-07 | Marinette | Wisconsin | 55075 | 4596 | 70 |
1264212 | 1264212 | 2021-04-27 | Wasatch | Utah | 49051 | 4596 | 21 |
1248198 | 1248198 | 2021-04-22 | Mercer | West Virginia | 54055 | 4596 | 125 |
1235985 | 1235985 | 2021-04-19 | Livingston | Illinois | 17105 | 4596 | 95 |
1235988 | 1235988 | 2021-04-19 | Macoupin | Illinois | 17117 | 4596 | 110 |
1193061 | 1193061 | 2021-04-05 | Pierce | Wisconsin | 55093 | 4596 | 41 |
1064101 | 1064101 | 2021-02-25 | Marshall | Iowa | 19127 | 4596 | 72 |
1050281 | 1050281 | 2021-02-21 | Dale | Alabama | 1045 | 4596 | 106 |
962314 | 962314 | 2021-01-24 | Augusta | Virginia | 51015 | 4596 | 44 |
957014 | 957014 | 2021-01-23 | Sioux | Iowa | 19167 | 4596 | 57 |
928028 | 928028 | 2021-01-14 | Pulaski | Kentucky | 21199 | 4596 | 66 |
923903 | 923903 | 2021-01-13 | San Benito | California | 6069 | 4596 | 41 |
904946 | 904946 | 2021-01-07 | Henry | Indiana | 18065 | 4596 | 61 |
897648 | 897648 | 2021-01-04 | Grant | Wisconsin | 55043 | 4596 | 82 |
888081 | 888081 | 2021-01-02 | Gila | Arizona | 4007 | 4596 | 136 |
878600 | 878600 | 2020-12-30 | Jackson | Florida | 12063 | 4596 | 118 |
871718 | 871718 | 2020-12-27 | Sauk | Wisconsin | 55111 | 4596 | 31 |
849439 | 849439 | 2020-12-21 | Barrow | Georgia | 13013 | 4596 | 63 |
846328 | 846328 | 2020-12-20 | Troup | Georgia | 13285 | 4596 | 127 |
846521 | 846521 | 2020-12-20 | Floyd | Indiana | 18043 | 4596 | 91 |
847073 | 847073 | 2020-12-20 | Ionia | Michigan | 26067 | 4596 | 41 |
843827 | 843827 | 2020-12-19 | Ionia | Michigan | 26067 | 4596 | 41 |
845678 | 845678 | 2020-12-19 | Monongalia | West Virginia | 54061 | 4596 | 16 |
755273 | 755273 | 2020-11-22 | Hernando | Florida | 12053 | 4596 | 197 |
699872 | 699872 | 2020-11-05 | Mohave | Arizona | 4015 | 4596 | 237 |
665921 | 665921 | 2020-10-25 | McKinley | New Mexico | 35031 | 4596 | 261 |
643809 | 643809 | 2020-10-18 | Dorchester | South Carolina | 45035 | 4596 | 94 |
552596 | 552596 | 2020-09-20 | Union | North Carolina | 37179 | 4596 | 58 |
549357 | 549357 | 2020-09-19 | Union | North Carolina | 37179 | 4596 | 58 |
546118 | 546118 | 2020-09-18 | Union | North Carolina | 37179 | 4596 | 58 |
520694 | 520694 | 2020-09-10 | York | South Carolina | 45091 | 4596 | 57 |
468917 | 468917 | 2020-08-25 | Beaufort | South Carolina | 45013 | 4596 | 64 |
437166 | 437166 | 2020-08-15 | Chesterfield | Virginia | 51041 | 4596 | 80 |
393366 | 393366 | 2020-08-02 | Wyandotte | Kansas | 20209 | 4596 | 95 |
347177 | 347177 | 2020-07-18 | Loudoun | Virginia | 51107 | 4596 | 103 |
260079 | 260079 | 2020-06-21 | Kent | Michigan | 26081 | 4596 | 124 |
168706 | 168706 | 2020-05-22 | Davidson | Tennessee | 47037 | 4596 | 52 |
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);