TIC
Sign in to Lens

Workplace search fields and examples

Fields and examples for the workplaces search collection behind /search-public/workplaces.

Max+ tier

These are the fields of the workplaces search collection behind /search-public/workplaces (GET, POST). Use them in query_by, filter_by and sort_by. The parameters, plan limits, Pro tier filtering, redacted properties and date handling that apply to every collection are described in Search, and the response schema on the endpoint pages.

Field guides for the other collections:

With our search for workplaces you can query (query_by) based on a number fields listed in the next chapter.

Examples on what you can query on:

  • Name of the workplace
  • Street, postalcode, city, municipality code, county code and much more
  • Companies that has ownership over the workplace
  • Industry codes relating to the workplace

Fields indexed

The following fields are currently indexed in memory. These can be used in the query_by and filter_by parameter.

FieldTypeDescription
companyWorkplaceIdint32Our global internal workspace identifier
workplaceCodeint32The workplace identifier in the local business register
workplaceCompanies.companyIdint32Our global internal company identifier
workplaceCompanies.fromDateint64If the workplace has been moved to company this will contain the Unix from time (epoch)
workplaceCompanies.toDateint64If the workplace is longer present on the company this will contain the Unix to time (epoch)
workplaceCompanies.registrationNumberstringThe registrationnumber of the business
workplaceCompanies.mostRecentNamestringThe most recent legalname for the business
workplaceCompanies.legalEntityTypestringThe legal entity type of the business
workplaceCompanies.localCompanyCodestringThe local market abbreviated code
workplaceCompanies.elfCodestringThe ISO Entity Legal Form code (ELF)
workplaceCompanies.registrationDatestringThe registration date (epoch) of the business
workplaceCompanies.ceasedDateint64The business has ceased operation (epoch)
workplaceCompanies.isCeasedboolFlag to indicate the business have ceased operation
workplaceUnits.companyIdint32Each workplace can contain one or multiple sub-units owned by businesses
workplaceUnits.unitIdentifierint32The identifier for the unit
workplaceUnits.firstSeenAtint64The timestamp when we located the unit (epoch)
workplaceUnits.lastSeenAtint64The timestamp when we located that the unit has disappeared (epoch)
workplaceTypeint32The type of the workplace
workplaceTypeDescriptionSvstringThe description of the type of the workplace, in the local language
employeesRangeTypeint32The range of number of employees (interval)
employeesRangeTypeDescriptionSvstringThe description of the range, in the local language
mostRecentVistingAddress.costringC/O of the visiting address
mostRecentVistingAddress.streetAddressstringThe full street address of the visting address
mostRecentVistingAddress.streetstringStreet name of the visiting address
mostRecentVistingAddress.houseNumberstringHouse number of the visting address
mostRecentVistingAddress.houseLetterstringHouse letter of the visiting address
mostRecentVistingAddress.postalCodestringPostal code of the visting address
mostRecentVistingAddress.citystringCity of the visting address
mostRecentVistingAddress.countryCodeAlpha3stringCountry code (alpha 3) of the visting address
mostRecentVistingAddress.municipalityCodestringThe municipality code (4 chars)
mostRecentVistingAddress.countyCodestringThe county code (2 chars)
mostRecentVistingAddress.nykostringThe subdivision code of the municipality
mostRecentVistingAddress.nykoYearstringThe origin year of the subdivision code
mostRecentVistingAddress.locationgeopointThe latitude and longitude of the address
mostRecentVistingAddress.firstSeenAtstringThe timestamp when we located the visting address (epoch)
mostRecentMailingAddress.costringC/O of the mailing address
mostRecentMailingAddress.streetAddressstringThe full street address of the mailing address
mostRecentMailingAddress.streetstringStreet name of the mailing address
mostRecentMailingAddress.houseNumberstringHouse number of the mailing address
mostRecentMailingAddress.houseLetterstringHouse letter of the mailing address
mostRecentMailingAddress.postalCodestringPostal code of the mailing address
mostRecentMailingAddress.citystringCity of the mailing address
mostRecentMailingAddress.countryCodeAlpha3stringCountry code (alpha 3) of the visting address
mostRecentMailingAddress.municipalityCodestringThe municipality code (4 chars)
mostRecentMailingAddress.countyCodestringThe county code (2 chars)
mostRecentMailingAddress.nykostringThe subdivision code of the municipality
mostRecentMailingAddress.nykoYearstringThe origin year of the subdivision code
mostRecentMailingAddress.locationgeopointThe latitude and longitude of the address
mostRecentMailingAddress.firstSeenAtstringThe timestamp when we located the mailing address (epoch)
sniCodes.firstSeenAtstringThe timestamp when we located the industry code (epoch)
sniCodes.sni_2007NamestringThe industry code of the workplace based on SNI 2007
sniCodes.sni_2007CodestringThe name/description of the industry cod
sniCodes.rankstringThe rank (sequence number)
status.statusTypestringThe status of the workplace
status.statusDescriptionstringThe description of the status of the workplace
status.statusDatestringThe date of the status (if it exists)

Examples

We have put together a few example of how you can use search for workplaces to easy find data.

Search for workplaces based on a freetext business name

Shows an example searching for workplaces controlled by the freetext business name, Bahnhof.

