DataBrighten

    Business/establishment census (Availability score over 20 years)

    3,800 × 6rows × columns: 190 countries, 2004 to 2023

    Real data: World Bank, Statistical Performance Indicators, indicator SPI.D4.1.3.BIZZ, retrieved 19 November 2026. Values are as published; we only reshaped the file.

    textnumberdateyes/no
    Rows3,800country-year values
    Countries190with at least one value
    Years2004 – 202320 years with data
    LicenceCC BY 4.0credit the World Bank

    What it measures

    Business/establishment censuses provide valuable information on all economic activities, number of employed and size of establishments in the economy. Business Register information is establishment-based and includes business location, organization type (e.g. subsidiary or parent), industry classification, and operating data (e.g., receipts and employment).

    The numbers in 2023

    In 2023, 190 countries have a value. At the top, 138 countries tie at 1 (e.g. Albania, Andorra, Angola); at the bottom, 47 countries tie at 0 (e.g. Afghanistan, Burundi, Central African Republic). The median country value is 1.

    Highest, 2023

    Ties are listed A to Z.

    #CountryValue
    1Albania1
    2Andorra1
    3Angola1
    4Antigua and Barbuda1
    5Argentina1
    6Armenia1
    7Australia1
    8Austria1
    9Azerbaijan1
    10Bahamas, The1

    Lowest, 2023

    Ties are listed A to Z.

    #CountryValue
    1Zambia0
    2Yemen, Rep.0
    3Venezuela, RB0
    4Tuvalu0
    5Turkmenistan0
    6Trinidad and Tobago0
    7Timor-Leste0
    8Syrian Arab Republic0
    9Sudan0
    10St. Vincent and the Grenadines0
    How many countries report, by decade
    DecadeMost countries in one year
    2000s190
    2010s190
    2020s190

    First rows

    business-establishment-census-availability-score-over-20-years.csv

    countrytextiso3textregiontextincome_grouptextyearnumbervaluenumber
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20040
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20050
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20060
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20070
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20080
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20090
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20100
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20110

    Data dictionary

    ColumnTypeMeaning
    countrytextCountry or economy, World Bank name
    iso3textISO 3166-1 alpha-3 code
    regiontextWorld Bank region
    income_grouptextWorld Bank income group
    yearnumberCalendar year of the value
    valuenumberBusiness/establishment census (Availability score over 20 years), exactly as the World Bank API returns it (not rounded)

    Only country-years with a value are in the long file; blank cells in the wide file mean no value was published.

    Practice questions

    answers computed from the file

    Which country has the highest value in 2023?

    There is a tie: 138 countries share the highest value, 1 (for example Albania, Andorra, Angola).

    Excel (on the long CSV: E = year, F = value)

    =FILTER(A2:A100000,(E2:E100000=2023)*(F2:F100000=MAXIFS(F2:F100000,E2:E100000,2023)))

    SQL (table wb = the CSV)

    SELECT country, value FROM wb WHERE year = 2023
      AND value = (SELECT MAX(value) FROM wb WHERE year = 2023);

    pandas (df = pd.read_csv("business-establishment-census-availability-score-over-20-years.csv"))

    y = df[df.year == 2023]
    y[y.value == y.value.max()][["country", "value"]]

    File: business-establishment-census-availability-score-over-20-years.csv

    How many countries report a value for 2023?

    190 of the 217 economies in the file's country list.

    Excel (on the long CSV: E = year, F = value)

    =COUNTIF(E2:E100000,2023)

    SQL (table wb = the CSV)

    SELECT COUNT(*) FROM wb WHERE year = 2023;

    pandas (df = pd.read_csv("business-establishment-census-availability-score-over-20-years.csv"))

    (df.year == 2023).sum()

    File: business-establishment-census-availability-score-over-20-years.csv

    What is the median across countries in 2023?

    1 (median of the 190 country values; not a World Bank aggregate).

    Excel (on the long CSV: E = year, F = value)

    =MEDIAN(FILTER(F2:F100000,E2:E100000=2023))

    SQL (table wb = the CSV)

    -- SQLite has no MEDIAN(); this picks the middle value(s)
    SELECT AVG(value) FROM (SELECT value FROM wb WHERE year = 2023 ORDER BY value
      LIMIT 2 - (SELECT COUNT(*) FROM wb WHERE year = 2023) % 2
      OFFSET (SELECT (COUNT(*) - 1) / 2 FROM wb WHERE year = 2023));

    pandas (df = pd.read_csv("business-establishment-census-availability-score-over-20-years.csv"))

    df[df.year == 2023]["value"].median()

    File: business-establishment-census-availability-score-over-20-years.csv

    Which country rose the most between 2013 and 2023?

    Albania: from 0 to 1, a rise of 1 (out of 190 countries with both years).

    Excel (on the long CSV: E = year, F = value)

    Use the wide file (business-establishment-census-availability-score-over-20-years-wide.csv): add a column = [2023] - [2013], then sort it largest to smallest.

    SQL (table wb = the CSV)

    SELECT a.country, b.value - a.value AS rise FROM wb a JOIN wb b ON a.iso3 = b.iso3
    WHERE a.year = 2013 AND b.year = 2023 ORDER BY rise DESC LIMIT 1;

    pandas (df = pd.read_csv("business-establishment-census-availability-score-over-20-years.csv"))

    w = df.pivot(index="country", columns="year", values="value")
    (w[2023] - w[2013]).dropna().nlargest(1)

    File: business-establishment-census-availability-score-over-20-years.csv

    Which year has the most countries reporting?

    2023, with 190 countries.

    Excel (on the long CSV: E = year, F = value)

    Make a pivot table: year in Rows, Count of value in Values, then sort by the count.

    SQL (table wb = the CSV)

    SELECT year, COUNT(*) AS n FROM wb GROUP BY year ORDER BY n DESC, year DESC LIMIT 1;

    pandas (df = pd.read_csv("business-establishment-census-availability-score-over-20-years.csv"))

    df.groupby("year").size().sort_values(ascending=False).head(1)

    File: business-establishment-census-availability-score-over-20-years.csv