ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
147 rows where deaths = 743 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Pennsylvania 29
- Louisiana 13
- Ohio 13
- California 9
- Nebraska 8
- Georgia 7
- Texas 6
- Colorado 5
- Florida 5
- Kansas 5
- New Jersey 5
- North Carolina 5
- Maryland 4
- Virginia 4
- Arizona 3
- Massachusetts 3
- New Mexico 3
- New York 3
- South Carolina 3
- Washington 3
- Delaware 2
- Indiana 2
- Michigan 2
- Alabama 1
- Arkansas 1
- Illinois 1
- Minnesota 1
- Puerto Rico 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501856 | 2501856 | 2022-05-13 | Butler | Pennsylvania | 42019 | 45173 | 743 |
2498598 | 2498598 | 2022-05-12 | Butler | Pennsylvania | 42019 | 45173 | 743 |
2495340 | 2495340 | 2022-05-11 | Butler | Pennsylvania | 42019 | 45173 | 743 |
2492076 | 2492076 | 2022-05-10 | Beaver | Pennsylvania | 42007 | 40525 | 743 |
2488818 | 2488818 | 2022-05-09 | Beaver | Pennsylvania | 42007 | 40525 | 743 |
2485561 | 2485561 | 2022-05-08 | Beaver | Pennsylvania | 42007 | 40525 | 743 |
2482303 | 2482303 | 2022-05-07 | Beaver | Pennsylvania | 42007 | 40525 | 743 |
2479045 | 2479045 | 2022-05-06 | Beaver | Pennsylvania | 42007 | 40525 | 743 |
2475787 | 2475787 | 2022-05-05 | Beaver | Pennsylvania | 42007 | 40525 | 743 |
2472530 | 2472530 | 2022-05-04 | Beaver | Pennsylvania | 42007 | 40525 | 743 |
2443986 | 2443986 | 2022-04-25 | Prince William | Virginia | 51153 | 95917 | 743 |
2393941 | 2393941 | 2022-04-10 | Doña Ana | New Mexico | 35013 | 63313 | 743 |
2390685 | 2390685 | 2022-04-09 | Doña Ana | New Mexico | 35013 | 63313 | 743 |
2387429 | 2387429 | 2022-04-08 | Doña Ana | New Mexico | 35013 | 63313 | 743 |
2366309 | 2366309 | 2022-04-02 | San Mateo | California | 6081 | 127776 | 743 |
2363056 | 2363056 | 2022-04-01 | San Mateo | California | 6081 | 127776 | 743 |
2359802 | 2359802 | 2022-03-31 | San Mateo | California | 6081 | 127607 | 743 |
2356548 | 2356548 | 2022-03-30 | San Mateo | California | 6081 | 127481 | 743 |
2353295 | 2353295 | 2022-03-29 | San Mateo | California | 6081 | 127383 | 743 |
2350043 | 2350043 | 2022-03-28 | San Mateo | California | 6081 | 127370 | 743 |
2346790 | 2346790 | 2022-03-27 | San Mateo | California | 6081 | 127211 | 743 |
2343537 | 2343537 | 2022-03-26 | San Mateo | California | 6081 | 127211 | 743 |
2313070 | 2313070 | 2022-03-16 | Erie | Pennsylvania | 42049 | 56812 | 743 |
2265647 | 2265647 | 2022-03-02 | Bibb | Georgia | 13021 | 36706 | 743 |
2262396 | 2262396 | 2022-03-01 | Bibb | Georgia | 13021 | 36698 | 743 |
2259145 | 2259145 | 2022-02-28 | Bibb | Georgia | 13021 | 36682 | 743 |
2258560 | 2258560 | 2022-02-27 | Clark | Washington | 53011 | 83776 | 743 |
2255309 | 2255309 | 2022-02-26 | Clark | Washington | 53011 | 83776 | 743 |
2252058 | 2252058 | 2022-02-25 | Clark | Washington | 53011 | 83776 | 743 |
2234675 | 2234675 | 2022-02-20 | Forsyth | North Carolina | 37067 | 90392 | 743 |
2235788 | 2235788 | 2022-02-20 | Virginia Beach city | Virginia | 51810 | 87908 | 743 |
2231424 | 2231424 | 2022-02-19 | Forsyth | North Carolina | 37067 | 90392 | 743 |
2232537 | 2232537 | 2022-02-19 | Virginia Beach city | Virginia | 51810 | 87908 | 743 |
2228173 | 2228173 | 2022-02-18 | Forsyth | North Carolina | 37067 | 90392 | 743 |
2229286 | 2229286 | 2022-02-18 | Virginia Beach city | Virginia | 51810 | 87908 | 743 |
2224924 | 2224924 | 2022-02-17 | Gaston | North Carolina | 37071 | 63961 | 743 |
2216595 | 2216595 | 2022-02-15 | Benton | Arkansas | 5007 | 64988 | 743 |
2195024 | 2195024 | 2022-02-08 | Ottawa | Michigan | 26139 | 72449 | 743 |
2191770 | 2191770 | 2022-02-07 | Ottawa | Michigan | 26139 | 72449 | 743 |
2178776 | 2178776 | 2022-02-03 | Anoka | Minnesota | 27003 | 93899 | 743 |
2159803 | 2159803 | 2022-01-28 | Oneida | New York | 36065 | 49607 | 743 |
2154990 | 2154990 | 2022-01-27 | Sussex | Delaware | 10005 | 57822 | 743 |
2151737 | 2151737 | 2022-01-26 | Sussex | Delaware | 10005 | 57361 | 743 |
2115091 | 2115091 | 2022-01-14 | Galveston | Texas | 48167 | 81808 | 743 |
2115130 | 2115130 | 2022-01-14 | Jefferson | Texas | 48245 | 36910 | 743 |
2111878 | 2111878 | 2022-01-13 | Jefferson | Texas | 48245 | 36994 | 743 |
2106536 | 2106536 | 2022-01-12 | Madison | Illinois | 17119 | 57472 | 743 |
2108626 | 2108626 | 2022-01-12 | Jefferson | Texas | 48245 | 36671 | 743 |
2101662 | 2101662 | 2022-01-10 | Cumberland | Pennsylvania | 42041 | 40593 | 743 |
2097298 | 2097298 | 2022-01-09 | St. Tammany | Louisiana | 22103 | 52884 | 743 |
2098411 | 2098411 | 2022-01-09 | Cumberland | Pennsylvania | 42041 | 40114 | 743 |
2094046 | 2094046 | 2022-01-08 | St. Tammany | Louisiana | 22103 | 52884 | 743 |
2095159 | 2095159 | 2022-01-08 | Cumberland | Pennsylvania | 42041 | 39720 | 743 |
2090794 | 2090794 | 2022-01-07 | St. Tammany | Louisiana | 22103 | 52884 | 743 |
2057216 | 2057216 | 2021-12-28 | Navajo | Arizona | 4017 | 26690 | 743 |
2039900 | 2039900 | 2021-12-22 | Dauphin | Pennsylvania | 42043 | 41579 | 743 |
2005617 | 2005617 | 2021-12-12 | Richmond | Georgia | 13245 | 35890 | 743 |
2002366 | 2002366 | 2021-12-11 | Richmond | Georgia | 13245 | 35890 | 743 |
1999116 | 1999116 | 2021-12-10 | Richmond | Georgia | 13245 | 35890 | 743 |
1929205 | 1929205 | 2021-11-18 | Mahoning | Ohio | 39099 | 33543 | 743 |
1925955 | 1925955 | 2021-11-17 | Mahoning | Ohio | 39099 | 33354 | 743 |
1922705 | 1922705 | 2021-11-16 | Mahoning | Ohio | 39099 | 33212 | 743 |
1919456 | 1919456 | 2021-11-15 | Mahoning | Ohio | 39099 | 33059 | 743 |
1916206 | 1916206 | 2021-11-14 | Mahoning | Ohio | 39099 | 32977 | 743 |
1912956 | 1912956 | 2021-11-13 | Mahoning | Ohio | 39099 | 32863 | 743 |
1909706 | 1909706 | 2021-11-12 | Mahoning | Ohio | 39099 | 32733 | 743 |
1898267 | 1898267 | 2021-11-09 | Clayton | Georgia | 13063 | 39654 | 743 |
1861274 | 1861274 | 2021-10-28 | Anderson | South Carolina | 45007 | 36473 | 743 |
1806074 | 1806074 | 2021-10-11 | Richland | South Carolina | 45079 | 67747 | 743 |
1795749 | 1795749 | 2021-10-08 | Onondaga | New York | 36067 | 49517 | 743 |
1785917 | 1785917 | 2021-10-05 | Atlantic | New Jersey | 34001 | 38037 | 743 |
1721452 | 1721452 | 2021-09-15 | Northampton | Pennsylvania | 42095 | 40452 | 743 |
1718204 | 1718204 | 2021-09-14 | Northampton | Pennsylvania | 42095 | 40326 | 743 |
1691790 | 1691790 | 2021-09-06 | Orange | New York | 36071 | 52797 | 743 |
1671119 | 1671119 | 2021-08-31 | Allen | Indiana | 18003 | 48857 | 743 |
1649377 | 1649377 | 2021-08-24 | Douglas | Nebraska | 31055 | 76850 | 743 |
1646128 | 1646128 | 2021-08-23 | Douglas | Nebraska | 31055 | 76633 | 743 |
1642879 | 1642879 | 2021-08-22 | Douglas | Nebraska | 31055 | 76231 | 743 |
1639629 | 1639629 | 2021-08-21 | Douglas | Nebraska | 31055 | 76231 | 743 |
1636379 | 1636379 | 2021-08-20 | Douglas | Nebraska | 31055 | 76231 | 743 |
1633129 | 1633129 | 2021-08-19 | Douglas | Nebraska | 31055 | 76090 | 743 |
1629882 | 1629882 | 2021-08-18 | Douglas | Nebraska | 31055 | 75907 | 743 |
1626635 | 1626635 | 2021-08-17 | Douglas | Nebraska | 31055 | 75748 | 743 |
1555470 | 1555470 | 2021-07-26 | Wake | North Carolina | 37183 | 92186 | 743 |
1407497 | 1407497 | 2021-06-11 | Mohave | Arizona | 4015 | 23276 | 743 |
1404251 | 1404251 | 2021-06-10 | Mohave | Arizona | 4015 | 23245 | 743 |
1388165 | 1388165 | 2021-06-05 | Adams | Colorado | 8001 | 61120 | 743 |
1324123 | 1324123 | 2021-05-16 | Caddo | Louisiana | 22017 | 26225 | 743 |
1320877 | 1320877 | 2021-05-15 | Caddo | Louisiana | 22017 | 26225 | 743 |
1317630 | 1317630 | 2021-05-14 | Caddo | Louisiana | 22017 | 26225 | 743 |
1314383 | 1314383 | 2021-05-13 | Caddo | Louisiana | 22017 | 26216 | 743 |
1311136 | 1311136 | 2021-05-12 | Caddo | Louisiana | 22017 | 26174 | 743 |
1281163 | 1281163 | 2021-05-03 | Pasco | Florida | 12101 | 40984 | 743 |
1277916 | 1277916 | 2021-05-02 | Pasco | Florida | 12101 | 40895 | 743 |
1278525 | 1278525 | 2021-05-02 | Sedgwick | Kansas | 20173 | 56132 | 743 |
1274669 | 1274669 | 2021-05-01 | Pasco | Florida | 12101 | 40808 | 743 |
1275278 | 1275278 | 2021-05-01 | Sedgwick | Kansas | 20173 | 56132 | 743 |
1271422 | 1271422 | 2021-04-30 | Pasco | Florida | 12101 | 40692 | 743 |
1272031 | 1272031 | 2021-04-30 | Sedgwick | Kansas | 20173 | 56132 | 743 |
1273377 | 1273377 | 2021-04-30 | Westmoreland | Pennsylvania | 42129 | 32649 | 743 |
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);