names

18 rows where place_id = 657888

✎ 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
3946193 2005746 2005746 defendant Hadlowe William laborer 657888 657888 Hadlowe, William, of Merdon, laborer 1
3957966 2009849 2009849 defendant Weldysshe Thomas gent 657888 657888 Weldysshe, Thomas, of Merdon, gent 0
4604185 2232478 2232478 defendant Lange John   657888 657888 Lange, John, of Merdon 0
4686648 2261435 2261435 defendant Knyth John smith 657888 657888 Knyth, John, of Merdon, smith 0
4960542 2345120 2345120 defendant Burford John husbandman 657888 657888 Burford, John, of Merdon, husbandman 2
4988487 2353518 2353518 defendant Woderove Robert husbandman 657888 657888 Woderove, Robert, of Merdon, husbandman 2
5003644 2357957 2357957 defendant Ippyngbery John husbandman 657888 657888 Ippyngbery, John, of Merdon, husbandman 0
5087682 2382784 2382784 defendant Ippyngbury Thomas husbandman 657888 657888 Ippyngbury, Thomas, of Merdon, husbandman 2
5144649 2399593 2399593 defendant Bygyspych Nicholas yeoman 657888 657888 Bygyspych, Nicholas, of Merdon, yeoman 0
5365536 2464895 2464895 plaintiff Bixspich William   657888 657888 Bixspich, William, of Merdon 0
5383711 2470425 2470425 defendant Roltclyf William husbandman 657888 657888 Roltclyf, William, of Merdon, husbandman 1
5422134 2481565 2481565 plaintiff atte Hyrst William   657888 657888 atte Hyrst, William, of Merdon 0
5422135 2481565 2481565 defendant Aston Thomas yeoman 657888 657888 Aston, Thomas, of Merdon, yeoman 0
5422136 2481565 2481565 defendant Ocle George yeoman 657888 657888 Ocle, George, of Merdon, yeoman 1
5424717 2482352 2482352 plaintiff Byschyche William   657888 657888 Byschyche, William, of Merdon 0
5431322 2484318 2484318 defendant Cornhill Stephen husbandman 657888 657888 Cornhill, Stephen, of Merdon, husbandman 0
5454291 2491193 2491193 defendant Aston Thomas husbandman 657888 657888 Aston, Thomas, of Merdon, husbandman 4
5466167 2494822 2494822 defendant Aston Thomas husbandman 657888 657888 Aston, Thomas, of Merdon, husbandman 3

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