FIND-IT Credentials and Identifiers

LIB REF NO	BATCH	TITLE	RECORDS
GEN-DET-001-02	DETLOR_NULL	DETLOR FAMILY: VALENTINE & CATHERINE HILL	1
DIR-COM-003-03	HAS_DIR_1860	HASTINGS COUNTY DIRECTORY – 1860	8,074
GEN-HUB-001-03	HUBBS_PEDI	HUBBS PEDIGREE CHARTS	3,220
CEM-HAS-BE-07	ST_BURIALS	SAINT THOMAS’ BURIALS	19,776
VARIOUS	SNAP360_ORIG	ORIGINAL FIND-IT FROM SNAP360	1,493,467
LIS-BMD-006-20	BRUCE_PEC_BMD	BRUCE FAMILY SCRAPBOOK OF PEC BMDs	9,993
DIR-COM-003-04	HAS_DIR_1864	HASTINGS COUNTY DIRECTORY – 1864	10,821
HIS-HAS-116-02	HUNT_CH_CEM	HUNTINGDON TOWNSHIP CLOSED/ACTIVE	7
LIS-FCC-002-05	SEA_SMITH	LINDA SEABROOKE SMITH ANCESTRY CHART	563
LIS-BMD-002-05	ST_BAPTISMS	SAINT THOMAS’ BAPTISMS	4,152
LIS-BMD-002-04	ST_MARRIAGES	SAINT THOMAS’ MARRIAGES	3,038
GEN-EMP-001-02	EMP_FAM2	LOYALIST CANADIAN EMPEY FAMILY # 2	8,183
GEN-BAK-001-01	BAK_FAM1	BAKER FAMILY	3,036
GEN-BRI-002-01	BRINT_FAM1	BRINTNELL FAMILY	153
GEN-DUL-001-05	DULM_FAM1	DULMAGE FAMILY	34
GEN-LAK-001-02	LAKE_FAM1	LAKE FAMILY	19
HIS-HAS-102-17	NURS_WW1	NURSES OF WORLD WAR I	195
LIS-FCC-002-01	PIERSON_PEDI	G.A. PIERSON PEDIGREE CHART	59
LIS-FCC-002-01	SLAV_FAM1	SLAVEN FAMILY HISTORY	199
GEN-WAL-004-01	WALK_FAM1	400 YEARS OF WALKERS	106
GEN-CAN-002-01	CAN_FAM1	CANNIFF FAMILY	253
GEN-FLA-001-01	FLAC_FAM1	FLACK FAMILY	26
GEN-McC-006-01	McCAL_FAM1	JAMES McCALMONT FAMILY	30
LIS-BMD-006-14	BELANGER_4	BELANGER COLLECTION # 4	29,877
GEN-STI-002-01	STIN_CONG1	STINSON CONGER FAMILY	91
GEN-CAD-001-01	CADMAN1	WILLIAM and ELIZABETH CADMAN	112
GEN-GRE-001-01	GREEN_HEN_SR	HENRY GREEN SR	200
GEN-GUF-001-01	GUF_FAU_FRA1	GUFFIN FAULKNER FRASER FAMILY	347
GEN-HAL-001-01	HALL_ALEX1	ALEXANDER HALL & CATHERINE McCULEY	78
GEN-HUD-001-01	HUD_WM_EST1	WILLIAM and ESTER HUDGINS	149
GEN-JON-001-01	JONES_FAM1	JONES FAMILY	81
GEN-LEE-001-01	LEE-QUI1	JOHN LEE & NANCY “ANNE” QUINN	65
GEN-McC-005-01	McCON_COV1	JONATHAN McCONNELL & HANNAH COVERT	169
GEN-WAL-003-01	WALD_ROB1	ROBERT WALDRON FAMILY	148
HIS-HAS-116-02	HUNT_CLOS_CH1	HUNTINGDON TOWNSHIP CLOSED CHURCHES	4
LIS-BMD-108-01	CAMP_HERALD	CAMPBELLFORD HERALD – BIRTHS	11,566
LIS-BMD-108-02	CAMP_HERALD	CAMPBELLFORD HERALD – DEATHS	17,060
LIS-BMD-108-03	CAMP_HERALD	CAMPBELLFORD HERALD – MARRIAGES/GROOM	7,425
LIS-BMD-108-04	CAMP_HERALD	CAMPBELLFORD HERALD – MARRIAGES/BRIDE	7,423
LIS-BMD-108-05	CAMP_HERALD	CAMPBELLFORD HERALD – EVENTS and PHOTOS	1,445
LIS-BMD-072-02	INTELL_BMD_2	INTELLIGENCER – BIRTHS/MARRIAGES/DEATHS 2022	7,476
GEN-HIL-001-01	HILL_FAM_1	HILL (from microfiche) FRALICK & FAULKNER	1,122
GEN-MOR-002-01	BET_MORD_FAM_1	JOSEPH MORDEN & MARGARET BETSKY	86
GEN-MUM-001-01	MUMM_FAM_1	MUMMERT FAMILY	18
GEN-PHI-001-01	GUN_PHIL_FAM_1	JOHN PHILLIPS & ANN GUNTER	307
GEN-SOU-001-01	SOUS_FAM_1	WILLIAM SOUSTER FAMILY	102
GEN-STE-001-01	STEW_FAM_1	HUGH STEWART FAMILY	213
GEN-STO-003-01	LID_STOR_FAM_1	ISAAC STORRING & ELIZABETH LIDDY	66
GEN-WOR-001-01	WORD_FAM_1	PETER WORDEN FAMILY	101
DIR-COM-003-05	HAS_DIR_1869	HASTINGS COUNTY DIRECTORY – 1869	12,000
GEN-McN-002-01	McNAR_BROW_1	JANET McNARIN & JAMES BROWN	322
GEN-O’BR-001-03	OBRIE_1	O’BRIENS OF ENNISCORTHY	43
GEN-OST-001-02	OSTRAN_1	OSTRANDER of SOUTH BAY	165
GEN-PET-001-01	PETE_1	PETERSON FAMILY	20
GEN-PIC-001-01	PICK_1	REV DANIEL PICKETT	173
GEN-SIM-002-02	SIMM_1	SIMMONS – PALATINE FAMILIES	266
GEN-TER-003-03	TER_FRE_1	EVERT TERWILLIGAR & SARAH FREER	47
GEN-YOU-001-02	YOUN_1	YOUNG – BIBLE RECORDINGS	40
GEN-SHO-001-01	SHOE_1	DESCENDANTS of RICHARD SHOEBRIDGE	1001
GEN-MEL-001-01	MELV_1	WILLIAM JOHN MELVILLE & ELIZABETH McDONALD	203
GEN-BLA-003-02	BLACK_1	BLACKBURN from YORKSHIRE ENGLAND	306
GEN-CAN-150-1/46	CAN_150	CANADA 150 PROJECT	7098
GEN-GOU-001-01	GOULD_1	GEORGE RYERSON GOULD	159
GEN-MOF-001-01	MOFFAT_1	THOMAS MOFFAT	156
GEN-NOL-001-01	NOLLES_1	WILLEM NOLLES	408
GEN-WAL-002-01	WALLACE_1	JAMES WALLACE & MARY IRWIN	274
GEN-CLA-002-02	CLARK_2	JACOB CLARK FAMILY	446
GEN-HOF-001-01	HOFF_1	HOFFMAN FAMILY	127
GEN-MIT-001-03	MITCH_3	ROBERT MITCHEL & ELIZABETH JUNKIN	182
LIS-VOT-001-01	VOTE35_HP	VOTER LISTS 1935: HASTINGS-PETERBOROUGH	16,949
LIS-BMD-123-01	PEC_BIRTHS_V3	PEC BIRTHS 1869-1879	3,030
LIS-BMD-124-01	QUAK_APR23	QUAKER REGISTERS from WEST LAKE (PEC)	1,911
LIS-BMD-125-01	MM_MAY23	MISSING MARRIAGES of HASTINGS COUNTY	2514
GEN-POS-001-23	POST_SP_AU0823	POST FAMILY SPOUSES	519
DIR-COM-003-07	HAS-DIR-89-AU1023	HASTINGS COUNTY DIRECTORY – 1889	16,234
REC-OBI-002-01	MEM_SERV_23	MEMORIAL SERVICES COLLECTION	214

		–> BLANK RECORDS <–	0

		TOTAL	1,735,195

