ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where deaths = 42 and state = "Maryland" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 15
county 15
- Somerset 37
- Wicomico 17
- Kent 10
- Washington 10
- Cecil 5
- Unknown 5
- Worcester 5
- Calvert 4
- Queen Anne's 4
- Baltimore city 1
- Caroline 1
- Charles 1
- Garrett 1
- Montgomery 1
- Prince George's 1
state 1
- Maryland · 103 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2321762 | 2321762 | 2022-03-19 | Unknown | Maryland | 0 | 42 | |
1977077 | 1977077 | 2021-12-03 | Unknown | Maryland | 0 | 42 | |
1970578 | 1970578 | 2021-12-01 | Unknown | Maryland | 0 | 42 | |
1808077 | 1808077 | 2021-10-12 | Caroline | Maryland | 24011 | 3031 | 42 |
1635903 | 1635903 | 2021-08-20 | Somerset | Maryland | 24039 | 2725 | 42 |
1632653 | 1632653 | 2021-08-19 | Somerset | Maryland | 24039 | 2723 | 42 |
1629406 | 1629406 | 2021-08-18 | Somerset | Maryland | 24039 | 2721 | 42 |
1626159 | 1626159 | 2021-08-17 | Somerset | Maryland | 24039 | 2718 | 42 |
1622912 | 1622912 | 2021-08-16 | Somerset | Maryland | 24039 | 2714 | 42 |
1619665 | 1619665 | 2021-08-15 | Somerset | Maryland | 24039 | 2711 | 42 |
1616417 | 1616417 | 2021-08-14 | Somerset | Maryland | 24039 | 2710 | 42 |
1613169 | 1613169 | 2021-08-13 | Somerset | Maryland | 24039 | 2704 | 42 |
1609920 | 1609920 | 2021-08-12 | Somerset | Maryland | 24039 | 2691 | 42 |
1606672 | 1606672 | 2021-08-11 | Somerset | Maryland | 24039 | 2688 | 42 |
1603423 | 1603423 | 2021-08-10 | Somerset | Maryland | 24039 | 2681 | 42 |
1600174 | 1600174 | 2021-08-09 | Somerset | Maryland | 24039 | 2669 | 42 |
1596926 | 1596926 | 2021-08-08 | Somerset | Maryland | 24039 | 2666 | 42 |
1593677 | 1593677 | 2021-08-07 | Somerset | Maryland | 24039 | 2665 | 42 |
1590428 | 1590428 | 2021-08-06 | Somerset | Maryland | 24039 | 2661 | 42 |
1587179 | 1587179 | 2021-08-05 | Somerset | Maryland | 24039 | 2655 | 42 |
1583928 | 1583928 | 2021-08-04 | Somerset | Maryland | 24039 | 2652 | 42 |
1580679 | 1580679 | 2021-08-03 | Somerset | Maryland | 24039 | 2646 | 42 |
1577430 | 1577430 | 2021-08-02 | Somerset | Maryland | 24039 | 2644 | 42 |
1574182 | 1574182 | 2021-08-01 | Somerset | Maryland | 24039 | 2641 | 42 |
1570934 | 1570934 | 2021-07-31 | Somerset | Maryland | 24039 | 2639 | 42 |
1567686 | 1567686 | 2021-07-30 | Somerset | Maryland | 24039 | 2637 | 42 |
1564438 | 1564438 | 2021-07-29 | Somerset | Maryland | 24039 | 2638 | 42 |
1561190 | 1561190 | 2021-07-28 | Somerset | Maryland | 24039 | 2634 | 42 |
1557942 | 1557942 | 2021-07-27 | Somerset | Maryland | 24039 | 2634 | 42 |
1554695 | 1554695 | 2021-07-26 | Somerset | Maryland | 24039 | 2633 | 42 |
1551448 | 1551448 | 2021-07-25 | Somerset | Maryland | 24039 | 2633 | 42 |
1548201 | 1548201 | 2021-07-24 | Somerset | Maryland | 24039 | 2633 | 42 |
1544954 | 1544954 | 2021-07-23 | Somerset | Maryland | 24039 | 2633 | 42 |
1541706 | 1541706 | 2021-07-22 | Somerset | Maryland | 24039 | 2632 | 42 |
1538459 | 1538459 | 2021-07-21 | Somerset | Maryland | 24039 | 2631 | 42 |
1535212 | 1535212 | 2021-07-20 | Somerset | Maryland | 24039 | 2630 | 42 |
1531964 | 1531964 | 2021-07-19 | Somerset | Maryland | 24039 | 2630 | 42 |
1528717 | 1528717 | 2021-07-18 | Somerset | Maryland | 24039 | 2628 | 42 |
1525470 | 1525470 | 2021-07-17 | Somerset | Maryland | 24039 | 2628 | 42 |
1522223 | 1522223 | 2021-07-16 | Somerset | Maryland | 24039 | 2628 | 42 |
1518974 | 1518974 | 2021-07-15 | Somerset | Maryland | 24039 | 2627 | 42 |
1236552 | 1236552 | 2021-04-19 | Queen Anne's | Maryland | 24035 | 2840 | 42 |
1233305 | 1233305 | 2021-04-18 | Queen Anne's | Maryland | 24035 | 2837 | 42 |
1230057 | 1230057 | 2021-04-17 | Queen Anne's | Maryland | 24035 | 2830 | 42 |
1226809 | 1226809 | 2021-04-16 | Queen Anne's | Maryland | 24035 | 2818 | 42 |
1077441 | 1077441 | 2021-03-01 | Kent | Maryland | 24029 | 1127 | 42 |
1074195 | 1074195 | 2021-02-28 | Kent | Maryland | 24029 | 1124 | 42 |
1070949 | 1070949 | 2021-02-27 | Kent | Maryland | 24029 | 1123 | 42 |
1067704 | 1067704 | 2021-02-26 | Kent | Maryland | 24029 | 1122 | 42 |
1064459 | 1064459 | 2021-02-25 | Kent | Maryland | 24029 | 1111 | 42 |
1061215 | 1061215 | 2021-02-24 | Kent | Maryland | 24029 | 1110 | 42 |
1057969 | 1057969 | 2021-02-23 | Kent | Maryland | 24029 | 1109 | 42 |
1054723 | 1054723 | 2021-02-22 | Kent | Maryland | 24029 | 1107 | 42 |
1051476 | 1051476 | 2021-02-21 | Kent | Maryland | 24029 | 1107 | 42 |
1048229 | 1048229 | 2021-02-20 | Kent | Maryland | 24029 | 1106 | 42 |
866481 | 866481 | 2020-12-26 | Garrett | Maryland | 24023 | 1404 | 42 |
847024 | 847024 | 2020-12-20 | Worcester | Maryland | 24047 | 1864 | 42 |
843778 | 843778 | 2020-12-19 | Worcester | Maryland | 24047 | 1843 | 42 |
840533 | 840533 | 2020-12-18 | Worcester | Maryland | 24047 | 1817 | 42 |
837288 | 837288 | 2020-12-17 | Worcester | Maryland | 24047 | 1788 | 42 |
834042 | 834042 | 2020-12-16 | Worcester | Maryland | 24047 | 1773 | 42 |
830775 | 830775 | 2020-12-15 | Calvert | Maryland | 24009 | 1917 | 42 |
827529 | 827529 | 2020-12-14 | Calvert | Maryland | 24009 | 1894 | 42 |
824282 | 824282 | 2020-12-13 | Calvert | Maryland | 24009 | 1868 | 42 |
821036 | 821036 | 2020-12-12 | Calvert | Maryland | 24009 | 1850 | 42 |
811316 | 811316 | 2020-12-09 | Unknown | Maryland | 0 | 42 | |
785342 | 785342 | 2020-12-01 | Cecil | Maryland | 24015 | 2158 | 42 |
782098 | 782098 | 2020-11-30 | Cecil | Maryland | 24015 | 2111 | 42 |
782112 | 782112 | 2020-11-30 | Unknown | Maryland | 0 | 42 | |
778852 | 778852 | 2020-11-29 | Cecil | Maryland | 24015 | 2080 | 42 |
772362 | 772362 | 2020-11-27 | Cecil | Maryland | 24015 | 2026 | 42 |
769117 | 769117 | 2020-11-26 | Cecil | Maryland | 24015 | 1982 | 42 |
662072 | 662072 | 2020-10-24 | Washington | Maryland | 24043 | 2211 | 42 |
658828 | 658828 | 2020-10-23 | Washington | Maryland | 24043 | 2182 | 42 |
655583 | 655583 | 2020-10-22 | Washington | Maryland | 24043 | 2158 | 42 |
652338 | 652338 | 2020-10-21 | Washington | Maryland | 24043 | 2137 | 42 |
649093 | 649093 | 2020-10-20 | Washington | Maryland | 24043 | 2116 | 42 |
645849 | 645849 | 2020-10-19 | Washington | Maryland | 24043 | 2108 | 42 |
642602 | 642602 | 2020-10-18 | Washington | Maryland | 24043 | 2099 | 42 |
639355 | 639355 | 2020-10-17 | Washington | Maryland | 24043 | 2093 | 42 |
636109 | 636109 | 2020-10-16 | Washington | Maryland | 24043 | 2075 | 42 |
632863 | 632863 | 2020-10-15 | Washington | Maryland | 24043 | 2054 | 42 |
377506 | 377506 | 2020-07-28 | Wicomico | Maryland | 24045 | 1256 | 42 |
374291 | 374291 | 2020-07-27 | Wicomico | Maryland | 24045 | 1249 | 42 |
371079 | 371079 | 2020-07-26 | Wicomico | Maryland | 24045 | 1239 | 42 |
367869 | 367869 | 2020-07-25 | Wicomico | Maryland | 24045 | 1228 | 42 |
364662 | 364662 | 2020-07-24 | Wicomico | Maryland | 24045 | 1219 | 42 |
361455 | 361455 | 2020-07-23 | Wicomico | Maryland | 24045 | 1206 | 42 |
358250 | 358250 | 2020-07-22 | Wicomico | Maryland | 24045 | 1201 | 42 |
355047 | 355047 | 2020-07-21 | Wicomico | Maryland | 24045 | 1195 | 42 |
351845 | 351845 | 2020-07-20 | Wicomico | Maryland | 24045 | 1189 | 42 |
348645 | 348645 | 2020-07-19 | Wicomico | Maryland | 24045 | 1181 | 42 |
345444 | 345444 | 2020-07-18 | Wicomico | Maryland | 24045 | 1176 | 42 |
342244 | 342244 | 2020-07-17 | Wicomico | Maryland | 24045 | 1173 | 42 |
339048 | 339048 | 2020-07-16 | Wicomico | Maryland | 24045 | 1164 | 42 |
335852 | 335852 | 2020-07-15 | Wicomico | Maryland | 24045 | 1160 | 42 |
332659 | 332659 | 2020-07-14 | Wicomico | Maryland | 24045 | 1156 | 42 |
329472 | 329472 | 2020-07-13 | Wicomico | Maryland | 24045 | 1139 | 42 |
326286 | 326286 | 2020-07-12 | Wicomico | Maryland | 24045 | 1136 | 42 |
99281 | 99281 | 2020-04-29 | Charles | Maryland | 24017 | 552 | 42 |
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);