ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Unknown" and state = "Massachusetts" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387173 | 387173 | 2020-07-31 | Unknown | Massachusetts | 307 | 6 | |
383955 | 383955 | 2020-07-30 | Unknown | Massachusetts | 335 | 6 | |
380738 | 380738 | 2020-07-29 | Unknown | Massachusetts | 334 | 6 | |
377521 | 377521 | 2020-07-28 | Unknown | Massachusetts | 327 | 6 | |
374306 | 374306 | 2020-07-27 | Unknown | Massachusetts | 328 | 6 | |
371094 | 371094 | 2020-07-26 | Unknown | Massachusetts | 325 | 6 | |
367884 | 367884 | 2020-07-25 | Unknown | Massachusetts | 323 | 6 | |
364677 | 364677 | 2020-07-24 | Unknown | Massachusetts | 328 | 6 | |
361470 | 361470 | 2020-07-23 | Unknown | Massachusetts | 321 | 6 | |
358265 | 358265 | 2020-07-22 | Unknown | Massachusetts | 315 | 6 | |
355062 | 355062 | 2020-07-21 | Unknown | Massachusetts | 311 | 6 | |
351860 | 351860 | 2020-07-20 | Unknown | Massachusetts | 317 | 6 | |
348660 | 348660 | 2020-07-19 | Unknown | Massachusetts | 314 | 6 | |
345459 | 345459 | 2020-07-18 | Unknown | Massachusetts | 319 | 6 | |
342259 | 342259 | 2020-07-17 | Unknown | Massachusetts | 316 | 6 | |
339063 | 339063 | 2020-07-16 | Unknown | Massachusetts | 317 | 7 | |
335867 | 335867 | 2020-07-15 | Unknown | Massachusetts | 303 | 7 | |
332674 | 332674 | 2020-07-14 | Unknown | Massachusetts | 301 | 7 | |
329487 | 329487 | 2020-07-13 | Unknown | Massachusetts | 299 | 7 | |
326301 | 326301 | 2020-07-12 | Unknown | Massachusetts | 300 | 7 | |
323118 | 323118 | 2020-07-11 | Unknown | Massachusetts | 300 | 7 | |
319939 | 319939 | 2020-07-10 | Unknown | Massachusetts | 294 | 7 | |
316764 | 316764 | 2020-07-09 | Unknown | Massachusetts | 297 | 7 | |
313590 | 313590 | 2020-07-08 | Unknown | Massachusetts | 298 | 7 | |
310420 | 310420 | 2020-07-07 | Unknown | Massachusetts | 294 | 7 | |
307252 | 307252 | 2020-07-06 | Unknown | Massachusetts | 292 | 7 | |
304085 | 304085 | 2020-07-05 | Unknown | Massachusetts | 291 | 7 | |
300921 | 300921 | 2020-07-04 | Unknown | Massachusetts | 291 | 7 | |
297759 | 297759 | 2020-07-03 | Unknown | Massachusetts | 292 | 7 | |
294601 | 294601 | 2020-07-02 | Unknown | Massachusetts | 287 | 7 | |
291447 | 291447 | 2020-07-01 | Unknown | Massachusetts | 346 | 7 | |
288296 | 288296 | 2020-06-30 | Unknown | Massachusetts | 288 | 7 | |
285146 | 285146 | 2020-06-29 | Unknown | Massachusetts | 288 | 7 | |
282001 | 282001 | 2020-06-28 | Unknown | Massachusetts | 287 | 7 | |
278853 | 278853 | 2020-06-27 | Unknown | Massachusetts | 289 | 7 | |
275705 | 275705 | 2020-06-26 | Unknown | Massachusetts | 285 | 7 | |
272562 | 272562 | 2020-06-25 | Unknown | Massachusetts | 283 | 6 | |
269425 | 269425 | 2020-06-24 | Unknown | Massachusetts | 290 | 8 | |
266292 | 266292 | 2020-06-23 | Unknown | Massachusetts | 288 | 8 | |
263166 | 263166 | 2020-06-22 | Unknown | Massachusetts | 300 | 10 | |
260037 | 260037 | 2020-06-21 | Unknown | Massachusetts | 303 | 10 | |
256911 | 256911 | 2020-06-20 | Unknown | Massachusetts | 297 | 10 | |
253791 | 253791 | 2020-06-19 | Unknown | Massachusetts | 296 | 10 | |
250676 | 250676 | 2020-06-18 | Unknown | Massachusetts | 308 | 10 | |
247564 | 247564 | 2020-06-17 | Unknown | Massachusetts | 306 | 9 | |
244451 | 244451 | 2020-06-16 | Unknown | Massachusetts | 307 | 9 | |
241340 | 241340 | 2020-06-15 | Unknown | Massachusetts | 311 | 10 | |
238231 | 238231 | 2020-06-14 | Unknown | Massachusetts | 308 | 10 | |
235124 | 235124 | 2020-06-13 | Unknown | Massachusetts | 307 | 10 | |
232019 | 232019 | 2020-06-12 | Unknown | Massachusetts | 298 | 10 | |
228915 | 228915 | 2020-06-11 | Unknown | Massachusetts | 304 | 10 | |
225813 | 225813 | 2020-06-10 | Unknown | Massachusetts | 297 | 10 | |
222717 | 222717 | 2020-06-09 | Unknown | Massachusetts | 299 | 10 | |
219622 | 219622 | 2020-06-08 | Unknown | Massachusetts | 309 | 8 | |
216530 | 216530 | 2020-06-07 | Unknown | Massachusetts | 292 | 8 | |
213442 | 213442 | 2020-06-06 | Unknown | Massachusetts | 297 | 8 | |
210358 | 210358 | 2020-06-05 | Unknown | Massachusetts | 313 | 7 | |
207277 | 207277 | 2020-06-04 | Unknown | Massachusetts | 310 | 10 | |
204196 | 204196 | 2020-06-03 | Unknown | Massachusetts | 307 | 12 | |
201119 | 201119 | 2020-06-02 | Unknown | Massachusetts | 319 | 12 | |
198047 | 198047 | 2020-06-01 | Unknown | Massachusetts | 340 | 14 | |
194976 | 194976 | 2020-05-31 | Unknown | Massachusetts | 297 | 7 | |
191908 | 191908 | 2020-05-30 | Unknown | Massachusetts | 336 | 6 | |
188844 | 188844 | 2020-05-29 | Unknown | Massachusetts | 289 | 6 | |
185786 | 185786 | 2020-05-28 | Unknown | Massachusetts | 318 | 6 | |
182731 | 182731 | 2020-05-27 | Unknown | Massachusetts | 309 | 5 | |
179685 | 179685 | 2020-05-26 | Unknown | Massachusetts | 297 | 4 | |
176641 | 176641 | 2020-05-25 | Unknown | Massachusetts | 311 | 4 | |
173598 | 173598 | 2020-05-24 | Unknown | Massachusetts | 308 | 4 | |
170556 | 170556 | 2020-05-23 | Unknown | Massachusetts | 319 | 3 | |
167519 | 167519 | 2020-05-22 | Unknown | Massachusetts | 296 | 3 | |
164483 | 164483 | 2020-05-21 | Unknown | Massachusetts | 304 | 3 | |
161454 | 161454 | 2020-05-20 | Unknown | Massachusetts | 294 | 3 | |
158428 | 158428 | 2020-05-19 | Unknown | Massachusetts | 288 | 3 | |
155410 | 155410 | 2020-05-18 | Unknown | Massachusetts | 312 | 3 | |
152396 | 152396 | 2020-05-17 | Unknown | Massachusetts | 315 | 3 | |
149385 | 149385 | 2020-05-16 | Unknown | Massachusetts | 309 | 3 | |
146380 | 146380 | 2020-05-15 | Unknown | Massachusetts | 285 | 2 | |
143380 | 143380 | 2020-05-14 | Unknown | Massachusetts | 300 | 3 | |
140385 | 140385 | 2020-05-13 | Unknown | Massachusetts | 264 | 4 | |
137391 | 137391 | 2020-05-12 | Unknown | Massachusetts | 273 | 4 | |
134401 | 134401 | 2020-05-11 | Unknown | Massachusetts | 287 | 5 | |
131410 | 131410 | 2020-05-10 | Unknown | Massachusetts | 303 | 5 | |
128420 | 128420 | 2020-05-09 | Unknown | Massachusetts | 288 | 3 | |
125433 | 125433 | 2020-05-08 | Unknown | Massachusetts | 297 | 3 | |
122451 | 122451 | 2020-05-07 | Unknown | Massachusetts | 328 | 3 | |
119479 | 119479 | 2020-05-06 | Unknown | Massachusetts | 326 | 3 | |
116518 | 116518 | 2020-05-05 | Unknown | Massachusetts | 594 | 7 | |
113637 | 113637 | 2020-05-04 | Unknown | Massachusetts | 662 | 7 | |
110759 | 110759 | 2020-05-03 | Unknown | Massachusetts | 981 | 7 | |
107887 | 107887 | 2020-05-02 | Unknown | Massachusetts | 377 | 4 | |
105023 | 105023 | 2020-05-01 | Unknown | Massachusetts | 425 | 6 | |
102163 | 102163 | 2020-04-30 | Unknown | Massachusetts | 415 | 5 | |
99311 | 99311 | 2020-04-29 | Unknown | Massachusetts | 457 | 5 | |
96465 | 96465 | 2020-04-28 | Unknown | Massachusetts | 625 | 5 | |
93630 | 93630 | 2020-04-27 | Unknown | Massachusetts | 795 | 8 | |
90809 | 90809 | 2020-04-26 | Unknown | Massachusetts | 807 | 14 | |
87993 | 87993 | 2020-04-25 | Unknown | Massachusetts | 753 | 13 | |
85183 | 85183 | 2020-04-24 | Unknown | Massachusetts | 791 | 12 | |
82379 | 82379 | 2020-04-23 | Unknown | Massachusetts | 737 | 10 |
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);