names

22 rows where place_id = 613382

✎ 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
3698056 1925619 1925619 defendant Garsham Philip husbandman 613382 613382 Garsham, Philip, of Worlyngton, husbandman 1
3710785 1929690 1929690 defendant Scylcokke William husbandman 613382 613382 Scylcokke, William, of Worlyngton, husbandman 2
3711086 1929778 1929778 defendant Lodsayn or Lodfayn William yeoman 613382 613382 Lodsayn or Lodfayn, William, of Worlyngton, yeoman 2
3932889 2001291 2001291 defendant Curtys John husbandman 613382 613382 Curtys, John, of Worlyngton, husbandman 0
3955733 2009079 2009079 defendant Mortlake Robert husbandman 613382 613382 Mortlake, Robert, of Worlyngton, husbandman 1
3968568 2013641 2013641 defendant Blakaby Thomas husbandman 613382 613382 Blakaby, Thomas, of Worlyngton, husbandman 2
4327407 2139490 2139490 defendant Fyson Richard yeoman 613382 613382 Fyson, Richard, of Worlyngton, yeoman 0
4813307 2300278 2300278 defendant Skytlat John husbandman 613382 613382 Skytlat, John, of Worlyngton, husbandman 1
4839329 2308223 2308223 defendant Hancok Thomas husbandman 613382 613382 Hancok, Thomas, of Worlyngton, husbandman 3
5142694 2398988 2398988 defendant Bagot John clerk 613382 613382 Bagot, John, of Worlyngton, clerk 2
5289095 2441820 2441820 defendant Blome John smith 613382 613382 Blome, John, of Worlyngton, smith 3
5289096 2441820 2441820 defendant Crembell John smith 613382 613382 Crembell, John, of Worlyngton, smith 4
5289164 2441834 2441834 defendant Blome John smith 613382 613382 Blome, John, of Worlyngton, smith 3
5289165 2441834 2441834 defendant Crembyll John smith 613382 613382 Crembyll, John, of Worlyngton, smith 4
5289190 2441839 2441839 defendant Blome John smith 613382 613382 Blome, John, of Worlyngton, smith 3
5289191 2441839 2441839 defendant Crombell John smith 613382 613382 Crombell, John, of Worlyngton, smith 4
5353476 2461160 2461160 defendant Bele John barker 613382 613382 Bele, John, of Worlyngton, barker 0
5564975 2524342 2524342 defendant Garsham Philip husbandman 613382 613382 Garsham, Philip, of Worlyngton, husbandman 3
5565134 2524389 2524389 defendant Carter William husbandman 613382 613382 Carter, William, of Worlyngton, husbandman 0
5568443 2525319 2525319 defendant Carter William husbandman 613382 613382 Carter, William, of Worlyngton, husbandman 0
5593534 2532961 2532961 defendant Hardewyke William husbandman 613382 613382 Hardewyke, William, of Worlyngton, husbandman 0
5593537 2532962 2532962 defendant Harderwyke William husbandman 613382 613382 Harderwyke, William, of Worlyngton, 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);