ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
112 rows where deaths = 27 and state = "Maryland" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 16
county 16
- Queen Anne's 47
- Calvert 31
- Kent 8
- Unknown 8
- Worcester 4
- Dorchester 2
- Howard 2
- Somerset 2
- Anne Arundel 1
- Baltimore city 1
- Cecil 1
- Frederick 1
- Harford 1
- St. Mary's 1
- Washington 1
- Wicomico 1
state 1
- Maryland · 112 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500802 | 2500802 | 2022-05-13 | Unknown | Maryland | 0 | 27 | |
2429155 | 2429155 | 2022-04-21 | Unknown | Maryland | 0 | 27 | |
2419387 | 2419387 | 2022-04-18 | Unknown | Maryland | 0 | 27 | |
2406363 | 2406363 | 2022-04-14 | Unknown | Maryland | 0 | 27 | |
1616420 | 1616420 | 2021-08-14 | Unknown | Maryland | 1 | 27 | |
1596929 | 1596929 | 2021-08-08 | Unknown | Maryland | 2 | 27 | |
957357 | 957357 | 2021-01-23 | Somerset | Maryland | 24039 | 2161 | 27 |
954103 | 954103 | 2021-01-22 | Dorchester | Maryland | 24019 | 1908 | 27 |
954112 | 954112 | 2021-01-22 | Somerset | Maryland | 24039 | 2140 | 27 |
950858 | 950858 | 2021-01-21 | Dorchester | Maryland | 24019 | 1899 | 27 |
885954 | 885954 | 2021-01-01 | Kent | Maryland | 24029 | 744 | 27 |
882709 | 882709 | 2020-12-31 | Kent | Maryland | 24029 | 739 | 27 |
879464 | 879464 | 2020-12-30 | Kent | Maryland | 24029 | 724 | 27 |
876219 | 876219 | 2020-12-29 | Kent | Maryland | 24029 | 720 | 27 |
872974 | 872974 | 2020-12-28 | Kent | Maryland | 24029 | 715 | 27 |
872977 | 872977 | 2020-12-28 | Queen Anne's | Maryland | 24035 | 1577 | 27 |
869729 | 869729 | 2020-12-27 | Kent | Maryland | 24029 | 697 | 27 |
869732 | 869732 | 2020-12-27 | Queen Anne's | Maryland | 24035 | 1561 | 27 |
866484 | 866484 | 2020-12-26 | Kent | Maryland | 24029 | 690 | 27 |
866487 | 866487 | 2020-12-26 | Queen Anne's | Maryland | 24035 | 1544 | 27 |
863239 | 863239 | 2020-12-25 | Kent | Maryland | 24029 | 683 | 27 |
863242 | 863242 | 2020-12-25 | Queen Anne's | Maryland | 24035 | 1532 | 27 |
859997 | 859997 | 2020-12-24 | Queen Anne's | Maryland | 24035 | 1508 | 27 |
856752 | 856752 | 2020-12-23 | Queen Anne's | Maryland | 24035 | 1496 | 27 |
853507 | 853507 | 2020-12-22 | Queen Anne's | Maryland | 24035 | 1479 | 27 |
850262 | 850262 | 2020-12-21 | Queen Anne's | Maryland | 24035 | 1463 | 27 |
847017 | 847017 | 2020-12-20 | Queen Anne's | Maryland | 24035 | 1450 | 27 |
843771 | 843771 | 2020-12-19 | Queen Anne's | Maryland | 24035 | 1439 | 27 |
840526 | 840526 | 2020-12-18 | Queen Anne's | Maryland | 24035 | 1407 | 27 |
837281 | 837281 | 2020-12-17 | Queen Anne's | Maryland | 24035 | 1387 | 27 |
834035 | 834035 | 2020-12-16 | Queen Anne's | Maryland | 24035 | 1379 | 27 |
830788 | 830788 | 2020-12-15 | Queen Anne's | Maryland | 24035 | 1369 | 27 |
827542 | 827542 | 2020-12-14 | Queen Anne's | Maryland | 24035 | 1366 | 27 |
824295 | 824295 | 2020-12-13 | Queen Anne's | Maryland | 24035 | 1347 | 27 |
821049 | 821049 | 2020-12-12 | Queen Anne's | Maryland | 24035 | 1338 | 27 |
817803 | 817803 | 2020-12-11 | Queen Anne's | Maryland | 24035 | 1316 | 27 |
814557 | 814557 | 2020-12-10 | Queen Anne's | Maryland | 24035 | 1278 | 27 |
811312 | 811312 | 2020-12-09 | Queen Anne's | Maryland | 24035 | 1251 | 27 |
808067 | 808067 | 2020-12-08 | Queen Anne's | Maryland | 24035 | 1237 | 27 |
804822 | 804822 | 2020-12-07 | Queen Anne's | Maryland | 24035 | 1223 | 27 |
801577 | 801577 | 2020-12-06 | Queen Anne's | Maryland | 24035 | 1206 | 27 |
798332 | 798332 | 2020-12-05 | Queen Anne's | Maryland | 24035 | 1192 | 27 |
795087 | 795087 | 2020-12-04 | Queen Anne's | Maryland | 24035 | 1160 | 27 |
795091 | 795091 | 2020-12-04 | Unknown | Maryland | 0 | 27 | |
791842 | 791842 | 2020-12-03 | Queen Anne's | Maryland | 24035 | 1136 | 27 |
788597 | 788597 | 2020-12-02 | Queen Anne's | Maryland | 24035 | 1112 | 27 |
785352 | 785352 | 2020-12-01 | Queen Anne's | Maryland | 24035 | 1109 | 27 |
782108 | 782108 | 2020-11-30 | Queen Anne's | Maryland | 24035 | 1098 | 27 |
778862 | 778862 | 2020-11-29 | Queen Anne's | Maryland | 24035 | 1084 | 27 |
775617 | 775617 | 2020-11-28 | Queen Anne's | Maryland | 24035 | 1075 | 27 |
772372 | 772372 | 2020-11-27 | Queen Anne's | Maryland | 24035 | 1062 | 27 |
769127 | 769127 | 2020-11-26 | Queen Anne's | Maryland | 24035 | 1050 | 27 |
765881 | 765881 | 2020-11-25 | Queen Anne's | Maryland | 24035 | 1046 | 27 |
762636 | 762636 | 2020-11-24 | Queen Anne's | Maryland | 24035 | 1034 | 27 |
759391 | 759391 | 2020-11-23 | Queen Anne's | Maryland | 24035 | 1028 | 27 |
756144 | 756144 | 2020-11-22 | Queen Anne's | Maryland | 24035 | 1011 | 27 |
752898 | 752898 | 2020-11-21 | Queen Anne's | Maryland | 24035 | 1002 | 27 |
749652 | 749652 | 2020-11-20 | Queen Anne's | Maryland | 24035 | 991 | 27 |
746406 | 746406 | 2020-11-19 | Queen Anne's | Maryland | 24035 | 964 | 27 |
743159 | 743159 | 2020-11-18 | Queen Anne's | Maryland | 24035 | 947 | 27 |
739912 | 739912 | 2020-11-17 | Queen Anne's | Maryland | 24035 | 938 | 27 |
736668 | 736668 | 2020-11-16 | Queen Anne's | Maryland | 24035 | 928 | 27 |
733422 | 733422 | 2020-11-15 | Queen Anne's | Maryland | 24035 | 909 | 27 |
730177 | 730177 | 2020-11-14 | Queen Anne's | Maryland | 24035 | 903 | 27 |
726934 | 726934 | 2020-11-13 | Queen Anne's | Maryland | 24035 | 886 | 27 |
584233 | 584233 | 2020-09-30 | Worcester | Maryland | 24047 | 1059 | 27 |
580992 | 580992 | 2020-09-29 | Worcester | Maryland | 24047 | 1054 | 27 |
577751 | 577751 | 2020-09-28 | Worcester | Maryland | 24047 | 1049 | 27 |
574510 | 574510 | 2020-09-27 | Worcester | Maryland | 24047 | 1051 | 27 |
480655 | 480655 | 2020-08-29 | Queen Anne's | Maryland | 24035 | 542 | 27 |
383921 | 383921 | 2020-07-30 | Calvert | Maryland | 24009 | 566 | 27 |
380704 | 380704 | 2020-07-29 | Calvert | Maryland | 24009 | 560 | 27 |
377487 | 377487 | 2020-07-28 | Calvert | Maryland | 24009 | 553 | 27 |
374272 | 374272 | 2020-07-27 | Calvert | Maryland | 24009 | 547 | 27 |
371060 | 371060 | 2020-07-26 | Calvert | Maryland | 24009 | 536 | 27 |
367850 | 367850 | 2020-07-25 | Calvert | Maryland | 24009 | 529 | 27 |
364643 | 364643 | 2020-07-24 | Calvert | Maryland | 24009 | 516 | 27 |
361436 | 361436 | 2020-07-23 | Calvert | Maryland | 24009 | 510 | 27 |
358231 | 358231 | 2020-07-22 | Calvert | Maryland | 24009 | 504 | 27 |
355028 | 355028 | 2020-07-21 | Calvert | Maryland | 24009 | 496 | 27 |
351826 | 351826 | 2020-07-20 | Calvert | Maryland | 24009 | 495 | 27 |
348626 | 348626 | 2020-07-19 | Calvert | Maryland | 24009 | 491 | 27 |
345425 | 345425 | 2020-07-18 | Calvert | Maryland | 24009 | 484 | 27 |
342225 | 342225 | 2020-07-17 | Calvert | Maryland | 24009 | 480 | 27 |
339029 | 339029 | 2020-07-16 | Calvert | Maryland | 24009 | 468 | 27 |
335833 | 335833 | 2020-07-15 | Calvert | Maryland | 24009 | 460 | 27 |
332640 | 332640 | 2020-07-14 | Calvert | Maryland | 24009 | 459 | 27 |
329453 | 329453 | 2020-07-13 | Calvert | Maryland | 24009 | 454 | 27 |
326267 | 326267 | 2020-07-12 | Calvert | Maryland | 24009 | 450 | 27 |
323084 | 323084 | 2020-07-11 | Calvert | Maryland | 24009 | 446 | 27 |
319905 | 319905 | 2020-07-10 | Calvert | Maryland | 24009 | 439 | 27 |
316730 | 316730 | 2020-07-09 | Calvert | Maryland | 24009 | 436 | 27 |
313556 | 313556 | 2020-07-08 | Calvert | Maryland | 24009 | 426 | 27 |
310386 | 310386 | 2020-07-07 | Calvert | Maryland | 24009 | 423 | 27 |
310403 | 310403 | 2020-07-07 | Unknown | Maryland | 0 | 27 | |
307218 | 307218 | 2020-07-06 | Calvert | Maryland | 24009 | 423 | 27 |
304051 | 304051 | 2020-07-05 | Calvert | Maryland | 24009 | 422 | 27 |
300887 | 300887 | 2020-07-04 | Calvert | Maryland | 24009 | 420 | 27 |
297725 | 297725 | 2020-07-03 | Calvert | Maryland | 24009 | 420 | 27 |
294567 | 294567 | 2020-07-02 | Calvert | Maryland | 24009 | 419 | 27 |
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);