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

785 rows where county = "Addison" and state = "Vermont" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Vermont · 785 ✖

fips 1

county 1

  • Addison · 785 ✖
Link rowid date ▲ county state fips cases deaths
2502492 2502492 2022-05-13 Addison Vermont 50001 5939 18
2499234 2499234 2022-05-12 Addison Vermont 50001 5922 18
2495976 2495976 2022-05-11 Addison Vermont 50001 5902 18
2492718 2492718 2022-05-10 Addison Vermont 50001 5886 18
2489460 2489460 2022-05-09 Addison Vermont 50001 5880 17
2486202 2486202 2022-05-08 Addison Vermont 50001 5845 16
2482944 2482944 2022-05-07 Addison Vermont 50001 5845 16
2479686 2479686 2022-05-06 Addison Vermont 50001 5845 16
2476428 2476428 2022-05-05 Addison Vermont 50001 5827 16
2473171 2473171 2022-05-04 Addison Vermont 50001 5810 15
2469915 2469915 2022-05-03 Addison Vermont 50001 5799 15
2466659 2466659 2022-05-02 Addison Vermont 50001 5789 15
2463404 2463404 2022-05-01 Addison Vermont 50001 5751 15
2460148 2460148 2022-04-30 Addison Vermont 50001 5751 15
2456892 2456892 2022-04-29 Addison Vermont 50001 5751 15
2453636 2453636 2022-04-28 Addison Vermont 50001 5729 15
2450380 2450380 2022-04-27 Addison Vermont 50001 5752 15
2447123 2447123 2022-04-26 Addison Vermont 50001 5752 15
2443868 2443868 2022-04-25 Addison Vermont 50001 5752 15
2440612 2440612 2022-04-24 Addison Vermont 50001 5718 15
2437356 2437356 2022-04-23 Addison Vermont 50001 5718 15
2434100 2434100 2022-04-22 Addison Vermont 50001 5718 15
2430844 2430844 2022-04-21 Addison Vermont 50001 5705 15
2427588 2427588 2022-04-20 Addison Vermont 50001 5696 15
2424332 2424332 2022-04-19 Addison Vermont 50001 5686 15
2421076 2421076 2022-04-18 Addison Vermont 50001 5679 15
2417820 2417820 2022-04-17 Addison Vermont 50001 5653 15
2414564 2414564 2022-04-16 Addison Vermont 50001 5653 15
2411308 2411308 2022-04-15 Addison Vermont 50001 5653 15
2408052 2408052 2022-04-14 Addison Vermont 50001 5637 15
2404796 2404796 2022-04-13 Addison Vermont 50001 5625 15
2401541 2401541 2022-04-12 Addison Vermont 50001 5601 15
2398286 2398286 2022-04-11 Addison Vermont 50001 5591 15
2395031 2395031 2022-04-10 Addison Vermont 50001 5559 15
2391775 2391775 2022-04-09 Addison Vermont 50001 5559 15
2388519 2388519 2022-04-08 Addison Vermont 50001 5559 15
2385264 2385264 2022-04-07 Addison Vermont 50001 5543 15
2382009 2382009 2022-04-06 Addison Vermont 50001 5529 15
2378754 2378754 2022-04-05 Addison Vermont 50001 5518 15
2375500 2375500 2022-04-04 Addison Vermont 50001 5513 15
2372248 2372248 2022-04-03 Addison Vermont 50001 5471 15
2368995 2368995 2022-04-02 Addison Vermont 50001 5471 15
2365742 2365742 2022-04-01 Addison Vermont 50001 5471 15
2362489 2362489 2022-03-31 Addison Vermont 50001 5465 15
2359235 2359235 2022-03-30 Addison Vermont 50001 5455 15
2355981 2355981 2022-03-29 Addison Vermont 50001 5431 15
2352728 2352728 2022-03-28 Addison Vermont 50001 5429 15
2349476 2349476 2022-03-27 Addison Vermont 50001 5418 15
2346223 2346223 2022-03-26 Addison Vermont 50001 5418 15
2342970 2342970 2022-03-25 Addison Vermont 50001 5418 15
2339717 2339717 2022-03-24 Addison Vermont 50001 5413 15
2336463 2336463 2022-03-23 Addison Vermont 50001 5395 15
2333209 2333209 2022-03-22 Addison Vermont 50001 5389 15
2329956 2329956 2022-03-21 Addison Vermont 50001 5381 15
2326704 2326704 2022-03-20 Addison Vermont 50001 5369 15
2323451 2323451 2022-03-19 Addison Vermont 50001 5369 15
2320197 2320197 2022-03-18 Addison Vermont 50001 5369 15
2316943 2316943 2022-03-17 Addison Vermont 50001 5361 15
2313690 2313690 2022-03-16 Addison Vermont 50001 5354 15
2310437 2310437 2022-03-15 Addison Vermont 50001 5336 15
2307184 2307184 2022-03-14 Addison Vermont 50001 5333 15
2303933 2303933 2022-03-13 Addison Vermont 50001 5319 15
2300681 2300681 2022-03-12 Addison Vermont 50001 5319 15
2297429 2297429 2022-03-11 Addison Vermont 50001 5319 15
2294177 2294177 2022-03-10 Addison Vermont 50001 5269 15
2290925 2290925 2022-03-09 Addison Vermont 50001 5255 15
2287673 2287673 2022-03-08 Addison Vermont 50001 5189 15
2284421 2284421 2022-03-07 Addison Vermont 50001 5188 15
2281169 2281169 2022-03-06 Addison Vermont 50001 5161 15
2277916 2277916 2022-03-05 Addison Vermont 50001 5161 15
2274663 2274663 2022-03-04 Addison Vermont 50001 5161 15
2271410 2271410 2022-03-03 Addison Vermont 50001 5097 15
2268158 2268158 2022-03-02 Addison Vermont 50001 5083 15
2264905 2264905 2022-03-01 Addison Vermont 50001 4120 15
2261655 2261655 2022-02-28 Addison Vermont 50001 4120 15
2258404 2258404 2022-02-27 Addison Vermont 50001 4034 15
2255153 2255153 2022-02-26 Addison Vermont 50001 4034 15
2251902 2251902 2022-02-25 Addison Vermont 50001 4034 15
2248651 2248651 2022-02-24 Addison Vermont 50001 3998 15
2245400 2245400 2022-02-23 Addison Vermont 50001 3978 15
2242149 2242149 2022-02-22 Addison Vermont 50001 3962 15
2238898 2238898 2022-02-21 Addison Vermont 50001 3935 15
2235647 2235647 2022-02-20 Addison Vermont 50001 3935 15
2232396 2232396 2022-02-19 Addison Vermont 50001 3935 15
2229145 2229145 2022-02-18 Addison Vermont 50001 3935 15
2225894 2225894 2022-02-17 Addison Vermont 50001 3927 15
2222643 2222643 2022-02-16 Addison Vermont 50001 3906 15
2219392 2219392 2022-02-15 Addison Vermont 50001 3891 15
2216141 2216141 2022-02-14 Addison Vermont 50001 3888 15
2212890 2212890 2022-02-13 Addison Vermont 50001 3863 13
2209637 2209637 2022-02-12 Addison Vermont 50001 3863 13
2206384 2206384 2022-02-11 Addison Vermont 50001 3863 13
2203131 2203131 2022-02-10 Addison Vermont 50001 3843 13
2199877 2199877 2022-02-09 Addison Vermont 50001 3834 13
2196623 2196623 2022-02-08 Addison Vermont 50001 3827 13
2193369 2193369 2022-02-07 Addison Vermont 50001 3814 13
2190116 2190116 2022-02-06 Addison Vermont 50001 3781 13
2186863 2186863 2022-02-05 Addison Vermont 50001 3781 13
2183610 2183610 2022-02-04 Addison Vermont 50001 3781 13
2180358 2180358 2022-02-03 Addison Vermont 50001 3774 13

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