names

38 rows where place_id = 598476

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3632668 1905032 1905032 defendant Holand Nicholas gent 598476 598476 Holand, Nicholas, of Were, gent 0
3663131 1914382 1914382 defendant Holand Nicholas esq 598476 598476 Holand, Nicholas, of Were, esq 0
3793085 1955696 1955696 plaintiff Smyth John   598476 598476 Smyth, John, of Were 1
4179207 2088203 2088203 defendant Hewyshe Peter butcher 598476 598476 Hewyshe, Peter, of Were, butcher 1
4202549 2096431 2096431 defendant Hewyshe Peter butcher 598476 598476 Hewyshe, Peter, of Were, butcher 1
4230917 2106313 2106313 defendant Addams Robert husbandman 598476 598476 Addams, Robert, of Were, husbandman 0
4244901 2111281 2111281 defendant Barnard Anthony husbandman 598476 598476 Barnard, Anthony, of Were, husbandman 0
4301091 2130495 2130495 defendant Fyppen George husbandman 598476 598476 Fyppen, George, of Were, husbandman 1
4305343 2132009 2132009 defendant Hewyshe Peter butcher 598476 598476 Hewyshe, Peter, of Were, butcher 0
4305743 2132147 2132147 defendant Evanes William yeoman 598476 598476 Evanes, William, of Were, yeoman 1
4360730 2151009 2151009 defendant Markes Richard husbandman 598476 598476 Markes, Richard, of Were, husbandman 2
4374728 2156017 2156017 defendant Barnarde Anthony husbandman 598476 598476 Barnarde, Anthony, of Were, husbandman 1
4396469 2163394 2163394 defendant Clement John husbandman 598476 598476 Clement, John, of Were, husbandman 0
4396470 2163394 2163394 defendant Robyns Thomas husbandman 598476 598476 Robyns, Thomas, of Were, husbandman 1
4448583 2184486 2184486 defendant Moton John   598476 598476 Moton, John, of Were 0
4465746 2189956 2189956 plaintiff Wylles Henry   598476 598476 Wylles, Henry, of Were 0
4465747 2189956 2189956 defendant Combe Nicholas   598476 598476 Combe, Nicholas, of Were 0
4476166 2193209 2193209 defendant Willes John   598476 598476 Willes, John, of Were 4
4545684 2214575 2214575 defendant Tremel Philip butcher 598476 598476 Tremel, Philip, of Were, butcher 0
4570877 2222458 2222458 defendant Tremell Philip   598476 598476 Tremell, Philip, of Were 1
4592721 2229065 2229065 defendant Lane John hosteller 598476 598476 Lane, John, of Were, hosteller 0
4604166 2232470 2232470 defendant Tremell Philip   598476 598476 Tremell, Philip, of Were 1
4635026 2241803 2241803 defendant Smyth Henry   598476 598476 Smyth, Henry, of Were 2
4693512 2263473 2263473 defendant Hardyng John husbandman 598476 598476 Hardyng, John, of Were, husbandman 1
4693513 2263473 2263473 defendant Cheper Thomas husbandman 598476 598476 Cheper, Thomas, of Were, husbandman 2
4750367 2280588 2280588 defendant Gorney Thomas (legal representative) 598476 598476 Gorney, Thomas, of Were, executors of 0
4941704 2339427 2339427 defendant Bythell Thomas husbandman 598476 598476 Bythell, Thomas, of Were, husbandman 2
5138846 2397863 2397863 defendant Salman John laborer 598476 598476 Salman, John, of Were Gyfford, junior, laborer 2
5259045 2432944 2432944 defendant Chapman Thomas chapman 598476 598476 Chapman, Thomas, of Were, chapman 1
5286241 2440985 2440985 defendant Chapman Thomas chapman 598476 598476 Chapman, Thomas, of Were, chapman 1
5428396 2483418 2483418 defendant Bedbere John ostler 598476 598476 Bedbere, John, of Were, ostler 0
5445760 2488619 2488619 defendant Bedbere John hosteller 598476 598476 Bedbere, John, of Were, hosteller 0
5479871 2498989 2498989 defendant Bedbere John ostler 598476 598476 Bedbere, John, of Were, ostler 7
5517009 2510151 2510151 defendant Waye Badum yeoman 598476 598476 Waye, Badum, of Were, yeoman 0
5557554 2522163 2522163 defendant Croser Thomas husbandman 598476 598476 Croser, Thomas, of Were, husbandman 2
5587528 2531114 2531114 defendant Taillour Ralph husbandman 598476 598476 Taillour, Ralph, of Were, husbandman 0
5589504 2531717 2531717 defendant Holand Nicholas esq 598476 598476 Holand, Nicholas, of Were, esq 0
5592337 2532590 2532590 defendant Taillour Ralph husbandman 598476 598476 Taillour, Ralph, of Were, husbandman 4

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