ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 24510 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486 | 2486 | 2020-03-15 | Baltimore city | Maryland | 24510 | 1 | 0 |
2933 | 2933 | 2020-03-16 | Baltimore city | Maryland | 24510 | 1 | 0 |
3434 | 3434 | 2020-03-17 | Baltimore city | Maryland | 24510 | 3 | 0 |
4016 | 4016 | 2020-03-18 | Baltimore city | Maryland | 24510 | 7 | 0 |
4718 | 4718 | 2020-03-19 | Baltimore city | Maryland | 24510 | 7 | 0 |
5536 | 5536 | 2020-03-20 | Baltimore city | Maryland | 24510 | 11 | 0 |
6492 | 6492 | 2020-03-21 | Baltimore city | Maryland | 24510 | 15 | 0 |
7567 | 7567 | 2020-03-22 | Baltimore city | Maryland | 24510 | 24 | 0 |
8737 | 8737 | 2020-03-23 | Baltimore city | Maryland | 24510 | 31 | 0 |
10026 | 10026 | 2020-03-24 | Baltimore city | Maryland | 24510 | 41 | 0 |
11436 | 11436 | 2020-03-25 | Baltimore city | Maryland | 24510 | 53 | 0 |
13017 | 13017 | 2020-03-26 | Baltimore city | Maryland | 24510 | 72 | 0 |
14725 | 14725 | 2020-03-27 | Baltimore city | Maryland | 24510 | 103 | 0 |
16545 | 16545 | 2020-03-28 | Baltimore city | Maryland | 24510 | 112 | 2 |
18460 | 18460 | 2020-03-29 | Baltimore city | Maryland | 24510 | 129 | 2 |
20476 | 20476 | 2020-03-30 | Baltimore city | Maryland | 24510 | 152 | 2 |
22585 | 22585 | 2020-03-31 | Baltimore city | Maryland | 24510 | 187 | 2 |
24762 | 24762 | 2020-04-01 | Baltimore city | Maryland | 24510 | 187 | 2 |
27014 | 27014 | 2020-04-02 | Baltimore city | Maryland | 24510 | 265 | 2 |
29333 | 29333 | 2020-04-03 | Baltimore city | Maryland | 24510 | 313 | 4 |
31711 | 31711 | 2020-04-04 | Baltimore city | Maryland | 24510 | 343 | 6 |
34136 | 34136 | 2020-04-05 | Baltimore city | Maryland | 24510 | 394 | 7 |
36595 | 36595 | 2020-04-06 | Baltimore city | Maryland | 24510 | 435 | 8 |
39103 | 39103 | 2020-04-07 | Baltimore city | Maryland | 24510 | 459 | 9 |
41655 | 41655 | 2020-04-08 | Baltimore city | Maryland | 24510 | 571 | 10 |
44231 | 44231 | 2020-04-09 | Baltimore city | Maryland | 24510 | 638 | 13 |
46839 | 46839 | 2020-04-10 | Baltimore city | Maryland | 24510 | 689 | 17 |
49481 | 49481 | 2020-04-11 | Baltimore city | Maryland | 24510 | 756 | 22 |
52151 | 52151 | 2020-04-12 | Baltimore city | Maryland | 24510 | 812 | 24 |
54832 | 54832 | 2020-04-13 | Baltimore city | Maryland | 24510 | 873 | 26 |
57530 | 57530 | 2020-04-14 | Baltimore city | Maryland | 24510 | 962 | 29 |
60238 | 60238 | 2020-04-15 | Baltimore city | Maryland | 24510 | 1062 | 27 |
62959 | 62959 | 2020-04-16 | Baltimore city | Maryland | 24510 | 1164 | 35 |
65697 | 65697 | 2020-04-17 | Baltimore city | Maryland | 24510 | 1277 | 42 |
68447 | 68447 | 2020-04-18 | Baltimore city | Maryland | 24510 | 1381 | 43 |
71211 | 71211 | 2020-04-19 | Baltimore city | Maryland | 24510 | 1397 | 51 |
73983 | 73983 | 2020-04-20 | Baltimore city | Maryland | 24510 | 1516 | 54 |
76763 | 76763 | 2020-04-21 | Baltimore city | Maryland | 24510 | 1547 | 59 |
79549 | 79549 | 2020-04-22 | Baltimore city | Maryland | 24510 | 1608 | 64 |
82344 | 82344 | 2020-04-23 | Baltimore city | Maryland | 24510 | 1678 | 66 |
85148 | 85148 | 2020-04-24 | Baltimore city | Maryland | 24510 | 1734 | 71 |
87958 | 87958 | 2020-04-25 | Baltimore city | Maryland | 24510 | 1797 | 78 |
90774 | 90774 | 2020-04-26 | Baltimore city | Maryland | 24510 | 1872 | 79 |
93595 | 93595 | 2020-04-27 | Baltimore city | Maryland | 24510 | 1939 | 88 |
96430 | 96430 | 2020-04-28 | Baltimore city | Maryland | 24510 | 1984 | 90 |
99276 | 99276 | 2020-04-29 | Baltimore city | Maryland | 24510 | 2021 | 101 |
102128 | 102128 | 2020-04-30 | Baltimore city | Maryland | 24510 | 2076 | 112 |
104988 | 104988 | 2020-05-01 | Baltimore city | Maryland | 24510 | 2171 | 115 |
107852 | 107852 | 2020-05-02 | Baltimore city | Maryland | 24510 | 2246 | 126 |
110724 | 110724 | 2020-05-03 | Baltimore city | Maryland | 24510 | 2328 | 129 |
113602 | 113602 | 2020-05-04 | Baltimore city | Maryland | 24510 | 2420 | 129 |
116483 | 116483 | 2020-05-05 | Baltimore city | Maryland | 24510 | 2618 | 133 |
119444 | 119444 | 2020-05-06 | Baltimore city | Maryland | 24510 | 2761 | 140 |
122416 | 122416 | 2020-05-07 | Baltimore city | Maryland | 24510 | 2865 | 149 |
125398 | 125398 | 2020-05-08 | Baltimore city | Maryland | 24510 | 2950 | 155 |
128385 | 128385 | 2020-05-09 | Baltimore city | Maryland | 24510 | 3217 | 163 |
131375 | 131375 | 2020-05-10 | Baltimore city | Maryland | 24510 | 3326 | 169 |
134366 | 134366 | 2020-05-11 | Baltimore city | Maryland | 24510 | 3362 | 171 |
137356 | 137356 | 2020-05-12 | Baltimore city | Maryland | 24510 | 3413 | 178 |
140350 | 140350 | 2020-05-13 | Baltimore city | Maryland | 24510 | 3485 | 186 |
143345 | 143345 | 2020-05-14 | Baltimore city | Maryland | 24510 | 3514 | 192 |
146345 | 146345 | 2020-05-15 | Baltimore city | Maryland | 24510 | 3615 | 192 |
149350 | 149350 | 2020-05-16 | Baltimore city | Maryland | 24510 | 3727 | 200 |
152361 | 152361 | 2020-05-17 | Baltimore city | Maryland | 24510 | 3806 | 203 |
155375 | 155375 | 2020-05-18 | Baltimore city | Maryland | 24510 | 3838 | 208 |
158393 | 158393 | 2020-05-19 | Baltimore city | Maryland | 24510 | 4010 | 210 |
161419 | 161419 | 2020-05-20 | Baltimore city | Maryland | 24510 | 4159 | 215 |
164448 | 164448 | 2020-05-21 | Baltimore city | Maryland | 24510 | 4347 | 218 |
167484 | 167484 | 2020-05-22 | Baltimore city | Maryland | 24510 | 4499 | 220 |
170521 | 170521 | 2020-05-23 | Baltimore city | Maryland | 24510 | 4682 | 229 |
173563 | 173563 | 2020-05-24 | Baltimore city | Maryland | 24510 | 4791 | 231 |
176606 | 176606 | 2020-05-25 | Baltimore city | Maryland | 24510 | 4897 | 234 |
179650 | 179650 | 2020-05-26 | Baltimore city | Maryland | 24510 | 5006 | 236 |
182696 | 182696 | 2020-05-27 | Baltimore city | Maryland | 24510 | 5062 | 236 |
185751 | 185751 | 2020-05-28 | Baltimore city | Maryland | 24510 | 5211 | 240 |
188809 | 188809 | 2020-05-29 | Baltimore city | Maryland | 24510 | 5434 | 248 |
191873 | 191873 | 2020-05-30 | Baltimore city | Maryland | 24510 | 5572 | 254 |
194941 | 194941 | 2020-05-31 | Baltimore city | Maryland | 24510 | 5672 | 258 |
198012 | 198012 | 2020-06-01 | Baltimore city | Maryland | 24510 | 5612 | 261 |
201084 | 201084 | 2020-06-02 | Baltimore city | Maryland | 24510 | 5696 | 263 |
204161 | 204161 | 2020-06-03 | Baltimore city | Maryland | 24510 | 5809 | 266 |
207242 | 207242 | 2020-06-04 | Baltimore city | Maryland | 24510 | 5914 | 269 |
210323 | 210323 | 2020-06-05 | Baltimore city | Maryland | 24510 | 6046 | 272 |
213407 | 213407 | 2020-06-06 | Baltimore city | Maryland | 24510 | 6149 | 276 |
216495 | 216495 | 2020-06-07 | Baltimore city | Maryland | 24510 | 6237 | 281 |
219587 | 219587 | 2020-06-08 | Baltimore city | Maryland | 24510 | 6304 | 282 |
222682 | 222682 | 2020-06-09 | Baltimore city | Maryland | 24510 | 6363 | 287 |
225778 | 225778 | 2020-06-10 | Baltimore city | Maryland | 24510 | 6436 | 289 |
228880 | 228880 | 2020-06-11 | Baltimore city | Maryland | 24510 | 6517 | 292 |
231984 | 231984 | 2020-06-12 | Baltimore city | Maryland | 24510 | 6567 | 294 |
235089 | 235089 | 2020-06-13 | Baltimore city | Maryland | 24510 | 6641 | 297 |
238196 | 238196 | 2020-06-14 | Baltimore city | Maryland | 24510 | 6698 | 301 |
241305 | 241305 | 2020-06-15 | Baltimore city | Maryland | 24510 | 6755 | 301 |
244416 | 244416 | 2020-06-16 | Baltimore city | Maryland | 24510 | 6790 | 304 |
247529 | 247529 | 2020-06-17 | Baltimore city | Maryland | 24510 | 6874 | 307 |
250641 | 250641 | 2020-06-18 | Baltimore city | Maryland | 24510 | 6914 | 309 |
253756 | 253756 | 2020-06-19 | Baltimore city | Maryland | 24510 | 6947 | 310 |
256876 | 256876 | 2020-06-20 | Baltimore city | Maryland | 24510 | 7002 | 313 |
260002 | 260002 | 2020-06-21 | Baltimore city | Maryland | 24510 | 7062 | 313 |
263131 | 263131 | 2020-06-22 | Baltimore city | Maryland | 24510 | 7104 | 316 |
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);