names

30 rows where place_id = 620447

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3735706 1937404 1937404 defendant Tompson William husbandman 620447 620447 Tompson, William, of Folsham, Norf, husbandman 0
4057878 2045202 2045202 defendant Themelthorpe George gent 620447 620447 Themelthorpe, George, of Folsham, Norf, gent 0
4085173 2054980 2054980 defendant Heyward William butcher 620447 620447 Heyward, William, of Folsham, Norf, butcher 2
4101369 2060793 2060793 defendant Hare Thomas chapman 620447 620447 Hare, Thomas, of Folsham, Norf, chapman 0
4208135 2098400 2098400 defendant Pynchebeck Richard gent 620447 620447 Pynchebeck, Richard, of Folsham, Norf, gent 2
4286243 2125133 2125133 defendant Lavile John gent 620447 620447 Lavile, John, of Folsham, Norf, gent 1
4287717 2125659 2125659 defendant Bate Robert husbandman 620447 620447 Bate, Robert, of Folsham, Norf, husbandman 0
4296315 2128780 2128780 defendant Bate Robert husbandman 620447 620447 Bate, Robert, of Folsham, Norf, husbandman 0
4296319 2128781 2128781 defendant Bate Robert husbandman 620447 620447 Bate, Robert, of Folsham, Norf, husbandman 0
4299963 2130082 2130082 defendant Hunt William gent 620447 620447 Hunt, William, of Folsham, Norf, gent 0
4745358 2279150 2279150 defendant Pelle John clerk 620447 620447 Pelle, John, of Folsham, Norf, clerk 0
4745360 2279151 2279151 defendant Pelle John clerk 620447 620447 Pelle, John, of Folsham, Norf, clerk 0
4746556 2279486 2279486 defendant Grene John yeoman 620447 620447 Grene, John, of Folsham, Norf, yeoman 1
4752166 2281111 2281111 defendant Brampton William gent 620447 620447 Brampton, William, of Folsham, Norf, gent 3
4811565 2299726 2299726 defendant Pelle John   620447 620447 Pelle, John, of Folsham, Norf, parson & clerk 0
4818904 2301997 2301997 defendant Cobald Nicholas yeoman 620447 620447 Cobald, Nicholas, of Folsham, Norf, yeoman 1
4896320 2325513 2325513 defendant Brampton William gent 620447 620447 Brampton, William, of Folsham, Norf, gent 1
4917518 2331994 2331994 defendant Bulman William yeoman 620447 620447 Bulman, William, of Folsham, Norf, yeoman 0
4948999 2341674 2341674 defendant Collys Robert butcher 620447 620447 Collys, Robert, of Folsham, Norf, butcher 0
4993126 2354825 2354825 defendant Talyour John yeoman 620447 620447 Talyour, John, of Folsham, Norf, yeoman 0
4999393 2356688 2356688 defendant Collys Robert butcher 620447 620447 Collys, Robert, of Folsham, Norf, butcher 1
5040916 2368903 2368903 defendant Collys Robert butcher 620447 620447 Collys, Robert, of Folsham, Norf, butcher 0
5041568 2369082 2369082 defendant Brampton William esq 620447 620447 Brampton, William, of Folsham, Norf, esq 0
5061138 2374909 2374909 defendant Beteryng Richard yeoman 620447 620447 Beteryng, Richard, of Folsham, Norf, yeoman 0
5124104 2393506 2393506 defendant Cartere John baker 620447 620447 Cartere, John, of Folsham, Norf, baker 3
5124109 2393507 2393507 defendant Carter John baker 620447 620447 Carter, John, of Folsham, Norf, baker 3
5166312 2405870 2405870 defendant Clerk William yeoman 620447 620447 Clerk, William, of Folsham, Norf, yeoman 1
5272206 2436949 2436949 defendant Roberdys Nicholas smith 620447 620447 Roberdys, Nicholas, of Folsham, Norf, smith 2
5595992 2533657 2533657 defendant Cley John (legal representative) 620447 620447 Cley, John, of Folsham, Norf, yeoman, executor of 0
5608736 2537632 2537632 defendant Cley Robert smith 620447 620447 Cley, Robert, of Folsham, Norf, smith 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);