ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where cases = 7599 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Florida 7
- North Carolina 4
- Texas 4
- Alabama 3
- Arkansas 3
- Minnesota 3
- Georgia 2
- Indiana 2
- New York 2
- Ohio 2
- California 1
- Colorado 1
- Delaware 1
- Kentucky 1
- Michigan 1
- Mississippi 1
- Nebraska 1
- New Jersey 1
- Oklahoma 1
- Oregon 1
- Puerto Rico 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2407376 | 2407376 | 2022-04-14 | Columbia | Oregon | 41009 | 7599 | 93 |
2404254 | 2404254 | 2022-04-13 | Humacao | Puerto Rico | 72069 | 7599 | |
2332259 | 2332259 | 2022-03-22 | Macon | North Carolina | 37113 | 7599 | 111 |
2288204 | 2288204 | 2022-03-09 | Calaveras | California | 6009 | 7599 | 117 |
2284675 | 2284675 | 2022-03-07 | Clark | Wisconsin | 55019 | 7599 | 117 |
2223525 | 2223525 | 2022-02-17 | Wayne | Georgia | 13305 | 7599 | 194 |
2128123 | 2128123 | 2022-01-18 | Hill | Texas | 48217 | 7599 | 178 |
2109285 | 2109285 | 2022-01-13 | Miller | Arkansas | 5091 | 7599 | 158 |
2107607 | 2107607 | 2022-01-12 | Madison | Nebraska | 31119 | 7599 | 55 |
2084608 | 2084608 | 2022-01-05 | Warren | Mississippi | 28149 | 7599 | 181 |
2076669 | 2076669 | 2022-01-03 | Russell | Alabama | 1113 | 7599 | 67 |
2049470 | 2049470 | 2021-12-25 | Logan | Ohio | 39091 | 7599 | 124 |
2046220 | 2046220 | 2021-12-24 | Logan | Ohio | 39091 | 7599 | 124 |
1941446 | 1941446 | 2021-11-22 | Goodhue | Minnesota | 27049 | 7599 | 93 |
1806416 | 1806416 | 2021-10-11 | Nacogdoches | Texas | 48347 | 7599 | 215 |
1803166 | 1803166 | 2021-10-10 | Nacogdoches | Texas | 48347 | 7599 | 215 |
1799917 | 1799917 | 2021-10-09 | Nacogdoches | Texas | 48347 | 7599 | 215 |
1782819 | 1782819 | 2021-10-04 | Granville | North Carolina | 37077 | 7599 | 96 |
1745559 | 1745559 | 2021-09-23 | Coffee | Georgia | 13069 | 7599 | 202 |
1621830 | 1621830 | 2021-08-16 | Greene | Arkansas | 5055 | 7599 | 85 |
1607330 | 1607330 | 2021-08-11 | Ontario | New York | 36069 | 7599 | 93 |
1495368 | 1495368 | 2021-07-08 | Flagler | Florida | 12035 | 7599 | 114 |
1492122 | 1492122 | 2021-07-07 | Flagler | Florida | 12035 | 7599 | 114 |
1492846 | 1492846 | 2021-07-07 | Laurel | Kentucky | 21125 | 7599 | 81 |
1488875 | 1488875 | 2021-07-06 | Flagler | Florida | 12035 | 7599 | 114 |
1485628 | 1485628 | 2021-07-05 | Flagler | Florida | 12035 | 7599 | 114 |
1482382 | 1482382 | 2021-07-04 | Flagler | Florida | 12035 | 7599 | 114 |
1479135 | 1479135 | 2021-07-03 | Flagler | Florida | 12035 | 7599 | 114 |
1475889 | 1475889 | 2021-07-02 | Flagler | Florida | 12035 | 7599 | 114 |
1393045 | 1393045 | 2021-06-06 | Oswego | New York | 36075 | 7599 | 91 |
1375668 | 1375668 | 2021-06-01 | Grant | Indiana | 18053 | 7599 | 183 |
1360041 | 1360041 | 2021-05-27 | Blue Earth | Minnesota | 27013 | 7599 | 41 |
1258786 | 1258786 | 2021-04-26 | Floyd | Indiana | 18043 | 7599 | 181 |
1091378 | 1091378 | 2021-03-05 | Garfield | Oklahoma | 40047 | 7599 | 78 |
1064578 | 1064578 | 2021-02-25 | Carver | Minnesota | 27019 | 7599 | 40 |
943212 | 943212 | 2021-01-19 | St. Clair | Alabama | 1115 | 7599 | 120 |
913989 | 913989 | 2021-01-10 | Limestone | Alabama | 1083 | 7599 | 60 |
836379 | 836379 | 2020-12-17 | Kent | Delaware | 10001 | 7599 | 147 |
769884 | 769884 | 2020-11-26 | Pitt | North Carolina | 37147 | 7599 | 44 |
766638 | 766638 | 2020-11-25 | Pitt | North Carolina | 37147 | 7599 | 44 |
654633 | 654633 | 2020-10-22 | Jefferson | Colorado | 8059 | 7599 | 301 |
650861 | 650861 | 2020-10-20 | Loudoun | Virginia | 51107 | 7599 | 130 |
641490 | 641490 | 2020-10-18 | Benton | Arkansas | 5007 | 7599 | 110 |
478002 | 478002 | 2020-08-28 | Morris | New Jersey | 34027 | 7599 | 829 |
288347 | 288347 | 2020-06-30 | Macomb | Michigan | 26099 | 7599 | 921 |
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);