ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 51700 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1092215 | 1092215 | 2021-03-05 | Newport News city | Virginia | 51700 | 11688 | 190 |
1088969 | 1088969 | 2021-03-04 | Newport News city | Virginia | 51700 | 11619 | 190 |
1085724 | 1085724 | 2021-03-03 | Newport News city | Virginia | 51700 | 11567 | 190 |
1082478 | 1082478 | 2021-03-02 | Newport News city | Virginia | 51700 | 11525 | 182 |
1079232 | 1079232 | 2021-03-01 | Newport News city | Virginia | 51700 | 11489 | 176 |
1075987 | 1075987 | 2021-02-28 | Newport News city | Virginia | 51700 | 11468 | 161 |
1072741 | 1072741 | 2021-02-27 | Newport News city | Virginia | 51700 | 11431 | 158 |
1069495 | 1069495 | 2021-02-26 | Newport News city | Virginia | 51700 | 11384 | 148 |
1066250 | 1066250 | 2021-02-25 | Newport News city | Virginia | 51700 | 11344 | 141 |
1063005 | 1063005 | 2021-02-24 | Newport News city | Virginia | 51700 | 11267 | 140 |
1059760 | 1059760 | 2021-02-23 | Newport News city | Virginia | 51700 | 11214 | 138 |
1056514 | 1056514 | 2021-02-22 | Newport News city | Virginia | 51700 | 11160 | 135 |
1053268 | 1053268 | 2021-02-21 | Newport News city | Virginia | 51700 | 11128 | 132 |
1050021 | 1050021 | 2021-02-20 | Newport News city | Virginia | 51700 | 11051 | 118 |
1046774 | 1046774 | 2021-02-19 | Newport News city | Virginia | 51700 | 10995 | 115 |
1043529 | 1043529 | 2021-02-18 | Newport News city | Virginia | 51700 | 10931 | 116 |
1040284 | 1040284 | 2021-02-17 | Newport News city | Virginia | 51700 | 10900 | 117 |
1037039 | 1037039 | 2021-02-16 | Newport News city | Virginia | 51700 | 10828 | 117 |
1033794 | 1033794 | 2021-02-15 | Newport News city | Virginia | 51700 | 10801 | 117 |
1030548 | 1030548 | 2021-02-14 | Newport News city | Virginia | 51700 | 10744 | 117 |
1027301 | 1027301 | 2021-02-13 | Newport News city | Virginia | 51700 | 10647 | 113 |
1024056 | 1024056 | 2021-02-12 | Newport News city | Virginia | 51700 | 10594 | 113 |
1020811 | 1020811 | 2021-02-11 | Newport News city | Virginia | 51700 | 10546 | 113 |
1017566 | 1017566 | 2021-02-10 | Newport News city | Virginia | 51700 | 10489 | 113 |
1014321 | 1014321 | 2021-02-09 | Newport News city | Virginia | 51700 | 10418 | 113 |
1011076 | 1011076 | 2021-02-08 | Newport News city | Virginia | 51700 | 10344 | 109 |
1007830 | 1007830 | 2021-02-07 | Newport News city | Virginia | 51700 | 10285 | 103 |
1004584 | 1004584 | 2021-02-06 | Newport News city | Virginia | 51700 | 10173 | 103 |
1001338 | 1001338 | 2021-02-05 | Newport News city | Virginia | 51700 | 10102 | 103 |
998092 | 998092 | 2021-02-04 | Newport News city | Virginia | 51700 | 9983 | 101 |
994846 | 994846 | 2021-02-03 | Newport News city | Virginia | 51700 | 9931 | 100 |
991600 | 991600 | 2021-02-02 | Newport News city | Virginia | 51700 | 9895 | 97 |
988354 | 988354 | 2021-02-01 | Newport News city | Virginia | 51700 | 9838 | 97 |
985107 | 985107 | 2021-01-31 | Newport News city | Virginia | 51700 | 9772 | 97 |
981860 | 981860 | 2021-01-30 | Newport News city | Virginia | 51700 | 9728 | 93 |
978614 | 978614 | 2021-01-29 | Newport News city | Virginia | 51700 | 9635 | 89 |
975369 | 975369 | 2021-01-28 | Newport News city | Virginia | 51700 | 9534 | 87 |
972124 | 972124 | 2021-01-27 | Newport News city | Virginia | 51700 | 9401 | 87 |
968879 | 968879 | 2021-01-26 | Newport News city | Virginia | 51700 | 9216 | 87 |
965635 | 965635 | 2021-01-25 | Newport News city | Virginia | 51700 | 9034 | 83 |
962390 | 962390 | 2021-01-24 | Newport News city | Virginia | 51700 | 8818 | 83 |
959145 | 959145 | 2021-01-23 | Newport News city | Virginia | 51700 | 8696 | 83 |
955899 | 955899 | 2021-01-22 | Newport News city | Virginia | 51700 | 8517 | 79 |
952654 | 952654 | 2021-01-21 | Newport News city | Virginia | 51700 | 8412 | 79 |
949409 | 949409 | 2021-01-20 | Newport News city | Virginia | 51700 | 8252 | 76 |
946163 | 946163 | 2021-01-19 | Newport News city | Virginia | 51700 | 8101 | 76 |
942916 | 942916 | 2021-01-18 | Newport News city | Virginia | 51700 | 8008 | 76 |
939671 | 939671 | 2021-01-17 | Newport News city | Virginia | 51700 | 7795 | 76 |
936426 | 936426 | 2021-01-16 | Newport News city | Virginia | 51700 | 7593 | 76 |
933181 | 933181 | 2021-01-15 | Newport News city | Virginia | 51700 | 7454 | 76 |
929936 | 929936 | 2021-01-14 | Newport News city | Virginia | 51700 | 7319 | 76 |
926691 | 926691 | 2021-01-13 | Newport News city | Virginia | 51700 | 7228 | 76 |
923445 | 923445 | 2021-01-12 | Newport News city | Virginia | 51700 | 7154 | 74 |
920200 | 920200 | 2021-01-11 | Newport News city | Virginia | 51700 | 7047 | 73 |
916955 | 916955 | 2021-01-10 | Newport News city | Virginia | 51700 | 6949 | 73 |
913710 | 913710 | 2021-01-09 | Newport News city | Virginia | 51700 | 6814 | 73 |
910465 | 910465 | 2021-01-08 | Newport News city | Virginia | 51700 | 6710 | 73 |
907220 | 907220 | 2021-01-07 | Newport News city | Virginia | 51700 | 6630 | 72 |
903974 | 903974 | 2021-01-06 | Newport News city | Virginia | 51700 | 6541 | 72 |
900729 | 900729 | 2021-01-05 | Newport News city | Virginia | 51700 | 6464 | 72 |
897484 | 897484 | 2021-01-04 | Newport News city | Virginia | 51700 | 6369 | 70 |
894238 | 894238 | 2021-01-03 | Newport News city | Virginia | 51700 | 6252 | 70 |
890992 | 890992 | 2021-01-02 | Newport News city | Virginia | 51700 | 6065 | 70 |
887745 | 887745 | 2021-01-01 | Newport News city | Virginia | 51700 | 6060 | 70 |
884500 | 884500 | 2020-12-31 | Newport News city | Virginia | 51700 | 5973 | 69 |
881255 | 881255 | 2020-12-30 | Newport News city | Virginia | 51700 | 5892 | 69 |
878010 | 878010 | 2020-12-29 | Newport News city | Virginia | 51700 | 5837 | 68 |
874765 | 874765 | 2020-12-28 | Newport News city | Virginia | 51700 | 5673 | 66 |
871520 | 871520 | 2020-12-27 | Newport News city | Virginia | 51700 | 5586 | 66 |
868275 | 868275 | 2020-12-26 | Newport News city | Virginia | 51700 | 5545 | 66 |
865030 | 865030 | 2020-12-25 | Newport News city | Virginia | 51700 | 5538 | 65 |
861785 | 861785 | 2020-12-24 | Newport News city | Virginia | 51700 | 5500 | 64 |
858540 | 858540 | 2020-12-23 | Newport News city | Virginia | 51700 | 5401 | 64 |
855295 | 855295 | 2020-12-22 | Newport News city | Virginia | 51700 | 5315 | 64 |
852050 | 852050 | 2020-12-21 | Newport News city | Virginia | 51700 | 5191 | 64 |
848805 | 848805 | 2020-12-20 | Newport News city | Virginia | 51700 | 5145 | 64 |
845560 | 845560 | 2020-12-19 | Newport News city | Virginia | 51700 | 5083 | 64 |
842314 | 842314 | 2020-12-18 | Newport News city | Virginia | 51700 | 4996 | 63 |
839069 | 839069 | 2020-12-17 | Newport News city | Virginia | 51700 | 4911 | 63 |
835823 | 835823 | 2020-12-16 | Newport News city | Virginia | 51700 | 4854 | 63 |
832577 | 832577 | 2020-12-15 | Newport News city | Virginia | 51700 | 4749 | 63 |
829330 | 829330 | 2020-12-14 | Newport News city | Virginia | 51700 | 4663 | 58 |
826084 | 826084 | 2020-12-13 | Newport News city | Virginia | 51700 | 4608 | 58 |
822837 | 822837 | 2020-12-12 | Newport News city | Virginia | 51700 | 4525 | 58 |
819591 | 819591 | 2020-12-11 | Newport News city | Virginia | 51700 | 4449 | 58 |
816345 | 816345 | 2020-12-10 | Newport News city | Virginia | 51700 | 4408 | 56 |
813099 | 813099 | 2020-12-09 | Newport News city | Virginia | 51700 | 4369 | 56 |
809855 | 809855 | 2020-12-08 | Newport News city | Virginia | 51700 | 4323 | 56 |
806610 | 806610 | 2020-12-07 | Newport News city | Virginia | 51700 | 4305 | 56 |
803365 | 803365 | 2020-12-06 | Newport News city | Virginia | 51700 | 4255 | 56 |
800120 | 800120 | 2020-12-05 | Newport News city | Virginia | 51700 | 4198 | 56 |
796875 | 796875 | 2020-12-04 | Newport News city | Virginia | 51700 | 4179 | 55 |
793630 | 793630 | 2020-12-03 | Newport News city | Virginia | 51700 | 4144 | 55 |
790385 | 790385 | 2020-12-02 | Newport News city | Virginia | 51700 | 4123 | 55 |
787140 | 787140 | 2020-12-01 | Newport News city | Virginia | 51700 | 4085 | 55 |
783896 | 783896 | 2020-11-30 | Newport News city | Virginia | 51700 | 4061 | 55 |
780651 | 780651 | 2020-11-29 | Newport News city | Virginia | 51700 | 4023 | 55 |
777405 | 777405 | 2020-11-28 | Newport News city | Virginia | 51700 | 3952 | 55 |
774160 | 774160 | 2020-11-27 | Newport News city | Virginia | 51700 | 3918 | 55 |
770915 | 770915 | 2020-11-26 | Newport News city | Virginia | 51700 | 3913 | 54 |
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);