names

28 rows where place_id = 625890

✎ 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
3766958 1947332 1947332 defendant Plummer William husbandman 625890 625890 Plummer, William, of Compton Martyn, husbandman 0
3766959 1947332 1947332 defendant Person John, junior husbandman 625890 625890 Person, John, junior, of Compton Martyn, husbandman 1
3766960 1947332 1947332 defendant Pachemere John husbandman 625890 625890 Pachemere, John, of Compton Martyn, husbandman 2
3766961 1947332 1947332 defendant Mayn Robert husbandman 625890 625890 Mayn, Robert, of Compton Martyn, husbandman 3
3775973 1950230 1950230 defendant Wekys John miner 625890 625890 Wekys, John, of Compton Martyn, miner 2
3775974 1950230 1950230 defendant Style Robert miner 625890 625890 Style, Robert, of Compton Martyn, miner 3
3775975 1950230 1950230 defendant Mayne Robert miner 625890 625890 Mayne, Robert, of Compton Martyn, miner 4
3914489 1995186 1995186 defendant Fere Richard husbandman 625890 625890 Fere, Richard, of Compton Martyn, husbandman 1
3992109 2021941 2021941 defendant Plummer William husbandman 625890 625890 Plummer, William, of Compton Martyn, husbandman 1
4624145 2238530 2238530 plaintiff Mulleward John, sen   625890 625890 Mulleward, John, sen, of Compton Martyn 0
4695499 2264073 2264073 defendant Sambrook Thomas gent 625890 625890 Sambrook, Thomas, of Compton Martyn, gent 0
4695500 2264073 2264073 defendant Lome William   625890 625890 Lome, William, of Compton Martyn, shepherd 1
4695501 2264073 2264073 defendant Wydecombe Walter husbandman 625890 625890 Wydecombe, Walter, of Compton Martyn, husbandman 2
4772296 2287302 2287302 defendant Lomes Robert husbandman 625890 625890 Lomes, Robert, of Compton Martyn, husbandman 3
4772297 2287302 2287302 defendant Blakedon John husbandman 625890 625890 Blakedon, John, of Compton Martyn, husbandman 4
4772298 2287302 2287302 defendant Wydecombe Walter husbandman 625890 625890 Wydecombe, Walter, of Compton Martyn, husbandman 5
4772299 2287302 2287302 defendant Burwer Robert husbandman 625890 625890 Burwer, Robert, of Compton Martyn, husbandman 6
4820701 2302551 2302551 defendant Alrygg Stephen husbandman 625890 625890 Alrygg, Stephen, of Compton Martyn, husbandman 0
4820704 2302552 2302552 defendant Alrygg Stephen husbandman 625890 625890 Alrygg, Stephen, of Compton Martyn, husbandman 0
4831788 2305961 2305961 defendant Roucestre Margery widow 625890 625890 Roucestre, Margery, of Compton Martyn, widow 0
4895655 2325313 2325313 defendant Hykkes John husbandman 625890 625890 Hykkes, John, of Compton Martyn, husbandman 2
5036663 2367592 2367592 defendant Hikkes John husbandman 625890 625890 Hikkes, John, of Compton Martyn, husbandman 0
5123520 2393333 2393333 defendant Rouceter or Rowecetour William clerk 625890 625890 Rouceter or Rowecetour, William, of Compton Martyn, clerk 0
5126805 2394313 2394313 defendant Savage (illegible) husbandman 625890 625890 Savage, ----, of Compton Martyn, husbandman 0
5357111 2462287 2462287 defendant Cook William husbandman 625890 625890 Cook, William, of Compton Martyn, husbandman 0
5357112 2462287 2462287 defendant Plomer John husbandman 625890 625890 Plomer, John, of Compton Martyn, husbandman 1
5357113 2462287 2462287 defendant Langford Thomas husbandman 625890 625890 Langford, Thomas, of Compton Martyn, husbandman 2
5586061 2530682 2530682 defendant Plommer John husbandman 625890 625890 Plommer, John, of Compton Martyn, 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);