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

787 rows where county = "Livingston" 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 · 787 ✖

fips 1

county 1

  • Livingston · 787 ✖
Link rowid date ▲ county state fips cases deaths
2501451 2501451 2022-05-13 Livingston New York 36051 12324 118
2498193 2498193 2022-05-12 Livingston New York 36051 12324 118
2494935 2494935 2022-05-11 Livingston New York 36051 12295 118
2491677 2491677 2022-05-10 Livingston New York 36051 12268 118
2488419 2488419 2022-05-09 Livingston New York 36051 12250 118
2485162 2485162 2022-05-08 Livingston New York 36051 12236 118
2481904 2481904 2022-05-07 Livingston New York 36051 12209 118
2478646 2478646 2022-05-06 Livingston New York 36051 12186 118
2475388 2475388 2022-05-05 Livingston New York 36051 12160 118
2472131 2472131 2022-05-04 Livingston New York 36051 12118 117
2468875 2468875 2022-05-03 Livingston New York 36051 12098 117
2465619 2465619 2022-05-02 Livingston New York 36051 12088 116
2462364 2462364 2022-05-01 Livingston New York 36051 12077 116
2459108 2459108 2022-04-30 Livingston New York 36051 12041 116
2455852 2455852 2022-04-29 Livingston New York 36051 12021 116
2452596 2452596 2022-04-28 Livingston New York 36051 11995 116
2449340 2449340 2022-04-27 Livingston New York 36051 11967 116
2446083 2446083 2022-04-26 Livingston New York 36051 11946 116
2442828 2442828 2022-04-25 Livingston New York 36051 11931 116
2439572 2439572 2022-04-24 Livingston New York 36051 11916 116
2436316 2436316 2022-04-23 Livingston New York 36051 11884 116
2433060 2433060 2022-04-22 Livingston New York 36051 11873 116
2429804 2429804 2022-04-21 Livingston New York 36051 11850 116
2426548 2426548 2022-04-20 Livingston New York 36051 11817 116
2423292 2423292 2022-04-19 Livingston New York 36051 11802 116
2420035 2420035 2022-04-18 Livingston New York 36051 11798 115
2416780 2416780 2022-04-17 Livingston New York 36051 11787 115
2413524 2413524 2022-04-16 Livingston New York 36051 11778 115
2410268 2410268 2022-04-15 Livingston New York 36051 11753 115
2407012 2407012 2022-04-14 Livingston New York 36051 11739 115
2403756 2403756 2022-04-13 Livingston New York 36051 11723 115
2400501 2400501 2022-04-12 Livingston New York 36051 11711 115
2397246 2397246 2022-04-11 Livingston New York 36051 11705 115
2393991 2393991 2022-04-10 Livingston New York 36051 11696 115
2390735 2390735 2022-04-09 Livingston New York 36051 11687 115
2387479 2387479 2022-04-08 Livingston New York 36051 11665 115
2384224 2384224 2022-04-07 Livingston New York 36051 11646 115
2380969 2380969 2022-04-06 Livingston New York 36051 11633 115
2377714 2377714 2022-04-05 Livingston New York 36051 11623 115
2374461 2374461 2022-04-04 Livingston New York 36051 11617 115
2371209 2371209 2022-04-03 Livingston New York 36051 11605 115
2367956 2367956 2022-04-02 Livingston New York 36051 11596 115
2364703 2364703 2022-04-01 Livingston New York 36051 11593 115
2361449 2361449 2022-03-31 Livingston New York 36051 11584 115
2358195 2358195 2022-03-30 Livingston New York 36051 11583 115
2354941 2354941 2022-03-29 Livingston New York 36051 11581 115
2351688 2351688 2022-03-28 Livingston New York 36051 11579 115
2348436 2348436 2022-03-27 Livingston New York 36051 11577 114
2345183 2345183 2022-03-26 Livingston New York 36051 11573 114
2341930 2341930 2022-03-25 Livingston New York 36051 11566 114
2338677 2338677 2022-03-24 Livingston New York 36051 11563 114
2335423 2335423 2022-03-23 Livingston New York 36051 11562 114
2332169 2332169 2022-03-22 Livingston New York 36051 11557 114
2328916 2328916 2022-03-21 Livingston New York 36051 11556 113
2325664 2325664 2022-03-20 Livingston New York 36051 11555 113
2322411 2322411 2022-03-19 Livingston New York 36051 11552 113
2319157 2319157 2022-03-18 Livingston New York 36051 11545 113
2315903 2315903 2022-03-17 Livingston New York 36051 11537 113
2312650 2312650 2022-03-16 Livingston New York 36051 11532 113
2309397 2309397 2022-03-15 Livingston New York 36051 11529 113
2306144 2306144 2022-03-14 Livingston New York 36051 11525 113
2302893 2302893 2022-03-13 Livingston New York 36051 11523 113
2299641 2299641 2022-03-12 Livingston New York 36051 11521 113
2296389 2296389 2022-03-11 Livingston New York 36051 11511 113
2293137 2293137 2022-03-10 Livingston New York 36051 11503 113
2289885 2289885 2022-03-09 Livingston New York 36051 11499 113
2286633 2286633 2022-03-08 Livingston New York 36051 11498 113
2283381 2283381 2022-03-07 Livingston New York 36051 11497 113
2280129 2280129 2022-03-06 Livingston New York 36051 11496 113
2276876 2276876 2022-03-05 Livingston New York 36051 11494 113
2273623 2273623 2022-03-04 Livingston New York 36051 11478 113
2270370 2270370 2022-03-03 Livingston New York 36051 11478 112
2267118 2267118 2022-03-02 Livingston New York 36051 11475 112
2263866 2263866 2022-03-01 Livingston New York 36051 11467 112
2260615 2260615 2022-02-28 Livingston New York 36051 11467 111
2257364 2257364 2022-02-27 Livingston New York 36051 11464 111
2254113 2254113 2022-02-26 Livingston New York 36051 11459 111
2250862 2250862 2022-02-25 Livingston New York 36051 11454 111
2247611 2247611 2022-02-24 Livingston New York 36051 11451 110
2244360 2244360 2022-02-23 Livingston New York 36051 11442 110
2241109 2241109 2022-02-22 Livingston New York 36051 11440 110
2237858 2237858 2022-02-21 Livingston New York 36051 11437 110
2234607 2234607 2022-02-20 Livingston New York 36051 11431 110
2231356 2231356 2022-02-19 Livingston New York 36051 11421 110
2228105 2228105 2022-02-18 Livingston New York 36051 11409 110
2224854 2224854 2022-02-17 Livingston New York 36051 11399 110
2221603 2221603 2022-02-16 Livingston New York 36051 11379 109
2218352 2218352 2022-02-15 Livingston New York 36051 11340 109
2215101 2215101 2022-02-14 Livingston New York 36051 11333 109
2211850 2211850 2022-02-13 Livingston New York 36051 11321 109
2208597 2208597 2022-02-12 Livingston New York 36051 11308 107
2205344 2205344 2022-02-11 Livingston New York 36051 11296 107
2202091 2202091 2022-02-10 Livingston New York 36051 11275 106
2198837 2198837 2022-02-09 Livingston New York 36051 11234 106
2195583 2195583 2022-02-08 Livingston New York 36051 11219 106
2192329 2192329 2022-02-07 Livingston New York 36051 11206 106
2189075 2189075 2022-02-06 Livingston New York 36051 11192 106
2185822 2185822 2022-02-05 Livingston New York 36051 11177 106
2182570 2182570 2022-02-04 Livingston New York 36051 11144 106
2179318 2179318 2022-02-03 Livingston New York 36051 11092 105

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