ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 10726 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- Oklahoma 8
- Florida 7
- California 4
- Indiana 3
- Louisiana 3
- Georgia 2
- Iowa 2
- Ohio 2
- Utah 2
- Arizona 1
- Connecticut 1
- Maine 1
- Massachusetts 1
- New York 1
- North Carolina 1
- North Dakota 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490559 | 2490559 | 2022-05-10 | Montgomery | Indiana | 18107 | 10726 | 164 |
2487302 | 2487302 | 2022-05-09 | Montgomery | Indiana | 18107 | 10726 | 164 |
2454180 | 2454180 | 2022-04-29 | Lassen | California | 6035 | 10726 | 69 |
2450924 | 2450924 | 2022-04-28 | Lassen | California | 6035 | 10726 | 69 |
2447668 | 2447668 | 2022-04-27 | Lassen | California | 6035 | 10726 | 69 |
2444412 | 2444412 | 2022-04-26 | Lassen | California | 6035 | 10726 | 69 |
2403116 | 2403116 | 2022-04-13 | Franklin | Massachusetts | 25011 | 10726 | 133 |
2311523 | 2311523 | 2022-03-16 | Knox | Indiana | 18083 | 10726 | 151 |
2290227 | 2290227 | 2022-03-09 | Pittsburg | Oklahoma | 40121 | 10726 | 195 |
2286975 | 2286975 | 2022-03-08 | Pittsburg | Oklahoma | 40121 | 10726 | 195 |
2283723 | 2283723 | 2022-03-07 | Pittsburg | Oklahoma | 40121 | 10726 | 195 |
2280471 | 2280471 | 2022-03-06 | Pittsburg | Oklahoma | 40121 | 10726 | 195 |
2277218 | 2277218 | 2022-03-05 | Pittsburg | Oklahoma | 40121 | 10726 | 195 |
2273965 | 2273965 | 2022-03-04 | Pittsburg | Oklahoma | 40121 | 10726 | 195 |
2270712 | 2270712 | 2022-03-03 | Pittsburg | Oklahoma | 40121 | 10726 | 195 |
2267460 | 2267460 | 2022-03-02 | Pittsburg | Oklahoma | 40121 | 10726 | 195 |
2006228 | 2006228 | 2021-12-12 | Acadia | Louisiana | 22001 | 10726 | 251 |
2002977 | 2002977 | 2021-12-11 | Acadia | Louisiana | 22001 | 10726 | 251 |
1999727 | 1999727 | 2021-12-10 | Acadia | Louisiana | 22001 | 10726 | 251 |
1968193 | 1968193 | 2021-11-30 | Geauga | Ohio | 39055 | 10726 | 175 |
1853543 | 1853543 | 2021-10-26 | Androscoggin | Maine | 23001 | 10726 | 99 |
1609082 | 1609082 | 2021-08-12 | Sumter | Florida | 12119 | 10726 | 284 |
1605833 | 1605833 | 2021-08-11 | Sumter | Florida | 12119 | 10726 | 284 |
1602584 | 1602584 | 2021-08-10 | Sumter | Florida | 12119 | 10726 | 284 |
1599335 | 1599335 | 2021-08-09 | Sumter | Florida | 12119 | 10726 | 284 |
1596086 | 1596086 | 2021-08-08 | Sumter | Florida | 12119 | 10726 | 284 |
1592837 | 1592837 | 2021-08-07 | Sumter | Florida | 12119 | 10726 | 284 |
1589588 | 1589588 | 2021-08-06 | Sumter | Florida | 12119 | 10726 | 284 |
1519776 | 1519776 | 2021-07-15 | Grand Forks | North Dakota | 38035 | 10726 | 79 |
1456958 | 1456958 | 2021-06-26 | Story | Iowa | 19169 | 10726 | 48 |
1338649 | 1338649 | 2021-05-20 | Comal | Texas | 48091 | 10726 | 321 |
1240464 | 1240464 | 2021-04-20 | Rensselaer | New York | 36083 | 10726 | 136 |
1184184 | 1184184 | 2021-04-03 | Dallas | Iowa | 19049 | 10726 | 96 |
1182247 | 1182247 | 2021-04-02 | Richland | Ohio | 39139 | 10726 | 198 |
1128258 | 1128258 | 2021-03-17 | Apache | Arizona | 4001 | 10726 | 400 |
1115588 | 1115588 | 2021-03-13 | Carroll | Georgia | 13045 | 10726 | 220 |
1105750 | 1105750 | 2021-03-10 | Middlesex | Connecticut | 9007 | 10726 | 346 |
985826 | 985826 | 2021-02-01 | Lowndes | Georgia | 13185 | 10726 | 165 |
815266 | 815266 | 2020-12-10 | Cumberland | North Carolina | 37051 | 10726 | 124 |
803260 | 803260 | 2020-12-06 | Washington | Utah | 49053 | 10726 | 81 |
800015 | 800015 | 2020-12-05 | Washington | Utah | 49053 | 10726 | 81 |
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);