ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 24017 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 |
---|---|---|---|---|---|---|---|
1747 | 1747 | 2020-03-13 | Charles | Maryland | 24017 | 1 | 0 |
2088 | 2088 | 2020-03-14 | Charles | Maryland | 24017 | 1 | 0 |
2488 | 2488 | 2020-03-15 | Charles | Maryland | 24017 | 1 | 0 |
2935 | 2935 | 2020-03-16 | Charles | Maryland | 24017 | 1 | 0 |
3436 | 3436 | 2020-03-17 | Charles | Maryland | 24017 | 1 | 0 |
4018 | 4018 | 2020-03-18 | Charles | Maryland | 24017 | 2 | 0 |
4721 | 4721 | 2020-03-19 | Charles | Maryland | 24017 | 2 | 0 |
5539 | 5539 | 2020-03-20 | Charles | Maryland | 24017 | 2 | 0 |
6496 | 6496 | 2020-03-21 | Charles | Maryland | 24017 | 4 | 0 |
7572 | 7572 | 2020-03-22 | Charles | Maryland | 24017 | 5 | 0 |
8742 | 8742 | 2020-03-23 | Charles | Maryland | 24017 | 5 | 0 |
10031 | 10031 | 2020-03-24 | Charles | Maryland | 24017 | 5 | 0 |
11441 | 11441 | 2020-03-25 | Charles | Maryland | 24017 | 8 | 0 |
13022 | 13022 | 2020-03-26 | Charles | Maryland | 24017 | 10 | 0 |
14730 | 14730 | 2020-03-27 | Charles | Maryland | 24017 | 17 | 0 |
16550 | 16550 | 2020-03-28 | Charles | Maryland | 24017 | 21 | 1 |
18465 | 18465 | 2020-03-29 | Charles | Maryland | 24017 | 28 | 1 |
20481 | 20481 | 2020-03-30 | Charles | Maryland | 24017 | 33 | 1 |
22590 | 22590 | 2020-03-31 | Charles | Maryland | 24017 | 40 | 1 |
24767 | 24767 | 2020-04-01 | Charles | Maryland | 24017 | 56 | 1 |
27019 | 27019 | 2020-04-02 | Charles | Maryland | 24017 | 69 | 1 |
29338 | 29338 | 2020-04-03 | Charles | Maryland | 24017 | 90 | 1 |
31716 | 31716 | 2020-04-04 | Charles | Maryland | 24017 | 95 | 1 |
34141 | 34141 | 2020-04-05 | Charles | Maryland | 24017 | 111 | 2 |
36600 | 36600 | 2020-04-06 | Charles | Maryland | 24017 | 129 | 2 |
39108 | 39108 | 2020-04-07 | Charles | Maryland | 24017 | 136 | 2 |
41660 | 41660 | 2020-04-08 | Charles | Maryland | 24017 | 164 | 2 |
44236 | 44236 | 2020-04-09 | Charles | Maryland | 24017 | 180 | 3 |
46844 | 46844 | 2020-04-10 | Charles | Maryland | 24017 | 220 | 4 |
49486 | 49486 | 2020-04-11 | Charles | Maryland | 24017 | 235 | 5 |
52156 | 52156 | 2020-04-12 | Charles | Maryland | 24017 | 253 | 9 |
54837 | 54837 | 2020-04-13 | Charles | Maryland | 24017 | 274 | 10 |
57535 | 57535 | 2020-04-14 | Charles | Maryland | 24017 | 292 | 12 |
60243 | 60243 | 2020-04-15 | Charles | Maryland | 24017 | 310 | 11 |
62964 | 62964 | 2020-04-16 | Charles | Maryland | 24017 | 327 | 13 |
65702 | 65702 | 2020-04-17 | Charles | Maryland | 24017 | 337 | 15 |
68452 | 68452 | 2020-04-18 | Charles | Maryland | 24017 | 347 | 16 |
71216 | 71216 | 2020-04-19 | Charles | Maryland | 24017 | 370 | 17 |
73988 | 73988 | 2020-04-20 | Charles | Maryland | 24017 | 393 | 20 |
76768 | 76768 | 2020-04-21 | Charles | Maryland | 24017 | 402 | 23 |
79554 | 79554 | 2020-04-22 | Charles | Maryland | 24017 | 428 | 30 |
82349 | 82349 | 2020-04-23 | Charles | Maryland | 24017 | 443 | 32 |
85153 | 85153 | 2020-04-24 | Charles | Maryland | 24017 | 460 | 34 |
87963 | 87963 | 2020-04-25 | Charles | Maryland | 24017 | 484 | 35 |
90779 | 90779 | 2020-04-26 | Charles | Maryland | 24017 | 505 | 35 |
93600 | 93600 | 2020-04-27 | Charles | Maryland | 24017 | 530 | 37 |
96435 | 96435 | 2020-04-28 | Charles | Maryland | 24017 | 540 | 39 |
99281 | 99281 | 2020-04-29 | Charles | Maryland | 24017 | 552 | 42 |
102133 | 102133 | 2020-04-30 | Charles | Maryland | 24017 | 565 | 44 |
104993 | 104993 | 2020-05-01 | Charles | Maryland | 24017 | 613 | 46 |
107857 | 107857 | 2020-05-02 | Charles | Maryland | 24017 | 624 | 47 |
110729 | 110729 | 2020-05-03 | Charles | Maryland | 24017 | 640 | 50 |
113607 | 113607 | 2020-05-04 | Charles | Maryland | 24017 | 654 | 50 |
116488 | 116488 | 2020-05-05 | Charles | Maryland | 24017 | 663 | 50 |
119449 | 119449 | 2020-05-06 | Charles | Maryland | 24017 | 673 | 52 |
122421 | 122421 | 2020-05-07 | Charles | Maryland | 24017 | 701 | 51 |
125403 | 125403 | 2020-05-08 | Charles | Maryland | 24017 | 719 | 54 |
128390 | 128390 | 2020-05-09 | Charles | Maryland | 24017 | 730 | 53 |
131380 | 131380 | 2020-05-10 | Charles | Maryland | 24017 | 749 | 54 |
134371 | 134371 | 2020-05-11 | Charles | Maryland | 24017 | 757 | 54 |
137361 | 137361 | 2020-05-12 | Charles | Maryland | 24017 | 762 | 55 |
140355 | 140355 | 2020-05-13 | Charles | Maryland | 24017 | 779 | 57 |
143350 | 143350 | 2020-05-14 | Charles | Maryland | 24017 | 798 | 59 |
146350 | 146350 | 2020-05-15 | Charles | Maryland | 24017 | 831 | 61 |
149355 | 149355 | 2020-05-16 | Charles | Maryland | 24017 | 846 | 62 |
152366 | 152366 | 2020-05-17 | Charles | Maryland | 24017 | 861 | 62 |
155380 | 155380 | 2020-05-18 | Charles | Maryland | 24017 | 869 | 62 |
158398 | 158398 | 2020-05-19 | Charles | Maryland | 24017 | 896 | 63 |
161424 | 161424 | 2020-05-20 | Charles | Maryland | 24017 | 922 | 64 |
164453 | 164453 | 2020-05-21 | Charles | Maryland | 24017 | 944 | 65 |
167489 | 167489 | 2020-05-22 | Charles | Maryland | 24017 | 958 | 67 |
170526 | 170526 | 2020-05-23 | Charles | Maryland | 24017 | 971 | 69 |
173568 | 173568 | 2020-05-24 | Charles | Maryland | 24017 | 991 | 69 |
176611 | 176611 | 2020-05-25 | Charles | Maryland | 24017 | 999 | 69 |
179655 | 179655 | 2020-05-26 | Charles | Maryland | 24017 | 1003 | 70 |
182701 | 182701 | 2020-05-27 | Charles | Maryland | 24017 | 1009 | 71 |
185756 | 185756 | 2020-05-28 | Charles | Maryland | 24017 | 1028 | 72 |
188814 | 188814 | 2020-05-29 | Charles | Maryland | 24017 | 1057 | 72 |
191878 | 191878 | 2020-05-30 | Charles | Maryland | 24017 | 1086 | 72 |
194946 | 194946 | 2020-05-31 | Charles | Maryland | 24017 | 1109 | 72 |
198017 | 198017 | 2020-06-01 | Charles | Maryland | 24017 | 1121 | 73 |
201089 | 201089 | 2020-06-02 | Charles | Maryland | 24017 | 1134 | 73 |
204166 | 204166 | 2020-06-03 | Charles | Maryland | 24017 | 1153 | 75 |
207247 | 207247 | 2020-06-04 | Charles | Maryland | 24017 | 1176 | 79 |
210328 | 210328 | 2020-06-05 | Charles | Maryland | 24017 | 1187 | 79 |
213412 | 213412 | 2020-06-06 | Charles | Maryland | 24017 | 1198 | 81 |
216500 | 216500 | 2020-06-07 | Charles | Maryland | 24017 | 1204 | 80 |
219592 | 219592 | 2020-06-08 | Charles | Maryland | 24017 | 1213 | 80 |
222687 | 222687 | 2020-06-09 | Charles | Maryland | 24017 | 1218 | 82 |
225783 | 225783 | 2020-06-10 | Charles | Maryland | 24017 | 1233 | 83 |
228885 | 228885 | 2020-06-11 | Charles | Maryland | 24017 | 1237 | 83 |
231989 | 231989 | 2020-06-12 | Charles | Maryland | 24017 | 1250 | 82 |
235094 | 235094 | 2020-06-13 | Charles | Maryland | 24017 | 1266 | 83 |
238201 | 238201 | 2020-06-14 | Charles | Maryland | 24017 | 1271 | 83 |
241310 | 241310 | 2020-06-15 | Charles | Maryland | 24017 | 1274 | 83 |
244421 | 244421 | 2020-06-16 | Charles | Maryland | 24017 | 1279 | 83 |
247534 | 247534 | 2020-06-17 | Charles | Maryland | 24017 | 1293 | 85 |
250646 | 250646 | 2020-06-18 | Charles | Maryland | 24017 | 1296 | 86 |
253761 | 253761 | 2020-06-19 | Charles | Maryland | 24017 | 1296 | 86 |
256881 | 256881 | 2020-06-20 | Charles | Maryland | 24017 | 1306 | 86 |
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);