Statistieken C1 Registry

[Rob M.]

For those who are interested in statistics, from the C1 and C2 registry we can derive all kind of statistics (ofcourse we won't provide any privacy related information to anyone):

E.g. nr. of cars per state in the US:
state_name count( * )
Alabama 3
Arizona 17
Arkansas 7
California 71
Colorado 12
Connecticut 5
Delaware 2
District of Columbia 1
Florida 44
Georgia 7
Hawaii 1
Idaho 2
Illinois 16
Indiana 13
Iowa 5
Kansas 8
Kentucky 4
Louisiana 6
Maine 3
Maryland 15
Massachusetts 9
Michigan 23
Minnesota 6
Mississippi 5
Missouri 12
Montana 4
Nebraska 3
Nevada 8
New Hampshire 1
New Jersey 16
New Mexico 3
New York 21
North Carolina 9
Ohio 43
Oklahoma 8
Oregon 8
Pennsylvania 38
Rhode Island 2
South Carolina 4
South Dakota 2
Tennessee 11
Texas 30
Utah 4
Virginia 8
Washington 14
West Virginia 1
Wisconsin 6

greetings,
Rob.

[Rob M.]

Re: Statistieken C1 Registry

Another one, cars per country:

country_name count( * )
Australia 1
Canada 13
Germany 5
Netherlands 80
Norway 2
Sweden 2
Swiss 2
United Kingdom 4
United States 536

[Rob M.]

Re: Statistieken C1 Registry

Exterior color cars per year currently in the database:

car_year ext_color_name count( * )
1953 Polo White 23
1954 Black 3
1954 Pennant Blue 9
1954 Polo White 46
1954 Sportsman Red 12
1955 Corvette Copper 4
1955 Gypsy Red 3
1955 Harvest Gold 3
1955 Pennant Blue 2
1955 Polo White 8
1956 Arctic Blue 4
1956 Aztec Copper 3
1956 Cascade Green 8
1956 Onyx Black 11
1956 Polo White 11
1956 Venetian Red 30
1957 Arctic Blue 11
1957 Aztec Copper 3
1957 Cascade Green 14
1957 Inca Silver 4
1957 Onyx Black 42
1957 Polo White 12
1957 Venetian Red 52
1958 Black 33
1958 Charcoal 18
1958 Panama Yellow 18
1958 Regal Turquoise 17
1958 Signet Red 94
1958 Silver 4
1958 Silver Blue 28
1958 Snowcrest White 42
1959 Classic Cream 5
1959 Crown Sapphire 12
1959 Frost Blue 14
1959 Inca Silver 9
1959 Roman Red 51
1959 Snowcrest White 24
1959 Tuxedo Black 27
1960 Cascade Green 5
1960 Ermine White 56
1960 Honduras Maroon 25
1960 Horizon Blue 26
1960 Roman Red 114
1960 Sateen Silver 15
1960 Tasco Turquoise 19
1960 Tuxedo Black 56
1961 Ermine White 27
1961 Fawn Beige 7
1961 Honduras Maroon 17
1961 Jewel Blue 12
1961 Roman Red 58
1961 Sateen Silver 11
1961 Tuxedo Black 27
1962 Almond Beige 15
1962 Ermine White 53
1962 Fawn Beige 11
1962 Honduras Maroon 43
1962 Roman Red 121
1962 Sateen Silver 22
1962 Tuxedo Black 52

[Sander B.]

[Tracy C.]

He typed it cause it rhymes with Heineken *NM*

[Donald Morfield]

Re: Statistieken C1 Registry

Rob:

Good Work! And, this evening..........................Alaska-1

Donald

[Rob M.]

Re: Statistieken C1 Registry

If someone would like to see results of other specific queries please let me know and I'll see what I can work out (in principle I can combine all kind of information in the database, e.g. colors, options, job numbers, engine types, geographic info, etc. etc.) Only privacy dependant information won't be available.

greetings,
Rob.