names

73 rows where place_id = 591164

✎ 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
3603554 1868782 1868782 defendant Barbour William mariner 591164 591164 Barbour, William, of Harwich, Essex, mariner 0
3627042 1903318 1903318 defendant Yong John merchant 591164 591164 Yong, John, of Harwich, Essex, merchant 0
3675203 1918277 1918277 defendant Harysse William merchant 591164 591164 Harysse, William, of Harwich, Essex, merchant 0
3758985 1944799 1944799 defendant Synger John merchant 591164 591164 Synger, John, of Harwich, essex, merchant 3
3789949 1954682 1954682 defendant Clyff John mariner 591164 591164 Clyff, John, of Harwich, Essex, mariner 0
3836887 1969436 1969436 plaintiff Sampson Adam merchant 591164 591164 Sampson, Adam, of Harwich, Essex, merchant 0
3927965 1999690 1999690 defendant Christmas William merchant 591164 591164 Christmas, William, of Harwich, Essex, merchant 0
3936656 2002587 2002587 defendant Crystmas William merchant 591164 591164 Crystmas, William, of Harwich, Essex, merchant 0
3996125 2023368 2023368 defendant Stretton Thomas gent 591164 591164 Stretton, Thomas, of Harwich, Essex, gent 0
4006281 2027025 2027025 defendant Fenne Anne widow 591164 591164 Fenne, Anne, of Harwich, Essex, widow 1
4007608 2027507 2027507 defendant Haukyn Roger mariner 591164 591164 Haukyn, Roger, of Harwich, Essex, mariner 0
4007610 2027508 2027508 defendant Haukyn Roger marriner 591164 591164 Haukyn, Roger, of Harwich, Essex, marriner 0
4051389 2042918 2042918 defendant Barflete Edward husbandman 591164 591164 Barflete, Edward, of Harwich, Essex, husbandman 0
4071846 2050228 2050228 defendant Bardwell Augustine carpenter 591164 591164 Bardwell, Augustine, of Harwich, Essex, carpenter 0
4087348 2055765 2055765 defendant Haukyn or Hankyn Roger mariner 591164 591164 Haukyn or Hankyn, Roger, of Harwich, Essex, mariner 0
4095436 2058692 2058692 defendant More Thomas mercer or chapman 591164 591164 More, Thomas, of Harwich, Essex, mercer or chapman 0
4180258 2088572 2088572 defendant Johnson alias Arnolde Richard beer brewer 591164 591164 Johnson alias Arnolde, Richard, of Harwich, Essex, beer brewer 0
4202621 2096460 2096460 defendant Storke John merchant 591164 591164 Storke, John, of Harwich, Essex, merchant 0
4218802 2102074 2102074 defendant Kynge Raymond merchant 591164 591164 Kynge, Raymond, of Harwich, Essex, merchant 1
4236250 2108247 2108247 defendant Goodinge Henry innholder 591164 591164 Goodinge, Henry, of Harwich, Essex, innholder 0
4237036 2108536 2108536 defendant Kinge Christopher   591164 591164 Kinge, Christopher, of Harwich, Essex, or of Southold, Suff, sailor 0
4278627 2122459 2122459 defendant Twydd Thomas merchant 591164 591164 Twydd, Thomas, of Harwich, Essex, merchant 0
4304185 2131595 2131595 defendant Sutton George butcher 591164 591164 Sutton, George, of Harwich, Essex, butcher 2
4305304 2131997 2131997 defendant Goodinge Henry innholder 591164 591164 Goodinge, Henry, of Harwich, Essex, innholder 0
4305826 2132175 2132175 defendant Belman John shoemaker 591164 591164 Belman, John, of Harwich, Essex, shoemaker 1
4307892 2132901 2132901 defendant Goodinge Henry innholder 591164 591164 Goodinge, Henry, of Harwich, Essex, innholder 3
4323555 2138295 2138295 defendant Johnson Hercules beer brewer 591164 591164 Johnson, Hercules, of Harwich, Essex, beer brewer 0
4357424 2149825 2149825 defendant Kynge Raymond merchant 591164 591164 Kynge, Raymond, of Harwich, Essex, merchant 0
4387220 2160375 2160375 defendant Chapman John tailor 591164 591164 Chapman, John, of Harwich, Essex, tailor 0
4691974 2263024 2263024 plaintiff Andrewe Thomas mercer 591164 591164 Andrewe, Thomas, of Harwich, Essex, mercer 0
4754709 2281857 2281857 defendant Martyn Richard mariner 591164 591164 Martyn, Richard, of Harwich, Essex, mariner 0
4755373 2282066 2282066 defendant Crouch Thomas chapman 591164 591164 Crouch, Thomas, of Harwich, Essex, chapman 1
4755483 2282094 2282094 defendant Pollard William husbandman 591164 591164 Pollard, William, of Harwich, Essex, husbandman 1
4758280 2282965 2282965 defendant Pollard John yeoman 591164 591164 Pollard, John, of Harwich, Essex, yeoman 0
4772930 2287503 2287503 defendant Prudman Thomas chapman 591164 591164 Prudman, Thomas, of Harwich, Essex, "sercheour" or searcher, Dowell, John, of Rudham, Norf, chapman 2
4773899 2287815 2287815 defendant Polard John yeoman 591164 591164 Polard, John, of Harwich, Essex, alias of Dersham, yeoman 0
4807384 2298506 2298506 defendant Crouch Richard chapman 591164 591164 Crouch, Richard, of Harwich, Essex, chapman 0
4929284 2335577 2335577 defendant Draughton William   591164 591164 Draughton, William, of Harwich, Essex 1
4985869 2352692 2352692 plaintiff Andrew Thomas (legal representative) 591164 591164 Andrew, Thomas, of Harwich, Essex, executors of 0
4985894 2352697 2352697 plaintiff Andrewe Thomas (legal representative) 591164 591164 Andrewe, Thomas, of Harwich, Essex, executors of 0
4986281 2352824 2352824 defendant Codlyng Robert merchant 591164 591164 Codlyng, Robert, of Harwich, Essex, merchant 0
4991293 2354283 2354283 plaintiff Codlyng Robert merchant 591164 591164 Codlyng, Robert, of Harwich, Essex, merchant 0
5002368 2357601 2357601 defendant Burwell John   591164 591164 Burwell, John, of Harwich, Essex, mason, formerly of Blaxhale 0
5002727 2357709 2357709 defendant Welles Clement chapman 591164 591164 Welles, Clement, of Harwich, Essex, chapman 0
5006750 2358870 2358870 defendant Welles Clcment chapman 591164 591164 Welles, Clcment, of Harwich, Essex, chapman 4
5015885 2361537 2361537 defendant Draughton William merchant 591164 591164 Draughton, William, of Harwich, Essex, merchant 2
5092566 2384202 2384202 defendant Dene Thomas tailor 591164 591164 Dene, Thomas, of Harwich, Essex, tailor 0
5095023 2384957 2384957 defendant Draughton William merchant 591164 591164 Draughton, William, of Harwich, Essex, merchant 0
5155512 2402772 2402772 defendant Deken Thomas husbandman 591164 591164 Deken, Thomas, of Harwich, Essex, husbandman 1
5172118 2407564 2407564 defendant Deken Thomas husbandman 591164 591164 Deken, Thomas, of Harwich, Essex, husbandman 1
5184833 2411312 2411312 defendant Drawsuerd Richard yeoman 591164 591164 Drawsuerd, Richard, of Harwich, Essex, yeoman 4
5191240 2413177 2413177 defendant Deken Thomas husbandman 591164 591164 Deken, Thomas, of Harwich, Essex, husbandman 1
5191243 2413178 2413178 defendant Deken Thomas husbandman 591164 591164 Deken, Thomas, of Harwich, Essex, husbandman 0
5200734 2415971 2415971 defendant Broun John yeoman & bailiff 591164 591164 Broun, John, of Harwich, Essex, yeoman & bailiff 0
5200745 2415976 2415976 defendant Broun John yeoman & formerly bailiff 591164 591164 Broun, John, of Harwich, Essex, yeoman & formerly bailiff 0
5200747 2415977 2415977 defendant Brown John yeoman alias bailiff 591164 591164 Brown, John, of Harwich, Essex, yeoman alias bailiff 0
5204559 2417082 2417082 defendant Drawsnerd Richard yeoman 591164 591164 Drawsnerd, Richard, of Harwich, Essex, yeoman 3
5210994 2418949 2418949 defendant Hardberd John merchant 591164 591164 Hardberd, John, of Harwich, Essex, merchant 0
5210997 2418950 2418950 defendant Hareberd John merchant 591164 591164 Hareberd, John, of Harwich, Essex, merchant 0
5235446 2425946 2425946 defendant Burwell John, senior   591164 591164 Burwell, John, senior, of Harwich, Essex, mason 0
5291632 2442558 2442558 defendant Bush John merchant 591164 591164 Bush, John, of Harwich, Essex, merchant 0
5306218 2446845 2446845 defendant Power John yeoman 591164 591164 Power, John, of Harwich, Essex, yeoman 0
5315243 2449613 2449613 defendant Gregory William mariner 591164 591164 Gregory, William, of Harwich, Essex, mariner 4
5364403 2464529 2464529 defendant Hobbys Thomas butcher 591164 591164 Hobbys, Thomas, of Harwich, Essex, butcher 1
5374482 2467623 2467623 defendant (illegible) (illegible)   591164 591164 ----, ----, of Harwich, Essex, tallow chandler 0
5376732 2468321 2468321 defendant Sextey Margaret widow 591164 591164 Sextey, Margaret, of Harwich, Essex, widow 0
5398053 2474510 2474510 defendant Howard William yeoman 591164 591164 Howard, William, of Harwich, Essex, yeoman 0
5448882 2489558 2489558 defendant Martyn Eleanor widow 591164 591164 Martyn, Eleanor, of Harwich, Essex, widow 2
5476681 2498022 2498022 defendant Love William mariner 591164 591164 Love, William, of Harwich, Essex, mariner 0
5476685 2498023 2498023 defendant Love William mariner 591164 591164 Love, William, of Harwich, Essex, mariner 0
5527943 2513305 2513305 defendant Pyers William mariner 591164 591164 Pyers, William, of Harwich, Essex, mariner 0
5529169 2513635 2513635 defendant Pyers William mariner 591164 591164 Pyers, William, of Harwich, Essex, mariner 4
5589638 2531755 2531755 defendant Boycher William butcher 591164 591164 Boycher, William, of Harwich, Essex, butcher 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);