ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
833 rows where fips = 25025 and state = "Massachusetts" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387172 | 387172 | 2020-07-31 | Suffolk | Massachusetts | 25025 | 21222 | 1055 |
383954 | 383954 | 2020-07-30 | Suffolk | Massachusetts | 25025 | 21113 | 1055 |
380737 | 380737 | 2020-07-29 | Suffolk | Massachusetts | 25025 | 21030 | 1054 |
377520 | 377520 | 2020-07-28 | Suffolk | Massachusetts | 25025 | 20960 | 1052 |
374305 | 374305 | 2020-07-27 | Suffolk | Massachusetts | 25025 | 20914 | 1048 |
371093 | 371093 | 2020-07-26 | Suffolk | Massachusetts | 25025 | 20896 | 1048 |
367883 | 367883 | 2020-07-25 | Suffolk | Massachusetts | 25025 | 20827 | 1046 |
364676 | 364676 | 2020-07-24 | Suffolk | Massachusetts | 25025 | 20793 | 1044 |
361469 | 361469 | 2020-07-23 | Suffolk | Massachusetts | 25025 | 20732 | 1042 |
358264 | 358264 | 2020-07-22 | Suffolk | Massachusetts | 25025 | 20678 | 1039 |
355061 | 355061 | 2020-07-21 | Suffolk | Massachusetts | 25025 | 20650 | 1039 |
351859 | 351859 | 2020-07-20 | Suffolk | Massachusetts | 25025 | 20621 | 1035 |
348659 | 348659 | 2020-07-19 | Suffolk | Massachusetts | 25025 | 20601 | 1035 |
345458 | 345458 | 2020-07-18 | Suffolk | Massachusetts | 25025 | 20555 | 1035 |
342258 | 342258 | 2020-07-17 | Suffolk | Massachusetts | 25025 | 20499 | 1030 |
339062 | 339062 | 2020-07-16 | Suffolk | Massachusetts | 25025 | 20445 | 1027 |
335866 | 335866 | 2020-07-15 | Suffolk | Massachusetts | 25025 | 20411 | 1024 |
332673 | 332673 | 2020-07-14 | Suffolk | Massachusetts | 25025 | 20386 | 1022 |
329486 | 329486 | 2020-07-13 | Suffolk | Massachusetts | 25025 | 20342 | 1020 |
326300 | 326300 | 2020-07-12 | Suffolk | Massachusetts | 25025 | 20301 | 1020 |
323117 | 323117 | 2020-07-11 | Suffolk | Massachusetts | 25025 | 20272 | 1018 |
319938 | 319938 | 2020-07-10 | Suffolk | Massachusetts | 25025 | 20228 | 1016 |
316763 | 316763 | 2020-07-09 | Suffolk | Massachusetts | 25025 | 20172 | 1013 |
313589 | 313589 | 2020-07-08 | Suffolk | Massachusetts | 25025 | 20120 | 1012 |
310419 | 310419 | 2020-07-07 | Suffolk | Massachusetts | 25025 | 20048 | 1008 |
307251 | 307251 | 2020-07-06 | Suffolk | Massachusetts | 25025 | 20014 | 1008 |
304084 | 304084 | 2020-07-05 | Suffolk | Massachusetts | 25025 | 19985 | 1007 |
300920 | 300920 | 2020-07-04 | Suffolk | Massachusetts | 25025 | 19972 | 1008 |
297758 | 297758 | 2020-07-03 | Suffolk | Massachusetts | 25025 | 19936 | 1009 |
294600 | 294600 | 2020-07-02 | Suffolk | Massachusetts | 25025 | 19892 | 1008 |
291446 | 291446 | 2020-07-01 | Suffolk | Massachusetts | 25025 | 19853 | 1004 |
288295 | 288295 | 2020-06-30 | Suffolk | Massachusetts | 25025 | 19819 | 1002 |
285145 | 285145 | 2020-06-29 | Suffolk | Massachusetts | 25025 | 19795 | 1007 |
282000 | 282000 | 2020-06-28 | Suffolk | Massachusetts | 25025 | 19795 | 1004 |
278852 | 278852 | 2020-06-27 | Suffolk | Massachusetts | 25025 | 19764 | 1004 |
275704 | 275704 | 2020-06-26 | Suffolk | Massachusetts | 25025 | 19707 | 997 |
272561 | 272561 | 2020-06-25 | Suffolk | Massachusetts | 25025 | 19664 | 990 |
269424 | 269424 | 2020-06-24 | Suffolk | Massachusetts | 25025 | 19628 | 984 |
266291 | 266291 | 2020-06-23 | Suffolk | Massachusetts | 25025 | 19601 | 976 |
263165 | 263165 | 2020-06-22 | Suffolk | Massachusetts | 25025 | 19567 | 979 |
260036 | 260036 | 2020-06-21 | Suffolk | Massachusetts | 25025 | 19551 | 978 |
256910 | 256910 | 2020-06-20 | Suffolk | Massachusetts | 25025 | 19528 | 973 |
253790 | 253790 | 2020-06-19 | Suffolk | Massachusetts | 25025 | 19493 | 971 |
250675 | 250675 | 2020-06-18 | Suffolk | Massachusetts | 25025 | 19477 | 963 |
247563 | 247563 | 2020-06-17 | Suffolk | Massachusetts | 25025 | 19434 | 959 |
244450 | 244450 | 2020-06-16 | Suffolk | Massachusetts | 25025 | 19367 | 952 |
241339 | 241339 | 2020-06-15 | Suffolk | Massachusetts | 25025 | 19334 | 951 |
238230 | 238230 | 2020-06-14 | Suffolk | Massachusetts | 25025 | 19335 | 950 |
235123 | 235123 | 2020-06-13 | Suffolk | Massachusetts | 25025 | 19299 | 943 |
232018 | 232018 | 2020-06-12 | Suffolk | Massachusetts | 25025 | 19249 | 941 |
228914 | 228914 | 2020-06-11 | Suffolk | Massachusetts | 25025 | 19195 | 938 |
225812 | 225812 | 2020-06-10 | Suffolk | Massachusetts | 25025 | 19099 | 936 |
222716 | 222716 | 2020-06-09 | Suffolk | Massachusetts | 25025 | 19067 | 935 |
219621 | 219621 | 2020-06-08 | Suffolk | Massachusetts | 25025 | 19028 | 931 |
216529 | 216529 | 2020-06-07 | Suffolk | Massachusetts | 25025 | 19001 | 924 |
213441 | 213441 | 2020-06-06 | Suffolk | Massachusetts | 25025 | 18955 | 923 |
210357 | 210357 | 2020-06-05 | Suffolk | Massachusetts | 25025 | 18858 | 922 |
207276 | 207276 | 2020-06-04 | Suffolk | Massachusetts | 25025 | 18790 | 913 |
204195 | 204195 | 2020-06-03 | Suffolk | Massachusetts | 25025 | 18733 | 908 |
201118 | 201118 | 2020-06-02 | Suffolk | Massachusetts | 25025 | 18636 | 902 |
198046 | 198046 | 2020-06-01 | Suffolk | Massachusetts | 25025 | 18581 | 896 |
194975 | 194975 | 2020-05-31 | Suffolk | Massachusetts | 25025 | 17936 | 871 |
191907 | 191907 | 2020-05-30 | Suffolk | Massachusetts | 25025 | 17873 | 868 |
188843 | 188843 | 2020-05-29 | Suffolk | Massachusetts | 25025 | 17786 | 861 |
185785 | 185785 | 2020-05-28 | Suffolk | Massachusetts | 25025 | 17698 | 852 |
182730 | 182730 | 2020-05-27 | Suffolk | Massachusetts | 25025 | 17596 | 850 |
179684 | 179684 | 2020-05-26 | Suffolk | Massachusetts | 25025 | 17533 | 844 |
176640 | 176640 | 2020-05-25 | Suffolk | Massachusetts | 25025 | 17480 | 839 |
173597 | 173597 | 2020-05-24 | Suffolk | Massachusetts | 25025 | 17417 | 838 |
170555 | 170555 | 2020-05-23 | Suffolk | Massachusetts | 25025 | 17291 | 827 |
167518 | 167518 | 2020-05-22 | Suffolk | Massachusetts | 25025 | 17180 | 818 |
164482 | 164482 | 2020-05-21 | Suffolk | Massachusetts | 25025 | 17089 | 813 |
161453 | 161453 | 2020-05-20 | Suffolk | Massachusetts | 25025 | 16962 | 807 |
158427 | 158427 | 2020-05-19 | Suffolk | Massachusetts | 25025 | 16825 | 797 |
155409 | 155409 | 2020-05-18 | Suffolk | Massachusetts | 25025 | 16671 | 793 |
152395 | 152395 | 2020-05-17 | Suffolk | Massachusetts | 25025 | 16479 | 787 |
149384 | 149384 | 2020-05-16 | Suffolk | Massachusetts | 25025 | 16346 | 778 |
146379 | 146379 | 2020-05-15 | Suffolk | Massachusetts | 25025 | 15996 | 768 |
143379 | 143379 | 2020-05-14 | Suffolk | Massachusetts | 25025 | 15881 | 759 |
140384 | 140384 | 2020-05-13 | Suffolk | Massachusetts | 25025 | 15587 | 749 |
137390 | 137390 | 2020-05-12 | Suffolk | Massachusetts | 25025 | 15454 | 732 |
134400 | 134400 | 2020-05-11 | Suffolk | Massachusetts | 25025 | 15356 | 731 |
131409 | 131409 | 2020-05-10 | Suffolk | Massachusetts | 25025 | 15279 | 718 |
128419 | 128419 | 2020-05-09 | Suffolk | Massachusetts | 25025 | 15119 | 703 |
125432 | 125432 | 2020-05-08 | Suffolk | Massachusetts | 25025 | 14944 | 683 |
122450 | 122450 | 2020-05-07 | Suffolk | Massachusetts | 25025 | 14732 | 663 |
119478 | 119478 | 2020-05-06 | Suffolk | Massachusetts | 25025 | 14476 | 642 |
116517 | 116517 | 2020-05-05 | Suffolk | Massachusetts | 25025 | 14173 | 609 |
113636 | 113636 | 2020-05-04 | Suffolk | Massachusetts | 25025 | 13941 | 596 |
110758 | 110758 | 2020-05-03 | Suffolk | Massachusetts | 25025 | 13777 | 588 |
107886 | 107886 | 2020-05-02 | Suffolk | Massachusetts | 25025 | 13606 | 569 |
105022 | 105022 | 2020-05-01 | Suffolk | Massachusetts | 25025 | 13295 | 550 |
102162 | 102162 | 2020-04-30 | Suffolk | Massachusetts | 25025 | 12890 | 524 |
99310 | 99310 | 2020-04-29 | Suffolk | Massachusetts | 25025 | 12539 | 504 |
96464 | 96464 | 2020-04-28 | Suffolk | Massachusetts | 25025 | 12140 | 469 |
93629 | 93629 | 2020-04-27 | Suffolk | Massachusetts | 25025 | 11883 | 448 |
90808 | 90808 | 2020-04-26 | Suffolk | Massachusetts | 25025 | 11543 | 424 |
87992 | 87992 | 2020-04-25 | Suffolk | Massachusetts | 25025 | 11218 | 391 |
85182 | 85182 | 2020-04-24 | Suffolk | Massachusetts | 25025 | 10724 | 372 |
82378 | 82378 | 2020-04-23 | Suffolk | Massachusetts | 25025 | 9739 | 346 |
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);