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

798 rows where fips = 36091 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 · 798 ✖

fips 1

  • 36091 · 798 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501468 2501468 2022-05-13 Saratoga New York 36091 49890 335
2498210 2498210 2022-05-12 Saratoga New York 36091 49890 335
2494952 2494952 2022-05-11 Saratoga New York 36091 49695 333
2491694 2491694 2022-05-10 Saratoga New York 36091 49553 333
2488436 2488436 2022-05-09 Saratoga New York 36091 49486 333
2485179 2485179 2022-05-08 Saratoga New York 36091 49337 332
2481921 2481921 2022-05-07 Saratoga New York 36091 49250 332
2478663 2478663 2022-05-06 Saratoga New York 36091 49094 331
2475405 2475405 2022-05-05 Saratoga New York 36091 48915 331
2472148 2472148 2022-05-04 Saratoga New York 36091 48727 331
2468892 2468892 2022-05-03 Saratoga New York 36091 48603 331
2465636 2465636 2022-05-02 Saratoga New York 36091 48520 330
2462381 2462381 2022-05-01 Saratoga New York 36091 48435 330
2459125 2459125 2022-04-30 Saratoga New York 36091 48317 330
2455869 2455869 2022-04-29 Saratoga New York 36091 48181 330
2452613 2452613 2022-04-28 Saratoga New York 36091 48038 330
2449357 2449357 2022-04-27 Saratoga New York 36091 47889 330
2446100 2446100 2022-04-26 Saratoga New York 36091 47759 330
2442845 2442845 2022-04-25 Saratoga New York 36091 47667 330
2439589 2439589 2022-04-24 Saratoga New York 36091 47557 330
2436333 2436333 2022-04-23 Saratoga New York 36091 47467 330
2433077 2433077 2022-04-22 Saratoga New York 36091 47372 330
2429821 2429821 2022-04-21 Saratoga New York 36091 47238 329
2426565 2426565 2022-04-20 Saratoga New York 36091 47135 329
2423309 2423309 2022-04-19 Saratoga New York 36091 47061 329
2420052 2420052 2022-04-18 Saratoga New York 36091 47029 329
2416797 2416797 2022-04-17 Saratoga New York 36091 46972 329
2413541 2413541 2022-04-16 Saratoga New York 36091 46864 329
2410285 2410285 2022-04-15 Saratoga New York 36091 46763 329
2407029 2407029 2022-04-14 Saratoga New York 36091 46646 329
2403773 2403773 2022-04-13 Saratoga New York 36091 46539 329
2400518 2400518 2022-04-12 Saratoga New York 36091 46479 329
2397263 2397263 2022-04-11 Saratoga New York 36091 46439 329
2394008 2394008 2022-04-10 Saratoga New York 36091 46395 329
2390752 2390752 2022-04-09 Saratoga New York 36091 46336 328
2387496 2387496 2022-04-08 Saratoga New York 36091 46272 327
2384241 2384241 2022-04-07 Saratoga New York 36091 46210 327
2380986 2380986 2022-04-06 Saratoga New York 36091 46161 327
2377731 2377731 2022-04-05 Saratoga New York 36091 46118 326
2374478 2374478 2022-04-04 Saratoga New York 36091 46089 326
2371226 2371226 2022-04-03 Saratoga New York 36091 46072 325
2367973 2367973 2022-04-02 Saratoga New York 36091 46041 325
2364720 2364720 2022-04-01 Saratoga New York 36091 46007 325
2361466 2361466 2022-03-31 Saratoga New York 36091 45959 325
2358212 2358212 2022-03-30 Saratoga New York 36091 45929 325
2354958 2354958 2022-03-29 Saratoga New York 36091 45898 325
2351705 2351705 2022-03-28 Saratoga New York 36091 45873 325
2348453 2348453 2022-03-27 Saratoga New York 36091 45854 325
2345200 2345200 2022-03-26 Saratoga New York 36091 45829 325
2341947 2341947 2022-03-25 Saratoga New York 36091 45802 324
2338694 2338694 2022-03-24 Saratoga New York 36091 45762 323
2335440 2335440 2022-03-23 Saratoga New York 36091 45734 323
2332186 2332186 2022-03-22 Saratoga New York 36091 45679 323
2328933 2328933 2022-03-21 Saratoga New York 36091 45661 323
2325681 2325681 2022-03-20 Saratoga New York 36091 45648 323
2322428 2322428 2022-03-19 Saratoga New York 36091 45629 323
2319174 2319174 2022-03-18 Saratoga New York 36091 45609 323
2315920 2315920 2022-03-17 Saratoga New York 36091 45580 323
2312667 2312667 2022-03-16 Saratoga New York 36091 45527 323
2309414 2309414 2022-03-15 Saratoga New York 36091 45492 323
2306161 2306161 2022-03-14 Saratoga New York 36091 45478 323
2302910 2302910 2022-03-13 Saratoga New York 36091 45468 323
2299658 2299658 2022-03-12 Saratoga New York 36091 45444 322
2296406 2296406 2022-03-11 Saratoga New York 36091 45415 322
2293154 2293154 2022-03-10 Saratoga New York 36091 45369 321
2289902 2289902 2022-03-09 Saratoga New York 36091 45346 320
2286650 2286650 2022-03-08 Saratoga New York 36091 45322 320
2283398 2283398 2022-03-07 Saratoga New York 36091 45298 319
2280146 2280146 2022-03-06 Saratoga New York 36091 45276 319
2276893 2276893 2022-03-05 Saratoga New York 36091 45250 319
2273640 2273640 2022-03-04 Saratoga New York 36091 45175 318
2270387 2270387 2022-03-03 Saratoga New York 36091 45175 318
2267135 2267135 2022-03-02 Saratoga New York 36091 45140 318
2263883 2263883 2022-03-01 Saratoga New York 36091 45101 318
2260632 2260632 2022-02-28 Saratoga New York 36091 45072 318
2257381 2257381 2022-02-27 Saratoga New York 36091 45059 318
2254130 2254130 2022-02-26 Saratoga New York 36091 45028 318
2250879 2250879 2022-02-25 Saratoga New York 36091 44982 318
2247628 2247628 2022-02-24 Saratoga New York 36091 44947 318
2244377 2244377 2022-02-23 Saratoga New York 36091 44902 318
2241126 2241126 2022-02-22 Saratoga New York 36091 44866 318
2237875 2237875 2022-02-21 Saratoga New York 36091 44837 318
2234624 2234624 2022-02-20 Saratoga New York 36091 44806 318
2231373 2231373 2022-02-19 Saratoga New York 36091 44769 317
2228122 2228122 2022-02-18 Saratoga New York 36091 44711 317
2224871 2224871 2022-02-17 Saratoga New York 36091 44651 317
2221620 2221620 2022-02-16 Saratoga New York 36091 44577 315
2218369 2218369 2022-02-15 Saratoga New York 36091 44526 315
2215118 2215118 2022-02-14 Saratoga New York 36091 44496 314
2211867 2211867 2022-02-13 Saratoga New York 36091 44437 314
2208614 2208614 2022-02-12 Saratoga New York 36091 44396 313
2205361 2205361 2022-02-11 Saratoga New York 36091 44325 313
2202108 2202108 2022-02-10 Saratoga New York 36091 44224 313
2198854 2198854 2022-02-09 Saratoga New York 36091 44117 313
2195600 2195600 2022-02-08 Saratoga New York 36091 44007 313
2192346 2192346 2022-02-07 Saratoga New York 36091 43946 313
2189092 2189092 2022-02-06 Saratoga New York 36091 43901 310
2185839 2185839 2022-02-05 Saratoga New York 36091 43784 310
2182587 2182587 2022-02-04 Saratoga New York 36091 43705 309
2179335 2179335 2022-02-03 Saratoga New York 36091 43541 307

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