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

760 rows where county = "Lincoln" and state = "West Virginia" sorted by date descending

✎ View and edit SQL

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

state 1

  • West Virginia · 760 ✖

fips 1

county 1

  • Lincoln · 760 ✖
Link rowid date ▲ county state fips cases deaths
2502704 2502704 2022-05-13 Lincoln West Virginia 54043 5606 82
2499446 2499446 2022-05-12 Lincoln West Virginia 54043 5601 82
2496188 2496188 2022-05-11 Lincoln West Virginia 54043 5593 82
2492930 2492930 2022-05-10 Lincoln West Virginia 54043 5588 82
2489672 2489672 2022-05-09 Lincoln West Virginia 54043 5588 82
2486415 2486415 2022-05-08 Lincoln West Virginia 54043 5572 82
2483157 2483157 2022-05-07 Lincoln West Virginia 54043 5572 82
2479899 2479899 2022-05-06 Lincoln West Virginia 54043 5572 82
2476641 2476641 2022-05-05 Lincoln West Virginia 54043 5568 82
2473383 2473383 2022-05-04 Lincoln West Virginia 54043 5565 82
2470126 2470126 2022-05-03 Lincoln West Virginia 54043 5563 82
2466870 2466870 2022-05-02 Lincoln West Virginia 54043 5559 81
2463615 2463615 2022-05-01 Lincoln West Virginia 54043 5554 81
2460359 2460359 2022-04-30 Lincoln West Virginia 54043 5554 81
2457103 2457103 2022-04-29 Lincoln West Virginia 54043 5554 81
2453847 2453847 2022-04-28 Lincoln West Virginia 54043 5549 81
2450591 2450591 2022-04-27 Lincoln West Virginia 54043 5547 81
2447335 2447335 2022-04-26 Lincoln West Virginia 54043 5542 81
2444079 2444079 2022-04-25 Lincoln West Virginia 54043 5536 81
2440823 2440823 2022-04-24 Lincoln West Virginia 54043 5532 81
2437567 2437567 2022-04-23 Lincoln West Virginia 54043 5532 81
2434311 2434311 2022-04-22 Lincoln West Virginia 54043 5532 81
2431055 2431055 2022-04-21 Lincoln West Virginia 54043 5531 81
2427799 2427799 2022-04-20 Lincoln West Virginia 54043 5530 81
2424543 2424543 2022-04-19 Lincoln West Virginia 54043 5526 81
2421287 2421287 2022-04-18 Lincoln West Virginia 54043 5525 81
2418031 2418031 2022-04-17 Lincoln West Virginia 54043 5524 81
2414775 2414775 2022-04-16 Lincoln West Virginia 54043 5524 81
2411519 2411519 2022-04-15 Lincoln West Virginia 54043 5524 81
2408263 2408263 2022-04-14 Lincoln West Virginia 54043 5523 81
2405007 2405007 2022-04-13 Lincoln West Virginia 54043 5523 80
2401752 2401752 2022-04-12 Lincoln West Virginia 54043 5522 80
2398497 2398497 2022-04-11 Lincoln West Virginia 54043 5520 78
2395242 2395242 2022-04-10 Lincoln West Virginia 54043 5522 78
2391986 2391986 2022-04-09 Lincoln West Virginia 54043 5522 78
2388730 2388730 2022-04-08 Lincoln West Virginia 54043 5522 78
2385475 2385475 2022-04-07 Lincoln West Virginia 54043 5520 78
2382220 2382220 2022-04-06 Lincoln West Virginia 54043 5520 78
2378965 2378965 2022-04-05 Lincoln West Virginia 54043 5517 77
2375711 2375711 2022-04-04 Lincoln West Virginia 54043 5515 78
2372459 2372459 2022-04-03 Lincoln West Virginia 54043 5510 78
2369206 2369206 2022-04-02 Lincoln West Virginia 54043 5510 78
2365953 2365953 2022-04-01 Lincoln West Virginia 54043 5510 78
2362700 2362700 2022-03-31 Lincoln West Virginia 54043 5509 78
2359446 2359446 2022-03-30 Lincoln West Virginia 54043 5508 78
2356192 2356192 2022-03-29 Lincoln West Virginia 54043 5508 77
2352939 2352939 2022-03-28 Lincoln West Virginia 54043 5507 77
2349687 2349687 2022-03-27 Lincoln West Virginia 54043 5505 77
2346434 2346434 2022-03-26 Lincoln West Virginia 54043 5505 77
2343181 2343181 2022-03-25 Lincoln West Virginia 54043 5505 77
2339928 2339928 2022-03-24 Lincoln West Virginia 54043 5505 76
2336675 2336675 2022-03-23 Lincoln West Virginia 54043 5502 76
2333421 2333421 2022-03-22 Lincoln West Virginia 54043 5501 76
2330167 2330167 2022-03-21 Lincoln West Virginia 54043 5501 76
2326915 2326915 2022-03-20 Lincoln West Virginia 54043 5495 76
2323662 2323662 2022-03-19 Lincoln West Virginia 54043 5495 76
2320408 2320408 2022-03-18 Lincoln West Virginia 54043 5495 76
2317154 2317154 2022-03-17 Lincoln West Virginia 54043 5491 76
2313901 2313901 2022-03-16 Lincoln West Virginia 54043 5492 76
2310648 2310648 2022-03-15 Lincoln West Virginia 54043 5490 76
2307395 2307395 2022-03-14 Lincoln West Virginia 54043 5488 74
2304144 2304144 2022-03-13 Lincoln West Virginia 54043 5482 74
2300892 2300892 2022-03-12 Lincoln West Virginia 54043 5482 74
2297640 2297640 2022-03-11 Lincoln West Virginia 54043 5482 74
2294388 2294388 2022-03-10 Lincoln West Virginia 54043 5478 73
2291136 2291136 2022-03-09 Lincoln West Virginia 54043 5472 72
2287884 2287884 2022-03-08 Lincoln West Virginia 54043 5469 72
2284632 2284632 2022-03-07 Lincoln West Virginia 54043 5465 70
2281380 2281380 2022-03-06 Lincoln West Virginia 54043 5452 70
2278127 2278127 2022-03-05 Lincoln West Virginia 54043 5452 70
2274874 2274874 2022-03-04 Lincoln West Virginia 54043 5452 70
2271621 2271621 2022-03-03 Lincoln West Virginia 54043 5444 70
2268369 2268369 2022-03-02 Lincoln West Virginia 54043 5433 69
2265116 2265116 2022-03-01 Lincoln West Virginia 54043 5432 69
2261866 2261866 2022-02-28 Lincoln West Virginia 54043 5430 69
2258615 2258615 2022-02-27 Lincoln West Virginia 54043 5411 69
2255364 2255364 2022-02-26 Lincoln West Virginia 54043 5411 69
2252113 2252113 2022-02-25 Lincoln West Virginia 54043 5411 69
2248862 2248862 2022-02-24 Lincoln West Virginia 54043 5404 69
2245611 2245611 2022-02-23 Lincoln West Virginia 54043 5386 68
2242360 2242360 2022-02-22 Lincoln West Virginia 54043 5376 68
2239109 2239109 2022-02-21 Lincoln West Virginia 54043 5360 68
2235858 2235858 2022-02-20 Lincoln West Virginia 54043 5297 68
2232607 2232607 2022-02-19 Lincoln West Virginia 54043 5297 68
2229356 2229356 2022-02-18 Lincoln West Virginia 54043 5297 68
2226105 2226105 2022-02-17 Lincoln West Virginia 54043 5273 67
2222854 2222854 2022-02-16 Lincoln West Virginia 54043 5257 67
2219603 2219603 2022-02-15 Lincoln West Virginia 54043 5234 66
2216353 2216353 2022-02-14 Lincoln West Virginia 54043 5221 65
2213102 2213102 2022-02-13 Lincoln West Virginia 54043 5213 64
2209849 2209849 2022-02-12 Lincoln West Virginia 54043 5195 64
2206596 2206596 2022-02-11 Lincoln West Virginia 54043 5168 64
2203343 2203343 2022-02-10 Lincoln West Virginia 54043 5121 63
2200089 2200089 2022-02-09 Lincoln West Virginia 54043 5088 63
2196835 2196835 2022-02-08 Lincoln West Virginia 54043 5063 63
2193580 2193580 2022-02-07 Lincoln West Virginia 54043 5037 62
2190327 2190327 2022-02-06 Lincoln West Virginia 54043 5026 62
2187074 2187074 2022-02-05 Lincoln West Virginia 54043 5006 62
2183821 2183821 2022-02-04 Lincoln West Virginia 54043 4936 62
2180569 2180569 2022-02-03 Lincoln West Virginia 54043 4896 62

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