ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where deaths = 2 and state = "Maryland" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 19
county 19
- Dorchester 34
- Caroline 13
- Somerset 8
- Baltimore city 6
- Queen Anne's 6
- Calvert 5
- Cecil 4
- Charles 4
- Frederick 4
- Howard 4
- Prince George's 4
- Talbot 3
- St. Mary's 2
- Wicomico 2
- Worcester 2
- Allegany 1
- Carroll 1
- Garrett 1
- Kent 1
state 1
- Maryland · 105 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
746400 | 746400 | 2020-11-19 | Garrett | Maryland | 24023 | 408 | 2 |
263133 | 263133 | 2020-06-22 | Caroline | Maryland | 24011 | 294 | 2 |
260004 | 260004 | 2020-06-21 | Caroline | Maryland | 24011 | 294 | 2 |
256878 | 256878 | 2020-06-20 | Caroline | Maryland | 24011 | 290 | 2 |
253758 | 253758 | 2020-06-19 | Caroline | Maryland | 24011 | 288 | 2 |
250643 | 250643 | 2020-06-18 | Caroline | Maryland | 24011 | 285 | 2 |
247531 | 247531 | 2020-06-17 | Caroline | Maryland | 24011 | 284 | 2 |
244418 | 244418 | 2020-06-16 | Caroline | Maryland | 24011 | 284 | 2 |
241307 | 241307 | 2020-06-15 | Caroline | Maryland | 24011 | 283 | 2 |
238198 | 238198 | 2020-06-14 | Caroline | Maryland | 24011 | 283 | 2 |
235091 | 235091 | 2020-06-13 | Caroline | Maryland | 24011 | 282 | 2 |
231986 | 231986 | 2020-06-12 | Caroline | Maryland | 24011 | 279 | 2 |
228882 | 228882 | 2020-06-11 | Caroline | Maryland | 24011 | 278 | 2 |
225780 | 225780 | 2020-06-10 | Caroline | Maryland | 24011 | 276 | 2 |
198027 | 198027 | 2020-06-01 | Somerset | Maryland | 24039 | 73 | 2 |
198029 | 198029 | 2020-06-01 | Talbot | Maryland | 24041 | 101 | 2 |
194956 | 194956 | 2020-05-31 | Somerset | Maryland | 24039 | 73 | 2 |
194958 | 194958 | 2020-05-31 | Talbot | Maryland | 24041 | 99 | 2 |
191888 | 191888 | 2020-05-30 | Somerset | Maryland | 24039 | 73 | 2 |
191890 | 191890 | 2020-05-30 | Talbot | Maryland | 24041 | 96 | 2 |
188824 | 188824 | 2020-05-29 | Somerset | Maryland | 24039 | 73 | 2 |
185766 | 185766 | 2020-05-28 | Somerset | Maryland | 24039 | 73 | 2 |
182711 | 182711 | 2020-05-27 | Somerset | Maryland | 24039 | 73 | 2 |
179656 | 179656 | 2020-05-26 | Dorchester | Maryland | 24019 | 130 | 2 |
179665 | 179665 | 2020-05-26 | Somerset | Maryland | 24039 | 73 | 2 |
176612 | 176612 | 2020-05-25 | Dorchester | Maryland | 24019 | 128 | 2 |
176621 | 176621 | 2020-05-25 | Somerset | Maryland | 24039 | 72 | 2 |
173569 | 173569 | 2020-05-24 | Dorchester | Maryland | 24019 | 127 | 2 |
170527 | 170527 | 2020-05-23 | Dorchester | Maryland | 24019 | 126 | 2 |
167490 | 167490 | 2020-05-22 | Dorchester | Maryland | 24019 | 126 | 2 |
164454 | 164454 | 2020-05-21 | Dorchester | Maryland | 24019 | 124 | 2 |
161425 | 161425 | 2020-05-20 | Dorchester | Maryland | 24019 | 122 | 2 |
158399 | 158399 | 2020-05-19 | Dorchester | Maryland | 24019 | 122 | 2 |
155381 | 155381 | 2020-05-18 | Dorchester | Maryland | 24019 | 122 | 2 |
152367 | 152367 | 2020-05-17 | Dorchester | Maryland | 24019 | 111 | 2 |
149356 | 149356 | 2020-05-16 | Dorchester | Maryland | 24019 | 111 | 2 |
146351 | 146351 | 2020-05-15 | Dorchester | Maryland | 24019 | 107 | 2 |
143351 | 143351 | 2020-05-14 | Dorchester | Maryland | 24019 | 104 | 2 |
140356 | 140356 | 2020-05-13 | Dorchester | Maryland | 24019 | 102 | 2 |
137362 | 137362 | 2020-05-12 | Dorchester | Maryland | 24019 | 102 | 2 |
134372 | 134372 | 2020-05-11 | Dorchester | Maryland | 24019 | 98 | 2 |
131381 | 131381 | 2020-05-10 | Dorchester | Maryland | 24019 | 95 | 2 |
128391 | 128391 | 2020-05-09 | Dorchester | Maryland | 24019 | 91 | 2 |
125404 | 125404 | 2020-05-08 | Dorchester | Maryland | 24019 | 86 | 2 |
122422 | 122422 | 2020-05-07 | Dorchester | Maryland | 24019 | 85 | 2 |
119450 | 119450 | 2020-05-06 | Dorchester | Maryland | 24019 | 79 | 2 |
116489 | 116489 | 2020-05-05 | Dorchester | Maryland | 24019 | 76 | 2 |
113608 | 113608 | 2020-05-04 | Dorchester | Maryland | 24019 | 75 | 2 |
110730 | 110730 | 2020-05-03 | Dorchester | Maryland | 24019 | 71 | 2 |
107858 | 107858 | 2020-05-02 | Dorchester | Maryland | 24019 | 59 | 2 |
104994 | 104994 | 2020-05-01 | Dorchester | Maryland | 24019 | 54 | 2 |
102134 | 102134 | 2020-04-30 | Dorchester | Maryland | 24019 | 51 | 2 |
102149 | 102149 | 2020-04-30 | Worcester | Maryland | 24047 | 61 | 2 |
99282 | 99282 | 2020-04-29 | Dorchester | Maryland | 24019 | 51 | 2 |
99297 | 99297 | 2020-04-29 | Worcester | Maryland | 24047 | 55 | 2 |
96436 | 96436 | 2020-04-28 | Dorchester | Maryland | 24019 | 52 | 2 |
93601 | 93601 | 2020-04-27 | Dorchester | Maryland | 24019 | 51 | 2 |
90780 | 90780 | 2020-04-26 | Dorchester | Maryland | 24019 | 46 | 2 |
87964 | 87964 | 2020-04-25 | Dorchester | Maryland | 24019 | 38 | 2 |
85154 | 85154 | 2020-04-24 | Dorchester | Maryland | 24019 | 32 | 2 |
85159 | 85159 | 2020-04-24 | Kent | Maryland | 24029 | 67 | 2 |
82350 | 82350 | 2020-04-23 | Dorchester | Maryland | 24019 | 31 | 2 |
82358 | 82358 | 2020-04-23 | Queen Anne's | Maryland | 24035 | 33 | 2 |
79563 | 79563 | 2020-04-22 | Queen Anne's | Maryland | 24035 | 31 | 2 |
79569 | 79569 | 2020-04-22 | Wicomico | Maryland | 24045 | 183 | 2 |
76760 | 76760 | 2020-04-21 | Allegany | Maryland | 24001 | 56 | 2 |
76777 | 76777 | 2020-04-21 | Queen Anne's | Maryland | 24035 | 27 | 2 |
76783 | 76783 | 2020-04-21 | Wicomico | Maryland | 24045 | 176 | 2 |
73997 | 73997 | 2020-04-20 | Queen Anne's | Maryland | 24035 | 26 | 2 |
73999 | 73999 | 2020-04-20 | St. Mary's | Maryland | 24037 | 107 | 2 |
71225 | 71225 | 2020-04-19 | Queen Anne's | Maryland | 24035 | 25 | 2 |
71227 | 71227 | 2020-04-19 | St. Mary's | Maryland | 24037 | 105 | 2 |
68448 | 68448 | 2020-04-18 | Calvert | Maryland | 24009 | 109 | 2 |
68461 | 68461 | 2020-04-18 | Queen Anne's | Maryland | 24035 | 24 | 2 |
65698 | 65698 | 2020-04-17 | Calvert | Maryland | 24009 | 109 | 2 |
65701 | 65701 | 2020-04-17 | Cecil | Maryland | 24015 | 127 | 2 |
62963 | 62963 | 2020-04-16 | Cecil | Maryland | 24015 | 101 | 2 |
60242 | 60242 | 2020-04-15 | Cecil | Maryland | 24015 | 90 | 2 |
57534 | 57534 | 2020-04-14 | Cecil | Maryland | 24015 | 85 | 2 |
46840 | 46840 | 2020-04-10 | Calvert | Maryland | 24009 | 76 | 2 |
44232 | 44232 | 2020-04-09 | Calvert | Maryland | 24009 | 66 | 2 |
41656 | 41656 | 2020-04-08 | Calvert | Maryland | 24009 | 56 | 2 |
41660 | 41660 | 2020-04-08 | Charles | Maryland | 24017 | 164 | 2 |
39108 | 39108 | 2020-04-07 | Charles | Maryland | 24017 | 136 | 2 |
36600 | 36600 | 2020-04-06 | Charles | Maryland | 24017 | 129 | 2 |
34141 | 34141 | 2020-04-05 | Charles | Maryland | 24017 | 111 | 2 |
31718 | 31718 | 2020-04-04 | Frederick | Maryland | 24021 | 73 | 2 |
29340 | 29340 | 2020-04-03 | Frederick | Maryland | 24021 | 54 | 2 |
29343 | 29343 | 2020-04-03 | Howard | Maryland | 24027 | 166 | 2 |
27014 | 27014 | 2020-04-02 | Baltimore city | Maryland | 24510 | 265 | 2 |
27021 | 27021 | 2020-04-02 | Frederick | Maryland | 24021 | 45 | 2 |
27024 | 27024 | 2020-04-02 | Howard | Maryland | 24027 | 152 | 2 |
24762 | 24762 | 2020-04-01 | Baltimore city | Maryland | 24510 | 187 | 2 |
24769 | 24769 | 2020-04-01 | Frederick | Maryland | 24021 | 35 | 2 |
24772 | 24772 | 2020-04-01 | Howard | Maryland | 24027 | 142 | 2 |
22585 | 22585 | 2020-03-31 | Baltimore city | Maryland | 24510 | 187 | 2 |
22588 | 22588 | 2020-03-31 | Carroll | Maryland | 24013 | 94 | 2 |
22594 | 22594 | 2020-03-31 | Howard | Maryland | 24027 | 117 | 2 |
20476 | 20476 | 2020-03-30 | Baltimore city | Maryland | 24510 | 152 | 2 |
18460 | 18460 | 2020-03-29 | Baltimore city | Maryland | 24510 | 129 | 2 |
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);