names

15 rows where place_id = 653403

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3928443 1999851 1999851 defendant Boston Hugh carpenter 653403 653403 Boston, Hugh, of Great Grimsby, carpenter 1
4309413 2133452 2133452 defendant Holdesworth Luke gent 653403 653403 Holdesworth, Luke, of Great Grimsby, gent 0
4835845 2307201 2307201 defendant Duffeld William husbandman 653403 653403 Duffeld, William, of Great Grimsby, husbandman 0
4995106 2355393 2355393 defendant Avntell Robert merchant 653403 653403 Avntell, Robert, of Great Grimsby, merchant 0
5124817 2393731 2393731 defendant Benyngworth Thomas weaver 653403 653403 Benyngworth, Thomas, of Great Grimsby, weaver 4
5139416 2398016 2398016 defendant D--d John merchant 653403 653403 D--d, John, of Great Grimsby, merchant 0
5139417 2398016 2398016 defendant More Richard merchant 653403 653403 More, Richard, of Great Grimsby, merchant 1
5143666 2399281 2399281 plaintiff Asby Richard   653403 653403 Asby, Richard, of Great Grimsby 0
5148915 2400809 2400809 defendant Hobson Peter shipman 653403 653403 Hobson, Peter, of Great Grimsby, shipman 0
5148916 2400809 2400809 defendant Pelton Henry mariner 653403 653403 Pelton, Henry, of Great Grimsby, mariner 1
5196329 2414676 2414676 defendant Wethern Robert yeoman 653403 653403 Wethern, Robert, of Great Grimsby, yeoman 1
5205487 2417355 2417355 defendant Broughton Thomas merchant 653403 653403 Broughton, Thomas, of Great Grimsby, merchant 3
5469347 2495762 2495762 plaintiff del See Stephen gent 653403 653403 del See, Stephen, of Great Grimsby, gent 0
5474908 2497477 2497477 defendant Clerke Richard butcher 653403 653403 Clerke, Richard, of Great Grimsby, butcher 0
5474909 2497477 2497477 defendant Clerke William yeoman 653403 653403 Clerke, William, of Great Grimsby, yeoman 1

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