names

20 rows where place_id = 588421

✎ 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
3594475 1865900 1865900 defendant Dowtefyre John yeoman 588421 588421 Dowtefyre, John, of Croyland, Lincs, yeoman 0
3811845 1961608 1961608 plaintiff Clerke William clerk 588421 588421 Clerke, William, of Croyland, Lincs, clerk 0
3811847 1961609 1961609 plaintiff Clerke William clerk 588421 588421 Clerke, William, of Croyland, Lincs, clerk 0
4179121 2088172 2088172 defendant Durrant John yeoman 588421 588421 Durrant, John, of Croyland, Lincs, yeoman 0
4721242 2271973 2271973 defendant Barboure Stephen barber 588421 588421 Barboure, Stephen, of Croyland, Lincs, barber 0
4769621 2286474 2286474 defendant Tebbe Richard fisherman 588421 588421 Tebbe, Richard, of Croyland, Lincs, fisherman 0
4769622 2286474 2286474 defendant Toche John fishmonger 588421 588421 Toche, John, of Croyland, Lincs, fishmonger 1
4769625 2286475 2286475 defendant Flaketter Roger husbandman 588421 588421 Flaketter, Roger, of Croyland, Lincs, husbandman 0
4842333 2309134 2309134 defendant Porter John husbandman 588421 588421 Porter, John, of Croyland, Lincs, husbandman 0
4873483 2318666 2318666 defendant Body William husbandman 588421 588421 Body, William, of Croyland, Lincs, husbandman 0
4873512 2318670 2318670 defendant Maddy John fisher 588421 588421 Maddy, John, of Croyland, Lincs, fisher 9
4873526 2318672 2318672 defendant Seman Richard husbandman 588421 588421 Seman, Richard, of Croyland, Lincs, husbandman 0
4873541 2318673 2318673 defendant Maddy John fisher 588421 588421 Maddy, John, of Croyland, Lincs, fisher 8
4928898 2335460 2335460 defendant Launder John tailor 588421 588421 Launder, John, of Croyland, Lincs, tailor 0
5000555 2357032 2357032 defendant Mason Richard fishmonger 588421 588421 Mason, Richard, of Croyland, Lincs, fishmonger 0
5092821 2384279 2384279 defendant Flaketer William husbandman 588421 588421 Flaketer, William, of Croyland, Lincs, husbandman 4
5132995 2396139 2396139 defendant Body John fisher 588421 588421 Body, John, of Croyland, Lincs, fisher 0
5168671 2406560 2406560 defendant Body John fishmonger 588421 588421 Body, John, of Croyland, Lincs, fishmonger 0
5251961 2430716 2430716 defendant Brode John husbandman 588421 588421 Brode, John, of Croyland, Lincs, husbandman 3
5251966 2430717 2430717 defendant Symson Henry baker 588421 588421 Symson, Henry, of Croyland, Lincs, baker 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);