Mobile_Food_Facility_Permit

Data source: data.sfgov.org

19 rows where "Received" is on date 2014-07-10 sorted by ExpirationDate

✎ View and edit SQL

This data as json, CSV (advanced)

Received (date) ✖

  • 2014-07-10 · 12 ✖
Link rowid locationid Applicant FacilityType cnn LocationDescription Address blocklot block lot permit Status FoodItems X Y Latitude Longitude Schedule dayshours NOISent Approved Received PriorPermit ExpirationDate ▼ Location
79 79 559782 Mang Hang Catering 35 Truck 1 9101000 MISSION ST: 07TH ST to ANGELOS ALY \ JULIA ST (1100 - 1165) 1118 MISSION ST 3702032 3702 67 032 14MFF-0109 EXPIRED 2 COLD TRUCK. Deli: bbq chicken skewer: Chinese spring roll: Chinese fried rice/noodle: fried chicken leg/wing: bbq chicken sandwich: chicken cheese burger: burrito: lumpia. Snack: sunflower seeds: muffins: chips: snickers: kit-kat: 10 types of chocolate. Drinks: Coke: 7-Up: Dr. Pepper: Pepsi: Redbull: Vitamin Water: Rockstar: Coconut Juice: Water. Hot drinks: coffee: tea. 6009238.199 2111812.954 37.7791572053411 -122.411615430519 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0109&ExportPDF=1&Filename=14MFF-0109_schedule.pdf Mo-Fr:12PM-1PM     2014-07-10 1 03/15/2017 12:00:00 AM (37.7791572053411, -122.411615430519)
80 80 559774 Mang Hang Catering 35 Truck 1 144000 02ND ST: FEDERAL ST to SOUTH PARK (519 - 548) 544 02ND ST 3775005 3775 68 005 14MFF-0109 EXPIRED 2 COLD TRUCK. Deli: bbq chicken skewer: Chinese spring roll: Chinese fried rice/noodle: fried chicken leg/wing: bbq chicken sandwich: chicken cheese burger: burrito: lumpia. Snack: sunflower seeds: muffins: chips: snickers: kit-kat: 10 types of chocolate. Drinks: Coke: 7-Up: Dr. Pepper: Pepsi: Redbull: Vitamin Water: Rockstar: Coconut Juice: Water. Hot drinks: coffee: tea. 6014572.797 2112894.0930000003 37.7824235632947 -122.393236399398 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0109&ExportPDF=1&Filename=14MFF-0109_schedule.pdf Mo-Fr:7AM-8AM/10AM-11AM/11AM-12PM     2014-07-10 1 03/15/2017 12:00:00 AM (37.7824235632947, -122.393236399398)
81 81 559777 Mang Hang Catering 35 Truck 1 131000 02ND ST: JESSIE ST to MISSION ST (69 - 99) 85 02ND ST 3708019 3708 4 019 14MFF-0109 EXPIRED 2 COLD TRUCK. Deli: bbq chicken skewer: Chinese spring roll: Chinese fried rice/noodle: fried chicken leg/wing: bbq chicken sandwich: chicken cheese burger: burrito: lumpia. Snack: sunflower seeds: muffins: chips: snickers: kit-kat: 10 types of chocolate. Drinks: Coke: 7-Up: Dr. Pepper: Pepsi: Redbull: Vitamin Water: Rockstar: Coconut Juice: Water. Hot drinks: coffee: tea. 6012696.635 2115129.488 37.788457028828894 -122.399884160566 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0109&ExportPDF=1&Filename=14MFF-0109_schedule.pdf Mo-Fr:7AM-8AM/10AM-11AM/12PM-1PM     2014-07-10 1 03/15/2017 12:00:00 AM (37.7884570288289, -122.399884160566)
82 82 559788 Mang Hang Catering 35 Truck 1 1177000 22ND ST: SAN BRUNO AVE to UTAH ST (2400 - 2449) 2401 22ND ST 4154001 4154 69 001 14MFF-0109 EXPIRED 2 COLD TRUCK. Deli: bbq chicken skewer: Chinese spring roll: Chinese fried rice/noodle: fried chicken leg/wing: bbq chicken sandwich: chicken cheese burger: burrito: lumpia. Snack: sunflower seeds: muffins: chips: snickers: kit-kat: 10 types of chocolate. Drinks: Coke: 7-Up: Dr. Pepper: Pepsi: Redbull: Vitamin Water: Rockstar: Coconut Juice: Water. Hot drinks: coffee: tea. 6010945.915 2103212.154 37.7556370098323 -122.405101930379 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0109&ExportPDF=1&Filename=14MFF-0109_schedule.pdf Mo-Fr:10AM-11AM     2014-07-10 1 03/15/2017 12:00:00 AM (37.7556370098323, -122.405101930379)
83 83 559773 Mang Hang Catering 35 Truck 1 5073000 EDDY ST: STEINER ST to PIERCE ST (1600 - 1699) 1652 EDDY ST 0730 044 0730 70 044 14MFF-0109 EXPIRED 2 COLD TRUCK. Deli: bbq chicken skewer: Chinese spring roll: Chinese fried rice/noodle: fried chicken leg/wing: bbq chicken sandwich: chicken cheese burger: burrito: lumpia. Snack: sunflower seeds: muffins: chips: snickers: kit-kat: 10 types of chocolate. Drinks: Coke: 7-Up: Dr. Pepper: Pepsi: Redbull: Vitamin Water: Rockstar: Coconut Juice: Water. Hot drinks: coffee: tea. 6002540.818 2112839.086 37.781596745760204 -122.43485778844 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0109&ExportPDF=1&Filename=14MFF-0109_schedule.pdf Mo-Fr:11AM-12PM     2014-07-10 1 03/15/2017 12:00:00 AM (37.7815967457602, -122.43485778844)
84 84 559772 Mang Hang Catering 35 Truck 1 13064000 VALENCIA ST: 18TH ST to 19TH ST (700 - 799) 740 VALENCIA ST 3588006 3588 71 006 14MFF-0109 EXPIRED 2 COLD TRUCK. Deli: bbq chicken skewer: Chinese spring roll: Chinese fried rice/noodle: fried chicken leg/wing: bbq chicken sandwich: chicken cheese burger: burrito: lumpia. Snack: sunflower seeds: muffins: chips: snickers: kit-kat: 10 types of chocolate. Drinks: Coke: 7-Up: Dr. Pepper: Pepsi: Redbull: Vitamin Water: Rockstar: Coconut Juice: Water. Hot drinks: coffee: tea. 6006152.35 2105247.76 37.7609571682785 -122.421824199358 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0109&ExportPDF=1&Filename=14MFF-0109_schedule.pdf Mo-Fr:11AM-12PM     2014-07-10 1 03/15/2017 12:00:00 AM (37.7609571682785, -122.421824199358)
85 85 559779 Mang Hang Catering 35 Truck 1 4083000 CLAY ST: BATTERY ST to SANSOME ST (400 - 499) 432 CLAY ST 0206006 0206 72 006 14MFF-0109 EXPIRED 2 COLD TRUCK. Deli: bbq chicken skewer: Chinese spring roll: Chinese fried rice/noodle: fried chicken leg/wing: bbq chicken sandwich: chicken cheese burger: burrito: lumpia. Snack: sunflower seeds: muffins: chips: snickers: kit-kat: 10 types of chocolate. Drinks: Coke: 7-Up: Dr. Pepper: Pepsi: Redbull: Vitamin Water: Rockstar: Coconut Juice: Water. Hot drinks: coffee: tea. 6012459.069 2117555.691 37.7951055609814 -122.400876633726 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0109&ExportPDF=1&Filename=14MFF-0109_schedule.pdf Mo-Fr:7AM-8AM/10AM-11AM/12PM-1PM     2014-07-10 1 03/15/2017 12:00:00 AM (37.7951055609814, -122.400876633726)
86 86 559783 Mang Hang Catering 35 Truck 1 9058000 MINNESOTA ST: 23RD ST to 24TH ST (1200 - 1299) 1240 MINNESOTA ST 4228015 4228 73 015 14MFF-0109 EXPIRED 2 COLD TRUCK. Deli: bbq chicken skewer: Chinese spring roll: Chinese fried rice/noodle: fried chicken leg/wing: bbq chicken sandwich: chicken cheese burger: burrito: lumpia. Snack: sunflower seeds: muffins: chips: snickers: kit-kat: 10 types of chocolate. Drinks: Coke: 7-Up: Dr. Pepper: Pepsi: Redbull: Vitamin Water: Rockstar: Coconut Juice: Water. Hot drinks: coffee: tea. 6015191.235 2102753.826 37.7546149514892 -122.39038813202 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0109&ExportPDF=1&Filename=14MFF-0109_schedule.pdf Mo-Fr:1PM-2PM     2014-07-10 1 03/15/2017 12:00:00 AM (37.7546149514892, -122.39038813202)
87 87 559789 Mang Hang Catering 35 Truck 1 5178000 ELLIS ST: LARKIN ST to POLK ST (700 - 799) 730 ELLIS ST 0717006 0717 74 006 14MFF-0109 EXPIRED 2 COLD TRUCK. Deli: bbq chicken skewer: Chinese spring roll: Chinese fried rice/noodle: fried chicken leg/wing: bbq chicken sandwich: chicken cheese burger: burrito: lumpia. Snack: sunflower seeds: muffins: chips: snickers: kit-kat: 10 types of chocolate. Drinks: Coke: 7-Up: Dr. Pepper: Pepsi: Redbull: Vitamin Water: Rockstar: Coconut Juice: Water. Hot drinks: coffee: tea. 6007315.572000001 2113769.269 37.7844207368995 -122.418405351782 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0109&ExportPDF=1&Filename=14MFF-0109_schedule.pdf Mo-Fr:10AM-11AM     2014-07-10 1 03/15/2017 12:00:00 AM (37.7844207368995, -122.418405351782)
88 88 559776 Mang Hang Catering 35 Truck 1 9094000 MISSION ST: ANNIE ST to 03RD ST (663 - 699) 690 MISSION ST 3707024 3707 22 024 14MFF-0109 EXPIRED 2 COLD TRUCK. Deli: bbq chicken skewer: Chinese spring roll: Chinese fried rice/noodle: fried chicken leg/wing: bbq chicken sandwich: chicken cheese burger: burrito: lumpia. Snack: sunflower seeds: muffins: chips: snickers: kit-kat: 10 types of chocolate. Drinks: Coke: 7-Up: Dr. Pepper: Pepsi: Redbull: Vitamin Water: Rockstar: Coconut Juice: Water. Hot drinks: coffee: tea.     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0109&ExportPDF=1&Filename=14MFF-0109_schedule.pdf Mo-Fr:7AM-8AM/10AM-11AM/12PM-1PM     2014-07-10 1 03/15/2017 12:00:00 AM (0, 0)
89 89 559778 Mang Hang Catering 35 Truck 1 12678000 TREAT AVE: DIVISION ST \ FLORIDA ST to ALAMEDA ST (1 - 99) Assessors Block 3902/Lot002 3902002 3902 75 002 14MFF-0109 EXPIRED 2 COLD TRUCK. Deli: bbq chicken skewer: Chinese spring roll: Chinese fried rice/noodle: fried chicken leg/wing: bbq chicken sandwich: chicken cheese burger: burrito: lumpia. Snack: sunflower seeds: muffins: chips: snickers: kit-kat: 10 types of chocolate. Drinks: Coke: 7-Up: Dr. Pepper: Pepsi: Redbull: Vitamin Water: Rockstar: Coconut Juice: Water. Hot drinks: coffee: tea. 6009046.271000001 2107865.259 37.7683069928 -122.41200033609199 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0109&ExportPDF=1&Filename=14MFF-0109_schedule.pdf Mo-Fr:7AM-8AM/10AM-11AM/12PM-1PM     2014-07-10 1 03/15/2017 12:00:00 AM (37.7683069928, -122.412000336092)
91 91 559784 Mang Hang Catering 35 Truck 1 4614000 DAVIDSON AVE: QUINT ST to RANKIN ST (1500 - 1599) 1580 DAVIDSON AVE 5216029 5216 76 029 14MFF-0109 EXPIRED 2 COLD TRUCK. Deli: bbq chicken skewer: Chinese spring roll: Chinese fried rice/noodle: fried chicken leg/wing: bbq chicken sandwich: chicken cheese burger: burrito: lumpia. Snack: sunflower seeds: muffins: chips: snickers: kit-kat: 10 types of chocolate. Drinks: Coke: 7-Up: Dr. Pepper: Pepsi: Redbull: Vitamin Water: Rockstar: Coconut Juice: Water. Hot drinks: coffee: tea. 6015031.248 2099507.747 37.7456930261204 -122.390714584821 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0109&ExportPDF=1&Filename=14MFF-0109_schedule.pdf Mo-Fr:2PM-3PM     2014-07-10 1 03/15/2017 12:00:00 AM (37.7456930261204, -122.390714584821)

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Mobile_Food_Facility_Permit" (
"locationid" INTEGER,
  "Applicant" INTEGER,
  "FacilityType" INTEGER,
  "cnn" INTEGER,
  "LocationDescription" TEXT,
  "Address" TEXT,
  "blocklot" TEXT,
  "block" INTEGER,
  "lot" TEXT,
  "permit" TEXT,
  "Status" INTEGER,
  "FoodItems" TEXT,
  "X" REAL,
  "Y" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Schedule" TEXT,
  "dayshours" REAL,
  "NOISent" REAL,
  "Approved" REAL,
  "Received" TEXT,
  "PriorPermit" INTEGER,
  "ExpirationDate" REAL,
  "Location" TEXT
,
FOREIGN KEY ("Applicant") REFERENCES [Applicant](id),
    FOREIGN KEY ("FacilityType") REFERENCES [FacilityType](id),
    FOREIGN KEY ("Status") REFERENCES [Status](id),
    FOREIGN KEY ("block") REFERENCES [block](id));
CREATE INDEX ["Mobile_Food_Facility_Permit_Applicant"] ON [Mobile_Food_Facility_Permit]("Applicant");
CREATE INDEX ["Mobile_Food_Facility_Permit_FacilityType"] ON [Mobile_Food_Facility_Permit]("FacilityType");
CREATE INDEX ["Mobile_Food_Facility_Permit_Status"] ON [Mobile_Food_Facility_Permit]("Status");
CREATE INDEX ["Mobile_Food_Facility_Permit_block"] ON [Mobile_Food_Facility_Permit]("block");
Powered by Datasette · Query took 11.109ms · Data source: data.sfgov.org