names

31 rows where place_id = 615221

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3707755 1928723 1928723 defendant Lete John smith 615221 615221 Lete, John, of Bernewell, smith 0
4424065 2172379 2172379 defendant Sonde Ralph le   615221 615221 Sonde, Ralph le, of Bernewell 1
4437930 2181183 2181183 defendant Smyth Hugh   615221 615221 Smyth, Hugh, of Bernewell 0
4445092 2183438 2183438 plaintiff Cotes Margery   615221 615221 Cotes, Margery, of Bernewell 0
4500124 2200680 2200680 defendant Bocher Reginald   615221 615221 Bocher, Reginald, of Bernewell 0
4515140 2205150 2205150 plaintiff Charwelton Simon de   615221 615221 Charwelton, Simon de, of Bernewell, parson of St Andrew's church 0
4530732 2209904 2209904 defendant Sandes Thomas   615221 615221 Sandes, Thomas, of Bernewell, son of Ralph 0
4532427 2210408 2210408 plaintiff Price John   615221 615221 Price, John, of Bernewell 0
4548388 2215434 2215434 plaintiff Child Walter   615221 615221 Child, Walter, of Bernewell, parson of All Saints church 0
4548390 2215435 2215435 plaintiff Child Walter   615221 615221 Child, Walter, of Bernewell, parson of All Saints church 0
4562721 2219896 2219896 plaintiff Price John   615221 615221 Price, John, of Bernewell 0
4590853 2228489 2228489 plaintiff May Joan widow 615221 615221 May, Joan, of Bernewell, widow 0
4672056 2256909 2256909 defendant Say Richard laborer 615221 615221 Say, Richard, of Bernewell, laborer 0
4695878 2264195 2264195 plaintiff Burton John   615221 615221 Burton, John, of Bernewell 0
4749553 2280350 2280350 defendant Smyth Richard smith 615221 615221 Smyth, Richard, of Bernewell, smith 3
4766024 2285365 2285365 defendant Yate John husbandman 615221 615221 Yate, John, of Bernewell, husbandman 1
4790394 2293080 2293080 defendant Yate John husbandman 615221 615221 Yate, John, of Bernewell, husbandman 1
4838629 2308009 2308009 plaintiff Radburne Walter   615221 615221 Radburne, Walter, of Bernewell 1
4842498 2309188 2309188 defendant Fyldyng Reginald yeoman 615221 615221 Fyldyng, Reginald, of Bernewell, yeoman 0
4852328 2312149 2312149 defendant Fyldyng Reginald husbandman 615221 615221 Fyldyng, Reginald, of Bernewell, husbandman 0
4864020 2315722 2315722 defendant Fyldyng Reginald yeoman 615221 615221 Fyldyng, Reginald, of Bernewell, yeoman 0
4880304 2320747 2320747 defendant Fyldyng Reginald husbandman 615221 615221 Fyldyng, Reginald, of Bernewell, husbandman 0
4901970 2327219 2327219 defendant Hunne William husbandman 615221 615221 Hunne, William, of Bernewell, husbandman 1
4928916 2335467 2335467 defendant Gydon William, junior husbandman 615221 615221 Gydon, William, junior, of Bernewell, husbandman 1
4939464 2338725 2338725 defendant Poket Robert husbandman 615221 615221 Poket, Robert, of Bernewell, husbandman 2
4976302 2349867 2349867 defendant Medburne William husbandman 615221 615221 Medburne, William, of Bernewell, husbandman 0
5018565 2362312 2362312 defendant Poket Richard husbandman 615221 615221 Poket, Richard, of Bernewell, husbandman 0
5057857 2373920 2373920 defendant Trumpyngton John husbandman 615221 615221 Trumpyngton, John, of Bernewell, husbandman 0
5288912 2441762 2441762 defendant Messenger John husbandman 615221 615221 Messenger, John, of Bernewell, husbandman 1
5425202 2482505 2482505 defendant Odam William yeoman 615221 615221 Odam, William, of Bernewell, yeoman 1
5619994 2550112 2550112 defendant Maisterman Richard   615221 615221 Maisterman, Richard, of Bernewell 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);