ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where cases = 10346 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 15
- Ohio 8
- New York 3
- Texas 3
- Illinois 2
- Indiana 2
- Pennsylvania 2
- Virginia 2
- Alabama 1
- Arkansas 1
- California 1
- Florida 1
- Georgia 1
- Kentucky 1
- Nebraska 1
- South Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2472337 | 2472337 | 2022-05-04 | Clinton | Ohio | 39027 | 10346 | 167 |
2469081 | 2469081 | 2022-05-03 | Clinton | Ohio | 39027 | 10346 | 167 |
2465825 | 2465825 | 2022-05-02 | Clinton | Ohio | 39027 | 10346 | 167 |
2462570 | 2462570 | 2022-05-01 | Clinton | Ohio | 39027 | 10346 | 167 |
2459314 | 2459314 | 2022-04-30 | Clinton | Ohio | 39027 | 10346 | 167 |
2456058 | 2456058 | 2022-04-29 | Clinton | Ohio | 39027 | 10346 | 167 |
2452802 | 2452802 | 2022-04-28 | Clinton | Ohio | 39027 | 10346 | 167 |
2303882 | 2303882 | 2022-03-13 | Van Zandt | Texas | 48467 | 10346 | 275 |
2300630 | 2300630 | 2022-03-12 | Van Zandt | Texas | 48467 | 10346 | 275 |
2296376 | 2296376 | 2022-03-11 | Cortland | New York | 36023 | 10346 | 114 |
2297378 | 2297378 | 2022-03-11 | Van Zandt | Texas | 48467 | 10346 | 275 |
2206735 | 2206735 | 2022-02-12 | Chilton | Alabama | 1021 | 10346 | 185 |
1971255 | 1971255 | 2021-12-01 | Wayne | New York | 36117 | 10346 | 103 |
1919054 | 1919054 | 2021-11-15 | Hall | Nebraska | 31079 | 10346 | 120 |
1904032 | 1904032 | 2021-11-10 | Augusta | Virginia | 51015 | 10346 | 133 |
1898871 | 1898871 | 2021-11-09 | Christian | Kentucky | 21047 | 10346 | 132 |
1602803 | 1602803 | 2021-08-10 | Adams | Illinois | 17001 | 10346 | 160 |
1534388 | 1534388 | 2021-07-20 | Barrow | Georgia | 13013 | 10346 | 147 |
1440589 | 1440589 | 2021-06-21 | Howard | Indiana | 18067 | 10346 | 228 |
1381565 | 1381565 | 2021-06-03 | Garland | Arkansas | 5051 | 10346 | 261 |
1293509 | 1293509 | 2021-05-06 | Hampton city | Virginia | 51650 | 10346 | 175 |
1267013 | 1267013 | 2021-04-28 | Sumter | South Carolina | 45085 | 10346 | 202 |
1178985 | 1178985 | 2021-04-01 | Miami | Ohio | 39109 | 10346 | 206 |
1123977 | 1123977 | 2021-03-15 | Monroe | Pennsylvania | 42089 | 10346 | 279 |
1080225 | 1080225 | 2021-03-02 | Monroe | Indiana | 18105 | 10346 | 165 |
1034361 | 1034361 | 2021-02-16 | Charlotte | Florida | 12015 | 10346 | 335 |
1023316 | 1023316 | 2021-02-12 | Blair | Pennsylvania | 42013 | 10346 | 285 |
976253 | 976253 | 2021-01-29 | Kendall | Illinois | 17093 | 10346 | 85 |
901173 | 901173 | 2021-01-06 | Marin | California | 6041 | 10346 | 143 |
513623 | 513623 | 2020-09-08 | Erie | New York | 36029 | 10346 | 610 |
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);