ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Unknown", fips = "" and state = "Massachusetts" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
2951 | 2951 | 2020-03-16 | Unknown | Massachusetts | 1 | 0 | |
3452 | 3452 | 2020-03-17 | Unknown | Massachusetts | 1 | 0 | |
4035 | 4035 | 2020-03-18 | Unknown | Massachusetts | 4 | 0 | |
4740 | 4740 | 2020-03-19 | Unknown | Massachusetts | 13 | 0 | |
5559 | 5559 | 2020-03-20 | Unknown | Massachusetts | 18 | 0 | |
6519 | 6519 | 2020-03-21 | Unknown | Massachusetts | 26 | 0 | |
7596 | 7596 | 2020-03-22 | Unknown | Massachusetts | 34 | 0 | |
8768 | 8768 | 2020-03-23 | Unknown | Massachusetts | 57 | 0 | |
10057 | 10057 | 2020-03-24 | Unknown | Massachusetts | 90 | 0 | |
11469 | 11469 | 2020-03-25 | Unknown | Massachusetts | 159 | 0 | |
13050 | 13050 | 2020-03-26 | Unknown | Massachusetts | 267 | 0 | |
14758 | 14758 | 2020-03-27 | Unknown | Massachusetts | 304 | 0 | |
16578 | 16578 | 2020-03-28 | Unknown | Massachusetts | 358 | 0 | |
18493 | 18493 | 2020-03-29 | Unknown | Massachusetts | 462 | 0 | |
20509 | 20509 | 2020-03-30 | Unknown | Massachusetts | 491 | 0 | |
22618 | 22618 | 2020-03-31 | Unknown | Massachusetts | 335 | 0 | |
24797 | 24797 | 2020-04-01 | Unknown | Massachusetts | 256 | 0 | |
27049 | 27049 | 2020-04-02 | Unknown | Massachusetts | 270 | 0 | |
29367 | 29367 | 2020-04-03 | Unknown | Massachusetts | 213 | 0 | |
31745 | 31745 | 2020-04-04 | Unknown | Massachusetts | 274 | 0 | |
34170 | 34170 | 2020-04-05 | Unknown | Massachusetts | 215 | 0 | |
36629 | 36629 | 2020-04-06 | Unknown | Massachusetts | 246 | 2 | |
39137 | 39137 | 2020-04-07 | Unknown | Massachusetts | 229 | 3 | |
41689 | 41689 | 2020-04-08 | Unknown | Massachusetts | 223 | 5 | |
44265 | 44265 | 2020-04-09 | Unknown | Massachusetts | 203 | 5 | |
46873 | 46873 | 2020-04-10 | Unknown | Massachusetts | 129 | 5 | |
49515 | 49515 | 2020-04-11 | Unknown | Massachusetts | 225 | 5 | |
52185 | 52185 | 2020-04-12 | Unknown | Massachusetts | 373 | 5 | |
54866 | 54866 | 2020-04-13 | Unknown | Massachusetts | 447 | 7 | |
57564 | 57564 | 2020-04-14 | Unknown | Massachusetts | 506 | 7 | |
60273 | 60273 | 2020-04-15 | Unknown | Massachusetts | 572 | 7 | |
62994 | 62994 | 2020-04-16 | Unknown | Massachusetts | 638 | 9 | |
65732 | 65732 | 2020-04-17 | Unknown | Massachusetts | 760 | 12 | |
68482 | 68482 | 2020-04-18 | Unknown | Massachusetts | 733 | 13 | |
71246 | 71246 | 2020-04-19 | Unknown | Massachusetts | 815 | 13 | |
74018 | 74018 | 2020-04-20 | Unknown | Massachusetts | 855 | 9 | |
76798 | 76798 | 2020-04-21 | Unknown | Massachusetts | 929 | 8 | |
79584 | 79584 | 2020-04-22 | Unknown | Massachusetts | 854 | 9 | |
82379 | 82379 | 2020-04-23 | Unknown | Massachusetts | 737 | 10 | |
85183 | 85183 | 2020-04-24 | Unknown | Massachusetts | 791 | 12 | |
87993 | 87993 | 2020-04-25 | Unknown | Massachusetts | 753 | 13 | |
90809 | 90809 | 2020-04-26 | Unknown | Massachusetts | 807 | 14 | |
93630 | 93630 | 2020-04-27 | Unknown | Massachusetts | 795 | 8 | |
96465 | 96465 | 2020-04-28 | Unknown | Massachusetts | 625 | 5 | |
99311 | 99311 | 2020-04-29 | Unknown | Massachusetts | 457 | 5 | |
102163 | 102163 | 2020-04-30 | Unknown | Massachusetts | 415 | 5 | |
105023 | 105023 | 2020-05-01 | Unknown | Massachusetts | 425 | 6 | |
107887 | 107887 | 2020-05-02 | Unknown | Massachusetts | 377 | 4 | |
110759 | 110759 | 2020-05-03 | Unknown | Massachusetts | 981 | 7 | |
113637 | 113637 | 2020-05-04 | Unknown | Massachusetts | 662 | 7 | |
116518 | 116518 | 2020-05-05 | Unknown | Massachusetts | 594 | 7 | |
119479 | 119479 | 2020-05-06 | Unknown | Massachusetts | 326 | 3 | |
122451 | 122451 | 2020-05-07 | Unknown | Massachusetts | 328 | 3 | |
125433 | 125433 | 2020-05-08 | Unknown | Massachusetts | 297 | 3 | |
128420 | 128420 | 2020-05-09 | Unknown | Massachusetts | 288 | 3 | |
131410 | 131410 | 2020-05-10 | Unknown | Massachusetts | 303 | 5 | |
134401 | 134401 | 2020-05-11 | Unknown | Massachusetts | 287 | 5 | |
137391 | 137391 | 2020-05-12 | Unknown | Massachusetts | 273 | 4 | |
140385 | 140385 | 2020-05-13 | Unknown | Massachusetts | 264 | 4 | |
143380 | 143380 | 2020-05-14 | Unknown | Massachusetts | 300 | 3 | |
146380 | 146380 | 2020-05-15 | Unknown | Massachusetts | 285 | 2 | |
149385 | 149385 | 2020-05-16 | Unknown | Massachusetts | 309 | 3 | |
152396 | 152396 | 2020-05-17 | Unknown | Massachusetts | 315 | 3 | |
155410 | 155410 | 2020-05-18 | Unknown | Massachusetts | 312 | 3 | |
158428 | 158428 | 2020-05-19 | Unknown | Massachusetts | 288 | 3 | |
161454 | 161454 | 2020-05-20 | Unknown | Massachusetts | 294 | 3 | |
164483 | 164483 | 2020-05-21 | Unknown | Massachusetts | 304 | 3 | |
167519 | 167519 | 2020-05-22 | Unknown | Massachusetts | 296 | 3 | |
170556 | 170556 | 2020-05-23 | Unknown | Massachusetts | 319 | 3 | |
173598 | 173598 | 2020-05-24 | Unknown | Massachusetts | 308 | 4 | |
176641 | 176641 | 2020-05-25 | Unknown | Massachusetts | 311 | 4 | |
179685 | 179685 | 2020-05-26 | Unknown | Massachusetts | 297 | 4 | |
182731 | 182731 | 2020-05-27 | Unknown | Massachusetts | 309 | 5 | |
185786 | 185786 | 2020-05-28 | Unknown | Massachusetts | 318 | 6 | |
188844 | 188844 | 2020-05-29 | Unknown | Massachusetts | 289 | 6 | |
191908 | 191908 | 2020-05-30 | Unknown | Massachusetts | 336 | 6 | |
194976 | 194976 | 2020-05-31 | Unknown | Massachusetts | 297 | 7 | |
198047 | 198047 | 2020-06-01 | Unknown | Massachusetts | 340 | 14 | |
201119 | 201119 | 2020-06-02 | Unknown | Massachusetts | 319 | 12 | |
204196 | 204196 | 2020-06-03 | Unknown | Massachusetts | 307 | 12 | |
207277 | 207277 | 2020-06-04 | Unknown | Massachusetts | 310 | 10 | |
210358 | 210358 | 2020-06-05 | Unknown | Massachusetts | 313 | 7 | |
213442 | 213442 | 2020-06-06 | Unknown | Massachusetts | 297 | 8 | |
216530 | 216530 | 2020-06-07 | Unknown | Massachusetts | 292 | 8 | |
219622 | 219622 | 2020-06-08 | Unknown | Massachusetts | 309 | 8 | |
222717 | 222717 | 2020-06-09 | Unknown | Massachusetts | 299 | 10 | |
225813 | 225813 | 2020-06-10 | Unknown | Massachusetts | 297 | 10 | |
228915 | 228915 | 2020-06-11 | Unknown | Massachusetts | 304 | 10 | |
232019 | 232019 | 2020-06-12 | Unknown | Massachusetts | 298 | 10 | |
235124 | 235124 | 2020-06-13 | Unknown | Massachusetts | 307 | 10 | |
238231 | 238231 | 2020-06-14 | Unknown | Massachusetts | 308 | 10 | |
241340 | 241340 | 2020-06-15 | Unknown | Massachusetts | 311 | 10 | |
244451 | 244451 | 2020-06-16 | Unknown | Massachusetts | 307 | 9 | |
247564 | 247564 | 2020-06-17 | Unknown | Massachusetts | 306 | 9 | |
250676 | 250676 | 2020-06-18 | Unknown | Massachusetts | 308 | 10 | |
253791 | 253791 | 2020-06-19 | Unknown | Massachusetts | 296 | 10 | |
256911 | 256911 | 2020-06-20 | Unknown | Massachusetts | 297 | 10 | |
260037 | 260037 | 2020-06-21 | Unknown | Massachusetts | 303 | 10 | |
263166 | 263166 | 2020-06-22 | Unknown | Massachusetts | 300 | 10 | |
266292 | 266292 | 2020-06-23 | Unknown | Massachusetts | 288 | 8 |
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);