names

16 rows where case_id = 2372701

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5053668 2372701 2372701 plaintiff Baynard Philip esq   Baynard, Philip, esq 0
5053669 2372701 2372701 defendant Wattes John husbandman 813438 813438 Wattes, John, of Bishops Canynges, husbandman 0
5053670 2372701 2372701 defendant Dokeman John yeoman 840770 840770 Dokeman, John, of Devysewyk, yeoman 1
5053671 2372701 2372701 defendant Weere John husbandman 813438 813438 Weere, John, of Bishops Canynges, husbandman 2
5053672 2372701 2372701 defendant Upton Nicholas husbandman 743082 743082 Upton, Nicholas, of Biddeston, husbandman 3
5053673 2372701 2372701 defendant Ned John miller 615404 615404 Ned, John, of Colerne, miller 4
5053674 2372701 2372701 defendant Newman William fuller 840771 840771 Newman, William, of Slangtonford, fuller 5
5053675 2372701 2372701 defendant Piers Henry fuller 649963 649963 Piers, Henry, of Castelcombe, fuller 6
5053676 2372701 2372701 defendant Cokkushale John weaver 649963 649963 Cokkushale, John, of Castelcombe, weaver 7
5053677 2372701 2372701 defendant Benet Robert weaver 781709 781709 Benet, Robert, of Netelton, weaver 8
5053678 2372701 2372701 defendant Palmer John husbandman 836727 836727 Palmer, John, of North Langley, husbandman 9
5053679 2372701 2372701 defendant Fynamore John husbandman 594609 594609 Fynamore, John, of Draycote, husbandman 10
5053680 2372701 2372701 defendant Pontyng Nicholas husbandman 840772 840772 Pontyng, Nicholas, of Segreve, husbandman 11
5053681 2372701 2372701 defendant Brewer John husbandman 614642 614642 Brewer, John, of Langley Burell, husbandman 12
5053682 2372701 2372701 defendant Brewer Thomas husbandman 614642 614642 Brewer, Thomas, of Langley Burell, husbandman 13
5053683 2372701 2372701 defendant Holwey John husbandman 672975 672975 Holwey, John, of Melkesham, husbandman 14

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