ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
134 rows where deaths = 623 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Pennsylvania 12
- Texas 12
- Colorado 11
- Wisconsin 9
- California 8
- Virginia 8
- Louisiana 7
- New Hampshire 7
- Alabama 6
- Florida 6
- New York 6
- Ohio 6
- Tennessee 5
- Massachusetts 4
- Mississippi 3
- Washington 3
- Georgia 2
- Illinois 2
- Indiana 2
- Michigan 2
- New Jersey 2
- Arkansas 1
- Connecticut 1
- District of Columbia 1
- Iowa 1
- Maryland 1
- Minnesota 1
- Nebraska 1
- Nevada 1
- New Mexico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2405143 | 2405143 | 2022-04-14 | Calhoun | Alabama | 1015 | 32361 | 623 |
2362763 | 2362763 | 2022-03-31 | Kenosha | Wisconsin | 55059 | 43928 | 623 |
2359509 | 2359509 | 2022-03-30 | Kenosha | Wisconsin | 55059 | 43921 | 623 |
2356255 | 2356255 | 2022-03-29 | Kenosha | Wisconsin | 55059 | 43909 | 623 |
2353002 | 2353002 | 2022-03-28 | Kenosha | Wisconsin | 55059 | 43899 | 623 |
2339523 | 2339523 | 2022-03-24 | Grayson | Texas | 48181 | 27068 | 623 |
2242803 | 2242803 | 2022-02-23 | New London | Connecticut | 9011 | 53366 | 623 |
2216946 | 2216946 | 2022-02-15 | Henry | Georgia | 13151 | 56764 | 623 |
2217214 | 2217214 | 2022-02-15 | Hamilton | Indiana | 18057 | 80521 | 623 |
2218735 | 2218735 | 2022-02-15 | Marion | Oregon | 41047 | 67156 | 623 |
2211417 | 2211417 | 2022-02-13 | Harrison | Mississippi | 28047 | 52000 | 623 |
2208164 | 2208164 | 2022-02-12 | Harrison | Mississippi | 28047 | 52000 | 623 |
2209444 | 2209444 | 2022-02-12 | Gregg | Texas | 48183 | 22806 | 623 |
2204911 | 2204911 | 2022-02-11 | Harrison | Mississippi | 28047 | 52000 | 623 |
2201501 | 2201501 | 2022-02-10 | Kalamazoo | Michigan | 26077 | 56668 | 623 |
2198247 | 2198247 | 2022-02-09 | Kalamazoo | Michigan | 26077 | 56668 | 623 |
2190685 | 2190685 | 2022-02-07 | Santa Barbara | California | 6083 | 85538 | 623 |
2187204 | 2187204 | 2022-02-06 | Baldwin | Alabama | 1003 | 53637 | 623 |
2183951 | 2183951 | 2022-02-05 | Baldwin | Alabama | 1003 | 53637 | 623 |
2180699 | 2180699 | 2022-02-04 | Baldwin | Alabama | 1003 | 53559 | 623 |
2183393 | 2183393 | 2022-02-04 | Ector | Texas | 48135 | 36288 | 623 |
2156990 | 2156990 | 2022-01-27 | Schuylkill | Pennsylvania | 42107 | 32328 | 623 |
2151724 | 2151724 | 2022-01-26 | Weld | Colorado | 8123 | 75013 | 623 |
2148472 | 2148472 | 2022-01-25 | Weld | Colorado | 8123 | 74084 | 623 |
2144714 | 2144714 | 2022-01-23 | Virginia Beach city | Virginia | 51810 | 80392 | 623 |
2141459 | 2141459 | 2022-01-22 | Virginia Beach city | Virginia | 51810 | 80392 | 623 |
2138203 | 2138203 | 2022-01-21 | Virginia Beach city | Virginia | 51810 | 80392 | 623 |
2134948 | 2134948 | 2022-01-20 | Virginia Beach city | Virginia | 51810 | 79419 | 623 |
2129800 | 2129800 | 2022-01-19 | Ouachita | Louisiana | 22073 | 41210 | 623 |
2131394 | 2131394 | 2022-01-19 | Johnson | Texas | 48251 | 36976 | 623 |
2126546 | 2126546 | 2022-01-18 | Ouachita | Louisiana | 22073 | 40661 | 623 |
2128202 | 2128202 | 2022-01-18 | Potter | Texas | 48375 | 30685 | 623 |
2107700 | 2107700 | 2022-01-12 | Doña Ana | New Mexico | 35013 | 45623 | 623 |
2077338 | 2077338 | 2022-01-03 | Elkhart | Indiana | 18039 | 44067 | 623 |
2079460 | 2079460 | 2022-01-03 | Taylor | Texas | 48441 | 24733 | 623 |
1997495 | 1997495 | 2021-12-09 | Trumbull | Ohio | 39155 | 28279 | 623 |
1994244 | 1994244 | 2021-12-08 | Trumbull | Ohio | 39155 | 28123 | 623 |
1990993 | 1990993 | 2021-12-07 | Trumbull | Ohio | 39155 | 27953 | 623 |
1944476 | 1944476 | 2021-11-23 | Calcasieu | Louisiana | 22019 | 34875 | 623 |
1941226 | 1941226 | 2021-11-22 | Calcasieu | Louisiana | 22019 | 34846 | 623 |
1937976 | 1937976 | 2021-11-21 | Calcasieu | Louisiana | 22019 | 34803 | 623 |
1934726 | 1934726 | 2021-11-20 | Calcasieu | Louisiana | 22019 | 34803 | 623 |
1931475 | 1931475 | 2021-11-19 | Calcasieu | Louisiana | 22019 | 34803 | 623 |
1923957 | 1923957 | 2021-11-17 | Benton | Arkansas | 5007 | 43203 | 623 |
1859081 | 1859081 | 2021-10-28 | San Mateo | California | 6081 | 54528 | 623 |
1855832 | 1855832 | 2021-10-27 | San Mateo | California | 6081 | 54423 | 623 |
1852583 | 1852583 | 2021-10-26 | San Mateo | California | 6081 | 54376 | 623 |
1849334 | 1849334 | 2021-10-25 | San Mateo | California | 6081 | 54168 | 623 |
1846084 | 1846084 | 2021-10-24 | San Mateo | California | 6081 | 54168 | 623 |
1842834 | 1842834 | 2021-10-23 | San Mateo | California | 6081 | 54168 | 623 |
1839584 | 1839584 | 2021-10-22 | San Mateo | California | 6081 | 54168 | 623 |
1825398 | 1825398 | 2021-10-17 | Dauphin | Pennsylvania | 42043 | 33756 | 623 |
1822149 | 1822149 | 2021-10-16 | Dauphin | Pennsylvania | 42043 | 33669 | 623 |
1818900 | 1818900 | 2021-10-15 | Dauphin | Pennsylvania | 42043 | 33580 | 623 |
1767188 | 1767188 | 2021-09-29 | Hamilton | Tennessee | 47065 | 61473 | 623 |
1745556 | 1745556 | 2021-09-23 | Clayton | Georgia | 13063 | 37190 | 623 |
1747844 | 1747844 | 2021-09-23 | Galveston | Texas | 48167 | 60925 | 623 |
1679020 | 1679020 | 2021-09-02 | Mahoning | Ohio | 39099 | 24496 | 623 |
1675772 | 1675772 | 2021-09-01 | Mahoning | Ohio | 39099 | 24402 | 623 |
1672525 | 1672525 | 2021-08-31 | Mahoning | Ohio | 39099 | 24342 | 623 |
1651586 | 1651586 | 2021-08-25 | Madison | Illinois | 17119 | 35349 | 623 |
1653383 | 1653383 | 2021-08-25 | Richland | South Carolina | 45079 | 56223 | 623 |
1601747 | 1601747 | 2021-08-09 | Montgomery | Texas | 48339 | 61721 | 623 |
1598499 | 1598499 | 2021-08-08 | Montgomery | Texas | 48339 | 61721 | 623 |
1595250 | 1595250 | 2021-08-07 | Montgomery | Texas | 48339 | 61721 | 623 |
1585799 | 1585799 | 2021-08-04 | Snohomish | Washington | 53061 | 43771 | 623 |
1582549 | 1582549 | 2021-08-03 | Snohomish | Washington | 53061 | 43529 | 623 |
1543785 | 1543785 | 2021-07-23 | Montgomery | Alabama | 1101 | 25640 | 623 |
1540537 | 1540537 | 2021-07-22 | Montgomery | Alabama | 1101 | 25598 | 623 |
1439825 | 1439825 | 2021-06-20 | Waukesha | Wisconsin | 55133 | 49189 | 623 |
1436578 | 1436578 | 2021-06-19 | Waukesha | Wisconsin | 55133 | 49189 | 623 |
1433331 | 1433331 | 2021-06-18 | Waukesha | Wisconsin | 55133 | 49189 | 623 |
1430085 | 1430085 | 2021-06-17 | Waukesha | Wisconsin | 55133 | 49184 | 623 |
1426840 | 1426840 | 2021-06-16 | Waukesha | Wisconsin | 55133 | 49179 | 623 |
1307633 | 1307633 | 2021-05-11 | Polk | Iowa | 19153 | 57488 | 623 |
1289068 | 1289068 | 2021-05-05 | Hillsborough | New Hampshire | 33011 | 35068 | 623 |
1285822 | 1285822 | 2021-05-04 | Hillsborough | New Hampshire | 33011 | 35025 | 623 |
1282576 | 1282576 | 2021-05-03 | Hillsborough | New Hampshire | 33011 | 34953 | 623 |
1279329 | 1279329 | 2021-05-02 | Hillsborough | New Hampshire | 33011 | 34900 | 623 |
1276082 | 1276082 | 2021-05-01 | Hillsborough | New Hampshire | 33011 | 34834 | 623 |
1272835 | 1272835 | 2021-04-30 | Hillsborough | New Hampshire | 33011 | 34768 | 623 |
1269588 | 1269588 | 2021-04-29 | Hillsborough | New Hampshire | 33011 | 34681 | 623 |
1258417 | 1258417 | 2021-04-26 | Lake | Florida | 12069 | 28949 | 623 |
1255170 | 1255170 | 2021-04-25 | Lake | Florida | 12069 | 28892 | 623 |
1238935 | 1238935 | 2021-04-20 | Lake | Florida | 12069 | 28465 | 623 |
1224915 | 1224915 | 2021-04-15 | Knox | Tennessee | 47093 | 50462 | 623 |
1221668 | 1221668 | 2021-04-14 | Knox | Tennessee | 47093 | 50379 | 623 |
1215683 | 1215683 | 2021-04-12 | Pierce | Washington | 53053 | 44908 | 623 |
1198931 | 1198931 | 2021-04-07 | Knox | Tennessee | 47093 | 49951 | 623 |
1153592 | 1153592 | 2021-03-24 | Fort Bend | Texas | 48157 | 62587 | 623 |
1040894 | 1040894 | 2021-02-18 | Pasco | Florida | 12101 | 32152 | 623 |
1042830 | 1042830 | 2021-02-18 | Northampton | Pennsylvania | 42095 | 25837 | 623 |
1037521 | 1037521 | 2021-02-17 | Adams | Colorado | 8001 | 48149 | 623 |
1034276 | 1034276 | 2021-02-16 | Adams | Colorado | 8001 | 48071 | 623 |
1031030 | 1031030 | 2021-02-15 | Adams | Colorado | 8001 | 48032 | 623 |
1027783 | 1027783 | 2021-02-14 | Adams | Colorado | 8001 | 47830 | 623 |
1024538 | 1024538 | 2021-02-13 | Adams | Colorado | 8001 | 47830 | 623 |
1021293 | 1021293 | 2021-02-12 | Adams | Colorado | 8001 | 47784 | 623 |
1018048 | 1018048 | 2021-02-11 | Adams | Colorado | 8001 | 47511 | 623 |
1014803 | 1014803 | 2021-02-10 | Adams | Colorado | 8001 | 47503 | 623 |
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);