ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Lee" and fips = 37105 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195065 | 1195065 | 2021-04-06 | Lee | North Carolina | 37105 | 5726 | 75 |
1191817 | 1191817 | 2021-04-05 | Lee | North Carolina | 37105 | 5726 | 75 |
1188568 | 1188568 | 2021-04-04 | Lee | North Carolina | 37105 | 5693 | 74 |
1185321 | 1185321 | 2021-04-03 | Lee | North Carolina | 37105 | 5693 | 74 |
1182074 | 1182074 | 2021-04-02 | Lee | North Carolina | 37105 | 5693 | 74 |
1178827 | 1178827 | 2021-04-01 | Lee | North Carolina | 37105 | 5693 | 74 |
1175580 | 1175580 | 2021-03-31 | Lee | North Carolina | 37105 | 5687 | 74 |
1172333 | 1172333 | 2021-03-30 | Lee | North Carolina | 37105 | 5673 | 73 |
1169086 | 1169086 | 2021-03-29 | Lee | North Carolina | 37105 | 5664 | 73 |
1165838 | 1165838 | 2021-03-28 | Lee | North Carolina | 37105 | 5629 | 73 |
1162590 | 1162590 | 2021-03-27 | Lee | North Carolina | 37105 | 5629 | 73 |
1159341 | 1159341 | 2021-03-26 | Lee | North Carolina | 37105 | 5629 | 73 |
1156094 | 1156094 | 2021-03-25 | Lee | North Carolina | 37105 | 5621 | 73 |
1152847 | 1152847 | 2021-03-24 | Lee | North Carolina | 37105 | 5611 | 73 |
1149600 | 1149600 | 2021-03-23 | Lee | North Carolina | 37105 | 5602 | 73 |
1146353 | 1146353 | 2021-03-22 | Lee | North Carolina | 37105 | 5597 | 73 |
1143106 | 1143106 | 2021-03-21 | Lee | North Carolina | 37105 | 5592 | 73 |
1139859 | 1139859 | 2021-03-20 | Lee | North Carolina | 37105 | 5592 | 73 |
1136613 | 1136613 | 2021-03-19 | Lee | North Carolina | 37105 | 5580 | 73 |
1133367 | 1133367 | 2021-03-18 | Lee | North Carolina | 37105 | 5570 | 73 |
1130119 | 1130119 | 2021-03-17 | Lee | North Carolina | 37105 | 5564 | 73 |
1126872 | 1126872 | 2021-03-16 | Lee | North Carolina | 37105 | 5554 | 73 |
1123626 | 1123626 | 2021-03-15 | Lee | North Carolina | 37105 | 5552 | 73 |
1120380 | 1120380 | 2021-03-14 | Lee | North Carolina | 37105 | 5541 | 73 |
1117133 | 1117133 | 2021-03-13 | Lee | North Carolina | 37105 | 5541 | 73 |
1113886 | 1113886 | 2021-03-12 | Lee | North Carolina | 37105 | 5534 | 73 |
1110640 | 1110640 | 2021-03-11 | Lee | North Carolina | 37105 | 5530 | 73 |
1107394 | 1107394 | 2021-03-10 | Lee | North Carolina | 37105 | 5516 | 73 |
1104148 | 1104148 | 2021-03-09 | Lee | North Carolina | 37105 | 5512 | 73 |
1100902 | 1100902 | 2021-03-08 | Lee | North Carolina | 37105 | 5512 | 73 |
1097656 | 1097656 | 2021-03-07 | Lee | North Carolina | 37105 | 5506 | 72 |
1094408 | 1094408 | 2021-03-06 | Lee | North Carolina | 37105 | 5506 | 72 |
1091162 | 1091162 | 2021-03-05 | Lee | North Carolina | 37105 | 5497 | 72 |
1087917 | 1087917 | 2021-03-04 | Lee | North Carolina | 37105 | 5489 | 72 |
1084672 | 1084672 | 2021-03-03 | Lee | North Carolina | 37105 | 5480 | 72 |
1081426 | 1081426 | 2021-03-02 | Lee | North Carolina | 37105 | 5478 | 72 |
1078180 | 1078180 | 2021-03-01 | Lee | North Carolina | 37105 | 5477 | 72 |
1074935 | 1074935 | 2021-02-28 | Lee | North Carolina | 37105 | 5456 | 66 |
1071689 | 1071689 | 2021-02-27 | Lee | North Carolina | 37105 | 5456 | 66 |
1068443 | 1068443 | 2021-02-26 | Lee | North Carolina | 37105 | 5444 | 66 |
1065198 | 1065198 | 2021-02-25 | Lee | North Carolina | 37105 | 5429 | 66 |
1061954 | 1061954 | 2021-02-24 | Lee | North Carolina | 37105 | 5408 | 66 |
1058708 | 1058708 | 2021-02-23 | Lee | North Carolina | 37105 | 5357 | 66 |
1055462 | 1055462 | 2021-02-22 | Lee | North Carolina | 37105 | 5350 | 66 |
1052216 | 1052216 | 2021-02-21 | Lee | North Carolina | 37105 | 5337 | 66 |
1048969 | 1048969 | 2021-02-20 | Lee | North Carolina | 37105 | 5324 | 66 |
1045722 | 1045722 | 2021-02-19 | Lee | North Carolina | 37105 | 5305 | 65 |
1042477 | 1042477 | 2021-02-18 | Lee | North Carolina | 37105 | 5291 | 65 |
1039232 | 1039232 | 2021-02-17 | Lee | North Carolina | 37105 | 5276 | 65 |
1035987 | 1035987 | 2021-02-16 | Lee | North Carolina | 37105 | 5259 | 65 |
1032742 | 1032742 | 2021-02-15 | Lee | North Carolina | 37105 | 5228 | 65 |
1029496 | 1029496 | 2021-02-14 | Lee | North Carolina | 37105 | 5222 | 65 |
1026249 | 1026249 | 2021-02-13 | Lee | North Carolina | 37105 | 5179 | 65 |
1023004 | 1023004 | 2021-02-12 | Lee | North Carolina | 37105 | 5144 | 65 |
1019759 | 1019759 | 2021-02-11 | Lee | North Carolina | 37105 | 5128 | 65 |
1016514 | 1016514 | 2021-02-10 | Lee | North Carolina | 37105 | 5105 | 65 |
1013269 | 1013269 | 2021-02-09 | Lee | North Carolina | 37105 | 5091 | 65 |
1010024 | 1010024 | 2021-02-08 | Lee | North Carolina | 37105 | 5075 | 65 |
1006778 | 1006778 | 2021-02-07 | Lee | North Carolina | 37105 | 5069 | 65 |
1003532 | 1003532 | 2021-02-06 | Lee | North Carolina | 37105 | 5034 | 65 |
1000286 | 1000286 | 2021-02-05 | Lee | North Carolina | 37105 | 5009 | 65 |
997040 | 997040 | 2021-02-04 | Lee | North Carolina | 37105 | 4989 | 58 |
993794 | 993794 | 2021-02-03 | Lee | North Carolina | 37105 | 4954 | 58 |
990548 | 990548 | 2021-02-02 | Lee | North Carolina | 37105 | 4869 | 57 |
987302 | 987302 | 2021-02-01 | Lee | North Carolina | 37105 | 4859 | 56 |
984055 | 984055 | 2021-01-31 | Lee | North Carolina | 37105 | 4838 | 56 |
980808 | 980808 | 2021-01-30 | Lee | North Carolina | 37105 | 4789 | 56 |
977562 | 977562 | 2021-01-29 | Lee | North Carolina | 37105 | 4789 | 56 |
974317 | 974317 | 2021-01-28 | Lee | North Carolina | 37105 | 4765 | 56 |
971072 | 971072 | 2021-01-27 | Lee | North Carolina | 37105 | 4712 | 56 |
967827 | 967827 | 2021-01-26 | Lee | North Carolina | 37105 | 4679 | 55 |
964583 | 964583 | 2021-01-25 | Lee | North Carolina | 37105 | 4644 | 52 |
961338 | 961338 | 2021-01-24 | Lee | North Carolina | 37105 | 4620 | 52 |
958093 | 958093 | 2021-01-23 | Lee | North Carolina | 37105 | 4593 | 47 |
954847 | 954847 | 2021-01-22 | Lee | North Carolina | 37105 | 4538 | 46 |
951602 | 951602 | 2021-01-21 | Lee | North Carolina | 37105 | 4483 | 46 |
948357 | 948357 | 2021-01-20 | Lee | North Carolina | 37105 | 4448 | 46 |
945110 | 945110 | 2021-01-19 | Lee | North Carolina | 37105 | 4408 | 46 |
941864 | 941864 | 2021-01-18 | Lee | North Carolina | 37105 | 4361 | 46 |
938619 | 938619 | 2021-01-17 | Lee | North Carolina | 37105 | 4361 | 46 |
935374 | 935374 | 2021-01-16 | Lee | North Carolina | 37105 | 4309 | 46 |
932129 | 932129 | 2021-01-15 | Lee | North Carolina | 37105 | 4254 | 46 |
928884 | 928884 | 2021-01-14 | Lee | North Carolina | 37105 | 4201 | 45 |
925639 | 925639 | 2021-01-13 | Lee | North Carolina | 37105 | 4130 | 45 |
922393 | 922393 | 2021-01-12 | Lee | North Carolina | 37105 | 4122 | 44 |
919148 | 919148 | 2021-01-11 | Lee | North Carolina | 37105 | 4085 | 44 |
915903 | 915903 | 2021-01-10 | Lee | North Carolina | 37105 | 4059 | 44 |
912658 | 912658 | 2021-01-09 | Lee | North Carolina | 37105 | 3986 | 44 |
909413 | 909413 | 2021-01-08 | Lee | North Carolina | 37105 | 3919 | 44 |
906168 | 906168 | 2021-01-07 | Lee | North Carolina | 37105 | 3845 | 44 |
902922 | 902922 | 2021-01-06 | Lee | North Carolina | 37105 | 3780 | 44 |
899677 | 899677 | 2021-01-05 | Lee | North Carolina | 37105 | 3723 | 44 |
896432 | 896432 | 2021-01-04 | Lee | North Carolina | 37105 | 3679 | 44 |
893186 | 893186 | 2021-01-03 | Lee | North Carolina | 37105 | 3654 | 44 |
889940 | 889940 | 2021-01-02 | Lee | North Carolina | 37105 | 3617 | 44 |
886693 | 886693 | 2021-01-01 | Lee | North Carolina | 37105 | 3510 | 41 |
883448 | 883448 | 2020-12-31 | Lee | North Carolina | 37105 | 3510 | 41 |
880203 | 880203 | 2020-12-30 | Lee | North Carolina | 37105 | 3475 | 39 |
876958 | 876958 | 2020-12-29 | Lee | North Carolina | 37105 | 3414 | 39 |
873713 | 873713 | 2020-12-28 | Lee | North Carolina | 37105 | 3392 | 39 |
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);