calls

3 rows where Responsible_Agency = 54

View and edit SQL

Link rowid rowid CaseID Opened Closed Updated Status Status_Notes Responsible_Agency Category Request_Type Request_Details Address Street Supervisor_District Neighborhood Police_District Latitude Longitude Point Source Media_URL SF_Find_Neighborhoods Current_Police_Districts Current_Supervisor_Districts Analysis_Neighborhoods :@computed_region_rxqg_mtj9 :@computed_region_yftq_j783 :@computed_region_jx4q_fizf :@computed_region_bh8s_q3mv :@computed_region_p5aj_wyqh :@computed_region_fyvs_ahh9 :@computed_region_f58d_8dbm :@computed_region_9dfj_4gjx :@computed_region_vtsz_7cme :@computed_region_n4xg_c4py :@computed_region_sruu_94in :@computed_region_4isq_27mq :@computed_region_viu7_rrfi :@computed_region_fcz8_est8 :@computed_region_pigm_ib2e :@computed_region_9jxd_iqea :@computed_region_6ezc_tdp2 :@computed_region_6pnf_4xz7 :@computed_region_h4ep_8xdi :@computed_region_nqbw_i6c3 :@computed_region_2dwj_jsy4 :@computed_region_y6ts_4iup Neighborhoods
2171043 2171043 4653060 2015-04-10T11:05:18 2015-04-15T16:12:00 2015-04-15T16:12:00 Closed 2 See service request number 4668195 PUC - Water Waste - Water Queue 54 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 351 SAN LEANDRO WAY, SAN FRANCISCO, CA, 94127 SAN LEANDRO WAY 7 Balboa Terrace TARAVAL 37.730730458188 -122.468748741238 POINT (-122.46874874 37.73073046) Phone   63 10 8 41 4 9 5 59 8 40 40   63   8             1         63
2299780 2299780 4866480 2015-06-30T08:14:17 2015-08-12T09:22:49 2015-08-12T09:22:49 Closed 2 See service request number 4887067 PUC - Water Waste - Water Queue 54 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 8TH ST and DIVISION ST 8TH ST 10 Showplace Square SOUTHERN 37.769805104328 -122.403406068363 POINT (-122.40340607 37.7698051) Phone   33 1 9 4 8 8 2 28,853 2 20 20   33   9     2       1   2     33
2710678 2710678 6208238 2016-08-17T18:58:24 2016-09-09T14:45:29 2016-09-09T14:45:29 Closed 2 Already sent courtesy letter to this building on 8/24/2016 PUC - Water Waste - Water Queue 54 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 5TH ST and MISSION ST 5TH ST 6 South of Market SOUTHERN 37.782731787459 -122.406481972863 POINT (-122.40648197 37.78273179) Phone   32 1 10 34 9 14 2 28,853 2 34 34   32 1 10           1 2 1       32

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "calls" (
"rowid" INTEGER,
  "CaseID" INTEGER,
  "Opened" TEXT,
  "Closed" REAL,
  "Updated" TEXT,
  "Status" INTEGER,
  "Status_Notes" TEXT,
  "Responsible_Agency" INTEGER,
  "Category" INTEGER,
  "Request_Type" INTEGER,
  "Request_Details" TEXT,
  "Address" TEXT,
  "Street" TEXT,
  "Supervisor_District" INTEGER,
  "Neighborhood" TEXT,
  "Police_District" TEXT,
  "Latitude" REAL,
  "Longitude" REAL,
  "Point" TEXT,
  "Source" TEXT,
  "Media_URL" TEXT,
  "SF_Find_Neighborhoods" INTEGER,
  "Current_Police_Districts" INTEGER,
  "Current_Supervisor_Districts" INTEGER,
  "Analysis_Neighborhoods" INTEGER,
  ":@computed_region_rxqg_mtj9" INTEGER,
  ":@computed_region_yftq_j783" INTEGER,
  ":@computed_region_jx4q_fizf" INTEGER,
  ":@computed_region_bh8s_q3mv" TEXT,
  ":@computed_region_p5aj_wyqh" INTEGER,
  ":@computed_region_fyvs_ahh9" INTEGER,
  ":@computed_region_f58d_8dbm" INTEGER,
  ":@computed_region_9dfj_4gjx" INTEGER,
  ":@computed_region_vtsz_7cme" INTEGER,
  ":@computed_region_n4xg_c4py" INTEGER,
  ":@computed_region_sruu_94in" INTEGER,
  ":@computed_region_4isq_27mq" INTEGER,
  ":@computed_region_viu7_rrfi" INTEGER,
  ":@computed_region_fcz8_est8" INTEGER,
  ":@computed_region_pigm_ib2e" INTEGER,
  ":@computed_region_9jxd_iqea" INTEGER,
  ":@computed_region_6ezc_tdp2" INTEGER,
  ":@computed_region_6pnf_4xz7" INTEGER,
  ":@computed_region_h4ep_8xdi" INTEGER,
  ":@computed_region_nqbw_i6c3" INTEGER,
  ":@computed_region_2dwj_jsy4" INTEGER,
  ":@computed_region_y6ts_4iup" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("Status") REFERENCES [Status](id),
    FOREIGN KEY ("Responsible_Agency") REFERENCES [Responsible_Agency](id),
    FOREIGN KEY ("Category") REFERENCES [Category](id),
    FOREIGN KEY ("Request_Type") REFERENCES [Request_Type](id))
Powered by Datasette · Query took 10.778ms