names

24 rows where place_id = 756979

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4421422 2171605 2171605 defendant Ranele John de   756979 756979 Ranele, John de, of Rameseye, son of Henry 0
4427126 2173308 2173308 plaintiff Ranele John de   756979 756979 Ranele, John de, of Rameseye, son of Henry 0
4441952 2182415 2182415 defendant Bakere Henry   756979 756979 Bakere, Henry, of Rameseye 1
4458437 2187683 2187683 defendant Osgood John   756979 756979 Osgood, John, of Rameseye 0
4468495 2190811 2190811 defendant Blaunche Thomas, senior   756979 756979 Blaunche, Thomas, senior, of Rameseye 0
4472185 2191966 2191966 defendant Bysshop William   756979 756979 Bysshop, William, of Rameseye 0
4485484 2196168 2196168 plaintiff Randolf John   756979 756979 Randolf, John, of Rameseye 0
4581109 2225576 2225576 defendant Bekeswelle John   756979 756979 Bekeswelle, John, of Rameseye 0
4626857 2239342 2239342 defendant Shirwode John   756979 756979 Shirwode, John, of Rameseye 1
4626858 2239342 2239342 defendant Shirwode William   756979 756979 Shirwode, William, of Rameseye 2
4626860 2239342 2239342 defendant Belle Richard   756979 756979 Belle, Richard, of Rameseye 4
4629150 2240046 2240046 defendant Boneface Arnald   756979 756979 Boneface, Arnald, of Rameseye 0
4636414 2242225 2242225 plaintiff Barkere Alice   756979 756979 Barkere, Alice, of Rameseye, formerly wife of John 0
4647701 2245385 2245385 plaintiff Smert William   756979 756979 Smert, William, of Rameseye 0
4678608 2258915 2258915 defendant Paynot Gilbert   756979 756979 Paynot, Gilbert, of Rameseye farmer 1
4678610 2258915 2258915 defendant Wrught Thomas carpenter 756979 756979 Wrught, Thomas, of Rameseye, carpenter 3
4864983 2316025 2316025 plaintiff Fygeon John   756979 756979 Fygeon, John, of Rameseye 0
4914951 2331183 2331183 plaintiff Draper John   756979 756979 Draper, John, of Rameseye 1
4914953 2331183 2331183 defendant Draper John   756979 756979 Draper, John, of Rameseye 1
4929400 2335613 2335613 defendant Faunt William yeoman 756979 756979 Faunt, William, of Rameseye, yeoman 0
4967626 2347258 2347258 defendant Neweman John husbandman 756979 756979 Neweman, John, of Rameseye, husbandman 2
5004784 2358299 2358299 defendant Faunt William yeoman 756979 756979 Faunt, William, of Rameseye, yeoman 0
5006281 2358734 2358734 plaintiff Cheker John   756979 756979 Cheker, John, of Rameseye 1
5025686 2364417 2364417 plaintiff Keteryng John, junior   756979 756979 Keteryng, John, junior, of Rameseye 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);