ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where cases = 4747 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Missouri 9
- Illinois 8
- Texas 8
- North Carolina 7
- Oklahoma 7
- Indiana 5
- Kansas 5
- Mississippi 5
- Ohio 5
- Virginia 5
- Wisconsin 5
- Colorado 4
- Georgia 4
- Louisiana 4
- Michigan 4
- Minnesota 4
- Pennsylvania 3
- Alabama 2
- Arkansas 2
- Maryland 2
- Hawaii 1
- Nevada 1
- New York 1
- North Dakota 1
- Oregon 1
- Puerto Rico 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490415 | 2490415 | 2022-05-10 | Clay | Illinois | 17025 | 4747 | 74 |
2487158 | 2487158 | 2022-05-09 | Clay | Illinois | 17025 | 4747 | 74 |
2483900 | 2483900 | 2022-05-08 | Clay | Illinois | 17025 | 4747 | 74 |
2480642 | 2480642 | 2022-05-07 | Clay | Illinois | 17025 | 4747 | 74 |
2477384 | 2477384 | 2022-05-06 | Clay | Illinois | 17025 | 4747 | 74 |
2383128 | 2383128 | 2022-04-07 | Starke | Indiana | 18149 | 4747 | 97 |
2379873 | 2379873 | 2022-04-06 | Starke | Indiana | 18149 | 4747 | 97 |
2307829 | 2307829 | 2022-03-15 | Teller | Colorado | 8119 | 4747 | 55 |
2308464 | 2308464 | 2022-03-15 | Jefferson | Kansas | 20087 | 4747 | 59 |
2305213 | 2305213 | 2022-03-14 | Jefferson | Kansas | 20087 | 4747 | 60 |
2306974 | 2306974 | 2022-03-14 | Fayette | Texas | 48149 | 4747 | 101 |
2185522 | 2185522 | 2022-02-05 | New Madrid | Missouri | 29143 | 4747 | 73 |
2172550 | 2172550 | 2022-02-01 | Vernon | Missouri | 29217 | 4747 | 95 |
2154382 | 2154382 | 2022-01-26 | Dinwiddie | Virginia | 51053 | 4747 | 63 |
2126612 | 2126612 | 2022-01-18 | Talbot | Maryland | 24041 | 4747 | 70 |
2124237 | 2124237 | 2022-01-17 | Holmes | Ohio | 39075 | 4747 | 161 |
2059769 | 2059769 | 2021-12-28 | Cass | Texas | 48067 | 4747 | 162 |
1996069 | 1996069 | 2021-12-09 | Clay | Indiana | 18021 | 4747 | 63 |
1974059 | 1974059 | 2021-12-02 | Leflore | Mississippi | 28083 | 4747 | 144 |
1940281 | 1940281 | 2021-11-22 | Yell | Arkansas | 5149 | 4747 | 81 |
1941498 | 1941498 | 2021-11-22 | Todd | Minnesota | 27153 | 4747 | 40 |
1941510 | 1941510 | 2021-11-22 | Adams | Mississippi | 28001 | 4747 | 125 |
1920473 | 1920473 | 2021-11-15 | Mingo | West Virginia | 54059 | 4747 | 83 |
1915217 | 1915217 | 2021-11-14 | Allen | Louisiana | 22003 | 4747 | 116 |
1911967 | 1911967 | 2021-11-13 | Allen | Louisiana | 22003 | 4747 | 116 |
1908718 | 1908718 | 2021-11-12 | Allen | Louisiana | 22003 | 4747 | 116 |
1898297 | 1898297 | 2021-11-09 | Gilmer | Georgia | 13123 | 4747 | 136 |
1883074 | 1883074 | 2021-11-04 | Scott | Mississippi | 28123 | 4747 | 98 |
1879825 | 1879825 | 2021-11-03 | Scott | Mississippi | 28123 | 4747 | 98 |
1846161 | 1846161 | 2021-10-24 | Summit | Colorado | 8117 | 4747 | 11 |
1842911 | 1842911 | 2021-10-23 | Summit | Colorado | 8117 | 4747 | 11 |
1839661 | 1839661 | 2021-10-22 | Summit | Colorado | 8117 | 4747 | 11 |
1809919 | 1809919 | 2021-10-12 | Warren | Virginia | 51187 | 4747 | 76 |
1771148 | 1771148 | 2021-10-01 | Dallas | Alabama | 1047 | 4747 | 190 |
1753242 | 1753242 | 2021-09-25 | Warren | Missouri | 29219 | 4747 | 40 |
1747226 | 1747226 | 2021-09-23 | Guernsey | Ohio | 39059 | 4747 | 64 |
1718021 | 1718021 | 2021-09-14 | Preble | Ohio | 39135 | 4747 | 110 |
1586687 | 1586687 | 2021-08-05 | Gibson | Indiana | 18051 | 4747 | 100 |
1580099 | 1580099 | 2021-08-03 | Jefferson | Illinois | 17081 | 4747 | 124 |
1555743 | 1555743 | 2021-07-26 | Bedford | Pennsylvania | 42009 | 4747 | 142 |
1552496 | 1552496 | 2021-07-25 | Bedford | Pennsylvania | 42009 | 4747 | 142 |
1549249 | 1549249 | 2021-07-24 | Bedford | Pennsylvania | 42009 | 4747 | 142 |
1515975 | 1515975 | 2021-07-14 | Pearl River | Mississippi | 28109 | 4747 | 148 |
1517463 | 1517463 | 2021-07-14 | Culpeper | Virginia | 51047 | 4747 | 67 |
1514216 | 1514216 | 2021-07-13 | Culpeper | Virginia | 51047 | 4747 | 67 |
1462515 | 1462515 | 2021-06-27 | Monroe | Wisconsin | 55081 | 4747 | 45 |
1459270 | 1459270 | 2021-06-26 | Monroe | Wisconsin | 55081 | 4747 | 45 |
1456025 | 1456025 | 2021-06-25 | Monroe | Wisconsin | 55081 | 4747 | 45 |
1452780 | 1452780 | 2021-06-24 | Monroe | Wisconsin | 55081 | 4747 | 45 |
1441444 | 1441444 | 2021-06-21 | Scott | Missouri | 29201 | 4747 | 87 |
1438198 | 1438198 | 2021-06-20 | Scott | Missouri | 29201 | 4747 | 87 |
1434951 | 1434951 | 2021-06-19 | Scott | Missouri | 29201 | 4747 | 87 |
1431704 | 1431704 | 2021-06-18 | Scott | Missouri | 29201 | 4747 | 87 |
1428459 | 1428459 | 2021-06-17 | Scott | Missouri | 29201 | 4747 | 87 |
1415805 | 1415805 | 2021-06-13 | Chatham | North Carolina | 37037 | 4747 | 89 |
1416145 | 1416145 | 2021-06-13 | Yamhill | Oregon | 41071 | 4747 | 79 |
1412559 | 1412559 | 2021-06-12 | Chatham | North Carolina | 37037 | 4747 | 89 |
1409314 | 1409314 | 2021-06-11 | Chatham | North Carolina | 37037 | 4747 | 89 |
1404703 | 1404703 | 2021-06-10 | Maui | Hawaii | 15009 | 4747 | 55 |
1405494 | 1405494 | 2021-06-10 | Douglas | Minnesota | 27041 | 4747 | 80 |
1402248 | 1402248 | 2021-06-09 | Douglas | Minnesota | 27041 | 4747 | 80 |
1402823 | 1402823 | 2021-06-09 | Chatham | North Carolina | 37037 | 4747 | 89 |
1374090 | 1374090 | 2021-05-31 | Toa Alta | Puerto Rico | 72135 | 4747 | |
1362581 | 1362581 | 2021-05-28 | Effingham | Illinois | 17049 | 4747 | 83 |
1359134 | 1359134 | 2021-05-27 | Colquitt | Georgia | 13071 | 4747 | 123 |
1281443 | 1281443 | 2021-05-03 | Livingston | Illinois | 17105 | 4747 | 96 |
1272596 | 1272596 | 2021-04-30 | Johnson | Missouri | 29101 | 4747 | 52 |
1273107 | 1273107 | 2021-04-30 | Williams | North Dakota | 38105 | 4747 | 38 |
1240347 | 1240347 | 2021-04-20 | Elko | Nevada | 32007 | 4747 | 55 |
1172594 | 1172594 | 2021-03-30 | Stephens | Oklahoma | 40137 | 4747 | 72 |
1169347 | 1169347 | 2021-03-29 | Stephens | Oklahoma | 40137 | 4747 | 72 |
1166099 | 1166099 | 2021-03-28 | Stephens | Oklahoma | 40137 | 4747 | 72 |
1162851 | 1162851 | 2021-03-27 | Stephens | Oklahoma | 40137 | 4747 | 72 |
1159602 | 1159602 | 2021-03-26 | Stephens | Oklahoma | 40137 | 4747 | 72 |
1156355 | 1156355 | 2021-03-25 | Stephens | Oklahoma | 40137 | 4747 | 72 |
1151629 | 1151629 | 2021-03-24 | Jackson | Indiana | 18071 | 4747 | 68 |
1153108 | 1153108 | 2021-03-24 | Stephens | Oklahoma | 40137 | 4747 | 72 |
1139234 | 1139234 | 2021-03-20 | Benton | Minnesota | 27009 | 4747 | 95 |
1130948 | 1130948 | 2021-03-17 | Medina | Texas | 48325 | 4747 | 101 |
1108632 | 1108632 | 2021-03-10 | Oconto | Wisconsin | 55083 | 4747 | 55 |
1087281 | 1087281 | 2021-03-04 | St. Joseph | Michigan | 26149 | 4747 | 85 |
1065342 | 1065342 | 2021-02-25 | Jefferson | Ohio | 39081 | 4747 | 107 |
1036752 | 1036752 | 2021-02-16 | Hardin | Texas | 48199 | 4747 | 89 |
1033507 | 1033507 | 2021-02-15 | Hardin | Texas | 48199 | 4747 | 89 |
1030261 | 1030261 | 2021-02-14 | Hardin | Texas | 48199 | 4747 | 89 |
1027014 | 1027014 | 2021-02-13 | Hardin | Texas | 48199 | 4747 | 87 |
1010013 | 1010013 | 2021-02-08 | Halifax | North Carolina | 37083 | 4747 | 86 |
989886 | 989886 | 2021-02-02 | Marquette | Michigan | 26103 | 4747 | 54 |
980062 | 980062 | 2021-01-30 | Cecil | Maryland | 24015 | 4747 | 111 |
946824 | 946824 | 2021-01-20 | Coffee | Georgia | 13069 | 4747 | 117 |
899710 | 899710 | 2021-01-05 | Surry | North Carolina | 37171 | 4747 | 84 |
869788 | 869788 | 2020-12-27 | Ionia | Michigan | 26067 | 4747 | 45 |
866543 | 866543 | 2020-12-26 | Ionia | Michigan | 26067 | 4747 | 45 |
854406 | 854406 | 2020-12-22 | Muskingum | Ohio | 39119 | 4747 | 27 |
828323 | 828323 | 2020-12-14 | Wilson | North Carolina | 37195 | 4747 | 89 |
801280 | 801280 | 2020-12-06 | Ford | Kansas | 20057 | 4747 | 10 |
798035 | 798035 | 2020-12-05 | Ford | Kansas | 20057 | 4747 | 10 |
794790 | 794790 | 2020-12-04 | Ford | Kansas | 20057 | 4747 | 10 |
774570 | 774570 | 2020-11-28 | Saline | Arkansas | 5125 | 4747 | 56 |
764687 | 764687 | 2020-11-25 | DeKalb | Alabama | 1049 | 4747 | 36 |
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);