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 355
- Harford 352
- Prince George's 351
- Baltimore 349
- Anne Arundel 347
- Charles 347
- Carroll 346
- Baltimore city 345
- Howard 345
- Frederick 344
- Talbot 344
- Calvert 341
- Wicomico 341
- Worcester 340
- Caroline 339
- Somerset 339
- Washington 339
- Cecil 338
- St. Mary's 338
- Garrett 337
- Queen Anne's 337
- Kent 335
- Dorchester 328
- Allegany 327
- Unknown 316
state 1
- Maryland · 8,520 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054709 | 1054709 | 2021-02-22 | Allegany | Maryland | 24001 | 6394 | 197 |
1054710 | 1054710 | 2021-02-22 | Anne Arundel | Maryland | 24003 | 35180 | 522 |
1054711 | 1054711 | 2021-02-22 | Baltimore | Maryland | 24005 | 50166 | 1251 |
1054712 | 1054712 | 2021-02-22 | Baltimore city | Maryland | 24510 | 39920 | 867 |
1054713 | 1054713 | 2021-02-22 | Calvert | Maryland | 24009 | 3621 | 67 |
1054714 | 1054714 | 2021-02-22 | Caroline | Maryland | 24011 | 2021 | 18 |
1054715 | 1054715 | 2021-02-22 | Carroll | Maryland | 24013 | 7452 | 208 |
1054716 | 1054716 | 2021-02-22 | Cecil | Maryland | 24015 | 4976 | 117 |
1054717 | 1054717 | 2021-02-22 | Charles | Maryland | 24017 | 8753 | 153 |
1054718 | 1054718 | 2021-02-22 | Dorchester | Maryland | 24019 | 2307 | 43 |
1054719 | 1054719 | 2021-02-22 | Frederick | Maryland | 24021 | 16724 | 267 |
1054720 | 1054720 | 2021-02-22 | Garrett | Maryland | 24023 | 1836 | 59 |
1054721 | 1054721 | 2021-02-22 | Harford | Maryland | 24025 | 12313 | 231 |
1054722 | 1054722 | 2021-02-22 | Howard | Maryland | 24027 | 15574 | 216 |
1054723 | 1054723 | 2021-02-22 | Kent | Maryland | 24029 | 1107 | 42 |
1054724 | 1054724 | 2021-02-22 | Montgomery | Maryland | 24031 | 62568 | 1398 |
1054725 | 1054725 | 2021-02-22 | Prince George's | Maryland | 24033 | 72279 | 1307 |
1054726 | 1054726 | 2021-02-22 | Queen Anne's | Maryland | 24035 | 2550 | 38 |
1054727 | 1054727 | 2021-02-22 | Somerset | Maryland | 24039 | 2365 | 30 |
1054728 | 1054728 | 2021-02-22 | St. Mary's | Maryland | 24037 | 5011 | 112 |
1054729 | 1054729 | 2021-02-22 | Talbot | Maryland | 24041 | 1851 | 31 |
1054730 | 1054730 | 2021-02-22 | Unknown | Maryland | 0 | 78 | |
1054731 | 1054731 | 2021-02-22 | Washington | Maryland | 24043 | 12252 | 248 |
1054732 | 1054732 | 2021-02-22 | Wicomico | Maryland | 24045 | 6698 | 141 |
1054733 | 1054733 | 2021-02-22 | Worcester | Maryland | 24047 | 3230 | 91 |
1051462 | 1051462 | 2021-02-21 | Allegany | Maryland | 24001 | 6392 | 197 |
1051463 | 1051463 | 2021-02-21 | Anne Arundel | Maryland | 24003 | 35108 | 521 |
1051464 | 1051464 | 2021-02-21 | Baltimore | Maryland | 24005 | 50097 | 1248 |
1051465 | 1051465 | 2021-02-21 | Baltimore city | Maryland | 24510 | 39860 | 867 |
1051466 | 1051466 | 2021-02-21 | Calvert | Maryland | 24009 | 3614 | 67 |
1051467 | 1051467 | 2021-02-21 | Caroline | Maryland | 24011 | 2017 | 18 |
1051468 | 1051468 | 2021-02-21 | Carroll | Maryland | 24013 | 7439 | 208 |
1051469 | 1051469 | 2021-02-21 | Cecil | Maryland | 24015 | 4974 | 117 |
1051470 | 1051470 | 2021-02-21 | Charles | Maryland | 24017 | 8735 | 153 |
1051471 | 1051471 | 2021-02-21 | Dorchester | Maryland | 24019 | 2302 | 43 |
1051472 | 1051472 | 2021-02-21 | Frederick | Maryland | 24021 | 16700 | 267 |
1051473 | 1051473 | 2021-02-21 | Garrett | Maryland | 24023 | 1834 | 59 |
1051474 | 1051474 | 2021-02-21 | Harford | Maryland | 24025 | 12289 | 231 |
1051475 | 1051475 | 2021-02-21 | Howard | Maryland | 24027 | 15525 | 216 |
1051476 | 1051476 | 2021-02-21 | Kent | Maryland | 24029 | 1107 | 42 |
1051477 | 1051477 | 2021-02-21 | Montgomery | Maryland | 24031 | 62481 | 1396 |
1051478 | 1051478 | 2021-02-21 | Prince George's | Maryland | 24033 | 72151 | 1305 |
1051479 | 1051479 | 2021-02-21 | Queen Anne's | Maryland | 24035 | 2547 | 38 |
1051480 | 1051480 | 2021-02-21 | Somerset | Maryland | 24039 | 2365 | 30 |
1051481 | 1051481 | 2021-02-21 | St. Mary's | Maryland | 24037 | 5001 | 112 |
1051482 | 1051482 | 2021-02-21 | Talbot | Maryland | 24041 | 1847 | 31 |
1051483 | 1051483 | 2021-02-21 | Unknown | Maryland | 0 | 69 | |
1051484 | 1051484 | 2021-02-21 | Washington | Maryland | 24043 | 12235 | 248 |
1051485 | 1051485 | 2021-02-21 | Wicomico | Maryland | 24045 | 6689 | 141 |
1051486 | 1051486 | 2021-02-21 | Worcester | Maryland | 24047 | 3228 | 91 |
1048215 | 1048215 | 2021-02-20 | Allegany | Maryland | 24001 | 6383 | 197 |
1048216 | 1048216 | 2021-02-20 | Anne Arundel | Maryland | 24003 | 35054 | 521 |
1048217 | 1048217 | 2021-02-20 | Baltimore | Maryland | 24005 | 50011 | 1247 |
1048218 | 1048218 | 2021-02-20 | Baltimore city | Maryland | 24510 | 39806 | 867 |
1048219 | 1048219 | 2021-02-20 | Calvert | Maryland | 24009 | 3612 | 67 |
1048220 | 1048220 | 2021-02-20 | Caroline | Maryland | 24011 | 2016 | 18 |
1048221 | 1048221 | 2021-02-20 | Carroll | Maryland | 24013 | 7428 | 208 |
1048222 | 1048222 | 2021-02-20 | Cecil | Maryland | 24015 | 4973 | 117 |
1048223 | 1048223 | 2021-02-20 | Charles | Maryland | 24017 | 8716 | 153 |
1048224 | 1048224 | 2021-02-20 | Dorchester | Maryland | 24019 | 2288 | 43 |
1048225 | 1048225 | 2021-02-20 | Frederick | Maryland | 24021 | 16668 | 266 |
1048226 | 1048226 | 2021-02-20 | Garrett | Maryland | 24023 | 1834 | 59 |
1048227 | 1048227 | 2021-02-20 | Harford | Maryland | 24025 | 12266 | 231 |
1048228 | 1048228 | 2021-02-20 | Howard | Maryland | 24027 | 15511 | 216 |
1048229 | 1048229 | 2021-02-20 | Kent | Maryland | 24029 | 1106 | 42 |
1048230 | 1048230 | 2021-02-20 | Montgomery | Maryland | 24031 | 62381 | 1395 |
1048231 | 1048231 | 2021-02-20 | Prince George's | Maryland | 24033 | 72022 | 1303 |
1048232 | 1048232 | 2021-02-20 | Queen Anne's | Maryland | 24035 | 2536 | 38 |
1048233 | 1048233 | 2021-02-20 | Somerset | Maryland | 24039 | 2362 | 30 |
1048234 | 1048234 | 2021-02-20 | St. Mary's | Maryland | 24037 | 4984 | 112 |
1048235 | 1048235 | 2021-02-20 | Talbot | Maryland | 24041 | 1844 | 31 |
1048236 | 1048236 | 2021-02-20 | Unknown | Maryland | 0 | 56 | |
1048237 | 1048237 | 2021-02-20 | Washington | Maryland | 24043 | 12206 | 248 |
1048238 | 1048238 | 2021-02-20 | Wicomico | Maryland | 24045 | 6685 | 141 |
1048239 | 1048239 | 2021-02-20 | Worcester | Maryland | 24047 | 3227 | 91 |
1044969 | 1044969 | 2021-02-19 | Allegany | Maryland | 24001 | 6383 | 196 |
1044970 | 1044970 | 2021-02-19 | Anne Arundel | Maryland | 24003 | 34978 | 518 |
1044971 | 1044971 | 2021-02-19 | Baltimore | Maryland | 24005 | 49931 | 1243 |
1044972 | 1044972 | 2021-02-19 | Baltimore city | Maryland | 24510 | 39722 | 867 |
1044973 | 1044973 | 2021-02-19 | Calvert | Maryland | 24009 | 3603 | 66 |
1044974 | 1044974 | 2021-02-19 | Caroline | Maryland | 24011 | 2013 | 18 |
1044975 | 1044975 | 2021-02-19 | Carroll | Maryland | 24013 | 7411 | 208 |
1044976 | 1044976 | 2021-02-19 | Cecil | Maryland | 24015 | 4973 | 116 |
1044977 | 1044977 | 2021-02-19 | Charles | Maryland | 24017 | 8688 | 153 |
1044978 | 1044978 | 2021-02-19 | Dorchester | Maryland | 24019 | 2282 | 43 |
1044979 | 1044979 | 2021-02-19 | Frederick | Maryland | 24021 | 16638 | 265 |
1044980 | 1044980 | 2021-02-19 | Garrett | Maryland | 24023 | 1834 | 59 |
1044981 | 1044981 | 2021-02-19 | Harford | Maryland | 24025 | 12216 | 231 |
1044982 | 1044982 | 2021-02-19 | Howard | Maryland | 24027 | 15467 | 216 |
1044983 | 1044983 | 2021-02-19 | Kent | Maryland | 24029 | 1105 | 41 |
1044984 | 1044984 | 2021-02-19 | Montgomery | Maryland | 24031 | 62279 | 1395 |
1044985 | 1044985 | 2021-02-19 | Prince George's | Maryland | 24033 | 71846 | 1303 |
1044986 | 1044986 | 2021-02-19 | Queen Anne's | Maryland | 24035 | 2530 | 38 |
1044987 | 1044987 | 2021-02-19 | Somerset | Maryland | 24039 | 2361 | 30 |
1044988 | 1044988 | 2021-02-19 | St. Mary's | Maryland | 24037 | 4979 | 112 |
1044989 | 1044989 | 2021-02-19 | Talbot | Maryland | 24041 | 1832 | 31 |
1044990 | 1044990 | 2021-02-19 | Unknown | Maryland | 0 | 49 | |
1044991 | 1044991 | 2021-02-19 | Washington | Maryland | 24043 | 12192 | 247 |
1044992 | 1044992 | 2021-02-19 | Wicomico | Maryland | 24045 | 6672 | 141 |
1044993 | 1044993 | 2021-02-19 | Worcester | Maryland | 24047 | 3221 | 91 |
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);