This data as json, CSV (advanced)
id | uuid | groupid ▼ | category | owning_groupid | content_string | normalized_string | lookup_identifier |
---|---|---|---|---|---|---|---|
11315673 | 8735875A-1DBA-47EA-A36D-5E5ACC2CF77B | 12 | 2 | 0 | Grove St | grove st | |
151902 | 2BE0CB22-929B-463E-B20C-83A518787BB4 | 107 | 2 | 0 | Hayes St | hayes st | |
568886 | 57EAA6E6-990D-45CF-842D-E0DD2CE521A3 | 1376 | 2 | 0 | Post St | post st | |
569293 | 6E7773AA-EE8C-4DB8-A8B8-7440B0BB0F3C | 1376 | 2 | 0 | Post St | post st | |
569847 | 93C7D5C0-E78B-47A0-8953-9A143D65597D | 1376 | 2 | 0 | Post St | post st | |
570012 | 9B076964-9931-4790-AE2D-A06011B97CE7 | 1376 | 2 | 0 | Post St | post st | |
514751 | 11C638ED-4C47-4D12-BF4C-4DF75D1508D2 | 1389 | 2 | 0 | Geary Blvd | geary blvd | |
517571 | B1FADEF4-2284-4D74-B306-1ADB41409035 | 1389 | 2 | 0 | Geary Blvd | geary blvd | |
23733 | 4989D148-E809-4B16-850E-E996339D7224 | 1634 | 2 | 962 | Curtis St | curtis st | |
25099 | 973F76C4-33A5-4ADD-A896-8E9744AB177E | 1634 | 2 | 962 | Curtis St | curtis st | |
65776 | 159FCAD3-7088-4AEB-929A-7BCDFF4A628A | 1642 | 2 | 962 | Santa Cruz Ave | santa cruz ave | |
66643 | 5C91B5A8-1A4C-4406-B5E6-11883EFC714E | 1642 | 2 | 962 | Santa Cruz Ave | santa cruz ave | |
53762 | 9ABD9958-31BE-4B9D-9480-7E3342B601FD | 1727 | 2 | 952 | Lasuen Mall | lasuen mall | |
11156994 | F19B5D7D-EFD0-4BE6-B335-CBE309FABB41 | 1738 | 2 | 10 | John F Kennedy Dr | john f kennedy dr | |
11453645 | BCAEC510-5871-42B9-9A19-C5FB587F61FA | 2167 | 2 | 1596 | New Years Creek Rd | new years creek rd | |
11552607 | 3A19DB48-E962-4B82-9E26-57BDA6F34B8C | 2167 | 2 | 1596 | New Years Creek Rd | new years creek rd | |
592928 | E4D43462-07AB-4803-9DCB-02B8321D8D94 | 2191 | 2 | 0 | Market St | market st | |
11432116 | 5F1D5E64-6DEB-4F8B-8A93-F57514B2EDDD | 2207 | 2 | 2206 | Alpine Rd | alpine rd | |
11104680 | B21AA170-9F4B-49A4-A3B4-F77AB2E3CDFA | 2578 | 2 | 2556 | Down Place | down place | |
11532428 | 28933E0F-FEFC-498F-9F5D-873E0E48B1B9 | 2948 | 2 | 2947 | Lothbury | lothbury | |
11349793 | 45CD64EE-9C93-48EA-89F8-8F9C849543F6 | 2951 | 2 | 2950 | Walbrook | walbrook | |
11545342 | 659F6A3E-8547-476F-B2AA-883117C53253 | 2955 | 2 | 2954 | Phoenix Place | phoenix place | |
11229665 | 062B182C-CD24-4EC8-8E27-420EECB14688 | 2957 | 2 | 2956 | Princeton Street | princeton street | |
11372673 | A8B386D0-B156-4594-886A-44207E4C0EA8 | 2959 | 2 | 2958 | Rosebery Avenue | rosebery avenue | |
11251656 | 3C3089C2-BA72-45E8-90B9-2974D8D2DB36 | 2971 | 2 | 2970 | E Observatory Ave | e observatory ave | |
11162310 | BF295F44-7050-4EF5-9D2D-597144A55C46 | 3802 | 2 | 92 | Dr. Carlton B Goodlett Pl | dr. carlton b goodlett pl | |
52482 | 2D40FEB4-03ED-4C06-BEAF-F54E0523D909 | 3814 | 2 | 0 | Embarcadero Rd | embarcadero rd | |
64251 | B03FB29E-EB36-434D-91D2-C6A2C625A252 | 4469 | 2 | 0 | 21st St | 21st st | |
11508783 | 46BAA089-F20D-40E3-8161-5C0FA28FAA90 | 4471 | 2 | 1908 | Port Of New Orleans Pl | port of new orleans pl | |
11272918 | 4C86821D-5061-4FAC-8CF9-CBCCA1ED4D55 | 4493 | 2 | 0 | Oretha Castle Haley Blvd | oretha castle haley blvd | |
11276299 | 43214F71-0B9A-4F8A-AA37-BD30EBF549AA | 4493 | 2 | 0 | Oretha Castle Haley Blvd | oretha castle haley blvd | |
11338090 | F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | 4493 | 2 | 0 | Oretha Castle Haley Blvd | oretha castle haley blvd | |
11382775 | 7E07EFBF-1F63-4142-8856-7DCD9F906811 | 4493 | 2 | 0 | Oretha Castle Haley Blvd | oretha castle haley blvd | |
11563373 | DA8753B5-BAFA-4A34-8DB6-7AC49AB86A6D | 4493 | 2 | 0 | Oretha Castle Haley Blvd | oretha castle haley blvd | |
11301341 | 6FDA5781-8D5F-4369-9F26-C605FF4ECFE4 | 4520 | 2 | 2550 | Slade Lane | slade lane | |
11409384 | BA5C0E8F-0086-47CD-9E8E-DAD96A494C5A | 4534 | 2 | 0 | Dunscombe Lane | dunscombe lane | |
11517972 | A3697779-FE08-47A2-A0F1-F72E5F253A9A | 4866 | 2 | 4865 | Rue Réaumur | rue reaumur | |
11186420 | D15F85D9-D70A-4182-AC30-BCA0EA2AF542 | 4879 | 2 | 4858 | Rue Buffon | rue buffon | |
11500616 | 51F8F5EC-2C01-4C2C-A167-93BBF9244B92 | 4879 | 2 | 4858 | Rue Buffon | rue buffon | |
11300607 | 43E95407-6F45-460A-830E-079C0F149D67 | 4886 | 2 | 948 | Perdido St | perdido st | |
11477248 | A06B7B8E-4BF6-4906-A1E6-0CA4CF0E28E8 | 5293 | 2 | 5291 | Rue de Liège | rue de liege | |
557375 | 40CFDB12-709C-4A22-BB3B-C17A6672C1E7 | 5653 | 2 | 0 | Bridgeway | bridgeway | |
558274 | 5EEC9ED6-BD95-4B4F-B364-DCCB49144A9B | 5653 | 2 | 0 | Bridgeway | bridgeway | |
559079 | 82B5CEE0-0DCB-4E73-84BC-2536F0676B06 | 5653 | 2 | 0 | Bridgeway | bridgeway | |
559970 | A9A5BE5B-A2FA-4224-A26D-6CE3A1AC02C7 | 5653 | 2 | 0 | Bridgeway | bridgeway | |
560703 | D3AECF29-CF9B-4CA0-8A6D-39D21CFA3D54 | 5653 | 2 | 0 | Bridgeway | bridgeway | |
11113423 | 8B27D87D-8FB6-4251-9E6A-68540AC7532B | 6262 | 2 | 0 | L St | l st | |
11480314 | 43A4A851-4821-4125-A673-C1E9FCF2F9AC | 6262 | 2 | 0 | L St | l st | |
11374135 | 277A0A26-444D-4384-8C97-794E66861E96 | 7174 | 2 | 7173 | Seminole Dr | seminole dr | |
11526992 | CE0B0837-963E-4427-8C83-23D6DC01DFEC | 7174 | 2 | 7173 | Seminole Dr | seminole dr | |
11215078 | DD6E4630-85BD-41BF-A7B3-524C02942A65 | 7188 | 2 | 7187 | Lancaster Rd | lancaster rd | |
11422946 | 151812CC-3A4F-4023-B7B6-286EC7E222E9 | 7188 | 2 | 7187 | Lancaster Rd | lancaster rd | |
11365172 | 9A7D9C6D-9566-4DAF-BDF6-84DE9FFAC1E1 | 7192 | 2 | 0 | Wood St | wood st | |
11114026 | A421A342-2706-4A6E-B993-38426E52421B | 8365 | 2 | 8364 | NE Captain Michael King Smith Way | ne captain michael king smith way | |
210466 | 40C65283-9CB3-4FAE-A390-4FDC22BCC29F | 8719 | 2 | 0 | 9th Ave | 9th ave | |
212512 | C0BEA1F5-AAA4-4BCD-A9B0-1E4A91218800 | 8719 | 2 | 0 | 9th Ave | 9th ave | |
11329950 | 903AEA63-4A86-4092-A52E-3DBAC94E1CBF | 8818 | 2 | 4861 | Rue de l'Arbre Sec | rue de l'arbre sec | |
11374450 | 410DD7AF-B97A-4508-9240-B2B0F55DC2FD | 8818 | 2 | 4861 | Rue de l'Arbre Sec | rue de l'arbre sec | |
11440738 | 910061FF-8B93-4DF6-8580-F61F3AF655AC | 8818 | 2 | 4861 | Rue de l'Arbre Sec | rue de l'arbre sec | |
11111841 | 48576FF3-4790-4A9E-957C-5B7AD552679D | 9333 | 2 | 0 | E Ninth St | e ninth st | |
11247598 | 13A4ED05-8B7F-4F49-A613-3B916B11555E | 11063 | 2 | 0 | CA-9 | ca-9 | |
11492718 | 5392047B-DF94-46CF-BA61-06ECE4D8CD9E | 11063 | 2 | 0 | CA-9 | ca-9 | |
11565303 | 4730CC47-5D37-4A64-A6D2-D44CDF5F5B0C | 11063 | 2 | 0 | CA-9 | ca-9 | |
318025 | 01FA701A-92D3-4818-934F-50FA0562366C | 11313 | 2 | 11312 | California Dr | california dr | |
318208 | 0EC5864B-16CC-4B6C-B890-330ADF4998BD | 11313 | 2 | 11312 | California Dr | california dr | |
318253 | 11842992-CE7D-4301-9925-A29B440C9C0E | 11313 | 2 | 11312 | California Dr | california dr | |
318271 | 12AB4E54-7810-428D-A275-7CB631F2E33A | 11313 | 2 | 11312 | California Dr | california dr | |
318461 | 2072695E-48EC-4C6E-9AFE-61F6590F67D5 | 11313 | 2 | 11312 | California Dr | california dr | |
318516 | 277756C5-6924-4E30-877D-CD2CE30630FD | 11313 | 2 | 11312 | California Dr | california dr | |
318616 | 2B9169E5-91EE-4E3C-8B1D-DAFF93D38079 | 11313 | 2 | 11312 | California Dr | california dr | |
318693 | 2FBB5984-3AAC-4565-9233-9B05EF887714 | 11313 | 2 | 11312 | California Dr | california dr | |
318820 | 3CEC2620-AD7D-45EC-A746-FDCADB335D44 | 11313 | 2 | 11312 | California Dr | california dr | |
319099 | 545CBF13-E5F7-4578-91E5-9CA7B023C4C5 | 11313 | 2 | 11312 | California Dr | california dr | |
319195 | 59FDAA51-7EF2-4D97-A110-7A42FA8AC018 | 11313 | 2 | 11312 | California Dr | california dr | |
319209 | 5A10AEF0-50DA-41BE-80F2-79E3367C343E | 11313 | 2 | 11312 | California Dr | california dr | |
319303 | 61A142C7-A526-4AE1-A1B5-C6FB3CE73EBC | 11313 | 2 | 11312 | California Dr | california dr | |
319338 | 625815AF-B061-4180-BFC5-CAC29E4C6C00 | 11313 | 2 | 11312 | California Dr | california dr | |
319371 | 63D46A8E-CB33-48E1-A6A6-662AF9AD922D | 11313 | 2 | 11312 | California Dr | california dr | |
319568 | 74FF69CF-A6F6-42CA-A2C1-1FBBB4F22EEC | 11313 | 2 | 11312 | California Dr | california dr | |
319579 | 75D227E6-3F2B-41A8-9977-E9B55255C861 | 11313 | 2 | 11312 | California Dr | california dr | |
319641 | 7A635293-467F-4C79-A04D-68A1C0250EB7 | 11313 | 2 | 11312 | California Dr | california dr | |
319831 | 8338977E-56F0-4A7D-A6FD-33C2B27C9364 | 11313 | 2 | 11312 | California Dr | california dr | |
319844 | 84CA3880-9BC5-4FF0-9416-8AF1800985EC | 11313 | 2 | 11312 | California Dr | california dr | |
319920 | 8800AD7C-B9A7-4EC9-B543-8CC8892258F1 | 11313 | 2 | 11312 | California Dr | california dr | |
320267 | 9C790AF0-D6F6-4CB6-8DB1-D74DF52754E5 | 11313 | 2 | 11312 | California Dr | california dr | |
320278 | 9D1D2C1F-5BBF-4142-AABF-36F7DE028FA4 | 11313 | 2 | 11312 | California Dr | california dr | |
320310 | 9FA3546D-056E-4B3F-BBAC-AD74DEA303C4 | 11313 | 2 | 11312 | California Dr | california dr | |
320451 | AB43E9CF-7846-4218-AB2E-191D1BA9844E | 11313 | 2 | 11312 | California Dr | california dr | |
320491 | B0DD56EB-03F6-4362-8DAA-DE8580838F78 | 11313 | 2 | 11312 | California Dr | california dr | |
320631 | B95E6DC5-8DFC-4B5B-86DC-68D7616C8C0E | 11313 | 2 | 11312 | California Dr | california dr | |
320717 | C4953733-B5AE-4410-B654-834DABC67F07 | 11313 | 2 | 11312 | California Dr | california dr | |
320801 | C82E683C-DE86-4E9F-A083-C236C315D363 | 11313 | 2 | 11312 | California Dr | california dr | |
320818 | C8CCC8EE-382E-4265-8236-E2F30764A55C | 11313 | 2 | 11312 | California Dr | california dr | |
320831 | CC3EF420-EAC4-4661-8D68-C2009F892C04 | 11313 | 2 | 11312 | California Dr | california dr | |
321154 | D6E497F5-7F93-4434-96D4-7927D358886A | 11313 | 2 | 11312 | California Dr | california dr | |
321255 | DAEEB402-23FC-4CFB-9C40-75DF9B7C0E8F | 11313 | 2 | 11312 | California Dr | california dr | |
321387 | E50B8F10-65AB-4938-AC6C-C8C35EB1C08C | 11313 | 2 | 11312 | California Dr | california dr | |
321404 | E5CE20F5-1129-4B42-B765-D847EE083715 | 11313 | 2 | 11312 | California Dr | california dr | |
321447 | E7C46C63-F84B-4535-86A7-A5028CC63E4B | 11313 | 2 | 11312 | California Dr | california dr | |
321550 | EAA0FF98-970A-42AA-9938-75D632855967 | 11313 | 2 | 11312 | California Dr | california dr |
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]);