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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 10
- Pennsylvania 783
- Mississippi 775
- Arkansas 771
- Alabama 770
- Georgia 767
- Ohio 767
- Missouri 765
- Illinois 760
- Kentucky 759
- Indiana 752
fips 10
county 1
- Pike · 7,669 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467053 | 2467053 | 2022-05-03 | Pike | Alabama | 1109 | 7579 | 134 |
2467164 | 2467164 | 2022-05-03 | Pike | Arkansas | 5109 | 2618 | 44 |
2467503 | 2467503 | 2022-05-03 | Pike | Georgia | 13231 | 5461 | 97 |
2467675 | 2467675 | 2022-05-03 | Pike | Illinois | 17149 | 5038 | 70 |
2467766 | 2467766 | 2022-05-03 | Pike | Indiana | 18125 | 3738 | 49 |
2468100 | 2468100 | 2022-05-03 | Pike | Kentucky | 21195 | 19051 | 301 |
2468473 | 2468473 | 2022-05-03 | Pike | Mississippi | 28113 | 9747 | 189 |
2468583 | 2468583 | 2022-05-03 | Pike | Missouri | 29163 | 4238 | 63 |
2469133 | 2469133 | 2022-05-03 | Pike | Ohio | 39131 | 7466 | 122 |
2469322 | 2469322 | 2022-05-03 | Pike | Pennsylvania | 42103 | 10443 | 96 |
2463798 | 2463798 | 2022-05-02 | Pike | Alabama | 1109 | 7579 | 134 |
2463909 | 2463909 | 2022-05-02 | Pike | Arkansas | 5109 | 2618 | 44 |
2464248 | 2464248 | 2022-05-02 | Pike | Georgia | 13231 | 5461 | 97 |
2464420 | 2464420 | 2022-05-02 | Pike | Illinois | 17149 | 5038 | 70 |
2464511 | 2464511 | 2022-05-02 | Pike | Indiana | 18125 | 3738 | 49 |
2464845 | 2464845 | 2022-05-02 | Pike | Kentucky | 21195 | 19051 | 301 |
2465218 | 2465218 | 2022-05-02 | Pike | Mississippi | 28113 | 9747 | 189 |
2465327 | 2465327 | 2022-05-02 | Pike | Missouri | 29163 | 4238 | 63 |
2465877 | 2465877 | 2022-05-02 | Pike | Ohio | 39131 | 7466 | 122 |
2466066 | 2466066 | 2022-05-02 | Pike | Pennsylvania | 42103 | 10426 | 96 |
2460542 | 2460542 | 2022-05-01 | Pike | Alabama | 1109 | 7576 | 134 |
2460653 | 2460653 | 2022-05-01 | Pike | Arkansas | 5109 | 2618 | 44 |
2460992 | 2460992 | 2022-05-01 | Pike | Georgia | 13231 | 5461 | 97 |
2461164 | 2461164 | 2022-05-01 | Pike | Illinois | 17149 | 5038 | 70 |
2461255 | 2461255 | 2022-05-01 | Pike | Indiana | 18125 | 3735 | 49 |
2461589 | 2461589 | 2022-05-01 | Pike | Kentucky | 21195 | 19001 | 298 |
2461962 | 2461962 | 2022-05-01 | Pike | Mississippi | 28113 | 9741 | 189 |
2462072 | 2462072 | 2022-05-01 | Pike | Missouri | 29163 | 4238 | 63 |
2462622 | 2462622 | 2022-05-01 | Pike | Ohio | 39131 | 7466 | 122 |
2462811 | 2462811 | 2022-05-01 | Pike | Pennsylvania | 42103 | 10420 | 96 |
2457286 | 2457286 | 2022-04-30 | Pike | Alabama | 1109 | 7576 | 134 |
2457397 | 2457397 | 2022-04-30 | Pike | Arkansas | 5109 | 2617 | 44 |
2457736 | 2457736 | 2022-04-30 | Pike | Georgia | 13231 | 5461 | 97 |
2457908 | 2457908 | 2022-04-30 | Pike | Illinois | 17149 | 5038 | 70 |
2457999 | 2457999 | 2022-04-30 | Pike | Indiana | 18125 | 3735 | 49 |
2458333 | 2458333 | 2022-04-30 | Pike | Kentucky | 21195 | 19001 | 298 |
2458706 | 2458706 | 2022-04-30 | Pike | Mississippi | 28113 | 9741 | 189 |
2458816 | 2458816 | 2022-04-30 | Pike | Missouri | 29163 | 4238 | 63 |
2459366 | 2459366 | 2022-04-30 | Pike | Ohio | 39131 | 7466 | 122 |
2459555 | 2459555 | 2022-04-30 | Pike | Pennsylvania | 42103 | 10410 | 96 |
2454030 | 2454030 | 2022-04-29 | Pike | Alabama | 1109 | 7576 | 134 |
2454141 | 2454141 | 2022-04-29 | Pike | Arkansas | 5109 | 2618 | 44 |
2454480 | 2454480 | 2022-04-29 | Pike | Georgia | 13231 | 5461 | 97 |
2454652 | 2454652 | 2022-04-29 | Pike | Illinois | 17149 | 5038 | 70 |
2454743 | 2454743 | 2022-04-29 | Pike | Indiana | 18125 | 3735 | 49 |
2455077 | 2455077 | 2022-04-29 | Pike | Kentucky | 21195 | 19001 | 298 |
2455450 | 2455450 | 2022-04-29 | Pike | Mississippi | 28113 | 9741 | 189 |
2455560 | 2455560 | 2022-04-29 | Pike | Missouri | 29163 | 4238 | 63 |
2456110 | 2456110 | 2022-04-29 | Pike | Ohio | 39131 | 7466 | 122 |
2456299 | 2456299 | 2022-04-29 | Pike | Pennsylvania | 42103 | 10392 | 96 |
2450774 | 2450774 | 2022-04-28 | Pike | Alabama | 1109 | 7566 | 134 |
2450885 | 2450885 | 2022-04-28 | Pike | Arkansas | 5109 | 2618 | 44 |
2451224 | 2451224 | 2022-04-28 | Pike | Georgia | 13231 | 5461 | 97 |
2451396 | 2451396 | 2022-04-28 | Pike | Illinois | 17149 | 5038 | 70 |
2451487 | 2451487 | 2022-04-28 | Pike | Indiana | 18125 | 3733 | 49 |
2451821 | 2451821 | 2022-04-28 | Pike | Kentucky | 21195 | 19001 | 298 |
2452194 | 2452194 | 2022-04-28 | Pike | Mississippi | 28113 | 9741 | 189 |
2452304 | 2452304 | 2022-04-28 | Pike | Missouri | 29163 | 4238 | 63 |
2452854 | 2452854 | 2022-04-28 | Pike | Ohio | 39131 | 7466 | 122 |
2453043 | 2453043 | 2022-04-28 | Pike | Pennsylvania | 42103 | 10371 | 96 |
2447518 | 2447518 | 2022-04-27 | Pike | Alabama | 1109 | 7561 | 134 |
2447629 | 2447629 | 2022-04-27 | Pike | Arkansas | 5109 | 2618 | 44 |
2447968 | 2447968 | 2022-04-27 | Pike | Georgia | 13231 | 5461 | 97 |
2448140 | 2448140 | 2022-04-27 | Pike | Illinois | 17149 | 5038 | 70 |
2448231 | 2448231 | 2022-04-27 | Pike | Indiana | 18125 | 3733 | 49 |
2448565 | 2448565 | 2022-04-27 | Pike | Kentucky | 21195 | 19001 | 298 |
2448938 | 2448938 | 2022-04-27 | Pike | Mississippi | 28113 | 9741 | 189 |
2449048 | 2449048 | 2022-04-27 | Pike | Missouri | 29163 | 4238 | 63 |
2449598 | 2449598 | 2022-04-27 | Pike | Ohio | 39131 | 7459 | 121 |
2449787 | 2449787 | 2022-04-27 | Pike | Pennsylvania | 42103 | 10354 | 96 |
2444262 | 2444262 | 2022-04-26 | Pike | Alabama | 1109 | 7556 | 134 |
2444373 | 2444373 | 2022-04-26 | Pike | Arkansas | 5109 | 2618 | 44 |
2444712 | 2444712 | 2022-04-26 | Pike | Georgia | 13231 | 5459 | 97 |
2444884 | 2444884 | 2022-04-26 | Pike | Illinois | 17149 | 5038 | 70 |
2444975 | 2444975 | 2022-04-26 | Pike | Indiana | 18125 | 3730 | 49 |
2445309 | 2445309 | 2022-04-26 | Pike | Kentucky | 21195 | 19001 | 298 |
2445682 | 2445682 | 2022-04-26 | Pike | Mississippi | 28113 | 9741 | 189 |
2445791 | 2445791 | 2022-04-26 | Pike | Missouri | 29163 | 4238 | 63 |
2446341 | 2446341 | 2022-04-26 | Pike | Ohio | 39131 | 7459 | 121 |
2446530 | 2446530 | 2022-04-26 | Pike | Pennsylvania | 42103 | 10344 | 96 |
2441006 | 2441006 | 2022-04-25 | Pike | Alabama | 1109 | 7550 | 134 |
2441117 | 2441117 | 2022-04-25 | Pike | Arkansas | 5109 | 2618 | 44 |
2441456 | 2441456 | 2022-04-25 | Pike | Georgia | 13231 | 5459 | 97 |
2441628 | 2441628 | 2022-04-25 | Pike | Illinois | 17149 | 5038 | 70 |
2441719 | 2441719 | 2022-04-25 | Pike | Indiana | 18125 | 3730 | 49 |
2442053 | 2442053 | 2022-04-25 | Pike | Kentucky | 21195 | 19001 | 298 |
2442426 | 2442426 | 2022-04-25 | Pike | Mississippi | 28113 | 9736 | 189 |
2442536 | 2442536 | 2022-04-25 | Pike | Missouri | 29163 | 4238 | 63 |
2443086 | 2443086 | 2022-04-25 | Pike | Ohio | 39131 | 7459 | 121 |
2443275 | 2443275 | 2022-04-25 | Pike | Pennsylvania | 42103 | 10338 | 96 |
2437750 | 2437750 | 2022-04-24 | Pike | Alabama | 1109 | 7529 | 134 |
2437861 | 2437861 | 2022-04-24 | Pike | Arkansas | 5109 | 2616 | 44 |
2438200 | 2438200 | 2022-04-24 | Pike | Georgia | 13231 | 5459 | 97 |
2438372 | 2438372 | 2022-04-24 | Pike | Illinois | 17149 | 5034 | 70 |
2438463 | 2438463 | 2022-04-24 | Pike | Indiana | 18125 | 3729 | 49 |
2438797 | 2438797 | 2022-04-24 | Pike | Kentucky | 21195 | 18979 | 295 |
2439170 | 2439170 | 2022-04-24 | Pike | Mississippi | 28113 | 9736 | 189 |
2439280 | 2439280 | 2022-04-24 | Pike | Missouri | 29163 | 4238 | 63 |
2439830 | 2439830 | 2022-04-24 | Pike | Ohio | 39131 | 7459 | 121 |
2440019 | 2440019 | 2022-04-24 | Pike | Pennsylvania | 42103 | 10324 | 96 |
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);