ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Bourbon" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054406 | 1054406 | 2021-02-22 | Bourbon | Kansas | 20011 | 1273 | 3 |
1051159 | 1051159 | 2021-02-21 | Bourbon | Kansas | 20011 | 1271 | 3 |
1047912 | 1047912 | 2021-02-20 | Bourbon | Kansas | 20011 | 1271 | 3 |
1044667 | 1044667 | 2021-02-19 | Bourbon | Kansas | 20011 | 1271 | 3 |
1041422 | 1041422 | 2021-02-18 | Bourbon | Kansas | 20011 | 1267 | 3 |
1038177 | 1038177 | 2021-02-17 | Bourbon | Kansas | 20011 | 1267 | 3 |
1034932 | 1034932 | 2021-02-16 | Bourbon | Kansas | 20011 | 1258 | 3 |
1031686 | 1031686 | 2021-02-15 | Bourbon | Kansas | 20011 | 1258 | 3 |
1028439 | 1028439 | 2021-02-14 | Bourbon | Kansas | 20011 | 1253 | 3 |
1025194 | 1025194 | 2021-02-13 | Bourbon | Kansas | 20011 | 1253 | 3 |
1021949 | 1021949 | 2021-02-12 | Bourbon | Kansas | 20011 | 1253 | 3 |
1018704 | 1018704 | 2021-02-11 | Bourbon | Kansas | 20011 | 1248 | 3 |
1015459 | 1015459 | 2021-02-10 | Bourbon | Kansas | 20011 | 1248 | 3 |
1012214 | 1012214 | 2021-02-09 | Bourbon | Kansas | 20011 | 1241 | 3 |
1008968 | 1008968 | 2021-02-08 | Bourbon | Kansas | 20011 | 1241 | 3 |
1005722 | 1005722 | 2021-02-07 | Bourbon | Kansas | 20011 | 1231 | 3 |
1002476 | 1002476 | 2021-02-06 | Bourbon | Kansas | 20011 | 1231 | 3 |
999230 | 999230 | 2021-02-05 | Bourbon | Kansas | 20011 | 1231 | 3 |
995984 | 995984 | 2021-02-04 | Bourbon | Kansas | 20011 | 1222 | 3 |
992738 | 992738 | 2021-02-03 | Bourbon | Kansas | 20011 | 1222 | 3 |
989492 | 989492 | 2021-02-02 | Bourbon | Kansas | 20011 | 1216 | 3 |
986245 | 986245 | 2021-02-01 | Bourbon | Kansas | 20011 | 1216 | 3 |
982998 | 982998 | 2021-01-31 | Bourbon | Kansas | 20011 | 1211 | 3 |
979752 | 979752 | 2021-01-30 | Bourbon | Kansas | 20011 | 1211 | 3 |
976506 | 976506 | 2021-01-29 | Bourbon | Kansas | 20011 | 1211 | 3 |
973261 | 973261 | 2021-01-28 | Bourbon | Kansas | 20011 | 1205 | 3 |
970016 | 970016 | 2021-01-27 | Bourbon | Kansas | 20011 | 1205 | 3 |
966772 | 966772 | 2021-01-26 | Bourbon | Kansas | 20011 | 1191 | 3 |
963527 | 963527 | 2021-01-25 | Bourbon | Kansas | 20011 | 1191 | 3 |
960282 | 960282 | 2021-01-24 | Bourbon | Kansas | 20011 | 1184 | 3 |
957036 | 957036 | 2021-01-23 | Bourbon | Kansas | 20011 | 1184 | 3 |
953791 | 953791 | 2021-01-22 | Bourbon | Kansas | 20011 | 1184 | 3 |
950546 | 950546 | 2021-01-21 | Bourbon | Kansas | 20011 | 1181 | 3 |
947300 | 947300 | 2021-01-20 | Bourbon | Kansas | 20011 | 1181 | 3 |
944053 | 944053 | 2021-01-19 | Bourbon | Kansas | 20011 | 1164 | 3 |
940808 | 940808 | 2021-01-18 | Bourbon | Kansas | 20011 | 1164 | 3 |
937563 | 937563 | 2021-01-17 | Bourbon | Kansas | 20011 | 1151 | 3 |
934318 | 934318 | 2021-01-16 | Bourbon | Kansas | 20011 | 1151 | 3 |
931073 | 931073 | 2021-01-15 | Bourbon | Kansas | 20011 | 1151 | 3 |
927828 | 927828 | 2021-01-14 | Bourbon | Kansas | 20011 | 1123 | 3 |
924582 | 924582 | 2021-01-13 | Bourbon | Kansas | 20011 | 1123 | 3 |
921337 | 921337 | 2021-01-12 | Bourbon | Kansas | 20011 | 1081 | 3 |
918092 | 918092 | 2021-01-11 | Bourbon | Kansas | 20011 | 1081 | 3 |
914847 | 914847 | 2021-01-10 | Bourbon | Kansas | 20011 | 1066 | 3 |
911602 | 911602 | 2021-01-09 | Bourbon | Kansas | 20011 | 1066 | 3 |
908357 | 908357 | 2021-01-08 | Bourbon | Kansas | 20011 | 1066 | 3 |
905111 | 905111 | 2021-01-07 | Bourbon | Kansas | 20011 | 1034 | 3 |
901866 | 901866 | 2021-01-06 | Bourbon | Kansas | 20011 | 1034 | 3 |
898621 | 898621 | 2021-01-05 | Bourbon | Kansas | 20011 | 1003 | 3 |
895376 | 895376 | 2021-01-04 | Bourbon | Kansas | 20011 | 1003 | 3 |
892129 | 892129 | 2021-01-03 | Bourbon | Kansas | 20011 | 971 | 3 |
888883 | 888883 | 2021-01-02 | Bourbon | Kansas | 20011 | 971 | 3 |
885637 | 885637 | 2021-01-01 | Bourbon | Kansas | 20011 | 971 | 3 |
882392 | 882392 | 2020-12-31 | Bourbon | Kansas | 20011 | 927 | 3 |
879147 | 879147 | 2020-12-30 | Bourbon | Kansas | 20011 | 927 | 3 |
875902 | 875902 | 2020-12-29 | Bourbon | Kansas | 20011 | 870 | 3 |
872657 | 872657 | 2020-12-28 | Bourbon | Kansas | 20011 | 870 | 3 |
869412 | 869412 | 2020-12-27 | Bourbon | Kansas | 20011 | 834 | 3 |
866167 | 866167 | 2020-12-26 | Bourbon | Kansas | 20011 | 834 | 3 |
862922 | 862922 | 2020-12-25 | Bourbon | Kansas | 20011 | 834 | 3 |
859677 | 859677 | 2020-12-24 | Bourbon | Kansas | 20011 | 834 | 3 |
856432 | 856432 | 2020-12-23 | Bourbon | Kansas | 20011 | 834 | 3 |
853187 | 853187 | 2020-12-22 | Bourbon | Kansas | 20011 | 811 | 3 |
849942 | 849942 | 2020-12-21 | Bourbon | Kansas | 20011 | 811 | 3 |
846697 | 846697 | 2020-12-20 | Bourbon | Kansas | 20011 | 799 | 3 |
843451 | 843451 | 2020-12-19 | Bourbon | Kansas | 20011 | 799 | 3 |
840206 | 840206 | 2020-12-18 | Bourbon | Kansas | 20011 | 799 | 3 |
836961 | 836961 | 2020-12-17 | Bourbon | Kansas | 20011 | 762 | 3 |
833715 | 833715 | 2020-12-16 | Bourbon | Kansas | 20011 | 762 | 3 |
830468 | 830468 | 2020-12-15 | Bourbon | Kansas | 20011 | 730 | 3 |
827222 | 827222 | 2020-12-14 | Bourbon | Kansas | 20011 | 730 | 3 |
823975 | 823975 | 2020-12-13 | Bourbon | Kansas | 20011 | 722 | 3 |
820729 | 820729 | 2020-12-12 | Bourbon | Kansas | 20011 | 722 | 3 |
817483 | 817483 | 2020-12-11 | Bourbon | Kansas | 20011 | 722 | 3 |
814237 | 814237 | 2020-12-10 | Bourbon | Kansas | 20011 | 695 | 3 |
810992 | 810992 | 2020-12-09 | Bourbon | Kansas | 20011 | 695 | 3 |
807747 | 807747 | 2020-12-08 | Bourbon | Kansas | 20011 | 663 | 3 |
804502 | 804502 | 2020-12-07 | Bourbon | Kansas | 20011 | 663 | 3 |
801257 | 801257 | 2020-12-06 | Bourbon | Kansas | 20011 | 641 | 3 |
798012 | 798012 | 2020-12-05 | Bourbon | Kansas | 20011 | 641 | 3 |
794767 | 794767 | 2020-12-04 | Bourbon | Kansas | 20011 | 641 | 3 |
791522 | 791522 | 2020-12-03 | Bourbon | Kansas | 20011 | 609 | 3 |
788277 | 788277 | 2020-12-02 | Bourbon | Kansas | 20011 | 609 | 3 |
785033 | 785033 | 2020-12-01 | Bourbon | Kansas | 20011 | 564 | 3 |
781788 | 781788 | 2020-11-30 | Bourbon | Kansas | 20011 | 564 | 3 |
778542 | 778542 | 2020-11-29 | Bourbon | Kansas | 20011 | 543 | 3 |
775297 | 775297 | 2020-11-28 | Bourbon | Kansas | 20011 | 543 | 3 |
772052 | 772052 | 2020-11-27 | Bourbon | Kansas | 20011 | 543 | 3 |
768807 | 768807 | 2020-11-26 | Bourbon | Kansas | 20011 | 520 | 3 |
765561 | 765561 | 2020-11-25 | Bourbon | Kansas | 20011 | 520 | 3 |
762316 | 762316 | 2020-11-24 | Bourbon | Kansas | 20011 | 495 | 3 |
759071 | 759071 | 2020-11-23 | Bourbon | Kansas | 20011 | 495 | 3 |
755824 | 755824 | 2020-11-22 | Bourbon | Kansas | 20011 | 463 | 3 |
752578 | 752578 | 2020-11-21 | Bourbon | Kansas | 20011 | 463 | 3 |
749332 | 749332 | 2020-11-20 | Bourbon | Kansas | 20011 | 463 | 3 |
746086 | 746086 | 2020-11-19 | Bourbon | Kansas | 20011 | 438 | 3 |
742839 | 742839 | 2020-11-18 | Bourbon | Kansas | 20011 | 438 | 3 |
739592 | 739592 | 2020-11-17 | Bourbon | Kansas | 20011 | 395 | 3 |
736348 | 736348 | 2020-11-16 | Bourbon | Kansas | 20011 | 395 | 3 |
733102 | 733102 | 2020-11-15 | Bourbon | Kansas | 20011 | 382 | 3 |
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);