ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Franklin" and fips = 37069 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195047 | 1195047 | 2021-04-06 | Franklin | North Carolina | 37069 | 6076 | 47 |
1191799 | 1191799 | 2021-04-05 | Franklin | North Carolina | 37069 | 6070 | 47 |
1188550 | 1188550 | 2021-04-04 | Franklin | North Carolina | 37069 | 6017 | 47 |
1185303 | 1185303 | 2021-04-03 | Franklin | North Carolina | 37069 | 6017 | 47 |
1182056 | 1182056 | 2021-04-02 | Franklin | North Carolina | 37069 | 6017 | 47 |
1178809 | 1178809 | 2021-04-01 | Franklin | North Carolina | 37069 | 6017 | 47 |
1175562 | 1175562 | 2021-03-31 | Franklin | North Carolina | 37069 | 5998 | 47 |
1172315 | 1172315 | 2021-03-30 | Franklin | North Carolina | 37069 | 5976 | 47 |
1169068 | 1169068 | 2021-03-29 | Franklin | North Carolina | 37069 | 5975 | 47 |
1165820 | 1165820 | 2021-03-28 | Franklin | North Carolina | 37069 | 5917 | 47 |
1162572 | 1162572 | 2021-03-27 | Franklin | North Carolina | 37069 | 5917 | 47 |
1159323 | 1159323 | 2021-03-26 | Franklin | North Carolina | 37069 | 5917 | 47 |
1156076 | 1156076 | 2021-03-25 | Franklin | North Carolina | 37069 | 5893 | 46 |
1152829 | 1152829 | 2021-03-24 | Franklin | North Carolina | 37069 | 5877 | 46 |
1149582 | 1149582 | 2021-03-23 | Franklin | North Carolina | 37069 | 5852 | 46 |
1146335 | 1146335 | 2021-03-22 | Franklin | North Carolina | 37069 | 5844 | 46 |
1143088 | 1143088 | 2021-03-21 | Franklin | North Carolina | 37069 | 5796 | 46 |
1139841 | 1139841 | 2021-03-20 | Franklin | North Carolina | 37069 | 5796 | 46 |
1136595 | 1136595 | 2021-03-19 | Franklin | North Carolina | 37069 | 5783 | 46 |
1133349 | 1133349 | 2021-03-18 | Franklin | North Carolina | 37069 | 5759 | 46 |
1130101 | 1130101 | 2021-03-17 | Franklin | North Carolina | 37069 | 5739 | 46 |
1126854 | 1126854 | 2021-03-16 | Franklin | North Carolina | 37069 | 5701 | 45 |
1123608 | 1123608 | 2021-03-15 | Franklin | North Carolina | 37069 | 5691 | 45 |
1120362 | 1120362 | 2021-03-14 | Franklin | North Carolina | 37069 | 5642 | 45 |
1117115 | 1117115 | 2021-03-13 | Franklin | North Carolina | 37069 | 5642 | 45 |
1113868 | 1113868 | 2021-03-12 | Franklin | North Carolina | 37069 | 5643 | 45 |
1110622 | 1110622 | 2021-03-11 | Franklin | North Carolina | 37069 | 5616 | 45 |
1107376 | 1107376 | 2021-03-10 | Franklin | North Carolina | 37069 | 5589 | 45 |
1104130 | 1104130 | 2021-03-09 | Franklin | North Carolina | 37069 | 5560 | 45 |
1100884 | 1100884 | 2021-03-08 | Franklin | North Carolina | 37069 | 5552 | 45 |
1097638 | 1097638 | 2021-03-07 | Franklin | North Carolina | 37069 | 5521 | 45 |
1094390 | 1094390 | 2021-03-06 | Franklin | North Carolina | 37069 | 5521 | 45 |
1091144 | 1091144 | 2021-03-05 | Franklin | North Carolina | 37069 | 5495 | 45 |
1087899 | 1087899 | 2021-03-04 | Franklin | North Carolina | 37069 | 5471 | 45 |
1084654 | 1084654 | 2021-03-03 | Franklin | North Carolina | 37069 | 5442 | 45 |
1081408 | 1081408 | 2021-03-02 | Franklin | North Carolina | 37069 | 5415 | 45 |
1078162 | 1078162 | 2021-03-01 | Franklin | North Carolina | 37069 | 5411 | 43 |
1074917 | 1074917 | 2021-02-28 | Franklin | North Carolina | 37069 | 5387 | 43 |
1071671 | 1071671 | 2021-02-27 | Franklin | North Carolina | 37069 | 5387 | 43 |
1068425 | 1068425 | 2021-02-26 | Franklin | North Carolina | 37069 | 5357 | 43 |
1065180 | 1065180 | 2021-02-25 | Franklin | North Carolina | 37069 | 5241 | 43 |
1061936 | 1061936 | 2021-02-24 | Franklin | North Carolina | 37069 | 5217 | 43 |
1058690 | 1058690 | 2021-02-23 | Franklin | North Carolina | 37069 | 5195 | 43 |
1055444 | 1055444 | 2021-02-22 | Franklin | North Carolina | 37069 | 5187 | 43 |
1052198 | 1052198 | 2021-02-21 | Franklin | North Carolina | 37069 | 5172 | 43 |
1048951 | 1048951 | 2021-02-20 | Franklin | North Carolina | 37069 | 5143 | 43 |
1045704 | 1045704 | 2021-02-19 | Franklin | North Carolina | 37069 | 5130 | 42 |
1042459 | 1042459 | 2021-02-18 | Franklin | North Carolina | 37069 | 5117 | 42 |
1039214 | 1039214 | 2021-02-17 | Franklin | North Carolina | 37069 | 5086 | 42 |
1035969 | 1035969 | 2021-02-16 | Franklin | North Carolina | 37069 | 5055 | 42 |
1032724 | 1032724 | 2021-02-15 | Franklin | North Carolina | 37069 | 5049 | 42 |
1029478 | 1029478 | 2021-02-14 | Franklin | North Carolina | 37069 | 5041 | 42 |
1026231 | 1026231 | 2021-02-13 | Franklin | North Carolina | 37069 | 5022 | 42 |
1022986 | 1022986 | 2021-02-12 | Franklin | North Carolina | 37069 | 4996 | 42 |
1019741 | 1019741 | 2021-02-11 | Franklin | North Carolina | 37069 | 4964 | 42 |
1016496 | 1016496 | 2021-02-10 | Franklin | North Carolina | 37069 | 4922 | 42 |
1013251 | 1013251 | 2021-02-09 | Franklin | North Carolina | 37069 | 4885 | 41 |
1010006 | 1010006 | 2021-02-08 | Franklin | North Carolina | 37069 | 4877 | 41 |
1006760 | 1006760 | 2021-02-07 | Franklin | North Carolina | 37069 | 4863 | 41 |
1003514 | 1003514 | 2021-02-06 | Franklin | North Carolina | 37069 | 4833 | 41 |
1000268 | 1000268 | 2021-02-05 | Franklin | North Carolina | 37069 | 4810 | 41 |
997022 | 997022 | 2021-02-04 | Franklin | North Carolina | 37069 | 4771 | 41 |
993776 | 993776 | 2021-02-03 | Franklin | North Carolina | 37069 | 4737 | 41 |
990530 | 990530 | 2021-02-02 | Franklin | North Carolina | 37069 | 4665 | 41 |
987284 | 987284 | 2021-02-01 | Franklin | North Carolina | 37069 | 4652 | 41 |
984037 | 984037 | 2021-01-31 | Franklin | North Carolina | 37069 | 4627 | 41 |
980790 | 980790 | 2021-01-30 | Franklin | North Carolina | 37069 | 4561 | 40 |
977544 | 977544 | 2021-01-29 | Franklin | North Carolina | 37069 | 4561 | 40 |
974299 | 974299 | 2021-01-28 | Franklin | North Carolina | 37069 | 4523 | 40 |
971054 | 971054 | 2021-01-27 | Franklin | North Carolina | 37069 | 4486 | 40 |
967809 | 967809 | 2021-01-26 | Franklin | North Carolina | 37069 | 4443 | 40 |
964565 | 964565 | 2021-01-25 | Franklin | North Carolina | 37069 | 4434 | 40 |
961320 | 961320 | 2021-01-24 | Franklin | North Carolina | 37069 | 4397 | 40 |
958075 | 958075 | 2021-01-23 | Franklin | North Carolina | 37069 | 4359 | 40 |
954829 | 954829 | 2021-01-22 | Franklin | North Carolina | 37069 | 4308 | 40 |
951584 | 951584 | 2021-01-21 | Franklin | North Carolina | 37069 | 4245 | 39 |
948339 | 948339 | 2021-01-20 | Franklin | North Carolina | 37069 | 4165 | 39 |
945092 | 945092 | 2021-01-19 | Franklin | North Carolina | 37069 | 4111 | 39 |
941846 | 941846 | 2021-01-18 | Franklin | North Carolina | 37069 | 4059 | 39 |
938601 | 938601 | 2021-01-17 | Franklin | North Carolina | 37069 | 4059 | 39 |
935356 | 935356 | 2021-01-16 | Franklin | North Carolina | 37069 | 4009 | 39 |
932111 | 932111 | 2021-01-15 | Franklin | North Carolina | 37069 | 3985 | 39 |
928866 | 928866 | 2021-01-14 | Franklin | North Carolina | 37069 | 3913 | 39 |
925621 | 925621 | 2021-01-13 | Franklin | North Carolina | 37069 | 3858 | 39 |
922375 | 922375 | 2021-01-12 | Franklin | North Carolina | 37069 | 3827 | 39 |
919130 | 919130 | 2021-01-11 | Franklin | North Carolina | 37069 | 3743 | 39 |
915885 | 915885 | 2021-01-10 | Franklin | North Carolina | 37069 | 3691 | 39 |
912640 | 912640 | 2021-01-09 | Franklin | North Carolina | 37069 | 3668 | 39 |
909395 | 909395 | 2021-01-08 | Franklin | North Carolina | 37069 | 3558 | 39 |
906150 | 906150 | 2021-01-07 | Franklin | North Carolina | 37069 | 3522 | 39 |
902904 | 902904 | 2021-01-06 | Franklin | North Carolina | 37069 | 3436 | 39 |
899659 | 899659 | 2021-01-05 | Franklin | North Carolina | 37069 | 3365 | 39 |
896414 | 896414 | 2021-01-04 | Franklin | North Carolina | 37069 | 3342 | 37 |
893168 | 893168 | 2021-01-03 | Franklin | North Carolina | 37069 | 3292 | 37 |
889922 | 889922 | 2021-01-02 | Franklin | North Carolina | 37069 | 3251 | 37 |
886675 | 886675 | 2021-01-01 | Franklin | North Carolina | 37069 | 3186 | 37 |
883430 | 883430 | 2020-12-31 | Franklin | North Carolina | 37069 | 3186 | 37 |
880185 | 880185 | 2020-12-30 | Franklin | North Carolina | 37069 | 3072 | 37 |
876940 | 876940 | 2020-12-29 | Franklin | North Carolina | 37069 | 3014 | 37 |
873695 | 873695 | 2020-12-28 | Franklin | North Carolina | 37069 | 2982 | 37 |
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);