ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
91 rows where deaths = 1047 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Florida 22
- California 9
- New York 9
- Texas 7
- Pennsylvania 6
- Colorado 4
- Indiana 4
- Maryland 4
- New Jersey 4
- South Carolina 4
- Delaware 3
- Ohio 3
- Illinois 2
- Massachusetts 2
- Arizona 1
- Arkansas 1
- District of Columbia 1
- Kentucky 1
- Missouri 1
- Nevada 1
- Washington 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2420043 | 2420043 | 2022-04-18 | Onondaga | New York | 36067 | 116493 | 1047 |
2416788 | 2416788 | 2022-04-17 | Onondaga | New York | 36067 | 116313 | 1047 |
2413532 | 2413532 | 2022-04-16 | Onondaga | New York | 36067 | 116097 | 1047 |
2410276 | 2410276 | 2022-04-15 | Onondaga | New York | 36067 | 115777 | 1047 |
2407020 | 2407020 | 2022-04-14 | Onondaga | New York | 36067 | 115487 | 1047 |
2403764 | 2403764 | 2022-04-13 | Onondaga | New York | 36067 | 115150 | 1047 |
2400509 | 2400509 | 2022-04-12 | Onondaga | New York | 36067 | 114864 | 1047 |
2397254 | 2397254 | 2022-04-11 | Onondaga | New York | 36067 | 114684 | 1047 |
2393999 | 2393999 | 2022-04-10 | Onondaga | New York | 36067 | 114488 | 1047 |
2307872 | 2307872 | 2022-03-15 | Hernando | Florida | 12053 | 41798 | 1047 |
2310749 | 2310749 | 2022-03-15 | Waukesha | Wisconsin | 55133 | 111493 | 1047 |
2304621 | 2304621 | 2022-03-14 | Hernando | Florida | 12053 | 41798 | 1047 |
2305478 | 2305478 | 2022-03-14 | Anne Arundel | Maryland | 24003 | 88678 | 1047 |
2301369 | 2301369 | 2022-03-13 | Hernando | Florida | 12053 | 41798 | 1047 |
2302226 | 2302226 | 2022-03-13 | Anne Arundel | Maryland | 24003 | 88664 | 1047 |
2298117 | 2298117 | 2022-03-12 | Hernando | Florida | 12053 | 41798 | 1047 |
2298974 | 2298974 | 2022-03-12 | Anne Arundel | Maryland | 24003 | 88647 | 1047 |
2294865 | 2294865 | 2022-03-11 | Hernando | Florida | 12053 | 41798 | 1047 |
2291613 | 2291613 | 2022-03-10 | Hernando | Florida | 12053 | 41720 | 1047 |
2288361 | 2288361 | 2022-03-09 | Hernando | Florida | 12053 | 41720 | 1047 |
2184121 | 2184121 | 2022-02-05 | Pulaski | Arkansas | 5119 | 98785 | 1047 |
2146693 | 2146693 | 2022-01-24 | Washoe | Nevada | 32031 | 91631 | 1047 |
2132541 | 2132541 | 2022-01-20 | Kane | Illinois | 17089 | 109013 | 1047 |
2132601 | 2132601 | 2022-01-20 | Allen | Indiana | 18003 | 93646 | 1047 |
2130192 | 2130192 | 2022-01-19 | Kansas City | Missouri | 98437 | 1047 | |
2108965 | 2108965 | 2022-01-12 | Pierce | Washington | 53053 | 135523 | 1047 |
2103008 | 2103008 | 2022-01-11 | St. Lucie | Florida | 12111 | 56900 | 1047 |
2099757 | 2099757 | 2022-01-10 | St. Lucie | Florida | 12111 | 56900 | 1047 |
2096506 | 2096506 | 2022-01-09 | St. Lucie | Florida | 12111 | 56900 | 1047 |
2093254 | 2093254 | 2022-01-08 | St. Lucie | Florida | 12111 | 56900 | 1047 |
2090002 | 2090002 | 2022-01-07 | St. Lucie | Florida | 12111 | 56900 | 1047 |
2086751 | 2086751 | 2022-01-06 | St. Lucie | Florida | 12111 | 52135 | 1047 |
2083499 | 2083499 | 2022-01-05 | St. Lucie | Florida | 12111 | 52135 | 1047 |
2080247 | 2080247 | 2022-01-04 | St. Lucie | Florida | 12111 | 52135 | 1047 |
2076995 | 2076995 | 2022-01-03 | St. Lucie | Florida | 12111 | 52135 | 1047 |
2073744 | 2073744 | 2022-01-02 | St. Lucie | Florida | 12111 | 52135 | 1047 |
2075667 | 2075667 | 2022-01-02 | Lehigh | Pennsylvania | 42077 | 65466 | 1047 |
2070493 | 2070493 | 2022-01-01 | St. Lucie | Florida | 12111 | 52135 | 1047 |
2072416 | 2072416 | 2022-01-01 | Lehigh | Pennsylvania | 42077 | 64637 | 1047 |
2067242 | 2067242 | 2021-12-31 | St. Lucie | Florida | 12111 | 52135 | 1047 |
2069165 | 2069165 | 2021-12-31 | Lehigh | Pennsylvania | 42077 | 63964 | 1047 |
2063991 | 2063991 | 2021-12-30 | St. Lucie | Florida | 12111 | 49332 | 1047 |
2065914 | 2065914 | 2021-12-30 | Lehigh | Pennsylvania | 42077 | 62899 | 1047 |
2060741 | 2060741 | 2021-12-29 | St. Lucie | Florida | 12111 | 49332 | 1047 |
2030567 | 2030567 | 2021-12-19 | Fort Bend | Texas | 48157 | 105845 | 1047 |
2027316 | 2027316 | 2021-12-18 | Fort Bend | Texas | 48157 | 105299 | 1047 |
2024065 | 2024065 | 2021-12-17 | Fort Bend | Texas | 48157 | 104791 | 1047 |
2020814 | 2020814 | 2021-12-16 | Fort Bend | Texas | 48157 | 104544 | 1047 |
2005367 | 2005367 | 2021-12-12 | Denver | Colorado | 8031 | 104584 | 1047 |
2002116 | 2002116 | 2021-12-11 | Denver | Colorado | 8031 | 104584 | 1047 |
1998866 | 1998866 | 2021-12-10 | Denver | Colorado | 8031 | 104584 | 1047 |
1972707 | 1972707 | 2021-12-02 | Mohave | Arizona | 4015 | 36291 | 1047 |
1965629 | 1965629 | 2021-11-29 | Lubbock | Texas | 48303 | 67876 | 1047 |
1940414 | 1940414 | 2021-11-22 | New Castle | Delaware | 10003 | 85662 | 1047 |
1937164 | 1937164 | 2021-11-21 | New Castle | Delaware | 10003 | 85521 | 1047 |
1933914 | 1933914 | 2021-11-20 | New Castle | Delaware | 10003 | 85352 | 1047 |
1927333 | 1927333 | 2021-11-18 | Tulare | California | 6107 | 85214 | 1047 |
1845401 | 1845401 | 2021-10-23 | Montgomery | Texas | 48339 | 87429 | 1047 |
1803882 | 1803882 | 2021-10-11 | El Paso | Colorado | 8041 | 95581 | 1047 |
1747273 | 1747273 | 2021-09-23 | Summit | Ohio | 39153 | 56442 | 1047 |
1744024 | 1744024 | 2021-09-22 | Summit | Ohio | 39153 | 56209 | 1047 |
1740775 | 1740775 | 2021-09-21 | Summit | Ohio | 39153 | 56008 | 1047 |
1656444 | 1656444 | 2021-08-26 | Berks | Pennsylvania | 42011 | 50443 | 1047 |
1602444 | 1602444 | 2021-08-10 | Ventura | California | 6111 | 89251 | 1047 |
1599195 | 1599195 | 2021-08-09 | Ventura | California | 6111 | 89119 | 1047 |
1595946 | 1595946 | 2021-08-08 | Ventura | California | 6111 | 88969 | 1047 |
1598144 | 1598144 | 2021-08-08 | Greenville | South Carolina | 45045 | 78433 | 1047 |
1592697 | 1592697 | 2021-08-07 | Ventura | California | 6111 | 88574 | 1047 |
1594895 | 1594895 | 2021-08-07 | Greenville | South Carolina | 45045 | 78433 | 1047 |
1589448 | 1589448 | 2021-08-06 | Ventura | California | 6111 | 88574 | 1047 |
1591646 | 1591646 | 2021-08-06 | Greenville | South Carolina | 45045 | 78433 | 1047 |
1586199 | 1586199 | 2021-08-05 | Ventura | California | 6111 | 88143 | 1047 |
1588397 | 1588397 | 2021-08-05 | Greenville | South Carolina | 45045 | 78152 | 1047 |
1430861 | 1430861 | 2021-06-18 | Lake | Indiana | 18089 | 55761 | 1047 |
1427616 | 1427616 | 2021-06-17 | Lake | Indiana | 18089 | 55722 | 1047 |
1424371 | 1424371 | 2021-06-16 | Lake | Indiana | 18089 | 55688 | 1047 |
1284273 | 1284273 | 2021-05-04 | Stanislaus | California | 6099 | 61606 | 1047 |
1281440 | 1281440 | 2021-05-03 | Lake | Illinois | 17097 | 66246 | 1047 |
1151947 | 1151947 | 2021-03-24 | Jefferson | Kentucky | 21111 | 77166 | 1047 |
1134979 | 1134979 | 2021-03-19 | District of Columbia | District of Columbia | 11001 | 43034 | 1047 |
1034368 | 1034368 | 2021-02-16 | Duval | Florida | 12031 | 86562 | 1047 |
970920 | 970920 | 2021-01-27 | Morris | New Jersey | 34027 | 31000 | 1047 |
931378 | 931378 | 2021-01-15 | Baltimore | Maryland | 24005 | 43434 | 1047 |
893493 | 893493 | 2021-01-03 | Allegheny | Pennsylvania | 42003 | 55790 | 1047 |
876232 | 876232 | 2020-12-29 | Bristol | Massachusetts | 25005 | 33272 | 1047 |
794091 | 794091 | 2020-12-04 | San Diego | California | 6073 | 88244 | 1047 |
624559 | 624559 | 2020-10-12 | Cameron | Texas | 48061 | 23492 | 1047 |
568601 | 568601 | 2020-09-25 | Ocean | New Jersey | 34029 | 12728 | 1047 |
565360 | 565360 | 2020-09-24 | Ocean | New Jersey | 34029 | 12613 | 1047 |
551844 | 551844 | 2020-09-20 | Norfolk | Massachusetts | 25021 | 10044 | 1047 |
186286 | 186286 | 2020-05-28 | Union | New Jersey | 34039 | 15475 | 1047 |
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);