names

32 rows where place_id = 589185

✎ 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
3596836 1866646 1866646 defendant Jeter Simon yeoman 589185 589185 Jeter, Simon, of Farnburgh, yeoman 0
3599957 1867641 1867641 defendant Dautre or Dantre William gent 589185 589185 Dautre or Dantre, William, of Farnburgh, gent 1
3892777 1987836 1987836 defendant Churcher Thomas husbandman 589185 589185 Churcher, Thomas, of Farnburgh, husbandman 0
3892778 1987836 1987836 defendant Churcher Robert yeoman 589185 589185 Churcher, Robert, of Farnburgh, yeoman 1
3990734 2021440 2021440 defendant Fulshurst George yeoman 589185 589185 Fulshurst, George, of Farnburgh, yeoman 0
3990736 2021441 2021441 defendant Fulsishurst alias Fulsis George yeoman 589185 589185 Fulsishurst alias Fulsis, George, of Farnburgh, yeoman 0
4559155 2218814 2218814 defendant Tweccheneye Thomas   589185 589185 Tweccheneye, Thomas, of Farnburgh 0
4595483 2229844 2229844 defendant Roggeres John   589185 589185 Roggeres, John, of Farnburgh 0
4595484 2229844 2229844 defendant Colnes Thomas   589185 589185 Colnes, Thomas, of Farnburgh 1
4658753 2248611 2248611 defendant Stake Thomas hosteler 589185 589185 Stake, Thomas, of Farnburgh, hosteler 0
4658754 2248611 2248611 defendant Grace John laborer 589185 589185 Grace, John, of Farnburgh, laborer 1
4658763 2248612 2248612 defendant Stake Thomas hosteler 589185 589185 together with, Stake, Thomas, of Farnburgh, hosteler 2
4658764 2248612 2248612 defendant Grace John laborer 589185 589185 Grace, John, of Farnburgh, laborer 3
4707869 2267831 2267831 defendant Cosyn William yeoman 589185 589185 Cosyn, William, of Farnburgh, yeoman 0
4774506 2288012 2288012 defendant Saundres John husbandman 589185 589185 Saundres, John, of Farnburgh, husbandman 0
4800202 2296239 2296239 defendant Saundres John husbandman 589185 589185 Saundres, John, of Farnburgh, husbandman 0
4949214 2341740 2341740 defendant Clerk Reginald husbandman 589185 589185 Clerk, Reginald, of Farnburgh, husbandman 1
4967640 2347262 2347262 defendant Broun Richard hosteler 589185 589185 Broun, Richard, of Farnburgh, hosteler 0
5046761 2370654 2370654 defendant brounflet Edward esq 589185 589185 brounflet, Edward, of Farnburgh, esq 0
5066557 2376521 2376521 defendant Brounflet Edward esq 589185 589185 Brounflet, Edward, of Farnburgh, esq 0
5097850 2385798 2385798 defendant Rykard Robert husbandman 589185 589185 Rykard, Robert, of Farnburgh, husbandman 2
5139580 2398059 2398059 defendant Gibbes William husbandman 589185 589185 Gibbes, William, of Farnburgh, husbandman 0
5139581 2398059 2398059 defendant Crosse Hugh husbandman 589185 589185 Crosse, Hugh, of Farnburgh, husbandman 1
5139586 2398059 2398059 defendant Bulle John husbandman 589185 589185 Bulle, John, of Farnburgh, husbandman 6
5139588 2398060 2398060 defendant Gibbes William husbandman 589185 589185 Gibbes, William, of Farnburgh, husbandman 0
5139589 2398060 2398060 defendant Crosse Hugh husbandman 589185 589185 Crosse, Hugh, of Farnburgh, husbandman 1
5334397 2455358 2455358 defendant Petle Richard husbandman 589185 589185 Petle, Richard, of Farnburgh, husbandman 1
5390517 2472350 2472350 defendant Payn Robert ostler 589185 589185 Payn, Robert, of Farnburgh, ostler 3
5403468 2476063 2476063 defendant Payn Robert ostler 589185 589185 Payn, Robert, of Farnburgh, ostler 3
5416533 2479862 2479862 defendant Payne Robert ostler 589185 589185 Payne, Robert, of Farnburgh, ostler 3
5532821 2514812 2514812 defendant Kyghley Agnes widow 589185 589185 Kyghley, Agnes, of Farnburgh, widow 3
5538859 2516640 2516640 defendant Bostowe Richard yeoman 589185 589185 Bostowe, Richard, of Farnburgh, yeoman 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);