ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 24003 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
1745 | 1745 | 2020-03-13 | Anne Arundel | Maryland | 24003 | 1 | 0 |
2085 | 2085 | 2020-03-14 | Anne Arundel | Maryland | 24003 | 1 | 0 |
2484 | 2484 | 2020-03-15 | Anne Arundel | Maryland | 24003 | 2 | 0 |
2931 | 2931 | 2020-03-16 | Anne Arundel | Maryland | 24003 | 2 | 0 |
3432 | 3432 | 2020-03-17 | Anne Arundel | Maryland | 24003 | 3 | 0 |
4014 | 4014 | 2020-03-18 | Anne Arundel | Maryland | 24003 | 4 | 0 |
4716 | 4716 | 2020-03-19 | Anne Arundel | Maryland | 24003 | 5 | 0 |
5534 | 5534 | 2020-03-20 | Anne Arundel | Maryland | 24003 | 10 | 0 |
6490 | 6490 | 2020-03-21 | Anne Arundel | Maryland | 24003 | 16 | 0 |
7565 | 7565 | 2020-03-22 | Anne Arundel | Maryland | 24003 | 19 | 0 |
8735 | 8735 | 2020-03-23 | Anne Arundel | Maryland | 24003 | 20 | 0 |
10024 | 10024 | 2020-03-24 | Anne Arundel | Maryland | 24003 | 24 | 0 |
11434 | 11434 | 2020-03-25 | Anne Arundel | Maryland | 24003 | 31 | 0 |
13015 | 13015 | 2020-03-26 | Anne Arundel | Maryland | 24003 | 42 | 0 |
14723 | 14723 | 2020-03-27 | Anne Arundel | Maryland | 24003 | 63 | 1 |
16543 | 16543 | 2020-03-28 | Anne Arundel | Maryland | 24003 | 88 | 1 |
18458 | 18458 | 2020-03-29 | Anne Arundel | Maryland | 24003 | 99 | 1 |
20474 | 20474 | 2020-03-30 | Anne Arundel | Maryland | 24003 | 110 | 1 |
22583 | 22583 | 2020-03-31 | Anne Arundel | Maryland | 24003 | 127 | 1 |
24760 | 24760 | 2020-04-01 | Anne Arundel | Maryland | 24003 | 158 | 1 |
27012 | 27012 | 2020-04-02 | Anne Arundel | Maryland | 24003 | 206 | 1 |
29331 | 29331 | 2020-04-03 | Anne Arundel | Maryland | 24003 | 249 | 4 |
31709 | 31709 | 2020-04-04 | Anne Arundel | Maryland | 24003 | 289 | 6 |
34134 | 34134 | 2020-04-05 | Anne Arundel | Maryland | 24003 | 319 | 6 |
36593 | 36593 | 2020-04-06 | Anne Arundel | Maryland | 24003 | 343 | 8 |
39101 | 39101 | 2020-04-07 | Anne Arundel | Maryland | 24003 | 370 | 8 |
41653 | 41653 | 2020-04-08 | Anne Arundel | Maryland | 24003 | 466 | 11 |
44229 | 44229 | 2020-04-09 | Anne Arundel | Maryland | 24003 | 505 | 12 |
46837 | 46837 | 2020-04-10 | Anne Arundel | Maryland | 24003 | 554 | 16 |
49479 | 49479 | 2020-04-11 | Anne Arundel | Maryland | 24003 | 615 | 19 |
52149 | 52149 | 2020-04-12 | Anne Arundel | Maryland | 24003 | 659 | 27 |
54830 | 54830 | 2020-04-13 | Anne Arundel | Maryland | 24003 | 724 | 29 |
57528 | 57528 | 2020-04-14 | Anne Arundel | Maryland | 24003 | 783 | 32 |
60236 | 60236 | 2020-04-15 | Anne Arundel | Maryland | 24003 | 850 | 30 |
62957 | 62957 | 2020-04-16 | Anne Arundel | Maryland | 24003 | 902 | 35 |
65695 | 65695 | 2020-04-17 | Anne Arundel | Maryland | 24003 | 972 | 40 |
68445 | 68445 | 2020-04-18 | Anne Arundel | Maryland | 24003 | 1012 | 41 |
71209 | 71209 | 2020-04-19 | Anne Arundel | Maryland | 24003 | 1053 | 46 |
73981 | 73981 | 2020-04-20 | Anne Arundel | Maryland | 24003 | 1104 | 48 |
76761 | 76761 | 2020-04-21 | Anne Arundel | Maryland | 24003 | 1164 | 52 |
79547 | 79547 | 2020-04-22 | Anne Arundel | Maryland | 24003 | 1197 | 56 |
82342 | 82342 | 2020-04-23 | Anne Arundel | Maryland | 24003 | 1301 | 61 |
85146 | 85146 | 2020-04-24 | Anne Arundel | Maryland | 24003 | 1380 | 63 |
87956 | 87956 | 2020-04-25 | Anne Arundel | Maryland | 24003 | 1438 | 70 |
90772 | 90772 | 2020-04-26 | Anne Arundel | Maryland | 24003 | 1518 | 71 |
93593 | 93593 | 2020-04-27 | Anne Arundel | Maryland | 24003 | 1552 | 74 |
96428 | 96428 | 2020-04-28 | Anne Arundel | Maryland | 24003 | 1579 | 78 |
99274 | 99274 | 2020-04-29 | Anne Arundel | Maryland | 24003 | 1670 | 83 |
102126 | 102126 | 2020-04-30 | Anne Arundel | Maryland | 24003 | 1733 | 91 |
104986 | 104986 | 2020-05-01 | Anne Arundel | Maryland | 24003 | 1815 | 90 |
107850 | 107850 | 2020-05-02 | Anne Arundel | Maryland | 24003 | 1893 | 94 |
110722 | 110722 | 2020-05-03 | Anne Arundel | Maryland | 24003 | 1967 | 96 |
113600 | 113600 | 2020-05-04 | Anne Arundel | Maryland | 24003 | 2026 | 101 |
116481 | 116481 | 2020-05-05 | Anne Arundel | Maryland | 24003 | 2054 | 107 |
119442 | 119442 | 2020-05-06 | Anne Arundel | Maryland | 24003 | 2094 | 108 |
122414 | 122414 | 2020-05-07 | Anne Arundel | Maryland | 24003 | 2203 | 111 |
125396 | 125396 | 2020-05-08 | Anne Arundel | Maryland | 24003 | 2300 | 115 |
128383 | 128383 | 2020-05-09 | Anne Arundel | Maryland | 24003 | 2381 | 117 |
131373 | 131373 | 2020-05-10 | Anne Arundel | Maryland | 24003 | 2472 | 121 |
134364 | 134364 | 2020-05-11 | Anne Arundel | Maryland | 24003 | 2501 | 124 |
137354 | 137354 | 2020-05-12 | Anne Arundel | Maryland | 24003 | 2530 | 127 |
140348 | 140348 | 2020-05-13 | Anne Arundel | Maryland | 24003 | 2606 | 133 |
143343 | 143343 | 2020-05-14 | Anne Arundel | Maryland | 24003 | 2670 | 135 |
146343 | 146343 | 2020-05-15 | Anne Arundel | Maryland | 24003 | 2760 | 136 |
149348 | 149348 | 2020-05-16 | Anne Arundel | Maryland | 24003 | 2809 | 141 |
152359 | 152359 | 2020-05-17 | Anne Arundel | Maryland | 24003 | 2864 | 142 |
155373 | 155373 | 2020-05-18 | Anne Arundel | Maryland | 24003 | 2901 | 142 |
158391 | 158391 | 2020-05-19 | Anne Arundel | Maryland | 24003 | 2989 | 145 |
161417 | 161417 | 2020-05-20 | Anne Arundel | Maryland | 24003 | 3041 | 145 |
164446 | 164446 | 2020-05-21 | Anne Arundel | Maryland | 24003 | 3140 | 147 |
167482 | 167482 | 2020-05-22 | Anne Arundel | Maryland | 24003 | 3215 | 149 |
170519 | 170519 | 2020-05-23 | Anne Arundel | Maryland | 24003 | 3290 | 150 |
173561 | 173561 | 2020-05-24 | Anne Arundel | Maryland | 24003 | 3315 | 153 |
176604 | 176604 | 2020-05-25 | Anne Arundel | Maryland | 24003 | 3365 | 157 |
179648 | 179648 | 2020-05-26 | Anne Arundel | Maryland | 24003 | 3402 | 159 |
182694 | 182694 | 2020-05-27 | Anne Arundel | Maryland | 24003 | 3457 | 163 |
185749 | 185749 | 2020-05-28 | Anne Arundel | Maryland | 24003 | 3565 | 163 |
188807 | 188807 | 2020-05-29 | Anne Arundel | Maryland | 24003 | 3652 | 167 |
191871 | 191871 | 2020-05-30 | Anne Arundel | Maryland | 24003 | 3752 | 172 |
194939 | 194939 | 2020-05-31 | Anne Arundel | Maryland | 24003 | 3794 | 174 |
198010 | 198010 | 2020-06-01 | Anne Arundel | Maryland | 24003 | 3851 | 175 |
201082 | 201082 | 2020-06-02 | Anne Arundel | Maryland | 24003 | 3933 | 178 |
204159 | 204159 | 2020-06-03 | Anne Arundel | Maryland | 24003 | 4018 | 178 |
207240 | 207240 | 2020-06-04 | Anne Arundel | Maryland | 24003 | 4089 | 179 |
210321 | 210321 | 2020-06-05 | Anne Arundel | Maryland | 24003 | 4159 | 182 |
213405 | 213405 | 2020-06-06 | Anne Arundel | Maryland | 24003 | 4219 | 185 |
216493 | 216493 | 2020-06-07 | Anne Arundel | Maryland | 24003 | 4245 | 185 |
219585 | 219585 | 2020-06-08 | Anne Arundel | Maryland | 24003 | 4276 | 185 |
222680 | 222680 | 2020-06-09 | Anne Arundel | Maryland | 24003 | 4318 | 186 |
225776 | 225776 | 2020-06-10 | Anne Arundel | Maryland | 24003 | 4357 | 190 |
228878 | 228878 | 2020-06-11 | Anne Arundel | Maryland | 24003 | 4430 | 191 |
231982 | 231982 | 2020-06-12 | Anne Arundel | Maryland | 24003 | 4462 | 192 |
235087 | 235087 | 2020-06-13 | Anne Arundel | Maryland | 24003 | 4531 | 192 |
238194 | 238194 | 2020-06-14 | Anne Arundel | Maryland | 24003 | 4616 | 194 |
241303 | 241303 | 2020-06-15 | Anne Arundel | Maryland | 24003 | 4632 | 194 |
244414 | 244414 | 2020-06-16 | Anne Arundel | Maryland | 24003 | 4760 | 194 |
247527 | 247527 | 2020-06-17 | Anne Arundel | Maryland | 24003 | 4805 | 195 |
250639 | 250639 | 2020-06-18 | Anne Arundel | Maryland | 24003 | 4844 | 196 |
253754 | 253754 | 2020-06-19 | Anne Arundel | Maryland | 24003 | 4871 | 198 |
256874 | 256874 | 2020-06-20 | Anne Arundel | Maryland | 24003 | 4889 | 200 |
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);