ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Newport News city" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388917 | 388917 | 2020-07-31 | Newport News city | Virginia | 51700 | 1573 | 16 |
385700 | 385700 | 2020-07-30 | Newport News city | Virginia | 51700 | 1544 | 16 |
382482 | 382482 | 2020-07-29 | Newport News city | Virginia | 51700 | 1519 | 15 |
379265 | 379265 | 2020-07-28 | Newport News city | Virginia | 51700 | 1489 | 15 |
376049 | 376049 | 2020-07-27 | Newport News city | Virginia | 51700 | 1474 | 15 |
372835 | 372835 | 2020-07-26 | Newport News city | Virginia | 51700 | 1424 | 15 |
369623 | 369623 | 2020-07-25 | Newport News city | Virginia | 51700 | 1385 | 15 |
366414 | 366414 | 2020-07-24 | Newport News city | Virginia | 51700 | 1356 | 14 |
363208 | 363208 | 2020-07-23 | Newport News city | Virginia | 51700 | 1308 | 14 |
360002 | 360002 | 2020-07-22 | Newport News city | Virginia | 51700 | 1276 | 14 |
356797 | 356797 | 2020-07-21 | Newport News city | Virginia | 51700 | 1237 | 14 |
353594 | 353594 | 2020-07-20 | Newport News city | Virginia | 51700 | 1206 | 14 |
350392 | 350392 | 2020-07-19 | Newport News city | Virginia | 51700 | 1151 | 13 |
347191 | 347191 | 2020-07-18 | Newport News city | Virginia | 51700 | 1029 | 13 |
343991 | 343991 | 2020-07-17 | Newport News city | Virginia | 51700 | 984 | 10 |
340792 | 340792 | 2020-07-16 | Newport News city | Virginia | 51700 | 940 | 10 |
337596 | 337596 | 2020-07-15 | Newport News city | Virginia | 51700 | 900 | 10 |
334401 | 334401 | 2020-07-14 | Newport News city | Virginia | 51700 | 856 | 10 |
331208 | 331208 | 2020-07-13 | Newport News city | Virginia | 51700 | 815 | 10 |
328022 | 328022 | 2020-07-12 | Newport News city | Virginia | 51700 | 719 | 10 |
324837 | 324837 | 2020-07-11 | Newport News city | Virginia | 51700 | 693 | 10 |
321656 | 321656 | 2020-07-10 | Newport News city | Virginia | 51700 | 679 | 10 |
318477 | 318477 | 2020-07-09 | Newport News city | Virginia | 51700 | 659 | 10 |
315304 | 315304 | 2020-07-08 | Newport News city | Virginia | 51700 | 634 | 10 |
312129 | 312129 | 2020-07-07 | Newport News city | Virginia | 51700 | 613 | 10 |
308960 | 308960 | 2020-07-06 | Newport News city | Virginia | 51700 | 592 | 10 |
305792 | 305792 | 2020-07-05 | Newport News city | Virginia | 51700 | 584 | 10 |
302628 | 302628 | 2020-07-04 | Newport News city | Virginia | 51700 | 568 | 10 |
299464 | 299464 | 2020-07-03 | Newport News city | Virginia | 51700 | 549 | 10 |
296302 | 296302 | 2020-07-02 | Newport News city | Virginia | 51700 | 541 | 10 |
293147 | 293147 | 2020-07-01 | Newport News city | Virginia | 51700 | 535 | 10 |
289994 | 289994 | 2020-06-30 | Newport News city | Virginia | 51700 | 523 | 10 |
286844 | 286844 | 2020-06-29 | Newport News city | Virginia | 51700 | 513 | 10 |
283698 | 283698 | 2020-06-28 | Newport News city | Virginia | 51700 | 500 | 10 |
280552 | 280552 | 2020-06-27 | Newport News city | Virginia | 51700 | 490 | 10 |
277404 | 277404 | 2020-06-26 | Newport News city | Virginia | 51700 | 474 | 10 |
274256 | 274256 | 2020-06-25 | Newport News city | Virginia | 51700 | 466 | 10 |
271116 | 271116 | 2020-06-24 | Newport News city | Virginia | 51700 | 463 | 10 |
267982 | 267982 | 2020-06-23 | Newport News city | Virginia | 51700 | 452 | 10 |
264853 | 264853 | 2020-06-22 | Newport News city | Virginia | 51700 | 447 | 10 |
261724 | 261724 | 2020-06-21 | Newport News city | Virginia | 51700 | 438 | 10 |
258597 | 258597 | 2020-06-20 | Newport News city | Virginia | 51700 | 430 | 10 |
255470 | 255470 | 2020-06-19 | Newport News city | Virginia | 51700 | 410 | 10 |
252351 | 252351 | 2020-06-18 | Newport News city | Virginia | 51700 | 402 | 10 |
249236 | 249236 | 2020-06-17 | Newport News city | Virginia | 51700 | 399 | 10 |
246124 | 246124 | 2020-06-16 | Newport News city | Virginia | 51700 | 390 | 10 |
243011 | 243011 | 2020-06-15 | Newport News city | Virginia | 51700 | 381 | 10 |
239900 | 239900 | 2020-06-14 | Newport News city | Virginia | 51700 | 371 | 10 |
236792 | 236792 | 2020-06-13 | Newport News city | Virginia | 51700 | 357 | 10 |
233685 | 233685 | 2020-06-12 | Newport News city | Virginia | 51700 | 351 | 10 |
230580 | 230580 | 2020-06-11 | Newport News city | Virginia | 51700 | 337 | 10 |
227476 | 227476 | 2020-06-10 | Newport News city | Virginia | 51700 | 328 | 10 |
224376 | 224376 | 2020-06-09 | Newport News city | Virginia | 51700 | 323 | 10 |
221280 | 221280 | 2020-06-08 | Newport News city | Virginia | 51700 | 322 | 10 |
218188 | 218188 | 2020-06-07 | Newport News city | Virginia | 51700 | 320 | 10 |
215098 | 215098 | 2020-06-06 | Newport News city | Virginia | 51700 | 314 | 10 |
212011 | 212011 | 2020-06-05 | Newport News city | Virginia | 51700 | 309 | 10 |
208926 | 208926 | 2020-06-04 | Newport News city | Virginia | 51700 | 299 | 10 |
205844 | 205844 | 2020-06-03 | Newport News city | Virginia | 51700 | 292 | 10 |
202765 | 202765 | 2020-06-02 | Newport News city | Virginia | 51700 | 291 | 10 |
199689 | 199689 | 2020-06-01 | Newport News city | Virginia | 51700 | 282 | 10 |
196616 | 196616 | 2020-05-31 | Newport News city | Virginia | 51700 | 273 | 10 |
193546 | 193546 | 2020-05-30 | Newport News city | Virginia | 51700 | 258 | 10 |
190480 | 190480 | 2020-05-29 | Newport News city | Virginia | 51700 | 257 | 10 |
187416 | 187416 | 2020-05-28 | Newport News city | Virginia | 51700 | 257 | 10 |
184359 | 184359 | 2020-05-27 | Newport News city | Virginia | 51700 | 254 | 10 |
181308 | 181308 | 2020-05-26 | Newport News city | Virginia | 51700 | 250 | 10 |
178264 | 178264 | 2020-05-25 | Newport News city | Virginia | 51700 | 245 | 10 |
175219 | 175219 | 2020-05-24 | Newport News city | Virginia | 51700 | 237 | 10 |
172176 | 172176 | 2020-05-23 | Newport News city | Virginia | 51700 | 234 | 10 |
169135 | 169135 | 2020-05-22 | Newport News city | Virginia | 51700 | 224 | 10 |
166099 | 166099 | 2020-05-21 | Newport News city | Virginia | 51700 | 215 | 10 |
163070 | 163070 | 2020-05-20 | Newport News city | Virginia | 51700 | 211 | 10 |
160042 | 160042 | 2020-05-19 | Newport News city | Virginia | 51700 | 209 | 10 |
157018 | 157018 | 2020-05-18 | Newport News city | Virginia | 51700 | 206 | 10 |
154001 | 154001 | 2020-05-17 | Newport News city | Virginia | 51700 | 193 | 10 |
150990 | 150990 | 2020-05-16 | Newport News city | Virginia | 51700 | 187 | 10 |
147981 | 147981 | 2020-05-15 | Newport News city | Virginia | 51700 | 184 | 10 |
144978 | 144978 | 2020-05-14 | Newport News city | Virginia | 51700 | 179 | 10 |
141981 | 141981 | 2020-05-13 | Newport News city | Virginia | 51700 | 171 | 10 |
138985 | 138985 | 2020-05-12 | Newport News city | Virginia | 51700 | 166 | 10 |
135994 | 135994 | 2020-05-11 | Newport News city | Virginia | 51700 | 164 | 10 |
133004 | 133004 | 2020-05-10 | Newport News city | Virginia | 51700 | 159 | 10 |
130014 | 130014 | 2020-05-09 | Newport News city | Virginia | 51700 | 152 | 10 |
127024 | 127024 | 2020-05-08 | Newport News city | Virginia | 51700 | 144 | 10 |
124039 | 124039 | 2020-05-07 | Newport News city | Virginia | 51700 | 137 | 10 |
121058 | 121058 | 2020-05-06 | Newport News city | Virginia | 51700 | 133 | 9 |
118094 | 118094 | 2020-05-05 | Newport News city | Virginia | 51700 | 133 | 9 |
115135 | 115135 | 2020-05-04 | Newport News city | Virginia | 51700 | 132 | 9 |
112252 | 112252 | 2020-05-03 | Newport News city | Virginia | 51700 | 125 | 9 |
109378 | 109378 | 2020-05-02 | Newport News city | Virginia | 51700 | 123 | 9 |
106509 | 106509 | 2020-05-01 | Newport News city | Virginia | 51700 | 120 | 9 |
103645 | 103645 | 2020-04-30 | Newport News city | Virginia | 51700 | 118 | 7 |
100790 | 100790 | 2020-04-29 | Newport News city | Virginia | 51700 | 114 | 7 |
97940 | 97940 | 2020-04-28 | Newport News city | Virginia | 51700 | 112 | 7 |
95096 | 95096 | 2020-04-27 | Newport News city | Virginia | 51700 | 112 | 7 |
92267 | 92267 | 2020-04-26 | Newport News city | Virginia | 51700 | 111 | 6 |
89450 | 89450 | 2020-04-25 | Newport News city | Virginia | 51700 | 109 | 6 |
86635 | 86635 | 2020-04-24 | Newport News city | Virginia | 51700 | 107 | 6 |
83828 | 83828 | 2020-04-23 | Newport News city | Virginia | 51700 | 105 | 6 |
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);