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 rowid
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 |
4842 | 4842 | 2020-03-19 | Essex | New Jersey | 34013 | 63 | 2 |
4871 | 4871 | 2020-03-19 | Essex | New York | 36031 | 1 | 0 |
5551 | 5551 | 2020-03-20 | Essex | Massachusetts | 25009 | 29 | 0 |
5686 | 5686 | 2020-03-20 | Essex | New Jersey | 34013 | 73 | 3 |
5718 | 5718 | 2020-03-20 | Essex | New York | 36031 | 1 | 0 |
6510 | 6510 | 2020-03-21 | Essex | Massachusetts | 25009 | 41 | 0 |
6679 | 6679 | 2020-03-21 | Essex | New Jersey | 34013 | 107 | 4 |
6712 | 6712 | 2020-03-21 | Essex | New York | 36031 | 2 | 0 |
7587 | 7587 | 2020-03-22 | Essex | Massachusetts | 25009 | 60 | 0 |
7770 | 7770 | 2020-03-22 | Essex | New Jersey | 34013 | 172 | 4 |
7806 | 7806 | 2020-03-22 | Essex | New York | 36031 | 3 | 0 |
8759 | 8759 | 2020-03-23 | Essex | Massachusetts | 25009 | 73 | 1 |
8966 | 8966 | 2020-03-23 | Essex | New Jersey | 34013 | 273 | 5 |
9004 | 9004 | 2020-03-23 | Essex | New York | 36031 | 3 | 0 |
10048 | 10048 | 2020-03-24 | Essex | Massachusetts | 25009 | 118 | 1 |
10270 | 10270 | 2020-03-24 | Essex | New Jersey | 34013 | 342 | 8 |
10311 | 10311 | 2020-03-24 | Essex | New York | 36031 | 3 | 0 |
11460 | 11460 | 2020-03-25 | Essex | Massachusetts | 25009 | 177 | 1 |
11702 | 11702 | 2020-03-25 | Essex | New Jersey | 34013 | 381 | 11 |
11746 | 11746 | 2020-03-25 | Essex | New York | 36031 | 4 | 0 |
13041 | 13041 | 2020-03-26 | Essex | Massachusetts | 25009 | 247 | 3 |
13305 | 13305 | 2020-03-26 | Essex | New Jersey | 34013 | 609 | 15 |
13349 | 13349 | 2020-03-26 | Essex | New York | 36031 | 4 | 0 |
14749 | 14749 | 2020-03-27 | Essex | Massachusetts | 25009 | 350 | 3 |
15037 | 15037 | 2020-03-27 | Essex | New Jersey | 34013 | 826 | 18 |
15083 | 15083 | 2020-03-27 | Essex | New York | 36031 | 4 | 0 |
16569 | 16569 | 2020-03-28 | Essex | Massachusetts | 25009 | 472 | 4 |
16866 | 16866 | 2020-03-28 | Essex | New Jersey | 34013 | 1086 | 20 |
16913 | 16913 | 2020-03-28 | Essex | New York | 36031 | 4 | 0 |
18484 | 18484 | 2020-03-29 | Essex | Massachusetts | 25009 | 570 | 5 |
18790 | 18790 | 2020-03-29 | Essex | New Jersey | 34013 | 1227 | 20 |
18837 | 18837 | 2020-03-29 | Essex | New York | 36031 | 4 | 0 |
20500 | 20500 | 2020-03-30 | Essex | Massachusetts | 25009 | 653 | 7 |
20828 | 20828 | 2020-03-30 | Essex | New Jersey | 34013 | 1564 | 36 |
20876 | 20876 | 2020-03-30 | Essex | New York | 36031 | 5 | 0 |
22609 | 22609 | 2020-03-31 | Essex | Massachusetts | 25009 | 784 | 13 |
22951 | 22951 | 2020-03-31 | Essex | New Jersey | 34013 | 1900 | 47 |
22999 | 22999 | 2020-03-31 | Essex | New York | 36031 | 5 | 0 |
24788 | 24788 | 2020-04-01 | Essex | Massachusetts | 25009 | 885 | 18 |
25142 | 25142 | 2020-04-01 | Essex | New Jersey | 34013 | 2262 | 69 |
25193 | 25193 | 2020-04-01 | Essex | New York | 36031 | 6 | 0 |
27040 | 27040 | 2020-04-02 | Essex | Massachusetts | 25009 | 1039 | 19 |
27402 | 27402 | 2020-04-02 | Essex | New Jersey | 34013 | 2617 | 99 |
27453 | 27453 | 2020-04-02 | Essex | New York | 36031 | 6 | 0 |
29358 | 29358 | 2020-04-03 | Essex | Massachusetts | 25009 | 1238 | 24 |
29725 | 29725 | 2020-04-03 | Essex | New Jersey | 34013 | 3067 | 118 |
29777 | 29777 | 2020-04-03 | Essex | New York | 36031 | 6 | 0 |
31736 | 31736 | 2020-04-04 | Essex | Massachusetts | 25009 | 1400 | 26 |
32110 | 32110 | 2020-04-04 | Essex | New Jersey | 34013 | 3584 | 156 |
32163 | 32163 | 2020-04-04 | Essex | New York | 36031 | 7 | 0 |
34161 | 34161 | 2020-04-05 | Essex | Massachusetts | 25009 | 1506 | 28 |
34541 | 34541 | 2020-04-05 | Essex | New Jersey | 34013 | 4082 | 172 |
34594 | 34594 | 2020-04-05 | Essex | New York | 36031 | 7 | 0 |
36620 | 36620 | 2020-04-06 | Essex | Massachusetts | 25009 | 1653 | 31 |
37011 | 37011 | 2020-04-06 | Essex | New Jersey | 34013 | 4493 | 186 |
37064 | 37064 | 2020-04-06 | Essex | New York | 36031 | 7 | 0 |
39128 | 39128 | 2020-04-07 | Essex | Massachusetts | 25009 | 1841 | 37 |
39526 | 39526 | 2020-04-07 | Essex | New Jersey | 34013 | 5078 | 232 |
39579 | 39579 | 2020-04-07 | Essex | New York | 36031 | 7 | 0 |
41680 | 41680 | 2020-04-08 | Essex | Massachusetts | 25009 | 2103 | 52 |
42083 | 42083 | 2020-04-08 | Essex | New Jersey | 34013 | 5598 | 276 |
42136 | 42136 | 2020-04-08 | Essex | New York | 36031 | 7 | 0 |
42907 | 42907 | 2020-04-08 | Essex | Vermont | 50009 | 3 | 0 |
44256 | 44256 | 2020-04-09 | Essex | Massachusetts | 25009 | 2336 | 61 |
44665 | 44665 | 2020-04-09 | Essex | New Jersey | 34013 | 6069 | 312 |
44719 | 44719 | 2020-04-09 | Essex | New York | 36031 | 8 | 0 |
45501 | 45501 | 2020-04-09 | Essex | Vermont | 50009 | 1 | 0 |
46864 | 46864 | 2020-04-10 | Essex | Massachusetts | 25009 | 2670 | 80 |
47277 | 47277 | 2020-04-10 | Essex | New Jersey | 34013 | 6580 | 352 |
47332 | 47332 | 2020-04-10 | Essex | New York | 36031 | 10 | 0 |
48125 | 48125 | 2020-04-10 | Essex | Vermont | 50009 | 1 | 0 |
49506 | 49506 | 2020-04-11 | Essex | Massachusetts | 25009 | 2896 | 92 |
49931 | 49931 | 2020-04-11 | Essex | New Jersey | 34013 | 7007 | 412 |
49987 | 49987 | 2020-04-11 | Essex | New York | 36031 | 12 | 0 |
50783 | 50783 | 2020-04-11 | Essex | Vermont | 50009 | 1 | 0 |
52176 | 52176 | 2020-04-12 | Essex | Massachusetts | 25009 | 3170 | 102 |
52604 | 52604 | 2020-04-12 | Essex | New Jersey | 34013 | 7410 | 428 |
52660 | 52660 | 2020-04-12 | Essex | New York | 36031 | 12 | 0 |
53458 | 53458 | 2020-04-12 | Essex | Vermont | 50009 | 1 | 0 |
54857 | 54857 | 2020-04-13 | Essex | Massachusetts | 25009 | 3413 | 114 |
55287 | 55287 | 2020-04-13 | Essex | New Jersey | 34013 | 7634 | 433 |
55343 | 55343 | 2020-04-13 | Essex | New York | 36031 | 12 | 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);