ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 23017 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3429 | 3429 | 2020-03-17 | Oxford | Maine | 23017 | 1 | 0 |
4010 | 4010 | 2020-03-18 | Oxford | Maine | 23017 | 1 | 0 |
4712 | 4712 | 2020-03-19 | Oxford | Maine | 23017 | 1 | 0 |
5530 | 5530 | 2020-03-20 | Oxford | Maine | 23017 | 1 | 0 |
6485 | 6485 | 2020-03-21 | Oxford | Maine | 23017 | 4 | 0 |
7560 | 7560 | 2020-03-22 | Oxford | Maine | 23017 | 4 | 0 |
8730 | 8730 | 2020-03-23 | Oxford | Maine | 23017 | 5 | 0 |
10019 | 10019 | 2020-03-24 | Oxford | Maine | 23017 | 6 | 0 |
11428 | 11428 | 2020-03-25 | Oxford | Maine | 23017 | 6 | 0 |
13009 | 13009 | 2020-03-26 | Oxford | Maine | 23017 | 8 | 0 |
14717 | 14717 | 2020-03-27 | Oxford | Maine | 23017 | 8 | 0 |
16537 | 16537 | 2020-03-28 | Oxford | Maine | 23017 | 8 | 0 |
18451 | 18451 | 2020-03-29 | Oxford | Maine | 23017 | 9 | 0 |
20467 | 20467 | 2020-03-30 | Oxford | Maine | 23017 | 9 | 0 |
22576 | 22576 | 2020-03-31 | Oxford | Maine | 23017 | 9 | 0 |
24753 | 24753 | 2020-04-01 | Oxford | Maine | 23017 | 9 | 0 |
27004 | 27004 | 2020-04-02 | Oxford | Maine | 23017 | 9 | 0 |
29322 | 29322 | 2020-04-03 | Oxford | Maine | 23017 | 10 | 0 |
31700 | 31700 | 2020-04-04 | Oxford | Maine | 23017 | 11 | 0 |
34125 | 34125 | 2020-04-05 | Oxford | Maine | 23017 | 11 | 0 |
36584 | 36584 | 2020-04-06 | Oxford | Maine | 23017 | 11 | 0 |
39092 | 39092 | 2020-04-07 | Oxford | Maine | 23017 | 12 | 0 |
41644 | 41644 | 2020-04-08 | Oxford | Maine | 23017 | 12 | 0 |
44220 | 44220 | 2020-04-09 | Oxford | Maine | 23017 | 12 | 0 |
46828 | 46828 | 2020-04-10 | Oxford | Maine | 23017 | 12 | 0 |
49470 | 49470 | 2020-04-11 | Oxford | Maine | 23017 | 13 | 0 |
52140 | 52140 | 2020-04-12 | Oxford | Maine | 23017 | 13 | 0 |
54821 | 54821 | 2020-04-13 | Oxford | Maine | 23017 | 13 | 0 |
57519 | 57519 | 2020-04-14 | Oxford | Maine | 23017 | 13 | 0 |
60227 | 60227 | 2020-04-15 | Oxford | Maine | 23017 | 13 | 0 |
62948 | 62948 | 2020-04-16 | Oxford | Maine | 23017 | 13 | 0 |
65687 | 65687 | 2020-04-17 | Oxford | Maine | 23017 | 13 | 0 |
68436 | 68436 | 2020-04-18 | Oxford | Maine | 23017 | 13 | 0 |
71199 | 71199 | 2020-04-19 | Oxford | Maine | 23017 | 14 | 0 |
73971 | 73971 | 2020-04-20 | Oxford | Maine | 23017 | 14 | 0 |
76751 | 76751 | 2020-04-21 | Oxford | Maine | 23017 | 14 | 0 |
79537 | 79537 | 2020-04-22 | Oxford | Maine | 23017 | 14 | 0 |
82333 | 82333 | 2020-04-23 | Oxford | Maine | 23017 | 14 | 0 |
85137 | 85137 | 2020-04-24 | Oxford | Maine | 23017 | 14 | 0 |
87946 | 87946 | 2020-04-25 | Oxford | Maine | 23017 | 15 | 0 |
90762 | 90762 | 2020-04-26 | Oxford | Maine | 23017 | 15 | 0 |
93583 | 93583 | 2020-04-27 | Oxford | Maine | 23017 | 15 | 0 |
96418 | 96418 | 2020-04-28 | Oxford | Maine | 23017 | 15 | 0 |
99264 | 99264 | 2020-04-29 | Oxford | Maine | 23017 | 15 | 0 |
102116 | 102116 | 2020-04-30 | Oxford | Maine | 23017 | 15 | 0 |
104977 | 104977 | 2020-05-01 | Oxford | Maine | 23017 | 15 | 0 |
107841 | 107841 | 2020-05-02 | Oxford | Maine | 23017 | 15 | 0 |
110713 | 110713 | 2020-05-03 | Oxford | Maine | 23017 | 15 | 0 |
113590 | 113590 | 2020-05-04 | Oxford | Maine | 23017 | 15 | 0 |
116472 | 116472 | 2020-05-05 | Oxford | Maine | 23017 | 15 | 0 |
119433 | 119433 | 2020-05-06 | Oxford | Maine | 23017 | 16 | 0 |
122404 | 122404 | 2020-05-07 | Oxford | Maine | 23017 | 17 | 0 |
125386 | 125386 | 2020-05-08 | Oxford | Maine | 23017 | 17 | 0 |
128373 | 128373 | 2020-05-09 | Oxford | Maine | 23017 | 17 | 0 |
131363 | 131363 | 2020-05-10 | Oxford | Maine | 23017 | 17 | 0 |
134354 | 134354 | 2020-05-11 | Oxford | Maine | 23017 | 17 | 0 |
137344 | 137344 | 2020-05-12 | Oxford | Maine | 23017 | 17 | 0 |
140338 | 140338 | 2020-05-13 | Oxford | Maine | 23017 | 17 | 0 |
143333 | 143333 | 2020-05-14 | Oxford | Maine | 23017 | 17 | 0 |
146333 | 146333 | 2020-05-15 | Oxford | Maine | 23017 | 17 | 0 |
149338 | 149338 | 2020-05-16 | Oxford | Maine | 23017 | 17 | 0 |
152349 | 152349 | 2020-05-17 | Oxford | Maine | 23017 | 17 | 0 |
155363 | 155363 | 2020-05-18 | Oxford | Maine | 23017 | 17 | 0 |
158381 | 158381 | 2020-05-19 | Oxford | Maine | 23017 | 17 | 0 |
161407 | 161407 | 2020-05-20 | Oxford | Maine | 23017 | 18 | 0 |
164436 | 164436 | 2020-05-21 | Oxford | Maine | 23017 | 18 | 0 |
167472 | 167472 | 2020-05-22 | Oxford | Maine | 23017 | 19 | 0 |
170510 | 170510 | 2020-05-23 | Oxford | Maine | 23017 | 19 | 0 |
173551 | 173551 | 2020-05-24 | Oxford | Maine | 23017 | 21 | 0 |
176595 | 176595 | 2020-05-25 | Oxford | Maine | 23017 | 21 | 0 |
179639 | 179639 | 2020-05-26 | Oxford | Maine | 23017 | 22 | 0 |
182684 | 182684 | 2020-05-27 | Oxford | Maine | 23017 | 26 | 0 |
185739 | 185739 | 2020-05-28 | Oxford | Maine | 23017 | 29 | 0 |
188797 | 188797 | 2020-05-29 | Oxford | Maine | 23017 | 32 | 0 |
191861 | 191861 | 2020-05-30 | Oxford | Maine | 23017 | 33 | 0 |
194929 | 194929 | 2020-05-31 | Oxford | Maine | 23017 | 34 | 0 |
198000 | 198000 | 2020-06-01 | Oxford | Maine | 23017 | 33 | 0 |
201072 | 201072 | 2020-06-02 | Oxford | Maine | 23017 | 33 | 0 |
204149 | 204149 | 2020-06-03 | Oxford | Maine | 23017 | 33 | 0 |
207230 | 207230 | 2020-06-04 | Oxford | Maine | 23017 | 32 | 0 |
210311 | 210311 | 2020-06-05 | Oxford | Maine | 23017 | 32 | 0 |
213396 | 213396 | 2020-06-06 | Oxford | Maine | 23017 | 32 | 0 |
216483 | 216483 | 2020-06-07 | Oxford | Maine | 23017 | 31 | 0 |
219575 | 219575 | 2020-06-08 | Oxford | Maine | 23017 | 31 | 0 |
222670 | 222670 | 2020-06-09 | Oxford | Maine | 23017 | 31 | 0 |
225766 | 225766 | 2020-06-10 | Oxford | Maine | 23017 | 31 | 0 |
228868 | 228868 | 2020-06-11 | Oxford | Maine | 23017 | 31 | 0 |
231972 | 231972 | 2020-06-12 | Oxford | Maine | 23017 | 31 | 0 |
235077 | 235077 | 2020-06-13 | Oxford | Maine | 23017 | 31 | 0 |
238184 | 238184 | 2020-06-14 | Oxford | Maine | 23017 | 33 | 0 |
241293 | 241293 | 2020-06-15 | Oxford | Maine | 23017 | 34 | 0 |
244404 | 244404 | 2020-06-16 | Oxford | Maine | 23017 | 34 | 0 |
247517 | 247517 | 2020-06-17 | Oxford | Maine | 23017 | 34 | 0 |
250629 | 250629 | 2020-06-18 | Oxford | Maine | 23017 | 33 | 0 |
253744 | 253744 | 2020-06-19 | Oxford | Maine | 23017 | 34 | 0 |
256864 | 256864 | 2020-06-20 | Oxford | Maine | 23017 | 34 | 0 |
259990 | 259990 | 2020-06-21 | Oxford | Maine | 23017 | 34 | 0 |
263119 | 263119 | 2020-06-22 | Oxford | Maine | 23017 | 34 | 0 |
266246 | 266246 | 2020-06-23 | Oxford | Maine | 23017 | 34 | 0 |
269379 | 269379 | 2020-06-24 | Oxford | Maine | 23017 | 35 | 0 |
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);