OpenRefine Foundation

Using the project created in the first lab (Building Permits 2014) from the lesson 1 lab answer the following questions. Answer are provided for your reference in a separate page.

Question 1: How many projects exist for the postal code M1G?

Question 2: In the postal code M1G, how permits type are there for “Plumbing”?

Question 3: What is the longest text for “Structure_Type” and how many characters does it contains?

Question 4: How many conditional permit (permits type) have no structure type defined?

Question 5: What is the permit number of the oldest application?

Question 6: How much does the most expensive project cost?

Question 7: How many unique permit number there is new buildings (column work) only with more than 100 dwelling units

Question 8: When was the latest permit issued?

Question 9: Which day received the most applications

Question 10 : Look for the permit number 00 137770 CMB. Then sort by permit number (text a -z) and then with the lowest revision number first and reorder row permanently. What happen