Structured data for Egg, Inc. researches

Complete JSON data download

1
2
3
4
5
6
7
8
9
10
11
12
13
14
66
67
68
69
70
71
72
73
74
75
76
77
78
79
121
122
123
124
125
126
127
128
129
130
131
132
133
134
151
152
153
154
155
156
157
158
159
160
161
162
163
164
191
192
193
194
195
196
197
198
199
200
201
202
203
204
214
215
216
217
218
219
220
221
222
223
224
225
226
227
239
[
  {
    "serial_id": 1,
    "id": "comfy_nests",
    "name": "Comfortable Nests",
    "type": "common",
    "tier": 1,
    "categories": "egg_laying_rate",
    "description": "Increase egg laying rate by 10%",
    "effect_type": "multiplicative",
    "levels": 50,
    "per_level": 0.1,
    "levels_compound": "additive",
    "prices": [...]
  },
  {
    "serial_id": 2,
    "id": "nutritional_sup",
    "name": "Nutritional Supplements",
    "type": "common",
    "tier": 1,
    "categories": "egg_value",
    "description": "Increase egg value by 25%",
    "effect_type": "multiplicative",
    "levels": 40,
    "per_level": 0.25,
    "levels_compound": "additive",
    "prices": [...]
  },
  {
    "serial_id": 3,
    "id": "better_incubators",
    "name": "Better Incubators",
    "type": "common",
    "tier": 1,
    "categories": "hatchery_refill_rate",
    "description": "Hatchery will refill 10% faster",
    "effect_type": "multiplicative",
    "levels": 15,
    "per_level": 0.1,
    "levels_compound": "additive",
    "prices": [...]
  },
  {
    "serial_id": 4,
    "id": "excitable_chickens",
    "name": "Excitable Chickens",
    "type": "common",
    "tier": 1,
    "categories": "running_chicken_bonus",
    "description": "+0.1% egg value bonus for each running chicken",
    "effect_type": "additive",
    "levels": 25,
    "per_level": 0.001,
    "levels_compound": "additive",
    "prices": [...]
  },
  {
    "serial_id": 5,
    "id": "hab_capacity1",
    "name": "Hen House Remodel",
    "type": "common",
    "tier": 2,
    "categories": "hab_capacity",
    "description": "Increase capacity of all habs by 5%",
    "effect_type": "multiplicative",
    "levels": 8,
    "per_level": 0.05,
    "levels_compound": "additive",
    "prices": [...]
  },
  {
    "serial_id": 6,
    "id": "internal_hatchery1",
    "name": "Internal Hatcheries",
    "type": "common",
    "tier": 2,
    "categories": "internal_hatchery_rate",
    "description": "Each hen house adds 2 additional chickens per minute",
    "effect_type": "additive",
    "levels": 10,
    "per_level": 2,
    "levels_compound": "additive",
    "prices": [...]
  },
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

You can query the full list of researches as a SQLite database with the following schema:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
CREATE TABLE research(
  serial_id INTEGER PRIMARY KEY,
  id TEXT UNIQUE NOT NULL,
  name TEXT NOT NULL,
  -- Research type, either 'common' or 'epic'.
  type TEXT NOT NULL,
  -- Tier number for common research, or NULL for epic research.
  tier INTEGER,
  -- Comma-delimited categories. Possible catogries:
  -- * 'egg_laying_rate'
  -- * 'egg_value'
  -- * 'fleet_size'
  -- * 'hab_capacity'
  -- * 'hatchery_capacity'
  -- * 'hatchery_refill_rate'
  -- * 'internal_hatchery_rate'
  -- * 'running_chicken_bonus'
  -- * 'shipping_capacity';
  -- One research could belong to more than one categories;
  -- e.g. 'improved_genetics' has categories 'egg_laying_rate,egg_value'.
  -- One of a kind epic researches have categories set to the empty string.
  categories TEXT NOT NULL,
  description TEXT NOT NULL,
  -- Whether this research adds to its base effect, or multiplies it.
  -- Either 'additive' or 'multiplicative'.
  effect_type TEXT NOT NULL,
  -- Total number of levels.
  levels INTEGER NOT NULL,
  -- Bonus value per level.
  per_level REAL NOT NULL,
  -- How levels of this research are compounded with each other.
  -- Either 'additive' or 'multiplicative'.
  levels_compound TEXT NOT NULL,
  -- The prices (before discount) for each research level, encoded in a JSON 
    array.
  -- The "Lab Upgrade" epic research is considered a discount.
  -- For common research, these are the bock prices; for epic research, these 
    are GE prices.
  -- You can use SQLite JSON1 extension functions to query this field, and the 
    result will be JSON-decoded as appropriate.
  -- E.g. json_extract(prices, '$[#-1]') extracts the price of the final level.
  prices TEXT NOT NULL
);
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Enter your query here:

1
2
3
4
-- All internal hatchery rate researches.
SELECT id, name, levels AS maxLevel, per_level AS perLevel, effect_type = 
  'multiplicative' AS multiplicative, prices FROM research WHERE categories LIKE 
  '%internal_hatchery_rate%' ORDER BY serial_id;
-- Another more advanced example where we also calculate the total price of each 
  entry:
--SELECT research.id, research.name, research.levels AS maxLevel, research
  .per_level AS perLevel, research.effect_type = 'multiplicative' AS 
  multiplicative, sum(CAST(prices.value AS REAL)) AS totalPrice FROM research, 
  json_each(prices) AS prices WHERE categories LIKE '%internal_hatchery_rate%' 
  GROUP BY research.serial_id ORDER BY research.serial_id;
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

1
2
3
4
5
6
7
8
20
21
22
23
24
25
26
27
39
40
41
42
43
44
45
46
[
  {
    "id": "internal_hatchery1",
    "name": "Internal Hatcheries",
    "maxLevel": 10,
    "perLevel": 2,
    "multiplicative": 0,
    "prices": [...]
  },
  {
    "id": "internal_hatchery2",
    "name": "Internal Hatchery Upgrades",
    "maxLevel": 10,
    "perLevel": 5,
    "multiplicative": 0,
    "prices": [...]
  },
  {
    "id": "internal_hatchery3",
    "name": "Internal Hatchery Expansion",
    "maxLevel": 15,
    "perLevel": 10,
    "multiplicative": 0,
    "prices": [...]
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX