ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
277 rows where deaths = 521 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 36
- New York 22
- Texas 21
- Arizona 19
- Pennsylvania 18
- Illinois 17
- North Carolina 13
- Georgia 12
- Indiana 12
- Ohio 12
- Maryland 9
- Michigan 9
- New Mexico 9
- California 8
- Alaska 7
- Wisconsin 7
- Colorado 6
- South Carolina 6
- Louisiana 5
- Arkansas 4
- Virginia 4
- New Jersey 3
- Tennessee 3
- Alabama 2
- Minnesota 2
- Montana 2
- Oregon 2
- Connecticut 1
- Delaware 1
- Idaho 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2494386 | 2494386 | 2022-05-11 | Washtenaw | Michigan | 26161 | 82599 | 521 |
2489870 | 2489870 | 2022-05-10 | Anchorage | Alaska | 2020 | 104774 | 521 |
2486613 | 2486613 | 2022-05-09 | Anchorage | Alaska | 2020 | 104774 | 521 |
2483355 | 2483355 | 2022-05-08 | Anchorage | Alaska | 2020 | 104774 | 521 |
2480097 | 2480097 | 2022-05-07 | Anchorage | Alaska | 2020 | 104774 | 521 |
2481881 | 2481881 | 2022-05-07 | Albany | New York | 36001 | 62740 | 521 |
2476839 | 2476839 | 2022-05-06 | Anchorage | Alaska | 2020 | 104774 | 521 |
2478623 | 2478623 | 2022-05-06 | Albany | New York | 36001 | 62542 | 521 |
2473581 | 2473581 | 2022-05-05 | Anchorage | Alaska | 2020 | 104774 | 521 |
2474194 | 2474194 | 2022-05-05 | Rock Island | Illinois | 17161 | 33510 | 521 |
2475365 | 2475365 | 2022-05-05 | Albany | New York | 36001 | 62332 | 521 |
2470324 | 2470324 | 2022-05-04 | Anchorage | Alaska | 2020 | 104774 | 521 |
2470937 | 2470937 | 2022-05-04 | Rock Island | Illinois | 17161 | 33496 | 521 |
2467681 | 2467681 | 2022-05-03 | Rock Island | Illinois | 17161 | 33471 | 521 |
2464426 | 2464426 | 2022-05-02 | Rock Island | Illinois | 17161 | 33443 | 521 |
2461170 | 2461170 | 2022-05-01 | Rock Island | Illinois | 17161 | 33407 | 521 |
2457914 | 2457914 | 2022-04-30 | Rock Island | Illinois | 17161 | 33407 | 521 |
2454658 | 2454658 | 2022-04-29 | Rock Island | Illinois | 17161 | 33407 | 521 |
2451402 | 2451402 | 2022-04-28 | Rock Island | Illinois | 17161 | 33374 | 521 |
2448146 | 2448146 | 2022-04-27 | Rock Island | Illinois | 17161 | 33342 | 521 |
2449780 | 2449780 | 2022-04-27 | Monroe | Pennsylvania | 42089 | 37356 | 521 |
2444890 | 2444890 | 2022-04-26 | Rock Island | Illinois | 17161 | 33325 | 521 |
2446523 | 2446523 | 2022-04-26 | Monroe | Pennsylvania | 42089 | 37326 | 521 |
2438912 | 2438912 | 2022-04-24 | Frederick | Maryland | 24021 | 45965 | 521 |
2435656 | 2435656 | 2022-04-23 | Frederick | Maryland | 24021 | 45965 | 521 |
2432400 | 2432400 | 2022-04-22 | Frederick | Maryland | 24021 | 45965 | 521 |
2429144 | 2429144 | 2022-04-21 | Frederick | Maryland | 24021 | 45939 | 521 |
2425888 | 2425888 | 2022-04-20 | Frederick | Maryland | 24021 | 45913 | 521 |
2402056 | 2402056 | 2022-04-13 | Sebastian | Arkansas | 5131 | 32700 | 521 |
2397620 | 2397620 | 2022-04-11 | Jackson | Oregon | 41029 | 42717 | 521 |
2358080 | 2358080 | 2022-03-30 | Unknown | Nebraska | 2758 | 521 | |
2312762 | 2312762 | 2022-03-16 | Robeson | North Carolina | 37155 | 40337 | 521 |
2309509 | 2309509 | 2022-03-15 | Robeson | North Carolina | 37155 | 40323 | 521 |
2306256 | 2306256 | 2022-03-14 | Robeson | North Carolina | 37155 | 40324 | 521 |
2303005 | 2303005 | 2022-03-13 | Robeson | North Carolina | 37155 | 40299 | 521 |
2299753 | 2299753 | 2022-03-12 | Robeson | North Carolina | 37155 | 40299 | 521 |
2296501 | 2296501 | 2022-03-11 | Robeson | North Carolina | 37155 | 40299 | 521 |
2277320 | 2277320 | 2022-03-05 | Northumberland | Pennsylvania | 42097 | 22677 | 521 |
2274067 | 2274067 | 2022-03-04 | Northumberland | Pennsylvania | 42097 | 22672 | 521 |
2270814 | 2270814 | 2022-03-03 | Northumberland | Pennsylvania | 42097 | 22663 | 521 |
2267562 | 2267562 | 2022-03-02 | Northumberland | Pennsylvania | 42097 | 22645 | 521 |
2263249 | 2263249 | 2022-03-01 | Berrien | Michigan | 26021 | 34368 | 521 |
2264309 | 2264309 | 2022-03-01 | Northumberland | Pennsylvania | 42097 | 22632 | 521 |
2259998 | 2259998 | 2022-02-28 | Berrien | Michigan | 26021 | 34368 | 521 |
2256747 | 2256747 | 2022-02-27 | Berrien | Michigan | 26021 | 34354 | 521 |
2253496 | 2253496 | 2022-02-26 | Berrien | Michigan | 26021 | 34354 | 521 |
2250245 | 2250245 | 2022-02-25 | Berrien | Michigan | 26021 | 34354 | 521 |
2247410 | 2247410 | 2022-02-24 | Yellowstone | Montana | 30111 | 41541 | 521 |
2244159 | 2244159 | 2022-02-23 | Yellowstone | Montana | 30111 | 41424 | 521 |
2238659 | 2238659 | 2022-02-21 | Comal | Texas | 48091 | 31686 | 521 |
2235408 | 2235408 | 2022-02-20 | Comal | Texas | 48091 | 31669 | 521 |
2232157 | 2232157 | 2022-02-19 | Comal | Texas | 48091 | 31653 | 521 |
2228906 | 2228906 | 2022-02-18 | Comal | Texas | 48091 | 31603 | 521 |
2213514 | 2213514 | 2022-02-14 | Mesa | Colorado | 8077 | 40307 | 521 |
2210262 | 2210262 | 2022-02-13 | Mesa | Colorado | 8077 | 40120 | 521 |
2207009 | 2207009 | 2022-02-12 | Mesa | Colorado | 8077 | 40120 | 521 |
2203756 | 2203756 | 2022-02-11 | Mesa | Colorado | 8077 | 40120 | 521 |
2200503 | 2200503 | 2022-02-10 | Mesa | Colorado | 8077 | 39994 | 521 |
2188365 | 2188365 | 2022-02-06 | Rapides | Louisiana | 22079 | 31754 | 521 |
2185112 | 2185112 | 2022-02-05 | Rapides | Louisiana | 22079 | 31754 | 521 |
2181860 | 2181860 | 2022-02-04 | Rapides | Louisiana | 22079 | 31754 | 521 |
2176893 | 2176893 | 2022-02-02 | Ellis | Texas | 48139 | 46599 | 521 |
2155896 | 2155896 | 2022-01-27 | Washington | Maryland | 24043 | 32335 | 521 |
2143644 | 2143644 | 2022-01-23 | Rowan | North Carolina | 37159 | 35352 | 521 |
2140389 | 2140389 | 2022-01-22 | Rowan | North Carolina | 37159 | 35352 | 521 |
2137133 | 2137133 | 2022-01-21 | Rowan | North Carolina | 37159 | 35352 | 521 |
2096308 | 2096308 | 2022-01-09 | Washington | Arkansas | 5143 | 51123 | 521 |
2093056 | 2093056 | 2022-01-08 | Washington | Arkansas | 5143 | 51123 | 521 |
2089804 | 2089804 | 2022-01-07 | Washington | Arkansas | 5143 | 50517 | 521 |
2089576 | 2089576 | 2022-01-06 | Racine | Wisconsin | 55101 | 43935 | 521 |
2085446 | 2085446 | 2022-01-05 | Washington | Pennsylvania | 42125 | 37281 | 521 |
2086325 | 2086325 | 2022-01-05 | Racine | Wisconsin | 55101 | 42975 | 521 |
2057475 | 2057475 | 2021-12-28 | Martin | Florida | 12085 | 21044 | 521 |
2054176 | 2054176 | 2021-12-27 | New London | Connecticut | 9011 | 34949 | 521 |
2054226 | 2054226 | 2021-12-27 | Martin | Florida | 12085 | 21044 | 521 |
2050976 | 2050976 | 2021-12-26 | Martin | Florida | 12085 | 21044 | 521 |
2051398 | 2051398 | 2021-12-26 | Vanderburgh | Indiana | 18163 | 36675 | 521 |
2047726 | 2047726 | 2021-12-25 | Martin | Florida | 12085 | 21044 | 521 |
2048148 | 2048148 | 2021-12-25 | Vanderburgh | Indiana | 18163 | 36675 | 521 |
2044476 | 2044476 | 2021-12-24 | Martin | Florida | 12085 | 21044 | 521 |
2044898 | 2044898 | 2021-12-24 | Vanderburgh | Indiana | 18163 | 36675 | 521 |
2041227 | 2041227 | 2021-12-23 | Martin | Florida | 12085 | 20602 | 521 |
2041649 | 2041649 | 2021-12-23 | Vanderburgh | Indiana | 18163 | 36675 | 521 |
2037977 | 2037977 | 2021-12-22 | Martin | Florida | 12085 | 20602 | 521 |
2038399 | 2038399 | 2021-12-22 | Vanderburgh | Indiana | 18163 | 36675 | 521 |
2035149 | 2035149 | 2021-12-21 | Vanderburgh | Indiana | 18163 | 36540 | 521 |
2031899 | 2031899 | 2021-12-20 | Vanderburgh | Indiana | 18163 | 36456 | 521 |
2026905 | 2026905 | 2021-12-18 | Franklin | Pennsylvania | 42055 | 26239 | 521 |
2017575 | 2017575 | 2021-12-15 | Grayson | Texas | 48181 | 16746 | 521 |
2012341 | 2012341 | 2021-12-14 | Hamilton | Indiana | 18057 | 53530 | 521 |
2013469 | 2013469 | 2021-12-14 | Dutchess | New York | 36027 | 39956 | 521 |
2008453 | 2008453 | 2021-12-13 | Apache | Arizona | 4001 | 15763 | 521 |
2009090 | 2009090 | 2021-12-13 | Hamilton | Indiana | 18057 | 53298 | 521 |
2005202 | 2005202 | 2021-12-12 | Apache | Arizona | 4001 | 15745 | 521 |
2001951 | 2001951 | 2021-12-11 | Apache | Arizona | 4001 | 15723 | 521 |
1992568 | 1992568 | 2021-12-08 | Henry | Georgia | 13151 | 39336 | 521 |
1994357 | 1994357 | 2021-12-08 | Marion | Oregon | 41047 | 40454 | 521 |
1988879 | 1988879 | 2021-12-07 | Etowah | Alabama | 1055 | 20084 | 521 |
1989210 | 1989210 | 2021-12-07 | Leon | Florida | 12073 | 51187 | 521 |
1989317 | 1989317 | 2021-12-07 | Henry | Georgia | 13151 | 39285 | 521 |
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);