ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where county = "Pike" and deaths = 46 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 6
- Indiana 47
- Pennsylvania 10
- Mississippi 7
- Kentucky 6
- Illinois 5
- Georgia 3
county 1
- Pike · 78 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2142425 | 2142425 | 2022-01-23 | Pike | Indiana | 18125 | 3279 | 46 |
2139170 | 2139170 | 2022-01-22 | Pike | Indiana | 18125 | 3279 | 46 |
2135914 | 2135914 | 2022-01-21 | Pike | Indiana | 18125 | 3279 | 46 |
2132662 | 2132662 | 2022-01-20 | Pike | Indiana | 18125 | 3235 | 46 |
2129409 | 2129409 | 2022-01-19 | Pike | Indiana | 18125 | 3163 | 46 |
2126155 | 2126155 | 2022-01-18 | Pike | Indiana | 18125 | 3114 | 46 |
2122903 | 2122903 | 2022-01-17 | Pike | Indiana | 18125 | 3090 | 46 |
2119651 | 2119651 | 2022-01-16 | Pike | Indiana | 18125 | 3021 | 46 |
2116399 | 2116399 | 2022-01-15 | Pike | Indiana | 18125 | 3021 | 46 |
2113148 | 2113148 | 2022-01-14 | Pike | Indiana | 18125 | 3021 | 46 |
2109896 | 2109896 | 2022-01-13 | Pike | Indiana | 18125 | 2992 | 46 |
2106645 | 2106645 | 2022-01-12 | Pike | Indiana | 18125 | 2951 | 46 |
2103394 | 2103394 | 2022-01-11 | Pike | Indiana | 18125 | 2917 | 46 |
2100143 | 2100143 | 2022-01-10 | Pike | Indiana | 18125 | 2904 | 46 |
2096892 | 2096892 | 2022-01-09 | Pike | Indiana | 18125 | 2856 | 46 |
2093640 | 2093640 | 2022-01-08 | Pike | Indiana | 18125 | 2856 | 46 |
2090388 | 2090388 | 2022-01-07 | Pike | Indiana | 18125 | 2856 | 46 |
2087137 | 2087137 | 2022-01-06 | Pike | Indiana | 18125 | 2836 | 46 |
2083885 | 2083885 | 2022-01-05 | Pike | Indiana | 18125 | 2823 | 46 |
2080633 | 2080633 | 2022-01-04 | Pike | Indiana | 18125 | 2805 | 46 |
2077381 | 2077381 | 2022-01-03 | Pike | Indiana | 18125 | 2798 | 46 |
2074130 | 2074130 | 2022-01-02 | Pike | Indiana | 18125 | 2776 | 46 |
2070879 | 2070879 | 2022-01-01 | Pike | Indiana | 18125 | 2776 | 46 |
2067628 | 2067628 | 2021-12-31 | Pike | Indiana | 18125 | 2776 | 46 |
2064377 | 2064377 | 2021-12-30 | Pike | Indiana | 18125 | 2776 | 46 |
2061127 | 2061127 | 2021-12-29 | Pike | Indiana | 18125 | 2762 | 46 |
2057878 | 2057878 | 2021-12-28 | Pike | Indiana | 18125 | 2750 | 46 |
2054629 | 2054629 | 2021-12-27 | Pike | Indiana | 18125 | 2748 | 46 |
2051379 | 2051379 | 2021-12-26 | Pike | Indiana | 18125 | 2723 | 46 |
2048129 | 2048129 | 2021-12-25 | Pike | Indiana | 18125 | 2723 | 46 |
2044879 | 2044879 | 2021-12-24 | Pike | Indiana | 18125 | 2723 | 46 |
2041630 | 2041630 | 2021-12-23 | Pike | Indiana | 18125 | 2723 | 46 |
2038380 | 2038380 | 2021-12-22 | Pike | Indiana | 18125 | 2723 | 46 |
2035130 | 2035130 | 2021-12-21 | Pike | Indiana | 18125 | 2717 | 46 |
2031880 | 2031880 | 2021-12-20 | Pike | Indiana | 18125 | 2708 | 46 |
2028629 | 2028629 | 2021-12-19 | Pike | Indiana | 18125 | 2680 | 46 |
2025378 | 2025378 | 2021-12-18 | Pike | Indiana | 18125 | 2680 | 46 |
2022127 | 2022127 | 2021-12-17 | Pike | Indiana | 18125 | 2680 | 46 |
2018876 | 2018876 | 2021-12-16 | Pike | Indiana | 18125 | 2657 | 46 |
2015626 | 2015626 | 2021-12-15 | Pike | Indiana | 18125 | 2645 | 46 |
2012375 | 2012375 | 2021-12-14 | Pike | Indiana | 18125 | 2634 | 46 |
2009124 | 2009124 | 2021-12-13 | Pike | Indiana | 18125 | 2618 | 46 |
2005873 | 2005873 | 2021-12-12 | Pike | Indiana | 18125 | 2587 | 46 |
2002622 | 2002622 | 2021-12-11 | Pike | Indiana | 18125 | 2587 | 46 |
1999372 | 1999372 | 2021-12-10 | Pike | Indiana | 18125 | 2587 | 46 |
1996121 | 1996121 | 2021-12-09 | Pike | Indiana | 18125 | 2566 | 46 |
1992870 | 1992870 | 2021-12-08 | Pike | Indiana | 18125 | 2544 | 46 |
1631937 | 1631937 | 2021-08-19 | Pike | Georgia | 13231 | 2750 | 46 |
1628690 | 1628690 | 2021-08-18 | Pike | Georgia | 13231 | 2729 | 46 |
1625443 | 1625443 | 2021-08-17 | Pike | Georgia | 13231 | 2702 | 46 |
1055819 | 1055819 | 2021-02-22 | Pike | Pennsylvania | 42103 | 2437 | 46 |
1052573 | 1052573 | 2021-02-21 | Pike | Pennsylvania | 42103 | 2436 | 46 |
1049326 | 1049326 | 2021-02-20 | Pike | Pennsylvania | 42103 | 2434 | 46 |
1046079 | 1046079 | 2021-02-19 | Pike | Pennsylvania | 42103 | 2412 | 46 |
1042834 | 1042834 | 2021-02-18 | Pike | Pennsylvania | 42103 | 2397 | 46 |
1039589 | 1039589 | 2021-02-17 | Pike | Pennsylvania | 42103 | 2382 | 46 |
1036344 | 1036344 | 2021-02-16 | Pike | Pennsylvania | 42103 | 2372 | 46 |
1033099 | 1033099 | 2021-02-15 | Pike | Pennsylvania | 42103 | 2363 | 46 |
1029853 | 1029853 | 2021-02-14 | Pike | Pennsylvania | 42103 | 2353 | 46 |
1026606 | 1026606 | 2021-02-13 | Pike | Pennsylvania | 42103 | 2351 | 46 |
992936 | 992936 | 2021-02-03 | Pike | Kentucky | 21195 | 4646 | 46 |
989690 | 989690 | 2021-02-02 | Pike | Kentucky | 21195 | 4620 | 46 |
986443 | 986443 | 2021-02-01 | Pike | Kentucky | 21195 | 4571 | 46 |
983196 | 983196 | 2021-01-31 | Pike | Kentucky | 21195 | 4549 | 46 |
979950 | 979950 | 2021-01-30 | Pike | Kentucky | 21195 | 4510 | 46 |
976704 | 976704 | 2021-01-29 | Pike | Kentucky | 21195 | 4441 | 46 |
947075 | 947075 | 2021-01-20 | Pike | Illinois | 17149 | 1559 | 46 |
943828 | 943828 | 2021-01-19 | Pike | Illinois | 17149 | 1543 | 46 |
940583 | 940583 | 2021-01-18 | Pike | Illinois | 17149 | 1542 | 46 |
937338 | 937338 | 2021-01-17 | Pike | Illinois | 17149 | 1539 | 46 |
934093 | 934093 | 2021-01-16 | Pike | Illinois | 17149 | 1538 | 46 |
519710 | 519710 | 2020-09-10 | Pike | Mississippi | 28113 | 1181 | 46 |
516475 | 516475 | 2020-09-09 | Pike | Mississippi | 28113 | 1180 | 46 |
513241 | 513241 | 2020-09-08 | Pike | Mississippi | 28113 | 1177 | 46 |
510009 | 510009 | 2020-09-07 | Pike | Mississippi | 28113 | 1171 | 46 |
506776 | 506776 | 2020-09-06 | Pike | Mississippi | 28113 | 1171 | 46 |
503543 | 503543 | 2020-09-05 | Pike | Mississippi | 28113 | 1167 | 46 |
500309 | 500309 | 2020-09-04 | Pike | Mississippi | 28113 | 1163 | 46 |
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);