This data as json, CSV (advanced)
id | uuid | groupid | category | owning_groupid ▼ | content_string | normalized_string | lookup_identifier |
---|---|---|---|---|---|---|---|
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 | |
151902 | 2BE0CB22-929B-463E-B20C-83A518787BB4 | 107 | 2 | 0 | Hayes St | hayes st | |
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 | |
413610 | 20AF6E7C-F979-40F6-9808-71FD59CAE1B8 | 14402 | 2 | 0 | Grace Ave | grace ave | |
415029 | 82A5EDE6-0455-46D5-82C4-0FF4E355D8FC | 14402 | 2 | 0 | Grace Ave | grace ave | |
415346 | 97F0AC20-F45C-40F3-BA5F-66210B77A487 | 14402 | 2 | 0 | Grace Ave | grace ave | |
415707 | ADE494D7-0048-491A-B410-D04C5C58B0DD | 14402 | 2 | 0 | Grace Ave | grace ave | |
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 | |
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 | |
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 | |
592928 | E4D43462-07AB-4803-9DCB-02B8321D8D94 | 2191 | 2 | 0 | Market St | market st | |
628967 | AA04E7D2-B517-4CA8-A331-7810A6902E2E | 20512 | 2 | 0 | Finley Rd | finley rd | |
11111841 | 48576FF3-4790-4A9E-957C-5B7AD552679D | 9333 | 2 | 0 | E Ninth St | e ninth st | |
11113423 | 8B27D87D-8FB6-4251-9E6A-68540AC7532B | 6262 | 2 | 0 | L St | l st | |
11116987 | 14B6764F-C911-4A53-8A56-28D1DE9F634A | 11593 | 2 | 0 | San Leandro Way | san leandro way | |
11132245 | A91633D1-A015-4857-AFD6-C27279445751 | 11593 | 2 | 0 | San Leandro Way | san leandro way | |
11132751 | C2CA0ADD-619E-4955-B88D-B5C7CB3005EB | 11593 | 2 | 0 | San Leandro Way | san leandro way | |
11133000 | C72BFA8A-CE27-403A-B0C3-83D20CF6EB3C | 11593 | 2 | 0 | San Leandro Way | san leandro way | |
11247598 | 13A4ED05-8B7F-4F49-A613-3B916B11555E | 11063 | 2 | 0 | CA-9 | ca-9 | |
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 | |
11315673 | 8735875A-1DBA-47EA-A36D-5E5ACC2CF77B | 12 | 2 | 0 | Grove St | grove st | |
11338090 | F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | 4493 | 2 | 0 | Oretha Castle Haley Blvd | oretha castle haley blvd | |
11365172 | 9A7D9C6D-9566-4DAF-BDF6-84DE9FFAC1E1 | 7192 | 2 | 0 | Wood St | wood st | |
11382775 | 7E07EFBF-1F63-4142-8856-7DCD9F906811 | 4493 | 2 | 0 | Oretha Castle Haley Blvd | oretha castle haley blvd | |
11409384 | BA5C0E8F-0086-47CD-9E8E-DAD96A494C5A | 4534 | 2 | 0 | Dunscombe Lane | dunscombe lane | |
11438729 | 090F6409-3525-4789-A369-CB5290CA68E0 | 17314 | 2 | 0 | Pearblossom Hwy | pearblossom hwy | |
11480314 | 43A4A851-4821-4125-A673-C1E9FCF2F9AC | 6262 | 2 | 0 | L St | l st | |
11492718 | 5392047B-DF94-46CF-BA61-06ECE4D8CD9E | 11063 | 2 | 0 | CA-9 | ca-9 | |
11563373 | DA8753B5-BAFA-4A34-8DB6-7AC49AB86A6D | 4493 | 2 | 0 | Oretha Castle Haley Blvd | oretha castle haley blvd | |
11565303 | 4730CC47-5D37-4A64-A6D2-D44CDF5F5B0C | 11063 | 2 | 0 | CA-9 | ca-9 | |
385934 | 1EAE7EE2-CBE6-491B-A8EF-337859628659 | 13148 | 2 | 10 | Nancy Pelosi Dr | nancy pelosi dr | |
386411 | 3D7AE6D3-0FD4-4130-B713-44EB2C885A30 | 13148 | 2 | 10 | Nancy Pelosi Dr | nancy pelosi dr | |
388571 | A92AF32A-7C12-48CC-B1C3-5C83D05B76AA | 13148 | 2 | 10 | Nancy Pelosi Dr | nancy pelosi dr | |
388615 | AC6610AB-FA5E-4B76-93B8-F91AC0ED2D8A | 13148 | 2 | 10 | Nancy Pelosi Dr | nancy pelosi dr | |
390010 | F142B8D1-24B8-4108-AFB7-0C454C72E625 | 13148 | 2 | 10 | Nancy Pelosi Dr | nancy pelosi dr | |
391571 | 3E20BE4D-619A-42EC-9CAA-6F67508892E4 | 13385 | 2 | 10 | Hydo Street Pier | hydo street pier | |
392658 | 76336F73-88DA-4E89-8E57-4A38FEA2986B | 13385 | 2 | 10 | Hydo Street Pier | hydo street pier | |
393409 | 9FAD352B-5A8E-4A93-B84D-5EB5D0A6C409 | 13385 | 2 | 10 | Hydo Street Pier | hydo street pier | |
393632 | AC4419FA-ED22-473F-8FB0-15B647BB2FBD | 13385 | 2 | 10 | Hydo Street Pier | hydo street pier | |
438113 | 1657E7D6-94E7-4344-BCFE-1F924546CE11 | 13148 | 2 | 10 | Nancy Pelosi Dr | nancy pelosi dr | |
438411 | 1F3A99DA-FBB6-4FDC-B84D-AE15DE0846BB | 13148 | 2 | 10 | Nancy Pelosi Dr | nancy pelosi dr | |
439159 | 57650917-1883-4D73-AD2B-B45C6A661534 | 13148 | 2 | 10 | Nancy Pelosi Dr | nancy pelosi dr | |
440931 | CECB8318-5241-46BB-AABF-8CF8A3B72890 | 13148 | 2 | 10 | Nancy Pelosi Dr | nancy pelosi dr | |
441063 | D3CF77DA-B6DD-47F1-A69C-3E01122F133E | 13148 | 2 | 10 | Nancy Pelosi Dr | nancy pelosi dr | |
575201 | CF759040-2FAD-4203-8C0F-88DF33C894BC | 19201 | 2 | 10 | Armistead Rd | armistead rd | |
5385266 | 70B3C358-DA0D-469F-B667-F0045F445AC6 | 13145 | 2 | 10 | Stow Lake Dr | stow lake dr | |
11147713 | 60198E20-708E-4125-B793-4466A87B2DDA | 13148 | 2 | 10 | Nancy Pelosi Dr | nancy pelosi dr | |
11148926 | 8DDE7452-CF7B-4EA0-AFB4-89A15001F19F | 13148 | 2 | 10 | Nancy Pelosi Dr | nancy pelosi dr | |
11156441 | D735F0CE-A3D7-49CB-B83E-594604415A1C | 13148 | 2 | 10 | Nancy Pelosi Dr | nancy pelosi dr | |
11156994 | F19B5D7D-EFD0-4BE6-B335-CBE309FABB41 | 1738 | 2 | 10 | John F Kennedy Dr | john f kennedy dr | |
11157016 | F5F65BC1-8BD3-40A2-B283-EBA2E7657A20 | 13148 | 2 | 10 | Nancy Pelosi Dr | nancy pelosi dr | |
11162310 | BF295F44-7050-4EF5-9D2D-597144A55C46 | 3802 | 2 | 92 | Dr. Carlton B Goodlett Pl | dr. carlton b goodlett pl | |
145759 | 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 | 15293 | 2 | 320 | Clementina St | clementina st | |
592168 | B3EDB403-A948-4ABA-BFE4-2C504A636F7A | 27118 | 2 | 320 | Jessie St | jessie st | |
11300607 | 43E95407-6F45-460A-830E-079C0F149D67 | 4886 | 2 | 948 | Perdido St | perdido st | |
53762 | 9ABD9958-31BE-4B9D-9480-7E3342B601FD | 1727 | 2 | 952 | Lasuen Mall | lasuen mall | |
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 | |
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 | |
11508783 | 46BAA089-F20D-40E3-8161-5C0FA28FAA90 | 4471 | 2 | 1908 | Port Of New Orleans Pl | port of new orleans pl | |
11432116 | 5F1D5E64-6DEB-4F8B-8A93-F57514B2EDDD | 2207 | 2 | 2206 | Alpine Rd | alpine rd | |
11301341 | 6FDA5781-8D5F-4369-9F26-C605FF4ECFE4 | 4520 | 2 | 2550 | Slade Lane | slade lane | |
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 | |
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 | |
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 | |
11517972 | A3697779-FE08-47A2-A0F1-F72E5F253A9A | 4866 | 2 | 4865 | Rue Réaumur | rue reaumur | |
11477248 | A06B7B8E-4BF6-4906-A1E6-0CA4CF0E28E8 | 5293 | 2 | 5291 | Rue de Liège | rue de liege | |
334956 | 011CE4D0-49CE-46BA-B506-D1B4C3745778 | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
334989 | 0173EE6B-1D43-4B54-B6DF-F9542D40BFE4 | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
335067 | 05F7112C-C7CE-4866-8964-29C94481B135 | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
335153 | 0E41A645-44E6-4251-BFDD-456129BC8849 | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
335388 | 2489642F-D29D-47EC-918A-63D1E2CEDF98 | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
335651 | 3A952955-7B08-4DEE-809D-C08685BDC3BF | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
335675 | 3BE3193F-45AF-4787-B445-A6260393657C | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
335834 | 499ABED7-CDCD-4A72-B9FD-21DD54B6008F | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
335992 | 55679037-0DCE-469C-A1B2-1ADD537FA1A6 | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
336086 | 5C55FD14-1786-4136-9026-FBBFFD74C4E3 | 12085 | 2 | 6113 | Evelyn Way | evelyn way |
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]);