names

24 rows where place_id = 618970

✎ 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
3727389 1934840 1934840 defendant Puttenham John gent 618970 618970 Puttenham, John, of Penne, Bucks, gent 0
3981412 2018118 2018118 defendant Saunder William husbandman 618970 618970 Saunder, William, of Penne, Bucks, husbandman 1
4345885 2145823 2145823 defendant Putnam Richard gent 618970 618970 Putnam, Richard, of Penne, Bucks, gent 1
4356376 2149456 2149456 defendant Maxe Francis yeoman 618970 618970 Maxe, Francis, of Penne, Bucks, yeoman 0
4369693 2154217 2154217 defendant Putnam Richard gent 618970 618970 Putnam, Richard, of Penne, Bucks, gent 1
4438556 2181350 2181350 defendant Coliere Walter   618970 618970 Coliere, Walter, of Penne, Bucks, Wirgun, William, of Penne 0
4619735 2237160 2237160 defendant Quyte Richard   618970 618970 Quyte, Richard, of Penne, Bucks 0
4619738 2237161 2237161 defendant Qwyte Richard   618970 618970 Qwyte, Richard, of Penne, Bucks 0
4619739 2237161 2237161 defendant Noursse William   618970 618970 Noursse, William, of Penne, Bucks 1
4983256 2351897 2351897 defendant Culverhous Robert husbandman 618970 618970 Culverhous, Robert, of Penne, Bucks, husbandman 0
4983262 2351899 2351899 defendant Culverhous Robert husbandman 618970 618970 Culverhous, Robert, of Penne, Bucks, husbandman 0
5096935 2385534 2385534 defendant Puttenham Henry gent 618970 618970 Puttenham, Henry, of Penne, Bucks, gent 3
5096940 2385535 2385535 defendant Puttenham Henry gent 618970 618970 Puttenham, Henry, of Penne, Bucks, gent 3
5136941 2397321 2397321 defendant Culverhouse Richard smith 618970 618970 Culverhouse, Richard, of Penne, bucks, smith 0
5217583 2420882 2420882 defendant Culverhous Richard smith 618970 618970 Culverhous, Richard, of Penne, Bucks, smith 3
5245348 2428797 2428797 defendant Puttenham Henry gent 618970 618970 Puttenham, Henry, of Penne, Bucks, gent 0
5257910 2432596 2432596 defendant Penne John gent 618970 618970 Penne, John, of Penne, Bucks, gent 2
5343344 2458108 2458108 defendant Penne John   618970 618970 Penne, John, of Penne, Bucks 0
5384094 2470540 2470540 defendant Everdone Roger   618970 618970 Everdone, Roger, of Penne, Bucks, gent & of the Hospice of Thomas, Archbishop of York, Chancellor of England 0
5395912 2473917 2473917 defendant Everdon Roger   618970 618970 Everdon, Roger, of Penne, Bucks, gent & of the Hospice of the Venerable Thomas, archbishop of York 0
5395914 2473918 2473918 defendant Guerdon Roger gent & of the Hospice of the Venerable in Christ Thomas Archbishop of Canterbury 618970 618970 Guerdon, Roger, of Penne, Bucks, gent & of the Hospice of the Venerable in Christ Thomas Archbishop of Canterbury 0
5472246 2496664 2496664 defendant Penne John gent 618970 618970 Penne, John, of Penne, Bucks, gent 0
5483636 2500056 2500056 defendant Penne John gent 618970 618970 Penne, John, of Penne, Bucks, gent 0
5511371 2508402 2508402 defendant Penne John gent 618970 618970 Penne, John, of Penne, Bucks, gent 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);