names

13 rows where place_id = 620553

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3736190 1937561 1937561 defendant Bonde John yeoman 620553 620553 Bonde, John, of Brode Somerford, yeoman 0
4263436 2117433 2117433 defendant Knappe Alice spinster 620553 620553 Knappe, Alice, of Brode Somerford, spinster 0
4318787 2136685 2136685 defendant Pockridge Thomas yeoman 620553 620553 Pockridge, Thomas, of Brode Somerford, yeoman 0
4318788 2136685 2136685 defendant Will Robert yeoman 620553 620553 Will, Robert, of Brode Somerford, yeoman 1
4563016 2219998 2219998 defendant Coubrigge William   620553 620553 Coubrigge, William, of Brode Somerford 3
5261691 2433767 2433767 defendant Wykewykes John husbandman 620553 620553 Wykewykes, John, of Brode Somerford, husbandman 2
5261694 2433767 2433767 defendant Bawedewyn Thomas husbandman 620553 620553 Bawedewyn, Thomas, of Brode Somerford, husbandman 5
5261695 2433767 2433767 defendant Hunt Walter husbandman 620553 620553 Hunt, Walter, of Brode Somerford, husbandman 6
5261696 2433767 2433767 defendant Bokelond John husbandman 620553 620553 Bokelond, John, of Brode Somerford, husbandman 7
5261697 2433767 2433767 defendant Kyng William husbandman 620553 620553 Kyng, William, of Brode Somerford, husbandman 8
5261698 2433767 2433767 defendant Pelkerugge William husbandman 620553 620553 Pelkerugge, William, of Brode Somerford, husbandman 9
5261699 2433767 2433767 defendant Pelkerugge Edward husbandman 620553 620553 Pelkerugge, Edward, of Brode Somerford, husbandman 10
5284769 2440562 2440562 defendant Baudweyn Thomas clothman 620553 620553 Baudweyn, Thomas, of Brode Somerford, clothman 5

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