names

17 rows where place_id = 611765

✎ 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
3689956 1923018 1923018 defendant Lodyngton John husbandman 611765 611765 Lodyngton, John, of Haylweston, husbandman 1
3689957 1923018 1923018 defendant Markham John husbandman 611765 611765 Markham, John, of Haylweston, husbandman 2
4686828 2261492 2261492 defendant Wake William husbandman 611765 611765 Wake, William, of Haylweston, husbandman 1
4760753 2283703 2283703 defendant Symmes Thomas husbandman 611765 611765 Symmes, Thomas, of Haylweston, husbandman 4
4828375 2304917 2304917 defendant Hamyle John husbandman 611765 611765 Hamyle, John, of Haylweston, husbandman 1
5101210 2386763 2386763 defendant Smyth Thomas smith 611765 611765 Smyth, Thomas, of Haylweston, smith 0
5158151 2403502 2403502 defendant Hamelden John husbandman 611765 611765 Hamelden, John, of Haylweston, husbandman 2
5158153 2403502 2403502 defendant Bosworth John husbandman 611765 611765 Bosworth, John, of Haylweston, husbandman 4
5173820 2408040 2408040 defendant Hamelden John husbandman 611765 611765 Hamelden, John, of Haylweston, husbandman 2
5173821 2408040 2408040 defendant Maryot John husbandman 611765 611765 Maryot, John, of Haylweston, husbandman 3
5173822 2408040 2408040 defendant Boseworth John husbandman 611765 611765 Boseworth, John, of Haylweston, husbandman 4
5193947 2413960 2413960 defendant Hamelden John husbandman 611765 611765 Hamelden, John, of Haylweston, husbandman 2
5193948 2413960 2413960 defendant Maryot John husbandman 611765 611765 Maryot, John, of Haylweston, husbandman 3
5193949 2413960 2413960 defendant Boseworth John husbandman 611765 611765 Boseworth, John, of Haylweston, husbandman 4
5297745 2444346 2444346 defendant Braas Elizabeth widow 611765 611765 Braas, Elizabeth, of Haylweston, widow 5
5297746 2444346 2444346 defendant Lyndesey William husbandman 611765 611765 Lyndesey, William, of Haylweston, husbandman 6
5312099 2448650 2448650 defendant Dalton William husbandman 611765 611765 Dalton, William, of Haylweston, 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);