names

20 rows where place_id = 602179

✎ 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
3648796 1910014 1910014 defendant Hall Robert husbandman 602179 602179 Hall, Robert, of Lytlyngton, Cams, husbandman 1
3676345 1918645 1918645 defendant Adcok Edward husbandman 602179 602179 Adcok, Edward, of Lytlyngton, Cams, husbandman 0
3676351 1918647 1918647 defendant Adcok Edward husbandman 602179 602179 Adcok, Edward, of Lytlyngton, Cams, husbandman 0
3717814 1931874 1931874 defendant Dryver William husbandman 602179 602179 Dryver, William, of Lytlyngton, Cams, husbandman 4
3739113 1938441 1938441 defendant Bownes John husbandman 602179 602179 Bownes, John, of Lytlyngton, Cams, husbandman 0
3887108 1985952 1985952 defendant Bolnest John husbandman 602179 602179 Bolnest, John, of Lytlyngton, Cams, husbandman 0
4172776 2085937 2085937 defendant Raynews William yeoman 602179 602179 Raynews, William, of Lytlyngton, Cams, yeoman 1
4661169 2249319 2249319 defendant Plattyng Thomas husbandman 602179 602179 Plattyng, Thomas, of Lytlyngton, Cams, husbandman 0
4661171 2249320 2249320 defendant Plattyng Thomas husbandman 602179 602179 Plattyng, Thomas, of Lytlyngton, Cams, husbandman 0
4882294 2321372 2321372 defendant Pynke John husbandman 602179 602179 Pynke, John, of Lytlyngton, Cams, husbandman 0
5321083 2451400 2451400 defendant Pynke John yeoman 602179 602179 Pynke, John, of Lytlyngton, Cams, yeoman 2
5530758 2514137 2514137 defendant Tufenall John yeoman 602179 602179 Tufenall, John, of Lytlyngton, Cams, yeoman 0
5533772 2515110 2515110 defendant Tadlowe Thomas yeoman 602179 602179 Tadlowe, Thomas, of Lytlyngton, Cams, yeoman 0
5557112 2522036 2522036 defendant Blyghton Thomas husbandman 602179 602179 Blyghton, Thomas, of Lytlyngton, Cams, husbandman 7
5560371 2522997 2522997 defendant Corse Edward husbandman 602179 602179 Corse, Edward, of Lytlyngton, Cams, husbandman 0
5562350 2523588 2523588 defendant Tuffenale Thomas husbandman 602179 602179 Tuffenale, Thomas, of Lytlyngton, Cams, husbandman 2
5562705 2523682 2523682 defendant Blyghton Thomas husbandman 602179 602179 Blyghton, Thomas, of Lytlyngton, Cams, husbandman 2
5562706 2523682 2523682 defendant Tuffenale Thomas husbandman 602179 602179 Tuffenale, Thomas, of Lytlyngton, Cams, husbandman 3
5576929 2527828 2527828 defendant Medowes William yeoman 602179 602179 Medowes, William, of Lytlyngton, Cams, yeoman 1
5583767 2529997 2529997 defendant Corse Edward husbandman 602179 602179 Corse, Edward, of Lytlyngton, Cams, 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);