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

799 rows where county = "Rockland", fips = 36087 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 · 799 ✖

fips 1

  • 36087 · 799 ✖

county 1

  • Rockland · 799 ✖
Link rowid date ▲ county state fips cases deaths
2501467 2501467 2022-05-13 Rockland New York 36087 96142 897
2498209 2498209 2022-05-12 Rockland New York 36087 96142 897
2494951 2494951 2022-05-11 Rockland New York 36087 95943 897
2491693 2491693 2022-05-10 Rockland New York 36087 95792 896
2488435 2488435 2022-05-09 Rockland New York 36087 95688 896
2485178 2485178 2022-05-08 Rockland New York 36087 95605 896
2481920 2481920 2022-05-07 Rockland New York 36087 95326 896
2478662 2478662 2022-05-06 Rockland New York 36087 95195 895
2475404 2475404 2022-05-05 Rockland New York 36087 95018 894
2472147 2472147 2022-05-04 Rockland New York 36087 94879 894
2468891 2468891 2022-05-03 Rockland New York 36087 94746 893
2465635 2465635 2022-05-02 Rockland New York 36087 94646 893
2462380 2462380 2022-05-01 Rockland New York 36087 94576 893
2459124 2459124 2022-04-30 Rockland New York 36087 94467 893
2455868 2455868 2022-04-29 Rockland New York 36087 94359 893
2452612 2452612 2022-04-28 Rockland New York 36087 94229 893
2449356 2449356 2022-04-27 Rockland New York 36087 94130 892
2446099 2446099 2022-04-26 Rockland New York 36087 94024 892
2442844 2442844 2022-04-25 Rockland New York 36087 93943 892
2439588 2439588 2022-04-24 Rockland New York 36087 93887 892
2436332 2436332 2022-04-23 Rockland New York 36087 93819 892
2433076 2433076 2022-04-22 Rockland New York 36087 93744 892
2429820 2429820 2022-04-21 Rockland New York 36087 93618 892
2426564 2426564 2022-04-20 Rockland New York 36087 93544 892
2423308 2423308 2022-04-19 Rockland New York 36087 93483 891
2420051 2420051 2022-04-18 Rockland New York 36087 93413 891
2416796 2416796 2022-04-17 Rockland New York 36087 93347 891
2413540 2413540 2022-04-16 Rockland New York 36087 93286 891
2410284 2410284 2022-04-15 Rockland New York 36087 93194 891
2407028 2407028 2022-04-14 Rockland New York 36087 93103 891
2403772 2403772 2022-04-13 Rockland New York 36087 93010 891
2400517 2400517 2022-04-12 Rockland New York 36087 92905 891
2397262 2397262 2022-04-11 Rockland New York 36087 92841 891
2394007 2394007 2022-04-10 Rockland New York 36087 92783 891
2390751 2390751 2022-04-09 Rockland New York 36087 92705 891
2387495 2387495 2022-04-08 Rockland New York 36087 92620 891
2384240 2384240 2022-04-07 Rockland New York 36087 92550 891
2380985 2380985 2022-04-06 Rockland New York 36087 92460 891
2377730 2377730 2022-04-05 Rockland New York 36087 92405 891
2374477 2374477 2022-04-04 Rockland New York 36087 92377 891
2371225 2371225 2022-04-03 Rockland New York 36087 92343 891
2367972 2367972 2022-04-02 Rockland New York 36087 92283 891
2364719 2364719 2022-04-01 Rockland New York 36087 92205 891
2361465 2361465 2022-03-31 Rockland New York 36087 92126 891
2358211 2358211 2022-03-30 Rockland New York 36087 92056 891
2354957 2354957 2022-03-29 Rockland New York 36087 92011 891
2351704 2351704 2022-03-28 Rockland New York 36087 91979 891
2348452 2348452 2022-03-27 Rockland New York 36087 91947 891
2345199 2345199 2022-03-26 Rockland New York 36087 91906 891
2341946 2341946 2022-03-25 Rockland New York 36087 91871 891
2338693 2338693 2022-03-24 Rockland New York 36087 91830 891
2335439 2335439 2022-03-23 Rockland New York 36087 91787 891
2332185 2332185 2022-03-22 Rockland New York 36087 91739 891
2328932 2328932 2022-03-21 Rockland New York 36087 91718 891
2325680 2325680 2022-03-20 Rockland New York 36087 91700 891
2322427 2322427 2022-03-19 Rockland New York 36087 91671 891
2319173 2319173 2022-03-18 Rockland New York 36087 91629 891
2315919 2315919 2022-03-17 Rockland New York 36087 91600 891
2312666 2312666 2022-03-16 Rockland New York 36087 91531 891
2309413 2309413 2022-03-15 Rockland New York 36087 91503 891
2306160 2306160 2022-03-14 Rockland New York 36087 91475 891
2302909 2302909 2022-03-13 Rockland New York 36087 91460 891
2299657 2299657 2022-03-12 Rockland New York 36087 91442 891
2296405 2296405 2022-03-11 Rockland New York 36087 91415 891
2293153 2293153 2022-03-10 Rockland New York 36087 91394 890
2289901 2289901 2022-03-09 Rockland New York 36087 91365 890
2286649 2286649 2022-03-08 Rockland New York 36087 91337 890
2283397 2283397 2022-03-07 Rockland New York 36087 91321 890
2280145 2280145 2022-03-06 Rockland New York 36087 91307 890
2276892 2276892 2022-03-05 Rockland New York 36087 91290 890
2273639 2273639 2022-03-04 Rockland New York 36087 91221 890
2270386 2270386 2022-03-03 Rockland New York 36087 91221 890
2267134 2267134 2022-03-02 Rockland New York 36087 91196 890
2263882 2263882 2022-03-01 Rockland New York 36087 91180 890
2260631 2260631 2022-02-28 Rockland New York 36087 91166 890
2257380 2257380 2022-02-27 Rockland New York 36087 91154 890
2254129 2254129 2022-02-26 Rockland New York 36087 91135 890
2250878 2250878 2022-02-25 Rockland New York 36087 91111 890
2247627 2247627 2022-02-24 Rockland New York 36087 91078 890
2244376 2244376 2022-02-23 Rockland New York 36087 91052 890
2241125 2241125 2022-02-22 Rockland New York 36087 91033 890
2237874 2237874 2022-02-21 Rockland New York 36087 91010 890
2234623 2234623 2022-02-20 Rockland New York 36087 90993 889
2231372 2231372 2022-02-19 Rockland New York 36087 90972 889
2228121 2228121 2022-02-18 Rockland New York 36087 90931 888
2224870 2224870 2022-02-17 Rockland New York 36087 90885 888
2221619 2221619 2022-02-16 Rockland New York 36087 90841 886
2218368 2218368 2022-02-15 Rockland New York 36087 90802 885
2215117 2215117 2022-02-14 Rockland New York 36087 90758 885
2211866 2211866 2022-02-13 Rockland New York 36087 90723 885
2208613 2208613 2022-02-12 Rockland New York 36087 90674 885
2205360 2205360 2022-02-11 Rockland New York 36087 90628 885
2202107 2202107 2022-02-10 Rockland New York 36087 90574 884
2198853 2198853 2022-02-09 Rockland New York 36087 90514 884
2195599 2195599 2022-02-08 Rockland New York 36087 90332 884
2192345 2192345 2022-02-07 Rockland New York 36087 90239 884
2189091 2189091 2022-02-06 Rockland New York 36087 90183 884
2185838 2185838 2022-02-05 Rockland New York 36087 90067 883
2182586 2182586 2022-02-04 Rockland New York 36087 89998 883
2179334 2179334 2022-02-03 Rockland New York 36087 89909 883

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