names

26 rows where place_id = 597554

✎ 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
3628996 1903945 1903945 defendant Doydchon Thomas carpenter 597554 597554 Doydchon, Thomas, of Grymmesby, carpenter 0
3630601 1904399 1904399 defendant Forest Alexander shoemaker 597554 597554 Forest, Alexander, of Grymmesby, shoemaker 3
3712581 1930250 1930250 defendant Bankys Petronilla (legal representative) 597554 597554 Bankys, Petronilla, of Grymmesby, administrator of 2
3825056 1965711 1965711 defendant West George mariner 597554 597554 West, George, of Grymmesby, mariner 1
4493021 2198516 2198516 defendant Burton Thomas   597554 597554 Burton, Thomas, of Grymmesby 0
4569997 2222186 2222186 defendant Cowenham John de, sen   597554 597554 Cowenham, John de, sen, of Grymmesby 1
4571036 2222509 2222509 defendant Cowenham John de, sen   597554 597554 Cowenham, John de, sen, of Grymmesby 1
4617416 2236458 2236458 defendant Burgey Robert   597554 597554 Burgey, Robert, of Grymmesby 4
4636411 2242224 2242224 plaintiff Barker Thomas   597554 597554 Barker, Thomas, of Grymmesby 0
4665395 2250655 2250655 defendant Clerk Thomas clerk 597554 597554 Clerk, Thomas, of Grymmesby, clerk 1
4665396 2250655 2250655 defendant Barker John barker 597554 597554 Barker, John, of Grymmesby, barker 2
4665397 2250655 2250655 defendant Litster John dyer 597554 597554 Litster, John, of Grymmesby, dyer 3
4665398 2250655 2250655 defendant Batteley Richard tailor 597554 597554 Batteley, Richard, of Grymmesby, tailor 4
4665399 2250655 2250655 defendant de Skendylby John flesshewer or butcher 597554 597554 de Skendylby, John, of Grymmesby, flesshewer or butcher 5
4665401 2250655 2250655 defendant de Stylyngton John shoemaker 597554 597554 de Stylyngton, John, of Grymmesby, shoemaker 7
4665402 2250655 2250655 defendant Hosear John hosier 597554 597554 Hosear, John, of Grymmesby, hosier 8
4673833 2257435 2257435 defendant Skendelby John butcher 597554 597554 Skendelby, John, of Grymmesby, butcher 0
4884715 2322125 2322125 defendant Mader Robert merchant 597554 597554 Mader, Robert, of Grymmesby, merchant 4
4886067 2322501 2322501 defendant Madur Robert chapman 597554 597554 Madur, Robert, of Grymmesby, chapman 2
4891184 2323975 2323975 defendant Madur Robert chapman 597554 597554 Madur, Robert, of Grymmesby, chapman 2
4891192 2323976 2323976 defendant Mader Robert merchant 597554 597554 Mader, Robert, of Grymmesby, merchant 4
4942831 2339728 2339728 defendant Ferrour or Smith Richard mariner 597554 597554 Ferrour or Smith, Richard, of Grymmesby, mariner 1
4966325 2346862 2346862 plaintiff Markham William mercer 597554 597554 Markham, William, of Grymmesby, mercer 1
5227287 2423609 2423609 defendant Conhope or Couhope Elizabeth widow 597554 597554 Conhope or Couhope, Elizabeth, of Grymmesby, widow 1
5256876 2432278 2432278 plaintiff Elston John   597554 597554 Elston, John, of Grymmesby 1
5538683 2516580 2516580 defendant Rede Robert shoemaker 597554 597554 Rede, Robert, of Grymmesby, shoemaker 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);