ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 51041 and state = "Virginia" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
264794 | 264794 | 2020-06-22 | Chesterfield | Virginia | 51041 | 2577 | 46 |
267923 | 267923 | 2020-06-23 | Chesterfield | Virginia | 51041 | 2651 | 49 |
271057 | 271057 | 2020-06-24 | Chesterfield | Virginia | 51041 | 2710 | 49 |
274197 | 274197 | 2020-06-25 | Chesterfield | Virginia | 51041 | 2735 | 49 |
277345 | 277345 | 2020-06-26 | Chesterfield | Virginia | 51041 | 2784 | 49 |
280493 | 280493 | 2020-06-27 | Chesterfield | Virginia | 51041 | 2842 | 49 |
283639 | 283639 | 2020-06-28 | Chesterfield | Virginia | 51041 | 2856 | 49 |
286785 | 286785 | 2020-06-29 | Chesterfield | Virginia | 51041 | 2869 | 49 |
289935 | 289935 | 2020-06-30 | Chesterfield | Virginia | 51041 | 2897 | 50 |
293088 | 293088 | 2020-07-01 | Chesterfield | Virginia | 51041 | 2914 | 53 |
296243 | 296243 | 2020-07-02 | Chesterfield | Virginia | 51041 | 2939 | 53 |
299405 | 299405 | 2020-07-03 | Chesterfield | Virginia | 51041 | 2974 | 53 |
302569 | 302569 | 2020-07-04 | Chesterfield | Virginia | 51041 | 2972 | 53 |
305733 | 305733 | 2020-07-05 | Chesterfield | Virginia | 51041 | 3015 | 53 |
308901 | 308901 | 2020-07-06 | Chesterfield | Virginia | 51041 | 3026 | 53 |
312070 | 312070 | 2020-07-07 | Chesterfield | Virginia | 51041 | 3059 | 56 |
315245 | 315245 | 2020-07-08 | Chesterfield | Virginia | 51041 | 3078 | 59 |
318418 | 318418 | 2020-07-09 | Chesterfield | Virginia | 51041 | 3108 | 61 |
321597 | 321597 | 2020-07-10 | Chesterfield | Virginia | 51041 | 3135 | 62 |
324778 | 324778 | 2020-07-11 | Chesterfield | Virginia | 51041 | 3169 | 62 |
327963 | 327963 | 2020-07-12 | Chesterfield | Virginia | 51041 | 3189 | 62 |
331149 | 331149 | 2020-07-13 | Chesterfield | Virginia | 51041 | 3216 | 62 |
334342 | 334342 | 2020-07-14 | Chesterfield | Virginia | 51041 | 3278 | 63 |
337537 | 337537 | 2020-07-15 | Chesterfield | Virginia | 51041 | 3324 | 63 |
340733 | 340733 | 2020-07-16 | Chesterfield | Virginia | 51041 | 3359 | 64 |
343932 | 343932 | 2020-07-17 | Chesterfield | Virginia | 51041 | 3402 | 64 |
347132 | 347132 | 2020-07-18 | Chesterfield | Virginia | 51041 | 3427 | 65 |
350333 | 350333 | 2020-07-19 | Chesterfield | Virginia | 51041 | 3447 | 65 |
353535 | 353535 | 2020-07-20 | Chesterfield | Virginia | 51041 | 3472 | 65 |
356738 | 356738 | 2020-07-21 | Chesterfield | Virginia | 51041 | 3538 | 65 |
359943 | 359943 | 2020-07-22 | Chesterfield | Virginia | 51041 | 3564 | 65 |
363149 | 363149 | 2020-07-23 | Chesterfield | Virginia | 51041 | 3609 | 65 |
366355 | 366355 | 2020-07-24 | Chesterfield | Virginia | 51041 | 3673 | 66 |
369564 | 369564 | 2020-07-25 | Chesterfield | Virginia | 51041 | 3702 | 66 |
372776 | 372776 | 2020-07-26 | Chesterfield | Virginia | 51041 | 3730 | 66 |
375990 | 375990 | 2020-07-27 | Chesterfield | Virginia | 51041 | 3766 | 66 |
379206 | 379206 | 2020-07-28 | Chesterfield | Virginia | 51041 | 3796 | 66 |
382423 | 382423 | 2020-07-29 | Chesterfield | Virginia | 51041 | 3829 | 69 |
385641 | 385641 | 2020-07-30 | Chesterfield | Virginia | 51041 | 3877 | 71 |
388858 | 388858 | 2020-07-31 | Chesterfield | Virginia | 51041 | 3937 | 72 |
392075 | 392075 | 2020-08-01 | Chesterfield | Virginia | 51041 | 3968 | 75 |
395291 | 395291 | 2020-08-02 | Chesterfield | Virginia | 51041 | 4020 | 75 |
398507 | 398507 | 2020-08-03 | Chesterfield | Virginia | 51041 | 4097 | 75 |
401723 | 401723 | 2020-08-04 | Chesterfield | Virginia | 51041 | 4141 | 75 |
404941 | 404941 | 2020-08-05 | Chesterfield | Virginia | 51041 | 4170 | 75 |
408161 | 408161 | 2020-08-06 | Chesterfield | Virginia | 51041 | 4216 | 77 |
411380 | 411380 | 2020-08-07 | Chesterfield | Virginia | 51041 | 4283 | 80 |
414600 | 414600 | 2020-08-08 | Chesterfield | Virginia | 51041 | 4350 | 80 |
417821 | 417821 | 2020-08-09 | Chesterfield | Virginia | 51041 | 4362 | 80 |
421042 | 421042 | 2020-08-10 | Chesterfield | Virginia | 51041 | 4370 | 80 |
424263 | 424263 | 2020-08-11 | Chesterfield | Virginia | 51041 | 4439 | 80 |
427487 | 427487 | 2020-08-12 | Chesterfield | Virginia | 51041 | 4475 | 80 |
430715 | 430715 | 2020-08-13 | Chesterfield | Virginia | 51041 | 4512 | 80 |
433940 | 433940 | 2020-08-14 | Chesterfield | Virginia | 51041 | 4542 | 80 |
437166 | 437166 | 2020-08-15 | Chesterfield | Virginia | 51041 | 4596 | 80 |
440392 | 440392 | 2020-08-16 | Chesterfield | Virginia | 51041 | 4621 | 80 |
443618 | 443618 | 2020-08-17 | Chesterfield | Virginia | 51041 | 4623 | 80 |
446845 | 446845 | 2020-08-18 | Chesterfield | Virginia | 51041 | 4684 | 81 |
450073 | 450073 | 2020-08-19 | Chesterfield | Virginia | 51041 | 4720 | 76 |
453301 | 453301 | 2020-08-20 | Chesterfield | Virginia | 51041 | 4747 | 76 |
456529 | 456529 | 2020-08-21 | Chesterfield | Virginia | 51041 | 4772 | 76 |
459756 | 459756 | 2020-08-22 | Chesterfield | Virginia | 51041 | 4815 | 76 |
462985 | 462985 | 2020-08-23 | Chesterfield | Virginia | 51041 | 4853 | 76 |
466214 | 466214 | 2020-08-24 | Chesterfield | Virginia | 51041 | 4867 | 76 |
469443 | 469443 | 2020-08-25 | Chesterfield | Virginia | 51041 | 4888 | 77 |
472675 | 472675 | 2020-08-26 | Chesterfield | Virginia | 51041 | 4915 | 77 |
475908 | 475908 | 2020-08-27 | Chesterfield | Virginia | 51041 | 4946 | 78 |
479141 | 479141 | 2020-08-28 | Chesterfield | Virginia | 51041 | 4974 | 82 |
482375 | 482375 | 2020-08-29 | Chesterfield | Virginia | 51041 | 5013 | 82 |
485610 | 485610 | 2020-08-30 | Chesterfield | Virginia | 51041 | 5027 | 82 |
488843 | 488843 | 2020-08-31 | Chesterfield | Virginia | 51041 | 5046 | 82 |
492076 | 492076 | 2020-09-01 | Chesterfield | Virginia | 51041 | 5106 | 83 |
495310 | 495310 | 2020-09-02 | Chesterfield | Virginia | 51041 | 5146 | 83 |
498543 | 498543 | 2020-09-03 | Chesterfield | Virginia | 51041 | 5185 | 83 |
501777 | 501777 | 2020-09-04 | Chesterfield | Virginia | 51041 | 5209 | 83 |
505011 | 505011 | 2020-09-05 | Chesterfield | Virginia | 51041 | 5251 | 83 |
508243 | 508243 | 2020-09-06 | Chesterfield | Virginia | 51041 | 5259 | 83 |
511476 | 511476 | 2020-09-07 | Chesterfield | Virginia | 51041 | 5264 | 83 |
514709 | 514709 | 2020-09-08 | Chesterfield | Virginia | 51041 | 5307 | 83 |
517944 | 517944 | 2020-09-09 | Chesterfield | Virginia | 51041 | 5347 | 85 |
521181 | 521181 | 2020-09-10 | Chesterfield | Virginia | 51041 | 5401 | 85 |
524417 | 524417 | 2020-09-11 | Chesterfield | Virginia | 51041 | 5450 | 85 |
527653 | 527653 | 2020-09-12 | Chesterfield | Virginia | 51041 | 5500 | 85 |
530890 | 530890 | 2020-09-13 | Chesterfield | Virginia | 51041 | 5540 | 85 |
534125 | 534125 | 2020-09-14 | Chesterfield | Virginia | 51041 | 5558 | 86 |
537361 | 537361 | 2020-09-15 | Chesterfield | Virginia | 51041 | 5593 | 87 |
540598 | 540598 | 2020-09-16 | Chesterfield | Virginia | 51041 | 5628 | 89 |
543834 | 543834 | 2020-09-17 | Chesterfield | Virginia | 51041 | 5656 | 91 |
547071 | 547071 | 2020-09-18 | Chesterfield | Virginia | 51041 | 5702 | 90 |
550310 | 550310 | 2020-09-19 | Chesterfield | Virginia | 51041 | 5724 | 90 |
553549 | 553549 | 2020-09-20 | Chesterfield | Virginia | 51041 | 5758 | 91 |
556786 | 556786 | 2020-09-21 | Chesterfield | Virginia | 51041 | 5797 | 91 |
560022 | 560022 | 2020-09-22 | Chesterfield | Virginia | 51041 | 5829 | 93 |
563261 | 563261 | 2020-09-23 | Chesterfield | Virginia | 51041 | 5851 | 94 |
566502 | 566502 | 2020-09-24 | Chesterfield | Virginia | 51041 | 5870 | 94 |
569743 | 569743 | 2020-09-25 | Chesterfield | Virginia | 51041 | 5916 | 94 |
572985 | 572985 | 2020-09-26 | Chesterfield | Virginia | 51041 | 5945 | 94 |
576229 | 576229 | 2020-09-27 | Chesterfield | Virginia | 51041 | 5985 | 94 |
579470 | 579470 | 2020-09-28 | Chesterfield | Virginia | 51041 | 6000 | 94 |
582709 | 582709 | 2020-09-29 | Chesterfield | Virginia | 51041 | 6036 | 95 |
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);