Skip to content

Instantly share code, notes, and snippets.

@korczis

korczis/cia-all-table.txt

Last active August 29, 2015 14:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save korczis/d353d6cabe8b75e16e53 to your computer and use it in GitHub Desktop.
Save korczis/d353d6cabe8b75e16e53 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
cia-all-table.txt
time ./bin/csv2psql analyze --format=table data/cia-data-all.csv
+------------------------------------------------------------------+--------+-----------+---------+------+--------+------+
| data/cia-data-all.csv |
+------------------------------------------------------------------+--------+-----------+---------+------+--------+------+
| column | Bigint | Character | Decimal | Null | String | Uuid |
+------------------------------------------------------------------+--------+-----------+---------+------+--------+------+
| id | 0 | 0 | 0 | 0 | 261 | 0 |
| Labor force | 222 | 0 | 0 | 39 | 222 | 0 |
| Labor force details | 66 | 0 | 0 | 39 | 222 | 0 |
| Judicial branch | 0 | 0 | 0 | 30 | 231 | 0 |
| Land use | 0 | 0 | 242 | 19 | 242 | 0 |
| Land use details | 241 | 0 | 0 | 19 | 242 | 0 |
| Land boundaries | 0 | 0 | 252 | 9 | 252 | 0 |
| Land boundaries details | 0 | 0 | 0 | 9 | 252 | 0 |
| Infant mortality rate | 0 | 0 | 224 | 37 | 224 | 0 |
| Infant mortality rate details | 0 | 0 | 0 | 37 | 224 | 0 |
| Industries | 0 | 0 | 0 | 24 | 237 | 0 |
| Waterways | 109 | 2 | 0 | 152 | 109 | 0 |
| Waterways details | 109 | 0 | 0 | 152 | 109 | 0 |
| Inflation rate (consumer prices) | 0 | 0 | 222 | 39 | 222 | 0 |
| Inflation rate (consumer prices) details | 31 | 0 | 0 | 39 | 222 | 0 |
| Languages | 0 | 0 | 73 | 188 | 73 | 0 |
| Languages details | 3 | 0 | 0 | 188 | 73 | 0 |
| Internet country code | 0 | 0 | 0 | 19 | 242 | 0 |
| HIV/AIDS - adult prevalence rate | 0 | 0 | 170 | 91 | 170 | 0 |
| HIV/AIDS - adult prevalence rate details | 2 | 0 | 0 | 91 | 170 | 0 |
| HIV/AIDS - people living with HIV/AIDS | 165 | 1 | 0 | 96 | 165 | 0 |
| HIV/AIDS - people living with HIV/AIDS details | 2 | 0 | 0 | 96 | 165 | 0 |
| HIV/AIDS - deaths | 156 | 1 | 0 | 105 | 156 | 0 |
| HIV/AIDS - deaths details | 2 | 0 | 0 | 105 | 156 | 0 |
| Telephones - main lines in use | 231 | 2 | 0 | 30 | 231 | 0 |
| Telephones - main lines in use details | 229 | 0 | 0 | 30 | 231 | 0 |
| Sex ratio | 0 | 0 | 227 | 34 | 227 | 0 |
| Sex ratio details | 0 | 0 | 0 | 34 | 227 | 0 |
| Internet users | 220 | 0 | 0 | 41 | 220 | 0 |
| Internet users details | 219 | 0 | 0 | 41 | 220 | 0 |
| Television broadcast stations | 0 | 0 | 230 | 31 | 230 | 0 |
| Television broadcast stations details | 222 | 0 | 0 | 31 | 230 | 0 |
| Geographic coordinates | 0 | 0 | 0 | 3 | 258 | 0 |
| Age structure | 0 | 0 | 229 | 32 | 229 | 0 |
| Age structure details | 0 | 0 | 0 | 32 | 229 | 0 |
| Radio broadcast stations | 0 | 0 | 238 | 23 | 238 | 0 |
| Radio broadcast stations details | 237 | 0 | 0 | 23 | 238 | 0 |
| GDP - composition by sector | 0 | 0 | 216 | 45 | 216 | 0 |
| GDP - composition by sector details | 21 | 0 | 0 | 45 | 216 | 0 |
| Disputes - international | 0 | 0 | 3 | 5 | 256 | 0 |
| Area | 256 | 9 | 0 | 5 | 256 | 0 |
| Area details | 0 | 0 | 0 | 5 | 256 | 0 |
| Irrigated land | 0 | 0 | 184 | 77 | 184 | 0 |
| Irrigated land details | 164 | 0 | 0 | 77 | 184 | 0 |
| Map references | 0 | 0 | 0 | 1 | 260 | 0 |
| Location | 0 | 0 | 0 | 2 | 259 | 0 |
| Country name | 0 | 0 | 0 | 8 | 253 | 0 |
| Coastline | 0 | 0 | 256 | 5 | 256 | 0 |
| Coastline details | 0 | 0 | 0 | 5 | 256 | 0 |
| Imports - partners | 0 | 0 | 184 | 77 | 184 | 0 |
| Imports - partners details | 182 | 0 | 0 | 77 | 184 | 0 |
| Constitution | 0 | 0 | 0 | 26 | 235 | 0 |
| Diplomatic representation in the US | 0 | 0 | 0 | 21 | 240 | 0 |
| Manpower reaching militarily significant age annually | 0 | 0 | 225 | 36 | 225 | 0 |
| Manpower reaching militarily significant age annually details | 0 | 0 | 0 | 36 | 225 | 0 |
| Distribution of family income - Gini index | 0 | 0 | 135 | 126 | 135 | 0 |
| Distribution of family income - Gini index details | 123 | 0 | 0 | 126 | 135 | 0 |
| Oil - production | 210 | 98 | 0 | 51 | 210 | 0 |
| Oil - production details | 12 | 0 | 0 | 51 | 210 | 0 |
| Debt - external | 0 | 0 | 0 | 57 | 204 | 0 |
| Debt - external details | 39 | 0 | 0 | 57 | 204 | 0 |
| Exports | 0 | 0 | 0 | 38 | 223 | 0 |
| Exports details | 54 | 0 | 0 | 38 | 223 | 0 |
| Oil - exports | 207 | 68 | 0 | 54 | 207 | 0 |
| Oil - exports details | 177 | 0 | 0 | 54 | 207 | 0 |
| Median age | 0 | 0 | 226 | 35 | 226 | 0 |
| Median age details | 0 | 0 | 0 | 35 | 226 | 0 |
| Oil - consumption | 208 | 0 | 0 | 53 | 208 | 0 |
| Oil - consumption details | 8 | 0 | 0 | 53 | 208 | 0 |
| Oil - imports | 208 | 2 | 0 | 53 | 208 | 0 |
| Oil - imports details | 182 | 0 | 0 | 53 | 208 | 0 |
| Oil - proved reserves | 195 | 97 | 0 | 66 | 195 | 0 |
| Oil - proved reserves details | 0 | 0 | 0 | 66 | 195 | 0 |
| Natural gas - proved reserves | 206 | 103 | 0 | 55 | 206 | 0 |
| Natural gas - proved reserves details | 0 | 0 | 0 | 55 | 206 | 0 |
| Executive branch | 0 | 0 | 104 | 21 | 240 | 0 |
| Exchange rates | 0 | 0 | 224 | 37 | 224 | 0 |
| Exchange rates details | 0 | 0 | 0 | 37 | 224 | 0 |
| Ethnic groups | 0 | 0 | 190 | 71 | 190 | 0 |
| Ethnic groups details | 15 | 0 | 0 | 71 | 190 | 0 |
| Market value of publicly traded shares | 0 | 0 | 0 | 143 | 118 | 0 |
| Market value of publicly traded shares details | 8 | 0 | 0 | 143 | 118 | 0 |
| Exports - partners | 0 | 0 | 184 | 77 | 184 | 0 |
| Exports - partners details | 182 | 0 | 0 | 77 | 184 | 0 |
| Airports | 235 | 77 | 0 | 26 | 235 | 0 |
| Airports details | 235 | 0 | 0 | 26 | 235 | 0 |
| School life expectancy (primary to tertiary education) | 0 | 0 | 178 | 83 | 178 | 0 |
| School life expectancy (primary to tertiary education) details | 178 | 0 | 0 | 83 | 178 | 0 |
| Population below poverty line | 0 | 0 | 145 | 116 | 145 | 0 |
| Population below poverty line details | 53 | 0 | 0 | 116 | 145 | 0 |
| Household income or consumption by percentage share | 0 | 0 | 128 | 133 | 128 | 0 |
| Household income or consumption by percentage share details | 116 | 0 | 0 | 133 | 128 | 0 |
| Electricity - exports | 0 | 0 | 213 | 48 | 213 | 0 |
| Electricity - exports details | 24 | 0 | 0 | 48 | 213 | 0 |
| Electricity - consumption | 213 | 0 | 0 | 48 | 213 | 0 |
| Electricity - consumption details | 23 | 0 | 0 | 48 | 213 | 0 |
| Capital | 0 | 0 | 9 | 26 | 235 | 0 |
| Background | 0 | 0 | 4 | 1 | 260 | 0 |
| Labor force - by occupation | 0 | 0 | 196 | 65 | 196 | 0 |
| Labor force - by occupation details | 69 | 0 | 0 | 65 | 196 | 0 |
| Exports - commodities | 0 | 0 | 5 | 29 | 232 | 0 |
| Commercial bank prime lending rate | 0 | 0 | 142 | 119 | 142 | 0 |
| Commercial bank prime lending rate details | 1 | 0 | 0 | 119 | 142 | 0 |
| Death rate | 0 | 0 | 223 | 38 | 223 | 0 |
| Death rate details | 0 | 0 | 0 | 38 | 223 | 0 |
| Pipelines | 0 | 0 | 120 | 141 | 120 | 0 |
| Pipelines details | 120 | 0 | 0 | 141 | 120 | 0 |
| GDP (official exchange rate) | 0 | 0 | 0 | 48 | 213 | 0 |
| GDP (official exchange rate) details | 14 | 0 | 0 | 48 | 213 | 0 |
| Stock of direct foreign investment - at home | 0 | 0 | 0 | 165 | 96 | 0 |
| Stock of direct foreign investment - at home details | 6 | 0 | 0 | 165 | 96 | 0 |
| Stock of direct foreign investment - abroad | 0 | 0 | 0 | 180 | 81 | 0 |
| Stock of direct foreign investment - abroad details | 4 | 0 | 0 | 180 | 81 | 0 |
| Administrative divisions | 0 | 0 | 0 | 28 | 233 | 0 |
| Total renewable water resources | 0 | 0 | 171 | 90 | 171 | 0 |
| Total renewable water resources details | 171 | 0 | 0 | 90 | 171 | 0 |
| Freshwater withdrawal (domestic/industrial/agricultural) | 0 | 0 | 168 | 93 | 168 | 0 |
| Freshwater withdrawal (domestic/industrial/agricultural) details | 168 | 0 | 0 | 93 | 168 | 0 |
| Agriculture - products | 0 | 0 | 0 | 28 | 233 | 0 |
| Military branches | 0 | 0 | 0 | 49 | 212 | 0 |
| Birth rate | 0 | 0 | 224 | 37 | 224 | 0 |
| Birth rate details | 0 | 0 | 0 | 37 | 224 | 0 |
| Education expenditures | 0 | 0 | 182 | 79 | 182 | 0 |
| Education expenditures details | 182 | 0 | 0 | 79 | 182 | 0 |
| Budget | 0 | 0 | 0 | 36 | 225 | 0 |
| Budget details | 27 | 0 | 0 | 36 | 225 | 0 |
| Climate | 0 | 0 | 1 | 1 | 260 | 0 |
| Imports - commodities | 0 | 0 | 4 | 29 | 232 | 0 |
| Political parties and leaders | 0 | 0 | 0 | 28 | 233 | 0 |
| Population | 238 | 0 | 0 | 23 | 238 | 0 |
| Population details | 0 | 0 | 0 | 23 | 238 | 0 |
| Nationality | 0 | 0 | 0 | 28 | 233 | 0 |
| Natural resources | 0 | 0 | 0 | 3 | 258 | 0 |
| Net migration rate | 0 | 0 | 181 | 80 | 181 | 0 |
| Net migration rate details | 0 | 0 | 0 | 80 | 181 | 0 |
| Geography - note | 0 | 0 | 3 | 4 | 257 | 0 |
| Political pressure groups and leaders | 0 | 0 | 0 | 29 | 232 | 0 |
| Economy - overview | 0 | 0 | 79 | 1 | 260 | 0 |
| Telephones - mobile cellular | 222 | 3 | 0 | 39 | 222 | 0 |
| Telephones - mobile cellular details | 221 | 0 | 0 | 39 | 222 | 0 |
| Independence | 0 | 0 | 0 | 28 | 233 | 0 |
| Natural gas - exports | 206 | 167 | 0 | 55 | 206 | 0 |
| Natural gas - exports details | 5 | 0 | 0 | 55 | 206 | 0 |
| Natural gas - imports | 205 | 145 | 0 | 56 | 205 | 0 |
| Natural gas - imports details | 12 | 0 | 0 | 56 | 205 | 0 |
| Natural gas - consumption | 209 | 98 | 0 | 52 | 209 | 0 |
| Natural gas - consumption details | 7 | 0 | 0 | 52 | 209 | 0 |
| Religions | 0 | 0 | 204 | 57 | 204 | 0 |
| Religions details | 15 | 0 | 0 | 57 | 204 | 0 |
| Current account balance | 0 | 0 | 0 | 71 | 190 | 0 |
| Current account balance details | 5 | 0 | 0 | 71 | 190 | 0 |
| Public debt | 0 | 0 | 0 | 261 | 0 | 0 |
| Public debt details | 0 | 0 | 0 | 261 | 0 | 0 |
| Investment (gross fixed) | 0 | 0 | 0 | 261 | 0 | 0 |
| Investment (gross fixed) details | 0 | 0 | 0 | 261 | 0 | 0 |
| Internet hosts | 0 | 0 | 0 | 261 | 0 | 0 |
| Internet hosts details | 0 | 0 | 0 | 261 | 0 | 0 |
| Reserves of foreign exchange and gold | 0 | 0 | 0 | 261 | 0 | 0 |
| Reserves of foreign exchange and gold details | 0 | 0 | 0 | 261 | 0 | 0 |
| Electricity - imports | 0 | 0 | 213 | 48 | 213 | 0 |
| Electricity - imports details | 20 | 0 | 0 | 48 | 213 | 0 |
| Urbanization | 0 | 0 | 226 | 35 | 226 | 0 |
| Urbanization details | 0 | 0 | 0 | 35 | 226 | 0 |
| Stock of domestic credit | 0 | 0 | 0 | 88 | 173 | 0 |
| Stock of domestic credit details | 0 | 0 | 0 | 88 | 173 | 0 |
| Military service age and obligation | 6 | 0 | 0 | 255 | 6 | 0 |
| Military service age and obligation details | 0 | 0 | 0 | 261 | 0 | 0 |
| Manpower fit for military service | 0 | 0 | 226 | 35 | 226 | 0 |
| Manpower fit for military service details | 0 | 0 | 0 | 35 | 226 | 0 |
| National holiday | 0 | 0 | 0 | 28 | 233 | 0 |
| Merchant marine | 162 | 49 | 0 | 99 | 162 | 0 |
| Merchant marine details | 162 | 0 | 0 | 99 | 162 | 0 |
| Elevation extremes | 0 | 0 | 255 | 6 | 255 | 0 |
| Elevation extremes details | 1 | 0 | 0 | 6 | 255 | 0 |
| Natural hazards | 0 | 0 | 1 | 7 | 254 | 0 |
| Area - comparative | 0 | 0 | 37 | 1 | 260 | 0 |
| Literacy | 0 | 0 | 214 | 47 | 214 | 0 |
| Literacy details | 7 | 0 | 0 | 47 | 214 | 0 |
| Life expectancy at birth | 0 | 0 | 224 | 37 | 224 | 0 |
| Life expectancy at birth details | 0 | 0 | 0 | 37 | 224 | 0 |
| Legislative branch | 0 | 0 | 102 | 28 | 233 | 0 |
| Legal system | 0 | 0 | 0 | 11 | 250 | 0 |
| International organization participation | 0 | 0 | 0 | 26 | 235 | 0 |
| Maritime claims | 0 | 0 | 196 | 65 | 196 | 0 |
| Maritime claims details | 0 | 0 | 0 | 65 | 196 | 0 |
| Manpower available for military service | 0 | 0 | 205 | 56 | 205 | 0 |
| Manpower available for military service details | 0 | 0 | 0 | 56 | 205 | 0 |
| Military expenditures | 0 | 0 | 173 | 88 | 173 | 0 |
| Military expenditures details | 68 | 0 | 0 | 88 | 173 | 0 |
| Environment - international agreements | 0 | 0 | 0 | 59 | 202 | 0 |
| Environment - current issues | 0 | 0 | 1 | 2 | 259 | 0 |
| Airports - with unpaved runways | 0 | 0 | 194 | 67 | 194 | 0 |
| Airports - with unpaved runways details | 194 | 0 | 0 | 67 | 194 | 0 |
| Airports - with paved runways | 0 | 0 | 232 | 29 | 232 | 0 |
| Airports - with paved runways details | 232 | 0 | 0 | 29 | 232 | 0 |
| Electricity - production | 212 | 0 | 0 | 49 | 212 | 0 |
| Electricity - production details | 24 | 0 | 0 | 49 | 212 | 0 |
| Railways | 133 | 0 | 0 | 128 | 133 | 0 |
| Railways details | 133 | 0 | 0 | 128 | 133 | 0 |
| Ports and terminals | 0 | 0 | 0 | 26 | 235 | 0 |
| Suffrage | 0 | 0 | 222 | 39 | 222 | 0 |
| Suffrage details | 0 | 0 | 0 | 39 | 222 | 0 |
| Industrial production growth rate | 0 | 0 | 168 | 93 | 168 | 0 |
| Industrial production growth rate details | 6 | 0 | 0 | 93 | 168 | 0 |
| Terrain | 0 | 0 | 1 | 4 | 257 | 0 |
| Telephone system | 0 | 0 | 3 | 20 | 241 | 0 |
| Total fertility rate | 0 | 0 | 224 | 37 | 224 | 0 |
| Total fertility rate details | 0 | 0 | 0 | 37 | 224 | 0 |
| Unemployment rate | 0 | 0 | 200 | 61 | 200 | 0 |
| Unemployment rate details | 38 | 0 | 0 | 61 | 200 | 0 |
| Government type | 0 | 0 | 0 | 28 | 233 | 0 |
| Flag description | 0 | 0 | 0 | 13 | 248 | 0 |
| Illicit drugs | 0 | 0 | 0 | 122 | 139 | 0 |
| Imports | 0 | 0 | 0 | 43 | 218 | 0 |
| Imports details | 51 | 0 | 0 | 43 | 218 | 0 |
| Roadways | 220 | 1 | 0 | 41 | 220 | 0 |
| Roadways details | 220 | 0 | 0 | 41 | 220 | 0 |
| Population growth rate | 0 | 0 | 234 | 27 | 234 | 0 |
| Population growth rate details | 0 | 0 | 0 | 27 | 234 | 0 |
| GDP - real growth rate | 0 | 0 | 217 | 44 | 217 | 0 |
| GDP - real growth rate details | 8 | 0 | 0 | 45 | 216 | 0 |
| Heliports | 0 | 0 | 100 | 161 | 100 | 0 |
| Heliports details | 100 | 0 | 0 | 161 | 100 | 0 |
| GDP (purchasing power parity) | 0 | 0 | 0 | 33 | 228 | 0 |
| GDP (purchasing power parity) details | 4 | 0 | 0 | 33 | 228 | 0 |
| Diplomatic representation from the US | 0 | 0 | 1 | 19 | 242 | 0 |
| GDP - per capita (PPP) | 0 | 0 | 0 | 32 | 229 | 0 |
| GDP - per capita (PPP) details | 4 | 0 | 0 | 32 | 229 | 0 |
| Natural gas - production | 209 | 117 | 0 | 52 | 209 | 0 |
| Natural gas - production details | 7 | 0 | 0 | 52 | 209 | 0 |
+------------------------------------------------------------------+--------+-----------+---------+------+--------+------+
real 0m1.203s
user 0m1.040s
sys 0m0.052s
Raw
cia-all.txt
time ./bin/csv2psql analyze data/cia-data-all.csv
{
"data/cia-data-all.csv": {
"columns": {
"id": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 0
},
"String": {
"count": 261,
"min": 4,
"max": 81
},
"Uuid": {
"count": 0
}
},
"Labor force": {
"Bigint": {
"count": 222,
"min": 15,
"max": 807300000
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 39
},
"String": {
"count": 222,
"min": 2,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Labor force details": {
"Bigint": {
"count": 66,
"min": 1991,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 39
},
"String": {
"count": 222,
"min": 4,
"max": 12
},
"Uuid": {
"count": 0
}
},
"Judicial branch": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 30
},
"String": {
"count": 231,
"min": 4,
"max": 1014
},
"Uuid": {
"count": 0
}
},
"Land use": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 242,
"min": 0.0,
"max": 23.32
},
"Null": {
"count": 19
},
"String": {
"count": 242,
"min": 3,
"max": 5
},
"Uuid": {
"count": 0
}
},
"Land use details": {
"Bigint": {
"count": 241,
"min": 2001,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 19
},
"String": {
"count": 242,
"min": 2,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Land boundaries": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 252,
"min": 0.0,
"max": 8893.0
},
"Null": {
"count": 9
},
"String": {
"count": 252,
"min": 3,
"max": 6
},
"Uuid": {
"count": 0
}
},
"Land boundaries details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 9
},
"String": {
"count": 252,
"min": 2,
"max": 2
},
"Uuid": {
"count": 0
}
},
"Infant mortality rate": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 224,
"min": 2.31,
"max": 180.21
},
"Null": {
"count": 37
},
"String": {
"count": 224,
"min": 3,
"max": 6
},
"Uuid": {
"count": 0
}
},
"Infant mortality rate details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 37
},
"String": {
"count": 224,
"min": 9,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Industries": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 24
},
"String": {
"count": 237,
"min": 4,
"max": 562
},
"Uuid": {
"count": 0
}
},
"Waterways": {
"Bigint": {
"count": 109,
"min": 5,
"max": 110000
},
"Character": {
"count": 2
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 152
},
"String": {
"count": 109,
"min": 1,
"max": 6
},
"Uuid": {
"count": 0
}
},
"Waterways details": {
"Bigint": {
"count": 109,
"min": 2003,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 152
},
"String": {
"count": 109,
"min": 4,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Inflation rate (consumer prices)": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 222,
"min": -3.5,
"max": 11200000.0
},
"Null": {
"count": 39
},
"String": {
"count": 222,
"min": 3,
"max": 10
},
"Uuid": {
"count": 0
}
},
"Inflation rate (consumer prices) details": {
"Bigint": {
"count": 31,
"min": 1995,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 39
},
"String": {
"count": 222,
"min": 4,
"max": 18
},
"Uuid": {
"count": 0
}
},
"Languages": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 73,
"min": 0.2,
"max": 100.0
},
"Null": {
"count": 188
},
"String": {
"count": 73,
"min": 3,
"max": 5
},
"Uuid": {
"count": 0
}
},
"Languages details": {
"Bigint": {
"count": 3,
"min": 1999,
"max": 2007
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 188
},
"String": {
"count": 73,
"min": 2,
"max": 11
},
"Uuid": {
"count": 0
}
},
"Internet country code": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 19
},
"String": {
"count": 242,
"min": 3,
"max": 131
},
"Uuid": {
"count": 0
}
},
"HIV/AIDS - adult prevalence rate": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 170,
"min": 0.0,
"max": 26.1
},
"Null": {
"count": 91
},
"String": {
"count": 170,
"min": 3,
"max": 4
},
"Uuid": {
"count": 0
}
},
"HIV/AIDS - adult prevalence rate details": {
"Bigint": {
"count": 2,
"min": 2001,
"max": 2005
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 91
},
"String": {
"count": 170,
"min": 2,
"max": 9
},
"Uuid": {
"count": 0
}
},
"HIV/AIDS - people living with HIV/AIDS": {
"Bigint": {
"count": 165,
"min": 0,
"max": 33000000
},
"Character": {
"count": 1
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 96
},
"String": {
"count": 165,
"min": 1,
"max": 8
},
"Uuid": {
"count": 0
}
},
"HIV/AIDS - people living with HIV/AIDS details": {
"Bigint": {
"count": 2,
"min": 2001,
"max": 2005
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 96
},
"String": {
"count": 165,
"min": 2,
"max": 9
},
"Uuid": {
"count": 0
}
},
"HIV/AIDS - deaths": {
"Bigint": {
"count": 156,
"min": 0,
"max": 350000
},
"Character": {
"count": 1
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 105
},
"String": {
"count": 156,
"min": 1,
"max": 6
},
"Uuid": {
"count": 0
}
},
"HIV/AIDS - deaths details": {
"Bigint": {
"count": 2,
"min": 2001,
"max": 2005
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 105
},
"String": {
"count": 156,
"min": 2,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Telephones - main lines in use": {
"Bigint": {
"count": 231,
"min": 0,
"max": 365400000
},
"Character": {
"count": 2
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 30
},
"String": {
"count": 231,
"min": 1,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Telephones - main lines in use details": {
"Bigint": {
"count": 229,
"min": 1992,
"max": 2009
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 30
},
"String": {
"count": 231,
"min": 2,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Sex ratio": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 227,
"min": 0.44,
"max": 1.06
},
"Null": {
"count": 34
},
"String": {
"count": 227,
"min": 3,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Sex ratio details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 34
},
"String": {
"count": 227,
"min": 9,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Internet users": {
"Bigint": {
"count": 220,
"min": 93,
"max": 253000000
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 41
},
"String": {
"count": 220,
"min": 2,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Internet users details": {
"Bigint": {
"count": 219,
"min": 2000,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 41
},
"String": {
"count": 220,
"min": 4,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Television broadcast stations": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 230,
"min": 0.0,
"max": 7306.0
},
"Null": {
"count": 31
},
"String": {
"count": 230,
"min": 3,
"max": 6
},
"Uuid": {
"count": 0
}
},
"Television broadcast stations details": {
"Bigint": {
"count": 222,
"min": 1995,
"max": 2009
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 31
},
"String": {
"count": 230,
"min": 2,
"max": 14
},
"Uuid": {
"count": 0
}
},
"Geographic coordinates": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 3
},
"String": {
"count": 258,
"min": 13,
"max": 434
},
"Uuid": {
"count": 0
}
},
"Age structure": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 229,
"min": 0.9,
"max": 16.9
},
"Null": {
"count": 32
},
"String": {
"count": 229,
"min": 3,
"max": 5
},
"Uuid": {
"count": 0
}
},
"Age structure details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 32
},
"String": {
"count": 229,
"min": 9,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Radio broadcast stations": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 238,
"min": 0.0,
"max": 698.0
},
"Null": {
"count": 23
},
"String": {
"count": 238,
"min": 3,
"max": 5
},
"Uuid": {
"count": 0
}
},
"Radio broadcast stations details": {
"Bigint": {
"count": 237,
"min": 1998,
"max": 2009
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 23
},
"String": {
"count": 238,
"min": 2,
"max": 4
},
"Uuid": {
"count": 0
}
},
"GDP - composition by sector": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 216,
"min": 0.0,
"max": 95.0
},
"Null": {
"count": 45
},
"String": {
"count": 216,
"min": 3,
"max": 4
},
"Uuid": {
"count": 0
}
},
"GDP - composition by sector details": {
"Bigint": {
"count": 21,
"min": 1996,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 45
},
"String": {
"count": 216,
"min": 4,
"max": 12
},
"Uuid": {
"count": 0
}
},
"Disputes - international": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 3,
"min": 0.0,
"max": 0.0
},
"Null": {
"count": 5
},
"String": {
"count": 256,
"min": 4,
"max": 3218
},
"Uuid": {
"count": 0
}
},
"Area": {
"Bigint": {
"count": 256,
"min": 0,
"max": 155557000
},
"Character": {
"count": 9
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 5
},
"String": {
"count": 256,
"min": 1,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Area details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 5
},
"String": {
"count": 256,
"min": 2,
"max": 2
},
"Uuid": {
"count": 0
}
},
"Irrigated land": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 184,
"min": 0.0,
"max": 558080.0
},
"Null": {
"count": 77
},
"String": {
"count": 184,
"min": 3,
"max": 8
},
"Uuid": {
"count": 0
}
},
"Irrigated land details": {
"Bigint": {
"count": 164,
"min": 2002,
"max": 2003
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 77
},
"String": {
"count": 184,
"min": 2,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Map references": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 1
},
"String": {
"count": 260,
"min": 4,
"max": 163
},
"Uuid": {
"count": 0
}
},
"Location": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 2
},
"String": {
"count": 259,
"min": 26,
"max": 1008
},
"Uuid": {
"count": 0
}
},
"Country name": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 8
},
"String": {
"count": 253,
"min": 59,
"max": 603
},
"Uuid": {
"count": 0
}
},
"Coastline": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 256,
"min": 0.0,
"max": 202080.0
},
"Null": {
"count": 5
},
"String": {
"count": 256,
"min": 3,
"max": 8
},
"Uuid": {
"count": 0
}
},
"Coastline details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 5
},
"String": {
"count": 256,
"min": 2,
"max": 2
},
"Uuid": {
"count": 0
}
},
"Imports - partners": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 184,
"min": 1.8,
"max": 11.2
},
"Null": {
"count": 77
},
"String": {
"count": 184,
"min": 3,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Imports - partners details": {
"Bigint": {
"count": 182,
"min": 2008,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 77
},
"String": {
"count": 184,
"min": 4,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Constitution": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 26
},
"String": {
"count": 235,
"min": 10,
"max": 1171
},
"Uuid": {
"count": 0
}
},
"Diplomatic representation in the US": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 21
},
"String": {
"count": 240,
"min": 4,
"max": 864
},
"Uuid": {
"count": 0
}
},
"Manpower reaching militarily significant age annually": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 225,
"min": 20.0,
"max": 10820590.0
},
"Null": {
"count": 36
},
"String": {
"count": 225,
"min": 4,
"max": 10
},
"Uuid": {
"count": 0
}
},
"Manpower reaching militarily significant age annually details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 36
},
"String": {
"count": 225,
"min": 9,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Distribution of family income - Gini index": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 135,
"min": 23.0,
"max": 70.7
},
"Null": {
"count": 126
},
"String": {
"count": 135,
"min": 4,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Distribution of family income - Gini index details": {
"Bigint": {
"count": 123,
"min": 1989,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 126
},
"String": {
"count": 135,
"min": 4,
"max": 18
},
"Uuid": {
"count": 0
}
},
"Oil - production": {
"Bigint": {
"count": 210,
"min": 0,
"max": 9980000
},
"Character": {
"count": 98
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 51
},
"String": {
"count": 210,
"min": 1,
"max": 7
},
"Uuid": {
"count": 0
}
},
"Oil - production details": {
"Bigint": {
"count": 12,
"min": 2004,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 51
},
"String": {
"count": 210,
"min": 4,
"max": 21
},
"Uuid": {
"count": 0
}
},
"Debt - external": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 57
},
"String": {
"count": 204,
"min": 3,
"max": 20
},
"Uuid": {
"count": 0
}
},
"Debt - external details": {
"Bigint": {
"count": 39,
"min": 1996,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 57
},
"String": {
"count": 204,
"min": 4,
"max": 22
},
"Uuid": {
"count": 0
}
},
"Exports": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 38
},
"String": {
"count": 223,
"min": 3,
"max": 19
},
"Uuid": {
"count": 0
}
},
"Exports details": {
"Bigint": {
"count": 54,
"min": 2000,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 38
},
"String": {
"count": 223,
"min": 4,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Oil - exports": {
"Bigint": {
"count": 207,
"min": 0,
"max": 8200000
},
"Character": {
"count": 68
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 54
},
"String": {
"count": 207,
"min": 1,
"max": 7
},
"Uuid": {
"count": 0
}
},
"Oil - exports details": {
"Bigint": {
"count": 177,
"min": 2005,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 54
},
"String": {
"count": 207,
"min": 4,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Median age": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 226,
"min": 15.0,
"max": 45.7
},
"Null": {
"count": 35
},
"String": {
"count": 226,
"min": 4,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Median age details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 35
},
"String": {
"count": 226,
"min": 9,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Oil - consumption": {
"Bigint": {
"count": 208,
"min": 20,
"max": 20680000
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 53
},
"String": {
"count": 208,
"min": 2,
"max": 8
},
"Uuid": {
"count": 0
}
},
"Oil - consumption details": {
"Bigint": {
"count": 8,
"min": 2004,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 53
},
"String": {
"count": 208,
"min": 4,
"max": 12
},
"Uuid": {
"count": 0
}
},
"Oil - imports": {
"Bigint": {
"count": 208,
"min": 0,
"max": 13710000
},
"Character": {
"count": 2
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 53
},
"String": {
"count": 208,
"min": 1,
"max": 8
},
"Uuid": {
"count": 0
}
},
"Oil - imports details": {
"Bigint": {
"count": 182,
"min": 2005,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 53
},
"String": {
"count": 208,
"min": 4,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Oil - proved reserves": {
"Bigint": {
"count": 195,
"min": 0,
"max": 264300000000
},
"Character": {
"count": 97
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 66
},
"String": {
"count": 195,
"min": 1,
"max": 12
},
"Uuid": {
"count": 0
}
},
"Oil - proved reserves details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 66
},
"String": {
"count": 195,
"min": 14,
"max": 19
},
"Uuid": {
"count": 0
}
},
"Natural gas - proved reserves": {
"Bigint": {
"count": 206,
"min": 0,
"max": 44650000000000
},
"Character": {
"count": 103
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 55
},
"String": {
"count": 206,
"min": 1,
"max": 14
},
"Uuid": {
"count": 0
}
},
"Natural gas - proved reserves details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 55
},
"String": {
"count": 206,
"min": 14,
"max": 19
},
"Uuid": {
"count": 0
}
},
"Executive branch": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 104,
"min": 0.0,
"max": 0.0
},
"Null": {
"count": 21
},
"String": {
"count": 240,
"min": 4,
"max": 1845
},
"Uuid": {
"count": 0
}
},
"Exchange rates": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 224,
"min": 0.27,
"max": 15746.0
},
"Null": {
"count": 37
},
"String": {
"count": 224,
"min": 3,
"max": 7
},
"Uuid": {
"count": 0
}
},
"Exchange rates details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 37
},
"String": {
"count": 224,
"min": 2,
"max": 2
},
"Uuid": {
"count": 0
}
},
"Ethnic groups": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 190,
"min": 0.06,
"max": 99.0
},
"Null": {
"count": 71
},
"String": {
"count": 190,
"min": 3,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Ethnic groups details": {
"Bigint": {
"count": 15,
"min": 1998,
"max": 2007
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 71
},
"String": {
"count": 190,
"min": 2,
"max": 13
},
"Uuid": {
"count": 0
}
},
"Market value of publicly traded shares": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 143
},
"String": {
"count": 118,
"min": 12,
"max": 20
},
"Uuid": {
"count": 0
}
},
"Market value of publicly traded shares details": {
"Bigint": {
"count": 8,
"min": 2003,
"max": 2006
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 143
},
"String": {
"count": 118,
"min": 4,
"max": 21
},
"Uuid": {
"count": 0
}
},
"Exports - partners": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 184,
"min": 0.7,
"max": 17.7
},
"Null": {
"count": 77
},
"String": {
"count": 184,
"min": 3,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Exports - partners details": {
"Bigint": {
"count": 182,
"min": 2008,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 77
},
"String": {
"count": 184,
"min": 4,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Airports": {
"Bigint": {
"count": 235,
"min": 1,
"max": 14951
},
"Character": {
"count": 77
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 26
},
"String": {
"count": 235,
"min": 1,
"max": 5
},
"Uuid": {
"count": 0
}
},
"Airports details": {
"Bigint": {
"count": 235,
"min": 2006,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 26
},
"String": {
"count": 235,
"min": 4,
"max": 4
},
"Uuid": {
"count": 0
}
},
"School life expectancy (primary to tertiary education)": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 178,
"min": 3.0,
"max": 20.0
},
"Null": {
"count": 83
},
"String": {
"count": 178,
"min": 3,
"max": 4
},
"Uuid": {
"count": 0
}
},
"School life expectancy (primary to tertiary education) details": {
"Bigint": {
"count": 178,
"min": 2000,
"max": 2007
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 83
},
"String": {
"count": 178,
"min": 4,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Population below poverty line": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 145,
"min": 0.95,
"max": 86.0
},
"Null": {
"count": 116
},
"String": {
"count": 145,
"min": 3,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Population below poverty line details": {
"Bigint": {
"count": 53,
"min": 1993,
"max": 2007
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 116
},
"String": {
"count": 145,
"min": 4,
"max": 17
},
"Uuid": {
"count": 0
}
},
"Household income or consumption by percentage share": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 128,
"min": 0.5,
"max": 27.0
},
"Null": {
"count": 133
},
"String": {
"count": 128,
"min": 3,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Household income or consumption by percentage share details": {
"Bigint": {
"count": 116,
"min": 1993,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 133
},
"String": {
"count": 128,
"min": 4,
"max": 18
},
"Uuid": {
"count": 0
}
},
"Electricity - exports": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 213,
"min": 0.0,
"max": 67600000000.0
},
"Null": {
"count": 48
},
"String": {
"count": 213,
"min": 3,
"max": 13
},
"Uuid": {
"count": 0
}
},
"Electricity - exports details": {
"Bigint": {
"count": 24,
"min": 2002,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 48
},
"String": {
"count": 213,
"min": 4,
"max": 17
},
"Uuid": {
"count": 0
}
},
"Electricity - consumption": {
"Bigint": {
"count": 213,
"min": 48300,
"max": 3892000000000
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 48
},
"String": {
"count": 213,
"min": 5,
"max": 13
},
"Uuid": {
"count": 0
}
},
"Electricity - consumption details": {
"Bigint": {
"count": 23,
"min": 2002,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 48
},
"String": {
"count": 213,
"min": 4,
"max": 12
},
"Uuid": {
"count": 0
}
},
"Capital": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 9,
"min": 0.0,
"max": 0.0
},
"Null": {
"count": 26
},
"String": {
"count": 235,
"min": 81,
"max": 456
},
"Uuid": {
"count": 0
}
},
"Background": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 4,
"min": 0.0,
"max": 0.0
},
"Null": {
"count": 1
},
"String": {
"count": 260,
"min": 152,
"max": 4598
},
"Uuid": {
"count": 0
}
},
"Labor force - by occupation": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 196,
"min": 0.0,
"max": 90.0
},
"Null": {
"count": 65
},
"String": {
"count": 196,
"min": 3,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Labor force - by occupation details": {
"Bigint": {
"count": 69,
"min": 1975,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 65
},
"String": {
"count": 196,
"min": 2,
"max": 22
},
"Uuid": {
"count": 0
}
},
"Exports - commodities": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 5,
"min": 0.0,
"max": 0.0
},
"Null": {
"count": 29
},
"String": {
"count": 232,
"min": 4,
"max": 466
},
"Uuid": {
"count": 0
}
},
"Commercial bank prime lending rate": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 142,
"min": 3.15,
"max": 578.96
},
"Null": {
"count": 119
},
"String": {
"count": 142,
"min": 3,
"max": 6
},
"Uuid": {
"count": 0
}
},
"Commercial bank prime lending rate details": {
"Bigint": {
"count": 1,
"min": 2004,
"max": 2004
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 119
},
"String": {
"count": 142,
"min": 4,
"max": 16
},
"Uuid": {
"count": 0
}
},
"Death rate": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 223,
"min": 2.11,
"max": 30.83
},
"Null": {
"count": 38
},
"String": {
"count": 223,
"min": 3,
"max": 5
},
"Uuid": {
"count": 0
}
},
"Death rate details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 38
},
"String": {
"count": 223,
"min": 9,
"max": 14
},
"Uuid": {
"count": 0
}
},
"Pipelines": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 120,
"min": 1.0,
"max": 244620.0
},
"Null": {
"count": 141
},
"String": {
"count": 120,
"min": 3,
"max": 8
},
"Uuid": {
"count": 0
}
},
"Pipelines details": {
"Bigint": {
"count": 120,
"min": 2006,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 141
},
"String": {
"count": 120,
"min": 4,
"max": 4
},
"Uuid": {
"count": 0
}
},
"GDP (official exchange rate)": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 48
},
"String": {
"count": 213,
"min": 12,
"max": 20
},
"Uuid": {
"count": 0
}
},
"GDP (official exchange rate) details": {
"Bigint": {
"count": 14,
"min": 2000,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 48
},
"String": {
"count": 213,
"min": 4,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Stock of direct foreign investment - at home": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 165
},
"String": {
"count": 96,
"min": 11,
"max": 19
},
"Uuid": {
"count": 0
}
},
"Stock of direct foreign investment - at home details": {
"Bigint": {
"count": 6,
"min": 2007,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 165
},
"String": {
"count": 96,
"min": 4,
"max": 21
},
"Uuid": {
"count": 0
}
},
"Stock of direct foreign investment - abroad": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 180
},
"String": {
"count": 81,
"min": 12,
"max": 19
},
"Uuid": {
"count": 0
}
},
"Stock of direct foreign investment - abroad details": {
"Bigint": {
"count": 4,
"min": 2007,
"max": 2007
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 180
},
"String": {
"count": 81,
"min": 4,
"max": 21
},
"Uuid": {
"count": 0
}
},
"Administrative divisions": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 28
},
"String": {
"count": 233,
"min": 4,
"max": 3178
},
"Uuid": {
"count": 0
}
},
"Total renewable water resources": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 171,
"min": 0.02,
"max": 8233.0
},
"Null": {
"count": 90
},
"String": {
"count": 171,
"min": 3,
"max": 6
},
"Uuid": {
"count": 0
}
},
"Total renewable water resources details": {
"Bigint": {
"count": 171,
"min": 1970,
"max": 2005
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 90
},
"String": {
"count": 171,
"min": 4,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Freshwater withdrawal (domestic/industrial/agricultural)": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 168,
"min": 0.0,
"max": 585.0
},
"Null": {
"count": 93
},
"String": {
"count": 168,
"min": 3,
"max": 6
},
"Uuid": {
"count": 0
}
},
"Freshwater withdrawal (domestic/industrial/agricultural) details": {
"Bigint": {
"count": 168,
"min": 1975,
"max": 2003
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 93
},
"String": {
"count": 168,
"min": 4,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Agriculture - products": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 28
},
"String": {
"count": 233,
"min": 2,
"max": 260
},
"Uuid": {
"count": 0
}
},
"Military branches": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 49
},
"String": {
"count": 212,
"min": 11,
"max": 491
},
"Uuid": {
"count": 0
}
},
"Birth rate": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 224,
"min": 7.42,
"max": 51.6
},
"Null": {
"count": 37
},
"String": {
"count": 224,
"min": 3,
"max": 5
},
"Uuid": {
"count": 0
}
},
"Birth rate details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 37
},
"String": {
"count": 224,
"min": 9,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Education expenditures": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 182,
"min": 0.2,
"max": 17.8
},
"Null": {
"count": 79
},
"String": {
"count": 182,
"min": 3,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Education expenditures details": {
"Bigint": {
"count": 182,
"min": 1991,
"max": 2007
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 79
},
"String": {
"count": 182,
"min": 4,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Budget": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 36
},
"String": {
"count": 225,
"min": 8,
"max": 19
},
"Uuid": {
"count": 0
}
},
"Budget details": {
"Bigint": {
"count": 27,
"min": 1997,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 36
},
"String": {
"count": 225,
"min": 4,
"max": 12
},
"Uuid": {
"count": 0
}
},
"Climate": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 1,
"min": 0.0,
"max": 0.0
},
"Null": {
"count": 1
},
"String": {
"count": 260,
"min": 8,
"max": 813
},
"Uuid": {
"count": 0
}
},
"Imports - commodities": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 4,
"min": 0.0,
"max": 0.0
},
"Null": {
"count": 29
},
"String": {
"count": 232,
"min": 2,
"max": 441
},
"Uuid": {
"count": 0
}
},
"Political parties and leaders": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 28
},
"String": {
"count": 233,
"min": 4,
"max": 5232
},
"Uuid": {
"count": 0
}
},
"Population": {
"Bigint": {
"count": 238,
"min": 48,
"max": 1338612968
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 23
},
"String": {
"count": 238,
"min": 2,
"max": 10
},
"Uuid": {
"count": 0
}
},
"Population details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 23
},
"String": {
"count": 238,
"min": 2,
"max": 14
},
"Uuid": {
"count": 0
}
},
"Nationality": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 28
},
"String": {
"count": 233,
"min": 22,
"max": 166
},
"Uuid": {
"count": 0
}
},
"Natural resources": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 3
},
"String": {
"count": 258,
"min": 4,
"max": 352
},
"Uuid": {
"count": 0
}
},
"Net migration rate": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 181,
"min": -21.03,
"max": 22.98
},
"Null": {
"count": 80
},
"String": {
"count": 181,
"min": 3,
"max": 6
},
"Uuid": {
"count": 0
}
},
"Net migration rate details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 80
},
"String": {
"count": 181,
"min": 9,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Geography - note": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 3,
"min": 0.0,
"max": 0.0
},
"Null": {
"count": 4
},
"String": {
"count": 257,
"min": 17,
"max": 945
},
"Uuid": {
"count": 0
}
},
"Political pressure groups and leaders": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 29
},
"String": {
"count": 232,
"min": 2,
"max": 1120
},
"Uuid": {
"count": 0
}
},
"Economy - overview": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 79,
"min": 0.0,
"max": 0.0
},
"Null": {
"count": 1
},
"String": {
"count": 260,
"min": 20,
"max": 3731
},
"Uuid": {
"count": 0
}
},
"Telephones - mobile cellular": {
"Bigint": {
"count": 222,
"min": 0,
"max": 547286000
},
"Character": {
"count": 3
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 39
},
"String": {
"count": 222,
"min": 1,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Telephones - mobile cellular details": {
"Bigint": {
"count": 221,
"min": 1999,
"max": 2009
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 39
},
"String": {
"count": 222,
"min": 2,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Independence": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 28
},
"String": {
"count": 233,
"min": 12,
"max": 715
},
"Uuid": {
"count": 0
}
},
"Natural gas - exports": {
"Bigint": {
"count": 206,
"min": 0,
"max": 173000000000
},
"Character": {
"count": 167
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 55
},
"String": {
"count": 206,
"min": 1,
"max": 12
},
"Uuid": {
"count": 0
}
},
"Natural gas - exports details": {
"Bigint": {
"count": 5,
"min": 2007,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 55
},
"String": {
"count": 206,
"min": 4,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Natural gas - imports": {
"Bigint": {
"count": 205,
"min": 0,
"max": 130300000000
},
"Character": {
"count": 145
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 56
},
"String": {
"count": 205,
"min": 1,
"max": 12
},
"Uuid": {
"count": 0
}
},
"Natural gas - imports details": {
"Bigint": {
"count": 12,
"min": 2005,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 56
},
"String": {
"count": 205,
"min": 4,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Natural gas - consumption": {
"Bigint": {
"count": 209,
"min": 0,
"max": 652900000000
},
"Character": {
"count": 98
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 52
},
"String": {
"count": 209,
"min": 1,
"max": 12
},
"Uuid": {
"count": 0
}
},
"Natural gas - consumption details": {
"Bigint": {
"count": 7,
"min": 2007,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 52
},
"String": {
"count": 209,
"min": 4,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Religions": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 204,
"min": 0.1,
"max": 100.0
},
"Null": {
"count": 57
},
"String": {
"count": 204,
"min": 3,
"max": 5
},
"Uuid": {
"count": 0
}
},
"Religions details": {
"Bigint": {
"count": 15,
"min": 1991,
"max": 2006
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 57
},
"String": {
"count": 204,
"min": 2,
"max": 24
},
"Uuid": {
"count": 0
}
},
"Current account balance": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 71
},
"String": {
"count": 190,
"min": 11,
"max": 18
},
"Uuid": {
"count": 0
}
},
"Current account balance details": {
"Bigint": {
"count": 5,
"min": 1999,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 71
},
"String": {
"count": 190,
"min": 4,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Public debt": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 261
},
"String": {
"count": 0,
"min": null,
"max": null
},
"Uuid": {
"count": 0
}
},
"Public debt details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 261
},
"String": {
"count": 0,
"min": null,
"max": null
},
"Uuid": {
"count": 0
}
},
"Investment (gross fixed)": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 261
},
"String": {
"count": 0,
"min": null,
"max": null
},
"Uuid": {
"count": 0
}
},
"Investment (gross fixed) details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 261
},
"String": {
"count": 0,
"min": null,
"max": null
},
"Uuid": {
"count": 0
}
},
"Internet hosts": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 261
},
"String": {
"count": 0,
"min": null,
"max": null
},
"Uuid": {
"count": 0
}
},
"Internet hosts details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 261
},
"String": {
"count": 0,
"min": null,
"max": null
},
"Uuid": {
"count": 0
}
},
"Reserves of foreign exchange and gold": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 261
},
"String": {
"count": 0,
"min": null,
"max": null
},
"Uuid": {
"count": 0
}
},
"Reserves of foreign exchange and gold details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 261
},
"String": {
"count": 0,
"min": null,
"max": null
},
"Uuid": {
"count": 0
}
},
"Electricity - imports": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 213,
"min": 0.0,
"max": 51400000000.0
},
"Null": {
"count": 48
},
"String": {
"count": 213,
"min": 3,
"max": 13
},
"Uuid": {
"count": 0
}
},
"Electricity - imports details": {
"Bigint": {
"count": 20,
"min": 2002,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 48
},
"String": {
"count": 213,
"min": 4,
"max": 17
},
"Uuid": {
"count": 0
}
},
"Urbanization": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 226,
"min": -1.5,
"max": 6.8
},
"Null": {
"count": 35
},
"String": {
"count": 226,
"min": 3,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Urbanization details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 35
},
"String": {
"count": 226,
"min": 2,
"max": 2
},
"Uuid": {
"count": 0
}
},
"Stock of domestic credit": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 88
},
"String": {
"count": 173,
"min": 11,
"max": 20
},
"Uuid": {
"count": 0
}
},
"Stock of domestic credit details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 88
},
"String": {
"count": 173,
"min": 16,
"max": 16
},
"Uuid": {
"count": 0
}
},
"Military service age and obligation": {
"Bigint": {
"count": 6,
"min": 2004,
"max": 2004
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 255
},
"String": {
"count": 6,
"min": 4,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Military service age and obligation details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 261
},
"String": {
"count": 0,
"min": null,
"max": null
},
"Uuid": {
"count": 0
}
},
"Manpower fit for military service": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 226,
"min": 1126.0,
"max": 296763134.0
},
"Null": {
"count": 35
},
"String": {
"count": 226,
"min": 6,
"max": 11
},
"Uuid": {
"count": 0
}
},
"Manpower fit for military service details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 35
},
"String": {
"count": 226,
"min": 9,
"max": 9
},
"Uuid": {
"count": 0
}
},
"National holiday": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 28
},
"String": {
"count": 233,
"min": 18,
"max": 383
},
"Uuid": {
"count": 0
}
},
"Merchant marine": {
"Bigint": {
"count": 162,
"min": 1,
"max": 6323
},
"Character": {
"count": 49
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 99
},
"String": {
"count": 162,
"min": 1,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Merchant marine details": {
"Bigint": {
"count": 162,
"min": 2008,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 99
},
"String": {
"count": 162,
"min": 4,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Elevation extremes": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 255,
"min": -10924.0,
"max": 3139.0
},
"Null": {
"count": 6
},
"String": {
"count": 255,
"min": 3,
"max": 8
},
"Uuid": {
"count": 0
}
},
"Elevation extremes details": {
"Bigint": {
"count": 1,
"min": 2006,
"max": 2006
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 6
},
"String": {
"count": 255,
"min": 2,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Natural hazards": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 1,
"min": 0.0,
"max": 0.0
},
"Null": {
"count": 7
},
"String": {
"count": 254,
"min": 2,
"max": 699
},
"Uuid": {
"count": 0
}
},
"Area - comparative": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 37,
"min": 0.0,
"max": 3.5
},
"Null": {
"count": 1
},
"String": {
"count": 260,
"min": 2,
"max": 732
},
"Uuid": {
"count": 0
}
},
"Literacy": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 214,
"min": 21.8,
"max": 100.0
},
"Null": {
"count": 47
},
"String": {
"count": 214,
"min": 4,
"max": 5
},
"Uuid": {
"count": 0
}
},
"Literacy details": {
"Bigint": {
"count": 7,
"min": 1999,
"max": 2004
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 47
},
"String": {
"count": 214,
"min": 2,
"max": 11
},
"Uuid": {
"count": 0
}
},
"Life expectancy at birth": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 224,
"min": 31.88,
"max": 84.36
},
"Null": {
"count": 37
},
"String": {
"count": 224,
"min": 4,
"max": 5
},
"Uuid": {
"count": 0
}
},
"Life expectancy at birth details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 37
},
"String": {
"count": 224,
"min": 9,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Legislative branch": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 102,
"min": 0.0,
"max": 0.0
},
"Null": {
"count": 28
},
"String": {
"count": 233,
"min": 55,
"max": 2173
},
"Uuid": {
"count": 0
}
},
"Legal system": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 11
},
"String": {
"count": 250,
"min": 2,
"max": 1769
},
"Uuid": {
"count": 0
}
},
"International organization participation": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 26
},
"String": {
"count": 235,
"min": 3,
"max": 651
},
"Uuid": {
"count": 0
}
},
"Maritime claims": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 196,
"min": 3.0,
"max": 200.0
},
"Null": {
"count": 65
},
"String": {
"count": 196,
"min": 3,
"max": 5
},
"Uuid": {
"count": 0
}
},
"Maritime claims details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 65
},
"String": {
"count": 196,
"min": 2,
"max": 2
},
"Uuid": {
"count": 0
}
},
"Manpower available for military service": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 205,
"min": 2528.0,
"max": 354314328.0
},
"Null": {
"count": 56
},
"String": {
"count": 205,
"min": 6,
"max": 11
},
"Uuid": {
"count": 0
}
},
"Manpower available for military service details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 56
},
"String": {
"count": 205,
"min": 9,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Military expenditures": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 173,
"min": 0.0,
"max": 11.4
},
"Null": {
"count": 88
},
"String": {
"count": 173,
"min": 3,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Military expenditures details": {
"Bigint": {
"count": 68,
"min": 2005,
"max": 2006
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 88
},
"String": {
"count": 173,
"min": 2,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Environment - international agreements": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 59
},
"String": {
"count": 202,
"min": 41,
"max": 818
},
"Uuid": {
"count": 0
}
},
"Environment - current issues": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 1,
"min": 0.0,
"max": 0.0
},
"Null": {
"count": 2
},
"String": {
"count": 259,
"min": 2,
"max": 728
},
"Uuid": {
"count": 0
}
},
"Airports - with unpaved runways": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 194,
"min": 1.0,
"max": 85.0
},
"Null": {
"count": 67
},
"String": {
"count": 194,
"min": 3,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Airports - with unpaved runways details": {
"Bigint": {
"count": 194,
"min": 2008,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 67
},
"String": {
"count": 194,
"min": 4,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Airports - with paved runways": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 232,
"min": 1.0,
"max": 190.0
},
"Null": {
"count": 29
},
"String": {
"count": 232,
"min": 3,
"max": 5
},
"Uuid": {
"count": 0
}
},
"Airports - with paved runways details": {
"Bigint": {
"count": 232,
"min": 2008,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 29
},
"String": {
"count": 232,
"min": 4,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Electricity - production": {
"Bigint": {
"count": 212,
"min": 60600,
"max": 4167000000000
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 49
},
"String": {
"count": 212,
"min": 5,
"max": 13
},
"Uuid": {
"count": 0
}
},
"Electricity - production details": {
"Bigint": {
"count": 24,
"min": 2002,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 49
},
"String": {
"count": 212,
"min": 4,
"max": 12
},
"Uuid": {
"count": 0
}
},
"Railways": {
"Bigint": {
"count": 133,
"min": 36,
"max": 229450
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 128
},
"String": {
"count": 133,
"min": 2,
"max": 6
},
"Uuid": {
"count": 0
}
},
"Railways details": {
"Bigint": {
"count": 133,
"min": 2006,
"max": 2009
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 128
},
"String": {
"count": 133,
"min": 4,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Ports and terminals": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 26
},
"String": {
"count": 235,
"min": 3,
"max": 561
},
"Uuid": {
"count": 0
}
},
"Suffrage": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 222,
"min": 16.0,
"max": 21.0
},
"Null": {
"count": 39
},
"String": {
"count": 222,
"min": 4,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Suffrage details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 39
},
"String": {
"count": 222,
"min": 2,
"max": 2
},
"Uuid": {
"count": 0
}
},
"Industrial production growth rate": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 168,
"min": -14.7,
"max": 14.3
},
"Null": {
"count": 93
},
"String": {
"count": 168,
"min": 3,
"max": 5
},
"Uuid": {
"count": 0
}
},
"Industrial production growth rate details": {
"Bigint": {
"count": 6,
"min": 2000,
"max": 2007
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 93
},
"String": {
"count": 168,
"min": 4,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Terrain": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 1,
"min": 0.0,
"max": 0.0
},
"Null": {
"count": 4
},
"String": {
"count": 257,
"min": 4,
"max": 840
},
"Uuid": {
"count": 0
}
},
"Telephone system": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 3,
"min": 0.0,
"max": 0.0
},
"Null": {
"count": 20
},
"String": {
"count": 241,
"min": 53,
"max": 1911
},
"Uuid": {
"count": 0
}
},
"Total fertility rate": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 224,
"min": 0.91,
"max": 7.75
},
"Null": {
"count": 37
},
"String": {
"count": 224,
"min": 3,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Total fertility rate details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 37
},
"String": {
"count": 224,
"min": 9,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Unemployment rate": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 200,
"min": 0.0,
"max": 90.0
},
"Null": {
"count": 61
},
"String": {
"count": 200,
"min": 3,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Unemployment rate details": {
"Bigint": {
"count": 38,
"min": 1997,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 61
},
"String": {
"count": 200,
"min": 4,
"max": 22
},
"Uuid": {
"count": 0
}
},
"Government type": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 28
},
"String": {
"count": 233,
"min": 2,
"max": 4757
},
"Uuid": {
"count": 0
}
},
"Flag description": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 13
},
"String": {
"count": 248,
"min": 26,
"max": 709
},
"Uuid": {
"count": 0
}
},
"Illicit drugs": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 122
},
"String": {
"count": 139,
"min": 2,
"max": 1234
},
"Uuid": {
"count": 0
}
},
"Imports": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 43
},
"String": {
"count": 218,
"min": 9,
"max": 19
},
"Uuid": {
"count": 0
}
},
"Imports details": {
"Bigint": {
"count": 51,
"min": 2001,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 43
},
"String": {
"count": 218,
"min": 4,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Roadways": {
"Bigint": {
"count": 220,
"min": 8,
"max": 6465799
},
"Character": {
"count": 1
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 41
},
"String": {
"count": 220,
"min": 1,
"max": 7
},
"Uuid": {
"count": 0
}
},
"Roadways details": {
"Bigint": {
"count": 220,
"min": 1994,
"max": 2009
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 41
},
"String": {
"count": 220,
"min": 4,
"max": 4
},
"Uuid": {
"count": 0
}
},
"Population growth rate": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 234,
"min": -3.3,
"max": 3.69
},
"Null": {
"count": 27
},
"String": {
"count": 234,
"min": 3,
"max": 5
},
"Uuid": {
"count": 0
}
},
"Population growth rate details": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 27
},
"String": {
"count": 234,
"min": 9,
"max": 9
},
"Uuid": {
"count": 0
}
},
"GDP - real growth rate": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 217,
"min": -12.6,
"max": 15.0
},
"Null": {
"count": 44
},
"String": {
"count": 217,
"min": 3,
"max": 5
},
"Uuid": {
"count": 0
}
},
"GDP - real growth rate details": {
"Bigint": {
"count": 8,
"min": 2003,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 45
},
"String": {
"count": 216,
"min": 4,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Heliports": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 100,
"min": 1.0,
"max": 536.0
},
"Null": {
"count": 161
},
"String": {
"count": 100,
"min": 3,
"max": 5
},
"Uuid": {
"count": 0
}
},
"Heliports details": {
"Bigint": {
"count": 100,
"min": 2007,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 161
},
"String": {
"count": 100,
"min": 4,
"max": 4
},
"Uuid": {
"count": 0
}
},
"GDP (purchasing power parity)": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 33
},
"String": {
"count": 228,
"min": 11,
"max": 20
},
"Uuid": {
"count": 0
}
},
"GDP (purchasing power parity) details": {
"Bigint": {
"count": 4,
"min": 2005,
"max": 2007
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 33
},
"String": {
"count": 228,
"min": 4,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Diplomatic representation from the US": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 1,
"min": 0.0,
"max": 0.0
},
"Null": {
"count": 19
},
"String": {
"count": 242,
"min": 4,
"max": 466
},
"Uuid": {
"count": 0
}
},
"GDP - per capita (PPP)": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 32
},
"String": {
"count": 229,
"min": 5,
"max": 9
},
"Uuid": {
"count": 0
}
},
"GDP - per capita (PPP) details": {
"Bigint": {
"count": 4,
"min": 2005,
"max": 2007
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 32
},
"String": {
"count": 229,
"min": 4,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Natural gas - production": {
"Bigint": {
"count": 209,
"min": 0,
"max": 654000000000
},
"Character": {
"count": 117
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 52
},
"String": {
"count": 209,
"min": 1,
"max": 12
},
"Uuid": {
"count": 0
}
},
"Natural gas - production details": {
"Bigint": {
"count": 7,
"min": 2007,
"max": 2008
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 52
},
"String": {
"count": 209,
"min": 4,
"max": 9
},
"Uuid": {
"count": 0
}
}
},
"lines": 261
}
}
real 0m1.113s
user 0m0.960s
sys 0m0.051s
Raw
guess-types.txt
time ./bin/csv2psql analyze tmp/sfpd_incident_2013.csv
{
"tmp/sfpd_incident_2013.csv": {
"columns": {
"IncidntNum": {
"Bigint": {
"count": 132145,
"min": 10073348,
"max": 991152237
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 0
},
"String": {
"count": 132145,
"min": 9,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Category": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 0
},
"String": {
"count": 132145,
"min": 5,
"max": 27
},
"Uuid": {
"count": 0
}
},
"Descript": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 0
},
"String": {
"count": 132145,
"min": 5,
"max": 49
},
"Uuid": {
"count": 0
}
},
"DayOfWeek": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 0
},
"String": {
"count": 132145,
"min": 6,
"max": 9
},
"Uuid": {
"count": 0
}
},
"Date": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 0
},
"String": {
"count": 132145,
"min": 10,
"max": 10
},
"Uuid": {
"count": 0
}
},
"Time": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 0
},
"String": {
"count": 132145,
"min": 5,
"max": 5
},
"Uuid": {
"count": 0
}
},
"PdDistrict": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 0
},
"String": {
"count": 132145,
"min": 4,
"max": 10
},
"Uuid": {
"count": 0
}
},
"Resolution": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 0
},
"String": {
"count": 132145,
"min": 4,
"max": 38
},
"Uuid": {
"count": 0
}
},
"Location": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 0,
"min": null,
"max": null
},
"Null": {
"count": 0
},
"String": {
"count": 132145,
"min": 15,
"max": 42
},
"Uuid": {
"count": 0
}
},
"X": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 132145,
"min": -122.513518299855,
"max": -122.365246233264
},
"Null": {
"count": 0
},
"String": {
"count": 132145,
"min": 13,
"max": 17
},
"Uuid": {
"count": 0
}
},
"Y": {
"Bigint": {
"count": 0,
"min": null,
"max": null
},
"Character": {
"count": 0
},
"Decimal": {
"count": 132145,
"min": 37.70801622581,
"max": 37.8182264404368
},
"Null": {
"count": 0
},
"String": {
"count": 132145,
"min": 13,
"max": 16
},
"Uuid": {
"count": 0
}
}
},
"lines": 132145
}
}
real 0m11.702s
user 0m11.447s
sys 0m0.103s
Raw
sfpd-2014-table.txt
time ./bin/csv2psql analyze --format=table tmp/sfpd_incident_2013.csv
+------------+--------+-----------+---------+------+--------+------+
| tmp/sfpd_incident_2013.csv |
+------------+--------+-----------+---------+------+--------+------+
| column | Bigint | Character | Decimal | Null | String | Uuid |
+------------+--------+-----------+---------+------+--------+------+
| IncidntNum | 132145 | 0 | 0 | 0 | 132145 | 0 |
| Category | 0 | 0 | 0 | 0 | 132145 | 0 |
| Descript | 0 | 0 | 0 | 0 | 132145 | 0 |
| DayOfWeek | 0 | 0 | 0 | 0 | 132145 | 0 |
| Date | 0 | 0 | 0 | 0 | 132145 | 0 |
| Time | 0 | 0 | 0 | 0 | 132145 | 0 |
| PdDistrict | 0 | 0 | 0 | 0 | 132145 | 0 |
| Resolution | 0 | 0 | 0 | 0 | 132145 | 0 |
| Location | 0 | 0 | 0 | 0 | 132145 | 0 |
| X | 0 | 0 | 132145 | 0 | 132145 | 0 |
| Y | 0 | 0 | 132145 | 0 | 132145 | 0 |
+------------+--------+-----------+---------+------+--------+------+
real 0m11.633s
user 0m11.451s
sys 0m0.069s
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment