ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,146 rows where county = "Middlesex" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
state 4
- Massachusetts 800
- New Jersey 794
- Connecticut 787
- Virginia 765
county 1
- Middlesex · 3,146 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
557 | 557 | 2020-03-05 | Middlesex | Massachusetts | 25017 | 1 | 0 |
617 | 617 | 2020-03-06 | Middlesex | Massachusetts | 25017 | 1 | 0 |
703 | 703 | 2020-03-07 | Middlesex | Massachusetts | 25017 | 5 | 0 |
805 | 805 | 2020-03-08 | Middlesex | Massachusetts | 25017 | 10 | 0 |
929 | 929 | 2020-03-09 | Middlesex | Massachusetts | 25017 | 15 | 0 |
1076 | 1076 | 2020-03-10 | Middlesex | Massachusetts | 25017 | 41 | 0 |
1256 | 1256 | 2020-03-11 | Middlesex | Massachusetts | 25017 | 41 | 0 |
1277 | 1277 | 2020-03-11 | Middlesex | New Jersey | 34023 | 2 | 0 |
1474 | 1474 | 2020-03-12 | Middlesex | Massachusetts | 25017 | 49 | 0 |
1507 | 1507 | 2020-03-12 | Middlesex | New Jersey | 34023 | 2 | 0 |
1753 | 1753 | 2020-03-13 | Middlesex | Massachusetts | 25017 | 60 | 0 |
1799 | 1799 | 2020-03-13 | Middlesex | New Jersey | 34023 | 4 | 0 |
2096 | 2096 | 2020-03-14 | Middlesex | Massachusetts | 25017 | 65 | 0 |
2146 | 2146 | 2020-03-14 | Middlesex | New Jersey | 34023 | 8 | 0 |
2498 | 2498 | 2020-03-15 | Middlesex | Massachusetts | 25017 | 75 | 0 |
2554 | 2554 | 2020-03-15 | Middlesex | New Jersey | 34023 | 9 | 0 |
2947 | 2947 | 2020-03-16 | Middlesex | Massachusetts | 25017 | 83 | 0 |
3011 | 3011 | 2020-03-16 | Middlesex | New Jersey | 34023 | 15 | 0 |
3448 | 3448 | 2020-03-17 | Middlesex | Massachusetts | 25017 | 89 | 0 |
3524 | 3524 | 2020-03-17 | Middlesex | New Jersey | 34023 | 20 | 0 |
3849 | 3849 | 2020-03-18 | Middlesex | Connecticut | 9007 | 1 | 0 |
4031 | 4031 | 2020-03-18 | Middlesex | Massachusetts | 25017 | 100 | 0 |
4120 | 4120 | 2020-03-18 | Middlesex | New Jersey | 34023 | 40 | 0 |
4512 | 4512 | 2020-03-19 | Middlesex | Connecticut | 9007 | 3 | 0 |
4736 | 4736 | 2020-03-19 | Middlesex | Massachusetts | 25017 | 119 | 0 |
4847 | 4847 | 2020-03-19 | Middlesex | New Jersey | 34023 | 64 | 0 |
5290 | 5290 | 2020-03-20 | Middlesex | Connecticut | 9007 | 5 | 0 |
5555 | 5555 | 2020-03-20 | Middlesex | Massachusetts | 25017 | 144 | 0 |
5691 | 5691 | 2020-03-20 | Middlesex | New Jersey | 34023 | 76 | 0 |
6217 | 6217 | 2020-03-21 | Middlesex | Connecticut | 9007 | 6 | 0 |
6514 | 6514 | 2020-03-21 | Middlesex | Massachusetts | 25017 | 177 | 1 |
6684 | 6684 | 2020-03-21 | Middlesex | New Jersey | 34023 | 116 | 0 |
7253 | 7253 | 2020-03-22 | Middlesex | Connecticut | 9007 | 6 | 0 |
7591 | 7591 | 2020-03-22 | Middlesex | Massachusetts | 25017 | 199 | 1 |
7775 | 7775 | 2020-03-22 | Middlesex | New Jersey | 34023 | 147 | 1 |
8399 | 8399 | 2020-03-23 | Middlesex | Connecticut | 9007 | 8 | 0 |
8763 | 8763 | 2020-03-23 | Middlesex | Massachusetts | 25017 | 232 | 1 |
8971 | 8971 | 2020-03-23 | Middlesex | New Jersey | 34023 | 210 | 1 |
9644 | 9644 | 2020-03-24 | Middlesex | Connecticut | 9007 | 8 | 0 |
10052 | 10052 | 2020-03-24 | Middlesex | Massachusetts | 25017 | 304 | 2 |
10275 | 10275 | 2020-03-24 | Middlesex | New Jersey | 34023 | 277 | 1 |
11018 | 11018 | 2020-03-25 | Middlesex | Connecticut | 9007 | 15 | 0 |
11464 | 11464 | 2020-03-25 | Middlesex | Massachusetts | 25017 | 446 | 2 |
11707 | 11707 | 2020-03-25 | Middlesex | New Jersey | 34023 | 316 | 2 |
12566 | 12566 | 2020-03-26 | Middlesex | Connecticut | 9007 | 18 | 1 |
13045 | 13045 | 2020-03-26 | Middlesex | Massachusetts | 25017 | 538 | 5 |
13310 | 13310 | 2020-03-26 | Middlesex | New Jersey | 34023 | 505 | 5 |
14235 | 14235 | 2020-03-27 | Middlesex | Connecticut | 9007 | 25 | 1 |
14753 | 14753 | 2020-03-27 | Middlesex | Massachusetts | 25017 | 685 | 6 |
15042 | 15042 | 2020-03-27 | Middlesex | New Jersey | 34023 | 640 | 9 |
16019 | 16019 | 2020-03-28 | Middlesex | Connecticut | 9007 | 28 | 1 |
16573 | 16573 | 2020-03-28 | Middlesex | Massachusetts | 25017 | 842 | 6 |
16871 | 16871 | 2020-03-28 | Middlesex | New Jersey | 34023 | 808 | 14 |
17911 | 17911 | 2020-03-29 | Middlesex | Connecticut | 9007 | 38 | 1 |
18488 | 18488 | 2020-03-29 | Middlesex | Massachusetts | 25017 | 981 | 7 |
18795 | 18795 | 2020-03-29 | Middlesex | New Jersey | 34023 | 938 | 14 |
19890 | 19890 | 2020-03-30 | Middlesex | Connecticut | 9007 | 50 | 1 |
20504 | 20504 | 2020-03-30 | Middlesex | Massachusetts | 25017 | 1141 | 9 |
20833 | 20833 | 2020-03-30 | Middlesex | New Jersey | 34023 | 1123 | 20 |
21967 | 21967 | 2020-03-31 | Middlesex | Connecticut | 9007 | 56 | 1 |
22613 | 22613 | 2020-03-31 | Middlesex | Massachusetts | 25017 | 1340 | 18 |
22956 | 22956 | 2020-03-31 | Middlesex | New Jersey | 34023 | 1277 | 24 |
24126 | 24126 | 2020-04-01 | Middlesex | Connecticut | 9007 | 66 | 2 |
24792 | 24792 | 2020-04-01 | Middlesex | Massachusetts | 25017 | 1582 | 21 |
25147 | 25147 | 2020-04-01 | Middlesex | New Jersey | 34023 | 1493 | 27 |
26356 | 26356 | 2020-04-02 | Middlesex | Connecticut | 9007 | 74 | 3 |
27044 | 27044 | 2020-04-02 | Middlesex | Massachusetts | 25017 | 1870 | 29 |
27407 | 27407 | 2020-04-02 | Middlesex | New Jersey | 34023 | 1766 | 48 |
28658 | 28658 | 2020-04-03 | Middlesex | Connecticut | 9007 | 91 | 2 |
29362 | 29362 | 2020-04-03 | Middlesex | Massachusetts | 25017 | 2202 | 39 |
29730 | 29730 | 2020-04-03 | Middlesex | New Jersey | 34023 | 2125 | 56 |
31016 | 31016 | 2020-04-04 | Middlesex | Connecticut | 9007 | 100 | 4 |
31740 | 31740 | 2020-04-04 | Middlesex | Massachusetts | 25017 | 2468 | 39 |
32115 | 32115 | 2020-04-04 | Middlesex | New Jersey | 34023 | 2578 | 76 |
33422 | 33422 | 2020-04-05 | Middlesex | Connecticut | 9007 | 110 | 5 |
34165 | 34165 | 2020-04-05 | Middlesex | Massachusetts | 25017 | 2632 | 42 |
34546 | 34546 | 2020-04-05 | Middlesex | New Jersey | 34023 | 2950 | 80 |
35867 | 35867 | 2020-04-06 | Middlesex | Connecticut | 9007 | 135 | 7 |
36624 | 36624 | 2020-04-06 | Middlesex | Massachusetts | 25017 | 2950 | 48 |
37016 | 37016 | 2020-04-06 | Middlesex | New Jersey | 34023 | 3263 | 87 |
38357 | 38357 | 2020-04-07 | Middlesex | Connecticut | 9007 | 150 | 7 |
39132 | 39132 | 2020-04-07 | Middlesex | Massachusetts | 25017 | 3187 | 69 |
39531 | 39531 | 2020-04-07 | Middlesex | New Jersey | 34023 | 3717 | 100 |
40900 | 40900 | 2020-04-08 | Middlesex | Connecticut | 9007 | 174 | 9 |
41684 | 41684 | 2020-04-08 | Middlesex | Massachusetts | 25017 | 3545 | 80 |
42088 | 42088 | 2020-04-08 | Middlesex | New Jersey | 34023 | 4156 | 139 |
43474 | 43474 | 2020-04-09 | Middlesex | Connecticut | 9007 | 205 | 14 |
44260 | 44260 | 2020-04-09 | Middlesex | Massachusetts | 25017 | 4045 | 93 |
44670 | 44670 | 2020-04-09 | Middlesex | New Jersey | 34023 | 4628 | 152 |
45585 | 45585 | 2020-04-09 | Middlesex | Virginia | 51119 | 2 | 0 |
46074 | 46074 | 2020-04-10 | Middlesex | Connecticut | 9007 | 240 | 17 |
46868 | 46868 | 2020-04-10 | Middlesex | Massachusetts | 25017 | 4447 | 109 |
47282 | 47282 | 2020-04-10 | Middlesex | New Jersey | 34023 | 5060 | 168 |
48211 | 48211 | 2020-04-10 | Middlesex | Virginia | 51119 | 3 | 0 |
48704 | 48704 | 2020-04-11 | Middlesex | Connecticut | 9007 | 290 | 18 |
49510 | 49510 | 2020-04-11 | Middlesex | Massachusetts | 25017 | 4872 | 137 |
49936 | 49936 | 2020-04-11 | Middlesex | New Jersey | 34023 | 5406 | 177 |
50869 | 50869 | 2020-04-11 | Middlesex | Virginia | 51119 | 3 | 0 |
51366 | 51366 | 2020-04-12 | Middlesex | Connecticut | 9007 | 299 | 18 |
52180 | 52180 | 2020-04-12 | Middlesex | Massachusetts | 25017 | 5660 | 149 |
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);