names

23 rows where place_id = 709573

✎ 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
4179052 2088145 2088145 defendant Wright Thomas husbandman 709573 709573 Wright, Thomas, of North Froddingham, husbandman 0
4189327 2091762 2091762 defendant Wright Thomas husbandman 709573 709573 Wright, Thomas, of North Froddingham, husbandman 1
4249274 2112739 2112739 defendant Walker John husbandman 709573 709573 Walker, John, of North Froddingham, husbandman 1
4249275 2112739 2112739 defendant Wrighte Abraham yeoman 709573 709573 Wrighte, Abraham, of North Froddingham, yeoman 2
4257548 2115501 2115501 defendant Wilson Charles clerk 709573 709573 Wilson, Charles, of North Froddingham, clerk 0
4257549 2115501 2115501 defendant Hoope Richard yeoman 709573 709573 Hoope, Richard, of North Froddingham, yeoman 1
4257550 2115501 2115501 defendant Walker John yeoman 709573 709573 Walker, John, of North Froddingham, yeoman 2
4257551 2115501 2115501 defendant Wrighte Abraham yeoman 709573 709573 Wrighte, Abraham, of North Froddingham, yeoman 3
4279192 2122655 2122655 defendant Kedd William yeoman 709573 709573 Kedd, William, of North Froddingham, yeoman 0
4279193 2122655 2122655 defendant Kedd John yeoman 709573 709573 Kedd, John, of North Froddingham, yeoman 1
4316630 2135936 2135936 defendant Thornton John yeoman 709573 709573 Thornton, John, of North Froddingham, yeoman 0
4316631 2135936 2135936 defendant Forman William laborer 709573 709573 Forman, William, of North Froddingham, laborer 1
4335438 2142124 2142124 defendant Parkinson Robert yeoman 709573 709573 Parkinson, Robert, of North Froddingham, yeoman 0
4335440 2142125 2142125 defendant Kydd William yeoman 709573 709573 Kydd, William, of North Froddingham, yeoman 0
4335441 2142125 2142125 defendant Usher Robert yeoman 709573 709573 Usher, Robert, of North Froddingham, yeoman 1
4335442 2142125 2142125 defendant Walker John, junior yeoman 709573 709573 Walker, John, junior, of North Froddingham, yeoman 2
4335443 2142125 2142125 defendant Thompson John yeoman 709573 709573 Thompson, John, of North Froddingham, yeoman 3
4336866 2142621 2142621 defendant Leake Richard husbandman 709573 709573 Leake, Richard, of North Froddingham, husbandman 0
4397176 2163629 2163629 defendant Kidd William husbandman 709573 709573 Kidd, William, of North Froddingham, husbandman 0
4402643 2165469 2165469 defendant Forman William yeoman 709573 709573 Forman, William, of North Froddingham, yeoman 0
4402644 2165469 2165469 defendant Clothinge Robert yeoman 709573 709573 Clothinge, Robert, of North Froddingham, yeoman 1
4402647 2165470 2165470 defendant Kydd Margaret spinster 709573 709573 Kydd, Margaret, of North Froddingham, spinster 1
4402649 2165471 2165471 defendant Cockerell John husbandman 709573 709573 Cockerell, John, of North Froddingham, 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);