ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Suffolk city" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
7040 | 7040 | 2020-03-21 | Suffolk city | Virginia | 51800 | 1 | 0 |
8177 | 8177 | 2020-03-22 | Suffolk city | Virginia | 51800 | 1 | 0 |
9400 | 9400 | 2020-03-23 | Suffolk city | Virginia | 51800 | 1 | 0 |
10748 | 10748 | 2020-03-24 | Suffolk city | Virginia | 51800 | 1 | 0 |
12270 | 12270 | 2020-03-25 | Suffolk city | Virginia | 51800 | 1 | 0 |
13918 | 13918 | 2020-03-26 | Suffolk city | Virginia | 51800 | 1 | 0 |
15687 | 15687 | 2020-03-27 | Suffolk city | Virginia | 51800 | 1 | 0 |
17567 | 17567 | 2020-03-28 | Suffolk city | Virginia | 51800 | 1 | 0 |
19529 | 19529 | 2020-03-29 | Suffolk city | Virginia | 51800 | 1 | 0 |
21596 | 21596 | 2020-03-30 | Suffolk city | Virginia | 51800 | 3 | 0 |
23743 | 23743 | 2020-03-31 | Suffolk city | Virginia | 51800 | 4 | 0 |
25959 | 25959 | 2020-04-01 | Suffolk city | Virginia | 51800 | 6 | 0 |
28250 | 28250 | 2020-04-02 | Suffolk city | Virginia | 51800 | 6 | 0 |
30599 | 30599 | 2020-04-03 | Suffolk city | Virginia | 51800 | 10 | 0 |
32999 | 32999 | 2020-04-04 | Suffolk city | Virginia | 51800 | 20 | 0 |
35437 | 35437 | 2020-04-05 | Suffolk city | Virginia | 51800 | 22 | 0 |
37921 | 37921 | 2020-04-06 | Suffolk city | Virginia | 51800 | 28 | 0 |
40456 | 40456 | 2020-04-07 | Suffolk city | Virginia | 51800 | 30 | 0 |
43025 | 43025 | 2020-04-08 | Suffolk city | Virginia | 51800 | 31 | 0 |
45621 | 45621 | 2020-04-09 | Suffolk city | Virginia | 51800 | 31 | 0 |
48248 | 48248 | 2020-04-10 | Suffolk city | Virginia | 51800 | 35 | 0 |
50906 | 50906 | 2020-04-11 | Suffolk city | Virginia | 51800 | 40 | 0 |
53581 | 53581 | 2020-04-12 | Suffolk city | Virginia | 51800 | 48 | 0 |
56271 | 56271 | 2020-04-13 | Suffolk city | Virginia | 51800 | 51 | 0 |
58977 | 58977 | 2020-04-14 | Suffolk city | Virginia | 51800 | 57 | 0 |
61696 | 61696 | 2020-04-15 | Suffolk city | Virginia | 51800 | 59 | 0 |
64429 | 64429 | 2020-04-16 | Suffolk city | Virginia | 51800 | 65 | 0 |
67177 | 67177 | 2020-04-17 | Suffolk city | Virginia | 51800 | 70 | 0 |
69939 | 69939 | 2020-04-18 | Suffolk city | Virginia | 51800 | 81 | 0 |
72709 | 72709 | 2020-04-19 | Suffolk city | Virginia | 51800 | 91 | 0 |
75485 | 75485 | 2020-04-20 | Suffolk city | Virginia | 51800 | 92 | 0 |
78269 | 78269 | 2020-04-21 | Suffolk city | Virginia | 51800 | 111 | 2 |
81062 | 81062 | 2020-04-22 | Suffolk city | Virginia | 51800 | 126 | 3 |
83863 | 83863 | 2020-04-23 | Suffolk city | Virginia | 51800 | 136 | 3 |
86670 | 86670 | 2020-04-24 | Suffolk city | Virginia | 51800 | 138 | 4 |
89485 | 89485 | 2020-04-25 | Suffolk city | Virginia | 51800 | 141 | 5 |
92302 | 92302 | 2020-04-26 | Suffolk city | Virginia | 51800 | 147 | 5 |
95131 | 95131 | 2020-04-27 | Suffolk city | Virginia | 51800 | 147 | 5 |
97975 | 97975 | 2020-04-28 | Suffolk city | Virginia | 51800 | 152 | 8 |
100825 | 100825 | 2020-04-29 | Suffolk city | Virginia | 51800 | 154 | 12 |
103680 | 103680 | 2020-04-30 | Suffolk city | Virginia | 51800 | 169 | 12 |
106544 | 106544 | 2020-05-01 | Suffolk city | Virginia | 51800 | 175 | 13 |
109413 | 109413 | 2020-05-02 | Suffolk city | Virginia | 51800 | 178 | 13 |
112287 | 112287 | 2020-05-03 | Suffolk city | Virginia | 51800 | 190 | 14 |
115170 | 115170 | 2020-05-04 | Suffolk city | Virginia | 51800 | 190 | 14 |
118129 | 118129 | 2020-05-05 | Suffolk city | Virginia | 51800 | 205 | 15 |
121093 | 121093 | 2020-05-06 | Suffolk city | Virginia | 51800 | 205 | 15 |
124074 | 124074 | 2020-05-07 | Suffolk city | Virginia | 51800 | 208 | 19 |
127059 | 127059 | 2020-05-08 | Suffolk city | Virginia | 51800 | 209 | 19 |
130049 | 130049 | 2020-05-09 | Suffolk city | Virginia | 51800 | 215 | 19 |
133039 | 133039 | 2020-05-10 | Suffolk city | Virginia | 51800 | 215 | 19 |
136029 | 136029 | 2020-05-11 | Suffolk city | Virginia | 51800 | 216 | 19 |
139020 | 139020 | 2020-05-12 | Suffolk city | Virginia | 51800 | 219 | 20 |
142016 | 142016 | 2020-05-13 | Suffolk city | Virginia | 51800 | 221 | 21 |
145013 | 145013 | 2020-05-14 | Suffolk city | Virginia | 51800 | 221 | 22 |
148016 | 148016 | 2020-05-15 | Suffolk city | Virginia | 51800 | 255 | 22 |
151025 | 151025 | 2020-05-16 | Suffolk city | Virginia | 51800 | 260 | 22 |
154036 | 154036 | 2020-05-17 | Suffolk city | Virginia | 51800 | 264 | 22 |
157053 | 157053 | 2020-05-18 | Suffolk city | Virginia | 51800 | 269 | 22 |
160077 | 160077 | 2020-05-19 | Suffolk city | Virginia | 51800 | 269 | 25 |
163105 | 163105 | 2020-05-20 | Suffolk city | Virginia | 51800 | 274 | 25 |
166134 | 166134 | 2020-05-21 | Suffolk city | Virginia | 51800 | 278 | 25 |
169170 | 169170 | 2020-05-22 | Suffolk city | Virginia | 51800 | 283 | 25 |
172211 | 172211 | 2020-05-23 | Suffolk city | Virginia | 51800 | 290 | 25 |
175254 | 175254 | 2020-05-24 | Suffolk city | Virginia | 51800 | 295 | 29 |
178299 | 178299 | 2020-05-25 | Suffolk city | Virginia | 51800 | 300 | 31 |
181343 | 181343 | 2020-05-26 | Suffolk city | Virginia | 51800 | 303 | 31 |
184394 | 184394 | 2020-05-27 | Suffolk city | Virginia | 51800 | 308 | 31 |
187451 | 187451 | 2020-05-28 | Suffolk city | Virginia | 51800 | 308 | 31 |
190515 | 190515 | 2020-05-29 | Suffolk city | Virginia | 51800 | 311 | 32 |
193581 | 193581 | 2020-05-30 | Suffolk city | Virginia | 51800 | 314 | 32 |
196651 | 196651 | 2020-05-31 | Suffolk city | Virginia | 51800 | 315 | 32 |
199724 | 199724 | 2020-06-01 | Suffolk city | Virginia | 51800 | 316 | 33 |
202800 | 202800 | 2020-06-02 | Suffolk city | Virginia | 51800 | 317 | 33 |
205879 | 205879 | 2020-06-03 | Suffolk city | Virginia | 51800 | 318 | 33 |
208961 | 208961 | 2020-06-04 | Suffolk city | Virginia | 51800 | 320 | 33 |
212046 | 212046 | 2020-06-05 | Suffolk city | Virginia | 51800 | 322 | 33 |
215133 | 215133 | 2020-06-06 | Suffolk city | Virginia | 51800 | 323 | 33 |
218223 | 218223 | 2020-06-07 | Suffolk city | Virginia | 51800 | 323 | 33 |
221315 | 221315 | 2020-06-08 | Suffolk city | Virginia | 51800 | 325 | 33 |
224411 | 224411 | 2020-06-09 | Suffolk city | Virginia | 51800 | 325 | 34 |
227511 | 227511 | 2020-06-10 | Suffolk city | Virginia | 51800 | 330 | 33 |
230615 | 230615 | 2020-06-11 | Suffolk city | Virginia | 51800 | 333 | 33 |
233720 | 233720 | 2020-06-12 | Suffolk city | Virginia | 51800 | 337 | 33 |
236827 | 236827 | 2020-06-13 | Suffolk city | Virginia | 51800 | 341 | 33 |
239935 | 239935 | 2020-06-14 | Suffolk city | Virginia | 51800 | 344 | 33 |
243046 | 243046 | 2020-06-15 | Suffolk city | Virginia | 51800 | 345 | 34 |
246159 | 246159 | 2020-06-16 | Suffolk city | Virginia | 51800 | 347 | 34 |
249271 | 249271 | 2020-06-17 | Suffolk city | Virginia | 51800 | 348 | 34 |
252386 | 252386 | 2020-06-18 | Suffolk city | Virginia | 51800 | 349 | 34 |
255505 | 255505 | 2020-06-19 | Suffolk city | Virginia | 51800 | 353 | 34 |
258632 | 258632 | 2020-06-20 | Suffolk city | Virginia | 51800 | 356 | 34 |
261759 | 261759 | 2020-06-21 | Suffolk city | Virginia | 51800 | 365 | 34 |
264888 | 264888 | 2020-06-22 | Suffolk city | Virginia | 51800 | 377 | 34 |
268017 | 268017 | 2020-06-23 | Suffolk city | Virginia | 51800 | 380 | 34 |
271151 | 271151 | 2020-06-24 | Suffolk city | Virginia | 51800 | 385 | 34 |
274291 | 274291 | 2020-06-25 | Suffolk city | Virginia | 51800 | 389 | 34 |
277439 | 277439 | 2020-06-26 | Suffolk city | Virginia | 51800 | 393 | 34 |
280587 | 280587 | 2020-06-27 | Suffolk city | Virginia | 51800 | 397 | 34 |
283733 | 283733 | 2020-06-28 | Suffolk city | Virginia | 51800 | 398 | 34 |
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);