cURLbash
curl -H "x-api-key: YOUR_API_KEY" \
  "https://lens-api.tic.io/search-public/workplaces?q=bahnhof&query_by=workplaceCompanies.mostRecentName"
{
	"facet_counts": [],
	"found": 16,
	"hits": [
		{
			"document": {
				"companyWorkplaceId": 805670,
				"employeesRangeType": 4,
				"employeesRangeTypeDescriptionSv": "10-19 anställda",
				"id": "805670",
				"mostRecentMailingAddress": {
					"city": "Malmö",
					"firstSeenAt": 1726790400,
					"houseLetter": "B",
					"houseNumber": "15",
					"location": [
						55.6001,
						13.003
					],
					"postalCode": "21141",
					"street": "Storgatan",
					"streetAddress": "Storgatan 15 B"
				},
				"mostRecentVistingAddress": {
					"city": "Malmö",
					"countyCode": "12",
					"firstSeenAt": 1726790400,
					"houseLetter": "B",
					"houseNumber": "15",
					"location": [
						55.6001,
						13.003
					],
					"municipalityCode": "1280",
					"nyko": "130110",
					"nykoYear": 2023,
					"postalCode": "21141",
					"street": "Storgatan",
					"streetAddress": "Storgatan 15 B"
				},
				"sniCodes": [
					{
						"rank": 1,
						"sni_2007Code": "63110",
						"sni_2007Name": "Databehandling, hosting o.d."
					}
				],
				"status": [
					{
						"statusDate": 1415318400,
						"statusDescription": "Workplace is active",
						"statusType": "isActive"
					}
				],
				"workplaceCode": 55205868,
				"workplaceCompanies": [
					{
						"companyId": 1893055,
						"elfCode": "XJHM",
						"isCeased": false,
						"legalEntityType": "Aktiebolag",
						"localCompanyCode": "AB",
						"mostRecentName": "Bahnhof AB (publ)",
						"registrationDate": 805680000,
						"registrationNumber": "5565199493"
					}
				],
				"workplaceName": [
					{
						"firstSeenAt": 1726790400,
						"nameOrIdentifier": "SPARVEN 15"
					}
				],
				"workplaceType": 2,
				"workplaceTypeDescriptionSv": "Representerar ej JE",
				"workplaceUnits": [
					{
						"companyId": 1893055,
						"firstSeenAt": 1734364731,
						"unitIdentifier": 9
					}
				]
			},
			"highlight": {
				"workplaceCompanies": [
					{
						"mostRecentName": {
							"matched_tokens": [
								"Bahnhof"
							],
							"snippet": "<mark>Bahnhof</mark> AB (publ)"
						}
					}
				]
			},
			"highlights": [],
			"text_match": 578730123365187705,
			"text_match_info": {
				"best_field_score": "1108091338752",
				"best_field_weight": 15,
				"fields_matched": 1,
				"num_tokens_dropped": 0,
				"score": "578730123365187705",
				"tokens_matched": 1,
				"typo_prefix_score": 0
			}
		},
	],
	"out_of": 1962201,
	"page": 1,
	"request_params": {
		"collection_name": "workplaces_20241228165159",
		"first_q": "bahnhof",
		"per_page": 10,
		"q": "bahnhof"
	},
	"search_cutoff": false,
	"search_time_ms": 1
}

Search for workplaces on a specific street and city

You can search virtually on anything, here is an example search for all workplaces on the specific street, Tunnelgatan, in the city Stockholm.

cURLbash
curl -H "x-api-key: YOUR_API_KEY" \
  "https://lens-api.tic.io/search-public/workplaces?q=*&query_by=*&filter_by=mostRecentVistingAddress.city:='Stockholm'&&mostRecentVistingAddress.street:='Tunnelgatan'"
{
    "facet_counts": [],
    "found": 12,
    "hits": [
        {
            "document": {
                "companyWorkplaceId": 1779625,
                "employeesRangeType": 1,
                "employeesRangeTypeDescriptionSv": "0 anställda",
                "id": "1779625",
                "mostRecentMailingAddress": {
                  ...

Search for workplaces with 5000 or more employees

You can also search for workplaces based on number of employees.

cURLbash
curl -H "x-api-key: YOUR_API_KEY" \
  "https://lens-api.tic.io/search-public/workplaces?q=*&query_by=*&filter_by=employeesRangeType:>=15"
{
    "facet_counts": [],
    "found": 20,
    "hits": [
        {
            "document": {
                "companyWorkplaceId": 369656,
                "employeesRangeType": 15,
                "employeesRangeTypeDescriptionSv": "5000-9999 anställda",
                ...

Search for all workplaces in a county

Search for all workplaces in a county is simple.

cURLbash
curl -H "x-api-key: YOUR_API_KEY" \
  "https://lens-api.tic.io/search-public/workplaces?q=*&query_by=*&filter_by=mostRecentVistingAddress.countyCode:='01'"
{
    "facet_counts": [],
    "found": 504707,
    "hits": [
        {
            "document": {
                "companyWorkplaceId": 1940000,
                "employeesRangeType": 1,
                "employeesRangeTypeDescriptionSv": "0 anställda",
                "id": "1940000",
                "mostRecentMailingAddress": {
                    "city": "Sigtuna",
                    "firstSeenAt": 1728864000,
                    "houseNumber": "8",
                    "location": [
                        59.61802,
                        17.71584
                    ],
                    "postalCode": "19332",
                    "street": "Tunvägen",
                    "streetAddress": "Tunvägen 8"
                },...