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 398
- Harford 395
- Prince George's 394
- Baltimore 392
- Anne Arundel 390
- Charles 390
- Carroll 389
- Baltimore city 388
- Howard 388
- Frederick 387
- Talbot 387
- Calvert 384
- Wicomico 384
- Worcester 383
- Caroline 382
- Somerset 382
- Washington 382
- Cecil 381
- St. Mary's 381
- Garrett 380
- Queen Anne's 380
- Kent 378
- Dorchester 371
- Allegany 370
- Unknown 359
state 1
- Maryland · 9,595 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194311 | 1194311 | 2021-04-06 | Allegany | Maryland | 24001 | 6561 | 204 |
1194312 | 1194312 | 2021-04-06 | Anne Arundel | Maryland | 24003 | 39672 | 572 |
1194313 | 1194313 | 2021-04-06 | Baltimore | Maryland | 24005 | 57418 | 1382 |
1194314 | 1194314 | 2021-04-06 | Baltimore city | Maryland | 24510 | 45989 | 953 |
1194315 | 1194315 | 2021-04-06 | Calvert | Maryland | 24009 | 3954 | 74 |
1194316 | 1194316 | 2021-04-06 | Caroline | Maryland | 24011 | 2156 | 22 |
1194317 | 1194317 | 2021-04-06 | Carroll | Maryland | 24013 | 8474 | 221 |
1194318 | 1194318 | 2021-04-06 | Cecil | Maryland | 24015 | 5475 | 127 |
1194319 | 1194319 | 2021-04-06 | Charles | Maryland | 24017 | 9908 | 177 |
1194320 | 1194320 | 2021-04-06 | Dorchester | Maryland | 24019 | 2502 | 49 |
1194321 | 1194321 | 2021-04-06 | Frederick | Maryland | 24021 | 18488 | 302 |
1194322 | 1194322 | 2021-04-06 | Garrett | Maryland | 24023 | 1915 | 62 |
1194323 | 1194323 | 2021-04-06 | Harford | Maryland | 24025 | 14557 | 259 |
1194324 | 1194324 | 2021-04-06 | Howard | Maryland | 24027 | 17647 | 229 |
1194325 | 1194325 | 2021-04-06 | Kent | Maryland | 24029 | 1248 | 45 |
1194326 | 1194326 | 2021-04-06 | Montgomery | Maryland | 24031 | 67421 | 1484 |
1194327 | 1194327 | 2021-04-06 | Prince George's | Maryland | 24033 | 79116 | 1394 |
1194328 | 1194328 | 2021-04-06 | Queen Anne's | Maryland | 24035 | 2746 | 41 |
1194329 | 1194329 | 2021-04-06 | Somerset | Maryland | 24039 | 2485 | 37 |
1194330 | 1194330 | 2021-04-06 | St. Mary's | Maryland | 24037 | 5499 | 123 |
1194331 | 1194331 | 2021-04-06 | Talbot | Maryland | 24041 | 1976 | 36 |
1194332 | 1194332 | 2021-04-06 | Unknown | Maryland | 1 | 75 | |
1194333 | 1194333 | 2021-04-06 | Washington | Maryland | 24043 | 13447 | 264 |
1194334 | 1194334 | 2021-04-06 | Wicomico | Maryland | 24045 | 7156 | 151 |
1194335 | 1194335 | 2021-04-06 | Worcester | Maryland | 24047 | 3430 | 95 |
1191062 | 1191062 | 2021-04-05 | Allegany | Maryland | 24001 | 6560 | 204 |
1191063 | 1191063 | 2021-04-05 | Anne Arundel | Maryland | 24003 | 39592 | 571 |
1191064 | 1191064 | 2021-04-05 | Baltimore | Maryland | 24005 | 57257 | 1376 |
1191065 | 1191065 | 2021-04-05 | Baltimore city | Maryland | 24510 | 45847 | 951 |
1191066 | 1191066 | 2021-04-05 | Calvert | Maryland | 24009 | 3952 | 74 |
1191067 | 1191067 | 2021-04-05 | Caroline | Maryland | 24011 | 2151 | 22 |
1191068 | 1191068 | 2021-04-05 | Carroll | Maryland | 24013 | 8444 | 220 |
1191069 | 1191069 | 2021-04-05 | Cecil | Maryland | 24015 | 5465 | 127 |
1191070 | 1191070 | 2021-04-05 | Charles | Maryland | 24017 | 9897 | 176 |
1191071 | 1191071 | 2021-04-05 | Dorchester | Maryland | 24019 | 2501 | 49 |
1191072 | 1191072 | 2021-04-05 | Frederick | Maryland | 24021 | 18434 | 302 |
1191073 | 1191073 | 2021-04-05 | Garrett | Maryland | 24023 | 1915 | 62 |
1191074 | 1191074 | 2021-04-05 | Harford | Maryland | 24025 | 14494 | 259 |
1191075 | 1191075 | 2021-04-05 | Howard | Maryland | 24027 | 17611 | 229 |
1191076 | 1191076 | 2021-04-05 | Kent | Maryland | 24029 | 1246 | 45 |
1191077 | 1191077 | 2021-04-05 | Montgomery | Maryland | 24031 | 67349 | 1481 |
1191078 | 1191078 | 2021-04-05 | Prince George's | Maryland | 24033 | 78977 | 1394 |
1191079 | 1191079 | 2021-04-05 | Queen Anne's | Maryland | 24035 | 2740 | 41 |
1191080 | 1191080 | 2021-04-05 | Somerset | Maryland | 24039 | 2484 | 37 |
1191081 | 1191081 | 2021-04-05 | St. Mary's | Maryland | 24037 | 5485 | 123 |
1191082 | 1191082 | 2021-04-05 | Talbot | Maryland | 24041 | 1975 | 36 |
1191083 | 1191083 | 2021-04-05 | Unknown | Maryland | 1 | 75 | |
1191084 | 1191084 | 2021-04-05 | Washington | Maryland | 24043 | 13428 | 263 |
1191085 | 1191085 | 2021-04-05 | Wicomico | Maryland | 24045 | 7144 | 151 |
1191086 | 1191086 | 2021-04-05 | Worcester | Maryland | 24047 | 3425 | 95 |
1187814 | 1187814 | 2021-04-04 | Allegany | Maryland | 24001 | 6560 | 204 |
1187815 | 1187815 | 2021-04-04 | Anne Arundel | Maryland | 24003 | 39497 | 571 |
1187816 | 1187816 | 2021-04-04 | Baltimore | Maryland | 24005 | 57118 | 1376 |
1187817 | 1187817 | 2021-04-04 | Baltimore city | Maryland | 24510 | 45682 | 951 |
1187818 | 1187818 | 2021-04-04 | Calvert | Maryland | 24009 | 3945 | 74 |
1187819 | 1187819 | 2021-04-04 | Caroline | Maryland | 24011 | 2148 | 22 |
1187820 | 1187820 | 2021-04-04 | Carroll | Maryland | 24013 | 8421 | 220 |
1187821 | 1187821 | 2021-04-04 | Cecil | Maryland | 24015 | 5449 | 127 |
1187822 | 1187822 | 2021-04-04 | Charles | Maryland | 24017 | 9874 | 176 |
1187823 | 1187823 | 2021-04-04 | Dorchester | Maryland | 24019 | 2496 | 49 |
1187824 | 1187824 | 2021-04-04 | Frederick | Maryland | 24021 | 18393 | 301 |
1187825 | 1187825 | 2021-04-04 | Garrett | Maryland | 24023 | 1914 | 62 |
1187826 | 1187826 | 2021-04-04 | Harford | Maryland | 24025 | 14441 | 259 |
1187827 | 1187827 | 2021-04-04 | Howard | Maryland | 24027 | 17573 | 229 |
1187828 | 1187828 | 2021-04-04 | Kent | Maryland | 24029 | 1242 | 44 |
1187829 | 1187829 | 2021-04-04 | Montgomery | Maryland | 24031 | 67258 | 1481 |
1187830 | 1187830 | 2021-04-04 | Prince George's | Maryland | 24033 | 78869 | 1394 |
1187831 | 1187831 | 2021-04-04 | Queen Anne's | Maryland | 24035 | 2736 | 41 |
1187832 | 1187832 | 2021-04-04 | Somerset | Maryland | 24039 | 2483 | 37 |
1187833 | 1187833 | 2021-04-04 | St. Mary's | Maryland | 24037 | 5477 | 123 |
1187834 | 1187834 | 2021-04-04 | Talbot | Maryland | 24041 | 1973 | 36 |
1187835 | 1187835 | 2021-04-04 | Unknown | Maryland | 0 | 64 | |
1187836 | 1187836 | 2021-04-04 | Washington | Maryland | 24043 | 13412 | 263 |
1187837 | 1187837 | 2021-04-04 | Wicomico | Maryland | 24045 | 7135 | 151 |
1187838 | 1187838 | 2021-04-04 | Worcester | Maryland | 24047 | 3418 | 95 |
1184567 | 1184567 | 2021-04-03 | Allegany | Maryland | 24001 | 6558 | 204 |
1184568 | 1184568 | 2021-04-03 | Anne Arundel | Maryland | 24003 | 39359 | 569 |
1184569 | 1184569 | 2021-04-03 | Baltimore | Maryland | 24005 | 56770 | 1376 |
1184570 | 1184570 | 2021-04-03 | Baltimore city | Maryland | 24510 | 45340 | 950 |
1184571 | 1184571 | 2021-04-03 | Calvert | Maryland | 24009 | 3933 | 74 |
1184572 | 1184572 | 2021-04-03 | Caroline | Maryland | 24011 | 2138 | 22 |
1184573 | 1184573 | 2021-04-03 | Carroll | Maryland | 24013 | 8376 | 219 |
1184574 | 1184574 | 2021-04-03 | Cecil | Maryland | 24015 | 5425 | 127 |
1184575 | 1184575 | 2021-04-03 | Charles | Maryland | 24017 | 9828 | 176 |
1184576 | 1184576 | 2021-04-03 | Dorchester | Maryland | 24019 | 2490 | 49 |
1184577 | 1184577 | 2021-04-03 | Frederick | Maryland | 24021 | 18356 | 301 |
1184578 | 1184578 | 2021-04-03 | Garrett | Maryland | 24023 | 1911 | 62 |
1184579 | 1184579 | 2021-04-03 | Harford | Maryland | 24025 | 14334 | 258 |
1184580 | 1184580 | 2021-04-03 | Howard | Maryland | 24027 | 17476 | 229 |
1184581 | 1184581 | 2021-04-03 | Kent | Maryland | 24029 | 1234 | 44 |
1184582 | 1184582 | 2021-04-03 | Montgomery | Maryland | 24031 | 67107 | 1480 |
1184583 | 1184583 | 2021-04-03 | Prince George's | Maryland | 24033 | 78662 | 1393 |
1184584 | 1184584 | 2021-04-03 | Queen Anne's | Maryland | 24035 | 2731 | 41 |
1184585 | 1184585 | 2021-04-03 | Somerset | Maryland | 24039 | 2481 | 37 |
1184586 | 1184586 | 2021-04-03 | St. Mary's | Maryland | 24037 | 5462 | 123 |
1184587 | 1184587 | 2021-04-03 | Talbot | Maryland | 24041 | 1971 | 36 |
1184588 | 1184588 | 2021-04-03 | Unknown | Maryland | 0 | 63 | |
1184589 | 1184589 | 2021-04-03 | Washington | Maryland | 24043 | 13366 | 263 |
1184590 | 1184590 | 2021-04-03 | Wicomico | Maryland | 24045 | 7127 | 151 |
1184591 | 1184591 | 2021-04-03 | Worcester | Maryland | 24047 | 3410 | 95 |
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);