names

35 rows where place_id = 588906

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595977 1866372 1866372 defendant Aleyn William husbandman 588906 588906 Aleyn, William, of Shelfanger, husbandman 0
3662986 1914336 1914336 plaintiff Noone Henry esq 588906 588906 Noone, Henry, of Shelfanger, esq 0
3758650 1944700 1944700 defendant Impyngton Robert glover 588906 588906 Impyngton, Robert, of Shelfanger, glover 0
3759370 1944919 1944919 defendant Grubbe Henry husbandman 588906 588906 Grubbe, Henry, of Shelfanger, husbandman 2
3774927 1949889 1949889 defendant Medowe Richard husbandman 588906 588906 Medowe, Richard, of Shelfanger, husbandman 0
3815456 1962750 1962750 defendant Noon Henry esq 588906 588906 Noon, Henry, of Shelfanger, esq 0
3841718 1970994 1970994 defendant Medowe Richard yeoman 588906 588906 Medowe, Richard, of Shelfanger, yeoman 0
3847152 1972662 1972662 defendant Doroigh or Doreigh John yeoman 588906 588906 Doroigh or Doreigh, John, of Shelfanger, yeoman 0
3875002 1981865 1981865 defendant Gachon Thomas husbandman 588906 588906 Gachon, Thomas, of Shelfanger, husbandman 0
3885840 1985519 1985519 defendant Baron John gent 588906 588906 Baron, John, of Shelfanger, gent 0
3964849 2012316 2012316 plaintiff Bade Roger glover 588906 588906 Bade, Roger, of Shelfanger, glover 0
3968775 2013706 2013706 defendant Allen Thomas yeoman 588906 588906 Allen, Thomas, of Shelfanger, yeoman 1
4065397 2047913 2047913 defendant Wallys Edmund yeoman 588906 588906 Wallys, Edmund, of Shelfanger, yeoman 1
4122275 2068273 2068273 defendant Hamynge alias Hamond Thomas yeoman 588906 588906 Hamynge alias Hamond, Thomas, of Shelfanger, yeoman 0
4128049 2070321 2070321 defendant Perrye Augustine yeoman 588906 588906 Perrye, Augustine, of Shelfanger, yeoman 0
4130874 2071355 2071355 defendant Stevenson John husbandman 588906 588906 Stevenson, John, of Shelfanger, husbandman 0
4186350 2090712 2090712 defendant Baldry Robert husbandman 588906 588906 Baldry, Robert, of Shelfanger, husbandman 0
4191854 2092708 2092708 defendant Hamyng or Hamont Thomas yeoman 588906 588906 Hamyng or Hamont, Thomas, of Shelfanger, yeoman 0
4210048 2099076 2099076 defendant Baldry Robert husbandman 588906 588906 Baldry, Robert, of Shelfanger, husbandman 0
4226513 2104746 2104746 defendant Braye Thomas husbandman 588906 588906 Braye, Thomas, of Shelfanger, husbandman 0
4251231 2113385 2113385 defendant Wheler Henry husbandman 588906 588906 Wheler, Henry, of Shelfanger, husbandman 2
4251776 2113583 2113583 defendant Allen Daniel carpenter 588906 588906 Allen, Daniel, of Shelfanger, carpenter 2
4274059 2120872 2120872 defendant Fulcher Robert yeoman 588906 588906 Fulcher, Robert, of Shelfanger, yeoman 0
4276504 2121723 2121723 defendant Fulcher Robert yeoman 588906 588906 Fulcher, Robert, of Shelfanger, yeoman 0
4324285 2138522 2138522 defendant Whaley Henry husbandman 588906 588906 Whaley, Henry, of Shelfanger, husbandman 0
4325995 2139067 2139067 defendant Braye Thomas yeoman 588906 588906 Braye, Thomas, of Shelfanger, yeoman 2
4382781 2158947 2158947 defendant Fitt Anthony husbandman 588906 588906 Fitt, Anthony, of Shelfanger, husbandman 1
4469432 2191101 2191101 defendant Neel Edmund   588906 588906 Neel, Edmund, of Shelfanger 2
4781690 2290285 2290285 defendant Crecy John husbandman 588906 588906 Crecy, John, of Shelfanger, husbandman 2
4926291 2334648 2334648 defendant Baldry John yeoman 588906 588906 Baldry, John, of Shelfanger, yeoman 0
5133677 2396343 2396343 defendant Rokyngham John   588906 588906 Rokyngham, John, of Shelfanger 3
5206298 2417578 2417578 defendant Rokyngham John yeoman 588906 588906 Rokyngham, John, of Shelfanger, yeoman 2
5220693 2421744 2421744 defendant Rokyngham John husbandman 588906 588906 Rokyngham, John, of Shelfanger, husbandman 4
5335852 2455790 2455790 defendant Lancastre Henry gent 588906 588906 Lancastre, Henry, of Shelfanger, gent 2
5546983 2519122 2519122 defendant Cowper alias Knotte Henry yeoman 588906 588906 Cowper alias Knotte, Henry, of Shelfanger, yeoman 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);