names

32 rows where place_id = 594685

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3617170 1872995 1872995 defendant Baret Thomas yeoman 594685 594685 Baret, Thomas, of South Birlyngham, yeoman 1
3984150 2019097 2019097 defendant Mason John yeoman 594685 594685 Mason, John, of South Birlyngham, yeoman 0
4555635 2217690 2217690 defendant Pykeryng John   594685 594685 Pykeryng, John, of South Birlyngham 1
4740112 2277624 2277624 defendant (not given) William vicar of Barton 594685 594685 Barton, William, of South Birlyngham, clerk & formerly vicar of Wesenham 2
4776007 2288496 2288496 defendant Palmere Thomas yeoman 594685 594685 Palmere, Thomas, of South Birlyngham, yeoman 0
4776648 2288688 2288688 defendant Constable Thomas laborer 594685 594685 Constable, Thomas, of South Birlyngham, laborer 1
4961043 2345263 2345263 defendant Hoo Richard husbandman 594685 594685 Hoo, Richard, of South Birlyngham, husbandman 0
4978824 2350619 2350619 defendant Roo Richard   594685 594685 Roo, Richard, of South Birlyngham 0
4978826 2350620 2350620 defendant Roo Richard   594685 594685 Roo, Richard, of South Birlyngham 0
4985957 2352716 2352716 defendant Roo Richard husbandman 594685 594685 Roo, Richard, of South Birlyngham, husbandman 0
4986846 2353004 2353004 defendant Hoo Richard husbandman 594685 594685 Hoo, Richard, of South Birlyngham, husbandman 4
5002789 2357722 2357722 defendant Roos Richard husbandman 594685 594685 Roos, Richard, of South Birlyngham, husbandman 0
5011957 2360348 2360348 defendant Deynes John yeoman 594685 594685 Deynes, John, of South Birlyngham, yeoman 0
5018243 2362221 2362221 defendant Chirch Roger husbandman 594685 594685 Chirch, Roger, of South Birlyngham, husbandman 2
5031385 2366036 2366036 defendant Chirche Roger husbandman 594685 594685 Chirche, Roger, of South Birlyngham, husbandman 0
5056155 2373416 2373416 defendant Roo Richard husbandman 594685 594685 Roo, Richard, of South Birlyngham, husbandman 0
5060096 2374586 2374586 defendant Atchirch Roger yeoman 594685 594685 Atchirch, Roger, of South Birlyngham, yeoman 1
5075182 2379074 2379074 defendant Roo Richard husbandman 594685 594685 Roo, Richard, of South Birlyngham, husbandman 0
5100340 2386544 2386544 defendant Roo Richard husbandman 594685 594685 Roo, Richard, of South Birlyngham, husbandman 12
5156463 2403045 2403045 defendant Bylawe Roger husbandman 594685 594685 Bylawe, Roger, of South Birlyngham, husbandman 0
5156466 2403046 2403046 defendant Bylawe Roger husbandman 594685 594685 Bylawe, Roger, of South Birlyngham, husbandman 1
5156469 2403047 2403047 defendant Bylawe Roger husbandman 594685 594685 Bylawe, Roger, of South Birlyngham, husbandman 1
5157130 2403224 2403224 defendant Roo Richard de husbandman 594685 594685 Roo, Richard de, of South Birlyngham, husbandman 2
5173172 2407863 2407863 defendant Roo Richard de husbandman 594685 594685 Roo, Richard de, of South Birlyngham, husbandman 2
5193030 2413690 2413690 defendant Roo Richard husbandman 594685 594685 Roo, Richard, of South Birlyngham, husbandman 2
5194642 2414165 2414165 defendant Belaugh William husbandman 594685 594685 Belaugh, William, of South Birlyngham, husbandman 1
5208866 2418317 2418317 defendant Belaugh William husbandman 594685 594685 Belaugh, William, of South Birlyngham, husbandman 1
5514740 2509450 2509450 defendant Warner Robert husbandman 594685 594685 Warner, Robert, of South Birlyngham, husbandman 0
5514741 2509450 2509450 defendant Warner William laborer 594685 594685 Warner, William, of South Birlyngham, laborer 1
5514742 2509450 2509450 defendant Colman William laborer 594685 594685 Colman, William, of South Birlyngham, laborer 2
5514743 2509450 2509450 defendant Botour John, senior husbandman 594685 594685 Botour, John, senior, of South Birlyngham, husbandman 3
5577764 2528115 2528115 defendant Crystenwhete Robert husbandman 594685 594685 Crystenwhete, Robert, of South Birlyngham, husbandman 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);