ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where cases = 7467 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 18
- Indiana 7
- Kansas 7
- Oklahoma 7
- New York 4
- North Carolina 4
- Georgia 3
- Minnesota 3
- Mississippi 3
- Missouri 3
- Virginia 3
- California 2
- Kentucky 2
- Ohio 2
- Texas 2
- Florida 1
- Illinois 1
- Massachusetts 1
- Puerto Rico 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2405810 | 2405810 | 2022-04-14 | Perry | Illinois | 17145 | 7467 | 106 |
2376558 | 2376558 | 2022-04-05 | Daviess | Indiana | 18027 | 7467 | 153 |
2373306 | 2373306 | 2022-04-04 | Daviess | Indiana | 18027 | 7467 | 153 |
2370053 | 2370053 | 2022-04-03 | Daviess | Indiana | 18027 | 7467 | 153 |
2366800 | 2366800 | 2022-04-02 | Daviess | Indiana | 18027 | 7467 | 153 |
2363547 | 2363547 | 2022-04-01 | Daviess | Indiana | 18027 | 7467 | 153 |
2359384 | 2359384 | 2022-03-30 | Wythe | Virginia | 51197 | 7467 | 142 |
2331014 | 2331014 | 2022-03-22 | Daviess | Indiana | 18027 | 7467 | 151 |
2316401 | 2316401 | 2022-03-17 | Humacao | Puerto Rico | 72069 | 7467 | |
2293227 | 2293227 | 2022-03-10 | Macon | North Carolina | 37113 | 7467 | 106 |
2218340 | 2218340 | 2022-02-15 | Delaware | New York | 36025 | 7467 | 68 |
2055263 | 2055263 | 2021-12-27 | Steele | Minnesota | 27147 | 7467 | 41 |
2033205 | 2033205 | 2021-12-20 | Guernsey | Ohio | 39059 | 7467 | 93 |
2034071 | 2034071 | 2021-12-20 | Culpeper | Virginia | 51047 | 7467 | 94 |
1931938 | 1931938 | 2021-11-19 | Scott | Missouri | 29201 | 7467 | 132 |
1905924 | 1905924 | 2021-11-11 | Pettis | Missouri | 29159 | 7467 | 105 |
1902675 | 1902675 | 2021-11-10 | Pettis | Missouri | 29159 | 7467 | 105 |
1834191 | 1834191 | 2021-10-20 | Benton | Minnesota | 27009 | 7467 | 110 |
1823591 | 1823591 | 2021-10-17 | Liberty | Georgia | 13179 | 7467 | 107 |
1820342 | 1820342 | 2021-10-16 | Liberty | Georgia | 13179 | 7467 | 107 |
1817093 | 1817093 | 2021-10-15 | Liberty | Georgia | 13179 | 7467 | 107 |
1807077 | 1807077 | 2021-10-12 | Mendocino | California | 6045 | 7467 | 86 |
1694134 | 1694134 | 2021-09-07 | Riley | Kansas | 20161 | 7467 | 57 |
1695314 | 1695314 | 2021-09-07 | Bryan | Oklahoma | 40013 | 7467 | 84 |
1690885 | 1690885 | 2021-09-06 | Riley | Kansas | 20161 | 7467 | 57 |
1692066 | 1692066 | 2021-09-06 | Bryan | Oklahoma | 40013 | 7467 | 84 |
1687635 | 1687635 | 2021-09-05 | Riley | Kansas | 20161 | 7467 | 57 |
1688817 | 1688817 | 2021-09-05 | Bryan | Oklahoma | 40013 | 7467 | 84 |
1684385 | 1684385 | 2021-09-04 | Riley | Kansas | 20161 | 7467 | 55 |
1685567 | 1685567 | 2021-09-04 | Bryan | Oklahoma | 40013 | 7467 | 84 |
1681134 | 1681134 | 2021-09-03 | Riley | Kansas | 20161 | 7467 | 55 |
1682316 | 1682316 | 2021-09-03 | Bryan | Oklahoma | 40013 | 7467 | 84 |
1677886 | 1677886 | 2021-09-02 | Riley | Kansas | 20161 | 7467 | 55 |
1679066 | 1679066 | 2021-09-02 | Bryan | Oklahoma | 40013 | 7467 | 84 |
1674639 | 1674639 | 2021-09-01 | Riley | Kansas | 20161 | 7467 | 54 |
1675555 | 1675555 | 2021-09-01 | Steuben | New York | 36101 | 7467 | 148 |
1675818 | 1675818 | 2021-09-01 | Bryan | Oklahoma | 40013 | 7467 | 84 |
1656132 | 1656132 | 2021-08-26 | Lee | North Carolina | 37105 | 7467 | 88 |
1619545 | 1619545 | 2021-08-15 | Pulaski | Kentucky | 21199 | 7467 | 133 |
1616297 | 1616297 | 2021-08-14 | Pulaski | Kentucky | 21199 | 7467 | 133 |
1587409 | 1587409 | 2021-08-05 | Lamar | Mississippi | 28073 | 7467 | 90 |
1359048 | 1359048 | 2021-05-27 | Flagler | Florida | 12035 | 7467 | 112 |
1331368 | 1331368 | 2021-05-18 | Oswego | New York | 36075 | 7467 | 90 |
1302121 | 1302121 | 2021-05-09 | Chemung | New York | 36015 | 7467 | 134 |
1191199 | 1191199 | 2021-04-05 | Clay | Minnesota | 27027 | 7467 | 89 |
1189656 | 1189656 | 2021-04-04 | Suffolk city | Virginia | 51800 | 7467 | 178 |
1162065 | 1162065 | 2021-03-27 | Forrest | Mississippi | 28035 | 7467 | 143 |
1039247 | 1039247 | 2021-02-17 | Orange | North Carolina | 37135 | 7467 | 91 |
1003023 | 1003023 | 2021-02-06 | Jones | Mississippi | 28067 | 7467 | 132 |
961492 | 961492 | 2021-01-24 | Marion | Ohio | 39101 | 7467 | 113 |
846552 | 846552 | 2020-12-20 | Monroe | Indiana | 18105 | 7467 | 86 |
742147 | 742147 | 2020-11-18 | Marin | California | 6041 | 7467 | 128 |
722038 | 722038 | 2020-11-11 | Randall | Texas | 48381 | 7467 | 70 |
718795 | 718795 | 2020-11-10 | Randall | Texas | 48381 | 7467 | 70 |
546060 | 546060 | 2020-09-18 | Durham | North Carolina | 37063 | 7467 | 90 |
393600 | 393600 | 2020-08-02 | Hampden | Massachusetts | 25013 | 7467 | 698 |
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);