ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Frederick" and fips = 24021 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 |
---|---|---|---|---|---|---|---|
2936 | 2936 | 2020-03-16 | Frederick | Maryland | 24021 | 1 | 0 |
3437 | 3437 | 2020-03-17 | Frederick | Maryland | 24021 | 1 | 0 |
4019 | 4019 | 2020-03-18 | Frederick | Maryland | 24021 | 1 | 0 |
4722 | 4722 | 2020-03-19 | Frederick | Maryland | 24021 | 1 | 0 |
5540 | 5540 | 2020-03-20 | Frederick | Maryland | 24021 | 1 | 0 |
6497 | 6497 | 2020-03-21 | Frederick | Maryland | 24021 | 1 | 0 |
7573 | 7573 | 2020-03-22 | Frederick | Maryland | 24021 | 1 | 0 |
8743 | 8743 | 2020-03-23 | Frederick | Maryland | 24021 | 4 | 0 |
10032 | 10032 | 2020-03-24 | Frederick | Maryland | 24021 | 4 | 0 |
11442 | 11442 | 2020-03-25 | Frederick | Maryland | 24021 | 7 | 0 |
13023 | 13023 | 2020-03-26 | Frederick | Maryland | 24021 | 14 | 0 |
14731 | 14731 | 2020-03-27 | Frederick | Maryland | 24021 | 15 | 0 |
16551 | 16551 | 2020-03-28 | Frederick | Maryland | 24021 | 22 | 0 |
18466 | 18466 | 2020-03-29 | Frederick | Maryland | 24021 | 24 | 0 |
20482 | 20482 | 2020-03-30 | Frederick | Maryland | 24021 | 26 | 0 |
22591 | 22591 | 2020-03-31 | Frederick | Maryland | 24021 | 33 | 0 |
24769 | 24769 | 2020-04-01 | Frederick | Maryland | 24021 | 35 | 2 |
27021 | 27021 | 2020-04-02 | Frederick | Maryland | 24021 | 45 | 2 |
29340 | 29340 | 2020-04-03 | Frederick | Maryland | 24021 | 54 | 2 |
31718 | 31718 | 2020-04-04 | Frederick | Maryland | 24021 | 73 | 2 |
34143 | 34143 | 2020-04-05 | Frederick | Maryland | 24021 | 112 | 3 |
36602 | 36602 | 2020-04-06 | Frederick | Maryland | 24021 | 138 | 4 |
39110 | 39110 | 2020-04-07 | Frederick | Maryland | 24021 | 151 | 4 |
41662 | 41662 | 2020-04-08 | Frederick | Maryland | 24021 | 199 | 4 |
44238 | 44238 | 2020-04-09 | Frederick | Maryland | 24021 | 233 | 4 |
46846 | 46846 | 2020-04-10 | Frederick | Maryland | 24021 | 289 | 9 |
49488 | 49488 | 2020-04-11 | Frederick | Maryland | 24021 | 341 | 11 |
52158 | 52158 | 2020-04-12 | Frederick | Maryland | 24021 | 368 | 12 |
54839 | 54839 | 2020-04-13 | Frederick | Maryland | 24021 | 417 | 12 |
57537 | 57537 | 2020-04-14 | Frederick | Maryland | 24021 | 441 | 14 |
60245 | 60245 | 2020-04-15 | Frederick | Maryland | 24021 | 449 | 27 |
62966 | 62966 | 2020-04-16 | Frederick | Maryland | 24021 | 504 | 29 |
65704 | 65704 | 2020-04-17 | Frederick | Maryland | 24021 | 532 | 30 |
68454 | 68454 | 2020-04-18 | Frederick | Maryland | 24021 | 565 | 31 |
71218 | 71218 | 2020-04-19 | Frederick | Maryland | 24021 | 596 | 30 |
73990 | 73990 | 2020-04-20 | Frederick | Maryland | 24021 | 621 | 30 |
76770 | 76770 | 2020-04-21 | Frederick | Maryland | 24021 | 637 | 33 |
79556 | 79556 | 2020-04-22 | Frederick | Maryland | 24021 | 664 | 35 |
82351 | 82351 | 2020-04-23 | Frederick | Maryland | 24021 | 696 | 36 |
85155 | 85155 | 2020-04-24 | Frederick | Maryland | 24021 | 771 | 41 |
87965 | 87965 | 2020-04-25 | Frederick | Maryland | 24021 | 820 | 45 |
90781 | 90781 | 2020-04-26 | Frederick | Maryland | 24021 | 840 | 45 |
93602 | 93602 | 2020-04-27 | Frederick | Maryland | 24021 | 871 | 48 |
96437 | 96437 | 2020-04-28 | Frederick | Maryland | 24021 | 876 | 48 |
99283 | 99283 | 2020-04-29 | Frederick | Maryland | 24021 | 899 | 51 |
102135 | 102135 | 2020-04-30 | Frederick | Maryland | 24021 | 925 | 56 |
104995 | 104995 | 2020-05-01 | Frederick | Maryland | 24021 | 949 | 56 |
107859 | 107859 | 2020-05-02 | Frederick | Maryland | 24021 | 983 | 59 |
110731 | 110731 | 2020-05-03 | Frederick | Maryland | 24021 | 1011 | 61 |
113609 | 113609 | 2020-05-04 | Frederick | Maryland | 24021 | 1045 | 62 |
116490 | 116490 | 2020-05-05 | Frederick | Maryland | 24021 | 1078 | 66 |
119451 | 119451 | 2020-05-06 | Frederick | Maryland | 24021 | 1115 | 68 |
122423 | 122423 | 2020-05-07 | Frederick | Maryland | 24021 | 1158 | 70 |
125405 | 125405 | 2020-05-08 | Frederick | Maryland | 24021 | 1188 | 70 |
128392 | 128392 | 2020-05-09 | Frederick | Maryland | 24021 | 1219 | 72 |
131382 | 131382 | 2020-05-10 | Frederick | Maryland | 24021 | 1257 | 74 |
134373 | 134373 | 2020-05-11 | Frederick | Maryland | 24021 | 1273 | 74 |
137363 | 137363 | 2020-05-12 | Frederick | Maryland | 24021 | 1288 | 77 |
140357 | 140357 | 2020-05-13 | Frederick | Maryland | 24021 | 1308 | 80 |
143352 | 143352 | 2020-05-14 | Frederick | Maryland | 24021 | 1331 | 84 |
146352 | 146352 | 2020-05-15 | Frederick | Maryland | 24021 | 1371 | 88 |
149357 | 149357 | 2020-05-16 | Frederick | Maryland | 24021 | 1409 | 89 |
152368 | 152368 | 2020-05-17 | Frederick | Maryland | 24021 | 1430 | 90 |
155382 | 155382 | 2020-05-18 | Frederick | Maryland | 24021 | 1467 | 90 |
158400 | 158400 | 2020-05-19 | Frederick | Maryland | 24021 | 1498 | 90 |
161426 | 161426 | 2020-05-20 | Frederick | Maryland | 24021 | 1540 | 93 |
164455 | 164455 | 2020-05-21 | Frederick | Maryland | 24021 | 1575 | 94 |
167491 | 167491 | 2020-05-22 | Frederick | Maryland | 24021 | 1632 | 95 |
170528 | 170528 | 2020-05-23 | Frederick | Maryland | 24021 | 1668 | 96 |
173570 | 173570 | 2020-05-24 | Frederick | Maryland | 24021 | 1703 | 98 |
176613 | 176613 | 2020-05-25 | Frederick | Maryland | 24021 | 1738 | 99 |
179657 | 179657 | 2020-05-26 | Frederick | Maryland | 24021 | 1753 | 101 |
182703 | 182703 | 2020-05-27 | Frederick | Maryland | 24021 | 1793 | 103 |
185758 | 185758 | 2020-05-28 | Frederick | Maryland | 24021 | 1831 | 104 |
188816 | 188816 | 2020-05-29 | Frederick | Maryland | 24021 | 1863 | 105 |
191880 | 191880 | 2020-05-30 | Frederick | Maryland | 24021 | 1897 | 105 |
194948 | 194948 | 2020-05-31 | Frederick | Maryland | 24021 | 1918 | 105 |
198019 | 198019 | 2020-06-01 | Frederick | Maryland | 24021 | 1935 | 106 |
201091 | 201091 | 2020-06-02 | Frederick | Maryland | 24021 | 1968 | 107 |
204168 | 204168 | 2020-06-03 | Frederick | Maryland | 24021 | 2012 | 109 |
207249 | 207249 | 2020-06-04 | Frederick | Maryland | 24021 | 2048 | 109 |
210330 | 210330 | 2020-06-05 | Frederick | Maryland | 24021 | 2076 | 110 |
213414 | 213414 | 2020-06-06 | Frederick | Maryland | 24021 | 2107 | 111 |
216502 | 216502 | 2020-06-07 | Frederick | Maryland | 24021 | 2121 | 111 |
219594 | 219594 | 2020-06-08 | Frederick | Maryland | 24021 | 2142 | 111 |
222689 | 222689 | 2020-06-09 | Frederick | Maryland | 24021 | 2159 | 111 |
225785 | 225785 | 2020-06-10 | Frederick | Maryland | 24021 | 2185 | 112 |
228887 | 228887 | 2020-06-11 | Frederick | Maryland | 24021 | 2209 | 112 |
231991 | 231991 | 2020-06-12 | Frederick | Maryland | 24021 | 2232 | 114 |
235096 | 235096 | 2020-06-13 | Frederick | Maryland | 24021 | 2258 | 114 |
238203 | 238203 | 2020-06-14 | Frederick | Maryland | 24021 | 2280 | 114 |
241312 | 241312 | 2020-06-15 | Frederick | Maryland | 24021 | 2305 | 114 |
244423 | 244423 | 2020-06-16 | Frederick | Maryland | 24021 | 2315 | 115 |
247536 | 247536 | 2020-06-17 | Frederick | Maryland | 24021 | 2343 | 115 |
250648 | 250648 | 2020-06-18 | Frederick | Maryland | 24021 | 2349 | 115 |
253763 | 253763 | 2020-06-19 | Frederick | Maryland | 24021 | 2368 | 116 |
256883 | 256883 | 2020-06-20 | Frederick | Maryland | 24021 | 2387 | 116 |
260009 | 260009 | 2020-06-21 | Frederick | Maryland | 24021 | 2400 | 116 |
263138 | 263138 | 2020-06-22 | Frederick | Maryland | 24021 | 2414 | 116 |
266264 | 266264 | 2020-06-23 | Frederick | Maryland | 24021 | 2426 | 116 |
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);