names

60 rows where place_id = 761081

✎ 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
4475951 2193148 2193148 defendant Steven Thomas   761081 761081 Steven, Thomas, of Syleby 0
4504037 2201813 2201813 plaintiff Stevene Thomas   761081 761081 Stevene, Thomas, of Syleby 1
4542129 2213428 2213428 defendant Bocher Walter   761081 761081 Bocher, Walter, of Syleby 0
4542130 2213428 2213428 defendant Taillour John   761081 761081 Taillour, John, of Syleby 1
4548149 2215358 2215358 defendant Pykwell William   761081 761081 Pykwell, William, of Syleby 1
4562915 2219966 2219966 plaintiff Pykwell William   761081 761081 Pykwell, William, of Syleby 0
4562917 2219967 2219967 plaintiff Pykwell William   761081 761081 Pykwell, William, of Syleby 0
4571045 2222513 2222513 defendant Haukyn John   761081 761081 Haukyn, John, of Syleby 0
4571048 2222514 2222514 defendant Shawe Walter   761081 761081 Shawe, Walter, of Syleby 1
4642679 2243974 2243974 defendant Poucrell or Pontrell Robert   761081 761081 Poucrell or Pontrell, Robert, of Syleby 1
4649349 2245860 2245860 defendant Pontrell Robert   761081 761081 Pontrell, Robert, of Syleby 2
4667296 2255499 2255499 defendant Jakson Ralph   761081 761081 Jakson, Ralph, of Syleby, parson 0
4675848 2258055 2258055 defendant Howys John husbandman 761081 761081 Howys, John, of Syleby, husbandman 0
4680038 2259362 2259362 defendant Pykwell Robert husbandman 761081 761081 Pykwell, Robert, of Syleby, husbandman 0
4680044 2259365 2259365 defendant Pykwell John husbandman 761081 761081 Pykwell, John, of Syleby, husbandman 0
4684713 2260821 2260821 defendant Jacson Ralph yeoman 761081 761081 Jacson, Ralph, of Syleby, yeoman 0
4710781 2268728 2268728 defendant Payle Roger husbandman 761081 761081 Payle, Roger, of Syleby, husbandman 0
4710782 2268728 2268728 defendant Payale Simon husbandman 761081 761081 Payale, Simon, of Syleby, husbandman 1
4720871 2271862 2271862 defendant Pountrell Robert husbandman 761081 761081 Pountrell, Robert, of Syleby, husbandman 0
4720872 2271862 2271862 defendant Hecok William husbandman 761081 761081 Hecok, William, of Syleby, husbandman 1
4720873 2271862 2271862 defendant Howes John husbandman 761081 761081 Howes, John, of syleby, husbandman 2
4739143 2277334 2277334 defendant Howes John husbandman 761081 761081 Howes, John, of Syleby, husbandman 1
4742139 2278192 2278192 defendant Couper Roger husbandman 761081 761081 Couper, Roger, of Syleby, husbandman 0
4742155 2278199 2278199 defendant Wynne John husbandman 761081 761081 Wynne, John, of Syleby, husbandman 0
4744059 2278788 2278788 defendant Michell Nicholas husbandman 761081 761081 Michell, Nicholas, of Syleby, husbandman 0
4767370 2285782 2285782 defendant Payle Simon husbandman 761081 761081 Payle, Simon, of Syleby, husbandman 3
4795888 2294864 2294864 defendant Wynne Maud widow 761081 761081 Wynne, Maud, of Syleby, widow 2
4798378 2295680 2295680 defendant Powetrell Robert husbandman 761081 761081 Powetrell, Robert, of Syleby, husbandman 0
4798379 2295680 2295680 defendant Peyle Simon husbandman 761081 761081 Peyle, Simon, of Syleby, husbandman 1
4816781 2301347 2301347 defendant Syleby Ralph de yeoman 761081 761081 Syleby, Ralph de, of Syleby, yeoman 0
4816783 2301348 2301348 defendant Syleby Ralph de yeoman 761081 761081 Syleby, Ralph de, of Syleby, yeoman 0
4832124 2306077 2306077 defendant Launes Geoffrey husbandman 761081 761081 Launes, Geoffrey, of Syleby, husbandman 1
4832125 2306077 2306077 defendant Fox William husbandman 761081 761081 Fox, William, of Syleby, husbandman 2
4892467 2324383 2324383 defendant Burbrygge Robert husbandman 761081 761081 Burbrygge, Robert, of Syleby, husbandman 1
4936278 2337747 2337747 defendant Howes John husbandman 761081 761081 Howes, John, of Syleby, husbandman 0
4957896 2344333 2344333 defendant Thorp John butcher 761081 761081 Thorp, John, of Syleby, son of Thorp, William, of Quenyburgh, Leics, butcher 1
4984986 2352443 2352443 defendant Braunston Thomas miller 761081 761081 Braunston, Thomas, of Syleby, miller 2
4985002 2352445 2352445 defendant Braunston Thomas miller 761081 761081 Braunston, Thomas, of Syleby, miller 2
5016681 2361769 2361769 defendant Payle Ralph husbandman 761081 761081 Payle, Ralph, of Syleby, husbandman 0
5019214 2362509 2362509 defendant Howes John husbandman 761081 761081 Howes, John, of Syleby, husbandman 4
5057876 2373927 2373927 defendant Salysbury John husbandman 761081 761081 Salysbury, John, of Syleby, husbandman 0
5059490 2374407 2374407 defendant Millyng Richard husbandman 761081 761081 Millyng, Richard, of Syleby, husbandman 0
5109772 2389287 2389287 defendant Couper William husbandman 761081 761081 Couper, William, of Syleby, husbandman 0
5198898 2415429 2415429 defendant Elyot William (legal representative) 761081 761081 Elyot, William, of Syleby, walker, executrix of 2
5198899 2415429 2415429 defendant Elyot Joan widow 761081 761081 Elyot, Joan, of Syleby, widow 3
5234569 2425697 2425697 plaintiff Cowper John   761081 761081 Cowper, John, of Syleby 0
5234570 2425697 2425697 plaintiff Michell Richard   761081 761081 Michell, Richard, of Syleby 1
5246790 2429224 2429224 defendant Daukes James yeoman 761081 761081 Daukes, James, of Syleby, yeoman 2
5295649 2443718 2443718 defendant Millyng Robert yeoman 761081 761081 Millyng, Robert, of Syleby, yeoman 0
5392545 2472937 2472937 defendant Bukkerfeld John butcher 761081 761081 Bukkerfeld, John, of Syleby, butcher 2
5419184 2480665 2480665 defendant Braunston John   761081 761081 Braunston, John, of Syleby 0
5436660 2485892 2485892 defendant Bukkerfeld John butcher 761081 761081 Bukkerfeld, John, of Syleby, butcher 2
5437351 2486116 2486116 defendant Braunston John smith 761081 761081 Braunston, John, of Syleby, smith 0
5451768 2490403 2490403 defendant Braunston John smith 761081 761081 Braunston, John, of Syleby, smith 0
5451770 2490404 2490404 defendant Braunston John smith 761081 761081 Braunston, John, of Syleby, smith 0
5625941 2552069 2552069 defendant Jakson Ralph husbandman 761081 761081 Jakson, Ralph, of Syleby, husbandman 0
5629152 2553089 2553089 defendant Skeryngton Nicholas husbandman 761081 761081 Skeryngton, Nicholas, of Syleby, husbandman 0
5629153 2553089 2553089 defendant Milner Alice   761081 761081 Milner, Alice, of Syleby, servant 1
5629333 2553152 2553152 plaintiff Randyll John   761081 761081 Randyll, John, of Syleby 0
5629334 2553152 2553152 defendant Skeryngton Nicholas husbandman 761081 761081 Skeryngton, Nicholas, of Syleby, husbandman 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);