Mobile_Food_Facility_Permit

Data source: data.sfgov.org

20 rows where FacilityType = 2 and "Received" is on date 2017-02-13 sorted by PriorPermit

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Applicant, cnn, LocationDescription, Address, blocklot, block, lot, permit, Status, FoodItems, X, Y, Latitude, Longitude, Schedule, dayshours, Approved, PriorPermit, ExpirationDate, Location

Received (date) ✖

  • 2017-02-13 · 20 ✖

FacilityType ✖

  • Push Cart · 20 ✖
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
139 139 934362 Mob Dog 44 Push Cart 2 8745201 MARKET ST: 03RD ST \ KEARNY ST to GRANT AVE \ OFARRELL ST (700 - 748) -- NORTH -- 720 MARKET ST 0312004 0312 116 004 17MFF-0068 REQUESTED 1 Hot Dogs: Chips: Bottled Drinks 6011475.041 2114841.614 37.7875984155546 -122.404090439434 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0068&ExportPDF=1&Filename=17MFF-0068_schedule.pdf Th/Fr/Sa:8AM-10PM     2017-02-13 0 05/06/2018 12:00:00 AM (37.7875984155546, -122.404090439434)
170 170 934559 The Sandwich Stand, LLC. 45 Push Cart 2 8627000 MAIN ST: MARKET ST to MISSION ST (1 - 99) 58 MAIN ST 3711005 3711 142 005 17MFF-0108 REQUESTED 1 Vietnamese sandwiches: spring rolls: bottle water: can soda: chicken and shrimp rice noodles: rice with chicken: chicken salad: noodle soup. 6013902.41 2116435.193 37.792109338609 -122.39580386550199 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0108&ExportPDF=1&Filename=17MFF-0108_schedule.pdf Mo-Fr:8AM-5PM     2017-02-13 0 05/02/2018 12:00:00 AM (37.792109338609, -122.395803865502)
377 377 934712 Halal Cart, LLC 31 Push Cart 2 9301000 MONTGOMERY ST: CALIFORNIA ST to SACRAMENTO ST (400 - 499) 400 MONTGOMERY ST 0239009 0239 81 009 17MFF-0116 APPROVED 5 kebabs: halal gyro: grilled halal meat: refreshments 6011956.214 2116853.2 37.7931486269835 -122.402567175578 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0116&ExportPDF=1&Filename=17MFF-0116_schedule.pdf Mo/We/Fr:10AM-3PM   03/13/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7931486269835, -122.402567175578)
381 381 934709 Halal Cart, LLC 31 Push Cart 2 8741101 MARKET ST: FREMONT ST \ FRONT ST to 01ST ST \ BUSH ST (401 - 499) -- SOUTH -- 455 MARKET ST 3709012 3709 279 012 17MFF-0114 APPROVED 5 Gyros: Kebabs: soft drinks: and water 6013076.33 2116028.637 37.790947041923395 -122.39863358940399 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0114&ExportPDF=1&Filename=17MFF-0114_schedule.pdf Mo-Su:10AM-8PM   03/13/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7909470419234, -122.398633589404)
396 396 934713 Halal Cart, LLC 31 Push Cart 2 8737101 MARKET ST: STEUART ST to SPEAR ST (1 - 99) -- SOUTH -- 1 MARKET ST 3713006 3713 79 006 17MFF-0116 APPROVED 5 kebabs: halal gyro: grilled halal meat: refreshments 6014186.566000001 2117071.214 37.793871507150605 -122.39486523862101 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0116&ExportPDF=1&Filename=17MFF-0116_schedule.pdf Tu/Th/Fr:9AM-3PM   03/13/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7938715071506, -122.394865238621)
402 402 934393 Creme Brulee To Go 71 Push Cart 2 8747202 MARKET ST: 04TH ST \ ELLIS ST \ STOCKTON ST to POWELL ST (800 - 890) -- NORTH -- 870 MARKET ST 0329005 0329 286 005 17MFF-0076 APPROVED 5 Kettle Corn: Pizza: Coffee: Lattes: Cappuchino: Expresso: Hot Tea 6010493.859 2113955.6580000003 37.7851109204478 -122.407422668277 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0076&ExportPDF=1&Filename=17MFF-0076_schedule.pdf Mo-Fr:8AM-7PM;Sa-Su:11AM-7PM   03/13/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7851109204478, -122.407422668277)
463 463 934432 The Chai Cart 17 Push Cart 2 8742101 MARKET ST: 01ST ST \ BUSH ST to 02ND ST (501 - 599) -- SOUTH -- 525 MARKET ST 3708056 3708 4 056 17MFF-0086 APPROVED 5 Hot Indian Chai 6012886.778 2115835.7 37.7904067199405 -122.399275886086 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0086&ExportPDF=1&Filename=17MFF-0086_schedule.pdf Mo-Fr:8AM-4PM   03/17/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7904067199405, -122.399275886086)
464 464 934431 The Chai Cart 17 Push Cart 2 13060000 VALENCIA ST: 16TH ST to 17TH ST (500 - 599) 560 VALENCIA ST 3568009 3568 317 009 17MFF-0086 APPROVED 5 Hot Indian Chai 6006099.355 2106305.353 37.7638580813603 -122.42208262099301 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0086&ExportPDF=1&Filename=17MFF-0086_schedule.pdf Sa-Su:9AM-4PM   03/17/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7638580813603, -122.422082620993)
465 465 934430 The Chai Cart 17 Push Cart 2 8739201 MARKET ST: MAIN ST to BEALE ST \ DAVIS ST \ PINE ST (214 - 298) -- NORTH -- 298 MARKET ST 0264004 0264 30 004 17MFF-0085 APPROVED 5 Indian Chai (Tea) 6013552.57 2116844.5 37.7932137316634 -122.397043036718 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0085&ExportPDF=1&Filename=17MFF-0085_schedule.pdf Mo-Su:7AM-6PM   03/17/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7932137316634, -122.397043036718)
496 496 934394 Creme Brulee To Go 71 Push Cart 2 8747102 MARKET ST: 04TH ST \ ELLIS ST \ STOCKTON ST to POWELL ST (801 - 863) -- SOUTH -- 801 MARKET ST 3705Z001 3705Z 333 001 17MFF-0077 APPROVED 5 Steak and chicken kebob:Steak and chicken kebob sandwiches:chicken teriyaki:chicken teriyaki sandwiches:garden salad side:grilled chicken burger: ground beef burgers: white rice side: canned drinks: and chips 6010997.43389 2113901.46037 37.784990279306506 -122.405676629072 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0077&ExportPDF=1&Filename=17MFF-0077_schedule.pdf Mo-Su:11AM-7PM   03/24/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7849902793065, -122.405676629072)
503 503 934716 Kettle Corn Star 97 Push Cart 2 8746103 MARKET ST: YERBA BUENA LN to 04TH ST \ ELLIS ST \ STOCKTON ST (767 - 799) -- SOUTH -- 773 MARKET ST 3706096 3706 338 096 17MFF-0120 APPROVED 5 Kettle Corn: Funnel Cakes: Lemonade: Beverages: Flan: Hot Dogs: Falafel: Hot and Cold Sandwiches: French Fries: Baklava and Pastries 6011371.872269999 2114041.46827 37.7853956394405 -122.40439104283001 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0120&ExportPDF=1&Filename=17MFF-0120_schedule.pdf Mo-Su:10AM-6PM   03/30/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7853956394405, -122.40439104283)
505 505 934715 Kettle Corn Star 97 Push Cart 2 8747103 MARKET ST: POWELL ST to 05TH ST \ CYRIL MAGNIN ST (865 - 899) -- SOUTH -- 865 MARKET ST 3705 042 3705 340 042 17MFF-0118 APPROVED 5 Kettle Corn: Funnel Cakes: Waffles: Lemonade 6010561.591 2113530.347 37.783946907974205 -122.407158344984 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0118&ExportPDF=1&Filename=17MFF-0118_schedule.pdf Mo-Su:10AM-6PM   03/30/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7839469079742, -122.407158344984)
592 592 934558 The Sandwich Stand, LLC. 45 Push Cart 2 24685000 SANSOME ST: CALIFORNIA ST intersection 351 CALIFORNIA ST 0261010A 0261 37 010A 17MFF-0107 INACTIVE 3 Vietnamese sandwiches: spring rolls: bottle water: can soda: chicken and shrimp rice noodles: rice with chicken: chicken salad: noodle soup. 6012479.848999999 2116741.356 37.7928707497415 -122.400747494077 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0107&ExportPDF=1&Filename=17MFF-0107_schedule.pdf Tu/We:8AM-5PM     2017-02-13 0 05/02/2018 12:00:00 AM (37.7928707497415, -122.400747494077)
605 605 934371 Taza Halal Cart 4 Push Cart 2 8742202 MARKET ST: BATTERY ST to SUTTER ST (540 - 558) -- NORTH -- 532 MARKET ST 0290012 0290 16 012 17MFF-0072 ONHOLD 6 Chicken Gyro: Lamb Gyro: Chiken Gyro Plate: Lamb Gyro Plate: Combination Gyro Plate. 6012582.227999999 2115893.453 37.790548318183205 -122.40033367367901 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0072&ExportPDF=1&Filename=17MFF-0072_schedule.pdf Mo-We:9AM-8PM     2017-02-13 0 06/29/2018 12:00:00 AM (37.7905483181832, -122.400333673679)
188 188 934356 Leo's Hot Dogs 50 Push Cart 2 9121000 MISSION ST: 19TH ST to 20TH ST (2300 - 2399) 2301 MISSION ST 3595031 3595 156 031 17MFF-0067 APPROVED 5 Hot dogs and related toppings: non alcoholic beverages 6007018.02 2104913.057 37.760086931987 -122.418806481101 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0067&ExportPDF=1&Filename=17MFF-0067_schedule.pdf Mo-Su:6PM-12AM   02/22/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.760086931987, -122.418806481101)
370 370 934544 San Francisco Street Foods, Inc. 68 Push Cart 2 7038000 HOWARD ST: 03RD ST to 04TH ST (700 - 799) 701 HOWARD ST 3734091 3734 272 091 17MFF-0100 APPROVED 5 Hot dogs: condiments: soft pretzels: soft drinks: coffee: cold beverages: pastries: bakery goods: cookies: ice cream: candy: soups: churros: chestnuts: nuts: fresh fruit: fruit juices: desserts: potato chips and popcorn. 6012391.612000001 2113335.21 37.7835133512454 -122.400813391105 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0100&ExportPDF=1&Filename=17MFF-0100_schedule.pdf Mo-Su:6AM-12AM   03/13/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7835133512454, -122.400813391105)
376 376 934543 San Francisco Street Foods, Inc. 68 Push Cart 2 30049000 DRUMM ST: CALIFORNIA ST intersection 5 THE EMBARCADERO 0234 017 0234 20 017 17MFF-0099 APPROVED 5 Hot dogs: condiments: soft pretzels: soft drinks: coffee: cold beverages: pastries: bakery goods: cookies: ice cream: candy: soups: churros: chestnuts: nuts: fresh fruit: fruit juices: desserts: potato chips and popcorn. 6013916.72 2117244.027 37.794331003246796 -122.395811053023 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0099&ExportPDF=1&Filename=17MFF-0099_schedule.pdf Mo-Su:6AM-12AM   03/13/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7943310032468, -122.395811053023)
398 398 934545 San Francisco Street Foods, Inc. 68 Push Cart 2 11222000 SACRAMENTO ST: FRONT ST to BATTERY ST (300 - 399) 1 THE EMBARCADERO 0230028 0230 283 028 17MFF-0101 APPROVED 5 Hot dogs: condiments: soft pretzels: soft drinks: coffee: cold beverages: pastries: bakery goods: cookies: ice cream: candy: soups: churros: chestnuts: nuts: fresh fruit: fruit juices: desserts: potato chips and popcorn. 6012811.658 2117380.371 37.7946438346195 -122.399644298529 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0101&ExportPDF=1&Filename=17MFF-0101_schedule.pdf Mo-Su:6AM-12AM   03/13/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7946438346195, -122.399644298529)
594 594 934556 The New York Frankfurter Co. of CA, Inc. DBA: Annie's Hot Dogs 109 Push Cart 2 24892000 STOCKTON ST: 04TH ST \ ELLIS ST \ MARKET ST intersection 800 MARKET ST 0329001 0329 286 001 17MFF-0105 APPROVED 5 Soft pretzels: hot dogs: sausages: chips: popcorn: sodea: coffee: espresso: cappucino: pastries: ice cream: Italian sausages: shish-ka-bob: churros: juice: water: various drinks. 6010729.654 2114081.536 37.785469746489895 -122.406615761073 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0105&ExportPDF=1&Filename=17MFF-0105_schedule.pdf Mo-Su:6AM-9PM   05/05/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7854697464899, -122.406615761073)
595 595 934557 The New York Frankfurter Co. of CA, Inc. DBA: Annie's Hot Dogs 109 Push Cart 2 8747202 MARKET ST: 04TH ST \ ELLIS ST \ STOCKTON ST to POWELL ST (800 - 890) -- NORTH -- 870 MARKET ST 0329005 0329 286 005 17MFF-0106 APPROVED 5 Soft pretzels: hot dogs: sausages: chips: popcorn: soda: espresso: cappucino: pastry: ica cream: ices: italian sausage: shish-ka-bob: churros: juice: water: various drinks 6010493.859 2113955.6580000003 37.7851109204478 -122.407422668277 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0106&ExportPDF=1&Filename=17MFF-0106_schedule.pdf Mo-Su:6AM-9PM   05/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7851109204478, -122.407422668277)

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