names

66 rows where place_id = 600541

✎ 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
3641451 1907785 1907785 defendant Myte Hugh yeoman 600541 600541 Myte, Hugh, of Necton, yeoman 1
3678043 1919176 1919176 defendant Bulbroke John husbandman 600541 600541 Bulbroke, John, of Necton, husbandman 0
3689089 1922747 1922747 defendant Skarlett James husbandman 600541 600541 Skarlett, James, of Necton, husbandman 0
3729231 1935392 1935392 defendant Myte Hugh husbandman 600541 600541 Myte, Hugh, of Necton, husbandman 2
3730057 1935641 1935641 defendant Goodwyn Richard clerk 600541 600541 Goodwyn, Richard, of Necton, clerk 0
3731997 1936237 1936237 defendant Hawe Giles husbandman 600541 600541 Hawe, Giles, of Necton, husbandman 0
3740907 1939015 1939015 defendant Walkar Henry husbandman 600541 600541 Walkar, Henry, of Necton, husbandman 1
3741571 1939234 1939234 defendant Lesse Thomas husbandman 600541 600541 Lesse, Thomas, of Necton, husbandman 0
3741851 1939316 1939316 defendant Pawly Richard roper 600541 600541 Pawly, Richard, of Necton, roper 0
3741853 1939316 1939316 defendant Seman John carpenter 600541 600541 Seman, John, of Necton, carpenter 2
3750019 1941922 1941922 defendant Blomvild George husbandman 600541 600541 Blomvild, George, of Necton, husbandman 2
3751935 1942520 1942520 defendant Hawke Giles husbandman 600541 600541 Hawke, Giles, of Necton, husbandman 5
3761106 1945476 1945476 defendant Scarlett James husbandman 600541 600541 Scarlett, James, of Necton, husbandman 0
3761108 1945476 1945476 defendant Ferby William husbandman 600541 600541 Ferby, William, of Necton, husbandman 2
3763991 1946379 1946379 defendant Browne John husbandman 600541 600541 Browne, John, of Necton, husbandman 0
3779769 1951405 1951405 defendant Hawke Giles husbandman 600541 600541 Hawke, Giles, of Necton, husbandman 0
3814997 1962610 1962610 defendant Tomson Nicholas husbandman 600541 600541 Tomson, Nicholas, of Necton, husbandman 0
3818459 1963672 1963672 defendant Bulbroke John (legal representative) 600541 600541 Bulbroke, John, of Necton, executor of 1
3830889 1967543 1967543 defendant Moryall John smith 600541 600541 Moryall, John, of Necton, smith 1
3831042 1967592 1967592 defendant Marshall John chaplain 600541 600541 Marshall, John, of Necton, chaplain 0
3849106 1973318 1973318 defendant Redhous Robert tailor 600541 600541 Redhous, Robert, of Necton, tailor 0
3858044 1976167 1976167 plaintiff Belle Thomas   600541 600541 Belle, Thomas, of Necton 0
3858046 1976167 1976167 defendant Skepper Henry husbandman 600541 600541 Skepper, Henry, of Necton, husbandman 1
3858047 1976167 1976167 defendant Slappe Edward husbandman 600541 600541 Slappe, Edward, of Necton, husbandman 2
3858048 1976167 1976167 defendant Otwey John husbandman 600541 600541 Otwey, John, of Necton, husbandman 3
3861966 1977462 1977462 plaintiff Goodwyn Richard clerk 600541 600541 Goodwyn, Richard, of Necton, clerk 0
3872836 1981127 1981127 defendant Brightmer John husbandman 600541 600541 Brightmer, John, of Necton, husbandman 0
3881141 1983962 1983962 plaintiff Ruste Robert   600541 600541 Ruste, Robert, of Necton 0
3893334 1988004 1988004 defendant Hendry John yeoman 600541 600541 Hendry, John, of Necton, yeoman 0
3907545 1992819 1992819 defendant Antyngham John laborer 600541 600541 Antyngham, John, of Necton, laborer 3
3908766 1993227 1993227 defendant Rychard Nicholas husbandman 600541 600541 Rychard, Nicholas, of Necton, husbandman 1
3917955 1996369 1996369 plaintiff Henry John yeoman 600541 600541 Henry, John, of Necton, yeoman 0
3920696 1997270 1997270 defendant Seman John husbandman 600541 600541 Seman, John, of Necton, husbandman 1
3925007 1998679 1998679 defendant Bekerton Gregory carpenter 600541 600541 Bekerton, Gregory, of Necton, carpenter 3
3974941 2015801 2015801 defendant Wymbyshe Mary   600541 600541 Wymbyshe, Mary, of Necton, widow, administrators of 0
3996214 2023395 2023395 defendant Cockett George gent 600541 600541 Cockett, George, of Necton, gent 0
3996216 2023396 2023396 defendant Cockett George gent 600541 600541 Cockett, George, of Necton, gent 0
4070513 2049746 2049746 defendant Cockett Anthony gent 600541 600541 Cockett, Anthony, of Necton, gent 0
4073528 2050818 2050818 defendant Palmer Henry yeoman 600541 600541 Palmer, Henry, of Necton, yeoman 0
4081601 2053724 2053724 defendant Cockett Anthony gent 600541 600541 Cockett, Anthony, of Necton, gent 0
4085537 2055099 2055099 defendant Cockett Anthony gent 600541 600541 Cockett, Anthony, of Necton, gent 4
4257626 2115526 2115526 defendant Kursted John husbandman 600541 600541 Kursted, John, of Necton, husbandman 0
4257627 2115526 2115526 defendant Kursted George husbandman 600541 600541 Kursted, George, of Necton, husbandman 1
4257628 2115526 2115526 defendant Barker Mary widow 600541 600541 Barker, Mary, of Necton, widow 2
4275545 2121387 2121387 defendant Cursted John laborer 600541 600541 Cursted, John, of Necton, laborer 0
4275546 2121387 2121387 defendant Cursted George singleman 600541 600541 Cursted, George, of Necton, laborer, singleman 1
4348329 2146668 2146668 defendant Garter Oliver yeoman 600541 600541 Garter, Oliver, of Necton, yeoman 2
4355867 2149270 2149270 defendant Gronn or Groun Charles yeoman 600541 600541 Gronn or Groun, Charles, of Necton, yeoman 2
4395135 2162961 2162961 defendant Mayor John yeoman 600541 600541 Mayor, John, of Necton, yeoman 1
4396101 2163270 2163270 defendant Collyson John tanner 600541 600541 Collyson, John, of Necton, tanner 2
4396102 2163270 2163270 defendant Inglishe Thomas husbandman 600541 600541 Inglishe, Thomas, of Necton, husbandman 3
4401191 2164994 2164994 defendant Everarde Edmund tanner 600541 600541 Everarde, Edmund, of Necton, tanner 0
4401192 2164994 2164994 defendant Collyson John yeoman 600541 600541 Collyson, John, of Necton, yeoman 1
4404632 2166118 2166118 defendant Clere Thomas yeoman 600541 600541 Clere, Thomas, of Necton, yeoman 1
4404633 2166118 2166118 defendant Powley John yeoman 600541 600541 Powley, John, of Necton, yeoman 2
4405530 2166424 2166424 defendant Taylor Robert gent 600541 600541 Taylor, Robert, of Necton, gent 1
4409176 2167669 2167669 defendant Crick Robert miller 600541 600541 Crick, Robert, of Necton, husbandman, Darby, John, of Necton, miller executors of 2
4409177 2167669 2167669 defendant Beckerton George husbandman 600541 600541 (Beckerton, George, of Necton, husbandman 3
4924910 2334221 2334221 defendant Crukok John   600541 600541 Crukok, John, of Necton Park, prior 0
5126123 2394120 2394120 defendant Hamond Geoffrey husbandman 600541 600541 Hamond, Geoffrey, of Necton, husbandman 0
5143339 2399191 2399191 defendant Thweyte Geoffrey husbandman 600541 600541 Thweyte, Geoffrey, of Necton, husbandman 0
5164636 2405391 2405391 defendant Thwayte Geoffrey husbandman 600541 600541 Thwayte, Geoffrey, of Necton, husbandman 0
5374509 2467631 2467631 defendant London Geoffrey yeoman 600541 600541 London, Geoffrey, of Necton, yeoman 0
5568920 2525461 2525461 defendant Blomefeld John yeoman 600541 600541 Blomefeld, John, of Necton, yeoman 0
5579429 2528645 2528645 plaintiff Blomvyle John (legal representative) 600541 600541 Blomvyle, John, of Necton, executor of 0
5589488 2531713 2531713 defendant Hegge John fuller 600541 600541 Hegge, John, of Necton, fuller 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);