names

31 rows where place_id = 640818

✎ 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
3857647 1976028 1976028 defendant Chamber Thomas gent 640818 640818 Chamber, Thomas, of Laughton, Sussex, gent 0
4120087 2067472 2067472 defendant Weneham John gent 640818 640818 Weneham, John, of Laughton, Sussex, gent 0
4137292 2073685 2073685 defendant Clarke William yeoman 640818 640818 (Clarke, William, of Laughton, Sussex, yeoman 2
4194885 2093773 2093773 defendant Weman John gent 640818 640818 Weman, John, of Laughton, Sussex, gent 0
4284637 2124557 2124557 defendant Wanam or Wenam John gent 640818 640818 Wanam or Wenam, John, of Laughton, Sussex, gent 0
4284638 2124557 2124557 defendant Martyn John yeoman 640818 640818 Martyn, John, of Laughton, Sussex, yeoman 1
4770207 2286655 2286655 defendant Messyngham John   640818 640818 Messyngham, John, of Laughton, Sussex, cook 1
4815812 2301048 2301048 defendant Bathe John gent 640818 640818 Bathe, John, of Laughton, Sussex, gent 0
5065515 2376218 2376218 defendant Pelham John   640818 640818 Pelham, John, of Laughton, Sussex, knight 2
5234615 2425710 2425710 defendant Lowemsford Walter gent 640818 640818 Lowemsford, Walter, of Laughton, Sussex, gent 0
5234617 2425711 2425711 defendant Lowemsford Walter gent 640818 640818 Lowemsford, Walter, of Laughton, Sussex, gent 0
5251928 2430707 2430707 defendant Thomas Thomas yeoman 640818 640818 Thomas, Thomas, of Laughton, Sussex, yeoman 1
5251939 2430710 2430710 defendant Thomas Thomas yeoman 640818 640818 Thomas, Thomas, of Laughton, Sussex, yeoman 0
5268008 2435756 2435756 defendant Thomas Thomas   640818 640818 Thomas, Thomas, of Laughton, Sussex, 1
5268813 2435991 2435991 defendant Thomas Thomas yeoman 640818 640818 Thomas, Thomas, of Laughton, Sussex, yeoman 0
5298751 2444610 2444610 defendant Thomas Thomas yeoman 640818 640818 Thomas, Thomas, of Laughton, Sussex, yeoman 0
5326427 2452990 2452990 defendant Lunsford William gent 640818 640818 Lunsford, William, of Laughton, Sussex, gent 0
5350325 2460223 2460223 defendant Thomas Thomas yeoman 640818 640818 Thomas, Thomas, of Laughton, Sussex, yeoman 0
5355169 2461687 2461687 defendant Thomas Thomas yeoman 640818 640818 Thomas, Thomas, of Laughton, Sussex, yeoman 3
5360552 2463331 2463331 defendant Thomas Thomas yeoman 640818 640818 Thomas, Thomas, of Laughton, Sussex, yeoman 0
5375199 2467830 2467830 defendant Thomas Thomas yeoman 640818 640818 Thomas, Thomas, of Laughton, Sussex, yeoman 0
5396588 2474118 2474118 defendant Pelham William esq 640818 640818 Pelham, William, of Laughton, Sussex, esq 0
5399253 2474856 2474856 defendant Thomas Thomas yeoman 640818 640818 Thomas, Thomas, of Laughton, Sussex, yeoman 0
5399256 2474857 2474857 defendant Thomas Thomas yeoman 640818 640818 Thomas, Thomas,of Laughton, Sussex, yeoman 0
5410772 2478170 2478170 defendant Pelham William esq 640818 640818 Pelham, William, of Laughton, Sussex, esq 0
5410777 2478172 2478172 defendant Pelham William esq 640818 640818 Pelham, William, of Laughton, Sussex, esq 0
5416695 2479911 2479911 defendant Thomas Thomas yeoman 640818 640818 Thomas, Thomas, of Laughton, Sussex, yeoman 0
5433589 2485009 2485009 defendant Thomas Thomas yeoman 640818 640818 Thomas, Thomas, of Laughton, Sussex, yeoman 0
5433591 2485010 2485010 defendant Thomas Thomas yeoman 640818 640818 Thomas, Thomas, of Laughton, Sussex, yeoman 0
5506179 2506851 2506851 defendant Luaff- William gent 640818 640818 Luaff-, William, of Laughton, Sussex, gent 0
5609252 2537797 2537797 defendant (illegible) Thomas yeoman 640818 640818 ---, Thomas, of Laughton, Sussex, yeoman 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);