names

60 rows where place_id = 598307

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3631919 1904794 1904794 defendant Clerke William husbandman 598307 598307 Clerke, William, of Stokesby, husbandman 0
3674360 1918025 1918025 defendant Clere Edmund esq 598307 598307 Clere, Edmund, of Stokesby, esq 0
3701577 1926742 1926742 defendant Clere Edmund esq 598307 598307 Clere, Edmund, of Stokesby, esq 0
3715189 1931043 1931043 defendant Clere Edmund esq 598307 598307 Clere, Edmund, of Stokesby, esq 0
3730656 1935823 1935823 defendant Clere Edmund esq 598307 598307 Clere, Edmund, of Stokesby, esq 0
3736942 1937803 1937803 defendant Clere Edmund esq 598307 598307 Clere, Edmund, of Stokesby, esq 1
3736948 1937804 1937804 defendant Clere Edmund esq 598307 598307 Clere, Edmund, of Stokesby, esq 1
3744414 1940154 1940154 defendant Faconer John husbandman 598307 598307 Faconer, John, of Stokesby, husbandman 3
3753972 1943192 1943192 defendant Berney William yeoman 598307 598307 Berney, William, of Stokesby, yeoman 0
3769644 1948163 1948163 defendant Clere Edmund esq 598307 598307 Clere, Edmund, of Stokesby, esq 0
3785894 1953380 1953380 defendant Clere Edmund esq 598307 598307 Clere, Edmund, of Stokesby, esq 0
3786031 1953424 1953424 defendant Clere Edmund esq 598307 598307 Clere, Edmund, of Stokesby, esq 0
3792929 1955643 1955643 defendant Clere Edmund esq 598307 598307 Clere, Edmund, of Stokesby, esq 0
3832777 1968180 1968180 defendant Clere Edward esq 598307 598307 Clere, Edward, of Stokesby, esq 0
3833308 1968345 1968345 defendant Clere Edward esq 598307 598307 Clere, Edward, of Stokesby, esq 0
3834364 1968691 1968691 defendant Clere Edward esq 598307 598307 Clere, Edward, of Stokesby, esq 0
3838645 1970012 1970012 defendant Clere Edward gent 598307 598307 Clere, Edward, of Stokesby, gent 0
3860905 1977136 1977136 defendant Clere Edward esq 598307 598307 Clere, Edward, of Stokesby, esq 1
3937120 2002751 2002751 defendant Jerney Edward gent 598307 598307 Jerney, Edward, of Stokesby, gent 1
3937121 2002751 2002751 defendant Founteyne George gent 598307 598307 Founteyne, George, of Stokesby, gent 2
3937125 2002752 2002752 defendant Jermy Edward gent 598307 598307 Jermy, Edward, of Stokesby, gent 2
3937126 2002752 2002752 defendant Fountyn George gent 598307 598307 Fountyn, George, of Stokesby, gent 3
3983307 2018802 2018802 defendant Studborne Barnard clerk 598307 598307 Studborne, Barnard, of Stokesby, clerk 0
3983315 2018803 2018803 defendant Fox John yeoman 598307 598307 Fox, John, of Stokesby, yeoman 4
4016398 2030566 2030566 plaintiff Stone William   598307 598307 Stone, William, of Stokesby 0
4180299 2088588 2088588 defendant Sawyer Richard bootman 598307 598307 Sawyer, Richard, of Stokesby, bootman 0
4180300 2088588 2088588 defendant Buxton Simon husbandman 598307 598307 Buxton, Simon, of Stokesby, husbandman 1
4314565 2135207 2135207 defendant Manthropp Margaret widow 598307 598307 Manthropp, Margaret, of Stokesby, widow 4
4335008 2141977 2141977 defendant Clere Thomas esq 598307 598307 Clere, Thomas, of Stokesby, esq 0
4339180 2143465 2143465 defendant Heyward Richard yeoman 598307 598307 Heyward, Richard, of Stokesby, yeoman 0
4399029 2164256 2164256 defendant Clere Thomas esq 598307 598307 Clere, Thomas, of Stokesby, esq 0
4528484 2209189 2209189 defendant Welman John   598307 598307 Welman, John, of Stokesby 0
4574888 2223672 2223672 defendant Salle Mathew   598307 598307 Salle, Mathew, of Stokesby, parson 2
4579868 2225189 2225189 defendant Tyrman Henry   598307 598307 Tyrman, Henry, of Stokesby 0
4586891 2227299 2227299 plaintiff Holesle John de   598307 598307 Holesle, John de, of Stokesby 0
4679472 2259195 2259195 defendant Roman William husbandman 598307 598307 with Roman, William, of Stokesby, husbandman 5
4720094 2271628 2271628 defendant Collesson John chaplain 598307 598307 Collesson, John, of Stokesby, chaplain 0
4753848 2281581 2281581 defendant Reman William yeoman 598307 598307 Reman, William, of Stokesby, yeoman 0
4771429 2287045 2287045 defendant Drye John yeoman 598307 598307 Drye, John, of Stokesby, yeoman 5
4964355 2346253 2346253 defendant Avot John husbandman 598307 598307 Avot, John, of Stokesby, husbandman 0
5098597 2386022 2386022 defendant Spencer William yeoman 598307 598307 Spencer, William, of Stokesby, yeoman 1
5107871 2388738 2388738 defendant Hert William husbandman 598307 598307 Hert, William, of Stokesby, husbandman 1
5112612 2390073 2390073 defendant Clere Edmund esq 598307 598307 Clere, Edmund, of Stokesby, esq 0
5200424 2415885 2415885 defendant Clere Edmund   598307 598307 Clere, Edmund, of Stokesby 4
5215084 2420136 2420136 plaintiff Clere Edmund esq 598307 598307 Clere, Edmund, of Stokesby, esq 1
5229421 2424214 2424214 defendant Clere Edmund esq 598307 598307 Clere, Edmund, of Stokesby, esq 0
5262212 2433930 2433930 defendant Hert William mercer 598307 598307 Hert, William, of Stokesby, mercer 1
5262265 2433947 2433947 defendant Baker Richard yeoman 598307 598307 Baker, Richard, of Stokesby, yeoman 0
5262266 2433947 2433947 defendant Hawe Robert yeoman 598307 598307 Hawe, Robert, of Stokesby, yeoman 1
5355714 2461865 2461865 defendant Clere Edmund esq 598307 598307 Clere, Edmund, of Stokesby, esq 0
5411184 2478304 2478304 plaintiff Clere Edmund esq 598307 598307 Clere, Edmund, of Stokesby, esq 0
5425362 2482559 2482559 plaintiff Clere Robert esq 598307 598307 Clere, Robert, of Stokesby, esq 0
5425364 2482560 2482560 plaintiff Clere Robert esq 598307 598307 Clere, Robert, of Stokesby, esq 0
5443885 2488089 2488089 plaintiff Clere Edmund esq 598307 598307 Clere, Edmund, of Stokesby, esq 0
5468477 2495514 2495514 plaintiff Clere Edmund esq 598307 598307 Clere, Edmund, of Stokesby, esq 0
5479613 2498915 2498915 plaintiff Clere Edmund esq 598307 598307 Clere, Edmund, of Stokesby, esq 0
5566169 2524701 2524701 defendant Ederych Thomas husbandman 598307 598307 Ederych, Thomas, of Stokesby, husbandman 0
5566170 2524701 2524701 defendant Ederych Sebastian husbandman 598307 598307 Ederych, Sebastian, of Stokesby, husbandman 1
5605404 2536569 2536569 defendant Sweyn Richard   598307 598307 Sweyn, Richard, of Stokesby 0
5623678 2551342 2551342 defendant Elys John husbandman 598307 598307 Elys, John, of Stokesby, husbandman 4

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