ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,552 rows where county = "Green" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054550 | 1054550 | 2021-02-22 | Green | Kentucky | 21087 | 1099 | 13 |
1056679 | 1056679 | 2021-02-22 | Green | Wisconsin | 55045 | 3186 | 22 |
1051303 | 1051303 | 2021-02-21 | Green | Kentucky | 21087 | 1092 | 13 |
1053433 | 1053433 | 2021-02-21 | Green | Wisconsin | 55045 | 3185 | 22 |
1048056 | 1048056 | 2021-02-20 | Green | Kentucky | 21087 | 1092 | 13 |
1050186 | 1050186 | 2021-02-20 | Green | Wisconsin | 55045 | 3175 | 22 |
1044811 | 1044811 | 2021-02-19 | Green | Kentucky | 21087 | 1089 | 13 |
1046939 | 1046939 | 2021-02-19 | Green | Wisconsin | 55045 | 3151 | 22 |
1041566 | 1041566 | 2021-02-18 | Green | Kentucky | 21087 | 1087 | 13 |
1043694 | 1043694 | 2021-02-18 | Green | Wisconsin | 55045 | 3131 | 22 |
1038321 | 1038321 | 2021-02-17 | Green | Kentucky | 21087 | 1083 | 13 |
1040449 | 1040449 | 2021-02-17 | Green | Wisconsin | 55045 | 3119 | 22 |
1035076 | 1035076 | 2021-02-16 | Green | Kentucky | 21087 | 1080 | 13 |
1037204 | 1037204 | 2021-02-16 | Green | Wisconsin | 55045 | 3087 | 22 |
1031830 | 1031830 | 2021-02-15 | Green | Kentucky | 21087 | 1074 | 13 |
1033959 | 1033959 | 2021-02-15 | Green | Wisconsin | 55045 | 3080 | 22 |
1028583 | 1028583 | 2021-02-14 | Green | Kentucky | 21087 | 1070 | 13 |
1030713 | 1030713 | 2021-02-14 | Green | Wisconsin | 55045 | 3075 | 22 |
1025338 | 1025338 | 2021-02-13 | Green | Kentucky | 21087 | 1070 | 13 |
1027466 | 1027466 | 2021-02-13 | Green | Wisconsin | 55045 | 3067 | 22 |
1022093 | 1022093 | 2021-02-12 | Green | Kentucky | 21087 | 1063 | 13 |
1024221 | 1024221 | 2021-02-12 | Green | Wisconsin | 55045 | 3045 | 22 |
1018848 | 1018848 | 2021-02-11 | Green | Kentucky | 21087 | 1055 | 13 |
1020976 | 1020976 | 2021-02-11 | Green | Wisconsin | 55045 | 3017 | 21 |
1015603 | 1015603 | 2021-02-10 | Green | Kentucky | 21087 | 1053 | 13 |
1017731 | 1017731 | 2021-02-10 | Green | Wisconsin | 55045 | 3000 | 21 |
1012358 | 1012358 | 2021-02-09 | Green | Kentucky | 21087 | 1049 | 13 |
1014486 | 1014486 | 2021-02-09 | Green | Wisconsin | 55045 | 2962 | 21 |
1009112 | 1009112 | 2021-02-08 | Green | Kentucky | 21087 | 1046 | 13 |
1011241 | 1011241 | 2021-02-08 | Green | Wisconsin | 55045 | 2957 | 19 |
1005866 | 1005866 | 2021-02-07 | Green | Kentucky | 21087 | 1037 | 13 |
1007995 | 1007995 | 2021-02-07 | Green | Wisconsin | 55045 | 2950 | 19 |
1002620 | 1002620 | 2021-02-06 | Green | Kentucky | 21087 | 1037 | 13 |
1004749 | 1004749 | 2021-02-06 | Green | Wisconsin | 55045 | 2940 | 19 |
999374 | 999374 | 2021-02-05 | Green | Kentucky | 21087 | 1024 | 13 |
1001503 | 1001503 | 2021-02-05 | Green | Wisconsin | 55045 | 2922 | 19 |
996128 | 996128 | 2021-02-04 | Green | Kentucky | 21087 | 1018 | 13 |
998257 | 998257 | 2021-02-04 | Green | Wisconsin | 55045 | 2901 | 19 |
992882 | 992882 | 2021-02-03 | Green | Kentucky | 21087 | 1012 | 13 |
995011 | 995011 | 2021-02-03 | Green | Wisconsin | 55045 | 2874 | 19 |
989636 | 989636 | 2021-02-02 | Green | Kentucky | 21087 | 1001 | 13 |
991765 | 991765 | 2021-02-02 | Green | Wisconsin | 55045 | 2844 | 19 |
986389 | 986389 | 2021-02-01 | Green | Kentucky | 21087 | 995 | 13 |
988519 | 988519 | 2021-02-01 | Green | Wisconsin | 55045 | 2837 | 19 |
983142 | 983142 | 2021-01-31 | Green | Kentucky | 21087 | 990 | 13 |
985272 | 985272 | 2021-01-31 | Green | Wisconsin | 55045 | 2829 | 19 |
979896 | 979896 | 2021-01-30 | Green | Kentucky | 21087 | 985 | 13 |
982025 | 982025 | 2021-01-30 | Green | Wisconsin | 55045 | 2812 | 19 |
976650 | 976650 | 2021-01-29 | Green | Kentucky | 21087 | 982 | 13 |
978779 | 978779 | 2021-01-29 | Green | Wisconsin | 55045 | 2805 | 19 |
973405 | 973405 | 2021-01-28 | Green | Kentucky | 21087 | 980 | 13 |
975534 | 975534 | 2021-01-28 | Green | Wisconsin | 55045 | 2773 | 17 |
970160 | 970160 | 2021-01-27 | Green | Kentucky | 21087 | 976 | 13 |
972289 | 972289 | 2021-01-27 | Green | Wisconsin | 55045 | 2756 | 17 |
966916 | 966916 | 2021-01-26 | Green | Kentucky | 21087 | 971 | 13 |
969044 | 969044 | 2021-01-26 | Green | Wisconsin | 55045 | 2730 | 17 |
963671 | 963671 | 2021-01-25 | Green | Kentucky | 21087 | 967 | 13 |
965800 | 965800 | 2021-01-25 | Green | Wisconsin | 55045 | 2716 | 17 |
960426 | 960426 | 2021-01-24 | Green | Kentucky | 21087 | 963 | 13 |
962555 | 962555 | 2021-01-24 | Green | Wisconsin | 55045 | 2712 | 17 |
957180 | 957180 | 2021-01-23 | Green | Kentucky | 21087 | 958 | 13 |
959310 | 959310 | 2021-01-23 | Green | Wisconsin | 55045 | 2705 | 17 |
953935 | 953935 | 2021-01-22 | Green | Kentucky | 21087 | 948 | 13 |
956064 | 956064 | 2021-01-22 | Green | Wisconsin | 55045 | 2683 | 15 |
950690 | 950690 | 2021-01-21 | Green | Kentucky | 21087 | 940 | 13 |
952819 | 952819 | 2021-01-21 | Green | Wisconsin | 55045 | 2659 | 15 |
947444 | 947444 | 2021-01-20 | Green | Kentucky | 21087 | 932 | 13 |
949574 | 949574 | 2021-01-20 | Green | Wisconsin | 55045 | 2649 | 15 |
944197 | 944197 | 2021-01-19 | Green | Kentucky | 21087 | 924 | 12 |
946328 | 946328 | 2021-01-19 | Green | Wisconsin | 55045 | 2635 | 15 |
940952 | 940952 | 2021-01-18 | Green | Kentucky | 21087 | 915 | 12 |
943081 | 943081 | 2021-01-18 | Green | Wisconsin | 55045 | 2630 | 15 |
937707 | 937707 | 2021-01-17 | Green | Kentucky | 21087 | 912 | 12 |
939836 | 939836 | 2021-01-17 | Green | Wisconsin | 55045 | 2625 | 14 |
934462 | 934462 | 2021-01-16 | Green | Kentucky | 21087 | 910 | 12 |
936591 | 936591 | 2021-01-16 | Green | Wisconsin | 55045 | 2614 | 14 |
931217 | 931217 | 2021-01-15 | Green | Kentucky | 21087 | 906 | 12 |
933346 | 933346 | 2021-01-15 | Green | Wisconsin | 55045 | 2597 | 14 |
927972 | 927972 | 2021-01-14 | Green | Kentucky | 21087 | 897 | 12 |
930101 | 930101 | 2021-01-14 | Green | Wisconsin | 55045 | 2578 | 14 |
924726 | 924726 | 2021-01-13 | Green | Kentucky | 21087 | 890 | 12 |
926856 | 926856 | 2021-01-13 | Green | Wisconsin | 55045 | 2566 | 14 |
921481 | 921481 | 2021-01-12 | Green | Kentucky | 21087 | 883 | 12 |
923610 | 923610 | 2021-01-12 | Green | Wisconsin | 55045 | 2542 | 14 |
918236 | 918236 | 2021-01-11 | Green | Kentucky | 21087 | 873 | 12 |
920365 | 920365 | 2021-01-11 | Green | Wisconsin | 55045 | 2527 | 14 |
914991 | 914991 | 2021-01-10 | Green | Kentucky | 21087 | 870 | 12 |
917120 | 917120 | 2021-01-10 | Green | Wisconsin | 55045 | 2523 | 14 |
911746 | 911746 | 2021-01-09 | Green | Kentucky | 21087 | 869 | 12 |
913875 | 913875 | 2021-01-09 | Green | Wisconsin | 55045 | 2511 | 14 |
908501 | 908501 | 2021-01-08 | Green | Kentucky | 21087 | 858 | 12 |
910630 | 910630 | 2021-01-08 | Green | Wisconsin | 55045 | 2489 | 14 |
905255 | 905255 | 2021-01-07 | Green | Kentucky | 21087 | 848 | 12 |
907385 | 907385 | 2021-01-07 | Green | Wisconsin | 55045 | 2471 | 13 |
902010 | 902010 | 2021-01-06 | Green | Kentucky | 21087 | 840 | 12 |
904139 | 904139 | 2021-01-06 | Green | Wisconsin | 55045 | 2459 | 13 |
898765 | 898765 | 2021-01-05 | Green | Kentucky | 21087 | 834 | 12 |
900894 | 900894 | 2021-01-05 | Green | Wisconsin | 55045 | 2438 | 13 |
895520 | 895520 | 2021-01-04 | Green | Kentucky | 21087 | 829 | 12 |
897649 | 897649 | 2021-01-04 | Green | Wisconsin | 55045 | 2438 | 12 |
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);