ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 25013 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 |
---|---|---|---|---|---|---|---|
2497 | 2497 | 2020-03-15 | Hampden | Massachusetts | 25013 | 1 | 0 |
2946 | 2946 | 2020-03-16 | Hampden | Massachusetts | 25013 | 1 | 0 |
3447 | 3447 | 2020-03-17 | Hampden | Massachusetts | 25013 | 1 | 0 |
4030 | 4030 | 2020-03-18 | Hampden | Massachusetts | 25013 | 2 | 0 |
4734 | 4734 | 2020-03-19 | Hampden | Massachusetts | 25013 | 3 | 0 |
5553 | 5553 | 2020-03-20 | Hampden | Massachusetts | 25013 | 3 | 0 |
6512 | 6512 | 2020-03-21 | Hampden | Massachusetts | 25013 | 9 | 0 |
7589 | 7589 | 2020-03-22 | Hampden | Massachusetts | 25013 | 12 | 1 |
8761 | 8761 | 2020-03-23 | Hampden | Massachusetts | 25013 | 15 | 1 |
10050 | 10050 | 2020-03-24 | Hampden | Massachusetts | 25013 | 24 | 1 |
11462 | 11462 | 2020-03-25 | Hampden | Massachusetts | 25013 | 45 | 1 |
13043 | 13043 | 2020-03-26 | Hampden | Massachusetts | 25013 | 55 | 2 |
14751 | 14751 | 2020-03-27 | Hampden | Massachusetts | 25013 | 90 | 2 |
16571 | 16571 | 2020-03-28 | Hampden | Massachusetts | 25013 | 183 | 5 |
18486 | 18486 | 2020-03-29 | Hampden | Massachusetts | 25013 | 201 | 5 |
20502 | 20502 | 2020-03-30 | Hampden | Massachusetts | 25013 | 255 | 5 |
22611 | 22611 | 2020-03-31 | Hampden | Massachusetts | 25013 | 354 | 12 |
24790 | 24790 | 2020-04-01 | Hampden | Massachusetts | 25013 | 475 | 17 |
27042 | 27042 | 2020-04-02 | Hampden | Massachusetts | 25013 | 546 | 20 |
29360 | 29360 | 2020-04-03 | Hampden | Massachusetts | 25013 | 661 | 28 |
31738 | 31738 | 2020-04-04 | Hampden | Massachusetts | 25013 | 733 | 35 |
34163 | 34163 | 2020-04-05 | Hampden | Massachusetts | 25013 | 768 | 35 |
36622 | 36622 | 2020-04-06 | Hampden | Massachusetts | 25013 | 889 | 39 |
39130 | 39130 | 2020-04-07 | Hampden | Massachusetts | 25013 | 997 | 56 |
41682 | 41682 | 2020-04-08 | Hampden | Massachusetts | 25013 | 1081 | 64 |
44258 | 44258 | 2020-04-09 | Hampden | Massachusetts | 25013 | 1276 | 81 |
46866 | 46866 | 2020-04-10 | Hampden | Massachusetts | 25013 | 1394 | 88 |
49508 | 49508 | 2020-04-11 | Hampden | Massachusetts | 25013 | 1545 | 94 |
52178 | 52178 | 2020-04-12 | Hampden | Massachusetts | 25013 | 1647 | 104 |
54859 | 54859 | 2020-04-13 | Hampden | Massachusetts | 25013 | 1694 | 115 |
57557 | 57557 | 2020-04-14 | Hampden | Massachusetts | 25013 | 1798 | 134 |
60266 | 60266 | 2020-04-15 | Hampden | Massachusetts | 25013 | 1885 | 153 |
62987 | 62987 | 2020-04-16 | Hampden | Massachusetts | 25013 | 1985 | 163 |
65725 | 65725 | 2020-04-17 | Hampden | Massachusetts | 25013 | 2134 | 183 |
68475 | 68475 | 2020-04-18 | Hampden | Massachusetts | 25013 | 2254 | 202 |
71239 | 71239 | 2020-04-19 | Hampden | Massachusetts | 25013 | 2337 | 213 |
74011 | 74011 | 2020-04-20 | Hampden | Massachusetts | 25013 | 2438 | 224 |
76791 | 76791 | 2020-04-21 | Hampden | Massachusetts | 25013 | 2533 | 244 |
79577 | 79577 | 2020-04-22 | Hampden | Massachusetts | 25013 | 2678 | 271 |
82372 | 82372 | 2020-04-23 | Hampden | Massachusetts | 25013 | 2836 | 287 |
85176 | 85176 | 2020-04-24 | Hampden | Massachusetts | 25013 | 3060 | 299 |
87986 | 87986 | 2020-04-25 | Hampden | Massachusetts | 25013 | 3229 | 315 |
90802 | 90802 | 2020-04-26 | Hampden | Massachusetts | 25013 | 3295 | 327 |
93623 | 93623 | 2020-04-27 | Hampden | Massachusetts | 25013 | 3381 | 337 |
96458 | 96458 | 2020-04-28 | Hampden | Massachusetts | 25013 | 3546 | 346 |
99304 | 99304 | 2020-04-29 | Hampden | Massachusetts | 25013 | 3698 | 358 |
102156 | 102156 | 2020-04-30 | Hampden | Massachusetts | 25013 | 3777 | 373 |
105016 | 105016 | 2020-05-01 | Hampden | Massachusetts | 25013 | 3900 | 381 |
107880 | 107880 | 2020-05-02 | Hampden | Massachusetts | 25013 | 4003 | 387 |
110752 | 110752 | 2020-05-03 | Hampden | Massachusetts | 25013 | 4066 | 398 |
113630 | 113630 | 2020-05-04 | Hampden | Massachusetts | 25013 | 4114 | 408 |
116511 | 116511 | 2020-05-05 | Hampden | Massachusetts | 25013 | 4203 | 415 |
119472 | 119472 | 2020-05-06 | Hampden | Massachusetts | 25013 | 4321 | 425 |
122444 | 122444 | 2020-05-07 | Hampden | Massachusetts | 25013 | 4441 | 434 |
125426 | 125426 | 2020-05-08 | Hampden | Massachusetts | 25013 | 4522 | 441 |
128413 | 128413 | 2020-05-09 | Hampden | Massachusetts | 25013 | 4647 | 445 |
131403 | 131403 | 2020-05-10 | Hampden | Massachusetts | 25013 | 4714 | 449 |
134394 | 134394 | 2020-05-11 | Hampden | Massachusetts | 25013 | 4763 | 458 |
137384 | 137384 | 2020-05-12 | Hampden | Massachusetts | 25013 | 4831 | 464 |
140378 | 140378 | 2020-05-13 | Hampden | Massachusetts | 25013 | 4889 | 475 |
143373 | 143373 | 2020-05-14 | Hampden | Massachusetts | 25013 | 4974 | 487 |
146373 | 146373 | 2020-05-15 | Hampden | Massachusetts | 25013 | 5038 | 494 |
149378 | 149378 | 2020-05-16 | Hampden | Massachusetts | 25013 | 5133 | 506 |
152389 | 152389 | 2020-05-17 | Hampden | Massachusetts | 25013 | 5205 | 516 |
155403 | 155403 | 2020-05-18 | Hampden | Massachusetts | 25013 | 5264 | 517 |
158421 | 158421 | 2020-05-19 | Hampden | Massachusetts | 25013 | 5335 | 521 |
161447 | 161447 | 2020-05-20 | Hampden | Massachusetts | 25013 | 5418 | 526 |
164476 | 164476 | 2020-05-21 | Hampden | Massachusetts | 25013 | 5492 | 533 |
167512 | 167512 | 2020-05-22 | Hampden | Massachusetts | 25013 | 5568 | 537 |
170549 | 170549 | 2020-05-23 | Hampden | Massachusetts | 25013 | 5621 | 541 |
173591 | 173591 | 2020-05-24 | Hampden | Massachusetts | 25013 | 5687 | 542 |
176634 | 176634 | 2020-05-25 | Hampden | Massachusetts | 25013 | 5755 | 543 |
179678 | 179678 | 2020-05-26 | Hampden | Massachusetts | 25013 | 5796 | 546 |
182724 | 182724 | 2020-05-27 | Hampden | Massachusetts | 25013 | 5845 | 554 |
185779 | 185779 | 2020-05-28 | Hampden | Massachusetts | 25013 | 5878 | 562 |
188837 | 188837 | 2020-05-29 | Hampden | Massachusetts | 25013 | 5942 | 569 |
191901 | 191901 | 2020-05-30 | Hampden | Massachusetts | 25013 | 5982 | 572 |
194969 | 194969 | 2020-05-31 | Hampden | Massachusetts | 25013 | 6035 | 580 |
198040 | 198040 | 2020-06-01 | Hampden | Massachusetts | 25013 | 6188 | 601 |
201112 | 201112 | 2020-06-02 | Hampden | Massachusetts | 25013 | 6201 | 603 |
204189 | 204189 | 2020-06-03 | Hampden | Massachusetts | 25013 | 6237 | 608 |
207270 | 207270 | 2020-06-04 | Hampden | Massachusetts | 25013 | 6268 | 609 |
210351 | 210351 | 2020-06-05 | Hampden | Massachusetts | 25013 | 6297 | 610 |
213435 | 213435 | 2020-06-06 | Hampden | Massachusetts | 25013 | 6337 | 618 |
216523 | 216523 | 2020-06-07 | Hampden | Massachusetts | 25013 | 6353 | 620 |
219615 | 219615 | 2020-06-08 | Hampden | Massachusetts | 25013 | 6365 | 622 |
222710 | 222710 | 2020-06-09 | Hampden | Massachusetts | 25013 | 6380 | 625 |
225806 | 225806 | 2020-06-10 | Hampden | Massachusetts | 25013 | 6395 | 629 |
228908 | 228908 | 2020-06-11 | Hampden | Massachusetts | 25013 | 6415 | 633 |
232012 | 232012 | 2020-06-12 | Hampden | Massachusetts | 25013 | 6431 | 632 |
235117 | 235117 | 2020-06-13 | Hampden | Massachusetts | 25013 | 6460 | 637 |
238224 | 238224 | 2020-06-14 | Hampden | Massachusetts | 25013 | 6481 | 640 |
241333 | 241333 | 2020-06-15 | Hampden | Massachusetts | 25013 | 6489 | 640 |
244444 | 244444 | 2020-06-16 | Hampden | Massachusetts | 25013 | 6503 | 642 |
247557 | 247557 | 2020-06-17 | Hampden | Massachusetts | 25013 | 6518 | 645 |
250669 | 250669 | 2020-06-18 | Hampden | Massachusetts | 25013 | 6537 | 646 |
253784 | 253784 | 2020-06-19 | Hampden | Massachusetts | 25013 | 6556 | 647 |
256904 | 256904 | 2020-06-20 | Hampden | Massachusetts | 25013 | 6584 | 648 |
260030 | 260030 | 2020-06-21 | Hampden | Massachusetts | 25013 | 6598 | 648 |
263159 | 263159 | 2020-06-22 | Hampden | Massachusetts | 25013 | 6610 | 647 |
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);