calls

5 rows where Responsible_Agency = 23

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
81894 81894 11436538 2019-09-19T09:30:00 2019-10-02T21:30:59 2019-10-02T21:30:59 Closed 2 Per process - cases are closed 10 days after assignment. Clear Channel - Transit Queue 23 Tree Maintenance 1 Trees - Landscaping 5 Other 410 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Castro MISSION 37.762235202838 -122.435481568732 POINT (-122.43548157 37.7622352) Mobile/Open311 http://mobile311.sfgov.org/reports/11436538/photos 38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1 12 5 1 9   1   5     38
596049 596049 10530458 2019-02-25T08:49:00 2019-05-01T21:30:22 2019-05-01T21:30:22 Closed 2 Per process - cases are closed 10 days after assignment. Clear Channel - Transit Queue 23 Tree Maintenance 1 Trees - Landscaping 5 Other 1520 MARKET ST, SAN FRANCISCO, CA, 94102 MARKET ST 5 Civic Center SOUTHERN 37.77499 -122.41956100000002 POINT (-122.419561 37.77499) Mobile/Open311   21 1 11 9 11 7 2 28,852 2 10 10   21 1 11     1   8 1 1 1 1     21
658371 658371 10584126 2019-03-10T10:57:00 2019-04-17T21:30:36 2019-04-17T21:30:36 Closed 2 Per process - cases are closed 10 days after assignment. Clear Channel - Transit Queue 23 Tree Maintenance 1 Trees - Landscaping 5 Other 1601 MARKET ST, SAN FRANCISCO, CA, 94103 MARKET ST 6 South of Market SOUTHERN 37.77421 -122.420222 POINT (-122.420222 37.77421) Mobile/Open311   32 1 10 20 9 8 2 28,853 2 19 19   32 1 10     1   8 1 2 1 1     32
2437971 2437971 5352056 2015-12-07T10:39:18 2015-12-07T13:56:52 2015-12-07T13:56:52 Closed 2   Clear Channel - Transit Queue 23 Tree Maintenance 1 Trees - Tree_Other 4 Other 1158 POTRERO AVE, SAN FRANCISCO, CA, 94110 POTRERO AVE 9 Mission MISSION 37.753355 -122.40626699999999 POINT (-122.406267 37.753355) Mobile/Open311 http://mobile311.sfgov.org/reports/5352056/photos 54 3 9 20 8 10 7 28,859 4 19 19 23 54   9 10   3 10     1   3     54
3724797 3724797 11327376 2019-08-26T17:49:00 2019-09-06T21:30:52 2019-09-06T21:30:52 Closed 2 Per process - cases are closed 10 days after assignment. Clear Channel - Transit Queue 23 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of CHATTANOOGA ST and 21ST ST CHATTANOOGA ST 8 Dolores Heights MISSION 37.756561279296996 -122.426788330078 POINT (-122.42678833 37.75656128) Phone   52 3 5 5 5 2 7 28,862 4 3 3   52   5             1         52

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