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 county
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 |
---|---|---|---|---|---|---|---|
27011 | 27011 | 2020-04-02 | Allegany | Maryland | 24001 | 1 | 0 |
29330 | 29330 | 2020-04-03 | Allegany | Maryland | 24001 | 2 | 0 |
31708 | 31708 | 2020-04-04 | Allegany | Maryland | 24001 | 3 | 0 |
34133 | 34133 | 2020-04-05 | Allegany | Maryland | 24001 | 6 | 0 |
36592 | 36592 | 2020-04-06 | Allegany | Maryland | 24001 | 6 | 0 |
39100 | 39100 | 2020-04-07 | Allegany | Maryland | 24001 | 7 | 0 |
41652 | 41652 | 2020-04-08 | Allegany | Maryland | 24001 | 6 | 0 |
44228 | 44228 | 2020-04-09 | Allegany | Maryland | 24001 | 8 | 0 |
46836 | 46836 | 2020-04-10 | Allegany | Maryland | 24001 | 10 | 0 |
49478 | 49478 | 2020-04-11 | Allegany | Maryland | 24001 | 11 | 0 |
52148 | 52148 | 2020-04-12 | Allegany | Maryland | 24001 | 13 | 0 |
54829 | 54829 | 2020-04-13 | Allegany | Maryland | 24001 | 15 | 0 |
57527 | 57527 | 2020-04-14 | Allegany | Maryland | 24001 | 17 | 0 |
60235 | 60235 | 2020-04-15 | Allegany | Maryland | 24001 | 17 | 1 |
62956 | 62956 | 2020-04-16 | Allegany | Maryland | 24001 | 20 | 1 |
65694 | 65694 | 2020-04-17 | Allegany | Maryland | 24001 | 26 | 1 |
68444 | 68444 | 2020-04-18 | Allegany | Maryland | 24001 | 33 | 1 |
71208 | 71208 | 2020-04-19 | Allegany | Maryland | 24001 | 33 | 1 |
73980 | 73980 | 2020-04-20 | Allegany | Maryland | 24001 | 32 | 1 |
76760 | 76760 | 2020-04-21 | Allegany | Maryland | 24001 | 56 | 2 |
79546 | 79546 | 2020-04-22 | Allegany | Maryland | 24001 | 58 | 3 |
82341 | 82341 | 2020-04-23 | Allegany | Maryland | 24001 | 77 | 3 |
85145 | 85145 | 2020-04-24 | Allegany | Maryland | 24001 | 90 | 3 |
87955 | 87955 | 2020-04-25 | Allegany | Maryland | 24001 | 105 | 3 |
90771 | 90771 | 2020-04-26 | Allegany | Maryland | 24001 | 113 | 3 |
93592 | 93592 | 2020-04-27 | Allegany | Maryland | 24001 | 114 | 4 |
96427 | 96427 | 2020-04-28 | Allegany | Maryland | 24001 | 115 | 5 |
99273 | 99273 | 2020-04-29 | Allegany | Maryland | 24001 | 116 | 6 |
102125 | 102125 | 2020-04-30 | Allegany | Maryland | 24001 | 118 | 7 |
104985 | 104985 | 2020-05-01 | Allegany | Maryland | 24001 | 118 | 7 |
107849 | 107849 | 2020-05-02 | Allegany | Maryland | 24001 | 121 | 8 |
110721 | 110721 | 2020-05-03 | Allegany | Maryland | 24001 | 124 | 12 |
113599 | 113599 | 2020-05-04 | Allegany | Maryland | 24001 | 126 | 12 |
116480 | 116480 | 2020-05-05 | Allegany | Maryland | 24001 | 129 | 12 |
119441 | 119441 | 2020-05-06 | Allegany | Maryland | 24001 | 129 | 12 |
122413 | 122413 | 2020-05-07 | Allegany | Maryland | 24001 | 143 | 12 |
125395 | 125395 | 2020-05-08 | Allegany | Maryland | 24001 | 143 | 12 |
128382 | 128382 | 2020-05-09 | Allegany | Maryland | 24001 | 144 | 12 |
131372 | 131372 | 2020-05-10 | Allegany | Maryland | 24001 | 146 | 12 |
134363 | 134363 | 2020-05-11 | Allegany | Maryland | 24001 | 146 | 12 |
137353 | 137353 | 2020-05-12 | Allegany | Maryland | 24001 | 148 | 13 |
140347 | 140347 | 2020-05-13 | Allegany | Maryland | 24001 | 149 | 13 |
143342 | 143342 | 2020-05-14 | Allegany | Maryland | 24001 | 150 | 13 |
146342 | 146342 | 2020-05-15 | Allegany | Maryland | 24001 | 151 | 13 |
149347 | 149347 | 2020-05-16 | Allegany | Maryland | 24001 | 160 | 13 |
152358 | 152358 | 2020-05-17 | Allegany | Maryland | 24001 | 161 | 13 |
155372 | 155372 | 2020-05-18 | Allegany | Maryland | 24001 | 164 | 14 |
158390 | 158390 | 2020-05-19 | Allegany | Maryland | 24001 | 166 | 14 |
161416 | 161416 | 2020-05-20 | Allegany | Maryland | 24001 | 166 | 14 |
164445 | 164445 | 2020-05-21 | Allegany | Maryland | 24001 | 166 | 14 |
167481 | 167481 | 2020-05-22 | Allegany | Maryland | 24001 | 168 | 14 |
170518 | 170518 | 2020-05-23 | Allegany | Maryland | 24001 | 168 | 14 |
173560 | 173560 | 2020-05-24 | Allegany | Maryland | 24001 | 170 | 14 |
176603 | 176603 | 2020-05-25 | Allegany | Maryland | 24001 | 176 | 14 |
179647 | 179647 | 2020-05-26 | Allegany | Maryland | 24001 | 176 | 14 |
182693 | 182693 | 2020-05-27 | Allegany | Maryland | 24001 | 177 | 15 |
185748 | 185748 | 2020-05-28 | Allegany | Maryland | 24001 | 178 | 15 |
188806 | 188806 | 2020-05-29 | Allegany | Maryland | 24001 | 177 | 16 |
191870 | 191870 | 2020-05-30 | Allegany | Maryland | 24001 | 177 | 16 |
194938 | 194938 | 2020-05-31 | Allegany | Maryland | 24001 | 178 | 17 |
198009 | 198009 | 2020-06-01 | Allegany | Maryland | 24001 | 180 | 17 |
201081 | 201081 | 2020-06-02 | Allegany | Maryland | 24001 | 181 | 17 |
204158 | 204158 | 2020-06-03 | Allegany | Maryland | 24001 | 182 | 17 |
207239 | 207239 | 2020-06-04 | Allegany | Maryland | 24001 | 182 | 16 |
210320 | 210320 | 2020-06-05 | Allegany | Maryland | 24001 | 183 | 16 |
213404 | 213404 | 2020-06-06 | Allegany | Maryland | 24001 | 184 | 16 |
216492 | 216492 | 2020-06-07 | Allegany | Maryland | 24001 | 184 | 16 |
219584 | 219584 | 2020-06-08 | Allegany | Maryland | 24001 | 185 | 16 |
222679 | 222679 | 2020-06-09 | Allegany | Maryland | 24001 | 186 | 17 |
225775 | 225775 | 2020-06-10 | Allegany | Maryland | 24001 | 185 | 17 |
228877 | 228877 | 2020-06-11 | Allegany | Maryland | 24001 | 185 | 17 |
231981 | 231981 | 2020-06-12 | Allegany | Maryland | 24001 | 187 | 17 |
235086 | 235086 | 2020-06-13 | Allegany | Maryland | 24001 | 187 | 17 |
238193 | 238193 | 2020-06-14 | Allegany | Maryland | 24001 | 187 | 17 |
241302 | 241302 | 2020-06-15 | Allegany | Maryland | 24001 | 187 | 17 |
244413 | 244413 | 2020-06-16 | Allegany | Maryland | 24001 | 188 | 17 |
247526 | 247526 | 2020-06-17 | Allegany | Maryland | 24001 | 188 | 17 |
250638 | 250638 | 2020-06-18 | Allegany | Maryland | 24001 | 187 | 17 |
253753 | 253753 | 2020-06-19 | Allegany | Maryland | 24001 | 187 | 17 |
256873 | 256873 | 2020-06-20 | Allegany | Maryland | 24001 | 188 | 17 |
259999 | 259999 | 2020-06-21 | Allegany | Maryland | 24001 | 188 | 17 |
263128 | 263128 | 2020-06-22 | Allegany | Maryland | 24001 | 189 | 17 |
266254 | 266254 | 2020-06-23 | Allegany | Maryland | 24001 | 192 | 17 |
269387 | 269387 | 2020-06-24 | Allegany | Maryland | 24001 | 194 | 17 |
272524 | 272524 | 2020-06-25 | Allegany | Maryland | 24001 | 203 | 17 |
275667 | 275667 | 2020-06-26 | Allegany | Maryland | 24001 | 204 | 17 |
278815 | 278815 | 2020-06-27 | Allegany | Maryland | 24001 | 204 | 17 |
281963 | 281963 | 2020-06-28 | Allegany | Maryland | 24001 | 204 | 17 |
285108 | 285108 | 2020-06-29 | Allegany | Maryland | 24001 | 204 | 17 |
288258 | 288258 | 2020-06-30 | Allegany | Maryland | 24001 | 205 | 17 |
291409 | 291409 | 2020-07-01 | Allegany | Maryland | 24001 | 205 | 17 |
294563 | 294563 | 2020-07-02 | Allegany | Maryland | 24001 | 205 | 17 |
297721 | 297721 | 2020-07-03 | Allegany | Maryland | 24001 | 206 | 17 |
300883 | 300883 | 2020-07-04 | Allegany | Maryland | 24001 | 208 | 17 |
304047 | 304047 | 2020-07-05 | Allegany | Maryland | 24001 | 210 | 18 |
307214 | 307214 | 2020-07-06 | Allegany | Maryland | 24001 | 210 | 18 |
310382 | 310382 | 2020-07-07 | Allegany | Maryland | 24001 | 210 | 18 |
313552 | 313552 | 2020-07-08 | Allegany | Maryland | 24001 | 212 | 18 |
316726 | 316726 | 2020-07-09 | Allegany | Maryland | 24001 | 212 | 18 |
319901 | 319901 | 2020-07-10 | Allegany | Maryland | 24001 | 213 | 18 |
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);