ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
266 rows where cases = 2179 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 25
- Virginia 24
- Iowa 19
- Georgia 17
- Missouri 16
- North Carolina 16
- Arkansas 11
- Illinois 11
- Kentucky 10
- Minnesota 10
- Mississippi 10
- West Virginia 10
- Idaho 9
- Colorado 8
- Wisconsin 8
- Indiana 6
- Michigan 6
- Washington 6
- Nebraska 5
- North Dakota 5
- Puerto Rico 5
- Tennessee 5
- South Carolina 4
- Utah 3
- Florida 2
- Kansas 2
- Pennsylvania 2
- Arizona 1
- California 1
- Hawaii 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501293 | 2501293 | 2022-05-13 | Holt | Nebraska | 31089 | 2179 | 20 |
2497888 | 2497888 | 2022-05-12 | Monroe | Missouri | 29137 | 2179 | 43 |
2494630 | 2494630 | 2022-05-11 | Monroe | Missouri | 29137 | 2179 | 43 |
2490307 | 2490307 | 2022-05-10 | Pulaski | Georgia | 13235 | 2179 | 78 |
2491372 | 2491372 | 2022-05-10 | Monroe | Missouri | 29137 | 2179 | 43 |
2487050 | 2487050 | 2022-05-09 | Pulaski | Georgia | 13235 | 2179 | 78 |
2488114 | 2488114 | 2022-05-09 | Monroe | Missouri | 29137 | 2179 | 43 |
2483792 | 2483792 | 2022-05-08 | Pulaski | Georgia | 13235 | 2179 | 78 |
2484857 | 2484857 | 2022-05-08 | Monroe | Missouri | 29137 | 2179 | 43 |
2480534 | 2480534 | 2022-05-07 | Pulaski | Georgia | 13235 | 2179 | 78 |
2481599 | 2481599 | 2022-05-07 | Monroe | Missouri | 29137 | 2179 | 43 |
2477276 | 2477276 | 2022-05-06 | Pulaski | Georgia | 13235 | 2179 | 78 |
2478341 | 2478341 | 2022-05-06 | Monroe | Missouri | 29137 | 2179 | 43 |
2474018 | 2474018 | 2022-05-05 | Pulaski | Georgia | 13235 | 2179 | 78 |
2470761 | 2470761 | 2022-05-04 | Pulaski | Georgia | 13235 | 2179 | 78 |
2470889 | 2470889 | 2022-05-04 | Hamilton | Illinois | 17065 | 2179 | 34 |
2467633 | 2467633 | 2022-05-03 | Hamilton | Illinois | 17065 | 2179 | 34 |
2464378 | 2464378 | 2022-05-02 | Hamilton | Illinois | 17065 | 2179 | 34 |
2461122 | 2461122 | 2022-05-01 | Hamilton | Illinois | 17065 | 2179 | 34 |
2463509 | 2463509 | 2022-05-01 | Northumberland | Virginia | 51133 | 2179 | 46 |
2457866 | 2457866 | 2022-04-30 | Hamilton | Illinois | 17065 | 2179 | 34 |
2460253 | 2460253 | 2022-04-30 | Northumberland | Virginia | 51133 | 2179 | 46 |
2454610 | 2454610 | 2022-04-29 | Hamilton | Illinois | 17065 | 2179 | 34 |
2456612 | 2456612 | 2022-04-29 | Archer | Texas | 48009 | 2179 | 28 |
2456997 | 2456997 | 2022-04-29 | Northumberland | Virginia | 51133 | 2179 | 46 |
2453356 | 2453356 | 2022-04-28 | Archer | Texas | 48009 | 2179 | 28 |
2444842 | 2444842 | 2022-04-26 | Hamilton | Illinois | 17065 | 2179 | 34 |
2441586 | 2441586 | 2022-04-25 | Hamilton | Illinois | 17065 | 2179 | 34 |
2416356 | 2416356 | 2022-04-17 | Kemper | Mississippi | 28069 | 2179 | 48 |
2413100 | 2413100 | 2022-04-16 | Kemper | Mississippi | 28069 | 2179 | 48 |
2409844 | 2409844 | 2022-04-15 | Kemper | Mississippi | 28069 | 2179 | 48 |
2406588 | 2406588 | 2022-04-14 | Kemper | Mississippi | 28069 | 2179 | 48 |
2403332 | 2403332 | 2022-04-13 | Kemper | Mississippi | 28069 | 2179 | 48 |
2400078 | 2400078 | 2022-04-12 | Kemper | Mississippi | 28069 | 2179 | 48 |
2388317 | 2388317 | 2022-04-08 | Gaines | Texas | 48165 | 2179 | 83 |
2324353 | 2324353 | 2022-03-20 | Benewah | Idaho | 16009 | 2179 | 40 |
2321099 | 2321099 | 2022-03-19 | Benewah | Idaho | 16009 | 2179 | 40 |
2317845 | 2317845 | 2022-03-18 | Benewah | Idaho | 16009 | 2179 | 40 |
2309069 | 2309069 | 2022-03-15 | Iron | Missouri | 29093 | 2179 | 42 |
2270553 | 2270553 | 2022-03-03 | Traill | North Dakota | 38097 | 2179 | 25 |
2246773 | 2246773 | 2022-02-24 | Elliott | Kentucky | 21063 | 2179 | 16 |
2243522 | 2243522 | 2022-02-23 | Elliott | Kentucky | 21063 | 2179 | 16 |
2236562 | 2236562 | 2022-02-21 | Clearwater | Idaho | 16035 | 2179 | 31 |
2233311 | 2233311 | 2022-02-20 | Clearwater | Idaho | 16035 | 2179 | 31 |
2230060 | 2230060 | 2022-02-19 | Clearwater | Idaho | 16035 | 2179 | 31 |
2226335 | 2226335 | 2022-02-18 | Greenlee | Arizona | 4011 | 2179 | 31 |
2226809 | 2226809 | 2022-02-18 | Clearwater | Idaho | 16035 | 2179 | 31 |
2222185 | 2222185 | 2022-02-16 | McCormick | South Carolina | 45065 | 2179 | 36 |
2215995 | 2215995 | 2022-02-14 | La Salle | Texas | 48283 | 2179 | 42 |
2212744 | 2212744 | 2022-02-13 | La Salle | Texas | 48283 | 2179 | 42 |
2197566 | 2197566 | 2022-02-09 | Washington | Idaho | 16087 | 2179 | 53 |
2174318 | 2174318 | 2022-02-02 | Cleveland | Arkansas | 5025 | 2179 | 33 |
2171386 | 2171386 | 2022-02-01 | Evans | Georgia | 13109 | 2179 | 61 |
2170940 | 2170940 | 2022-01-31 | Washakie | Wyoming | 56043 | 2179 | 41 |
2164963 | 2164963 | 2022-01-30 | Towns | Georgia | 13281 | 2179 | 93 |
2165725 | 2165725 | 2022-01-30 | Luce | Michigan | 26095 | 2179 | 8 |
2161708 | 2161708 | 2022-01-29 | Towns | Georgia | 13281 | 2179 | 93 |
2162470 | 2162470 | 2022-01-29 | Luce | Michigan | 26095 | 2179 | 8 |
2158452 | 2158452 | 2022-01-28 | Towns | Georgia | 13281 | 2179 | 93 |
2159215 | 2159215 | 2022-01-28 | Luce | Michigan | 26095 | 2179 | 8 |
2155588 | 2155588 | 2022-01-27 | Doniphan | Kansas | 20043 | 2179 | 32 |
2152335 | 2152335 | 2022-01-26 | Doniphan | Kansas | 20043 | 2179 | 32 |
2106013 | 2106013 | 2022-01-12 | Fulton | Arkansas | 5049 | 2179 | 79 |
2106476 | 2106476 | 2022-01-12 | Teton | Idaho | 16081 | 2179 | 8 |
2072523 | 2072523 | 2022-01-01 | Yauco | Puerto Rico | 72153 | 2179 | |
2069272 | 2069272 | 2021-12-31 | Yauco | Puerto Rico | 72153 | 2179 | |
2058688 | 2058688 | 2021-12-28 | Pemiscot | Missouri | 29155 | 2179 | 59 |
2046145 | 2046145 | 2021-12-24 | McLean | North Dakota | 38055 | 2179 | 47 |
2007099 | 2007099 | 2021-12-12 | Swain | North Carolina | 37173 | 2179 | 28 |
2003848 | 2003848 | 2021-12-11 | Swain | North Carolina | 37173 | 2179 | 28 |
2003892 | 2003892 | 2021-12-11 | Mountrail | North Dakota | 38061 | 2179 | 31 |
2000597 | 2000597 | 2021-12-10 | Swain | North Carolina | 37173 | 2179 | 28 |
1982638 | 1982638 | 2021-12-05 | Moffat | Colorado | 8081 | 2179 | 47 |
1979388 | 1979388 | 2021-12-04 | Moffat | Colorado | 8081 | 2179 | 47 |
1976138 | 1976138 | 2021-12-03 | Moffat | Colorado | 8081 | 2179 | 47 |
1964179 | 1964179 | 2021-11-29 | Aitkin | Minnesota | 27001 | 2179 | 50 |
1890455 | 1890455 | 2021-11-06 | Fajardo | Puerto Rico | 72053 | 2179 | |
1878618 | 1878618 | 2021-11-03 | Grand | Colorado | 8049 | 2179 | 16 |
1859036 | 1859036 | 2021-10-28 | Van Buren | Arkansas | 5141 | 2179 | 42 |
1861443 | 1861443 | 2021-10-28 | Meigs | Tennessee | 47121 | 2179 | 28 |
1855787 | 1855787 | 2021-10-27 | Van Buren | Arkansas | 5141 | 2179 | 42 |
1852538 | 1852538 | 2021-10-26 | Van Buren | Arkansas | 5141 | 2179 | 42 |
1853051 | 1853051 | 2021-10-26 | Wabash | Illinois | 17185 | 2179 | 22 |
1853195 | 1853195 | 2021-10-26 | Harrison | Iowa | 19085 | 2179 | 77 |
1849946 | 1849946 | 2021-10-25 | Harrison | Iowa | 19085 | 2179 | 77 |
1850641 | 1850641 | 2021-10-25 | Gasconade | Missouri | 29073 | 2179 | 50 |
1846696 | 1846696 | 2021-10-24 | Harrison | Iowa | 19085 | 2179 | 77 |
1843446 | 1843446 | 2021-10-23 | Harrison | Iowa | 19085 | 2179 | 77 |
1840196 | 1840196 | 2021-10-22 | Harrison | Iowa | 19085 | 2179 | 77 |
1836947 | 1836947 | 2021-10-21 | Harrison | Iowa | 19085 | 2179 | 77 |
1837674 | 1837674 | 2021-10-21 | Mississippi | Missouri | 29133 | 2179 | 39 |
1838401 | 1838401 | 2021-10-21 | Fulton | Pennsylvania | 42057 | 2179 | 28 |
1839327 | 1839327 | 2021-10-21 | Washburn | Wisconsin | 55129 | 2179 | 27 |
1833698 | 1833698 | 2021-10-20 | Harrison | Iowa | 19085 | 2179 | 77 |
1801776 | 1801776 | 2021-10-10 | Wadena | Minnesota | 27159 | 2179 | 28 |
1798527 | 1798527 | 2021-10-09 | Wadena | Minnesota | 27159 | 2179 | 28 |
1795278 | 1795278 | 2021-10-08 | Wadena | Minnesota | 27159 | 2179 | 28 |
1782230 | 1782230 | 2021-10-04 | Houston | Minnesota | 27055 | 2179 | 17 |
1743413 | 1743413 | 2021-09-22 | Dallas | Missouri | 29059 | 2179 | 40 |
1741534 | 1741534 | 2021-09-21 | San Juan | Utah | 49037 | 2179 | 39 |
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);