ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Middlesex" and state = "Connecticut" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635196 | 635196 | 2020-10-16 | Middlesex | Connecticut | 9007 | 1754 | 194 |
631950 | 631950 | 2020-10-15 | Middlesex | Connecticut | 9007 | 1733 | 193 |
628706 | 628706 | 2020-10-14 | Middlesex | Connecticut | 9007 | 1720 | 193 |
625463 | 625463 | 2020-10-13 | Middlesex | Connecticut | 9007 | 1714 | 193 |
622220 | 622220 | 2020-10-12 | Middlesex | Connecticut | 9007 | 1709 | 193 |
618977 | 618977 | 2020-10-11 | Middlesex | Connecticut | 9007 | 1667 | 193 |
615735 | 615735 | 2020-10-10 | Middlesex | Connecticut | 9007 | 1667 | 193 |
612494 | 612494 | 2020-10-09 | Middlesex | Connecticut | 9007 | 1667 | 193 |
609252 | 609252 | 2020-10-08 | Middlesex | Connecticut | 9007 | 1652 | 193 |
606009 | 606009 | 2020-10-07 | Middlesex | Connecticut | 9007 | 1635 | 193 |
602767 | 602767 | 2020-10-06 | Middlesex | Connecticut | 9007 | 1631 | 193 |
599524 | 599524 | 2020-10-05 | Middlesex | Connecticut | 9007 | 1627 | 193 |
596281 | 596281 | 2020-10-04 | Middlesex | Connecticut | 9007 | 1614 | 193 |
593039 | 593039 | 2020-10-03 | Middlesex | Connecticut | 9007 | 1614 | 193 |
589799 | 589799 | 2020-10-02 | Middlesex | Connecticut | 9007 | 1614 | 193 |
586558 | 586558 | 2020-10-01 | Middlesex | Connecticut | 9007 | 1604 | 193 |
583318 | 583318 | 2020-09-30 | Middlesex | Connecticut | 9007 | 1599 | 193 |
580079 | 580079 | 2020-09-29 | Middlesex | Connecticut | 9007 | 1588 | 193 |
576838 | 576838 | 2020-09-28 | Middlesex | Connecticut | 9007 | 1583 | 193 |
573595 | 573595 | 2020-09-27 | Middlesex | Connecticut | 9007 | 1566 | 193 |
570353 | 570353 | 2020-09-26 | Middlesex | Connecticut | 9007 | 1566 | 193 |
567111 | 567111 | 2020-09-25 | Middlesex | Connecticut | 9007 | 1566 | 193 |
563871 | 563871 | 2020-09-24 | Middlesex | Connecticut | 9007 | 1564 | 193 |
560631 | 560631 | 2020-09-23 | Middlesex | Connecticut | 9007 | 1560 | 193 |
557395 | 557395 | 2020-09-22 | Middlesex | Connecticut | 9007 | 1556 | 193 |
554158 | 554158 | 2020-09-21 | Middlesex | Connecticut | 9007 | 1552 | 193 |
550919 | 550919 | 2020-09-20 | Middlesex | Connecticut | 9007 | 1542 | 193 |
547680 | 547680 | 2020-09-19 | Middlesex | Connecticut | 9007 | 1542 | 193 |
544442 | 544442 | 2020-09-18 | Middlesex | Connecticut | 9007 | 1542 | 193 |
541206 | 541206 | 2020-09-17 | Middlesex | Connecticut | 9007 | 1537 | 193 |
537969 | 537969 | 2020-09-16 | Middlesex | Connecticut | 9007 | 1531 | 193 |
534733 | 534733 | 2020-09-15 | Middlesex | Connecticut | 9007 | 1527 | 193 |
531498 | 531498 | 2020-09-14 | Middlesex | Connecticut | 9007 | 1524 | 193 |
528261 | 528261 | 2020-09-13 | Middlesex | Connecticut | 9007 | 1512 | 193 |
525025 | 525025 | 2020-09-12 | Middlesex | Connecticut | 9007 | 1512 | 193 |
521789 | 521789 | 2020-09-11 | Middlesex | Connecticut | 9007 | 1512 | 193 |
518552 | 518552 | 2020-09-10 | Middlesex | Connecticut | 9007 | 1505 | 193 |
515317 | 515317 | 2020-09-09 | Middlesex | Connecticut | 9007 | 1499 | 193 |
512084 | 512084 | 2020-09-08 | Middlesex | Connecticut | 9007 | 1496 | 193 |
508851 | 508851 | 2020-09-07 | Middlesex | Connecticut | 9007 | 1484 | 192 |
505619 | 505619 | 2020-09-06 | Middlesex | Connecticut | 9007 | 1484 | 192 |
502385 | 502385 | 2020-09-05 | Middlesex | Connecticut | 9007 | 1484 | 192 |
499151 | 499151 | 2020-09-04 | Middlesex | Connecticut | 9007 | 1484 | 192 |
495918 | 495918 | 2020-09-03 | Middlesex | Connecticut | 9007 | 1469 | 192 |
492684 | 492684 | 2020-09-02 | Middlesex | Connecticut | 9007 | 1469 | 192 |
489451 | 489451 | 2020-09-01 | Middlesex | Connecticut | 9007 | 1466 | 192 |
486218 | 486218 | 2020-08-31 | Middlesex | Connecticut | 9007 | 1455 | 192 |
482983 | 482983 | 2020-08-30 | Middlesex | Connecticut | 9007 | 1446 | 192 |
479749 | 479749 | 2020-08-29 | Middlesex | Connecticut | 9007 | 1446 | 192 |
476516 | 476516 | 2020-08-28 | Middlesex | Connecticut | 9007 | 1446 | 192 |
473283 | 473283 | 2020-08-27 | Middlesex | Connecticut | 9007 | 1438 | 192 |
470051 | 470051 | 2020-08-26 | Middlesex | Connecticut | 9007 | 1437 | 192 |
466822 | 466822 | 2020-08-25 | Middlesex | Connecticut | 9007 | 1436 | 192 |
463593 | 463593 | 2020-08-24 | Middlesex | Connecticut | 9007 | 1434 | 192 |
460364 | 460364 | 2020-08-23 | Middlesex | Connecticut | 9007 | 1426 | 192 |
457137 | 457137 | 2020-08-22 | Middlesex | Connecticut | 9007 | 1426 | 192 |
453909 | 453909 | 2020-08-21 | Middlesex | Connecticut | 9007 | 1426 | 192 |
450681 | 450681 | 2020-08-20 | Middlesex | Connecticut | 9007 | 1425 | 192 |
447453 | 447453 | 2020-08-19 | Middlesex | Connecticut | 9007 | 1425 | 192 |
444226 | 444226 | 2020-08-18 | Middlesex | Connecticut | 9007 | 1424 | 192 |
441000 | 441000 | 2020-08-17 | Middlesex | Connecticut | 9007 | 1425 | 192 |
437774 | 437774 | 2020-08-16 | Middlesex | Connecticut | 9007 | 1414 | 192 |
434548 | 434548 | 2020-08-15 | Middlesex | Connecticut | 9007 | 1414 | 192 |
431323 | 431323 | 2020-08-14 | Middlesex | Connecticut | 9007 | 1414 | 192 |
428095 | 428095 | 2020-08-13 | Middlesex | Connecticut | 9007 | 1411 | 192 |
424871 | 424871 | 2020-08-12 | Middlesex | Connecticut | 9007 | 1408 | 192 |
421650 | 421650 | 2020-08-11 | Middlesex | Connecticut | 9007 | 1408 | 192 |
418429 | 418429 | 2020-08-10 | Middlesex | Connecticut | 9007 | 1405 | 192 |
415208 | 415208 | 2020-08-09 | Middlesex | Connecticut | 9007 | 1396 | 192 |
411988 | 411988 | 2020-08-08 | Middlesex | Connecticut | 9007 | 1396 | 192 |
408769 | 408769 | 2020-08-07 | Middlesex | Connecticut | 9007 | 1396 | 192 |
405549 | 405549 | 2020-08-06 | Middlesex | Connecticut | 9007 | 1395 | 191 |
402331 | 402331 | 2020-08-05 | Middlesex | Connecticut | 9007 | 1396 | 191 |
399115 | 399115 | 2020-08-04 | Middlesex | Connecticut | 9007 | 1391 | 191 |
395899 | 395899 | 2020-08-03 | Middlesex | Connecticut | 9007 | 1388 | 191 |
392683 | 392683 | 2020-08-02 | Middlesex | Connecticut | 9007 | 1377 | 191 |
389466 | 389466 | 2020-08-01 | Middlesex | Connecticut | 9007 | 1377 | 191 |
386249 | 386249 | 2020-07-31 | Middlesex | Connecticut | 9007 | 1377 | 191 |
383031 | 383031 | 2020-07-30 | Middlesex | Connecticut | 9007 | 1377 | 191 |
379814 | 379814 | 2020-07-29 | Middlesex | Connecticut | 9007 | 1375 | 189 |
376597 | 376597 | 2020-07-28 | Middlesex | Connecticut | 9007 | 1374 | 189 |
373383 | 373383 | 2020-07-27 | Middlesex | Connecticut | 9007 | 1373 | 189 |
370171 | 370171 | 2020-07-26 | Middlesex | Connecticut | 9007 | 1365 | 188 |
366961 | 366961 | 2020-07-25 | Middlesex | Connecticut | 9007 | 1365 | 188 |
363754 | 363754 | 2020-07-24 | Middlesex | Connecticut | 9007 | 1365 | 188 |
360547 | 360547 | 2020-07-23 | Middlesex | Connecticut | 9007 | 1360 | 188 |
357342 | 357342 | 2020-07-22 | Middlesex | Connecticut | 9007 | 1362 | 188 |
354139 | 354139 | 2020-07-21 | Middlesex | Connecticut | 9007 | 1361 | 189 |
350937 | 350937 | 2020-07-20 | Middlesex | Connecticut | 9007 | 1359 | 189 |
347736 | 347736 | 2020-07-19 | Middlesex | Connecticut | 9007 | 1357 | 189 |
344536 | 344536 | 2020-07-18 | Middlesex | Connecticut | 9007 | 1357 | 189 |
341337 | 341337 | 2020-07-17 | Middlesex | Connecticut | 9007 | 1357 | 189 |
338140 | 338140 | 2020-07-16 | Middlesex | Connecticut | 9007 | 1351 | 189 |
334945 | 334945 | 2020-07-15 | Middlesex | Connecticut | 9007 | 1346 | 188 |
331752 | 331752 | 2020-07-14 | Middlesex | Connecticut | 9007 | 1341 | 187 |
328565 | 328565 | 2020-07-13 | Middlesex | Connecticut | 9007 | 1340 | 187 |
325379 | 325379 | 2020-07-12 | Middlesex | Connecticut | 9007 | 1335 | 187 |
322198 | 322198 | 2020-07-11 | Middlesex | Connecticut | 9007 | 1335 | 187 |
319019 | 319019 | 2020-07-10 | Middlesex | Connecticut | 9007 | 1335 | 187 |
315846 | 315846 | 2020-07-09 | Middlesex | Connecticut | 9007 | 1334 | 187 |
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);