ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
7,769 rows where county = "Pike" sorted by rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 10
- Pennsylvania 793
- Mississippi 785
- Arkansas 781
- Alabama 780
- Georgia 777
- Ohio 777
- Missouri 775
- Illinois 770
- Kentucky 769
- Indiana 762
fips 10
county 1
- Pike · 7,769 ✖
Link | rowid ▲ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501898 | 2501898 | 2022-05-13 | Pike | Pennsylvania | 42103 | 10557 | 98 |
2501709 | 2501709 | 2022-05-13 | Pike | Ohio | 39131 | 7493 | 123 |
2501159 | 2501159 | 2022-05-13 | Pike | Missouri | 29163 | 4264 | 63 |
2501049 | 2501049 | 2022-05-13 | Pike | Mississippi | 28113 | 9751 | 189 |
2500676 | 2500676 | 2022-05-13 | Pike | Kentucky | 21195 | 19099 | 307 |
2500342 | 2500342 | 2022-05-13 | Pike | Indiana | 18125 | 3761 | 49 |
2500251 | 2500251 | 2022-05-13 | Pike | Illinois | 17149 | 5050 | 70 |
2500079 | 2500079 | 2022-05-13 | Pike | Georgia | 13231 | 5473 | 98 |
2499740 | 2499740 | 2022-05-13 | Pike | Arkansas | 5109 | 2617 | 44 |
2499629 | 2499629 | 2022-05-13 | Pike | Alabama | 1109 | 7590 | 134 |
2498640 | 2498640 | 2022-05-12 | Pike | Pennsylvania | 42103 | 10557 | 98 |
2498451 | 2498451 | 2022-05-12 | Pike | Ohio | 39131 | 7493 | 123 |
2497901 | 2497901 | 2022-05-12 | Pike | Missouri | 29163 | 4263 | 63 |
2497791 | 2497791 | 2022-05-12 | Pike | Mississippi | 28113 | 9751 | 189 |
2497418 | 2497418 | 2022-05-12 | Pike | Kentucky | 21195 | 19099 | 307 |
2497084 | 2497084 | 2022-05-12 | Pike | Indiana | 18125 | 3752 | 49 |
2496993 | 2496993 | 2022-05-12 | Pike | Illinois | 17149 | 5047 | 70 |
2496821 | 2496821 | 2022-05-12 | Pike | Georgia | 13231 | 5473 | 98 |
2496482 | 2496482 | 2022-05-12 | Pike | Arkansas | 5109 | 2617 | 44 |
2496371 | 2496371 | 2022-05-12 | Pike | Alabama | 1109 | 7587 | 134 |
2495382 | 2495382 | 2022-05-11 | Pike | Pennsylvania | 42103 | 10557 | 98 |
2495193 | 2495193 | 2022-05-11 | Pike | Ohio | 39131 | 7476 | 123 |
2494643 | 2494643 | 2022-05-11 | Pike | Missouri | 29163 | 4263 | 63 |
2494533 | 2494533 | 2022-05-11 | Pike | Mississippi | 28113 | 9751 | 189 |
2494160 | 2494160 | 2022-05-11 | Pike | Kentucky | 21195 | 19099 | 307 |
2493826 | 2493826 | 2022-05-11 | Pike | Indiana | 18125 | 3752 | 49 |
2493735 | 2493735 | 2022-05-11 | Pike | Illinois | 17149 | 5044 | 70 |
2493563 | 2493563 | 2022-05-11 | Pike | Georgia | 13231 | 5473 | 98 |
2493224 | 2493224 | 2022-05-11 | Pike | Arkansas | 5109 | 2617 | 44 |
2493113 | 2493113 | 2022-05-11 | Pike | Alabama | 1109 | 7583 | 134 |
2492124 | 2492124 | 2022-05-10 | Pike | Pennsylvania | 42103 | 10453 | 96 |
2491935 | 2491935 | 2022-05-10 | Pike | Ohio | 39131 | 7476 | 123 |
2491385 | 2491385 | 2022-05-10 | Pike | Missouri | 29163 | 4263 | 63 |
2491275 | 2491275 | 2022-05-10 | Pike | Mississippi | 28113 | 9751 | 189 |
2490902 | 2490902 | 2022-05-10 | Pike | Kentucky | 21195 | 19099 | 307 |
2490568 | 2490568 | 2022-05-10 | Pike | Indiana | 18125 | 3747 | 49 |
2490477 | 2490477 | 2022-05-10 | Pike | Illinois | 17149 | 5045 | 70 |
2490305 | 2490305 | 2022-05-10 | Pike | Georgia | 13231 | 5466 | 98 |
2489966 | 2489966 | 2022-05-10 | Pike | Arkansas | 5109 | 2617 | 44 |
2489855 | 2489855 | 2022-05-10 | Pike | Alabama | 1109 | 7582 | 134 |
2488866 | 2488866 | 2022-05-09 | Pike | Pennsylvania | 42103 | 10453 | 96 |
2488677 | 2488677 | 2022-05-09 | Pike | Ohio | 39131 | 7476 | 123 |
2488127 | 2488127 | 2022-05-09 | Pike | Missouri | 29163 | 4263 | 63 |
2488018 | 2488018 | 2022-05-09 | Pike | Mississippi | 28113 | 9751 | 189 |
2487645 | 2487645 | 2022-05-09 | Pike | Kentucky | 21195 | 19099 | 307 |
2487311 | 2487311 | 2022-05-09 | Pike | Indiana | 18125 | 3747 | 49 |
2487220 | 2487220 | 2022-05-09 | Pike | Illinois | 17149 | 5044 | 70 |
2487048 | 2487048 | 2022-05-09 | Pike | Georgia | 13231 | 5466 | 98 |
2486709 | 2486709 | 2022-05-09 | Pike | Arkansas | 5109 | 2617 | 44 |
2486598 | 2486598 | 2022-05-09 | Pike | Alabama | 1109 | 7580 | 134 |
2485609 | 2485609 | 2022-05-08 | Pike | Pennsylvania | 42103 | 10453 | 96 |
2485420 | 2485420 | 2022-05-08 | Pike | Ohio | 39131 | 7476 | 123 |
2484870 | 2484870 | 2022-05-08 | Pike | Missouri | 29163 | 4263 | 63 |
2484760 | 2484760 | 2022-05-08 | Pike | Mississippi | 28113 | 9747 | 189 |
2484387 | 2484387 | 2022-05-08 | Pike | Kentucky | 21195 | 19051 | 301 |
2484053 | 2484053 | 2022-05-08 | Pike | Indiana | 18125 | 3743 | 49 |
2483962 | 2483962 | 2022-05-08 | Pike | Illinois | 17149 | 5042 | 70 |
2483790 | 2483790 | 2022-05-08 | Pike | Georgia | 13231 | 5465 | 98 |
2483451 | 2483451 | 2022-05-08 | Pike | Arkansas | 5109 | 2617 | 44 |
2483340 | 2483340 | 2022-05-08 | Pike | Alabama | 1109 | 7580 | 134 |
2482351 | 2482351 | 2022-05-07 | Pike | Pennsylvania | 42103 | 10453 | 96 |
2482162 | 2482162 | 2022-05-07 | Pike | Ohio | 39131 | 7476 | 123 |
2481612 | 2481612 | 2022-05-07 | Pike | Missouri | 29163 | 4263 | 63 |
2481502 | 2481502 | 2022-05-07 | Pike | Mississippi | 28113 | 9747 | 189 |
2481129 | 2481129 | 2022-05-07 | Pike | Kentucky | 21195 | 19051 | 301 |
2480795 | 2480795 | 2022-05-07 | Pike | Indiana | 18125 | 3743 | 49 |
2480704 | 2480704 | 2022-05-07 | Pike | Illinois | 17149 | 5042 | 70 |
2480532 | 2480532 | 2022-05-07 | Pike | Georgia | 13231 | 5465 | 98 |
2480193 | 2480193 | 2022-05-07 | Pike | Arkansas | 5109 | 2617 | 44 |
2480082 | 2480082 | 2022-05-07 | Pike | Alabama | 1109 | 7580 | 134 |
2479093 | 2479093 | 2022-05-06 | Pike | Pennsylvania | 42103 | 10453 | 96 |
2478904 | 2478904 | 2022-05-06 | Pike | Ohio | 39131 | 7476 | 123 |
2478354 | 2478354 | 2022-05-06 | Pike | Missouri | 29163 | 4263 | 63 |
2478244 | 2478244 | 2022-05-06 | Pike | Mississippi | 28113 | 9747 | 189 |
2477871 | 2477871 | 2022-05-06 | Pike | Kentucky | 21195 | 19051 | 301 |
2477537 | 2477537 | 2022-05-06 | Pike | Indiana | 18125 | 3743 | 49 |
2477446 | 2477446 | 2022-05-06 | Pike | Illinois | 17149 | 5042 | 70 |
2477274 | 2477274 | 2022-05-06 | Pike | Georgia | 13231 | 5465 | 98 |
2476935 | 2476935 | 2022-05-06 | Pike | Arkansas | 5109 | 2617 | 44 |
2476824 | 2476824 | 2022-05-06 | Pike | Alabama | 1109 | 7580 | 134 |
2475835 | 2475835 | 2022-05-05 | Pike | Pennsylvania | 42103 | 10453 | 96 |
2475646 | 2475646 | 2022-05-05 | Pike | Ohio | 39131 | 7476 | 123 |
2475096 | 2475096 | 2022-05-05 | Pike | Missouri | 29163 | 4252 | 63 |
2474986 | 2474986 | 2022-05-05 | Pike | Mississippi | 28113 | 9747 | 189 |
2474613 | 2474613 | 2022-05-05 | Pike | Kentucky | 21195 | 19051 | 301 |
2474279 | 2474279 | 2022-05-05 | Pike | Indiana | 18125 | 3743 | 49 |
2474188 | 2474188 | 2022-05-05 | Pike | Illinois | 17149 | 5042 | 70 |
2474016 | 2474016 | 2022-05-05 | Pike | Georgia | 13231 | 5465 | 98 |
2473677 | 2473677 | 2022-05-05 | Pike | Arkansas | 5109 | 2617 | 44 |
2473566 | 2473566 | 2022-05-05 | Pike | Alabama | 1109 | 7580 | 134 |
2472578 | 2472578 | 2022-05-04 | Pike | Pennsylvania | 42103 | 10453 | 96 |
2472389 | 2472389 | 2022-05-04 | Pike | Ohio | 39131 | 7466 | 122 |
2471839 | 2471839 | 2022-05-04 | Pike | Missouri | 29163 | 4238 | 63 |
2471729 | 2471729 | 2022-05-04 | Pike | Mississippi | 28113 | 9747 | 189 |
2471356 | 2471356 | 2022-05-04 | Pike | Kentucky | 21195 | 19051 | 301 |
2471022 | 2471022 | 2022-05-04 | Pike | Indiana | 18125 | 3743 | 49 |
2470931 | 2470931 | 2022-05-04 | Pike | Illinois | 17149 | 5041 | 70 |
2470759 | 2470759 | 2022-05-04 | Pike | Georgia | 13231 | 5465 | 98 |
2470420 | 2470420 | 2022-05-04 | Pike | Arkansas | 5109 | 2618 | 44 |
2470309 | 2470309 | 2022-05-04 | Pike | Alabama | 1109 | 7580 | 134 |
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);