names

27 rows where place_id = 611723

✎ 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
3689797 1922965 1922965 defendant Worth John husbandman 611723 611723 Worth, John, of South Normanton, husbandman 0
3801728 1958435 1958435 defendant Lie Thomas husbandman 611723 611723 Lie, Thomas, of South Normanton, husbandman 0
3900299 1990332 1990332 defendant Legh Thomas husbandman 611723 611723 Legh, Thomas, of South Normanton, husbandman 0
3914123 1995069 1995069 defendant Legh Thomas husbandman 611723 611723 Legh, Thomas, of South Normanton, husbandman 0
3914124 1995069 1995069 defendant Whytworth Richard husbandman 611723 611723 Whytworth, Richard, of South Normanton, husbandman 1
3914125 1995069 1995069 defendant Buggy Henry husbandman 611723 611723 Buggy, Henry, of South Normanton, husbandman 2
3914126 1995069 1995069 defendant Pypes Richard husbandman 611723 611723 Pypes, Richard, of South Normanton, husbandman 3
3958246 2009957 2009957 defendant Revell Edward gent 611723 611723 Revell, Edward, of South Normanton, gent 0
4026016 2033951 2033951 defendant Lee John husbandman 611723 611723 Lee, John, of South Normanton, husbandman 2
4026017 2033951 2033951 defendant Buggye Henry husbandman 611723 611723 Buggye, Henry, of South Normanton, husbandman 3
4207577 2098210 2098210 defendant Stevenson James clerk 611723 611723 Stevenson, James, of South Normanton, clerk 0
4214779 2100675 2100675 defendant Robenson Nicholas husbandman 611723 611723 Robenson, Nicholas, of South Normanton, husbandman 1
4271163 2119930 2119930 defendant Cooke Thomas husbandman 611723 611723 Cooke, Thomas, of South Normanton, husbandman 0
4271164 2119930 2119930 defendant Robinson Nicholas husbandman 611723 611723 Robinson, Nicholas, of South Normanton, husbandman 1
4280288 2123009 2123009 defendant Dobb John husbandman 611723 611723 Dobb, John, of South Normanton, husbandman 3
4281141 2123308 2123308 defendant Woode Hugh yeoman 611723 611723 Woode, Hugh, of South Normanton, yeoman 0
4299239 2129823 2129823 defendant Robinson Nicholas husbandman 611723 611723 Robinson, Nicholas, of South Normanton, husbandman 0
4300490 2130268 2130268 defendant Lee John husbandman 611723 611723 Lee, John, of South Normanton, husbandman 1
4300491 2130268 2130268 defendant Robynson Nicholas husbandman 611723 611723 Robynson, Nicholas, of South Normanton, husbandman 2
4379510 2157756 2157756 defendant Stephenson William yeoman 611723 611723 Stephenson, William, of South Normanton, yeoman 2
4409531 2167783 2167783 defendant Stephenson William yeoman 611723 611723 Stephenson, William, of South Normanton, yeoman 2
5321691 2451562 2451562 defendant Otwey John yeoman 611723 611723 Otwey, John, of South Normanton, yeoman 1
5375706 2467992 2467992 defendant Bolyngton Richard   611723 611723 Bolyngton, Richard, of South Normanton, parson 0
5375736 2468003 2468003 defendant Bolyngton Richard   611723 611723 Bolyngton, Richard, of South Normanton, parson 0
5472933 2496862 2496862 defendant Bolyngton Richard husbandman 611723 611723 Bolyngton, Richard, of South Normanton, husbandman 1
5491101 2502235 2502235 defendant Walker Robert husbandman 611723 611723 Walker, Robert, of South Normanton, husbandman 0
5500591 2505113 2505113 defendant Oteway John yeoman 611723 611723 Oteway, John, of South Normanton, 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);