ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,630 rows where county = "Suffolk" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
45 | 45 | 2020-02-01 | Suffolk | Massachusetts | 25025 | 1 | 0 |
53 | 53 | 2020-02-02 | Suffolk | Massachusetts | 25025 | 1 | 0 |
61 | 61 | 2020-02-03 | Suffolk | Massachusetts | 25025 | 1 | 0 |
69 | 69 | 2020-02-04 | Suffolk | Massachusetts | 25025 | 1 | 0 |
77 | 77 | 2020-02-05 | Suffolk | Massachusetts | 25025 | 1 | 0 |
86 | 86 | 2020-02-06 | Suffolk | Massachusetts | 25025 | 1 | 0 |
95 | 95 | 2020-02-07 | Suffolk | Massachusetts | 25025 | 1 | 0 |
104 | 104 | 2020-02-08 | Suffolk | Massachusetts | 25025 | 1 | 0 |
113 | 113 | 2020-02-09 | Suffolk | Massachusetts | 25025 | 1 | 0 |
123 | 123 | 2020-02-10 | Suffolk | Massachusetts | 25025 | 1 | 0 |
133 | 133 | 2020-02-11 | Suffolk | Massachusetts | 25025 | 1 | 0 |
143 | 143 | 2020-02-12 | Suffolk | Massachusetts | 25025 | 1 | 0 |
154 | 154 | 2020-02-13 | Suffolk | Massachusetts | 25025 | 1 | 0 |
165 | 165 | 2020-02-14 | Suffolk | Massachusetts | 25025 | 1 | 0 |
176 | 176 | 2020-02-15 | Suffolk | Massachusetts | 25025 | 1 | 0 |
187 | 187 | 2020-02-16 | Suffolk | Massachusetts | 25025 | 1 | 0 |
198 | 198 | 2020-02-17 | Suffolk | Massachusetts | 25025 | 1 | 0 |
210 | 210 | 2020-02-18 | Suffolk | Massachusetts | 25025 | 1 | 0 |
222 | 222 | 2020-02-19 | Suffolk | Massachusetts | 25025 | 1 | 0 |
235 | 235 | 2020-02-20 | Suffolk | Massachusetts | 25025 | 1 | 0 |
249 | 249 | 2020-02-21 | Suffolk | Massachusetts | 25025 | 1 | 0 |
263 | 263 | 2020-02-22 | Suffolk | Massachusetts | 25025 | 1 | 0 |
277 | 277 | 2020-02-23 | Suffolk | Massachusetts | 25025 | 1 | 0 |
292 | 292 | 2020-02-24 | Suffolk | Massachusetts | 25025 | 1 | 0 |
308 | 308 | 2020-02-25 | Suffolk | Massachusetts | 25025 | 1 | 0 |
328 | 328 | 2020-02-26 | Suffolk | Massachusetts | 25025 | 1 | 0 |
348 | 348 | 2020-02-27 | Suffolk | Massachusetts | 25025 | 1 | 0 |
368 | 368 | 2020-02-28 | Suffolk | Massachusetts | 25025 | 1 | 0 |
390 | 390 | 2020-02-29 | Suffolk | Massachusetts | 25025 | 1 | 0 |
415 | 415 | 2020-03-01 | Suffolk | Massachusetts | 25025 | 1 | 0 |
446 | 446 | 2020-03-02 | Suffolk | Massachusetts | 25025 | 1 | 0 |
480 | 480 | 2020-03-03 | Suffolk | Massachusetts | 25025 | 1 | 0 |
515 | 515 | 2020-03-04 | Suffolk | Massachusetts | 25025 | 1 | 0 |
559 | 559 | 2020-03-05 | Suffolk | Massachusetts | 25025 | 1 | 0 |
619 | 619 | 2020-03-06 | Suffolk | Massachusetts | 25025 | 4 | 0 |
705 | 705 | 2020-03-07 | Suffolk | Massachusetts | 25025 | 4 | 0 |
807 | 807 | 2020-03-08 | Suffolk | Massachusetts | 25025 | 9 | 0 |
824 | 824 | 2020-03-08 | Suffolk | New York | 36103 | 1 | 0 |
931 | 931 | 2020-03-09 | Suffolk | Massachusetts | 25025 | 10 | 0 |
951 | 951 | 2020-03-09 | Suffolk | New York | 36103 | 1 | 0 |
1078 | 1078 | 2020-03-10 | Suffolk | Massachusetts | 25025 | 20 | 0 |
1102 | 1102 | 2020-03-10 | Suffolk | New York | 36103 | 1 | 0 |
1258 | 1258 | 2020-03-11 | Suffolk | Massachusetts | 25025 | 20 | 0 |
1289 | 1289 | 2020-03-11 | Suffolk | New York | 36103 | 6 | 0 |
1476 | 1476 | 2020-03-12 | Suffolk | Massachusetts | 25025 | 22 | 0 |
1526 | 1526 | 2020-03-12 | Suffolk | New York | 36103 | 21 | 0 |
1755 | 1755 | 2020-03-13 | Suffolk | Massachusetts | 25025 | 26 | 0 |
1820 | 1820 | 2020-03-13 | Suffolk | New York | 36103 | 29 | 0 |
2098 | 2098 | 2020-03-14 | Suffolk | Massachusetts | 25025 | 27 | 0 |
2169 | 2169 | 2020-03-14 | Suffolk | New York | 36103 | 41 | 0 |
2501 | 2501 | 2020-03-15 | Suffolk | Massachusetts | 25025 | 31 | 0 |
2581 | 2581 | 2020-03-15 | Suffolk | New York | 36103 | 47 | 0 |
2950 | 2950 | 2020-03-16 | Suffolk | Massachusetts | 25025 | 42 | 0 |
3451 | 3451 | 2020-03-17 | Suffolk | Massachusetts | 25025 | 42 | 0 |
4034 | 4034 | 2020-03-18 | Suffolk | Massachusetts | 25025 | 51 | 0 |
4739 | 4739 | 2020-03-19 | Suffolk | Massachusetts | 25025 | 72 | 0 |
5558 | 5558 | 2020-03-20 | Suffolk | Massachusetts | 25025 | 87 | 1 |
6518 | 6518 | 2020-03-21 | Suffolk | Massachusetts | 25025 | 108 | 1 |
3042 | 3042 | 2020-03-16 | Suffolk | New York | 36103 | 63 | 2 |
7595 | 7595 | 2020-03-22 | Suffolk | Massachusetts | 25025 | 126 | 2 |
3559 | 3559 | 2020-03-17 | Suffolk | New York | 36103 | 84 | 3 |
4160 | 4160 | 2020-03-18 | Suffolk | New York | 36103 | 116 | 3 |
4890 | 4890 | 2020-03-19 | Suffolk | New York | 36103 | 178 | 3 |
8767 | 8767 | 2020-03-23 | Suffolk | Massachusetts | 25025 | 154 | 3 |
10056 | 10056 | 2020-03-24 | Suffolk | Massachusetts | 25025 | 234 | 3 |
11468 | 11468 | 2020-03-25 | Suffolk | Massachusetts | 25025 | 342 | 3 |
13049 | 13049 | 2020-03-26 | Suffolk | Massachusetts | 25025 | 448 | 4 |
14757 | 14757 | 2020-03-27 | Suffolk | Massachusetts | 25025 | 631 | 4 |
16577 | 16577 | 2020-03-28 | Suffolk | Massachusetts | 25025 | 843 | 5 |
18492 | 18492 | 2020-03-29 | Suffolk | Massachusetts | 25025 | 940 | 5 |
5741 | 5741 | 2020-03-20 | Suffolk | New York | 36103 | 371 | 7 |
20508 | 20508 | 2020-03-30 | Suffolk | Massachusetts | 25025 | 1115 | 7 |
22617 | 22617 | 2020-03-31 | Suffolk | Massachusetts | 25025 | 1373 | 8 |
6736 | 6736 | 2020-03-21 | Suffolk | New York | 36103 | 662 | 9 |
7832 | 7832 | 2020-03-22 | Suffolk | New York | 36103 | 1034 | 12 |
9032 | 9032 | 2020-03-23 | Suffolk | New York | 36103 | 1458 | 13 |
10340 | 10340 | 2020-03-24 | Suffolk | New York | 36103 | 1880 | 13 |
24796 | 24796 | 2020-04-01 | Suffolk | Massachusetts | 25025 | 1624 | 15 |
11776 | 11776 | 2020-03-25 | Suffolk | New York | 36103 | 2260 | 20 |
27048 | 27048 | 2020-04-02 | Suffolk | Massachusetts | 25025 | 1896 | 21 |
13379 | 13379 | 2020-03-26 | Suffolk | New York | 36103 | 2735 | 22 |
15113 | 15113 | 2020-03-27 | Suffolk | New York | 36103 | 3385 | 22 |
29366 | 29366 | 2020-04-03 | Suffolk | Massachusetts | 25025 | 2183 | 23 |
31744 | 31744 | 2020-04-04 | Suffolk | Massachusetts | 25025 | 2429 | 28 |
34169 | 34169 | 2020-04-05 | Suffolk | Massachusetts | 25025 | 2658 | 29 |
36628 | 36628 | 2020-04-06 | Suffolk | Massachusetts | 25025 | 2929 | 33 |
16944 | 16944 | 2020-03-28 | Suffolk | New York | 36103 | 4138 | 37 |
18869 | 18869 | 2020-03-29 | Suffolk | New York | 36103 | 5023 | 40 |
39136 | 39136 | 2020-04-07 | Suffolk | Massachusetts | 25025 | 3245 | 42 |
20908 | 20908 | 2020-03-30 | Suffolk | New York | 36103 | 5791 | 44 |
41688 | 41688 | 2020-04-08 | Suffolk | Massachusetts | 25025 | 3600 | 50 |
23032 | 23032 | 2020-03-31 | Suffolk | New York | 36103 | 6713 | 53 |
44264 | 44264 | 2020-04-09 | Suffolk | Massachusetts | 25025 | 4041 | 56 |
25226 | 25226 | 2020-04-01 | Suffolk | New York | 36103 | 7605 | 69 |
46872 | 46872 | 2020-04-10 | Suffolk | Massachusetts | 25025 | 4534 | 73 |
49514 | 49514 | 2020-04-11 | Suffolk | Massachusetts | 25025 | 4926 | 81 |
27486 | 27486 | 2020-04-02 | Suffolk | New York | 36103 | 8746 | 84 |
52184 | 52184 | 2020-04-12 | Suffolk | Massachusetts | 25025 | 5359 | 88 |
29810 | 29810 | 2020-04-03 | Suffolk | New York | 36103 | 10154 | 96 |
54865 | 54865 | 2020-04-13 | Suffolk | Massachusetts | 25025 | 5579 | 106 |
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);