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)
state 5
- Massachusetts 775
- New Jersey 773
- New York 767
- Vermont 746
- Virginia 738
county 1
- Essex · 3,799 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2435675 | 2435675 | 2022-04-23 | Essex | Massachusetts | 25009 | 207962 | 2736 |
2436243 | 2436243 | 2022-04-23 | Essex | New Jersey | 34013 | 216059 | 3602 |
2436307 | 2436307 | 2022-04-23 | Essex | New York | 36031 | 5868 | 59 |
2437360 | 2437360 | 2022-04-23 | Essex | Vermont | 50009 | 1291 | 3 |
2437410 | 2437410 | 2022-04-23 | Essex | Virginia | 51057 | 2261 | 33 |
2432419 | 2432419 | 2022-04-22 | Essex | Massachusetts | 25009 | 207962 | 2736 |
2432987 | 2432987 | 2022-04-22 | Essex | New Jersey | 34013 | 215839 | 3601 |
2433051 | 2433051 | 2022-04-22 | Essex | New York | 36031 | 5860 | 59 |
2434104 | 2434104 | 2022-04-22 | Essex | Vermont | 50009 | 1291 | 3 |
2434154 | 2434154 | 2022-04-22 | Essex | Virginia | 51057 | 2261 | 33 |
2429163 | 2429163 | 2022-04-21 | Essex | Massachusetts | 25009 | 207770 | 2735 |
2429731 | 2429731 | 2022-04-21 | Essex | New Jersey | 34013 | 215585 | 3601 |
2429795 | 2429795 | 2022-04-21 | Essex | New York | 36031 | 5850 | 59 |
2430848 | 2430848 | 2022-04-21 | Essex | Vermont | 50009 | 1289 | 3 |
2430898 | 2430898 | 2022-04-21 | Essex | Virginia | 51057 | 2260 | 32 |
2425907 | 2425907 | 2022-04-20 | Essex | Massachusetts | 25009 | 207493 | 2734 |
2426475 | 2426475 | 2022-04-20 | Essex | New Jersey | 34013 | 215359 | 3600 |
2426539 | 2426539 | 2022-04-20 | Essex | New York | 36031 | 5837 | 59 |
2427592 | 2427592 | 2022-04-20 | Essex | Vermont | 50009 | 1288 | 3 |
2427642 | 2427642 | 2022-04-20 | Essex | Virginia | 51057 | 2259 | 32 |
2422651 | 2422651 | 2022-04-19 | Essex | Massachusetts | 25009 | 207319 | 2731 |
2423219 | 2423219 | 2022-04-19 | Essex | New Jersey | 34013 | 215155 | 3600 |
2423283 | 2423283 | 2022-04-19 | Essex | New York | 36031 | 5830 | 59 |
2424336 | 2424336 | 2022-04-19 | Essex | Vermont | 50009 | 1289 | 3 |
2424386 | 2424386 | 2022-04-19 | Essex | Virginia | 51057 | 2258 | 32 |
2419395 | 2419395 | 2022-04-18 | Essex | Massachusetts | 25009 | 206639 | 2730 |
2419962 | 2419962 | 2022-04-18 | Essex | New Jersey | 34013 | 215010 | 3598 |
2420026 | 2420026 | 2022-04-18 | Essex | New York | 36031 | 5827 | 59 |
2421080 | 2421080 | 2022-04-18 | Essex | Vermont | 50009 | 1289 | 3 |
2421130 | 2421130 | 2022-04-18 | Essex | Virginia | 51057 | 2259 | 32 |
2416139 | 2416139 | 2022-04-17 | Essex | Massachusetts | 25009 | 206639 | 2730 |
2416707 | 2416707 | 2022-04-17 | Essex | New Jersey | 34013 | 214933 | 3600 |
2416771 | 2416771 | 2022-04-17 | Essex | New York | 36031 | 5824 | 59 |
2417824 | 2417824 | 2022-04-17 | Essex | Vermont | 50009 | 1285 | 3 |
2417874 | 2417874 | 2022-04-17 | Essex | Virginia | 51057 | 2258 | 32 |
2412883 | 2412883 | 2022-04-16 | Essex | Massachusetts | 25009 | 206639 | 2730 |
2413451 | 2413451 | 2022-04-16 | Essex | New Jersey | 34013 | 214767 | 3600 |
2413515 | 2413515 | 2022-04-16 | Essex | New York | 36031 | 5818 | 59 |
2414568 | 2414568 | 2022-04-16 | Essex | Vermont | 50009 | 1285 | 3 |
2414618 | 2414618 | 2022-04-16 | Essex | Virginia | 51057 | 2258 | 32 |
2409627 | 2409627 | 2022-04-15 | Essex | Massachusetts | 25009 | 206639 | 2730 |
2410195 | 2410195 | 2022-04-15 | Essex | New Jersey | 34013 | 214304 | 3599 |
2410259 | 2410259 | 2022-04-15 | Essex | New York | 36031 | 5810 | 59 |
2411312 | 2411312 | 2022-04-15 | Essex | Vermont | 50009 | 1285 | 3 |
2411362 | 2411362 | 2022-04-15 | Essex | Virginia | 51057 | 2258 | 32 |
2406371 | 2406371 | 2022-04-14 | Essex | Massachusetts | 25009 | 206382 | 2729 |
2406939 | 2406939 | 2022-04-14 | Essex | New Jersey | 34013 | 214304 | 3599 |
2407003 | 2407003 | 2022-04-14 | Essex | New York | 36031 | 5799 | 59 |
2408056 | 2408056 | 2022-04-14 | Essex | Vermont | 50009 | 1285 | 3 |
2408106 | 2408106 | 2022-04-14 | Essex | Virginia | 51057 | 2259 | 32 |
2403115 | 2403115 | 2022-04-13 | Essex | Massachusetts | 25009 | 206145 | 2730 |
2403683 | 2403683 | 2022-04-13 | Essex | New Jersey | 34013 | 213994 | 3598 |
2403747 | 2403747 | 2022-04-13 | Essex | New York | 36031 | 5793 | 59 |
2404800 | 2404800 | 2022-04-13 | Essex | Vermont | 50009 | 1284 | 3 |
2404850 | 2404850 | 2022-04-13 | Essex | Virginia | 51057 | 2257 | 32 |
2399861 | 2399861 | 2022-04-12 | Essex | Massachusetts | 25009 | 205978 | 2731 |
2400428 | 2400428 | 2022-04-12 | Essex | New Jersey | 34013 | 213770 | 3598 |
2400492 | 2400492 | 2022-04-12 | Essex | New York | 36031 | 5781 | 59 |
2401545 | 2401545 | 2022-04-12 | Essex | Vermont | 50009 | 1285 | 3 |
2401595 | 2401595 | 2022-04-12 | Essex | Virginia | 51057 | 2257 | 32 |
2396605 | 2396605 | 2022-04-11 | Essex | Massachusetts | 25009 | 205824 | 2728 |
2397173 | 2397173 | 2022-04-11 | Essex | New Jersey | 34013 | 213607 | 3598 |
2397237 | 2397237 | 2022-04-11 | Essex | New York | 36031 | 5770 | 59 |
2398290 | 2398290 | 2022-04-11 | Essex | Vermont | 50009 | 1285 | 3 |
2398340 | 2398340 | 2022-04-11 | Essex | Virginia | 51057 | 2257 | 32 |
2393350 | 2393350 | 2022-04-10 | Essex | Massachusetts | 25009 | 205415 | 2729 |
2393918 | 2393918 | 2022-04-10 | Essex | New Jersey | 34013 | 213485 | 3597 |
2393982 | 2393982 | 2022-04-10 | Essex | New York | 36031 | 5759 | 59 |
2395035 | 2395035 | 2022-04-10 | Essex | Vermont | 50009 | 1279 | 3 |
2395085 | 2395085 | 2022-04-10 | Essex | Virginia | 51057 | 2257 | 32 |
2390094 | 2390094 | 2022-04-09 | Essex | Massachusetts | 25009 | 205415 | 2729 |
2390662 | 2390662 | 2022-04-09 | Essex | New Jersey | 34013 | 213301 | 3597 |
2390726 | 2390726 | 2022-04-09 | Essex | New York | 36031 | 5748 | 59 |
2391779 | 2391779 | 2022-04-09 | Essex | Vermont | 50009 | 1279 | 3 |
2391829 | 2391829 | 2022-04-09 | Essex | Virginia | 51057 | 2257 | 32 |
2386838 | 2386838 | 2022-04-08 | Essex | Massachusetts | 25009 | 205415 | 2729 |
2387406 | 2387406 | 2022-04-08 | Essex | New Jersey | 34013 | 213147 | 3597 |
2387470 | 2387470 | 2022-04-08 | Essex | New York | 36031 | 5728 | 58 |
2388523 | 2388523 | 2022-04-08 | Essex | Vermont | 50009 | 1279 | 3 |
2388573 | 2388573 | 2022-04-08 | Essex | Virginia | 51057 | 2257 | 32 |
2383583 | 2383583 | 2022-04-07 | Essex | Massachusetts | 25009 | 205284 | 2729 |
2384151 | 2384151 | 2022-04-07 | Essex | New Jersey | 34013 | 212946 | 3596 |
2384215 | 2384215 | 2022-04-07 | Essex | New York | 36031 | 5720 | 58 |
2385268 | 2385268 | 2022-04-07 | Essex | Vermont | 50009 | 1279 | 3 |
2385318 | 2385318 | 2022-04-07 | Essex | Virginia | 51057 | 2257 | 32 |
2380328 | 2380328 | 2022-04-06 | Essex | Massachusetts | 25009 | 205128 | 2729 |
2380896 | 2380896 | 2022-04-06 | Essex | New Jersey | 34013 | 212763 | 3595 |
2380960 | 2380960 | 2022-04-06 | Essex | New York | 36031 | 5712 | 58 |
2382013 | 2382013 | 2022-04-06 | Essex | Vermont | 50009 | 1279 | 3 |
2382063 | 2382063 | 2022-04-06 | Essex | Virginia | 51057 | 2256 | 32 |
2377073 | 2377073 | 2022-04-05 | Essex | Massachusetts | 25009 | 205012 | 2726 |
2377641 | 2377641 | 2022-04-05 | Essex | New Jersey | 34013 | 212590 | 3594 |
2377705 | 2377705 | 2022-04-05 | Essex | New York | 36031 | 5703 | 58 |
2378758 | 2378758 | 2022-04-05 | Essex | Vermont | 50009 | 1280 | 3 |
2378808 | 2378808 | 2022-04-05 | Essex | Virginia | 51057 | 2256 | 32 |
2373821 | 2373821 | 2022-04-04 | Essex | Massachusetts | 25009 | 204895 | 2725 |
2374388 | 2374388 | 2022-04-04 | Essex | New Jersey | 34013 | 212437 | 3595 |
2374452 | 2374452 | 2022-04-04 | Essex | New York | 36031 | 5699 | 58 |
2375504 | 2375504 | 2022-04-04 | Essex | Vermont | 50009 | 1280 | 3 |
2375554 | 2375554 | 2022-04-04 | Essex | Virginia | 51057 | 2256 | 32 |
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);