names

19 rows where place_id = 603750

✎ 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
3655676 1912040 1912040 defendant Borham Thomas yeoman 603750 603750 Borham, Thomas, of Egerton, Kent, yeoman 2
3657551 1912623 1912623 defendant Nyn Robert   603750 603750 Nyn, Robert, of Egerton, Kent 0
3675057 1918229 1918229 defendant Gyll John smith 603750 603750 Gyll, John, of Egerton, Kent, smith 1
3759547 1944978 1944978 defendant Peers Robert gent 603750 603750 Peers, Robert, of Egerton, Kent, gent 0
3759549 1944979 1944979 defendant Peers Robert gent 603750 603750 Peers, Robert, of Egerton, Kent, gent 0
3759943 1945106 1945106 defendant Peers Robert gent 603750 603750 Peers, Robert, of Egerton, Kent, gent 0
3799206 1957663 1957663 defendant Hunt John chapman 603750 603750 Hunt, John, of Egerton, Kent, chapman 1
3799210 1957664 1957664 defendant Hunt John chapman 603750 603750 Hunt, John, of Egerton, Kent, chapman 1
3800938 1958203 1958203 defendant Hunt John chapman 603750 603750 Hunt, John, of Egerton, Kent, chapman 0
3820567 1964316 1964316 defendant Pers John clothmaker 603750 603750 Pers, John, of Egerton, Kent, clothmaker 0
3842361 1971145 1971145 defendant Borcham Thomas yeoman 603750 603750 Borcham, Thomas, of Egerton, Kent, yeoman 1
3901447 1990707 1990707 defendant Monnes Robert clothier 603750 603750 Monnes, Robert, of Egerton, Kent, clothier 1
4140804 2074948 2074948 defendant Motte Robert yeoman 603750 603750 Motte, Robert, of Egerton, Kent, yeoman 0
4140809 2074949 2074949 defendant Spice Robert yeoman 603750 603750 Spice, Robert, of Egerton, Kent, yeoman 1
4140860 2074968 2074968 defendant Mette Robert yeoman 603750 603750 Mette, Robert, of Egerton, Kent, yeoman 0
4341376 2144261 2144261 defendant Carter William gent 603750 603750 Carter, William, of Egerton, Kent, gent 0
4382107 2158705 2158705 defendant Bridge Abel clothier 603750 603750 Bridge, Abel, of Egerton, Kent, clothier 0
5396345 2474047 2474047 defendant Knokke Nicholas butcher 603750 603750 Knokke, Nicholas, of Egerton, Kent, butcher 0
5409653 2477858 2477858 defendant Knokke Nicholas butcher 603750 603750 Knokke, Nicholas, of Egerton, Kent, butcher 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);