names

43 rows where place_id = 608576

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3674288 1918002 1918002 defendant Stork Tristan gent 608576 608576 Stork, Tristan, of Trent, gent 0
3882130 1984281 1984281 defendant Dole James clerk 608576 608576 Dole, James, of Trent, clerk 0
3939047 2003390 2003390 defendant (illegible) (illegible) yeoman 608576 608576 ---,---, of Trent, yeoman 0
3952107 2007807 2007807 defendant Raynold John gent 608576 608576 Raynold, John, of Trent, gent 0
3952109 2007808 2007808 defendant Raynold John gent 608576 608576 Raynold, John, of Trent, gent 0
3957929 2009836 2009836 defendant Fantleroye Edward gent 608576 608576 Fantleroye, Edward, of Trent, gent 0
3993888 2022564 2022564 defendant Francis Robert husbandman 608576 608576 Francis, Robert, of Trent, husbandman 1
3993891 2022565 2022565 defendant Francis Robert husbandman 608576 608576 Francis, Robert, of Trent, husbandman 1
3996570 2023533 2023533 defendant Fraunces alias Jaye Richard husbandman 608576 608576 Fraunces alias Jaye, Richard, of Trent, husbandman 0
4055949 2044507 2044507 defendant Hurrowe Edward husbandman 608576 608576 Hurrowe, Edward, of Trent, husbandman 0
4314664 2135242 2135242 defendant Knowlte Thomas husbandman 608576 608576 Knowlte, Thomas, of Trent, husbandman 0
4346877 2146162 2146162 defendant Frances Nicholas husbandman 608576 608576 Frances, Nicholas, of Trent, husbandman 0
4544461 2214179 2214179 defendant Draper William   608576 608576 Draper, William, of Trent 0
4596532 2230153 2230153 defendant Draper Alice   608576 608576 Draper, Alice, of Trent 4
4601700 2231748 2231748 defendant Geffray William   608576 608576 Geffray, William, of Trent 2
4602419 2231975 2231975 defendant Loukere William   608576 608576 Loukere, William, of Trent 0
4602438 2231982 2231982 defendant Loukere Richard   608576 608576 Loukere, Richard, of Trent 0
4628922 2239977 2239977 defendant Jolyf John   608576 608576 Jolyf, John, of Trent 0
4631390 2240708 2240708 defendant Kenton Adam   608576 608576 Kenton, Adam, of Trent 0
4660561 2249128 2249128 defendant Kenton Adam husbandman 608576 608576 Kenton, Adam, of Trent, husbandman 0
4679861 2259307 2259307 defendant Harewell Richard   608576 608576 Harewell, Richard, of Trent, parson 0
4679862 2259307 2259307 defendant Byour atte Splotte John husbandman 608576 608576 Byour atte Splotte, John, of Trent, husbandman 1
4681871 2259944 2259944 defendant Spencer John, senior   608576 608576 Spencer, John, senior, of Trent 0
4681872 2259944 2259944 defendant Spencer John, junior   608576 608576 Spencer, John, junior, of Trent 1
4708358 2267985 2267985 defendant Saundres Richard husbandman 608576 608576 Saundres, Richard, of Trent, husbandman 4
4943254 2339861 2339861 defendant Homer Stephen yeoman 608576 608576 Homer, Stephen, of Trent, yeoman 2
4953490 2343012 2343012 defendant Saunder Richard husbandman 608576 608576 Saunder, Richard, of Trent, husbandman 0
4965309 2346545 2346545 defendant Peremptorye John   608576 608576 Peremptorye, John, of Trent, mason 1
4971303 2348352 2348352 defendant Maudyt John yeoman 608576 608576 Maudyt, John, of Trent, yeoman 0
5009878 2359766 2359766 defendant Smyth Thomas smith 608576 608576 Smyth, Thomas, of Trent, smith 0
5009879 2359766 2359766 defendant Stegge Henry husbandman 608576 608576 Stegge, Henry, of Trent, husbandman 1
5009880 2359766 2359766 defendant Geffreys John husbandman 608576 608576 Geffreys, John, of Trent, husbandman 2
5009881 2359766 2359766 defendant Permanter John husbandman 608576 608576 Permanter, John, of Trent, husbandman 3
5009882 2359766 2359766 defendant Strange John husbandman 608576 608576 Strange, John, of Trent, husbandman 4
5076051 2379335 2379335 defendant Wodyll John yeoman 608576 608576 Wodyll, John, of Trent, yeoman 0
5087507 2382725 2382725 defendant Wodehele John husbandman 608576 608576 Wodehele, John, of Trent, husbandman 0
5226969 2423543 2423543 defendant Permyter John   608576 608576 Permyter, John, of Trent, mason 7
5226970 2423543 2423543 defendant Permyter William laborer 608576 608576 Permyter, William, of Trent, laborer 8
5226971 2423543 2423543 defendant Moure William laborer 608576 608576 Moure, William, of Trent, laborer 9
5226972 2423543 2423543 defendant Broun Thomas laborer 608576 608576 Broun, Thomas, of Trent, laborer 10
5553370 2521026 2521026 defendant Stegge Nicholas husbandman 608576 608576 Stegge, Nicholas, of Trent, husbandman 0
5553814 2521153 2521153 defendant Stegge Nicholas husbandman 608576 608576 Stegge, Nicholas, of Trent, husbandman 0
5603102 2535856 2535856 defendant Storke Tristram gent 608576 608576 Storke, Tristram, of Trent, gent 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);