ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
228 rows where cases = 2719 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 31
- Virginia 22
- Georgia 16
- Ohio 13
- Texas 13
- Kentucky 10
- North Dakota 10
- Illinois 9
- Alabama 8
- Michigan 8
- Tennessee 8
- Indiana 7
- Missouri 7
- Nevada 6
- Pennsylvania 6
- Arkansas 5
- Wisconsin 5
- Louisiana 4
- South Dakota 4
- Colorado 3
- Nebraska 3
- New York 3
- Oregon 3
- Florida 2
- Kansas 2
- Massachusetts 2
- North Carolina 2
- Puerto Rico 2
- South Carolina 2
- Arizona 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2416373 | 2416373 | 2022-04-17 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2413117 | 2413117 | 2022-04-16 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2409861 | 2409861 | 2022-04-15 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2406605 | 2406605 | 2022-04-14 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2403349 | 2403349 | 2022-04-13 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2400095 | 2400095 | 2022-04-12 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2396839 | 2396839 | 2022-04-11 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2393584 | 2393584 | 2022-04-10 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2390328 | 2390328 | 2022-04-09 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2387072 | 2387072 | 2022-04-08 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2383817 | 2383817 | 2022-04-07 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2380562 | 2380562 | 2022-04-06 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2377307 | 2377307 | 2022-04-05 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2374055 | 2374055 | 2022-04-04 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2370802 | 2370802 | 2022-04-03 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2367549 | 2367549 | 2022-04-02 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2364296 | 2364296 | 2022-04-01 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2361042 | 2361042 | 2022-03-31 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2357788 | 2357788 | 2022-03-30 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2354535 | 2354535 | 2022-03-29 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2351283 | 2351283 | 2022-03-28 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2348030 | 2348030 | 2022-03-27 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2344777 | 2344777 | 2022-03-26 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2341524 | 2341524 | 2022-03-25 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2338271 | 2338271 | 2022-03-24 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2338839 | 2338839 | 2022-03-24 | McLean | North Dakota | 38055 | 2719 | 49 |
2335017 | 2335017 | 2022-03-23 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2335585 | 2335585 | 2022-03-23 | McLean | North Dakota | 38055 | 2719 | 49 |
2331763 | 2331763 | 2022-03-22 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2332331 | 2332331 | 2022-03-22 | McLean | North Dakota | 38055 | 2719 | 49 |
2328511 | 2328511 | 2022-03-21 | Noxubee | Mississippi | 28103 | 2719 | 48 |
2329078 | 2329078 | 2022-03-21 | McLean | North Dakota | 38055 | 2719 | 49 |
2329857 | 2329857 | 2022-03-21 | Pecos | Texas | 48371 | 2719 | 71 |
2325826 | 2325826 | 2022-03-20 | McLean | North Dakota | 38055 | 2719 | 49 |
2326605 | 2326605 | 2022-03-20 | Pecos | Texas | 48371 | 2719 | 71 |
2322573 | 2322573 | 2022-03-19 | McLean | North Dakota | 38055 | 2719 | 49 |
2319319 | 2319319 | 2022-03-18 | McLean | North Dakota | 38055 | 2719 | 49 |
2312467 | 2312467 | 2022-03-16 | Colfax | Nebraska | 31037 | 2719 | 26 |
2305962 | 2305962 | 2022-03-14 | Colfax | Nebraska | 31037 | 2719 | 26 |
2264028 | 2264028 | 2022-03-01 | McLean | North Dakota | 38055 | 2719 | 49 |
2260777 | 2260777 | 2022-02-28 | McLean | North Dakota | 38055 | 2719 | 49 |
2256153 | 2256153 | 2022-02-27 | Marshall | Illinois | 17123 | 2719 | 32 |
2257526 | 2257526 | 2022-02-27 | McLean | North Dakota | 38055 | 2719 | 49 |
2252902 | 2252902 | 2022-02-26 | Marshall | Illinois | 17123 | 2719 | 32 |
2249651 | 2249651 | 2022-02-25 | Marshall | Illinois | 17123 | 2719 | 32 |
2225410 | 2225410 | 2022-02-17 | Calhoun | South Carolina | 45017 | 2719 | 57 |
2220213 | 2220213 | 2022-02-16 | Long | Georgia | 13183 | 2719 | 31 |
2216600 | 2216600 | 2022-02-15 | Chicot | Arkansas | 5017 | 2719 | 53 |
2206166 | 2206166 | 2022-02-11 | Eastland | Texas | 48133 | 2719 | 100 |
2128900 | 2128900 | 2022-01-19 | Crowley | Colorado | 8025 | 2719 | 27 |
2126641 | 2126641 | 2022-01-18 | Benzie | Michigan | 26019 | 2719 | 57 |
2123389 | 2123389 | 2022-01-17 | Benzie | Michigan | 26019 | 2719 | 57 |
2120137 | 2120137 | 2022-01-16 | Benzie | Michigan | 26019 | 2719 | 57 |
2116885 | 2116885 | 2022-01-15 | Benzie | Michigan | 26019 | 2719 | 57 |
2113634 | 2113634 | 2022-01-14 | Benzie | Michigan | 26019 | 2719 | 57 |
2087415 | 2087415 | 2022-01-06 | Green | Kentucky | 21087 | 2719 | 40 |
2089223 | 2089223 | 2022-01-06 | Tyler | Texas | 48457 | 2719 | 73 |
2084677 | 2084677 | 2022-01-05 | Macon | Missouri | 29121 | 2719 | 37 |
2073504 | 2073504 | 2022-01-02 | Howard | Arkansas | 5061 | 2719 | 39 |
2070253 | 2070253 | 2022-01-01 | Howard | Arkansas | 5061 | 2719 | 39 |
2034130 | 2034130 | 2021-12-20 | Nottoway | Virginia | 51135 | 2719 | 70 |
2021121 | 2021121 | 2021-12-16 | New Kent | Virginia | 51127 | 2719 | 27 |
1943816 | 1943816 | 2021-11-23 | Jefferson | Georgia | 13163 | 2719 | 87 |
1924896 | 1924896 | 2021-11-17 | Henry | Kentucky | 21103 | 2719 | 32 |
1902354 | 1902354 | 2021-11-10 | Charlevoix | Michigan | 26029 | 2719 | 38 |
1870373 | 1870373 | 2021-10-31 | Humboldt | Nevada | 32013 | 2719 | 33 |
1867124 | 1867124 | 2021-10-30 | Humboldt | Nevada | 32013 | 2719 | 33 |
1863875 | 1863875 | 2021-10-29 | Humboldt | Nevada | 32013 | 2719 | 33 |
1860626 | 1860626 | 2021-10-28 | Humboldt | Nevada | 32013 | 2719 | 33 |
1849241 | 1849241 | 2021-10-25 | Franklin | Arkansas | 5047 | 2719 | 52 |
1845991 | 1845991 | 2021-10-24 | Franklin | Arkansas | 5047 | 2719 | 52 |
1839262 | 1839262 | 2021-10-21 | Adams | Wisconsin | 55001 | 2719 | 33 |
1828253 | 1828253 | 2021-10-18 | Seneca | New York | 36099 | 2719 | 63 |
1823747 | 1823747 | 2021-10-17 | Hancock | Illinois | 17067 | 2719 | 45 |
1820498 | 1820498 | 2021-10-16 | Hancock | Illinois | 17067 | 2719 | 45 |
1817249 | 1817249 | 2021-10-15 | Hancock | Illinois | 17067 | 2719 | 45 |
1813762 | 1813762 | 2021-10-14 | Banks | Georgia | 13011 | 2719 | 59 |
1802629 | 1802629 | 2021-10-10 | Wasco | Oregon | 41065 | 2719 | 39 |
1799380 | 1799380 | 2021-10-09 | Wasco | Oregon | 41065 | 2719 | 39 |
1799417 | 1799417 | 2021-10-09 | Juniata | Pennsylvania | 42067 | 2719 | 111 |
1799745 | 1799745 | 2021-10-09 | Andrews | Texas | 48003 | 2719 | 52 |
1796131 | 1796131 | 2021-10-08 | Wasco | Oregon | 41065 | 2719 | 39 |
1796496 | 1796496 | 2021-10-08 | Andrews | Texas | 48003 | 2719 | 52 |
1793247 | 1793247 | 2021-10-07 | Andrews | Texas | 48003 | 2719 | 52 |
1789998 | 1789998 | 2021-10-06 | Andrews | Texas | 48003 | 2719 | 52 |
1784866 | 1784866 | 2021-10-05 | Jay | Indiana | 18075 | 2719 | 44 |
1774040 | 1774040 | 2021-10-01 | Franklin | Vermont | 50011 | 2719 | 43 |
1767455 | 1767455 | 2021-09-29 | San Jacinto | Texas | 48407 | 2719 | 64 |
1764403 | 1764403 | 2021-09-28 | Prince Edward | Virginia | 51147 | 2719 | 45 |
1739641 | 1739641 | 2021-09-21 | Anderson | Kentucky | 21005 | 2719 | 34 |
1733148 | 1733148 | 2021-09-19 | Bourbon | Kentucky | 21017 | 2719 | 22 |
1729898 | 1729898 | 2021-09-18 | Bourbon | Kentucky | 21017 | 2719 | 22 |
1726648 | 1726648 | 2021-09-17 | Bourbon | Kentucky | 21017 | 2719 | 22 |
1715412 | 1715412 | 2021-09-13 | Lee | Texas | 48287 | 2719 | 45 |
1695755 | 1695755 | 2021-09-07 | Polk | Tennessee | 47139 | 2719 | 25 |
1667217 | 1667217 | 2021-08-30 | Monroe | Alabama | 1099 | 2719 | 42 |
1653070 | 1653070 | 2021-08-25 | Van Wert | Ohio | 39161 | 2719 | 67 |
1646493 | 1646493 | 2021-08-23 | Adams | Ohio | 39001 | 2719 | 59 |
1629418 | 1629418 | 2021-08-18 | Franklin | Massachusetts | 25011 | 2719 | 114 |
1619066 | 1619066 | 2021-08-15 | Douglas | Illinois | 17041 | 2719 | 42 |
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);