names

15 rows where place_id = 658528

✎ 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
3948822 2006654 2006654 defendant Armyshed Lawrence butcher 658528 658528 Armyshed, Lawrence, of Downham Market, butcher 0
3967488 2013265 2013265 plaintiff Butteler Robert shoemaker 658528 658528 Butteler, Robert, of Downham Market, shoemaker 0
4124420 2069029 2069029 defendant Edward Walter cooper 658528 658528 Edward, Walter, of Downham Market, cooper 0
4205773 2097567 2097567 defendant Style Richard yeoman 658528 658528 Style, Richard, of Downham Market, yeoman 2
4273545 2120706 2120706 defendant Weston David saddler 658528 658528 Weston, David, of Downham Market, saddler 2
4713926 2269683 2269683 defendant Skekeby Robert yeoman 658528 658528 Skekeby, Robert, of Downham Market, yeoman 0
4713927 2269683 2269683 defendant Gedeneye John laborer 658528 658528 Gedeneye, John, of Downham Market, laborer 1
4834817 2306892 2306892 defendant Thomson Elwin weaver 658528 658528 Thomson, Elwin, of Downham Market, weaver 0
5282755 2440015 2440015 defendant Bocher John butcher 658528 658528 Bocher, John, of Downham Market, butcher 2
5414066 2479141 2479141 defendant Gauge Richard yeoman 658528 658528 Gauge, Richard, of Downham Market, yeoman 0
5419733 2480815 2480815 defendant Martyn William husbandman 658528 658528 Martyn, William, of Downham Market, husbandman 0
5429677 2483814 2483814 defendant Gauge Richard yeoman 658528 658528 Gauge, Richard, of Downham Market, yeoman 0
5429681 2483815 2483815 defendant Gauge Richard yeoman 658528 658528 Gauge, Richard, of Downham Market, yeoman 0
5429685 2483816 2483816 defendant Gauge Richard yeoman 658528 658528 Gauge, Richard, of Downham Market, yeoman 0
5475776 2497753 2497753 defendant Martyn William husbandman 658528 658528 Martyn, William, of Downham Market, 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);