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)
Suggested facets: date (date)
fips 25
county 25
- Montgomery 800
- Harford 797
- Prince George's 796
- Baltimore 794
- Anne Arundel 792
- Charles 792
- Carroll 791
- Baltimore city 790
- Howard 790
- Frederick 789
- Talbot 789
- Calvert 786
- Wicomico 786
- Worcester 785
- Caroline 784
- Somerset 784
- Washington 784
- Cecil 783
- St. Mary's 783
- Garrett 782
- Queen Anne's 782
- Kent 780
- Dorchester 773
- Allegany 772
- Unknown 761
state 1
- Maryland · 19,645 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500781 | 2500781 | 2022-05-13 | Allegany | Maryland | 24001 | 17291 | 362 |
2500782 | 2500782 | 2022-05-13 | Anne Arundel | Maryland | 24003 | 92830 | 1078 |
2500783 | 2500783 | 2022-05-13 | Baltimore | Maryland | 24005 | 136295 | 2484 |
2500784 | 2500784 | 2022-05-13 | Baltimore city | Maryland | 24510 | 116724 | 1777 |
2500785 | 2500785 | 2022-05-13 | Calvert | Maryland | 24009 | 11468 | 146 |
2500786 | 2500786 | 2022-05-13 | Caroline | Maryland | 24011 | 6159 | 80 |
2500787 | 2500787 | 2022-05-13 | Carroll | Maryland | 24013 | 22141 | 409 |
2500788 | 2500788 | 2022-05-13 | Cecil | Maryland | 24015 | 15906 | 259 |
2500789 | 2500789 | 2022-05-13 | Charles | Maryland | 24017 | 28950 | 353 |
2500790 | 2500790 | 2022-05-13 | Dorchester | Maryland | 24019 | 7819 | 108 |
2500791 | 2500791 | 2022-05-13 | Frederick | Maryland | 24021 | 46920 | 525 |
2500792 | 2500792 | 2022-05-13 | Garrett | Maryland | 24023 | 5761 | 116 |
2500793 | 2500793 | 2022-05-13 | Harford | Maryland | 24025 | 39423 | 582 |
2500794 | 2500794 | 2022-05-13 | Howard | Maryland | 24027 | 46124 | 378 |
2500795 | 2500795 | 2022-05-13 | Kent | Maryland | 24029 | 3122 | 66 |
2500796 | 2500796 | 2022-05-13 | Montgomery | Maryland | 24031 | 178052 | 2044 |
2500797 | 2500797 | 2022-05-13 | Prince George's | Maryland | 24033 | 175401 | 2163 |
2500798 | 2500798 | 2022-05-13 | Queen Anne's | Maryland | 24035 | 7246 | 110 |
2500799 | 2500799 | 2022-05-13 | Somerset | Maryland | 24039 | 5267 | 74 |
2500800 | 2500800 | 2022-05-13 | St. Mary's | Maryland | 24037 | 19329 | 217 |
2500801 | 2500801 | 2022-05-13 | Talbot | Maryland | 24041 | 5702 | 88 |
2500802 | 2500802 | 2022-05-13 | Unknown | Maryland | 0 | 27 | |
2500803 | 2500803 | 2022-05-13 | Washington | Maryland | 24043 | 35434 | 586 |
2500804 | 2500804 | 2022-05-13 | Wicomico | Maryland | 24045 | 20013 | 328 |
2500805 | 2500805 | 2022-05-13 | Worcester | Maryland | 24047 | 8826 | 160 |
2497523 | 2497523 | 2022-05-12 | Allegany | Maryland | 24001 | 17277 | 362 |
2497524 | 2497524 | 2022-05-12 | Anne Arundel | Maryland | 24003 | 92637 | 1078 |
2497525 | 2497525 | 2022-05-12 | Baltimore | Maryland | 24005 | 135986 | 2484 |
2497526 | 2497526 | 2022-05-12 | Baltimore city | Maryland | 24510 | 116321 | 1776 |
2497527 | 2497527 | 2022-05-12 | Calvert | Maryland | 24009 | 11439 | 145 |
2497528 | 2497528 | 2022-05-12 | Caroline | Maryland | 24011 | 6147 | 80 |
2497529 | 2497529 | 2022-05-12 | Carroll | Maryland | 24013 | 22092 | 409 |
2497530 | 2497530 | 2022-05-12 | Cecil | Maryland | 24015 | 15873 | 259 |
2497531 | 2497531 | 2022-05-12 | Charles | Maryland | 24017 | 28860 | 353 |
2497532 | 2497532 | 2022-05-12 | Dorchester | Maryland | 24019 | 7812 | 108 |
2497533 | 2497533 | 2022-05-12 | Frederick | Maryland | 24021 | 46839 | 525 |
2497534 | 2497534 | 2022-05-12 | Garrett | Maryland | 24023 | 5757 | 116 |
2497535 | 2497535 | 2022-05-12 | Harford | Maryland | 24025 | 39366 | 582 |
2497536 | 2497536 | 2022-05-12 | Howard | Maryland | 24027 | 46011 | 378 |
2497537 | 2497537 | 2022-05-12 | Kent | Maryland | 24029 | 3117 | 66 |
2497538 | 2497538 | 2022-05-12 | Montgomery | Maryland | 24031 | 177386 | 2044 |
2497539 | 2497539 | 2022-05-12 | Prince George's | Maryland | 24033 | 175116 | 2161 |
2497540 | 2497540 | 2022-05-12 | Queen Anne's | Maryland | 24035 | 7236 | 110 |
2497541 | 2497541 | 2022-05-12 | Somerset | Maryland | 24039 | 5254 | 74 |
2497542 | 2497542 | 2022-05-12 | St. Mary's | Maryland | 24037 | 19312 | 217 |
2497543 | 2497543 | 2022-05-12 | Talbot | Maryland | 24041 | 5694 | 88 |
2497544 | 2497544 | 2022-05-12 | Unknown | Maryland | 0 | 30 | |
2497545 | 2497545 | 2022-05-12 | Washington | Maryland | 24043 | 35423 | 586 |
2497546 | 2497546 | 2022-05-12 | Wicomico | Maryland | 24045 | 19968 | 328 |
2497547 | 2497547 | 2022-05-12 | Worcester | Maryland | 24047 | 8813 | 160 |
2494265 | 2494265 | 2022-05-11 | Allegany | Maryland | 24001 | 17272 | 362 |
2494266 | 2494266 | 2022-05-11 | Anne Arundel | Maryland | 24003 | 92440 | 1078 |
2494267 | 2494267 | 2022-05-11 | Baltimore | Maryland | 24005 | 135688 | 2482 |
2494268 | 2494268 | 2022-05-11 | Baltimore city | Maryland | 24510 | 116053 | 1776 |
2494269 | 2494269 | 2022-05-11 | Calvert | Maryland | 24009 | 11418 | 145 |
2494270 | 2494270 | 2022-05-11 | Caroline | Maryland | 24011 | 6133 | 80 |
2494271 | 2494271 | 2022-05-11 | Carroll | Maryland | 24013 | 22048 | 408 |
2494272 | 2494272 | 2022-05-11 | Cecil | Maryland | 24015 | 15853 | 259 |
2494273 | 2494273 | 2022-05-11 | Charles | Maryland | 24017 | 28808 | 353 |
2494274 | 2494274 | 2022-05-11 | Dorchester | Maryland | 24019 | 7803 | 108 |
2494275 | 2494275 | 2022-05-11 | Frederick | Maryland | 24021 | 46763 | 525 |
2494276 | 2494276 | 2022-05-11 | Garrett | Maryland | 24023 | 5755 | 116 |
2494277 | 2494277 | 2022-05-11 | Harford | Maryland | 24025 | 39291 | 582 |
2494278 | 2494278 | 2022-05-11 | Howard | Maryland | 24027 | 45875 | 377 |
2494279 | 2494279 | 2022-05-11 | Kent | Maryland | 24029 | 3112 | 66 |
2494280 | 2494280 | 2022-05-11 | Montgomery | Maryland | 24031 | 176822 | 2043 |
2494281 | 2494281 | 2022-05-11 | Prince George's | Maryland | 24033 | 174839 | 2159 |
2494282 | 2494282 | 2022-05-11 | Queen Anne's | Maryland | 24035 | 7223 | 110 |
2494283 | 2494283 | 2022-05-11 | Somerset | Maryland | 24039 | 5250 | 74 |
2494284 | 2494284 | 2022-05-11 | St. Mary's | Maryland | 24037 | 19267 | 217 |
2494285 | 2494285 | 2022-05-11 | Talbot | Maryland | 24041 | 5687 | 88 |
2494286 | 2494286 | 2022-05-11 | Unknown | Maryland | 0 | 28 | |
2494287 | 2494287 | 2022-05-11 | Washington | Maryland | 24043 | 35393 | 586 |
2494288 | 2494288 | 2022-05-11 | Wicomico | Maryland | 24045 | 19936 | 328 |
2494289 | 2494289 | 2022-05-11 | Worcester | Maryland | 24047 | 8797 | 160 |
2491007 | 2491007 | 2022-05-10 | Allegany | Maryland | 24001 | 17265 | 362 |
2491008 | 2491008 | 2022-05-10 | Anne Arundel | Maryland | 24003 | 92316 | 1078 |
2491009 | 2491009 | 2022-05-10 | Baltimore | Maryland | 24005 | 135487 | 2480 |
2491010 | 2491010 | 2022-05-10 | Baltimore city | Maryland | 24510 | 115782 | 1776 |
2491011 | 2491011 | 2022-05-10 | Calvert | Maryland | 24009 | 11391 | 145 |
2491012 | 2491012 | 2022-05-10 | Caroline | Maryland | 24011 | 6132 | 80 |
2491013 | 2491013 | 2022-05-10 | Carroll | Maryland | 24013 | 22018 | 405 |
2491014 | 2491014 | 2022-05-10 | Cecil | Maryland | 24015 | 15825 | 259 |
2491015 | 2491015 | 2022-05-10 | Charles | Maryland | 24017 | 28769 | 353 |
2491016 | 2491016 | 2022-05-10 | Dorchester | Maryland | 24019 | 7801 | 108 |
2491017 | 2491017 | 2022-05-10 | Frederick | Maryland | 24021 | 46709 | 525 |
2491018 | 2491018 | 2022-05-10 | Garrett | Maryland | 24023 | 5752 | 116 |
2491019 | 2491019 | 2022-05-10 | Harford | Maryland | 24025 | 39256 | 582 |
2491020 | 2491020 | 2022-05-10 | Howard | Maryland | 24027 | 45774 | 376 |
2491021 | 2491021 | 2022-05-10 | Kent | Maryland | 24029 | 3105 | 66 |
2491022 | 2491022 | 2022-05-10 | Montgomery | Maryland | 24031 | 176454 | 2041 |
2491023 | 2491023 | 2022-05-10 | Prince George's | Maryland | 24033 | 174683 | 2159 |
2491024 | 2491024 | 2022-05-10 | Queen Anne's | Maryland | 24035 | 7221 | 110 |
2491025 | 2491025 | 2022-05-10 | Somerset | Maryland | 24039 | 5246 | 74 |
2491026 | 2491026 | 2022-05-10 | St. Mary's | Maryland | 24037 | 19234 | 216 |
2491027 | 2491027 | 2022-05-10 | Talbot | Maryland | 24041 | 5685 | 88 |
2491028 | 2491028 | 2022-05-10 | Unknown | Maryland | 0 | 32 | |
2491029 | 2491029 | 2022-05-10 | Washington | Maryland | 24043 | 35375 | 586 |
2491030 | 2491030 | 2022-05-10 | Wicomico | Maryland | 24045 | 19919 | 328 |
2491031 | 2491031 | 2022-05-10 | Worcester | Maryland | 24047 | 8787 | 160 |
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);