names

13 rows where place_id = 631943

✎ 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
3803689 1959069 1959069 defendant Dobbe William husbandman 631943 631943 Dobbe, William, of Pyllesley, husbandman 2
4194685 2093699 2093699 defendant Calowe Francis yeoman 631943 631943 Calowe, Francis, of Pyllesley, or of Sutton le Dale, yeoman 2
4391149 2161658 2161658 defendant Lynham John husbandman 631943 631943 Lynham, John, of Pyllesley, husbandman 0
4391153 2161659 2161659 defendant Lynham John husbandman 631943 631943 together with Lynham, John, of Pyllesley, husbandman 2
4391155 2161660 2161660 defendant Lynham John husbandman 631943 631943 Lynham, John, of Pyllesley, husbandman 0
5241217 2427635 2427635 defendant Heywarde Richard laborer 631943 631943 Heywarde, Richard, of Pyllesley, laborer 7
5241218 2427635 2427635 defendant Heywarde Henry laborer 631943 631943 Heywarde, Henry, of Pyllesley, laborer 8
5241219 2427635 2427635 defendant Sclater James husbandman 631943 631943 Sclater, James, of Pyllesley, husbandman 9
5241220 2427635 2427635 defendant Merpull John husbandman 631943 631943 Merpull, John, of Pyllesley, husbandman 10
5321065 2451395 2451395 defendant Hayward Joan widow 631943 631943 Hayward, Joan, of Pyllesley, widow 0
5325083 2452584 2452584 defendant Sclater James husbandman 631943 631943 Sclater, James, of Pyllesley, husbandman 2
5560893 2523159 2523159 defendant Penyston John husbandman 631943 631943 Penyston, John, of Pyllesley, husbandman 2
5579382 2528631 2528631 defendant Roulland Thomas husbandman 631943 631943 Roulland, Thomas, of Pyllesley, husbandman 2

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