names

29 rows where place_id = 612714

✎ 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
3651733 1910896 1910896 defendant Spendlove alias Spendley Thomas   612714 612714 Spendlove alias Spendley, Thomas, of Alforth, yeoman, administrators of 1
3694682 1924539 1924539 defendant Walhed Thomas yeoman 612714 612714 Walhed, Thomas, of Alforth, yeoman 0
3697753 1925520 1925520 defendant Johnson Thomas yeoman 612714 612714 Johnson, Thomas, of Alforth, yeoman 0
3715418 1931108 1931108 defendant Glover Simon glover 612714 612714 Glover, Simon, of Alforth, glover 1
3774643 1949798 1949798 defendant Turtull William husbandman 612714 612714 Turtull, William, of Alforth, husbandman 0
3796898 1956908 1956908 defendant Clerk William skinner 612714 612714 Clerk, William, of Alforth, skinner 0
3796899 1956908 1956908 defendant Byrket John shoemaker 612714 612714 Byrket, John, of Alforth, shoemaker 1
3799566 1957784 1957784 defendant Anderson William glover 612714 612714 Anderson, William, of Alforth, glover 3
3905217 1992007 1992007 defendant Johnson Hugh mercer 612714 612714 Johnson, Hugh, of Alforth, mercer 0
3980032 2017621 2017621 plaintiff Parmorte Christopher gent 612714 612714 Parmorte, Christopher, of Alforth, or of Lowthe, gent 0
3980036 2017622 2017622 plaintiff Parmote or Pormorte Christopher gent 612714 612714 Parmote or Pormorte, Christopher, of Alforth, or of Lowthe, gent 0
4511869 2204161 2204161 plaintiff Bocher Andrew   612714 612714 Bocher, Andrew, of Alforth 0
4511870 2204161 2204161 defendant Cook Adam   612714 612714 Cook, Adam, of Alforth 0
4511871 2204161 2204161 defendant Brone Robert miller 612714 612714 Brone, Robert, of Alforth, miller 1
4511872 2204161 2204161 defendant Chaloner Robert   612714 612714 Chaloner, Robert, of Alforth 2
5065715 2376269 2376269 defendant Bower Johgn chapman 612714 612714 Bower, Johgn, of Alforth, chapman 2
5099118 2386169 2386169 defendant Forster John barber 612714 612714 Forster, John, of Alforth, barber 3
5106784 2388411 2388411 defendant Tetenay William summoner 612714 612714 Tetenay, William, of Alforth, summoner 0
5247539 2429434 2429434 defendant Gudknape Thomas yeoman 612714 612714 Gudknape, Thomas, of Alforth, yeoman 0
5247540 2429434 2429434 defendant Gudknape John yeoman 612714 612714 Gudknape, John, of Alforth, yeoman 1
5247552 2429439 2429439 defendant Gudknape Thomas yeoman 612714 612714 Gudknape, Thomas, of Alforth, yeoman 0
5247553 2429439 2429439 defendant Gudknape John yeoman 612714 612714 Gudknape, John, of Alforth, yeoman 1
5287904 2441478 2441478 defendant Bust Robert yeoman 612714 612714 Bust, Robert, of Alforth, yeoman 0
5293725 2443125 2443125 defendant Magnus Robert courser 612714 612714 Magnus, Robert, of Alforth, courser 3
5346986 2459216 2459216 defendant Webster Thomas husbandman 612714 612714 Webster Thomas, of Alforth, husbandman 1
5372938 2467127 2467127 plaintiff Lowe John, junior   612714 612714 Lowe, John, junior, of Alforth 0
5388693 2471821 2471821 defendant Dowesyng Stephen chaplain 612714 612714 Dowesyng, Stephen, of Alforth, chaplain 0
5517846 2510422 2510422 defendant Gudknape Thomas (legal representative) 612714 612714 Gudknape, Thomas, of Alforth, executor of 0
5517849 2510423 2510423 defendant Gudknape Thomas (legal representative) 612714 612714 Gudknape, Thomas, of Alforth, executor of 0

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