ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where deaths = 1466 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 16
- Georgia 7
- Pennsylvania 5
- Texas 5
- Alabama 4
- Illinois 4
- Arizona 3
- Florida 3
- California 2
- New Jersey 2
- South Carolina 2
- Connecticut 1
- Kentucky 1
- Massachusetts 1
- Missouri 1
- New York 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500226 | 2500226 | 2022-05-13 | Lake | Illinois | 17097 | 159179 | 1466 |
2496968 | 2496968 | 2022-05-12 | Lake | Illinois | 17097 | 158607 | 1466 |
2493710 | 2493710 | 2022-05-11 | Lake | Illinois | 17097 | 158299 | 1466 |
2490452 | 2490452 | 2022-05-10 | Lake | Illinois | 17097 | 157777 | 1466 |
2306606 | 2306606 | 2022-03-14 | York | Pennsylvania | 42133 | 118162 | 1466 |
2303355 | 2303355 | 2022-03-13 | York | Pennsylvania | 42133 | 118151 | 1466 |
2300103 | 2300103 | 2022-03-12 | York | Pennsylvania | 42133 | 118139 | 1466 |
2300439 | 2300439 | 2022-03-12 | Collin | Texas | 48085 | 206252 | 1466 |
2190563 | 2190563 | 2022-02-07 | Pinal | Arizona | 4021 | 125067 | 1466 |
2187310 | 2187310 | 2022-02-06 | Pinal | Arizona | 4021 | 124625 | 1466 |
2184057 | 2184057 | 2022-02-05 | Pinal | Arizona | 4021 | 124304 | 1466 |
2155103 | 2155103 | 2022-01-27 | DeKalb | Georgia | 13089 | 136958 | 1466 |
2077037 | 2077037 | 2022-01-03 | Cobb | Georgia | 13067 | 130033 | 1466 |
2073786 | 2073786 | 2022-01-02 | Cobb | Georgia | 13067 | 130033 | 1466 |
2070535 | 2070535 | 2022-01-01 | Cobb | Georgia | 13067 | 130033 | 1466 |
2067284 | 2067284 | 2021-12-31 | Cobb | Georgia | 13067 | 130033 | 1466 |
1932618 | 1932618 | 2021-11-19 | Bucks | Pennsylvania | 42017 | 77104 | 1466 |
1922390 | 1922390 | 2021-11-16 | Camden | New Jersey | 34007 | 69987 | 1466 |
1906785 | 1906785 | 2021-11-11 | Greenville | South Carolina | 45045 | 106066 | 1466 |
1901283 | 1901283 | 2021-11-10 | Alameda | California | 6001 | 123044 | 1466 |
1903536 | 1903536 | 2021-11-10 | Greenville | South Carolina | 45045 | 106066 | 1466 |
1882054 | 1882054 | 2021-11-04 | Gwinnett | Georgia | 13135 | 133730 | 1466 |
1823485 | 1823485 | 2021-10-17 | Pasco | Florida | 12101 | 78642 | 1466 |
1820236 | 1820236 | 2021-10-16 | Pasco | Florida | 12101 | 78642 | 1466 |
1816987 | 1816987 | 2021-10-15 | Pasco | Florida | 12101 | 78642 | 1466 |
1789659 | 1789659 | 2021-10-06 | Delaware | Pennsylvania | 42045 | 59850 | 1466 |
1736445 | 1736445 | 2021-09-20 | Jefferson | Kentucky | 21111 | 107012 | 1466 |
1450037 | 1450037 | 2021-06-24 | Fulton | Georgia | 13121 | 99450 | 1466 |
1189895 | 1189895 | 2021-04-05 | Jefferson | Alabama | 1073 | 74976 | 1466 |
1186648 | 1186648 | 2021-04-04 | Jefferson | Alabama | 1073 | 74942 | 1466 |
1183401 | 1183401 | 2021-04-03 | Jefferson | Alabama | 1073 | 74917 | 1466 |
1180154 | 1180154 | 2021-04-02 | Jefferson | Alabama | 1073 | 74855 | 1466 |
1173451 | 1173451 | 2021-03-30 | King | Washington | 53033 | 90335 | 1466 |
1089402 | 1089402 | 2021-03-05 | Fresno | California | 6019 | 96023 | 1466 |
1069139 | 1069139 | 2021-02-26 | Cameron | Texas | 48061 | 37166 | 1466 |
1065894 | 1065894 | 2021-02-25 | Cameron | Texas | 48061 | 37166 | 1466 |
1051489 | 1051489 | 2021-02-21 | Bristol | Massachusetts | 25005 | 54825 | 1466 |
909056 | 909056 | 2021-01-08 | St. Louis | Missouri | 29189 | 73847 | 1466 |
841997 | 841997 | 2020-12-18 | El Paso | Texas | 48141 | 94530 | 1466 |
811902 | 811902 | 2020-12-09 | Union | New Jersey | 34039 | 31410 | 1466 |
757604 | 757604 | 2020-11-22 | Dallas | Texas | 48113 | 130186 | 1466 |
745496 | 745496 | 2020-11-19 | Fairfield | Connecticut | 9001 | 33067 | 1466 |
640031 | 640031 | 2020-10-17 | Westchester | New York | 36119 | 39397 | 1466 |
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);