names

21 rows where place_id = 772731

✎ 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
4592475 2228998 2228998 defendant Cokshute Richard   772731 772731 Cokshute, Richard, of Bolne 9
4667205 2255474 2255474 defendant Smyth John laborer 772731 772731 Smyth, John, of Bolne, laborer 1
4692134 2263068 2263068 defendant Tylyon Richard laborer 772731 772731 Tylyon, Richard, of Bolne, laborer 4
4706027 2267257 2267257 defendant Bolne Walter   772731 772731 Bolne, Walter, of Bolne 1
4708171 2267933 2267933 defendant Gravele Walter husbandman 772731 772731 Gravele, Walter, of Bolne, husbandman 2
4829061 2305128 2305128 defendant Wotton Robert   772731 772731 Wotton, Robert, of Bolne, bailiff 2
4906569 2328640 2328640 defendant Cokfote Richard husbandman 772731 772731 Cokfote, Richard, of Bolne, husbandman 0
4908650 2329261 2329261 defendant Costedell Richard husbandman 772731 772731 Costedell, Richard, of Bolne, husbandman 0
4908651 2329261 2329261 defendant Coksshete Richard husbandman 772731 772731 Coksshete, Richard, of Bolne, husbandman 1
4920484 2332922 2332922 defendant Bolne Bartholomew gent 772731 772731 Bolne, Bartholomew, of Bolne, gent 0
4920496 2332925 2332925 defendant Bolne Bartholomew gent 772731 772731 Bolne, Bartholomew, of Bolne, gent 1
4963430 2345974 2345974 defendant Bolne John gent 772731 772731 Bolne, John, of Bolne, gent 0
5024471 2364070 2364070 plaintiff Homwode James, senior   772731 772731 Homwode, James, senior, of Bolne 0
5236625 2426296 2426296 defendant Smethe Robert husbandman 772731 772731 Smethe, Robert, of Bolne, husbandman 0
5270776 2436552 2436552 defendant Harpar John husbandman 772731 772731 Harpar, John, of Bolne, husbandman 0
5283560 2440245 2440245 defendant Harper John husbandman 772731 772731 Harper, John, of Bolne, husbandman 0
5302415 2445689 2445689 defendant Harper John husbandman 772731 772731 Harper, John, of Bolne, husbandman 0
5317233 2450235 2450235 defendant Harper John husbandman 772731 772731 Harper, John, of Bolne, husbandman 0
5334373 2455351 2455351 defendant Harper John husbandman 772731 772731 Harper, John, of Bolne, husbandman 0
5636838 2555463 2555463 defendant Cokshete Richard husbandman 772731 772731 Cokshete, Richard, of Bolne, husbandman 1
5636875 2555475 2555475 defendant Cokshete Richard husbandman 772731 772731 Cokshete, Richard, of Bolne, husbandman 1

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