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 state
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 25
county 25
- Worcester 785
- Anne Arundel 784
- Baltimore 784
- Baltimore city 784
- Calvert 784
- Caroline 784
- Carroll 784
- Charles 784
- Frederick 784
- Harford 784
- Howard 784
- Montgomery 784
- Prince George's 784
- Somerset 784
- Talbot 784
- Washington 784
- Wicomico 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,545 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5547 | 5547 | 2020-03-20 | Worcester | Maryland | 24047 | 1 | 0 |
6490 | 6490 | 2020-03-21 | Anne Arundel | Maryland | 24003 | 16 | 0 |
6491 | 6491 | 2020-03-21 | Baltimore | Maryland | 24005 | 19 | 1 |
6492 | 6492 | 2020-03-21 | Baltimore city | Maryland | 24510 | 15 | 0 |
6493 | 6493 | 2020-03-21 | Calvert | Maryland | 24009 | 1 | 0 |
6494 | 6494 | 2020-03-21 | Caroline | Maryland | 24011 | 1 | 0 |
6495 | 6495 | 2020-03-21 | Carroll | Maryland | 24013 | 4 | 0 |
6496 | 6496 | 2020-03-21 | Charles | Maryland | 24017 | 4 | 0 |
6497 | 6497 | 2020-03-21 | Frederick | Maryland | 24021 | 1 | 0 |
6498 | 6498 | 2020-03-21 | Harford | Maryland | 24025 | 5 | 0 |
6499 | 6499 | 2020-03-21 | Howard | Maryland | 24027 | 19 | 0 |
6500 | 6500 | 2020-03-21 | Montgomery | Maryland | 24031 | 68 | 1 |
6501 | 6501 | 2020-03-21 | Prince George's | Maryland | 24033 | 36 | 1 |
6502 | 6502 | 2020-03-21 | Somerset | Maryland | 24039 | 1 | 0 |
6503 | 6503 | 2020-03-21 | Talbot | Maryland | 24041 | 1 | 0 |
6504 | 6504 | 2020-03-21 | Washington | Maryland | 24043 | 1 | 0 |
6505 | 6505 | 2020-03-21 | Wicomico | Maryland | 24045 | 2 | 0 |
6506 | 6506 | 2020-03-21 | Worcester | Maryland | 24047 | 1 | 0 |
7565 | 7565 | 2020-03-22 | Anne Arundel | Maryland | 24003 | 19 | 0 |
7566 | 7566 | 2020-03-22 | Baltimore | Maryland | 24005 | 28 | 1 |
7567 | 7567 | 2020-03-22 | Baltimore city | Maryland | 24510 | 24 | 0 |
7568 | 7568 | 2020-03-22 | Calvert | Maryland | 24009 | 2 | 0 |
7569 | 7569 | 2020-03-22 | Caroline | Maryland | 24011 | 1 | 0 |
7570 | 7570 | 2020-03-22 | Carroll | Maryland | 24013 | 4 | 0 |
7571 | 7571 | 2020-03-22 | Cecil | Maryland | 24015 | 1 | 0 |
7572 | 7572 | 2020-03-22 | Charles | Maryland | 24017 | 5 | 0 |
7573 | 7573 | 2020-03-22 | Frederick | Maryland | 24021 | 1 | 0 |
7574 | 7574 | 2020-03-22 | Harford | Maryland | 24025 | 5 | 0 |
7575 | 7575 | 2020-03-22 | Howard | Maryland | 24027 | 24 | 0 |
7576 | 7576 | 2020-03-22 | Montgomery | Maryland | 24031 | 83 | 1 |
7577 | 7577 | 2020-03-22 | Prince George's | Maryland | 24033 | 40 | 1 |
7578 | 7578 | 2020-03-22 | Somerset | Maryland | 24039 | 1 | 0 |
7579 | 7579 | 2020-03-22 | St. Mary's | Maryland | 24037 | 1 | 0 |
7580 | 7580 | 2020-03-22 | Talbot | Maryland | 24041 | 1 | 0 |
7581 | 7581 | 2020-03-22 | Washington | Maryland | 24043 | 1 | 0 |
7582 | 7582 | 2020-03-22 | Wicomico | Maryland | 24045 | 2 | 0 |
7583 | 7583 | 2020-03-22 | Worcester | Maryland | 24047 | 2 | 0 |
8735 | 8735 | 2020-03-23 | Anne Arundel | Maryland | 24003 | 20 | 0 |
8736 | 8736 | 2020-03-23 | Baltimore | Maryland | 24005 | 35 | 1 |
8737 | 8737 | 2020-03-23 | Baltimore city | Maryland | 24510 | 31 | 0 |
8738 | 8738 | 2020-03-23 | Calvert | Maryland | 24009 | 2 | 0 |
8739 | 8739 | 2020-03-23 | Caroline | Maryland | 24011 | 1 | 0 |
8740 | 8740 | 2020-03-23 | Carroll | Maryland | 24013 | 5 | 0 |
8741 | 8741 | 2020-03-23 | Cecil | Maryland | 24015 | 1 | 0 |
8742 | 8742 | 2020-03-23 | Charles | Maryland | 24017 | 5 | 0 |
8743 | 8743 | 2020-03-23 | Frederick | Maryland | 24021 | 4 | 0 |
8744 | 8744 | 2020-03-23 | Garrett | Maryland | 24023 | 3 | 0 |
8745 | 8745 | 2020-03-23 | Harford | Maryland | 24025 | 5 | 0 |
8746 | 8746 | 2020-03-23 | Howard | Maryland | 24027 | 26 | 0 |
8747 | 8747 | 2020-03-23 | Montgomery | Maryland | 24031 | 93 | 1 |
8748 | 8748 | 2020-03-23 | Prince George's | Maryland | 24033 | 47 | 1 |
8749 | 8749 | 2020-03-23 | Queen Anne's | Maryland | 24035 | 1 | 0 |
8750 | 8750 | 2020-03-23 | Somerset | Maryland | 24039 | 1 | 0 |
8751 | 8751 | 2020-03-23 | St. Mary's | Maryland | 24037 | 1 | 0 |
8752 | 8752 | 2020-03-23 | Talbot | Maryland | 24041 | 1 | 0 |
8753 | 8753 | 2020-03-23 | Washington | Maryland | 24043 | 2 | 0 |
8754 | 8754 | 2020-03-23 | Wicomico | Maryland | 24045 | 4 | 0 |
8755 | 8755 | 2020-03-23 | Worcester | Maryland | 24047 | 2 | 0 |
10024 | 10024 | 2020-03-24 | Anne Arundel | Maryland | 24003 | 24 | 0 |
10025 | 10025 | 2020-03-24 | Baltimore | Maryland | 24005 | 42 | 1 |
10026 | 10026 | 2020-03-24 | Baltimore city | Maryland | 24510 | 41 | 0 |
10027 | 10027 | 2020-03-24 | Calvert | Maryland | 24009 | 3 | 0 |
10028 | 10028 | 2020-03-24 | Caroline | Maryland | 24011 | 1 | 0 |
10029 | 10029 | 2020-03-24 | Carroll | Maryland | 24013 | 5 | 0 |
10030 | 10030 | 2020-03-24 | Cecil | Maryland | 24015 | 3 | 0 |
10031 | 10031 | 2020-03-24 | Charles | Maryland | 24017 | 5 | 0 |
10032 | 10032 | 2020-03-24 | Frederick | Maryland | 24021 | 4 | 0 |
10033 | 10033 | 2020-03-24 | Garrett | Maryland | 24023 | 3 | 0 |
10034 | 10034 | 2020-03-24 | Harford | Maryland | 24025 | 5 | 0 |
10035 | 10035 | 2020-03-24 | Howard | Maryland | 24027 | 30 | 0 |
10036 | 10036 | 2020-03-24 | Montgomery | Maryland | 24031 | 107 | 1 |
10037 | 10037 | 2020-03-24 | Prince George's | Maryland | 24033 | 63 | 2 |
10038 | 10038 | 2020-03-24 | Queen Anne's | Maryland | 24035 | 1 | 0 |
10039 | 10039 | 2020-03-24 | Somerset | Maryland | 24039 | 1 | 0 |
10040 | 10040 | 2020-03-24 | St. Mary's | Maryland | 24037 | 2 | 0 |
10041 | 10041 | 2020-03-24 | Talbot | Maryland | 24041 | 1 | 0 |
10042 | 10042 | 2020-03-24 | Washington | Maryland | 24043 | 2 | 0 |
10043 | 10043 | 2020-03-24 | Wicomico | Maryland | 24045 | 4 | 0 |
10044 | 10044 | 2020-03-24 | Worcester | Maryland | 24047 | 2 | 0 |
11434 | 11434 | 2020-03-25 | Anne Arundel | Maryland | 24003 | 31 | 0 |
11435 | 11435 | 2020-03-25 | Baltimore | Maryland | 24005 | 51 | 1 |
11436 | 11436 | 2020-03-25 | Baltimore city | Maryland | 24510 | 53 | 0 |
11437 | 11437 | 2020-03-25 | Calvert | Maryland | 24009 | 3 | 0 |
11438 | 11438 | 2020-03-25 | Caroline | Maryland | 24011 | 1 | 0 |
11439 | 11439 | 2020-03-25 | Carroll | Maryland | 24013 | 5 | 0 |
11440 | 11440 | 2020-03-25 | Cecil | Maryland | 24015 | 4 | 0 |
11441 | 11441 | 2020-03-25 | Charles | Maryland | 24017 | 8 | 0 |
11442 | 11442 | 2020-03-25 | Frederick | Maryland | 24021 | 7 | 0 |
11443 | 11443 | 2020-03-25 | Garrett | Maryland | 24023 | 3 | 0 |
11444 | 11444 | 2020-03-25 | Harford | Maryland | 24025 | 5 | 0 |
11445 | 11445 | 2020-03-25 | Howard | Maryland | 24027 | 35 | 0 |
11446 | 11446 | 2020-03-25 | Kent | Maryland | 24029 | 1 | 0 |
11447 | 11447 | 2020-03-25 | Montgomery | Maryland | 24031 | 127 | 1 |
11448 | 11448 | 2020-03-25 | Prince George's | Maryland | 24033 | 76 | 2 |
11449 | 11449 | 2020-03-25 | Queen Anne's | Maryland | 24035 | 1 | 0 |
11450 | 11450 | 2020-03-25 | Somerset | Maryland | 24039 | 1 | 0 |
11451 | 11451 | 2020-03-25 | St. Mary's | Maryland | 24037 | 2 | 0 |
11452 | 11452 | 2020-03-25 | Talbot | Maryland | 24041 | 1 | 0 |
11453 | 11453 | 2020-03-25 | Washington | Maryland | 24043 | 2 | 0 |
11454 | 11454 | 2020-03-25 | Wicomico | Maryland | 24045 | 4 | 0 |
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);