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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, 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 |
1505 | 1505 | 2020-03-12 | Essex | New Jersey | 34013 | 1 | 0 |
4142 | 4142 | 2020-03-18 | Essex | New York | 36031 | 1 | 0 |
4871 | 4871 | 2020-03-19 | Essex | New York | 36031 | 1 | 0 |
5718 | 5718 | 2020-03-20 | Essex | New York | 36031 | 1 | 0 |
45501 | 45501 | 2020-04-09 | Essex | Vermont | 50009 | 1 | 0 |
48125 | 48125 | 2020-04-10 | Essex | Vermont | 50009 | 1 | 0 |
50783 | 50783 | 2020-04-11 | Essex | Vermont | 50009 | 1 | 0 |
53458 | 53458 | 2020-04-12 | Essex | Vermont | 50009 | 1 | 0 |
56147 | 56147 | 2020-04-13 | Essex | Vermont | 50009 | 1 | 0 |
58853 | 58853 | 2020-04-14 | Essex | Vermont | 50009 | 1 | 0 |
61572 | 61572 | 2020-04-15 | Essex | Vermont | 50009 | 1 | 0 |
64304 | 64304 | 2020-04-16 | Essex | Vermont | 50009 | 1 | 0 |
67052 | 67052 | 2020-04-17 | Essex | Vermont | 50009 | 1 | 0 |
69814 | 69814 | 2020-04-18 | Essex | Vermont | 50009 | 1 | 0 |
1473 | 1473 | 2020-03-12 | Essex | Massachusetts | 25009 | 2 | 0 |
1752 | 1752 | 2020-03-13 | Essex | Massachusetts | 25009 | 2 | 0 |
6712 | 6712 | 2020-03-21 | Essex | New York | 36031 | 2 | 0 |
64351 | 64351 | 2020-04-16 | Essex | Virginia | 51057 | 2 | 0 |
67099 | 67099 | 2020-04-17 | Essex | Virginia | 51057 | 2 | 0 |
69861 | 69861 | 2020-04-18 | Essex | Virginia | 51057 | 2 | 0 |
72584 | 72584 | 2020-04-19 | Essex | Vermont | 50009 | 2 | 0 |
72631 | 72631 | 2020-04-19 | Essex | Virginia | 51057 | 2 | 0 |
75360 | 75360 | 2020-04-20 | Essex | Vermont | 50009 | 2 | 0 |
75407 | 75407 | 2020-04-20 | Essex | Virginia | 51057 | 2 | 0 |
78142 | 78142 | 2020-04-21 | Essex | Vermont | 50009 | 2 | 0 |
78189 | 78189 | 2020-04-21 | Essex | Virginia | 51057 | 2 | 0 |
80934 | 80934 | 2020-04-22 | Essex | Vermont | 50009 | 2 | 0 |
80981 | 80981 | 2020-04-22 | Essex | Virginia | 51057 | 2 | 0 |
83735 | 83735 | 2020-04-23 | Essex | Vermont | 50009 | 2 | 0 |
86542 | 86542 | 2020-04-24 | Essex | Vermont | 50009 | 2 | 0 |
89357 | 89357 | 2020-04-25 | Essex | Vermont | 50009 | 2 | 0 |
92174 | 92174 | 2020-04-26 | Essex | Vermont | 50009 | 2 | 0 |
95003 | 95003 | 2020-04-27 | Essex | Vermont | 50009 | 2 | 0 |
97845 | 97845 | 2020-04-28 | Essex | Vermont | 50009 | 2 | 0 |
100695 | 100695 | 2020-04-29 | Essex | Vermont | 50009 | 2 | 0 |
103550 | 103550 | 2020-04-30 | Essex | Vermont | 50009 | 2 | 0 |
106414 | 106414 | 2020-05-01 | Essex | Vermont | 50009 | 2 | 0 |
109283 | 109283 | 2020-05-02 | Essex | Vermont | 50009 | 2 | 0 |
112157 | 112157 | 2020-05-03 | Essex | Vermont | 50009 | 2 | 0 |
115040 | 115040 | 2020-05-04 | Essex | Vermont | 50009 | 2 | 0 |
117999 | 117999 | 2020-05-05 | Essex | Vermont | 50009 | 2 | 0 |
120963 | 120963 | 2020-05-06 | Essex | Vermont | 50009 | 2 | 0 |
123944 | 123944 | 2020-05-07 | Essex | Vermont | 50009 | 2 | 0 |
126929 | 126929 | 2020-05-08 | Essex | Vermont | 50009 | 2 | 0 |
129918 | 129918 | 2020-05-09 | Essex | Vermont | 50009 | 2 | 0 |
132908 | 132908 | 2020-05-10 | Essex | Vermont | 50009 | 2 | 0 |
135898 | 135898 | 2020-05-11 | Essex | Vermont | 50009 | 2 | 0 |
138889 | 138889 | 2020-05-12 | Essex | Vermont | 50009 | 2 | 0 |
141885 | 141885 | 2020-05-13 | Essex | Vermont | 50009 | 2 | 0 |
144882 | 144882 | 2020-05-14 | Essex | Vermont | 50009 | 2 | 0 |
147885 | 147885 | 2020-05-15 | Essex | Vermont | 50009 | 2 | 0 |
150894 | 150894 | 2020-05-16 | Essex | Vermont | 50009 | 2 | 0 |
153905 | 153905 | 2020-05-17 | Essex | Vermont | 50009 | 2 | 0 |
156922 | 156922 | 2020-05-18 | Essex | Vermont | 50009 | 2 | 0 |
159946 | 159946 | 2020-05-19 | Essex | Vermont | 50009 | 2 | 0 |
162974 | 162974 | 2020-05-20 | Essex | Vermont | 50009 | 2 | 0 |
166003 | 166003 | 2020-05-21 | Essex | Vermont | 50009 | 2 | 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 |
42907 | 42907 | 2020-04-08 | Essex | Vermont | 50009 | 3 | 0 |
83782 | 83782 | 2020-04-23 | Essex | Virginia | 51057 | 3 | 0 |
86589 | 86589 | 2020-04-24 | Essex | Virginia | 51057 | 3 | 0 |
169039 | 169039 | 2020-05-22 | Essex | Vermont | 50009 | 3 | 0 |
172080 | 172080 | 2020-05-23 | Essex | Vermont | 50009 | 3 | 0 |
175123 | 175123 | 2020-05-24 | Essex | Vermont | 50009 | 3 | 0 |
178168 | 178168 | 2020-05-25 | Essex | Vermont | 50009 | 3 | 0 |
181212 | 181212 | 2020-05-26 | Essex | Vermont | 50009 | 3 | 0 |
184263 | 184263 | 2020-05-27 | Essex | Vermont | 50009 | 3 | 0 |
187320 | 187320 | 2020-05-28 | Essex | Vermont | 50009 | 3 | 0 |
190384 | 190384 | 2020-05-29 | Essex | Vermont | 50009 | 3 | 0 |
193450 | 193450 | 2020-05-30 | Essex | Vermont | 50009 | 3 | 0 |
196520 | 196520 | 2020-05-31 | Essex | Vermont | 50009 | 3 | 0 |
199593 | 199593 | 2020-06-01 | Essex | Vermont | 50009 | 3 | 0 |
202669 | 202669 | 2020-06-02 | Essex | Vermont | 50009 | 3 | 0 |
205748 | 205748 | 2020-06-03 | Essex | Vermont | 50009 | 3 | 0 |
208830 | 208830 | 2020-06-04 | Essex | Vermont | 50009 | 3 | 0 |
211915 | 211915 | 2020-06-05 | Essex | Vermont | 50009 | 3 | 0 |
215002 | 215002 | 2020-06-06 | Essex | Vermont | 50009 | 3 | 0 |
218092 | 218092 | 2020-06-07 | Essex | Vermont | 50009 | 3 | 0 |
221184 | 221184 | 2020-06-08 | Essex | Vermont | 50009 | 3 | 0 |
224280 | 224280 | 2020-06-09 | Essex | Vermont | 50009 | 3 | 0 |
227380 | 227380 | 2020-06-10 | Essex | Vermont | 50009 | 3 | 0 |
230484 | 230484 | 2020-06-11 | Essex | Vermont | 50009 | 3 | 0 |
233589 | 233589 | 2020-06-12 | Essex | Vermont | 50009 | 3 | 0 |
236696 | 236696 | 2020-06-13 | Essex | Vermont | 50009 | 3 | 0 |
239804 | 239804 | 2020-06-14 | Essex | Vermont | 50009 | 3 | 0 |
242915 | 242915 | 2020-06-15 | Essex | Vermont | 50009 | 3 | 0 |
246027 | 246027 | 2020-06-16 | Essex | Vermont | 50009 | 3 | 0 |
249139 | 249139 | 2020-06-17 | Essex | Vermont | 50009 | 3 | 0 |
252254 | 252254 | 2020-06-18 | Essex | Vermont | 50009 | 3 | 0 |
255372 | 255372 | 2020-06-19 | Essex | Vermont | 50009 | 3 | 0 |
258499 | 258499 | 2020-06-20 | Essex | Vermont | 50009 | 3 | 0 |
261626 | 261626 | 2020-06-21 | Essex | Vermont | 50009 | 3 | 0 |
264755 | 264755 | 2020-06-22 | Essex | Vermont | 50009 | 3 | 0 |
267884 | 267884 | 2020-06-23 | Essex | Vermont | 50009 | 3 | 0 |
271018 | 271018 | 2020-06-24 | Essex | Vermont | 50009 | 3 | 0 |
274158 | 274158 | 2020-06-25 | Essex | Vermont | 50009 | 3 | 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);