ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "St. Johns" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1063622 | 1063622 | 2021-02-25 | St. Johns | Florida | 12109 | 19982 | 189 |
1060377 | 1060377 | 2021-02-24 | St. Johns | Florida | 12109 | 19945 | 188 |
1057131 | 1057131 | 2021-02-23 | St. Johns | Florida | 12109 | 19905 | 188 |
1053885 | 1053885 | 2021-02-22 | St. Johns | Florida | 12109 | 19860 | 188 |
1050638 | 1050638 | 2021-02-21 | St. Johns | Florida | 12109 | 19835 | 186 |
1047391 | 1047391 | 2021-02-20 | St. Johns | Florida | 12109 | 19799 | 185 |
1044146 | 1044146 | 2021-02-19 | St. Johns | Florida | 12109 | 19727 | 184 |
1040901 | 1040901 | 2021-02-18 | St. Johns | Florida | 12109 | 19705 | 182 |
1037656 | 1037656 | 2021-02-17 | St. Johns | Florida | 12109 | 19660 | 182 |
1034411 | 1034411 | 2021-02-16 | St. Johns | Florida | 12109 | 19610 | 182 |
1031165 | 1031165 | 2021-02-15 | St. Johns | Florida | 12109 | 19568 | 182 |
1027918 | 1027918 | 2021-02-14 | St. Johns | Florida | 12109 | 19532 | 182 |
1024673 | 1024673 | 2021-02-13 | St. Johns | Florida | 12109 | 19457 | 182 |
1021428 | 1021428 | 2021-02-12 | St. Johns | Florida | 12109 | 19401 | 180 |
1018183 | 1018183 | 2021-02-11 | St. Johns | Florida | 12109 | 19343 | 180 |
1014938 | 1014938 | 2021-02-10 | St. Johns | Florida | 12109 | 19229 | 176 |
1011693 | 1011693 | 2021-02-09 | St. Johns | Florida | 12109 | 19167 | 175 |
1008447 | 1008447 | 2021-02-08 | St. Johns | Florida | 12109 | 19089 | 175 |
1005201 | 1005201 | 2021-02-07 | St. Johns | Florida | 12109 | 19023 | 175 |
1001955 | 1001955 | 2021-02-06 | St. Johns | Florida | 12109 | 18948 | 175 |
998709 | 998709 | 2021-02-05 | St. Johns | Florida | 12109 | 18855 | 174 |
995463 | 995463 | 2021-02-04 | St. Johns | Florida | 12109 | 18743 | 173 |
992217 | 992217 | 2021-02-03 | St. Johns | Florida | 12109 | 18676 | 170 |
988971 | 988971 | 2021-02-02 | St. Johns | Florida | 12109 | 18594 | 170 |
985724 | 985724 | 2021-02-01 | St. Johns | Florida | 12109 | 18397 | 167 |
982477 | 982477 | 2021-01-31 | St. Johns | Florida | 12109 | 18328 | 166 |
979231 | 979231 | 2021-01-30 | St. Johns | Florida | 12109 | 18261 | 164 |
975986 | 975986 | 2021-01-29 | St. Johns | Florida | 12109 | 18085 | 161 |
972741 | 972741 | 2021-01-28 | St. Johns | Florida | 12109 | 17918 | 160 |
969496 | 969496 | 2021-01-27 | St. Johns | Florida | 12109 | 17784 | 158 |
966252 | 966252 | 2021-01-26 | St. Johns | Florida | 12109 | 17695 | 157 |
963007 | 963007 | 2021-01-25 | St. Johns | Florida | 12109 | 17573 | 155 |
959762 | 959762 | 2021-01-24 | St. Johns | Florida | 12109 | 17492 | 154 |
956516 | 956516 | 2021-01-23 | St. Johns | Florida | 12109 | 17379 | 151 |
953271 | 953271 | 2021-01-22 | St. Johns | Florida | 12109 | 17242 | 146 |
950026 | 950026 | 2021-01-21 | St. Johns | Florida | 12109 | 17044 | 145 |
946780 | 946780 | 2021-01-20 | St. Johns | Florida | 12109 | 16887 | 143 |
943533 | 943533 | 2021-01-19 | St. Johns | Florida | 12109 | 16763 | 140 |
940288 | 940288 | 2021-01-18 | St. Johns | Florida | 12109 | 16673 | 140 |
937043 | 937043 | 2021-01-17 | St. Johns | Florida | 12109 | 16555 | 138 |
933798 | 933798 | 2021-01-16 | St. Johns | Florida | 12109 | 16460 | 136 |
930553 | 930553 | 2021-01-15 | St. Johns | Florida | 12109 | 16306 | 134 |
927308 | 927308 | 2021-01-14 | St. Johns | Florida | 12109 | 16073 | 130 |
924062 | 924062 | 2021-01-13 | St. Johns | Florida | 12109 | 15906 | 129 |
920817 | 920817 | 2021-01-12 | St. Johns | Florida | 12109 | 15700 | 129 |
917572 | 917572 | 2021-01-11 | St. Johns | Florida | 12109 | 15492 | 129 |
914327 | 914327 | 2021-01-10 | St. Johns | Florida | 12109 | 15329 | 123 |
911082 | 911082 | 2021-01-09 | St. Johns | Florida | 12109 | 15165 | 120 |
907837 | 907837 | 2021-01-08 | St. Johns | Florida | 12109 | 15000 | 119 |
904591 | 904591 | 2021-01-07 | St. Johns | Florida | 12109 | 14697 | 118 |
901346 | 901346 | 2021-01-06 | St. Johns | Florida | 12109 | 14407 | 118 |
898101 | 898101 | 2021-01-05 | St. Johns | Florida | 12109 | 14165 | 117 |
894856 | 894856 | 2021-01-04 | St. Johns | Florida | 12109 | 13858 | 117 |
891609 | 891609 | 2021-01-03 | St. Johns | Florida | 12109 | 13756 | 115 |
888362 | 888362 | 2021-01-02 | St. Johns | Florida | 12109 | 13556 | 115 |
885117 | 885117 | 2021-01-01 | St. Johns | Florida | 12109 | 13072 | 113 |
881872 | 881872 | 2020-12-31 | St. Johns | Florida | 12109 | 13072 | 113 |
878627 | 878627 | 2020-12-30 | St. Johns | Florida | 12109 | 12828 | 112 |
875382 | 875382 | 2020-12-29 | St. Johns | Florida | 12109 | 12660 | 112 |
872137 | 872137 | 2020-12-28 | St. Johns | Florida | 12109 | 12481 | 112 |
868892 | 868892 | 2020-12-27 | St. Johns | Florida | 12109 | 12407 | 112 |
865647 | 865647 | 2020-12-26 | St. Johns | Florida | 12109 | 12299 | 110 |
862402 | 862402 | 2020-12-25 | St. Johns | Florida | 12109 | 12003 | 109 |
859157 | 859157 | 2020-12-24 | St. Johns | Florida | 12109 | 12003 | 109 |
855912 | 855912 | 2020-12-23 | St. Johns | Florida | 12109 | 11818 | 109 |
852667 | 852667 | 2020-12-22 | St. Johns | Florida | 12109 | 11659 | 109 |
849422 | 849422 | 2020-12-21 | St. Johns | Florida | 12109 | 11491 | 110 |
846177 | 846177 | 2020-12-20 | St. Johns | Florida | 12109 | 11300 | 108 |
842931 | 842931 | 2020-12-19 | St. Johns | Florida | 12109 | 11172 | 108 |
839686 | 839686 | 2020-12-18 | St. Johns | Florida | 12109 | 11025 | 108 |
836441 | 836441 | 2020-12-17 | St. Johns | Florida | 12109 | 10868 | 108 |
833195 | 833195 | 2020-12-16 | St. Johns | Florida | 12109 | 10697 | 107 |
829948 | 829948 | 2020-12-15 | St. Johns | Florida | 12109 | 10542 | 106 |
826702 | 826702 | 2020-12-14 | St. Johns | Florida | 12109 | 10422 | 106 |
823455 | 823455 | 2020-12-13 | St. Johns | Florida | 12109 | 10331 | 105 |
820209 | 820209 | 2020-12-12 | St. Johns | Florida | 12109 | 10215 | 105 |
816963 | 816963 | 2020-12-11 | St. Johns | Florida | 12109 | 10080 | 104 |
813717 | 813717 | 2020-12-10 | St. Johns | Florida | 12109 | 9942 | 103 |
810473 | 810473 | 2020-12-09 | St. Johns | Florida | 12109 | 9852 | 102 |
807228 | 807228 | 2020-12-08 | St. Johns | Florida | 12109 | 9722 | 102 |
803983 | 803983 | 2020-12-07 | St. Johns | Florida | 12109 | 9620 | 101 |
800738 | 800738 | 2020-12-06 | St. Johns | Florida | 12109 | 9542 | 100 |
797493 | 797493 | 2020-12-05 | St. Johns | Florida | 12109 | 9433 | 99 |
794248 | 794248 | 2020-12-04 | St. Johns | Florida | 12109 | 9339 | 99 |
791003 | 791003 | 2020-12-03 | St. Johns | Florida | 12109 | 9217 | 99 |
787758 | 787758 | 2020-12-02 | St. Johns | Florida | 12109 | 9085 | 97 |
784514 | 784514 | 2020-12-01 | St. Johns | Florida | 12109 | 8931 | 96 |
781269 | 781269 | 2020-11-30 | St. Johns | Florida | 12109 | 8832 | 96 |
778023 | 778023 | 2020-11-29 | St. Johns | Florida | 12109 | 8727 | 96 |
774778 | 774778 | 2020-11-28 | St. Johns | Florida | 12109 | 8649 | 95 |
771533 | 771533 | 2020-11-27 | St. Johns | Florida | 12109 | 8539 | 94 |
768288 | 768288 | 2020-11-26 | St. Johns | Florida | 12109 | 8308 | 94 |
765042 | 765042 | 2020-11-25 | St. Johns | Florida | 12109 | 8308 | 94 |
761797 | 761797 | 2020-11-24 | St. Johns | Florida | 12109 | 8205 | 92 |
758552 | 758552 | 2020-11-23 | St. Johns | Florida | 12109 | 8082 | 91 |
755305 | 755305 | 2020-11-22 | St. Johns | Florida | 12109 | 8030 | 91 |
752059 | 752059 | 2020-11-21 | St. Johns | Florida | 12109 | 7952 | 91 |
748813 | 748813 | 2020-11-20 | St. Johns | Florida | 12109 | 7881 | 90 |
745567 | 745567 | 2020-11-19 | St. Johns | Florida | 12109 | 7786 | 90 |
742320 | 742320 | 2020-11-18 | St. Johns | Florida | 12109 | 7699 | 89 |
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);