names

60 rows where place_id = 753434

✎ 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
4049704 2042332 2042332 defendant Sheryn Richard   753434 753434 Sheryn, Richard, of Perham, mason 0
4413416 2169075 2169075 defendant atte Brouke William   753434 753434 atte Brouke, William, of Perham 0
4459292 2187955 2187955 plaintiff Roys John   753434 753434 Roys, John, of Perham 0
4502664 2201415 2201415 defendant Ratford John   753434 753434 Ratford, John, of Perham 2
4514796 2205046 2205046 defendant Markaunt John   753434 753434 Markaunt, John, of Perham, vicar 0
4525783 2208367 2208367 defendant Markaunt John   753434 753434 Markaunt, John, of Perham, vicar 0
4525785 2208368 2208368 defendant Markaunt John   753434 753434 Markaunt, John, of Perham, vicar 0
4566717 2221164 2221164 defendant Godyng William   753434 753434 Godyng, William, of Perham 1
4566721 2221164 2221164 defendant Dunche John   753434 753434 Dunche, John, of Perham 5
4568198 2221625 2221625 plaintiff Tut John   753434 753434 Tut, John, of Perham, vicar 0
4643475 2244191 2244191 defendant Prentys Robert   753434 753434 Prentys, Robert, of Perham 3
4659941 2248959 2248959 defendant Gerard John clerk 753434 753434 Gerard, John, of Perham, clerk 1
4683091 2260326 2260326 defendant Stebbyng John husbandman 753434 753434 Stebbyng, John, of Perham, husbandman 1
4683093 2260326 2260326 defendant Cook John butcher 753434 753434 Cook, John, of Perham, butcher 3
4685148 2260957 2260957 defendant Wryght William husbandman 753434 753434 Wryght, William, of Perham, husbandman 0
4746031 2279341 2279341 defendant Stillefeld Walter husbandman 753434 753434 Stillefeld, Walter, of Perham, husbandman 1
4749661 2280387 2280387 defendant Stebbyng John butcher 753434 753434 Stebbyng, John, of Perham, butcher 0
4752651 2281237 2281237 defendant Hawe John carpenter 753434 753434 Hawe, John, of Perham, carpenter 0
4760099 2283502 2283502 defendant Stebbyng John butcher 753434 753434 Stebbyng, John, of Perham, butcher 0
4766291 2285450 2285450 defendant Stebbyng John butcher 753434 753434 Stebbyng, John, of Perham, butcher 0
4767961 2285950 2285950 defendant Stilfeld Walter yeoman 753434 753434 Stilfeld, Walter, of Perham, yeoman 3
4772659 2287418 2287418 defendant Aylemer Nicholas sawyer 753434 753434 Aylemer, Nicholas, of Perham, sawyer 0
4777296 2288889 2288889 defendant Stebbyng John butcher 753434 753434 Stebbyng, John, of Perham, butcher 0
4780375 2289859 2289859 defendant Stebbyng John butcher 753434 753434 Stebbyng, John, of Perham, butcher 0
4782332 2290478 2290478 defendant Stebbyng John butcher 753434 753434 Stebbyng, John, of Perham, butcher 0
4790681 2293172 2293172 defendant Stebbyng John butcher 753434 753434 Stebbyng, John, of Perham, butcher 0
4822767 2303199 2303199 defendant Malt Richard husbandman 753434 753434 Malt, Richard, of Perham, husbandman 3
4886922 2322761 2322761 defendant Stebbyng John butcher 753434 753434 Stebbyng, John, of Perham, butcher 3
4932582 2336582 2336582 defendant Stebbyng John butcher 753434 753434 Stebbyng, John, of Perham, butcher 4
4956880 2344016 2344016 defendant Hunte Thomas thatcher 753434 753434 Hunte, Thomas, of Perham, thatcher 2
4986025 2352738 2352738 defendant Dogger Nicholas clerk 753434 753434 Dogger, Nicholas, of Perham, clerk 0
5043027 2369532 2369532 defendant Dogger Nicholas husbandman 753434 753434 Dogger, Nicholas, of Perham, husbandman 1
5053506 2372654 2372654 defendant Broker Robert tanner 753434 753434 Broker, Robert, of Perham, tanner 0
5053507 2372654 2372654 defendant Broker William tanner 753434 753434 Broker, William, of Perham, tanner 1
5053508 2372654 2372654 defendant Frankeleyn Thomas husbandman 753434 753434 Frankeleyn, Thomas, of Perham, husbandman 2
5147354 2400370 2400370 defendant Duke Richard husbandman 753434 753434 Duke, Richard, of Perham, husbandman 1
5182369 2410598 2410598 defendant Duke Richard husbandman 753434 753434 Duke, Richard, of Perham, husbandman 1
5182373 2410599 2410599 defendant Duke Richard husbandman 753434 753434 Duke, Richard, of Perham, husbandman 1
5203353 2416743 2416743 defendant Duke Richard husbandman 753434 753434 Duke, Richard, of Perham, husbandman 1
5241454 2427699 2427699 defendant Duke Richard husbandman 753434 753434 Duke, Richard, of Perham, husbandman 2
5241458 2427700 2427700 defendant Duke Richard husbandman 753434 753434 Duke, Richard, of Perham, husbandman 2
5350904 2460393 2460393 defendant Wolnard or Wolvard Richard husbandman 753434 753434 Wolnard or Wolvard, Richard, of Perham, husbandman 0
5352433 2460862 2460862 defendant Ramesholt William husbandman 753434 753434 Ramesholt, William, of Perham, husbandman 0
5354852 2461595 2461595 defendant Wulvard Richard husbandman 753434 753434 Wulvard, Richard, of Perham, husbandman 2
5354853 2461595 2461595 defendant Wulvard Stephen husbandman 753434 753434 Wulvard, Stephen, of Perham, husbandman 3
5397474 2474357 2474357 defendant Ferrour Robert husbandman 753434 753434 Ferrour, Robert, of Perham, husbandman 15
5424647 2482336 2482336 defendant Ferrour Robert husbandman 753434 753434 Ferrour, Robert, of Perham, husbandman 15
5434106 2485153 2485153 defendant Ravinsholt William husbandman 753434 753434 Ravinsholt, William, of Perham, husbandman 0
5434108 2485154 2485154 defendant Raumesholt William husbandman 753434 753434 Raumesholt, William, of Perham, husbandman 0
5449591 2489768 2489768 defendant Raumesholt William husbandman 753434 753434 Raumesholt, William, of Perham, husbandman 0
5457230 2492061 2492061 defendant Wolnard Richard husbandman 753434 753434 Wolnard, Richard, of Perham, husbandman 0
5461886 2493498 2493498 defendant Raumesholt William husbandman 753434 753434 Raumesholt, William, of Perham, husbandman 0
5469081 2495680 2495680 defendant Wolnard Richard husbandman 753434 753434 Wolnard, Richard, of Perham, husbandman 0
5480252 2499074 2499074 defendant Wolnard Richard husbandman 753434 753434 Wolnard, Richard, of Perham, husbandman 0
5493665 2503018 2503018 defendant Ramesholt William husbandman 753434 753434 Ramesholt, William, of Perham, husbandman 3
5508076 2507418 2507418 defendant Ramesholt William husbandman 753434 753434 Ramesholt, William, of Perham, husbandman 3
5508657 2507571 2507571 defendant Ramesholt William husbandman 753434 753434 Ramesholt, William, of Perham, husbandman 2
5620263 2550195 2550195 plaintiff Roys Thomas   753434 753434 Roys, Thomas, of Perham 0
5627856 2552681 2552681 plaintiff Parmafay John   753434 753434 Parmafay, John, of Perham 0
5627859 2552682 2552682 plaintiff Parmasay John   753434 753434 Parmasay, John, of Perham 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);