names

53 rows where place_id = 755245

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4426766 2173186 2173186 defendant Penbrugge Robert de   755245 755245 Penbrugge, Robert de, of Herefordshire 0
4433442 2175220 2175220 defendant Sholle Richard   755245 755245 Sholle, Richard, of Herefordshire 1
4433443 2175220 2175220 defendant Grendon Warin   755245 755245 Grendon, Warin, of Herefordshire 2
4439151 2181528 2181528 defendant Berd Roger   755245 755245 Berd, Roger, of Herefordshire 2
4453318 2186046 2186046 defendant Madbrok John   755245 755245 Madbrok, John, of Herefordshire 3
4461412 2188651 2188651 defendant Bradewey John   755245 755245 Bradewey, John, of Herefordshire, esquire 2
4462109 2188849 2188849 defendant Weston Giles de   755245 755245 Weston, Giles de, of Herefordshire 2
4462113 2188850 2188850 defendant Weston Giles   755245 755245 Weston, Giles, of Herefordshire 2
4476192 2193216 2193216 defendant Wyche John   755245 755245 Wyche, John, of Herefordshire 1
4486843 2196600 2196600 defendant Burley Roger   755245 755245 Burley, Roger, of Herefordshire 0
4486847 2196601 2196601 defendant Burley Roger   755245 755245 Burley, Roger, of Herefordshire 0
4488557 2197141 2197141 defendant Solers William   755245 755245 Solers, William, of Herefordshire 0
4503512 2201670 2201670 defendant Enynes Richard   755245 755245 Enynes, Richard, of Herefordshire 0
4518422 2206135 2206135 defendant Baunebury John   755245 755245 Baunebury, John, of Herefordshire 1
4532317 2210375 2210375 defendant Parker Thomas   755245 755245 Parker, Thomas, of Herefordshire 2
4548675 2215528 2215528 defendant Bernard Thomas   755245 755245 Bernard, Thomas, of Herefordshire 1
4550507 2216103 2216103 defendant Wynter Richard   755245 755245 Wynter, Richard, of Herefordshire 2
4554546 2217352 2217352 plaintiff Gydy Walter   755245 755245 Gydy, Walter, of Herefordshire 0
4555790 2217748 2217748 defendant Wyche John   755245 755245 Wyche, John, of Herefordshire 0
4556209 2217882 2217882 defendant Parkere Thomas   755245 755245 Parkere, Thomas, of Herefordshire, esq, staying with Thomas, earl of Arundell 2
4558071 2218458 2218458 defendant Luggore Richard   755245 755245 Luggore, Richard, of Herefordshire 0
4577094 2224344 2224344 defendant Crikton William esq 755245 755245 Crikton, William, of Herefordshire, esq 1
4577715 2224536 2224536 defendant Barlee John   755245 755245 Barlee, John, of Herefordshire 0
4585524 2226895 2226895 plaintiff Hammes Roger   755245 755245 Hammes, Roger, of Herefordshire 0
4601294 2231640 2231640 defendant Wygan Hugh esq 755245 755245 Wygan, Hugh, of Herefordshire, esq 0
4607947 2233607 2233607 defendant Mare James de la esq 755245 755245 Mare, James de la, of Herefordshire, esq 0
4611587 2234687 2234687 defendant Russell John   755245 755245 Russell, John, of Herefordshire 0
4611591 2234689 2234689 defendant Russell John   755245 755245 Russell, John, of Herefordshire 0
4613754 2235316 2235316 defendant Pypaudre Thomas   755245 755245 Pypaudre, Thomas, of Herefordshire 1
4617827 2236578 2236578 defendant Coys Walter   755245 755245 Coys, Walter, of Herefordshire 5
4626994 2239391 2239391 defendant Parker Thomas Thomas   755245 755245 Parker, Thomas Thomas, of Herefordshire, esquire 0
4639192 2242982 2242982 defendant Russell John   755245 755245 Russell, John, of Herefordshire 0
4639194 2242983 2242983 defendant Russell John   755245 755245 Russell, John, of Herefordshire 0
4639196 2242984 2242984 defendant Russell John   755245 755245 Russell, John, of Herefordshire 0
4639198 2242985 2242985 defendant Russell John   755245 755245 Russell, John, of Herefordshire 0
4640199 2243247 2243247 defendant Pipaudre Thomas   755245 755245 Pipaudre, Thomas, of Herefordshire 1
4640794 2243409 2243409 defendant Wynnesley Richard   755245 755245 Wynnesley, Richard, of Herefordshire 2
4645276 2244687 2244687 defendant Brugge John esq 755245 755245 Brugge, John, of Herefordshire, esq 4
4645285 2244688 2244688 defendant Brugge John esq 755245 755245 Brugge, John, of Herefordshire, esq 5
4645752 2244822 2244822 defendant Wymesley Richard   755245 755245 Wymesley, Richard, of Herefordshire 0
4647060 2245198 2245198 plaintiff Russell John   755245 755245 (Russell, John, of Herefordshire 1
4656692 2247986 2247986 defendant Lenthale Roland   755245 755245 Lenthale, Roland, of Herefordshire, knight 0
4657485 2248235 2248235 defendant Russell John   755245 755245 Russell, John, of Herefordshire 0
4698857 2265124 2265124 defendant Dogeon John (legal representative) 755245 755245 Dogeon, John, of Herefordshire, executors of 0
4707452 2267708 2267708 plaintiff Mey John   755245 755245 Mey, John, of Herefordshire 0
4760827 2283724 2283724 plaintiff Dausey John   755245 755245 Dausey, John, of Herefordshire 0
5127777 2394602 2394602 plaintiff Catesby William   755245 755245 Catesby, William, of Herefordshire, sheriff & knight 0
5127783 2394603 2394603 plaintiff Catesby William   755245 755245 Catesby, William, of Herefordshire, sheriff & knight 0
5366306 2465116 2465116 plaintiff Gamage Thomas clerk 755245 755245 Gamage, Thomas, of Herefordshire, clerk 1
5396998 2474222 2474222 plaintiff Gamage Thomas clerk 755245 755245 Gamage, Thomas, of Herefordshire, clerk 1
5399092 2474811 2474811 plaintiff de la Bere Richard   755245 755245 de la Bere, Richard, of Herefordshire, sheriff 0
5410255 2478019 2478019 plaintiff Camage Thomas clerk 755245 755245 Camage, Thomas, of Herefordshire, clerk 1
5622128 2550834 2550834 defendant Burwell Thomas haberdasher 755245 755245 Burwell, Thomas, of Herefordshire, haberdasher 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);