names

60 rows where place_id = 586475

✎ 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
3588816 1864150 1864150 defendant Elyotte William husbandman 586475 586475 Elyotte, William, of Fareham, husbandman 0
3588817 1864150 1864150 defendant Style Nicholas shoemaker 586475 586475 Style, Nicholas, of Fareham, shoemaker 1
3658251 1912835 1912835 defendant Love Nicholas gunner 586475 586475 Love, Nicholas, of Fareham, gunner 0
3658252 1912835 1912835 defendant Shappe Simon sheer man 586475 586475 Shappe, Simon, of Fareham, sheer man 1
3666919 1915597 1915597 defendant Broke Richard yeoman 586475 586475 Broke, Richard, of Fareham, yeoman 1
3730648 1935820 1935820 defendant Bysshop Robert butcher 586475 586475 Bysshop, Robert, of Fareham, butcher 0
3777984 1950826 1950826 defendant Elyot Richard mariner 586475 586475 Elyot, Richard, of Fareham, mariner 0
3898030 1989548 1989548 defendant Becheham Thomas mariner 586475 586475 Becheham, Thomas, of Fareham, mariner 0
4010267 2028440 2028440 defendant Hamond Alexander (legal representative) 586475 586475 Hamond, Alexander, of Fareham, husbandman, executor of 0
4095235 2058618 2058618 defendant Deryng Alexander gent 586475 586475 Deryng, Alexander, of Fareham, gent 1
4159869 2081518 2081518 defendant Puttocke Henry sherman 586475 586475 Puttocke, Henry, of Fareham, sherman 1
4159870 2081518 2081518 defendant Woodman Richard yeoman 586475 586475 Woodman, Richard, of Fareham, yeoman 2
4208198 2098420 2098420 defendant Mylles Stephen yeoman 586475 586475 Mylles, Stephen, of Fareham, yeoman 0
4235455 2107969 2107969 defendant Virey or Verey John   586475 586475 Virey or Verey, John, of Fareham, shipwright 0
4235457 2107969 2107969 defendant Standley Mathew cooper 586475 586475 Standley, Mathew, of Fareham, cooper 2
4236900 2108484 2108484 defendant Downynge Ralph cooper 586475 586475 Downynge, Ralph, of Fareham, cooper 0
4267546 2118779 2118779 defendant Urrey John   586475 586475 Urrey, John, of Fareham, or of Isle of Wight, shipwright 0
4267548 2118779 2118779 defendant Standley Mathew cooper 586475 586475 Standley, Mathew, of Fareham, cooper 2
4269763 2119475 2119475 defendant Downinge Ralph cooper 586475 586475 Downinge, Ralph, of Fareham, cooper 0
4367777 2153528 2153528 defendant Filkin alias Tayler Roger husbandman 586475 586475 Filkin alias Tayler, Roger, of Fareham, husbandman 0
4376853 2156793 2156793 defendant White Thomas gent 586475 586475 White, Thomas, of Fareham, gent 0
4378233 2157281 2157281 defendant Albecke John husbandman 586475 586475 Albecke, John, of Fareham, husbandman 0
4486951 2196637 2196637 plaintiff Serle William   586475 586475 Serle, William, of fareham 0
4541272 2213166 2213166 defendant Cutte Robert   586475 586475 Cutte, Robert, of Fareham 2
4597456 2230448 2230448 defendant Dysebaunt John   586475 586475 Dysebaunt, John, of Fareham 0
4602427 2231978 2231978 defendant Chadde Thomas   586475 586475 Chadde, Thomas, of Fareham 0
4703993 2266628 2266628 defendant Harecourt Stephen weaver 586475 586475 Harecourt, Stephen, of Fareham, weaver 0
4924724 2334169 2334169 defendant Coke Thomas chapman 586475 586475 Coke, Thomas, of Fareham, chapman 1
4971464 2348393 2348393 defendant Lok Thomas husbandman 586475 586475 Lok, Thomas, of Fareham, husbandman 0
5021264 2363119 2363119 defendant Hoke alias Cook Philip merchant 586475 586475 Hoke alias Cook, Philip, of Fareham, merchant 0
5026044 2364510 2364510 defendant Cook Philip merchant 586475 586475 Cook, Philip, of Fareham, merchant 0
5027211 2364828 2364828 defendant Cook Philip chapman 586475 586475 Cook, Philip, of Fareham, chapman 0
5045008 2370138 2370138 defendant Purse Philip husbandman 586475 586475 Purse, Philip, of Fareham, husbandman 1
5045009 2370138 2370138 defendant Langeford William sawyer 586475 586475 Langeford, William, of Fareham, sawyer 2
5048495 2371188 2371188 defendant Smyth John merchant 586475 586475 Smyth, John, of Fareham, merchant 4
5101450 2386836 2386836 defendant Averell Robert yeoman 586475 586475 Averell, Robert, of Fareham, yeoman 0
5113132 2390237 2390237 defendant Mundy William tanner 586475 586475 Mundy, William, of Fareham, tanner 1
5113133 2390237 2390237 defendant Tryp John yeoman 586475 586475 Tryp, John, of Fareham, yeoman 2
5113134 2390237 2390237 defendant Southeley Edward chapman 586475 586475 Southeley, Edward, of Fareham, chapman 3
5130159 2395306 2395306 defendant Allard William husbandman 586475 586475 Allard, William, of Fareham, husbandman 0
5130160 2395306 2395306 defendant Freman Henry yeoman 586475 586475 Freman, Henry, of Fareham, yeoman 1
5224326 2422790 2422790 defendant Cutte John yeoman 586475 586475 Cutte, John, of Fareham, yeoman 0
5299214 2444748 2444748 defendant Stanbanke John yeoman 586475 586475 Stanbanke, John, of Fareham, yeoman 3
5299221 2444749 2444749 defendant Stanbanke John yeoman 586475 586475 Stanbanke, John, of Fareham, yeoman 3
5317184 2450222 2450222 defendant Johnson Robert butcher 586475 586475 Johnson, Robert, of Fareham, butcher 2
5318446 2450609 2450609 defendant Baker John baker 586475 586475 Baker, John, of Fareham, baker 2
5347182 2459279 2459279 defendant Mundy alias Cristmas Lewis tanner 586475 586475 Mundy alias Cristmas, Lewis, of Fareham, tanner 0
5361254 2463545 2463545 defendant Mundy alias Cristman Lewis tanner 586475 586475 Mundy alias Cristman, Lewis, of Fareham, tanner 0
5362621 2463958 2463958 defendant Cristmas Lewis tanner 586475 586475 Cristmas, Lewis, of Fareham, tanner 0
5367401 2465456 2465456 defendant Mounde Lewis tanner 586475 586475 Mounde, Lewis, of Fareham, tanner 6
5424271 2482226 2482226 defendant Cristmasse Lewis tanner 586475 586475 Cristmasse, Lewis, of Fareham, tanner 0
5429344 2483710 2483710 defendant Bocher John butcher 586475 586475 Bocher, John, of Fareham, butcher 0
5455895 2491670 2491670 defendant Cristmasse Lewis tanner 586475 586475 Cristmasse, Lewis, of Fareham, tanner 0
5467722 2495279 2495279 defendant Cristmasse Lewis tanner 586475 586475 Cristmasse, Lewis, of Fareham, tanner 0
5474980 2497500 2497500 defendant Joye John husbandman 586475 586475 Joye, John, of Fareham, husbandman 0
5482723 2499776 2499776 defendant Grover John husbandman 586475 586475 Grover, John, of Fareham, husbandman 1
5482724 2499776 2499776 defendant Buklond John baker 586475 586475 Buklond, John, of Fareham, baker 2
5490423 2502030 2502030 defendant Bucher John butcher 586475 586475 Bucher, John, of Fareham, butcher 2
5566757 2524872 2524872 defendant Arnold John (legal representative) 586475 586475 Arnold, John, of Fareham, smith, executrix of 1
5566758 2524872 2524872 defendant Arnold Agnes widow 586475 586475 Arnold, Agnes, of Fareham, widow 2

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);