ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 24027 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490 | 2490 | 2020-03-15 | Howard | Maryland | 24027 | 1 | 0 |
2938 | 2938 | 2020-03-16 | Howard | Maryland | 24027 | 1 | 0 |
3439 | 3439 | 2020-03-17 | Howard | Maryland | 24027 | 3 | 0 |
4021 | 4021 | 2020-03-18 | Howard | Maryland | 24027 | 8 | 0 |
4724 | 4724 | 2020-03-19 | Howard | Maryland | 24027 | 16 | 0 |
5542 | 5542 | 2020-03-20 | Howard | Maryland | 24027 | 18 | 0 |
6499 | 6499 | 2020-03-21 | Howard | Maryland | 24027 | 19 | 0 |
7575 | 7575 | 2020-03-22 | Howard | Maryland | 24027 | 24 | 0 |
8746 | 8746 | 2020-03-23 | Howard | Maryland | 24027 | 26 | 0 |
10035 | 10035 | 2020-03-24 | Howard | Maryland | 24027 | 30 | 0 |
11445 | 11445 | 2020-03-25 | Howard | Maryland | 24027 | 35 | 0 |
13026 | 13026 | 2020-03-26 | Howard | Maryland | 24027 | 49 | 0 |
14734 | 14734 | 2020-03-27 | Howard | Maryland | 24027 | 62 | 0 |
16554 | 16554 | 2020-03-28 | Howard | Maryland | 24027 | 73 | 0 |
18469 | 18469 | 2020-03-29 | Howard | Maryland | 24027 | 81 | 0 |
20485 | 20485 | 2020-03-30 | Howard | Maryland | 24027 | 96 | 1 |
22594 | 22594 | 2020-03-31 | Howard | Maryland | 24027 | 117 | 2 |
24772 | 24772 | 2020-04-01 | Howard | Maryland | 24027 | 142 | 2 |
27024 | 27024 | 2020-04-02 | Howard | Maryland | 24027 | 152 | 2 |
29343 | 29343 | 2020-04-03 | Howard | Maryland | 24027 | 166 | 2 |
31721 | 31721 | 2020-04-04 | Howard | Maryland | 24027 | 180 | 3 |
34146 | 34146 | 2020-04-05 | Howard | Maryland | 24027 | 199 | 3 |
36605 | 36605 | 2020-04-06 | Howard | Maryland | 24027 | 214 | 3 |
39113 | 39113 | 2020-04-07 | Howard | Maryland | 24027 | 236 | 3 |
41665 | 41665 | 2020-04-08 | Howard | Maryland | 24027 | 274 | 3 |
44241 | 44241 | 2020-04-09 | Howard | Maryland | 24027 | 299 | 4 |
46849 | 46849 | 2020-04-10 | Howard | Maryland | 24027 | 319 | 5 |
49491 | 49491 | 2020-04-11 | Howard | Maryland | 24027 | 351 | 6 |
52161 | 52161 | 2020-04-12 | Howard | Maryland | 24027 | 371 | 6 |
54842 | 54842 | 2020-04-13 | Howard | Maryland | 24027 | 386 | 8 |
57540 | 57540 | 2020-04-14 | Howard | Maryland | 24027 | 403 | 9 |
60248 | 60248 | 2020-04-15 | Howard | Maryland | 24027 | 425 | 10 |
62969 | 62969 | 2020-04-16 | Howard | Maryland | 24027 | 452 | 11 |
65707 | 65707 | 2020-04-17 | Howard | Maryland | 24027 | 476 | 11 |
68457 | 68457 | 2020-04-18 | Howard | Maryland | 24027 | 510 | 12 |
71221 | 71221 | 2020-04-19 | Howard | Maryland | 24027 | 516 | 12 |
73993 | 73993 | 2020-04-20 | Howard | Maryland | 24027 | 539 | 13 |
76773 | 76773 | 2020-04-21 | Howard | Maryland | 24027 | 566 | 13 |
79559 | 79559 | 2020-04-22 | Howard | Maryland | 24027 | 593 | 14 |
82354 | 82354 | 2020-04-23 | Howard | Maryland | 24027 | 619 | 15 |
85158 | 85158 | 2020-04-24 | Howard | Maryland | 24027 | 643 | 15 |
87968 | 87968 | 2020-04-25 | Howard | Maryland | 24027 | 687 | 16 |
90784 | 90784 | 2020-04-26 | Howard | Maryland | 24027 | 708 | 16 |
93605 | 93605 | 2020-04-27 | Howard | Maryland | 24027 | 779 | 17 |
96440 | 96440 | 2020-04-28 | Howard | Maryland | 24027 | 803 | 18 |
99286 | 99286 | 2020-04-29 | Howard | Maryland | 24027 | 832 | 19 |
102138 | 102138 | 2020-04-30 | Howard | Maryland | 24027 | 867 | 19 |
104998 | 104998 | 2020-05-01 | Howard | Maryland | 24027 | 897 | 19 |
107862 | 107862 | 2020-05-02 | Howard | Maryland | 24027 | 932 | 20 |
110734 | 110734 | 2020-05-03 | Howard | Maryland | 24027 | 970 | 20 |
113612 | 113612 | 2020-05-04 | Howard | Maryland | 24027 | 993 | 22 |
116493 | 116493 | 2020-05-05 | Howard | Maryland | 24027 | 1011 | 23 |
119454 | 119454 | 2020-05-06 | Howard | Maryland | 24027 | 1062 | 25 |
122426 | 122426 | 2020-05-07 | Howard | Maryland | 24027 | 1099 | 27 |
125408 | 125408 | 2020-05-08 | Howard | Maryland | 24027 | 1139 | 27 |
128395 | 128395 | 2020-05-09 | Howard | Maryland | 24027 | 1171 | 29 |
131385 | 131385 | 2020-05-10 | Howard | Maryland | 24027 | 1206 | 29 |
134376 | 134376 | 2020-05-11 | Howard | Maryland | 24027 | 1224 | 31 |
137366 | 137366 | 2020-05-12 | Howard | Maryland | 24027 | 1235 | 35 |
140360 | 140360 | 2020-05-13 | Howard | Maryland | 24027 | 1260 | 38 |
143355 | 143355 | 2020-05-14 | Howard | Maryland | 24027 | 1287 | 40 |
146355 | 146355 | 2020-05-15 | Howard | Maryland | 24027 | 1315 | 40 |
149360 | 149360 | 2020-05-16 | Howard | Maryland | 24027 | 1354 | 43 |
152371 | 152371 | 2020-05-17 | Howard | Maryland | 24027 | 1380 | 43 |
155385 | 155385 | 2020-05-18 | Howard | Maryland | 24027 | 1419 | 45 |
158403 | 158403 | 2020-05-19 | Howard | Maryland | 24027 | 1468 | 49 |
161429 | 161429 | 2020-05-20 | Howard | Maryland | 24027 | 1498 | 50 |
164458 | 164458 | 2020-05-21 | Howard | Maryland | 24027 | 1552 | 49 |
167494 | 167494 | 2020-05-22 | Howard | Maryland | 24027 | 1590 | 50 |
170531 | 170531 | 2020-05-23 | Howard | Maryland | 24027 | 1642 | 52 |
173573 | 173573 | 2020-05-24 | Howard | Maryland | 24027 | 1671 | 52 |
176616 | 176616 | 2020-05-25 | Howard | Maryland | 24027 | 1720 | 52 |
179660 | 179660 | 2020-05-26 | Howard | Maryland | 24027 | 1736 | 53 |
182706 | 182706 | 2020-05-27 | Howard | Maryland | 24027 | 1764 | 54 |
185761 | 185761 | 2020-05-28 | Howard | Maryland | 24027 | 1819 | 56 |
188819 | 188819 | 2020-05-29 | Howard | Maryland | 24027 | 1872 | 58 |
191883 | 191883 | 2020-05-30 | Howard | Maryland | 24027 | 1909 | 58 |
194951 | 194951 | 2020-05-31 | Howard | Maryland | 24027 | 1932 | 58 |
198022 | 198022 | 2020-06-01 | Howard | Maryland | 24027 | 1949 | 61 |
201094 | 201094 | 2020-06-02 | Howard | Maryland | 24027 | 1980 | 61 |
204171 | 204171 | 2020-06-03 | Howard | Maryland | 24027 | 2009 | 61 |
207252 | 207252 | 2020-06-04 | Howard | Maryland | 24027 | 2038 | 65 |
210333 | 210333 | 2020-06-05 | Howard | Maryland | 24027 | 2079 | 65 |
213417 | 213417 | 2020-06-06 | Howard | Maryland | 24027 | 2099 | 65 |
216505 | 216505 | 2020-06-07 | Howard | Maryland | 24027 | 2130 | 67 |
219597 | 219597 | 2020-06-08 | Howard | Maryland | 24027 | 2161 | 68 |
222692 | 222692 | 2020-06-09 | Howard | Maryland | 24027 | 2196 | 71 |
225788 | 225788 | 2020-06-10 | Howard | Maryland | 24027 | 2225 | 73 |
228890 | 228890 | 2020-06-11 | Howard | Maryland | 24027 | 2316 | 73 |
231994 | 231994 | 2020-06-12 | Howard | Maryland | 24027 | 2337 | 73 |
235099 | 235099 | 2020-06-13 | Howard | Maryland | 24027 | 2376 | 73 |
238206 | 238206 | 2020-06-14 | Howard | Maryland | 24027 | 2340 | 74 |
241315 | 241315 | 2020-06-15 | Howard | Maryland | 24027 | 2355 | 75 |
244426 | 244426 | 2020-06-16 | Howard | Maryland | 24027 | 2332 | 76 |
247539 | 247539 | 2020-06-17 | Howard | Maryland | 24027 | 2348 | 77 |
250651 | 250651 | 2020-06-18 | Howard | Maryland | 24027 | 2353 | 79 |
253766 | 253766 | 2020-06-19 | Howard | Maryland | 24027 | 2387 | 79 |
256886 | 256886 | 2020-06-20 | Howard | Maryland | 24027 | 2414 | 80 |
260012 | 260012 | 2020-06-21 | Howard | Maryland | 24027 | 2428 | 80 |
263141 | 263141 | 2020-06-22 | Howard | Maryland | 24027 | 2441 | 80 |
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);