ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,899 rows where county = "Essex" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 5
- Massachusetts 795
- New Jersey 793
- New York 787
- Vermont 766
- Virginia 758
county 1
- Essex · 3,899 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500810 | 2500810 | 2022-05-13 | Essex | Massachusetts | 25009 | 214332 | 2758 |
2501378 | 2501378 | 2022-05-13 | Essex | New Jersey | 34013 | 222558 | 3614 |
2501442 | 2501442 | 2022-05-13 | Essex | New York | 36031 | 6124 | 61 |
2502496 | 2502496 | 2022-05-13 | Essex | Vermont | 50009 | 1301 | 3 |
2502546 | 2502546 | 2022-05-13 | Essex | Virginia | 51057 | 2285 | 33 |
2497552 | 2497552 | 2022-05-12 | Essex | Massachusetts | 25009 | 213890 | 2758 |
2498120 | 2498120 | 2022-05-12 | Essex | New Jersey | 34013 | 221984 | 3612 |
2498184 | 2498184 | 2022-05-12 | Essex | New York | 36031 | 6124 | 61 |
2499238 | 2499238 | 2022-05-12 | Essex | Vermont | 50009 | 1296 | 3 |
2499288 | 2499288 | 2022-05-12 | Essex | Virginia | 51057 | 2279 | 33 |
2494294 | 2494294 | 2022-05-11 | Essex | Massachusetts | 25009 | 213261 | 2758 |
2494862 | 2494862 | 2022-05-11 | Essex | New Jersey | 34013 | 221477 | 3611 |
2494926 | 2494926 | 2022-05-11 | Essex | New York | 36031 | 6103 | 60 |
2495980 | 2495980 | 2022-05-11 | Essex | Vermont | 50009 | 1292 | 3 |
2496030 | 2496030 | 2022-05-11 | Essex | Virginia | 51057 | 2278 | 33 |
2491036 | 2491036 | 2022-05-10 | Essex | Massachusetts | 25009 | 212871 | 2757 |
2491604 | 2491604 | 2022-05-10 | Essex | New Jersey | 34013 | 221033 | 3611 |
2491668 | 2491668 | 2022-05-10 | Essex | New York | 36031 | 6081 | 59 |
2492722 | 2492722 | 2022-05-10 | Essex | Vermont | 50009 | 1291 | 3 |
2492772 | 2492772 | 2022-05-10 | Essex | Virginia | 51057 | 2277 | 33 |
2487779 | 2487779 | 2022-05-09 | Essex | Massachusetts | 25009 | 212536 | 2747 |
2488346 | 2488346 | 2022-05-09 | Essex | New Jersey | 34013 | 220683 | 3611 |
2488410 | 2488410 | 2022-05-09 | Essex | New York | 36031 | 6072 | 59 |
2489464 | 2489464 | 2022-05-09 | Essex | Vermont | 50009 | 1290 | 3 |
2489514 | 2489514 | 2022-05-09 | Essex | Virginia | 51057 | 2278 | 33 |
2484521 | 2484521 | 2022-05-08 | Essex | Massachusetts | 25009 | 211651 | 2748 |
2485089 | 2485089 | 2022-05-08 | Essex | New Jersey | 34013 | 220451 | 3610 |
2485153 | 2485153 | 2022-05-08 | Essex | New York | 36031 | 6067 | 59 |
2486206 | 2486206 | 2022-05-08 | Essex | Vermont | 50009 | 1286 | 3 |
2486257 | 2486257 | 2022-05-08 | Essex | Virginia | 51057 | 2277 | 33 |
2481263 | 2481263 | 2022-05-07 | Essex | Massachusetts | 25009 | 211651 | 2748 |
2481831 | 2481831 | 2022-05-07 | Essex | New Jersey | 34013 | 220065 | 3610 |
2481895 | 2481895 | 2022-05-07 | Essex | New York | 36031 | 6054 | 59 |
2482948 | 2482948 | 2022-05-07 | Essex | Vermont | 50009 | 1286 | 3 |
2482999 | 2482999 | 2022-05-07 | Essex | Virginia | 51057 | 2277 | 33 |
2478005 | 2478005 | 2022-05-06 | Essex | Massachusetts | 25009 | 211651 | 2748 |
2478573 | 2478573 | 2022-05-06 | Essex | New Jersey | 34013 | 219718 | 3610 |
2478637 | 2478637 | 2022-05-06 | Essex | New York | 36031 | 6026 | 59 |
2479690 | 2479690 | 2022-05-06 | Essex | Vermont | 50009 | 1286 | 3 |
2479741 | 2479741 | 2022-05-06 | Essex | Virginia | 51057 | 2277 | 33 |
2474747 | 2474747 | 2022-05-05 | Essex | Massachusetts | 25009 | 211312 | 2747 |
2475315 | 2475315 | 2022-05-05 | Essex | New Jersey | 34013 | 219342 | 3610 |
2475379 | 2475379 | 2022-05-05 | Essex | New York | 36031 | 6006 | 59 |
2476432 | 2476432 | 2022-05-05 | Essex | Vermont | 50009 | 1285 | 3 |
2476483 | 2476483 | 2022-05-05 | Essex | Virginia | 51057 | 2274 | 33 |
2471490 | 2471490 | 2022-05-04 | Essex | Massachusetts | 25009 | 210805 | 2745 |
2472058 | 2472058 | 2022-05-04 | Essex | New Jersey | 34013 | 218989 | 3610 |
2472122 | 2472122 | 2022-05-04 | Essex | New York | 36031 | 5987 | 59 |
2473175 | 2473175 | 2022-05-04 | Essex | Vermont | 50009 | 1283 | 3 |
2473225 | 2473225 | 2022-05-04 | Essex | Virginia | 51057 | 2272 | 33 |
2468234 | 2468234 | 2022-05-03 | Essex | Massachusetts | 25009 | 210536 | 2742 |
2468802 | 2468802 | 2022-05-03 | Essex | New Jersey | 34013 | 218710 | 3607 |
2468866 | 2468866 | 2022-05-03 | Essex | New York | 36031 | 5979 | 59 |
2469919 | 2469919 | 2022-05-03 | Essex | Vermont | 50009 | 1283 | 3 |
2469969 | 2469969 | 2022-05-03 | Essex | Virginia | 51057 | 2272 | 33 |
2464979 | 2464979 | 2022-05-02 | Essex | Massachusetts | 25009 | 210295 | 2742 |
2465546 | 2465546 | 2022-05-02 | Essex | New Jersey | 34013 | 218510 | 3606 |
2465610 | 2465610 | 2022-05-02 | Essex | New York | 36031 | 5969 | 59 |
2466663 | 2466663 | 2022-05-02 | Essex | Vermont | 50009 | 1282 | 3 |
2466713 | 2466713 | 2022-05-02 | Essex | Virginia | 51057 | 2271 | 33 |
2461723 | 2461723 | 2022-05-01 | Essex | Massachusetts | 25009 | 209640 | 2740 |
2462291 | 2462291 | 2022-05-01 | Essex | New Jersey | 34013 | 218154 | 3604 |
2462355 | 2462355 | 2022-05-01 | Essex | New York | 36031 | 5961 | 59 |
2463408 | 2463408 | 2022-05-01 | Essex | Vermont | 50009 | 1281 | 3 |
2463458 | 2463458 | 2022-05-01 | Essex | Virginia | 51057 | 2265 | 33 |
2458467 | 2458467 | 2022-04-30 | Essex | Massachusetts | 25009 | 209640 | 2740 |
2459035 | 2459035 | 2022-04-30 | Essex | New Jersey | 34013 | 217910 | 3604 |
2459099 | 2459099 | 2022-04-30 | Essex | New York | 36031 | 5951 | 59 |
2460152 | 2460152 | 2022-04-30 | Essex | Vermont | 50009 | 1281 | 3 |
2460202 | 2460202 | 2022-04-30 | Essex | Virginia | 51057 | 2265 | 33 |
2455211 | 2455211 | 2022-04-29 | Essex | Massachusetts | 25009 | 209640 | 2740 |
2455779 | 2455779 | 2022-04-29 | Essex | New Jersey | 34013 | 217586 | 3604 |
2455843 | 2455843 | 2022-04-29 | Essex | New York | 36031 | 5926 | 59 |
2456896 | 2456896 | 2022-04-29 | Essex | Vermont | 50009 | 1281 | 3 |
2456946 | 2456946 | 2022-04-29 | Essex | Virginia | 51057 | 2265 | 33 |
2451955 | 2451955 | 2022-04-28 | Essex | Massachusetts | 25009 | 209340 | 2739 |
2452523 | 2452523 | 2022-04-28 | Essex | New Jersey | 34013 | 217255 | 3604 |
2452587 | 2452587 | 2022-04-28 | Essex | New York | 36031 | 5914 | 59 |
2453640 | 2453640 | 2022-04-28 | Essex | Vermont | 50009 | 1281 | 3 |
2453690 | 2453690 | 2022-04-28 | Essex | Virginia | 51057 | 2265 | 33 |
2448699 | 2448699 | 2022-04-27 | Essex | Massachusetts | 25009 | 209027 | 2738 |
2449267 | 2449267 | 2022-04-27 | Essex | New Jersey | 34013 | 216999 | 3604 |
2449331 | 2449331 | 2022-04-27 | Essex | New York | 36031 | 5902 | 59 |
2450384 | 2450384 | 2022-04-27 | Essex | Vermont | 50009 | 1291 | 3 |
2450434 | 2450434 | 2022-04-27 | Essex | Virginia | 51057 | 2264 | 33 |
2445443 | 2445443 | 2022-04-26 | Essex | Massachusetts | 25009 | 208775 | 2737 |
2446010 | 2446010 | 2022-04-26 | Essex | New Jersey | 34013 | 216680 | 3603 |
2446074 | 2446074 | 2022-04-26 | Essex | New York | 36031 | 5893 | 59 |
2447127 | 2447127 | 2022-04-26 | Essex | Vermont | 50009 | 1291 | 3 |
2447177 | 2447177 | 2022-04-26 | Essex | Virginia | 51057 | 2263 | 33 |
2442187 | 2442187 | 2022-04-25 | Essex | Massachusetts | 25009 | 208519 | 2738 |
2442755 | 2442755 | 2022-04-25 | Essex | New Jersey | 34013 | 216385 | 3603 |
2442819 | 2442819 | 2022-04-25 | Essex | New York | 36031 | 5889 | 59 |
2443872 | 2443872 | 2022-04-25 | Essex | Vermont | 50009 | 1291 | 3 |
2443922 | 2443922 | 2022-04-25 | Essex | Virginia | 51057 | 2263 | 33 |
2438931 | 2438931 | 2022-04-24 | Essex | Massachusetts | 25009 | 207962 | 2736 |
2439499 | 2439499 | 2022-04-24 | Essex | New Jersey | 34013 | 216241 | 3602 |
2439563 | 2439563 | 2022-04-24 | Essex | New York | 36031 | 5880 | 59 |
2440616 | 2440616 | 2022-04-24 | Essex | Vermont | 50009 | 1291 | 3 |
2440666 | 2440666 | 2022-04-24 | Essex | Virginia | 51057 | 2261 | 33 |
Advanced export
JSON shape: default, array, newline-delimited
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);