names

30 rows where place_id = 593627

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3612619 1871584 1871584 defendant Hacker Alice widow 593627 593627 Hacker, Alice, of Alton Westbroke, widow 1
3635625 1905944 1905944 defendant Arnolde William clothier 593627 593627 Arnolde, William, of Alton Westbroke, clothier 0
3635629 1905945 1905945 defendant Arnolde William clothier 593627 593627 Arnolde, William, of Alton Westbroke, clothier 0
3646309 1909237 1909237 defendant Dyddelfold Thomas yeoman 593627 593627 Dyddelfold, Thomas, of Alton Westbroke, yeoman 0
3648648 1909963 1909963 defendant Markam Edmund butcher 593627 593627 Markam, Edmund, of Alton Westbroke, butcher 1
3651367 1910793 1910793 defendant Arnold William innholder 593627 593627 Arnold, William, of Alton Westbroke, innholder 2
3704088 1927566 1927566 defendant Clerk Richard dyer 593627 593627 Clerk, Richard, of Alton Westbroke, dyer 0
3704090 1927567 1927567 defendant Smyth Richard weaver 593627 593627 Smyth, Richard, of Alton Westbroke, weaver 0
3728980 1935311 1935311 defendant Walyson Christopher yeoman 593627 593627 Walyson, Christopher, of Alton Westbroke, yeoman 0
3737414 1937939 1937939 defendant Clarke Richard dyer 593627 593627 Clarke, Richard, of Alton Westbroke, dyer 0
3814372 1962409 1962409 defendant Fawchyn Nicholas tailor 593627 593627 Fawchyn, Nicholas, of Alton Westbroke, tailor 0
5276616 2438239 2438239 defendant Byrchet John yeoman 593627 593627 Byrchet, John, of Alton Westbroke, yeoman 0
5289820 2442030 2442030 defendant Notte Katherine widow 593627 593627 Notte, Katherine, of Alton Westbroke, widow 3
5324762 2452482 2452482 defendant Birch John hosteler 593627 593627 Birch, John, of Alton Westbroke, hosteler 0
5339794 2457021 2457021 defendant Balchild Richard mercer 593627 593627 Balchild, Richard, of Alton Westbroke, mercer 0
5502909 2505822 2505822 defendant Byrde John skinner 593627 593627 Byrde, John, of Alton Westbroke, skinner 0
5504275 2506253 2506253 defendant Bole William innholder 593627 593627 Bole, William, of Alton Westbroke, innholder 3
5519852 2511046 2511046 defendant Chapman Edward yeoman 593627 593627 Chapman, Edward, of Alton Westbroke, yeoman 0
5521440 2511522 2511522 defendant Boteler Henry dyer 593627 593627 Boteler, Henry, of Alton Westbroke, dyer 1
5532036 2514562 2514562 defendant Boteler Thomas weaver 593627 593627 Boteler, Thomas, of Alton Westbroke, weaver 1
5532037 2514562 2514562 defendant Kyng Henry yeoman 593627 593627 Kyng, Henry, of Alton Westbroke, yeoman 2
5533188 2514930 2514930 defendant Ball alias Denne Richard chapman or husbandman 593627 593627 Ball alias Denne, Richard, of Alton Westbroke, chapman or husbandman 1
5541836 2517560 2517560 defendant Clerke Richard clothier 593627 593627 Clerke, Richard, of Alton Westbroke, clothier 0
5541837 2517560 2517560 defendant Arnold William clothier 593627 593627 Arnold, William, of Alton Westbroke, clothier 1
5547401 2519251 2519251 defendant Randolfe Richard weaver 593627 593627 Randolfe, Richard, of Alton Westbroke, weaver 0
5563409 2523897 2523897 defendant Feld Robert (legal representative) 593627 593627 Feld, Robert, of Alton Westbroke, yeoman, executrix of 0
5563410 2523897 2523897 defendant Feld Rose widow 593627 593627 Feld, Rose, of Alton Westbroke, widow 1
5572218 2526426 2526426 defendant Botiller alias Dyer Henry dyer 593627 593627 Botiller alias Dyer, Henry, of Alton Westbroke, dyer 0
5590639 2532042 2532042 defendant Clerk Richard dyer 593627 593627 Clerk, Richard, of Alton Westbroke, dyer 0
5594430 2533237 2533237 defendant Andrewe Thomas fuller 593627 593627 Andrewe, Thomas, of Alton Westbroke, fuller 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);