home / cp40x

Row counts

How many cases, names, places, and rolls

Custom SQL query returning 4 rows (hide)

SELECT 'cases' AS table_name, COUNT(*) AS n FROM cases
UNION ALL
SELECT 'names', COUNT(*) FROM names
UNION ALL
SELECT 'places', COUNT(*) FROM places
UNION ALL
SELECT 'rolls', COUNT(*) FROM rolls

Edit SQL

This data as json, CSV

table_namen
cases 646925
names 2049671
places 238900
rolls 138
Powered by Datasette · Queries took 56.532ms