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 |
---|---|---|---|---|---|---|---|
535660 | 535660 | 2020-09-15 | Unknown | Massachusetts | 2311 | 5 | |
532425 | 532425 | 2020-09-14 | Unknown | Massachusetts | 2281 | 5 | |
529189 | 529189 | 2020-09-13 | Unknown | Massachusetts | 2262 | 5 | |
525953 | 525953 | 2020-09-12 | Unknown | Massachusetts | 2238 | 5 | |
522717 | 522717 | 2020-09-11 | Unknown | Massachusetts | 2128 | 5 | |
519480 | 519480 | 2020-09-10 | Unknown | Massachusetts | 2140 | 5 | |
516245 | 516245 | 2020-09-09 | Unknown | Massachusetts | 2119 | 5 | |
513011 | 513011 | 2020-09-08 | Unknown | Massachusetts | 2117 | 5 | |
509779 | 509779 | 2020-09-07 | Unknown | Massachusetts | 2108 | 5 | |
506546 | 506546 | 2020-09-06 | Unknown | Massachusetts | 2097 | 5 | |
503313 | 503313 | 2020-09-05 | Unknown | Massachusetts | 2095 | 5 | |
500079 | 500079 | 2020-09-04 | Unknown | Massachusetts | 2065 | 5 | |
496845 | 496845 | 2020-09-03 | Unknown | Massachusetts | 2065 | 5 | |
493612 | 493612 | 2020-09-02 | Unknown | Massachusetts | 2037 | 5 | |
490378 | 490378 | 2020-09-01 | Unknown | Massachusetts | 1599 | 5 | |
487145 | 487145 | 2020-08-31 | Unknown | Massachusetts | 1586 | 5 | |
483911 | 483911 | 2020-08-30 | Unknown | Massachusetts | 1580 | 5 | |
480676 | 480676 | 2020-08-29 | Unknown | Massachusetts | 1558 | 5 | |
477444 | 477444 | 2020-08-28 | Unknown | Massachusetts | 1533 | 5 | |
474211 | 474211 | 2020-08-27 | Unknown | Massachusetts | 1506 | 5 | |
470979 | 470979 | 2020-08-26 | Unknown | Massachusetts | 1491 | 5 | |
467749 | 467749 | 2020-08-25 | Unknown | Massachusetts | 1469 | 5 | |
464520 | 464520 | 2020-08-24 | Unknown | Massachusetts | 1410 | 5 | |
461289 | 461289 | 2020-08-23 | Unknown | Massachusetts | 1320 | 5 | |
458062 | 458062 | 2020-08-22 | Unknown | Massachusetts | 1320 | 5 | |
454834 | 454834 | 2020-08-21 | Unknown | Massachusetts | 1265 | 5 | |
451606 | 451606 | 2020-08-20 | Unknown | Massachusetts | 1195 | 5 | |
448378 | 448378 | 2020-08-19 | Unknown | Massachusetts | 1156 | 5 | |
445152 | 445152 | 2020-08-18 | Unknown | Massachusetts | 2682 | 103 | |
441926 | 441926 | 2020-08-17 | Unknown | Massachusetts | 2460 | 97 | |
438699 | 438699 | 2020-08-16 | Unknown | Massachusetts | 2212 | 93 | |
435474 | 435474 | 2020-08-15 | Unknown | Massachusetts | 1818 | 81 | |
432248 | 432248 | 2020-08-14 | Unknown | Massachusetts | 1347 | 65 | |
429021 | 429021 | 2020-08-13 | Unknown | Massachusetts | 1042 | 45 | |
425797 | 425797 | 2020-08-12 | Unknown | Massachusetts | 619 | 24 | |
422575 | 422575 | 2020-08-11 | Unknown | Massachusetts | 326 | 6 | |
419353 | 419353 | 2020-08-10 | Unknown | Massachusetts | 329 | 6 | |
416132 | 416132 | 2020-08-09 | Unknown | Massachusetts | 325 | 6 | |
412912 | 412912 | 2020-08-08 | Unknown | Massachusetts | 316 | 6 | |
409692 | 409692 | 2020-08-07 | Unknown | Massachusetts | 314 | 6 | |
406472 | 406472 | 2020-08-06 | Unknown | Massachusetts | 308 | 6 | |
403254 | 403254 | 2020-08-05 | Unknown | Massachusetts | 342 | 6 | |
400037 | 400037 | 2020-08-04 | Unknown | Massachusetts | 318 | 6 | |
396823 | 396823 | 2020-08-03 | Unknown | Massachusetts | 303 | 6 | |
393607 | 393607 | 2020-08-02 | Unknown | Massachusetts | 306 | 6 | |
390390 | 390390 | 2020-08-01 | Unknown | Massachusetts | 303 | 6 | |
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 |
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);