names

22 rows where place_id = 623677

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3753675 1943091 1943091 defendant Russell Richard yeoman 623677 623677 Russell, Richard, of Kings Bromley, yeoman 2
3753676 1943091 1943091 defendant Crosse William yweoman 623677 623677 Crosse, William, of Kings Bromley, yweoman 3
3756060 1943851 1943851 defendant More John husbandman 623677 623677 More, John, of Kings Bromley, husbandman 1
3756061 1943851 1943851 defendant Corbet Thomas yeoman 623677 623677 Corbet, Thomas, of Kings Bromley, yeoman 2
3756062 1943851 1943851 defendant Walker Ralph husbandman 623677 623677 Walker, Ralph, of Kings Bromley, husbandman 3
3799533 1957773 1957773 defendant Mote Ralph husbandman 623677 623677 Mote, Ralph, of Kings Bromley, husbandman 0
4038288 2038330 2038330 defendant Partryche George gent 623677 623677 Partryche, George, of Kings Bromley, gent 0
4095590 2058750 2058750 defendant Parteriche George gent 623677 623677 Parteriche, George, of Kings Bromley, gent 1
4327982 2139680 2139680 defendant Caldwall Thomas yeoman 623677 623677 Caldwall, Thomas, of Kings Bromley, yeoman 0
4327983 2139680 2139680 defendant Sommer Robert yeoman 623677 623677 Sommer, Robert, of Kings Bromley, yeoman 1
4327984 2139680 2139680 defendant Wood Henry yeoman 623677 623677 Wood, Henry, of Kings Bromley, yeoman 2
4327985 2139680 2139680 defendant Woodroff George yeoman 623677 623677 Woodroff, George, of Kings Bromley, yeoman 3
4330096 2140364 2140364 defendant Hunt Edward yeoman 623677 623677 Hunt, Edward, of Kings Bromley, yeoman 0
4805304 2297862 2297862 defendant Haster alice widow 623677 623677 Haster, alice, of Kings Bromley, widow 1
4959418 2344783 2344783 defendant Annesley John chaplain 623677 623677 Annesley, John, of Kings Bromley, chaplain 0
4974855 2349450 2349450 defendant Mitton Richard husbandman 623677 623677 Mitton, Richard, of Kings Bromley, husbandman 0
5347312 2459324 2459324 defendant Crosse John, senior (legal representative) 623677 623677 Crosse, John, senior, of Kings Bromley, executors of 0
5347313 2459324 2459324 defendant Crosse Joan widow 623677 623677 (Crosse, Joan, of Kings Bromley, widow 1
5347314 2459324 2459324 defendant Crosse Thomas husbandman 623677 623677 Crosse, Thomas, of Kings Bromley, husbandman 2
5417831 2480258 2480258 defendant Auley Thomas husbandman 623677 623677 Auley, Thomas, of Kings Bromley, husbandman 0
5474077 2497224 2497224 defendant Lynton Thomas yeoman 623677 623677 Lynton, Thomas, of Kings Bromley, yeoman 1
5563451 2523911 2523911 plaintiff Awbey Thomas   623677 623677 Awbey, Thomas, of Kings Bromley 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);