ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where fips = 25017 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
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 |
1474 | 1474 | 2020-03-12 | Middlesex | Massachusetts | 25017 | 49 | 0 |
1753 | 1753 | 2020-03-13 | Middlesex | Massachusetts | 25017 | 60 | 0 |
2096 | 2096 | 2020-03-14 | Middlesex | Massachusetts | 25017 | 65 | 0 |
2498 | 2498 | 2020-03-15 | Middlesex | Massachusetts | 25017 | 75 | 0 |
2947 | 2947 | 2020-03-16 | Middlesex | Massachusetts | 25017 | 83 | 0 |
3448 | 3448 | 2020-03-17 | Middlesex | Massachusetts | 25017 | 89 | 0 |
4031 | 4031 | 2020-03-18 | Middlesex | Massachusetts | 25017 | 100 | 0 |
4736 | 4736 | 2020-03-19 | Middlesex | Massachusetts | 25017 | 119 | 0 |
5555 | 5555 | 2020-03-20 | Middlesex | Massachusetts | 25017 | 144 | 0 |
6514 | 6514 | 2020-03-21 | Middlesex | Massachusetts | 25017 | 177 | 1 |
7591 | 7591 | 2020-03-22 | Middlesex | Massachusetts | 25017 | 199 | 1 |
8763 | 8763 | 2020-03-23 | Middlesex | Massachusetts | 25017 | 232 | 1 |
10052 | 10052 | 2020-03-24 | Middlesex | Massachusetts | 25017 | 304 | 2 |
11464 | 11464 | 2020-03-25 | Middlesex | Massachusetts | 25017 | 446 | 2 |
13045 | 13045 | 2020-03-26 | Middlesex | Massachusetts | 25017 | 538 | 5 |
14753 | 14753 | 2020-03-27 | Middlesex | Massachusetts | 25017 | 685 | 6 |
16573 | 16573 | 2020-03-28 | Middlesex | Massachusetts | 25017 | 842 | 6 |
18488 | 18488 | 2020-03-29 | Middlesex | Massachusetts | 25017 | 981 | 7 |
20504 | 20504 | 2020-03-30 | Middlesex | Massachusetts | 25017 | 1141 | 9 |
22613 | 22613 | 2020-03-31 | Middlesex | Massachusetts | 25017 | 1340 | 18 |
24792 | 24792 | 2020-04-01 | Middlesex | Massachusetts | 25017 | 1582 | 21 |
27044 | 27044 | 2020-04-02 | Middlesex | Massachusetts | 25017 | 1870 | 29 |
29362 | 29362 | 2020-04-03 | Middlesex | Massachusetts | 25017 | 2202 | 39 |
31740 | 31740 | 2020-04-04 | Middlesex | Massachusetts | 25017 | 2468 | 39 |
34165 | 34165 | 2020-04-05 | Middlesex | Massachusetts | 25017 | 2632 | 42 |
36624 | 36624 | 2020-04-06 | Middlesex | Massachusetts | 25017 | 2950 | 48 |
39132 | 39132 | 2020-04-07 | Middlesex | Massachusetts | 25017 | 3187 | 69 |
41684 | 41684 | 2020-04-08 | Middlesex | Massachusetts | 25017 | 3545 | 80 |
44260 | 44260 | 2020-04-09 | Middlesex | Massachusetts | 25017 | 4045 | 93 |
46868 | 46868 | 2020-04-10 | Middlesex | Massachusetts | 25017 | 4447 | 109 |
49510 | 49510 | 2020-04-11 | Middlesex | Massachusetts | 25017 | 4872 | 137 |
52180 | 52180 | 2020-04-12 | Middlesex | Massachusetts | 25017 | 5660 | 149 |
54861 | 54861 | 2020-04-13 | Middlesex | Massachusetts | 25017 | 5983 | 163 |
57559 | 57559 | 2020-04-14 | Middlesex | Massachusetts | 25017 | 6254 | 188 |
60268 | 60268 | 2020-04-15 | Middlesex | Massachusetts | 25017 | 6681 | 221 |
62989 | 62989 | 2020-04-16 | Middlesex | Massachusetts | 25017 | 7206 | 258 |
65727 | 65727 | 2020-04-17 | Middlesex | Massachusetts | 25017 | 7744 | 294 |
68477 | 68477 | 2020-04-18 | Middlesex | Massachusetts | 25017 | 8297 | 334 |
71241 | 71241 | 2020-04-19 | Middlesex | Massachusetts | 25017 | 8737 | 372 |
74013 | 74013 | 2020-04-20 | Middlesex | Massachusetts | 25017 | 9253 | 402 |
76793 | 76793 | 2020-04-21 | Middlesex | Massachusetts | 25017 | 9621 | 428 |
79579 | 79579 | 2020-04-22 | Middlesex | Massachusetts | 25017 | 10094 | 494 |
82374 | 82374 | 2020-04-23 | Middlesex | Massachusetts | 25017 | 10724 | 545 |
85178 | 85178 | 2020-04-24 | Middlesex | Massachusetts | 25017 | 11681 | 585 |
87988 | 87988 | 2020-04-25 | Middlesex | Massachusetts | 25017 | 12253 | 629 |
90804 | 90804 | 2020-04-26 | Middlesex | Massachusetts | 25017 | 12648 | 670 |
93625 | 93625 | 2020-04-27 | Middlesex | Massachusetts | 25017 | 12953 | 700 |
96460 | 96460 | 2020-04-28 | Middlesex | Massachusetts | 25017 | 13417 | 731 |
99306 | 99306 | 2020-04-29 | Middlesex | Massachusetts | 25017 | 13799 | 802 |
102158 | 102158 | 2020-04-30 | Middlesex | Massachusetts | 25017 | 14208 | 845 |
105018 | 105018 | 2020-05-01 | Middlesex | Massachusetts | 25017 | 14607 | 885 |
107882 | 107882 | 2020-05-02 | Middlesex | Massachusetts | 25017 | 15048 | 923 |
110754 | 110754 | 2020-05-03 | Middlesex | Massachusetts | 25017 | 15370 | 972 |
113632 | 113632 | 2020-05-04 | Middlesex | Massachusetts | 25017 | 15757 | 997 |
116513 | 116513 | 2020-05-05 | Middlesex | Massachusetts | 25017 | 15980 | 1028 |
119474 | 119474 | 2020-05-06 | Middlesex | Massachusetts | 25017 | 16327 | 1070 |
122446 | 122446 | 2020-05-07 | Middlesex | Massachusetts | 25017 | 16676 | 1103 |
125428 | 125428 | 2020-05-08 | Middlesex | Massachusetts | 25017 | 17014 | 1132 |
128415 | 128415 | 2020-05-09 | Middlesex | Massachusetts | 25017 | 17307 | 1169 |
131405 | 131405 | 2020-05-10 | Middlesex | Massachusetts | 25017 | 17589 | 1207 |
134396 | 134396 | 2020-05-11 | Middlesex | Massachusetts | 25017 | 17774 | 1235 |
137386 | 137386 | 2020-05-12 | Middlesex | Massachusetts | 25017 | 17953 | 1244 |
140380 | 140380 | 2020-05-13 | Middlesex | Massachusetts | 25017 | 18201 | 1282 |
143375 | 143375 | 2020-05-14 | Middlesex | Massachusetts | 25017 | 18381 | 1327 |
146375 | 146375 | 2020-05-15 | Middlesex | Massachusetts | 25017 | 18683 | 1347 |
149380 | 149380 | 2020-05-16 | Middlesex | Massachusetts | 25017 | 18883 | 1370 |
152391 | 152391 | 2020-05-17 | Middlesex | Massachusetts | 25017 | 19129 | 1394 |
155405 | 155405 | 2020-05-18 | Middlesex | Massachusetts | 25017 | 19345 | 1412 |
158423 | 158423 | 2020-05-19 | Middlesex | Massachusetts | 25017 | 19504 | 1436 |
161449 | 161449 | 2020-05-20 | Middlesex | Massachusetts | 25017 | 19708 | 1462 |
164478 | 164478 | 2020-05-21 | Middlesex | Massachusetts | 25017 | 19930 | 1478 |
167514 | 167514 | 2020-05-22 | Middlesex | Massachusetts | 25017 | 20085 | 1496 |
170551 | 170551 | 2020-05-23 | Middlesex | Massachusetts | 25017 | 20232 | 1512 |
173593 | 173593 | 2020-05-24 | Middlesex | Massachusetts | 25017 | 20437 | 1518 |
176636 | 176636 | 2020-05-25 | Middlesex | Massachusetts | 25017 | 20539 | 1527 |
179680 | 179680 | 2020-05-26 | Middlesex | Massachusetts | 25017 | 20601 | 1535 |
182726 | 182726 | 2020-05-27 | Middlesex | Massachusetts | 25017 | 20706 | 1549 |
185781 | 185781 | 2020-05-28 | Middlesex | Massachusetts | 25017 | 20857 | 1564 |
188839 | 188839 | 2020-05-29 | Middlesex | Massachusetts | 25017 | 20972 | 1583 |
191903 | 191903 | 2020-05-30 | Middlesex | Massachusetts | 25017 | 21124 | 1596 |
194971 | 194971 | 2020-05-31 | Middlesex | Massachusetts | 25017 | 21287 | 1615 |
198042 | 198042 | 2020-06-01 | Middlesex | Massachusetts | 25017 | 22224 | 1650 |
201114 | 201114 | 2020-06-02 | Middlesex | Massachusetts | 25017 | 22296 | 1663 |
204191 | 204191 | 2020-06-03 | Middlesex | Massachusetts | 25017 | 22403 | 1676 |
207272 | 207272 | 2020-06-04 | Middlesex | Massachusetts | 25017 | 22485 | 1689 |
210353 | 210353 | 2020-06-05 | Middlesex | Massachusetts | 25017 | 22583 | 1695 |
213437 | 213437 | 2020-06-06 | Middlesex | Massachusetts | 25017 | 22686 | 1701 |
216525 | 216525 | 2020-06-07 | Middlesex | Massachusetts | 25017 | 22754 | 1705 |
219617 | 219617 | 2020-06-08 | Middlesex | Massachusetts | 25017 | 22812 | 1711 |
222712 | 222712 | 2020-06-09 | Middlesex | Massachusetts | 25017 | 22845 | 1720 |
225808 | 225808 | 2020-06-10 | Middlesex | Massachusetts | 25017 | 22889 | 1725 |
228910 | 228910 | 2020-06-11 | Middlesex | Massachusetts | 25017 | 22996 | 1733 |
232014 | 232014 | 2020-06-12 | Middlesex | Massachusetts | 25017 | 23075 | 1744 |
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);