ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

789 rows where county = "York" and state = "Virginia" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Virginia · 789 ✖

fips 1

county 1

  • York · 789 ✖
Link rowid date ▲ county state fips cases deaths
2502642 2502642 2022-05-13 York Virginia 51199 10189 109
2499384 2499384 2022-05-12 York Virginia 51199 10170 109
2496126 2496126 2022-05-11 York Virginia 51199 10142 109
2492868 2492868 2022-05-10 York Virginia 51199 10121 109
2489610 2489610 2022-05-09 York Virginia 51199 10091 109
2486353 2486353 2022-05-08 York Virginia 51199 10048 109
2483095 2483095 2022-05-07 York Virginia 51199 10048 109
2479837 2479837 2022-05-06 York Virginia 51199 10048 109
2476579 2476579 2022-05-05 York Virginia 51199 10036 109
2473321 2473321 2022-05-04 York Virginia 51199 10032 109
2470065 2470065 2022-05-03 York Virginia 51199 9997 109
2466809 2466809 2022-05-02 York Virginia 51199 9975 109
2463554 2463554 2022-05-01 York Virginia 51199 9956 109
2460298 2460298 2022-04-30 York Virginia 51199 9956 109
2457042 2457042 2022-04-29 York Virginia 51199 9956 109
2453786 2453786 2022-04-28 York Virginia 51199 9949 109
2450530 2450530 2022-04-27 York Virginia 51199 9931 109
2447274 2447274 2022-04-26 York Virginia 51199 9922 108
2444018 2444018 2022-04-25 York Virginia 51199 9908 108
2440762 2440762 2022-04-24 York Virginia 51199 9894 108
2437506 2437506 2022-04-23 York Virginia 51199 9894 108
2434250 2434250 2022-04-22 York Virginia 51199 9894 108
2430994 2430994 2022-04-21 York Virginia 51199 9886 108
2427738 2427738 2022-04-20 York Virginia 51199 9881 108
2424482 2424482 2022-04-19 York Virginia 51199 9872 108
2421226 2421226 2022-04-18 York Virginia 51199 9862 107
2417970 2417970 2022-04-17 York Virginia 51199 9845 106
2414714 2414714 2022-04-16 York Virginia 51199 9845 106
2411458 2411458 2022-04-15 York Virginia 51199 9845 106
2408202 2408202 2022-04-14 York Virginia 51199 9837 106
2404946 2404946 2022-04-13 York Virginia 51199 9824 105
2401691 2401691 2022-04-12 York Virginia 51199 9815 105
2398436 2398436 2022-04-11 York Virginia 51199 9812 105
2395181 2395181 2022-04-10 York Virginia 51199 9801 105
2391925 2391925 2022-04-09 York Virginia 51199 9801 105
2388669 2388669 2022-04-08 York Virginia 51199 9801 105
2385414 2385414 2022-04-07 York Virginia 51199 9796 105
2382159 2382159 2022-04-06 York Virginia 51199 9790 105
2378904 2378904 2022-04-05 York Virginia 51199 9781 105
2375650 2375650 2022-04-04 York Virginia 51199 9778 105
2372398 2372398 2022-04-03 York Virginia 51199 9770 105
2369145 2369145 2022-04-02 York Virginia 51199 9770 105
2365892 2365892 2022-04-01 York Virginia 51199 9770 105
2362639 2362639 2022-03-31 York Virginia 51199 9765 105
2359385 2359385 2022-03-30 York Virginia 51199 9764 105
2356131 2356131 2022-03-29 York Virginia 51199 9757 105
2352878 2352878 2022-03-28 York Virginia 51199 9758 105
2349626 2349626 2022-03-27 York Virginia 51199 9745 105
2346373 2346373 2022-03-26 York Virginia 51199 9745 105
2343120 2343120 2022-03-25 York Virginia 51199 9745 105
2339867 2339867 2022-03-24 York Virginia 51199 9744 105
2336614 2336614 2022-03-23 York Virginia 51199 9741 104
2333360 2333360 2022-03-22 York Virginia 51199 9734 104
2330106 2330106 2022-03-21 York Virginia 51199 9734 104
2326854 2326854 2022-03-20 York Virginia 51199 9728 104
2323601 2323601 2022-03-19 York Virginia 51199 9728 104
2320347 2320347 2022-03-18 York Virginia 51199 9728 104
2317093 2317093 2022-03-17 York Virginia 51199 9726 104
2313840 2313840 2022-03-16 York Virginia 51199 9723 104
2310587 2310587 2022-03-15 York Virginia 51199 9714 104
2307334 2307334 2022-03-14 York Virginia 51199 9701 104
2304083 2304083 2022-03-13 York Virginia 51199 9685 104
2300831 2300831 2022-03-12 York Virginia 51199 9685 104
2297579 2297579 2022-03-11 York Virginia 51199 9685 104
2294327 2294327 2022-03-10 York Virginia 51199 9674 104
2291075 2291075 2022-03-09 York Virginia 51199 9669 105
2287823 2287823 2022-03-08 York Virginia 51199 9664 105
2284571 2284571 2022-03-07 York Virginia 51199 9665 105
2281319 2281319 2022-03-06 York Virginia 51199 9651 105
2278066 2278066 2022-03-05 York Virginia 51199 9651 105
2274813 2274813 2022-03-04 York Virginia 51199 9651 105
2271560 2271560 2022-03-03 York Virginia 51199 9651 105
2268308 2268308 2022-03-02 York Virginia 51199 9641 104
2265055 2265055 2022-03-01 York Virginia 51199 9639 103
2261805 2261805 2022-02-28 York Virginia 51199 9634 103
2258554 2258554 2022-02-27 York Virginia 51199 9618 102
2255303 2255303 2022-02-26 York Virginia 51199 9618 102
2252052 2252052 2022-02-25 York Virginia 51199 9618 102
2248801 2248801 2022-02-24 York Virginia 51199 9604 102
2245550 2245550 2022-02-23 York Virginia 51199 9594 101
2242299 2242299 2022-02-22 York Virginia 51199 9584 101
2239048 2239048 2022-02-21 York Virginia 51199 9580 100
2235797 2235797 2022-02-20 York Virginia 51199 9549 100
2232546 2232546 2022-02-19 York Virginia 51199 9549 100
2229295 2229295 2022-02-18 York Virginia 51199 9549 100
2226044 2226044 2022-02-17 York Virginia 51199 9543 98
2222793 2222793 2022-02-16 York Virginia 51199 9525 97
2219542 2219542 2022-02-15 York Virginia 51199 9512 97
2216292 2216292 2022-02-14 York Virginia 51199 9486 96
2213041 2213041 2022-02-13 York Virginia 51199 9439 95
2209788 2209788 2022-02-12 York Virginia 51199 9439 95
2206535 2206535 2022-02-11 York Virginia 51199 9439 95
2203282 2203282 2022-02-10 York Virginia 51199 9423 95
2200028 2200028 2022-02-09 York Virginia 51199 9401 95
2196774 2196774 2022-02-08 York Virginia 51199 9382 95
2193519 2193519 2022-02-07 York Virginia 51199 9358 95
2190266 2190266 2022-02-06 York Virginia 51199 9290 90
2187013 2187013 2022-02-05 York Virginia 51199 9290 90
2183760 2183760 2022-02-04 York Virginia 51199 9290 90
2180508 2180508 2022-02-03 York Virginia 51199 9256 89

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);