names

28 rows where place_id = 756657

✎ 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
4439503 2181620 2181620 plaintiff Bakere Thomas   756657 756657 Bakere, Thomas, of Banewell 0
4449530 2184800 2184800 defendant Brounyng John   756657 756657 Brounyng, John, of Banewell 0
4482872 2195347 2195347 defendant Shipper Richard   756657 756657 Shipper, Richard, of Banewell 0
4493682 2198721 2198721 defendant Bakere Thomas   756657 756657 Bakere, Thomas, of Banewell, bailiff of Wynterstok 1
4552683 2216793 2216793 defendant Bakere Thomas   756657 756657 Bakere, Thomas, of Banewell 1
4553740 2217092 2217092 defendant Horne John   756657 756657 Horne, John, of Banewell 1
4569056 2221909 2221909 defendant Frenshe John   756657 756657 Frenshe, John, of Banewell 1
4569063 2221910 2221910 defendant Purbrigge William   756657 756657 Purbrigge, William, of Banewell 2
4631371 2240702 2240702 defendant Bakere Thomas   756657 756657 Bakere, Thomas, of Banewell 0
4697037 2264552 2264552 defendant Reve Walter husbandman 756657 756657 Reve, Walter, of Banewell, husbandman 1
4721826 2272159 2272159 defendant Reve Walter husbandman 756657 756657 Reve, Walter, of Banewell, husbandman 0
4721827 2272159 2272159 defendant Bristoll John husbandman 756657 756657 Bristoll, John, of Banewell, husbandman 1
4721829 2272160 2272160 defendant Reve Walter husbandman 756657 756657 Reve, Walter, of Banewell, husbandman 0
4721830 2272160 2272160 defendant Bustell John husbandman 756657 756657 Bustell, John, of Banewell, husbandman 1
4755477 2282092 2282092 defendant Slegge John husbandman 756657 756657 Slegge, John, of Banewell, husbandman 0
4777363 2288912 2288912 defendant Slegge John husbandman 756657 756657 Slegge, John, of Banewell, husbandman 0
4833107 2306373 2306373 defendant Selewode Thomas baker 756657 756657 Selewode, Thomas, of Banewell, baker 4
4833133 2306376 2306376 defendant Selewode Thomas baker 756657 756657 Selewode, Thomas, of Banewell, baker 5
4882486 2321431 2321431 defendant Penbroke John butcher 756657 756657 Penbroke, John, of Banewell, butcher 1
4952523 2342713 2342713 defendant Mayhewe William shoemaker 756657 756657 Mayhewe, William, of Banewell, shoemaker 4
4967785 2347310 2347310 defendant Bustill William husbandman 756657 756657 Bustill, William, of Banewell, husbandman 0
4987011 2353058 2353058 defendant Landowe Nicholas husbandman 756657 756657 Landowe, Nicholas, of Banewell, husbandman 2
5082425 2381240 2381240 defendant Brydde John baker 756657 756657 Brydde, John, of Banewell, baker 4
5227152 2423585 2423585 defendant Mannyng Walter laborer 756657 756657 Mannyng, Walter, of Banewell, laborer 16
5227181 2423586 2423586 defendant Mannyng Walter laborer 756657 756657 Mannyng, Walter, of Banewell, laborer 16
5299437 2444810 2444810 defendant Cabbell John yeoman 756657 756657 Cabbell, John, of Banewell, yeoman 0
5341311 2457472 2457472 defendant Turnepeny Thomas husbandman 756657 756657 Turnepeny, Thomas, of Banewell, husbandman 0
5496597 2503898 2503898 defendant Baylyf John husbandman 756657 756657 Baylyf, John, of Banewell, 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);