ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
61 rows where deaths = 1068 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- California 18
- Ohio 6
- Florida 4
- Texas 4
- Massachusetts 3
- Nebraska 3
- New Jersey 3
- North Carolina 3
- Pennsylvania 3
- Connecticut 2
- Illinois 2
- Indiana 2
- Maryland 2
- Arizona 1
- Colorado 1
- Georgia 1
- Nevada 1
- New York 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2478654 | 2478654 | 2022-05-06 | Onondaga | New York | 36067 | 120720 | 1068 |
2270813 | 2270813 | 2022-03-03 | Northampton | Pennsylvania | 42095 | 78875 | 1068 |
2267561 | 2267561 | 2022-03-02 | Northampton | Pennsylvania | 42095 | 78841 | 1068 |
2264308 | 2264308 | 2022-03-01 | Northampton | Pennsylvania | 42095 | 78813 | 1068 |
2257191 | 2257191 | 2022-02-27 | Douglas | Nebraska | 31055 | 141526 | 1068 |
2253940 | 2253940 | 2022-02-26 | Douglas | Nebraska | 31055 | 141526 | 1068 |
2250689 | 2250689 | 2022-02-25 | Douglas | Nebraska | 31055 | 141526 | 1068 |
2234682 | 2234682 | 2022-02-20 | Guilford | North Carolina | 37081 | 112988 | 1068 |
2231431 | 2231431 | 2022-02-19 | Guilford | North Carolina | 37081 | 112988 | 1068 |
2228180 | 2228180 | 2022-02-18 | Guilford | North Carolina | 37081 | 112988 | 1068 |
2172722 | 2172722 | 2022-02-01 | Washoe | Nevada | 32031 | 97267 | 1068 |
2148811 | 2148811 | 2022-01-25 | Kane | Illinois | 17089 | 116516 | 1068 |
2140198 | 2140198 | 2022-01-22 | Burlington | New Jersey | 34005 | 94240 | 1068 |
2055971 | 2055971 | 2021-12-27 | Lucas | Ohio | 39095 | 69273 | 1068 |
2052722 | 2052722 | 2021-12-26 | Lucas | Ohio | 39095 | 68958 | 1068 |
2049472 | 2049472 | 2021-12-25 | Lucas | Ohio | 39095 | 68266 | 1068 |
2046222 | 2046222 | 2021-12-24 | Lucas | Ohio | 39095 | 68266 | 1068 |
2037806 | 2037806 | 2021-12-22 | Contra Costa | California | 6013 | 106751 | 1068 |
2034556 | 2034556 | 2021-12-21 | Contra Costa | California | 6013 | 106547 | 1068 |
2031306 | 2031306 | 2021-12-20 | Contra Costa | California | 6013 | 106402 | 1068 |
1992207 | 1992207 | 2021-12-08 | Mohave | Arizona | 4015 | 36830 | 1068 |
1988289 | 1988289 | 2021-12-06 | Denton | Texas | 48121 | 111758 | 1068 |
1985039 | 1985039 | 2021-12-05 | Denton | Texas | 48121 | 111621 | 1068 |
1826626 | 1826626 | 2021-10-18 | El Paso | Colorado | 8041 | 97962 | 1068 |
1654418 | 1654418 | 2021-08-26 | Ventura | California | 6111 | 93440 | 1068 |
1651171 | 1651171 | 2021-08-25 | Ventura | California | 6111 | 93138 | 1068 |
1515256 | 1515256 | 2021-07-14 | Lake | Indiana | 18089 | 56698 | 1068 |
1512010 | 1512010 | 2021-07-13 | Lake | Indiana | 18089 | 56679 | 1068 |
1423858 | 1423858 | 2021-06-16 | Stanislaus | California | 6099 | 63302 | 1068 |
1420610 | 1420610 | 2021-06-15 | Stanislaus | California | 6099 | 63302 | 1068 |
1417365 | 1417365 | 2021-06-14 | Stanislaus | California | 6099 | 63266 | 1068 |
1414119 | 1414119 | 2021-06-13 | Stanislaus | California | 6099 | 63190 | 1068 |
1410874 | 1410874 | 2021-06-12 | Stanislaus | California | 6099 | 63190 | 1068 |
1407629 | 1407629 | 2021-06-11 | Stanislaus | California | 6099 | 63190 | 1068 |
1404383 | 1404383 | 2021-06-10 | Stanislaus | California | 6099 | 63142 | 1068 |
1401138 | 1401138 | 2021-06-09 | Stanislaus | California | 6099 | 63108 | 1068 |
1397893 | 1397893 | 2021-06-08 | Stanislaus | California | 6099 | 63076 | 1068 |
1394646 | 1394646 | 2021-06-07 | Stanislaus | California | 6099 | 63041 | 1068 |
1391401 | 1391401 | 2021-06-06 | Stanislaus | California | 6099 | 62981 | 1068 |
1388156 | 1388156 | 2021-06-05 | Stanislaus | California | 6099 | 62981 | 1068 |
1384911 | 1384911 | 2021-06-04 | Stanislaus | California | 6099 | 62953 | 1068 |
1352867 | 1352867 | 2021-05-25 | Lake | Illinois | 17097 | 67871 | 1068 |
1311213 | 1311213 | 2021-05-12 | Baltimore city | Maryland | 24510 | 52122 | 1068 |
1261024 | 1261024 | 2021-04-26 | Fairfax | Virginia | 51059 | 75417 | 1068 |
1044136 | 1044136 | 2021-02-19 | Orange | Florida | 12095 | 111177 | 1068 |
1037726 | 1037726 | 2021-02-17 | Fulton | Georgia | 13121 | 82709 | 1068 |
1016352 | 1016352 | 2021-02-10 | Camden | New Jersey | 34007 | 41843 | 1068 |
951723 | 951723 | 2021-01-21 | Cuyahoga | Ohio | 39035 | 84523 | 1068 |
948478 | 948478 | 2021-01-20 | Cuyahoga | Ohio | 39035 | 83770 | 1068 |
944358 | 944358 | 2021-01-19 | Baltimore | Maryland | 24005 | 44422 | 1068 |
898955 | 898955 | 2021-01-05 | Hampden | Massachusetts | 25013 | 27844 | 1068 |
878597 | 878597 | 2020-12-30 | Hillsborough | Florida | 12057 | 76221 | 1068 |
777088 | 777088 | 2020-11-28 | El Paso | Texas | 48141 | 85318 | 1068 |
647276 | 647276 | 2020-10-19 | Cameron | Texas | 48061 | 23818 | 1068 |
590725 | 590725 | 2020-10-02 | Norfolk | Massachusetts | 25021 | 10430 | 1068 |
587484 | 587484 | 2020-10-01 | Norfolk | Massachusetts | 25021 | 10384 | 1068 |
453925 | 453925 | 2020-08-21 | Broward | Florida | 12011 | 68542 | 1068 |
312724 | 312724 | 2020-07-08 | Miami-Dade | Florida | 12086 | 53973 | 1068 |
271656 | 271656 | 2020-06-25 | New Haven | Connecticut | 9009 | 12245 | 1068 |
155893 | 155893 | 2020-05-18 | Hudson | New Jersey | 34017 | 17574 | 1068 |
139501 | 139501 | 2020-05-13 | Fairfield | Connecticut | 9001 | 13636 | 1068 |
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);