names

49 rows where place_id = 642463

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3868134 1979578 1979578 defendant Wawde Thomas husbandman 642463 642463 Wawde, Thomas, of North Duffeld, husbandman 3
4429585 2174045 2174045 plaintiff Ward William   642463 642463 Ward, William, of North Duffeld 0
4462748 2189048 2189048 defendant Sappe Adam   642463 642463 Sappe, Adam, of North duffeld 6
4469199 2191035 2191035 defendant Barker John   642463 642463 Barker, John, of North duffeld 0
4469200 2191035 2191035 defendant Lyly William   642463 642463 Lyly, William, of North Duffeld 1
4518093 2206033 2206033 plaintiff Day John   642463 642463 Day, John, of North Duffeld 0
4519024 2206304 2206304 defendant Merston Robert   642463 642463 Merston, Robert, of North Duffeld 1
4556381 2217932 2217932 defendant Baker John   642463 642463 Baker, John, of North Duffeld 5
4561081 2219420 2219420 defendant Taillour John   642463 642463 Taillour, John, of North Duffeld 0
4561082 2219420 2219420 defendant Day John   642463 642463 Day, John, of North Duffeld 1
4604663 2232620 2232620 defendant Typpyng Roger   642463 642463 Typpyng, Roger, of North Duffeld 1
4656523 2247936 2247936 defendant Richardson Thomas smith 642463 642463 Richardson, Thomas, of North Duffeld, smith 1
4713701 2269608 2269608 defendant Janne or Jaune John miller 642463 642463 Janne or Jaune, John, of North Duffeld, miller 0
4769984 2286584 2286584 defendant Saltmershe William gent 642463 642463 Saltmershe, William, of North Duffeld, gent 0
4794604 2294453 2294453 defendant Saltmersshe William gent 642463 642463 Saltmersshe, William, of North Duffeld, gent 0
4815062 2300823 2300823 defendant Salvayne Thomas gent 642463 642463 Salvayne, Thomas, of North Duffeld, gent 0
4875589 2319322 2319322 defendant Nicholl Thomas husbandman 642463 642463 Nicholl, Thomas, of North Duffeld, husbandman 3
4875590 2319322 2319322 defendant Nodder Christopher smith 642463 642463 Nodder, Christopher, of North Duffeld, smith 4
4885692 2322400 2322400 defendant Ensam or Enfam John walker 642463 642463 Ensam or Enfam, John, of North Duffeld, walker 0
4998746 2356513 2356513 defendant Nicoll Thomas husbandman 642463 642463 Nicoll,Thomas, of North Duffeld, husbandman 0
5036077 2367405 2367405 defendant Nicoll Thomas husbandman 642463 642463 Nicoll, Thomas, of North Duffeld, husbandman 4
5052221 2372268 2372268 defendant Palmes George gent 642463 642463 Palmes, George, of North Duffeld, gent 2
5054697 2372984 2372984 defendant Salvayn John   642463 642463 Salvayn, John,of North Duffeld, knight 0
5054698 2372984 2372984 defendant Wilton Henry gent 642463 642463 Wilton, Henry, of North Duffeld, gent 1
5101170 2386754 2386754 defendant Blaunchard John, senior yeoman 642463 642463 Blaunchard, John, senior, of North Duffeld, yeoman 0
5101172 2386754 2386754 defendant Blaunchard John, junior yeoman 642463 642463 Blaunchard, John, junior, of North Duffeld, yeoman 2
5101173 2386754 2386754 defendant Walker William walker 642463 642463 Walker, William, of North Duffeld, walker 3
5101174 2386754 2386754 defendant Smert Richard yeoman 642463 642463 Smert, Richard, of North Duffeld, yeoman;togther with Fippes, William, of North Duffeld, yeoman 4
5101176 2386754 2386754 defendant Osbaldston Robert yeoman 642463 642463 Osbaldston, Robert, of North Duffeld, yeoman 6
5101177 2386754 2386754 defendant Saltmerssh John yeoman 642463 642463 Saltmerssh, John, of North Duffeld, yeoman 7
5101180 2386755 2386755 defendant Fyppes William yeoman 642463 642463 Fyppes, William, of North Duffeld, yeoman 0
5101182 2386755 2386755 defendant Osbaldston Robert yeoman 642463 642463 Osbaldston, Robert, of North Duffeld, yeoman 2
5101183 2386755 2386755 defendant Saltmerssh John yeoman 642463 642463 Saltmerssh, John, of North Duffeld, yeoman 3
5101185 2386755 2386755 defendant Blaunchard John yeoman 642463 642463 together with Blaunchard, John, of North Duffeld, yeoman 5
5101187 2386755 2386755 defendant Smert Richard yeoman 642463 642463 Smert, Richard, of North Duffeld, yeoman 7
5363542 2464249 2464249 defendant Salvayn John esq 642463 642463 Salvayn, John, of North Duffeld, esq 0
5367819 2465562 2465562 defendant Walker George yeoman 642463 642463 Walker, George, of North Duffeld, yeoman 0
5381405 2469742 2469742 defendant Walker George yeoman 642463 642463 Walker, George, of North Duffeld, yeoman 0
5382886 2470172 2470172 defendant Hokerby John husbandman 642463 642463 Hokerby, John, of North Duffeld, husbandman 0
5386219 2471122 2471122 defendant Walker George yeoman 642463 642463 Walker, George, of North Duffeld, yeoman 0
5386226 2471123 2471123 defendant Walker George yeoman 642463 642463 Walker, George, of North Duffeld, yeoman 0
5397351 2474329 2474329 defendant Baret Richard husbandman 642463 642463 Baret, Richard, of North Duffeld, husbandman 0
5507807 2507339 2507339 defendant Salvan William esq 642463 642463 Salvan, William, of North Duffeld, esq 0
5507811 2507341 2507341 defendant Salvan William esq 642463 642463 Salvan, William, of North Duffeld, esq 0
5526958 2512999 2512999 defendant Caldbok William yeoman 642463 642463 Caldbok, William, of North Duffeld, yeoman 0
5530861 2514166 2514166 defendant Forster William   642463 642463 Forster, William, of North Duffeld, cartwright 3
5571033 2526092 2526092 defendant Nicholl Thomas husbandman 642463 642463 Nicholl, Thomas, of North Duffeld, husbandman 0
5571034 2526092 2526092 defendant Nicholl John husbandman 642463 642463 Nicholl, John, of North Duffeld, husbandman 1
5635063 2554952 2554952 defendant Dey John husbandman 642463 642463 Dey, John, of North Duffeld, husbandman 1

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