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

768 rows where county = "St. Thomas", fips = 78030 and state = "Virgin Islands" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Virgin Islands · 768 ✖

fips 1

  • 78030 · 768 ✖

county 1

  • St. Thomas · 768 ✖
Link rowid date ▲ county state fips cases deaths
2502509 2502509 2022-05-13 St. Thomas Virgin Islands 78030 8643 59
2499251 2499251 2022-05-12 St. Thomas Virgin Islands 78030 8532 59
2495993 2495993 2022-05-11 St. Thomas Virgin Islands 78030 8469 59
2492735 2492735 2022-05-10 St. Thomas Virgin Islands 78030 8272 59
2489477 2489477 2022-05-09 St. Thomas Virgin Islands 78030 8272 59
2486219 2486219 2022-05-08 St. Thomas Virgin Islands 78030 8123 59
2482961 2482961 2022-05-07 St. Thomas Virgin Islands 78030 8123 59
2479703 2479703 2022-05-06 St. Thomas Virgin Islands 78030 8123 59
2476445 2476445 2022-05-05 St. Thomas Virgin Islands 78030 7987 59
2473188 2473188 2022-05-04 St. Thomas Virgin Islands 78030 7570 59
2469932 2469932 2022-05-03 St. Thomas Virgin Islands 78030 7498 59
2466676 2466676 2022-05-02 St. Thomas Virgin Islands 78030 7498 59
2463421 2463421 2022-05-01 St. Thomas Virgin Islands 78030 7457 59
2460165 2460165 2022-04-30 St. Thomas Virgin Islands 78030 7457 59
2456909 2456909 2022-04-29 St. Thomas Virgin Islands 78030 7457 59
2453653 2453653 2022-04-28 St. Thomas Virgin Islands 78030 7457 59
2450397 2450397 2022-04-27 St. Thomas Virgin Islands 78030 7444 59
2447140 2447140 2022-04-26 St. Thomas Virgin Islands 78030 7395 59
2443885 2443885 2022-04-25 St. Thomas Virgin Islands 78030 7395 59
2440629 2440629 2022-04-24 St. Thomas Virgin Islands 78030 7377 59
2437373 2437373 2022-04-23 St. Thomas Virgin Islands 78030 7377 59
2434117 2434117 2022-04-22 St. Thomas Virgin Islands 78030 7377 59
2430861 2430861 2022-04-21 St. Thomas Virgin Islands 78030 7341 59
2427605 2427605 2022-04-20 St. Thomas Virgin Islands 78030 7293 59
2424349 2424349 2022-04-19 St. Thomas Virgin Islands 78030 7293 59
2421093 2421093 2022-04-18 St. Thomas Virgin Islands 78030 7270 59
2417837 2417837 2022-04-17 St. Thomas Virgin Islands 78030 7267 59
2414581 2414581 2022-04-16 St. Thomas Virgin Islands 78030 7267 59
2411325 2411325 2022-04-15 St. Thomas Virgin Islands 78030 7267 59
2408069 2408069 2022-04-14 St. Thomas Virgin Islands 78030 7267 59
2404813 2404813 2022-04-13 St. Thomas Virgin Islands 78030 7252 59
2401558 2401558 2022-04-12 St. Thomas Virgin Islands 78030 7230 59
2398303 2398303 2022-04-11 St. Thomas Virgin Islands 78030 7219 59
2395048 2395048 2022-04-10 St. Thomas Virgin Islands 78030 7219 59
2391792 2391792 2022-04-09 St. Thomas Virgin Islands 78030 7219 59
2388536 2388536 2022-04-08 St. Thomas Virgin Islands 78030 7219 59
2385281 2385281 2022-04-07 St. Thomas Virgin Islands 78030 7206 59
2382026 2382026 2022-04-06 St. Thomas Virgin Islands 78030 7199 59
2378771 2378771 2022-04-05 St. Thomas Virgin Islands 78030 7189 59
2375517 2375517 2022-04-04 St. Thomas Virgin Islands 78030 7145 59
2372265 2372265 2022-04-03 St. Thomas Virgin Islands 78030 7145 59
2369012 2369012 2022-04-02 St. Thomas Virgin Islands 78030 7145 59
2365759 2365759 2022-04-01 St. Thomas Virgin Islands 78030 7145 59
2362506 2362506 2022-03-31 St. Thomas Virgin Islands 78030 7138 59
2359252 2359252 2022-03-30 St. Thomas Virgin Islands 78030 7135 59
2355998 2355998 2022-03-29 St. Thomas Virgin Islands 78030 7135 59
2352745 2352745 2022-03-28 St. Thomas Virgin Islands 78030 7131 59
2349493 2349493 2022-03-27 St. Thomas Virgin Islands 78030 7131 59
2346240 2346240 2022-03-26 St. Thomas Virgin Islands 78030 7131 59
2342987 2342987 2022-03-25 St. Thomas Virgin Islands 78030 7131 59
2339734 2339734 2022-03-24 St. Thomas Virgin Islands 78030 7128 59
2336480 2336480 2022-03-23 St. Thomas Virgin Islands 78030 7128 59
2333226 2333226 2022-03-22 St. Thomas Virgin Islands 78030 7125 59
2329973 2329973 2022-03-21 St. Thomas Virgin Islands 78030 7124 59
2326721 2326721 2022-03-20 St. Thomas Virgin Islands 78030 7121 59
2323468 2323468 2022-03-19 St. Thomas Virgin Islands 78030 7121 59
2320214 2320214 2022-03-18 St. Thomas Virgin Islands 78030 7121 59
2316960 2316960 2022-03-17 St. Thomas Virgin Islands 78030 7120 59
2313707 2313707 2022-03-16 St. Thomas Virgin Islands 78030 7119 59
2310454 2310454 2022-03-15 St. Thomas Virgin Islands 78030 7116 59
2307201 2307201 2022-03-14 St. Thomas Virgin Islands 78030 7114 59
2303950 2303950 2022-03-13 St. Thomas Virgin Islands 78030 7114 59
2300698 2300698 2022-03-12 St. Thomas Virgin Islands 78030 7114 59
2297446 2297446 2022-03-11 St. Thomas Virgin Islands 78030 7114 59
2294194 2294194 2022-03-10 St. Thomas Virgin Islands 78030 7088 59
2290942 2290942 2022-03-09 St. Thomas Virgin Islands 78030 7088 59
2287690 2287690 2022-03-08 St. Thomas Virgin Islands 78030 7086 59
2284438 2284438 2022-03-07 St. Thomas Virgin Islands 78030 7078 59
2281186 2281186 2022-03-06 St. Thomas Virgin Islands 78030 7078 59
2277933 2277933 2022-03-05 St. Thomas Virgin Islands 78030 7078 59
2274680 2274680 2022-03-04 St. Thomas Virgin Islands 78030 7078 59
2271427 2271427 2022-03-03 St. Thomas Virgin Islands 78030 7071 59
2268175 2268175 2022-03-02 St. Thomas Virgin Islands 78030 7070 59
2264922 2264922 2022-03-01 St. Thomas Virgin Islands 78030 7069 59
2261672 2261672 2022-02-28 St. Thomas Virgin Islands 78030 7069 59
2258421 2258421 2022-02-27 St. Thomas Virgin Islands 78030 7058 59
2255170 2255170 2022-02-26 St. Thomas Virgin Islands 78030 7058 59
2251919 2251919 2022-02-25 St. Thomas Virgin Islands 78030 7058 59
2248668 2248668 2022-02-24 St. Thomas Virgin Islands 78030 7053 59
2245417 2245417 2022-02-23 St. Thomas Virgin Islands 78030 7034 58
2242166 2242166 2022-02-22 St. Thomas Virgin Islands 78030 7034 58
2238915 2238915 2022-02-21 St. Thomas Virgin Islands 78030 7034 58
2235664 2235664 2022-02-20 St. Thomas Virgin Islands 78030 7034 58
2232413 2232413 2022-02-19 St. Thomas Virgin Islands 78030 7034 58
2229162 2229162 2022-02-18 St. Thomas Virgin Islands 78030 7034 58
2225911 2225911 2022-02-17 St. Thomas Virgin Islands 78030 7034 58
2222660 2222660 2022-02-16 St. Thomas Virgin Islands 78030 7027 58
2219409 2219409 2022-02-15 St. Thomas Virgin Islands 78030 7027 58
2216158 2216158 2022-02-14 St. Thomas Virgin Islands 78030 7020 54
2212907 2212907 2022-02-13 St. Thomas Virgin Islands 78030 7016 54
2209654 2209654 2022-02-12 St. Thomas Virgin Islands 78030 7016 54
2206401 2206401 2022-02-11 St. Thomas Virgin Islands 78030 7016 54
2203148 2203148 2022-02-10 St. Thomas Virgin Islands 78030 6952 54
2199894 2199894 2022-02-09 St. Thomas Virgin Islands 78030 6952 54
2196640 2196640 2022-02-08 St. Thomas Virgin Islands 78030 6952 54
2193386 2193386 2022-02-07 St. Thomas Virgin Islands 78030 6943 54
2190133 2190133 2022-02-06 St. Thomas Virgin Islands 78030 6943 54
2186880 2186880 2022-02-05 St. Thomas Virgin Islands 78030 6943 54
2183627 2183627 2022-02-04 St. Thomas Virgin Islands 78030 6943 54
2180375 2180375 2022-02-03 St. Thomas Virgin Islands 78030 6934 54

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