ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71 rows where deaths = 1207 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- Florida 16
- Georgia 12
- New Jersey 8
- District of Columbia 7
- Ohio 5
- Pennsylvania 5
- Massachusetts 4
- California 3
- Michigan 3
- Colorado 1
- Connecticut 1
- Indiana 1
- Louisiana 1
- New Mexico 1
- Oregon 1
- South Carolina 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501836 | 2501836 | 2022-05-13 | Multnomah | Oregon | 41051 | 123906 | 1207 |
2488342 | 2488342 | 2022-05-09 | Burlington | New Jersey | 34005 | 105717 | 1207 |
2485085 | 2485085 | 2022-05-08 | Burlington | New Jersey | 34005 | 105592 | 1207 |
2481827 | 2481827 | 2022-05-07 | Burlington | New Jersey | 34005 | 105469 | 1207 |
2353449 | 2353449 | 2022-03-29 | St. Lucie | Florida | 12111 | 73954 | 1207 |
2350197 | 2350197 | 2022-03-28 | St. Lucie | Florida | 12111 | 73954 | 1207 |
2346944 | 2346944 | 2022-03-27 | St. Lucie | Florida | 12111 | 73954 | 1207 |
2343691 | 2343691 | 2022-03-26 | St. Lucie | Florida | 12111 | 73954 | 1207 |
2340438 | 2340438 | 2022-03-25 | St. Lucie | Florida | 12111 | 73954 | 1207 |
2337185 | 2337185 | 2022-03-24 | St. Lucie | Florida | 12111 | 73759 | 1207 |
2278643 | 2278643 | 2022-03-06 | Unknown | Florida | 1760 | 1207 | |
2275390 | 2275390 | 2022-03-05 | Unknown | Florida | 1760 | 1207 | |
2272137 | 2272137 | 2022-03-04 | Unknown | Florida | 6 | 1207 | |
2169801 | 2169801 | 2022-01-31 | Lucas | Ohio | 39095 | 95798 | 1207 |
2166546 | 2166546 | 2022-01-30 | Lucas | Ohio | 39095 | 95675 | 1207 |
2163291 | 2163291 | 2022-01-29 | Lucas | Ohio | 39095 | 95466 | 1207 |
2160036 | 2160036 | 2022-01-28 | Lucas | Ohio | 39095 | 95192 | 1207 |
2137479 | 2137479 | 2022-01-21 | Westmoreland | Pennsylvania | 42129 | 71312 | 1207 |
2129780 | 2129780 | 2022-01-19 | East Baton Rouge | Louisiana | 22033 | 94614 | 1207 |
2063852 | 2063852 | 2021-12-30 | Ventura | California | 6111 | 111853 | 1207 |
2060602 | 2060602 | 2021-12-29 | Ventura | California | 6111 | 110586 | 1207 |
2050934 | 2050934 | 2021-12-26 | District of Columbia | District of Columbia | 11001 | 79565 | 1207 |
2047684 | 2047684 | 2021-12-25 | District of Columbia | District of Columbia | 11001 | 79565 | 1207 |
2044434 | 2044434 | 2021-12-24 | District of Columbia | District of Columbia | 11001 | 79565 | 1207 |
2041185 | 2041185 | 2021-12-23 | District of Columbia | District of Columbia | 11001 | 79565 | 1207 |
2037935 | 2037935 | 2021-12-22 | District of Columbia | District of Columbia | 11001 | 77661 | 1207 |
2034685 | 2034685 | 2021-12-21 | District of Columbia | District of Columbia | 11001 | 76137 | 1207 |
2031435 | 2031435 | 2021-12-20 | District of Columbia | District of Columbia | 11001 | 74982 | 1207 |
1997169 | 1997169 | 2021-12-09 | Bernalillo | New Mexico | 35001 | 91622 | 1207 |
1927358 | 1927358 | 2021-11-18 | El Paso | Colorado | 8041 | 110712 | 1207 |
1914450 | 1914450 | 2021-11-14 | Lake | Florida | 12069 | 54930 | 1207 |
1911200 | 1911200 | 2021-11-13 | Lake | Florida | 12069 | 54930 | 1207 |
1907951 | 1907951 | 2021-11-12 | Lake | Florida | 12069 | 54930 | 1207 |
1904702 | 1904702 | 2021-11-11 | Lake | Florida | 12069 | 54697 | 1207 |
1901452 | 1901452 | 2021-11-10 | Lake | Florida | 12069 | 54697 | 1207 |
1898202 | 1898202 | 2021-11-09 | Lake | Florida | 12069 | 54697 | 1207 |
1894952 | 1894952 | 2021-11-08 | Lake | Florida | 12069 | 54697 | 1207 |
1833609 | 1833609 | 2021-10-20 | Lake | Indiana | 18089 | 66276 | 1207 |
1783677 | 1783677 | 2021-10-04 | Nueces | Texas | 48355 | 60407 | 1207 |
1747575 | 1747575 | 2021-09-23 | Greenville | South Carolina | 45045 | 97935 | 1207 |
1714944 | 1714944 | 2021-09-13 | Lancaster | Pennsylvania | 42071 | 61919 | 1207 |
1711698 | 1711698 | 2021-09-12 | Lancaster | Pennsylvania | 42071 | 61728 | 1207 |
1708451 | 1708451 | 2021-09-11 | Lancaster | Pennsylvania | 42071 | 61551 | 1207 |
1696828 | 1696828 | 2021-09-08 | Cobb | Georgia | 13067 | 99234 | 1207 |
1472761 | 1472761 | 2021-07-01 | Gwinnett | Georgia | 13135 | 103450 | 1207 |
1469515 | 1469515 | 2021-06-30 | Gwinnett | Georgia | 13135 | 103415 | 1207 |
1466270 | 1466270 | 2021-06-29 | Gwinnett | Georgia | 13135 | 103349 | 1207 |
1463025 | 1463025 | 2021-06-28 | Gwinnett | Georgia | 13135 | 103349 | 1207 |
1459780 | 1459780 | 2021-06-27 | Gwinnett | Georgia | 13135 | 103330 | 1207 |
1456535 | 1456535 | 2021-06-26 | Gwinnett | Georgia | 13135 | 103295 | 1207 |
1453290 | 1453290 | 2021-06-25 | Gwinnett | Georgia | 13135 | 103259 | 1207 |
1443554 | 1443554 | 2021-06-22 | Gwinnett | Georgia | 13135 | 103193 | 1207 |
1440309 | 1440309 | 2021-06-21 | Gwinnett | Georgia | 13135 | 103184 | 1207 |
1437062 | 1437062 | 2021-06-20 | Gwinnett | Georgia | 13135 | 103168 | 1207 |
1433815 | 1433815 | 2021-06-19 | Gwinnett | Georgia | 13135 | 103146 | 1207 |
1256619 | 1256619 | 2021-04-25 | Morris | New Jersey | 34027 | 49346 | 1207 |
1253372 | 1253372 | 2021-04-24 | Morris | New Jersey | 34027 | 49274 | 1207 |
1250125 | 1250125 | 2021-04-23 | Morris | New Jersey | 34027 | 49152 | 1207 |
1126710 | 1126710 | 2021-03-16 | Camden | New Jersey | 34007 | 46111 | 1207 |
989826 | 989826 | 2021-02-02 | Hampden | Massachusetts | 25013 | 37640 | 1207 |
990669 | 990669 | 2021-02-02 | Cuyahoga | Ohio | 39035 | 89554 | 1207 |
986579 | 986579 | 2021-02-01 | Hampden | Massachusetts | 25013 | 37397 | 1207 |
954694 | 954694 | 2021-01-22 | Monmouth | New Jersey | 34025 | 45267 | 1207 |
906519 | 906519 | 2021-01-07 | Montgomery | Pennsylvania | 42091 | 39388 | 1207 |
807070 | 807070 | 2020-12-08 | San Bernardino | California | 6071 | 108946 | 1207 |
761730 | 761730 | 2020-11-24 | New Haven | Connecticut | 9009 | 26643 | 1207 |
600517 | 600517 | 2020-10-05 | Oakland | Michigan | 26125 | 21241 | 1207 |
597274 | 597274 | 2020-10-04 | Oakland | Michigan | 26125 | 21107 | 1207 |
594033 | 594033 | 2020-10-03 | Oakland | Michigan | 26125 | 21107 | 1207 |
451597 | 451597 | 2020-08-20 | Essex | Massachusetts | 25009 | 18343 | 1207 |
131405 | 131405 | 2020-05-10 | Middlesex | Massachusetts | 25017 | 17589 | 1207 |
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);