names

28 rows where place_id = 615097

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3707151 1928524 1928524 defendant Barnby Charles esq 615097 615097 Barnby, Charles, of Calthorn, esq 1
4441403 2182252 2182252 defendant Dobson John, junior   615097 615097 Dobson, John, junior, of Calthorn 1
4478799 2194039 2194039 defendant Dobson Alan   615097 615097 Dobson, Alan, of Calthorn, son of John 1
4498062 2200042 2200042 plaintiff Faldewe Richard   615097 615097 Faldewe, Richard, of Calthorn, on his own account 0
4499497 2200490 2200490 defendant Scorer William, junior   615097 615097 Scorer, William, junior, of Calthorn 0
4550907 2216220 2216220 defendant Chalesworth John   615097 615097 Chalesworth, John, of Calthorn 0
4606782 2233235 2233235 defendant Litster John   615097 615097 Litster, John, of Calthorn 1
4669951 2256298 2256298 defendant Holgreve John cooper 615097 615097 Holgreve, John, of Calthorn, cooper 0
4731211 2274960 2274960 defendant Sketyard Robert smith 615097 615097 Sketyard, Robert, of Calthorn, smith 3
4787327 2292107 2292107 defendant Mason Robert smith 615097 615097 Mason, Robert, of Calthorn, smith 1
4936255 2337737 2337737 defendant Rede Robert yeoman 615097 615097 Rede, Robert, of Calthorn, yeoman 0
4954335 2343266 2343266 defendant Metheley John husbandman 615097 615097 Metheley, John, of Calthorn, husbandman 1
4954336 2343266 2343266 defendant Waynwright John husbandman 615097 615097 Waynwright, John, of Calthorn, husbandman 2
4957268 2344138 2344138 defendant Kellet Robert shoemaker 615097 615097 Kellet, Robert, of Calthorn, shoemaker 2
4957269 2344138 2344138 defendant Pierson William shoemaker 615097 615097 Pierson, William, of Calthorn, shoemaker 3
4957273 2344139 2344139 defendant Kellet Robert shoemaker 615097 615097 Kellet, Robert, of Calthorn, shoemaker 2
4957274 2344139 2344139 defendant Pierson William shoemaker 615097 615097 Pierson, William, of Calthorn, shoemaker 3
5052373 2372308 2372308 defendant Peirson William shoemaker 615097 615097 Peirson, William, of Calthorn, shoemaker 0
5088028 2382873 2382873 defendant Kenet Robert shoemaker 615097 615097 Kenet, Robert, of Calthorn, shoemaker 0
5107013 2388480 2388480 defendant Kelet Robert cordwainer 615097 615097 Kelet, Robert, of Calthorn, cordwainer 2
5143463 2399221 2399221 defendant Wylson Robert husbandman 615097 615097 Wylson, Robert, of Calthorn, husbandman 0
5164677 2405404 2405404 defendant Wylson Robert husbandman 615097 615097 Wylson, Robert, of Calthorn, husbandman 0
5178064 2409287 2409287 defendant Wilson Robert husbandman 615097 615097 Wilson, Robert, of Calthorn, husbandman 0
5178067 2409288 2409288 defendant Wilson Robert husbandman 615097 615097 Wilson, Robert, of Calthorn, husbandman 0
5235372 2425927 2425927 defendant Kelette Robert corveser 615097 615097 Kelette, Robert, of Calthorn, corveser 3
5316286 2449957 2449957 defendant Yongsmyth John   615097 615097 Yongsmyth, John, of Calthorn, blade smith 2
5592186 2532551 2532551 plaintiff Walkar William   615097 615097 Walkar, William, of Calthorn 0
5618824 2549726 2549726 defendant Dobson John   615097 615097 Dobson, John, of Calthorn 2

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