Useful SQL queries to run against the census DB: ================================================ SQLite version 3.12.2 2016-04-19 15:16:33 Enter ".help" for usage hints. sqlite> .timer on sqlite> .mode columns Distinct still-life counts: sqlite> SELECT prefix, count(distinct(code)) FROM census WHERE rule = "b3s23" AND symmetry = "C1" AND type = "xs" GROUP BY prefix ORDER BY p; xs4 2 xs5 1 xs6 5 xs7 4 xs8 9 xs9 10 xs10 25 xs11 46 xs12 121 xs13 240 xs14 616 xs15 1252 xs16 2465 xs17 4127 xs18 6315 xs19 8274 xs20 9893 xs21 10393 xs22 10252 xs23 8732 xs24 7382 xs25 5185 xs26 3764 xs27 2385 xs28 1539 xs29 871 xs30 588 xs31 256 xs32 154 xs33 78 xs34 62 xs35 20 xs36 18 xs37 9 xs38 7 xs39 2 xs40 5 xs41 2 xs42 3 xs45 1 Run Time: real 3.447 user 3.120000 sys 0.328000 Distinct spaceship counts: sqlite> SELECT prefix, count(distinct(code)) FROM census WHERE rule = "b3s23" AND symmetry = "C1" AND type = "xq" GROUP BY prefix ORDER BY p; xq4 41 xq16 1 Run Time: real 3.152 user 2.776000 sys 0.374000 Distinct oscillator counts: sqlite> SELECT prefix, count(distinct(code)) FROM census WHERE rule = "b3s23" AND symmetry = "C1" AND type = "xp" GROUP BY prefix ORDER BY p; xp2 1498 xp3 249 xp4 27 xp5 8 xp6 7 xp8 6 xp14 1 xp15 13 xp24 2 xp30 18 xp46 3 Run Time: real 3.166 user 2.652000 sys 0.515000 Distinct linear-growth pattern count: sqlite> SELECT count(distinct(code)) FROM census WHERE rule = "b3s23" AND symmetry = "C1" AND type = "yl"; 20 Run Time: real 6.336 user 2.683000 sys 0.483000 Total number of objects in higher symmetries of B3/S23: sqlite> SELECT sum(count) FROM census WHERE rule = "b3s23" AND symmetry != "C1"; 3538585356813 Run Time: real 0.453 user 0.219000 sys 0.078000 Number of distinct objects in higher symmetries of B3/S23: sqlite> SELECT count(distinct(code)) FROM census WHERE rule = "b3s23" AND symmetry != "C1"; 121109 Run Time: real 1.729 user 0.795000 sys 0.125000 Top 100 most common objects: sqlite> .width 60 -15 sqlite> SELECT code, count FROM census WHERE rule = "b3s23" AND symmetry = "C1" ORDER BY count DESC LIMIT 100; xs4_33 31431858269206 xp2_7 29191718455976 xs6_696 16657531111543 xq4_153 8936480327882 xs7_2596 4914760808410 xs5_253 4543683765120 xs6_356 3130488561120 xs4_252 989382618575 xs8_6996 962374101895 xs7_25ac 318715101099 xp2_7e 222722080416 xs12_g8o653z11 161695484163 xp2_318c 69649628809 xs6_25a4 66938022712 xs14_g88m952z121 54761071410 xs8_69ic 24659281634 xs7_178c 15884143627 xq4_6frc 13060857809 xs8_25ak8 8948491851 xs6_39c 7731068986 xp3_co9nas0san9oczgoldlo0oldlogz1047210127401 7175764241 xs14_69bqic 4489163602 xq4_27dee6 3441269905 xs8_35ac 3055283138 xs9_31ego 2812302760 xs8_3pm 2425516100 xs10_g8o652z01 2376145858 xs6_bd 2124544506 xs14_g88b96z123 2122857147 xs16_g88m996z1221 1848147375 xs9_178ko 1015831164 xs11_g8o652z11 840016973 xs9_4aar 799356603 xs10_35ako 651651204 xq4_27deee6 598048142 xs9_25ako 583554501 xs8_178k8 550788358 xs12_raar 412266238 xs18_rhe0ehr 389296167 xs8_312ko 341740880 xs16_j1u0696z11 256992070 xs14_6970796 252235361 xs15_354cgc453 226399609 xs10_32qr 184355082 xs14_j1u066z11 167711675 xs16_69egmiczx1 134789205 xs10_178kk8 111494520 xs17_2ege1ege2 106189500 xs10_69ar 91250483 xs7_3lo 89941120 xs14_69bo8a6 88538999 xp15_4r4z4r4 77243223 xs14_39e0e93 72322736 xs9_178kc 58391447 xs14_6is079c 57500243 xs11_g0s453z11 56155911 xs20_3lkkl3z32w23 51756002 xs12_330f96 50004243 xs11_ggm952z1 48654895 xs10_358gkc 47936903 xs14_69e0eic 46519547 xp2_2a54 45029483 xs12_330fho 43663774 yl144_1_16_afb5f3db909e60548f086e22ee3353ac 40317884 xs10_g0s252z11 39376041 xs10_0drz32 35595611 xs14_39e0eic 32913702 xs12_178c453 32087213 xs12_178br 32036908 xs15_j1u06a4z11 31949354 xs12_3hu066 29980263 xs8_31248c 29669930 xs10_3215ac 27592285 xs9_312453 26519856 xs13_g88m96z121 26339841 xs15_259e0eic 22088842 xs10_3542ac 21245634 xs9_25a84c 21141627 xs14_39e0e96 21111888 xs8_32qk 21056646 xs11_69lic 20637501 xs9_g0g853z11 16918859 xs11_178jd 16664147 xs13_4a960ui 16611221 xs11_178kic 16541225 xs16_69bob96 16529418 xs10_1784ko 15877790 xs15_3lkm96z01 15067314 xs18_69is0si96 14830906 xs14_g8o0e96z121 14779931 yl384_1_59_7aeb1999980c43b4945fb7fcdb023326 14529933 xs16_259e0e952 14462377 xs13_69e0mq 13226742 xs12_256o8a6 12443373 xs12_2egm93 11896620 xs12_6960ui 11768246 xs11_2530f9 11467064 xs10_ggka52z1 10660383 xs15_3lk453z121 10005254 xs14_6960uic 9878447 Run Time: real 3.067 user 2.792000 sys 0.266000 Top 100 objects with names: sqlite> .width 60 60 -15 sqlite> .mode column sqlite> .timer on sqlite> SELECT census.code, names.name, census.count FROM census NATURAL JOIN names WHERE rule = "b3s23" AND symmetry = "C1" ORDER BY count DESC LIMIT 100; xs4_33 block 32346135375036 xp2_7 blinker 30040673527202 xs6_696 beehive 17142030894022 xq4_153 glider 9196394682326 xs7_2596 loaf 5057700600783 xs5_253 boat 4675841706589 xs6_356 ship 3221543433163 xs4_252 tub 1018159566258 xs8_6996 pond 990363256475 xs7_25ac long boat 327984263805 xp2_7e toad 229199229775 xs12_g8o653z11 ship-tie 166397824412 xp2_318c beacon 71675136771 xs6_25a4 barge 68885032807 xs14_g88m952z121 half-bakery 56353538554 xs8_69ic mango 25376421781 xs7_178c eater 16346075189 xq4_6frc lightweight spaceship 13440740280 xs8_25ak8 long barge 9208709021 xs6_39c carrier 7955912827 xp3_co9nas0san9oczgoldlo0oldlogz1047210127401 pulsar 7384431477 xs14_69bqic paperclip 4619698481 xq4_27dee6 middleweight spaceship 3541345010 xs8_35ac long ship 3144150083 xs9_31ego integral sign 2894072293 xs8_3pm shillelagh 2496064267 xs10_g8o652z01 boat-tie 2445246447 xs6_bd snake 2186339484 xs14_g88b96z123 big S 2184604279 xs16_g88m996z1221 bipond 1901902476 xs9_178ko trans boat with tail 1045383411 xs11_g8o652z11 boat tie ship 864452261 xs9_4aar hat 822602594 xs10_35ako very long ship 670603868 xq4_27deee6 heavyweight spaceship 615443270 xs9_25ako very long boat 600522182 xs8_178k8 twit 566802718 xs12_raar table on table 424256525 xs18_rhe0ehr dead spark coil 400624347 xs8_312ko canoe 351682016 xs16_j1u0696z11 beehive on dock 264465718 xs14_6970796 cis-mirrored R-bee 259571475 xs15_354cgc453 moose antlers 232982944 xs10_32qr block on table 189714102 xs14_j1u066z11 block on dock 172589103 xs16_69egmiczx1 scorpion 138711171 xs10_178kk8 beehive with tail 114736399 xs17_2ege1ege2 twin hat 109278246 xs10_69ar loop 93903025 xs7_3lo python 92555687 xs14_69bo8a6 fourteener 91114189 xp15_4r4z4r4 pentadecathlon 79489011 xs14_39e0e93 bookends 74426597 xs9_178kc cis boat with tail 60088365 xs14_6is079c cis-rotated hook 59173529 xs11_g0s453z11 elevener 57789732 xs20_3lkkl3z32w23 mirrored dock 53259568 xs12_330f96 block and cap 51457751 xs11_ggm952z1 trans loaf with tail 50069628 xs10_358gkc cis-shillelagh 49329873 xs14_69e0eic trans-mirrored R-bee 47874195 xp2_2a54 clock 46339289 xs12_330fho trans block and longhook 44932831 yl144_1_16_afb5f3db909e60548f086e22ee3353ac block-laying switch engine 41492012 xs10_g0s252z11 prodigal 40520681 xs10_0drz32 broken snake 36630210 xs14_39e0eic trans-hook and R-bee 33869318 xs12_178c453 eater with nine 33021280 xs12_178br block and two tails 32968520 xs15_j1u06a4z11 cis-boat and dock 32877008 xs12_3hu066 cis block and longhook 30852135 xs8_31248c very long snake 30533354 xs10_3215ac boat with long tail 28394364 xs9_312453 long shillelagh 27291567 xs13_g88m96z121 beehive at loaf 27105971 xs15_259e0eic trans R-bee and R-loaf 22731503 xs10_3542ac long integral 21863072 xs9_25a84c tub with long tail 21757026 xs14_39e0e96 cis-hook and R-bee 21725181 xs8_32qk hook with tail 21670294 xs11_69lic loaf siamese loaf 21236742 xs9_g0g853z11 long canoe 17411452 xs11_178jd 11-loop 17148117 xs13_4a960ui ortho loaf and table 17094692 xs11_178kic cis loaf with tail 17022708 xs16_69bob96 symmetric scorpion 17009789 xs10_1784ko claw with tail 16339328 xs15_3lkm96z01 bee-hat 15505570 xs18_69is0si96 [cis-mirrored R-mango] 15261083 xs14_g8o0e96z121 trans-rotated R-bee 15210179 yl384_1_59_7aeb1999980c43b4945fb7fcdb023326 glider-producing switch engine 14952305 xs16_259e0e952 cis-mirrored R-loaf 14883770 xs13_69e0mq R-bee and snake 13612187 xs12_256o8a6 eater on boat 12804874 xs12_2egm93 snorkel loop 12242007 xs12_6960ui beehive and table 12109620 xs11_2530f9 cis boat and table 11800918 xs10_ggka52z1 trans barge with tail 10970956 xs15_3lk453z121 trans boat and dock 10296252 xs14_6960uic beehive with cap 10165601 Run Time: real 3.248 user 2.823000 sys 0.421000 Naturally-occurring high-period oscillators: sqlite> SELECT code, count FROM census WHERE rule = "b3s23" AND symmetry = "C1" AND type = "xp" AND p > 4 ORDER BY count DESC; xp15_4r4z4r4 77243223 xp8_gk2gb3z11 2763232 xp8_g3jgz1ut 210176 xp30_w33z8kqrqk8zzzx33 90944 xp30_w33z8kqrqk8zzzw33 89076 xp5_idiidiz01w1 47848 xp6_ccb7w66z066 46991 xp14_j9d0d9j 31059 xp8_wgovnz234z33 6844 xp5_3pmwmp3zx11 525 xp15_4r4y14r4z4r4y14r4 265 xp46_330279cx1aad3y833zx4e93x855bc 104 xp46_330279cx1aad3zx4e93x855bcy8cc 79 xp15_g0444g0g4440gy14r4z30kkk303kkk03y14r4z70ggg707ggg07 39 xp15_4r4y0oge2z4r4 14 xp30_32aczw8kqrqk8zzzy133 13 xp30_32aczw8kqrqk8zzzy033 11 xp30_oox8k2s3zy3103y531e8 10 xp15_co9nas0san9oczgoldlo0oldlogxuquz1047210127401xfbf 8 xp30_ccx8k2s3zy3103y531e8 8 xp6_w8o0uh224a4z32 7 xp15_4r4y0oge13z4r4 6 xp46_033y133zzzckgsxsgkczz0cc 6 xp8_25du4szx327ba4 6 xp5_2mq3sggozx346 5 xp8_2erore2z07x7 5 xp24_co9nas0san9oczgoldlo0oldlogy0ggz1047210127401y01581qo 4 xp30_31egoxg0ozy22587oy666 4 xp30_31egoxg0ozy22587oy633 3 xp30_31egoy5g8gzyafn872x33 3 xp5_0o8gka53z3c84ko 3 xp6_wq52z01aq23z32 3 xp24_co9nas0san9ocy0ssszgoldlo0oldlogy3777z1047210127401 2 xp30_3hu0oox8k2s3y6oozy7103 2 xp6_318c0fh884a4 2 xp6_4a422hu0og26 2 xp15_04r4z04r4zzeaeeeeae 1 xp15_4r4y0ohf0352z4r4 1 xp15_4r4z4r4y031e8gzy3c871 1 xp15_sksy0j1u066zvnvy011 1 xp15_sksy0j1u0ok8zvnvy011 1 xp15_sksy1vtvzvnvy1757 1 xp15_vtvy18sws0kk0sws8z757 1 xp30_0mligz32w23zzy015aia51zy2oo 1 xp30_31egoy5g8gzyafn872x66 1 xp30_3lkkl3z32w23zzy015aia51zy3oo 1 xp30_j1u0oox8k2s3y6ccz11y5103 1 xp30_w33z8kqrqk8zzy3gggozy27ddfoy0cx33 1 xp30_w33z8kqrqk8zzzc97079c 1 xp30_x33zgka9akgzzzx75777757 1 xp30_y1ok46164kozz3589853zzw66 1 xp5_035426ozca5123 1 xp5_25a84cgz8ka2461 1 xp5_mlligz36asgv0rr 1 xp5_w6qgwc453z65w1 1 xp6_178b988a6zwc813 1 xp6_8k8442s0c813zxc871 1 xp8_66625dw660uic 1 Run Time: real 3.245 user 2.854000 sys 0.343000 Naturally-occurring non-stationary patterns: sqlite> SELECT code, count FROM census WHERE rule = "b3s23" AND symmetry = "C1" AND (type = "xq" OR type = "yl" OR type = "zz") ORDER BY count DESC; xq4_153 8936480327882 xq4_6frc 13060857809 xq4_27dee6 3441269905 xq4_27deee6 598048142 yl144_1_16_afb5f3db909e60548f086e22ee3353ac 40317884 yl384_1_59_7aeb1999980c43b4945fb7fcdb023326 14529933 xq4_27dee6z4eb776 1695 xq4_27deee6z4eb7776 473 xq4_27de6z4eb776 207 xq4_0791h1az8smec 162 xq4_27de6z4eb7776 135 xq4_27du6ze98885 64 xq4_06eed72zaghgis 50 xq4_27dumze988885 27 xq4_6ed72z6777be4 26 xq4_027deee6z8smec 20 xq4_27de6zw8smeeec 18 xq4_27dee6zw4eb776 18 xq4_677be4zx48889e 15 xq4_27de6z8smeeec 14 xq4_27due6ze98885 13 xq4_sighgazz791hh1a 13 xq4_06eeed72z677be4 12 xq4_27dee6z4eb7776 11 xq4_6eeed72zaghgis 9 xq4_06eeed72zcems8 8 xq4_0791hh1az8smeec 6 xq4_27dee6zw4eb7776 6 xq4_0aghhgiszza1h197 5 xq4_27duee6ze98885 5 xq4_27duu6ze988885 5 xq4_6eed72zaghhgis 5 xq4_aghgiszza1hh197 5 xq4_27duue6ze988885 4 xq4_27dee6zx8smeeec 3 xq16_gcbgzvgg826frc 2 xq4_06eeed72zaghhgis 2 xq4_0sighhgazz791h1a 2 xq4_a1hh197zx6777be4 2 xq4_02111197zcssqe4 1 xq4_027deee6zsighhga 1 xq4_0aghhgiszza1hh197 1 xq4_27deee6zw4eb7776 1 xq4_aghhgiszzwa1hh197 1 yl1152_1_275_a3591abbc6ddbf461332c01353cae282 1 yl1152_1_287_c668cfc798dfdec402beb6f34f208596 1 yl1152_1_305_23828957c259441638bcee6ea2ba8520 1 yl1152_1_305_5795153c1f2b6ae9bfe120246730d361 1 yl1152_1_339_7ce7f51dc84f94e6f44da81dfd75695c 1 yl1152_1_341_e23efe60ede5bb26a3dd2f5e50289969 1 yl1152_1_352_e741512e9dbc4415e12596860f4cc981 1 yl1152_1_397_bc4d2ad5ba21ed7b8dc4c2e12f614815 1 yl1152_1_418_2ecd07e1895c6fcc85d61ac1b6cff7e5 1 yl1152_1_443_04860d73350799a2521c0f8aaab40cd5 1 yl144_1_32_54a1c82db27c03fc332b1c87fa1f6a0a 1 yl2304_2016_04_28 1 yl288_1_50_6a37ebc99bdaeddc3bc120d2636b4e14 1 yl288_1_53_86446d1a55ce18f37611d7d02a125ad1 1 yl384_1_112_b71599811f718beb61d58022ec600208 1 yl384_1_118_3a356dd26ac32668a4d3538d95ad6ab5 1 yl384_1_171_1ea23c50d3a143f0a8bc16970c7de8c3 1 yl4608_2015_11_28 1 Run Time: real 3.238 user 2.746000 sys 0.483000 Top 25 rules with the highest number of investigated symmetries: sqlite> .width 40 sqlite> SELECT rule, count(distinct(symmetry)) AS scount FROM census GROUP BY rule ORDER BY scount DESC LIMIT 25; b3s23 22 b35s136 17 b3678s34678 17 b36s23 17 b38s23 17 b36s125 16 b457s0123578 16 b56s14568 16 b368s024578 15 b38s238 13 b3s2 13 b35s23 12 b357s238 11 b368s245 11 b2in3s123a 10 b34s26 10 b35s137 10 b36s245 10 b378s3478 10 b367s3567 9 b3s01357 9 b34s5678 8 b3578s24678 7 b3s12 7 b3s238 7 Run Time: real 7.675 user 7.021000 sys 0.655000 Top 25 rules with the highest object count across all symmetries: sqlite> SELECT rule, sum(count) AS total FROM census GROUP BY rule ORDER BY total DESC LIMIT 25; b3s23 105242518944600 b3s01367 2987081586348 b3s12 829744930595 b35s136 691242144192 b38s23 390773930198 b3s03478 261099461914 b35s137 223592100792 b3s2 186655846461 b38s238 127696669292 b3s238 116779119937 b36s125 108261384174 b3678s34678 106867605253 b3s18 59681623746 b35s23 46836588166 b367s3567 45788920839 b3s0135678 33187710139 b35s13 19382254627 b34s26 14384303712 b378s3567 12464739079 b357s238 11729730333 b3s01357 10222019950 b3s24 9703948408 b3678s0456 8994517034 bs2 8817210494 b3678s04567 8266145047 Run Time: real 6.042 user 5.616000 sys 0.421000 Top 100 rule/symmetry combinations with the highest object count: sqlite> .width 60 10 -20 sqlite> SELECT rule, symmetry, sum(count) AS sumcount FROM census GROUP BY (rule || symmetry) ORDER BY sumcount DESC LIMIT 100; b3s23 C1 114325772396389 b3s01367 C1 2850511612134 b3s12 C1 827521448458 b3s23 D8_1 606514929213 b3s23 D2_+1 566175587137 b3s23 D8_4 480773102181 b3s23 D2_+2 434971023889 b35s136 C1 367911049413 b38s23 C1 363465027828 b3s03478 C1 304052260406 b3s23 D4_x4 280276166292 b3s23 D4_+2 270947649214 b3s23 D4_+1 229242116711 b3s23 D4_x1 193906651157 b38s23 D2_+2 192504873518 b3s2 C1 165709918078 b3s01367 D2_+1 161058941522 b3s23 D4_+4 144116347697 b3678s34678 C1 130248400993 b3s23 C2_2 128556425291 b35s137 C1 118389360556 b38s238 C1 107355659269 b3s238 C1 105106690336 b3s23 C4_1 84719180015 b3s23 C2_4 80237879184 b36s125 C1 75520953068 b3s23 C4_4 73225487906 b3s23 D2_x 69517686259 b3s18 C1 59681623746 b3s23 8x32 54104457360 b367s3567 C1 51073094793 b3s23 C2_1 47242154107 b35s136 D4_+2 43673046673 b35s23 C1 36086157737 b45s12 C1 30493553911 b35s136 D8_1 29396450467 b3s2 D2_x 29234748969 b35s136 D8_4 27975098445 b35s136 D4_x4 26841262760 b38s23 D4_+2 26345842238 b35s136 D4_+1 26040779476 b35s136 C4_4 25945262856 b35s136 D2_+2 25623389863 b35s135 C1 25499832343 b35s136 C2_1 25472162492 b35s136 8x32 25418800453 b35s136 D4_x1 25321623252 b35s136 C4_1 25232130592 b35s136 D4_+4 25226802332 b35s136 D2_+1 25181856371 b35s136 C2_4 25172323857 b35s136 C2_2 25131753980 b35s136 D2_x 25018681398 b36s125 D4_+4 23661831624 b3s0135678 D8_1 19160388310 b35s13 D2_+1 18938341609 b357s23 C1 15650594186 b378s3567 C1 14389677047 b35s137 C2_1 14110457846 b3s2 D8_1 13824000919 b35s137 C2_2 13452216370 b35s137 C2_4 13433654290 b38s238 D4_+2 13100391944 b35s137 C4_1 12297175676 b35s137 D4_x1 11872969016 b35s137 C4_4 10971284614 b35s137 D4_+4 10946627796 b35s137 D8_1 10856503551 b35s137 8x32 10622038431 b35s137 D8_4 10611239072 b35s137 D4_+1 10484927013 b35s135 C2_2 10432022061 b35s137 D4_x4 10328364443 b35s137 D4_+2 10262159433 b35s135 D2_x 10232425178 b35s135 D2_+2 10212871735 b35s137 D2_+1 10146680846 b35s137 D2_x 10123568634 b35s135 C4_4 10109637629 b35s135 C4_1 10083582963 b35s135 C2_1 10082671574 b35s135 D2_+1 10057006885 b35s137 D2_+2 10045663529 b35s135 C2_4 10030801223 b3s24 C1 9703948408 b3678s0456 D4_+2 8994517034 bs2 C1 8813336443 b3s238 D4_+2 8670764653 b358s23 C1 8518749097 b3678s04567 C1 8174621229 b378s3567 D2_+1 8152442991 b3678s3567 C1 7356579941 b35s0145 C1 7140824625 b357s238 D4_+2 6957348845 b38s014567 C1 6894161658 b3s01367 D4_+2 6843207829 b3s01357 C1 5833077834 b3s26 C1 5552939367 b38s238 D8_1 5241238618 b3s0135678 C1 4696910256 Run Time: real 16.310 user 12.434000 sys 1.030000 sqlite> Total number of rules: sqlite> SELECT count(distinct(rule)) FROM census; 618 Run Time: real 9.815 user 4.649000 sys 0.281000 Total number of symmetries: sqlite> SELECT count(distinct(symmetry)) FROM census; 24 Run Time: real 4.659 user 2.230000 sys 0.187000 List of symmetries: sqlite> SELECT distinct(symmetry) FROM census ORDER BY symmetry; 25% 25pct 75% 8x32 C1 C1-2016-04-05-2016-04-05 C2_1 C2_2 C2_4 C4_1 C4_4 D2_+1 D2_+2 D2_x D4 D4 +4 D4_+1 D4_+2 D4_+4 D4_x1 D4_x4 D8_+4 D8_1 D8_4 Run Time: real 3.201 user 1.466000 sys 0.125000 List of rules without a C1 census: sqlite> SELECT distinct(rule) FROM census EXCEPT SELECT distinct(rule) FROM census WHERE symmetry = "C1"; b35678s256 b35678s28 b35678s356 b35678s456 b3678s01456 b3678s0456 b36s135 b378s24678 b378s25678 b37s0245 b38s02456 b38s34 Run Time: real 10.879 user 10.296000 sys 0.593000 Top 25 rules with the highest number of spaceships: sqlite> SELECT rule, count(distinct(code)) AS ships FROM census WHERE type = "xq" GROUP BY rule ORDER by ships DESC LIMIT 25; b3s23-e4e 1019 b2-ain3is12-akn 797 b3s135 568 b2ik367s127 418 b2-akn3ci4jnr5ikns12-ck4einqy5er6-ckn8 363 b3s23-ae 263 b36s02458 220 b35s136 217 b2-a5s135678 213 b3s34ar5 209 b36ce7-es23-y 198 b2ce3eis1-e2-i3a 178 b368s02458 136 b2ce3ais23 130 b2ei3-a4ce5y6is234i7-c 125 b367s3567 119 b36s245 119 b368s245 110 b368s0245 107 b36s0245 107 b36s2-i35i 101 b368s24578 99 b36s125 95 b3s357 95 b3-kq4k6ns2-in3-c5q 75 Run Time: real 0.090 user 0.000000 sys 0.093000 Top 25 rules with the highest number of spaceship periods: sqlite> SELECT rule, count(distinct p) AS numps FROM census WHERE type="xq" OR type="ov_q" GROUP BY rule ORDER BY numps DESC LIMIT 25; b378s3567 16 b3-q4w678s23-air4-jkrtwy 12 b3678s34678 11 b367s3567 11 b2ce3ais1-e23-a 10 b3-nrys2-i3-j4-ajy5i6 9 b2-a3is12-ace3ay 8 b2-aci3ei4zs23-e6 8 b2en34es23-a4-aiqr6c78 7 b2i34cik7s23-a4cikn7 7 b2in34ks2-e3-cknry4-jr 7 b34-qr7s23-a4-ackrw6c 7 b35ys23-a4i 7 b3-kys23-aiy4anq6n 6 b34-iqr7-es23-a4i 6 b34n5ys2-k34a 6 b35iy7s23-acy4aejt5c 6 b3678s3567 6 b378s2-a35678 6 b378s24568 6 b38s135 6 b3s2-a35 6 b3s23 6 b3s2e34ar5 6 b2-a5s135678 5 Run Time: real 0.185 user 0.078000 sys 0.109000 Smallest oscillator period not yet seen in B3/S23/C1: sqlite> SELECT rowid FROM census WHERE rowid BETWEEN 2 AND 1000 EXCEPT SELECT distinct(p) FROM census WHERE type = "xp" AND RULE = "b3s23" AND symmetry = "C1" LIMIT 1; 7 Run Time: real 3.447 user 3.135000 sys 0.312000 Smallest oscillator period not yet seen in B3/S23: sqlite> SELECT rowid FROM census WHERE rowid BETWEEN 2 AND 1000 EXCEPT SELECT distinct(p) FROM census WHERE type = "xp" AND RULE = "b3s23" LIMIT 1; 17 Run Time: real 0.219 user 0.171000 sys 0.047000 How many distinct objects (of a given type; xp4 is used as an example here) have appeared a certain number of times each? And what's an example of each? (This should be read as e.g. "There are 2 distinct xp4s that have appeared 5 times each. xp4_xcikb73z6513 is an example" etc.) sqlite> SELECT count(distinct(code)) AS dcount, count, code FROM census WHERE prefix = "xp4" AND rule = "b3s23" AND symmetry = "C1" GROUP BY count ORDER BY count DESC; 1 1629161 xp4_37bkic 1 309757 xp4_ssj3744zw3 1 58995 xp4_8eh5e0e5he8z178a707a871 1 247 xp4_8eh5e0e5he8gz178a707a871 1 55 xp4_3lk453z34ats 1 17 xp4_hv4a4vh 1 16 xp4_037bkicz6953 1 10 xp4_xcikb73z2553 1 9 xp4_037bkicz2553 1 8 xp4_03lozsta43123 2 5 xp4_xcikb73z6513 3 2 xp4_37bkic0f96 12 1 xp4_xcikb73z6953 Run Time: real 3.198 user 2.808000 sys 0.390000 Biggest still life in any rule: sqlite> .mode tab sqlite> SELECT code, rule, p FROM census WHERE type = "xs" ORDER BY p DESC LIMIT 1; xs1484_0oo66vvuuvvuvvuvvuvuuvuvvuvvuvvuuvv66oozjvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvjzdvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvdzbvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvbzqvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvqzmvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvmzpvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvpz033ccvvffvvfvvfvvfvffvfvvfvvfvvffvvcc33 b3678s34678 1484 Run Time: real 4.666 user 3.931000 sys 0.265000 B3/S23 symmetries by total number of objects: sqlite> SELECT symmetry, sum(count) AS numobjects FROM census WHERE rule = "b3s23" GROUP BY symmetry ORDER BY numobjects DESC; C1 107715555647943 D8_1 601259933091 D2_+1 534999743604 D8_4 475356566612 D2_+2 377986734436 D4_x4 275459137569 D4_+2 267479468864 D4_+1 226612839154 D4_x1 189069051499 D4_+4 140360463435 C2_2 126650252663 C4_1 82458635602 C2_4 78305230861 D2_x 66413427716 C4_4 65898536652 8x32 52589128062 C2_1 41509874120 D4 +4 305685440 25pct 168090934 D8_+4 7260783 75% 2598383 25% 2594300 Run Time: real 0.453 user 0.436000 sys 0.016000 B3/S23 symmetries by number of distinct objects: sqlite> SELECT symmetry, count(distinct(code)) AS distobj FROM census WHERE rule = "b3s23" GROUP BY symmetry ORDER BY distobj DESC; C1 89112 D8_1 59602 D8_4 31268 D4_x4 22648 D4_x1 18557 D2_+1 17094 D4_+1 16368 D4_+2 15639 D2_x 11396 D2_+2 8704 C2_2 6495 D4_+4 5535 C2_4 4187 C4_1 4039 C2_1 3762 8x32 3532 C4_4 3229 D4 +4 489 25pct 373 D8_+4 120 75% 82 25% 81 Run Time: real 1.357 user 1.279000 sys 0.062000 Number of objects, per prefix, that have been seen in higher symmetries of B3/S23 but not in C1: sqlite> .mode column sqlite> .width 10 -15 sqlite> SELECT prefix, COUNT(*) FROM (SELECT prefix, code FROM census WHERE rule = "b3s23" AND symmetry != "C1" EXCEPT SELECT prefix, code FROM census WHERE rule = "b3s23" AND symmetry = "C1") GROUP BY prefix ORDER BY prefix; ov 14 xp10 14 xp11 10 xp12 1 xp120 4 xp13 1 xp138 2 xp15 186 xp16 3 xp2 15223 xp22 1 xp24 8 xp28 1 xp29 2 xp3 1419 xp30 85 xp31 1 xp32 1 xp37 2 xp4 257 xp40 2 xp46 5 xp5 307 xp51 1 xp6 223 xp60 1 xp7 9 xp8 24 xp9 6 xq10 1 xq12 3 xq4 17 xs100 1365 xs102 1 xs104 2243 xs108 1326 xs110 1 xs112 2314 xs116 1129 xs120 2243 xs124 919 xs128 2002 xs132 644 xs136 1691 xs14 1 xs140 471 xs144 1335 xs148 293 xs15 2 xs152 989 xs156 147 xs16 44 xs160 780 xs164 97 xs168 481 xs17 38 xs172 62 xs176 316 xs18 222 xs180 40 xs184 197 xs188 19 xs19 134 xs192 126 xs196 12 xs20 631 xs200 74 xs204 5 xs208 31 xs21 361 xs212 3 xs216 18 xs22 1319 xs220 2 xs224 20 xs23 670 xs232 9 xs24 2195 xs240 4 xs248 2 xs25 970 xs26 3279 xs264 1 xs27 1101 xs28 4282 xs29 1156 xs30 5079 xs31 1134 xs32 5295 xs33 1002 xs34 5053 xs35 788 xs36 4722 xs37 593 xs38 3924 xs39 407 xs40 3544 xs41 244 xs42 2635 xs43 144 xs44 2648 xs45 86 xs46 1575 xs47 57 xs48 2040 xs49 32 xs50 911 xs51 25 xs52 1727 xs53 6 xs54 536 xs55 9 xs56 1462 xs57 5 xs58 383 xs59 1 xs60 1286 xs61 2 xs62 270 xs63 2 xs64 1182 xs66 170 xs67 1 xs68 1012 xs70 108 xs71 2 xs72 981 xs74 74 xs76 939 xs78 56 xs80 1120 xs82 19 xs84 1084 xs86 14 xs88 1592 xs90 5 xs92 1204 xs94 8 xs96 1964 xs98 3 yl1152 3 yl12 1 yl120 2 yl1248 1 yl128 1 yl1344 1 yl1536 51 yl180 2 yl1920 1 yl2304 94 yl2688 2 yl288 2 yl3072 3 yl312 1 yl384 77 yl480 2 yl576 8 yl768 3 yl78 2 yl96 2 zz 2 Run Time: real 5.429 user 4.898000 sys 0.452000 sqlite> Rulesyms that have PATHOLOGICALs: sqlite> SELECT distinct(rule), symmetry FROM census WHERE prefix="PATHOLOGICAL" ORDER BY rule; b2-aci3ei4zs23-e6 C1 b2-ain3is12-akn C1 b2ce3ais23 D4_+1 b2i34cik7s23-a4cikn7 C1 b2i34cik7s23-a4cikn7 D2_+1 b2i34cik7s23-a4cikn7 D8_1 b2i34e6i7-es2-i36n C1 b2in34ks2-e3-cknry4-jr C1 b2in34ks2-e3-cknry4-jr D2_+1 b2in34ks2-e3-cknry4-jr D8_1 b3-c4ikt7-cs23-y7-e C1 b3-c4ikt7-cs23-y7-e D2_+1 b34-i5-a6-as2-an34-akrw C1 b34578s567 C1 b3457s5 C1 b3458s38 D8_1 b345s5 C1 b345s5 C2_1 b345s5 C2_2 b345s5 C2_4 b345s678 C1 b3478s5678 C1 b34cs23 C1 b34ek5aks2-c34cz C1 b34ek5aks2-c34z C1 b34ets23-a4eit6 C1 b34k5es236c C1 b34s5678 D8_1 b3578s0138 C1 b358s23 D4_x4 b358s3567 D4_+2 b35ys23-a4i C1 b3678s04567 D4_+2 b3678s25678 C1 b3678s34678 C1 b3678s34678 D4_+1 b3678s34678 D4_x1 b3678s34678 D8_4 b3678s35678 8x32 b3678s35678 C1 b3678s35678 C2_1 b3678s35678 D2_+1 b3678s35678 D2_x b3678s4567 D4_+2 b367s035678 C1 b367s134-ar5ei678 C1 b367s25678 C1 b367s35678 C1 b368s23 C1 b368s23 D4_+2 b368s238 C1 b368s238 D4_+2 b36s035678 C1 b36s125 C1 b36s125 D4_+4 b36s1258 C1 b36s23 C1 b36s23 C2_4 b36s23 D2_+1 b36s23 D2_+2 b36s23 D2_x b36s23 D4_+1 b36s23 D4_+2 b36s23 D4_+4 b36s23 D8_1 b36s238 C1 b36s238 D4_+2 b36s245 C1 b36s245 C4_1 b378s14567 C1 b378s14567 D4_+2 b378s3567 C1 b37s13567 C1 b37s2-i34q C1 b37s2-i34q C2_2 b38s014567 C1 b38s014567 D4_+2 b38s23 D8_4 b3s013 D4_+2 b3s0135 C1 b3s0135 D4_+2 b3s01357 C1 b3s01357 C4_1 b3s01357 D2_x b3s01357 D4_+2 b3s01357 D8_1 b3s01357 D8_4 b3s01367 D4_+2 b3s14567 C1 b3s23 D2_x b3s23 D4_x4 b3s23-a4i5i C1 Run Time: real 0.000 user 0.000000 sys 0.000000 sqlite> All users: sqlite> SELECT DISTINCT name FROM users ORDER BY name; 3+4i @danielc2034 @doctroid @m_t_ireland @rawles @th222 A for awesome Actinoid.wadas@gmail.com Alessandro Morelli Alexey Nigin Anonymous Apple Bottom Arie Paap BartekChom Billabob Billabobcraft@gmail.com C. Wang Caenbe CounterShadowform Daniel R. Collazo Dannyu NDos [David] Dave Greene DivusIulius EricABQ Excuse me if this breaks the chart\\ Extrementhusiast G_Dubya_Lee Glider_Rider Hooloovoo Indi Isaac Grosof John Cerkan Josh Ball LV LegionMammal978 Lewis Patterson MNiemiec Mars Ultor Moth Wingthane NBickford Nathaniel Johnston Nigin Public Account Nigin's Public Account NoLongerBreathedIn Parcly Taxel Q Rhombic Ryan Hitchman Saka SimSim314 SimSim314@gmail.com SuperJedi224 Tanner Jacobi The Turtle Twm Stone U03A6 Vadim Rumyantsev Yimmy _zM aerkiaga3@gmail.com andrew@trevorrow.com andrewslattery.13@gmail.com apgoucher@gmx.com benetnasch85 bwbigmac@gmail.com codeholic crowett@gmail.com david.loyall@the-good-guys.net dmqwerty425@gmail.com dsmiller dvgrn egarpad97@gmail.com elie@malonihotel.com epicrichard72@gmail.com flipper77 gmc_nxtman goldtiger997 holdenmui@gmail.com isaacg@mit.edu jaco2785@kettering.edu jh05013 johnhw@gmail.com jtjierui@gmail.com l0cksit@gmail.com luis.camara904@gmail.com m_t_ireland mr.meowcat muzikbike nathan nic peyote philipp.groene@googlemail.com rawles rokicki@gmail.com rs.holmes@gmail.com scorbiclife@gmail.com shouldsee.gem@gmail.com simeksgml@gmail.com skomick smithrobertlawrence@gmail.com the_jsaur theo77186 thunk towerator vita.libertas.est@gmail.com vneckrasov yootaamath@gmail.com Run Time: real 0.003 user 0.015000 sys 0.000000 sqlite> Number of users: sqlite> SELECT count(distinct(name)) FROM users ORDER BY name; 107 Run Time: real 0.001 user 0.000000 sys 0.000000 sqlite> User ranking for B3/S23/*, by total contributions: sqlite> SELECT name, sum(count) AS total FROM users WHERE rule = "b3s23" GROUP BY name ORDER BY total DESC; apgoucher@gmx.com 113994552848555 Apple Bottom 10343644385468 bwbigmac@gmail.com 9485261966488 Vadim Rumyantsev 6804300628737 rokicki@gmail.com 5743976435124 thunk 5655025521570 rawles 4669858262844 @th222 3217490351468 benetnasch85 2239060502425 Moth Wingthane 1492228576273 EricABQ 1440187382550 @doctroid 1410190363780 G_Dubya_Lee 1323780221911 dsmiller 1272100613179 nic 995675569668 Anonymous 699624700384 @m_t_ireland 612094868066 C. Wang 456835071102 SimSim314@gmail.com 405047829779 Hooloovoo 404825271770 Daniel R. Collazo 288414483382 muzikbike 266676212974 Billabob 251276684108 Tanner Jacobi 247929740224 smithrobertlawrence@gmail.com 217833890884 epicrichard72@gmail.com 202316791829 Nathaniel Johnston 192320883673 simeksgml@gmail.com 178029605106 yootaamath@gmail.com 159680886999 Dannyu NDos [David] 155180730603 Dave Greene 153869773730 johnhw@gmail.com 148323921638 Josh Ball 144377994866 DivusIulius 111845827519 the_jsaur 87944288090 NoLongerBreathedIn 85202268872 Twm Stone 68111065343 andrew@trevorrow.com 64067062411 dvgrn 59307195113 gmc_nxtman 51069444255 Indi 47876213037 @danielc2034 34549311330 Glider_Rider 34277926047 Ryan Hitchman 33792584644 Isaac Grosof 22523478158 jaco2785@kettering.edu 20966742800 A for awesome 18951848989 Saka 15807095650 Lewis Patterson 10966589239 @rawles 10921433317 3+4i 9502030709 Parcly Taxel 9099325283 theo77186 7645939536 crowett@gmail.com 7169704239 Extrementhusiast 6705979995 dmqwerty425@gmail.com 6671569131 LegionMammal978 5898578333 NBickford 5871941718 rs.holmes@gmail.com 5678659109 flipper77 4684498369 m_t_ireland 4368862987 isaacg@mit.edu 3975058105 Actinoid.wadas@gmail.com 2512543070 codeholic 2133988725 david.loyall@the-good-guys.net 1747951593 Nigin Public Account 1579253723 vita.libertas.est@gmail.com 1542191399 SimSim314 1526942587 towerator 1189760149 Alexey Nigin 1002543597 SuperJedi224 936644245 goldtiger997 898844857 l0cksit@gmail.com 655536714 scorbiclife@gmail.com 567207269 jh05013 409896633 mr.meowcat 363827729 Nigin's Public Account 265442871 jtjierui@gmail.com 228140313 peyote 218461901 BartekChom 218423118 LV 218333199 U03A6 190674338 Alessandro Morelli 169110907 The Turtle 149359381 philipp.groene@googlemail.com 122052347 MNiemiec 111577889 CounterShadowform 101785337 aerkiaga3@gmail.com 70699664 skomick 70039265 _zM 51768917 holdenmui@gmail.com 24032954 nathan 22096431 andrewslattery.13@gmail.com 12520427 Rhombic 3753272 Billabobcraft@gmail.com 3091179 Excuse me if this breaks the chart\\ 2162268 luis.camara904@gmail.com 991740 Run Time: real 0.001 user 0.000000 sys 0.000000 Breakdown of contributions to B3/S23 for a single user: sqlite> SELECT name, symmetry, count FROM users WHERE name="Apple Bottom" AND rule="b3s23" ORDER BY count DESC; Apple Bottom C1 7939939833465 Apple Bottom D2_+2 956794478521 Apple Bottom D8_1 284320303461 Apple Bottom D8_4 134550099270 Apple Bottom D4_x1 117358615194 Apple Bottom D4_x4 107458661797 Apple Bottom D4_+4 101107730492 Apple Bottom D2_+1 98737270383 Apple Bottom D4_+2 96138375503 Apple Bottom D4_+1 91483011554 Apple Bottom D2_x 83583304159 Apple Bottom C4_1 64794827067 Apple Bottom C4_4 63387753346 Apple Bottom 8x32 53314926281 Apple Bottom C2_1 51254492645 Apple Bottom C2_4 49931786443 Apple Bottom C2_2 49488915887 Run Time: real 0.001 user 0.000000 sys 0.000000 sqlite> Rules a single user has contributed to: sqlite> SELECT rule, sum(count) AS t FROM users WHERE name="Apple Bottom" GROUP BY rule ORDER BY rule; b2-a3s2-a 311142 b2-a5s135678 12431529 b2-aci3eir4zs23-e6 403499 b2-ae3s45 97964 b2-aei4s3 351671 b2-aen3aei7s02-a 5431386 b2-ain3-jqys3 1824056 b2-ain3is12-akn 640576 b2-an3aei4es02e3ei 28246042 b2-an3aeis02 2923576 b2e3s23-j 5452771 b2ei3-a4ce5y6is234i7-c 42519319 b2i34s23a 4518834 b2i3s2-i3 103547 b2i3s2-in3 93215 b2i3s2-n3 91551 b2i4is2-i34-i 184257 b2i4is2-i4-i 131347 b2in3s02-k3-ay4ar 19523992 b2k3-as2-aei34-i 100710 b2k3s2-k34c 240713 b2n3s2-i3 94149 b2n3s2-in3 58686 b2n3s2-n3 82742 b3-i4-an5ckqys5ckqy 202518 b3-is2-i3 1148902 b3458s38 13756549 b345s1 965667943 b345s2 327728 b345s3 28669780 b345s5 1337290 b345s5-e 12326 b345s678 281564 b34678s3678 2987045 b3468s378 465667 b3468s46 622647 b3478s01678 4675939424 b3478s167 1514212 b3478s2678 2296697 b347s268 309182 b348s028 404887342 b348s0378 8988177 b348s046 86770782 b348s2 56102554 b348s27 1627762 b348s28 41289227 b348s3 7282242 b348s4 5251824 b348s5 37247480 b34cs234c5e 23086745 b34ets23-a4eit6 319989 b34s01 1439574511 b34s1 904218284 b34s26 3717398 b34s267 19027 b34s4 27880187 b34s5 67011414 b34s5678 3295897 b34s678 559843 b35678s0178 9656636 b35678s0258 99800918 b35678s13 156890215 b35678s367 4116058 b35678s3678 2842952 b35678s37 4800358 b35678s4678 3052522 b35678s5678 926725 b3567s45 6586 b3568s02568 1481073 b356s045 16565770 b356s13 3742820 b3578s0347 165408403 b3578s2467 552315 b3578s4568 552604115 b357s135 31547028 b357s1358 2933037 b357s1368 4402257 b357s23 2215257 b357s238 35614686 b358s23 16797066 b358s3567 3303350 b358s357 588408 b358s367 52665 b358s4 30956 b35i6cs2-i34q 374041 b35s013 670907770 b35s0145 7140824625 b35s014578 3120533 b35s024 71162840 b35s036 98809696 b35s05 113107313 b35s13 18946938106 b35s136 15155785673 b35s1367 333191561 b35s138 1294439841 b35s145 18547198 b35s148 1516969 b35s23 1893983869 b35s2467 523736 b35s24678 666555948 b35s457 1105 b36-k78s34-k6-k78 70411 b3678s245 23144527 b3678s24578 9447196 b3678s34-k678 109064 b3678s346 89510037 b3678s3467 665521226 b3678s34678 201867891945 b3678s3468 821313359 b3678s3567 7350763267 b3678s35678 20326123 b3678s3678 27376 b367s2457 674240265 b367s3467 306461172 b367s34678 1480074059 b367s3567 56685754145 b367s35678 16964954 b367s357 1718873 b367s3678 14264463 b368s0245 851910154 b368s02458 313269339 b368s03 48984644 b368s23 921366 b368s24 9197481 b368s245 3876488708 b368s24578 155472547 b368s34678 961089997 b368s3468 668985453 b368s3478 117128399 b36s0 1417339 b36s0245 881543115 b36s02458 781212845 b36s06 148490962 b36s12 3861497 b36s125 1779853339 b36s1258 11501106 b36s15 1976957 b36s2-i35i 1138463 b36s23 894219872 b36s245 143636404 b36s25 839608 b36s34678 242867362 b36s35 739390 b36s356 53086 b36s357 22171116 b378s34 658606593 b378s3567 25726720051 b37s0145 16087121 b37s035 6612793 b37s2456 24306636 b37s278 558561 b37s3567 1688070457 b37s4 91982 b37s45 1709 b37s457 2591 b38s0137 53860179 b38s078 11026533 b38s13 520528863 b38s135 3433020811 b38s2 102391145 b38s23 747798707 b38s238 62203420852 b38s34 3815473 b3s0 189929473 b3s013567 6802432 b3s01357 7547824962 b3s01367 2782838097 b3s0137 908154334 b3s014568 17093946 b3s018 11306886 b3s02468 476658 b3s03478 139745875 b3s0357 238251563 b3s0358 520568605 b3s0378 10606813 b3s06 69638280 b3s08 36514320 b3s12 768203315 b3s125 62807280 b3s126 63536666 b3s13 711992187 b3s14 41528287 b3s1456 16553329 b3s1457 36280541 b3s15 42356735 b3s2 195037140 b3s2-a36n 33644262 b3s2-i3 83526 b3s23 10348266132295 b3s23-a 575072 b3s23-ac 764718 b3s23-ae 4856281 b3s23-ai 457452 b3s23-aj 11536725 b3s23-ak 3350489 b3s23-an 12445243 b3s23-aq 5052163 b3s23-ar 5109172 b3s23-ay 423716 b3s23-c 555029 b3s23-ce 3573803 b3s23-ci 1975708 b3s23-j 637323 b3s23-k 896413 b3s23-n 1692853 b3s23-r 2202381 b3s23-y 604724 b3s234ce 453194 b3s234w 148829 b3s234z 3449178 b3s235k 269446 b3s238 4553410 b3s24 31888092 b3s246 28112924 b3s25 55263666 b3s2568 5380162 b3s258 186146 b3s26 5628624 b3s27 2336602 b3s3 578183055 b3s34 26424451 b3s34ar5 4973329 b3s35 6205907 b3s356 5692602 b3s3567 22240106 b3s35678 5538688 b3s3568 22756608 b3s357 36984896 b3s3578 5952303 b3s468 4917 b3s567 5250 b3s5678 78 b3s568 853 b4568s01346 43698184 b456s0146 162757 b457s0123578 417489420 b457s012378 11543410 b457s047 6626024 b45s035678 1472959 b45s1234 12809756 b45s234 1213142 b4678s35678 6920952 b467s0267 3372642 b467s1238 1103916 b468s01238 1252318 b468s12578 2390742 b478s234678 1594532 b47s012357 1045338 b4s02347 71673 b4s123 7099530 b4s23 26234534 b5678s1234 143481 b5678s12348 144295 b5678s145678 24925 b5678s14568 11750275 b5678s45678 99164 b5678s4568 204106 b568s125 3106554 b568s14568 19748504 b568s2 5918535 b568s4568 11237 b56s02378 2308602 b56s14568 411337967 b56s456 650 b56s4568 24372 b578s148 24953208 b57s1478 3963735 b5s1 384691 b5s125 589807 b5s2 4800100 b5s23 971726 b5s238 37159 b5s3 22490 b678s034678 58202386 b678s13478 1645637 b6s02467 14867013 b6s13457 124952 b6s236 42627 b7s013468 2634563 b7s23 1401111 b8s1356 6167411 b8s23 1142304 b8s236 825646 Run Time: real 0.002 user 0.000000 sys 0.000000 sqlite> Users by number of rules contributed to: sqlite> SELECT name, count(distinct(rule)) AS r FROM users GROUP BY name ORDER BY r DESC; Apple Bottom 283 Daniel R. Collazo 262 Josh Ball 132 dmqwerty425@gmail.com 100 SuperJedi224 72 EricABQ 68 _zM 67 Anonymous 64 muzikbike 40 Dannyu NDos [David] 36 shouldsee.gem@gmail.com 33 Saka 32 A for awesome 31 Isaac Grosof 31 Alexey Nigin 27 Rhombic 26 @doctroid 17 Glider_Rider 16 LegionMammal978 15 Lewis Patterson 14 Moth Wingthane 14 gmc_nxtman 12 theo77186 11 Q 10 Billabob 8 apgoucher@gmx.com 8 John Cerkan 7 Arie Paap 6 BartekChom 6 holdenmui@gmail.com 6 scorbiclife@gmail.com 6 yootaamath@gmail.com 5 aerkiaga3@gmail.com 4 dsmiller 4 Billabobcraft@gmail.com 3 Mars Ultor 3 Nathaniel Johnston 3 Nigin Public Account 3 Nigin's Public Account 3 NoLongerBreathedIn 3 Tanner Jacobi 3 Yimmy 3 elie@malonihotel.com 3 goldtiger997 3 smithrobertlawrence@gmail.com 3 vneckrasov 3 Hooloovoo 2 LV 2 codeholic 2 flipper77 2 jaco2785@kettering.edu 2 luis.camara904@gmail.com 2 nic 2 3+4i 1 @danielc2034 1 @m_t_ireland 1 @rawles 1 @th222 1 Actinoid.wadas@gmail.com 1 Alessandro Morelli 1 C. Wang 1 Caenbe 1 CounterShadowform 1 Dave Greene 1 DivusIulius 1 Excuse me if this breaks the chart\\ 1 Extrementhusiast 1 G_Dubya_Lee 1 Indi 1 MNiemiec 1 NBickford 1 Parcly Taxel 1 Ryan Hitchman 1 SimSim314 1 SimSim314@gmail.com 1 The Turtle 1 Twm Stone 1 U03A6 1 Vadim Rumyantsev 1 andrew@trevorrow.com 1 andrewslattery.13@gmail.com 1 benetnasch85 1 bwbigmac@gmail.com 1 crowett@gmail.com 1 david.loyall@the-good-guys.net 1 dvgrn 1 egarpad97@gmail.com 1 epicrichard72@gmail.com 1 isaacg@mit.edu 1 jh05013 1 johnhw@gmail.com 1 jtjierui@gmail.com 1 l0cksit@gmail.com 1 m_t_ireland 1 mr.meowcat 1 nathan 1 peyote 1 philipp.groene@googlemail.com 1 rawles 1 rokicki@gmail.com 1 rs.holmes@gmail.com 1 simeksgml@gmail.com 1 skomick 1 the_jsaur 1 thunk 1 towerator 1 vita.libertas.est@gmail.com 1 Run Time: real 0.019 user 0.000000 sys 0.031000 sqlite> How many distinct rules have objects appeared in (and what's one example of such a rule)? (Example: xq4s) sqlite> .mode column sqlite> .width 40 -15 40 sqlite> SELECT code, COUNT(DISTINCT rule) AS numrules, rule FROM census WHERE prefix="xq4" GROUP BY code ORDER BY numrules DESC LIMIT 25; xq4_153 271 tlife xq4_6frc 120 klife xq4_27dee6 103 klife xq4_27deee6 88 klife xq4_1ba4 38 tlife xq4_270o 31 b3s1378 xq4_237066f 12 b36s2458 xq4_27 9 b3s23-a5 xq4_27dee6z4eb776 9 b3s2-n36c xq4_31f0f13 9 b2en34es23-a4-aiqr6c78 xq4_15 8 b2ce3aiys12-ckn3r xq4_15w103 8 b2ce3aiys12-ckn3r xq4_203g0o 8 b2ce3aiys12-ckn3r xq4_203wgk 8 b2ce3aiys12-ckn3r xq4_2433ee 8 b3s135 xq4_2ax16 8 b2ce3aiys12-ckn3r xq4_36bsk 8 b3s2-in34-akr xq4_43wgk 8 b2ce3aiys12-ckn3r xq4_8d52zx6863 8 b3s2-i34q xq4_2030g0o 7 b2ce3aiys12-ckn3r xq4_203w8a 7 b2ce3aiys12-ckn3r xq4_2210g0o 7 b2ce3aiys12-ckn3r xq4_2210gk 7 b2ce3aiys12-ckn3r xq4_221g0o 7 b2ce3aiys12-ckn3r xq4_221wgk 7 b2ce3aiys12-ckn3r Run Time: real 0.266 user 0.000000 sys 0.266000 sqlite> How many spaceships (oversized or not) of each period are there in a given rule? sqlite> SELECT p, count(distinct(code)) FROM census WHERE type="xq" OR type="ov_q" AND rule="b2-a4k5678s1-c2ci3q4567-c8" GROUP BY p ORDER BY p; 2 311 4 1102 8 75 12 47 16 183 20 3 24 6 28 17 32 12 36 2 40 1 44 1 48 7 52 1 56 1 60 1 72 2 80 2 84 4 88 1 112 1 144 1 160 2 168 1 180 2 188 172 216 1 224 1 252 1 296 1 300 1 304 1 308 1 364 1 376 6 420 1 424 1 500 1 524 1 564 5 592 1 644 1 674 1 752 46 960 1 Run Time: real 0.016 user 0.015000 sys 0.000000