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 = "Orange", fips = 50017 and state = "Vermont" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • Vermont · 789 ✖

fips 1

  • 50017 · 789 ✖

county 1

  • Orange · 789 ✖
Link rowid date ▲ county state fips cases deaths
2502500 2502500 2022-05-13 Orange Vermont 50017 4420 14
2499242 2499242 2022-05-12 Orange Vermont 50017 4410 14
2495984 2495984 2022-05-11 Orange Vermont 50017 4388 14
2492726 2492726 2022-05-10 Orange Vermont 50017 4376 14
2489468 2489468 2022-05-09 Orange Vermont 50017 4370 13
2486210 2486210 2022-05-08 Orange Vermont 50017 4339 13
2482952 2482952 2022-05-07 Orange Vermont 50017 4339 13
2479694 2479694 2022-05-06 Orange Vermont 50017 4339 13
2476436 2476436 2022-05-05 Orange Vermont 50017 4324 13
2473179 2473179 2022-05-04 Orange Vermont 50017 4306 13
2469923 2469923 2022-05-03 Orange Vermont 50017 4284 13
2466667 2466667 2022-05-02 Orange Vermont 50017 4277 13
2463412 2463412 2022-05-01 Orange Vermont 50017 4249 13
2460156 2460156 2022-04-30 Orange Vermont 50017 4249 13
2456900 2456900 2022-04-29 Orange Vermont 50017 4249 13
2453644 2453644 2022-04-28 Orange Vermont 50017 4240 13
2450388 2450388 2022-04-27 Orange Vermont 50017 4986 14
2447131 2447131 2022-04-26 Orange Vermont 50017 4986 14
2443876 2443876 2022-04-25 Orange Vermont 50017 4986 14
2440620 2440620 2022-04-24 Orange Vermont 50017 4963 14
2437364 2437364 2022-04-23 Orange Vermont 50017 4963 14
2434108 2434108 2022-04-22 Orange Vermont 50017 4963 14
2430852 2430852 2022-04-21 Orange Vermont 50017 4949 14
2427596 2427596 2022-04-20 Orange Vermont 50017 4941 14
2424340 2424340 2022-04-19 Orange Vermont 50017 4935 14
2421084 2421084 2022-04-18 Orange Vermont 50017 4930 14
2417828 2417828 2022-04-17 Orange Vermont 50017 4900 14
2414572 2414572 2022-04-16 Orange Vermont 50017 4900 14
2411316 2411316 2022-04-15 Orange Vermont 50017 4900 14
2408060 2408060 2022-04-14 Orange Vermont 50017 4896 14
2404804 2404804 2022-04-13 Orange Vermont 50017 4889 14
2401549 2401549 2022-04-12 Orange Vermont 50017 4884 14
2398294 2398294 2022-04-11 Orange Vermont 50017 4884 14
2395039 2395039 2022-04-10 Orange Vermont 50017 4879 14
2391783 2391783 2022-04-09 Orange Vermont 50017 4879 14
2388527 2388527 2022-04-08 Orange Vermont 50017 4879 14
2385272 2385272 2022-04-07 Orange Vermont 50017 4872 14
2382017 2382017 2022-04-06 Orange Vermont 50017 4870 14
2378762 2378762 2022-04-05 Orange Vermont 50017 4868 14
2375508 2375508 2022-04-04 Orange Vermont 50017 4866 14
2372256 2372256 2022-04-03 Orange Vermont 50017 4873 14
2369003 2369003 2022-04-02 Orange Vermont 50017 4873 14
2365750 2365750 2022-04-01 Orange Vermont 50017 4873 14
2362497 2362497 2022-03-31 Orange Vermont 50017 4884 14
2359243 2359243 2022-03-30 Orange Vermont 50017 4882 14
2355989 2355989 2022-03-29 Orange Vermont 50017 4888 14
2352736 2352736 2022-03-28 Orange Vermont 50017 4894 14
2349484 2349484 2022-03-27 Orange Vermont 50017 4889 14
2346231 2346231 2022-03-26 Orange Vermont 50017 4889 14
2342978 2342978 2022-03-25 Orange Vermont 50017 4889 14
2339725 2339725 2022-03-24 Orange Vermont 50017 4883 14
2336471 2336471 2022-03-23 Orange Vermont 50017 4883 14
2333217 2333217 2022-03-22 Orange Vermont 50017 4873 14
2329964 2329964 2022-03-21 Orange Vermont 50017 4869 14
2326712 2326712 2022-03-20 Orange Vermont 50017 4862 14
2323459 2323459 2022-03-19 Orange Vermont 50017 4862 14
2320205 2320205 2022-03-18 Orange Vermont 50017 4862 14
2316951 2316951 2022-03-17 Orange Vermont 50017 4849 14
2313698 2313698 2022-03-16 Orange Vermont 50017 4847 14
2310445 2310445 2022-03-15 Orange Vermont 50017 4838 14
2307192 2307192 2022-03-14 Orange Vermont 50017 4834 14
2303941 2303941 2022-03-13 Orange Vermont 50017 4809 14
2300689 2300689 2022-03-12 Orange Vermont 50017 4809 14
2297437 2297437 2022-03-11 Orange Vermont 50017 4809 14
2294185 2294185 2022-03-10 Orange Vermont 50017 4807 14
2290933 2290933 2022-03-09 Orange Vermont 50017 4797 14
2287681 2287681 2022-03-08 Orange Vermont 50017 4787 14
2284429 2284429 2022-03-07 Orange Vermont 50017 4787 14
2281177 2281177 2022-03-06 Orange Vermont 50017 4764 14
2277924 2277924 2022-03-05 Orange Vermont 50017 4764 14
2274671 2274671 2022-03-04 Orange Vermont 50017 4764 14
2271418 2271418 2022-03-03 Orange Vermont 50017 4762 14
2268166 2268166 2022-03-02 Orange Vermont 50017 4749 14
2264913 2264913 2022-03-01 Orange Vermont 50017 3269 11
2261663 2261663 2022-02-28 Orange Vermont 50017 3269 11
2258412 2258412 2022-02-27 Orange Vermont 50017 3253 11
2255161 2255161 2022-02-26 Orange Vermont 50017 3253 11
2251910 2251910 2022-02-25 Orange Vermont 50017 3253 11
2248659 2248659 2022-02-24 Orange Vermont 50017 3240 11
2245408 2245408 2022-02-23 Orange Vermont 50017 3208 11
2242157 2242157 2022-02-22 Orange Vermont 50017 3197 11
2238906 2238906 2022-02-21 Orange Vermont 50017 3177 11
2235655 2235655 2022-02-20 Orange Vermont 50017 3177 11
2232404 2232404 2022-02-19 Orange Vermont 50017 3177 11
2229153 2229153 2022-02-18 Orange Vermont 50017 3177 11
2225902 2225902 2022-02-17 Orange Vermont 50017 3171 11
2222651 2222651 2022-02-16 Orange Vermont 50017 3163 11
2219400 2219400 2022-02-15 Orange Vermont 50017 3157 11
2216149 2216149 2022-02-14 Orange Vermont 50017 3146 11
2212898 2212898 2022-02-13 Orange Vermont 50017 3140 11
2209645 2209645 2022-02-12 Orange Vermont 50017 3140 11
2206392 2206392 2022-02-11 Orange Vermont 50017 3140 11
2203139 2203139 2022-02-10 Orange Vermont 50017 3136 11
2199885 2199885 2022-02-09 Orange Vermont 50017 3129 11
2196631 2196631 2022-02-08 Orange Vermont 50017 3118 11
2193377 2193377 2022-02-07 Orange Vermont 50017 3107 11
2190124 2190124 2022-02-06 Orange Vermont 50017 3087 11
2186871 2186871 2022-02-05 Orange Vermont 50017 3087 11
2183618 2183618 2022-02-04 Orange Vermont 50017 3087 11
2180366 2180366 2022-02-03 Orange Vermont 50017 3078 11

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