names

40 rows where place_id = 605275

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3660992 1913711 1913711 defendant Payn John husbandman 605275 605275 Payn, John, of Thuxton, husbandman 0
3667008 1915625 1915625 defendant Sparke Robert husbandman 605275 605275 Sparke, Robert, of Thuxton, husbandman 1
3717540 1931775 1931775 defendant Leveryche John husbandman 605275 605275 Leveryche, John, of Thuxton, husbandman 0
3769295 1948050 1948050 defendant Leverych John husbandman 605275 605275 Leverych, John, of Thuxton, husbandman 2
3815573 1962788 1962788 defendant Sawton Richard husbandman 605275 605275 Sawton, Richard, of Thuxton, husbandman 0
3903507 1991400 1991400 defendant Dowsyng Simon sawyer 605275 605275 Dowsyng, Simon, of Thuxton, sawyer 4
3964851 2012316 2012316 defendant Futter Richard gent 605275 605275 Futter, Richard, of Thuxton, gent 1
3972331 2014892 2014892 plaintiff Futter John, senior gent 605275 605275 Futter, John, senior, of Thuxton, gent 0
3972333 2014893 2014893 plaintiff Futter John, senior gent 605275 605275 Futter, John, senior, of Thuxton, gent 0
3994137 2022652 2022652 defendant Futter John, senior gent 605275 605275 Futter, John, senior, of Thuxton, gent 0
3994139 2022653 2022653 defendant Futter John, senior gent 605275 605275 Futter, John, senior, of Thuxton, gent 0
4042524 2039794 2039794 plaintiff Pagrave Gregory gent 605275 605275 Pagrave, Gregory, of Thuxton, gent 1
4104550 2061908 2061908 defendant Wyseman John tailor 605275 605275 Wyseman, John, of Thuxton, tailor 0
4145100 2076446 2076446 defendant Joyse Edmund   605275 605275 Joyse, Edmund, of Thuxton, "bowler" 1
4172178 2085730 2085730 defendant Joyce or Josse Edmund, junior singleman 605275 605275 Joyce or Josse, Edmund, junior, of Thuxton, husbandman, singleman 0
4172180 2085731 2085731 defendant Joyce or Josse Edmund, senior yeoman 605275 605275 Joyce or Josse, Edmund, senior, of Thuxton, yeoman 0
4179850 2088427 2088427 defendant Futter John gent 605275 605275 Futter, John, of Thuxton, gent 1
4208293 2098448 2098448 defendant Holmes Christopher husbandman 605275 605275 Holmes, Christopher, of Thuxton, husbandman 3
4208298 2098449 2098449 defendant Holmes Christopher husbandman 605275 605275 Holmes, Christopher, of Thuxton, husbandman 3
4261930 2116941 2116941 defendant Futter John gent 605275 605275 Futter, John, of Thuxton, gent 0
4265001 2117929 2117929 defendant Futter John gent 605275 605275 Futter, John, of Thuxton, gent 0
4743060 2278489 2278489 defendant Estgate Richard husbandman 605275 605275 Estgate, Richard, of Thuxton, husbandman 0
4773043 2287540 2287540 defendant Rory Hugh chaplain 605275 605275 Rory, Hugh, of Thuxton, chaplain 0
4791714 2293504 2293504 defendant Estgate Richard husbandman 605275 605275 Estgate, Richard, of Thuxton, husbandman 2
4888394 2323170 2323170 defendant Peyntour John laborer 605275 605275 Peyntour, John, of Thuxton, laborer 1
4929517 2335646 2335646 defendant Deynes Thomas laborer 605275 605275 Deynes, Thomas, of Thuxton, laborer 1
4950316 2342064 2342064 defendant Dekeman John yeoman 605275 605275 Dekeman, John, of Thuxton, yeoman 2
4955029 2343456 2343456 defendant Roslyn Henry laborer 605275 605275 Roslyn, Henry, of Thuxton, laborer 5
4972215 2348633 2348633 defendant Dykeman John yeoman 605275 605275 Dykeman, John, of Thuxton, yeoman 3
4982246 2351608 2351608 defendant Pecher John laborer 605275 605275 Pecher, John, of Thuxton, laborer 0
5141198 2398549 2398549 defendant Leverych Hugh husbandman 605275 605275 Leverych, Hugh, of Thuxton, husbandman 0
5141200 2398550 2398550 defendant Leverych Hugh husbandman 605275 605275 Leverych, Hugh, of Thuxton, husbandman 0
5176260 2408744 2408744 defendant Leverych Hugh husbandman 605275 605275 Leverych, Hugh, of Thuxton, husbandman 0
5188876 2412480 2412480 defendant Chapman John husbandman 605275 605275 Chapman, John, of Thuxton, husbandman 0
5203751 2416847 2416847 defendant Leveryche Hugh yeoman 605275 605275 Leveryche, Hugh, of Thuxton, yeoman 0
5203753 2416847 2416847 defendant atte Hyrne John husbandman 605275 605275 atte Hyrne, John, of Thuxton, husbandman 2
5360137 2463211 2463211 defendant Chapman Richard (legal representative) 605275 605275 Chapman, Richard, of Thuxton, yeoman, administrator of 2
5360138 2463211 2463211 defendant Chapman John husbandman 605275 605275 Chapman, John, of Thuxton, husbandman 3
5480624 2499167 2499167 defendant Hyrne or Hyrve Robert chaplain 605275 605275 Hyrne or Hyrve, Robert, of Thuxton, chaplain 20
5566346 2524749 2524749 defendant Sparke Robert husbandman 605275 605275 Sparke, Robert, of Thuxton, 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);