names

76 rows where place_id = 604392

✎ 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
3657867 1912710 1912710 defendant Dene Ralph draper 604392 604392 Dene, Ralph, of Lowestoft, Suff, draper 0
3663385 1914472 1914472 defendant Palmer John gent 604392 604392 Palmer, John, of Lowestoft, Suff, gent 0
3676120 1918571 1918571 defendant Lobbys Geoffrey merchant 604392 604392 Lobbys, Geoffrey, of Lowestoft, Suff, merchant 0
3680122 1919852 1919852 defendant Hugyell William butcher 604392 604392 Hugyell, William, of Lowestoft, Suff, butcher 0
3686762 1922013 1922013 defendant Botyswyn John husbandman 604392 604392 Botyswyn, John, of Lowestoft, Suff, husbandman 0
3690890 1923314 1923314 defendant Hattle Nicholas yeoman 604392 604392 Hattle, Nicholas, of Lowestoft, Suff, yeoman 0
3749304 1941707 1941707 defendant Broun John clerk 604392 604392 Broun, John, of Lowestoft, Suff, clerk 0
3749692 1941815 1941815 defendant Lobbys Geoffrey yeoman 604392 604392 Lobbys, Geoffrey, of Lowestoft, Suff, yeoman 0
3752532 1942718 1942718 defendant Hankys Thomas husbandman 604392 604392 Hankys, Thomas, of Lowestoft, Suff, husbandman 0
3752989 1942868 1942868 defendant Gare Robert mariner 604392 604392 Gare, Robert, of Lowestoft, Suff, mariner 0
3759454 1944949 1944949 defendant Denne Ralph tailor 604392 604392 Denne, Ralph, of Lowestoft, Suff, tailor 0
3764737 1946635 1946635 defendant Sparowe John (legal representative) 604392 604392 Sparowe, John, of Lowestoft, Suff, husbandman, executors of 0
3766935 1947324 1947324 defendant Browne Thomas merchant 604392 604392 Browne, Thomas, of Lowestoft, Suff, merchant 0
3768493 1947797 1947797 defendant Gare Robert mariner 604392 604392 Gare, Robert, of Lowestoft, Suff, mariner 0
3776615 1950431 1950431 defendant Caar Robert mariner 604392 604392 Caar, Robert, of Lowestoft, Suff, mariner 0
3793531 1955840 1955840 defendant Deen Ralph husbandman 604392 604392 Deen, Ralph, of Lowestoft, Suff, husbandman 4
3868033 1979542 1979542 defendant Betesweyms John baker 604392 604392 Betesweyms, John, of Lowestoft, Suff, baker 0
3869747 1980121 1980121 defendant Rowet John baker 604392 604392 Rowet, John, of Lowestoft, Suff, baker 0
3909694 1993550 1993550 defendant Culleys William baxter 604392 604392 Culleys, William, of Lowestoft, Suff, baxter 0
3922225 1997742 1997742 defendant Mewse William butcher 604392 604392 Mewse, William, of Lowestoft, Suff, butcher 0
3922229 1997743 1997743 defendant Mewse William butcher 604392 604392 Mewse, William, of Lowestoft, Suff, butcher 1
3935171 2002073 2002073 plaintiff Jettor James merchant 604392 604392 Jettor, James, of Lowestoft, Suff, merchant 0
4258347 2115760 2115760 defendant Fulwood Mathew yeoman 604392 604392 Fulwood, Mathew, of Lowestoft, Suff, yeoman 0
4738461 2277120 2277120 defendant Bullok Adam   604392 604392 Bullok, Adam, of Lowestoft, Suff, cook 0
4770989 2286904 2286904 defendant Edward Henry yeoman 604392 604392 Edward, Henry, of Lowestoft, Suff, yeoman 0
4775500 2288332 2288332 defendant Palgrave Robert gent 604392 604392 Palgrave, Robert, of Lowestoft, Suff, gent 0
4805156 2297813 2297813 defendant Huntman Stephen cooper 604392 604392 Huntman, Stephen, of Lowestoft, Suff, cooper 0
4815177 2300856 2300856 defendant Folvyll John yeoman 604392 604392 Folvyll, John, of Lowestoft, Suff, yeoman 0
4829999 2305428 2305428 defendant Marche Richard merchant 604392 604392 Marche, Richard, of Lowestoft, Suff, merchant 1
4830052 2305445 2305445 defendant Gybson John chapman 604392 604392 Gybson, John, of Lowestoft, Suff, chapman 1
4831305 2305821 2305821 defendant Huntman Stephen cooper 604392 604392 Huntman, Stephen, of Lowestoft, Suff, cooper 0
4833676 2306540 2306540 defendant Folvyle John yeoman 604392 604392 Folvyle, John, of Lowestoft, Suff, yeoman 0
4833679 2306541 2306541 defendant Folvyle John yeoman 604392 604392 Folvyle, John, of Lowestoft, Suff, yeoman 0
4833682 2306542 2306542 defendant Folvyle John yeoman 604392 604392 Folvyle, John, of Lowestoft, Suff, yeoman 0
4917093 2331853 2331853 defendant Baret James yeoman 604392 604392 Baret, James, of Lowestoft, Suff, yeoman 1
4949844 2341939 2341939 defendant Boef John gent 604392 604392 Boef, John, of Lowestoft, Suff, gent 2
4967622 2347257 2347257 defendant Baret James baker 604392 604392 Baret, James, of Lowestoft, Suff, baker 0
4982104 2351564 2351564 defendant Heigham John   604392 604392 Heigham, John, of Lowestoft, Suff, mechant 0
4982107 2351565 2351565 defendant Heigham John   604392 604392 Heigham, John, of Lowestoft, Suff, mechant 0
4984761 2352372 2352372 defendant Gibbesson William merchant 604392 604392 Gibbesson, William, of Lowestoft, Suff, or of Scotland, merchant 0
5095059 2384969 2384969 defendant Saly Edmund chandler 604392 604392 Saly, Edmund, of Lowestoft, Suff, chandler 0
5129372 2395078 2395078 defendant Gybson Wiliam merchant 604392 604392 Gybson, Wiliam, of Lowestoft, Suff, merchant 0
5138016 2397625 2397625 defendant Mundes John merchant 604392 604392 Mundes, John, of Lowestoft, Suff, merchant 0
5143539 2399246 2399246 defendant Writh Thomas yeoman 604392 604392 Writh, Thomas, of Lowestoft, Suff, yeoman 0
5145228 2399745 2399745 defendant Booff alias Boffe John gent 604392 604392 Booff alias Boffe, John, of Lowestoft, Suff, gent 1
5148659 2400730 2400730 defendant Gibson William merchant 604392 604392 Gibson, William, of Lowestoft, Suff, merchant 0
5150889 2401399 2401399 defendant Heigham John merchant 604392 604392 Heigham, John, of Lowestoft, Suff, merchant 6
5154915 2402596 2402596 defendant Booff John gent 604392 604392 Booff, John, of Lowestoft, Suff, gent 1
5164721 2405416 2405416 defendant Wright Thomas yeoman 604392 604392 Wright, Thomas, of Lowestoft, Suff, yeoman 0
5165773 2405733 2405733 defendant Booff John gent 604392 604392 Booff, John, of Lowestoft, Suff, gent 1
5167886 2406319 2406319 defendant Gibson William merchant 604392 604392 Gibson, William, of Lowestoft, Suff, merchant 0
5173200 2407873 2407873 defendant Gibson William merchant 604392 604392 Gibson, William, of Lowestoft, Suff, merchant 0
5174133 2408136 2408136 defendant Mundes John merchant 604392 604392 Mundes, John, of Lowestoft, Suff, merchant 0
5180227 2409956 2409956 defendant Booff John gent 604392 604392 Booff, John, of Lowestoft, Suff, gent 1
5186083 2411680 2411680 defendant Bormde John husbandman 604392 604392 Bormde, John, of Lowestoft, Suff, husbandman 2
5201296 2416137 2416137 defendant Thorp John yeoman 604392 604392 Thorp, John, of Lowestoft, Suff, yeoman 0
5201450 2416182 2416182 defendant Gybsons William merchant 604392 604392 Gybsons, William, of Lowestoft, Suff, merchant 0
5210418 2418779 2418779 defendant Gybson William merchant 604392 604392 Gybson, William, of Lowestoft, Suff, merchant 0
5233682 2425438 2425438 defendant Gybson William merchant 604392 604392 Gybson, William, of Lowestoft, Suff, merchant 1
5276857 2438314 2438314 defendant Rysyng James yeoman 604392 604392 Rysyng, James, of Lowestoft, Suff, yeoman 2
5292026 2442674 2442674 defendant Alman Simon yeoman 604392 604392 Alman, Simon, of Lowestoft, Suff, yeoman 1
5292050 2442679 2442679 defendant Saxmondham William merchant 604392 604392 Saxmondham, William, of Lowestoft, Suff, merchant 0
5292064 2442681 2442681 defendant Mondys John (legal representative) 604392 604392 Mondys, John, of Lowestoft, Suff, merchant, executrix of 4
5292071 2442682 2442682 defendant Mondys John (legal representative) 604392 604392 Mondys, John, of Lowestoft, Suff, merchant, executrix of 4
5373979 2467459 2467459 defendant Gall Richard merchant 604392 604392 Gall, Richard, of Lowestoft, Suff, merchant 0
5405525 2476659 2476659 defendant Werasteler Everard smith 604392 604392 Werasteler, Everard, of Lowestoft, Suff, smith 2
5406252 2476860 2476860 defendant Mounton Robert gent 604392 604392 Mounton, Robert, of Lowestoft, Suff, gent 0
5419282 2480693 2480693 defendant Mounton Robert gent 604392 604392 Mounton, Robert, of Lowestoft, Suff, gent 0
5431447 2484359 2484359 defendant Neweman Richard mariner 604392 604392 Neweman,Richard, of Lowestoft, Suff, mariner 0
5435276 2485483 2485483 defendant Galle Richard   604392 604392 Galle, Richard, of Lowestoft, Suff 0
5435280 2485485 2485485 defendant Galle Richard yeoman 604392 604392 Galle, Richard, of Lowestoft, Suff, yeoman 0
5437584 2486178 2486178 defendant Mo_ Robert gent 604392 604392 Mo_, Robert, of Lowestoft, Suff, gent 0
5437589 2486179 2486179 defendant Mounton Robert gent 604392 604392 Mounton, Robert, of Lowestoft, Suff, gent 0
5470464 2496086 2496086 defendant Wetyng Robert baker 604392 604392 Wetyng, Robert, of Lowestoft, Suff, baker 0
5481913 2499521 2499521 defendant Wetyng Robert baker 604392 604392 Wetyng, Robert, of Lowestoft, Suff, baker 0
5559012 2522593 2522593 defendant Wheymond William smith 604392 604392 Wheymond, William, of Lowestoft, Suff, smith 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);