ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Franklin" and fips = 50011 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
7006 | 7006 | 2020-03-21 | Franklin | Vermont | 50011 | 2 | 0 |
8136 | 8136 | 2020-03-22 | Franklin | Vermont | 50011 | 2 | 0 |
9356 | 9356 | 2020-03-23 | Franklin | Vermont | 50011 | 2 | 0 |
10701 | 10701 | 2020-03-24 | Franklin | Vermont | 50011 | 2 | 0 |
12212 | 12212 | 2020-03-25 | Franklin | Vermont | 50011 | 3 | 0 |
13848 | 13848 | 2020-03-26 | Franklin | Vermont | 50011 | 4 | 0 |
15614 | 15614 | 2020-03-27 | Franklin | Vermont | 50011 | 6 | 0 |
17488 | 17488 | 2020-03-28 | Franklin | Vermont | 50011 | 7 | 0 |
19447 | 19447 | 2020-03-29 | Franklin | Vermont | 50011 | 9 | 0 |
21510 | 21510 | 2020-03-30 | Franklin | Vermont | 50011 | 11 | 0 |
23649 | 23649 | 2020-03-31 | Franklin | Vermont | 50011 | 13 | 0 |
25864 | 25864 | 2020-04-01 | Franklin | Vermont | 50011 | 15 | 0 |
28153 | 28153 | 2020-04-02 | Franklin | Vermont | 50011 | 16 | 0 |
30496 | 30496 | 2020-04-03 | Franklin | Vermont | 50011 | 21 | 0 |
32894 | 32894 | 2020-04-04 | Franklin | Vermont | 50011 | 23 | 0 |
35332 | 35332 | 2020-04-05 | Franklin | Vermont | 50011 | 27 | 0 |
37810 | 37810 | 2020-04-06 | Franklin | Vermont | 50011 | 29 | 0 |
40339 | 40339 | 2020-04-07 | Franklin | Vermont | 50011 | 33 | 0 |
42908 | 42908 | 2020-04-08 | Franklin | Vermont | 50011 | 33 | 3 |
45502 | 45502 | 2020-04-09 | Franklin | Vermont | 50011 | 35 | 3 |
48126 | 48126 | 2020-04-10 | Franklin | Vermont | 50011 | 68 | 3 |
50784 | 50784 | 2020-04-11 | Franklin | Vermont | 50011 | 80 | 3 |
53459 | 53459 | 2020-04-12 | Franklin | Vermont | 50011 | 81 | 3 |
56148 | 56148 | 2020-04-13 | Franklin | Vermont | 50011 | 83 | 3 |
58854 | 58854 | 2020-04-14 | Franklin | Vermont | 50011 | 84 | 3 |
61573 | 61573 | 2020-04-15 | Franklin | Vermont | 50011 | 84 | 3 |
64305 | 64305 | 2020-04-16 | Franklin | Vermont | 50011 | 86 | 3 |
67053 | 67053 | 2020-04-17 | Franklin | Vermont | 50011 | 88 | 3 |
69815 | 69815 | 2020-04-18 | Franklin | Vermont | 50011 | 90 | 3 |
72585 | 72585 | 2020-04-19 | Franklin | Vermont | 50011 | 91 | 3 |
75361 | 75361 | 2020-04-20 | Franklin | Vermont | 50011 | 93 | 3 |
78143 | 78143 | 2020-04-21 | Franklin | Vermont | 50011 | 92 | 4 |
80935 | 80935 | 2020-04-22 | Franklin | Vermont | 50011 | 92 | 4 |
83736 | 83736 | 2020-04-23 | Franklin | Vermont | 50011 | 90 | 5 |
86543 | 86543 | 2020-04-24 | Franklin | Vermont | 50011 | 90 | 5 |
89358 | 89358 | 2020-04-25 | Franklin | Vermont | 50011 | 90 | 5 |
92175 | 92175 | 2020-04-26 | Franklin | Vermont | 50011 | 91 | 5 |
95004 | 95004 | 2020-04-27 | Franklin | Vermont | 50011 | 91 | 5 |
97846 | 97846 | 2020-04-28 | Franklin | Vermont | 50011 | 91 | 5 |
100696 | 100696 | 2020-04-29 | Franklin | Vermont | 50011 | 91 | 5 |
103551 | 103551 | 2020-04-30 | Franklin | Vermont | 50011 | 91 | 5 |
106415 | 106415 | 2020-05-01 | Franklin | Vermont | 50011 | 98 | 5 |
109284 | 109284 | 2020-05-02 | Franklin | Vermont | 50011 | 98 | 5 |
112158 | 112158 | 2020-05-03 | Franklin | Vermont | 50011 | 99 | 5 |
115041 | 115041 | 2020-05-04 | Franklin | Vermont | 50011 | 99 | 5 |
118000 | 118000 | 2020-05-05 | Franklin | Vermont | 50011 | 99 | 5 |
120964 | 120964 | 2020-05-06 | Franklin | Vermont | 50011 | 99 | 5 |
123945 | 123945 | 2020-05-07 | Franklin | Vermont | 50011 | 99 | 5 |
126930 | 126930 | 2020-05-08 | Franklin | Vermont | 50011 | 99 | 5 |
129919 | 129919 | 2020-05-09 | Franklin | Vermont | 50011 | 99 | 5 |
132909 | 132909 | 2020-05-10 | Franklin | Vermont | 50011 | 99 | 5 |
135899 | 135899 | 2020-05-11 | Franklin | Vermont | 50011 | 99 | 5 |
138890 | 138890 | 2020-05-12 | Franklin | Vermont | 50011 | 99 | 5 |
141886 | 141886 | 2020-05-13 | Franklin | Vermont | 50011 | 99 | 5 |
144883 | 144883 | 2020-05-14 | Franklin | Vermont | 50011 | 99 | 5 |
147886 | 147886 | 2020-05-15 | Franklin | Vermont | 50011 | 99 | 5 |
150895 | 150895 | 2020-05-16 | Franklin | Vermont | 50011 | 99 | 5 |
153906 | 153906 | 2020-05-17 | Franklin | Vermont | 50011 | 99 | 5 |
156923 | 156923 | 2020-05-18 | Franklin | Vermont | 50011 | 99 | 5 |
159947 | 159947 | 2020-05-19 | Franklin | Vermont | 50011 | 99 | 5 |
162975 | 162975 | 2020-05-20 | Franklin | Vermont | 50011 | 99 | 5 |
166004 | 166004 | 2020-05-21 | Franklin | Vermont | 50011 | 99 | 5 |
169040 | 169040 | 2020-05-22 | Franklin | Vermont | 50011 | 99 | 5 |
172081 | 172081 | 2020-05-23 | Franklin | Vermont | 50011 | 99 | 5 |
175124 | 175124 | 2020-05-24 | Franklin | Vermont | 50011 | 99 | 5 |
178169 | 178169 | 2020-05-25 | Franklin | Vermont | 50011 | 99 | 5 |
181213 | 181213 | 2020-05-26 | Franklin | Vermont | 50011 | 99 | 5 |
184264 | 184264 | 2020-05-27 | Franklin | Vermont | 50011 | 99 | 5 |
187321 | 187321 | 2020-05-28 | Franklin | Vermont | 50011 | 99 | 5 |
190385 | 190385 | 2020-05-29 | Franklin | Vermont | 50011 | 99 | 5 |
193451 | 193451 | 2020-05-30 | Franklin | Vermont | 50011 | 99 | 5 |
196521 | 196521 | 2020-05-31 | Franklin | Vermont | 50011 | 99 | 5 |
199594 | 199594 | 2020-06-01 | Franklin | Vermont | 50011 | 99 | 5 |
202670 | 202670 | 2020-06-02 | Franklin | Vermont | 50011 | 99 | 5 |
205749 | 205749 | 2020-06-03 | Franklin | Vermont | 50011 | 99 | 5 |
208831 | 208831 | 2020-06-04 | Franklin | Vermont | 50011 | 99 | 5 |
211916 | 211916 | 2020-06-05 | Franklin | Vermont | 50011 | 100 | 5 |
215003 | 215003 | 2020-06-06 | Franklin | Vermont | 50011 | 100 | 5 |
218093 | 218093 | 2020-06-07 | Franklin | Vermont | 50011 | 100 | 5 |
221185 | 221185 | 2020-06-08 | Franklin | Vermont | 50011 | 100 | 5 |
224281 | 224281 | 2020-06-09 | Franklin | Vermont | 50011 | 100 | 5 |
227381 | 227381 | 2020-06-10 | Franklin | Vermont | 50011 | 101 | 5 |
230485 | 230485 | 2020-06-11 | Franklin | Vermont | 50011 | 101 | 5 |
233590 | 233590 | 2020-06-12 | Franklin | Vermont | 50011 | 102 | 5 |
236697 | 236697 | 2020-06-13 | Franklin | Vermont | 50011 | 102 | 5 |
239805 | 239805 | 2020-06-14 | Franklin | Vermont | 50011 | 102 | 5 |
242916 | 242916 | 2020-06-15 | Franklin | Vermont | 50011 | 102 | 5 |
246028 | 246028 | 2020-06-16 | Franklin | Vermont | 50011 | 102 | 5 |
249140 | 249140 | 2020-06-17 | Franklin | Vermont | 50011 | 102 | 5 |
252255 | 252255 | 2020-06-18 | Franklin | Vermont | 50011 | 102 | 6 |
255373 | 255373 | 2020-06-19 | Franklin | Vermont | 50011 | 102 | 6 |
258500 | 258500 | 2020-06-20 | Franklin | Vermont | 50011 | 102 | 6 |
261627 | 261627 | 2020-06-21 | Franklin | Vermont | 50011 | 102 | 6 |
264756 | 264756 | 2020-06-22 | Franklin | Vermont | 50011 | 102 | 6 |
267885 | 267885 | 2020-06-23 | Franklin | Vermont | 50011 | 102 | 6 |
271019 | 271019 | 2020-06-24 | Franklin | Vermont | 50011 | 102 | 6 |
274159 | 274159 | 2020-06-25 | Franklin | Vermont | 50011 | 103 | 6 |
277307 | 277307 | 2020-06-26 | Franklin | Vermont | 50011 | 103 | 6 |
280455 | 280455 | 2020-06-27 | Franklin | Vermont | 50011 | 104 | 6 |
283601 | 283601 | 2020-06-28 | Franklin | Vermont | 50011 | 104 | 6 |
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);