ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 50007 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1341 | 1341 | 2020-03-11 | Chittenden | Vermont | 50007 | 1 | 0 |
1588 | 1588 | 2020-03-12 | Chittenden | Vermont | 50007 | 1 | 0 |
1897 | 1897 | 2020-03-13 | Chittenden | Vermont | 50007 | 1 | 0 |
2265 | 2265 | 2020-03-14 | Chittenden | Vermont | 50007 | 1 | 0 |
2692 | 2692 | 2020-03-15 | Chittenden | Vermont | 50007 | 2 | 0 |
3163 | 3163 | 2020-03-16 | Chittenden | Vermont | 50007 | 4 | 0 |
3699 | 3699 | 2020-03-17 | Chittenden | Vermont | 50007 | 6 | 0 |
4331 | 4331 | 2020-03-18 | Chittenden | Vermont | 50007 | 11 | 0 |
5087 | 5087 | 2020-03-19 | Chittenden | Vermont | 50007 | 12 | 1 |
5982 | 5982 | 2020-03-20 | Chittenden | Vermont | 50007 | 12 | 1 |
7005 | 7005 | 2020-03-21 | Chittenden | Vermont | 50007 | 22 | 1 |
8135 | 8135 | 2020-03-22 | Chittenden | Vermont | 50007 | 22 | 1 |
9355 | 9355 | 2020-03-23 | Chittenden | Vermont | 50007 | 22 | 1 |
10700 | 10700 | 2020-03-24 | Chittenden | Vermont | 50007 | 40 | 1 |
12211 | 12211 | 2020-03-25 | Chittenden | Vermont | 50007 | 55 | 6 |
13847 | 13847 | 2020-03-26 | Chittenden | Vermont | 50007 | 75 | 6 |
15613 | 15613 | 2020-03-27 | Chittenden | Vermont | 50007 | 90 | 6 |
17487 | 17487 | 2020-03-28 | Chittenden | Vermont | 50007 | 105 | 6 |
19446 | 19446 | 2020-03-29 | Chittenden | Vermont | 50007 | 117 | 6 |
21509 | 21509 | 2020-03-30 | Chittenden | Vermont | 50007 | 133 | 6 |
23648 | 23648 | 2020-03-31 | Chittenden | Vermont | 50007 | 152 | 6 |
25863 | 25863 | 2020-04-01 | Chittenden | Vermont | 50007 | 164 | 6 |
28152 | 28152 | 2020-04-02 | Chittenden | Vermont | 50007 | 177 | 6 |
30495 | 30495 | 2020-04-03 | Chittenden | Vermont | 50007 | 199 | 6 |
32893 | 32893 | 2020-04-04 | Chittenden | Vermont | 50007 | 245 | 6 |
35331 | 35331 | 2020-04-05 | Chittenden | Vermont | 50007 | 271 | 6 |
37809 | 37809 | 2020-04-06 | Chittenden | Vermont | 50007 | 285 | 6 |
40338 | 40338 | 2020-04-07 | Chittenden | Vermont | 50007 | 308 | 6 |
42906 | 42906 | 2020-04-08 | Chittenden | Vermont | 50007 | 324 | 15 |
45500 | 45500 | 2020-04-09 | Chittenden | Vermont | 50007 | 336 | 15 |
48124 | 48124 | 2020-04-10 | Chittenden | Vermont | 50007 | 336 | 15 |
50782 | 50782 | 2020-04-11 | Chittenden | Vermont | 50007 | 351 | 16 |
53457 | 53457 | 2020-04-12 | Chittenden | Vermont | 50007 | 364 | 17 |
56146 | 56146 | 2020-04-13 | Chittenden | Vermont | 50007 | 372 | 18 |
58852 | 58852 | 2020-04-14 | Chittenden | Vermont | 50007 | 372 | 19 |
61571 | 61571 | 2020-04-15 | Chittenden | Vermont | 50007 | 372 | 20 |
64303 | 64303 | 2020-04-16 | Chittenden | Vermont | 50007 | 377 | 22 |
67051 | 67051 | 2020-04-17 | Chittenden | Vermont | 50007 | 378 | 22 |
69813 | 69813 | 2020-04-18 | Chittenden | Vermont | 50007 | 384 | 23 |
72583 | 72583 | 2020-04-19 | Chittenden | Vermont | 50007 | 385 | 23 |
75359 | 75359 | 2020-04-20 | Chittenden | Vermont | 50007 | 385 | 24 |
78141 | 78141 | 2020-04-21 | Chittenden | Vermont | 50007 | 391 | 25 |
80933 | 80933 | 2020-04-22 | Chittenden | Vermont | 50007 | 393 | 25 |
83734 | 83734 | 2020-04-23 | Chittenden | Vermont | 50007 | 395 | 27 |
86541 | 86541 | 2020-04-24 | Chittenden | Vermont | 50007 | 396 | 28 |
89356 | 89356 | 2020-04-25 | Chittenden | Vermont | 50007 | 405 | 30 |
92173 | 92173 | 2020-04-26 | Chittenden | Vermont | 50007 | 410 | 30 |
95002 | 95002 | 2020-04-27 | Chittenden | Vermont | 50007 | 414 | 31 |
97844 | 97844 | 2020-04-28 | Chittenden | Vermont | 50007 | 416 | 31 |
100694 | 100694 | 2020-04-29 | Chittenden | Vermont | 50007 | 416 | 31 |
103549 | 103549 | 2020-04-30 | Chittenden | Vermont | 50007 | 418 | 32 |
106413 | 106413 | 2020-05-01 | Chittenden | Vermont | 50007 | 419 | 33 |
109282 | 109282 | 2020-05-02 | Chittenden | Vermont | 50007 | 422 | 34 |
112156 | 112156 | 2020-05-03 | Chittenden | Vermont | 50007 | 423 | 36 |
115039 | 115039 | 2020-05-04 | Chittenden | Vermont | 50007 | 425 | 36 |
117998 | 117998 | 2020-05-05 | Chittenden | Vermont | 50007 | 425 | 36 |
120962 | 120962 | 2020-05-06 | Chittenden | Vermont | 50007 | 426 | 36 |
123943 | 123943 | 2020-05-07 | Chittenden | Vermont | 50007 | 431 | 37 |
126928 | 126928 | 2020-05-08 | Chittenden | Vermont | 50007 | 431 | 37 |
129917 | 129917 | 2020-05-09 | Chittenden | Vermont | 50007 | 431 | 37 |
132907 | 132907 | 2020-05-10 | Chittenden | Vermont | 50007 | 432 | 37 |
135897 | 135897 | 2020-05-11 | Chittenden | Vermont | 50007 | 432 | 37 |
138888 | 138888 | 2020-05-12 | Chittenden | Vermont | 50007 | 432 | 37 |
141884 | 141884 | 2020-05-13 | Chittenden | Vermont | 50007 | 432 | 37 |
144881 | 144881 | 2020-05-14 | Chittenden | Vermont | 50007 | 432 | 37 |
147884 | 147884 | 2020-05-15 | Chittenden | Vermont | 50007 | 433 | 37 |
150893 | 150893 | 2020-05-16 | Chittenden | Vermont | 50007 | 434 | 37 |
153904 | 153904 | 2020-05-17 | Chittenden | Vermont | 50007 | 439 | 38 |
156921 | 156921 | 2020-05-18 | Chittenden | Vermont | 50007 | 439 | 38 |
159945 | 159945 | 2020-05-19 | Chittenden | Vermont | 50007 | 439 | 38 |
162973 | 162973 | 2020-05-20 | Chittenden | Vermont | 50007 | 439 | 38 |
166002 | 166002 | 2020-05-21 | Chittenden | Vermont | 50007 | 440 | 38 |
169038 | 169038 | 2020-05-22 | Chittenden | Vermont | 50007 | 440 | 38 |
172079 | 172079 | 2020-05-23 | Chittenden | Vermont | 50007 | 440 | 38 |
175122 | 175122 | 2020-05-24 | Chittenden | Vermont | 50007 | 440 | 38 |
178167 | 178167 | 2020-05-25 | Chittenden | Vermont | 50007 | 441 | 38 |
181211 | 181211 | 2020-05-26 | Chittenden | Vermont | 50007 | 444 | 38 |
184262 | 184262 | 2020-05-27 | Chittenden | Vermont | 50007 | 446 | 38 |
187319 | 187319 | 2020-05-28 | Chittenden | Vermont | 50007 | 449 | 39 |
190383 | 190383 | 2020-05-29 | Chittenden | Vermont | 50007 | 448 | 39 |
193449 | 193449 | 2020-05-30 | Chittenden | Vermont | 50007 | 449 | 39 |
196519 | 196519 | 2020-05-31 | Chittenden | Vermont | 50007 | 451 | 39 |
199592 | 199592 | 2020-06-01 | Chittenden | Vermont | 50007 | 453 | 39 |
202668 | 202668 | 2020-06-02 | Chittenden | Vermont | 50007 | 457 | 39 |
205747 | 205747 | 2020-06-03 | Chittenden | Vermont | 50007 | 457 | 39 |
208829 | 208829 | 2020-06-04 | Chittenden | Vermont | 50007 | 491 | 39 |
211914 | 211914 | 2020-06-05 | Chittenden | Vermont | 50007 | 490 | 39 |
215001 | 215001 | 2020-06-06 | Chittenden | Vermont | 50007 | 503 | 39 |
218091 | 218091 | 2020-06-07 | Chittenden | Vermont | 50007 | 520 | 39 |
221183 | 221183 | 2020-06-08 | Chittenden | Vermont | 50007 | 528 | 39 |
224279 | 224279 | 2020-06-09 | Chittenden | Vermont | 50007 | 535 | 39 |
227379 | 227379 | 2020-06-10 | Chittenden | Vermont | 50007 | 544 | 39 |
230483 | 230483 | 2020-06-11 | Chittenden | Vermont | 50007 | 559 | 39 |
233588 | 233588 | 2020-06-12 | Chittenden | Vermont | 50007 | 564 | 39 |
236695 | 236695 | 2020-06-13 | Chittenden | Vermont | 50007 | 568 | 39 |
239803 | 239803 | 2020-06-14 | Chittenden | Vermont | 50007 | 569 | 39 |
242914 | 242914 | 2020-06-15 | Chittenden | Vermont | 50007 | 572 | 39 |
246026 | 246026 | 2020-06-16 | Chittenden | Vermont | 50007 | 572 | 39 |
249138 | 249138 | 2020-06-17 | Chittenden | Vermont | 50007 | 572 | 39 |
252253 | 252253 | 2020-06-18 | Chittenden | Vermont | 50007 | 574 | 39 |
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);