ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 51800 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388952 | 388952 | 2020-07-31 | Suffolk city | Virginia | 51800 | 1034 | 49 |
385735 | 385735 | 2020-07-30 | Suffolk city | Virginia | 51800 | 1001 | 48 |
382517 | 382517 | 2020-07-29 | Suffolk city | Virginia | 51800 | 989 | 48 |
379300 | 379300 | 2020-07-28 | Suffolk city | Virginia | 51800 | 974 | 46 |
376084 | 376084 | 2020-07-27 | Suffolk city | Virginia | 51800 | 948 | 45 |
372870 | 372870 | 2020-07-26 | Suffolk city | Virginia | 51800 | 914 | 45 |
369658 | 369658 | 2020-07-25 | Suffolk city | Virginia | 51800 | 886 | 45 |
366449 | 366449 | 2020-07-24 | Suffolk city | Virginia | 51800 | 862 | 45 |
363243 | 363243 | 2020-07-23 | Suffolk city | Virginia | 51800 | 826 | 45 |
360037 | 360037 | 2020-07-22 | Suffolk city | Virginia | 51800 | 797 | 45 |
356832 | 356832 | 2020-07-21 | Suffolk city | Virginia | 51800 | 780 | 45 |
353629 | 353629 | 2020-07-20 | Suffolk city | Virginia | 51800 | 757 | 44 |
350427 | 350427 | 2020-07-19 | Suffolk city | Virginia | 51800 | 725 | 44 |
347226 | 347226 | 2020-07-18 | Suffolk city | Virginia | 51800 | 701 | 44 |
344026 | 344026 | 2020-07-17 | Suffolk city | Virginia | 51800 | 676 | 44 |
340827 | 340827 | 2020-07-16 | Suffolk city | Virginia | 51800 | 647 | 44 |
337631 | 337631 | 2020-07-15 | Suffolk city | Virginia | 51800 | 633 | 42 |
334436 | 334436 | 2020-07-14 | Suffolk city | Virginia | 51800 | 612 | 42 |
331243 | 331243 | 2020-07-13 | Suffolk city | Virginia | 51800 | 573 | 42 |
328057 | 328057 | 2020-07-12 | Suffolk city | Virginia | 51800 | 554 | 42 |
324872 | 324872 | 2020-07-11 | Suffolk city | Virginia | 51800 | 535 | 42 |
321691 | 321691 | 2020-07-10 | Suffolk city | Virginia | 51800 | 526 | 42 |
318512 | 318512 | 2020-07-09 | Suffolk city | Virginia | 51800 | 504 | 40 |
315339 | 315339 | 2020-07-08 | Suffolk city | Virginia | 51800 | 487 | 38 |
312164 | 312164 | 2020-07-07 | Suffolk city | Virginia | 51800 | 470 | 38 |
308995 | 308995 | 2020-07-06 | Suffolk city | Virginia | 51800 | 457 | 38 |
305827 | 305827 | 2020-07-05 | Suffolk city | Virginia | 51800 | 451 | 38 |
302663 | 302663 | 2020-07-04 | Suffolk city | Virginia | 51800 | 443 | 37 |
299499 | 299499 | 2020-07-03 | Suffolk city | Virginia | 51800 | 441 | 37 |
296337 | 296337 | 2020-07-02 | Suffolk city | Virginia | 51800 | 425 | 36 |
293182 | 293182 | 2020-07-01 | Suffolk city | Virginia | 51800 | 420 | 35 |
290029 | 290029 | 2020-06-30 | Suffolk city | Virginia | 51800 | 414 | 34 |
286879 | 286879 | 2020-06-29 | Suffolk city | Virginia | 51800 | 403 | 34 |
283733 | 283733 | 2020-06-28 | Suffolk city | Virginia | 51800 | 398 | 34 |
280587 | 280587 | 2020-06-27 | Suffolk city | Virginia | 51800 | 397 | 34 |
277439 | 277439 | 2020-06-26 | Suffolk city | Virginia | 51800 | 393 | 34 |
274291 | 274291 | 2020-06-25 | Suffolk city | Virginia | 51800 | 389 | 34 |
271151 | 271151 | 2020-06-24 | Suffolk city | Virginia | 51800 | 385 | 34 |
268017 | 268017 | 2020-06-23 | Suffolk city | Virginia | 51800 | 380 | 34 |
264888 | 264888 | 2020-06-22 | Suffolk city | Virginia | 51800 | 377 | 34 |
261759 | 261759 | 2020-06-21 | Suffolk city | Virginia | 51800 | 365 | 34 |
258632 | 258632 | 2020-06-20 | Suffolk city | Virginia | 51800 | 356 | 34 |
255505 | 255505 | 2020-06-19 | Suffolk city | Virginia | 51800 | 353 | 34 |
252386 | 252386 | 2020-06-18 | Suffolk city | Virginia | 51800 | 349 | 34 |
249271 | 249271 | 2020-06-17 | Suffolk city | Virginia | 51800 | 348 | 34 |
246159 | 246159 | 2020-06-16 | Suffolk city | Virginia | 51800 | 347 | 34 |
243046 | 243046 | 2020-06-15 | Suffolk city | Virginia | 51800 | 345 | 34 |
239935 | 239935 | 2020-06-14 | Suffolk city | Virginia | 51800 | 344 | 33 |
236827 | 236827 | 2020-06-13 | Suffolk city | Virginia | 51800 | 341 | 33 |
233720 | 233720 | 2020-06-12 | Suffolk city | Virginia | 51800 | 337 | 33 |
230615 | 230615 | 2020-06-11 | Suffolk city | Virginia | 51800 | 333 | 33 |
227511 | 227511 | 2020-06-10 | Suffolk city | Virginia | 51800 | 330 | 33 |
224411 | 224411 | 2020-06-09 | Suffolk city | Virginia | 51800 | 325 | 34 |
221315 | 221315 | 2020-06-08 | Suffolk city | Virginia | 51800 | 325 | 33 |
218223 | 218223 | 2020-06-07 | Suffolk city | Virginia | 51800 | 323 | 33 |
215133 | 215133 | 2020-06-06 | Suffolk city | Virginia | 51800 | 323 | 33 |
212046 | 212046 | 2020-06-05 | Suffolk city | Virginia | 51800 | 322 | 33 |
208961 | 208961 | 2020-06-04 | Suffolk city | Virginia | 51800 | 320 | 33 |
205879 | 205879 | 2020-06-03 | Suffolk city | Virginia | 51800 | 318 | 33 |
202800 | 202800 | 2020-06-02 | Suffolk city | Virginia | 51800 | 317 | 33 |
199724 | 199724 | 2020-06-01 | Suffolk city | Virginia | 51800 | 316 | 33 |
196651 | 196651 | 2020-05-31 | Suffolk city | Virginia | 51800 | 315 | 32 |
193581 | 193581 | 2020-05-30 | Suffolk city | Virginia | 51800 | 314 | 32 |
190515 | 190515 | 2020-05-29 | Suffolk city | Virginia | 51800 | 311 | 32 |
187451 | 187451 | 2020-05-28 | Suffolk city | Virginia | 51800 | 308 | 31 |
184394 | 184394 | 2020-05-27 | Suffolk city | Virginia | 51800 | 308 | 31 |
181343 | 181343 | 2020-05-26 | Suffolk city | Virginia | 51800 | 303 | 31 |
178299 | 178299 | 2020-05-25 | Suffolk city | Virginia | 51800 | 300 | 31 |
175254 | 175254 | 2020-05-24 | Suffolk city | Virginia | 51800 | 295 | 29 |
172211 | 172211 | 2020-05-23 | Suffolk city | Virginia | 51800 | 290 | 25 |
169170 | 169170 | 2020-05-22 | Suffolk city | Virginia | 51800 | 283 | 25 |
166134 | 166134 | 2020-05-21 | Suffolk city | Virginia | 51800 | 278 | 25 |
163105 | 163105 | 2020-05-20 | Suffolk city | Virginia | 51800 | 274 | 25 |
160077 | 160077 | 2020-05-19 | Suffolk city | Virginia | 51800 | 269 | 25 |
157053 | 157053 | 2020-05-18 | Suffolk city | Virginia | 51800 | 269 | 22 |
154036 | 154036 | 2020-05-17 | Suffolk city | Virginia | 51800 | 264 | 22 |
151025 | 151025 | 2020-05-16 | Suffolk city | Virginia | 51800 | 260 | 22 |
148016 | 148016 | 2020-05-15 | Suffolk city | Virginia | 51800 | 255 | 22 |
145013 | 145013 | 2020-05-14 | Suffolk city | Virginia | 51800 | 221 | 22 |
142016 | 142016 | 2020-05-13 | Suffolk city | Virginia | 51800 | 221 | 21 |
139020 | 139020 | 2020-05-12 | Suffolk city | Virginia | 51800 | 219 | 20 |
136029 | 136029 | 2020-05-11 | Suffolk city | Virginia | 51800 | 216 | 19 |
133039 | 133039 | 2020-05-10 | Suffolk city | Virginia | 51800 | 215 | 19 |
130049 | 130049 | 2020-05-09 | Suffolk city | Virginia | 51800 | 215 | 19 |
127059 | 127059 | 2020-05-08 | Suffolk city | Virginia | 51800 | 209 | 19 |
124074 | 124074 | 2020-05-07 | Suffolk city | Virginia | 51800 | 208 | 19 |
121093 | 121093 | 2020-05-06 | Suffolk city | Virginia | 51800 | 205 | 15 |
118129 | 118129 | 2020-05-05 | Suffolk city | Virginia | 51800 | 205 | 15 |
115170 | 115170 | 2020-05-04 | Suffolk city | Virginia | 51800 | 190 | 14 |
112287 | 112287 | 2020-05-03 | Suffolk city | Virginia | 51800 | 190 | 14 |
109413 | 109413 | 2020-05-02 | Suffolk city | Virginia | 51800 | 178 | 13 |
106544 | 106544 | 2020-05-01 | Suffolk city | Virginia | 51800 | 175 | 13 |
103680 | 103680 | 2020-04-30 | Suffolk city | Virginia | 51800 | 169 | 12 |
100825 | 100825 | 2020-04-29 | Suffolk city | Virginia | 51800 | 154 | 12 |
97975 | 97975 | 2020-04-28 | Suffolk city | Virginia | 51800 | 152 | 8 |
95131 | 95131 | 2020-04-27 | Suffolk city | Virginia | 51800 | 147 | 5 |
92302 | 92302 | 2020-04-26 | Suffolk city | Virginia | 51800 | 147 | 5 |
89485 | 89485 | 2020-04-25 | Suffolk city | Virginia | 51800 | 141 | 5 |
86670 | 86670 | 2020-04-24 | Suffolk city | Virginia | 51800 | 138 | 4 |
83863 | 83863 | 2020-04-23 | Suffolk city | Virginia | 51800 | 136 | 3 |
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);