names

28 rows where place_id = 740988

✎ 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
4343113 2144863 2144863 defendant Lucas John husbandman 740988 740988 Lucas, John, of Dorking, husbandman 1
4401528 2165107 2165107 defendant Neale Robert yeoman 740988 740988 Neale, Robert, of Dorking, yeoman 0
4401529 2165107 2165107 defendant Sheffeld Robert yeoman 740988 740988 Sheffeld, Robert, of Dorking, yeoman 1
4667227 2255482 2255482 defendant atte Lake Walter laborer 740988 740988 atte Lake, Walter, of Dorking, laborer 0
4696247 2264312 2264312 defendant Chamberlayn Robert hostler 740988 740988 Chamberlayn, Robert, of Dorking, hostler 0
4696251 2264312 2264312 defendant mulsey John laborer 740988 740988 mulsey, John, of Dorking, laborer 4
4715609 2270208 2270208 defendant Chaper John yeoman 740988 740988 Chaper, John, of Dorking, yeoman 0
4755191 2282011 2282011 defendant Lithiare John fletcher 740988 740988 Lithiare, John, of Dorking, fletcher 0
4840783 2308655 2308655 defendant Skete Richard warrener 740988 740988 Skete, Richard, of Dorking, warrener 0
4850074 2311483 2311483 defendant Tymberden Richard husbandman 740988 740988 Tymberden, Richard, of Dorking, husbandman 0
4850075 2311483 2311483 defendant Bocher Thomas butcher 740988 740988 Bocher, Thomas, of Dorking, butcher 1
4851725 2311975 2311975 defendant Tannere John husbandman 740988 740988 Tannere, John, of Dorking, husbandman 0
4851726 2311975 2311975 defendant Tannere William husbandman 740988 740988 Tannere, William, of Dorking, husbandman 1
4852886 2312323 2312323 defendant Bole William tailor 740988 740988 Bole, William, of Dorking, tailor 0
4997681 2356162 2356162 defendant Constable John   740988 740988 Constable, John, of Dorking, hoop maker 1
4997682 2356162 2356162 defendant Steone John husbandman 740988 740988 Steone, John, of Dorking, husbandman 2
4997683 2356162 2356162 defendant Chaper Thomas husbandman 740988 740988 Chaper, Thomas, of Dorking, husbandman 3
5047274 2370807 2370807 defendant Godynowe William chapman 740988 740988 Godynowe, William, of Dorking, chapman 1
5150221 2401199 2401199 defendant Carpenter Henry yeoman 740988 740988 Carpenter, Henry, of Dorking, yeoman 0
5185110 2411387 2411387 defendant Carpenter Henry yeoman 740988 740988 Carpenter, Henry, of Dorking, yeoman 0
5196350 2414683 2414683 defendant Stapeler Richard husbandman 740988 740988 Stapeler, Richard, of Dorking, husbandman 0
5196351 2414683 2414683 defendant Brokate Richard husbandman 740988 740988 Brokate, Richard, of Dorking, husbandman 1
5196353 2414684 2414684 defendant Stapeler Richard husbandman 740988 740988 Stapeler, Richard, of Dorking, husbandman 0
5196354 2414684 2414684 defendant Brokette Richard husbandman 740988 740988 Brokette, Richard, of Dorking, husbandman 1
5204653 2417105 2417105 defendant Carpenter Henry yeoman 740988 740988 Carpenter, Henry, of Dorking, yeoman 0
5209613 2418551 2418551 defendant Stapeler Richard husbandman 740988 740988 Stapeler, Richard, of Dorking, husbandman 0
5209614 2418551 2418551 defendant Brokette Richard husbandman 740988 740988 Brokette, Richard, of Dorking, husbandman 1
5273007 2437180 2437180 defendant Goldryng John yeoman 740988 740988 Goldryng, John, of Dorking, yeoman 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);