names

20 rows where place_id = 617066

✎ 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
3717640 1931813 1931813 defendant Hampton Christopher yeoman 617066 617066 Hampton, Christopher, of Southwark St George, yeoman 0
4016803 2030707 2030707 defendant Loveles William gent 617066 617066 Loveles, William, of Southwark St George, gent 0
4154211 2079568 2079568 defendant Fetherston Anthony yeoman 617066 617066 Fetherston, Anthony, of Southwark St George, yeoman 0
4206648 2097865 2097865 defendant Beconsawe John esq 617066 617066 Beconsawe, John, of Southwark St George, esq 0
4224313 2103988 2103988 defendant Sharpe John merchant 617066 617066 Sharpe, John, of Southwark St George, or of London, merchant 0
4236586 2108370 2108370 defendant Pestell William innholder 617066 617066 Pestell, William, of Southwark St George, innholder 0
4240836 2109919 2109919 defendant Gardyner Thomas gent 617066 617066 Gardyner, Thomas, of Southwark St George, or of London, gent 0
4312980 2134663 2134663 defendant Pattenson Brian vintner 617066 617066 Pattenson, Brian, of Southwark St George, vintner 0
4313146 2134713 2134713 defendant Fowllell Richard chapman 617066 617066 Fowllell, Richard, of Southwark St George, chapman 1
4328332 2139792 2139792 defendant Nevell Alexander gent 617066 617066 Nevell, Alexander, of Southwark St George, gent 1
4343730 2145086 2145086 defendant Peterson William carpenter 617066 617066 Peterson, William, of Southwark St George, carpenter 0
4343731 2145086 2145086 defendant Asheley John gent 617066 617066 Asheley, John, of Southwark St George, gent 1
4343732 2145086 2145086 defendant Parramore Richard carpenter 617066 617066 Parramore, Richard, of Southwark St George, carpenter 2
4360876 2151058 2151058 defendant Hyggens Mary widow 617066 617066 Mary his wife, formerly Mary Eaton, of Southwark St George, widow 1
4367558 2153453 2153453 defendant Peterson William gent 617066 617066 Peterson, William, of Southwark St George, gent 0
4367559 2153453 2153453 defendant Asheley John gent 617066 617066 Asheley, John, of Southwark St George, gent 1
4367560 2153453 2153453 defendant Parramore Richard carpenter 617066 617066 Parramore, Richard, of Southwark St George, carpenter 2
4380774 2158237 2158237 defendant Rodes William   617066 617066 Rodes, William, of Southwark St George, brick maker, administrators of 0
4391726 2161853 2161853 defendant Martyn Edmund yeoman 617066 617066 Martyn, Edmund, of Southwark St George, yeoman 1
4394926 2162889 2162889 defendant Somner William victualer 617066 617066 Somner, William, of Southwark St George, victualer 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);