calls

4 rows where Responsible_Agency = 6

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
2092 2092 11486922 2019-09-30T16:42:00   2019-10-07T07:43:27 Open 1 sent RPD TMA Queue 6 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 233 MELROSE AVE, SAN FRANCISCO, CA, 94127 MELROSE AVE 7 Sunnyside INGLESIDE 37.733641666667 -122.447616666667 POINT (-122.44761667 37.73364167) Mobile/Open311 http://mobile311.sfgov.org/reports/11486922/photos 95 9 8 41 4 9 4 59 7 40 40   95   8             1         95
82994 82994 11485960 2019-09-30T14:05:00   2019-10-02T08:34:21 Open 1 Open RPD TMA Queue 6 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Sunnyside Playground, , SAN FRANCISCO, CA, 94127 Sunnyside Playground 7 Sunnyside INGLESIDE 37.733717480983 -122.44755886357099 POINT (-122.44755886 37.73371748) Mobile/Open311 http://mobile311.sfgov.org/reports/11485960/photos 95 9 8 41 4 9 4 59 7 40 40   95   8             1         95
146858 146858 10810208 2019-05-02T20:31:00   2019-08-08T18:52:08 Open 1 sent RPD TMA Queue 6 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1174 FULTON ST, SAN FRANCISCO, CA, 94117 FULTON ST 5 Alamo Square NORTHERN 37.776819105939005 -122.43605940487 POINT (-122.4360594 37.77681911) Mobile/Open311 http://mobile311.sfgov.org/reports/10810208/photos 23 4 11 9 11 15 8 29,492 5 10 10   23   11             1         23
650692 650692 10505499 2019-02-19T09:24:00   2019-08-22T10:46:02 Open 1 sent RPD TMA Queue 6 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 263 DUBLIN ST, SAN FRANCISCO, CA, 94112 DUBLIN ST 11 Excelsior INGLESIDE 37.715930938721 -122.42819976806601 POINT (-122.42819977 37.71593094) Phone   90 9 1 7 6 9 4 28,861 7 5 5   90   1             2         90

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 9.095ms