ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
106 rows where cases = 4242 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 11
- North Carolina 10
- Louisiana 8
- West Virginia 7
- Indiana 5
- Mississippi 5
- Nebraska 5
- Virginia 5
- Georgia 4
- Michigan 4
- Ohio 4
- Tennessee 4
- Kentucky 3
- Maryland 3
- Minnesota 3
- Wyoming 3
- Arkansas 2
- Colorado 2
- Illinois 2
- Kansas 2
- Pennsylvania 2
- Puerto Rico 2
- Washington 2
- California 1
- Iowa 1
- Missouri 1
- Nevada 1
- North Dakota 1
- South Carolina 1
- Utah 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2446125 | 2446125 | 2022-04-26 | Bertie | North Carolina | 37015 | 4242 | 67 |
2447230 | 2447230 | 2022-04-26 | Nottoway | Virginia | 51135 | 4242 | 90 |
2442870 | 2442870 | 2022-04-25 | Bertie | North Carolina | 37015 | 4242 | 67 |
2439614 | 2439614 | 2022-04-24 | Bertie | North Carolina | 37015 | 4242 | 67 |
2436358 | 2436358 | 2022-04-23 | Bertie | North Carolina | 37015 | 4242 | 67 |
2433102 | 2433102 | 2022-04-22 | Bertie | North Carolina | 37015 | 4242 | 67 |
2429846 | 2429846 | 2022-04-21 | Bertie | North Carolina | 37015 | 4242 | 67 |
2426590 | 2426590 | 2022-04-20 | Bertie | North Carolina | 37015 | 4242 | 67 |
2391634 | 2391634 | 2022-04-09 | Lee | Texas | 48287 | 4242 | 60 |
2388378 | 2388378 | 2022-04-08 | Lee | Texas | 48287 | 4242 | 60 |
2385122 | 2385122 | 2022-04-07 | Lavaca | Texas | 48285 | 4242 | 119 |
2385123 | 2385123 | 2022-04-07 | Lee | Texas | 48287 | 4242 | 60 |
2381867 | 2381867 | 2022-04-06 | Lavaca | Texas | 48285 | 4242 | 119 |
2381868 | 2381868 | 2022-04-06 | Lee | Texas | 48287 | 4242 | 60 |
2378976 | 2378976 | 2022-04-05 | Morgan | West Virginia | 54065 | 4242 | 68 |
2375722 | 2375722 | 2022-04-04 | Morgan | West Virginia | 54065 | 4242 | 69 |
2352722 | 2352722 | 2022-03-28 | Unknown | Utah | 4242 | 94 | |
2345723 | 2345723 | 2022-03-26 | Yabucoa | Puerto Rico | 72151 | 4242 | |
2333840 | 2333840 | 2022-03-23 | Otero | Colorado | 8089 | 4242 | 126 |
2262894 | 2262894 | 2022-03-01 | Atchison | Kansas | 20005 | 4242 | 33 |
2259643 | 2259643 | 2022-02-28 | Atchison | Kansas | 20005 | 4242 | 33 |
2243737 | 2243737 | 2022-02-23 | Antrim | Michigan | 26009 | 4242 | 58 |
2217546 | 2217546 | 2022-02-15 | Lawrence | Kentucky | 21127 | 4242 | 56 |
2188645 | 2188645 | 2022-02-06 | Holmes | Mississippi | 28051 | 4242 | 98 |
2185392 | 2185392 | 2022-02-05 | Holmes | Mississippi | 28051 | 4242 | 98 |
2182140 | 2182140 | 2022-02-04 | Holmes | Mississippi | 28051 | 4242 | 98 |
2149424 | 2149424 | 2022-01-25 | Cheboygan | Michigan | 26031 | 4242 | 87 |
2146172 | 2146172 | 2022-01-24 | Cheboygan | Michigan | 26031 | 4242 | 87 |
2143157 | 2143157 | 2022-01-23 | Andrew | Missouri | 29003 | 4242 | 44 |
2063899 | 2063899 | 2021-12-30 | Morgan | Colorado | 8087 | 4242 | 125 |
2057754 | 2057754 | 2021-12-28 | Jersey | Illinois | 17083 | 4242 | 76 |
2055545 | 2055545 | 2021-12-27 | Cass | Nebraska | 31025 | 4242 | 23 |
2052295 | 2052295 | 2021-12-26 | Cass | Nebraska | 31025 | 4242 | 23 |
2049045 | 2049045 | 2021-12-25 | Cass | Nebraska | 31025 | 4242 | 23 |
2045795 | 2045795 | 2021-12-24 | Cass | Nebraska | 31025 | 4242 | 23 |
2042545 | 2042545 | 2021-12-23 | Cass | Nebraska | 31025 | 4242 | 23 |
2040738 | 2040738 | 2021-12-22 | Mason | West Virginia | 54053 | 4242 | 65 |
2012377 | 2012377 | 2021-12-14 | Posey | Indiana | 18129 | 4242 | 45 |
1914586 | 1914586 | 2021-11-14 | Monroe | Georgia | 13207 | 4242 | 149 |
1911336 | 1911336 | 2021-11-13 | Monroe | Georgia | 13207 | 4242 | 149 |
1908087 | 1908087 | 2021-11-12 | Monroe | Georgia | 13207 | 4242 | 149 |
1908807 | 1908807 | 2021-11-12 | Dorchester | Maryland | 24019 | 4242 | 84 |
1879809 | 1879809 | 2021-11-03 | Marion | Mississippi | 28091 | 4242 | 108 |
1853077 | 1853077 | 2021-10-26 | Decatur | Indiana | 18031 | 4242 | 110 |
1830404 | 1830404 | 2021-10-19 | Wells | Indiana | 18179 | 4242 | 90 |
1810235 | 1810235 | 2021-10-13 | Carroll | Arkansas | 5015 | 4242 | 73 |
1801531 | 1801531 | 2021-10-10 | Richland | Louisiana | 22083 | 4242 | 76 |
1798282 | 1798282 | 2021-10-09 | Richland | Louisiana | 22083 | 4242 | 76 |
1795033 | 1795033 | 2021-10-08 | Richland | Louisiana | 22083 | 4242 | 76 |
1791707 | 1791707 | 2021-10-07 | Mercer | Kentucky | 21167 | 4242 | 68 |
1784002 | 1784002 | 2021-10-04 | Mineral | West Virginia | 54057 | 4242 | 106 |
1719286 | 1719286 | 2021-09-15 | Johnson | Arkansas | 5071 | 4242 | 55 |
1714031 | 1714031 | 2021-09-13 | Polk | Minnesota | 27119 | 4242 | 75 |
1712546 | 1712546 | 2021-09-12 | Wayne | West Virginia | 54099 | 4242 | 49 |
1691056 | 1691056 | 2021-09-06 | Jefferson Davis | Louisiana | 22053 | 4242 | 110 |
1687806 | 1687806 | 2021-09-05 | Jefferson Davis | Louisiana | 22053 | 4242 | 110 |
1684556 | 1684556 | 2021-09-04 | Jefferson Davis | Louisiana | 22053 | 4242 | 110 |
1681305 | 1681305 | 2021-09-03 | Jefferson Davis | Louisiana | 22053 | 4242 | 110 |
1634383 | 1634383 | 2021-08-19 | Charlottesville city | Virginia | 51540 | 4242 | 58 |
1591535 | 1591535 | 2021-08-06 | Wayne | Pennsylvania | 42127 | 4242 | 84 |
1562358 | 1562358 | 2021-07-28 | Ponce | Puerto Rico | 72113 | 4242 | |
1542420 | 1542420 | 2021-07-22 | Davie | North Carolina | 37059 | 4242 | 42 |
1517355 | 1517355 | 2021-07-14 | Titus | Texas | 48449 | 4242 | 84 |
1496236 | 1496236 | 2021-07-08 | Calvert | Maryland | 24009 | 4242 | 86 |
1497889 | 1497889 | 2021-07-08 | Waller | Texas | 48473 | 4242 | 51 |
1492989 | 1492989 | 2021-07-07 | Calvert | Maryland | 24009 | 4242 | 86 |
1469299 | 1469299 | 2021-06-30 | Tuolumne | California | 6109 | 4242 | 71 |
1449202 | 1449202 | 2021-06-23 | Washington | Texas | 48477 | 4242 | 94 |
1339112 | 1339112 | 2021-05-20 | Ohio | West Virginia | 54069 | 4242 | 86 |
1325073 | 1325073 | 2021-05-16 | Defiance | Ohio | 39039 | 4242 | 97 |
1304272 | 1304272 | 2021-05-10 | Montgomery | Indiana | 18107 | 4242 | 90 |
1287132 | 1287132 | 2021-05-04 | Whitman | Washington | 53075 | 4242 | 48 |
1283886 | 1283886 | 2021-05-03 | Whitman | Washington | 53075 | 4242 | 48 |
1280768 | 1280768 | 2021-05-02 | Albany | Wyoming | 56001 | 4242 | 11 |
1277521 | 1277521 | 2021-05-01 | Albany | Wyoming | 56001 | 4242 | 11 |
1274274 | 1274274 | 2021-04-30 | Albany | Wyoming | 56001 | 4242 | 11 |
1256943 | 1256943 | 2021-04-25 | Putnam | Ohio | 39137 | 4242 | 99 |
1225299 | 1225299 | 2021-04-15 | Danville city | Virginia | 51590 | 4242 | 133 |
1218848 | 1218848 | 2021-04-13 | Manassas city | Virginia | 51683 | 4242 | 45 |
1215714 | 1215714 | 2021-04-12 | Jefferson | West Virginia | 54037 | 4242 | 48 |
1200339 | 1200339 | 2021-04-08 | Harrison | Indiana | 18061 | 4242 | 72 |
1194459 | 1194459 | 2021-04-06 | Goodhue | Minnesota | 27049 | 4242 | 70 |
1190913 | 1190913 | 2021-04-05 | Hopkins | Kentucky | 21107 | 4242 | 140 |
1179302 | 1179302 | 2021-04-01 | Dillon | South Carolina | 45033 | 4242 | 80 |
1165370 | 1165370 | 2021-03-28 | Warren | Mississippi | 28149 | 4242 | 117 |
1157093 | 1157093 | 2021-03-25 | Culpeper | Virginia | 51047 | 4242 | 56 |
1152071 | 1152071 | 2021-03-24 | Washington | Louisiana | 22117 | 4242 | 126 |
1132787 | 1132787 | 2021-03-18 | Mower | Minnesota | 27099 | 4242 | 31 |
1134280 | 1134280 | 2021-03-18 | Wilson | Texas | 48493 | 4242 | 64 |
1127712 | 1127712 | 2021-03-16 | Nacogdoches | Texas | 48347 | 4242 | 158 |
1086826 | 1086826 | 2021-03-04 | Muscatine | Iowa | 19139 | 4242 | 93 |
977654 | 977654 | 2021-01-29 | Stark | North Dakota | 38089 | 4242 | 48 |
969059 | 969059 | 2021-01-26 | Marinette | Wisconsin | 55075 | 4242 | 60 |
938776 | 938776 | 2021-01-17 | Mercer | Ohio | 39107 | 4242 | 87 |
916509 | 916509 | 2021-01-10 | Hawkins | Tennessee | 47073 | 4242 | 63 |
906505 | 906505 | 2021-01-07 | Indiana | Pennsylvania | 42063 | 4242 | 130 |
899808 | 899808 | 2021-01-05 | Geauga | Ohio | 39055 | 4242 | 53 |
804890 | 804890 | 2020-12-07 | Lenawee | Michigan | 26091 | 4242 | 40 |
795868 | 795868 | 2020-12-04 | Wilson | North Carolina | 37195 | 4242 | 82 |
776323 | 776323 | 2020-11-28 | Cleveland | North Carolina | 37045 | 4242 | 108 |
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);