ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where cases = 13116 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- Indiana 6
- Minnesota 4
- Maryland 3
- Tennessee 3
- New York 2
- Alabama 1
- Colorado 1
- Georgia 1
- Iowa 1
- New Hampshire 1
- North Carolina 1
- Ohio 1
- Oregon 1
- Pennsylvania 1
- Puerto Rico 1
- Texas 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466717 | 2466717 | 2022-05-02 | Fauquier | Virginia | 51061 | 13116 | 143 |
2337245 | 2337245 | 2022-03-24 | Effingham | Georgia | 13103 | 13116 | 190 |
2221115 | 2221115 | 2022-02-16 | Otter Tail | Minnesota | 27111 | 13116 | 160 |
2188536 | 2188536 | 2022-02-06 | Benton | Minnesota | 27009 | 13116 | 162 |
2185283 | 2185283 | 2022-02-05 | Benton | Minnesota | 27009 | 13116 | 162 |
2182031 | 2182031 | 2022-02-04 | Benton | Minnesota | 27009 | 13116 | 162 |
2173174 | 2173174 | 2022-02-01 | Benton | Oregon | 41003 | 13116 | 53 |
2127245 | 2127245 | 2022-01-18 | Clinton | New York | 36019 | 13116 | 64 |
2074089 | 2074089 | 2022-01-02 | Floyd | Indiana | 18043 | 13116 | 249 |
2070838 | 2070838 | 2022-01-01 | Floyd | Indiana | 18043 | 13116 | 249 |
2071339 | 2071339 | 2022-01-01 | Wicomico | Maryland | 24045 | 13116 | 250 |
2067587 | 2067587 | 2021-12-31 | Floyd | Indiana | 18043 | 13116 | 249 |
2068088 | 2068088 | 2021-12-31 | Wicomico | Maryland | 24045 | 13116 | 250 |
2064336 | 2064336 | 2021-12-30 | Floyd | Indiana | 18043 | 13116 | 249 |
2064837 | 2064837 | 2021-12-30 | Wicomico | Maryland | 24045 | 13116 | 250 |
2037147 | 2037147 | 2021-12-21 | Maverick | Texas | 48323 | 13116 | 413 |
1968216 | 1968216 | 2021-11-30 | Marion | Ohio | 39101 | 13116 | 194 |
1939192 | 1939192 | 2021-11-21 | Carolina | Puerto Rico | 72031 | 13116 | |
1701571 | 1701571 | 2021-09-09 | Burke | North Carolina | 37023 | 13116 | 164 |
1573009 | 1573009 | 2021-08-01 | Marshall | Alabama | 1095 | 13116 | 235 |
1356176 | 1356176 | 2021-05-26 | Clark | Indiana | 18019 | 13116 | 201 |
1240477 | 1240477 | 2021-04-20 | Ulster | New York | 36111 | 13116 | 243 |
1234690 | 1234690 | 2021-04-18 | Sevier | Tennessee | 47155 | 13116 | 174 |
1231442 | 1231442 | 2021-04-17 | Sevier | Tennessee | 47155 | 13116 | 174 |
1228194 | 1228194 | 2021-04-16 | Sevier | Tennessee | 47155 | 13116 | 174 |
1223167 | 1223167 | 2021-04-15 | Dubuque | Iowa | 19061 | 13116 | 202 |
1016882 | 1016882 | 2021-02-10 | Washington | Pennsylvania | 42125 | 13116 | 240 |
925469 | 925469 | 2021-01-13 | Rockingham | New Hampshire | 33015 | 13116 | 162 |
833599 | 833599 | 2020-12-16 | Vanderburgh | Indiana | 18163 | 13116 | 174 |
573544 | 573544 | 2020-09-27 | Denver | Colorado | 8031 | 13116 | 440 |
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);