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 226
- Harford 223
- Prince George's 222
- Baltimore 220
- Anne Arundel 218
- Charles 218
- Carroll 217
- Baltimore city 216
- Howard 216
- Frederick 215
- Talbot 215
- Calvert 212
- Wicomico 212
- Worcester 211
- Caroline 210
- Somerset 210
- Washington 210
- Cecil 209
- St. Mary's 209
- Garrett 208
- Queen Anne's 208
- Kent 206
- Dorchester 199
- Allegany 198
- Unknown 187
state 1
- Maryland · 5,295 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636087 | 636087 | 2020-10-16 | Allegany | Maryland | 24001 | 543 | 23 |
636088 | 636088 | 2020-10-16 | Anne Arundel | Maryland | 24003 | 11163 | 262 |
636089 | 636089 | 2020-10-16 | Baltimore | Maryland | 24005 | 19426 | 650 |
636090 | 636090 | 2020-10-16 | Baltimore city | Maryland | 24510 | 16698 | 495 |
636091 | 636091 | 2020-10-16 | Calvert | Maryland | 24009 | 1099 | 28 |
636092 | 636092 | 2020-10-16 | Caroline | Maryland | 24011 | 687 | 8 |
636093 | 636093 | 2020-10-16 | Carroll | Maryland | 24013 | 2123 | 128 |
636094 | 636094 | 2020-10-16 | Cecil | Maryland | 24015 | 1245 | 36 |
636095 | 636095 | 2020-10-16 | Charles | Maryland | 24017 | 2993 | 101 |
636096 | 636096 | 2020-10-16 | Dorchester | Maryland | 24019 | 661 | 10 |
636097 | 636097 | 2020-10-16 | Frederick | Maryland | 24021 | 4472 | 137 |
636098 | 636098 | 2020-10-16 | Garrett | Maryland | 24023 | 94 | 1 |
636099 | 636099 | 2020-10-16 | Harford | Maryland | 24025 | 3357 | 77 |
636100 | 636100 | 2020-10-16 | Howard | Maryland | 24027 | 5540 | 123 |
636101 | 636101 | 2020-10-16 | Kent | Maryland | 24029 | 328 | 24 |
636102 | 636102 | 2020-10-16 | Montgomery | Maryland | 24031 | 24214 | 860 |
636103 | 636103 | 2020-10-16 | Prince George's | Maryland | 24033 | 31582 | 841 |
636104 | 636104 | 2020-10-16 | Queen Anne's | Maryland | 24035 | 720 | 26 |
636105 | 636105 | 2020-10-16 | Somerset | Maryland | 24039 | 368 | 5 |
636106 | 636106 | 2020-10-16 | St. Mary's | Maryland | 24037 | 1385 | 59 |
636107 | 636107 | 2020-10-16 | Talbot | Maryland | 24041 | 602 | 6 |
636108 | 636108 | 2020-10-16 | Unknown | Maryland | 0 | 11 | |
636109 | 636109 | 2020-10-16 | Washington | Maryland | 24043 | 2075 | 42 |
636110 | 636110 | 2020-10-16 | Wicomico | Maryland | 24045 | 2287 | 49 |
636111 | 636111 | 2020-10-16 | Worcester | Maryland | 24047 | 1160 | 30 |
632841 | 632841 | 2020-10-15 | Allegany | Maryland | 24001 | 538 | 23 |
632842 | 632842 | 2020-10-15 | Anne Arundel | Maryland | 24003 | 11065 | 262 |
632843 | 632843 | 2020-10-15 | Baltimore | Maryland | 24005 | 19298 | 649 |
632844 | 632844 | 2020-10-15 | Baltimore city | Maryland | 24510 | 16664 | 494 |
632845 | 632845 | 2020-10-15 | Calvert | Maryland | 24009 | 1083 | 28 |
632846 | 632846 | 2020-10-15 | Caroline | Maryland | 24011 | 688 | 8 |
632847 | 632847 | 2020-10-15 | Carroll | Maryland | 24013 | 2111 | 128 |
632848 | 632848 | 2020-10-15 | Cecil | Maryland | 24015 | 1193 | 36 |
632849 | 632849 | 2020-10-15 | Charles | Maryland | 24017 | 2985 | 101 |
632850 | 632850 | 2020-10-15 | Dorchester | Maryland | 24019 | 653 | 10 |
632851 | 632851 | 2020-10-15 | Frederick | Maryland | 24021 | 4444 | 137 |
632852 | 632852 | 2020-10-15 | Garrett | Maryland | 24023 | 88 | 1 |
632853 | 632853 | 2020-10-15 | Harford | Maryland | 24025 | 3339 | 77 |
632854 | 632854 | 2020-10-15 | Howard | Maryland | 24027 | 5514 | 123 |
632855 | 632855 | 2020-10-15 | Kent | Maryland | 24029 | 328 | 24 |
632856 | 632856 | 2020-10-15 | Montgomery | Maryland | 24031 | 24055 | 860 |
632857 | 632857 | 2020-10-15 | Prince George's | Maryland | 24033 | 31475 | 841 |
632858 | 632858 | 2020-10-15 | Queen Anne's | Maryland | 24035 | 715 | 26 |
632859 | 632859 | 2020-10-15 | Somerset | Maryland | 24039 | 363 | 5 |
632860 | 632860 | 2020-10-15 | St. Mary's | Maryland | 24037 | 1382 | 59 |
632861 | 632861 | 2020-10-15 | Talbot | Maryland | 24041 | 596 | 6 |
632862 | 632862 | 2020-10-15 | Unknown | Maryland | 0 | 9 | |
632863 | 632863 | 2020-10-15 | Washington | Maryland | 24043 | 2054 | 42 |
632864 | 632864 | 2020-10-15 | Wicomico | Maryland | 24045 | 2259 | 49 |
632865 | 632865 | 2020-10-15 | Worcester | Maryland | 24047 | 1152 | 30 |
629596 | 629596 | 2020-10-14 | Allegany | Maryland | 24001 | 536 | 23 |
629597 | 629597 | 2020-10-14 | Anne Arundel | Maryland | 24003 | 10998 | 260 |
629598 | 629598 | 2020-10-14 | Baltimore | Maryland | 24005 | 19199 | 647 |
629599 | 629599 | 2020-10-14 | Baltimore city | Maryland | 24510 | 16601 | 495 |
629600 | 629600 | 2020-10-14 | Calvert | Maryland | 24009 | 1079 | 28 |
629601 | 629601 | 2020-10-14 | Caroline | Maryland | 24011 | 686 | 8 |
629602 | 629602 | 2020-10-14 | Carroll | Maryland | 24013 | 2102 | 127 |
629603 | 629603 | 2020-10-14 | Cecil | Maryland | 24015 | 1191 | 36 |
629604 | 629604 | 2020-10-14 | Charles | Maryland | 24017 | 2964 | 101 |
629605 | 629605 | 2020-10-14 | Dorchester | Maryland | 24019 | 644 | 10 |
629606 | 629606 | 2020-10-14 | Frederick | Maryland | 24021 | 4407 | 135 |
629607 | 629607 | 2020-10-14 | Garrett | Maryland | 24023 | 87 | 1 |
629608 | 629608 | 2020-10-14 | Harford | Maryland | 24025 | 3321 | 77 |
629609 | 629609 | 2020-10-14 | Howard | Maryland | 24027 | 5493 | 123 |
629610 | 629610 | 2020-10-14 | Kent | Maryland | 24029 | 327 | 24 |
629611 | 629611 | 2020-10-14 | Montgomery | Maryland | 24031 | 23966 | 859 |
629612 | 629612 | 2020-10-14 | Prince George's | Maryland | 24033 | 31343 | 840 |
629613 | 629613 | 2020-10-14 | Queen Anne's | Maryland | 24035 | 712 | 26 |
629614 | 629614 | 2020-10-14 | Somerset | Maryland | 24039 | 358 | 4 |
629615 | 629615 | 2020-10-14 | St. Mary's | Maryland | 24037 | 1375 | 59 |
629616 | 629616 | 2020-10-14 | Talbot | Maryland | 24041 | 593 | 6 |
629617 | 629617 | 2020-10-14 | Unknown | Maryland | 0 | 13 | |
629618 | 629618 | 2020-10-14 | Washington | Maryland | 24043 | 2039 | 41 |
629619 | 629619 | 2020-10-14 | Wicomico | Maryland | 24045 | 2248 | 49 |
629620 | 629620 | 2020-10-14 | Worcester | Maryland | 24047 | 1144 | 30 |
626352 | 626352 | 2020-10-13 | Allegany | Maryland | 24001 | 528 | 23 |
626353 | 626353 | 2020-10-13 | Anne Arundel | Maryland | 24003 | 10927 | 258 |
626354 | 626354 | 2020-10-13 | Baltimore | Maryland | 24005 | 19125 | 647 |
626355 | 626355 | 2020-10-13 | Baltimore city | Maryland | 24510 | 16560 | 494 |
626356 | 626356 | 2020-10-13 | Calvert | Maryland | 24009 | 1075 | 28 |
626357 | 626357 | 2020-10-13 | Caroline | Maryland | 24011 | 684 | 8 |
626358 | 626358 | 2020-10-13 | Carroll | Maryland | 24013 | 2095 | 126 |
626359 | 626359 | 2020-10-13 | Cecil | Maryland | 24015 | 1180 | 36 |
626360 | 626360 | 2020-10-13 | Charles | Maryland | 24017 | 2949 | 101 |
626361 | 626361 | 2020-10-13 | Dorchester | Maryland | 24019 | 642 | 10 |
626362 | 626362 | 2020-10-13 | Frederick | Maryland | 24021 | 4387 | 135 |
626363 | 626363 | 2020-10-13 | Garrett | Maryland | 24023 | 82 | 1 |
626364 | 626364 | 2020-10-13 | Harford | Maryland | 24025 | 3292 | 77 |
626365 | 626365 | 2020-10-13 | Howard | Maryland | 24027 | 5479 | 123 |
626366 | 626366 | 2020-10-13 | Kent | Maryland | 24029 | 327 | 24 |
626367 | 626367 | 2020-10-13 | Montgomery | Maryland | 24031 | 23857 | 856 |
626368 | 626368 | 2020-10-13 | Prince George's | Maryland | 24033 | 31253 | 839 |
626369 | 626369 | 2020-10-13 | Queen Anne's | Maryland | 24035 | 706 | 26 |
626370 | 626370 | 2020-10-13 | Somerset | Maryland | 24039 | 345 | 4 |
626371 | 626371 | 2020-10-13 | St. Mary's | Maryland | 24037 | 1373 | 59 |
626372 | 626372 | 2020-10-13 | Talbot | Maryland | 24041 | 589 | 6 |
626373 | 626373 | 2020-10-13 | Unknown | Maryland | 0 | 11 | |
626374 | 626374 | 2020-10-13 | Washington | Maryland | 24043 | 2008 | 41 |
626375 | 626375 | 2020-10-13 | Wicomico | Maryland | 24045 | 2242 | 49 |
626376 | 626376 | 2020-10-13 | Worcester | Maryland | 24047 | 1134 | 30 |
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);