names

34 rows where place_id = 601869

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3647378 1909567 1909567 defendant Scot John gent 601869 601869 Scot, John, of Camberwell, gent 0
3708617 1928994 1928994 defendant Scott John esq 601869 601869 Scott, John, of Camberwell, esq 4
3727393 1934841 1934841 defendant Webster John yeoman 601869 601869 Webster, John, of Camberwell, yeoman 1
3741517 1939220 1939220 defendant Ode Henry husbandman 601869 601869 Ode, Henry, of Camberwell, husbandman 0
3741522 1939221 1939221 defendant Ode Henry husbandman 601869 601869 Ode, Henry, of Camberwell, husbandman 0
3743051 1939675 1939675 defendant Scott John esq 601869 601869 Scott, John, of Camberwell, esq 3
3788912 1954343 1954343 defendant Ode Henry yeoman 601869 601869 Ode, Henry, of Camberwell, yeoman 2
3915887 1995694 1995694 plaintiff Draper Robert   601869 601869 Draper, Robert, of Camberwell 0
4147468 2077255 2077255 defendant Awberye John gent 601869 601869 Awberye, John, of Camberwell, gent 2
4762982 2284406 2284406 defendant Aleyn Laurence husbandman 601869 601869 Aleyn, Laurence, of Camberwell, husbandman 0
4893741 2324736 2324736 defendant Middylton John yeoman 601869 601869 Middylton, John, of Camberwell, yeoman 1
5059540 2374425 2374425 defendant Otteley William husbandman 601869 601869 Otteley, William, of Camberwell, husbandman 1
5067353 2376743 2376743 defendant Pynchon William husbandman 601869 601869 Pynchon, William, of Camberwell, husbandman 0
5067354 2376743 2376743 defendant Mathew Peter husbandman 601869 601869 Mathew, Peter, of Camberwell, husbandman 1
5141832 2398727 2398727 defendant Goodson Nicholas husbandman 601869 601869 Goodson, Nicholas, of Camberwell, husbandman 0
5143198 2399145 2399145 defendant Maynell John esq 601869 601869 Maynell, John, of Camberwell, esq 0
5177849 2409224 2409224 defendant Maynell John esq 601869 601869 Maynell, John, of Camberwell, esq 0
5187360 2412028 2412028 plaintiff Otteley William   601869 601869 Otteley, William, of Camberwell 1
5187363 2412029 2412029 plaintiff Otteley William   601869 601869 Otteley, William, of Camberwell 1
5189074 2412536 2412536 defendant Ottley William yeoman 601869 601869 Ottley, William, of Camberwell, yeoman 3
5189360 2412622 2412622 defendant Webbe William husbandman 601869 601869 Webbe, William, of Camberwell, husbandman 1
5192923 2413654 2413654 defendant Lepham Thomas husbandman 601869 601869 Lepham, Thomas, of Camberwell, husbandman 0
5207923 2418049 2418049 defendant Lopham Thomas husbandman 601869 601869 Lopham, Thomas, of Camberwell, husbandman 0
5290736 2442293 2442293 defendant Scotte John gent 601869 601869 together with Scotte, John, of Camberwell, gent 1
5290743 2442294 2442294 defendant Scotte John gent 601869 601869 Scotte, John, of Camberwell, gent 0
5420887 2481176 2481176 defendant Knyght John husbandman 601869 601869 Knyght, John, of Camberwell, husbandman 0
5439969 2486899 2486899 defendant Knyght John husbandman 601869 601869 Knyght, John, of Camberwell, husbandman 0
5439976 2486900 2486900 defendant Knyght John husbandman 601869 601869 Knyght, John, of Camberwell, husbandman 0
5453515 2490945 2490945 defendant Knight John husbandman 601869 601869 Knight, John, of Camberwell, husbandman 0
5465413 2494566 2494566 defendant Knyght John husbandman 601869 601869 Knyght, John, of Camberwell, husbandman 0
5465420 2494567 2494567 defendant Knyght John husbandman 601869 601869 Knyght, John, of Camberwell, husbandman 0
5476907 2498098 2498098 defendant Knyght John husbandman 601869 601869 Knyght, John, of Camberwell, husbandman 0
5550675 2520224 2520224 defendant Heggelond Agnes widow 601869 601869 Heggelond, Agnes, of Camberwell, widow 1
5580814 2529078 2529078 defendant Heggelond Agnes widow 601869 601869 Heggelond, Agnes, of Camberwell, widow 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);