ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Franklin" and fips = 20059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194033 | 1194033 | 2021-04-06 | Franklin | Kansas | 20059 | 2500 | 40 |
1190783 | 1190783 | 2021-04-05 | Franklin | Kansas | 20059 | 2500 | 40 |
1187536 | 1187536 | 2021-04-04 | Franklin | Kansas | 20059 | 2495 | 40 |
1184289 | 1184289 | 2021-04-03 | Franklin | Kansas | 20059 | 2495 | 40 |
1181042 | 1181042 | 2021-04-02 | Franklin | Kansas | 20059 | 2495 | 40 |
1177795 | 1177795 | 2021-04-01 | Franklin | Kansas | 20059 | 2495 | 40 |
1174548 | 1174548 | 2021-03-31 | Franklin | Kansas | 20059 | 2495 | 40 |
1171301 | 1171301 | 2021-03-30 | Franklin | Kansas | 20059 | 2490 | 40 |
1168053 | 1168053 | 2021-03-29 | Franklin | Kansas | 20059 | 2490 | 40 |
1164805 | 1164805 | 2021-03-28 | Franklin | Kansas | 20059 | 2489 | 39 |
1161557 | 1161557 | 2021-03-27 | Franklin | Kansas | 20059 | 2489 | 39 |
1158309 | 1158309 | 2021-03-26 | Franklin | Kansas | 20059 | 2489 | 39 |
1155062 | 1155062 | 2021-03-25 | Franklin | Kansas | 20059 | 2488 | 39 |
1151815 | 1151815 | 2021-03-24 | Franklin | Kansas | 20059 | 2488 | 39 |
1148568 | 1148568 | 2021-03-23 | Franklin | Kansas | 20059 | 2485 | 39 |
1145321 | 1145321 | 2021-03-22 | Franklin | Kansas | 20059 | 2485 | 39 |
1142074 | 1142074 | 2021-03-21 | Franklin | Kansas | 20059 | 2483 | 39 |
1138828 | 1138828 | 2021-03-20 | Franklin | Kansas | 20059 | 2483 | 39 |
1135582 | 1135582 | 2021-03-19 | Franklin | Kansas | 20059 | 2483 | 39 |
1132335 | 1132335 | 2021-03-18 | Franklin | Kansas | 20059 | 2483 | 39 |
1129087 | 1129087 | 2021-03-17 | Franklin | Kansas | 20059 | 2483 | 39 |
1125841 | 1125841 | 2021-03-16 | Franklin | Kansas | 20059 | 2482 | 39 |
1122595 | 1122595 | 2021-03-15 | Franklin | Kansas | 20059 | 2482 | 39 |
1119348 | 1119348 | 2021-03-14 | Franklin | Kansas | 20059 | 2472 | 39 |
1116101 | 1116101 | 2021-03-13 | Franklin | Kansas | 20059 | 2472 | 39 |
1112855 | 1112855 | 2021-03-12 | Franklin | Kansas | 20059 | 2472 | 39 |
1109609 | 1109609 | 2021-03-11 | Franklin | Kansas | 20059 | 2470 | 39 |
1106363 | 1106363 | 2021-03-10 | Franklin | Kansas | 20059 | 2470 | 39 |
1103117 | 1103117 | 2021-03-09 | Franklin | Kansas | 20059 | 2460 | 39 |
1099871 | 1099871 | 2021-03-08 | Franklin | Kansas | 20059 | 2460 | 39 |
1096623 | 1096623 | 2021-03-07 | Franklin | Kansas | 20059 | 2456 | 39 |
1093377 | 1093377 | 2021-03-06 | Franklin | Kansas | 20059 | 2456 | 39 |
1090131 | 1090131 | 2021-03-05 | Franklin | Kansas | 20059 | 2456 | 39 |
1086886 | 1086886 | 2021-03-04 | Franklin | Kansas | 20059 | 2446 | 39 |
1083640 | 1083640 | 2021-03-03 | Franklin | Kansas | 20059 | 2446 | 39 |
1080394 | 1080394 | 2021-03-02 | Franklin | Kansas | 20059 | 2438 | 37 |
1077149 | 1077149 | 2021-03-01 | Franklin | Kansas | 20059 | 2438 | 37 |
1073903 | 1073903 | 2021-02-28 | Franklin | Kansas | 20059 | 2432 | 37 |
1070657 | 1070657 | 2021-02-27 | Franklin | Kansas | 20059 | 2432 | 37 |
1067412 | 1067412 | 2021-02-26 | Franklin | Kansas | 20059 | 2432 | 37 |
1064167 | 1064167 | 2021-02-25 | Franklin | Kansas | 20059 | 2428 | 37 |
1060922 | 1060922 | 2021-02-24 | Franklin | Kansas | 20059 | 2428 | 37 |
1057676 | 1057676 | 2021-02-23 | Franklin | Kansas | 20059 | 2423 | 36 |
1054430 | 1054430 | 2021-02-22 | Franklin | Kansas | 20059 | 2423 | 36 |
1051183 | 1051183 | 2021-02-21 | Franklin | Kansas | 20059 | 2415 | 20 |
1047936 | 1047936 | 2021-02-20 | Franklin | Kansas | 20059 | 2415 | 20 |
1044691 | 1044691 | 2021-02-19 | Franklin | Kansas | 20059 | 2415 | 20 |
1041446 | 1041446 | 2021-02-18 | Franklin | Kansas | 20059 | 2409 | 20 |
1038201 | 1038201 | 2021-02-17 | Franklin | Kansas | 20059 | 2409 | 20 |
1034956 | 1034956 | 2021-02-16 | Franklin | Kansas | 20059 | 2396 | 19 |
1031710 | 1031710 | 2021-02-15 | Franklin | Kansas | 20059 | 2396 | 19 |
1028463 | 1028463 | 2021-02-14 | Franklin | Kansas | 20059 | 2378 | 19 |
1025218 | 1025218 | 2021-02-13 | Franklin | Kansas | 20059 | 2378 | 19 |
1021973 | 1021973 | 2021-02-12 | Franklin | Kansas | 20059 | 2378 | 19 |
1018728 | 1018728 | 2021-02-11 | Franklin | Kansas | 20059 | 2369 | 19 |
1015483 | 1015483 | 2021-02-10 | Franklin | Kansas | 20059 | 2369 | 19 |
1012238 | 1012238 | 2021-02-09 | Franklin | Kansas | 20059 | 2347 | 19 |
1008992 | 1008992 | 2021-02-08 | Franklin | Kansas | 20059 | 2347 | 19 |
1005746 | 1005746 | 2021-02-07 | Franklin | Kansas | 20059 | 2340 | 19 |
1002500 | 1002500 | 2021-02-06 | Franklin | Kansas | 20059 | 2340 | 19 |
999254 | 999254 | 2021-02-05 | Franklin | Kansas | 20059 | 2340 | 19 |
996008 | 996008 | 2021-02-04 | Franklin | Kansas | 20059 | 2319 | 19 |
992762 | 992762 | 2021-02-03 | Franklin | Kansas | 20059 | 2319 | 19 |
989516 | 989516 | 2021-02-02 | Franklin | Kansas | 20059 | 2296 | 19 |
986269 | 986269 | 2021-02-01 | Franklin | Kansas | 20059 | 2296 | 19 |
983022 | 983022 | 2021-01-31 | Franklin | Kansas | 20059 | 2264 | 19 |
979776 | 979776 | 2021-01-30 | Franklin | Kansas | 20059 | 2264 | 19 |
976530 | 976530 | 2021-01-29 | Franklin | Kansas | 20059 | 2264 | 19 |
973285 | 973285 | 2021-01-28 | Franklin | Kansas | 20059 | 2244 | 19 |
970040 | 970040 | 2021-01-27 | Franklin | Kansas | 20059 | 2244 | 19 |
966796 | 966796 | 2021-01-26 | Franklin | Kansas | 20059 | 2204 | 19 |
963551 | 963551 | 2021-01-25 | Franklin | Kansas | 20059 | 2204 | 19 |
960306 | 960306 | 2021-01-24 | Franklin | Kansas | 20059 | 2188 | 19 |
957060 | 957060 | 2021-01-23 | Franklin | Kansas | 20059 | 2188 | 19 |
953815 | 953815 | 2021-01-22 | Franklin | Kansas | 20059 | 2188 | 19 |
950570 | 950570 | 2021-01-21 | Franklin | Kansas | 20059 | 2162 | 19 |
947324 | 947324 | 2021-01-20 | Franklin | Kansas | 20059 | 2162 | 19 |
944077 | 944077 | 2021-01-19 | Franklin | Kansas | 20059 | 2102 | 19 |
940832 | 940832 | 2021-01-18 | Franklin | Kansas | 20059 | 2102 | 19 |
937587 | 937587 | 2021-01-17 | Franklin | Kansas | 20059 | 2072 | 19 |
934342 | 934342 | 2021-01-16 | Franklin | Kansas | 20059 | 2072 | 19 |
931097 | 931097 | 2021-01-15 | Franklin | Kansas | 20059 | 2072 | 19 |
927852 | 927852 | 2021-01-14 | Franklin | Kansas | 20059 | 2059 | 19 |
924606 | 924606 | 2021-01-13 | Franklin | Kansas | 20059 | 2059 | 19 |
921361 | 921361 | 2021-01-12 | Franklin | Kansas | 20059 | 2038 | 19 |
918116 | 918116 | 2021-01-11 | Franklin | Kansas | 20059 | 2038 | 19 |
914871 | 914871 | 2021-01-10 | Franklin | Kansas | 20059 | 2001 | 19 |
911626 | 911626 | 2021-01-09 | Franklin | Kansas | 20059 | 2001 | 19 |
908381 | 908381 | 2021-01-08 | Franklin | Kansas | 20059 | 2001 | 19 |
905135 | 905135 | 2021-01-07 | Franklin | Kansas | 20059 | 1942 | 18 |
901890 | 901890 | 2021-01-06 | Franklin | Kansas | 20059 | 1942 | 18 |
898645 | 898645 | 2021-01-05 | Franklin | Kansas | 20059 | 1883 | 18 |
895400 | 895400 | 2021-01-04 | Franklin | Kansas | 20059 | 1883 | 18 |
892153 | 892153 | 2021-01-03 | Franklin | Kansas | 20059 | 1835 | 18 |
888907 | 888907 | 2021-01-02 | Franklin | Kansas | 20059 | 1835 | 18 |
885661 | 885661 | 2021-01-01 | Franklin | Kansas | 20059 | 1835 | 18 |
882416 | 882416 | 2020-12-31 | Franklin | Kansas | 20059 | 1757 | 18 |
879171 | 879171 | 2020-12-30 | Franklin | Kansas | 20059 | 1757 | 18 |
875926 | 875926 | 2020-12-29 | Franklin | Kansas | 20059 | 1703 | 18 |
872681 | 872681 | 2020-12-28 | Franklin | Kansas | 20059 | 1703 | 18 |
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);