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 195
- Harford 192
- Prince George's 191
- Baltimore 189
- Anne Arundel 187
- Charles 187
- Carroll 186
- Baltimore city 185
- Howard 185
- Frederick 184
- Talbot 184
- Calvert 181
- Wicomico 181
- Worcester 180
- Caroline 179
- Somerset 179
- Washington 179
- Cecil 178
- St. Mary's 178
- Garrett 177
- Queen Anne's 177
- Kent 175
- Dorchester 168
- Allegany 167
- Unknown 156
state 1
- Maryland · 4,520 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535622 | 535622 | 2020-09-15 | Allegany | Maryland | 24001 | 429 | 22 |
535623 | 535623 | 2020-09-15 | Anne Arundel | Maryland | 24003 | 9313 | 240 |
535624 | 535624 | 2020-09-15 | Baltimore | Maryland | 24005 | 16928 | 613 |
535625 | 535625 | 2020-09-15 | Baltimore city | Maryland | 24510 | 15254 | 474 |
535626 | 535626 | 2020-09-15 | Calvert | Maryland | 24009 | 882 | 28 |
535627 | 535627 | 2020-09-15 | Caroline | Maryland | 24011 | 612 | 3 |
535628 | 535628 | 2020-09-15 | Carroll | Maryland | 24013 | 1874 | 123 |
535629 | 535629 | 2020-09-15 | Cecil | Maryland | 24015 | 943 | 31 |
535630 | 535630 | 2020-09-15 | Charles | Maryland | 24017 | 2609 | 95 |
535631 | 535631 | 2020-09-15 | Dorchester | Maryland | 24019 | 538 | 9 |
535632 | 535632 | 2020-09-15 | Frederick | Maryland | 24021 | 3792 | 128 |
535633 | 535633 | 2020-09-15 | Garrett | Maryland | 24023 | 71 | 1 |
535634 | 535634 | 2020-09-15 | Harford | Maryland | 24025 | 2850 | 75 |
535635 | 535635 | 2020-09-15 | Howard | Maryland | 24027 | 4815 | 119 |
535636 | 535636 | 2020-09-15 | Kent | Maryland | 24029 | 295 | 24 |
535637 | 535637 | 2020-09-15 | Montgomery | Maryland | 24031 | 21415 | 835 |
535638 | 535638 | 2020-09-15 | Prince George's | Maryland | 24033 | 28271 | 813 |
535639 | 535639 | 2020-09-15 | Queen Anne's | Maryland | 24035 | 614 | 26 |
535640 | 535640 | 2020-09-15 | Somerset | Maryland | 24039 | 225 | 4 |
535641 | 535641 | 2020-09-15 | St. Mary's | Maryland | 24037 | 1202 | 57 |
535642 | 535642 | 2020-09-15 | Talbot | Maryland | 24041 | 515 | 5 |
535643 | 535643 | 2020-09-15 | Unknown | Maryland | 0 | 15 | |
535644 | 535644 | 2020-09-15 | Washington | Maryland | 24043 | 1525 | 35 |
535645 | 535645 | 2020-09-15 | Wicomico | Maryland | 24045 | 1819 | 48 |
535646 | 535646 | 2020-09-15 | Worcester | Maryland | 24047 | 954 | 26 |
532387 | 532387 | 2020-09-14 | Allegany | Maryland | 24001 | 424 | 22 |
532388 | 532388 | 2020-09-14 | Anne Arundel | Maryland | 24003 | 9202 | 240 |
532389 | 532389 | 2020-09-14 | Baltimore | Maryland | 24005 | 16820 | 612 |
532390 | 532390 | 2020-09-14 | Baltimore city | Maryland | 24510 | 15317 | 473 |
532391 | 532391 | 2020-09-14 | Calvert | Maryland | 24009 | 875 | 28 |
532392 | 532392 | 2020-09-14 | Caroline | Maryland | 24011 | 609 | 3 |
532393 | 532393 | 2020-09-14 | Carroll | Maryland | 24013 | 1866 | 123 |
532394 | 532394 | 2020-09-14 | Cecil | Maryland | 24015 | 919 | 31 |
532395 | 532395 | 2020-09-14 | Charles | Maryland | 24017 | 2593 | 95 |
532396 | 532396 | 2020-09-14 | Dorchester | Maryland | 24019 | 530 | 9 |
532397 | 532397 | 2020-09-14 | Frederick | Maryland | 24021 | 3763 | 128 |
532398 | 532398 | 2020-09-14 | Garrett | Maryland | 24023 | 68 | 1 |
532399 | 532399 | 2020-09-14 | Harford | Maryland | 24025 | 2838 | 75 |
532400 | 532400 | 2020-09-14 | Howard | Maryland | 24027 | 4793 | 119 |
532401 | 532401 | 2020-09-14 | Kent | Maryland | 24029 | 293 | 24 |
532402 | 532402 | 2020-09-14 | Montgomery | Maryland | 24031 | 21321 | 834 |
532403 | 532403 | 2020-09-14 | Prince George's | Maryland | 24033 | 28141 | 813 |
532404 | 532404 | 2020-09-14 | Queen Anne's | Maryland | 24035 | 613 | 26 |
532405 | 532405 | 2020-09-14 | Somerset | Maryland | 24039 | 220 | 4 |
532406 | 532406 | 2020-09-14 | St. Mary's | Maryland | 24037 | 1197 | 57 |
532407 | 532407 | 2020-09-14 | Talbot | Maryland | 24041 | 512 | 5 |
532408 | 532408 | 2020-09-14 | Unknown | Maryland | 0 | 8 | |
532409 | 532409 | 2020-09-14 | Washington | Maryland | 24043 | 1506 | 35 |
532410 | 532410 | 2020-09-14 | Wicomico | Maryland | 24045 | 1778 | 48 |
532411 | 532411 | 2020-09-14 | Worcester | Maryland | 24047 | 949 | 26 |
529151 | 529151 | 2020-09-13 | Allegany | Maryland | 24001 | 421 | 22 |
529152 | 529152 | 2020-09-13 | Anne Arundel | Maryland | 24003 | 9130 | 240 |
529153 | 529153 | 2020-09-13 | Baltimore | Maryland | 24005 | 16747 | 611 |
529154 | 529154 | 2020-09-13 | Baltimore city | Maryland | 24510 | 15272 | 473 |
529155 | 529155 | 2020-09-13 | Calvert | Maryland | 24009 | 863 | 28 |
529156 | 529156 | 2020-09-13 | Caroline | Maryland | 24011 | 609 | 3 |
529157 | 529157 | 2020-09-13 | Carroll | Maryland | 24013 | 1855 | 123 |
529158 | 529158 | 2020-09-13 | Cecil | Maryland | 24015 | 912 | 31 |
529159 | 529159 | 2020-09-13 | Charles | Maryland | 24017 | 2572 | 95 |
529160 | 529160 | 2020-09-13 | Dorchester | Maryland | 24019 | 527 | 9 |
529161 | 529161 | 2020-09-13 | Frederick | Maryland | 24021 | 3749 | 128 |
529162 | 529162 | 2020-09-13 | Garrett | Maryland | 24023 | 68 | 1 |
529163 | 529163 | 2020-09-13 | Harford | Maryland | 24025 | 2815 | 75 |
529164 | 529164 | 2020-09-13 | Howard | Maryland | 24027 | 4774 | 119 |
529165 | 529165 | 2020-09-13 | Kent | Maryland | 24029 | 292 | 24 |
529166 | 529166 | 2020-09-13 | Montgomery | Maryland | 24031 | 21207 | 834 |
529167 | 529167 | 2020-09-13 | Prince George's | Maryland | 24033 | 28053 | 813 |
529168 | 529168 | 2020-09-13 | Queen Anne's | Maryland | 24035 | 608 | 26 |
529169 | 529169 | 2020-09-13 | Somerset | Maryland | 24039 | 219 | 4 |
529170 | 529170 | 2020-09-13 | St. Mary's | Maryland | 24037 | 1193 | 57 |
529171 | 529171 | 2020-09-13 | Talbot | Maryland | 24041 | 510 | 5 |
529172 | 529172 | 2020-09-13 | Unknown | Maryland | 0 | 8 | |
529173 | 529173 | 2020-09-13 | Washington | Maryland | 24043 | 1493 | 35 |
529174 | 529174 | 2020-09-13 | Wicomico | Maryland | 24045 | 1770 | 48 |
529175 | 529175 | 2020-09-13 | Worcester | Maryland | 24047 | 941 | 26 |
525915 | 525915 | 2020-09-12 | Allegany | Maryland | 24001 | 415 | 22 |
525916 | 525916 | 2020-09-12 | Anne Arundel | Maryland | 24003 | 9076 | 240 |
525917 | 525917 | 2020-09-12 | Baltimore | Maryland | 24005 | 16671 | 610 |
525918 | 525918 | 2020-09-12 | Baltimore city | Maryland | 24510 | 15201 | 472 |
525919 | 525919 | 2020-09-12 | Calvert | Maryland | 24009 | 855 | 28 |
525920 | 525920 | 2020-09-12 | Caroline | Maryland | 24011 | 606 | 3 |
525921 | 525921 | 2020-09-12 | Carroll | Maryland | 24013 | 1845 | 123 |
525922 | 525922 | 2020-09-12 | Cecil | Maryland | 24015 | 905 | 31 |
525923 | 525923 | 2020-09-12 | Charles | Maryland | 24017 | 2556 | 95 |
525924 | 525924 | 2020-09-12 | Dorchester | Maryland | 24019 | 514 | 9 |
525925 | 525925 | 2020-09-12 | Frederick | Maryland | 24021 | 3724 | 128 |
525926 | 525926 | 2020-09-12 | Garrett | Maryland | 24023 | 67 | 1 |
525927 | 525927 | 2020-09-12 | Harford | Maryland | 24025 | 2785 | 75 |
525928 | 525928 | 2020-09-12 | Howard | Maryland | 24027 | 4749 | 119 |
525929 | 525929 | 2020-09-12 | Kent | Maryland | 24029 | 290 | 24 |
525930 | 525930 | 2020-09-12 | Montgomery | Maryland | 24031 | 21129 | 834 |
525931 | 525931 | 2020-09-12 | Prince George's | Maryland | 24033 | 27812 | 810 |
525932 | 525932 | 2020-09-12 | Queen Anne's | Maryland | 24035 | 607 | 26 |
525933 | 525933 | 2020-09-12 | Somerset | Maryland | 24039 | 216 | 4 |
525934 | 525934 | 2020-09-12 | St. Mary's | Maryland | 24037 | 1186 | 57 |
525935 | 525935 | 2020-09-12 | Talbot | Maryland | 24041 | 508 | 5 |
525936 | 525936 | 2020-09-12 | Unknown | Maryland | 0 | 11 | |
525937 | 525937 | 2020-09-12 | Washington | Maryland | 24043 | 1474 | 35 |
525938 | 525938 | 2020-09-12 | Wicomico | Maryland | 24045 | 1754 | 48 |
525939 | 525939 | 2020-09-12 | Worcester | Maryland | 24047 | 931 | 26 |
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);