Template:Info for goat number

From MediaWiki

(Difference between revisions)
Jump to: navigation, search
m (Changed subtitle to allow paging to keep its place)
Line 145: Line 145:
|database=EcoReality}}
|database=EcoReality}}
-
==Notes==
+
==Records==
{{#tag:mysql|
{{#tag:mysql|
SELECT
SELECT

Revision as of 00:22, 27 January 2016

Usage

This template is used to display various information for a goat.

It is typically placed on pages named like "Dairy production/5", in the following manner: {{info for goat number|{{SUBPAGENAME}}}}.

Parameters

  1. the ID number of the goat information to be displayed.

Example

as entered
{{info for goat number|15}}
as displayed

Statistics for goat #15, Nubian female: Taara

Dark brown with white star on forehead

Photo

Provenance

BreedBirth dateBirth weightDispositionDisposition dateDescriptionSireDam
Nubian2011-05-16 16:00:003.100owned0000-00-00Dark brown with white star on foreheadLincoln (Nubian)Shakti (Sable)

Kids

KidGenderBirth dateBirth weightSireDamDispositionDisposition dateDescription
(unnamed) (Nubian)male2013-04-25 09:30:003.400Zuciana (Sable)Taara (Nubian)sold2013-06-30black back with white and brown, white star, brown socks
(unnamed) (Nubian)male2013-04-25 09:30:003.200Zuciana (Sable)Taara (Nubian)sold2013-06-22black with white belly extending up and back
(unnamed) (Nubian)male2014-08-15 14:30:002.890Murkha (Nubian)Taara (Nubian)sold2014-11-26Grizzled black with white band.
Odie (Nubian)female2014-08-15 14:30:002.860Murkha (Nubian)Taara (Nubian)sold2015-03-16White head, tan socks, white belly.
(unnamed) (Lamancha)female2015-05-22 20:07:002.510Titan (Lamancha)Taara (Nubian)died2015-05-24brown with white and black points
[Taara-Titan] (Lamancha)neutered2016-04-23 13:20:003.410Titan (Lamancha)Taara (Nubian)sold2017-01-20Deer coloured
Stubby (Lamancha)female2016-04-23 13:25:003.330Titan (Lamancha)Taara (Nubian)sold2020-03-18Deer coloured, lighter than brother, with white on face
[Taara-Bucky] (Nubian)male2017-04-02 08:00:002.800Bucky (Nubian)Taara (Nubian)sold2018-02-27Brown/black with white star
[Taara-Bucky] (Nubian)male2017-04-02 08:00:002.400Bucky (Nubian)Taara (Nubian)sold2018-02-27Brown/black
Shy (Lamancha)female2017-04-02 08:00:002.300Cow (Nubian)Taara (Nubian)sold2020-03-15Brown with a bit of white
[Taara-Bucky] (Nubian)female2018-01-24 10:30:002.610Bucky (Nubian)Taara (Nubian)sold2018-04-22Nubian ears, chocolate with black socks, slash on left rear leg
[Taara-Bucky 2] (Nubian)doe2019-03-17 16:00:003.060Bucky (Nubian)Taara (Nubian)owned0000-00-00dark brown with black points, Nubian ears
[Taara-Bucky] (Nubian)doe2019-03-17 16:05:002.880Bucky (Nubian)Taara (Nubian)owned0000-00-00medium brown with grey spots, Nubian ears

Production

by year

20072008200920102011201220132014201520162017201820192020TotalUnits
217.50111.95164.82376.72361.99379.28218.19182.322,012.76kilograms

by month

Month20072008200920102011201220132014201520162017201820192020TotalUnits
January20.289.9227.716.6530.0994.66kilograms
February20.800.4623.2024.5068.96kilograms
March3.5131.9737.9673.44kilograms
April5.1138.4910.7941.3095.69kilograms
May7.4046.8226.9144.840.9948.47175.43kilograms
June19.4722.8837.4330.7341.3919.73171.63kilograms
July48.6010.5751.8845.3445.7636.45238.61kilograms
August43.630.1431.1862.9970.6843.6126.12278.36kilograms
September36.218.5537.2862.1559.4635.9728.48268.09kilograms
October26.8011.2424.6248.3342.0536.7835.21225.03kilograms
November20.8919.7218.7632.9531.5224.2530.68178.76kilograms
December21.8827.712.2229.0627.136.3729.74144.12kilograms

by week

Week20072008200920102011201220132014201520162017201820192020TotalUnits
11.026.553.347.242.011.784.0125.95kilograms
24.293.387.270.516.8322.28kilograms
33.742.256.327.4919.80kilograms
45.140.954.632.057.1619.94kilograms
55.491.535.306.0918.40kilograms
65.184.523.8313.53kilograms
75.426.387.8019.60kilograms
85.366.486.0517.88kilograms
94.596.146.2817.01kilograms
102.206.787.4816.46kilograms
117.007.5114.51kilograms
127.938.4316.36liters
138.0010.6618.65liters
149.0210.1619.18liters
158.769.4418.20liters
168.835.667.4621.95liters
176.219.425.1310.3631.12kilograms
188.152.639.4812.1332.39kilograms
1910.996.639.860.9913.1541.61kilograms
209.416.2910.2713.8539.82kilograms
210.5213.257.4810.7814.5346.56kilograms
226.879.168.8410.251.6236.74kilograms
238.337.819.9210.6136.67kilograms
247.1610.1411.175.789.9344.17kilograms
255.984.418.285.578.788.6641.66kilograms
266.347.946.428.7711.0740.54kilograms
2712.377.579.779.819.5249.04kilograms
2810.3614.0810.9710.557.8453.81kilograms
299.4113.809.3111.037.7751.32kilograms
3010.105.8913.4311.5510.338.2359.54kilograms
3112.986.6913.9913.499.696.6963.53kilograms
328.937.9313.4516.0610.876.3963.62kilograms
338.567.9514.6616.3411.276.5865.36kilograms
3410.280.146.6914.6417.249.525.9864.50kilograms
3510.635.7114.6616.307.294.0658.66kilograms
368.364.9314.6316.807.966.4159.10kilograms
379.670.8111.1214.8813.858.837.7066.85kilograms
388.753.8710.1414.0911.998.276.4263.53kilograms
397.203.218.9613.3011.328.656.4659.08kilograms
406.561.936.1612.0710.219.427.3553.70kilograms
416.562.105.0411.239.808.597.5350.84kilograms
426.452.835.2310.329.408.078.0650.35kilograms
435.342.996.3210.128.637.658.7849.82kilograms
444.922.955.729.818.916.698.0547.06kilograms
454.524.006.178.597.605.317.5343.73kilograms
464.985.095.557.516.635.007.1341.88kilograms
475.564.963.425.927.316.096.4839.74kilograms
484.124.772.416.577.045.816.9037.61kilograms
494.574.242.105.897.314.337.4735.91kilograms
505.274.770.516.627.140.455.5730.33kilograms
515.746.886.995.626.7431.97kilograms
524.798.445.564.877.2730.93kilograms
217.50111.95164.82376.72361.99379.28218.19182.322,012.76kilograms

First/Last by Year

YearFirstLastDayskgPer DayHarvestsPer Harvest
2013Jun 10Dec 31205217.4991.0613990.545
2014Jan 1Dec 31365111.9480.3072950.379
2015Jan 1Dec 10344164.8180.4793340.493
2016Apr 26Dec 31250376.7181.5074220.893
2017Jan 1Dec 31365361.9880.9924790.756
2018Jan 1Dec 12346379.2831.0966610.574
2019Apr 16Dec 31260218.1880.8394070.536
2020Jan 1May 25146182.3201.2492920.624

Milker by year

IDHarvester20072008200920102011201220132014201520162017201820192020TotalUnits
2Steinman, Jan159.6579.67120.68223.91243.31257.11183.12181.871,449.31kilograms
3Rowe, Cleome0.1113.388.370.4522.30liters
212Corno, Ben0.570.2711.0511.89kilograms
216Raginsky, Sofya0.080.360.44kilograms
231Morrow, Geo6.536.53kilograms
359Ada, Ronald16.4016.40kilograms
364Ross, Mindy40.2940.29kilograms
367Adams, Landis0.400.40kilograms
370Todd, Sylvain7.047.04kilograms
374Goodsir, Clover0.860.86liters
393Christensen, Camilla1.241.24kilograms
394Valleé, Steven23.3723.37kilograms
403Kyomugisha-Perry, Grace0.330.33kilograms
405Hamilton, Kelvin1.060.891.94kilograms
423Al-Zeer, Bader0.560.56kilograms
424Fontana, Andrea1.021.02kilograms
425Solow, Neel4.444.44kilograms
426Reesor, Natasha11.8211.82kilograms
431Re, Kate5.715.71kilograms
435Peters, Jon0.800.80kilograms
436Canabe, Barbara6.776.77kilograms
437Canabe, Danny5.285.28kilograms
438Vargas, Elisabeth1.861.86kilograms
446Smith, Joel5.555.55kilograms
459Kats, Anton4.264.26kilograms
471Phipps, Joan1.391.39kilograms
473Strong, Christopher146.11146.11kilograms
500Stephenson, Kate14.741.8016.54kilograms
504Hyatt, Vienna29.9929.99kilograms
508Cox, John4.314.31kilograms
509Lloyd, Alexander7.527.52kilograms
510Bevilacqua, Gaia3.053.05kilograms
515Klein, Philipp33.019.3142.33kilograms
518Dekens, Leonard18.6539.822.2760.74liters
520Medina, Sergio2.692.69liters
522Harel, Xavier0.610.61liters
523Gasulla, Maties1.231.23liters
529Chisholm, Lauren30.2530.25liters
539Rass, Lena12.6712.67liters
540Bourasseau, Ann-Sophie2.172.17liters
543, James1.561.56kilograms
544Röttgers, Bruce3.913.91kilograms
548Pitkethly, Andrea0.700.70kilograms
549Pitkethly, Jase1.201.20kilograms
573Mittendorf, Greta8.718.71kilograms
574Gillard, Matthiew1.391.39kilograms
578Stawowy, Emma2.802.80kilograms
583Rohnacher, Leandra0.490.49kilograms
TOTAL:Rohnacher, Leandra217.50111.95164.82376.72361.99379.28218.19182.322,012.76kilograms

Records

1 to 21 of 67 [1] 2 3 4
datetypenote
2020-04-19trim hooves
2020-02-04wormedsoft poop, 12 ml eprinomectin transdermally
2020-02-01experimentResumed wormwood.
2020-01-24experimentDiscontinued wormwood while on hay so we won't run out in spring when they go on grass. Ditomaceous earth continued.
2020-01-16heat
2020-01-09trim hooves
2020-01-08experimentBegan adding one capful of bleach to the wash water, primarily to treat Shy's (120) udder pox.
2019-12-25heat
2019-12-04heat
2019-11-12heat
2019-10-22heat
2019-10-14trim hooves
2019-09-13experimentAdded about 5cc diotomaceous earth to feed to help ward off intestinal parasites. Given to all seven current milkers: Shy, Right, Taara, Friendly, Stubby, Whitey, and Sazmaz.
2019-09-01wormedscouring; wormwood in feed
2019-08-31wormedscouring; 3ml fenbenzidole drench, 12.5ml eprinomectin transdermally, wormwood, black oil sunflower seeds
2019-07-19trim hooves
2019-06-25trim hooves
2019-04-28wormedtransdermal: 7cc moxidectin
2019-04-22trim hooves
2019-04-20wormedtransdermal: 20cc Eprinomectin
1 to 21 of 67 [1] 2 3 4

EXPERIMENTAL STUFF

The extension MySQL needs to be turned into a parser function first, so that gender-specific statistics can be presented in a reasonable way. (We don't really want to know how much milk we got out of a buck, for example.)

Sex of this animal is: {{#mysqlinline:SELECT Sex FROM s_animals WHERE ID=15|database=EcoReality}} .

The sex of this animal is not defined.

The sex of this animal is undefined.

See also

See Also

Template

Share your opinion


blog comments powered by Disqus
Personal tools
Get our newsletter!
Name:
Email Address:

disturbance
entry points
help (off site)
Environmental jobs, green volunteering, good work! Powered by the wind! This server and other
EcoReality operations
are 100% wind powered.
Powered by Mac OS X Powered by Mac MediaWiki Powered by MariaDB Powered by Valentina Studio Pro