Useful website - extract-table.com - ようこそ　KengBlog.com

The Internet is full of information, and there are many cases where useful information is displayed as tables and graphs, but the problem is that they are not searchable as images. “Extract-Table” can automatically generate a table from an image of a table, which is useful when you want to convert such an image table into text data format. It makes full use of Amazon’s machine learning service, Amazon Textract.

How to

You can simply click the choose file then submit it.

Otherwise use CURL. It points out its api-endpoint “https://api.extract-table.com” for you to easily curl and download the data. I have tried by upload Capture.PNG, a table-image file and outputted to 1.txt file.

curl -s https://api.extract-table.com -H "Content-Type: image/png" --data-binary @Capture.PNG > 1.txt

It seems the data structure is a nested array.

[
  [
    "Country, # Other 11",
    "Total Cases 17",
    "New Cases It",
    "Total Deaths 11",
    "New Deaths",
    "Total Recovered 11",
    "New Recovered 11",
    "Active Cases 11",
    "Serious, Critical 11",
    "Tot Cases/ 1M pop 11",
    "Deaths/ 1M pop 11",
    "Total Tests 11",
    "Tests/ 1M pop 11",
    "Population 11"
  ],
  [
    "World",
    "233,649,003",
    "+124,126",
    "4,781,114",
    "+2,941",
    "210,467,822",
    "+128,452",
    "18,400,067",
    "91,427",
    "29,975",
    "613.4",
    "",
    "",
    ""
  ],
  [
    "1 USA",
    "44,054,825",
    "",
    "711,222",
    "",
    "33,520,958",
    "",
    "9,822,645",
    "21,296",
    "132,134",
    "2,133",
    "638,049,739",
    "1,913,705",
    "333,410,743"
  ],
  [
    "2 India",
    "33,716,451",
    "+1,402",
    "447,781",
    "",
    "32,986,180",
    "+7,623",
    "282,490",
    "8,944",
    "24,138",
    "321",
    "567,450,185",
    "406,242",
    "1,396,827,844"
  ],
  [
    "3 Brazil",
    "21,381,790",
    "",
    "595,520",
    "",
    "20,383,243",
    "",
    "403,027",
    "8,318",
    "99,713",
    "2,777",
    "57,282,520",
    "267,134",
    "214,433,687"
  ],
  [
    "4 UK",
    "7,736,235",
    "",
    "136,375",
    "",
    "6,255,350",
    "",
    "1,344,510",
    "831",
    "113,221",
    "1,996",
    "301,307,653",
    "4,409,694",
    "68,328,470"
  ],
  [
    "5 Russia",
    "7,487,138",
    "+22,430",
    "206,388",
    "+857",
    "6,653,941",
    "+18,456",
    "626,809",
    "2,300",
    "51,278",
    "1,413",
    "191,000,000",
    "1,308,110",
    "146,012,147"
  ],
  [
    "6 Turkey",
    "7,095,580",
    "",
    "63,611",
    "",
    "6,552,771",
    "",
    "479,198",
    "633",
    "83,024",
    "744",
    "85,596,459",
    "1,001,547",
    "85,464,220"
  ],
  [
    "7 France",
    "7,002,393",
    "",
    "116,615",
    "",
    "6,750,241",
    "",
    "135,537",
    "1,609",
    "106,984",
    "1,782",
    "139,307,228",
    "2,128,362",
    "65,452,786"
  ],
  [
    "8 Iran",
    "5,559,691",
    "",
    "119,888",
    "",
    "4,988,109",
    "",
    "451,694",
    "6,124",
    "65,159",
    "1,405",
    "31,868,828",
    "373,498",
    "85,325,399"
  ],
  [
    "9 Argentina",
    "5,253,765",
    "",
    "115,038",
    "",
    "5,115,084",
    "",
    "23,643",
    "1,184",
    "114,937",
    "2,517",
    "24,252,818",
    "530,579",
    "45,710,072"
  ],
  [
    "10 Colombia",
    "4,954,376",
    "",
    "126,219",
    "",
    "4,795,975",
    "",
    "32,182",
    "542",
    "96,098",
    "2,448",
    "25,449,549",
    "493,636",
    "51,555,296"
  ],
  [
    "11 Spain",
    "4,953,930",
    "",
    "86,358",
    "",
    "4,745,511",
    "",
    "122,061",
    "771",
    "105,905",
    "1,846",
    "64,557,887",
    "1,380,113",
    "46,777,260"
  ],
  [
    "12 Italy",
    "4,665,049",
    "",
    "130,807",
    "",
    "4,435,370",
    "",
    "98,872",
    "459",
    "77,298",
    "2,167",
    "91,861,354",
    "1,522,107",
    "60,351,431"
  ]
]