ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Jefferson" and fips = 12065 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053859 | 1053859 | 2021-02-22 | Jefferson | Florida | 12065 | 1392 | 23 |
1050612 | 1050612 | 2021-02-21 | Jefferson | Florida | 12065 | 1390 | 22 |
1047365 | 1047365 | 2021-02-20 | Jefferson | Florida | 12065 | 1390 | 22 |
1044120 | 1044120 | 2021-02-19 | Jefferson | Florida | 12065 | 1385 | 22 |
1040875 | 1040875 | 2021-02-18 | Jefferson | Florida | 12065 | 1380 | 22 |
1037630 | 1037630 | 2021-02-17 | Jefferson | Florida | 12065 | 1380 | 22 |
1034385 | 1034385 | 2021-02-16 | Jefferson | Florida | 12065 | 1378 | 22 |
1031139 | 1031139 | 2021-02-15 | Jefferson | Florida | 12065 | 1373 | 22 |
1027892 | 1027892 | 2021-02-14 | Jefferson | Florida | 12065 | 1372 | 22 |
1024647 | 1024647 | 2021-02-13 | Jefferson | Florida | 12065 | 1369 | 22 |
1021402 | 1021402 | 2021-02-12 | Jefferson | Florida | 12065 | 1365 | 22 |
1018157 | 1018157 | 2021-02-11 | Jefferson | Florida | 12065 | 1362 | 22 |
1014912 | 1014912 | 2021-02-10 | Jefferson | Florida | 12065 | 1351 | 22 |
1011667 | 1011667 | 2021-02-09 | Jefferson | Florida | 12065 | 1346 | 22 |
1008421 | 1008421 | 2021-02-08 | Jefferson | Florida | 12065 | 1341 | 22 |
1005175 | 1005175 | 2021-02-07 | Jefferson | Florida | 12065 | 1341 | 22 |
1001929 | 1001929 | 2021-02-06 | Jefferson | Florida | 12065 | 1334 | 22 |
998683 | 998683 | 2021-02-05 | Jefferson | Florida | 12065 | 1326 | 22 |
995437 | 995437 | 2021-02-04 | Jefferson | Florida | 12065 | 1321 | 22 |
992191 | 992191 | 2021-02-03 | Jefferson | Florida | 12065 | 1315 | 22 |
988945 | 988945 | 2021-02-02 | Jefferson | Florida | 12065 | 1307 | 22 |
985698 | 985698 | 2021-02-01 | Jefferson | Florida | 12065 | 1297 | 22 |
982451 | 982451 | 2021-01-31 | Jefferson | Florida | 12065 | 1296 | 22 |
979205 | 979205 | 2021-01-30 | Jefferson | Florida | 12065 | 1285 | 22 |
975960 | 975960 | 2021-01-29 | Jefferson | Florida | 12065 | 1277 | 21 |
972715 | 972715 | 2021-01-28 | Jefferson | Florida | 12065 | 1273 | 21 |
969470 | 969470 | 2021-01-27 | Jefferson | Florida | 12065 | 1255 | 21 |
966226 | 966226 | 2021-01-26 | Jefferson | Florida | 12065 | 1252 | 19 |
962981 | 962981 | 2021-01-25 | Jefferson | Florida | 12065 | 1250 | 19 |
959736 | 959736 | 2021-01-24 | Jefferson | Florida | 12065 | 1247 | 19 |
956490 | 956490 | 2021-01-23 | Jefferson | Florida | 12065 | 1241 | 19 |
953245 | 953245 | 2021-01-22 | Jefferson | Florida | 12065 | 1233 | 18 |
950000 | 950000 | 2021-01-21 | Jefferson | Florida | 12065 | 1220 | 18 |
946754 | 946754 | 2021-01-20 | Jefferson | Florida | 12065 | 1210 | 18 |
943507 | 943507 | 2021-01-19 | Jefferson | Florida | 12065 | 1199 | 18 |
940262 | 940262 | 2021-01-18 | Jefferson | Florida | 12065 | 1193 | 18 |
937017 | 937017 | 2021-01-17 | Jefferson | Florida | 12065 | 1191 | 18 |
933772 | 933772 | 2021-01-16 | Jefferson | Florida | 12065 | 1176 | 18 |
930527 | 930527 | 2021-01-15 | Jefferson | Florida | 12065 | 1170 | 18 |
927282 | 927282 | 2021-01-14 | Jefferson | Florida | 12065 | 1160 | 18 |
924036 | 924036 | 2021-01-13 | Jefferson | Florida | 12065 | 1151 | 18 |
920791 | 920791 | 2021-01-12 | Jefferson | Florida | 12065 | 1141 | 18 |
917546 | 917546 | 2021-01-11 | Jefferson | Florida | 12065 | 1127 | 18 |
914301 | 914301 | 2021-01-10 | Jefferson | Florida | 12065 | 1126 | 18 |
911056 | 911056 | 2021-01-09 | Jefferson | Florida | 12065 | 1111 | 18 |
907811 | 907811 | 2021-01-08 | Jefferson | Florida | 12065 | 1105 | 18 |
904565 | 904565 | 2021-01-07 | Jefferson | Florida | 12065 | 1090 | 18 |
901320 | 901320 | 2021-01-06 | Jefferson | Florida | 12065 | 1077 | 18 |
898075 | 898075 | 2021-01-05 | Jefferson | Florida | 12065 | 1055 | 18 |
894830 | 894830 | 2021-01-04 | Jefferson | Florida | 12065 | 1040 | 17 |
891583 | 891583 | 2021-01-03 | Jefferson | Florida | 12065 | 1036 | 17 |
888336 | 888336 | 2021-01-02 | Jefferson | Florida | 12065 | 1032 | 17 |
885091 | 885091 | 2021-01-01 | Jefferson | Florida | 12065 | 994 | 16 |
881846 | 881846 | 2020-12-31 | Jefferson | Florida | 12065 | 994 | 16 |
878601 | 878601 | 2020-12-30 | Jefferson | Florida | 12065 | 981 | 16 |
875356 | 875356 | 2020-12-29 | Jefferson | Florida | 12065 | 971 | 16 |
872111 | 872111 | 2020-12-28 | Jefferson | Florida | 12065 | 957 | 16 |
868866 | 868866 | 2020-12-27 | Jefferson | Florida | 12065 | 955 | 16 |
865621 | 865621 | 2020-12-26 | Jefferson | Florida | 12065 | 945 | 16 |
862376 | 862376 | 2020-12-25 | Jefferson | Florida | 12065 | 909 | 16 |
859131 | 859131 | 2020-12-24 | Jefferson | Florida | 12065 | 909 | 16 |
855886 | 855886 | 2020-12-23 | Jefferson | Florida | 12065 | 905 | 16 |
852641 | 852641 | 2020-12-22 | Jefferson | Florida | 12065 | 897 | 15 |
849396 | 849396 | 2020-12-21 | Jefferson | Florida | 12065 | 890 | 15 |
846151 | 846151 | 2020-12-20 | Jefferson | Florida | 12065 | 885 | 14 |
842905 | 842905 | 2020-12-19 | Jefferson | Florida | 12065 | 875 | 14 |
839660 | 839660 | 2020-12-18 | Jefferson | Florida | 12065 | 872 | 14 |
836415 | 836415 | 2020-12-17 | Jefferson | Florida | 12065 | 864 | 14 |
833169 | 833169 | 2020-12-16 | Jefferson | Florida | 12065 | 856 | 13 |
829922 | 829922 | 2020-12-15 | Jefferson | Florida | 12065 | 848 | 12 |
826676 | 826676 | 2020-12-14 | Jefferson | Florida | 12065 | 842 | 12 |
823429 | 823429 | 2020-12-13 | Jefferson | Florida | 12065 | 836 | 12 |
820183 | 820183 | 2020-12-12 | Jefferson | Florida | 12065 | 833 | 12 |
816937 | 816937 | 2020-12-11 | Jefferson | Florida | 12065 | 826 | 12 |
813691 | 813691 | 2020-12-10 | Jefferson | Florida | 12065 | 816 | 12 |
810447 | 810447 | 2020-12-09 | Jefferson | Florida | 12065 | 815 | 12 |
807202 | 807202 | 2020-12-08 | Jefferson | Florida | 12065 | 810 | 12 |
803957 | 803957 | 2020-12-07 | Jefferson | Florida | 12065 | 803 | 12 |
800712 | 800712 | 2020-12-06 | Jefferson | Florida | 12065 | 802 | 12 |
797467 | 797467 | 2020-12-05 | Jefferson | Florida | 12065 | 802 | 12 |
794222 | 794222 | 2020-12-04 | Jefferson | Florida | 12065 | 799 | 12 |
790977 | 790977 | 2020-12-03 | Jefferson | Florida | 12065 | 792 | 11 |
787732 | 787732 | 2020-12-02 | Jefferson | Florida | 12065 | 789 | 11 |
784488 | 784488 | 2020-12-01 | Jefferson | Florida | 12065 | 785 | 11 |
781243 | 781243 | 2020-11-30 | Jefferson | Florida | 12065 | 774 | 11 |
777997 | 777997 | 2020-11-29 | Jefferson | Florida | 12065 | 773 | 11 |
774752 | 774752 | 2020-11-28 | Jefferson | Florida | 12065 | 770 | 11 |
771507 | 771507 | 2020-11-27 | Jefferson | Florida | 12065 | 764 | 11 |
768262 | 768262 | 2020-11-26 | Jefferson | Florida | 12065 | 750 | 11 |
765016 | 765016 | 2020-11-25 | Jefferson | Florida | 12065 | 750 | 11 |
761771 | 761771 | 2020-11-24 | Jefferson | Florida | 12065 | 743 | 11 |
758526 | 758526 | 2020-11-23 | Jefferson | Florida | 12065 | 739 | 11 |
755279 | 755279 | 2020-11-22 | Jefferson | Florida | 12065 | 736 | 11 |
752033 | 752033 | 2020-11-21 | Jefferson | Florida | 12065 | 736 | 11 |
748787 | 748787 | 2020-11-20 | Jefferson | Florida | 12065 | 730 | 11 |
745541 | 745541 | 2020-11-19 | Jefferson | Florida | 12065 | 728 | 11 |
742294 | 742294 | 2020-11-18 | Jefferson | Florida | 12065 | 725 | 11 |
739047 | 739047 | 2020-11-17 | Jefferson | Florida | 12065 | 724 | 11 |
735803 | 735803 | 2020-11-16 | Jefferson | Florida | 12065 | 718 | 11 |
732557 | 732557 | 2020-11-15 | Jefferson | Florida | 12065 | 718 | 11 |
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);