names

15 rows where place_id = 617569

✎ 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
3720180 1932587 1932587 defendant Roberdys John husbandman 617569 617569 Roberdys, John, of Rayley, Essex, husbandman 1
3720189 1932589 1932589 defendant Roberdys John husbandman 617569 617569 Roberdys, John, of Rayley, Essex, husbandman 1
3731736 1936155 1936155 defendant Trafforth Edward yeoman 617569 617569 Trafforth, Edward, of Rayley, Essex, yeoman 0
3827748 1966545 1966545 defendant Aleyn Thomas yeoman of the crown 617569 617569 Aleyn, Thomas, of Rayley, Essex, yeoman of the crown 2
3838535 1969977 1969977 defendant Aleyn Thomas gent 617569 617569 Aleyn, Thomas, of Rayley, Essex, gent 0
3910772 1993924 1993924 defendant Brownyng John sherman 617569 617569 Brownyng, John, of Rayley, Essex, sherman 1
3934661 2001887 2001887 defendant Stevens Robert yeoman 617569 617569 Stevens, Robert, of Rayley, Essex, yeoman 1
4131878 2071713 2071713 defendant Dadcocke Richard chapman 617569 617569 Dadcocke, Richard, of Rayley, Essex, chapman 3
4356284 2149423 2149423 defendant Berye Benjamin yeoman 617569 617569 Berye, Benjamin, of Rayley, Essex, yeoman 0
4402047 2165274 2165274 defendant French Humphrey gent 617569 617569 French, Humphrey, of Rayley, Essex, gent 1
4735850 2276362 2276362 defendant Barrenton John gent 617569 617569 Barrenton, John, of Rayley, Essex, gent 0
5099152 2386176 2386176 defendant Weld John draper 617569 617569 Weld, John, of Rayley, Essex, draper 1
5099179 2386183 2386183 defendant Weld John husbandman 617569 617569 Weld, John, of Rayley, Essex, husbandman 1
5287922 2441482 2441482 defendant Bode John husbandman 617569 617569 Bode, John, of Rayley, Essex, husbandman 3
5287930 2441484 2441484 defendant Bode John husbandman 617569 617569 Bode, John, of Rayley, Essex, husbandman 1

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