ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
124 rows where deaths = 70 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Clarendon 12
- Georgetown 10
- Bamberg 9
- Edgefield 8
- Marlboro 8
- Newberry 8
- Abbeville 7
- Fairfield 6
- Chester 5
- Lancaster 5
- Lee 5
- Chesterfield 4
- Richland 4
- Hampton 3
- Kershaw 3
- Sumter 3
- Berkeley 2
- Cherokee 2
- Darlington 2
- Greenville 2
- Lexington 2
- Orangeburg 2
- Pickens 2
- Williamsburg 2
- York 2
- Anderson 1
- Dillon 1
- Greenwood 1
- Marion 1
- Oconee 1
- …
state 1
- South Carolina · 124 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492243 | 2492243 | 2022-05-10 | Edgefield | South Carolina | 45037 | 6779 | 70 |
2488985 | 2488985 | 2022-05-09 | Edgefield | South Carolina | 45037 | 6779 | 70 |
2485728 | 2485728 | 2022-05-08 | Edgefield | South Carolina | 45037 | 6779 | 70 |
2482470 | 2482470 | 2022-05-07 | Edgefield | South Carolina | 45037 | 6779 | 70 |
2479212 | 2479212 | 2022-05-06 | Edgefield | South Carolina | 45037 | 6779 | 70 |
2475954 | 2475954 | 2022-05-05 | Edgefield | South Carolina | 45037 | 6779 | 70 |
2472697 | 2472697 | 2022-05-04 | Edgefield | South Carolina | 45037 | 6779 | 70 |
2469441 | 2469441 | 2022-05-03 | Edgefield | South Carolina | 45037 | 6779 | 70 |
2375008 | 2375008 | 2022-04-04 | Abbeville | South Carolina | 45001 | 6629 | 70 |
2371756 | 2371756 | 2022-04-03 | Abbeville | South Carolina | 45001 | 6629 | 70 |
2368503 | 2368503 | 2022-04-02 | Abbeville | South Carolina | 45001 | 6629 | 70 |
2365250 | 2365250 | 2022-04-01 | Abbeville | South Carolina | 45001 | 6629 | 70 |
2361997 | 2361997 | 2022-03-31 | Abbeville | South Carolina | 45001 | 6629 | 70 |
2358743 | 2358743 | 2022-03-30 | Abbeville | South Carolina | 45001 | 6629 | 70 |
2355489 | 2355489 | 2022-03-29 | Abbeville | South Carolina | 45001 | 6629 | 70 |
2218904 | 2218904 | 2022-02-15 | Bamberg | South Carolina | 45009 | 3369 | 70 |
2215653 | 2215653 | 2022-02-14 | Bamberg | South Carolina | 45009 | 3366 | 70 |
2212402 | 2212402 | 2022-02-13 | Bamberg | South Carolina | 45009 | 3346 | 70 |
2209149 | 2209149 | 2022-02-12 | Bamberg | South Carolina | 45009 | 3346 | 70 |
2205896 | 2205896 | 2022-02-11 | Bamberg | South Carolina | 45009 | 3346 | 70 |
2202643 | 2202643 | 2022-02-10 | Bamberg | South Carolina | 45009 | 3346 | 70 |
2199389 | 2199389 | 2022-02-09 | Bamberg | South Carolina | 45009 | 3339 | 70 |
2196135 | 2196135 | 2022-02-08 | Bamberg | South Carolina | 45009 | 3337 | 70 |
2192881 | 2192881 | 2022-02-07 | Bamberg | South Carolina | 45009 | 3336 | 70 |
1786571 | 1786571 | 2021-10-05 | Lee | South Carolina | 45061 | 2459 | 70 |
1783322 | 1783322 | 2021-10-04 | Lee | South Carolina | 45061 | 2453 | 70 |
1780073 | 1780073 | 2021-10-03 | Lee | South Carolina | 45061 | 2431 | 70 |
1776823 | 1776823 | 2021-10-02 | Lee | South Carolina | 45061 | 2431 | 70 |
1773573 | 1773573 | 2021-10-01 | Lee | South Carolina | 45061 | 2431 | 70 |
1767068 | 1767068 | 2021-09-29 | Hampton | South Carolina | 45049 | 2997 | 70 |
1763819 | 1763819 | 2021-09-28 | Hampton | South Carolina | 45049 | 2994 | 70 |
1760570 | 1760570 | 2021-09-27 | Hampton | South Carolina | 45049 | 2988 | 70 |
1747586 | 1747586 | 2021-09-23 | Marlboro | South Carolina | 45069 | 4534 | 70 |
1744336 | 1744336 | 2021-09-22 | Marlboro | South Carolina | 45069 | 4515 | 70 |
1741087 | 1741087 | 2021-09-21 | Marlboro | South Carolina | 45069 | 4504 | 70 |
1737838 | 1737838 | 2021-09-20 | Marlboro | South Carolina | 45069 | 4493 | 70 |
1734588 | 1734588 | 2021-09-19 | Marlboro | South Carolina | 45069 | 4430 | 70 |
1731338 | 1731338 | 2021-09-18 | Marlboro | South Carolina | 45069 | 4430 | 70 |
1728088 | 1728088 | 2021-09-17 | Marlboro | South Carolina | 45069 | 4430 | 70 |
1724839 | 1724839 | 2021-09-16 | Marlboro | South Carolina | 45069 | 4417 | 70 |
1176050 | 1176050 | 2021-03-31 | Chester | South Carolina | 45023 | 3963 | 70 |
1172803 | 1172803 | 2021-03-30 | Chester | South Carolina | 45023 | 3959 | 70 |
1169556 | 1169556 | 2021-03-29 | Chester | South Carolina | 45023 | 3958 | 70 |
1166308 | 1166308 | 2021-03-28 | Chester | South Carolina | 45023 | 3950 | 70 |
1163060 | 1163060 | 2021-03-27 | Chester | South Carolina | 45023 | 3941 | 70 |
1062430 | 1062430 | 2021-02-24 | Fairfield | South Carolina | 45039 | 2082 | 70 |
1059185 | 1059185 | 2021-02-23 | Fairfield | South Carolina | 45039 | 2071 | 70 |
1055939 | 1055939 | 2021-02-22 | Fairfield | South Carolina | 45039 | 2065 | 70 |
1052693 | 1052693 | 2021-02-21 | Fairfield | South Carolina | 45039 | 2058 | 70 |
1049446 | 1049446 | 2021-02-20 | Fairfield | South Carolina | 45039 | 2050 | 70 |
1046199 | 1046199 | 2021-02-19 | Fairfield | South Carolina | 45039 | 2038 | 70 |
1036488 | 1036488 | 2021-02-16 | Union | South Carolina | 45087 | 2461 | 70 |
987776 | 987776 | 2021-02-01 | Dillon | South Carolina | 45033 | 3543 | 70 |
945581 | 945581 | 2021-01-19 | Chesterfield | South Carolina | 45025 | 2968 | 70 |
945613 | 945613 | 2021-01-19 | Williamsburg | South Carolina | 45089 | 2943 | 70 |
942334 | 942334 | 2021-01-18 | Chesterfield | South Carolina | 45025 | 2951 | 70 |
942366 | 942366 | 2021-01-18 | Williamsburg | South Carolina | 45089 | 2927 | 70 |
939089 | 939089 | 2021-01-17 | Chesterfield | South Carolina | 45025 | 2933 | 70 |
935844 | 935844 | 2021-01-16 | Chesterfield | South Carolina | 45025 | 2890 | 70 |
906658 | 906658 | 2021-01-07 | Marion | South Carolina | 45067 | 2182 | 70 |
906662 | 906662 | 2021-01-07 | Oconee | South Carolina | 45073 | 5729 | 70 |
864471 | 864471 | 2020-12-25 | Newberry | South Carolina | 45071 | 2682 | 70 |
861226 | 861226 | 2020-12-24 | Newberry | South Carolina | 45071 | 2682 | 70 |
857981 | 857981 | 2020-12-23 | Newberry | South Carolina | 45071 | 2655 | 70 |
854736 | 854736 | 2020-12-22 | Newberry | South Carolina | 45071 | 2631 | 70 |
851491 | 851491 | 2020-12-21 | Newberry | South Carolina | 45071 | 2619 | 70 |
848246 | 848246 | 2020-12-20 | Newberry | South Carolina | 45071 | 2585 | 70 |
845001 | 845001 | 2020-12-19 | Newberry | South Carolina | 45071 | 2567 | 70 |
841741 | 841741 | 2020-12-18 | Georgetown | South Carolina | 45043 | 3392 | 70 |
841755 | 841755 | 2020-12-18 | Newberry | South Carolina | 45071 | 2537 | 70 |
838496 | 838496 | 2020-12-17 | Georgetown | South Carolina | 45043 | 3273 | 70 |
835250 | 835250 | 2020-12-16 | Georgetown | South Carolina | 45043 | 3210 | 70 |
832004 | 832004 | 2020-12-15 | Georgetown | South Carolina | 45043 | 3174 | 70 |
828757 | 828757 | 2020-12-14 | Georgetown | South Carolina | 45043 | 3158 | 70 |
825511 | 825511 | 2020-12-13 | Georgetown | South Carolina | 45043 | 3142 | 70 |
822264 | 822264 | 2020-12-12 | Georgetown | South Carolina | 45043 | 3102 | 70 |
819018 | 819018 | 2020-12-11 | Georgetown | South Carolina | 45043 | 3063 | 70 |
819024 | 819024 | 2020-12-11 | Kershaw | South Carolina | 45055 | 3228 | 70 |
815761 | 815761 | 2020-12-10 | Cherokee | South Carolina | 45021 | 2404 | 70 |
815764 | 815764 | 2020-12-10 | Clarendon | South Carolina | 45027 | 1477 | 70 |
815772 | 815772 | 2020-12-10 | Georgetown | South Carolina | 45043 | 2987 | 70 |
815778 | 815778 | 2020-12-10 | Kershaw | South Carolina | 45055 | 3202 | 70 |
815779 | 815779 | 2020-12-10 | Lancaster | South Carolina | 45057 | 3906 | 70 |
812515 | 812515 | 2020-12-09 | Cherokee | South Carolina | 45021 | 2390 | 70 |
812518 | 812518 | 2020-12-09 | Clarendon | South Carolina | 45027 | 1470 | 70 |
812526 | 812526 | 2020-12-09 | Georgetown | South Carolina | 45043 | 2970 | 70 |
812532 | 812532 | 2020-12-09 | Kershaw | South Carolina | 45055 | 3186 | 70 |
812533 | 812533 | 2020-12-09 | Lancaster | South Carolina | 45057 | 3874 | 70 |
809274 | 809274 | 2020-12-08 | Clarendon | South Carolina | 45027 | 1457 | 70 |
809289 | 809289 | 2020-12-08 | Lancaster | South Carolina | 45057 | 3825 | 70 |
806029 | 806029 | 2020-12-07 | Clarendon | South Carolina | 45027 | 1442 | 70 |
806044 | 806044 | 2020-12-07 | Lancaster | South Carolina | 45057 | 3763 | 70 |
802784 | 802784 | 2020-12-06 | Clarendon | South Carolina | 45027 | 1440 | 70 |
802799 | 802799 | 2020-12-06 | Lancaster | South Carolina | 45057 | 3721 | 70 |
799539 | 799539 | 2020-12-05 | Clarendon | South Carolina | 45027 | 1421 | 70 |
796294 | 796294 | 2020-12-04 | Clarendon | South Carolina | 45027 | 1408 | 70 |
793049 | 793049 | 2020-12-03 | Clarendon | South Carolina | 45027 | 1404 | 70 |
789804 | 789804 | 2020-12-02 | Clarendon | South Carolina | 45027 | 1400 | 70 |
786559 | 786559 | 2020-12-01 | Clarendon | South Carolina | 45027 | 1391 | 70 |
783315 | 783315 | 2020-11-30 | Clarendon | South Carolina | 45027 | 1390 | 70 |
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);