ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
833 rows where fips = 25025 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
79583 | 79583 | 2020-04-22 | Suffolk | Massachusetts | 25025 | 9060 | 318 |
76797 | 76797 | 2020-04-21 | Suffolk | Massachusetts | 25025 | 8669 | 285 |
74017 | 74017 | 2020-04-20 | Suffolk | Massachusetts | 25025 | 8314 | 263 |
71245 | 71245 | 2020-04-19 | Suffolk | Massachusetts | 25025 | 8074 | 238 |
68481 | 68481 | 2020-04-18 | Suffolk | Massachusetts | 25025 | 7696 | 214 |
65731 | 65731 | 2020-04-17 | Suffolk | Massachusetts | 25025 | 7272 | 190 |
62993 | 62993 | 2020-04-16 | Suffolk | Massachusetts | 25025 | 6820 | 166 |
60272 | 60272 | 2020-04-15 | Suffolk | Massachusetts | 25025 | 6279 | 147 |
57563 | 57563 | 2020-04-14 | Suffolk | Massachusetts | 25025 | 5872 | 120 |
54865 | 54865 | 2020-04-13 | Suffolk | Massachusetts | 25025 | 5579 | 106 |
52184 | 52184 | 2020-04-12 | Suffolk | Massachusetts | 25025 | 5359 | 88 |
49514 | 49514 | 2020-04-11 | Suffolk | Massachusetts | 25025 | 4926 | 81 |
46872 | 46872 | 2020-04-10 | Suffolk | Massachusetts | 25025 | 4534 | 73 |
44264 | 44264 | 2020-04-09 | Suffolk | Massachusetts | 25025 | 4041 | 56 |
41688 | 41688 | 2020-04-08 | Suffolk | Massachusetts | 25025 | 3600 | 50 |
39136 | 39136 | 2020-04-07 | Suffolk | Massachusetts | 25025 | 3245 | 42 |
36628 | 36628 | 2020-04-06 | Suffolk | Massachusetts | 25025 | 2929 | 33 |
34169 | 34169 | 2020-04-05 | Suffolk | Massachusetts | 25025 | 2658 | 29 |
31744 | 31744 | 2020-04-04 | Suffolk | Massachusetts | 25025 | 2429 | 28 |
29366 | 29366 | 2020-04-03 | Suffolk | Massachusetts | 25025 | 2183 | 23 |
27048 | 27048 | 2020-04-02 | Suffolk | Massachusetts | 25025 | 1896 | 21 |
24796 | 24796 | 2020-04-01 | Suffolk | Massachusetts | 25025 | 1624 | 15 |
22617 | 22617 | 2020-03-31 | Suffolk | Massachusetts | 25025 | 1373 | 8 |
20508 | 20508 | 2020-03-30 | Suffolk | Massachusetts | 25025 | 1115 | 7 |
18492 | 18492 | 2020-03-29 | Suffolk | Massachusetts | 25025 | 940 | 5 |
16577 | 16577 | 2020-03-28 | Suffolk | Massachusetts | 25025 | 843 | 5 |
14757 | 14757 | 2020-03-27 | Suffolk | Massachusetts | 25025 | 631 | 4 |
13049 | 13049 | 2020-03-26 | Suffolk | Massachusetts | 25025 | 448 | 4 |
11468 | 11468 | 2020-03-25 | Suffolk | Massachusetts | 25025 | 342 | 3 |
10056 | 10056 | 2020-03-24 | Suffolk | Massachusetts | 25025 | 234 | 3 |
8767 | 8767 | 2020-03-23 | Suffolk | Massachusetts | 25025 | 154 | 3 |
7595 | 7595 | 2020-03-22 | Suffolk | Massachusetts | 25025 | 126 | 2 |
6518 | 6518 | 2020-03-21 | Suffolk | Massachusetts | 25025 | 108 | 1 |
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);