ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
803 rows where fips = 25021 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281998 | 281998 | 2020-06-28 | Norfolk | Massachusetts | 25021 | 9151 | 927 |
278850 | 278850 | 2020-06-27 | Norfolk | Massachusetts | 25021 | 9125 | 927 |
275702 | 275702 | 2020-06-26 | Norfolk | Massachusetts | 25021 | 9100 | 927 |
272559 | 272559 | 2020-06-25 | Norfolk | Massachusetts | 25021 | 9082 | 924 |
269422 | 269422 | 2020-06-24 | Norfolk | Massachusetts | 25021 | 9056 | 923 |
266289 | 266289 | 2020-06-23 | Norfolk | Massachusetts | 25021 | 9042 | 919 |
263163 | 263163 | 2020-06-22 | Norfolk | Massachusetts | 25021 | 9010 | 914 |
260034 | 260034 | 2020-06-21 | Norfolk | Massachusetts | 25021 | 8994 | 912 |
256908 | 256908 | 2020-06-20 | Norfolk | Massachusetts | 25021 | 8983 | 908 |
253788 | 253788 | 2020-06-19 | Norfolk | Massachusetts | 25021 | 8962 | 907 |
250673 | 250673 | 2020-06-18 | Norfolk | Massachusetts | 25021 | 8935 | 905 |
247561 | 247561 | 2020-06-17 | Norfolk | Massachusetts | 25021 | 8908 | 903 |
244448 | 244448 | 2020-06-16 | Norfolk | Massachusetts | 25021 | 8892 | 891 |
241337 | 241337 | 2020-06-15 | Norfolk | Massachusetts | 25021 | 8872 | 890 |
238228 | 238228 | 2020-06-14 | Norfolk | Massachusetts | 25021 | 8866 | 888 |
235121 | 235121 | 2020-06-13 | Norfolk | Massachusetts | 25021 | 8860 | 882 |
232016 | 232016 | 2020-06-12 | Norfolk | Massachusetts | 25021 | 8842 | 882 |
228912 | 228912 | 2020-06-11 | Norfolk | Massachusetts | 25021 | 8809 | 876 |
225810 | 225810 | 2020-06-10 | Norfolk | Massachusetts | 25021 | 8774 | 873 |
222714 | 222714 | 2020-06-09 | Norfolk | Massachusetts | 25021 | 8753 | 870 |
219619 | 219619 | 2020-06-08 | Norfolk | Massachusetts | 25021 | 8715 | 866 |
216527 | 216527 | 2020-06-07 | Norfolk | Massachusetts | 25021 | 8713 | 863 |
213439 | 213439 | 2020-06-06 | Norfolk | Massachusetts | 25021 | 8689 | 859 |
210355 | 210355 | 2020-06-05 | Norfolk | Massachusetts | 25021 | 8646 | 855 |
207274 | 207274 | 2020-06-04 | Norfolk | Massachusetts | 25021 | 8625 | 854 |
204193 | 204193 | 2020-06-03 | Norfolk | Massachusetts | 25021 | 8613 | 850 |
201116 | 201116 | 2020-06-02 | Norfolk | Massachusetts | 25021 | 8600 | 845 |
198044 | 198044 | 2020-06-01 | Norfolk | Massachusetts | 25021 | 8586 | 841 |
194973 | 194973 | 2020-05-31 | Norfolk | Massachusetts | 25021 | 8079 | 821 |
191905 | 191905 | 2020-05-30 | Norfolk | Massachusetts | 25021 | 8016 | 815 |
188841 | 188841 | 2020-05-29 | Norfolk | Massachusetts | 25021 | 7959 | 811 |
185783 | 185783 | 2020-05-28 | Norfolk | Massachusetts | 25021 | 7919 | 799 |
182728 | 182728 | 2020-05-27 | Norfolk | Massachusetts | 25021 | 7880 | 794 |
179682 | 179682 | 2020-05-26 | Norfolk | Massachusetts | 25021 | 7863 | 791 |
176638 | 176638 | 2020-05-25 | Norfolk | Massachusetts | 25021 | 7844 | 784 |
173595 | 173595 | 2020-05-24 | Norfolk | Massachusetts | 25021 | 7812 | 782 |
170553 | 170553 | 2020-05-23 | Norfolk | Massachusetts | 25021 | 7759 | 774 |
167516 | 167516 | 2020-05-22 | Norfolk | Massachusetts | 25021 | 7724 | 771 |
164480 | 164480 | 2020-05-21 | Norfolk | Massachusetts | 25021 | 7691 | 759 |
161451 | 161451 | 2020-05-20 | Norfolk | Massachusetts | 25021 | 7607 | 749 |
158425 | 158425 | 2020-05-19 | Norfolk | Massachusetts | 25021 | 7565 | 735 |
155407 | 155407 | 2020-05-18 | Norfolk | Massachusetts | 25021 | 7524 | 728 |
152393 | 152393 | 2020-05-17 | Norfolk | Massachusetts | 25021 | 7474 | 725 |
149382 | 149382 | 2020-05-16 | Norfolk | Massachusetts | 25021 | 7412 | 719 |
146377 | 146377 | 2020-05-15 | Norfolk | Massachusetts | 25021 | 7331 | 710 |
143377 | 143377 | 2020-05-14 | Norfolk | Massachusetts | 25021 | 7258 | 696 |
140382 | 140382 | 2020-05-13 | Norfolk | Massachusetts | 25021 | 7129 | 676 |
137388 | 137388 | 2020-05-12 | Norfolk | Massachusetts | 25021 | 7046 | 663 |
134398 | 134398 | 2020-05-11 | Norfolk | Massachusetts | 25021 | 7004 | 661 |
131407 | 131407 | 2020-05-10 | Norfolk | Massachusetts | 25021 | 6952 | 650 |
128417 | 128417 | 2020-05-09 | Norfolk | Massachusetts | 25021 | 6887 | 635 |
125430 | 125430 | 2020-05-08 | Norfolk | Massachusetts | 25021 | 6801 | 623 |
122448 | 122448 | 2020-05-07 | Norfolk | Massachusetts | 25021 | 6729 | 608 |
119476 | 119476 | 2020-05-06 | Norfolk | Massachusetts | 25021 | 6610 | 596 |
116515 | 116515 | 2020-05-05 | Norfolk | Massachusetts | 25021 | 6466 | 575 |
113634 | 113634 | 2020-05-04 | Norfolk | Massachusetts | 25021 | 6382 | 555 |
110756 | 110756 | 2020-05-03 | Norfolk | Massachusetts | 25021 | 6280 | 550 |
107884 | 107884 | 2020-05-02 | Norfolk | Massachusetts | 25021 | 6187 | 535 |
105020 | 105020 | 2020-05-01 | Norfolk | Massachusetts | 25021 | 6065 | 522 |
102160 | 102160 | 2020-04-30 | Norfolk | Massachusetts | 25021 | 5896 | 499 |
99308 | 99308 | 2020-04-29 | Norfolk | Massachusetts | 25021 | 5700 | 484 |
96462 | 96462 | 2020-04-28 | Norfolk | Massachusetts | 25021 | 5567 | 448 |
93627 | 93627 | 2020-04-27 | Norfolk | Massachusetts | 25021 | 5398 | 429 |
90806 | 90806 | 2020-04-26 | Norfolk | Massachusetts | 25021 | 5288 | 418 |
87990 | 87990 | 2020-04-25 | Norfolk | Massachusetts | 25021 | 5172 | 400 |
85180 | 85180 | 2020-04-24 | Norfolk | Massachusetts | 25021 | 4979 | 368 |
82376 | 82376 | 2020-04-23 | Norfolk | Massachusetts | 25021 | 4541 | 335 |
79581 | 79581 | 2020-04-22 | Norfolk | Massachusetts | 25021 | 4212 | 312 |
76795 | 76795 | 2020-04-21 | Norfolk | Massachusetts | 25021 | 4062 | 290 |
74015 | 74015 | 2020-04-20 | Norfolk | Massachusetts | 25021 | 3960 | 263 |
71243 | 71243 | 2020-04-19 | Norfolk | Massachusetts | 25021 | 3789 | 246 |
68479 | 68479 | 2020-04-18 | Norfolk | Massachusetts | 25021 | 3659 | 217 |
65729 | 65729 | 2020-04-17 | Norfolk | Massachusetts | 25021 | 3499 | 197 |
62991 | 62991 | 2020-04-16 | Norfolk | Massachusetts | 25021 | 3342 | 175 |
60270 | 60270 | 2020-04-15 | Norfolk | Massachusetts | 25021 | 3122 | 149 |
57561 | 57561 | 2020-04-14 | Norfolk | Massachusetts | 25021 | 2969 | 125 |
54863 | 54863 | 2020-04-13 | Norfolk | Massachusetts | 25021 | 2838 | 107 |
52182 | 52182 | 2020-04-12 | Norfolk | Massachusetts | 25021 | 2649 | 93 |
49512 | 49512 | 2020-04-11 | Norfolk | Massachusetts | 25021 | 2395 | 81 |
46870 | 46870 | 2020-04-10 | Norfolk | Massachusetts | 25021 | 2216 | 66 |
44262 | 44262 | 2020-04-09 | Norfolk | Massachusetts | 25021 | 2007 | 52 |
41686 | 41686 | 2020-04-08 | Norfolk | Massachusetts | 25021 | 1778 | 42 |
39134 | 39134 | 2020-04-07 | Norfolk | Massachusetts | 25021 | 1592 | 36 |
36626 | 36626 | 2020-04-06 | Norfolk | Massachusetts | 25021 | 1382 | 30 |
34167 | 34167 | 2020-04-05 | Norfolk | Massachusetts | 25021 | 1271 | 27 |
31742 | 31742 | 2020-04-04 | Norfolk | Massachusetts | 25021 | 1199 | 26 |
29364 | 29364 | 2020-04-03 | Norfolk | Massachusetts | 25021 | 1045 | 25 |
27046 | 27046 | 2020-04-02 | Norfolk | Massachusetts | 25021 | 938 | 22 |
24794 | 24794 | 2020-04-01 | Norfolk | Massachusetts | 25021 | 829 | 16 |
22615 | 22615 | 2020-03-31 | Norfolk | Massachusetts | 25021 | 738 | 13 |
20506 | 20506 | 2020-03-30 | Norfolk | Massachusetts | 25021 | 628 | 11 |
18490 | 18490 | 2020-03-29 | Norfolk | Massachusetts | 25021 | 548 | 10 |
16575 | 16575 | 2020-03-28 | Norfolk | Massachusetts | 25021 | 490 | 9 |
14755 | 14755 | 2020-03-27 | Norfolk | Massachusetts | 25021 | 393 | 7 |
13047 | 13047 | 2020-03-26 | Norfolk | Massachusetts | 25021 | 292 | 3 |
11466 | 11466 | 2020-03-25 | Norfolk | Massachusetts | 25021 | 222 | 2 |
10054 | 10054 | 2020-03-24 | Norfolk | Massachusetts | 25021 | 129 | 1 |
8765 | 8765 | 2020-03-23 | Norfolk | Massachusetts | 25021 | 82 | 1 |
7593 | 7593 | 2020-03-22 | Norfolk | Massachusetts | 25021 | 75 | 0 |
6516 | 6516 | 2020-03-21 | Norfolk | Massachusetts | 25021 | 69 | 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);