names

35 rows where place_id = 598806

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3634148 1905480 1905480 defendant Tadlowe Robert husbandman 598806 598806 Tadlowe, Robert, of Bassyngbourne, husbandman 0
4571567 2222685 2222685 defendant Lemman Edward   598806 598806 Lemman, Edward, of Bassyngbourne 3
4673792 2257425 2257425 defendant Ponder John, junior husbandman 598806 598806 Ponder, John, junior, of Bassyngbourne, husbandman 1
4690522 2262591 2262591 defendant Aasshewell Thomas husbandman 598806 598806 Aasshewell, Thomas, of Bassyngbourne, husbandman 5
4690523 2262591 2262591 defendant Taillour Thomas husbandman 598806 598806 Taillour, Thomas, of Bassyngbourne, husbandman 6
4690527 2262592 2262592 defendant Hebbe John husbandman 598806 598806 Hebbe, John, of Bassyngbourne, husbandman 2
4690528 2262592 2262592 defendant Paton John, senior husbandman 598806 598806 Paton, John, senior, of Bassyngbourne, husbandman 3
4690532 2262593 2262593 plaintiff White Warin   598806 598806 White, Warin, of Bassyngbourne 0
4690535 2262593 2262593 defendant Prentyce William husbandman 598806 598806 Prentyce, William, of Bassyngbourne, husbandman 1
4690536 2262593 2262593 defendant Perkyn William husbandman 598806 598806 Perkyn, William, of Bassyngbourne, husbandman 2
4690537 2262593 2262593 defendant Pondere William husbandman 598806 598806 Pondere, William, of Bassyngbourne, husbandman 3
4690538 2262593 2262593 defendant Stabeler John husbandman 598806 598806 Stabeler, John, of Bassyngbourne, husbandman 4
4721527 2272065 2272065 plaintiff Chambirleyn John   598806 598806 Chambirleyn, John, of Bassyngbourne 0
4738558 2277150 2277150 defendant Dambour John husbandman 598806 598806 Dambour, John, of Bassyngbourne, husbandman 5
4742099 2278182 2278182 defendant Bocher William butcher 598806 598806 Bocher, William, of Bassyngbourne, butcher 3
4784511 2291160 2291160 defendant Lorkyn Thomas husbandman 598806 598806 Lorkyn, Thomas, of Bassyngbourne, husbandman 0
4784512 2291160 2291160 defendant Bocher William butcher 598806 598806 Bocher, William, of Bassyngbourne, butcher 1
4784513 2291160 2291160 defendant Tadlowe John husbandman 598806 598806 Tadlowe, John, of Bassyngbourne, husbandman 2
4793779 2294174 2294174 defendant Parker Hugh carter 598806 598806 Parker, Hugh, of Bassyngbourne, carter 0
4793780 2294174 2294174 defendant Burdewes John carter 598806 598806 Burdewes, John, of Bassyngbourne, carter 1
4793782 2294175 2294175 defendant Chicche Thomas butcher 598806 598806 Chicche, Thomas, of Bassyngbourne, butcher 0
4882080 2321292 2321292 defendant Pynke William husbandman 598806 598806 Pynke, William, of Bassyngbourne, husbandman 0
4953312 2342954 2342954 defendant Parlet John husbandman 598806 598806 Parlet, John, of Bassyngbourne, husbandman 0
4954225 2343235 2343235 defendant Pynke Thomas husbandman 598806 598806 Pynke, Thomas, of Bassyngbourne, husbandman 4
4960955 2345242 2345242 defendant Haukyn William butcher 598806 598806 Haukyn, William, of Bassyngbourne, butcher 1
4970255 2348058 2348058 defendant Noorthe Thomas husbandman 598806 598806 Noorthe, Thomas, of Bassyngbourne, husbandman 0
4994533 2355230 2355230 plaintiff Fodheryngey John   598806 598806 Fodheryngey, John, of Bassyngbourne 0
4994534 2355230 2355230 defendant Burdeux John husbandman 598806 598806 Burdeux, John, of Bassyngbourne, husbandman 0
5104782 2387836 2387836 defendant Derley John tiler 598806 598806 Derley, John, of Bassyngbourne, tiler 0
5104783 2387836 2387836 defendant Tadlowe John, junior husbandman 598806 598806 Tadlowe, John, junior, of Bassyngbourne, husbandman 1
5104784 2387836 2387836 defendant Ramarwyk John carpenter 598806 598806 Ramarwyk, John, of Bassyngbourne, carpenter 2
5114461 2390628 2390628 plaintiff Lynne John gent 598806 598806 Lynne, John, of Bassyngbourne, gent 0
5118481 2391841 2391841 defendant Anteny John husbandman 598806 598806 Anteny, John, of Bassyngbourne, husbandman 1
5245894 2428960 2428960 defendant Hale John husbandman 598806 598806 Hale, John, of Bassyngbourne, husbandman 0
5533774 2515110 2515110 defendant Tadlowe John husbandman 598806 598806 Tadlowe, John, of Bassyngbourne, husbandman 2

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