PotterSys / sii_uf_value

Gets the Unidad de Fomento daily value


This is a scraper that runs on Morph, and fetches the latest Unidad de Fomento information from Servicio de Impuestos Internos

Columns

  1. date: primary column, date, composition from year-month-day (Y-n-j in PHP's date() format)
  2. year: year
  3. month: month (without leading zero)
  4. day: day (without leading zero)
  5. value: the Unidad de Fomento value for that date

Usage

(yes, you can use SQL in Morph!)

https://api.morph.io/PotterSys/sii_uf_value/data.json?&query=select%20date%2Cvalue%20from%20%27data%27%20where%20date%3D%222014-10-1%22&key=*YOUR MORPH API KEY*

Answer:

[{ "date":"2014-10-1", "value":"24170.44" }]

Contributors PotterSys

Last run completed successfully .

Console output of last run

2014-1-1 => 23312.57 2014-1-2 => 23315.57 2014-1-3 => 23318.57 2014-1-4 => 23321.57 2014-1-5 => 23324.58 2014-1-6 => 23327.58 2014-1-7 => 23330.58 2014-1-8 => 23333.59 2014-1-9 => 23336.59 2014-1-10 => 23341.09 2014-1-11 => 23345.6 2014-1-12 => 23350.1 2014-1-13 => 23354.61 2014-1-14 => 23359.12 2014-1-15 => 23363.63 2014-1-16 => 23368.13 2014-1-17 => 23372.64 2014-1-18 => 23377.15 2014-1-19 => 23381.67 2014-1-20 => 23386.18 2014-1-21 => 23390.69 2014-1-22 => 23395.21 2014-1-23 => 23399.72 2014-1-24 => 23404.24 2014-1-25 => 23408.75 2014-1-26 => 23413.27 2014-1-27 => 23417.79 2014-1-28 => 23422.31 2014-1-29 => 23426.83 2014-1-30 => 23431.35 2014-1-31 => 23435.87 ## ## ## ## ## ## 2014-2-1 => 23440.4 2014-2-2 => 23444.92 2014-2-3 => 23449.44 2014-2-4 => 23453.97 2014-2-5 => 23458.5 2014-2-6 => 23463.02 2014-2-7 => 23467.55 2014-2-8 => 23472.08 2014-2-9 => 23476.61 2014-2-10 => 23478.29 2014-2-11 => 23479.96 2014-2-12 => 23481.64 2014-2-13 => 23483.31 2014-2-14 => 23484.99 2014-2-15 => 23486.66 2014-2-16 => 23488.34 2014-2-17 => 23490.02 2014-2-18 => 23491.69 2014-2-19 => 23493.37 2014-2-20 => 23495.04 2014-2-21 => 23496.72 2014-2-22 => 23498.4 2014-2-23 => 23500.07 2014-2-24 => 23501.75 2014-2-25 => 23503.43 2014-2-26 => 23505.11 2014-2-27 => 23506.78 2014-2-28 => 23508.46 ## ## ## ## ## ## 2014-3-1 => 23510.14 2014-3-2 => 23511.82 2014-3-3 => 23513.49 2014-3-4 => 23515.17 2014-3-5 => 23516.85 2014-3-6 => 23518.53 2014-3-7 => 23520.21 2014-3-8 => 23521.88 2014-3-9 => 23523.56 2014-3-10 => 23527.34 2014-3-11 => 23531.13 2014-3-12 => 23534.92 2014-3-13 => 23538.7 2014-3-14 => 23542.49 2014-3-15 => 23546.28 2014-3-16 => 23550.07 2014-3-17 => 23553.86 2014-3-18 => 23557.65 2014-3-19 => 23561.44 2014-3-20 => 23565.23 2014-3-21 => 23569.02 2014-3-22 => 23572.81 2014-3-23 => 23576.61 2014-3-24 => 23580.4 2014-3-25 => 23584.19 2014-3-26 => 23587.99 2014-3-27 => 23591.78 2014-3-28 => 23595.58 2014-3-29 => 23599.38 2014-3-30 => 23603.17 2014-3-31 => 23606.97 ## ## ## ## ## ## 2014-4-1 => 23610.77 2014-4-2 => 23614.57 2014-4-3 => 23618.37 2014-4-4 => 23622.17 2014-4-5 => 23625.97 2014-4-6 => 23629.77 2014-4-7 => 23633.57 2014-4-8 => 23637.37 2014-4-9 => 23641.18 2014-4-10 => 23647.46 2014-4-11 => 23653.74 2014-4-12 => 23660.03 2014-4-13 => 23666.31 2014-4-14 => 23672.6 2014-4-15 => 23678.89 2014-4-16 => 23685.18 2014-4-17 => 23691.47 2014-4-18 => 23697.76 2014-4-19 => 23704.06 2014-4-20 => 23710.35 2014-4-21 => 23716.65 2014-4-22 => 23722.95 2014-4-23 => 23729.25 2014-4-24 => 23735.56 2014-4-25 => 23741.86 2014-4-26 => 23748.17 2014-4-27 => 23754.48 2014-4-28 => 23760.79 2014-4-29 => 23767.1 2014-4-30 => 23773.41 ## ## ## ## ## ## 2014-5-1 => 23779.73 2014-5-2 => 23786.04 2014-5-3 => 23792.36 2014-5-4 => 23798.68 2014-5-5 => 23805.01 2014-5-6 => 23811.33 2014-5-7 => 23817.65 2014-5-8 => 23823.98 2014-5-9 => 23830.31 2014-5-10 => 23834.91 2014-5-11 => 23839.51 2014-5-12 => 23844.11 2014-5-13 => 23848.71 2014-5-14 => 23853.31 2014-5-15 => 23857.92 2014-5-16 => 23862.52 2014-5-17 => 23867.13 2014-5-18 => 23871.73 2014-5-19 => 23876.34 2014-5-20 => 23880.95 2014-5-21 => 23885.56 2014-5-22 => 23890.17 2014-5-23 => 23894.78 2014-5-24 => 23899.39 2014-5-25 => 23904 2014-5-26 => 23908.61 2014-5-27 => 23913.23 2014-5-28 => 23917.84 2014-5-29 => 23922.46 2014-5-30 => 23927.08 2014-5-31 => 23931.69 ## ## ## ## ## ## 2014-6-1 => 23936.31 2014-6-2 => 23940.93 2014-6-3 => 23945.55 2014-6-4 => 23950.17 2014-6-5 => 23954.79 2014-6-6 => 23959.42 2014-6-7 => 23964.04 2014-6-8 => 23968.67 2014-6-9 => 23973.29 2014-6-10 => 23975.68 2014-6-11 => 23978.08 2014-6-12 => 23980.47 2014-6-13 => 23982.87 2014-6-14 => 23985.26 2014-6-15 => 23987.66 2014-6-16 => 23990.05 2014-6-17 => 23992.45 2014-6-18 => 23994.84 2014-6-19 => 23997.24 2014-6-20 => 23999.64 2014-6-21 => 24002.03 2014-6-22 => 24004.43 2014-6-23 => 24006.83 2014-6-24 => 24009.22 2014-6-25 => 24011.62 2014-6-26 => 24014.02 2014-6-27 => 24016.42 2014-6-28 => 24018.81 2014-6-29 => 24021.21 2014-6-30 => 24023.61 ## ## ## ## ## ## 2014-7-1 => 24026.01 2014-7-2 => 24028.41 2014-7-3 => 24030.81 2014-7-4 => 24033.21 2014-7-5 => 24035.61 2014-7-6 => 24038.01 2014-7-7 => 24040.41 2014-7-8 => 24042.81 2014-7-9 => 24045.21 2014-7-10 => 24045.99 2014-7-11 => 24046.76 2014-7-12 => 24047.54 2014-7-13 => 24048.31 2014-7-14 => 24049.09 2014-7-15 => 24049.86 2014-7-16 => 24050.64 2014-7-17 => 24051.41 2014-7-18 => 24052.19 2014-7-19 => 24052.96 2014-7-20 => 24053.74 2014-7-21 => 24054.51 2014-7-22 => 24055.29 2014-7-23 => 24056.07 2014-7-24 => 24056.84 2014-7-25 => 24057.62 2014-7-26 => 24058.39 2014-7-27 => 24059.17 2014-7-28 => 24059.94 2014-7-29 => 24060.72 2014-7-30 => 24061.5 2014-7-31 => 24062.27 ## ## ## ## ## ## 2014-8-1 => 24063.05 2014-8-2 => 24063.82 2014-8-3 => 24064.6 2014-8-4 => 24065.38 2014-8-5 => 24066.15 2014-8-6 => 24066.93 2014-8-7 => 24067.7 2014-8-8 => 24068.48 2014-8-9 => 24069.26 2014-8-10 => 24070.81 2014-8-11 => 24072.36 2014-8-12 => 24073.91 2014-8-13 => 24075.47 2014-8-14 => 24077.02 2014-8-15 => 24078.57 2014-8-16 => 24080.12 2014-8-17 => 24081.67 2014-8-18 => 24083.23 2014-8-19 => 24084.78 2014-8-20 => 24086.33 2014-8-21 => 24087.88 2014-8-22 => 24089.44 2014-8-23 => 24090.99 2014-8-24 => 24092.54 2014-8-25 => 24094.09 2014-8-26 => 24095.65 2014-8-27 => 24097.2 2014-8-28 => 24098.75 2014-8-29 => 24100.31 2014-8-30 => 24101.86 2014-8-31 => 24103.41 ## ## ## ## ## ## 2014-9-1 => 24104.97 2014-9-2 => 24106.52 2014-9-3 => 24108.07 2014-9-4 => 24109.63 2014-9-5 => 24111.18 2014-9-6 => 24112.74 2014-9-7 => 24114.29 2014-9-8 => 24115.84 2014-9-9 => 24117.4 2014-9-10 => 24119.81 2014-9-11 => 24122.22 2014-9-12 => 24124.63 2014-9-13 => 24127.03 2014-9-14 => 24129.44 2014-9-15 => 24131.85 2014-9-16 => 24134.26 2014-9-17 => 24136.67 2014-9-18 => 24139.08 2014-9-19 => 24141.49 2014-9-20 => 24143.9 2014-9-21 => 24146.31 2014-9-22 => 24148.73 2014-9-23 => 24151.14 2014-9-24 => 24153.55 2014-9-25 => 24155.96 2014-9-26 => 24158.37 2014-9-27 => 24160.79 2014-9-28 => 24163.2 2014-9-29 => 24165.61 2014-9-30 => 24168.02 ## ## ## ## ## ## 2014-10-1 => 24170.44 2014-10-2 => 24172.85 2014-10-3 => 24175.26 2014-10-4 => 24177.68 2014-10-5 => 24180.09 2014-10-6 => 24182.51 2014-10-7 => 24184.92 2014-10-8 => 24187.34 2014-10-9 => 24189.75 2014-10-10 => 24195.97 2014-10-11 => 24202.19 2014-10-12 => 24208.41 2014-10-13 => 24214.63 2014-10-14 => 24220.86 2014-10-15 => 24227.08 2014-10-16 => 24233.31 2014-10-17 => 24239.54 2014-10-18 => 24245.77 2014-10-19 => 24252.01 2014-10-20 => 24258.24 2014-10-21 => 24264.48 2014-10-22 => 24270.72 2014-10-23 => 24276.95 2014-10-24 => 24283.2 2014-10-25 => 24289.44 2014-10-26 => 24295.68 2014-10-27 => 24301.93 2014-10-28 => 24308.17 2014-10-29 => 24314.42 2014-10-30 => 24320.67 2014-10-31 => 24326.93 ## ## ## ## ## ## 2014-11-1 => 24333.18 2014-11-2 => 24339.44 2014-11-3 => 24345.69 2014-11-4 => 24351.95 2014-11-5 => 24358.21 2014-11-6 => 24364.47 2014-11-7 => 24370.74 2014-11-8 => 24377 2014-11-9 => 24383.27 2014-11-10 => 24391.36 2014-11-11 => 24399.45 2014-11-12 => 24407.54 2014-11-13 => 24415.64 2014-11-14 => 24423.74 2014-11-15 => 24431.84 2014-11-16 => 24439.95 2014-11-17 => 24448.06 2014-11-18 => 24456.17 2014-11-19 => 24464.28 2014-11-20 => 24472.39 2014-11-21 => 24480.51 2014-11-22 => 24488.63 2014-11-23 => 24496.76 2014-11-24 => 24504.88 2014-11-25 => 24513.01 2014-11-26 => 24521.14 2014-11-27 => 24529.28 2014-11-28 => 24537.42 2014-11-29 => 24545.56 2014-11-30 => 24553.7 ## ## ## ## ## ## 2014-12-1 => 24561.84 2014-12-2 => 24569.99 2014-12-3 => 24578.14 2014-12-4 => 24586.3 2014-12-5 => 24594.45 2014-12-6 => 24602.61 2014-12-7 => 24610.77 2014-12-8 => 24618.94 2014-12-9 => 24627.1 2014-12-10 => 24627.1 2014-12-11 => 24627.1 2014-12-12 => 24627.1 2014-12-13 => 24627.1 2014-12-14 => 24627.1 2014-12-15 => 24627.1 2014-12-16 => 24627.1 2014-12-17 => 24627.1 2014-12-18 => 24627.1 2014-12-19 => 24627.1 2014-12-20 => 24627.1 2014-12-21 => 24627.1 2014-12-22 => 24627.1 2014-12-23 => 24627.1 2014-12-24 => 24627.1 2014-12-25 => 24627.1 2014-12-26 => 24627.1 2014-12-27 => 24627.1 2014-12-28 => 24627.1 2014-12-29 => 24627.1 2014-12-30 => 24627.1 2014-12-31 => 24627.1 ## ## ## ## ## ##

Data

Downloaded 1 time by MikeRalphson

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (107 KB) Use the API

rows 10 / 1826

id date year month day value
1
2010-1-1
2010
1
1
20939.49
2
2010-1-2
2010
1
2
20936.11
3
2010-1-3
2010
1
3
20932.72
4
2010-1-4
2010
1
4
20929.34
5
2010-1-5
2010
1
5
20925.95
6
2010-1-6
2010
1
6
20922.57
7
2010-1-7
2010
1
7
20919.19
8
2010-1-8
2010
1
8
20915.8
9
2010-1-9
2010
1
9
20912.42
10
2010-1-10
2010
1
10
20910.39

Statistics

Average successful run time: less than 20 seconds

Total run time: about 4 hours

Total cpu time used: less than 10 seconds

Total disk space used: 142 KB

History

  • Manually ran revision 243ec6bb and completed successfully .
    365 records added, 343 records removed, 1 record updated in the database
  • Manually ran revision 243ec6bb and completed successfully .
    343 records added, 313 records removed, 1 record updated in the database
  • Manually ran revision 243ec6bb and completed successfully .
    313 records added, 282 records removed, 1 record updated in the database
  • Manually ran revision 92e3c66a and completed successfully .
    1744 records added in the database
  • Manually ran revision ae74c3de and completed successfully .
    1744 records added in the database
  • Manually ran revision 4a9fd6f7 and completed successfully .
    1743 records added, 282 records removed, 1 record updated in the database
  • Manually ran revision 945af79f and completed successfully .
    283 records added in the database
  • Manually ran revision 5aac7300 and failed .
    nothing changed in the database
  • Manually ran revision 5aac7300 and failed .
    nothing changed in the database
  • Manually ran revision 5aac7300 and failed .
    nothing changed in the database
  • Manually ran revision 5aac7300 and failed .
    nothing changed in the database
  • Manually ran revision 5ebbaa87 and failed .
    nothing changed in the database
  • Manually ran revision 4f2442f4 and failed .
    nothing changed in the database
  • Manually ran revision 4f2442f4 and failed .
    nothing changed in the database
  • Created on morph.io

Scraper code

PHP

sii_uf_value / scraper.php