names

68 rows where place_id = 605880

✎ 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
3663247 1914430 1914430 plaintiff Palton Nicholas yeoman 605880 605880 Palton, Nicholas, of Soham, yeoman 0
3663249 1914431 1914431 plaintiff Palton Nicholas yeoman 605880 605880 Palton, Nicholas, of Soham, yeoman 0
3663251 1914432 1914432 plaintiff Palton Nicholas yeoman 605880 605880 Palton, Nicholas, of Soham, yeoman 0
3669465 1916388 1916388 defendant Norfolke Edward husbandman 605880 605880 Norfolke, Edward, of Soham, husbandman 0
3677103 1918879 1918879 plaintiff Langrod John   605880 605880 Langrod, John, of Soham 0
3743158 1939722 1939722 defendant Chapman William yeoman 605880 605880 Chapman, William, of Soham, yeoman 0
3744897 1940305 1940305 defendant Wright William husbandman 605880 605880 Wright, William, of Soham, husbandman 0
3795415 1956438 1956438 defendant Leke Edmund husbandman 605880 605880 Leke, Edmund, of Soham, husbandman 0
3812218 1961725 1961725 defendant Gunston Richard master of arts 605880 605880 Gunston, Richard, of Soham, clerk, master of arts 1
3841497 1970921 1970921 plaintiff Bestney Edward yeoman 605880 605880 Bestney, Edward, of Soham, yeoman 0
3866160 1978911 1978911 defendant Bocher John butcher 605880 605880 Bocher, John, of Soham, butcher 0
3883311 1984684 1984684 defendant Harman William husbandman 605880 605880 Harman, William, of Soham, husbandman 0
3887509 1986077 1986077 defendant White Richard husbandman 605880 605880 White, Richard, of Soham, husbandman 0
3905175 1991994 1991994 defendant Salusbury Robert yeoman 605880 605880 Salusbury, Robert, of Soham, yeoman 0
3969456 2013924 2013924 defendant Cropley John husbandman 605880 605880 Cropley, John, of Soham, husbandman 1
3971012 2014419 2014419 defendant Maxy alias Mackerell John yeoman 605880 605880 Maxy alias Mackerell, John, of Soham, yeoman 0
3971013 2014419 2014419 defendant Bearnes Edward yeoman 605880 605880 Bearnes, Edward, of Soham, yeoman 1
4058697 2045502 2045502 defendant Potter Thomas yeoman 605880 605880 Potter, Thomas, of Soham, yeoman 0
4079681 2053032 2053032 defendant Desborough William miller 605880 605880 Desborough, William, of Soham, miller 0
4120442 2067588 2067588 defendant Spylman Edward yeoman 605880 605880 Spylman, Edward, of Soham, yeoman 0
4120444 2067589 2067589 defendant Voyce William yeoman 605880 605880 Voyce, William, of Soham, yeoman 0
4289244 2126210 2126210 defendant Peche Robert gent 605880 605880 Peche, Robert, of Soham, gent 0
4293914 2127896 2127896 defendant Carter Robert miller 605880 605880 Carter, Robert, of Soham, miller 0
4293915 2127896 2127896 defendant Carter George miller 605880 605880 Carter, George, of Soham, miller 1
4296826 2128964 2128964 defendant Lowdham Thomas, junior yeoman 605880 605880 Lowdham, Thomas, junior, of Soham, yeoman 0
4296827 2128964 2128964 defendant Gallant William yeoman 605880 605880 Gallant, William, of Soham, yeoman 1
4296828 2128964 2128964 defendant Darbie William yeoman 605880 605880 Darbie, William, of Soham, yeoman 2
4297840 2129333 2129333 defendant Peche Robert gent 605880 605880 Peche, Robert, of Soham, gent 0
4333291 2141417 2141417 defendant Pytches Geoffrey   605880 605880 Pytches, Geoffrey, of Soham, wheelwright 1
4464479 2189557 2189557 defendant Elyof Hugh   605880 605880 Elyof, Hugh, of Soham, servant of John Elyof 0
4493603 2198703 2198703 defendant Waryner John butcher 605880 605880 Waryner, John, of Soham, butcher 0
4505405 2202222 2202222 defendant Waryner John butcher 605880 605880 Waryner, John, of Soham, butcher 1
4696932 2264518 2264518 defendant atte Fen Thomas husbandman 605880 605880 atte Fen, Thomas, of Soham, husbandman 1
4737841 2276939 2276939 plaintiff Warner John   605880 605880 Warner, John, of Soham 0
4737849 2276942 2276942 plaintiff Warner Thomas   605880 605880 Warner, Thomas, of Soham 0
4737850 2276942 2276942 plaintiff Peche Thomas   605880 605880 Peche, Thomas, of Soham 1
4852982 2312354 2312354 defendant Pyngle John, sen tailor 605880 605880 Pyngle, John, sen, of Soham, tailor 0
4852983 2312354 2312354 defendant Broun John tailor 605880 605880 Broun, John, of Soham, tailor 1
4853819 2312606 2312606 defendant Palmere Thomas husbandman 605880 605880 Palmere, Thomas, of Soham, husbandman 0
4853820 2312606 2312606 defendant Yakesley Richard husbandman 605880 605880 Yakesley, Richard, of Soham, husbandman 1
4853821 2312606 2312606 defendant Pyngell John tailor 605880 605880 Pyngell, John, of Soham, tailor 2
4927007 2334874 2334874 defendant Pyng--- John husbandman 605880 605880 Pyng---, John, of Soham, husbandman 2
5044206 2369897 2369897 plaintiff Halle Thomas   605880 605880 Halle, Thomas, of Soham 0
5147623 2400444 2400444 defendant Salysbury John husbandman 605880 605880 Salysbury, John, of Soham, husbandman 0
5167249 2406154 2406154 defendant Salysbury John husbandman 605880 605880 Salysbury, John, of Soham, husbandman 0
5182583 2410660 2410660 defendant Salysbury John husbandman 605880 605880 Salysbury, John, of Soham, husbandman 0
5182585 2410661 2410661 defendant Salysbury John husbandman 605880 605880 Salysbury, John, of Soham, husbandman 0
5182588 2410662 2410662 defendant Salysbury John husbandman 605880 605880 Salysbury, John, of Soham, husbandman 0
5193199 2413740 2413740 defendant Mullyng Henry yeoman 605880 605880 Mullyng, Henry, of Soham, yeoman 1
5283151 2440135 2440135 defendant Peytwyn John yeoman 605880 605880 Peytwyn, John, of Soham, yeoman 1
5283152 2440135 2440135 defendant Reyner John yeoman 605880 605880 Reyner, John, of Soham, yeoman 2
5283173 2440145 2440145 defendant Peytwyn John yeoman 605880 605880 Peytwyn, John, of Soham, yeoman 1
5283174 2440145 2440145 defendant Reyner John yeoman 605880 605880 Reyner, John, of Soham, yeoman 2
5283401 2440199 2440199 defendant Exnyng Richard fisher 605880 605880 Exnyng, Richard, of Soham, fisher 0
5330334 2454149 2454149 defendant Derby John husbandman 605880 605880 Derby, John, of Soham, husbandman 0
5330335 2454149 2454149 defendant Wake John husbandman 605880 605880 Wake, John, of Soham, husbandman 1
5330336 2454149 2454149 defendant Palmer alias Clerke Thomas husbandman 605880 605880 Palmer alias Clerke, Thomas, of Soham, husbandman 2
5341007 2457388 2457388 defendant Besteney Thomas yeoman 605880 605880 Besteney, Thomas, of Soham, yeoman 0
5341008 2457388 2457388 defendant Makere John husbandman 605880 605880 Makere, John, of Soham, husbandman 1
5367240 2465406 2465406 defendant Derby John yeoman 605880 605880 Derby, John, of Soham, yeoman 0
5473308 2496980 2496980 defendant Rodon William clerk 605880 605880 Rodon, William, of Soham, clerk 0
5576217 2527623 2527623 defendant Wake William husbandman 605880 605880 Wake, William, of Soham, husbandman 0
5576218 2527623 2527623 defendant Wake Edmund husbandman 605880 605880 Wake, Edmund, of Soham, husbandman 1
5576219 2527623 2527623 defendant Wake John husbandman 605880 605880 Wake, John, of Soham, husbandman 2
5576221 2527624 2527624 defendant Wake William husbandman 605880 605880 Wake, William, of Soham, husbandman 0
5576222 2527624 2527624 defendant Wake Edmund husbandman 605880 605880 Wake, Edmund, of Soham, husbandman 1
5576223 2527624 2527624 defendant Wake John husbandman 605880 605880 Wake, John, of Soham, husbandman 2
5601840 2535476 2535476 defendant Hervy William yeoman 605880 605880 Hervy, William, of Soham, yeoman 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);