names

31 rows where place_id = 602336

✎ 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
3649666 1910267 1910267 plaintiff Pymme William   602336 602336 Pymme, William, of Princes Risborough 0
3652997 1911268 1911268 defendant Broun Edmund barber 602336 602336 Broun, Edmund, of Princes Risborough, barber 0
3656676 1912340 1912340 defendant Rytwyld Edmund butcher 602336 602336 Rytwyld, Edmund, of Princes Risborough, butcher 0
3659511 1913234 1913234 defendant Warwyke Robert weaver 602336 602336 Warwyke, Robert, of Princes Risborough, weaver 0
3675438 1918355 1918355 defendant Wibourn George butcher 602336 602336 Wibourn, George, of Princes Risborough, butcher 0
3692058 1923686 1923686 defendant Smyth Thomas husbandman 602336 602336 Smyth, Thomas, of Princes Risborough, husbandman 0
3709144 1929157 1929157 defendant Clerke Thomas husbandman 602336 602336 Clerke, Thomas, of Princes Risborough, husbandman 2
3727548 1934896 1934896 defendant Hawes Thomas husbandman 602336 602336 Hawes, Thomas, of Princes Risborough, husbandman 0
3732137 1936286 1936286 defendant Smyth Robert husbandman 602336 602336 Smyth, Robert, of Princes Risborough, husbandman 3
3813210 1962042 1962042 defendant Smyth William yeoman 602336 602336 Smyth, William, of Princes Risborough, yeoman 0
3825363 1965783 1965783 defendant Colshill Thomas tailor 602336 602336 Colshill, Thomas, of Princes Risborough, tailor 0
3909119 1993349 1993349 defendant Michell Thomas husbandman 602336 602336 Michell, Thomas, of Princes Risborough, husbandman 2
4081220 2053591 2053591 defendant Neale William husbandman 602336 602336 Neale, William, of Princes Risborough, husbandman 0
4515680 2205325 2205325 defendant Boucher John   602336 602336 Boucher, John, of Princes Risborough 0
5038310 2368098 2368098 defendant Pendley John butcher 602336 602336 Pendley, John, of Princes Risborough, butcher 4
5047192 2370781 2370781 defendant Onyet or Ouyet William husbandman 602336 602336 Onyet or Ouyet, William, of Princes Risborough, husbandman 0
5047193 2370781 2370781 defendant Chesop Walter laborer 602336 602336 Chesop, Walter, of Princes Risborough, laborer 1
5205123 2417257 2417257 plaintiff Gomme Henry   602336 602336 Gomme, Henry, of Princes Risborough 0
5223268 2422500 2422500 defendant Mixhill Andrew butcher 602336 602336 Mixhill, Andrew, of Princes Risborough, butcher 0
5368958 2465882 2465882 defendant Grene William mercer 602336 602336 Grene, William, of Princes Risborough, mercer 1
5378026 2468705 2468705 defendant Pynchyn John chapman 602336 602336 Pynchyn, John, of Princes Risborough, chapman 2
5378030 2468706 2468706 defendant Pynchyn John chapman 602336 602336 Pynchyn, John, of Princes Risborough, chapman 2
5379895 2469296 2469296 defendant Pynchyn John chapman 602336 602336 Pynchyn, John, of Princes Risborough, chapman 2
5380379 2469438 2469438 defendant Pynchon William chapman 602336 602336 Pynchon, William, of Princes Risborough, chapman 1
5385004 2470786 2470786 defendant Pynchon William chapman 602336 602336 Pynchon, William, of Princes Risborough, chapman 1
5393665 2473249 2473249 defendant Pynchon John   602336 602336 Pynchon, John, of Princes Risborough 2
5393669 2473250 2473250 defendant Pynchyn John   602336 602336 Pynchyn, John, of Princes Risborough 2
5406842 2477021 2477021 defendant Pynchyn John chapman 602336 602336 Pynchyn, John, of Princes Risborough, chapman 1
5594574 2533282 2533282 defendant Boller William husbandman 602336 602336 Boller, William, of Princes Risborough, husbandman 1
5596683 2533883 2533883 defendant Hawes Robert husbandman 602336 602336 Hawes, Robert, of Princes Risborough, husbandman 1
5608419 2537535 2537535 defendant Pynchon William chapman 602336 602336 Pynchon, William, of Princes Risborough, chapman 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);