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

801 rows where county = "Westchester", fips = 36119 and state = "New York" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • New York · 801 ✖

fips 1

  • 36119 · 801 ✖

county 1

  • Westchester · 801 ✖
Link rowid date ▲ county state fips cases deaths
2501483 2501483 2022-05-13 Westchester New York 36119 264447 2720
2498225 2498225 2022-05-12 Westchester New York 36119 264447 2720
2494967 2494967 2022-05-11 Westchester New York 36119 263806 2719
2491709 2491709 2022-05-10 Westchester New York 36119 263253 2718
2488451 2488451 2022-05-09 Westchester New York 36119 262890 2718
2485194 2485194 2022-05-08 Westchester New York 36119 262511 2718
2481936 2481936 2022-05-07 Westchester New York 36119 262014 2718
2478678 2478678 2022-05-06 Westchester New York 36119 261464 2718
2475420 2475420 2022-05-05 Westchester New York 36119 260907 2718
2472163 2472163 2022-05-04 Westchester New York 36119 260394 2717
2468907 2468907 2022-05-03 Westchester New York 36119 259923 2717
2465651 2465651 2022-05-02 Westchester New York 36119 259642 2717
2462396 2462396 2022-05-01 Westchester New York 36119 259391 2715
2459140 2459140 2022-04-30 Westchester New York 36119 259051 2715
2455884 2455884 2022-04-29 Westchester New York 36119 258570 2715
2452628 2452628 2022-04-28 Westchester New York 36119 258177 2715
2449372 2449372 2022-04-27 Westchester New York 36119 257736 2715
2446115 2446115 2022-04-26 Westchester New York 36119 257351 2714
2442860 2442860 2022-04-25 Westchester New York 36119 257144 2714
2439604 2439604 2022-04-24 Westchester New York 36119 256934 2714
2436348 2436348 2022-04-23 Westchester New York 36119 256698 2713
2433092 2433092 2022-04-22 Westchester New York 36119 256401 2712
2429836 2429836 2022-04-21 Westchester New York 36119 255973 2710
2426580 2426580 2022-04-20 Westchester New York 36119 255610 2709
2423324 2423324 2022-04-19 Westchester New York 36119 255289 2709
2420067 2420067 2022-04-18 Westchester New York 36119 255016 2708
2416812 2416812 2022-04-17 Westchester New York 36119 254778 2708
2413556 2413556 2022-04-16 Westchester New York 36119 254505 2708
2410300 2410300 2022-04-15 Westchester New York 36119 254171 2708
2407044 2407044 2022-04-14 Westchester New York 36119 253855 2706
2403788 2403788 2022-04-13 Westchester New York 36119 253499 2706
2400533 2400533 2022-04-12 Westchester New York 36119 253168 2706
2397278 2397278 2022-04-11 Westchester New York 36119 252946 2706
2394023 2394023 2022-04-10 Westchester New York 36119 252751 2706
2390767 2390767 2022-04-09 Westchester New York 36119 252418 2706
2387511 2387511 2022-04-08 Westchester New York 36119 252073 2706
2384256 2384256 2022-04-07 Westchester New York 36119 251676 2706
2381001 2381001 2022-04-06 Westchester New York 36119 251390 2705
2377746 2377746 2022-04-05 Westchester New York 36119 251124 2705
2374493 2374493 2022-04-04 Westchester New York 36119 250973 2705
2371241 2371241 2022-04-03 Westchester New York 36119 250856 2705
2367988 2367988 2022-04-02 Westchester New York 36119 250640 2704
2364735 2364735 2022-04-01 Westchester New York 36119 250429 2703
2361481 2361481 2022-03-31 Westchester New York 36119 250207 2702
2358227 2358227 2022-03-30 Westchester New York 36119 249982 2702
2354973 2354973 2022-03-29 Westchester New York 36119 249794 2702
2351720 2351720 2022-03-28 Westchester New York 36119 249660 2701
2348468 2348468 2022-03-27 Westchester New York 36119 249566 2700
2345215 2345215 2022-03-26 Westchester New York 36119 249451 2700
2341962 2341962 2022-03-25 Westchester New York 36119 249289 2699
2338709 2338709 2022-03-24 Westchester New York 36119 249120 2699
2335455 2335455 2022-03-23 Westchester New York 36119 248969 2699
2332201 2332201 2022-03-22 Westchester New York 36119 248831 2698
2328948 2328948 2022-03-21 Westchester New York 36119 248765 2698
2325696 2325696 2022-03-20 Westchester New York 36119 248705 2698
2322443 2322443 2022-03-19 Westchester New York 36119 248603 2698
2319189 2319189 2022-03-18 Westchester New York 36119 248323 2698
2315935 2315935 2022-03-17 Westchester New York 36119 248222 2697
2312682 2312682 2022-03-16 Westchester New York 36119 248100 2697
2309429 2309429 2022-03-15 Westchester New York 36119 248001 2696
2306176 2306176 2022-03-14 Westchester New York 36119 247863 2695
2302925 2302925 2022-03-13 Westchester New York 36119 247815 2695
2299673 2299673 2022-03-12 Westchester New York 36119 247737 2692
2296421 2296421 2022-03-11 Westchester New York 36119 247646 2692
2293169 2293169 2022-03-10 Westchester New York 36119 247540 2692
2289917 2289917 2022-03-09 Westchester New York 36119 247451 2692
2286665 2286665 2022-03-08 Westchester New York 36119 247343 2691
2283413 2283413 2022-03-07 Westchester New York 36119 247297 2691
2280161 2280161 2022-03-06 Westchester New York 36119 247249 2690
2276908 2276908 2022-03-05 Westchester New York 36119 247035 2690
2273655 2273655 2022-03-04 Westchester New York 36119 246819 2690
2270402 2270402 2022-03-03 Westchester New York 36119 246819 2690
2267150 2267150 2022-03-02 Westchester New York 36119 246696 2689
2263898 2263898 2022-03-01 Westchester New York 36119 246610 2687
2260647 2260647 2022-02-28 Westchester New York 36119 246550 2686
2257396 2257396 2022-02-27 Westchester New York 36119 246495 2685
2254145 2254145 2022-02-26 Westchester New York 36119 246425 2685
2250894 2250894 2022-02-25 Westchester New York 36119 246358 2681
2247643 2247643 2022-02-24 Westchester New York 36119 246262 2680
2244392 2244392 2022-02-23 Westchester New York 36119 246157 2677
2241141 2241141 2022-02-22 Westchester New York 36119 246058 2676
2237890 2237890 2022-02-21 Westchester New York 36119 246000 2676
2234639 2234639 2022-02-20 Westchester New York 36119 245951 2672
2231388 2231388 2022-02-19 Westchester New York 36119 245849 2672
2228137 2228137 2022-02-18 Westchester New York 36119 245709 2670
2224886 2224886 2022-02-17 Westchester New York 36119 245429 2669
2221635 2221635 2022-02-16 Westchester New York 36119 245289 2665
2218384 2218384 2022-02-15 Westchester New York 36119 245172 2665
2215133 2215133 2022-02-14 Westchester New York 36119 245085 2660
2211882 2211882 2022-02-13 Westchester New York 36119 244997 2658
2208629 2208629 2022-02-12 Westchester New York 36119 244861 2655
2205376 2205376 2022-02-11 Westchester New York 36119 244676 2655
2202123 2202123 2022-02-10 Westchester New York 36119 244499 2651
2198869 2198869 2022-02-09 Westchester New York 36119 244269 2649
2195615 2195615 2022-02-08 Westchester New York 36119 244032 2647
2192361 2192361 2022-02-07 Westchester New York 36119 243877 2643
2189107 2189107 2022-02-06 Westchester New York 36119 243770 2640
2185854 2185854 2022-02-05 Westchester New York 36119 243595 2638
2182602 2182602 2022-02-04 Westchester New York 36119 243178 2635
2179350 2179350 2022-02-03 Westchester New York 36119 242887 2632

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