names

29 rows where place_id = 595815

✎ 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
3622011 1874426 1874426 defendant Reygate Reginald yeoman 595815 595815 Reygate, Reginald, of Baburham, yeoman 0
3622887 1874687 1874687 defendant Hayles William butcher 595815 595815 Hayles, William, of Baburham, butcher 0
3622889 1874688 1874688 defendant Hayles William butcher 595815 595815 Hayles, William, of Baburham, butcher 0
3624789 1875287 1875287 defendant Regyt Reginald husbandman 595815 595815 Regyt, Reginald, of Baburham, husbandman 0
3642255 1908026 1908026 defendant Robynson Robert innholder 595815 595815 Robynson, Robert, of Baburham, innholder 0
3675089 1918241 1918241 defendant Downes Geoffrey gent 595815 595815 Downes, Geoffrey, of Baburham, gent 3
3745812 1940593 1940593 defendant Broun William husbandman 595815 595815 Broun, William, of Baburham, husbandman 3
3774840 1949859 1949859 defendant Tayler John laborer 595815 595815 Tayler, John, of Baburham, laborer 1
3804395 1959311 1959311 defendant Barfote William innholder 595815 595815 Barfote, William, of Baburham, innholder 0
3806151 1959852 1959852 defendant Parmenter William innholder 595815 595815 Parmenter, William, of Baburham, innholder 0
3823700 1965309 1965309 defendant Parmenter William innholder 595815 595815 Parmenter, William, of Baburham, innholder 0
3854143 1974934 1974934 defendant Daunte Robert yeoman 595815 595815 Daunte, Robert, of Baburham, yeoman 0
4575925 2223960 2223960 defendant Takele John   595815 595815 Takele, John, of Baburham 0
4825175 2303915 2303915 defendant Munne John ostler 595815 595815 Munne, John, of Baburham, ostler 1
4950588 2342146 2342146 defendant Glover John yeoman 595815 595815 Glover, John, of Baburham, yeoman 0
4972751 2348786 2348786 defendant Thurgour Roger husbandman 595815 595815 Thurgour, Roger, of Baburham, husbandman Thurgour, Simon, of Parva Abyton, husbandman 1
5147704 2400467 2400467 defendant Pye Walter (legal representative) 595815 595815 Pye, Walter, of Baburham, husbandman, administrator of 0
5147705 2400467 2400467 defendant Pye John husbandman 595815 595815 Pye, John, of Baburham, husbandman 1
5154903 2402594 2402594 defendant Thurger Robert husbandman 595815 595815 Thurger, Robert, of Baburham, husbandman 0
5171757 2407462 2407462 defendant Thurger Robert husbandman 595815 595815 Thurger, Robert, of Baburham, husbandman 0
5206950 2417769 2417769 defendant Thurger Robert husbandman 595815 595815 Thurger, Robert, of Baburham, husbandman 0
5353092 2461047 2461047 defendant Treve or Trene Robert smith 595815 595815 Treve or Trene, Robert, of Baburham, smith 3
5353093 2461047 2461047 defendant Chirche John smith 595815 595815 Chirche, John, of Baburham, smith 4
5358333 2462659 2462659 defendant Gylson William husbandman 595815 595815 Gylson, William, of Baburham, husbandman 1
5358337 2462660 2462660 defendant Gilson William husbandman 595815 595815 Gilson, William, of Baburham, husbandman 1
5358341 2462661 2462661 defendant Gilson William husbandman 595815 595815 Gilson, William, of Baburham, husbandman 1
5504553 2506345 2506345 defendant Humfrey Richard laborer 595815 595815 Humfrey, Richard, of Baburham, laborer 3
5504558 2506346 2506346 defendant Humfrey Richard laborer 595815 595815 Humfrey, Richard, of Baburham, laborer 3
5584483 2530212 2530212 defendant Pynk William yeoman 595815 595815 Pynk, William, of Baburham, 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);