ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAE
1
How it works? / Where is this data comes from?
2
The script brute-forces member ids from 1 to until active member count is equal to what https://robertsspaceindustries.com/api/spectrum/search/member/autocomplete?text=0&page=1&pagesize=1 reports intotal hits (but in POST).

From the structure of the answer it looks like it comes from the elasticsearch backend and it should be possible to iterate the response, but alas - after 500000 entry the server returns error 500 (internal server error, looks like some assert is tripping). That's probably the reason why the community members API returns an incomplete list as wel

Note: the method that the script is using was patched or is being patched by the CIG, so scripts are no longer useful. They also asked me to kill the repo because it creates legal problems for them, which also means that scripts went down
3
4
How the data can be tested
5
The website and the database have been removed per CIG request as this creates legal problems for them. The data have been validated in the reddit thread, and it has been discovered that old accounts that did not log in into Spectrum since end of July/August do not have proper roles. The database won't be updated anymore as the flaw the scripts have been using is being patched and we aren't going to get a lot more updates anyway

To facilitate increased number of entires and general inefficiency of python, I had to split and compact the database format into a less human-readable form. You can search the database at http://starcitizendb.github.io

Script sources and raw database data can be found at the https://github.com/starcitizendb/starcitizendb.github.io/tree/main/scripts
6
7
Notes
8
Backers w/o Concierge or simply Backers - the category does not include Concierge and Staff members that are also backers
9
Removed Accounts - number of "holes" found during member_id brute-forcing. Note that there could be many reasons why an id might be missing - it does not necessary mean a user-created account that was then removed
10
Min Concierge Contribution - it's just $1000 multiplied by the number of concierge. This is an absolute minimum concierge backers contributed towards common funding level
11
Subscribers - number of subscribers of any level (backers or concierge), except for Staff
12
MMHC - Million-Mile High-Club - early high-value spenders ($10k+) or current high-level recruters (lots of referrals): https://starcitizen.tools/Million_Mile_High_Club
13
Max Avg Per Backer - this is a maximum contribution of backers not counting concierge. This is very rough estimate of "game sales" statistics - if that number goes does down over time, then the game sales (starter packs) prevail over ship pledges
14
Old Accounts - accounts who never logged in since ~August/late July 2020. Could be backers, concierge or civilians. I am working on trying to figure out exactly what those are. Newly registered accounts are unaffected by the issue, so it is not reflect in funding dynamics
15
16
DateFunding LevelOfficial countActive RegistrationsRemovedBackers w/o ConciergeConciergeCiviliansStaffSubscribersMMHCOld AccountsKnown Concierge% of all accountsKnown Backer% of known paying accountsKnown Civilians%Old/Inactive Accounts %Min Concierge ContributionMax Backer ContributionMax Avg. Per Backer
17
2020-10-06$313,881,897.912,833,489.002,791,731.001220631,869.0061,853.002,097,156.00853.0032,770.00141.002.22%91.08%75.12%0.00%$61,853,000.00$252,028,897.91$398.86
18
2020-10-07$313,920,468.512,833,831.002,791,831.001120642,339.0061,910.002,086,726.00856.0032,859.00141.002.22%91.21%74.74%0.00%$61,910,000.00$252,010,468.51$392.33
19
2020-10-11$314,663,197.962,836,367.002,794,595.001078647,644.0062,070.002,084,022.00858.0033,182.00142.002.22%91.25%74.57%0.00%$62,070,000.00$252,593,197.96$390.02
20
2020-10-12$314,801,939.312,837,127.002,795,399.001078649,278.0062,109.002,083,153.00858.0033,201.00142.002.22%91.27%74.52%0.00%$62,109,000.00$252,692,939.31$389.19
21
2020-10-13$314,909,483.842,837,828.002,796,068.001078650,224.0062,131.002,082,850.00862.0033,197.00142.002.22%91.28%74.49%0.00%$62,131,000.00$252,778,483.84$388.76
22
2020-10-14$315,007,903.742,838,401.002,796,693.001085651,401.0062,170.002,082,259.00863.0033,196.00142.002.22%91.29%74.45%0.00%$62,170,000.00$252,837,903.74$388.14
23
2020-10-15$315,110,815.492,838,960.002,797,252.001086652,905.0062,198.002,081,286.00863.0033,355.00142.002.22%91.30%74.40%0.00%$62,198,000.00$252,912,815.49$387.37
24
2020-10-16$315,211,060.442,839,534.002,797,787.001080654,847.0062,231.002,079,845.00863.0033,773.00142.002.22%91.32%74.34%0.00%$62,231,000.00$252,980,060.44$386.32
25
2020-10-17$315,315,467.142,840,164.002,798,424.001080657,102.0062,269.002,078,187.00865.0033,947.00142.002.23%91.34%74.26%0.00%$62,269,000.00$253,046,467.14$385.09
26
2020-10-18$315,417,767.032,840,842.002,799,055.001080658,679.0062,302.002,077,209.00864.0034,049.00142.002.23%91.36%74.21%0.00%$62,302,000.00$253,115,767.03$384.28
27
2020-10-19$315,516,024.932,841,548.002,799,807.001080660,133.0062,324.002,076,485.00864.0034,128.00142.002.23%91.37%74.17%0.00%$62,324,000.00$253,192,024.93$383.55
28
2020-10-20$315,593,699.032,842,080.002,800,348.001080663,773.0062,354.002,073,352.00868.0034,213.00142.002.23%91.41%74.04%0.00%$62,354,000.00$253,239,699.03$381.52
29
2020-10-21$315,777,922.102,843,060.002,800,882.001080667,691.0062,388.00394,767.00869.0034,217.00142.001,675,166.002.23%91.45%14.09%59.81%$62,388,000.00$253,389,922.10$379.50
30
2020-10-22$315,794,471.602,843,219.002,801,499.001080669,598.0062,409.00398,680.00869.0034,207.00142.001,669,942.002.23%91.47%14.23%59.61%$62,409,000.00$253,385,471.60$378.41
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100