UNIQUE BATCHES in FIND-IT

FIND-IT: MAINTENANCE

SELECT * FROM Has_Dir_1889 WHERE BATCH LIKE “HAS-DIR-1889_SID1”

UPDATE FIND_IT_table SET TITLE = “Hastings County Directory – 1879” WHERE LIB_REF_NO = “DIR-COM-003-06”

SELECT * FROM FIND_IT_table WHERE LIB_REF_NO like ‘HIS-LOY-002-06’

SELECT * FROM FIND_IT_table WHERE TITLE like “%Parks; Cyrenius%”

SELECT TITLE, LIB_REF_NO, COUNT(*) as RECORD_COUNT FROM FIND_IT_table GROUP BY TITLE

SELECT TITLE,LIB_REF_NO, COUNT(*) FROM FIND_IT_table GROUP BY TITLE

Select COALESCE(batch, ‘TOTAL’) as Batch,format(count(*),0) as Count from `FIND_IT_table` group by batch with rollup

Select count(batch) from FIND_IT_table group by batch

=IF(G1=”McCaw; Alex 1669-c1734″,”—–“, “CHECK ME”)

UPDATE FIND_IT_table SET XXXXX = “XXXXX” WHERE batch = “XXXXX”

UPDATE FIND_IT_table SET TITLE = “Sample Title” WHERE BATCH like “SAMPLE”

