names

22 rows where place_id = 671592

✎ 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
3995133 2023007 2023007 defendant Bragge Robert   671592 671592 Bragge, Robert, of Dolton, groom, son of John 1
4002185 2025568 2025568 defendant Nenowe or Nevowe John cordwainer 671592 671592 Nenowe or Nevowe, John, of Dolton, cordwainer 0
4002186 2025568 2025568 defendant Shurte William husbandman 671592 671592 Shurte, William, of Dolton, husbandman 1
4002187 2025568 2025568 defendant Lyncombe John husbandman 671592 671592 Lyncombe, John, of Dolton, husbandman 2
4034884 2037153 2037153 defendant Lyncombe John husbandman 671592 671592 Lyncombe, John, of Dolton, husbandman 0
4034885 2037153 2037153 defendant Atwell William carpenter 671592 671592 Atwell, William, of Dolton, carpenter 1
4034887 2037154 2037154 defendant Mules or Miles Brian husbandman 671592 671592 Mules or Miles, Brian, of Dolton, husbandman 0
4034888 2037154 2037154 defendant Nene or Neve John cordwainer 671592 671592 Nene or Neve, John, of Dolton, cordwainer 1
4034889 2037154 2037154 defendant Shurte William husbandman 671592 671592 Shurte, William, of Dolton, husbandman 2
4034892 2037155 2037155 defendant Nenowe or Nevowe John cordwainer 671592 671592 Nenowe or Nevowe, John, of Dolton, cordwainer 0
4034893 2037155 2037155 defendant Shurte William husbandman 671592 671592 Shurte, William, of Dolton, husbandman 1
4036314 2037671 2037671 defendant Bragge John   671592 671592 Bragge, John, of Dolton, mason 0
4036315 2037671 2037671 defendant Lyncombe John husbandman 671592 671592 Lyncombe, John, of Dolton, husbandman 1
4039600 2038780 2038780 defendant Richard John husbandman 671592 671592 Richard, John, of Dolton, husbandman 10
4039617 2038781 2038781 defendant Richard John husbandman 671592 671592 Richard, John, of Dolton, husbandman 10
4060254 2046066 2046066 defendant Lyncam John husbandman 671592 671592 Lyncam, John, of Dolton, husbandman 0
4060255 2046066 2046066 defendant Neve John husbandman 671592 671592 Neve, John, of Dolton, husbandman 1
4060256 2046066 2046066 defendant Shurte William husbandman 671592 671592 Shurte, William, of Dolton, husbandman 2
4061596 2046545 2046545 defendant Shorte William husbandman 671592 671592 Shorte, William, of Dolton, husbandman 0
4160300 2081673 2081673 defendant Averye Nectas butcher 671592 671592 Averye, Nectas, of Dolton, butcher 0
4774383 2287969 2287969 defendant Reyner Robert husbandman 671592 671592 Reyner, Robert, of Dolton, husbandman 1
5607662 2537294 2537294 defendant Burgyn John butcher 671592 671592 Burgyn, John, of Dolton, butcher 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);