ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
125 rows where cases = 4268 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 28
- Mississippi 8
- Kansas 7
- South Carolina 7
- Kentucky 6
- Georgia 5
- Illinois 5
- Indiana 5
- Missouri 5
- Virginia 5
- Alabama 3
- Alaska 3
- Michigan 3
- Nevada 3
- New York 3
- Pennsylvania 3
- Wisconsin 3
- Iowa 2
- Louisiana 2
- Minnesota 2
- Ohio 2
- Puerto Rico 2
- Washington 2
- Arkansas 1
- California 1
- Colorado 1
- Florida 1
- Maine 1
- Maryland 1
- New Jersey 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500287 | 2500287 | 2022-05-13 | Carroll | Indiana | 18015 | 4268 | 68 |
2489317 | 2489317 | 2022-05-09 | Lavaca | Texas | 48285 | 4268 | 120 |
2476287 | 2476287 | 2022-05-05 | Lee | Texas | 48287 | 4268 | 60 |
2448073 | 2448073 | 2022-04-27 | Carroll | Illinois | 17015 | 4268 | 49 |
2331195 | 2331195 | 2022-03-22 | Atchison | Kansas | 20005 | 4268 | 33 |
2327943 | 2327943 | 2022-03-21 | Atchison | Kansas | 20005 | 4268 | 33 |
2324690 | 2324690 | 2022-03-20 | Atchison | Kansas | 20005 | 4268 | 33 |
2321436 | 2321436 | 2022-03-19 | Atchison | Kansas | 20005 | 4268 | 33 |
2318182 | 2318182 | 2022-03-18 | Atchison | Kansas | 20005 | 4268 | 33 |
2314929 | 2314929 | 2022-03-17 | Atchison | Kansas | 20005 | 4268 | 33 |
2311676 | 2311676 | 2022-03-16 | Atchison | Kansas | 20005 | 4268 | 33 |
2271266 | 2271266 | 2022-03-03 | Lamb | Texas | 48279 | 4268 | 121 |
2268014 | 2268014 | 2022-03-02 | Lamb | Texas | 48279 | 4268 | 120 |
2240546 | 2240546 | 2022-02-22 | Ogemaw | Michigan | 26129 | 4268 | 95 |
2237295 | 2237295 | 2022-02-21 | Ogemaw | Michigan | 26129 | 4268 | 95 |
2234044 | 2234044 | 2022-02-20 | Ogemaw | Michigan | 26129 | 4268 | 95 |
2217627 | 2217627 | 2022-02-15 | Jackson | Louisiana | 22049 | 4268 | 70 |
2176509 | 2176509 | 2022-02-02 | Montour | Pennsylvania | 42093 | 4268 | 85 |
2134595 | 2134595 | 2022-01-20 | Fayette | Texas | 48149 | 4268 | 94 |
2118284 | 2118284 | 2022-01-15 | Burleson | Texas | 48051 | 4268 | 61 |
2107100 | 2107100 | 2022-01-12 | Somerset | Maryland | 24039 | 4268 | 62 |
2082886 | 2082886 | 2022-01-04 | Page | Virginia | 51139 | 4268 | 92 |
2061003 | 2061003 | 2021-12-29 | Jersey | Illinois | 17083 | 4268 | 76 |
2053327 | 2053327 | 2021-12-26 | Gray | Texas | 48179 | 4268 | 90 |
2050077 | 2050077 | 2021-12-25 | Gray | Texas | 48179 | 4268 | 90 |
2046827 | 2046827 | 2021-12-24 | Gray | Texas | 48179 | 4268 | 90 |
2043577 | 2043577 | 2021-12-23 | Gray | Texas | 48179 | 4268 | 90 |
2011340 | 2011340 | 2021-12-13 | Halifax | Virginia | 51083 | 4268 | 117 |
1996422 | 1996422 | 2021-12-09 | Letcher | Kentucky | 21133 | 4268 | 80 |
1921086 | 1921086 | 2021-11-16 | Monroe | Georgia | 13207 | 4268 | 149 |
1920373 | 1920373 | 2021-11-15 | Pulaski | Virginia | 51155 | 4268 | 92 |
1896078 | 1896078 | 2021-11-08 | Sunflower | Mississippi | 28133 | 4268 | 105 |
1883923 | 1883923 | 2021-11-04 | Warren | Pennsylvania | 42123 | 4268 | 135 |
1878851 | 1878851 | 2021-11-03 | Pierce | Georgia | 13229 | 4268 | 103 |
1875602 | 1875602 | 2021-11-02 | Pierce | Georgia | 13229 | 4268 | 102 |
1808734 | 1808734 | 2021-10-12 | Greene | New York | 36039 | 4268 | 85 |
1732168 | 1732168 | 2021-09-19 | Geneva | Alabama | 1061 | 4268 | 106 |
1733617 | 1733617 | 2021-09-19 | Simpson | Mississippi | 28127 | 4268 | 111 |
1730367 | 1730367 | 2021-09-18 | Simpson | Mississippi | 28127 | 4268 | 111 |
1727117 | 1727117 | 2021-09-17 | Simpson | Mississippi | 28127 | 4268 | 111 |
1717279 | 1717279 | 2021-09-14 | Polk | Minnesota | 27119 | 4268 | 75 |
1672816 | 1672816 | 2021-08-31 | Trujillo Alto | Puerto Rico | 72139 | 4268 | |
1629656 | 1629656 | 2021-08-18 | Pike | Mississippi | 28113 | 4268 | 117 |
1564681 | 1564681 | 2021-07-29 | Neshoba | Mississippi | 28099 | 4268 | 181 |
1553655 | 1553655 | 2021-07-26 | Union | Arkansas | 5139 | 4268 | 116 |
1497724 | 1497724 | 2021-07-08 | Erath | Texas | 48143 | 4268 | 70 |
1468238 | 1468238 | 2021-06-29 | Chester | South Carolina | 45023 | 4268 | 76 |
1464993 | 1464993 | 2021-06-28 | Chester | South Carolina | 45023 | 4268 | 76 |
1460903 | 1460903 | 2021-06-27 | Platte | Missouri | 29165 | 4268 | 48 |
1457658 | 1457658 | 2021-06-26 | Platte | Missouri | 29165 | 4268 | 48 |
1444604 | 1444604 | 2021-06-22 | Butler | Missouri | 29023 | 4268 | 50 |
1445522 | 1445522 | 2021-06-22 | Chester | South Carolina | 45023 | 4268 | 76 |
1442277 | 1442277 | 2021-06-21 | Chester | South Carolina | 45023 | 4268 | 76 |
1439032 | 1439032 | 2021-06-20 | Chester | South Carolina | 45023 | 4268 | 76 |
1435785 | 1435785 | 2021-06-19 | Chester | South Carolina | 45023 | 4268 | 76 |
1432538 | 1432538 | 2021-06-18 | Chester | South Carolina | 45023 | 4268 | 76 |
1428377 | 1428377 | 2021-06-17 | Camden | Missouri | 29029 | 4268 | 89 |
1421180 | 1421180 | 2021-06-15 | Buena Vista | Iowa | 19021 | 4268 | 40 |
1404356 | 1404356 | 2021-06-10 | Mendocino | California | 6045 | 4268 | 50 |
1397070 | 1397070 | 2021-06-07 | Cherokee | Texas | 48073 | 4268 | 143 |
1393823 | 1393823 | 2021-06-06 | Cherokee | Texas | 48073 | 4268 | 143 |
1390578 | 1390578 | 2021-06-05 | Cherokee | Texas | 48073 | 4268 | 143 |
1387333 | 1387333 | 2021-06-04 | Cherokee | Texas | 48073 | 4268 | 143 |
1384088 | 1384088 | 2021-06-03 | Cherokee | Texas | 48073 | 4268 | 142 |
1338628 | 1338628 | 2021-05-20 | Brown | Texas | 48049 | 4268 | 137 |
1333491 | 1333491 | 2021-05-19 | Montgomery | Indiana | 18107 | 4268 | 91 |
1335381 | 1335381 | 2021-05-19 | Brown | Texas | 48049 | 4268 | 137 |
1332134 | 1332134 | 2021-05-18 | Brown | Texas | 48049 | 4268 | 137 |
1328887 | 1328887 | 2021-05-17 | Brown | Texas | 48049 | 4268 | 137 |
1325641 | 1325641 | 2021-05-16 | Brown | Texas | 48049 | 4268 | 137 |
1322395 | 1322395 | 2021-05-15 | Brown | Texas | 48049 | 4268 | 137 |
1319149 | 1319149 | 2021-05-14 | Brown | Texas | 48049 | 4268 | 137 |
1294493 | 1294493 | 2021-05-07 | DeKalb | Indiana | 18033 | 4268 | 87 |
1292657 | 1292657 | 2021-05-06 | Putnam | Ohio | 39137 | 4268 | 100 |
1284752 | 1284752 | 2021-05-04 | Clinton | Indiana | 18023 | 4268 | 58 |
1283647 | 1283647 | 2021-05-03 | Van Zandt | Texas | 48467 | 4268 | 117 |
1280400 | 1280400 | 2021-05-02 | Van Zandt | Texas | 48467 | 4268 | 117 |
1277153 | 1277153 | 2021-05-01 | Van Zandt | Texas | 48467 | 4268 | 117 |
1273906 | 1273906 | 2021-04-30 | Van Zandt | Texas | 48467 | 4268 | 117 |
1241537 | 1241537 | 2021-04-20 | Danville city | Virginia | 51590 | 4268 | 134 |
1232162 | 1232162 | 2021-04-18 | Kenai Peninsula Borough | Alaska | 2122 | 4268 | 19 |
1228914 | 1228914 | 2021-04-17 | Kenai Peninsula Borough | Alaska | 2122 | 4268 | 19 |
1225666 | 1225666 | 2021-04-16 | Kenai Peninsula Borough | Alaska | 2122 | 4268 | 19 |
1223075 | 1223075 | 2021-04-15 | Harrison | Indiana | 18061 | 4268 | 72 |
1202910 | 1202910 | 2021-04-09 | Russell | Alabama | 1113 | 4268 | 37 |
1187617 | 1187617 | 2021-04-04 | Barren | Kentucky | 21009 | 4268 | 86 |
1184370 | 1184370 | 2021-04-03 | Barren | Kentucky | 21009 | 4268 | 86 |
1181123 | 1181123 | 2021-04-02 | Barren | Kentucky | 21009 | 4268 | 85 |
1177498 | 1177498 | 2021-04-01 | Franklin | Illinois | 17055 | 4268 | 82 |
1171568 | 1171568 | 2021-03-30 | Kennebec | Maine | 23011 | 4268 | 57 |
1145809 | 1145809 | 2021-03-22 | Winona | Minnesota | 27169 | 4268 | 49 |
1121408 | 1121408 | 2021-03-14 | Henry | Virginia | 51089 | 4268 | 119 |
1109742 | 1109742 | 2021-03-11 | Jessamine | Kentucky | 21113 | 4268 | 55 |
1105359 | 1105359 | 2021-03-09 | Douglas | Wisconsin | 55031 | 4268 | 43 |
1083373 | 1083373 | 2021-03-03 | Marion | Illinois | 17121 | 4268 | 118 |
1064710 | 1064710 | 2021-02-25 | Panola | Mississippi | 28107 | 4268 | 92 |
1043423 | 1043423 | 2021-02-18 | Wasatch | Utah | 49051 | 4268 | 19 |
1028175 | 1028175 | 2021-02-14 | Henry | Illinois | 17073 | 4268 | 82 |
1017750 | 1017750 | 2021-02-10 | Monroe | Wisconsin | 55081 | 4268 | 31 |
997132 | 997132 | 2021-02-04 | Stark | North Dakota | 38089 | 4268 | 48 |
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);