names

23 rows where place_id = 647625

✎ 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
3897229 1989291 1989291 defendant Appulby Edward husbandman 647625 647625 Appulby, Edward, of Manfeld, husbandman 0
4428612 2173756 2173756 plaintiff Swan John, senior   647625 647625 Swan, John, senior, of Manfeld 0
4428613 2173756 2173756 defendant Pigot John   647625 647625 Pigot, John, of Manfeld, son of Brian 0
4548287 2215406 2215406 defendant Stephenson William   647625 647625 Stephenson, William, of Manfeld 0
4548288 2215406 2215406 defendant Stephenson Thomas   647625 647625 Stephenson, Thomas, of Manfeld, son of William 1
4570183 2222244 2222244 defendant Williamson Thomas   647625 647625 Williamson, Thomas, of Manfeld 0
4616796 2236255 2236255 defendant Stok Gilbert   647625 647625 Stok, Gilbert, of Manfeld 0
4732340 2275292 2275292 defendant Stonle William husbandman 647625 647625 Stonle, William, of Manfeld, husbandman 0
4771006 2286911 2286911 defendant Fleshewer John husbandman 647625 647625 Fleshewer, John, of Manfeld, husbandman 0
4772833 2287473 2287473 defendant Mone or Move John husbandman 647625 647625 Mone or Move, John, of Manfeld, husbandman 0
4783546 2290871 2290871 defendant Frithebank Robert gent 647625 647625 Frithebank, Robert, of Manfeld, gent 0
4795817 2294843 2294843 defendant Fleshewer John husbandman 647625 647625 Fleshewer, John, of Manfeld, husbandman 0
4841087 2308748 2308748 defendant Frythbank John gent 647625 647625 Frythbank, John, of Manfeld, gent 2
4896784 2325652 2325652 defendant Stevenson John yeoman 647625 647625 Stevenson, John, of Manfeld, yeoman 0
4926956 2334860 2334860 defendant Neuton John husbandman 647625 647625 Neuton, John, of Manfeld, husbandman 0
5045705 2370350 2370350 defendant Stevenson Helen widow 647625 647625 Stevenson, Helen, of Manfeld, widow 0
5168852 2406619 2406619 defendant Manfeld Thomas gent 647625 647625 Manfeld, Thomas, of Manfeld, gent 1
5185096 2411381 2411381 defendant Manfeld Thomas gent 647625 647625 Manfeld, Thomas, of Manfeld, gent 0
5283894 2440322 2440322 defendant Raph Thomas yeoman 647625 647625 Raph, Thomas, of Manfeld, yeoman 0
5283895 2440322 2440322 defendant Neuson William yeoman 647625 647625 Neuson, William, of Manfeld, yeoman 1
5283896 2440322 2440322 defendant Seriantson Thomas yeoman 647625 647625 Seriantson, Thomas, of Manfeld, yeoman 2
5328290 2453539 2453539 defendant Hobson Henry   647625 647625 Hobson, Henry, of Manfeld 0
5392568 2472943 2472943 defendant Bellerby Henry   647625 647625 Bellerby, Henry, of Manfeld, franklin 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);