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 deaths
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 ▼ |
---|---|---|---|---|---|---|---|
1075 | 1075 | 2020-03-10 | Essex | Massachusetts | 25009 | 1 | 0 |
1255 | 1255 | 2020-03-11 | Essex | Massachusetts | 25009 | 1 | 0 |
1473 | 1473 | 2020-03-12 | Essex | Massachusetts | 25009 | 2 | 0 |
1505 | 1505 | 2020-03-12 | Essex | New Jersey | 34013 | 1 | 0 |
1752 | 1752 | 2020-03-13 | Essex | Massachusetts | 25009 | 2 | 0 |
1797 | 1797 | 2020-03-13 | Essex | New Jersey | 34013 | 6 | 0 |
2095 | 2095 | 2020-03-14 | Essex | Massachusetts | 25009 | 5 | 0 |
2143 | 2143 | 2020-03-14 | Essex | New Jersey | 34013 | 7 | 0 |
2496 | 2496 | 2020-03-15 | Essex | Massachusetts | 25009 | 6 | 0 |
2551 | 2551 | 2020-03-15 | Essex | New Jersey | 34013 | 11 | 0 |
2945 | 2945 | 2020-03-16 | Essex | Massachusetts | 25009 | 7 | 0 |
3007 | 3007 | 2020-03-16 | Essex | New Jersey | 34013 | 20 | 0 |
3446 | 3446 | 2020-03-17 | Essex | Massachusetts | 25009 | 8 | 0 |
3519 | 3519 | 2020-03-17 | Essex | New Jersey | 34013 | 32 | 0 |
4028 | 4028 | 2020-03-18 | Essex | Massachusetts | 25009 | 14 | 0 |
4115 | 4115 | 2020-03-18 | Essex | New Jersey | 34013 | 45 | 0 |
4142 | 4142 | 2020-03-18 | Essex | New York | 36031 | 1 | 0 |
4732 | 4732 | 2020-03-19 | Essex | Massachusetts | 25009 | 19 | 0 |
4871 | 4871 | 2020-03-19 | Essex | New York | 36031 | 1 | 0 |
5551 | 5551 | 2020-03-20 | Essex | Massachusetts | 25009 | 29 | 0 |
5718 | 5718 | 2020-03-20 | Essex | New York | 36031 | 1 | 0 |
6510 | 6510 | 2020-03-21 | Essex | Massachusetts | 25009 | 41 | 0 |
6712 | 6712 | 2020-03-21 | Essex | New York | 36031 | 2 | 0 |
7587 | 7587 | 2020-03-22 | Essex | Massachusetts | 25009 | 60 | 0 |
7806 | 7806 | 2020-03-22 | Essex | New York | 36031 | 3 | 0 |
9004 | 9004 | 2020-03-23 | Essex | New York | 36031 | 3 | 0 |
10311 | 10311 | 2020-03-24 | Essex | New York | 36031 | 3 | 0 |
11746 | 11746 | 2020-03-25 | Essex | New York | 36031 | 4 | 0 |
13349 | 13349 | 2020-03-26 | Essex | New York | 36031 | 4 | 0 |
15083 | 15083 | 2020-03-27 | Essex | New York | 36031 | 4 | 0 |
16913 | 16913 | 2020-03-28 | Essex | New York | 36031 | 4 | 0 |
18837 | 18837 | 2020-03-29 | Essex | New York | 36031 | 4 | 0 |
20876 | 20876 | 2020-03-30 | Essex | New York | 36031 | 5 | 0 |
22999 | 22999 | 2020-03-31 | Essex | New York | 36031 | 5 | 0 |
25193 | 25193 | 2020-04-01 | Essex | New York | 36031 | 6 | 0 |
27453 | 27453 | 2020-04-02 | Essex | New York | 36031 | 6 | 0 |
29777 | 29777 | 2020-04-03 | Essex | New York | 36031 | 6 | 0 |
32163 | 32163 | 2020-04-04 | Essex | New York | 36031 | 7 | 0 |
34594 | 34594 | 2020-04-05 | Essex | New York | 36031 | 7 | 0 |
37064 | 37064 | 2020-04-06 | Essex | New York | 36031 | 7 | 0 |
39579 | 39579 | 2020-04-07 | Essex | New York | 36031 | 7 | 0 |
42136 | 42136 | 2020-04-08 | Essex | New York | 36031 | 7 | 0 |
42907 | 42907 | 2020-04-08 | Essex | Vermont | 50009 | 3 | 0 |
44719 | 44719 | 2020-04-09 | Essex | New York | 36031 | 8 | 0 |
45501 | 45501 | 2020-04-09 | Essex | Vermont | 50009 | 1 | 0 |
47332 | 47332 | 2020-04-10 | Essex | New York | 36031 | 10 | 0 |
48125 | 48125 | 2020-04-10 | Essex | Vermont | 50009 | 1 | 0 |
49987 | 49987 | 2020-04-11 | Essex | New York | 36031 | 12 | 0 |
50783 | 50783 | 2020-04-11 | Essex | Vermont | 50009 | 1 | 0 |
52660 | 52660 | 2020-04-12 | Essex | New York | 36031 | 12 | 0 |
53458 | 53458 | 2020-04-12 | Essex | Vermont | 50009 | 1 | 0 |
55343 | 55343 | 2020-04-13 | Essex | New York | 36031 | 12 | 0 |
56147 | 56147 | 2020-04-13 | Essex | Vermont | 50009 | 1 | 0 |
58043 | 58043 | 2020-04-14 | Essex | New York | 36031 | 12 | 0 |
58853 | 58853 | 2020-04-14 | Essex | Vermont | 50009 | 1 | 0 |
60757 | 60757 | 2020-04-15 | Essex | New York | 36031 | 12 | 0 |
61572 | 61572 | 2020-04-15 | Essex | Vermont | 50009 | 1 | 0 |
63483 | 63483 | 2020-04-16 | Essex | New York | 36031 | 12 | 0 |
64304 | 64304 | 2020-04-16 | Essex | Vermont | 50009 | 1 | 0 |
64351 | 64351 | 2020-04-16 | Essex | Virginia | 51057 | 2 | 0 |
66225 | 66225 | 2020-04-17 | Essex | New York | 36031 | 15 | 0 |
67052 | 67052 | 2020-04-17 | Essex | Vermont | 50009 | 1 | 0 |
67099 | 67099 | 2020-04-17 | Essex | Virginia | 51057 | 2 | 0 |
68982 | 68982 | 2020-04-18 | Essex | New York | 36031 | 22 | 0 |
69814 | 69814 | 2020-04-18 | Essex | Vermont | 50009 | 1 | 0 |
69861 | 69861 | 2020-04-18 | Essex | Virginia | 51057 | 2 | 0 |
71749 | 71749 | 2020-04-19 | Essex | New York | 36031 | 24 | 0 |
72584 | 72584 | 2020-04-19 | Essex | Vermont | 50009 | 2 | 0 |
72631 | 72631 | 2020-04-19 | Essex | Virginia | 51057 | 2 | 0 |
74524 | 74524 | 2020-04-20 | Essex | New York | 36031 | 26 | 0 |
75360 | 75360 | 2020-04-20 | Essex | Vermont | 50009 | 2 | 0 |
75407 | 75407 | 2020-04-20 | Essex | Virginia | 51057 | 2 | 0 |
77305 | 77305 | 2020-04-21 | Essex | New York | 36031 | 27 | 0 |
78142 | 78142 | 2020-04-21 | Essex | Vermont | 50009 | 2 | 0 |
78189 | 78189 | 2020-04-21 | Essex | Virginia | 51057 | 2 | 0 |
80094 | 80094 | 2020-04-22 | Essex | New York | 36031 | 28 | 0 |
80934 | 80934 | 2020-04-22 | Essex | Vermont | 50009 | 2 | 0 |
80981 | 80981 | 2020-04-22 | Essex | Virginia | 51057 | 2 | 0 |
82893 | 82893 | 2020-04-23 | Essex | New York | 36031 | 22 | 0 |
83735 | 83735 | 2020-04-23 | Essex | Vermont | 50009 | 2 | 0 |
83782 | 83782 | 2020-04-23 | Essex | Virginia | 51057 | 3 | 0 |
85697 | 85697 | 2020-04-24 | Essex | New York | 36031 | 28 | 0 |
86542 | 86542 | 2020-04-24 | Essex | Vermont | 50009 | 2 | 0 |
86589 | 86589 | 2020-04-24 | Essex | Virginia | 51057 | 3 | 0 |
88509 | 88509 | 2020-04-25 | Essex | New York | 36031 | 30 | 0 |
89357 | 89357 | 2020-04-25 | Essex | Vermont | 50009 | 2 | 0 |
89404 | 89404 | 2020-04-25 | Essex | Virginia | 51057 | 4 | 0 |
91324 | 91324 | 2020-04-26 | Essex | New York | 36031 | 30 | 0 |
92174 | 92174 | 2020-04-26 | Essex | Vermont | 50009 | 2 | 0 |
92221 | 92221 | 2020-04-26 | Essex | Virginia | 51057 | 6 | 0 |
94149 | 94149 | 2020-04-27 | Essex | New York | 36031 | 30 | 0 |
95003 | 95003 | 2020-04-27 | Essex | Vermont | 50009 | 2 | 0 |
95050 | 95050 | 2020-04-27 | Essex | Virginia | 51057 | 6 | 0 |
96985 | 96985 | 2020-04-28 | Essex | New York | 36031 | 32 | 0 |
97845 | 97845 | 2020-04-28 | Essex | Vermont | 50009 | 2 | 0 |
97892 | 97892 | 2020-04-28 | Essex | Virginia | 51057 | 6 | 0 |
99832 | 99832 | 2020-04-29 | Essex | New York | 36031 | 33 | 0 |
100695 | 100695 | 2020-04-29 | Essex | Vermont | 50009 | 2 | 0 |
100742 | 100742 | 2020-04-29 | Essex | Virginia | 51057 | 6 | 0 |
102685 | 102685 | 2020-04-30 | Essex | New York | 36031 | 34 | 0 |
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);