This data as json, CSV (advanced)
Suggested facets: groupid, content_string, normalized_string
id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
---|---|---|---|---|---|---|---|
64250 | B03FB29E-EB36-434D-91D2-C6A2C625A252 | 2160 | 3 | 10 | Castro | castro | |
151901 | 2BE0CB22-929B-463E-B20C-83A518787BB4 | 11 | 3 | 10 | Hayes Valley | hayes valley | |
396319 | 4BCA66D4-BF92-4060-BF82-85FAEF3033C9 | 985 | 3 | 10 | Outer Richmond | outer richmond | |
397955 | A3621F93-93FE-4025-8C7A-ECC62CA9F326 | 985 | 3 | 10 | Outer Richmond | outer richmond | |
399333 | F78D8339-34E9-4A9A-9BF8-6A73F52566EE | 985 | 3 | 10 | Outer Richmond | outer richmond | |
568884 | 57EAA6E6-990D-45CF-842D-E0DD2CE521A3 | 993 | 3 | 10 | Japantown | japantown | |
569291 | 6E7773AA-EE8C-4DB8-A8B8-7440B0BB0F3C | 993 | 3 | 10 | Japantown | japantown | |
569845 | 93C7D5C0-E78B-47A0-8953-9A143D65597D | 993 | 3 | 10 | Japantown | japantown | |
570010 | 9B076964-9931-4790-AE2D-A06011B97CE7 | 993 | 3 | 10 | Japantown | japantown | |
592166 | B3EDB403-A948-4ABA-BFE4-2C504A636F7A | 2190 | 3 | 10 | Tenderloin | tenderloin | |
592927 | E4D43462-07AB-4803-9DCB-02B8321D8D94 | 2190 | 3 | 10 | Tenderloin | tenderloin | |
11116986 | 14B6764F-C911-4A53-8A56-28D1DE9F634A | 11592 | 3 | 10 | Balboa Terrace | balboa terrace | |
11132244 | A91633D1-A015-4857-AFD6-C27279445751 | 11592 | 3 | 10 | Balboa Terrace | balboa terrace | |
11132750 | C2CA0ADD-619E-4955-B88D-B5C7CB3005EB | 11592 | 3 | 10 | Balboa Terrace | balboa terrace | |
11132999 | C72BFA8A-CE27-403A-B0C3-83D20CF6EB3C | 11592 | 3 | 10 | Balboa Terrace | balboa terrace | |
11315672 | 8735875A-1DBA-47EA-A36D-5E5ACC2CF77B | 11 | 3 | 10 | Hayes Valley | hayes valley |
JSON shape: default, array, newline-delimited, object
CREATE TABLE [labels] ( [id] INTEGER PRIMARY KEY, [uuid] TEXT, [groupid] INTEGER, [category] INTEGER, [owning_groupid] INTEGER, [content_string] TEXT, [normalized_string] TEXT, [lookup_identifier] TEXT ); CREATE INDEX [idx_labels_uuid] ON [labels] ([uuid]); CREATE INDEX [idx_labels_normalized_string] ON [labels] ([normalized_string]);