names

38 rows where place_id = 632524

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3807079 1960107 1960107 defendant Clerk Clement husbandman 632524 632524 Clerk, Clement, of Northorp, husbandman 1
3807080 1960107 1960107 defendant Smyth Thomas husbandman 632524 632524 Smyth, Thomas, of Northorp, husbandman 2
3807081 1960107 1960107 defendant Fermere William husbandman 632524 632524 Fermere, William, of Northorp, husbandman 3
3807082 1960107 1960107 defendant Bett Richard husbandman 632524 632524 Bett, Richard, of Northorp, husbandman 4
3824627 1965578 1965578 defendant Clarke Clement husbandman 632524 632524 Clarke, Clement, of Northorp, husbandman 1
3824628 1965578 1965578 defendant Smyth Thomas husbandman 632524 632524 Smyth, Thomas, of Northorp, husbandman 2
3824629 1965578 1965578 defendant Feremere William husbandman 632524 632524 Feremere, William, of Northorp, husbandman 3
3824630 1965578 1965578 defendant Bett Richard husbandman 632524 632524 Bett, Richard, of Northorp, husbandman 4
3824683 1965594 1965594 defendant Newell Richard husbandman 632524 632524 Newell, Richard, of Northorp, husbandman 1
3824790 1965629 1965629 defendant Newell Richard husbandman 632524 632524 Newell, Richard, of Northorp, husbandman 1
4441693 2182342 2182342 defendant Takel Richard   632524 632524 Takel, Richard, of Northorp 0
4516799 2205661 2205661 defendant Burdon Alan weaver 632524 632524 Burdon, Alan, of Northorp, weaver 0
4563517 2220164 2220164 defendant Williamson John   632524 632524 Williamson, John, of Northorp 1
4580832 2225487 2225487 plaintiff Diconson William   632524 632524 Diconson, William, of Northorp 0
4581129 2225581 2225581 defendant Alens Henry   632524 632524 Alens, Henry, of Northorp 4
4581130 2225581 2225581 defendant Yole William   632524 632524 Yole, William, of Northorp 5
4592041 2228865 2228865 defendant Tyryngton John de   632524 632524 Tyryngton, John de, of Northorp, administrators of 0
4592043 2228865 2228865 defendant Tyryngton Thomas   632524 632524 Tyryngton, Thomas, of Northorp 2
4592045 2228866 2228866 defendant Tyryngton John de   632524 632524 Tyryngton, John de, of Northorp, administrators of 0
4592047 2228866 2228866 defendant Tyryngton Thomas   632524 632524 Tyryngton, Thomas, of Northorp 2
4657251 2248154 2248154 defendant Knyght John husbandman 632524 632524 Knyght, John, of Northorp, husbandman 0
4678666 2258933 2258933 defendant Doughty John husbandman 632524 632524 Doughty, John, of Northorp, husbandman 0
4739450 2277422 2277422 defendant Shadd William husbandman 632524 632524 Shadd, William, of Northorp, husbandman 1
4754350 2281740 2281740 defendant Northorp George   632524 632524 Northorp, George, of Northorp, franklin 2
4802766 2297051 2297051 defendant Bocher John butcher 632524 632524 Bocher, John, of Northorp, butcher 0
4823889 2303552 2303552 defendant Bardan John shoemaker 632524 632524 Bardan, John, of Northorp, shoemaker 0
4834080 2306666 2306666 defendant Havecrof Adam laborer 632524 632524 Havecrof, Adam, of Northorp, laborer 1
4861042 2314812 2314812 defendant Theker Adam husbandman 632524 632524 Theker, Adam, of Northorp, husbandman 3
4873448 2318655 2318655 plaintiff Perteney Richard chaplain 632524 632524 Perteney, Richard, of Northorp, chaplain 0
4882332 2321385 2321385 defendant Barden John yeoman 632524 632524 Barden, John, of Northorp, yeoman 1
4891692 2324144 2324144 defendant Barden John yeoman 632524 632524 Barden, John, of Northorp, yeoman 1
5015616 2361448 2361448 defendant Barden John husbandman 632524 632524 Barden, John, of Northorp, husbandman 1
5309265 2447808 2447808 defendant Bryan Robert yeoman 632524 632524 Bryan, Robert, of Northorp, yeoman 0
5309266 2447808 2447808 defendant Chaumbre John yeoman 632524 632524 Chaumbre, John, of Northorp, yeoman 1
5336164 2455897 2455897 defendant Stokes Robert husbandman 632524 632524 Stokes, Robert, of Northorp, husbandman 2
5506136 2506837 2506837 defendant Johnson Robert husbandman 632524 632524 Johnson, Robert, of Northorp, husbandman 0
5537270 2516144 2516144 defendant Bryan John yeoman 632524 632524 Bryan, John, of Northorp, yeoman 0
5537271 2516144 2516144 defendant Clarke John husbandman 632524 632524 Clarke, John, of Northorp, husbandman 1

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