Considerations...

The US census includes cities ("places"). The questions asked (the data collected), and geographic levels covered, vary somewhat by census.

Some of the larger cities are developing data portals (to both tabulated and raw datasets)

There are also several agencies/organizations collecting city-level statistics.

Selected data sources for urban areas