ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 51760 and state = "Virginia" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
277425 | 277425 | 2020-06-26 | Richmond city | Virginia | 51760 | 2133 | 30 |
280573 | 280573 | 2020-06-27 | Richmond city | Virginia | 51760 | 2159 | 30 |
283719 | 283719 | 2020-06-28 | Richmond city | Virginia | 51760 | 2184 | 30 |
286865 | 286865 | 2020-06-29 | Richmond city | Virginia | 51760 | 2195 | 30 |
290015 | 290015 | 2020-06-30 | Richmond city | Virginia | 51760 | 2209 | 30 |
293168 | 293168 | 2020-07-01 | Richmond city | Virginia | 51760 | 2213 | 29 |
296323 | 296323 | 2020-07-02 | Richmond city | Virginia | 51760 | 2227 | 30 |
299485 | 299485 | 2020-07-03 | Richmond city | Virginia | 51760 | 2248 | 30 |
302649 | 302649 | 2020-07-04 | Richmond city | Virginia | 51760 | 2262 | 29 |
305813 | 305813 | 2020-07-05 | Richmond city | Virginia | 51760 | 2276 | 29 |
308981 | 308981 | 2020-07-06 | Richmond city | Virginia | 51760 | 2288 | 29 |
312150 | 312150 | 2020-07-07 | Richmond city | Virginia | 51760 | 2301 | 29 |
315325 | 315325 | 2020-07-08 | Richmond city | Virginia | 51760 | 2321 | 29 |
318498 | 318498 | 2020-07-09 | Richmond city | Virginia | 51760 | 2333 | 33 |
321677 | 321677 | 2020-07-10 | Richmond city | Virginia | 51760 | 2361 | 35 |
324858 | 324858 | 2020-07-11 | Richmond city | Virginia | 51760 | 2386 | 35 |
328043 | 328043 | 2020-07-12 | Richmond city | Virginia | 51760 | 2415 | 35 |
331229 | 331229 | 2020-07-13 | Richmond city | Virginia | 51760 | 2432 | 35 |
334422 | 334422 | 2020-07-14 | Richmond city | Virginia | 51760 | 2457 | 36 |
337617 | 337617 | 2020-07-15 | Richmond city | Virginia | 51760 | 2473 | 36 |
340813 | 340813 | 2020-07-16 | Richmond city | Virginia | 51760 | 2498 | 36 |
344012 | 344012 | 2020-07-17 | Richmond city | Virginia | 51760 | 2521 | 36 |
347212 | 347212 | 2020-07-18 | Richmond city | Virginia | 51760 | 2541 | 36 |
350413 | 350413 | 2020-07-19 | Richmond city | Virginia | 51760 | 2563 | 36 |
353615 | 353615 | 2020-07-20 | Richmond city | Virginia | 51760 | 2588 | 36 |
356818 | 356818 | 2020-07-21 | Richmond city | Virginia | 51760 | 2623 | 35 |
360023 | 360023 | 2020-07-22 | Richmond city | Virginia | 51760 | 2643 | 35 |
363229 | 363229 | 2020-07-23 | Richmond city | Virginia | 51760 | 2670 | 35 |
366435 | 366435 | 2020-07-24 | Richmond city | Virginia | 51760 | 2686 | 36 |
369644 | 369644 | 2020-07-25 | Richmond city | Virginia | 51760 | 2695 | 36 |
372856 | 372856 | 2020-07-26 | Richmond city | Virginia | 51760 | 2712 | 36 |
376070 | 376070 | 2020-07-27 | Richmond city | Virginia | 51760 | 2762 | 36 |
379286 | 379286 | 2020-07-28 | Richmond city | Virginia | 51760 | 2794 | 37 |
382503 | 382503 | 2020-07-29 | Richmond city | Virginia | 51760 | 2831 | 39 |
385721 | 385721 | 2020-07-30 | Richmond city | Virginia | 51760 | 2857 | 38 |
388938 | 388938 | 2020-07-31 | Richmond city | Virginia | 51760 | 2893 | 39 |
392155 | 392155 | 2020-08-01 | Richmond city | Virginia | 51760 | 2936 | 39 |
395371 | 395371 | 2020-08-02 | Richmond city | Virginia | 51760 | 2946 | 39 |
398587 | 398587 | 2020-08-03 | Richmond city | Virginia | 51760 | 2992 | 39 |
401803 | 401803 | 2020-08-04 | Richmond city | Virginia | 51760 | 3015 | 39 |
405021 | 405021 | 2020-08-05 | Richmond city | Virginia | 51760 | 3034 | 39 |
408241 | 408241 | 2020-08-06 | Richmond city | Virginia | 51760 | 3067 | 41 |
411460 | 411460 | 2020-08-07 | Richmond city | Virginia | 51760 | 3112 | 41 |
414680 | 414680 | 2020-08-08 | Richmond city | Virginia | 51760 | 3132 | 41 |
417901 | 417901 | 2020-08-09 | Richmond city | Virginia | 51760 | 3165 | 41 |
421122 | 421122 | 2020-08-10 | Richmond city | Virginia | 51760 | 3190 | 41 |
424343 | 424343 | 2020-08-11 | Richmond city | Virginia | 51760 | 3229 | 41 |
427567 | 427567 | 2020-08-12 | Richmond city | Virginia | 51760 | 3248 | 41 |
430795 | 430795 | 2020-08-13 | Richmond city | Virginia | 51760 | 3280 | 41 |
434020 | 434020 | 2020-08-14 | Richmond city | Virginia | 51760 | 3308 | 41 |
437246 | 437246 | 2020-08-15 | Richmond city | Virginia | 51760 | 3339 | 42 |
440472 | 440472 | 2020-08-16 | Richmond city | Virginia | 51760 | 3354 | 42 |
443698 | 443698 | 2020-08-17 | Richmond city | Virginia | 51760 | 3404 | 42 |
446925 | 446925 | 2020-08-18 | Richmond city | Virginia | 51760 | 3425 | 42 |
450153 | 450153 | 2020-08-19 | Richmond city | Virginia | 51760 | 3455 | 43 |
453381 | 453381 | 2020-08-20 | Richmond city | Virginia | 51760 | 3480 | 43 |
456609 | 456609 | 2020-08-21 | Richmond city | Virginia | 51760 | 3502 | 43 |
459836 | 459836 | 2020-08-22 | Richmond city | Virginia | 51760 | 3548 | 43 |
463065 | 463065 | 2020-08-23 | Richmond city | Virginia | 51760 | 3588 | 43 |
466294 | 466294 | 2020-08-24 | Richmond city | Virginia | 51760 | 3615 | 43 |
469523 | 469523 | 2020-08-25 | Richmond city | Virginia | 51760 | 3662 | 43 |
472755 | 472755 | 2020-08-26 | Richmond city | Virginia | 51760 | 3735 | 44 |
475988 | 475988 | 2020-08-27 | Richmond city | Virginia | 51760 | 3767 | 45 |
479221 | 479221 | 2020-08-28 | Richmond city | Virginia | 51760 | 3795 | 47 |
482455 | 482455 | 2020-08-29 | Richmond city | Virginia | 51760 | 3831 | 47 |
485690 | 485690 | 2020-08-30 | Richmond city | Virginia | 51760 | 3879 | 47 |
488923 | 488923 | 2020-08-31 | Richmond city | Virginia | 51760 | 3897 | 47 |
492156 | 492156 | 2020-09-01 | Richmond city | Virginia | 51760 | 3920 | 49 |
495390 | 495390 | 2020-09-02 | Richmond city | Virginia | 51760 | 3950 | 49 |
498623 | 498623 | 2020-09-03 | Richmond city | Virginia | 51760 | 4027 | 49 |
501857 | 501857 | 2020-09-04 | Richmond city | Virginia | 51760 | 4052 | 49 |
505091 | 505091 | 2020-09-05 | Richmond city | Virginia | 51760 | 4099 | 49 |
508323 | 508323 | 2020-09-06 | Richmond city | Virginia | 51760 | 4135 | 49 |
511556 | 511556 | 2020-09-07 | Richmond city | Virginia | 51760 | 4153 | 49 |
514789 | 514789 | 2020-09-08 | Richmond city | Virginia | 51760 | 4176 | 49 |
518024 | 518024 | 2020-09-09 | Richmond city | Virginia | 51760 | 4198 | 49 |
521261 | 521261 | 2020-09-10 | Richmond city | Virginia | 51760 | 4220 | 50 |
524497 | 524497 | 2020-09-11 | Richmond city | Virginia | 51760 | 4259 | 50 |
527733 | 527733 | 2020-09-12 | Richmond city | Virginia | 51760 | 4291 | 50 |
530970 | 530970 | 2020-09-13 | Richmond city | Virginia | 51760 | 4317 | 50 |
534205 | 534205 | 2020-09-14 | Richmond city | Virginia | 51760 | 4336 | 50 |
537441 | 537441 | 2020-09-15 | Richmond city | Virginia | 51760 | 4363 | 55 |
540678 | 540678 | 2020-09-16 | Richmond city | Virginia | 51760 | 4384 | 55 |
543914 | 543914 | 2020-09-17 | Richmond city | Virginia | 51760 | 4407 | 56 |
547151 | 547151 | 2020-09-18 | Richmond city | Virginia | 51760 | 4434 | 55 |
550390 | 550390 | 2020-09-19 | Richmond city | Virginia | 51760 | 4468 | 55 |
553629 | 553629 | 2020-09-20 | Richmond city | Virginia | 51760 | 4495 | 56 |
556866 | 556866 | 2020-09-21 | Richmond city | Virginia | 51760 | 4516 | 56 |
560102 | 560102 | 2020-09-22 | Richmond city | Virginia | 51760 | 4540 | 58 |
563341 | 563341 | 2020-09-23 | Richmond city | Virginia | 51760 | 4551 | 60 |
566582 | 566582 | 2020-09-24 | Richmond city | Virginia | 51760 | 4578 | 61 |
569823 | 569823 | 2020-09-25 | Richmond city | Virginia | 51760 | 4595 | 61 |
573065 | 573065 | 2020-09-26 | Richmond city | Virginia | 51760 | 4625 | 61 |
576309 | 576309 | 2020-09-27 | Richmond city | Virginia | 51760 | 4637 | 61 |
579550 | 579550 | 2020-09-28 | Richmond city | Virginia | 51760 | 4647 | 61 |
582789 | 582789 | 2020-09-29 | Richmond city | Virginia | 51760 | 4649 | 61 |
586029 | 586029 | 2020-09-30 | Richmond city | Virginia | 51760 | 4674 | 61 |
589270 | 589270 | 2020-10-01 | Richmond city | Virginia | 51760 | 4683 | 62 |
592510 | 592510 | 2020-10-02 | Richmond city | Virginia | 51760 | 4701 | 62 |
595752 | 595752 | 2020-10-03 | Richmond city | Virginia | 51760 | 4743 | 62 |
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);