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 state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
824 | 824 | 2020-03-08 | Suffolk | New York | 36103 | 1 | 0 |
951 | 951 | 2020-03-09 | Suffolk | New York | 36103 | 1 | 0 |
1102 | 1102 | 2020-03-10 | Suffolk | New York | 36103 | 1 | 0 |
1289 | 1289 | 2020-03-11 | Suffolk | New York | 36103 | 6 | 0 |
1526 | 1526 | 2020-03-12 | Suffolk | New York | 36103 | 21 | 0 |
1820 | 1820 | 2020-03-13 | Suffolk | New York | 36103 | 29 | 0 |
2169 | 2169 | 2020-03-14 | Suffolk | New York | 36103 | 41 | 0 |
2581 | 2581 | 2020-03-15 | Suffolk | New York | 36103 | 47 | 0 |
3042 | 3042 | 2020-03-16 | Suffolk | New York | 36103 | 63 | 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 |
5741 | 5741 | 2020-03-20 | Suffolk | New York | 36103 | 371 | 7 |
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 |
11776 | 11776 | 2020-03-25 | Suffolk | New York | 36103 | 2260 | 20 |
13379 | 13379 | 2020-03-26 | Suffolk | New York | 36103 | 2735 | 22 |
15113 | 15113 | 2020-03-27 | Suffolk | New York | 36103 | 3385 | 22 |
16944 | 16944 | 2020-03-28 | Suffolk | New York | 36103 | 4138 | 37 |
18869 | 18869 | 2020-03-29 | Suffolk | New York | 36103 | 5023 | 40 |
20908 | 20908 | 2020-03-30 | Suffolk | New York | 36103 | 5791 | 44 |
23032 | 23032 | 2020-03-31 | Suffolk | New York | 36103 | 6713 | 53 |
25226 | 25226 | 2020-04-01 | Suffolk | New York | 36103 | 7605 | 69 |
27486 | 27486 | 2020-04-02 | Suffolk | New York | 36103 | 8746 | 84 |
29810 | 29810 | 2020-04-03 | Suffolk | New York | 36103 | 10154 | 96 |
32196 | 32196 | 2020-04-04 | Suffolk | New York | 36103 | 12328 | 175 |
34627 | 34627 | 2020-04-05 | Suffolk | New York | 36103 | 12933 | 175 |
37097 | 37097 | 2020-04-06 | Suffolk | New York | 36103 | 14473 | 237 |
39612 | 39612 | 2020-04-07 | Suffolk | New York | 36103 | 15561 | 266 |
42169 | 42169 | 2020-04-08 | Suffolk | New York | 36103 | 15844 | 328 |
44752 | 44752 | 2020-04-09 | Suffolk | New York | 36103 | 17413 | 369 |
47365 | 47365 | 2020-04-10 | Suffolk | New York | 36103 | 18692 | 425 |
50020 | 50020 | 2020-04-11 | Suffolk | New York | 36103 | 19883 | 469 |
52693 | 52693 | 2020-04-12 | Suffolk | New York | 36103 | 20816 | 529 |
55376 | 55376 | 2020-04-13 | Suffolk | New York | 36103 | 21643 | 580 |
58076 | 58076 | 2020-04-14 | Suffolk | New York | 36103 | 22462 | 617 |
60790 | 60790 | 2020-04-15 | Suffolk | New York | 36103 | 23278 | 663 |
63516 | 63516 | 2020-04-16 | Suffolk | New York | 36103 | 24182 | 706 |
66258 | 66258 | 2020-04-17 | Suffolk | New York | 36103 | 25035 | 706 |
69015 | 69015 | 2020-04-18 | Suffolk | New York | 36103 | 26143 | 706 |
71782 | 71782 | 2020-04-19 | Suffolk | New York | 36103 | 26888 | 845 |
74557 | 74557 | 2020-04-20 | Suffolk | New York | 36103 | 27662 | 887 |
77338 | 77338 | 2020-04-21 | Suffolk | New York | 36103 | 28154 | 918 |
80127 | 80127 | 2020-04-22 | Suffolk | New York | 36103 | 28854 | 959 |
82926 | 82926 | 2020-04-23 | Suffolk | New York | 36103 | 29567 | 994 |
85730 | 85730 | 2020-04-24 | Suffolk | New York | 36103 | 30606 | 1035 |
88542 | 88542 | 2020-04-25 | Suffolk | New York | 36103 | 31368 | 1085 |
91357 | 91357 | 2020-04-26 | Suffolk | New York | 36103 | 32059 | 1115 |
94182 | 94182 | 2020-04-27 | Suffolk | New York | 36103 | 32470 | 1147 |
97018 | 97018 | 2020-04-28 | Suffolk | New York | 36103 | 32724 | 1179 |
99865 | 99865 | 2020-04-29 | Suffolk | New York | 36103 | 33265 | 1205 |
102718 | 102718 | 2020-04-30 | Suffolk | New York | 36103 | 33664 | 1228 |
105580 | 105580 | 2020-05-01 | Suffolk | New York | 36103 | 34037 | 1252 |
108447 | 108447 | 2020-05-02 | Suffolk | New York | 36103 | 34478 | 1277 |
111320 | 111320 | 2020-05-03 | Suffolk | New York | 36103 | 34855 | 1309 |
114201 | 114201 | 2020-05-04 | Suffolk | New York | 36103 | 35077 | 1325 |
117081 | 117081 | 2020-05-05 | Suffolk | New York | 36103 | 35275 | 1347 |
120042 | 120042 | 2020-05-06 | Suffolk | New York | 36103 | 35543 | 1574 |
123017 | 123017 | 2020-05-07 | Suffolk | New York | 36103 | 35892 | 1599 |
126000 | 126000 | 2020-05-08 | Suffolk | New York | 36103 | 36223 | 1616 |
128989 | 128989 | 2020-05-09 | Suffolk | New York | 36103 | 36461 | 1647 |
131978 | 131978 | 2020-05-10 | Suffolk | New York | 36103 | 36702 | 1667 |
134969 | 134969 | 2020-05-11 | Suffolk | New York | 36103 | 36911 | 1689 |
137959 | 137959 | 2020-05-12 | Suffolk | New York | 36103 | 37062 | 1704 |
140955 | 140955 | 2020-05-13 | Suffolk | New York | 36103 | 37305 | 1729 |
143950 | 143950 | 2020-05-14 | Suffolk | New York | 36103 | 37544 | 1745 |
146951 | 146951 | 2020-05-15 | Suffolk | New York | 36103 | 37719 | 1757 |
149958 | 149958 | 2020-05-16 | Suffolk | New York | 36103 | 37942 | 1783 |
152968 | 152968 | 2020-05-17 | Suffolk | New York | 36103 | 38117 | 1799 |
155985 | 155985 | 2020-05-18 | Suffolk | New York | 36103 | 38224 | 1804 |
159003 | 159003 | 2020-05-19 | Suffolk | New York | 36103 | 38327 | 1822 |
162030 | 162030 | 2020-05-20 | Suffolk | New York | 36103 | 38411 | 1840 |
165059 | 165059 | 2020-05-21 | Suffolk | New York | 36103 | 38553 | 1851 |
168094 | 168094 | 2020-05-22 | Suffolk | New York | 36103 | 38672 | 1863 |
171133 | 171133 | 2020-05-23 | Suffolk | New York | 36103 | 38802 | 1871 |
174175 | 174175 | 2020-05-24 | Suffolk | New York | 36103 | 38964 | 1883 |
177219 | 177219 | 2020-05-25 | Suffolk | New York | 36103 | 39090 | 1888 |
180262 | 180262 | 2020-05-26 | Suffolk | New York | 36103 | 39199 | 1900 |
183310 | 183310 | 2020-05-27 | Suffolk | New York | 36103 | 39258 | 1910 |
186367 | 186367 | 2020-05-28 | Suffolk | New York | 36103 | 39359 | 1920 |
189427 | 189427 | 2020-05-29 | Suffolk | New York | 36103 | 39445 | 1928 |
192491 | 192491 | 2020-05-30 | Suffolk | New York | 36103 | 39532 | 1941 |
195561 | 195561 | 2020-05-31 | Suffolk | New York | 36103 | 39643 | 1949 |
198634 | 198634 | 2020-06-01 | Suffolk | New York | 36103 | 39705 | 1954 |
201708 | 201708 | 2020-06-02 | Suffolk | New York | 36103 | 39980 | 1957 |
204785 | 204785 | 2020-06-03 | Suffolk | New York | 36103 | 40062 | 1963 |
207866 | 207866 | 2020-06-04 | Suffolk | New York | 36103 | 40153 | 1963 |
210948 | 210948 | 2020-06-05 | Suffolk | New York | 36103 | 40239 | 1965 |
214032 | 214032 | 2020-06-06 | Suffolk | New York | 36103 | 40278 | 1970 |
217122 | 217122 | 2020-06-07 | Suffolk | New York | 36103 | 40329 | 1978 |
220214 | 220214 | 2020-06-08 | Suffolk | New York | 36103 | 40377 | 1983 |
223308 | 223308 | 2020-06-09 | Suffolk | New York | 36103 | 40426 | 1988 |
226408 | 226408 | 2020-06-10 | Suffolk | New York | 36103 | 40464 | 1990 |
229512 | 229512 | 2020-06-11 | Suffolk | New York | 36103 | 40512 | 1994 |
232617 | 232617 | 2020-06-12 | Suffolk | New York | 36103 | 40559 | 1994 |
235722 | 235722 | 2020-06-13 | Suffolk | New York | 36103 | 40615 | 1996 |
238830 | 238830 | 2020-06-14 | Suffolk | New York | 36103 | 40659 | 1997 |
241939 | 241939 | 2020-06-15 | Suffolk | New York | 36103 | 40692 | 2004 |
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);