ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where cases = 10076 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 18
- Tennessee 7
- Minnesota 4
- Virginia 4
- Georgia 3
- North Carolina 3
- Ohio 2
- Alabama 1
- Connecticut 1
- Indiana 1
- Kentucky 1
- Mississippi 1
- New York 1
- North Dakota 1
- Oregon 1
- Pennsylvania 1
- Puerto Rico 1
- South Carolina 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496343 | 2496343 | 2022-05-12 | Escambia | Alabama | 1053 | 10076 | 171 |
2393474 | 2393474 | 2022-04-10 | Isanti | Minnesota | 27059 | 10076 | 117 |
2390218 | 2390218 | 2022-04-09 | Isanti | Minnesota | 27059 | 10076 | 117 |
2386962 | 2386962 | 2022-04-08 | Isanti | Minnesota | 27059 | 10076 | 117 |
2380955 | 2380955 | 2022-04-06 | Columbia | New York | 36021 | 10076 | 140 |
2313731 | 2313731 | 2022-03-16 | Charlottesville city | Virginia | 51540 | 10076 | 77 |
2224474 | 2224474 | 2022-02-17 | Washington | Mississippi | 28151 | 10076 | 188 |
2217882 | 2217882 | 2022-02-15 | Steele | Minnesota | 27147 | 10076 | 50 |
2219068 | 2219068 | 2022-02-15 | Marshall | Tennessee | 47117 | 10076 | 110 |
2215817 | 2215817 | 2022-02-14 | Marshall | Tennessee | 47117 | 10076 | 110 |
2212566 | 2212566 | 2022-02-13 | Marshall | Tennessee | 47117 | 10076 | 110 |
2209313 | 2209313 | 2022-02-12 | Marshall | Tennessee | 47117 | 10076 | 110 |
2206060 | 2206060 | 2022-02-11 | Marshall | Tennessee | 47117 | 10076 | 110 |
2202807 | 2202807 | 2022-02-10 | Marshall | Tennessee | 47117 | 10076 | 110 |
2199553 | 2199553 | 2022-02-09 | Marshall | Tennessee | 47117 | 10076 | 110 |
2016962 | 2016962 | 2021-12-15 | Jefferson | Ohio | 39081 | 10076 | 236 |
2013874 | 2013874 | 2021-12-14 | Yamhill | Oregon | 41071 | 10076 | 152 |
1998236 | 1998236 | 2021-12-09 | Box Elder | Utah | 49003 | 10076 | 97 |
1802652 | 1802652 | 2021-10-10 | Crawford | Pennsylvania | 42039 | 10076 | 175 |
1712381 | 1712381 | 2021-09-12 | Hanover | Virginia | 51085 | 10076 | 178 |
1709134 | 1709134 | 2021-09-11 | Hanover | Virginia | 51085 | 10076 | 178 |
1705887 | 1705887 | 2021-09-10 | Hanover | Virginia | 51085 | 10076 | 178 |
1669242 | 1669242 | 2021-08-30 | Columbiana | Ohio | 39029 | 10076 | 236 |
1628932 | 1628932 | 2021-08-18 | Kosciusko | Indiana | 18085 | 10076 | 129 |
1545789 | 1545789 | 2021-07-23 | Ward | North Dakota | 38101 | 10076 | 201 |
1505236 | 1505236 | 2021-07-11 | Jackson | Georgia | 13157 | 10076 | 152 |
1501990 | 1501990 | 2021-07-10 | Jackson | Georgia | 13157 | 10076 | 152 |
1498744 | 1498744 | 2021-07-09 | Jackson | Georgia | 13157 | 10076 | 152 |
1393079 | 1393079 | 2021-06-06 | Burke | North Carolina | 37023 | 10076 | 159 |
1389834 | 1389834 | 2021-06-05 | Burke | North Carolina | 37023 | 10076 | 159 |
1386589 | 1386589 | 2021-06-04 | Burke | North Carolina | 37023 | 10076 | 159 |
1305860 | 1305860 | 2021-05-10 | Carolina | Puerto Rico | 72031 | 10076 | |
1199922 | 1199922 | 2021-04-08 | Windham | Connecticut | 9015 | 10076 | 188 |
1179328 | 1179328 | 2021-04-01 | Sumter | South Carolina | 45085 | 10076 | 196 |
652147 | 652147 | 2020-10-21 | Fayette | Kentucky | 21067 | 10076 | 91 |
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);