names

50 rows where place_id = 593375

✎ 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
3611543 1871279 1871279 defendant Walker Robert yeoman 593375 593375 Walker, Robert, of Tenelby, yeoman 0
3618087 1873280 1873280 defendant Tyryngton Robert yeoman 593375 593375 Tyryngton, Robert, of Tenelby, yeoman 0
4446356 2183778 2183778 plaintiff del Grene William   593375 593375 del Grene, William, of Tenelby 0
4454586 2186452 2186452 defendant Wadyngham Lawrence de   593375 593375 Wadyngham, Lawrence de, of Tenelby 0
4493922 2198795 2198795 defendant Smyth John   593375 593375 Smyth, John, of Tenelby 0
4493923 2198795 2198795 defendant Godeson John   593375 593375 Godeson, John, of Tenelby 1
4522150 2207273 2207273 defendant Marsshall William   593375 593375 Marsshall, William, of Tenelby 0
4525465 2208297 2208297 defendant Smyth John   593375 593375 Smyth, John, of Tenelby 1
4526178 2208477 2208477 defendant Markand William   593375 593375 Markand, William, of Tenelby 1
4540839 2213039 2213039 defendant Godeson John   593375 593375 Godeson, John, of Tenelby 0
4546800 2214925 2214925 defendant Cook John   593375 593375 Cook, John, of Tenelby 0
4563366 2220115 2220115 plaintiff Riby John   593375 593375 Riby, John, of Tenelby 0
4566982 2221234 2221234 defendant Brughton John   593375 593375 Brughton, John, of Tenelby 4
4568599 2221758 2221758 defendant Cook Robert   593375 593375 Cook, Robert, of Tenelby 0
4569756 2222122 2222122 defendant Riby John   593375 593375 Riby, John, of Tenelby 10
4569794 2222128 2222128 defendant Riby John   593375 593375 Riby, John, of Tenelby 5
4571019 2222503 2222503 defendant Smyth William chaplain 593375 593375 Smyth, William, of Tenelby, chaplain 0
4590631 2228430 2228430 defendant Britte John   593375 593375 Britte, John, of Tenelby 0
4603992 2232419 2232419 defendant Keller Thomas   593375 593375 Keller, Thomas, of Tenelby 6
4619817 2237175 2237175 defendant Walesby John   593375 593375 Walesby, John, of Tenelby 0
4721658 2272107 2272107 defendant Wadyngham William gent 593375 593375 Wadyngham, William, of Tenelby, gent 1
4738330 2277084 2277084 defendant Blaunche Robert   593375 593375 Blaunche, Robert, of Tenelby, vicar 0
4753799 2281561 2281561 defendant Blaunche Robert   593375 593375 Blaunche, Robert, of Tenelby, vicar 0
4754449 2281770 2281770 defendant Walesby John husbandman 593375 593375 Walesby, John, of Tenelby, husbandman 2
4813001 2300182 2300182 defendant Walesby John butcher 593375 593375 Walesby, John, of Tenelby, butcher 0
4823859 2303542 2303542 defendant Blewuch Robert clerk 593375 593375 Blewuch, Robert, of Tenelby, clerk 0
4850161 2311513 2311513 defendant Haunserd Gilbert gent 593375 593375 Haunserd, Gilbert, of Tenelby, gent 0
4869198 2317341 2317341 defendant Ingram Peter yeoman 593375 593375 Ingram, Peter, of Tenelby, yeoman 3
4876699 2319684 2319684 defendant Cabolirne Thomas husbandman 593375 593375 Cabolirne, Thomas, of Tenelby, husbandman 0
4900725 2326866 2326866 plaintiff Ingram Henry   593375 593375 Ingram, Henry, of Tenelby 2
4905637 2328365 2328365 defendant Haunsard Gilbert gent 593375 593375 Haunsard, Gilbert, of Tenelby, gent 0
4955857 2343718 2343718 defendant Holme Hugh husbandman 593375 593375 Holme, Hugh, of Tenelby, husbandman 0
4972515 2348711 2348711 defendant Trewe William husbandman 593375 593375 Trewe, William, of Tenelby, husbandman 0
4998749 2356514 2356514 defendant Walker William husbandman 593375 593375 Walker, William, of Tenelby, husbandman 0
5025807 2364447 2364447 defendant Walker William husbandman 593375 593375 Walker, William, of Tenelby, husbandman 0
5152188 2401778 2401778 defendant Lyndesey William syvyer or seive maker 593375 593375 Lyndesey, William, of Tenelby, syvyer or seive maker 0
5170061 2406980 2406980 defendant Lyndesey William syvyer 593375 593375 Lyndesey, William, of Tenelby, syvyer 0
5260151 2433301 2433301 defendant Walker Richard husbandman 593375 593375 Walker, Richard, of Tenelby, husbandman 0
5287146 2441255 2441255 defendant Grene William husbandman 593375 593375 Grene, William, of Tenelby, husbandman 0
5287147 2441255 2441255 defendant Lannam Thomas husbandman 593375 593375 Lannam, Thomas, of Tenelby, husbandman 1
5294712 2443434 2443434 defendant Baldok William husbandman 593375 593375 Baldok, William, of Tenelby, or of Cadeney, husbandman 0
5319310 2450869 2450869 defendant Ingylby alias Walker William husbandman 593375 593375 Ingylby alias Walker, William, of Tenelby, husbandman 0
5319311 2450869 2450869 defendant Marshall William husbandman 593375 593375 Marshall, William, of Tenelby, husbandman 1
5322448 2451782 2451782 defendant Milner John miller 593375 593375 Milner, John, of Tenelby, miller 0
5334738 2455455 2455455 defendant Wryght Thomas fuller 593375 593375 Wryght, Thomas, of Tenelby, fuller 0
5334739 2455455 2455455 defendant Wryght John chapman 593375 593375 Wryght, John, of Tenelby, chapman 1
5353768 2461245 2461245 defendant Walkar Richard husbandman 593375 593375 Walkar, Richard, of Tenelby, husbandman 1
5355733 2461870 2461870 defendant Walker William yeoman 593375 593375 Walker, William, of Tenelby, yeoman 1
5464529 2494311 2494311 defendant Goodale Richard mercer 593375 593375 Goodale, Richard, of Tenelby, mercer 0
5614982 2548479 2548479 defendant Wadyngham Lawrence de   593375 593375 Wadyngham, Lawrence de, of Tenelby 0

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);