{"id":1559,"date":"2026-02-15T12:02:36","date_gmt":"2026-02-15T17:02:36","guid":{"rendered":"https:\/\/wickson.net\/blog\/?page_id=1559"},"modified":"2026-02-15T12:02:36","modified_gmt":"2026-02-15T17:02:36","slug":"find-it-credentials-and-identifiers","status":"publish","type":"page","link":"https:\/\/wickson.net\/blog\/find-it-credentials-and-identifiers\/","title":{"rendered":"FIND-IT Credentials and Identifiers"},"content":{"rendered":"\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
LIB REF NO<\/td>\r\nBATCH<\/td>\r\nTITLE<\/td>\r\n\r\n

RECORDS<\/p>\r\n<\/td>\r\n<\/tr>\r\n

GEN-DET-001-02<\/span><\/td>\r\nDETLOR_NULL<\/span><\/td>\r\nDETLOR FAMILY: VALENTINE & CATHERINE HILL<\/span><\/td>\r\n1<\/span><\/td>\r\n<\/tr>\r\n
DIR-COM-003-03<\/span><\/td>\r\nHAS_DIR_1860<\/span><\/td>\r\nHASTINGS COUNTY DIRECTORY – 1860<\/span><\/td>\r\n8,074<\/span><\/td>\r\n<\/tr>\r\n
GEN-HUB-001-03<\/span><\/td>\r\nHUBBS_PEDI<\/span><\/td>\r\nHUBBS PEDIGREE CHARTS<\/span><\/td>\r\n3,220<\/span><\/td>\r\n<\/tr>\r\n
CEM-HAS-BE-07<\/span><\/td>\r\nST_BURIALS<\/span><\/td>\r\nSAINT THOMAS’ BURIALS<\/span><\/td>\r\n19,776<\/span><\/td>\r\n<\/tr>\r\n
VARIOUS<\/span><\/td>\r\nSNAP360_ORIG<\/span><\/td>\r\nORIGINAL FIND-IT FROM SNAP360<\/span><\/td>\r\n1,493,467<\/span><\/td>\r\n<\/tr>\r\n
LIS-BMD-006-20<\/span><\/td>\r\nBRUCE_PEC_BMD<\/span><\/td>\r\nBRUCE FAMILY SCRAPBOOK OF PEC BMDs<\/span><\/td>\r\n9,993<\/span><\/td>\r\n<\/tr>\r\n
DIR-COM-003-04<\/span><\/td>\r\nHAS_DIR_1864<\/span><\/td>\r\nHASTINGS COUNTY DIRECTORY – 1864<\/span><\/td>\r\n10,821<\/span><\/td>\r\n<\/tr>\r\n
HIS-HAS-116-02<\/span><\/td>\r\nHUNT_CH_CEM<\/span><\/td>\r\nHUNTINGDON TOWNSHIP CLOSED\/ACTIVE<\/span><\/td>\r\n7<\/span><\/td>\r\n<\/tr>\r\n
LIS-FCC-002-05<\/span><\/td>\r\nSEA_SMITH<\/span><\/td>\r\nLINDA SEABROOKE SMITH ANCESTRY CHART<\/span><\/td>\r\n563<\/span><\/td>\r\n<\/tr>\r\n
LIS-BMD-002-05<\/span><\/td>\r\nST_BAPTISMS<\/span><\/td>\r\nSAINT THOMAS’ BAPTISMS<\/span><\/td>\r\n4,152<\/span><\/td>\r\n<\/tr>\r\n
LIS-BMD-002-04<\/span><\/td>\r\nST_MARRIAGES<\/span><\/td>\r\nSAINT THOMAS’ MARRIAGES<\/span><\/td>\r\n3,038<\/span><\/td>\r\n<\/tr>\r\n
GEN-EMP-001-02<\/span><\/td>\r\nEMP_FAM2<\/span><\/td>\r\nLOYALIST CANADIAN EMPEY FAMILY # 2<\/span><\/td>\r\n8,183<\/span><\/td>\r\n<\/tr>\r\n
GEN-BAK-001-01<\/span><\/td>\r\nBAK_FAM1<\/span><\/td>\r\nBAKER FAMILY<\/span><\/td>\r\n3,036<\/span><\/td>\r\n<\/tr>\r\n
GEN-BRI-002-01<\/span><\/td>\r\nBRINT_FAM1<\/span><\/td>\r\nBRINTNELL FAMILY<\/span><\/td>\r\n153<\/span><\/td>\r\n<\/tr>\r\n
GEN-DUL-001-05<\/span><\/td>\r\nDULM_FAM1<\/span><\/td>\r\nDULMAGE FAMILY<\/span><\/td>\r\n34<\/span><\/td>\r\n<\/tr>\r\n
GEN-LAK-001-02<\/span><\/td>\r\nLAKE_FAM1<\/span><\/td>\r\nLAKE FAMILY<\/span><\/td>\r\n19<\/span><\/td>\r\n<\/tr>\r\n
HIS-HAS-102-17<\/span><\/td>\r\nNURS_WW1<\/span><\/td>\r\nNURSES OF WORLD WAR I<\/span><\/td>\r\n195<\/span><\/td>\r\n<\/tr>\r\n
LIS-FCC-002-01<\/span><\/td>\r\nPIERSON_PEDI<\/span><\/td>\r\nG.A. PIERSON PEDIGREE CHART<\/span><\/td>\r\n59<\/span><\/td>\r\n<\/tr>\r\n
LIS-FCC-002-01<\/span><\/td>\r\nSLAV_FAM1<\/span><\/td>\r\nSLAVEN FAMILY HISTORY<\/span><\/td>\r\n199<\/span><\/td>\r\n<\/tr>\r\n
GEN-WAL-004-01<\/span><\/td>\r\nWALK_FAM1<\/span><\/td>\r\n400 YEARS OF WALKERS<\/span><\/td>\r\n106<\/span><\/td>\r\n<\/tr>\r\n
GEN-CAN-002-01<\/span><\/td>\r\nCAN_FAM1<\/span><\/td>\r\nCANNIFF FAMILY<\/span><\/td>\r\n253<\/span><\/td>\r\n<\/tr>\r\n
GEN-FLA-001-01<\/span><\/td>\r\nFLAC_FAM1<\/span><\/td>\r\nFLACK FAMILY<\/span><\/td>\r\n26<\/span><\/td>\r\n<\/tr>\r\n
GEN-McC-006-01<\/span><\/td>\r\nMcCAL_FAM1<\/span><\/td>\r\nJAMES McCALMONT FAMILY<\/span><\/td>\r\n30<\/span><\/td>\r\n<\/tr>\r\n
LIS-BMD-006-14<\/span><\/td>\r\nBELANGER_4<\/span><\/td>\r\nBELANGER COLLECTION # 4<\/span><\/td>\r\n29,877<\/span><\/td>\r\n<\/tr>\r\n
GEN-STI-002-01<\/span><\/td>\r\nSTIN_CONG1<\/span><\/td>\r\nSTINSON CONGER FAMILY<\/span><\/td>\r\n91<\/span><\/td>\r\n<\/tr>\r\n
GEN-CAD-001-01<\/span><\/td>\r\nCADMAN1<\/span><\/td>\r\nWILLIAM and ELIZABETH CADMAN<\/span><\/td>\r\n112<\/span><\/td>\r\n<\/tr>\r\n
GEN-GRE-001-01<\/span><\/td>\r\nGREEN_HEN_SR<\/span><\/td>\r\nHENRY GREEN SR<\/span><\/td>\r\n200<\/span><\/td>\r\n<\/tr>\r\n
GEN-GUF-001-01<\/span><\/td>\r\nGUF_FAU_FRA1<\/span><\/td>\r\nGUFFIN FAULKNER FRASER FAMILY<\/span><\/td>\r\n347<\/span><\/td>\r\n<\/tr>\r\n
GEN-HAL-001-01<\/span><\/td>\r\nHALL_ALEX1<\/span><\/td>\r\nALEXANDER HALL & CATHERINE McCULEY<\/span><\/td>\r\n78<\/span><\/td>\r\n<\/tr>\r\n
GEN-HUD-001-01<\/span><\/td>\r\nHUD_WM_EST1<\/span><\/td>\r\nWILLIAM and ESTER HUDGINS<\/span><\/td>\r\n149<\/span><\/td>\r\n<\/tr>\r\n
GEN-JON-001-01<\/span><\/td>\r\nJONES_FAM1<\/span><\/td>\r\nJONES FAMILY<\/span><\/td>\r\n81<\/span><\/td>\r\n<\/tr>\r\n
GEN-LEE-001-01<\/span><\/td>\r\nLEE-QUI1<\/span><\/td>\r\nJOHN LEE & NANCY “ANNE” QUINN<\/span><\/td>\r\n65<\/span><\/td>\r\n<\/tr>\r\n
GEN-McC-005-01<\/span><\/td>\r\nMcCON_COV1<\/span><\/td>\r\nJONATHAN McCONNELL & HANNAH COVERT<\/span><\/td>\r\n169<\/span><\/td>\r\n<\/tr>\r\n
GEN-WAL-003-01<\/span><\/td>\r\nWALD_ROB1<\/span><\/td>\r\nROBERT WALDRON FAMILY<\/span><\/td>\r\n148<\/span><\/td>\r\n<\/tr>\r\n
HIS-HAS-116-02<\/span><\/td>\r\nHUNT_CLOS_CH1<\/span><\/td>\r\nHUNTINGDON TOWNSHIP CLOSED CHURCHES<\/span><\/td>\r\n4<\/span><\/td>\r\n<\/tr>\r\n
LIS-BMD-108-01<\/span><\/td>\r\nCAMP_HERALD<\/span><\/td>\r\nCAMPBELLFORD HERALD – BIRTHS<\/span><\/td>\r\n11,566<\/span><\/td>\r\n<\/tr>\r\n
LIS-BMD-108-02<\/span><\/td>\r\nCAMP_HERALD<\/span><\/td>\r\nCAMPBELLFORD HERALD – DEATHS<\/span><\/td>\r\n17,060<\/span><\/td>\r\n<\/tr>\r\n
LIS-BMD-108-03<\/span><\/td>\r\nCAMP_HERALD<\/span><\/td>\r\nCAMPBELLFORD HERALD – MARRIAGES\/GROOM<\/span><\/td>\r\n7,425<\/span><\/td>\r\n<\/tr>\r\n
LIS-BMD-108-04<\/span><\/td>\r\nCAMP_HERALD<\/span><\/td>\r\nCAMPBELLFORD HERALD – MARRIAGES\/BRIDE<\/span><\/td>\r\n7,423<\/span><\/td>\r\n<\/tr>\r\n
LIS-BMD-108-05<\/span><\/td>\r\nCAMP_HERALD<\/span><\/td>\r\nCAMPBELLFORD HERALD – EVENTS and PHOTOS<\/span><\/td>\r\n1,445<\/span><\/td>\r\n<\/tr>\r\n
LIS-BMD-072-02<\/span><\/td>\r\nINTELL_BMD_2<\/span><\/td>\r\nINTELLIGENCER – BIRTHS\/MARRIAGES\/DEATHS 2022<\/span><\/td>\r\n7,476<\/span><\/td>\r\n<\/tr>\r\n
GEN-HIL-001-01<\/span><\/td>\r\nHILL_FAM_1<\/span><\/td>\r\nHILL (from microfiche) FRALICK & FAULKNER<\/span><\/td>\r\n1,122<\/span><\/td>\r\n<\/tr>\r\n
GEN-MOR-002-01<\/span><\/td>\r\nBET_MORD_FAM_1<\/span><\/td>\r\nJOSEPH MORDEN & MARGARET BETSKY<\/span><\/td>\r\n86<\/span><\/td>\r\n<\/tr>\r\n
GEN-MUM-001-01<\/span><\/td>\r\nMUMM_FAM_1<\/span><\/td>\r\nMUMMERT FAMILY<\/span><\/td>\r\n18<\/span><\/td>\r\n<\/tr>\r\n
GEN-PHI-001-01<\/span><\/td>\r\nGUN_PHIL_FAM_1<\/span><\/td>\r\nJOHN PHILLIPS & ANN GUNTER<\/span><\/td>\r\n307<\/span><\/td>\r\n<\/tr>\r\n
GEN-SOU-001-01<\/span><\/td>\r\nSOUS_FAM_1<\/span><\/td>\r\nWILLIAM SOUSTER FAMILY<\/span><\/td>\r\n102<\/span><\/td>\r\n<\/tr>\r\n
GEN-STE-001-01<\/span><\/td>\r\nSTEW_FAM_1<\/span><\/td>\r\nHUGH STEWART FAMILY<\/span><\/td>\r\n213<\/span><\/td>\r\n<\/tr>\r\n
GEN-STO-003-01<\/span><\/td>\r\nLID_STOR_FAM_1<\/span><\/td>\r\nISAAC STORRING & ELIZABETH LIDDY<\/span><\/td>\r\n66<\/span><\/td>\r\n<\/tr>\r\n
GEN-WOR-001-01<\/span><\/td>\r\nWORD_FAM_1<\/span><\/td>\r\nPETER WORDEN FAMILY<\/span><\/td>\r\n101<\/span><\/td>\r\n<\/tr>\r\n
DIR-COM-003-05<\/span><\/td>\r\nHAS_DIR_1869<\/span><\/td>\r\nHASTINGS COUNTY DIRECTORY – 1869<\/span><\/td>\r\n12,000<\/span><\/td>\r\n<\/tr>\r\n
GEN-McN-002-01<\/span><\/td>\r\nMcNAR_BROW_1<\/span><\/td>\r\nJANET McNARIN & JAMES BROWN<\/span><\/td>\r\n322<\/span><\/td>\r\n<\/tr>\r\n
GEN-O’BR-001-03<\/span><\/td>\r\nOBRIE_1<\/span><\/td>\r\nO’BRIENS OF ENNISCORTHY<\/span><\/td>\r\n43<\/span><\/td>\r\n<\/tr>\r\n
GEN-OST-001-02<\/span><\/td>\r\nOSTRAN_1<\/span><\/td>\r\nOSTRANDER of SOUTH BAY<\/span><\/td>\r\n165<\/span><\/td>\r\n<\/tr>\r\n
GEN-PET-001-01<\/span><\/td>\r\nPETE_1<\/span><\/td>\r\nPETERSON FAMILY<\/span><\/td>\r\n20<\/span><\/td>\r\n<\/tr>\r\n
GEN-PIC-001-01<\/span><\/td>\r\nPICK_1<\/span><\/td>\r\nREV DANIEL PICKETT<\/span><\/td>\r\n173<\/span><\/td>\r\n<\/tr>\r\n
GEN-SIM-002-02<\/span><\/td>\r\nSIMM_1<\/span><\/td>\r\nSIMMONS – PALATINE FAMILIES<\/span><\/td>\r\n266<\/span><\/td>\r\n<\/tr>\r\n
GEN-TER-003-03<\/span><\/td>\r\nTER_FRE_1<\/span><\/td>\r\nEVERT TERWILLIGAR & SARAH FREER<\/span><\/td>\r\n47<\/span><\/td>\r\n<\/tr>\r\n
GEN-YOU-001-02<\/span><\/td>\r\nYOUN_1<\/span><\/td>\r\nYOUNG – BIBLE RECORDINGS<\/span><\/td>\r\n40<\/span><\/td>\r\n<\/tr>\r\n
GEN-SHO-001-01<\/span><\/td>\r\nSHOE_1<\/span><\/td>\r\nDESCENDANTS of RICHARD SHOEBRIDGE<\/span><\/td>\r\n1001<\/span><\/td>\r\n<\/tr>\r\n
GEN-MEL-001-01<\/span><\/td>\r\nMELV_1<\/span><\/td>\r\nWILLIAM JOHN MELVILLE & ELIZABETH McDONALD<\/span><\/td>\r\n203<\/span><\/td>\r\n<\/tr>\r\n
GEN-BLA-003-02<\/span><\/td>\r\nBLACK_1<\/span><\/td>\r\nBLACKBURN from YORKSHIRE ENGLAND<\/span><\/td>\r\n306<\/span><\/td>\r\n<\/tr>\r\n
GEN-CAN-150-1\/46<\/span><\/td>\r\nCAN_150<\/span><\/td>\r\nCANADA 150 PROJECT<\/span><\/td>\r\n7098<\/span><\/td>\r\n<\/tr>\r\n
GEN-GOU-001-01<\/span><\/td>\r\nGOULD_1<\/span><\/td>\r\nGEORGE RYERSON GOULD<\/span><\/td>\r\n159<\/span><\/td>\r\n<\/tr>\r\n
GEN-MOF-001-01<\/span><\/td>\r\nMOFFAT_1<\/span><\/td>\r\nTHOMAS MOFFAT<\/span><\/td>\r\n156<\/span><\/td>\r\n<\/tr>\r\n
GEN-NOL-001-01<\/span><\/td>\r\nNOLLES_1<\/span><\/td>\r\nWILLEM NOLLES<\/span><\/td>\r\n408<\/span><\/td>\r\n<\/tr>\r\n
GEN-WAL-002-01<\/span><\/td>\r\nWALLACE_1<\/span><\/td>\r\nJAMES WALLACE & MARY IRWIN<\/span><\/td>\r\n274<\/span><\/td>\r\n<\/tr>\r\n
GEN-CLA-002-02<\/span><\/td>\r\nCLARK_2<\/span><\/td>\r\nJACOB CLARK FAMILY<\/span><\/td>\r\n446<\/span><\/td>\r\n<\/tr>\r\n
GEN-HOF-001-01<\/span><\/td>\r\nHOFF_1<\/span><\/td>\r\nHOFFMAN FAMILY<\/span><\/td>\r\n127<\/span><\/td>\r\n<\/tr>\r\n
GEN-MIT-001-03<\/span><\/td>\r\nMITCH_3<\/span><\/td>\r\nROBERT MITCHEL & ELIZABETH JUNKIN<\/span><\/td>\r\n182<\/span><\/td>\r\n<\/tr>\r\n
LIS-VOT-001-01<\/span><\/td>\r\nVOTE35_HP<\/span><\/td>\r\nVOTER LISTS 1935: HASTINGS-PETERBOROUGH<\/span><\/td>\r\n16,949<\/span><\/td>\r\n<\/tr>\r\n
LIS-BMD-123-01<\/span><\/td>\r\nPEC_BIRTHS_V3<\/span><\/td>\r\nPEC BIRTHS 1869-1879<\/span><\/td>\r\n3,030<\/span><\/td>\r\n<\/tr>\r\n
LIS-BMD-124-01<\/span><\/td>\r\nQUAK_APR23<\/span><\/td>\r\nQUAKER REGISTERS from WEST LAKE (PEC)<\/span><\/td>\r\n1,911<\/span><\/td>\r\n<\/tr>\r\n
\u00a0LIS-BMD-125-01<\/span><\/td>\r\n\u00a0MM_MAY23<\/span><\/td>\r\n\u00a0MISSING MARRIAGES of HASTINGS COUNTY<\/span><\/td>\r\n\u00a02514<\/span><\/td>\r\n<\/tr>\r\n
GEN-POS-001-23<\/span><\/td>\r\nPOST_SP_AU0823<\/span><\/td>\r\nPOST FAMILY SPOUSES<\/span><\/td>\r\n519<\/span><\/td>\r\n<\/tr>\r\n
DIR-COM-003-07<\/span><\/td>\r\nHAS-DIR-89-AU1023<\/span><\/td>\r\nHASTINGS COUNTY DIRECTORY – 1889<\/span><\/td>\r\n16,234<\/span><\/td>\r\n<\/tr>\r\n
\u00a0REC-OBI-002-01<\/span><\/td>\r\n\u00a0MEM_SERV_23<\/span><\/td>\r\nMEMORIAL SERVICES COLLECTION\u00a0<\/span><\/td>\r\n\u00a0214<\/span><\/td>\r\n<\/tr>\r\n
<\/td>\r\n<\/td>\r\n<\/td>\r\n<\/td>\r\n<\/tr>\r\n
<\/td>\r\n<\/td>\r\n–> BLANK RECORDS <–<\/span><\/td>\r\n0<\/span><\/td>\r\n<\/tr>\r\n
<\/td>\r\n<\/td>\r\n<\/td>\r\n<\/td>\r\n<\/tr>\r\n
<\/td>\r\n<\/td>\r\nTOTAL<\/span><\/td>\r\n1,735,195<\/strong><\/span><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/figure>\r\n\r\n

UNIQUE BATCHES in FIND-IT<\/a><\/div><\/p>\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
FIND-IT: MAINTENANCE<\/strong><\/a><\/span><\/td>\r\n<\/tr>\r\n
SELECT * FROM Has_Dir_1889 WHERE BATCH LIKE “HAS-DIR-1889_SID1”\r\n<\/strong><\/td>\r\n<\/tr>\r\n
UPDATE FIND_IT_table SET TITLE = “Hastings County Directory – 1879” WHERE LIB_REF_NO = “DIR-COM-003-06”\r\n<\/strong><\/td>\r\n<\/tr>\r\n
SELECT * FROM FIND_IT_table WHERE LIB_REF_NO like ‘HIS-LOY-002-06’\r\n<\/strong><\/td>\r\n<\/tr>\r\n
SELECT * FROM FIND_IT_table WHERE TITLE like “%Parks; Cyrenius%”\r\n<\/strong><\/td>\r\n<\/tr>\r\n
SELECT TITLE, LIB_REF_NO, COUNT(*) as RECORD_COUNT FROM FIND_IT_table GROUP BY TITLE\r\n<\/strong><\/td>\r\n<\/tr>\r\n
SELECT TITLE,LIB_REF_NO, COUNT(*) FROM FIND_IT_table GROUP BY TITLE\r\n<\/strong><\/td>\r\n<\/tr>\r\n
Select COALESCE(batch, ‘TOTAL’) as Batch,format(count(*),0) as Count from `FIND_IT_table` group by batch with rollup<\/strong><\/td>\r\n<\/tr>\r\n
Select count(batch) from FIND_IT_table group by batch<\/strong><\/td>\r\n<\/tr>\r\n
=IF(G1=”McCaw; Alex 1669-c1734″,”—–“, “CHECK ME”)\r\n<\/strong><\/td>\r\n<\/tr>\r\n
UPDATE FIND_IT_table SET XXXXX = “XXXXX” WHERE batch = “XXXXX”\u00a0<\/strong><\/td>\r\n<\/tr>\r\n
UPDATE FIND_IT_table SET TITLE = “Sample Title” WHERE BATCH like “SAMPLE”<\/strong><\/td>\r\n<\/tr>\r\n
UPDATE FIND_IT_table SET GIVEN_NAMES = “Alice 1873-05-02 – 1933-05-01” WHERE ID = 1222228<\/strong><\/td>\r\n<\/tr>\r\n
DELETE FROM FIND_IT_table WHERE batch = “”<\/strong><\/td>\r\n<\/tr>\r\n
SELECT SURNAME, COUNT(SURNAME) FROM FIND_IT_table GROUP BY SURNAME ORDER BY COUNT(SURNAME) DESC<\/strong><\/td>\r\n<\/tr>\r\n
select count(*) FROM Hast_Directory_1879 WHERE municipality like “Ameliasburgh Township”<\/strong><\/td>\r\n<\/tr>\r\n
SELECT COUNT(ID) FROM FIND_IT_table WHERE SURNAME IS NOT NULL<\/strong><\/td>\r\n<\/tr>\r\n
SELECT COUNT(ID) FROM FIND_IT_table WHERE SURNAME IS NULL<\/strong><\/td>\r\n<\/tr>\r\n
DELETE FROM Quinte_Obituary_Collection WHERE batch = “OBITS_Aug23”<\/strong><\/td>\r\n<\/tr>\r\n
\u00a0SELECT 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(<\/em>) > 1<\/strong> <\/mark>[ChatGPT]<\/mark><\/strong><\/td>\r\n<\/tr>\r\n
\u00a0SELECT * FROM Quinte_Obituary_Collection WHERE BATCH = “QB_OBITS_CP12” ORDER BY SURNAME, GIVEN_NAMES<\/strong> <\/mark>[ChatGPT]<\/mark><\/strong><\/td>\r\n<\/tr>\r\n
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(<\/em>)>1<\/strong><\/td>\r\n<\/tr>\r\n
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(<\/em>)>1<\/strong><\/td>\r\n<\/tr>\r\n
\u00a0SELECT 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(<\/em>)> 1<\/strong><\/span><\/td>\r\n<\/tr>\r\n
SELECT CONCAT(SURNAME, ‘ # ‘,GIVEN_NAMES) AS COMBO\r\nFROM OBITUARY_TEST_1\r\nGROUP BY COMBO\r\nHAVING COUNT(COMBO)>1<\/strong><\/td>\r\n<\/tr>\r\n
DELETE FROM TCA1 WHERE ID > 4151<\/strong><\/td>\r\n<\/tr>\r\n
DELETE FROM TCA1 WHERE INDEX_PAGE is null<\/strong><\/td>\r\n<\/tr>\r\n
\u00a0SELECT DISTINCT BATCH FROM FIND_IT_table<\/strong><\/td>\r\n<\/tr>\r\n
SELECT INDEX_PAGE, COUNT(*) FROM TCA1 GROUP BY INDEX_PAGE ORDER BY INDEX_PAGE<\/strong><\/td>\r\n<\/tr>\r\n
\r\nUPDATE FIND_IT_table<\/strong>\r\nSET PAGE = REPLACE(PAGE, “QWPL”, “newspaper”)<\/strong>\r\nWHERE LIB_REF_NO = “LIS-BMD-072_11”<\/strong><\/td>\r\n<\/tr>\r\n
UPDATE FIND_IT_table\r\n<\/strong>SET PAGE = REPLACE(PAGE, “index”, “newspaper index”)<\/strong>\r\nWHERE LIB_REF_NO = “LIS-BMD-072_11” AND ID >= 3217491<\/strong><\/td>\r\n<\/tr>\r\n
SELECT cast(<\/strong>\r\nreplace(<\/strong>\r\nSUBSTRING_INDEX(page, ‘ page ‘, -1),<\/strong>\r\n” of newspaper index”,<\/strong>\r\n“”<\/strong>\r\n) as unsigned<\/strong>\r\n) AS page_num,<\/strong>\r\ncount(*) as Couint<\/strong>\r\nFROM `FIND_IT_table`<\/strong>\r\nwhere TITLE = “Trenton Courier Advocate 1950-1960”<\/strong>\r\ngroup by page_num<\/strong>\r\norder by page_num;<\/strong><\/td>\r\n<\/tr>\r\n
<\/td>\r\n<\/tr>\r\n
SELECT cast(<\/strong>\r\nreplace(<\/strong>\r\nSUBSTRING_INDEX(page, ‘ page ‘, -1),<\/strong>\r\n” of newspaper index”,<\/strong>\r\n“”<\/strong>\r\n) as unsigned<\/strong>\r\n) AS page_num,<\/strong>\r\ncount(*) as Couint<\/strong>\r\nFROM `FIND_IT_table`<\/strong>\r\nwhere TITLE = “Trenton Courier Advocate 1950-1960”<\/strong>\r\ngroup by page_num<\/strong>\r\norder by page_num;<\/strong><\/td>\r\n<\/tr>\r\n
<\/td>\r\n<\/tr>\r\n
UPDATE FIND_IT_table<\/strong>\r\nSET PAGE = REPLACE(PAGE, “QWPL”, “newspaper”)<\/strong>\r\nWHERE LIB_REF_NO = “LIS-BMD-106-01”<\/strong><\/td>\r\n<\/tr>\r\n
<\/td>\r\n<\/tr>\r\n
UPDATE FIND_IT_table<\/strong>\r\nSET PAGE = REPLACE(PAGE, “index”, “newspaper index”)<\/strong>\r\nWHERE LIB_REF_NO = “LIS-BMD-072_11”<\/strong><\/td>\r\n<\/tr>\r\n
<\/td>\r\n<\/tr>\r\n
<\/td>\r\n<\/tr>\r\n
[NOTE: Quotation Marks Must Be Entered from the Keyboard \/ NOT COPIED]<\/strong><\/td>\r\n<\/tr>\r\n
<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/figure>\r\n\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","footnotes":""},"class_list":["post-1559","page","type-page","status-publish","czr-hentry"],"_links":{"self":[{"href":"https:\/\/wickson.net\/blog\/wp-json\/wp\/v2\/pages\/1559","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wickson.net\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/wickson.net\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/wickson.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wickson.net\/blog\/wp-json\/wp\/v2\/comments?post=1559"}],"version-history":[{"count":1,"href":"https:\/\/wickson.net\/blog\/wp-json\/wp\/v2\/pages\/1559\/revisions"}],"predecessor-version":[{"id":1560,"href":"https:\/\/wickson.net\/blog\/wp-json\/wp\/v2\/pages\/1559\/revisions\/1560"}],"wp:attachment":[{"href":"https:\/\/wickson.net\/blog\/wp-json\/wp\/v2\/media?parent=1559"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}