names

49 rows where place_id = 608553

✎ 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
3674184 1917962 1917962 defendant Skynner John husbandman 608553 608553 Skynner, John, of Tollesbury, husbandman 1
3674185 1917962 1917962 defendant Crips John mariner 608553 608553 Crips, John, of Tollesbury, mariner 2
3744054 1940034 1940034 defendant Sammys John yeoman 608553 608553 Sammys, John, of Tollesbury, yeoman 0
3759014 1944806 1944806 defendant Samme John yeoman 608553 608553 Samme, John, of Tollesbury, yeoman 2
3768071 1947651 1947651 defendant Sames John, senior yeoman 608553 608553 Sames, John, senior, of Tollesbury, yeoman 0
3857792 1976075 1976075 defendant Bennett Robert husbandman 608553 608553 Bennett, Robert, of Tollesbury, husbandman 2
4407050 2166916 2166916 defendant Burles Arthur butcher 608553 608553 Burles, Arthur, of Tollesbury, butcher 0
4407052 2166917 2166917 defendant Burles Arthur butcher 608553 608553 Burles, Arthur, of Tollesbury, butcher 0
4532174 2210328 2210328 plaintiff Porter John   608553 608553 Porter, John, of Tollesbury 0
4574449 2223538 2223538 defendant Broun Thomas   608553 608553 Broun, Thomas, of Tollesbury 0
4620486 2237388 2237388 defendant Seyre John   608553 608553 Seyre, John, of Tollesbury 0
4667911 2255664 2255664 plaintiff Baker Christine   608553 608553 Baker, Christine, of Tollesbury 0
4689115 2262157 2262157 defendant Milnehouse John husbandman 608553 608553 Milnehouse, John, of Tollesbury, husbandman 0
4689249 2262199 2262199 defendant Milnehous John husbandman 608553 608553 Milnehous, John, of tollesbury, husbandman 0
4689251 2262199 2262199 defendant Sayer John, senior husbandman 608553 608553 Sayer, John, senior, of Tollesbury, husbandman 2
4699269 2265238 2265238 plaintiff Doun Robert de la   608553 608553 Doun, Robert de la, of Tollesbury 0
4714332 2269813 2269813 defendant Milnehouse John husbandman 608553 608553 Milnehouse, John, of Tollesbury, husbandman 0
4714334 2269813 2269813 defendant Sawyer John, sen husbandman 608553 608553 Sawyer, John, sen, of Tollesbury, husbandman 2
4733021 2275506 2275506 plaintiff Potter John   608553 608553 Potter, John, of Tollesbury 0
4733023 2275506 2275506 defendant Virly John   608553 608553 Virly, John, of Tollesbury 1
4741669 2278055 2278055 defendant Forryder John yeoman 608553 608553 Forryder, John, of Tollesbury, yeoman 1
4778529 2289265 2289265 defendant Fouler John, senior laborer 608553 608553 Fouler, John, senior, of Tollesbury, laborer 1
4811184 2299608 2299608 defendant Bussh Thomas shipman 608553 608553 Bussh, Thomas, of Tollesbury, shipman 1
4828961 2305102 2305102 defendant Smyth John   608553 608553 Smyth, John, of Tollesbury, ship wright 0
4828964 2305102 2305102 defendant Savage John yeoman 608553 608553 Savage, John, of Tollesbury, yeoman 3
4828965 2305102 2305102 defendant Hampton John carter 608553 608553 Hampton, John, of Tollesbury, carter 4
4905573 2328343 2328343 defendant Smyth John   608553 608553 Smyth, John, of Tollesbury, shipwright 0
4908204 2329117 2329117 defendant Hunte John yeoman 608553 608553 Hunte, John, of Tollesbury, yeoman 0
5062284 2375281 2375281 defendant Scot John   608553 608553 Scot, John, of Tollesbury, "hierd" 2
5065036 2376072 2376072 defendant Carter Richard yeoman 608553 608553 Carter, Richard, of Tollesbury, yeoman 2
5065037 2376072 2376072 defendant Berkham John yeoman 608553 608553 Berkham, John, of Tollesbury, yeoman 3
5065039 2376072 2376072 defendant Kechen Robert yeoman 608553 608553 Kechen, Robert, of Tollesbury, yeoman 5
5079577 2380381 2380381 defendant Hireston Thomas husbandman 608553 608553 Hireston, Thomas, of Tollesbury, husbandman 1
5106946 2388462 2388462 defendant Carter Richard husbandman 608553 608553 Carter, Richard, of Tollesbury, husbandman 0
5106947 2388462 2388462 defendant Smyth Robert husbandman 608553 608553 Smyth, Robert, of Tollesbury, husbandman 1
5117116 2391431 2391431 defendant Page John husbandman 608553 608553 Page, John, of Tollesbury, husbandman 1
5118801 2391930 2391930 defendant Broke John husbandman 608553 608553 Broke, John, of Tollesbury, husbandman 2
5123394 2393285 2393285 defendant Page John, junior husbandman 608553 608553 Page, John, junior, of Tollesbury, husbandman 0
5133986 2396435 2396435 defendant Hobbes John butcher 608553 608553 Hobbes, John, of Tollesbury, butcher 3
5134023 2396448 2396448 defendant Page John yeoman 608553 608553 Page, John, of Tollesbury, yeoman 0
5134026 2396448 2396448 defendant Aleyn John   608553 608553 Aleyn, John, of Tollesbury 3
5134028 2396449 2396449 defendant Page John yeoman 608553 608553 Page, John, of Tollesbury, yeoman 0
5134031 2396449 2396449 defendant Aleyn John husbandman 608553 608553 Aleyn, John, of Tollesbury, husbandman 3
5153779 2402266 2402266 defendant Berkham John butcher 608553 608553 Berkham, John, of Tollesbury, butcher 0
5153781 2402266 2402266 defendant Hobbes John butcher 608553 608553 Hobbes, John, of Tollesbury, butcher 2
5171171 2407290 2407290 defendant Berkham John butcher 608553 608553 Berkham, John, of Tollesbury, butcher 0
5171173 2407290 2407290 defendant Hobbes John butcher 608553 608553 Hobbes, John, of Tollesbury, butcher 2
5403151 2475984 2475984 defendant Kecheyn Robert   608553 608553 Kecheyn, Robert, of Tollesbury, tile maker 2
5456655 2491915 2491915 defendant Sayer Robert shipman 608553 608553 Sayer, Robert, of Tollesbury, shipman 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);