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 = "Essex" 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

  • Essex · 787 ✖
Link rowid date ▲ county state fips cases deaths
2501442 2501442 2022-05-13 Essex New York 36031 6124 61
2498184 2498184 2022-05-12 Essex New York 36031 6124 61
2494926 2494926 2022-05-11 Essex New York 36031 6103 60
2491668 2491668 2022-05-10 Essex New York 36031 6081 59
2488410 2488410 2022-05-09 Essex New York 36031 6072 59
2485153 2485153 2022-05-08 Essex New York 36031 6067 59
2481895 2481895 2022-05-07 Essex New York 36031 6054 59
2478637 2478637 2022-05-06 Essex New York 36031 6026 59
2475379 2475379 2022-05-05 Essex New York 36031 6006 59
2472122 2472122 2022-05-04 Essex New York 36031 5987 59
2468866 2468866 2022-05-03 Essex New York 36031 5979 59
2465610 2465610 2022-05-02 Essex New York 36031 5969 59
2462355 2462355 2022-05-01 Essex New York 36031 5961 59
2459099 2459099 2022-04-30 Essex New York 36031 5951 59
2455843 2455843 2022-04-29 Essex New York 36031 5926 59
2452587 2452587 2022-04-28 Essex New York 36031 5914 59
2449331 2449331 2022-04-27 Essex New York 36031 5902 59
2446074 2446074 2022-04-26 Essex New York 36031 5893 59
2442819 2442819 2022-04-25 Essex New York 36031 5889 59
2439563 2439563 2022-04-24 Essex New York 36031 5880 59
2436307 2436307 2022-04-23 Essex New York 36031 5868 59
2433051 2433051 2022-04-22 Essex New York 36031 5860 59
2429795 2429795 2022-04-21 Essex New York 36031 5850 59
2426539 2426539 2022-04-20 Essex New York 36031 5837 59
2423283 2423283 2022-04-19 Essex New York 36031 5830 59
2420026 2420026 2022-04-18 Essex New York 36031 5827 59
2416771 2416771 2022-04-17 Essex New York 36031 5824 59
2413515 2413515 2022-04-16 Essex New York 36031 5818 59
2410259 2410259 2022-04-15 Essex New York 36031 5810 59
2407003 2407003 2022-04-14 Essex New York 36031 5799 59
2403747 2403747 2022-04-13 Essex New York 36031 5793 59
2400492 2400492 2022-04-12 Essex New York 36031 5781 59
2397237 2397237 2022-04-11 Essex New York 36031 5770 59
2393982 2393982 2022-04-10 Essex New York 36031 5759 59
2390726 2390726 2022-04-09 Essex New York 36031 5748 59
2387470 2387470 2022-04-08 Essex New York 36031 5728 58
2384215 2384215 2022-04-07 Essex New York 36031 5720 58
2380960 2380960 2022-04-06 Essex New York 36031 5712 58
2377705 2377705 2022-04-05 Essex New York 36031 5703 58
2374452 2374452 2022-04-04 Essex New York 36031 5699 58
2371200 2371200 2022-04-03 Essex New York 36031 5695 58
2367947 2367947 2022-04-02 Essex New York 36031 5680 57
2364694 2364694 2022-04-01 Essex New York 36031 5668 57
2361440 2361440 2022-03-31 Essex New York 36031 5650 57
2358186 2358186 2022-03-30 Essex New York 36031 5636 57
2354932 2354932 2022-03-29 Essex New York 36031 5624 57
2351679 2351679 2022-03-28 Essex New York 36031 5620 57
2348427 2348427 2022-03-27 Essex New York 36031 5616 57
2345174 2345174 2022-03-26 Essex New York 36031 5612 57
2341921 2341921 2022-03-25 Essex New York 36031 5605 57
2338668 2338668 2022-03-24 Essex New York 36031 5601 57
2335414 2335414 2022-03-23 Essex New York 36031 5591 57
2332160 2332160 2022-03-22 Essex New York 36031 5579 57
2328907 2328907 2022-03-21 Essex New York 36031 5576 57
2325655 2325655 2022-03-20 Essex New York 36031 5571 57
2322402 2322402 2022-03-19 Essex New York 36031 5565 57
2319148 2319148 2022-03-18 Essex New York 36031 5556 57
2315894 2315894 2022-03-17 Essex New York 36031 5543 57
2312641 2312641 2022-03-16 Essex New York 36031 5533 57
2309388 2309388 2022-03-15 Essex New York 36031 5517 57
2306135 2306135 2022-03-14 Essex New York 36031 5514 57
2302884 2302884 2022-03-13 Essex New York 36031 5513 57
2299632 2299632 2022-03-12 Essex New York 36031 5508 57
2296380 2296380 2022-03-11 Essex New York 36031 5502 57
2293128 2293128 2022-03-10 Essex New York 36031 5498 57
2289876 2289876 2022-03-09 Essex New York 36031 5497 57
2286624 2286624 2022-03-08 Essex New York 36031 5492 57
2283372 2283372 2022-03-07 Essex New York 36031 5490 57
2280120 2280120 2022-03-06 Essex New York 36031 5488 57
2276867 2276867 2022-03-05 Essex New York 36031 5485 57
2273614 2273614 2022-03-04 Essex New York 36031 5476 57
2270361 2270361 2022-03-03 Essex New York 36031 5476 57
2267109 2267109 2022-03-02 Essex New York 36031 5469 56
2263857 2263857 2022-03-01 Essex New York 36031 5465 56
2260606 2260606 2022-02-28 Essex New York 36031 5460 56
2257355 2257355 2022-02-27 Essex New York 36031 5457 56
2254104 2254104 2022-02-26 Essex New York 36031 5451 56
2250853 2250853 2022-02-25 Essex New York 36031 5441 55
2247602 2247602 2022-02-24 Essex New York 36031 5434 55
2244351 2244351 2022-02-23 Essex New York 36031 5406 55
2241100 2241100 2022-02-22 Essex New York 36031 5394 55
2237849 2237849 2022-02-21 Essex New York 36031 5391 55
2234598 2234598 2022-02-20 Essex New York 36031 5386 55
2231347 2231347 2022-02-19 Essex New York 36031 5378 55
2228096 2228096 2022-02-18 Essex New York 36031 5369 55
2224845 2224845 2022-02-17 Essex New York 36031 5356 54
2221594 2221594 2022-02-16 Essex New York 36031 5343 54
2218343 2218343 2022-02-15 Essex New York 36031 5337 54
2215092 2215092 2022-02-14 Essex New York 36031 5336 54
2211841 2211841 2022-02-13 Essex New York 36031 5327 54
2208588 2208588 2022-02-12 Essex New York 36031 5320 54
2205335 2205335 2022-02-11 Essex New York 36031 5298 54
2202082 2202082 2022-02-10 Essex New York 36031 5286 54
2198828 2198828 2022-02-09 Essex New York 36031 5261 54
2195574 2195574 2022-02-08 Essex New York 36031 5249 53
2192320 2192320 2022-02-07 Essex New York 36031 5238 52
2189066 2189066 2022-02-06 Essex New York 36031 5227 52
2185813 2185813 2022-02-05 Essex New York 36031 5213 52
2182561 2182561 2022-02-04 Essex New York 36031 5197 52
2179309 2179309 2022-02-03 Essex New York 36031 5179 52

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