names

25 rows where place_id = 588951

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596094 1866408 1866408 plaintiff Nytyngyale John mercer 588951 588951 Nytyngyale, John, of Brentwode, mercer 0
3648808 1910015 1910015 defendant Aleyn Richard innholder 588951 588951 Aleyn, Richard, of Brentwode, innholder 4
3855817 1975450 1975450 defendant Skylman John yeoman 588951 588951 Skylman, John, of Brentwode, yeoman 0
4573584 2223255 2223255 defendant Childe John   588951 588951 Childe, John, of Brentwode 2
4633045 2241203 2241203 defendant Pulter Henry   588951 588951 Pulter, Henry, of Brentwode 4
5095590 2385134 2385134 defendant Ely John ostler 588951 588951 Ely, John, of Brentwode, ostler 1
5138607 2397787 2397787 defendant Wyberd Robert husbandman 588951 588951 Wyberd, Robert, of Brentwode, husbandman 0
5219022 2421293 2421293 defendant Franche Thomas butcher 588951 588951 Franche, Thomas, of Brentwode, butcher 0
5219023 2421293 2421293 defendant Franche William butcher 588951 588951 Franche, William, of Brentwode, butcher 1
5264251 2434577 2434577 defendant Cook William yeoman 588951 588951 Cook, William, of Brentwode, yeoman 0
5281784 2439746 2439746 defendant Botyld John yeoman 588951 588951 Botyld, John, of Brentwode, yeoman 0
5281786 2439747 2439747 defendant Botyld John yeoman 588951 588951 Botyld, John, of Brentwode, yeoman 0
5301215 2445322 2445322 defendant Ponde Henry husbandman 588951 588951 Ponde, Henry, of Brentwode, husbandman 0
5339031 2456780 2456780 defendant Mastlyn John glover 588951 588951 Mastlyn, John, of Brentwode, glover 0
5341973 2457679 2457679 defendant Baille John yeoman 588951 588951 Baille, John, of Brentwode, yeoman 1
5350680 2460325 2460325 defendant Baldewyn John butcher 588951 588951 Baldewyn, John, of Brentwode, butcher 0
5356598 2462134 2462134 defendant Broman Thomas butcher 588951 588951 Broman, Thomas, of Brentwode, butcher 0
5358300 2462650 2462650 defendant Bardvyld William yeoman 588951 588951 Bardvyld, William, of Brentwode, yeoman 1
5370256 2466285 2466285 defendant Grene John tiler 588951 588951 Grene, John, of Brentwode, tiler 2
5387734 2471556 2471556 defendant Tryppe John (legal representative) 588951 588951 Tryppe, John, of Brentwode, yeoman, executors of 0
5387735 2471556 2471556 defendant Tryppe Olive widow 588951 588951 (Tryppe, Olive, of Brentwode, widow 1
5387736 2471556 2471556 defendant Waren Nicholas   588951 588951 Waren, Nicholas, of Brentwode, wheel wright 2
5492461 2502659 2502659 defendant Prentys William yeoman 588951 588951 Prentys, William, of Brentwode, yeoman 4
5565038 2524360 2524360 defendant Newman John yeoman 588951 588951 Newman, John, of Brentwode, yeoman 0
5584325 2530164 2530164 defendant Newman John, junior husbandman 588951 588951 Newman, John, junior, of Brentwode, 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);