ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
165 rows where deaths = 607 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Pennsylvania 21
- Florida 14
- New York 12
- Texas 12
- Georgia 10
- Alabama 9
- Virginia 9
- Arizona 8
- Missouri 8
- Ohio 8
- California 7
- Illinois 7
- North Carolina 6
- Washington 6
- Louisiana 5
- New Jersey 5
- Indiana 3
- District of Columbia 2
- Maryland 2
- Massachusetts 2
- Connecticut 1
- Hawaii 1
- Iowa 1
- Michigan 1
- Minnesota 1
- Nevada 1
- New Mexico 1
- South Carolina 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2421512 | 2421512 | 2022-04-19 | Apache | Arizona | 4001 | 22306 | 607 |
2418256 | 2418256 | 2022-04-18 | Apache | Arizona | 4001 | 22306 | 607 |
2415000 | 2415000 | 2022-04-17 | Apache | Arizona | 4001 | 22306 | 607 |
2411744 | 2411744 | 2022-04-16 | Apache | Arizona | 4001 | 22306 | 607 |
2408488 | 2408488 | 2022-04-15 | Apache | Arizona | 4001 | 22306 | 607 |
2405232 | 2405232 | 2022-04-14 | Apache | Arizona | 4001 | 22306 | 607 |
2401977 | 2401977 | 2022-04-13 | Apache | Arizona | 4001 | 22306 | 607 |
2374862 | 2374862 | 2022-04-04 | Blair | Pennsylvania | 42013 | 29617 | 607 |
2371610 | 2371610 | 2022-04-03 | Blair | Pennsylvania | 42013 | 29613 | 607 |
2368357 | 2368357 | 2022-04-02 | Blair | Pennsylvania | 42013 | 29613 | 607 |
2365104 | 2365104 | 2022-04-01 | Blair | Pennsylvania | 42013 | 29607 | 607 |
2361851 | 2361851 | 2022-03-31 | Blair | Pennsylvania | 42013 | 29603 | 607 |
2353445 | 2353445 | 2022-03-29 | Santa Rosa | Florida | 12113 | 48302 | 607 |
2353486 | 2353486 | 2022-03-29 | Cherokee | Georgia | 13057 | 63093 | 607 |
2350193 | 2350193 | 2022-03-28 | Santa Rosa | Florida | 12113 | 48302 | 607 |
2346940 | 2346940 | 2022-03-27 | Santa Rosa | Florida | 12113 | 48302 | 607 |
2343687 | 2343687 | 2022-03-26 | Santa Rosa | Florida | 12113 | 48302 | 607 |
2340434 | 2340434 | 2022-03-25 | Santa Rosa | Florida | 12113 | 48302 | 607 |
2337181 | 2337181 | 2022-03-24 | Santa Rosa | Florida | 12113 | 48241 | 607 |
2331041 | 2331041 | 2022-03-22 | Johnson | Indiana | 18081 | 42295 | 607 |
2327789 | 2327789 | 2022-03-21 | Johnson | Indiana | 18081 | 42288 | 607 |
2278283 | 2278283 | 2022-03-06 | Etowah | Alabama | 1055 | 28693 | 607 |
2275030 | 2275030 | 2022-03-05 | Etowah | Alabama | 1055 | 28693 | 607 |
2271777 | 2271777 | 2022-03-04 | Etowah | Alabama | 1055 | 28693 | 607 |
2266032 | 2266032 | 2022-03-02 | Vanderburgh | Indiana | 18163 | 57025 | 607 |
2200533 | 2200533 | 2022-02-10 | New London | Connecticut | 9011 | 52453 | 607 |
2194176 | 2194176 | 2022-02-08 | Henry | Georgia | 13151 | 56414 | 607 |
2176914 | 2176914 | 2022-02-02 | Gregg | Texas | 48183 | 22301 | 607 |
2152646 | 2152646 | 2022-01-26 | Barnstable | Massachusetts | 25001 | 32270 | 607 |
2150485 | 2150485 | 2022-01-25 | Schuylkill | Pennsylvania | 42107 | 31996 | 607 |
2131896 | 2131896 | 2022-01-20 | Baldwin | Alabama | 1003 | 48338 | 607 |
2105678 | 2105678 | 2022-01-11 | Virginia Beach city | Virginia | 51810 | 70170 | 607 |
2095173 | 2095173 | 2022-01-08 | Lackawanna | Pennsylvania | 42069 | 32861 | 607 |
2091921 | 2091921 | 2022-01-07 | Lackawanna | Pennsylvania | 42069 | 32210 | 607 |
2076316 | 2076316 | 2022-01-02 | Chesterfield | Virginia | 51041 | 48029 | 607 |
2073065 | 2073065 | 2022-01-01 | Chesterfield | Virginia | 51041 | 48029 | 607 |
2069814 | 2069814 | 2021-12-31 | Chesterfield | Virginia | 51041 | 48029 | 607 |
2066563 | 2066563 | 2021-12-30 | Chesterfield | Virginia | 51041 | 47306 | 607 |
2059385 | 2059385 | 2021-12-28 | Butler | Pennsylvania | 42019 | 32136 | 607 |
2055801 | 2055801 | 2021-12-27 | Forsyth | North Carolina | 37067 | 56881 | 607 |
2052551 | 2052551 | 2021-12-26 | Forsyth | North Carolina | 37067 | 56881 | 607 |
2049301 | 2049301 | 2021-12-25 | Forsyth | North Carolina | 37067 | 56881 | 607 |
2046051 | 2046051 | 2021-12-24 | Forsyth | North Carolina | 37067 | 56881 | 607 |
2042801 | 2042801 | 2021-12-23 | Forsyth | North Carolina | 37067 | 56881 | 607 |
2039552 | 2039552 | 2021-12-22 | Forsyth | North Carolina | 37067 | 56881 | 607 |
2035521 | 2035521 | 2021-12-21 | Ouachita | Louisiana | 22073 | 32740 | 607 |
2036653 | 2036653 | 2021-12-21 | Erie | Pennsylvania | 42049 | 39590 | 607 |
2033959 | 2033959 | 2021-12-20 | Taylor | Texas | 48441 | 24210 | 607 |
2029020 | 2029020 | 2021-12-19 | Ouachita | Louisiana | 22073 | 32617 | 607 |
2025769 | 2025769 | 2021-12-18 | Ouachita | Louisiana | 22073 | 32617 | 607 |
2022518 | 2022518 | 2021-12-17 | Ouachita | Louisiana | 22073 | 32617 | 607 |
1993941 | 1993941 | 2021-12-08 | San Juan | New Mexico | 35045 | 27358 | 607 |
1969008 | 1969008 | 2021-11-30 | Utah | Utah | 49049 | 135852 | 607 |
1924546 | 1924546 | 2021-11-17 | Winnebago | Illinois | 17201 | 44553 | 607 |
1917193 | 1917193 | 2021-11-14 | Yakima | Washington | 53077 | 46028 | 607 |
1913943 | 1913943 | 2021-11-13 | Yakima | Washington | 53077 | 46028 | 607 |
1910693 | 1910693 | 2021-11-12 | Yakima | Washington | 53077 | 46028 | 607 |
1896474 | 1896474 | 2021-11-08 | Oneida | New York | 36065 | 30146 | 607 |
1778040 | 1778040 | 2021-10-03 | Chatham | Georgia | 13051 | 37769 | 607 |
1774790 | 1774790 | 2021-10-02 | Chatham | Georgia | 13051 | 37769 | 607 |
1774928 | 1774928 | 2021-10-02 | Honolulu | Hawaii | 15003 | 55489 | 607 |
1771540 | 1771540 | 2021-10-01 | Chatham | Georgia | 13051 | 37769 | 607 |
1758641 | 1758641 | 2021-09-27 | Richmond | Georgia | 13245 | 33700 | 607 |
1745362 | 1745362 | 2021-09-23 | San Mateo | California | 6081 | 52471 | 607 |
1745646 | 1745646 | 2021-09-23 | Richmond | Georgia | 13245 | 33361 | 607 |
1742113 | 1742113 | 2021-09-22 | San Mateo | California | 6081 | 52347 | 607 |
1738864 | 1738864 | 2021-09-21 | San Mateo | California | 6081 | 52311 | 607 |
1741275 | 1741275 | 2021-09-21 | Bell | Texas | 48027 | 35840 | 607 |
1741473 | 1741473 | 2021-09-21 | Smith | Texas | 48423 | 32559 | 607 |
1735615 | 1735615 | 2021-09-20 | San Mateo | California | 6081 | 52239 | 607 |
1738096 | 1738096 | 2021-09-20 | Galveston | Texas | 48167 | 60163 | 607 |
1732365 | 1732365 | 2021-09-19 | San Mateo | California | 6081 | 52172 | 607 |
1729115 | 1729115 | 2021-09-18 | San Mateo | California | 6081 | 52065 | 607 |
1725865 | 1725865 | 2021-09-17 | San Mateo | California | 6081 | 51984 | 607 |
1716001 | 1716001 | 2021-09-14 | Yavapai | Arizona | 4025 | 24832 | 607 |
1715092 | 1715092 | 2021-09-13 | Lexington | South Carolina | 45063 | 49111 | 607 |
1600549 | 1600549 | 2021-08-09 | St. Charles | Missouri | 29183 | 52157 | 607 |
1597301 | 1597301 | 2021-08-08 | St. Charles | Missouri | 29183 | 52043 | 607 |
1594052 | 1594052 | 2021-08-07 | St. Charles | Missouri | 29183 | 51888 | 607 |
1590803 | 1590803 | 2021-08-06 | St. Charles | Missouri | 29183 | 51770 | 607 |
1563874 | 1563874 | 2021-07-29 | Madison | Illinois | 17119 | 32544 | 607 |
1518411 | 1518411 | 2021-07-15 | Madison | Illinois | 17119 | 31643 | 607 |
1519302 | 1519302 | 2021-07-15 | Kansas City | Missouri | 46636 | 607 | |
1515164 | 1515164 | 2021-07-14 | Madison | Illinois | 17119 | 31595 | 607 |
1516055 | 1516055 | 2021-07-14 | Kansas City | Missouri | 46467 | 607 | |
1511918 | 1511918 | 2021-07-13 | Madison | Illinois | 17119 | 31545 | 607 |
1512809 | 1512809 | 2021-07-13 | Kansas City | Missouri | 46327 | 607 | |
1514053 | 1514053 | 2021-07-13 | Montgomery | Texas | 48339 | 56137 | 607 |
1510807 | 1510807 | 2021-07-12 | Montgomery | Texas | 48339 | 55960 | 607 |
1507560 | 1507560 | 2021-07-11 | Montgomery | Texas | 48339 | 55960 | 607 |
1504314 | 1504314 | 2021-07-10 | Montgomery | Texas | 48339 | 55960 | 607 |
1501068 | 1501068 | 2021-07-09 | Montgomery | Texas | 48339 | 55871 | 607 |
1464635 | 1464635 | 2021-06-28 | Butler | Ohio | 39017 | 39147 | 607 |
1461390 | 1461390 | 2021-06-27 | Butler | Ohio | 39017 | 39140 | 607 |
1458145 | 1458145 | 2021-06-26 | Butler | Ohio | 39017 | 39136 | 607 |
1454900 | 1454900 | 2021-06-25 | Butler | Ohio | 39017 | 39130 | 607 |
1397708 | 1397708 | 2021-06-08 | Montgomery | Alabama | 1101 | 25061 | 607 |
1394461 | 1394461 | 2021-06-07 | Montgomery | Alabama | 1101 | 25057 | 607 |
1360023 | 1360023 | 2021-05-27 | Saginaw | Michigan | 26145 | 22310 | 607 |
1300005 | 1300005 | 2021-05-08 | Henrico | Virginia | 51087 | 25191 | 607 |
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);