ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
181 rows where cases = 3324 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 16
- Iowa 15
- Georgia 14
- Illinois 12
- Texas 12
- Virginia 11
- Ohio 8
- Indiana 7
- Oregon 7
- Tennessee 7
- Wisconsin 7
- Florida 6
- Minnesota 6
- Idaho 5
- Kentucky 5
- Arkansas 4
- Louisiana 4
- New Jersey 4
- West Virginia 4
- Mississippi 3
- New Mexico 3
- Pennsylvania 3
- South Carolina 3
- Alabama 2
- Nebraska 2
- Puerto Rico 2
- Alaska 1
- Arizona 1
- Colorado 1
- Missouri 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501328 | 2501328 | 2022-05-13 | Seward | Nebraska | 31159 | 3324 | 42 |
2429745 | 2429745 | 2022-04-21 | Unknown | New Jersey | 3324 | 0 | |
2426489 | 2426489 | 2022-04-20 | Unknown | New Jersey | 3324 | 0 | |
2427659 | 2427659 | 2022-04-20 | Greensville | Virginia | 51081 | 3324 | 39 |
2421147 | 2421147 | 2022-04-18 | Greensville | Virginia | 51081 | 3324 | 39 |
2401612 | 2401612 | 2022-04-12 | Greensville | Virginia | 51081 | 3324 | 39 |
2383303 | 2383303 | 2022-04-07 | Marion | Kansas | 20115 | 3324 | 43 |
2380048 | 2380048 | 2022-04-06 | Marion | Kansas | 20115 | 3324 | 43 |
2376793 | 2376793 | 2022-04-05 | Marion | Kansas | 20115 | 3324 | 43 |
2373541 | 2373541 | 2022-04-04 | Marion | Kansas | 20115 | 3324 | 43 |
2370288 | 2370288 | 2022-04-03 | Marion | Kansas | 20115 | 3324 | 43 |
2371150 | 2371150 | 2022-04-03 | Unknown | New Jersey | 3324 | 0 | |
2367035 | 2367035 | 2022-04-02 | Marion | Kansas | 20115 | 3324 | 43 |
2367897 | 2367897 | 2022-04-02 | Unknown | New Jersey | 3324 | 0 | |
2363782 | 2363782 | 2022-04-01 | Marion | Kansas | 20115 | 3324 | 43 |
2354021 | 2354021 | 2022-03-29 | Marion | Kansas | 20115 | 3324 | 40 |
2350769 | 2350769 | 2022-03-28 | Marion | Kansas | 20115 | 3324 | 40 |
2347516 | 2347516 | 2022-03-27 | Marion | Kansas | 20115 | 3324 | 40 |
2348803 | 2348803 | 2022-03-27 | Curry | Oregon | 41015 | 3324 | 50 |
2349609 | 2349609 | 2022-03-27 | Southampton | Virginia | 51175 | 3324 | 89 |
2344263 | 2344263 | 2022-03-26 | Marion | Kansas | 20115 | 3324 | 40 |
2345550 | 2345550 | 2022-03-26 | Curry | Oregon | 41015 | 3324 | 50 |
2346356 | 2346356 | 2022-03-26 | Southampton | Virginia | 51175 | 3324 | 89 |
2341010 | 2341010 | 2022-03-25 | Marion | Kansas | 20115 | 3324 | 40 |
2342297 | 2342297 | 2022-03-25 | Curry | Oregon | 41015 | 3324 | 50 |
2343103 | 2343103 | 2022-03-25 | Southampton | Virginia | 51175 | 3324 | 89 |
2339850 | 2339850 | 2022-03-24 | Southampton | Virginia | 51175 | 3324 | 89 |
2335790 | 2335790 | 2022-03-23 | Curry | Oregon | 41015 | 3324 | 49 |
2329283 | 2329283 | 2022-03-21 | Curry | Oregon | 41015 | 3324 | 47 |
2316724 | 2316724 | 2022-03-17 | Duval | Texas | 48131 | 3324 | 68 |
2313471 | 2313471 | 2022-03-16 | Duval | Texas | 48131 | 3324 | 68 |
2289580 | 2289580 | 2022-03-09 | Mississippi | Missouri | 29133 | 3324 | 56 |
2270235 | 2270235 | 2022-03-03 | Otoe | Nebraska | 31131 | 3324 | 17 |
2220134 | 2220134 | 2022-02-16 | Bleckley | Georgia | 13023 | 3324 | 87 |
2195956 | 2195956 | 2022-02-08 | Hood River | Oregon | 41027 | 3324 | 41 |
2179844 | 2179844 | 2022-02-03 | San German | Puerto Rico | 72125 | 3324 | |
2165100 | 2165100 | 2022-01-30 | Menard | Illinois | 17129 | 3324 | 22 |
2161845 | 2161845 | 2022-01-29 | Menard | Illinois | 17129 | 3324 | 22 |
2158590 | 2158590 | 2022-01-28 | Menard | Illinois | 17129 | 3324 | 22 |
2149189 | 2149189 | 2022-01-25 | Casey | Kentucky | 21045 | 3324 | 65 |
2128164 | 2128164 | 2022-01-18 | Llano | Texas | 48299 | 3324 | 87 |
2122279 | 2122279 | 2022-01-17 | Izard | Arkansas | 5065 | 3324 | 60 |
2108647 | 2108647 | 2022-01-12 | Lee | Texas | 48287 | 3324 | 54 |
2075478 | 2075478 | 2022-01-02 | Meigs | Ohio | 39105 | 3324 | 67 |
2057016 | 2057016 | 2021-12-27 | Adams | Wisconsin | 55001 | 3324 | 39 |
2053767 | 2053767 | 2021-12-26 | Adams | Wisconsin | 55001 | 3324 | 39 |
2050517 | 2050517 | 2021-12-25 | Adams | Wisconsin | 55001 | 3324 | 39 |
2047267 | 2047267 | 2021-12-24 | Adams | Wisconsin | 55001 | 3324 | 39 |
2032463 | 2032463 | 2021-12-20 | Fillmore | Minnesota | 27045 | 3324 | 15 |
2013003 | 2013003 | 2021-12-14 | Roseau | Minnesota | 27135 | 3324 | 33 |
2008864 | 2008864 | 2021-12-13 | Putnam | Georgia | 13237 | 3324 | 88 |
1994755 | 1994755 | 2021-12-08 | Burleson | Texas | 48051 | 3324 | 60 |
1991504 | 1991504 | 2021-12-07 | Burleson | Texas | 48051 | 3324 | 60 |
1983094 | 1983094 | 2021-12-05 | Jay | Indiana | 18075 | 3324 | 55 |
1979844 | 1979844 | 2021-12-04 | Jay | Indiana | 18075 | 3324 | 55 |
1976594 | 1976594 | 2021-12-03 | Jay | Indiana | 18075 | 3324 | 55 |
1898575 | 1898575 | 2021-11-09 | Fulton | Indiana | 18049 | 3324 | 69 |
1872472 | 1872472 | 2021-11-01 | Douglas | Illinois | 17041 | 3324 | 44 |
1833477 | 1833477 | 2021-10-20 | Crawford | Illinois | 17033 | 3324 | 46 |
1804108 | 1804108 | 2021-10-11 | Mitchell | Georgia | 13205 | 3324 | 97 |
1800859 | 1800859 | 2021-10-10 | Mitchell | Georgia | 13205 | 3324 | 97 |
1803469 | 1803469 | 2021-10-10 | Boone | West Virginia | 54005 | 3324 | 44 |
1797610 | 1797610 | 2021-10-09 | Mitchell | Georgia | 13205 | 3324 | 97 |
1794361 | 1794361 | 2021-10-08 | Mitchell | Georgia | 13205 | 3324 | 97 |
1784934 | 1784934 | 2021-10-05 | Carroll | Iowa | 19027 | 3324 | 53 |
1781685 | 1781685 | 2021-10-04 | Carroll | Iowa | 19027 | 3324 | 53 |
1778435 | 1778435 | 2021-10-03 | Carroll | Iowa | 19027 | 3324 | 53 |
1775185 | 1775185 | 2021-10-02 | Carroll | Iowa | 19027 | 3324 | 53 |
1771935 | 1771935 | 2021-10-01 | Carroll | Iowa | 19027 | 3324 | 53 |
1768686 | 1768686 | 2021-09-30 | Carroll | Iowa | 19027 | 3324 | 53 |
1768927 | 1768927 | 2021-09-30 | Hart | Kentucky | 21099 | 3324 | 60 |
1770893 | 1770893 | 2021-09-30 | Orange | Virginia | 51137 | 3324 | 49 |
1765437 | 1765437 | 2021-09-29 | Carroll | Iowa | 19027 | 3324 | 53 |
1747689 | 1747689 | 2021-09-23 | Fentress | Tennessee | 47049 | 3324 | 58 |
1716732 | 1716732 | 2021-09-14 | Henry | Iowa | 19087 | 3324 | 40 |
1713486 | 1713486 | 2021-09-13 | Henry | Iowa | 19087 | 3324 | 40 |
1710239 | 1710239 | 2021-09-12 | Henry | Iowa | 19087 | 3324 | 40 |
1710325 | 1710325 | 2021-09-12 | Franklin | Kansas | 20059 | 3324 | 52 |
1706992 | 1706992 | 2021-09-11 | Henry | Iowa | 19087 | 3324 | 40 |
1707078 | 1707078 | 2021-09-11 | Franklin | Kansas | 20059 | 3324 | 52 |
1703744 | 1703744 | 2021-09-10 | Henry | Iowa | 19087 | 3324 | 40 |
1703830 | 1703830 | 2021-09-10 | Franklin | Kansas | 20059 | 3324 | 52 |
1700494 | 1700494 | 2021-09-09 | Henry | Iowa | 19087 | 3324 | 40 |
1697245 | 1697245 | 2021-09-08 | Henry | Iowa | 19087 | 3324 | 40 |
1689359 | 1689359 | 2021-09-05 | Fayette | Texas | 48149 | 3324 | 79 |
1685530 | 1685530 | 2021-09-04 | Morrow | Ohio | 39117 | 3324 | 47 |
1686109 | 1686109 | 2021-09-04 | Fayette | Texas | 48149 | 3324 | 79 |
1630773 | 1630773 | 2021-08-18 | McNairy | Tennessee | 47109 | 3324 | 57 |
1618896 | 1618896 | 2021-08-15 | Gilmer | Georgia | 13123 | 3324 | 93 |
1615648 | 1615648 | 2021-08-14 | Gilmer | Georgia | 13123 | 3324 | 93 |
1612399 | 1612399 | 2021-08-13 | Gilmer | Georgia | 13123 | 3324 | 93 |
1605968 | 1605968 | 2021-08-11 | Stephens | Georgia | 13257 | 3324 | 81 |
1588947 | 1588947 | 2021-08-05 | Isle of Wight | Virginia | 51093 | 3324 | 70 |
1568556 | 1568556 | 2021-07-30 | Guernsey | Ohio | 39059 | 3324 | 54 |
1563398 | 1563398 | 2021-07-29 | Unknown | Arkansas | 3324 | 0 | |
1565308 | 1565308 | 2021-07-29 | Guernsey | Ohio | 39059 | 3324 | 54 |
1556595 | 1556595 | 2021-07-26 | Logan | West Virginia | 54045 | 3324 | 96 |
1537724 | 1537724 | 2021-07-21 | Madison | Georgia | 13195 | 3324 | 56 |
1521049 | 1521049 | 2021-07-16 | Marion | Alabama | 1093 | 3324 | 106 |
1515884 | 1515884 | 2021-07-14 | Nicollet | Minnesota | 27103 | 3324 | 45 |
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);