names

87 rows where place_id = 585960

✎ 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
3587577 1863761 1863761 defendant Taillour Thomas tailor 585960 585960 Taillour, Thomas, of Burneham, tailor 1
3590524 1864678 1864678 defendant Bonche or Bouche Robert husbandman 585960 585960 Bonche or Bouche, Robert, of Burneham, husbandman 0
3594406 1865886 1865886 defendant Purfote Thomas yeoman 585960 585960 Purfote, Thomas, of burneham, yeoman 0
3604554 1869089 1869089 defendant Laurens John husbandman 585960 585960 Laurens, John, of Burneham, husbandman 0
3604555 1869089 1869089 defendant Grene Robert husbandman 585960 585960 Grene, Robert, of Burneham, husbandman 1
3604556 1869089 1869089 defendant Grene Nicholas husbandman 585960 585960 Grene, Nicholas, of Burneham, husbandman 2
3604557 1869089 1869089 defendant Laurence Robert husbandman 585960 585960 Laurence, Robert, of Burneham, husbandman 3
3638063 1906724 1906724 defendant Gole John husbandman 585960 585960 Gole, John, of Burneham, husbandman 0
3638066 1906724 1906724 defendant Lawrence John husbandman 585960 585960 Lawrence, John, of Burneham, husbandman 3
3750848 1942187 1942187 plaintiff Melhowse Richard   585960 585960 Melhowse, Richard, of Burneham, administrators of 0
3760718 1945351 1945351 defendant West John yeoman 585960 585960 West, John, of Burneham, yeoman 0
3784580 1952965 1952965 plaintiff Melhowse Richard   585960 585960 Melhowse, Richard, of Burneham, yeoman, administrators of 0
3865238 1978580 1978580 defendant Dey John laborer 585960 585960 Dey, John, of Burneham, laborer 0
3866239 1978934 1978934 defendant Dussyng Robert clerk 585960 585960 Dussyng, Robert, of Burneham, clerk 0
3867731 1979440 1979440 plaintiff Shethe Thomas (legal representative) 585960 585960 Shethe, Thomas, of Burneham, executor of 0
3876542 1982399 1982399 defendant Gyggys John gent 585960 585960 Gyggys, John, of Burneham, gent 0
3876887 1982511 1982511 defendant Arcall John husbandman 585960 585960 Arcall, John, of Burneham, husbandman 2
3885501 1985407 1985407 defendant Peryn John husbandman 585960 585960 Peryn, John, of Burneham, husbandman 0
3916266 1995825 1995825 defendant Eyer Thomas yeoman 585960 585960 Eyer, Thomas, of Burneham, yeoman 0
3973961 2015464 2015464 defendant Mydlam Robert, junior yeoman 585960 585960 Mydlam, Robert, junior, of Burneham, or of South Brente, Soms, yeoman 0
3985554 2019597 2019597 defendant Fascett Reginald tailor 585960 585960 Fascett, Reginald, of Burneham, tailor 2
3994653 2022840 2022840 plaintiff Colman Walter merchant 585960 585960 Colman, Walter, of Burneham, merchant 0
4046088 2041040 2041040 defendant Longe Richard husbandman 585960 585960 Longe, Richard, of Burneham, husbandman 1
4082716 2054126 2054126 defendant Dodd Robert husbandman 585960 585960 Dodd, Robert, of Burneham, husbandman 0
4094636 2058420 2058420 defendant More Thomas yeoman 585960 585960 More, Thomas, of Burneham, yeoman 1
4101493 2060840 2060840 defendant Dodd Robert husbandman 585960 585960 Dodd, Robert, of Burneham, husbandman 0
4172285 2085772 2085772 defendant Lewys Peter clerk 585960 585960 Lewys, Peter, of Burneham, clerk 0
4174469 2086538 2086538 defendant Bruckman Thomas husbandman 585960 585960 Bruckman, Thomas, of Burneham, husbandman 0
4174473 2086539 2086539 defendant Buckman Thomas husbandman 585960 585960 Buckman, Thomas, of Burneham, husbandman 0
4181538 2089022 2089022 defendant Sergean William yeoman 585960 585960 Sergean, William, of Burneham, yeoman 1
4181541 2089023 2089023 defendant Sergeant William yeoman 585960 585960 Sergeant, William, of Burneham, yeoman 1
4193957 2093446 2093446 defendant Buntinge Roger   585960 585960 Buntinge, Roger, of Burneham Markett, sailor 2
4212427 2099894 2099894 defendant Moore Thomas yeoman 585960 585960 Moore, Thomas, of Burneham, yeoman 3
4224090 2103913 2103913 defendant Grimes John yeoman 585960 585960 Grimes, John, of Burneham, yeoman 0
4226997 2104915 2104915 defendant Mason Nicholas (legal representative) 585960 585960 Mason, Nicholas, of Burneham, yeoman, executor of 1
4226998 2104915 2104915 defendant Mason Zachary yeoman 585960 585960 Mason, Zachary, of Burneham, yeoman 2
4233219 2107128 2107128 defendant Hopkyn George yeoman 585960 585960 Hopkyn, George, of Burneham, yeoman 0
4243499 2110818 2110818 defendant Eade or Gade Edward husbandman 585960 585960 Eade or Gade, Edward, of Burneham, husbandman 0
4243500 2110818 2110818 defendant Pepis Richard yeoman 585960 585960 Pepis, Richard, of Burneham, yeoman 1
4245677 2111535 2111535 defendant Reade Michael husbandman 585960 585960 Reade, Michael, of Burneham, husbandman 0
4256988 2115309 2115309 defendant Shypman Richard husbandman 585960 585960 Shypman, Richard, of Burneham, husbandman 0
4257861 2115604 2115604 defendant Reade Micghael husbandman 585960 585960 Reade, Micghael, of Burneham, husbandman 0
4276761 2121805 2121805 defendant Marshe Michael cooper 585960 585960 Marshe, Michael, of Burneham, cooper 3
4278072 2122264 2122264 defendant Mason Peter yeoman 585960 585960 Mason, Peter, of Burneham, yeoman 3
4288173 2125819 2125819 defendant Colston Nicholas husbandman 585960 585960 Colston, Nicholas, of Burneham, husbandman 1
4288220 2125831 2125831 defendant Tubbinge Arthur mercer 585960 585960 Tubbinge, Arthur, of Burneham, or of North Walsham, mercer 0
4288486 2125929 2125929 defendant Midlambe John yeoman 585960 585960 Midlambe, John, of Burneham, yeoman 0
4307503 2132761 2132761 defendant Hurwood Nicholas husbandman 585960 585960 Hurwood, Nicholas, of Burneham, husbandman 4
4311209 2134068 2134068 defendant Moore Thomas husbandman 585960 585960 Moore, Thomas, of Burneham, husbandman 0
4337216 2142746 2142746 defendant Mawson Peter yeoman 585960 585960 Mawson, Peter, of Burneham, yeoman 0
4367297 2153359 2153359 defendant Gould Richard husbandman 585960 585960 Gould, Richard, of Burneham, husbandman 0
4387835 2160566 2160566 defendant Wembredye Thomas husbandman 585960 585960 Wembredye, Thomas, of Burneham, husbandman 1
4405129 2166291 2166291 defendant Puttypoole William yeoman 585960 585960 Puttypoole, William, of Burneham, yeoman 0
4405131 2166291 2166291 defendant Johnson Thomas   585960 585960 Johnson, Thomas, of Burneham, shipwright 2
4405132 2166291 2166291 defendant Haward Timothy   585960 585960 Haward, Timothy, of Burneham, sailor 3
4405134 2166292 2166292 defendant Pycke Thomas husbandman 585960 585960 Pycke, Thomas, of Burneham, husbandman 0
4408347 2167365 2167365 defendant Hales Mathew   585960 585960 Hales, Mathew, of Burneham, Essex, sailor 1
4409932 2167928 2167928 defendant Howse Robert esq 585960 585960 Howse, Robert, of Burneham, esq 1
4618240 2236713 2236713 plaintiff Goldehoppe Thomas   585960 585960 Goldehoppe, Thomas, of Burneham, vicar 3
4701207 2265779 2265779 defendant Cook William   585960 585960 Cook, William, of Burneham, franklin 1
4893619 2324704 2324704 defendant Myddelham John yeoman 585960 585960 Myddelham, John, of Burneham, yeoman 0
4893620 2324704 2324704 defendant Lauerens John husbandman 585960 585960 Lauerens, John, of Burneham, husbandman 1
4893621 2324704 2324704 defendant Bysham Robert husbandman 585960 585960 Bysham, Robert, of Burneham, husbandman 2
4893622 2324704 2324704 defendant Golde Thomas husbandman 585960 585960 Golde, Thomas, of Burneham, husbandman 3
4893623 2324704 2324704 defendant Hyll Thomas husbandman 585960 585960 Hyll, Thomas, of Burneham, husbandman 4
4893624 2324704 2324704 defendant Dodde Thomas husbandman 585960 585960 Dodde, Thomas, of Burneham, husbandman 5
4954417 2343293 2343293 defendant Balle John yeoman 585960 585960 Balle, John, of Burneham, yeoman 0
4991273 2354273 2354273 defendant Braweghyng John husbandman 585960 585960 Braweghyng, John, of Burneham, husbandman 0
5010983 2360069 2360069 defendant Desam Robert husbandman 585960 585960 Desam, Robert, of Burneham, husbandman 0
5087995 2382863 2382863 defendant Fuller Robert drover 585960 585960 Fuller, Robert, of Burneham, drover 2
5102906 2387270 2387270 defendant Austyn William yeoman 585960 585960 Austyn, William, of Burneham, yeoman 0
5166059 2405816 2405816 defendant Penle John yeoman 585960 585960 Penle, John, of Burneham, yeoman 0
5262202 2433926 2433926 defendant Walter John husbandman 585960 585960 Walter, John, of Burneham, husbandman 0
5355600 2461827 2461827 defendant Bunche William   585960 585960 Bunche, William, of Burneham, franklin 0
5385100 2470813 2470813 defendant Hill John butcher 585960 585960 Hill, John, of Burneham, butcher 0
5418954 2480593 2480593 defendant Hethton John yeoman 585960 585960 Hethton, John, of Burneham, yeoman 1
5429831 2483864 2483864 defendant Hill John butcher 585960 585960 Hill, John, of Burneham, butcher 0
5440451 2487047 2487047 defendant Overman Thomas laborer 585960 585960 Overman, Thomas, of Burneham, laborer 3
5446779 2488935 2488935 defendant Hill John butcher 585960 585960 Hill, John, of Burneham, butcher 0
5460006 2492924 2492924 defendant Hall John butcher 585960 585960 Hall, John, of Burneham, butcher 0
5471008 2496266 2496266 defendant Hill John butcher 585960 585960 Hill, John, of Burneham, butcher 0
5503101 2505880 2505880 defendant Bunche William   585960 585960 Bunche, William, of Burneham, franklin 0
5513431 2509048 2509048 defendant Harward Robert sherman 585960 585960 Harward, Robert, of Burneham, sherman 0
5514823 2509480 2509480 defendant Saweger Thomas yeoman 585960 585960 Saweger, Thomas, of Burneham, yeoman 0
5514824 2509480 2509480 defendant Skynner Roger husbandman 585960 585960 Skynner, Roger, of Burneham, husbandman 1
5518268 2510541 2510541 defendant Hyll John butcher 585960 585960 Hyll, John, of Burneham, butcher 0
5616547 2548974 2548974 defendant Hogges Thomas   585960 585960 Hogges, Thomas, of Burneham 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);