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 = 39049 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195193 | 1195193 | 2021-04-06 | Franklin | Ohio | 39049 | 119303 | 1339 |
1191945 | 1191945 | 2021-04-05 | Franklin | Ohio | 39049 | 119040 | 1328 |
1188696 | 1188696 | 2021-04-04 | Franklin | Ohio | 39049 | 118657 | 1328 |
1185449 | 1185449 | 2021-04-03 | Franklin | Ohio | 39049 | 118657 | 1328 |
1182202 | 1182202 | 2021-04-02 | Franklin | Ohio | 39049 | 118366 | 1328 |
1178955 | 1178955 | 2021-04-01 | Franklin | Ohio | 39049 | 118171 | 1322 |
1175708 | 1175708 | 2021-03-31 | Franklin | Ohio | 39049 | 117832 | 1322 |
1172461 | 1172461 | 2021-03-30 | Franklin | Ohio | 39049 | 117583 | 1322 |
1169214 | 1169214 | 2021-03-29 | Franklin | Ohio | 39049 | 117227 | 1316 |
1165966 | 1165966 | 2021-03-28 | Franklin | Ohio | 39049 | 117050 | 1316 |
1162718 | 1162718 | 2021-03-27 | Franklin | Ohio | 39049 | 116888 | 1316 |
1159469 | 1159469 | 2021-03-26 | Franklin | Ohio | 39049 | 116726 | 1316 |
1156222 | 1156222 | 2021-03-25 | Franklin | Ohio | 39049 | 116365 | 1305 |
1152975 | 1152975 | 2021-03-24 | Franklin | Ohio | 39049 | 116117 | 1305 |
1149728 | 1149728 | 2021-03-23 | Franklin | Ohio | 39049 | 115937 | 1305 |
1146481 | 1146481 | 2021-03-22 | Franklin | Ohio | 39049 | 115731 | 1300 |
1143234 | 1143234 | 2021-03-21 | Franklin | Ohio | 39049 | 115553 | 1300 |
1139987 | 1139987 | 2021-03-20 | Franklin | Ohio | 39049 | 115433 | 1300 |
1136741 | 1136741 | 2021-03-19 | Franklin | Ohio | 39049 | 115261 | 1300 |
1133495 | 1133495 | 2021-03-18 | Franklin | Ohio | 39049 | 115083 | 1282 |
1130247 | 1130247 | 2021-03-17 | Franklin | Ohio | 39049 | 114839 | 1282 |
1127000 | 1127000 | 2021-03-16 | Franklin | Ohio | 39049 | 114675 | 1282 |
1123754 | 1123754 | 2021-03-15 | Franklin | Ohio | 39049 | 114458 | 1276 |
1120508 | 1120508 | 2021-03-14 | Franklin | Ohio | 39049 | 114335 | 1276 |
1117261 | 1117261 | 2021-03-13 | Franklin | Ohio | 39049 | 114206 | 1276 |
1114014 | 1114014 | 2021-03-12 | Franklin | Ohio | 39049 | 113992 | 1276 |
1110768 | 1110768 | 2021-03-11 | Franklin | Ohio | 39049 | 113797 | 1259 |
1107522 | 1107522 | 2021-03-10 | Franklin | Ohio | 39049 | 113640 | 1259 |
1104276 | 1104276 | 2021-03-09 | Franklin | Ohio | 39049 | 113458 | 1259 |
1101030 | 1101030 | 2021-03-08 | Franklin | Ohio | 39049 | 113218 | 1251 |
1097784 | 1097784 | 2021-03-07 | Franklin | Ohio | 39049 | 113037 | 1251 |
1094536 | 1094536 | 2021-03-06 | Franklin | Ohio | 39049 | 112955 | 1251 |
1091290 | 1091290 | 2021-03-05 | Franklin | Ohio | 39049 | 112797 | 1251 |
1088045 | 1088045 | 2021-03-04 | Franklin | Ohio | 39049 | 112585 | 1214 |
1084800 | 1084800 | 2021-03-03 | Franklin | Ohio | 39049 | 112367 | 1214 |
1081554 | 1081554 | 2021-03-02 | Franklin | Ohio | 39049 | 112182 | 1214 |
1078308 | 1078308 | 2021-03-01 | Franklin | Ohio | 39049 | 111987 | 1212 |
1075063 | 1075063 | 2021-02-28 | Franklin | Ohio | 39049 | 111851 | 1208 |
1071817 | 1071817 | 2021-02-27 | Franklin | Ohio | 39049 | 111688 | 1202 |
1068571 | 1068571 | 2021-02-26 | Franklin | Ohio | 39049 | 111496 | 1198 |
1065326 | 1065326 | 2021-02-25 | Franklin | Ohio | 39049 | 111312 | 1196 |
1062082 | 1062082 | 2021-02-24 | Franklin | Ohio | 39049 | 111107 | 1193 |
1058836 | 1058836 | 2021-02-23 | Franklin | Ohio | 39049 | 110938 | 1191 |
1055590 | 1055590 | 2021-02-22 | Franklin | Ohio | 39049 | 110653 | 1186 |
1052344 | 1052344 | 2021-02-21 | Franklin | Ohio | 39049 | 110499 | 1181 |
1049097 | 1049097 | 2021-02-20 | Franklin | Ohio | 39049 | 110335 | 1178 |
1045850 | 1045850 | 2021-02-19 | Franklin | Ohio | 39049 | 110079 | 1176 |
1042605 | 1042605 | 2021-02-18 | Franklin | Ohio | 39049 | 109830 | 1175 |
1039360 | 1039360 | 2021-02-17 | Franklin | Ohio | 39049 | 109605 | 1172 |
1036115 | 1036115 | 2021-02-16 | Franklin | Ohio | 39049 | 109415 | 1169 |
1032870 | 1032870 | 2021-02-15 | Franklin | Ohio | 39049 | 109190 | 1168 |
1029624 | 1029624 | 2021-02-14 | Franklin | Ohio | 39049 | 108993 | 1163 |
1026377 | 1026377 | 2021-02-13 | Franklin | Ohio | 39049 | 108800 | 1163 |
1023132 | 1023132 | 2021-02-12 | Franklin | Ohio | 39049 | 108550 | 1060 |
1019887 | 1019887 | 2021-02-11 | Franklin | Ohio | 39049 | 108226 | 783 |
1016642 | 1016642 | 2021-02-10 | Franklin | Ohio | 39049 | 107954 | 714 |
1013397 | 1013397 | 2021-02-09 | Franklin | Ohio | 39049 | 107627 | 714 |
1010152 | 1010152 | 2021-02-08 | Franklin | Ohio | 39049 | 107282 | 713 |
1006906 | 1006906 | 2021-02-07 | Franklin | Ohio | 39049 | 107107 | 713 |
1003660 | 1003660 | 2021-02-06 | Franklin | Ohio | 39049 | 106893 | 713 |
1000414 | 1000414 | 2021-02-05 | Franklin | Ohio | 39049 | 106526 | 712 |
997168 | 997168 | 2021-02-04 | Franklin | Ohio | 39049 | 106211 | 712 |
993922 | 993922 | 2021-02-03 | Franklin | Ohio | 39049 | 105796 | 712 |
990676 | 990676 | 2021-02-02 | Franklin | Ohio | 39049 | 105457 | 710 |
987430 | 987430 | 2021-02-01 | Franklin | Ohio | 39049 | 105102 | 709 |
984183 | 984183 | 2021-01-31 | Franklin | Ohio | 39049 | 104761 | 709 |
980936 | 980936 | 2021-01-30 | Franklin | Ohio | 39049 | 104449 | 709 |
977690 | 977690 | 2021-01-29 | Franklin | Ohio | 39049 | 104034 | 709 |
974445 | 974445 | 2021-01-28 | Franklin | Ohio | 39049 | 103578 | 709 |
971200 | 971200 | 2021-01-27 | Franklin | Ohio | 39049 | 103088 | 708 |
967955 | 967955 | 2021-01-26 | Franklin | Ohio | 39049 | 102616 | 707 |
964711 | 964711 | 2021-01-25 | Franklin | Ohio | 39049 | 102154 | 707 |
961466 | 961466 | 2021-01-24 | Franklin | Ohio | 39049 | 101705 | 707 |
958221 | 958221 | 2021-01-23 | Franklin | Ohio | 39049 | 101171 | 707 |
954975 | 954975 | 2021-01-22 | Franklin | Ohio | 39049 | 100550 | 707 |
951730 | 951730 | 2021-01-21 | Franklin | Ohio | 39049 | 100046 | 706 |
948485 | 948485 | 2021-01-20 | Franklin | Ohio | 39049 | 99253 | 706 |
945239 | 945239 | 2021-01-19 | Franklin | Ohio | 39049 | 98533 | 705 |
941992 | 941992 | 2021-01-18 | Franklin | Ohio | 39049 | 97996 | 705 |
938747 | 938747 | 2021-01-17 | Franklin | Ohio | 39049 | 97493 | 705 |
935502 | 935502 | 2021-01-16 | Franklin | Ohio | 39049 | 96935 | 704 |
932257 | 932257 | 2021-01-15 | Franklin | Ohio | 39049 | 96280 | 704 |
929012 | 929012 | 2021-01-14 | Franklin | Ohio | 39049 | 95508 | 704 |
925767 | 925767 | 2021-01-13 | Franklin | Ohio | 39049 | 94591 | 702 |
922521 | 922521 | 2021-01-12 | Franklin | Ohio | 39049 | 93903 | 702 |
919276 | 919276 | 2021-01-11 | Franklin | Ohio | 39049 | 93057 | 701 |
916031 | 916031 | 2021-01-10 | Franklin | Ohio | 39049 | 92060 | 700 |
912786 | 912786 | 2021-01-09 | Franklin | Ohio | 39049 | 91391 | 700 |
909541 | 909541 | 2021-01-08 | Franklin | Ohio | 39049 | 90416 | 700 |
906296 | 906296 | 2021-01-07 | Franklin | Ohio | 39049 | 89439 | 700 |
903050 | 903050 | 2021-01-06 | Franklin | Ohio | 39049 | 88447 | 700 |
899805 | 899805 | 2021-01-05 | Franklin | Ohio | 39049 | 87784 | 700 |
896560 | 896560 | 2021-01-04 | Franklin | Ohio | 39049 | 87106 | 698 |
893314 | 893314 | 2021-01-03 | Franklin | Ohio | 39049 | 86446 | 698 |
890068 | 890068 | 2021-01-02 | Franklin | Ohio | 39049 | 85553 | 698 |
886821 | 886821 | 2021-01-01 | Franklin | Ohio | 39049 | 84050 | 698 |
883576 | 883576 | 2020-12-31 | Franklin | Ohio | 39049 | 84050 | 698 |
880331 | 880331 | 2020-12-30 | Franklin | Ohio | 39049 | 83105 | 698 |
877086 | 877086 | 2020-12-29 | Franklin | Ohio | 39049 | 82402 | 697 |
873841 | 873841 | 2020-12-28 | Franklin | Ohio | 39049 | 81515 | 697 |
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);