calls

1 row where Responsible_Agency = 53 sorted by :@computed_region_fyvs_ahh9 descending

Search:

descending

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
2153398	2153398	2153398	4724092	2015-05-06T13:45:14		2015-05-27T11:51:35	Open 1	new	City College - G 53	Tree Maintenance 1	Trees - Landscaping 5	Weeding	50 PHELAN AVE, SAN FRANCISCO, CA, 94112	PHELAN AVE	7	Sunnyside	INGLESIDE	37.724439061392005	-122.452293229392	POINT (-122.45229323 37.72443906)	Phone		95	9	8	41	4	9	4	28,861	7	40	40		95		8	19			19	13		1					95

Advanced export

JSON shape: default, array, newline-delimited

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))