johns_hopkins_csse_daily_reports

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

6,553 rows where province_or_state = "South Carolina" sorted by day descending

View and edit SQL

Suggested facets: day (date), last_update (date)

province_or_state

  • South Carolina · 6,553

country_or_region

  • US 6,553
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
391082 2020-08-08 US South Carolina Abbeville 45001 325 8 0 317 34.22333378 -82.46170658 2020-08-09 04:34:54 Abbeville, South Carolina, US
391108 2020-08-08 US South Carolina Aiken 45003 1843 37 0 1806 33.54338026 -81.63645384 2020-08-09 04:34:54 Aiken, South Carolina, US
391138 2020-08-08 US South Carolina Allendale 45005 216 3 0 213 32.98837386 -81.35321066 2020-08-09 04:34:54 Allendale, South Carolina, US
391149 2020-08-08 US South Carolina Anderson 45007 2321 62 0 2259 34.51828081 -82.63959517 2020-08-09 04:34:54 Anderson, South Carolina, US
391214 2020-08-08 US South Carolina Bamberg 45009 468 22 0 446 33.21927586 -81.05659969 2020-08-09 04:34:54 Bamberg, South Carolina, US
391226 2020-08-08 US South Carolina Barnwell 45011 409 5 0 404 33.26679302 -81.43584352 2020-08-09 04:34:54 Barnwell, South Carolina, US
391251 2020-08-08 US South Carolina Beaufort 45013 4046 55 0 3991 32.39226291 -80.72619758 2020-08-09 04:34:54 Beaufort, South Carolina, US
391284 2020-08-08 US South Carolina Berkeley 45015 4133 66 0 4067 33.20222596 -79.94654523 2020-08-09 04:34:54 Berkeley, South Carolina, US
391446 2020-08-08 US South Carolina Calhoun 45017 374 10 0 364 33.66926881 -80.77722168 2020-08-09 04:34:54 Calhoun, South Carolina, US
391547 2020-08-08 US South Carolina Charleston 45019 12213 194 0 12019 32.82487866 -79.96512315 2020-08-09 04:34:54 Charleston, South Carolina, US
391573 2020-08-08 US South Carolina Cherokee 45021 630 28 0 602 35.05122251 -81.61828622 2020-08-09 04:34:54 Cherokee, South Carolina, US
391579 2020-08-08 US South Carolina Chester 45023 654 14 0 640 34.69249168 -81.1583216 2020-08-09 04:34:54 Chester, South Carolina, US
391581 2020-08-08 US South Carolina Chesterfield 45025 758 21 0 737 34.64137396 -80.15640140000002 2020-08-09 04:34:54 Chesterfield, South Carolina, US
391616 2020-08-08 US South Carolina Clarendon 45027 836 51 0 785 33.66610974 -80.21647898 2020-08-09 04:34:54 Clarendon, South Carolina, US
391697 2020-08-08 US South Carolina Colleton 45029 807 34 0 773 32.87582989 -80.67641292 2020-08-09 04:34:54 Colleton, South Carolina, US
391819 2020-08-08 US South Carolina Darlington 45031 1261 35 0 1226 34.33358335 -79.96027485 2020-08-09 04:34:54 Darlington, South Carolina, US
391886 2020-08-08 US South Carolina Dillon 45033 634 24 0 610 34.39007791 -79.37741872 2020-08-09 04:34:54 Dillon, South Carolina, US
391906 2020-08-08 US South Carolina Dorchester 45035 3070 47 0 3023 33.0794369 -80.40502652 2020-08-09 04:34:54 Dorchester, South Carolina, US
391949 2020-08-08 US South Carolina Edgefield 45037 318 7 0 311 33.77221995 -81.96231108 2020-08-09 04:34:54 Edgefield, South Carolina, US
392000 2020-08-08 US South Carolina Fairfield 45039 564 23 0 541 34.39287073 -81.1195624 2020-08-09 04:34:54 Fairfield, South Carolina, US
392034 2020-08-08 US South Carolina Florence 45041 3371 112 0 3259 34.02361754 -79.70189312 2020-08-09 04:34:54 Florence, South Carolina, US
392134 2020-08-08 US South Carolina Georgetown 45043 1446 20 0 1426 33.43443342 -79.33202141 2020-08-09 04:34:54 Georgetown, South Carolina, US
392226 2020-08-08 US South Carolina Greenville 45045 10819 206 0 10613 34.89502264 -82.37295012 2020-08-09 04:34:54 Greenville, South Carolina, US
392228 2020-08-08 US South Carolina Greenwood 45047 1375 18 0 1357 34.15272415 -82.12715789 2020-08-09 04:34:54 Greenwood, South Carolina, US
392277 2020-08-08 US South Carolina Hampton 45049 421 9 0 412 32.77419582 -81.13845571 2020-08-09 04:34:54 Hampton, South Carolina, US
392398 2020-08-08 US South Carolina Horry 45051 8555 151 0 8404 33.9212828 -78.99555293 2020-08-09 04:34:54 Horry, South Carolina, US
392499 2020-08-08 US South Carolina Jasper 45053 578 15 0 563 32.43171982 -81.02487495 2020-08-09 04:34:54 Jasper, South Carolina, US
392601 2020-08-08 US South Carolina Kershaw 45055 1390 24 0 1366 34.33988254 -80.58763164 2020-08-09 04:34:54 Kershaw, South Carolina, US
392687 2020-08-08 US South Carolina Lancaster 45057 1181 23 0 1158 34.68270843 -80.70513032 2020-08-09 04:34:54 Lancaster, South Carolina, US
392710 2020-08-08 US South Carolina Laurens 45059 1311 44 0 1267 34.48244419 -82.00490796 2020-08-09 04:34:54 Laurens, South Carolina, US
392738 2020-08-08 US South Carolina Lee 45061 561 27 0 534 34.16393091 -80.25690731 2020-08-09 04:34:54 Lee, South Carolina, US
392759 2020-08-08 US South Carolina Lexington 45063 4923 110 0 4813 33.89665987 -81.27146426 2020-08-09 04:34:54 Lexington, South Carolina, US
392913 2020-08-08 US South Carolina Marion 45067 549 13 0 536 34.07859748 -79.36400756 2020-08-09 04:34:54 Marion, South Carolina, US
392918 2020-08-08 US South Carolina Marlboro 45069 489 4 0 485 34.59905577 -79.67561152 2020-08-09 04:34:54 Marlboro, South Carolina, US
392959 2020-08-08 US South Carolina McCormick 45065 116 2 0 114 33.90161443 -82.30794338 2020-08-09 04:34:54 McCormick, South Carolina, US
393180 2020-08-08 US South Carolina Newberry 45071 841 9 0 832 34.28629098 -81.59935761 2020-08-09 04:34:54 Newberry, South Carolina, US
393227 2020-08-08 US South Carolina Oconee 45073 815 9 0 806 34.75225169 -83.06742317 2020-08-09 04:34:54 Oconee, South Carolina, US
393262 2020-08-08 US South Carolina Orangeburg 45075 2383 64 0 2319 33.4391073 -80.79886287 2020-08-09 04:34:54 Orangeburg, South Carolina, US
393379 2020-08-08 US South Carolina Pickens 45077 1841 27 0 1814 34.88807695 -82.72791551 2020-08-09 04:34:54 Pickens, South Carolina, US
393542 2020-08-08 US South Carolina Richland 45079 8707 151 0 8556 34.01791263 -80.90267209 2020-08-09 04:34:54 Richland, South Carolina, US
393623 2020-08-08 US South Carolina Saluda 45081 452 8 0 444 34.00795823 -81.72713237 2020-08-09 04:34:54 Saluda, South Carolina, US
393771 2020-08-08 US South Carolina Spartanburg 45083 4057 101 0 3956 34.92960077 -81.99225984 2020-08-09 04:34:54 Spartanburg, South Carolina, US
393863 2020-08-08 US South Carolina Sumter 45085 2515 50 0 2465 33.91826534 -80.37942316 2020-08-09 04:34:54 Sumter, South Carolina, US
394021 2020-08-08 US South Carolina Unassigned 90045 0 0 0 0 35.05122251 -83.06742317 2020-08-09 04:34:54 Unassigned, South Carolina, US
394047 2020-08-08 US South Carolina Union 45087 360 4 0 356 34.68835752 -81.61730349 2020-08-09 04:34:54 Union, South Carolina, US
394245 2020-08-08 US South Carolina Williamsburg 45089 993 31 0 962 33.62190129 -79.72767442 2020-08-09 04:34:54 Williamsburg, South Carolina, US
394317 2020-08-08 US South Carolina York 45091 3531 29 0 3502 34.97281497 -81.18085944 2020-08-09 04:34:54 York, South Carolina, US
281646 2020-08-07 US South Carolina Abbeville 45001 321 8 0 313 34.22333378 -82.46170658 2020-08-08 04:34:53 Abbeville, South Carolina, US
281672 2020-08-07 US South Carolina Aiken 45003 1810 34 0 1776 33.54338026 -81.63645384 2020-08-08 04:34:53 Aiken, South Carolina, US
281702 2020-08-07 US South Carolina Allendale 45005 213 3 0 210 32.98837386 -81.35321066 2020-08-08 04:34:53 Allendale, South Carolina, US
281713 2020-08-07 US South Carolina Anderson 45007 2271 59 0 2212 34.51828081 -82.63959517 2020-08-08 04:34:53 Anderson, South Carolina, US
281778 2020-08-07 US South Carolina Bamberg 45009 463 20 0 443 33.21927586 -81.05659969 2020-08-08 04:34:53 Bamberg, South Carolina, US
281790 2020-08-07 US South Carolina Barnwell 45011 402 5 0 397 33.26679302 -81.43584352 2020-08-08 04:34:53 Barnwell, South Carolina, US
281815 2020-08-07 US South Carolina Beaufort 45013 3999 55 0 3944 32.39226291 -80.72619758 2020-08-08 04:34:53 Beaufort, South Carolina, US
281848 2020-08-07 US South Carolina Berkeley 45015 4079 66 0 4013 33.20222596 -79.94654523 2020-08-08 04:34:53 Berkeley, South Carolina, US
282010 2020-08-07 US South Carolina Calhoun 45017 367 10 0 357 33.66926881 -80.77722168 2020-08-08 04:34:53 Calhoun, South Carolina, US
282111 2020-08-07 US South Carolina Charleston 45019 12118 189 0 11929 32.82487866 -79.96512315 2020-08-08 04:34:53 Charleston, South Carolina, US
282137 2020-08-07 US South Carolina Cherokee 45021 624 28 0 596 35.05122251 -81.61828622 2020-08-08 04:34:53 Cherokee, South Carolina, US
282143 2020-08-07 US South Carolina Chester 45023 633 13 0 620 34.69249168 -81.1583216 2020-08-08 04:34:53 Chester, South Carolina, US
282145 2020-08-07 US South Carolina Chesterfield 45025 743 21 0 722 34.64137396 -80.15640140000002 2020-08-08 04:34:53 Chesterfield, South Carolina, US
282180 2020-08-07 US South Carolina Clarendon 45027 826 51 0 775 33.66610974 -80.21647898 2020-08-08 04:34:53 Clarendon, South Carolina, US
282261 2020-08-07 US South Carolina Colleton 45029 798 34 0 764 32.87582989 -80.67641292 2020-08-08 04:34:53 Colleton, South Carolina, US
282383 2020-08-07 US South Carolina Darlington 45031 1234 35 0 1199 34.33358335 -79.96027485 2020-08-08 04:34:53 Darlington, South Carolina, US
282450 2020-08-07 US South Carolina Dillon 45033 619 24 0 595 34.39007791 -79.37741872 2020-08-08 04:34:53 Dillon, South Carolina, US
282470 2020-08-07 US South Carolina Dorchester 45035 3021 47 0 2974 33.0794369 -80.40502652 2020-08-08 04:34:53 Dorchester, South Carolina, US
282513 2020-08-07 US South Carolina Edgefield 45037 314 6 0 308 33.77221995 -81.96231108 2020-08-08 04:34:53 Edgefield, South Carolina, US
282564 2020-08-07 US South Carolina Fairfield 45039 557 23 0 534 34.39287073 -81.1195624 2020-08-08 04:34:53 Fairfield, South Carolina, US
282598 2020-08-07 US South Carolina Florence 45041 3329 108 0 3221 34.02361754 -79.70189312 2020-08-08 04:34:53 Florence, South Carolina, US
282698 2020-08-07 US South Carolina Georgetown 45043 1419 19 0 1400 33.43443342 -79.33202141 2020-08-08 04:34:53 Georgetown, South Carolina, US
282790 2020-08-07 US South Carolina Greenville 45045 10745 204 0 10541 34.89502264 -82.37295012 2020-08-08 04:34:53 Greenville, South Carolina, US
282792 2020-08-07 US South Carolina Greenwood 45047 1355 18 0 1337 34.15272415 -82.12715789 2020-08-08 04:34:53 Greenwood, South Carolina, US
282841 2020-08-07 US South Carolina Hampton 45049 412 7 0 405 32.77419582 -81.13845571 2020-08-08 04:34:53 Hampton, South Carolina, US
282962 2020-08-07 US South Carolina Horry 45051 8486 146 0 8340 33.9212828 -78.99555293 2020-08-08 04:34:53 Horry, South Carolina, US
283063 2020-08-07 US South Carolina Jasper 45053 571 15 0 556 32.43171982 -81.02487495 2020-08-08 04:34:53 Jasper, South Carolina, US
283165 2020-08-07 US South Carolina Kershaw 45055 1365 23 0 1342 34.33988254 -80.58763164 2020-08-08 04:34:53 Kershaw, South Carolina, US
283251 2020-08-07 US South Carolina Lancaster 45057 1161 23 0 1138 34.68270843 -80.70513032 2020-08-08 04:34:53 Lancaster, South Carolina, US
283274 2020-08-07 US South Carolina Laurens 45059 1292 43 0 1249 34.48244419 -82.00490796 2020-08-08 04:34:53 Laurens, South Carolina, US
283302 2020-08-07 US South Carolina Lee 45061 556 27 0 529 34.16393091 -80.25690731 2020-08-08 04:34:53 Lee, South Carolina, US
283323 2020-08-07 US South Carolina Lexington 45063 4877 108 0 4769 33.89665987 -81.27146426 2020-08-08 04:34:53 Lexington, South Carolina, US
283477 2020-08-07 US South Carolina Marion 45067 542 13 0 529 34.07859748 -79.36400756 2020-08-08 04:34:53 Marion, South Carolina, US
283482 2020-08-07 US South Carolina Marlboro 45069 473 4 0 469 34.59905577 -79.67561152 2020-08-08 04:34:53 Marlboro, South Carolina, US
283523 2020-08-07 US South Carolina McCormick 45065 113 2 0 111 33.90161443 -82.30794338 2020-08-08 04:34:53 McCormick, South Carolina, US
283744 2020-08-07 US South Carolina Newberry 45071 830 9 0 821 34.28629098 -81.59935761 2020-08-08 04:34:53 Newberry, South Carolina, US
283791 2020-08-07 US South Carolina Oconee 45073 802 9 0 793 34.75225169 -83.06742317 2020-08-08 04:34:53 Oconee, South Carolina, US
283826 2020-08-07 US South Carolina Orangeburg 45075 2353 61 0 2292 33.4391073 -80.79886287 2020-08-08 04:34:53 Orangeburg, South Carolina, US
283943 2020-08-07 US South Carolina Pickens 45077 1818 27 0 1791 34.88807695 -82.72791551 2020-08-08 04:34:53 Pickens, South Carolina, US
284106 2020-08-07 US South Carolina Richland 45079 8579 148 0 8431 34.01791263 -80.90267209 2020-08-08 04:34:53 Richland, South Carolina, US
284187 2020-08-07 US South Carolina Saluda 45081 449 8 0 441 34.00795823 -81.72713237 2020-08-08 04:34:53 Saluda, South Carolina, US
284335 2020-08-07 US South Carolina Spartanburg 45083 4005 99 0 3906 34.92960077 -81.99225984 2020-08-08 04:34:53 Spartanburg, South Carolina, US
284427 2020-08-07 US South Carolina Sumter 45085 2463 47 0 2416 33.91826534 -80.37942316 2020-08-08 04:34:53 Sumter, South Carolina, US
284585 2020-08-07 US South Carolina Unassigned 90045 0 0 0 0 35.05122251 -83.06742317 2020-08-08 04:34:53 Unassigned, South Carolina, US
284611 2020-08-07 US South Carolina Union 45087 355 4 0 351 34.68835752 -81.61730349 2020-08-08 04:34:53 Union, South Carolina, US
284809 2020-08-07 US South Carolina Williamsburg 45089 983 30 0 953 33.62190129 -79.72767442 2020-08-08 04:34:53 Williamsburg, South Carolina, US
284881 2020-08-07 US South Carolina York 45091 3474 29 0 3445 34.97281497 -81.18085944 2020-08-08 04:34:53 York, South Carolina, US
332061 2020-08-06 US South Carolina Abbeville 45001 313 8 0 305 34.22333378 -82.46170658 2020-08-07 04:35:11 Abbeville, South Carolina, US
332087 2020-08-06 US South Carolina Aiken 45003 1788 33 0 1755 33.54338026 -81.63645384 2020-08-07 04:35:11 Aiken, South Carolina, US
332117 2020-08-06 US South Carolina Allendale 45005 204 3 0 201 32.98837386 -81.35321066 2020-08-07 04:35:11 Allendale, South Carolina, US
332128 2020-08-06 US South Carolina Anderson 45007 2237 55 0 2182 34.51828081 -82.63959517 2020-08-07 04:35:11 Anderson, South Carolina, US
332193 2020-08-06 US South Carolina Bamberg 45009 455 20 0 435 33.21927586 -81.05659969 2020-08-07 04:35:11 Bamberg, South Carolina, US
332205 2020-08-06 US South Carolina Barnwell 45011 390 5 0 385 33.26679302 -81.43584352 2020-08-07 04:35:11 Barnwell, South Carolina, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
                ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
                ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
                ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
                ON [johns_hopkins_csse_daily_reports] ([combined_key]);
Powered by Datasette · Query took 1566.929ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette