names

24 rows where place_id = 761485

✎ 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
4479352 2194193 2194193 defendant Whelewright John   761485 761485 Whelewright, John, of St Neot 0
4591856 2228806 2228806 defendant Curteys John   761485 761485 Curteys, John, of St Neot 6
4737128 2276731 2276731 defendant Harry Stephen laborer 761485 761485 Harry, Stephen, of St Neot, laborer 0
4737129 2276731 2276731 defendant Malet Robert   761485 761485 Malet, Robert, of St Neot, bailiff 1
4737136 2276732 2276732 defendant Harry Stephen laborer 761485 761485 Harry, Stephen, of St Neot, laborer 1
4752939 2281311 2281311 defendant Mulet Robert   761485 761485 Mulet, Robert, of St Neot, bailiff 3
4774061 2287872 2287872 defendant Gonet John collier 761485 761485 Gonet, John, of St Neot, collier 3
4915867 2331458 2331458 plaintiff Dyer John   761485 761485 Dyer, John, of St Neot 0
4915868 2331458 2331458 defendant Pya John chaplain 761485 761485 Pya, John, of St Neot, chaplain 0
4935533 2337511 2337511 defendant Croppe James tinner 761485 761485 Croppe, James, of St Neot, tinner 0
4935534 2337511 2337511 defendant Trenyggowe William tinner 761485 761485 Trenyggowe, William, of St Neot, tinner 1
4935535 2337511 2337511 defendant Trenyggowe Stephen tinner 761485 761485 Trenyggowe, Stephen, of St Neot, tinner 2
4935536 2337511 2337511 defendant Harry John tinner 761485 761485 Harry, John, of St Neot, tinner 3
4935537 2337511 2337511 defendant Pye William husbandman 761485 761485 Pye, William, of St Neot, husbandman M Nicoll, Stephen, of St Neot, husbandman 4
4935538 2337511 2337511 defendant Rese Richard husbandman 761485 761485 Rese, Richard, of St Neot, husbandman 5
4935539 2337511 2337511 defendant Attehill John husbandman 761485 761485 Attehill, John, of St Neot, husbandman 6
4935540 2337511 2337511 defendant Martyn John husbandman 761485 761485 Martyn, John, of St Neot, husbandman 7
4935542 2337511 2337511 defendant Harry Robert husbandman 761485 761485 Harry, Robert, of St Neot, husbandman 9
4941065 2339227 2339227 plaintiff Dyer John   761485 761485 Dyer, John, of St Neot 0
4941066 2339227 2339227 defendant Pya John chaplain 761485 761485 Pya, John, of St Neot, chaplain 0
4964470 2346282 2346282 defendant Pya John clerk 761485 761485 Pya, John, of St Neot, clerk 12
4998885 2356550 2356550 defendant Knyght William chaplain 761485 761485 Knyght, William, of St Neot, chaplain 1
5621280 2550543 2550543 defendant Willito Robert   761485 761485 Willito, Robert, of St Neot 0
5634158 2554668 2554668 defendant Guvet John yeoman 761485 761485 Guvet, John, of St Neot, yeoman 3

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