ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
158 rows where cases = 3773 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 14
- Tennessee 13
- Texas 13
- Kentucky 10
- Iowa 9
- Illinois 8
- Kansas 8
- Minnesota 8
- North Carolina 7
- West Virginia 7
- Virginia 5
- Wisconsin 5
- Louisiana 4
- Nebraska 4
- New Hampshire 4
- New York 4
- Arkansas 3
- Missouri 3
- New Mexico 3
- Ohio 3
- Alabama 2
- Florida 2
- Mississippi 2
- Oregon 2
- Pennsylvania 2
- Wyoming 2
- Colorado 1
- Maine 1
- Maryland 1
- Michigan 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498066 | 2498066 | 2022-05-12 | Saline | Nebraska | 31151 | 3773 | 12 |
2494808 | 2494808 | 2022-05-11 | Saline | Nebraska | 31151 | 3773 | 12 |
2489328 | 2489328 | 2022-05-09 | Madison | Texas | 48313 | 3773 | 54 |
2472519 | 2472519 | 2022-05-04 | Tillamook | Oregon | 41057 | 3773 | 64 |
2467851 | 2467851 | 2022-05-03 | Kossuth | Iowa | 19109 | 3773 | 88 |
2464596 | 2464596 | 2022-05-02 | Kossuth | Iowa | 19109 | 3773 | 88 |
2461340 | 2461340 | 2022-05-01 | Kossuth | Iowa | 19109 | 3773 | 88 |
2458084 | 2458084 | 2022-04-30 | Kossuth | Iowa | 19109 | 3773 | 88 |
2454828 | 2454828 | 2022-04-29 | Kossuth | Iowa | 19109 | 3773 | 88 |
2451572 | 2451572 | 2022-04-28 | Kossuth | Iowa | 19109 | 3773 | 88 |
2448316 | 2448316 | 2022-04-27 | Kossuth | Iowa | 19109 | 3773 | 88 |
2424533 | 2424533 | 2022-04-19 | Grant | West Virginia | 54023 | 3773 | 56 |
2421277 | 2421277 | 2022-04-18 | Grant | West Virginia | 54023 | 3773 | 56 |
2415920 | 2415920 | 2022-04-17 | Breathitt | Kentucky | 21025 | 3773 | 54 |
2412664 | 2412664 | 2022-04-16 | Breathitt | Kentucky | 21025 | 3773 | 54 |
2409408 | 2409408 | 2022-04-15 | Breathitt | Kentucky | 21025 | 3773 | 54 |
2406152 | 2406152 | 2022-04-14 | Breathitt | Kentucky | 21025 | 3773 | 54 |
2402896 | 2402896 | 2022-04-13 | Breathitt | Kentucky | 21025 | 3773 | 54 |
2399642 | 2399642 | 2022-04-12 | Breathitt | Kentucky | 21025 | 3773 | 54 |
2396386 | 2396386 | 2022-04-11 | Breathitt | Kentucky | 21025 | 3773 | 54 |
2393466 | 2393466 | 2022-04-10 | Faribault | Minnesota | 27043 | 3773 | 50 |
2395055 | 2395055 | 2022-04-10 | Appomattox | Virginia | 51011 | 3773 | 52 |
2390210 | 2390210 | 2022-04-09 | Faribault | Minnesota | 27043 | 3773 | 50 |
2391799 | 2391799 | 2022-04-09 | Appomattox | Virginia | 51011 | 3773 | 52 |
2386954 | 2386954 | 2022-04-08 | Faribault | Minnesota | 27043 | 3773 | 50 |
2388543 | 2388543 | 2022-04-08 | Appomattox | Virginia | 51011 | 3773 | 52 |
2270342 | 2270342 | 2022-03-03 | Socorro | New Mexico | 35053 | 3773 | 85 |
2263070 | 2263070 | 2022-03-01 | Magoffin | Kentucky | 21153 | 3773 | 40 |
2264939 | 2264939 | 2022-03-01 | Buckingham | Virginia | 51029 | 3773 | 51 |
2265188 | 2265188 | 2022-03-01 | Marquette | Wisconsin | 55077 | 3773 | 55 |
2257473 | 2257473 | 2022-02-27 | Polk | North Carolina | 37149 | 3773 | 51 |
2254222 | 2254222 | 2022-02-26 | Polk | North Carolina | 37149 | 3773 | 51 |
2250971 | 2250971 | 2022-02-25 | Polk | North Carolina | 37149 | 3773 | 51 |
2235944 | 2235944 | 2022-02-20 | Richland | Wisconsin | 55103 | 3773 | 41 |
2232693 | 2232693 | 2022-02-19 | Richland | Wisconsin | 55103 | 3773 | 41 |
2229442 | 2229442 | 2022-02-18 | Richland | Wisconsin | 55103 | 3773 | 41 |
2218048 | 2218048 | 2022-02-15 | Moniteau | Missouri | 29135 | 3773 | 51 |
2216211 | 2216211 | 2022-02-14 | Grayson | Virginia | 51077 | 3773 | 74 |
2211369 | 2211369 | 2022-02-13 | Redwood | Minnesota | 27127 | 3773 | 52 |
2208116 | 2208116 | 2022-02-12 | Redwood | Minnesota | 27127 | 3773 | 52 |
2204863 | 2204863 | 2022-02-11 | Redwood | Minnesota | 27127 | 3773 | 52 |
2206101 | 2206101 | 2022-02-11 | Andrews | Texas | 48003 | 3773 | 70 |
2196319 | 2196319 | 2022-02-08 | Sequatchie | Tennessee | 47153 | 3773 | 62 |
2193065 | 2193065 | 2022-02-07 | Sequatchie | Tennessee | 47153 | 3773 | 62 |
2188143 | 2188143 | 2022-02-06 | Jackson | Kansas | 20085 | 3773 | 26 |
2189811 | 2189811 | 2022-02-06 | Sequatchie | Tennessee | 47153 | 3773 | 62 |
2184890 | 2184890 | 2022-02-05 | Jackson | Kansas | 20085 | 3773 | 26 |
2186558 | 2186558 | 2022-02-05 | Sequatchie | Tennessee | 47153 | 3773 | 62 |
2181638 | 2181638 | 2022-02-04 | Jackson | Kansas | 20085 | 3773 | 26 |
2183306 | 2183306 | 2022-02-04 | Sequatchie | Tennessee | 47153 | 3773 | 62 |
2180054 | 2180054 | 2022-02-03 | Sequatchie | Tennessee | 47153 | 3773 | 62 |
2180091 | 2180091 | 2022-02-03 | Bosque | Texas | 48035 | 3773 | 63 |
2176803 | 2176803 | 2022-02-02 | Sequatchie | Tennessee | 47153 | 3773 | 62 |
2177358 | 2177358 | 2022-02-02 | Burnett | Wisconsin | 55013 | 3773 | 38 |
2104464 | 2104464 | 2022-01-11 | Roosevelt | New Mexico | 35041 | 3773 | 83 |
2101017 | 2101017 | 2022-01-10 | Lincoln | Montana | 30053 | 3773 | 74 |
2083123 | 2083123 | 2022-01-05 | Butler | Alabama | 1013 | 3773 | 102 |
2082633 | 2082633 | 2022-01-04 | Lampasas | Texas | 48281 | 3773 | 71 |
2075155 | 2075155 | 2022-01-02 | Unknown | New Hampshire | 3773 | 22 | |
2071904 | 2071904 | 2022-01-01 | Unknown | New Hampshire | 3773 | 22 | |
2068653 | 2068653 | 2021-12-31 | Unknown | New Hampshire | 3773 | 22 | |
2063772 | 2063772 | 2021-12-30 | Ouachita | Arkansas | 5103 | 3773 | 90 |
2065402 | 2065402 | 2021-12-30 | Unknown | New Hampshire | 3773 | 22 | |
2039505 | 2039505 | 2021-12-22 | Seneca | New York | 36099 | 3773 | 75 |
1985465 | 1985465 | 2021-12-05 | Hampshire | West Virginia | 54027 | 3773 | 51 |
1974565 | 1974565 | 2021-12-02 | Martin | North Carolina | 37117 | 3773 | 75 |
1960815 | 1960815 | 2021-11-28 | Garrett | Maryland | 24023 | 3773 | 86 |
1943752 | 1943752 | 2021-11-23 | Burke | Georgia | 13033 | 3773 | 85 |
1935119 | 1935119 | 2021-11-20 | Crawford | Missouri | 29055 | 3773 | 73 |
1869046 | 1869046 | 2021-10-31 | Fannin | Georgia | 13111 | 3773 | 106 |
1865797 | 1865797 | 2021-10-30 | Fannin | Georgia | 13111 | 3773 | 106 |
1862548 | 1862548 | 2021-10-29 | Fannin | Georgia | 13111 | 3773 | 106 |
1859780 | 1859780 | 2021-10-28 | Franklin | Kansas | 20059 | 3773 | 58 |
1856531 | 1856531 | 2021-10-27 | Franklin | Kansas | 20059 | 3773 | 58 |
1810621 | 1810621 | 2021-10-13 | Pike | Georgia | 13231 | 3773 | 65 |
1807390 | 1807390 | 2021-10-12 | Tattnall | Georgia | 13267 | 3773 | 104 |
1806184 | 1806184 | 2021-10-11 | Haywood | Tennessee | 47075 | 3773 | 71 |
1789043 | 1789043 | 2021-10-06 | Adams | Nebraska | 31001 | 3773 | 54 |
1774239 | 1774239 | 2021-10-01 | Hancock | West Virginia | 54029 | 3773 | 99 |
1766458 | 1766458 | 2021-09-29 | Luna | New Mexico | 35029 | 3773 | 93 |
1761900 | 1761900 | 2021-09-28 | Tattnall | Georgia | 13267 | 3773 | 97 |
1758579 | 1758579 | 2021-09-27 | Franklin | Georgia | 13119 | 3773 | 70 |
1740241 | 1740241 | 2021-09-21 | Stone | Missouri | 29209 | 3773 | 78 |
1734758 | 1734758 | 2021-09-19 | Wayne | Tennessee | 47181 | 3773 | 38 |
1731508 | 1731508 | 2021-09-18 | Wayne | Tennessee | 47181 | 3773 | 38 |
1728258 | 1728258 | 2021-09-17 | Wayne | Tennessee | 47181 | 3773 | 38 |
1710082 | 1710082 | 2021-09-12 | Saline | Illinois | 17165 | 3773 | 78 |
1706835 | 1706835 | 2021-09-11 | Saline | Illinois | 17165 | 3773 | 78 |
1703587 | 1703587 | 2021-09-10 | Saline | Illinois | 17165 | 3773 | 78 |
1677412 | 1677412 | 2021-09-02 | Pierce | Georgia | 13229 | 3773 | 72 |
1652000 | 1652000 | 2021-08-25 | Logan | Kentucky | 21141 | 3773 | 76 |
1652357 | 1652357 | 2021-08-25 | Copiah | Mississippi | 28029 | 3773 | 75 |
1634009 | 1634009 | 2021-08-19 | Lauderdale | Tennessee | 47097 | 3773 | 50 |
1621567 | 1621567 | 2021-08-15 | Marshall | West Virginia | 54051 | 3773 | 80 |
1618319 | 1618319 | 2021-08-14 | Marshall | West Virginia | 54051 | 3773 | 80 |
1615071 | 1615071 | 2021-08-13 | Marshall | West Virginia | 54051 | 3773 | 80 |
1514516 | 1514516 | 2021-07-14 | Chambers | Alabama | 1017 | 3773 | 124 |
1505689 | 1505689 | 2021-07-11 | Ellis | Kansas | 20051 | 3773 | 73 |
1502443 | 1502443 | 2021-07-10 | Ellis | Kansas | 20051 | 3773 | 73 |
1499197 | 1499197 | 2021-07-09 | Ellis | Kansas | 20051 | 3773 | 73 |
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);