names

16 rows where place_id = 611816

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3690192 1923090 1923090 plaintiff Gallawey John   611816 611816 Gallawey, John, of Mose 0
4067059 2048517 2048517 plaintiff Hunte James husbandman 611816 611816 Hunte, James, of Mose, husbandman 0
4131112 2071446 2071446 defendant Hunt James husbandman 611816 611816 Hunt, James, of Mose, husbandman 0
4173048 2086029 2086029 defendant Wade John yeoman 611816 611816 Wade, John, of Mose, yeoman 0
4177940 2087757 2087757 defendant Wheler William husbandman 611816 611816 Wheler, William, of Mose, or of Holland Magna, husbandman 0
4188290 2091407 2091407 defendant Warde Thomas husbandman 611816 611816 Warde, Thomas, of Mose, husbandman 0
4687113 2261573 2261573 defendant Estasse Robert yeoman 611816 611816 Estasse, Robert, of Mose, yeoman 0
4748713 2280108 2280108 plaintiff Merssh Thomas   611816 611816 Merssh, Thomas, of Mose 0
4813281 2300268 2300268 defendant Outlawe William   611816 611816 Outlawe, William, of Mose 0
4864271 2315802 2315802 defendant Eustace Robert husbandman 611816 611816 Eustace, Robert, of Mose, husbandman 0
5131739 2395767 2395767 defendant Keye Thomas husbandman 611816 611816 Keye, Thomas, of Mose, husbandman 1
5131740 2395767 2395767 defendant Lerkyn Thomas husbandman 611816 611816 Lerkyn, Thomas, of Mose, husbandman 2
5151282 2401522 2401522 defendant Leye Thomas husbandman 611816 611816 Leye, Thomas, of Mose, husbandman 1
5299342 2444781 2444781 defendant Amslet John carpenter 611816 611816 Amslet, John, of Mose, carpenter 1
5302239 2445632 2445632 plaintiff Elyot John   611816 611816 Elyot, John, of Mose 0
5302240 2445632 2445632 defendant Awnslet John carpenter 611816 611816 Awnslet, John, of Mose, carpenter 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);