ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 23027 and state = "Maine" 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 |
---|---|---|---|---|---|---|---|
10022 | 10022 | 2020-03-24 | Waldo | Maine | 23027 | 1 | 0 |
11432 | 11432 | 2020-03-25 | Waldo | Maine | 23027 | 1 | 0 |
13013 | 13013 | 2020-03-26 | Waldo | Maine | 23027 | 2 | 0 |
14721 | 14721 | 2020-03-27 | Waldo | Maine | 23027 | 2 | 0 |
16541 | 16541 | 2020-03-28 | Waldo | Maine | 23027 | 2 | 0 |
18456 | 18456 | 2020-03-29 | Waldo | Maine | 23027 | 2 | 0 |
20472 | 20472 | 2020-03-30 | Waldo | Maine | 23027 | 2 | 0 |
22581 | 22581 | 2020-03-31 | Waldo | Maine | 23027 | 2 | 0 |
24758 | 24758 | 2020-04-01 | Waldo | Maine | 23027 | 2 | 0 |
27009 | 27009 | 2020-04-02 | Waldo | Maine | 23027 | 2 | 0 |
29327 | 29327 | 2020-04-03 | Waldo | Maine | 23027 | 3 | 0 |
31705 | 31705 | 2020-04-04 | Waldo | Maine | 23027 | 3 | 0 |
34130 | 34130 | 2020-04-05 | Waldo | Maine | 23027 | 3 | 0 |
36589 | 36589 | 2020-04-06 | Waldo | Maine | 23027 | 5 | 0 |
39097 | 39097 | 2020-04-07 | Waldo | Maine | 23027 | 5 | 0 |
41649 | 41649 | 2020-04-08 | Waldo | Maine | 23027 | 7 | 1 |
44225 | 44225 | 2020-04-09 | Waldo | Maine | 23027 | 11 | 2 |
46833 | 46833 | 2020-04-10 | Waldo | Maine | 23027 | 19 | 2 |
49475 | 49475 | 2020-04-11 | Waldo | Maine | 23027 | 27 | 2 |
52145 | 52145 | 2020-04-12 | Waldo | Maine | 23027 | 29 | 2 |
54826 | 54826 | 2020-04-13 | Waldo | Maine | 23027 | 29 | 2 |
57524 | 57524 | 2020-04-14 | Waldo | Maine | 23027 | 29 | 2 |
60232 | 60232 | 2020-04-15 | Waldo | Maine | 23027 | 30 | 2 |
62953 | 62953 | 2020-04-16 | Waldo | Maine | 23027 | 39 | 3 |
65691 | 65691 | 2020-04-17 | Waldo | Maine | 23027 | 42 | 5 |
68441 | 68441 | 2020-04-18 | Waldo | Maine | 23027 | 42 | 7 |
71205 | 71205 | 2020-04-19 | Waldo | Maine | 23027 | 42 | 7 |
73977 | 73977 | 2020-04-20 | Waldo | Maine | 23027 | 43 | 8 |
76757 | 76757 | 2020-04-21 | Waldo | Maine | 23027 | 43 | 8 |
79543 | 79543 | 2020-04-22 | Waldo | Maine | 23027 | 45 | 10 |
82338 | 82338 | 2020-04-23 | Waldo | Maine | 23027 | 47 | 10 |
85142 | 85142 | 2020-04-24 | Waldo | Maine | 23027 | 47 | 10 |
87952 | 87952 | 2020-04-25 | Waldo | Maine | 23027 | 48 | 11 |
90768 | 90768 | 2020-04-26 | Waldo | Maine | 23027 | 48 | 11 |
93589 | 93589 | 2020-04-27 | Waldo | Maine | 23027 | 48 | 11 |
96424 | 96424 | 2020-04-28 | Waldo | Maine | 23027 | 48 | 11 |
99270 | 99270 | 2020-04-29 | Waldo | Maine | 23027 | 48 | 11 |
102122 | 102122 | 2020-04-30 | Waldo | Maine | 23027 | 48 | 11 |
104982 | 104982 | 2020-05-01 | Waldo | Maine | 23027 | 49 | 12 |
107846 | 107846 | 2020-05-02 | Waldo | Maine | 23027 | 49 | 13 |
110718 | 110718 | 2020-05-03 | Waldo | Maine | 23027 | 49 | 13 |
113596 | 113596 | 2020-05-04 | Waldo | Maine | 23027 | 49 | 13 |
116477 | 116477 | 2020-05-05 | Waldo | Maine | 23027 | 49 | 13 |
119438 | 119438 | 2020-05-06 | Waldo | Maine | 23027 | 49 | 13 |
122410 | 122410 | 2020-05-07 | Waldo | Maine | 23027 | 49 | 13 |
125392 | 125392 | 2020-05-08 | Waldo | Maine | 23027 | 49 | 13 |
128379 | 128379 | 2020-05-09 | Waldo | Maine | 23027 | 49 | 14 |
131369 | 131369 | 2020-05-10 | Waldo | Maine | 23027 | 49 | 14 |
134360 | 134360 | 2020-05-11 | Waldo | Maine | 23027 | 49 | 14 |
137350 | 137350 | 2020-05-12 | Waldo | Maine | 23027 | 49 | 14 |
140344 | 140344 | 2020-05-13 | Waldo | Maine | 23027 | 49 | 14 |
143339 | 143339 | 2020-05-14 | Waldo | Maine | 23027 | 50 | 14 |
146339 | 146339 | 2020-05-15 | Waldo | Maine | 23027 | 50 | 14 |
149344 | 149344 | 2020-05-16 | Waldo | Maine | 23027 | 50 | 14 |
152355 | 152355 | 2020-05-17 | Waldo | Maine | 23027 | 50 | 14 |
155369 | 155369 | 2020-05-18 | Waldo | Maine | 23027 | 50 | 14 |
158387 | 158387 | 2020-05-19 | Waldo | Maine | 23027 | 50 | 14 |
161413 | 161413 | 2020-05-20 | Waldo | Maine | 23027 | 50 | 14 |
164442 | 164442 | 2020-05-21 | Waldo | Maine | 23027 | 51 | 14 |
167478 | 167478 | 2020-05-22 | Waldo | Maine | 23027 | 51 | 14 |
170515 | 170515 | 2020-05-23 | Waldo | Maine | 23027 | 51 | 14 |
173557 | 173557 | 2020-05-24 | Waldo | Maine | 23027 | 51 | 14 |
176600 | 176600 | 2020-05-25 | Waldo | Maine | 23027 | 51 | 14 |
179644 | 179644 | 2020-05-26 | Waldo | Maine | 23027 | 51 | 14 |
182690 | 182690 | 2020-05-27 | Waldo | Maine | 23027 | 51 | 14 |
185745 | 185745 | 2020-05-28 | Waldo | Maine | 23027 | 51 | 14 |
188803 | 188803 | 2020-05-29 | Waldo | Maine | 23027 | 51 | 14 |
191867 | 191867 | 2020-05-30 | Waldo | Maine | 23027 | 51 | 14 |
194935 | 194935 | 2020-05-31 | Waldo | Maine | 23027 | 51 | 14 |
198006 | 198006 | 2020-06-01 | Waldo | Maine | 23027 | 51 | 14 |
201078 | 201078 | 2020-06-02 | Waldo | Maine | 23027 | 51 | 14 |
204155 | 204155 | 2020-06-03 | Waldo | Maine | 23027 | 51 | 14 |
207236 | 207236 | 2020-06-04 | Waldo | Maine | 23027 | 51 | 14 |
210317 | 210317 | 2020-06-05 | Waldo | Maine | 23027 | 52 | 14 |
213401 | 213401 | 2020-06-06 | Waldo | Maine | 23027 | 52 | 14 |
216489 | 216489 | 2020-06-07 | Waldo | Maine | 23027 | 52 | 14 |
219581 | 219581 | 2020-06-08 | Waldo | Maine | 23027 | 53 | 14 |
222676 | 222676 | 2020-06-09 | Waldo | Maine | 23027 | 53 | 14 |
225772 | 225772 | 2020-06-10 | Waldo | Maine | 23027 | 54 | 14 |
228874 | 228874 | 2020-06-11 | Waldo | Maine | 23027 | 55 | 14 |
231978 | 231978 | 2020-06-12 | Waldo | Maine | 23027 | 55 | 14 |
235083 | 235083 | 2020-06-13 | Waldo | Maine | 23027 | 55 | 14 |
238190 | 238190 | 2020-06-14 | Waldo | Maine | 23027 | 55 | 14 |
241299 | 241299 | 2020-06-15 | Waldo | Maine | 23027 | 55 | 14 |
244410 | 244410 | 2020-06-16 | Waldo | Maine | 23027 | 55 | 14 |
247523 | 247523 | 2020-06-17 | Waldo | Maine | 23027 | 55 | 14 |
250635 | 250635 | 2020-06-18 | Waldo | Maine | 23027 | 55 | 14 |
253750 | 253750 | 2020-06-19 | Waldo | Maine | 23027 | 55 | 14 |
256870 | 256870 | 2020-06-20 | Waldo | Maine | 23027 | 55 | 14 |
259996 | 259996 | 2020-06-21 | Waldo | Maine | 23027 | 55 | 14 |
263125 | 263125 | 2020-06-22 | Waldo | Maine | 23027 | 55 | 14 |
266251 | 266251 | 2020-06-23 | Waldo | Maine | 23027 | 55 | 14 |
269384 | 269384 | 2020-06-24 | Waldo | Maine | 23027 | 55 | 14 |
272521 | 272521 | 2020-06-25 | Waldo | Maine | 23027 | 55 | 14 |
275664 | 275664 | 2020-06-26 | Waldo | Maine | 23027 | 55 | 14 |
278812 | 278812 | 2020-06-27 | Waldo | Maine | 23027 | 55 | 14 |
281960 | 281960 | 2020-06-28 | Waldo | Maine | 23027 | 55 | 14 |
285105 | 285105 | 2020-06-29 | Waldo | Maine | 23027 | 55 | 14 |
288255 | 288255 | 2020-06-30 | Waldo | Maine | 23027 | 55 | 14 |
291406 | 291406 | 2020-07-01 | Waldo | Maine | 23027 | 56 | 14 |
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);