ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19,645 rows where state = "Maryland" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 25
county 25
- Montgomery 314
- Harford 311
- Prince George's 310
- Baltimore 308
- Anne Arundel 306
- Charles 306
- Carroll 305
- Baltimore city 304
- Howard 304
- Frederick 303
- Talbot 303
- Calvert 300
- Wicomico 300
- Worcester 299
- Caroline 298
- Somerset 298
- Washington 298
- Cecil 297
- St. Mary's 297
- Garrett 296
- Queen Anne's 296
- Kent 294
- Dorchester 287
- Allegany 286
- Unknown 275
state 1
- Maryland · 7,495 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921640 | 921640 | 2021-01-12 | Allegany | Maryland | 24001 | 5785 | 163 |
921641 | 921641 | 2021-01-12 | Anne Arundel | Maryland | 24003 | 28430 | 404 |
921642 | 921642 | 2021-01-12 | Baltimore | Maryland | 24005 | 42536 | 1015 |
921643 | 921643 | 2021-01-12 | Baltimore city | Maryland | 24510 | 34464 | 749 |
921644 | 921644 | 2021-01-12 | Calvert | Maryland | 24009 | 2784 | 47 |
921645 | 921645 | 2021-01-12 | Caroline | Maryland | 24011 | 1556 | 12 |
921646 | 921646 | 2021-01-12 | Carroll | Maryland | 24013 | 6020 | 178 |
921647 | 921647 | 2021-01-12 | Cecil | Maryland | 24015 | 4127 | 83 |
921648 | 921648 | 2021-01-12 | Charles | Maryland | 24017 | 6819 | 132 |
921649 | 921649 | 2021-01-12 | Dorchester | Maryland | 24019 | 1645 | 24 |
921650 | 921650 | 2021-01-12 | Frederick | Maryland | 24021 | 13509 | 212 |
921651 | 921651 | 2021-01-12 | Garrett | Maryland | 24023 | 1635 | 55 |
921652 | 921652 | 2021-01-12 | Harford | Maryland | 24025 | 9743 | 181 |
921653 | 921653 | 2021-01-12 | Howard | Maryland | 24027 | 12869 | 188 |
921654 | 921654 | 2021-01-12 | Kent | Maryland | 24029 | 879 | 31 |
921655 | 921655 | 2021-01-12 | Montgomery | Maryland | 24031 | 52058 | 1189 |
921656 | 921656 | 2021-01-12 | Prince George's | Maryland | 24033 | 60544 | 1147 |
921657 | 921657 | 2021-01-12 | Queen Anne's | Maryland | 24035 | 2015 | 30 |
921658 | 921658 | 2021-01-12 | Somerset | Maryland | 24039 | 2022 | 23 |
921659 | 921659 | 2021-01-12 | St. Mary's | Maryland | 24037 | 3818 | 94 |
921660 | 921660 | 2021-01-12 | Talbot | Maryland | 24041 | 1420 | 11 |
921661 | 921661 | 2021-01-12 | Unknown | Maryland | 0 | 70 | |
921662 | 921662 | 2021-01-12 | Washington | Maryland | 24043 | 9855 | 176 |
921663 | 921663 | 2021-01-12 | Wicomico | Maryland | 24045 | 5386 | 94 |
921664 | 921664 | 2021-01-12 | Worcester | Maryland | 24047 | 2615 | 59 |
918395 | 918395 | 2021-01-11 | Allegany | Maryland | 24001 | 5771 | 162 |
918396 | 918396 | 2021-01-11 | Anne Arundel | Maryland | 24003 | 28216 | 402 |
918397 | 918397 | 2021-01-11 | Baltimore | Maryland | 24005 | 42338 | 1003 |
918398 | 918398 | 2021-01-11 | Baltimore city | Maryland | 24510 | 34421 | 746 |
918399 | 918399 | 2021-01-11 | Calvert | Maryland | 24009 | 2752 | 47 |
918400 | 918400 | 2021-01-11 | Caroline | Maryland | 24011 | 1542 | 11 |
918401 | 918401 | 2021-01-11 | Carroll | Maryland | 24013 | 5958 | 178 |
918402 | 918402 | 2021-01-11 | Cecil | Maryland | 24015 | 4102 | 82 |
918403 | 918403 | 2021-01-11 | Charles | Maryland | 24017 | 6772 | 131 |
918404 | 918404 | 2021-01-11 | Dorchester | Maryland | 24019 | 1627 | 24 |
918405 | 918405 | 2021-01-11 | Frederick | Maryland | 24021 | 12945 | 209 |
918406 | 918406 | 2021-01-11 | Garrett | Maryland | 24023 | 1624 | 55 |
918407 | 918407 | 2021-01-11 | Harford | Maryland | 24025 | 9686 | 179 |
918408 | 918408 | 2021-01-11 | Howard | Maryland | 24027 | 12740 | 187 |
918409 | 918409 | 2021-01-11 | Kent | Maryland | 24029 | 872 | 30 |
918410 | 918410 | 2021-01-11 | Montgomery | Maryland | 24031 | 51570 | 1183 |
918411 | 918411 | 2021-01-11 | Prince George's | Maryland | 24033 | 60067 | 1142 |
918412 | 918412 | 2021-01-11 | Queen Anne's | Maryland | 24035 | 2007 | 29 |
918413 | 918413 | 2021-01-11 | Somerset | Maryland | 24039 | 1973 | 22 |
918414 | 918414 | 2021-01-11 | St. Mary's | Maryland | 24037 | 3790 | 92 |
918415 | 918415 | 2021-01-11 | Talbot | Maryland | 24041 | 1401 | 11 |
918416 | 918416 | 2021-01-11 | Unknown | Maryland | 0 | 51 | |
918417 | 918417 | 2021-01-11 | Washington | Maryland | 24043 | 9771 | 174 |
918418 | 918418 | 2021-01-11 | Wicomico | Maryland | 24045 | 5333 | 94 |
918419 | 918419 | 2021-01-11 | Worcester | Maryland | 24047 | 2596 | 57 |
915150 | 915150 | 2021-01-10 | Allegany | Maryland | 24001 | 5758 | 162 |
915151 | 915151 | 2021-01-10 | Anne Arundel | Maryland | 24003 | 27784 | 400 |
915152 | 915152 | 2021-01-10 | Baltimore | Maryland | 24005 | 42003 | 998 |
915153 | 915153 | 2021-01-10 | Baltimore city | Maryland | 24510 | 34142 | 744 |
915154 | 915154 | 2021-01-10 | Calvert | Maryland | 24009 | 2680 | 47 |
915155 | 915155 | 2021-01-10 | Caroline | Maryland | 24011 | 1502 | 11 |
915156 | 915156 | 2021-01-10 | Carroll | Maryland | 24013 | 5900 | 177 |
915157 | 915157 | 2021-01-10 | Cecil | Maryland | 24015 | 4012 | 82 |
915158 | 915158 | 2021-01-10 | Charles | Maryland | 24017 | 6696 | 131 |
915159 | 915159 | 2021-01-10 | Dorchester | Maryland | 24019 | 1618 | 24 |
915160 | 915160 | 2021-01-10 | Frederick | Maryland | 24021 | 12826 | 209 |
915161 | 915161 | 2021-01-10 | Garrett | Maryland | 24023 | 1615 | 55 |
915162 | 915162 | 2021-01-10 | Harford | Maryland | 24025 | 9567 | 179 |
915163 | 915163 | 2021-01-10 | Howard | Maryland | 24027 | 12618 | 186 |
915164 | 915164 | 2021-01-10 | Kent | Maryland | 24029 | 854 | 30 |
915165 | 915165 | 2021-01-10 | Montgomery | Maryland | 24031 | 51110 | 1180 |
915166 | 915166 | 2021-01-10 | Prince George's | Maryland | 24033 | 59575 | 1137 |
915167 | 915167 | 2021-01-10 | Queen Anne's | Maryland | 24035 | 1970 | 29 |
915168 | 915168 | 2021-01-10 | Somerset | Maryland | 24039 | 1965 | 22 |
915169 | 915169 | 2021-01-10 | St. Mary's | Maryland | 24037 | 3734 | 92 |
915170 | 915170 | 2021-01-10 | Talbot | Maryland | 24041 | 1381 | 11 |
915171 | 915171 | 2021-01-10 | Unknown | Maryland | 0 | 44 | |
915172 | 915172 | 2021-01-10 | Washington | Maryland | 24043 | 9681 | 174 |
915173 | 915173 | 2021-01-10 | Wicomico | Maryland | 24045 | 5295 | 93 |
915174 | 915174 | 2021-01-10 | Worcester | Maryland | 24047 | 2567 | 55 |
911905 | 911905 | 2021-01-09 | Allegany | Maryland | 24001 | 5729 | 161 |
911906 | 911906 | 2021-01-09 | Anne Arundel | Maryland | 24003 | 27359 | 397 |
911907 | 911907 | 2021-01-09 | Baltimore | Maryland | 24005 | 41632 | 996 |
911908 | 911908 | 2021-01-09 | Baltimore city | Maryland | 24510 | 33869 | 745 |
911909 | 911909 | 2021-01-09 | Calvert | Maryland | 24009 | 2612 | 47 |
911910 | 911910 | 2021-01-09 | Caroline | Maryland | 24011 | 1482 | 11 |
911911 | 911911 | 2021-01-09 | Carroll | Maryland | 24013 | 5846 | 177 |
911912 | 911912 | 2021-01-09 | Cecil | Maryland | 24015 | 3962 | 82 |
911913 | 911913 | 2021-01-09 | Charles | Maryland | 24017 | 6625 | 130 |
911914 | 911914 | 2021-01-09 | Dorchester | Maryland | 24019 | 1597 | 24 |
911915 | 911915 | 2021-01-09 | Frederick | Maryland | 24021 | 12738 | 209 |
911916 | 911916 | 2021-01-09 | Garrett | Maryland | 24023 | 1599 | 54 |
911917 | 911917 | 2021-01-09 | Harford | Maryland | 24025 | 9448 | 179 |
911918 | 911918 | 2021-01-09 | Howard | Maryland | 24027 | 12465 | 184 |
911919 | 911919 | 2021-01-09 | Kent | Maryland | 24029 | 842 | 28 |
911920 | 911920 | 2021-01-09 | Montgomery | Maryland | 24031 | 50471 | 1174 |
911921 | 911921 | 2021-01-09 | Prince George's | Maryland | 24033 | 58981 | 1131 |
911922 | 911922 | 2021-01-09 | Queen Anne's | Maryland | 24035 | 1936 | 29 |
911923 | 911923 | 2021-01-09 | Somerset | Maryland | 24039 | 1962 | 22 |
911924 | 911924 | 2021-01-09 | St. Mary's | Maryland | 24037 | 3708 | 92 |
911925 | 911925 | 2021-01-09 | Talbot | Maryland | 24041 | 1355 | 11 |
911926 | 911926 | 2021-01-09 | Unknown | Maryland | 1 | 44 | |
911927 | 911927 | 2021-01-09 | Washington | Maryland | 24043 | 9583 | 173 |
911928 | 911928 | 2021-01-09 | Wicomico | Maryland | 24045 | 5216 | 92 |
911929 | 911929 | 2021-01-09 | Worcester | Maryland | 24047 | 2517 | 54 |
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);