ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
160 rows where deaths = 604 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Pennsylvania 18
- New Jersey 15
- Texas 14
- Florida 12
- Louisiana 11
- Georgia 8
- Indiana 7
- Maryland 6
- New York 6
- Ohio 6
- California 5
- Illinois 5
- Kansas 5
- Washington 5
- District of Columbia 4
- Michigan 4
- Colorado 3
- Iowa 3
- Missouri 3
- Oregon 3
- Virginia 3
- Alabama 2
- Arkansas 2
- South Carolina 2
- Tennessee 2
- Idaho 1
- Mississippi 1
- Nevada 1
- New Hampshire 1
- New Mexico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2485088 | 2485088 | 2022-05-08 | Cumberland | New Jersey | 34011 | 40165 | 604 |
2481830 | 2481830 | 2022-05-07 | Cumberland | New Jersey | 34011 | 40139 | 604 |
2478572 | 2478572 | 2022-05-06 | Cumberland | New Jersey | 34011 | 40100 | 604 |
2475314 | 2475314 | 2022-05-05 | Cumberland | New Jersey | 34011 | 40079 | 604 |
2329318 | 2329318 | 2022-03-21 | Blair | Pennsylvania | 42013 | 29573 | 604 |
2326066 | 2326066 | 2022-03-20 | Blair | Pennsylvania | 42013 | 29567 | 604 |
2320720 | 2320720 | 2022-03-19 | Washington | Arkansas | 5143 | 67801 | 604 |
2322813 | 2322813 | 2022-03-19 | Blair | Pennsylvania | 42013 | 29564 | 604 |
2317466 | 2317466 | 2022-03-18 | Washington | Arkansas | 5143 | 67764 | 604 |
2319559 | 2319559 | 2022-03-18 | Blair | Pennsylvania | 42013 | 29558 | 604 |
2316305 | 2316305 | 2022-03-17 | Blair | Pennsylvania | 42013 | 29549 | 604 |
2310784 | 2310784 | 2022-03-16 | Calhoun | Alabama | 1015 | 32324 | 604 |
2310994 | 2310994 | 2022-03-16 | Placer | California | 6061 | 69718 | 604 |
2311522 | 2311522 | 2022-03-16 | Johnson | Indiana | 18081 | 42266 | 604 |
2313052 | 2313052 | 2022-03-16 | Blair | Pennsylvania | 42013 | 29547 | 604 |
2307531 | 2307531 | 2022-03-15 | Calhoun | Alabama | 1015 | 32295 | 604 |
2308269 | 2308269 | 2022-03-15 | Johnson | Indiana | 18081 | 42262 | 604 |
2305018 | 2305018 | 2022-03-14 | Johnson | Indiana | 18081 | 42258 | 604 |
2217785 | 2217785 | 2022-02-15 | Muskegon | Michigan | 26121 | 40841 | 604 |
2214534 | 2214534 | 2022-02-14 | Muskegon | Michigan | 26121 | 40841 | 604 |
2215522 | 2215522 | 2022-02-14 | Fayette | Pennsylvania | 42051 | 30041 | 604 |
2202549 | 2202549 | 2022-02-10 | Washington | Pennsylvania | 42125 | 49426 | 604 |
2191896 | 2191896 | 2022-02-07 | Harrison | Mississippi | 28047 | 51319 | 604 |
2187956 | 2187956 | 2022-02-06 | Madison | Indiana | 18095 | 31822 | 604 |
2184703 | 2184703 | 2022-02-05 | Madison | Indiana | 18095 | 31822 | 604 |
2181451 | 2181451 | 2022-02-04 | Madison | Indiana | 18095 | 31822 | 604 |
2170408 | 2170408 | 2022-01-31 | Gregg | Texas | 48183 | 22167 | 604 |
2164662 | 2164662 | 2022-01-30 | Santa Barbara | California | 6083 | 80393 | 604 |
2167154 | 2167154 | 2022-01-30 | Gregg | Texas | 48183 | 22074 | 604 |
2161407 | 2161407 | 2022-01-29 | Santa Barbara | California | 6083 | 80393 | 604 |
2163875 | 2163875 | 2022-01-29 | Ector | Texas | 48135 | 35715 | 604 |
2158151 | 2158151 | 2022-01-28 | Santa Barbara | California | 6083 | 80393 | 604 |
2160620 | 2160620 | 2022-01-28 | Ector | Texas | 48135 | 35623 | 604 |
2157364 | 2157364 | 2022-01-27 | Ector | Texas | 48135 | 35442 | 604 |
2140724 | 2140724 | 2022-01-22 | Schuylkill | Pennsylvania | 42107 | 31511 | 604 |
2109436 | 2109436 | 2022-01-13 | Weld | Colorado | 8123 | 66308 | 604 |
2106185 | 2106185 | 2022-01-12 | Weld | Colorado | 8123 | 65502 | 604 |
2103903 | 2103903 | 2022-01-11 | Ingham | Michigan | 26065 | 47947 | 604 |
2100652 | 2100652 | 2022-01-10 | Ingham | Michigan | 26065 | 47947 | 604 |
2102127 | 2102127 | 2022-01-10 | Johnson | Texas | 48251 | 33174 | 604 |
2098876 | 2098876 | 2022-01-09 | Johnson | Texas | 48251 | 32933 | 604 |
2095624 | 2095624 | 2022-01-08 | Johnson | Texas | 48251 | 32746 | 604 |
2092372 | 2092372 | 2022-01-07 | Johnson | Texas | 48251 | 32434 | 604 |
2082166 | 2082166 | 2022-01-04 | Lackawanna | Pennsylvania | 42069 | 30897 | 604 |
2078436 | 2078436 | 2022-01-03 | Doña Ana | New Mexico | 35013 | 42010 | 604 |
2075632 | 2075632 | 2022-01-02 | Beaver | Pennsylvania | 42007 | 30017 | 604 |
2072381 | 2072381 | 2022-01-01 | Beaver | Pennsylvania | 42007 | 29879 | 604 |
2069130 | 2069130 | 2021-12-31 | Beaver | Pennsylvania | 42007 | 29633 | 604 |
2057682 | 2057682 | 2021-12-28 | Canyon | Idaho | 16027 | 44917 | 604 |
2012766 | 2012766 | 2021-12-14 | Ouachita | Louisiana | 22073 | 32542 | 604 |
2009515 | 2009515 | 2021-12-13 | Ouachita | Louisiana | 22073 | 32520 | 604 |
2006264 | 2006264 | 2021-12-12 | Ouachita | Louisiana | 22073 | 32470 | 604 |
2003013 | 2003013 | 2021-12-11 | Ouachita | Louisiana | 22073 | 32470 | 604 |
1999763 | 1999763 | 2021-12-10 | Ouachita | Louisiana | 22073 | 32470 | 604 |
1996512 | 1996512 | 2021-12-09 | Ouachita | Louisiana | 22073 | 32439 | 604 |
1989148 | 1989148 | 2021-12-07 | Pueblo | Colorado | 8101 | 30071 | 604 |
1889974 | 1889974 | 2021-11-06 | Oneida | New York | 36065 | 29946 | 604 |
1863704 | 1863704 | 2021-10-29 | St. Louis city | Missouri | 29510 | 32564 | 604 |
1860455 | 1860455 | 2021-10-28 | St. Louis city | Missouri | 29510 | 32515 | 604 |
1805904 | 1805904 | 2021-10-11 | Dauphin | Pennsylvania | 42043 | 33091 | 604 |
1802654 | 1802654 | 2021-10-10 | Dauphin | Pennsylvania | 42043 | 33025 | 604 |
1799405 | 1799405 | 2021-10-09 | Dauphin | Pennsylvania | 42043 | 32942 | 604 |
1796156 | 1796156 | 2021-10-08 | Dauphin | Pennsylvania | 42043 | 32819 | 604 |
1768291 | 1768291 | 2021-09-30 | Chatham | Georgia | 13051 | 37692 | 604 |
1736166 | 1736166 | 2021-09-20 | St. Joseph | Indiana | 18141 | 41766 | 604 |
1737808 | 1737808 | 2021-09-20 | Anderson | South Carolina | 45007 | 33139 | 604 |
1738026 | 1738026 | 2021-09-20 | Bell | Texas | 48027 | 35525 | 604 |
1732559 | 1732559 | 2021-09-19 | Clayton | Georgia | 13063 | 36025 | 604 |
1729309 | 1729309 | 2021-09-18 | Clayton | Georgia | 13063 | 36025 | 604 |
1726059 | 1726059 | 2021-09-17 | Clayton | Georgia | 13063 | 36025 | 604 |
1671586 | 1671586 | 2021-08-31 | St. Tammany | Louisiana | 22103 | 39777 | 604 |
1668339 | 1668339 | 2021-08-30 | St. Tammany | Louisiana | 22103 | 39777 | 604 |
1665092 | 1665092 | 2021-08-29 | St. Tammany | Louisiana | 22103 | 39777 | 604 |
1661844 | 1661844 | 2021-08-28 | St. Tammany | Louisiana | 22103 | 39777 | 604 |
1658596 | 1658596 | 2021-08-27 | St. Tammany | Louisiana | 22103 | 39777 | 604 |
1494575 | 1494575 | 2021-07-07 | Montgomery | Texas | 48339 | 55768 | 604 |
1474412 | 1474412 | 2021-07-01 | Mahoning | Ohio | 39099 | 22421 | 604 |
1471166 | 1471166 | 2021-06-30 | Mahoning | Ohio | 39099 | 22415 | 604 |
1472145 | 1472145 | 2021-06-30 | Snohomish | Washington | 53061 | 40231 | 604 |
1466470 | 1466470 | 2021-06-29 | Madison | Illinois | 17119 | 31114 | 604 |
1467921 | 1467921 | 2021-06-29 | Mahoning | Ohio | 39099 | 22414 | 604 |
1450244 | 1450244 | 2021-06-24 | Madison | Illinois | 17119 | 31004 | 604 |
1428934 | 1428934 | 2021-06-17 | Butler | Ohio | 39017 | 38951 | 604 |
1425689 | 1425689 | 2021-06-16 | Butler | Ohio | 39017 | 38937 | 604 |
1422442 | 1422442 | 2021-06-15 | Butler | Ohio | 39017 | 38912 | 604 |
1325246 | 1325246 | 2021-05-16 | Multnomah | Oregon | 41051 | 38714 | 604 |
1322000 | 1322000 | 2021-05-15 | Multnomah | Oregon | 41051 | 38618 | 604 |
1318754 | 1318754 | 2021-05-14 | Multnomah | Oregon | 41051 | 38497 | 604 |
1311211 | 1311211 | 2021-05-12 | Anne Arundel | Maryland | 24003 | 43262 | 604 |
1307964 | 1307964 | 2021-05-11 | Anne Arundel | Maryland | 24003 | 43211 | 604 |
1304718 | 1304718 | 2021-05-10 | Anne Arundel | Maryland | 24003 | 43162 | 604 |
1301472 | 1301472 | 2021-05-09 | Anne Arundel | Maryland | 24003 | 43132 | 604 |
1298224 | 1298224 | 2021-05-08 | Anne Arundel | Maryland | 24003 | 43075 | 604 |
1266354 | 1266354 | 2021-04-28 | Gloucester | New Jersey | 34015 | 29466 | 604 |
1263107 | 1263107 | 2021-04-27 | Gloucester | New Jersey | 34015 | 29396 | 604 |
1232957 | 1232957 | 2021-04-18 | Polk | Iowa | 19153 | 56023 | 604 |
1229708 | 1229708 | 2021-04-17 | Polk | Iowa | 19153 | 55970 | 604 |
1229818 | 1229818 | 2021-04-17 | Sedgwick | Kansas | 20173 | 55462 | 604 |
1226460 | 1226460 | 2021-04-16 | Polk | Iowa | 19153 | 55892 | 604 |
1226570 | 1226570 | 2021-04-16 | Sedgwick | Kansas | 20173 | 55462 | 604 |
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);