ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Bristol" and fips = 25005 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 |
---|---|---|---|---|---|---|---|
2094 | 2094 | 2020-03-14 | Bristol | Massachusetts | 25005 | 1 | 0 |
2495 | 2495 | 2020-03-15 | Bristol | Massachusetts | 25005 | 1 | 0 |
2944 | 2944 | 2020-03-16 | Bristol | Massachusetts | 25005 | 2 | 0 |
3445 | 3445 | 2020-03-17 | Bristol | Massachusetts | 25005 | 5 | 0 |
4027 | 4027 | 2020-03-18 | Bristol | Massachusetts | 25005 | 5 | 0 |
4731 | 4731 | 2020-03-19 | Bristol | Massachusetts | 25005 | 6 | 0 |
5550 | 5550 | 2020-03-20 | Bristol | Massachusetts | 25005 | 6 | 0 |
6509 | 6509 | 2020-03-21 | Bristol | Massachusetts | 25005 | 14 | 0 |
7586 | 7586 | 2020-03-22 | Bristol | Massachusetts | 25005 | 24 | 0 |
8758 | 8758 | 2020-03-23 | Bristol | Massachusetts | 25005 | 25 | 0 |
10047 | 10047 | 2020-03-24 | Bristol | Massachusetts | 25005 | 31 | 0 |
11458 | 11458 | 2020-03-25 | Bristol | Massachusetts | 25005 | 67 | 0 |
13039 | 13039 | 2020-03-26 | Bristol | Massachusetts | 25005 | 90 | 0 |
14747 | 14747 | 2020-03-27 | Bristol | Massachusetts | 25005 | 129 | 1 |
16567 | 16567 | 2020-03-28 | Bristol | Massachusetts | 25005 | 179 | 1 |
18482 | 18482 | 2020-03-29 | Bristol | Massachusetts | 25005 | 208 | 1 |
20498 | 20498 | 2020-03-30 | Bristol | Massachusetts | 25005 | 263 | 2 |
22607 | 22607 | 2020-03-31 | Bristol | Massachusetts | 25005 | 306 | 2 |
24786 | 24786 | 2020-04-01 | Bristol | Massachusetts | 25005 | 366 | 3 |
27038 | 27038 | 2020-04-02 | Bristol | Massachusetts | 25005 | 424 | 3 |
29356 | 29356 | 2020-04-03 | Bristol | Massachusetts | 25005 | 517 | 4 |
31734 | 31734 | 2020-04-04 | Bristol | Massachusetts | 25005 | 601 | 5 |
34159 | 34159 | 2020-04-05 | Bristol | Massachusetts | 25005 | 659 | 8 |
36618 | 36618 | 2020-04-06 | Bristol | Massachusetts | 25005 | 722 | 8 |
39126 | 39126 | 2020-04-07 | Bristol | Massachusetts | 25005 | 768 | 16 |
41678 | 41678 | 2020-04-08 | Bristol | Massachusetts | 25005 | 835 | 23 |
44254 | 44254 | 2020-04-09 | Bristol | Massachusetts | 25005 | 994 | 28 |
46862 | 46862 | 2020-04-10 | Bristol | Massachusetts | 25005 | 1086 | 33 |
49504 | 49504 | 2020-04-11 | Bristol | Massachusetts | 25005 | 1191 | 39 |
52174 | 52174 | 2020-04-12 | Bristol | Massachusetts | 25005 | 1327 | 43 |
54855 | 54855 | 2020-04-13 | Bristol | Massachusetts | 25005 | 1394 | 46 |
57553 | 57553 | 2020-04-14 | Bristol | Massachusetts | 25005 | 1435 | 53 |
60262 | 60262 | 2020-04-15 | Bristol | Massachusetts | 25005 | 1508 | 56 |
62983 | 62983 | 2020-04-16 | Bristol | Massachusetts | 25005 | 1605 | 63 |
65721 | 65721 | 2020-04-17 | Bristol | Massachusetts | 25005 | 1659 | 75 |
68471 | 68471 | 2020-04-18 | Bristol | Massachusetts | 25005 | 1698 | 83 |
71235 | 71235 | 2020-04-19 | Bristol | Massachusetts | 25005 | 1731 | 87 |
74007 | 74007 | 2020-04-20 | Bristol | Massachusetts | 25005 | 1779 | 88 |
76787 | 76787 | 2020-04-21 | Bristol | Massachusetts | 25005 | 1852 | 96 |
79573 | 79573 | 2020-04-22 | Bristol | Massachusetts | 25005 | 1908 | 104 |
82368 | 82368 | 2020-04-23 | Bristol | Massachusetts | 25005 | 2181 | 109 |
85172 | 85172 | 2020-04-24 | Bristol | Massachusetts | 25005 | 2697 | 126 |
87982 | 87982 | 2020-04-25 | Bristol | Massachusetts | 25005 | 2829 | 130 |
90798 | 90798 | 2020-04-26 | Bristol | Massachusetts | 25005 | 2923 | 134 |
93619 | 93619 | 2020-04-27 | Bristol | Massachusetts | 25005 | 3068 | 137 |
96454 | 96454 | 2020-04-28 | Bristol | Massachusetts | 25005 | 3270 | 155 |
99300 | 99300 | 2020-04-29 | Bristol | Massachusetts | 25005 | 3429 | 165 |
102152 | 102152 | 2020-04-30 | Bristol | Massachusetts | 25005 | 3580 | 172 |
105012 | 105012 | 2020-05-01 | Bristol | Massachusetts | 25005 | 3792 | 182 |
107876 | 107876 | 2020-05-02 | Bristol | Massachusetts | 25005 | 3916 | 187 |
110748 | 110748 | 2020-05-03 | Bristol | Massachusetts | 25005 | 4019 | 198 |
113626 | 113626 | 2020-05-04 | Bristol | Massachusetts | 25005 | 4103 | 205 |
116507 | 116507 | 2020-05-05 | Bristol | Massachusetts | 25005 | 4235 | 210 |
119468 | 119468 | 2020-05-06 | Bristol | Massachusetts | 25005 | 4380 | 223 |
122440 | 122440 | 2020-05-07 | Bristol | Massachusetts | 25005 | 4529 | 232 |
125422 | 125422 | 2020-05-08 | Bristol | Massachusetts | 25005 | 4670 | 252 |
128409 | 128409 | 2020-05-09 | Bristol | Massachusetts | 25005 | 4847 | 260 |
131399 | 131399 | 2020-05-10 | Bristol | Massachusetts | 25005 | 4931 | 266 |
134390 | 134390 | 2020-05-11 | Bristol | Massachusetts | 25005 | 4999 | 274 |
137380 | 137380 | 2020-05-12 | Bristol | Massachusetts | 25005 | 5125 | 278 |
140374 | 140374 | 2020-05-13 | Bristol | Massachusetts | 25005 | 5249 | 288 |
143369 | 143369 | 2020-05-14 | Bristol | Massachusetts | 25005 | 5440 | 297 |
146369 | 146369 | 2020-05-15 | Bristol | Massachusetts | 25005 | 5590 | 303 |
149374 | 149374 | 2020-05-16 | Bristol | Massachusetts | 25005 | 5748 | 313 |
152385 | 152385 | 2020-05-17 | Bristol | Massachusetts | 25005 | 5870 | 320 |
155399 | 155399 | 2020-05-18 | Bristol | Massachusetts | 25005 | 5996 | 324 |
158417 | 158417 | 2020-05-19 | Bristol | Massachusetts | 25005 | 6080 | 330 |
161443 | 161443 | 2020-05-20 | Bristol | Massachusetts | 25005 | 6165 | 338 |
164472 | 164472 | 2020-05-21 | Bristol | Massachusetts | 25005 | 6286 | 345 |
167508 | 167508 | 2020-05-22 | Bristol | Massachusetts | 25005 | 6362 | 353 |
170545 | 170545 | 2020-05-23 | Bristol | Massachusetts | 25005 | 6426 | 362 |
173587 | 173587 | 2020-05-24 | Bristol | Massachusetts | 25005 | 6596 | 369 |
176630 | 176630 | 2020-05-25 | Bristol | Massachusetts | 25005 | 6681 | 375 |
179674 | 179674 | 2020-05-26 | Bristol | Massachusetts | 25005 | 6733 | 382 |
182720 | 182720 | 2020-05-27 | Bristol | Massachusetts | 25005 | 6779 | 390 |
185775 | 185775 | 2020-05-28 | Bristol | Massachusetts | 25005 | 6852 | 399 |
188833 | 188833 | 2020-05-29 | Bristol | Massachusetts | 25005 | 6930 | 404 |
191897 | 191897 | 2020-05-30 | Bristol | Massachusetts | 25005 | 7089 | 410 |
194965 | 194965 | 2020-05-31 | Bristol | Massachusetts | 25005 | 7159 | 415 |
198036 | 198036 | 2020-06-01 | Bristol | Massachusetts | 25005 | 7348 | 429 |
201108 | 201108 | 2020-06-02 | Bristol | Massachusetts | 25005 | 7380 | 435 |
204185 | 204185 | 2020-06-03 | Bristol | Massachusetts | 25005 | 7453 | 441 |
207266 | 207266 | 2020-06-04 | Bristol | Massachusetts | 25005 | 7508 | 452 |
210347 | 210347 | 2020-06-05 | Bristol | Massachusetts | 25005 | 7573 | 455 |
213431 | 213431 | 2020-06-06 | Bristol | Massachusetts | 25005 | 7635 | 467 |
216519 | 216519 | 2020-06-07 | Bristol | Massachusetts | 25005 | 7683 | 469 |
219611 | 219611 | 2020-06-08 | Bristol | Massachusetts | 25005 | 7698 | 473 |
222706 | 222706 | 2020-06-09 | Bristol | Massachusetts | 25005 | 7728 | 481 |
225802 | 225802 | 2020-06-10 | Bristol | Massachusetts | 25005 | 7754 | 487 |
228904 | 228904 | 2020-06-11 | Bristol | Massachusetts | 25005 | 7793 | 492 |
232008 | 232008 | 2020-06-12 | Bristol | Massachusetts | 25005 | 7872 | 496 |
235113 | 235113 | 2020-06-13 | Bristol | Massachusetts | 25005 | 7906 | 507 |
238220 | 238220 | 2020-06-14 | Bristol | Massachusetts | 25005 | 7933 | 516 |
241329 | 241329 | 2020-06-15 | Bristol | Massachusetts | 25005 | 7925 | 518 |
244440 | 244440 | 2020-06-16 | Bristol | Massachusetts | 25005 | 7940 | 520 |
247553 | 247553 | 2020-06-17 | Bristol | Massachusetts | 25005 | 7956 | 528 |
250665 | 250665 | 2020-06-18 | Bristol | Massachusetts | 25005 | 7979 | 534 |
253780 | 253780 | 2020-06-19 | Bristol | Massachusetts | 25005 | 8002 | 537 |
256900 | 256900 | 2020-06-20 | Bristol | Massachusetts | 25005 | 8028 | 539 |
260026 | 260026 | 2020-06-21 | Bristol | Massachusetts | 25005 | 8035 | 542 |
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);