names

26 rows where place_id = 605372

✎ 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
3661401 1913839 1913839 defendant Smyth William smith 605372 605372 Smyth, William, of Payneswyke, smith 0
3716433 1931433 1931433 defendant West William husbandman 605372 605372 West, William, of Payneswyke, husbandman 0
3801059 1958246 1958246 defendant Corbet Patrick clerk 605372 605372 Corbet, Patrick, of Payneswyke, clerk 0
4013855 2029683 2029683 defendant West Thomas tailor 605372 605372 West, Thomas, of Payneswyke, tailor 1
4028423 2034818 2034818 defendant Ducke Thomas yeoman 605372 605372 Ducke, Thomas, of Payneswyke, yeoman 0
4548591 2215500 2215500 plaintiff Clere Richard   605372 605372 Clere, Richard, of Payneswyke 0
4657252 2248155 2248155 plaintiff Clerk Richard   605372 605372 Clerk, Richard, of Payneswyke 0
4671680 2256789 2256789 plaintiff Chapman John   605372 605372 Chapman, John, of Payneswyke 0
4692579 2263195 2263195 defendant Bealson John butcher 605372 605372 Bealson, John, of Payneswyke, butcher 0
4697697 2264772 2264772 defendant Jude William   605372 605372 Jude, William, of Payneswyke, plough man 0
4697698 2264772 2264772 defendant Jude or Inde Robert husbandman 605372 605372 Jude or Inde, Robert, of Payneswyke, husbandman 1
4704809 2266882 2266882 defendant Beleson John butcher 605372 605372 Beleson, John, of Payneswyke, butcher 1
4787436 2292142 2292142 defendant Webbe Thomas tucker 605372 605372 Webbe, Thomas, of Payneswyke, tucker 0
4791412 2293409 2293409 defendant Belamy Thomas husbandman 605372 605372 Belamy, Thomas, of Payneswyke, husbandman 0
4792767 2293825 2293825 defendant Bacherell Roger husbandman 605372 605372 Bacherell, Roger, of Payneswyke, husbandman 2
4806663 2298295 2298295 plaintiff Chapman John (legal representative) 605372 605372 Chapman, John, of Payneswyke, executors of 0
4836157 2307289 2307289 defendant Clerk John   605372 605372 Clerk, John, of Payneswyke, mason 0
4893957 2324811 2324811 defendant Shipston alias Twenyng John tucker 605372 605372 Shipston alias Twenyng, John, of Payneswyke, tucker 0
4893985 2324820 2324820 defendant Payne John gent 605372 605372 Payne, John, of Payneswyke, gent 1
4917766 2332069 2332069 defendant Westhourd John pyper 605372 605372 Westhourd, John, of Payneswyke, pyper 5
5260398 2433381 2433381 defendant Chambour John weaver 605372 605372 Chambour, John, of Payneswyke, weaver 0
5314466 2449354 2449354 defendant Wey John husbandman 605372 605372 Wey, John, of Payneswyke, husbandman 0
5314470 2449355 2449355 defendant Wey John husbandman 605372 605372 Wey, John, of Payneswyke, husbandman 0
5352375 2460841 2460841 defendant Hore Thomas yeoman 605372 605372 Hore, Thomas, of Payneswyke, yeoman 0
5355853 2461904 2461904 defendant Grene John cordwainer 605372 605372 Grene, John, of Payneswyke, cordwainer 1
5527653 2513227 2513227 defendant Vynour John gent 605372 605372 Vynour, John, of Payneswyke, gent 4

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