UPDATE FIND_IT_table SET GIVEN_NAMES = “Alice 1873-05-02 – 1933-05-01” WHERE ID = 1222228

DELETE FROM FIND_IT_table WHERE batch = “”

SELECT SURNAME, COUNT(SURNAME) FROM FIND_IT_table GROUP BY SURNAME ORDER BY COUNT(SURNAME) DESC

select count(*) FROM Hast_Directory_1879 WHERE municipality like “Ameliasburgh Township”

SELECT COUNT(ID) FROM FIND_IT_table WHERE SURNAME IS NOT NULL

SELECT COUNT(ID) FROM FIND_IT_table WHERE SURNAME IS NULL

DELETE FROM Quinte_Obituary_Collection WHERE batch = “OBITS_Aug23”

SELECT SURNAME, GIVEN_NAMES, “DATE OF DEATH”, BATCH, COUNT() AS Duplicate_Count, GROUP_CONCAT(ID) AS Duplicate_Record_Ids FROM Quinte_Obituary_Collection GROUP BY SURNAME, GIVEN_NAMES, “DATE OF DEATH” HAVING COUNT() > 1 [ChatGPT]

SELECT * FROM Quinte_Obituary_Collection WHERE BATCH = “QB_OBITS_CP12” ORDER BY SURNAME, GIVEN_NAMES [ChatGPT]

SELECT SURNAME,GIVEN_NAMES,DATE_OF_DEATH,OBITUARY_PUBLICATION,BATCH, count() FROM Quinte_Obituary_Collection GROUP BY SURNAME,GIVEN_NAMES,DATE_OF_DEATH,OBITUARY_PUBLICATION,BATCH HAVING count()>1

SELECT SURNAME,GIVEN_NAMES,DATE_OF_DEATH,OBITUARY_PUBLICATION, count() FROM Quinte_Obituary_Collection GROUP BY SURNAME,GIVEN_NAMES,DATE_OF_DEATH,OBITUARY_PUBLICATION HAVING count()>1

SELECT SURNAME,GIVEN_NAMES,DATE_OF_DEATH,OBITUARY_PUBLICATION, count() FROM Quinte_Obituary_Collection GROUP BY SURNAME,GIVEN_NAMES,DATE_OF_DEATH,OBITUARY_PUBLICATION HAVING count()> 1

SELECT CONCAT(SURNAME, ‘ # ‘,GIVEN_NAMES) AS COMBO FROM OBITUARY_TEST_1 GROUP BY COMBO HAVING COUNT(COMBO)>1

DELETE FROM TCA1 WHERE ID > 4151

DELETE FROM TCA1 WHERE INDEX_PAGE is null

SELECT DISTINCT BATCH FROM FIND_IT_table

SELECT INDEX_PAGE, COUNT(*) FROM TCA1 GROUP BY INDEX_PAGE ORDER BY INDEX_PAGE

UPDATE FIND_IT_table SET PAGE = REPLACE(PAGE, “QWPL”, “newspaper”) WHERE LIB_REF_NO = “LIS-BMD-072_11”

UPDATE FIND_IT_table SET PAGE = REPLACE(PAGE, “index”, “newspaper index”) WHERE LIB_REF_NO = “LIS-BMD-072_11” AND ID >= 3217491

SELECT cast( replace( SUBSTRING_INDEX(page, ‘ page ‘, -1), ” of newspaper index”, “” ) as unsigned ) AS page_num, count(*) as Couint FROM `FIND_IT_table` where TITLE = “Trenton Courier Advocate 1950-1960” group by page_num order by page_num;

UPDATE FIND_IT_table SET PAGE = REPLACE(PAGE, “QWPL”, “newspaper”) WHERE LIB_REF_NO = “LIS-BMD-106-01”

UPDATE FIND_IT_table SET PAGE = REPLACE(PAGE, “index”, “newspaper index”) WHERE LIB_REF_NO = “LIS-BMD-072_11”

[NOTE: Quotation Marks Must Be Entered from the Keyboard / NOT COPIED]