ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where cases = 5042 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 14
- Kentucky 11
- Illinois 10
- Tennessee 7
- Texas 5
- Indiana 4
- New York 4
- Iowa 3
- North Carolina 3
- Wisconsin 3
- Arkansas 2
- California 2
- Michigan 2
- Mississippi 2
- Pennsylvania 2
- Puerto Rico 2
- South Dakota 2
- Virginia 2
- West Virginia 2
- Alaska 1
- Connecticut 1
- Florida 1
- Idaho 1
- Minnesota 1
- Nevada 1
- New Jersey 1
- New Mexico 1
- North Dakota 1
- Oregon 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2483962 | 2483962 | 2022-05-08 | Pike | Illinois | 17149 | 5042 | 70 |
2480704 | 2480704 | 2022-05-07 | Pike | Illinois | 17149 | 5042 | 70 |
2477446 | 2477446 | 2022-05-06 | Pike | Illinois | 17149 | 5042 | 70 |
2474188 | 2474188 | 2022-05-05 | Pike | Illinois | 17149 | 5042 | 70 |
2451483 | 2451483 | 2022-04-28 | Orange | Indiana | 18117 | 5042 | 96 |
2448227 | 2448227 | 2022-04-27 | Orange | Indiana | 18117 | 5042 | 96 |
2416009 | 2416009 | 2022-04-17 | Rockcastle | Kentucky | 21203 | 5042 | 58 |
2412753 | 2412753 | 2022-04-16 | Rockcastle | Kentucky | 21203 | 5042 | 58 |
2409497 | 2409497 | 2022-04-15 | Rockcastle | Kentucky | 21203 | 5042 | 58 |
2406241 | 2406241 | 2022-04-14 | Rockcastle | Kentucky | 21203 | 5042 | 58 |
2402985 | 2402985 | 2022-04-13 | Rockcastle | Kentucky | 21203 | 5042 | 58 |
2399731 | 2399731 | 2022-04-12 | Rockcastle | Kentucky | 21203 | 5042 | 58 |
2396475 | 2396475 | 2022-04-11 | Rockcastle | Kentucky | 21203 | 5042 | 58 |
2353555 | 2353555 | 2022-03-29 | McDuffie | Georgia | 13189 | 5042 | 93 |
2347037 | 2347037 | 2022-03-27 | Jones | Georgia | 13169 | 5042 | 108 |
2343784 | 2343784 | 2022-03-26 | Jones | Georgia | 13169 | 5042 | 108 |
2340531 | 2340531 | 2022-03-25 | Jones | Georgia | 13169 | 5042 | 108 |
2265398 | 2265398 | 2022-03-02 | Logan | Arkansas | 5083 | 5042 | 70 |
2268426 | 2268426 | 2022-03-02 | Green Lake | Wisconsin | 55047 | 5042 | 58 |
2217105 | 2217105 | 2022-02-15 | Edgar | Illinois | 17045 | 5042 | 77 |
2196596 | 2196596 | 2022-02-08 | Carbon | Utah | 49007 | 5042 | 43 |
2186328 | 2186328 | 2022-02-05 | Las Piedras | Puerto Rico | 72085 | 5042 | |
2177026 | 2177026 | 2022-02-02 | San Jacinto | Texas | 48407 | 5042 | 91 |
2170487 | 2170487 | 2022-01-31 | Moore | Texas | 48341 | 5042 | 104 |
2141059 | 2141059 | 2022-01-22 | Calhoun | Texas | 48057 | 5042 | 40 |
2127917 | 2127917 | 2022-01-18 | Yankton | South Dakota | 46135 | 5042 | 47 |
2110611 | 2110611 | 2022-01-13 | Sunflower | Mississippi | 28133 | 5042 | 111 |
2099962 | 2099962 | 2022-01-10 | Latah | Idaho | 16057 | 5042 | 41 |
2082800 | 2082800 | 2022-01-04 | Amherst | Virginia | 51009 | 5042 | 63 |
2077092 | 2077092 | 2022-01-03 | Lee | Georgia | 13177 | 5042 | 85 |
2073841 | 2073841 | 2022-01-02 | Lee | Georgia | 13177 | 5042 | 85 |
2070590 | 2070590 | 2022-01-01 | Lee | Georgia | 13177 | 5042 | 85 |
2067339 | 2067339 | 2021-12-31 | Lee | Georgia | 13177 | 5042 | 85 |
2014118 | 2014118 | 2021-12-14 | Meade | South Dakota | 46093 | 5042 | 55 |
2006129 | 2006129 | 2021-12-12 | Carter | Kentucky | 21043 | 5042 | 73 |
2002878 | 2002878 | 2021-12-11 | Carter | Kentucky | 21043 | 5042 | 73 |
1999628 | 1999628 | 2021-12-10 | Carter | Kentucky | 21043 | 5042 | 73 |
1996758 | 1996758 | 2021-12-09 | Todd | Minnesota | 27153 | 5042 | 45 |
1937011 | 1937011 | 2021-11-21 | Poinsett | Arkansas | 5111 | 5042 | 102 |
1906200 | 1906200 | 2021-11-11 | Chenango | New York | 36017 | 5042 | 94 |
1856378 | 1856378 | 2021-10-27 | Ripley | Indiana | 18137 | 5042 | 89 |
1844913 | 1844913 | 2021-10-23 | McKean | Pennsylvania | 42083 | 5042 | 86 |
1745805 | 1745805 | 2021-09-23 | Morgan | Illinois | 17137 | 5042 | 117 |
1741745 | 1741745 | 2021-09-21 | Fayette | West Virginia | 54019 | 5042 | 98 |
1721762 | 1721762 | 2021-09-15 | White | Tennessee | 47185 | 5042 | 83 |
1718459 | 1718459 | 2021-09-14 | Henderson | Tennessee | 47077 | 5042 | 83 |
1688531 | 1688531 | 2021-09-05 | Madison | New York | 36053 | 5042 | 91 |
1648305 | 1648305 | 2021-08-24 | Effingham | Illinois | 17049 | 5042 | 87 |
1643776 | 1643776 | 2021-08-22 | Obion | Tennessee | 47131 | 5042 | 99 |
1640526 | 1640526 | 2021-08-21 | Obion | Tennessee | 47131 | 5042 | 99 |
1640670 | 1640670 | 2021-08-21 | Howard | Texas | 48227 | 5042 | 104 |
1637276 | 1637276 | 2021-08-20 | Obion | Tennessee | 47131 | 5042 | 99 |
1628055 | 1628055 | 2021-08-17 | Jefferson | West Virginia | 54037 | 5042 | 60 |
1585953 | 1585953 | 2021-08-04 | Sweetwater | Wyoming | 56037 | 5042 | 45 |
1579378 | 1579378 | 2021-08-02 | Douglas | Wisconsin | 55031 | 5042 | 66 |
1562233 | 1562233 | 2021-07-28 | Yamhill | Oregon | 41071 | 5042 | 81 |
1562398 | 1562398 | 2021-07-28 | Chesterfield | South Carolina | 45025 | 5042 | 108 |
1532742 | 1532742 | 2021-07-19 | Watauga | North Carolina | 37189 | 5042 | 33 |
1514311 | 1514311 | 2021-07-13 | Washington | Virginia | 51191 | 5042 | 111 |
1493839 | 1493839 | 2021-07-07 | Williams | North Dakota | 38105 | 5042 | 40 |
1411133 | 1411133 | 2021-06-12 | Murray | Georgia | 13213 | 5042 | 91 |
1401397 | 1401397 | 2021-06-09 | Murray | Georgia | 13213 | 5042 | 90 |
1394905 | 1394905 | 2021-06-07 | Murray | Georgia | 13213 | 5042 | 90 |
1383196 | 1383196 | 2021-06-03 | Elko | Nevada | 32007 | 5042 | 56 |
1352854 | 1352854 | 2021-05-25 | Henry | Illinois | 17073 | 5042 | 97 |
1343594 | 1343594 | 2021-05-22 | Whitley | Kentucky | 21235 | 5042 | 57 |
1336620 | 1336620 | 2021-05-20 | Jackson | Illinois | 17077 | 5042 | 75 |
1293697 | 1293697 | 2021-05-06 | Dunn | Wisconsin | 55033 | 5042 | 32 |
1216724 | 1216724 | 2021-04-13 | Sioux | Iowa | 19167 | 5042 | 73 |
1178689 | 1178689 | 2021-04-01 | Curry | New Mexico | 35009 | 5042 | 72 |
1149451 | 1149451 | 2021-03-23 | Salem | New Jersey | 34033 | 5042 | 167 |
1125564 | 1125564 | 2021-03-16 | Knox | Illinois | 17095 | 5042 | 164 |
1126783 | 1126783 | 2021-03-16 | Jefferson | New York | 36045 | 5042 | 63 |
1127191 | 1127191 | 2021-03-16 | Carbon | Pennsylvania | 42025 | 5042 | 155 |
1106256 | 1106256 | 2021-03-10 | Clinton | Iowa | 19045 | 5042 | 87 |
1100891 | 1100891 | 2021-03-08 | Halifax | North Carolina | 37083 | 5042 | 100 |
1077485 | 1077485 | 2021-03-01 | Clinton | Michigan | 26037 | 5042 | 70 |
1021553 | 1021553 | 2021-02-12 | Polk | Georgia | 13233 | 5042 | 70 |
993328 | 993328 | 2021-02-03 | Washington | Mississippi | 28151 | 5042 | 125 |
982816 | 982816 | 2021-01-31 | Dearborn | Indiana | 18029 | 5042 | 49 |
974931 | 974931 | 2021-01-28 | Jefferson | Tennessee | 47089 | 5042 | 83 |
949867 | 949867 | 2021-01-21 | San Benito | California | 6069 | 5042 | 46 |
940284 | 940284 | 2021-01-18 | Putnam | Florida | 12107 | 5042 | 89 |
872154 | 872154 | 2020-12-28 | Barrow | Georgia | 13013 | 5042 | 65 |
862217 | 862217 | 2020-12-25 | El Dorado | California | 6017 | 5042 | 13 |
858141 | 858141 | 2020-12-23 | Tipton | Tennessee | 47167 | 5042 | 51 |
853575 | 853575 | 2020-12-22 | Lenawee | Michigan | 26091 | 5042 | 64 |
829880 | 829880 | 2020-12-15 | Middlesex | Connecticut | 9007 | 5042 | 220 |
806930 | 806930 | 2020-12-08 | Matanuska-Susitna Borough | Alaska | 2170 | 5042 | 8 |
685888 | 685888 | 2020-10-31 | Bayamon | Puerto Rico | 72021 | 5042 | |
554738 | 554738 | 2020-09-21 | Woodbury | Iowa | 19193 | 5042 | 63 |
542746 | 542746 | 2020-09-17 | Dutchess | New York | 36027 | 5042 | 156 |
384644 | 384644 | 2020-07-30 | Guilford | North Carolina | 37081 | 5042 | 142 |
369478 | 369478 | 2020-07-25 | Webb | Texas | 48479 | 5042 | 99 |
265510 | 265510 | 2020-06-23 | DeKalb | Georgia | 13089 | 5042 | 166 |
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);