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 |
---|---|---|---|---|---|---|---|
387170 | 387170 | 2020-07-31 | Norfolk | Massachusetts | 25021 | 10236 | 984 |
383952 | 383952 | 2020-07-30 | Norfolk | Massachusetts | 25021 | 10160 | 982 |
380735 | 380735 | 2020-07-29 | Norfolk | Massachusetts | 25021 | 10103 | 979 |
377518 | 377518 | 2020-07-28 | Norfolk | Massachusetts | 25021 | 10034 | 977 |
374303 | 374303 | 2020-07-27 | Norfolk | Massachusetts | 25021 | 10013 | 977 |
371091 | 371091 | 2020-07-26 | Norfolk | Massachusetts | 25021 | 9971 | 977 |
367881 | 367881 | 2020-07-25 | Norfolk | Massachusetts | 25021 | 9934 | 976 |
364674 | 364674 | 2020-07-24 | Norfolk | Massachusetts | 25021 | 9895 | 975 |
361467 | 361467 | 2020-07-23 | Norfolk | Massachusetts | 25021 | 9849 | 974 |
358262 | 358262 | 2020-07-22 | Norfolk | Massachusetts | 25021 | 9821 | 972 |
355059 | 355059 | 2020-07-21 | Norfolk | Massachusetts | 25021 | 9779 | 970 |
351857 | 351857 | 2020-07-20 | Norfolk | Massachusetts | 25021 | 9737 | 968 |
348657 | 348657 | 2020-07-19 | Norfolk | Massachusetts | 25021 | 9699 | 967 |
345456 | 345456 | 2020-07-18 | Norfolk | Massachusetts | 25021 | 9658 | 966 |
342256 | 342256 | 2020-07-17 | Norfolk | Massachusetts | 25021 | 9612 | 963 |
339060 | 339060 | 2020-07-16 | Norfolk | Massachusetts | 25021 | 9588 | 962 |
335864 | 335864 | 2020-07-15 | Norfolk | Massachusetts | 25021 | 9560 | 962 |
332671 | 332671 | 2020-07-14 | Norfolk | Massachusetts | 25021 | 9530 | 959 |
329484 | 329484 | 2020-07-13 | Norfolk | Massachusetts | 25021 | 9485 | 958 |
326298 | 326298 | 2020-07-12 | Norfolk | Massachusetts | 25021 | 9462 | 958 |
323115 | 323115 | 2020-07-11 | Norfolk | Massachusetts | 25021 | 9440 | 957 |
319936 | 319936 | 2020-07-10 | Norfolk | Massachusetts | 25021 | 9403 | 956 |
316761 | 316761 | 2020-07-09 | Norfolk | Massachusetts | 25021 | 9384 | 950 |
313587 | 313587 | 2020-07-08 | Norfolk | Massachusetts | 25021 | 9339 | 943 |
310417 | 310417 | 2020-07-07 | Norfolk | Massachusetts | 25021 | 9306 | 941 |
307249 | 307249 | 2020-07-06 | Norfolk | Massachusetts | 25021 | 9284 | 940 |
304082 | 304082 | 2020-07-05 | Norfolk | Massachusetts | 25021 | 9273 | 940 |
300918 | 300918 | 2020-07-04 | Norfolk | Massachusetts | 25021 | 9260 | 937 |
297756 | 297756 | 2020-07-03 | Norfolk | Massachusetts | 25021 | 9242 | 934 |
294598 | 294598 | 2020-07-02 | Norfolk | Massachusetts | 25021 | 9200 | 933 |
291444 | 291444 | 2020-07-01 | Norfolk | Massachusetts | 25021 | 9184 | 930 |
288293 | 288293 | 2020-06-30 | Norfolk | Massachusetts | 25021 | 9166 | 923 |
285143 | 285143 | 2020-06-29 | Norfolk | Massachusetts | 25021 | 9161 | 930 |
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 |
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);