ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 23001 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 |
---|---|---|---|---|---|---|---|
1467 | 1467 | 2020-03-12 | Androscoggin | Maine | 23001 | 1 | 0 |
1743 | 1743 | 2020-03-13 | Androscoggin | Maine | 23001 | 1 | 0 |
2083 | 2083 | 2020-03-14 | Androscoggin | Maine | 23001 | 1 | 0 |
2481 | 2481 | 2020-03-15 | Androscoggin | Maine | 23001 | 1 | 0 |
2927 | 2927 | 2020-03-16 | Androscoggin | Maine | 23001 | 1 | 0 |
3425 | 3425 | 2020-03-17 | Androscoggin | Maine | 23001 | 3 | 0 |
4006 | 4006 | 2020-03-18 | Androscoggin | Maine | 23001 | 3 | 0 |
4708 | 4708 | 2020-03-19 | Androscoggin | Maine | 23001 | 3 | 0 |
5526 | 5526 | 2020-03-20 | Androscoggin | Maine | 23001 | 3 | 0 |
6481 | 6481 | 2020-03-21 | Androscoggin | Maine | 23001 | 3 | 0 |
7556 | 7556 | 2020-03-22 | Androscoggin | Maine | 23001 | 3 | 0 |
8725 | 8725 | 2020-03-23 | Androscoggin | Maine | 23001 | 3 | 0 |
10014 | 10014 | 2020-03-24 | Androscoggin | Maine | 23001 | 3 | 0 |
11423 | 11423 | 2020-03-25 | Androscoggin | Maine | 23001 | 4 | 0 |
13003 | 13003 | 2020-03-26 | Androscoggin | Maine | 23001 | 5 | 0 |
14711 | 14711 | 2020-03-27 | Androscoggin | Maine | 23001 | 6 | 0 |
16531 | 16531 | 2020-03-28 | Androscoggin | Maine | 23001 | 7 | 0 |
18445 | 18445 | 2020-03-29 | Androscoggin | Maine | 23001 | 8 | 0 |
20461 | 20461 | 2020-03-30 | Androscoggin | Maine | 23001 | 8 | 0 |
22570 | 22570 | 2020-03-31 | Androscoggin | Maine | 23001 | 11 | 0 |
24746 | 24746 | 2020-04-01 | Androscoggin | Maine | 23001 | 12 | 0 |
26997 | 26997 | 2020-04-02 | Androscoggin | Maine | 23001 | 12 | 0 |
29314 | 29314 | 2020-04-03 | Androscoggin | Maine | 23001 | 19 | 0 |
31692 | 31692 | 2020-04-04 | Androscoggin | Maine | 23001 | 20 | 0 |
34117 | 34117 | 2020-04-05 | Androscoggin | Maine | 23001 | 20 | 0 |
36576 | 36576 | 2020-04-06 | Androscoggin | Maine | 23001 | 23 | 0 |
39084 | 39084 | 2020-04-07 | Androscoggin | Maine | 23001 | 23 | 0 |
41636 | 41636 | 2020-04-08 | Androscoggin | Maine | 23001 | 23 | 0 |
44212 | 44212 | 2020-04-09 | Androscoggin | Maine | 23001 | 24 | 0 |
46820 | 46820 | 2020-04-10 | Androscoggin | Maine | 23001 | 24 | 0 |
49462 | 49462 | 2020-04-11 | Androscoggin | Maine | 23001 | 27 | 0 |
52132 | 52132 | 2020-04-12 | Androscoggin | Maine | 23001 | 28 | 0 |
54813 | 54813 | 2020-04-13 | Androscoggin | Maine | 23001 | 28 | 0 |
57511 | 57511 | 2020-04-14 | Androscoggin | Maine | 23001 | 29 | 0 |
60219 | 60219 | 2020-04-15 | Androscoggin | Maine | 23001 | 31 | 1 |
62940 | 62940 | 2020-04-16 | Androscoggin | Maine | 23001 | 32 | 1 |
65679 | 65679 | 2020-04-17 | Androscoggin | Maine | 23001 | 32 | 1 |
68428 | 68428 | 2020-04-18 | Androscoggin | Maine | 23001 | 35 | 1 |
71191 | 71191 | 2020-04-19 | Androscoggin | Maine | 23001 | 35 | 1 |
73963 | 73963 | 2020-04-20 | Androscoggin | Maine | 23001 | 35 | 1 |
76743 | 76743 | 2020-04-21 | Androscoggin | Maine | 23001 | 36 | 1 |
79529 | 79529 | 2020-04-22 | Androscoggin | Maine | 23001 | 36 | 1 |
82325 | 82325 | 2020-04-23 | Androscoggin | Maine | 23001 | 37 | 1 |
85129 | 85129 | 2020-04-24 | Androscoggin | Maine | 23001 | 38 | 1 |
87938 | 87938 | 2020-04-25 | Androscoggin | Maine | 23001 | 41 | 2 |
90754 | 90754 | 2020-04-26 | Androscoggin | Maine | 23001 | 42 | 2 |
93575 | 93575 | 2020-04-27 | Androscoggin | Maine | 23001 | 42 | 2 |
96410 | 96410 | 2020-04-28 | Androscoggin | Maine | 23001 | 42 | 2 |
99256 | 99256 | 2020-04-29 | Androscoggin | Maine | 23001 | 43 | 2 |
102108 | 102108 | 2020-04-30 | Androscoggin | Maine | 23001 | 48 | 2 |
104969 | 104969 | 2020-05-01 | Androscoggin | Maine | 23001 | 52 | 2 |
107833 | 107833 | 2020-05-02 | Androscoggin | Maine | 23001 | 54 | 2 |
110705 | 110705 | 2020-05-03 | Androscoggin | Maine | 23001 | 56 | 2 |
113582 | 113582 | 2020-05-04 | Androscoggin | Maine | 23001 | 60 | 2 |
116464 | 116464 | 2020-05-05 | Androscoggin | Maine | 23001 | 62 | 2 |
119425 | 119425 | 2020-05-06 | Androscoggin | Maine | 23001 | 67 | 2 |
122396 | 122396 | 2020-05-07 | Androscoggin | Maine | 23001 | 74 | 2 |
125378 | 125378 | 2020-05-08 | Androscoggin | Maine | 23001 | 78 | 2 |
128365 | 128365 | 2020-05-09 | Androscoggin | Maine | 23001 | 82 | 2 |
131355 | 131355 | 2020-05-10 | Androscoggin | Maine | 23001 | 84 | 2 |
134346 | 134346 | 2020-05-11 | Androscoggin | Maine | 23001 | 92 | 2 |
137336 | 137336 | 2020-05-12 | Androscoggin | Maine | 23001 | 97 | 2 |
140330 | 140330 | 2020-05-13 | Androscoggin | Maine | 23001 | 103 | 2 |
143325 | 143325 | 2020-05-14 | Androscoggin | Maine | 23001 | 109 | 2 |
146325 | 146325 | 2020-05-15 | Androscoggin | Maine | 23001 | 113 | 2 |
149330 | 149330 | 2020-05-16 | Androscoggin | Maine | 23001 | 120 | 2 |
152341 | 152341 | 2020-05-17 | Androscoggin | Maine | 23001 | 131 | 2 |
155355 | 155355 | 2020-05-18 | Androscoggin | Maine | 23001 | 139 | 2 |
158373 | 158373 | 2020-05-19 | Androscoggin | Maine | 23001 | 151 | 2 |
161399 | 161399 | 2020-05-20 | Androscoggin | Maine | 23001 | 185 | 2 |
164428 | 164428 | 2020-05-21 | Androscoggin | Maine | 23001 | 202 | 2 |
167464 | 167464 | 2020-05-22 | Androscoggin | Maine | 23001 | 209 | 2 |
170502 | 170502 | 2020-05-23 | Androscoggin | Maine | 23001 | 227 | 2 |
173543 | 173543 | 2020-05-24 | Androscoggin | Maine | 23001 | 233 | 2 |
176587 | 176587 | 2020-05-25 | Androscoggin | Maine | 23001 | 238 | 2 |
179631 | 179631 | 2020-05-26 | Androscoggin | Maine | 23001 | 247 | 2 |
182676 | 182676 | 2020-05-27 | Androscoggin | Maine | 23001 | 252 | 2 |
185731 | 185731 | 2020-05-28 | Androscoggin | Maine | 23001 | 264 | 2 |
188789 | 188789 | 2020-05-29 | Androscoggin | Maine | 23001 | 269 | 2 |
191853 | 191853 | 2020-05-30 | Androscoggin | Maine | 23001 | 287 | 2 |
194921 | 194921 | 2020-05-31 | Androscoggin | Maine | 23001 | 298 | 2 |
197992 | 197992 | 2020-06-01 | Androscoggin | Maine | 23001 | 304 | 2 |
201064 | 201064 | 2020-06-02 | Androscoggin | Maine | 23001 | 314 | 2 |
204141 | 204141 | 2020-06-03 | Androscoggin | Maine | 23001 | 326 | 2 |
207222 | 207222 | 2020-06-04 | Androscoggin | Maine | 23001 | 334 | 2 |
210303 | 210303 | 2020-06-05 | Androscoggin | Maine | 23001 | 338 | 3 |
213388 | 213388 | 2020-06-06 | Androscoggin | Maine | 23001 | 346 | 3 |
216475 | 216475 | 2020-06-07 | Androscoggin | Maine | 23001 | 367 | 3 |
219567 | 219567 | 2020-06-08 | Androscoggin | Maine | 23001 | 376 | 3 |
222662 | 222662 | 2020-06-09 | Androscoggin | Maine | 23001 | 381 | 3 |
225758 | 225758 | 2020-06-10 | Androscoggin | Maine | 23001 | 390 | 3 |
228860 | 228860 | 2020-06-11 | Androscoggin | Maine | 23001 | 397 | 3 |
231964 | 231964 | 2020-06-12 | Androscoggin | Maine | 23001 | 415 | 3 |
235069 | 235069 | 2020-06-13 | Androscoggin | Maine | 23001 | 419 | 3 |
238176 | 238176 | 2020-06-14 | Androscoggin | Maine | 23001 | 425 | 3 |
244396 | 244396 | 2020-06-16 | Androscoggin | Maine | 23001 | 428 | 4 |
241285 | 241285 | 2020-06-15 | Androscoggin | Maine | 23001 | 429 | 4 |
247509 | 247509 | 2020-06-17 | Androscoggin | Maine | 23001 | 434 | 4 |
250621 | 250621 | 2020-06-18 | Androscoggin | Maine | 23001 | 441 | 4 |
253736 | 253736 | 2020-06-19 | Androscoggin | Maine | 23001 | 445 | 4 |
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);