ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 25019 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
6515 | 6515 | 2020-03-21 | Nantucket | Massachusetts | 25019 | 1 | 0 |
7592 | 7592 | 2020-03-22 | Nantucket | Massachusetts | 25019 | 1 | 0 |
8764 | 8764 | 2020-03-23 | Nantucket | Massachusetts | 25019 | 1 | 0 |
10053 | 10053 | 2020-03-24 | Nantucket | Massachusetts | 25019 | 2 | 0 |
11465 | 11465 | 2020-03-25 | Nantucket | Massachusetts | 25019 | 2 | 0 |
13046 | 13046 | 2020-03-26 | Nantucket | Massachusetts | 25019 | 2 | 0 |
14754 | 14754 | 2020-03-27 | Nantucket | Massachusetts | 25019 | 2 | 0 |
16574 | 16574 | 2020-03-28 | Nantucket | Massachusetts | 25019 | 5 | 0 |
18489 | 18489 | 2020-03-29 | Nantucket | Massachusetts | 25019 | 5 | 0 |
20505 | 20505 | 2020-03-30 | Nantucket | Massachusetts | 25019 | 5 | 0 |
22614 | 22614 | 2020-03-31 | Nantucket | Massachusetts | 25019 | 5 | 0 |
24793 | 24793 | 2020-04-01 | Nantucket | Massachusetts | 25019 | 5 | 0 |
27045 | 27045 | 2020-04-02 | Nantucket | Massachusetts | 25019 | 7 | 0 |
29363 | 29363 | 2020-04-03 | Nantucket | Massachusetts | 25019 | 9 | 0 |
31741 | 31741 | 2020-04-04 | Nantucket | Massachusetts | 25019 | 9 | 0 |
34166 | 34166 | 2020-04-05 | Nantucket | Massachusetts | 25019 | 9 | 0 |
36625 | 36625 | 2020-04-06 | Nantucket | Massachusetts | 25019 | 9 | 0 |
39133 | 39133 | 2020-04-07 | Nantucket | Massachusetts | 25019 | 9 | 0 |
41685 | 41685 | 2020-04-08 | Nantucket | Massachusetts | 25019 | 9 | 0 |
44261 | 44261 | 2020-04-09 | Nantucket | Massachusetts | 25019 | 9 | 0 |
46869 | 46869 | 2020-04-10 | Nantucket | Massachusetts | 25019 | 9 | 0 |
49511 | 49511 | 2020-04-11 | Nantucket | Massachusetts | 25019 | 9 | 0 |
52181 | 52181 | 2020-04-12 | Nantucket | Massachusetts | 25019 | 9 | 0 |
54862 | 54862 | 2020-04-13 | Nantucket | Massachusetts | 25019 | 9 | 0 |
57560 | 57560 | 2020-04-14 | Nantucket | Massachusetts | 25019 | 9 | 0 |
60269 | 60269 | 2020-04-15 | Nantucket | Massachusetts | 25019 | 9 | 0 |
62990 | 62990 | 2020-04-16 | Nantucket | Massachusetts | 25019 | 9 | 0 |
65728 | 65728 | 2020-04-17 | Nantucket | Massachusetts | 25019 | 9 | 0 |
68478 | 68478 | 2020-04-18 | Nantucket | Massachusetts | 25019 | 9 | 0 |
71242 | 71242 | 2020-04-19 | Nantucket | Massachusetts | 25019 | 9 | 0 |
74014 | 74014 | 2020-04-20 | Nantucket | Massachusetts | 25019 | 9 | 0 |
76794 | 76794 | 2020-04-21 | Nantucket | Massachusetts | 25019 | 9 | 0 |
79580 | 79580 | 2020-04-22 | Nantucket | Massachusetts | 25019 | 9 | 0 |
82375 | 82375 | 2020-04-23 | Nantucket | Massachusetts | 25019 | 9 | 0 |
85179 | 85179 | 2020-04-24 | Nantucket | Massachusetts | 25019 | 9 | 0 |
87989 | 87989 | 2020-04-25 | Nantucket | Massachusetts | 25019 | 9 | 0 |
90805 | 90805 | 2020-04-26 | Nantucket | Massachusetts | 25019 | 10 | 0 |
93626 | 93626 | 2020-04-27 | Nantucket | Massachusetts | 25019 | 10 | 0 |
96461 | 96461 | 2020-04-28 | Nantucket | Massachusetts | 25019 | 11 | 0 |
99307 | 99307 | 2020-04-29 | Nantucket | Massachusetts | 25019 | 11 | 0 |
102159 | 102159 | 2020-04-30 | Nantucket | Massachusetts | 25019 | 11 | 0 |
105019 | 105019 | 2020-05-01 | Nantucket | Massachusetts | 25019 | 11 | 0 |
107883 | 107883 | 2020-05-02 | Nantucket | Massachusetts | 25019 | 11 | 0 |
110755 | 110755 | 2020-05-03 | Nantucket | Massachusetts | 25019 | 11 | 0 |
113633 | 113633 | 2020-05-04 | Nantucket | Massachusetts | 25019 | 11 | 0 |
116514 | 116514 | 2020-05-05 | Nantucket | Massachusetts | 25019 | 11 | 0 |
119475 | 119475 | 2020-05-06 | Nantucket | Massachusetts | 25019 | 12 | 0 |
122447 | 122447 | 2020-05-07 | Nantucket | Massachusetts | 25019 | 11 | 0 |
125429 | 125429 | 2020-05-08 | Nantucket | Massachusetts | 25019 | 11 | 0 |
128416 | 128416 | 2020-05-09 | Nantucket | Massachusetts | 25019 | 11 | 0 |
131406 | 131406 | 2020-05-10 | Nantucket | Massachusetts | 25019 | 11 | 0 |
134397 | 134397 | 2020-05-11 | Nantucket | Massachusetts | 25019 | 12 | 0 |
137387 | 137387 | 2020-05-12 | Nantucket | Massachusetts | 25019 | 12 | 0 |
140381 | 140381 | 2020-05-13 | Nantucket | Massachusetts | 25019 | 12 | 0 |
143376 | 143376 | 2020-05-14 | Nantucket | Massachusetts | 25019 | 12 | 0 |
146376 | 146376 | 2020-05-15 | Nantucket | Massachusetts | 25019 | 12 | 0 |
149381 | 149381 | 2020-05-16 | Nantucket | Massachusetts | 25019 | 12 | 0 |
152392 | 152392 | 2020-05-17 | Nantucket | Massachusetts | 25019 | 12 | 0 |
155406 | 155406 | 2020-05-18 | Nantucket | Massachusetts | 25019 | 12 | 0 |
158424 | 158424 | 2020-05-19 | Nantucket | Massachusetts | 25019 | 12 | 0 |
161450 | 161450 | 2020-05-20 | Nantucket | Massachusetts | 25019 | 12 | 0 |
164479 | 164479 | 2020-05-21 | Nantucket | Massachusetts | 25019 | 13 | 0 |
167515 | 167515 | 2020-05-22 | Nantucket | Massachusetts | 25019 | 13 | 0 |
170552 | 170552 | 2020-05-23 | Nantucket | Massachusetts | 25019 | 13 | 0 |
173594 | 173594 | 2020-05-24 | Nantucket | Massachusetts | 25019 | 13 | 0 |
176637 | 176637 | 2020-05-25 | Nantucket | Massachusetts | 25019 | 13 | 0 |
179681 | 179681 | 2020-05-26 | Nantucket | Massachusetts | 25019 | 13 | 0 |
182727 | 182727 | 2020-05-27 | Nantucket | Massachusetts | 25019 | 13 | 0 |
185782 | 185782 | 2020-05-28 | Nantucket | Massachusetts | 25019 | 13 | 0 |
188840 | 188840 | 2020-05-29 | Nantucket | Massachusetts | 25019 | 13 | 0 |
191904 | 191904 | 2020-05-30 | Nantucket | Massachusetts | 25019 | 13 | 0 |
194972 | 194972 | 2020-05-31 | Nantucket | Massachusetts | 25019 | 13 | 0 |
198043 | 198043 | 2020-06-01 | Nantucket | Massachusetts | 25019 | 13 | 0 |
201115 | 201115 | 2020-06-02 | Nantucket | Massachusetts | 25019 | 13 | 0 |
204192 | 204192 | 2020-06-03 | Nantucket | Massachusetts | 25019 | 13 | 0 |
207273 | 207273 | 2020-06-04 | Nantucket | Massachusetts | 25019 | 14 | 0 |
210354 | 210354 | 2020-06-05 | Nantucket | Massachusetts | 25019 | 14 | 0 |
213438 | 213438 | 2020-06-06 | Nantucket | Massachusetts | 25019 | 13 | 0 |
216526 | 216526 | 2020-06-07 | Nantucket | Massachusetts | 25019 | 13 | 0 |
219618 | 219618 | 2020-06-08 | Nantucket | Massachusetts | 25019 | 13 | 0 |
222713 | 222713 | 2020-06-09 | Nantucket | Massachusetts | 25019 | 13 | 0 |
225809 | 225809 | 2020-06-10 | Nantucket | Massachusetts | 25019 | 13 | 0 |
228911 | 228911 | 2020-06-11 | Nantucket | Massachusetts | 25019 | 13 | 0 |
232015 | 232015 | 2020-06-12 | Nantucket | Massachusetts | 25019 | 13 | 0 |
235120 | 235120 | 2020-06-13 | Nantucket | Massachusetts | 25019 | 13 | 0 |
238227 | 238227 | 2020-06-14 | Nantucket | Massachusetts | 25019 | 13 | 0 |
241336 | 241336 | 2020-06-15 | Nantucket | Massachusetts | 25019 | 13 | 0 |
244447 | 244447 | 2020-06-16 | Nantucket | Massachusetts | 25019 | 14 | 0 |
247560 | 247560 | 2020-06-17 | Nantucket | Massachusetts | 25019 | 13 | 0 |
250672 | 250672 | 2020-06-18 | Nantucket | Massachusetts | 25019 | 13 | 0 |
253787 | 253787 | 2020-06-19 | Nantucket | Massachusetts | 25019 | 13 | 0 |
256907 | 256907 | 2020-06-20 | Nantucket | Massachusetts | 25019 | 13 | 0 |
260033 | 260033 | 2020-06-21 | Nantucket | Massachusetts | 25019 | 13 | 0 |
263162 | 263162 | 2020-06-22 | Nantucket | Massachusetts | 25019 | 14 | 0 |
266288 | 266288 | 2020-06-23 | Nantucket | Massachusetts | 25019 | 14 | 0 |
269421 | 269421 | 2020-06-24 | Nantucket | Massachusetts | 25019 | 14 | 0 |
272558 | 272558 | 2020-06-25 | Nantucket | Massachusetts | 25019 | 14 | 0 |
275701 | 275701 | 2020-06-26 | Nantucket | Massachusetts | 25019 | 14 | 0 |
278849 | 278849 | 2020-06-27 | Nantucket | Massachusetts | 25019 | 15 | 0 |
281997 | 281997 | 2020-06-28 | Nantucket | Massachusetts | 25019 | 15 | 1 |
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);