ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where deaths = 1102 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Iowa 14
- Nebraska 6
- Illinois 5
- Pennsylvania 5
- California 4
- Louisiana 4
- Colorado 3
- Texas 3
- Indiana 2
- North Carolina 2
- Tennessee 2
- Arizona 1
- Florida 1
- Georgia 1
- Maryland 1
- Michigan 1
- Missouri 1
- Nevada 1
- New Jersey 1
- New York 1
- Oregon 1
- South Carolina 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490675 | 2490675 | 2022-05-10 | Polk | Iowa | 19153 | 125671 | 1102 |
2487418 | 2487418 | 2022-05-09 | Polk | Iowa | 19153 | 125671 | 1102 |
2484160 | 2484160 | 2022-05-08 | Polk | Iowa | 19153 | 125671 | 1102 |
2480902 | 2480902 | 2022-05-07 | Polk | Iowa | 19153 | 125671 | 1102 |
2477644 | 2477644 | 2022-05-06 | Polk | Iowa | 19153 | 125671 | 1102 |
2474386 | 2474386 | 2022-05-05 | Polk | Iowa | 19153 | 125671 | 1102 |
2471129 | 2471129 | 2022-05-04 | Polk | Iowa | 19153 | 125671 | 1102 |
2467873 | 2467873 | 2022-05-03 | Polk | Iowa | 19153 | 125306 | 1102 |
2464618 | 2464618 | 2022-05-02 | Polk | Iowa | 19153 | 125306 | 1102 |
2461362 | 2461362 | 2022-05-01 | Polk | Iowa | 19153 | 125306 | 1102 |
2458106 | 2458106 | 2022-04-30 | Polk | Iowa | 19153 | 125306 | 1102 |
2454850 | 2454850 | 2022-04-29 | Polk | Iowa | 19153 | 125306 | 1102 |
2451594 | 2451594 | 2022-04-28 | Polk | Iowa | 19153 | 125306 | 1102 |
2448338 | 2448338 | 2022-04-27 | Polk | Iowa | 19153 | 125306 | 1102 |
2354767 | 2354767 | 2022-03-29 | Douglas | Nebraska | 31055 | 149960 | 1102 |
2351514 | 2351514 | 2022-03-28 | Douglas | Nebraska | 31055 | 149995 | 1102 |
2348262 | 2348262 | 2022-03-27 | Douglas | Nebraska | 31055 | 149861 | 1102 |
2345009 | 2345009 | 2022-03-26 | Douglas | Nebraska | 31055 | 149861 | 1102 |
2341756 | 2341756 | 2022-03-25 | Douglas | Nebraska | 31055 | 149861 | 1102 |
2338503 | 2338503 | 2022-03-24 | Douglas | Nebraska | 31055 | 149940 | 1102 |
2315187 | 2315187 | 2022-03-17 | Orleans | Louisiana | 22071 | 87079 | 1102 |
2311934 | 2311934 | 2022-03-16 | Orleans | Louisiana | 22071 | 87051 | 1102 |
2308681 | 2308681 | 2022-03-15 | Orleans | Louisiana | 22071 | 87004 | 1102 |
2309782 | 2309782 | 2022-03-15 | Multnomah | Oregon | 41051 | 111984 | 1102 |
2306836 | 2306836 | 2022-03-14 | Hamilton | Tennessee | 47065 | 99176 | 1102 |
2270445 | 2270445 | 2022-03-03 | Guilford | North Carolina | 37081 | 114839 | 1102 |
2240783 | 2240783 | 2022-02-22 | Jackson | Missouri | 29095 | 94939 | 1102 |
2231766 | 2231766 | 2022-02-19 | Chester | Pennsylvania | 42029 | 90104 | 1102 |
2228515 | 2228515 | 2022-02-18 | Chester | Pennsylvania | 42029 | 89907 | 1102 |
2225264 | 2225264 | 2022-02-17 | Chester | Pennsylvania | 42029 | 89819 | 1102 |
2222013 | 2222013 | 2022-02-16 | Chester | Pennsylvania | 42029 | 89517 | 1102 |
2192237 | 2192237 | 2022-02-07 | Washoe | Nevada | 32031 | 99614 | 1102 |
2187850 | 2187850 | 2022-02-06 | Kane | Illinois | 17089 | 121407 | 1102 |
2184597 | 2184597 | 2022-02-05 | Kane | Illinois | 17089 | 121407 | 1102 |
2181345 | 2181345 | 2022-02-04 | Kane | Illinois | 17089 | 121407 | 1102 |
2175990 | 2175990 | 2022-02-02 | Burlington | New Jersey | 34005 | 97807 | 1102 |
2167882 | 2167882 | 2022-01-31 | Contra Costa | California | 6013 | 183484 | 1102 |
2106125 | 2106125 | 2022-01-12 | Arapahoe | Colorado | 8005 | 123482 | 1102 |
2080127 | 2080127 | 2022-01-04 | Denver | Colorado | 8031 | 122831 | 1102 |
2079391 | 2079391 | 2022-01-03 | Lubbock | Texas | 48303 | 73877 | 1102 |
2063885 | 2063885 | 2021-12-30 | Jefferson | Colorado | 8059 | 81365 | 1102 |
1995594 | 1995594 | 2021-12-09 | Tulare | California | 6107 | 87470 | 1102 |
1985842 | 1985842 | 2021-12-06 | Tulare | California | 6107 | 86979 | 1102 |
1929888 | 1929888 | 2021-11-18 | Montgomery | Texas | 48339 | 88759 | 1102 |
1884953 | 1884953 | 2021-11-05 | Pinal | Arizona | 4021 | 74997 | 1102 |
1743033 | 1743033 | 2021-09-22 | Jefferson | Louisiana | 22051 | 67956 | 1102 |
1721105 | 1721105 | 2021-09-15 | Mecklenburg | North Carolina | 37119 | 143760 | 1102 |
1718694 | 1718694 | 2021-09-14 | Nueces | Texas | 48355 | 58292 | 1102 |
1679348 | 1679348 | 2021-09-02 | Greenville | South Carolina | 45045 | 88141 | 1102 |
1674412 | 1674412 | 2021-09-01 | Lake | Indiana | 18089 | 60258 | 1102 |
1632083 | 1632083 | 2021-08-19 | Lake | Illinois | 17097 | 71681 | 1102 |
1628836 | 1628836 | 2021-08-18 | Lake | Illinois | 17097 | 71576 | 1102 |
1605687 | 1605687 | 2021-08-11 | Stanislaus | California | 6099 | 68119 | 1102 |
1433781 | 1433781 | 2021-06-19 | Cobb | Georgia | 13067 | 80425 | 1102 |
1377900 | 1377900 | 2021-06-01 | Fairfax | Virginia | 51059 | 77004 | 1102 |
960587 | 960587 | 2021-01-24 | Baltimore | Maryland | 24005 | 45703 | 1102 |
929532 | 929532 | 2021-01-14 | Shelby | Tennessee | 47157 | 76534 | 1102 |
901316 | 901316 | 2021-01-06 | Hillsborough | Florida | 12057 | 82257 | 1102 |
867574 | 867574 | 2020-12-26 | Montgomery | Pennsylvania | 42091 | 34146 | 1102 |
857391 | 857391 | 2020-12-23 | Erie | New York | 36029 | 37755 | 1102 |
849793 | 849793 | 2020-12-21 | Marion | Indiana | 18097 | 64739 | 1102 |
320003 | 320003 | 2020-07-10 | Oakland | Michigan | 26125 | 12568 | 1102 |
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);