names

30 rows where place_id = 596100

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3623127 1874754 1874754 defendant Popehurn Thomas husbandman 596100 596100 Popehurn, Thomas, of Long Burton, husbandman 1
3695994 1924987 1924987 plaintiff Roode John husbandman 596100 596100 Roode, John, of Long Burton, husbandman 0
3695995 1924987 1924987 plaintiff Goolde John husbandman 596100 596100 Goolde, John, of Long Burton, husbandman 1
3707144 1928521 1928521 defendant Clerke John, senior husbandman 596100 596100 Clerke, John, senior, of Long Burton, husbandman 1
3932078 2001032 2001032 defendant Hyckes Henry butcher 596100 596100 Hyckes, Henry, of Long Burton, butcher 3
4013508 2029567 2029567 plaintiff Rowde or Roode Richard   596100 596100 Rowde or Roode, Richard, of Long Burton 0
4085451 2055073 2055073 defendant Payne Henry husbandman 596100 596100 Payne, Henry, of Long Burton, husbandman 0
4145654 2076632 2076632 defendant Grange Henry tailor 596100 596100 Grange, Henry, of Long Burton, tailor 0
4155440 2079992 2079992 defendant Rowde Richard yeoman 596100 596100 Rowde, Richard, of Long Burton, yeoman 1
4155441 2079992 2079992 defendant Fevyan alias Hoggard Richard yeoman 596100 596100 Fevyan alias Hoggard, Richard, of Long Burton, yeoman 2
4167589 2084160 2084160 defendant Vyvyan Richard yeoman 596100 596100 Vyvyan, Richard, of Long Burton, yeoman 0
4191126 2092461 2092461 defendant Vivian Richard yeoman 596100 596100 Vivian, Richard, of Long Burton, yeoman 0
4196916 2094473 2094473 defendant Vyvyan alias Hoggard Richard yeoman 596100 596100 together with Vyvyan alias Hoggard, Richard, of Long Burton, yeoman 1
4249094 2112681 2112681 defendant Payne John yeoman 596100 596100 Payne, John, of Long Burton, yeoman 1
4306937 2132567 2132567 defendant Patye William tanner 596100 596100 Patye, William, of Long Burton, tanner 0
4307897 2132903 2132903 defendant Tompson Alexander husbandman 596100 596100 Tompson, Alexander, of Long Burton, husbandman 0
4313914 2134970 2134970 defendant Martyn Thomas husbandman 596100 596100 Martyn, Thomas, of Long Burton, husbandman 0
4320996 2137439 2137439 defendant Granger John husbandman 596100 596100 Granger, John, of Long Burton, husbandman 0
4326564 2139245 2139245 defendant Symons Thomas smith 596100 596100 Symons, Thomas, of Long Burton, smith 3
4329165 2140066 2140066 defendant Graunge John yeoman 596100 596100 Graunge, John, of Long Burton, yeoman 1
4332127 2141045 2141045 defendant Paty John tanner 596100 596100 Paty, John, of Long Burton, tanner 0
4332128 2141045 2141045 defendant Graunger John yeoman 596100 596100 Graunger, John, of Long Burton, yeoman 1
4391000 2161609 2161609 defendant Patye John tanner 596100 596100 Patye, John, of Long Burton, tanner 0
5414458 2479261 2479261 defendant Dollyng John husbandman 596100 596100 Dollyng, John, of Long Burton, husbandman 4
5428559 2483466 2483466 defendant Vyd Robert yeoman 596100 596100 Vyd, Robert, of Long Burton, yeoman 0
5428560 2483466 2483466 defendant Locke Robert yeoman 596100 596100 Locke, Robert, of Long Burton, yeoman 1
5430259 2483987 2483987 defendant Dollyng John husbandman 596100 596100 Dollyng, John, of Long Burton, husbandman 3
5441044 2487231 2487231 defendant Vye Robert yeoman 596100 596100 Vye, Robert, of Long Burton, yeoman 0
5447065 2489010 2489010 defendant Dollyng John husbandman 596100 596100 Dollyng, John, of Long Burton, husbandman 3
5459507 2492755 2492755 defendant Dollyng John husbandman 596100 596100 Dollyng, John, of Long Burton, husbandman 3

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