Mobile_Food_Facility_Permit

Data source: data.sfgov.org

14 rows where ExpirationDate = "03/31/2018 12:00:00 AM"

View and edit SQL

Suggested facets: Applicant, block, lot, permit, FoodItems, Schedule, dayshours, PriorPermit, Received (date)

ExpirationDate

  • 03/31/2018 12:00:00 AM · 14
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
94 934561 M M Catering 38 Truck 1 9083000 MISSION ST: STEUART ST to SPEAR ST (35 - 99) 98 MISSION ST 3713007 3713 79 007 17MFF-0109 REQUESTED 1 Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks 6014365.441000001 2116885.206 37.7933707169278 -122.39423328044799 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf Mo-Fr:7AM-9AM     2017-02-13 1 03/31/2018 12:00:00 AM (37.7933707169278, -122.394233280448)
100 934565 M M Catering 38 Truck 1 7173000 ILLINOIS ST: 24TH ST to 25TH ST (1400 - 1499) 1499 ILLINOIS ST 4244002 4244 85 002 17MFF-0109 REQUESTED 1 Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks 6016265.425 2102158.675 37.753040320194295 -122.38663176353799 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf Mo-Fr:5PM-6PM     2017-02-13 1 03/31/2018 12:00:00 AM (37.7530403201943, -122.386631763538)
101 934515 Munch India 41 Truck 1 3528000 CALIFORNIA ST: SANSOME ST to LEIDESDORFF ST (400 - 448) 400 CALIFORNIA ST 0239003 0239 81 003 17MFF-0093 REQUESTED 1 Daily rotating menus consisting of various local & organic vegetable: poultry: meat: seafood : rice & bread dishes. 6012277.507999999 2116903.356 37.793304275561 -122.40145899841299 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0093&ExportPDF=1&Filename=17MFF-0093_schedule.pdf Mo/Fr:9AM-3PM     2017-02-13 0 03/31/2018 12:00:00 AM (37.793304275561, -122.401458998413)
116 934569 M M Catering 38 Truck 1 716000 16TH ST: HAMPSHIRE ST to BRYANT ST (2200 - 2399) Assessors Block 3930A/Lot002 3930A002 3930A 95 002 17MFF-0109 REQUESTED 1 Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks 6009824.81 2107195.241 37.766510926908296 -122.40926014493 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf Mo-Fr:7PM-8PM     2017-02-13 1 03/31/2018 12:00:00 AM (37.7665109269083, -122.40926014493)
118 934570 M M Catering 38 Truck 1 7037000 HOWARD ST: HAWTHORNE ST to 03RD ST (648 - 699) 661 HOWARD ST 3735040 3735 97 040 17MFF-0109 REQUESTED 1 Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks 6012797.551 2113994.294 37.785345676641796 -122.39945527669799 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf Mo-Fr:8PM-9PM     2017-02-13 1 03/31/2018 12:00:00 AM (37.7853456766418, -122.399455276698)
120 934568 M M Catering 38 Truck 1 6603000 HAIGHT ST: GOUGH ST to OCTAVIA ST (20 - 99) 20 HAIGHT ST 0853023 0853 99 023 17MFF-0109 REQUESTED 1 Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks 6005961.175 2109761.804 37.7733408773453 -122.422806203983 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf Mo-Fr:6PM-8PM     2017-02-13 1 03/31/2018 12:00:00 AM (37.7733408773453, -122.422806203983)
130 934562 M M Catering 38 Truck 1 2110000 ALABAMA ST: 17TH ST to MARIPOSA ST (400 - 499) 400 ALABAMA ST 3968001 3968 107 001 17MFF-0109 REQUESTED 1 Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks 6008836.323 2106230.5409999997 37.7638066535277 -122.412610953897 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf Mo-Fr:7AM-8AM/9AM-10AM/12PM-1PM/8PM-9PM     2017-02-13 1 03/31/2018 12:00:00 AM (37.7638066535277, -122.412610953897)
134 934564 M M Catering 38 Truck 1 3144000 BROADWAY: FRONT ST to BATTERY ST (100 - 199) 100 BROADWAY 0141003B 0141 111 003B 17MFF-0109 REQUESTED 1 Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks 6012663.956 2118920.369 37.7988640669494 -122.400263583781 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf Mo-Fr:10AM-11AM     2017-02-13 1 03/31/2018 12:00:00 AM (37.7988640669494, -122.400263583781)
140 934560 M M Catering 38 Truck 1 9206000 MISSISSIPPI ST: END to CESAR CHAVEZ ST (1200 - 1299) 1200 MISSISSIPPI ST 4288003 4288 117 003 17MFF-0109 REQUESTED 1 Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks 6014017.542 2101712.6890000002 37.7516910357229 -122.39437421326299 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf Mo/Tu/We/Th/Fr:12AM-5AM;Sa:2PM-6PM;Mo-Fr:3PM-6PM     2017-02-13 1 03/31/2018 12:00:00 AM (37.7516910357229, -122.394374213263)
141 934563 M M Catering 38 Truck 1 12044000 SPEAR ST: MARKET ST to MISSION ST (1 - 99) 45 SPEAR ST 3713006 3713 79 006 17MFF-0109 REQUESTED 1 Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks 6014186.566000001 2117071.214 37.793871507150605 -122.39486523862101 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf Mo-Fr:7AM-8AM/9AM-11AM/12PM-1PM     2017-02-13 1 03/31/2018 12:00:00 AM (37.7938715071506, -122.394865238621)
145 934572 M M Catering 38 Truck 1 6729000 HARRISON ST: LANGTON ST to CHESLEY ST (1113 - 1144) 1140 HARRISON ST 3755023 3755 121 023 17MFF-0109 REQUESTED 1 Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks 6010297.8610000005 2110271.569 37.774984306068795 -122.40784088806002 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf Mo-Fr:9PM-10PM     2017-02-13 1 03/31/2018 12:00:00 AM (37.7749843060688, -122.40784088806)
150 934571 M M Catering 38 Truck 1 9094000 MISSION ST: ANNIE ST to 03RD ST (663 - 699) 667 MISSION ST 3722067 3722 27 067 17MFF-0109 REQUESTED 1 Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks 6012350.571 2114444.914 37.7865580501799 -122.40103337535 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf Mo-Fr:8PM-9PM     2017-02-13 1 03/31/2018 12:00:00 AM (37.7865580501799, -122.40103337535)
163 934567 M M Catering 38 Truck 1 7196000 INDIANA ST: 22ND ST to TUBBS ST (1000 - 1099) 1095 INDIANA ST 4170010 4170 136 010 17MFF-0109 REQUESTED 1 Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks 6015168.427 2103589.069 37.7569070856214 -122.39052536813499 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf Mo-Fr:6PM-7PM     2017-02-13 1 03/31/2018 12:00:00 AM (37.7569070856214, -122.390525368135)
167 934566 M M Catering 38 Truck 1 192201 03RD ST: 23RD ST to 24TH ST (2700 - 2798) -- WEST -- 2700 03RD ST 4230001 4230 140 001 17MFF-0109 REQUESTED 1 Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks 6015750.256 2102782.473 37.75472460401279 -122.388456870373 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf Mo-Fr:6PM-7PM     2017-02-13 1 03/31/2018 12:00:00 AM (37.7547246040128, -122.388456870373)

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 59.759ms · Data source: data.sfgov.org