names

21 rows where place_id = 589978

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3599454 1867468 1867468 defendant Rakley John laborer 589978 589978 Rakley, John, of Newenton, Kent, laborer 1
4437894 2181173 2181173 defendant Belgrave Thomas   589978 589978 Belgrave, Thomas, of Newenton, Kent 3
4437902 2181174 2181174 defendant Belgrave Thomas   589978 589978 Belgrave, Thomas, of Newenton, Kent 3
4437909 2181175 2181175 defendant Belgrave Thomas   589978 589978 Belgrave, Thomas, of Newenton, Kent 3
4467218 2190420 2190420 defendant Stoylle Adam   589978 589978 Stoylle, Adam, of Newenton, Kent 0
4548620 2215510 2215510 defendant Mayner Thomas   589978 589978 Mayner, Thomas, of Newenton, Kent 1
4550792 2216187 2216187 defendant Wyndesore Thomas   589978 589978 Wyndesore, Thomas, of Newenton, Kent 0
4578085 2224649 2224649 defendant Watford William   589978 589978 Watford, William, of Newenton, Kent 4
4629953 2240288 2240288 defendant Trigge John   589978 589978 Trigge, John, of Newenton, Kent 3
4629957 2240289 2240289 defendant Trigge John   589978 589978 Trigge, John, of Newenton, Kent 2
4737848 2276941 2276941 defendant Kelsham Nicholas gent 589978 589978 Kelsham, Nicholas, of Newenton, Kent, gent 2
4883348 2321713 2321713 defendant Bereford William gent 589978 589978 Bereford, William, of Newenton, Kent, gent 0
4886380 2322599 2322599 defendant Bereford William gent 589978 589978 Bereford, William, of Newenton, Kent, gent 0
4889148 2323394 2323394 defendant Cowestede John husbandman 589978 589978 Cowestede, John, of Newenton, Kent, husbandman 0
4896390 2325536 2325536 defendant Cowestede John husbandman 589978 589978 Cowestede, John, of Newenton, Kent, husbandman 0
5016782 2361801 2361801 defendant Ledys John gent 589978 589978 Ledys, John, of Newenton, Kent, gent 0
5045870 2370400 2370400 defendant Leys John gent 589978 589978 Leys, John, of Newenton, Kent, gent 0
5275335 2437859 2437859 defendant Thomas Thomas beer brewer 589978 589978 Thomas, Thomas, of Newenton, Kent, beer brewer 1
5275379 2437869 2437869 defendant Tomas Thomas beer brewer 589978 589978 Tomas, Thomas, of Newenton, Kent, beer brewer 2
5295846 2443775 2443775 defendant Anger or Auger Henry esq 589978 589978 Anger or Auger, Henry, of Newenton, Kent, esq 3
5297866 2444382 2444382 defendant Geffrey John smith 589978 589978 Geffrey, John, of Newenton, Kent, smith 3

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