DataBrighten

    Sample restaurant sales data

    1,000 × 11rows × columns in the 1,000-row file

    Updated 3 November 2026. Fictional U.S. businesses and people, generated with a fixed seed.

    CSV XLSX JSON SQL
    textnumberdateyes/no
    Largest file10,000rows; also 100 and 1,000
    Columns11with a data dictionary below
    Dates2024-01-01 – 2024-12-29range in the file
    LicenceCC0synthetic, free for any use

    What is in it

    Each row is one line on a ticket at a fictional restaurant in 2024: ticket number, date and time, item, category, quantity, price and line total, dine-in/takeout/delivery and payment method.

    First rows

    point at a column to light it up

    order_line_idtextorder_idtextdatedatetimetextitemtextcategorytextquantitynumberunit_pricenumberline_totalnumberorder_typetextpayment_methodtext
    L1000001T0500012024-04-2914:39CheeseburgerBurgers11313DeliveryCard
    L1000002T0500012024-04-2914:39Margherita PizzaPizza11414DeliveryCard
    L1000003T0500012024-04-2914:39Veggie PizzaPizza11515DeliveryCard
    L1000004T0500022024-06-0212:22SodaDrinks22.55TakeoutCard
    L1000005T0500022024-06-0212:22FriesSides14.54.5TakeoutCard
    L1000006T0500022024-06-0212:22CheeseburgerBurgers11313TakeoutCard
    L1000007T0500032024-12-0420:39Pepperoni PizzaPizza21632TakeoutCash
    L1000008T0500042024-03-2513:22Margherita PizzaPizza11414Dine-inCard
    L1000009T0500042024-03-2513:22FriesSides34.513.5Dine-inCard
    L1000010T0500052024-11-1918:36Margherita PizzaPizza11414Dine-inCard

    Revenue by menu category

    USD, 1,000-row file

    Pizza$5,676Burgers$2,413Sandwiches$1,841Salads$1,259Sides$956Drinks$702Desserts$538Soups$292
    Show as a table
    categoryvalue
    Pizza$5,676
    Burgers$2,413
    Sandwiches$1,841
    Salads$1,259
    Sides$956
    Drinks$702
    Desserts$538
    Soups$292
    Source: DataBrighten synthetic data (seed 42), computed from the file you can download here.

    Data dictionary

    ColumnTypeMeaning
    order_line_idtextLine number, unique
    order_idtextTicket number (several lines can share it)
    datedateOrder date (2024)
    timetextOrder time HH:MM
    itemtextMenu item
    categorytextMenu category
    quantityintegerUnits
    unit_pricedecimalMenu price (USD)
    line_totaldecimalquantity x unit_price
    order_typetextDine-in, Takeout or Delivery
    payment_methodtextCard, Cash or App

    Practice questions

    answers checked in SQL and in Python

    Revenue by menu category?

    Pizza $5,676.00; Burgers $2,413.00; Sandwiches $1,841.00; Salads $1,259.00; Sides $956.50; Drinks $702.00; Desserts $538.50; Soups $292.50

    Excel

    =SUMIFS(I:I,F:F,"Pizza")

    SQL

    SELECT category, ROUND(SUM(line_total),2) AS v FROM restaurant_orders GROUP BY category ORDER BY v DESC

    File: restaurant-orders-1000

    How many tickets are there, and what is the average ticket value?

    429 tickets, average $31.88

    SQL

    SELECT COUNT(DISTINCT order_id), ROUND(SUM(line_total)/COUNT(DISTINCT order_id),2) FROM restaurant_orders

    A ticket (order_id) has several lines, so count distinct order_id values; in Excel 365 use =COUNTA(UNIQUE(B2:B1001)).

    File: restaurant-orders-1000