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)
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 |
---|---|---|---|---|---|---|---|
556 | 556 | 2020-03-05 | Montgomery | Maryland | 24031 | 3 | 0 |
616 | 616 | 2020-03-06 | Montgomery | Maryland | 24031 | 3 | 0 |
701 | 701 | 2020-03-07 | Montgomery | Maryland | 24031 | 3 | 0 |
802 | 802 | 2020-03-08 | Harford | Maryland | 24025 | 1 | 0 |
803 | 803 | 2020-03-08 | Montgomery | Maryland | 24031 | 4 | 0 |
925 | 925 | 2020-03-09 | Harford | Maryland | 24025 | 1 | 0 |
926 | 926 | 2020-03-09 | Montgomery | Maryland | 24031 | 4 | 0 |
927 | 927 | 2020-03-09 | Prince George's | Maryland | 24033 | 1 | 0 |
1071 | 1071 | 2020-03-10 | Harford | Maryland | 24025 | 1 | 0 |
1072 | 1072 | 2020-03-10 | Montgomery | Maryland | 24031 | 5 | 0 |
1073 | 1073 | 2020-03-10 | Prince George's | Maryland | 24033 | 3 | 0 |
1250 | 1250 | 2020-03-11 | Baltimore | Maryland | 24005 | 1 | 0 |
1251 | 1251 | 2020-03-11 | Harford | Maryland | 24025 | 1 | 0 |
1252 | 1252 | 2020-03-11 | Montgomery | Maryland | 24031 | 6 | 0 |
1253 | 1253 | 2020-03-11 | Prince George's | Maryland | 24033 | 5 | 0 |
1468 | 1468 | 2020-03-12 | Baltimore | Maryland | 24005 | 1 | 0 |
1469 | 1469 | 2020-03-12 | Harford | Maryland | 24025 | 1 | 0 |
1470 | 1470 | 2020-03-12 | Montgomery | Maryland | 24031 | 6 | 0 |
1471 | 1471 | 2020-03-12 | Prince George's | Maryland | 24033 | 5 | 0 |
1745 | 1745 | 2020-03-13 | Anne Arundel | Maryland | 24003 | 1 | 0 |
1746 | 1746 | 2020-03-13 | Baltimore | Maryland | 24005 | 2 | 0 |
1747 | 1747 | 2020-03-13 | Charles | Maryland | 24017 | 1 | 0 |
1748 | 1748 | 2020-03-13 | Harford | Maryland | 24025 | 1 | 0 |
1749 | 1749 | 2020-03-13 | Montgomery | Maryland | 24031 | 6 | 0 |
1750 | 1750 | 2020-03-13 | Prince George's | Maryland | 24033 | 7 | 0 |
2085 | 2085 | 2020-03-14 | Anne Arundel | Maryland | 24003 | 1 | 0 |
2086 | 2086 | 2020-03-14 | Baltimore | Maryland | 24005 | 3 | 0 |
2087 | 2087 | 2020-03-14 | Carroll | Maryland | 24013 | 1 | 0 |
2088 | 2088 | 2020-03-14 | Charles | Maryland | 24017 | 1 | 0 |
2089 | 2089 | 2020-03-14 | Harford | Maryland | 24025 | 2 | 0 |
2090 | 2090 | 2020-03-14 | Montgomery | Maryland | 24031 | 12 | 0 |
2091 | 2091 | 2020-03-14 | Prince George's | Maryland | 24033 | 7 | 0 |
2484 | 2484 | 2020-03-15 | Anne Arundel | Maryland | 24003 | 2 | 0 |
2485 | 2485 | 2020-03-15 | Baltimore | Maryland | 24005 | 3 | 0 |
2486 | 2486 | 2020-03-15 | Baltimore city | Maryland | 24510 | 1 | 0 |
2487 | 2487 | 2020-03-15 | Carroll | Maryland | 24013 | 1 | 0 |
2488 | 2488 | 2020-03-15 | Charles | Maryland | 24017 | 1 | 0 |
2489 | 2489 | 2020-03-15 | Harford | Maryland | 24025 | 2 | 0 |
2490 | 2490 | 2020-03-15 | Howard | Maryland | 24027 | 1 | 0 |
2491 | 2491 | 2020-03-15 | Montgomery | Maryland | 24031 | 12 | 0 |
2492 | 2492 | 2020-03-15 | Prince George's | Maryland | 24033 | 9 | 0 |
2931 | 2931 | 2020-03-16 | Anne Arundel | Maryland | 24003 | 2 | 0 |
2932 | 2932 | 2020-03-16 | Baltimore | Maryland | 24005 | 4 | 0 |
2933 | 2933 | 2020-03-16 | Baltimore city | Maryland | 24510 | 1 | 0 |
2934 | 2934 | 2020-03-16 | Carroll | Maryland | 24013 | 1 | 0 |
2935 | 2935 | 2020-03-16 | Charles | Maryland | 24017 | 1 | 0 |
2936 | 2936 | 2020-03-16 | Frederick | Maryland | 24021 | 1 | 0 |
2937 | 2937 | 2020-03-16 | Harford | Maryland | 24025 | 2 | 0 |
2938 | 2938 | 2020-03-16 | Howard | Maryland | 24027 | 1 | 0 |
2939 | 2939 | 2020-03-16 | Montgomery | Maryland | 24031 | 15 | 0 |
2940 | 2940 | 2020-03-16 | Prince George's | Maryland | 24033 | 10 | 0 |
2941 | 2941 | 2020-03-16 | Talbot | Maryland | 24041 | 1 | 0 |
3432 | 3432 | 2020-03-17 | Anne Arundel | Maryland | 24003 | 3 | 0 |
3433 | 3433 | 2020-03-17 | Baltimore | Maryland | 24005 | 4 | 0 |
3434 | 3434 | 2020-03-17 | Baltimore city | Maryland | 24510 | 3 | 0 |
3435 | 3435 | 2020-03-17 | Carroll | Maryland | 24013 | 1 | 0 |
3436 | 3436 | 2020-03-17 | Charles | Maryland | 24017 | 1 | 0 |
3437 | 3437 | 2020-03-17 | Frederick | Maryland | 24021 | 1 | 0 |
3438 | 3438 | 2020-03-17 | Harford | Maryland | 24025 | 2 | 0 |
3439 | 3439 | 2020-03-17 | Howard | Maryland | 24027 | 3 | 0 |
3440 | 3440 | 2020-03-17 | Montgomery | Maryland | 24031 | 24 | 0 |
3441 | 3441 | 2020-03-17 | Prince George's | Maryland | 24033 | 14 | 0 |
3442 | 3442 | 2020-03-17 | Talbot | Maryland | 24041 | 1 | 0 |
4014 | 4014 | 2020-03-18 | Anne Arundel | Maryland | 24003 | 4 | 0 |
4015 | 4015 | 2020-03-18 | Baltimore | Maryland | 24005 | 7 | 0 |
4016 | 4016 | 2020-03-18 | Baltimore city | Maryland | 24510 | 7 | 0 |
4017 | 4017 | 2020-03-18 | Carroll | Maryland | 24013 | 1 | 0 |
4018 | 4018 | 2020-03-18 | Charles | Maryland | 24017 | 2 | 0 |
4019 | 4019 | 2020-03-18 | Frederick | Maryland | 24021 | 1 | 0 |
4020 | 4020 | 2020-03-18 | Harford | Maryland | 24025 | 3 | 0 |
4021 | 4021 | 2020-03-18 | Howard | Maryland | 24027 | 8 | 0 |
4022 | 4022 | 2020-03-18 | Montgomery | Maryland | 24031 | 31 | 0 |
4023 | 4023 | 2020-03-18 | Prince George's | Maryland | 24033 | 20 | 1 |
4024 | 4024 | 2020-03-18 | Talbot | Maryland | 24041 | 1 | 0 |
4716 | 4716 | 2020-03-19 | Anne Arundel | Maryland | 24003 | 5 | 0 |
4717 | 4717 | 2020-03-19 | Baltimore | Maryland | 24005 | 13 | 0 |
4718 | 4718 | 2020-03-19 | Baltimore city | Maryland | 24510 | 7 | 0 |
4719 | 4719 | 2020-03-19 | Calvert | Maryland | 24009 | 1 | 0 |
4720 | 4720 | 2020-03-19 | Carroll | Maryland | 24013 | 2 | 0 |
4721 | 4721 | 2020-03-19 | Charles | Maryland | 24017 | 2 | 0 |
4722 | 4722 | 2020-03-19 | Frederick | Maryland | 24021 | 1 | 0 |
4723 | 4723 | 2020-03-19 | Harford | Maryland | 24025 | 3 | 0 |
4724 | 4724 | 2020-03-19 | Howard | Maryland | 24027 | 16 | 0 |
4725 | 4725 | 2020-03-19 | Montgomery | Maryland | 24031 | 33 | 0 |
4726 | 4726 | 2020-03-19 | Prince George's | Maryland | 24033 | 23 | 1 |
4727 | 4727 | 2020-03-19 | Talbot | Maryland | 24041 | 1 | 0 |
4728 | 4728 | 2020-03-19 | Wicomico | Maryland | 24045 | 1 | 0 |
5534 | 5534 | 2020-03-20 | Anne Arundel | Maryland | 24003 | 10 | 0 |
5535 | 5535 | 2020-03-20 | Baltimore | Maryland | 24005 | 13 | 1 |
5536 | 5536 | 2020-03-20 | Baltimore city | Maryland | 24510 | 11 | 0 |
5537 | 5537 | 2020-03-20 | Calvert | Maryland | 24009 | 1 | 0 |
5538 | 5538 | 2020-03-20 | Carroll | Maryland | 24013 | 4 | 0 |
5539 | 5539 | 2020-03-20 | Charles | Maryland | 24017 | 2 | 0 |
5540 | 5540 | 2020-03-20 | Frederick | Maryland | 24021 | 1 | 0 |
5541 | 5541 | 2020-03-20 | Harford | Maryland | 24025 | 5 | 0 |
5542 | 5542 | 2020-03-20 | Howard | Maryland | 24027 | 18 | 0 |
5543 | 5543 | 2020-03-20 | Montgomery | Maryland | 24031 | 51 | 0 |
5544 | 5544 | 2020-03-20 | Prince George's | Maryland | 24033 | 31 | 1 |
5545 | 5545 | 2020-03-20 | Talbot | Maryland | 24041 | 1 | 0 |
5546 | 5546 | 2020-03-20 | Wicomico | Maryland | 24045 | 1 | 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);