ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,253 rows where county = "Beaver" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 3
- Pennsylvania 788
- Oklahoma 767
- Utah 698
county 1
- Beaver · 2,253 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501736 | 2501736 | 2022-05-13 | Beaver | Oklahoma | 40007 | 969 | 11 |
2501850 | 2501850 | 2022-05-13 | Beaver | Pennsylvania | 42007 | 40744 | 745 |
2502462 | 2502462 | 2022-05-13 | Beaver | Utah | 49001 | 1609 | 16 |
2498478 | 2498478 | 2022-05-12 | Beaver | Oklahoma | 40007 | 969 | 11 |
2498592 | 2498592 | 2022-05-12 | Beaver | Pennsylvania | 42007 | 40744 | 745 |
2499204 | 2499204 | 2022-05-12 | Beaver | Utah | 49001 | 1609 | 16 |
2495220 | 2495220 | 2022-05-11 | Beaver | Oklahoma | 40007 | 968 | 11 |
2495334 | 2495334 | 2022-05-11 | Beaver | Pennsylvania | 42007 | 40744 | 745 |
2495946 | 2495946 | 2022-05-11 | Beaver | Utah | 49001 | 1609 | 16 |
2491962 | 2491962 | 2022-05-10 | Beaver | Oklahoma | 40007 | 968 | 11 |
2492076 | 2492076 | 2022-05-10 | Beaver | Pennsylvania | 42007 | 40525 | 743 |
2492688 | 2492688 | 2022-05-10 | Beaver | Utah | 49001 | 1609 | 16 |
2488704 | 2488704 | 2022-05-09 | Beaver | Oklahoma | 40007 | 968 | 11 |
2488818 | 2488818 | 2022-05-09 | Beaver | Pennsylvania | 42007 | 40525 | 743 |
2489430 | 2489430 | 2022-05-09 | Beaver | Utah | 49001 | 1609 | 16 |
2485447 | 2485447 | 2022-05-08 | Beaver | Oklahoma | 40007 | 968 | 11 |
2485561 | 2485561 | 2022-05-08 | Beaver | Pennsylvania | 42007 | 40525 | 743 |
2486172 | 2486172 | 2022-05-08 | Beaver | Utah | 49001 | 1609 | 16 |
2482189 | 2482189 | 2022-05-07 | Beaver | Oklahoma | 40007 | 968 | 11 |
2482303 | 2482303 | 2022-05-07 | Beaver | Pennsylvania | 42007 | 40525 | 743 |
2482914 | 2482914 | 2022-05-07 | Beaver | Utah | 49001 | 1609 | 16 |
2478931 | 2478931 | 2022-05-06 | Beaver | Oklahoma | 40007 | 968 | 11 |
2479045 | 2479045 | 2022-05-06 | Beaver | Pennsylvania | 42007 | 40525 | 743 |
2479656 | 2479656 | 2022-05-06 | Beaver | Utah | 49001 | 1609 | 16 |
2475673 | 2475673 | 2022-05-05 | Beaver | Oklahoma | 40007 | 968 | 11 |
2475787 | 2475787 | 2022-05-05 | Beaver | Pennsylvania | 42007 | 40525 | 743 |
2476398 | 2476398 | 2022-05-05 | Beaver | Utah | 49001 | 1609 | 16 |
2472416 | 2472416 | 2022-05-04 | Beaver | Oklahoma | 40007 | 968 | 11 |
2472530 | 2472530 | 2022-05-04 | Beaver | Pennsylvania | 42007 | 40525 | 743 |
2473141 | 2473141 | 2022-05-04 | Beaver | Utah | 49001 | 1609 | 16 |
2469160 | 2469160 | 2022-05-03 | Beaver | Oklahoma | 40007 | 968 | 11 |
2469274 | 2469274 | 2022-05-03 | Beaver | Pennsylvania | 42007 | 40505 | 742 |
2469885 | 2469885 | 2022-05-03 | Beaver | Utah | 49001 | 1609 | 16 |
2465904 | 2465904 | 2022-05-02 | Beaver | Oklahoma | 40007 | 968 | 11 |
2466018 | 2466018 | 2022-05-02 | Beaver | Pennsylvania | 42007 | 40474 | 741 |
2466629 | 2466629 | 2022-05-02 | Beaver | Utah | 49001 | 1609 | 16 |
2462649 | 2462649 | 2022-05-01 | Beaver | Oklahoma | 40007 | 968 | 11 |
2462763 | 2462763 | 2022-05-01 | Beaver | Pennsylvania | 42007 | 40465 | 741 |
2463374 | 2463374 | 2022-05-01 | Beaver | Utah | 49001 | 1603 | 16 |
2459393 | 2459393 | 2022-04-30 | Beaver | Oklahoma | 40007 | 968 | 11 |
2459507 | 2459507 | 2022-04-30 | Beaver | Pennsylvania | 42007 | 40453 | 741 |
2460118 | 2460118 | 2022-04-30 | Beaver | Utah | 49001 | 1603 | 16 |
2456137 | 2456137 | 2022-04-29 | Beaver | Oklahoma | 40007 | 968 | 11 |
2456251 | 2456251 | 2022-04-29 | Beaver | Pennsylvania | 42007 | 40423 | 741 |
2456862 | 2456862 | 2022-04-29 | Beaver | Utah | 49001 | 1603 | 16 |
2452881 | 2452881 | 2022-04-28 | Beaver | Oklahoma | 40007 | 968 | 11 |
2452995 | 2452995 | 2022-04-28 | Beaver | Pennsylvania | 42007 | 40394 | 742 |
2453606 | 2453606 | 2022-04-28 | Beaver | Utah | 49001 | 1603 | 16 |
2449625 | 2449625 | 2022-04-27 | Beaver | Oklahoma | 40007 | 968 | 11 |
2449739 | 2449739 | 2022-04-27 | Beaver | Pennsylvania | 42007 | 40370 | 742 |
2450350 | 2450350 | 2022-04-27 | Beaver | Utah | 49001 | 1604 | 16 |
2446368 | 2446368 | 2022-04-26 | Beaver | Oklahoma | 40007 | 968 | 11 |
2446482 | 2446482 | 2022-04-26 | Beaver | Pennsylvania | 42007 | 40338 | 742 |
2447093 | 2447093 | 2022-04-26 | Beaver | Utah | 49001 | 1604 | 16 |
2443113 | 2443113 | 2022-04-25 | Beaver | Oklahoma | 40007 | 968 | 11 |
2443227 | 2443227 | 2022-04-25 | Beaver | Pennsylvania | 42007 | 40313 | 742 |
2443838 | 2443838 | 2022-04-25 | Beaver | Utah | 49001 | 1604 | 16 |
2439857 | 2439857 | 2022-04-24 | Beaver | Oklahoma | 40007 | 968 | 11 |
2439971 | 2439971 | 2022-04-24 | Beaver | Pennsylvania | 42007 | 40307 | 742 |
2440582 | 2440582 | 2022-04-24 | Beaver | Utah | 49001 | 1604 | 16 |
2436601 | 2436601 | 2022-04-23 | Beaver | Oklahoma | 40007 | 968 | 11 |
2436715 | 2436715 | 2022-04-23 | Beaver | Pennsylvania | 42007 | 40302 | 742 |
2437326 | 2437326 | 2022-04-23 | Beaver | Utah | 49001 | 1604 | 16 |
2433345 | 2433345 | 2022-04-22 | Beaver | Oklahoma | 40007 | 968 | 11 |
2433459 | 2433459 | 2022-04-22 | Beaver | Pennsylvania | 42007 | 40290 | 742 |
2434070 | 2434070 | 2022-04-22 | Beaver | Utah | 49001 | 1604 | 16 |
2430089 | 2430089 | 2022-04-21 | Beaver | Oklahoma | 40007 | 968 | 11 |
2430203 | 2430203 | 2022-04-21 | Beaver | Pennsylvania | 42007 | 40270 | 741 |
2430814 | 2430814 | 2022-04-21 | Beaver | Utah | 49001 | 1604 | 16 |
2426833 | 2426833 | 2022-04-20 | Beaver | Oklahoma | 40007 | 967 | 11 |
2426947 | 2426947 | 2022-04-20 | Beaver | Pennsylvania | 42007 | 40252 | 740 |
2427558 | 2427558 | 2022-04-20 | Beaver | Utah | 49001 | 1604 | 16 |
2423577 | 2423577 | 2022-04-19 | Beaver | Oklahoma | 40007 | 967 | 11 |
2423691 | 2423691 | 2022-04-19 | Beaver | Pennsylvania | 42007 | 40227 | 740 |
2424302 | 2424302 | 2022-04-19 | Beaver | Utah | 49001 | 1604 | 16 |
2420320 | 2420320 | 2022-04-18 | Beaver | Oklahoma | 40007 | 967 | 11 |
2420435 | 2420435 | 2022-04-18 | Beaver | Pennsylvania | 42007 | 40218 | 739 |
2421046 | 2421046 | 2022-04-18 | Beaver | Utah | 49001 | 1603 | 16 |
2417065 | 2417065 | 2022-04-17 | Beaver | Oklahoma | 40007 | 967 | 11 |
2417179 | 2417179 | 2022-04-17 | Beaver | Pennsylvania | 42007 | 40210 | 739 |
2417790 | 2417790 | 2022-04-17 | Beaver | Utah | 49001 | 1603 | 16 |
2413809 | 2413809 | 2022-04-16 | Beaver | Oklahoma | 40007 | 967 | 11 |
2413923 | 2413923 | 2022-04-16 | Beaver | Pennsylvania | 42007 | 40204 | 739 |
2414534 | 2414534 | 2022-04-16 | Beaver | Utah | 49001 | 1603 | 16 |
2410553 | 2410553 | 2022-04-15 | Beaver | Oklahoma | 40007 | 967 | 11 |
2410667 | 2410667 | 2022-04-15 | Beaver | Pennsylvania | 42007 | 40192 | 739 |
2411278 | 2411278 | 2022-04-15 | Beaver | Utah | 49001 | 1603 | 16 |
2407297 | 2407297 | 2022-04-14 | Beaver | Oklahoma | 40007 | 967 | 11 |
2407411 | 2407411 | 2022-04-14 | Beaver | Pennsylvania | 42007 | 40181 | 739 |
2408022 | 2408022 | 2022-04-14 | Beaver | Utah | 49001 | 1603 | 16 |
2404041 | 2404041 | 2022-04-13 | Beaver | Oklahoma | 40007 | 966 | 11 |
2404155 | 2404155 | 2022-04-13 | Beaver | Pennsylvania | 42007 | 40171 | 738 |
2404766 | 2404766 | 2022-04-13 | Beaver | Utah | 49001 | 1603 | 16 |
2400786 | 2400786 | 2022-04-12 | Beaver | Oklahoma | 40007 | 966 | 11 |
2400900 | 2400900 | 2022-04-12 | Beaver | Pennsylvania | 42007 | 40163 | 738 |
2401511 | 2401511 | 2022-04-12 | Beaver | Utah | 49001 | 1603 | 16 |
2397531 | 2397531 | 2022-04-11 | Beaver | Oklahoma | 40007 | 966 | 11 |
2397645 | 2397645 | 2022-04-11 | Beaver | Pennsylvania | 42007 | 40146 | 737 |
2398256 | 2398256 | 2022-04-11 | Beaver | Utah | 49001 | 1603 | 16 |
2394276 | 2394276 | 2022-04-10 | Beaver | Oklahoma | 40007 | 966 | 11 |
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);