names

31 rows where place_id = 648593

✎ 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
3902375 1991025 1991025 defendant Bolle William husbandman 648593 648593 Bolle, William, of North Lopham, husbandman 1
3971837 2014710 2014710 defendant Fordham Richard   648593 648593 Fordham, Richard, of North Lopham, spoon maker 1
3972366 2014908 2014908 defendant Bisshop Richard turner 648593 648593 Bisshop, Richard, of North Lopham, turner 0
3972367 2014908 2014908 defendant Fordham Richard   648593 648593 Fordham, Richard, of North Lopham, spoon maker 1
3996913 2023662 2023662 defendant Hawis John yeoman 648593 648593 Hawis, John, of North Lopham, yeoman 0
4089974 2056698 2056698 defendant Cristmas Roger husbandman 648593 648593 Cristmas, Roger, of North Lopham, husbandman 2
4220964 2102826 2102826 defendant Muryell Humphrey carpenter 648593 648593 Muryell, Humphrey, of North Lopham, carpenter 0
4224486 2104045 2104045 defendant Bullock George yeoman 648593 648593 Bullock, George, of North Lopham, yeoman 0
4282343 2123723 2123723 defendant Toftwood Christopher gent 648593 648593 Toftwood, Christopher, of North Lopham, gent 0
4342181 2144546 2144546 defendant Pattryge John husbandman 648593 648593 Pattryge, John, of North Lopham, husbandman 0
4342182 2144546 2144546 defendant Coote Francis gent 648593 648593 Coote, Francis, of North Lopham, gent 1
4779604 2289607 2289607 defendant Busshe William husbandman 648593 648593 Busshe, William, of North Lopham, husbandman 0
4779605 2289607 2289607 defendant Baldry Thomas husbandman 648593 648593 Baldry, Thomas, of North Lopham, husbandman 1
4779606 2289607 2289607 defendant Turnour Richard husbandman 648593 648593 Turnour, Richard, of North Lopham, husbandman 2
4779607 2289607 2289607 defendant Lyng Robert husbandman 648593 648593 Lyng, Robert, of North Lopham, husbandman 3
5015703 2361478 2361478 defendant Baldry Robert yeoman 648593 648593 Baldry, Robert, of North Lopham, yeoman 3
5286271 2440993 2440993 defendant Rammesbury Margaret widow 648593 648593 Rammesbury, Margaret, of North Lopham, widow 5
5286280 2440994 2440994 defendant Rammesbury Margaret widow 648593 648593 Rammesbury, Margaret, of North Lopham, widow 5
5347609 2459407 2459407 defendant Bolle Thomas yeoman 648593 648593 Bolle, Thomas, of North Lopham, yeoman 2
5351925 2460704 2460704 defendant Bolle John husbandman 648593 648593 Bolle, John, of North Lopham, husbandman 0
5351926 2460704 2460704 defendant Bolle Thomas husbandman 648593 648593 Bolle, Thomas, of North Lopham, husbandman 1
5357355 2462366 2462366 defendant Bolle Thomas yeoman 648593 648593 Bolle, Thomas, of North Lopham, yeoman 0
5440080 2486937 2486937 defendant Bolle Thomas husbandman 648593 648593 Bolle, Thomas, of North Lopham, husbandman 2
5462332 2493635 2493635 defendant Bulle Thomas husbandman 648593 648593 Bulle, Thomas, of North Lopham, husbandman 1
5462335 2493636 2493636 defendant Bulle Thomas husbandman 648593 648593 Bulle, Thomas, of North Lopham, husbandman 1
5477119 2498164 2498164 defendant Bolle Thomas husbandman 648593 648593 Bolle, Thomas, of North Lopham, husbandman 0
5488682 2501498 2501498 defendant Bolle Thomas husbandman 648593 648593 Bolle, Thomas, of North Lopham, husbandman 0
5488688 2501499 2501499 defendant Bolle Thomas husbandman 648593 648593 Bolle, Thomas, of North Lopham, husbandman 0
5508287 2507476 2507476 defendant Bolle Robert, senior husbandman 648593 648593 Bolle, Robert, senior, of North Lopham, husbandman 0
5508292 2507477 2507477 defendant Bolle Robert, senior husbandman 648593 648593 Bolle, Robert, senior, of North Lopham, husbandman 0
5555383 2521580 2521580 defendant Sparke Stephen husbandman 648593 648593 Sparke, Stephen, of North Lopham, 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);