ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Goochland" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637856 | 637856 | 2020-10-16 | Goochland | Virginia | 51075 | 305 | 7 |
634611 | 634611 | 2020-10-15 | Goochland | Virginia | 51075 | 306 | 7 |
631366 | 631366 | 2020-10-14 | Goochland | Virginia | 51075 | 305 | 7 |
628122 | 628122 | 2020-10-13 | Goochland | Virginia | 51075 | 305 | 7 |
624879 | 624879 | 2020-10-12 | Goochland | Virginia | 51075 | 301 | 7 |
621636 | 621636 | 2020-10-11 | Goochland | Virginia | 51075 | 300 | 7 |
618393 | 618393 | 2020-10-10 | Goochland | Virginia | 51075 | 296 | 7 |
615151 | 615151 | 2020-10-09 | Goochland | Virginia | 51075 | 294 | 7 |
611910 | 611910 | 2020-10-08 | Goochland | Virginia | 51075 | 290 | 7 |
608668 | 608668 | 2020-10-07 | Goochland | Virginia | 51075 | 287 | 7 |
605425 | 605425 | 2020-10-06 | Goochland | Virginia | 51075 | 287 | 7 |
602183 | 602183 | 2020-10-05 | Goochland | Virginia | 51075 | 285 | 7 |
598940 | 598940 | 2020-10-04 | Goochland | Virginia | 51075 | 282 | 7 |
595697 | 595697 | 2020-10-03 | Goochland | Virginia | 51075 | 277 | 7 |
592455 | 592455 | 2020-10-02 | Goochland | Virginia | 51075 | 277 | 7 |
589215 | 589215 | 2020-10-01 | Goochland | Virginia | 51075 | 276 | 7 |
585974 | 585974 | 2020-09-30 | Goochland | Virginia | 51075 | 275 | 7 |
582734 | 582734 | 2020-09-29 | Goochland | Virginia | 51075 | 274 | 7 |
579495 | 579495 | 2020-09-28 | Goochland | Virginia | 51075 | 272 | 7 |
576254 | 576254 | 2020-09-27 | Goochland | Virginia | 51075 | 271 | 7 |
573010 | 573010 | 2020-09-26 | Goochland | Virginia | 51075 | 269 | 7 |
569768 | 569768 | 2020-09-25 | Goochland | Virginia | 51075 | 266 | 7 |
566527 | 566527 | 2020-09-24 | Goochland | Virginia | 51075 | 261 | 7 |
563286 | 563286 | 2020-09-23 | Goochland | Virginia | 51075 | 260 | 7 |
560047 | 560047 | 2020-09-22 | Goochland | Virginia | 51075 | 260 | 7 |
556811 | 556811 | 2020-09-21 | Goochland | Virginia | 51075 | 257 | 7 |
553574 | 553574 | 2020-09-20 | Goochland | Virginia | 51075 | 256 | 7 |
550335 | 550335 | 2020-09-19 | Goochland | Virginia | 51075 | 255 | 7 |
547096 | 547096 | 2020-09-18 | Goochland | Virginia | 51075 | 254 | 7 |
543859 | 543859 | 2020-09-17 | Goochland | Virginia | 51075 | 252 | 7 |
540623 | 540623 | 2020-09-16 | Goochland | Virginia | 51075 | 252 | 7 |
537386 | 537386 | 2020-09-15 | Goochland | Virginia | 51075 | 252 | 7 |
534150 | 534150 | 2020-09-14 | Goochland | Virginia | 51075 | 249 | 7 |
530915 | 530915 | 2020-09-13 | Goochland | Virginia | 51075 | 247 | 7 |
527678 | 527678 | 2020-09-12 | Goochland | Virginia | 51075 | 242 | 7 |
524442 | 524442 | 2020-09-11 | Goochland | Virginia | 51075 | 241 | 7 |
521206 | 521206 | 2020-09-10 | Goochland | Virginia | 51075 | 238 | 7 |
517969 | 517969 | 2020-09-09 | Goochland | Virginia | 51075 | 231 | 7 |
514734 | 514734 | 2020-09-08 | Goochland | Virginia | 51075 | 229 | 7 |
511501 | 511501 | 2020-09-07 | Goochland | Virginia | 51075 | 228 | 7 |
508268 | 508268 | 2020-09-06 | Goochland | Virginia | 51075 | 228 | 7 |
505036 | 505036 | 2020-09-05 | Goochland | Virginia | 51075 | 224 | 7 |
501802 | 501802 | 2020-09-04 | Goochland | Virginia | 51075 | 224 | 7 |
498568 | 498568 | 2020-09-03 | Goochland | Virginia | 51075 | 224 | 7 |
495335 | 495335 | 2020-09-02 | Goochland | Virginia | 51075 | 222 | 7 |
492101 | 492101 | 2020-09-01 | Goochland | Virginia | 51075 | 222 | 7 |
488868 | 488868 | 2020-08-31 | Goochland | Virginia | 51075 | 220 | 7 |
485635 | 485635 | 2020-08-30 | Goochland | Virginia | 51075 | 219 | 7 |
482400 | 482400 | 2020-08-29 | Goochland | Virginia | 51075 | 217 | 7 |
479166 | 479166 | 2020-08-28 | Goochland | Virginia | 51075 | 214 | 7 |
475933 | 475933 | 2020-08-27 | Goochland | Virginia | 51075 | 213 | 7 |
472700 | 472700 | 2020-08-26 | Goochland | Virginia | 51075 | 212 | 7 |
469468 | 469468 | 2020-08-25 | Goochland | Virginia | 51075 | 182 | 7 |
466239 | 466239 | 2020-08-24 | Goochland | Virginia | 51075 | 180 | 7 |
463010 | 463010 | 2020-08-23 | Goochland | Virginia | 51075 | 179 | 7 |
459781 | 459781 | 2020-08-22 | Goochland | Virginia | 51075 | 178 | 7 |
456554 | 456554 | 2020-08-21 | Goochland | Virginia | 51075 | 177 | 7 |
453326 | 453326 | 2020-08-20 | Goochland | Virginia | 51075 | 175 | 7 |
450098 | 450098 | 2020-08-19 | Goochland | Virginia | 51075 | 175 | 7 |
446870 | 446870 | 2020-08-18 | Goochland | Virginia | 51075 | 174 | 7 |
443643 | 443643 | 2020-08-17 | Goochland | Virginia | 51075 | 173 | 7 |
440417 | 440417 | 2020-08-16 | Goochland | Virginia | 51075 | 172 | 7 |
437191 | 437191 | 2020-08-15 | Goochland | Virginia | 51075 | 171 | 7 |
433965 | 433965 | 2020-08-14 | Goochland | Virginia | 51075 | 170 | 7 |
430740 | 430740 | 2020-08-13 | Goochland | Virginia | 51075 | 169 | 7 |
427512 | 427512 | 2020-08-12 | Goochland | Virginia | 51075 | 167 | 7 |
424288 | 424288 | 2020-08-11 | Goochland | Virginia | 51075 | 165 | 7 |
421067 | 421067 | 2020-08-10 | Goochland | Virginia | 51075 | 164 | 7 |
417846 | 417846 | 2020-08-09 | Goochland | Virginia | 51075 | 163 | 7 |
414625 | 414625 | 2020-08-08 | Goochland | Virginia | 51075 | 161 | 7 |
411405 | 411405 | 2020-08-07 | Goochland | Virginia | 51075 | 159 | 7 |
408186 | 408186 | 2020-08-06 | Goochland | Virginia | 51075 | 157 | 7 |
404966 | 404966 | 2020-08-05 | Goochland | Virginia | 51075 | 153 | 7 |
401748 | 401748 | 2020-08-04 | Goochland | Virginia | 51075 | 152 | 7 |
398532 | 398532 | 2020-08-03 | Goochland | Virginia | 51075 | 151 | 7 |
395316 | 395316 | 2020-08-02 | Goochland | Virginia | 51075 | 151 | 7 |
392100 | 392100 | 2020-08-01 | Goochland | Virginia | 51075 | 151 | 7 |
388883 | 388883 | 2020-07-31 | Goochland | Virginia | 51075 | 150 | 7 |
385666 | 385666 | 2020-07-30 | Goochland | Virginia | 51075 | 149 | 7 |
382448 | 382448 | 2020-07-29 | Goochland | Virginia | 51075 | 149 | 7 |
379231 | 379231 | 2020-07-28 | Goochland | Virginia | 51075 | 148 | 7 |
376015 | 376015 | 2020-07-27 | Goochland | Virginia | 51075 | 147 | 6 |
372801 | 372801 | 2020-07-26 | Goochland | Virginia | 51075 | 145 | 6 |
369589 | 369589 | 2020-07-25 | Goochland | Virginia | 51075 | 144 | 6 |
366380 | 366380 | 2020-07-24 | Goochland | Virginia | 51075 | 144 | 6 |
363174 | 363174 | 2020-07-23 | Goochland | Virginia | 51075 | 143 | 6 |
359968 | 359968 | 2020-07-22 | Goochland | Virginia | 51075 | 142 | 6 |
356763 | 356763 | 2020-07-21 | Goochland | Virginia | 51075 | 141 | 6 |
353560 | 353560 | 2020-07-20 | Goochland | Virginia | 51075 | 139 | 6 |
350358 | 350358 | 2020-07-19 | Goochland | Virginia | 51075 | 139 | 6 |
347157 | 347157 | 2020-07-18 | Goochland | Virginia | 51075 | 138 | 6 |
343957 | 343957 | 2020-07-17 | Goochland | Virginia | 51075 | 138 | 6 |
340758 | 340758 | 2020-07-16 | Goochland | Virginia | 51075 | 135 | 6 |
337562 | 337562 | 2020-07-15 | Goochland | Virginia | 51075 | 135 | 6 |
334367 | 334367 | 2020-07-14 | Goochland | Virginia | 51075 | 131 | 6 |
331174 | 331174 | 2020-07-13 | Goochland | Virginia | 51075 | 131 | 6 |
327988 | 327988 | 2020-07-12 | Goochland | Virginia | 51075 | 130 | 6 |
324803 | 324803 | 2020-07-11 | Goochland | Virginia | 51075 | 129 | 6 |
321622 | 321622 | 2020-07-10 | Goochland | Virginia | 51075 | 129 | 6 |
318443 | 318443 | 2020-07-09 | Goochland | Virginia | 51075 | 129 | 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);