space_used

400 rows sorted by depth

View and edit SQL

Suggested facets: depth, ovfl_payload, ovfl_cnt, int_pages, ovfl_pages, ovfl_unused, gap_cnt

Link rowid name tblname is_index is_without_rowid nentry leaf_entries depth ▼ payload ovfl_payload ovfl_cnt mx_payload int_pages leaf_pages ovfl_pages int_unused leaf_unused ovfl_unused gap_cnt compressed_size
5 bad-drivers/bad-drivers bad-drivers/bad-drivers 0 0 51 51 1 2322 0 0 57 0 1 0 0 1562 0 0 4096
7 terrorism/eu_terrorism_fatalities_by_year terrorism/eu_terrorism_fatalities_by_year 0 0 29 29 1 180 0 0 7 0 1 0 0 3792 0 0 4096
8 terrorism/country_stats_1993_appendix2 terrorism/country_stats_1993_appendix2 0 0 129 129 1 3037 0 0 35 0 1 0 0 533 0 0 4096
9 terrorism/france_terrorism_fatalities_by_year terrorism/france_terrorism_fatalities_by_year 0 0 43 43 1 242 0 0 6 0 1 0 0 3674 0 0 4096
10 terrorism/eu_terrorism_fatalities_by_country terrorism/eu_terrorism_fatalities_by_country 0 0 45 45 1 916 0 0 24 0 1 0 0 2992 0 0 4096
13 puerto-rico-media/mediacloud_top_online_news puerto-rico-media/mediacloud_top_online_news 0 0 49 49 1 1750 0 0 55 0 1 0 0 2142 0 0 4096
14 puerto-rico-media/tv_states puerto-rico-media/tv_states 0 0 52 52 1 1824 0 0 37 0 1 0 0 2056 0 0 4096
15 puerto-rico-media/tv_hurricanes puerto-rico-media/tv_hurricanes 0 0 37 37 1 1152 0 0 45 0 1 0 0 2788 0 0 4096
16 puerto-rico-media/mediacloud_trump puerto-rico-media/mediacloud_trump 0 0 51 51 1 1154 0 0 26 0 1 0 0 2730 0 0 4096
17 puerto-rico-media/mediacloud_states puerto-rico-media/mediacloud_states 0 0 51 51 1 889 0 0 18 0 1 0 0 2995 0 0 4096
19 puerto-rico-media/mediacloud_hurricanes puerto-rico-media/mediacloud_hurricanes 0 0 38 38 1 621 0 0 20 0 1 0 0 3315 0 0 4096
20 puerto-rico-media/google_trends puerto-rico-media/google_trends 0 0 37 37 1 654 0 0 19 0 1 0 0 3286 0 0 4096
23 scrabble-games/scrabble_games scrabble-games/scrabble_games 0 0 2 2 1 94 0 0 78 0 1 0 0 3986 0 0 4096
24 nfl-wide-receivers/try-per-game-aging-curve nfl-wide-receivers/try-per-game-aging-curve 0 0 24 24 1 336 0 0 14 0 1 0 0 3656 0 0 4096
28 unisex-names/aging_curve unisex-names/aging_curve 0 0 12 12 1 356 0 0 32 0 1 0 0 3684 0 0 4096
30 science-giving/science_federal_giving science-giving/science_federal_giving 0 0 2 2 1 94 0 0 78 0 1 0 0 3986 0 0 4096
33 drug-use-by-age/drug-use-by-age drug-use-by-age/drug-use-by-age 0 0 17 17 1 2611 0 0 173 0 1 0 0 1393 0 0 4096
38 presidential-campaign-trail/clinton presidential-campaign-trail/clinton 0 0 71 71 1 3557 0 0 60 0 1 0 0 247 0 0 4096
41 marriage/divorce marriage/divorce 0 0 17 17 1 2994 0 0 179 0 1 0 0 1009 0 0 4096
61 cousin-marriage/cousin-marriage-data cousin-marriage/cousin-marriage-data 0 0 70 70 1 1257 0 0 26 0 1 0 0 2551 0 0 4096
66 most-common-name/new-top-firstNames most-common-name/new-top-firstNames 0 0 100 100 1 1912 0 0 24 0 1 0 0 1776 0 0 4096
67 most-common-name/adjusted-name-combinations-matrix most-common-name/adjusted-name-combinations-matrix 0 0 20 20 1 2921 0 0 169 0 1 0 0 1070 0 0 4096
68 most-common-name/aging-curve most-common-name/aging-curve 0 0 12 12 1 356 0 0 32 0 1 0 0 3684 0 0 4096
69 most-common-name/new-top-surnames most-common-name/new-top-surnames 0 0 100 100 1 1892 0 0 23 0 1 0 0 1796 0 0 4096
71 most-common-name/adjustments most-common-name/adjustments 0 0 20 20 1 3474 0 0 187 0 1 0 0 514 0 0 4096
72 most-common-name/state-pop most-common-name/state-pop 0 0 51 51 1 1457 0 0 37 0 1 0 0 2427 0 0 4096
74 womens-world-cup-predictions/wwc-matches-20150612-205525 womens-world-cup-predictions/wwc-matches-20150612-205525 0 0 36 36 1 1656 0 0 64 0 1 0 0 2288 0 0 4096
75 womens-world-cup-predictions/wwc-forecast-20150627-213532 womens-world-cup-predictions/wwc-forecast-20150627-213532 0 0 24 24 1 1228 0 0 64 0 1 0 0 2764 0 0 4096
76 womens-world-cup-predictions/wwc-forecast-20150616-190139 womens-world-cup-predictions/wwc-forecast-20150616-190139 0 0 24 24 1 2300 0 0 130 0 1 0 0 1689 0 0 4096
77 womens-world-cup-predictions/wwc-forecast-20150607-150137 womens-world-cup-predictions/wwc-forecast-20150607-150137 0 0 24 24 1 3052 0 0 132 0 1 0 0 929 0 0 4096
78 womens-world-cup-predictions/wwc-forecast-20150612-215533 womens-world-cup-predictions/wwc-forecast-20150612-215533 0 0 24 24 1 2908 0 0 132 0 1 0 0 1077 0 0 4096
79 womens-world-cup-predictions/wwc-matches-20150627-180119 womens-world-cup-predictions/wwc-matches-20150627-180119 0 0 49 49 1 1663 0 0 47 0 1 0 0 2229 0 0 4096
80 womens-world-cup-predictions/wwc-matches-20150615-175745 womens-world-cup-predictions/wwc-matches-20150615-175745 0 0 36 36 1 1464 0 0 62 0 1 0 0 2480 0 0 4096
81 womens-world-cup-predictions/wwc-forecast-20150705-205539 womens-world-cup-predictions/wwc-forecast-20150705-205539 0 0 24 24 1 1164 0 0 52 0 1 0 0 2828 0 0 4096
82 womens-world-cup-predictions/wwc-matches-20150705-205539 womens-world-cup-predictions/wwc-matches-20150705-205539 0 0 52 52 1 1719 0 0 41 0 1 0 0 2161 0 0 4096
83 womens-world-cup-predictions/wwc-forecast-20150615-175745 womens-world-cup-predictions/wwc-forecast-20150615-175745 0 0 24 24 1 2628 0 0 132 0 1 0 0 1360 0 0 4096
84 womens-world-cup-predictions/wwc-forecast-20150627-180119 womens-world-cup-predictions/wwc-forecast-20150627-180119 0 0 24 24 1 1260 0 0 72 0 1 0 0 2732 0 0 4096
85 womens-world-cup-predictions/wwc-matches-20150612-215533 womens-world-cup-predictions/wwc-matches-20150612-215533 0 0 36 36 1 1632 0 0 64 0 1 0 0 2312 0 0 4096
86 womens-world-cup-predictions/wwc-matches-20150607-150137 womens-world-cup-predictions/wwc-matches-20150607-150137 0 0 36 36 1 2016 0 0 64 0 1 0 0 1928 0 0 4096
87 womens-world-cup-predictions/wwc-matches-20150616-190139 womens-world-cup-predictions/wwc-matches-20150616-190139 0 0 36 36 1 1368 0 0 59 0 1 0 0 2576 0 0 4096
88 womens-world-cup-predictions/wwc-matches-20150627-213532 womens-world-cup-predictions/wwc-matches-20150627-213532 0 0 50 50 1 1693 0 0 46 0 1 0 0 2195 0 0 4096
89 womens-world-cup-predictions/wwc-forecast-20150612-205525 womens-world-cup-predictions/wwc-forecast-20150612-205525 0 0 24 24 1 2916 0 0 132 0 1 0 0 1070 0 0 4096
90 womens-world-cup-predictions/wwc-matches-20150617-210614 womens-world-cup-predictions/wwc-matches-20150617-210614 0 0 44 44 1 1611 0 0 51 0 1 0 0 2301 0 0 4096
91 womens-world-cup-predictions/wwc-matches-20150612-235650 womens-world-cup-predictions/wwc-matches-20150612-235650 0 0 36 36 1 1608 0 0 64 0 1 0 0 2336 0 0 4096
92 womens-world-cup-predictions/wwc-forecast-20150611-182114 womens-world-cup-predictions/wwc-forecast-20150611-182114 0 0 24 24 1 3020 0 0 132 0 1 0 0 962 0 0 4096
93 womens-world-cup-predictions/wwc-matches-20150616-220036 womens-world-cup-predictions/wwc-matches-20150616-220036 0 0 36 36 1 1320 0 0 59 0 1 0 0 2624 0 0 4096
94 womens-world-cup-predictions/wwc-matches-20150626-212544 womens-world-cup-predictions/wwc-matches-20150626-212544 0 0 49 49 1 1679 0 0 48 0 1 0 0 2213 0 0 4096
95 womens-world-cup-predictions/wwc-matches-20150612-185329 womens-world-cup-predictions/wwc-matches-20150612-185329 0 0 36 36 1 1680 0 0 64 0 1 0 0 2264 0 0 4096
96 womens-world-cup-predictions/wwc-matches-20150606-200029 womens-world-cup-predictions/wwc-matches-20150606-200029 0 0 36 36 1 2064 0 0 65 0 1 0 0 1880 0 0 4096
97 womens-world-cup-predictions/wwc-matches-20150621-175918 womens-world-cup-predictions/wwc-matches-20150621-175918 0 0 45 45 1 1594 0 0 51 0 1 0 0 2314 0 0 4096
98 womens-world-cup-predictions/wwc-matches-20150630-210243 womens-world-cup-predictions/wwc-matches-20150630-210243 0 0 50 50 1 1677 0 0 46 0 1 0 0 2211 0 0 4096
99 womens-world-cup-predictions/wwc-forecast-20150615-213540 womens-world-cup-predictions/wwc-forecast-20150615-213540 0 0 24 24 1 2452 0 0 130 0 1 0 0 1537 0 0 4096
100 womens-world-cup-predictions/wwc-forecast-20150609-205725 womens-world-cup-predictions/wwc-forecast-20150609-205725 0 0 24 24 1 3012 0 0 132 0 1 0 0 971 0 0 4096
101 womens-world-cup-predictions/wwc-forecast-20150608-212619 womens-world-cup-predictions/wwc-forecast-20150608-212619 0 0 24 24 1 3012 0 0 132 0 1 0 0 971 0 0 4096
102 womens-world-cup-predictions/wwc-matches-20150613-145639 womens-world-cup-predictions/wwc-matches-20150613-145639 0 0 36 36 1 1584 0 0 64 0 1 0 0 2360 0 0 4096
103 womens-world-cup-predictions/wwc-forecast-20150613-145639 womens-world-cup-predictions/wwc-forecast-20150613-145639 0 0 24 24 1 2860 0 0 132 0 1 0 0 1127 0 0 4096
104 womens-world-cup-predictions/wwc-matches-20150608-212619 womens-world-cup-predictions/wwc-matches-20150608-212619 0 0 36 36 1 1920 0 0 64 0 1 0 0 2024 0 0 4096
105 womens-world-cup-predictions/wwc-matches-20150609-205725 womens-world-cup-predictions/wwc-matches-20150609-205725 0 0 36 36 1 1800 0 0 64 0 1 0 0 2144 0 0 4096
106 womens-world-cup-predictions/wwc-matches-20150615-213540 womens-world-cup-predictions/wwc-matches-20150615-213540 0 0 36 36 1 1416 0 0 62 0 1 0 0 2528 0 0 4096
107 womens-world-cup-predictions/wwc-forecast-20150630-210243 womens-world-cup-predictions/wwc-forecast-20150630-210243 0 0 24 24 1 1204 0 0 64 0 1 0 0 2788 0 0 4096
108 womens-world-cup-predictions/wwc-forecast-20150621-175918 womens-world-cup-predictions/wwc-forecast-20150621-175918 0 0 24 24 1 1516 0 0 84 0 1 0 0 2476 0 0 4096
109 womens-world-cup-predictions/wwc-forecast-20150612-185329 womens-world-cup-predictions/wwc-forecast-20150612-185329 0 0 24 24 1 2948 0 0 132 0 1 0 0 1036 0 0 4096
110 womens-world-cup-predictions/wwc-forecast-20150606-200029 womens-world-cup-predictions/wwc-forecast-20150606-200029 0 0 24 24 1 3060 0 0 132 0 1 0 0 920 0 0 4096
111 womens-world-cup-predictions/wwc-forecast-20150626-212544 womens-world-cup-predictions/wwc-forecast-20150626-212544 0 0 24 24 1 1292 0 0 74 0 1 0 0 2700 0 0 4096
112 womens-world-cup-predictions/wwc-matches-20150611-182114 womens-world-cup-predictions/wwc-matches-20150611-182114 0 0 36 36 1 1776 0 0 64 0 1 0 0 2168 0 0 4096
113 womens-world-cup-predictions/wwc-forecast-20150616-220036 womens-world-cup-predictions/wwc-forecast-20150616-220036 0 0 24 24 1 2084 0 0 128 0 1 0 0 1907 0 0 4096
114 womens-world-cup-predictions/wwc-forecast-20150612-235650 womens-world-cup-predictions/wwc-forecast-20150612-235650 0 0 24 24 1 2892 0 0 132 0 1 0 0 1094 0 0 4096
115 womens-world-cup-predictions/wwc-forecast-20150617-210614 womens-world-cup-predictions/wwc-forecast-20150617-210614 0 0 24 24 1 1676 0 0 84 0 1 0 0 2316 0 0 4096
116 womens-world-cup-predictions/wwc-forecast-20150608-235509 womens-world-cup-predictions/wwc-forecast-20150608-235509 0 0 24 24 1 2996 0 0 132 0 1 0 0 987 0 0 4096
117 womens-world-cup-predictions/wwc-forecast-20150609-175933 womens-world-cup-predictions/wwc-forecast-20150609-175933 0 0 24 24 1 3028 0 0 132 0 1 0 0 954 0 0 4096
118 womens-world-cup-predictions/wwc-matches-20150611-232844 womens-world-cup-predictions/wwc-matches-20150611-232844 0 0 36 36 1 1704 0 0 64 0 1 0 0 2240 0 0 4096
119 womens-world-cup-predictions/wwc-matches-20150620-213513 womens-world-cup-predictions/wwc-matches-20150620-213513 0 0 44 44 1 1579 0 0 51 0 1 0 0 2333 0 0 4096
120 womens-world-cup-predictions/wwc-forecast-20150622-215702 womens-world-cup-predictions/wwc-forecast-20150622-215702 0 0 24 24 1 1396 0 0 84 0 1 0 0 2596 0 0 4096
121 womens-world-cup-predictions/wwc-matches-20150609-145605 womens-world-cup-predictions/wwc-matches-20150609-145605 0 0 36 36 1 1872 0 0 64 0 1 0 0 2072 0 0 4096
122 womens-world-cup-predictions/wwc-matches-20150617-175941 womens-world-cup-predictions/wwc-matches-20150617-175941 0 0 36 36 1 1272 0 0 59 0 1 0 0 2672 0 0 4096
123 womens-world-cup-predictions/wwc-matches-20150626-184421 womens-world-cup-predictions/wwc-matches-20150626-184421 0 0 48 48 1 1651 0 0 48 0 1 0 0 2245 0 0 4096
124 womens-world-cup-predictions/wwc-forecast-20150606-230045 womens-world-cup-predictions/wwc-forecast-20150606-230045 0 0 24 24 1 3052 0 0 132 0 1 0 0 929 0 0 4096
125 womens-world-cup-predictions/wwc-matches-20150607-180420 womens-world-cup-predictions/wwc-matches-20150607-180420 0 0 36 36 1 1992 0 0 64 0 1 0 0 1952 0 0 4096
126 womens-world-cup-predictions/wwc-forecast-20150611-210229 womens-world-cup-predictions/wwc-forecast-20150611-210229 0 0 24 24 1 2972 0 0 132 0 1 0 0 1011 0 0 4096
127 womens-world-cup-predictions/wwc-matches-20150622-185345 womens-world-cup-predictions/wwc-matches-20150622-185345 0 0 46 46 1 1609 0 0 50 0 1 0 0 2295 0 0 4096
128 womens-world-cup-predictions/wwc-matches-20150613-205441 womens-world-cup-predictions/wwc-matches-20150613-205441 0 0 36 36 1 1512 0 0 62 0 1 0 0 2432 0 0 4096
129 womens-world-cup-predictions/wwc-matches-20150608-175420 womens-world-cup-predictions/wwc-matches-20150608-175420 0 0 36 36 1 1968 0 0 64 0 1 0 0 1976 0 0 4096
130 womens-world-cup-predictions/wwc-forecast-20150608-175420 womens-world-cup-predictions/wwc-forecast-20150608-175420 0 0 24 24 1 3036 0 0 132 0 1 0 0 946 0 0 4096
131 womens-world-cup-predictions/wwc-forecast-20150613-205441 womens-world-cup-predictions/wwc-forecast-20150613-205441 0 0 24 24 1 2780 0 0 132 0 1 0 0 1208 0 0 4096
132 womens-world-cup-predictions/wwc-forecast-20150622-185345 womens-world-cup-predictions/wwc-forecast-20150622-185345 0 0 24 24 1 1436 0 0 84 0 1 0 0 2556 0 0 4096
133 womens-world-cup-predictions/wwc-matches-20150611-210229 womens-world-cup-predictions/wwc-matches-20150611-210229 0 0 36 36 1 1728 0 0 64 0 1 0 0 2216 0 0 4096
134 womens-world-cup-predictions/wwc-forecast-20150607-180420 womens-world-cup-predictions/wwc-forecast-20150607-180420 0 0 24 24 1 3036 0 0 132 0 1 0 0 946 0 0 4096
135 womens-world-cup-predictions/wwc-forecast-20150626-184421 womens-world-cup-predictions/wwc-forecast-20150626-184421 0 0 24 24 1 1324 0 0 74 0 1 0 0 2668 0 0 4096
136 womens-world-cup-predictions/wwc-matches-20150606-230045 womens-world-cup-predictions/wwc-matches-20150606-230045 0 0 36 36 1 2040 0 0 64 0 1 0 0 1904 0 0 4096
137 womens-world-cup-predictions/wwc-forecast-20150617-175941 womens-world-cup-predictions/wwc-forecast-20150617-175941 0 0 24 24 1 1876 0 0 124 0 1 0 0 2116 0 0 4096
138 womens-world-cup-predictions/wwc-forecast-20150609-145605 womens-world-cup-predictions/wwc-forecast-20150609-145605 0 0 24 24 1 3004 0 0 132 0 1 0 0 978 0 0 4096
139 womens-world-cup-predictions/wwc-matches-20150622-215702 womens-world-cup-predictions/wwc-matches-20150622-215702 0 0 47 47 1 1635 0 0 50 0 1 0 0 2265 0 0 4096
140 womens-world-cup-predictions/wwc-forecast-20150620-213513 womens-world-cup-predictions/wwc-forecast-20150620-213513 0 0 24 24 1 1596 0 0 84 0 1 0 0 2396 0 0 4096
141 womens-world-cup-predictions/wwc-forecast-20150611-232844 womens-world-cup-predictions/wwc-forecast-20150611-232844 0 0 24 24 1 2948 0 0 132 0 1 0 0 1036 0 0 4096
142 womens-world-cup-predictions/wwc-matches-20150609-175933 womens-world-cup-predictions/wwc-matches-20150609-175933 0 0 36 36 1 1824 0 0 64 0 1 0 0 2120 0 0 4096
143 womens-world-cup-predictions/wwc-matches-20150608-235509 womens-world-cup-predictions/wwc-matches-20150608-235509 0 0 36 36 1 1896 0 0 64 0 1 0 0 2048 0 0 4096
144 womens-world-cup-predictions/wwc-forecast-20150621-145724 womens-world-cup-predictions/wwc-forecast-20150621-145724 0 0 24 24 1 1556 0 0 84 0 1 0 0 2436 0 0 4096
145 womens-world-cup-predictions/wwc-matches-20150623-235546 womens-world-cup-predictions/wwc-matches-20150623-235546 0 0 48 48 1 1667 0 0 48 0 1 0 0 2229 0 0 4096
146 womens-world-cup-predictions/wwc-forecast-20150621-213134 womens-world-cup-predictions/wwc-forecast-20150621-213134 0 0 24 24 1 1476 0 0 84 0 1 0 0 2516 0 0 4096
147 womens-world-cup-predictions/wwc-matches-20150613-175552 womens-world-cup-predictions/wwc-matches-20150613-175552 0 0 36 36 1 1536 0 0 64 0 1 0 0 2408 0 0 4096

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE space_used(
   name clob,        -- Name of a table or index in the database file
   tblname clob,     -- Name of associated table
   is_index boolean, -- TRUE if it is an index, false for a table
   is_without_rowid boolean, -- TRUE if WITHOUT ROWID table  
   nentry int,       -- Number of entries in the BTree
   leaf_entries int, -- Number of leaf entries
   depth int,        -- Depth of the b-tree
   payload int,      -- Total amount of data stored in this table or index
   ovfl_payload int, -- Total amount of data stored on overflow pages
   ovfl_cnt int,     -- Number of entries that use overflow
   mx_payload int,   -- Maximum payload size
   int_pages int,    -- Number of interior pages used
   leaf_pages int,   -- Number of leaf pages used
   ovfl_pages int,   -- Number of overflow pages used
   int_unused int,   -- Number of unused bytes on interior pages
   leaf_unused int,  -- Number of unused bytes on primary pages
   ovfl_unused int,  -- Number of unused bytes on overflow pages
   gap_cnt int,      -- Number of gaps in the page layout
   compressed_size int  -- Total bytes stored on disk
);
Powered by Datasette · Query took 63.848ms