ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where cases = 7827 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Texas 8
- Minnesota 6
- North Carolina 5
- Pennsylvania 5
- New York 4
- Tennessee 4
- Arkansas 3
- California 2
- Georgia 2
- Indiana 2
- Maine 2
- Ohio 2
- Florida 1
- Illinois 1
- Maryland 1
- Mississippi 1
- Missouri 1
- Nevada 1
- New Hampshire 1
- New Jersey 1
- South Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2417722 | 2417722 | 2022-04-17 | Polk | Texas | 48373 | 7827 | 247 |
2414466 | 2414466 | 2022-04-16 | Polk | Texas | 48373 | 7827 | 247 |
2411210 | 2411210 | 2022-04-15 | Polk | Texas | 48373 | 7827 | 247 |
2407954 | 2407954 | 2022-04-14 | Polk | Texas | 48373 | 7827 | 247 |
2404698 | 2404698 | 2022-04-13 | Polk | Texas | 48373 | 7827 | 247 |
2391188 | 2391188 | 2022-04-09 | Susquehanna | Pennsylvania | 42115 | 7827 | 108 |
2311460 | 2311460 | 2022-03-16 | Saline | Illinois | 17165 | 7827 | 108 |
2256872 | 2256872 | 2022-02-27 | Nicollet | Minnesota | 27103 | 7827 | 66 |
2253621 | 2253621 | 2022-02-26 | Nicollet | Minnesota | 27103 | 7827 | 66 |
2250370 | 2250370 | 2022-02-25 | Nicollet | Minnesota | 27103 | 7827 | 66 |
2244814 | 2244814 | 2022-02-23 | Tioga | Pennsylvania | 42117 | 7827 | 187 |
2149749 | 2149749 | 2022-01-25 | Pulaski | Missouri | 29169 | 7827 | 104 |
2149956 | 2149956 | 2022-01-25 | Sullivan | New Hampshire | 33019 | 7827 | 58 |
2090816 | 2090816 | 2022-01-07 | Oxford | Maine | 23017 | 7827 | 111 |
2081964 | 2081964 | 2022-01-04 | Highland | Ohio | 39071 | 7827 | 137 |
2075260 | 2075260 | 2022-01-02 | Tioga | New York | 36107 | 7827 | 78 |
2059762 | 2059762 | 2021-12-28 | Burnet | Texas | 48053 | 7827 | 133 |
2036907 | 2036907 | 2021-12-21 | Cocke | Tennessee | 47029 | 7827 | 126 |
1945201 | 1945201 | 2021-11-23 | Clinton | New York | 36019 | 7827 | 45 |
1857414 | 1857414 | 2021-10-27 | Salem | New Jersey | 34033 | 7827 | 205 |
1844740 | 1844740 | 2021-10-23 | Sandusky | Ohio | 39143 | 7827 | 151 |
1812019 | 1812019 | 2021-10-13 | Wayne | New York | 36117 | 7827 | 83 |
1747031 | 1747031 | 2021-09-23 | Sullivan | New York | 36105 | 7827 | 81 |
1693285 | 1693285 | 2021-09-07 | Crittenden | Arkansas | 5035 | 7827 | 112 |
1572014 | 1572014 | 2021-07-31 | Lawrence | Pennsylvania | 42073 | 7827 | 218 |
1568766 | 1568766 | 2021-07-30 | Lawrence | Pennsylvania | 42073 | 7827 | 218 |
1428298 | 1428298 | 2021-06-17 | Forrest | Mississippi | 28035 | 7827 | 153 |
1385187 | 1385187 | 2021-06-04 | Rockdale | Georgia | 13247 | 7827 | 173 |
1365992 | 1365992 | 2021-05-29 | Warrick | Indiana | 18173 | 7827 | 158 |
1362746 | 1362746 | 2021-05-28 | Warrick | Indiana | 18173 | 7827 | 158 |
1279529 | 1279529 | 2021-05-02 | Sampson | North Carolina | 37163 | 7827 | 108 |
1280100 | 1280100 | 2021-05-02 | Greene | Tennessee | 47059 | 7827 | 153 |
1276282 | 1276282 | 2021-05-01 | Sampson | North Carolina | 37163 | 7827 | 108 |
1276853 | 1276853 | 2021-05-01 | Greene | Tennessee | 47059 | 7827 | 153 |
1273035 | 1273035 | 2021-04-30 | Sampson | North Carolina | 37163 | 7827 | 108 |
1273606 | 1273606 | 2021-04-30 | Greene | Tennessee | 47059 | 7827 | 153 |
1196705 | 1196705 | 2021-04-07 | Highlands | Florida | 12055 | 7827 | 328 |
1183548 | 1183548 | 2021-04-03 | White | Arkansas | 5145 | 7827 | 116 |
1134825 | 1134825 | 2021-03-19 | Pope | Arkansas | 5115 | 7827 | 103 |
1128616 | 1128616 | 2021-03-17 | Gordon | Georgia | 13129 | 7827 | 105 |
1119632 | 1119632 | 2021-03-14 | Carroll | Maryland | 24013 | 7827 | 216 |
1097671 | 1097671 | 2021-03-07 | Orange | North Carolina | 37135 | 7827 | 95 |
1094423 | 1094423 | 2021-03-06 | Orange | North Carolina | 37135 | 7827 | 95 |
1078653 | 1078653 | 2021-03-01 | Darlington | South Carolina | 45031 | 7827 | 163 |
954093 | 954093 | 2021-01-22 | York | Maine | 23031 | 7827 | 96 |
880515 | 880515 | 2020-12-30 | Blair | Pennsylvania | 42013 | 7827 | 173 |
769302 | 769302 | 2020-11-26 | Scott | Minnesota | 27139 | 7827 | 54 |
766056 | 766056 | 2020-11-25 | Scott | Minnesota | 27139 | 7827 | 54 |
516777 | 516777 | 2020-09-09 | Washoe | Nevada | 32031 | 7827 | 147 |
453220 | 453220 | 2020-08-20 | Williamson | Texas | 48491 | 7827 | 113 |
429168 | 429168 | 2020-08-13 | Ramsey | Minnesota | 27123 | 7827 | 270 |
372484 | 372484 | 2020-07-26 | Cameron | Texas | 48061 | 7827 | 177 |
325270 | 325270 | 2020-07-12 | Imperial | California | 6025 | 7827 | 134 |
322089 | 322089 | 2020-07-11 | Imperial | California | 6025 | 7827 | 134 |
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);