ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where county = "Suffolk" and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387810 | 387810 | 2020-07-31 | Suffolk | New York | 36103 | 43224 | 2044 |
384593 | 384593 | 2020-07-30 | Suffolk | New York | 36103 | 43170 | 2043 |
381375 | 381375 | 2020-07-29 | Suffolk | New York | 36103 | 43084 | 2043 |
378158 | 378158 | 2020-07-28 | Suffolk | New York | 36103 | 43024 | 2043 |
374942 | 374942 | 2020-07-27 | Suffolk | New York | 36103 | 42967 | 2043 |
371730 | 371730 | 2020-07-26 | Suffolk | New York | 36103 | 42883 | 2043 |
368518 | 368518 | 2020-07-25 | Suffolk | New York | 36103 | 42822 | 2043 |
365309 | 365309 | 2020-07-24 | Suffolk | New York | 36103 | 42773 | 2042 |
362103 | 362103 | 2020-07-23 | Suffolk | New York | 36103 | 42715 | 2042 |
358897 | 358897 | 2020-07-22 | Suffolk | New York | 36103 | 42621 | 2042 |
355693 | 355693 | 2020-07-21 | Suffolk | New York | 36103 | 42575 | 2042 |
352490 | 352490 | 2020-07-20 | Suffolk | New York | 36103 | 42496 | 2041 |
349287 | 349287 | 2020-07-19 | Suffolk | New York | 36103 | 42466 | 2041 |
346086 | 346086 | 2020-07-18 | Suffolk | New York | 36103 | 42440 | 2040 |
342887 | 342887 | 2020-07-17 | Suffolk | New York | 36103 | 42382 | 2040 |
339689 | 339689 | 2020-07-16 | Suffolk | New York | 36103 | 42333 | 2039 |
336493 | 336493 | 2020-07-15 | Suffolk | New York | 36103 | 42267 | 2039 |
333299 | 333299 | 2020-07-14 | Suffolk | New York | 36103 | 42214 | 2039 |
330109 | 330109 | 2020-07-13 | Suffolk | New York | 36103 | 42112 | 2039 |
326922 | 326922 | 2020-07-12 | Suffolk | New York | 36103 | 42028 | 2039 |
323738 | 323738 | 2020-07-11 | Suffolk | New York | 36103 | 41987 | 2039 |
320558 | 320558 | 2020-07-10 | Suffolk | New York | 36103 | 41911 | 2038 |
317381 | 317381 | 2020-07-09 | Suffolk | New York | 36103 | 41849 | 2037 |
314207 | 314207 | 2020-07-08 | Suffolk | New York | 36103 | 41799 | 2030 |
311036 | 311036 | 2020-07-07 | Suffolk | New York | 36103 | 41730 | 2031 |
307868 | 307868 | 2020-07-06 | Suffolk | New York | 36103 | 41685 | 2030 |
304701 | 304701 | 2020-07-05 | Suffolk | New York | 36103 | 41642 | 2029 |
301538 | 301538 | 2020-07-04 | Suffolk | New York | 36103 | 41585 | 2029 |
298375 | 298375 | 2020-07-03 | Suffolk | New York | 36103 | 41538 | 2029 |
295215 | 295215 | 2020-07-02 | Suffolk | New York | 36103 | 41491 | 2028 |
292060 | 292060 | 2020-07-01 | Suffolk | New York | 36103 | 41427 | 2028 |
288908 | 288908 | 2020-06-30 | Suffolk | New York | 36103 | 41385 | 2028 |
285758 | 285758 | 2020-06-29 | Suffolk | New York | 36103 | 41339 | 2026 |
282613 | 282613 | 2020-06-28 | Suffolk | New York | 36103 | 41306 | 2026 |
279467 | 279467 | 2020-06-27 | Suffolk | New York | 36103 | 41253 | 2025 |
276319 | 276319 | 2020-06-26 | Suffolk | New York | 36103 | 41208 | 2022 |
273173 | 273173 | 2020-06-25 | Suffolk | New York | 36103 | 41151 | 2022 |
270034 | 270034 | 2020-06-24 | Suffolk | New York | 36103 | 41101 | 2020 |
266900 | 266900 | 2020-06-23 | Suffolk | New York | 36103 | 41056 | 2018 |
263772 | 263772 | 2020-06-22 | Suffolk | New York | 36103 | 41010 | 2014 |
260644 | 260644 | 2020-06-21 | Suffolk | New York | 36103 | 40972 | 2013 |
257517 | 257517 | 2020-06-20 | Suffolk | New York | 36103 | 40908 | 2012 |
254394 | 254394 | 2020-06-19 | Suffolk | New York | 36103 | 40864 | 2011 |
251279 | 251279 | 2020-06-18 | Suffolk | New York | 36103 | 40810 | 2010 |
248164 | 248164 | 2020-06-17 | Suffolk | New York | 36103 | 40770 | 2006 |
245051 | 245051 | 2020-06-16 | Suffolk | New York | 36103 | 40738 | 2005 |
241939 | 241939 | 2020-06-15 | Suffolk | New York | 36103 | 40692 | 2004 |
238830 | 238830 | 2020-06-14 | Suffolk | New York | 36103 | 40659 | 1997 |
235722 | 235722 | 2020-06-13 | Suffolk | New York | 36103 | 40615 | 1996 |
232617 | 232617 | 2020-06-12 | Suffolk | New York | 36103 | 40559 | 1994 |
229512 | 229512 | 2020-06-11 | Suffolk | New York | 36103 | 40512 | 1994 |
226408 | 226408 | 2020-06-10 | Suffolk | New York | 36103 | 40464 | 1990 |
223308 | 223308 | 2020-06-09 | Suffolk | New York | 36103 | 40426 | 1988 |
220214 | 220214 | 2020-06-08 | Suffolk | New York | 36103 | 40377 | 1983 |
217122 | 217122 | 2020-06-07 | Suffolk | New York | 36103 | 40329 | 1978 |
214032 | 214032 | 2020-06-06 | Suffolk | New York | 36103 | 40278 | 1970 |
210948 | 210948 | 2020-06-05 | Suffolk | New York | 36103 | 40239 | 1965 |
207866 | 207866 | 2020-06-04 | Suffolk | New York | 36103 | 40153 | 1963 |
204785 | 204785 | 2020-06-03 | Suffolk | New York | 36103 | 40062 | 1963 |
201708 | 201708 | 2020-06-02 | Suffolk | New York | 36103 | 39980 | 1957 |
198634 | 198634 | 2020-06-01 | Suffolk | New York | 36103 | 39705 | 1954 |
195561 | 195561 | 2020-05-31 | Suffolk | New York | 36103 | 39643 | 1949 |
192491 | 192491 | 2020-05-30 | Suffolk | New York | 36103 | 39532 | 1941 |
189427 | 189427 | 2020-05-29 | Suffolk | New York | 36103 | 39445 | 1928 |
186367 | 186367 | 2020-05-28 | Suffolk | New York | 36103 | 39359 | 1920 |
183310 | 183310 | 2020-05-27 | Suffolk | New York | 36103 | 39258 | 1910 |
180262 | 180262 | 2020-05-26 | Suffolk | New York | 36103 | 39199 | 1900 |
177219 | 177219 | 2020-05-25 | Suffolk | New York | 36103 | 39090 | 1888 |
174175 | 174175 | 2020-05-24 | Suffolk | New York | 36103 | 38964 | 1883 |
171133 | 171133 | 2020-05-23 | Suffolk | New York | 36103 | 38802 | 1871 |
168094 | 168094 | 2020-05-22 | Suffolk | New York | 36103 | 38672 | 1863 |
165059 | 165059 | 2020-05-21 | Suffolk | New York | 36103 | 38553 | 1851 |
162030 | 162030 | 2020-05-20 | Suffolk | New York | 36103 | 38411 | 1840 |
159003 | 159003 | 2020-05-19 | Suffolk | New York | 36103 | 38327 | 1822 |
155985 | 155985 | 2020-05-18 | Suffolk | New York | 36103 | 38224 | 1804 |
152968 | 152968 | 2020-05-17 | Suffolk | New York | 36103 | 38117 | 1799 |
149958 | 149958 | 2020-05-16 | Suffolk | New York | 36103 | 37942 | 1783 |
146951 | 146951 | 2020-05-15 | Suffolk | New York | 36103 | 37719 | 1757 |
143950 | 143950 | 2020-05-14 | Suffolk | New York | 36103 | 37544 | 1745 |
140955 | 140955 | 2020-05-13 | Suffolk | New York | 36103 | 37305 | 1729 |
137959 | 137959 | 2020-05-12 | Suffolk | New York | 36103 | 37062 | 1704 |
134969 | 134969 | 2020-05-11 | Suffolk | New York | 36103 | 36911 | 1689 |
131978 | 131978 | 2020-05-10 | Suffolk | New York | 36103 | 36702 | 1667 |
128989 | 128989 | 2020-05-09 | Suffolk | New York | 36103 | 36461 | 1647 |
126000 | 126000 | 2020-05-08 | Suffolk | New York | 36103 | 36223 | 1616 |
123017 | 123017 | 2020-05-07 | Suffolk | New York | 36103 | 35892 | 1599 |
120042 | 120042 | 2020-05-06 | Suffolk | New York | 36103 | 35543 | 1574 |
117081 | 117081 | 2020-05-05 | Suffolk | New York | 36103 | 35275 | 1347 |
114201 | 114201 | 2020-05-04 | Suffolk | New York | 36103 | 35077 | 1325 |
111320 | 111320 | 2020-05-03 | Suffolk | New York | 36103 | 34855 | 1309 |
108447 | 108447 | 2020-05-02 | Suffolk | New York | 36103 | 34478 | 1277 |
105580 | 105580 | 2020-05-01 | Suffolk | New York | 36103 | 34037 | 1252 |
102718 | 102718 | 2020-04-30 | Suffolk | New York | 36103 | 33664 | 1228 |
99865 | 99865 | 2020-04-29 | Suffolk | New York | 36103 | 33265 | 1205 |
97018 | 97018 | 2020-04-28 | Suffolk | New York | 36103 | 32724 | 1179 |
94182 | 94182 | 2020-04-27 | Suffolk | New York | 36103 | 32470 | 1147 |
91357 | 91357 | 2020-04-26 | Suffolk | New York | 36103 | 32059 | 1115 |
88542 | 88542 | 2020-04-25 | Suffolk | New York | 36103 | 31368 | 1085 |
85730 | 85730 | 2020-04-24 | Suffolk | New York | 36103 | 30606 | 1035 |
82926 | 82926 | 2020-04-23 | Suffolk | New York | 36103 | 29567 | 994 |
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);