Smart Bin Sensor Fill Levels

This dataset provides granular IoT sensor readings from urban smart waste bins, including fill levels, geolocation, bin status, and overflow alerts. It enables city planners and public sector analysts to optimize waste collection routes, prevent bin overflow, and improve sustainability through data-driven decisions. The comprehensive structure supports geospatial analysis, operational monitoring, and predictive maintenance.

  • opened 28 times
  • last updated 29 Oct 2025
  • by GoMask
The brief that made it

Optimizing waste collection routes using real-time bin fill levels

Sample rows

preview · 8 of 120 rows · all 16 columns
bin_idstringbin_statusstringbattery_level_percentfloatoverflow_alertbooleanaddress_countrystringsensor_idstringreading_idstringtimestampdatetimefill_level_percentfloatbin_typestringlocation_latitudefloatlocation_longitudefloataddress_streetstringaddress_citystringaddress_statestringaddress_postal_codestring
BIN-001active83.5falseUSASNSR-1001READ-000012024-06-03T07:34:15Z12.3general40.7128-74.006123 BroadwayNew YorkNY10007
BIN-002active61.2falseUKSNSR-1002READ-000022024-06-03T09:21:47Z69.4recycling51.5074-0.1278456 PiccadillyLondonEnglandW1J 9HS
BIN-003maintenance17.8trueJapanSNSR-1003READ-000032024-06-03T11:10:32Z95.1organic35.6895139.6917789 ShibuyaTokyoTokyo150-0002
BIN-004out_of_service13.4falseGermanySNSR-1004READ-000042024-06-03T13:58:06Z8.6hazardous52.5213.40523 AlexanderplatzBerlinBE10178
BIN-005active58.7falseAustraliaSNSR-1005READ-000052024-06-03T15:46:51Z46.2other-33.8688151.209355 George StSydneyNSW2000
BIN-006maintenance21trueFranceSNSR-1006READ-000062024-06-03T17:00:19Z91.4general48.85662.352210 Rue de RivoliParisIDF75001
BIN-007active47.1falseUSASNSR-1007READ-000072024-06-03T19:18:05Z33.9recycling34.0522-118.2437210 Main StLos AngelesCA90012
BIN-008active35.4falseRussiaSNSR-1008READ-000082024-06-03T20:45:12Z57.8organic55.755837.61737 Tverskaya StMoscowMOW101000

What the 120 rows show

from the 120-row sample

Active (bin status) stands out: mean battery_level_percent is 54.5, against 13.6 for the rest.

  • 24%overflow_alert = true
  • 38.8median battery_level_percent
  • 5bin types
  • 59.9median fill_level_percent
Mean battery_level_percent by bin_status120 rows
05010054.5active77 rows10.3out_of_servi…18 rows16.0maintenance25 rows
battery_level_percent120 rows, in bands of 10
020409331011141611673050100battery_level_percent →

Median 38.8, from 0.0 to 97.5.

address_country120 rows · top 10 of 38 values
  1. USA13
  2. Japan9
  3. Germany7
  4. China6
  5. UK5
  6. Brazil5
  7. Canada5
  8. Spain5
  9. Australia4
  10. Italy4
16 columns by typefrom the column list below
  • string 10
  • float 4
  • datetime 1
  • boolean 1

Columns

16 columns in four groups
blueprint · 16 columns
columntypedescriptionexample
Text 10 columns
bin_idstringUnique identifier for each smart waste binuniqueBIN-001
sensor_idstringUnique identifier for the IoT sensor installed in the binSNSR-1001
reading_idstringUnique identifier for each sensor readinguniqueREAD-00001
bin_typestringType of waste bin (e.g., general, recycling, organic)general · recycling · organic · hazardous · othergeneral
address_streetstringStreet address of the bin's locationoptional123 Broadway
address_citystringCity where the bin is locatedoptionalNew York
address_statestringState or region where the bin is locatedoptionalNY
address_postal_codestringPostal code of the bin's locationoptional10007
address_countrystringCountry where the bin is locatedoptionalUSA
bin_statusstringOperational status of the bin (e.g., active, out_of_service, maintenance)active · out_of_service · maintenance · optionalactive
Numbers 4 columns
fill_level_percentfloatCurrent fill level of the bin as a percentage (0-100)0 to 10012.3
location_latitudefloatLatitude coordinate of the bin's location-90 to 9040.7128
location_longitudefloatLongitude coordinate of the bin's location-180 to 180-74.006
battery_level_percentfloatCurrent battery level of the sensor as a percentage (0-100)0 to 100 · optional83.5
Dates and times 1 column
timestampdatetimeDate and time when the sensor reading was recorded2024-06-03T07:34:15Z
True or false 1 column
overflow_alertbooleanIndicates if the bin is overflowing based on sensor readingoptionalfalse

15 SQL practice questions for the Smart Bin Sensor Fill Levels

Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.

  1. 01BeginnerFreeSELECT · WHERE · ORDER BY

    Bins with overflow alerts

    Return bin_id, address_city and fill_level_percent for every bin where overflow_alert equals 1. Sort by fill_level_percent from highest to lowest, then by bin_id in ascending order.

    Tables: smart_bin_sensor_fill_levels · your result: 3 columns, 29 rows
  2. 02BeginnerFreeDISTINCT · ORDER BY

    Distinct bin types

    Return each distinct bin_type value once, in a single column named bin_type, sorted alphabetically.

    Tables: smart_bin_sensor_fill_levels · your result: 1 columns, 5 rows
  3. 03BeginnerFreeGROUP BY · COUNT

    Bins per status

    Count the bins in each bin_status. Return bin_status and bin_count, ordered by bin_count from highest to lowest, then by bin_status in ascending order.

    Tables: smart_bin_sensor_fill_levels · your result: 2 columns, 3 rows
  1. 04Average fill by bin typeBeginner
  2. 05Card: bins with low batteryPower BI
  3. 06Countries with many binsIntermediate
  4. 07Fill level bucketsIntermediate
  5. 08Bins fuller than averageIntermediate
  6. 09Readings per dayIntermediate
  7. 10Table: cities above average fillPower BI
  8. 11Rank bins within typeAdvanced
  9. 12Fill change vs previous readingAdvanced
  10. 13Running alert total by dayAdvanced
  11. 14Share of bins by countryAdvanced
  12. 15Table: fill vs type averagePower BI

Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.

Get the practice kit · $3.99

Use it for

  • overflow alert24%29 of 120 rowsmean battery level pe…54.5active10.3out_of…16.0mainte…

    A government dashboard

    The overflow_alert rate, battery_level_percent by bin_status and a breakdown of address_country. Excel, Power BI or Tableau.

  • Why do the 77 active rows have a mean battery_level_percent of 54.5?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable bins with sensor_id, reading_id and timestamp to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 16 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset120 rows16 columns
Yours1,000 rows16 columnslocation_latitude: UK only

blueprint · smart-bin-sensor-fill-levels

Behind this dataset

Same schema. As many rows as you need.

These 120 rows came out of a blueprint — 16 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Each row represents a single waste bin sensor reading event.
  • Fill level recorded as percentage (0-100%).
  • Bin ID, location type (commercial, residential, public space), and timestamp required for each entry.
  • Overflow alerts flagged when fill level exceeds 95%.
  • Weather conditions logged with each reading to assess environmental impact.
  • Collection status noted (collected/not collected).
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
smart-bin-sensor-fill-levels

What should your data show?

Preview 20 rows free
No signup. No card.