pickupdate_street (view)
367,160 rows
This data as json, v1_json, CSV (advanced)
Suggested facets: start (date), end (date)
street | zipcode | start | end | district | summary |
---|---|---|---|---|---|
Aachener Straße | 70376 | 2015-12-29 | 2015-12-30 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2016-01-19 | 2016-01-20 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2016-02-09 | 2016-02-10 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2016-03-01 | 2016-03-02 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2016-03-22 | 2016-03-23 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2016-04-12 | 2016-04-13 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2016-05-03 | 2016-05-04 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2016-05-24 | 2016-05-25 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2016-06-14 | 2016-06-15 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2016-07-05 | 2016-07-06 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2016-07-26 | 2016-07-27 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2016-08-16 | 2016-08-17 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2016-09-06 | 2016-09-07 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2016-09-27 | 2016-09-28 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2016-10-18 | 2016-10-19 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2016-11-08 | 2016-11-09 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2016-11-29 | 2016-11-30 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2016-12-20 | 2016-12-21 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2017-01-10 | 2017-01-11 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2017-10-01 | 2017-10-02 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2017-01-31 | 2017-02-01 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2017-02-21 | 2017-02-22 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2017-03-14 | 2017-03-15 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2017-04-04 | 2017-04-05 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2017-04-25 | 2017-04-26 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2017-05-16 | 2017-05-17 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2017-06-06 | 2017-06-07 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2017-06-27 | 2017-06-28 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2017-07-18 | 2017-07-19 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2017-08-08 | 2017-08-09 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2017-08-29 | 2017-08-30 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2017-09-19 | 2017-09-20 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2017-10-10 | 2017-10-11 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2017-10-28 | 2017-10-29 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2017-11-21 | 2017-11-22 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2017-12-12 | 2017-12-13 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2018-01-03 | 2018-01-04 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2018-01-23 | 2018-01-24 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2018-02-13 | 2018-02-14 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2018-03-06 | 2018-03-07 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2018-03-27 | 2018-03-28 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2018-04-17 | 2018-04-18 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2018-05-08 | 2018-05-09 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2018-05-29 | 2018-05-30 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2018-06-19 | 2018-06-20 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2018-07-10 | 2018-07-11 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2018-07-31 | 2018-08-01 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2018-08-21 | 2018-08-22 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2018-09-11 | 2018-09-12 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2018-10-02 | 2018-10-03 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2018-10-23 | 2018-10-24 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2018-11-13 | 2018-11-14 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2018-12-04 | 2018-12-05 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2018-12-24 | 2018-12-25 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2019-01-15 | 2019-01-16 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2019-02-05 | 2019-02-06 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2019-02-26 | 2019-02-27 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2019-03-19 | 2019-03-20 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2019-04-09 | 2019-04-10 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2019-04-30 | 2019-05-01 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2019-05-21 | 2019-05-22 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2019-06-11 | 2019-06-12 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2019-07-02 | 2019-07-03 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2019-07-23 | 2019-07-24 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2019-08-13 | 2019-08-14 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2019-09-03 | 2019-09-04 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2019-09-24 | 2019-09-25 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2019-10-15 | 2019-10-16 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2019-11-05 | 2019-11-06 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2019-11-26 | 2019-11-27 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2019-12-17 | 2019-12-18 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2020-01-07 | 2020-01-08 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2020-01-28 | 2020-01-29 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2020-02-18 | 2020-02-19 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2020-03-10 | 2020-03-11 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2020-03-31 | 2020-04-01 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2020-04-21 | 2020-04-22 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2020-05-12 | 2020-05-13 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2020-06-02 | 2020-06-03 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2020-06-23 | 2020-06-24 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2020-07-14 | 2020-07-15 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2020-08-04 | 2020-08-05 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2020-08-25 | 2020-08-26 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2020-09-15 | 2020-09-16 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2020-10-06 | 2020-10-07 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2020-10-27 | 2020-10-28 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2020-11-17 | 2020-11-18 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2020-12-08 | 2020-12-09 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2020-12-29 | 2020-12-30 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2021-01-19 | 2021-01-20 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2021-02-09 | 2021-02-10 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2021-03-02 | 2021-03-03 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2021-03-23 | 2021-03-24 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2021-04-13 | 2021-04-14 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2021-05-04 | 2021-05-05 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2021-05-25 | 2021-05-26 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2021-06-15 | 2021-06-16 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2021-07-06 | 2021-07-07 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2021-07-27 | 2021-07-28 | Bad Cannstatt | Gelber Sack Abholtermin |
Aachener Straße | 70376 | 2021-08-17 | 2021-08-18 | Bad Cannstatt | Gelber Sack Abholtermin |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW pickupdate_street as select s.name as street, z.zipcode as zipcode, pickupdate.date as start, date(pickupdate.date, "+1 day") as end, d.name as district, "Gelber Sack Abholtermin" as summary from pickupdate join area as a on pickupdate.area_id=a.id join zipcode as z on s.zipcode_id=z.id join street as s on a.id=s.schaalundmueller_district_id join district as d on s.district_id=d.id;