ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 50017 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3164 | 3164 | 2020-03-16 | Orange | Vermont | 50017 | 1 | 0 |
3700 | 3700 | 2020-03-17 | Orange | Vermont | 50017 | 1 | 0 |
4332 | 4332 | 2020-03-18 | Orange | Vermont | 50017 | 1 | 0 |
5088 | 5088 | 2020-03-19 | Orange | Vermont | 50017 | 2 | 0 |
5983 | 5983 | 2020-03-20 | Orange | Vermont | 50017 | 3 | 0 |
7007 | 7007 | 2020-03-21 | Orange | Vermont | 50017 | 3 | 0 |
8137 | 8137 | 2020-03-22 | Orange | Vermont | 50017 | 3 | 0 |
9357 | 9357 | 2020-03-23 | Orange | Vermont | 50017 | 3 | 0 |
10702 | 10702 | 2020-03-24 | Orange | Vermont | 50017 | 3 | 0 |
12214 | 12214 | 2020-03-25 | Orange | Vermont | 50017 | 3 | 0 |
13850 | 13850 | 2020-03-26 | Orange | Vermont | 50017 | 3 | 0 |
15616 | 15616 | 2020-03-27 | Orange | Vermont | 50017 | 3 | 0 |
17490 | 17490 | 2020-03-28 | Orange | Vermont | 50017 | 3 | 0 |
19449 | 19449 | 2020-03-29 | Orange | Vermont | 50017 | 3 | 0 |
21512 | 21512 | 2020-03-30 | Orange | Vermont | 50017 | 4 | 0 |
23651 | 23651 | 2020-03-31 | Orange | Vermont | 50017 | 4 | 0 |
25866 | 25866 | 2020-04-01 | Orange | Vermont | 50017 | 4 | 0 |
28155 | 28155 | 2020-04-02 | Orange | Vermont | 50017 | 4 | 0 |
30498 | 30498 | 2020-04-03 | Orange | Vermont | 50017 | 4 | 0 |
32896 | 32896 | 2020-04-04 | Orange | Vermont | 50017 | 4 | 0 |
35334 | 35334 | 2020-04-05 | Orange | Vermont | 50017 | 4 | 0 |
37812 | 37812 | 2020-04-06 | Orange | Vermont | 50017 | 4 | 0 |
40342 | 40342 | 2020-04-07 | Orange | Vermont | 50017 | 4 | 0 |
42911 | 42911 | 2020-04-08 | Orange | Vermont | 50017 | 5 | 0 |
45505 | 45505 | 2020-04-09 | Orange | Vermont | 50017 | 5 | 0 |
48129 | 48129 | 2020-04-10 | Orange | Vermont | 50017 | 5 | 0 |
50787 | 50787 | 2020-04-11 | Orange | Vermont | 50017 | 5 | 0 |
53462 | 53462 | 2020-04-12 | Orange | Vermont | 50017 | 5 | 0 |
56151 | 56151 | 2020-04-13 | Orange | Vermont | 50017 | 5 | 0 |
58857 | 58857 | 2020-04-14 | Orange | Vermont | 50017 | 5 | 0 |
61576 | 61576 | 2020-04-15 | Orange | Vermont | 50017 | 5 | 0 |
64308 | 64308 | 2020-04-16 | Orange | Vermont | 50017 | 5 | 0 |
67056 | 67056 | 2020-04-17 | Orange | Vermont | 50017 | 5 | 0 |
69818 | 69818 | 2020-04-18 | Orange | Vermont | 50017 | 5 | 0 |
72588 | 72588 | 2020-04-19 | Orange | Vermont | 50017 | 5 | 0 |
75364 | 75364 | 2020-04-20 | Orange | Vermont | 50017 | 5 | 0 |
78146 | 78146 | 2020-04-21 | Orange | Vermont | 50017 | 6 | 0 |
80938 | 80938 | 2020-04-22 | Orange | Vermont | 50017 | 6 | 0 |
83739 | 83739 | 2020-04-23 | Orange | Vermont | 50017 | 6 | 0 |
86546 | 86546 | 2020-04-24 | Orange | Vermont | 50017 | 6 | 0 |
89361 | 89361 | 2020-04-25 | Orange | Vermont | 50017 | 6 | 0 |
92178 | 92178 | 2020-04-26 | Orange | Vermont | 50017 | 6 | 0 |
95007 | 95007 | 2020-04-27 | Orange | Vermont | 50017 | 7 | 0 |
97849 | 97849 | 2020-04-28 | Orange | Vermont | 50017 | 7 | 0 |
100699 | 100699 | 2020-04-29 | Orange | Vermont | 50017 | 7 | 0 |
103554 | 103554 | 2020-04-30 | Orange | Vermont | 50017 | 7 | 0 |
106418 | 106418 | 2020-05-01 | Orange | Vermont | 50017 | 7 | 0 |
109287 | 109287 | 2020-05-02 | Orange | Vermont | 50017 | 7 | 0 |
112161 | 112161 | 2020-05-03 | Orange | Vermont | 50017 | 7 | 0 |
115044 | 115044 | 2020-05-04 | Orange | Vermont | 50017 | 8 | 0 |
118003 | 118003 | 2020-05-05 | Orange | Vermont | 50017 | 8 | 0 |
120967 | 120967 | 2020-05-06 | Orange | Vermont | 50017 | 8 | 0 |
123948 | 123948 | 2020-05-07 | Orange | Vermont | 50017 | 8 | 0 |
126933 | 126933 | 2020-05-08 | Orange | Vermont | 50017 | 8 | 0 |
129922 | 129922 | 2020-05-09 | Orange | Vermont | 50017 | 8 | 0 |
132912 | 132912 | 2020-05-10 | Orange | Vermont | 50017 | 8 | 0 |
135902 | 135902 | 2020-05-11 | Orange | Vermont | 50017 | 8 | 0 |
138893 | 138893 | 2020-05-12 | Orange | Vermont | 50017 | 8 | 0 |
141889 | 141889 | 2020-05-13 | Orange | Vermont | 50017 | 8 | 0 |
144886 | 144886 | 2020-05-14 | Orange | Vermont | 50017 | 8 | 0 |
147889 | 147889 | 2020-05-15 | Orange | Vermont | 50017 | 8 | 0 |
150898 | 150898 | 2020-05-16 | Orange | Vermont | 50017 | 8 | 0 |
153909 | 153909 | 2020-05-17 | Orange | Vermont | 50017 | 8 | 0 |
156926 | 156926 | 2020-05-18 | Orange | Vermont | 50017 | 8 | 0 |
159950 | 159950 | 2020-05-19 | Orange | Vermont | 50017 | 8 | 0 |
162978 | 162978 | 2020-05-20 | Orange | Vermont | 50017 | 8 | 0 |
166007 | 166007 | 2020-05-21 | Orange | Vermont | 50017 | 8 | 0 |
169043 | 169043 | 2020-05-22 | Orange | Vermont | 50017 | 8 | 0 |
172084 | 172084 | 2020-05-23 | Orange | Vermont | 50017 | 8 | 0 |
175127 | 175127 | 2020-05-24 | Orange | Vermont | 50017 | 8 | 0 |
178172 | 178172 | 2020-05-25 | Orange | Vermont | 50017 | 8 | 0 |
181216 | 181216 | 2020-05-26 | Orange | Vermont | 50017 | 8 | 0 |
184267 | 184267 | 2020-05-27 | Orange | Vermont | 50017 | 8 | 0 |
187324 | 187324 | 2020-05-28 | Orange | Vermont | 50017 | 8 | 0 |
190388 | 190388 | 2020-05-29 | Orange | Vermont | 50017 | 8 | 0 |
193454 | 193454 | 2020-05-30 | Orange | Vermont | 50017 | 8 | 0 |
196524 | 196524 | 2020-05-31 | Orange | Vermont | 50017 | 9 | 0 |
199597 | 199597 | 2020-06-01 | Orange | Vermont | 50017 | 9 | 0 |
202673 | 202673 | 2020-06-02 | Orange | Vermont | 50017 | 9 | 0 |
205752 | 205752 | 2020-06-03 | Orange | Vermont | 50017 | 9 | 0 |
208834 | 208834 | 2020-06-04 | Orange | Vermont | 50017 | 9 | 0 |
211919 | 211919 | 2020-06-05 | Orange | Vermont | 50017 | 9 | 0 |
215006 | 215006 | 2020-06-06 | Orange | Vermont | 50017 | 9 | 0 |
218096 | 218096 | 2020-06-07 | Orange | Vermont | 50017 | 9 | 0 |
221188 | 221188 | 2020-06-08 | Orange | Vermont | 50017 | 9 | 0 |
224284 | 224284 | 2020-06-09 | Orange | Vermont | 50017 | 9 | 0 |
227384 | 227384 | 2020-06-10 | Orange | Vermont | 50017 | 9 | 0 |
230488 | 230488 | 2020-06-11 | Orange | Vermont | 50017 | 9 | 0 |
233593 | 233593 | 2020-06-12 | Orange | Vermont | 50017 | 9 | 0 |
236700 | 236700 | 2020-06-13 | Orange | Vermont | 50017 | 9 | 0 |
239808 | 239808 | 2020-06-14 | Orange | Vermont | 50017 | 9 | 0 |
242919 | 242919 | 2020-06-15 | Orange | Vermont | 50017 | 9 | 0 |
246031 | 246031 | 2020-06-16 | Orange | Vermont | 50017 | 9 | 0 |
249143 | 249143 | 2020-06-17 | Orange | Vermont | 50017 | 9 | 0 |
252258 | 252258 | 2020-06-18 | Orange | Vermont | 50017 | 9 | 0 |
255376 | 255376 | 2020-06-19 | Orange | Vermont | 50017 | 9 | 0 |
258503 | 258503 | 2020-06-20 | Orange | Vermont | 50017 | 9 | 0 |
261630 | 261630 | 2020-06-21 | Orange | Vermont | 50017 | 9 | 0 |
264759 | 264759 | 2020-06-22 | Orange | Vermont | 50017 | 9 | 0 |
267888 | 267888 | 2020-06-23 | Orange | Vermont | 50017 | 9 | 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);