names

28 rows where place_id = 606553

✎ 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
3665646 1915205 1915205 defendant Smyth Richard yeoman 606553 606553 Smyth, Richard, of Arley, yeoman 0
3715539 1931146 1931146 defendant Smyth Richard yeoman 606553 606553 Smyth, Richard, of Arley, yeoman 2
3718812 1932164 1932164 defendant Stonhurst Richard husbandman 606553 606553 Stonhurst, Richard, of Arley, husbandman 0
3720651 1932747 1932747 defendant Salwey John husbandman 606553 606553 Salwey, John, of Arley, husbandman 0
3768609 1947831 1947831 defendant Morgan Henry husbandman 606553 606553 Morgan, Henry, of Arley, husbandman 0
4042657 2039848 2039848 defendant Cooke Thomas smith 606553 606553 Cooke, Thomas, of Arley, smith 0
4046434 2041171 2041171 defendant Cooke John smith 606553 606553 Cooke, John, of Arley, smith 1
4046498 2041198 2041198 defendant Oughton Henry husbandman 606553 606553 Oughton, Henry, of Arley, husbandman 0
4046500 2041199 2041199 defendant Oughton Henry husbandman 606553 606553 Oughton, Henry, of Arley, husbandman 0
4489706 2197496 2197496 defendant Buryate John   606553 606553 Buryate, John, of Arley 0
4630430 2240428 2240428 defendant Sloley John de   606553 606553 Sloley, John de, of Arley 0
4703523 2266483 2266483 defendant Longeley Walter chaplain 606553 606553 Longeley, Walter, of Arley, chaplain 0
4711620 2268961 2268961 defendant Sloley John husbandman 606553 606553 Sloley, John, of Arley, husbandman 5
4823344 2303388 2303388 defendant Clerk William   606553 606553 Clerk, William, of Arley, parson 0
4823345 2303388 2303388 defendant Ardyng John husbandman 606553 606553 Ardyng, John, of Arley, husbandman 1
4963270 2345924 2345924 defendant Lyne or Lyve Thomas husbandman 606553 606553 Lyne or Lyve, Thomas, of Arley, husbandman 0
5094142 2384690 2384690 defendant Benet Hugh yeoman 606553 606553 Benet, Hugh, of Arley, yeoman 0
5206970 2417774 2417774 defendant Hardyng Robert husbandman 606553 606553 Hardyng, Robert, of Arley, husbandman 0
5329824 2453989 2453989 defendant Derby William, senior husbandman 606553 606553 Derby, William, senior, of Arley, husbandman 0
5329825 2453989 2453989 defendant Derby Robert husbandman 606553 606553 Derby, Robert, of Arley, husbandman 1
5473548 2497052 2497052 defendant Taillour Richard (legal representative) 606553 606553 Taillour, Richard, of Arley, executors of 0
5477782 2498374 2498374 defendant Shepey John husbandman 606553 606553 Shepey, John, of Arley, husbandman 1
5535295 2515565 2515565 defendant Payn William yeoman 606553 606553 Payn, William, of Arley, yeoman 0
5535296 2515565 2515565 defendant Tugge William yeoman 606553 606553 Tugge, William, of Arley, yeoman 1
5535298 2515566 2515566 defendant Tugge William husbandman 606553 606553 Tugge, William, of Arley, husbandman 0
5535299 2515566 2515566 defendant Payn William yeoman 606553 606553 Payn, William, of Arley, yeoman 1
5541957 2517605 2517605 defendant Hardyng Richard husbandman 606553 606553 Hardyng, Richard, of Arley, husbandman 3
5558460 2522420 2522420 defendant Heth Richard husbandman 606553 606553 Heth, Richard, of Arley, husbandman 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);