names

148 rows where place_id = 588779

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595548 1866243 1866243 defendant Munden Henry waterman 588779 588779 Munden, Henry, of Gravesend, waterman 0
3616455 1872785 1872785 defendant Owetelawe John laborer 588779 588779 Owetelawe, John, of Gravesend, laborer 0
3616456 1872785 1872785 defendant Sey John barber 588779 588779 Sey, John, of Gravesend, barber 1
3617669 1873151 1873151 defendant Flower William husbandman 588779 588779 Flower, William, of Gravesend, husbandman 2
3624281 1875129 1875129 defendant Stace John hackneyman 588779 588779 Stace, John, of Gravesend, hackneyman 0
3631645 1904711 1904711 defendant Yermouthe Thomas yeoman 588779 588779 Yermouthe, Thomas, of Gravesend, yeoman 0
3648694 1909979 1909979 defendant Gybson John husbandman 588779 588779 Gybson, John, of Gravesend, husbandman 0
3648695 1909979 1909979 defendant Fresell Edward husbandman 588779 588779 Fresell, Edward, of Gravesend, husbandman 1
3648696 1909979 1909979 defendant Ratesey James husbandman 588779 588779 Ratesey, James, of Gravesend, husbandman 2
3666410 1915445 1915445 defendant Yermouth Thomas   588779 588779 Yermouth, Thomas, of Gravesend, inn holder 0
3673774 1917825 1917825 defendant Steer William barber 588779 588779 Steer, William, of Gravesend, barber 2
3681121 1920178 1920178 defendant Redyng Thomas butcher 588779 588779 Redyng, Thomas, of Gravesend, butcher 0
3682457 1920612 1920612 defendant Redyng Thomas butcher 588779 588779 Redyng, Thomas, of Gravesend, butcher 2
3716326 1931396 1931396 defendant Laurence Richard mercer 588779 588779 Laurence, Richard, of Gravesend, mercer 0
3724455 1933934 1933934 defendant Pylbeme Thomas chandler 588779 588779 Pylbeme, Thomas, of Gravesend, chandler 0
3737199 1937866 1937866 plaintiff Laurence Richard   588779 588779 Laurence, Richard, of Gravesend 0
3758150 1944535 1944535 defendant Whitwang William yeoman 588779 588779 Whitwang, William, of Gravesend, yeoman 0
3856342 1975602 1975602 plaintiff Woode William   588779 588779 Woode, William, of Gravesend 0
3878647 1983105 1983105 defendant Norgynnay alias Skulkyn John shoemaker 588779 588779 Norgynnay alias Skulkyn, John, of Gravesend, shoemaker 0
3881366 1984034 1984034 defendant Fresyll Edmund yeoman 588779 588779 Fresyll, Edmund, of Gravesend, yeoman 1
3895704 1988769 1988769 defendant Twyne Ralph cordwainer 588779 588779 Twyne, Ralph, of Gravesend, cordwainer 0
3901972 1990888 1990888 defendant Davy John butcher 588779 588779 Davy, John, of Gravesend, butcher 0
3911923 1994312 1994312 defendant Spur Cuthbert yeoman 588779 588779 Spur, Cuthbert, of Gravesend, yeoman 0
3923618 1998210 1998210 defendant Dogett Nicholas yeoman 588779 588779 Dogett, Nicholas, of Gravesend, yeoman 0
3956172 2009231 2009231 defendant Kynderley Thomas weaver 588779 588779 Kynderley, Thomas, of Gravesend, weaver 0
3956173 2009231 2009231 defendant Chatweston John husbandman 588779 588779 Chatweston, John, of Gravesend, husbandman 1
3963621 2011886 2011886 defendant Williams William waterman 588779 588779 Williams, William, of Gravesend, waterman 2
3980874 2017922 2017922 plaintiff Potter Ambrose yeoman 588779 588779 Potter, Ambrose, of Gravesend, yeoman 0
3980876 2017923 2017923 plaintiff Potter Ambrose yeoman 588779 588779 Potter, Ambrose, of Gravesend, yeoman 0
3980877 2017923 2017923 defendant Gamble John innholder 588779 588779 Gamble, John, of Gravesend, innholder 0
3996238 2023406 2023406 plaintiff Darbyshere Edward (legal representative) 588779 588779 Darbyshere, Edward, of Gravesend, gent, executors of 0
3996243 2023407 2023407 plaintiff Darbyshere Edward (legal representative) 588779 588779 Darbyshere, Edward, of Gravesend, yeoman or gent, executors of 0
3999084 2024432 2024432 defendant Burnam Hugh innholder 588779 588779 Burnam, Hugh, of Gravesend, innholder 1
4009200 2028059 2028059 defendant Darbyshere Edward gent 588779 588779 (Darbyshere, Edward, of Gravesend, gent 1
4009201 2028059 2028059 defendant Darbyshere John   588779 588779 Darbyshere, John, of Gravesend 2
4009202 2028059 2028059 defendant Darbyshere William gent 588779 588779 together with Darbyshere, William, of Gravesend, gent 3
4009206 2028060 2028060 defendant Darbyshere Edward gent 588779 588779 together with Darbyshere, Edward, of Gravesend, gent 2
4011782 2028951 2028951 plaintiff Potter Ambrose yeoman 588779 588779 Potter, Ambrose, of Gravesend, yeoman 0
4026224 2034028 2034028 defendant Robynson James tapster 588779 588779 Robynson, James, of Gravesend, tapster 0
4045532 2040853 2040853 plaintiff Sampson John tailor 588779 588779 Sampson, John, of Gravesend, tailor 0
4046695 2041271 2041271 defendant Tyndeley or Tyndesley Thomas yeoman 588779 588779 Tyndeley or Tyndesley, Thomas, of Gravesend, yeoman 0
4046698 2041272 2041272 defendant Tyndeley or Tyndesley Thomas yeoman 588779 588779 Tyndeley or Tyndesley, Thomas, of Gravesend, yeoman 0
4048009 2041732 2041732 plaintiff Swaynland Thomas   588779 588779 Swaynland, Thomas, of Gravesend, yeoman, administrators of 0
4048012 2041733 2041733 plaintiff Swaynland Thomas   588779 588779 Swaynland, Thomas, of Gravesend, yeoman, administrators of 0
4073843 2050936 2050936 plaintiff Pratt Thomas waterman 588779 588779 Pratt, Thomas, of Gravesend, waterman 0
4073845 2050937 2050937 plaintiff Pratt Thomas waterman 588779 588779 Pratt, Thomas, of Gravesend, waterman 0
4226022 2104571 2104571 defendant Potter Robert gent 588779 588779 Potter, Robert, of Gravesend, gent 0
4242980 2110647 2110647 defendant Potter Robert gent 588779 588779 Potter, Robert, of Gravesend, gent 0
4307946 2132921 2132921 defendant Potter Robert yeoman 588779 588779 Potter, Robert, of Gravesend, yeoman 0
4314024 2135015 2135015 defendant Potter Robert gent 588779 588779 Potter, Robert, of Gravesend, gent 0
4318437 2136557 2136557 defendant Phillippe John hackneyman 588779 588779 Phillippe, John, of Gravesend, hackneyman 0
4353581 2148476 2148476 defendant Smith Abraham   588779 588779 Smith, Abraham, of Gravesend, gent, administrators of 0
4365281 2152645 2152645 defendant Tomson Richard butcher 588779 588779 Tomson, Richard, of Gravesend, butcher 0
4365283 2152646 2152646 defendant Tompson Richard butcher 588779 588779 Tompson, Richard, of Gravesend, butcher 0
4377842 2157144 2157144 defendant Smith Abraham   588779 588779 Smith, Abraham, of Gravesend, gent, administrators of 0
4378196 2157269 2157269 defendant Potter Robert yeoman 588779 588779 Potter, Robert, of Gravesend, yeoman 0
4402349 2165371 2165371 defendant Smythe Abraham   588779 588779 Smythe, Abraham, of Gravesend, gent, administrators of 0
4478540 2193954 2193954 defendant bocher Thomas   588779 588779 bocher, Thomas, of Gravesend 3
4496979 2199719 2199719 defendant Kenet Robert   588779 588779 Kenet, Robert, of Gravesend 3
4598944 2230892 2230892 defendant Sprenyr John   588779 588779 Sprenyr, John, of Gravesend 0
4615133 2235742 2235742 defendant Whappelode John   588779 588779 Whappelode, John, of Gravesend 0
4682488 2260149 2260149 defendant Sabyn John husbandman 588779 588779 Sabyn, John, of Gravesend, husbandman 0
4697154 2264587 2264587 defendant Mordon Thomas husbandman 588779 588779 Mordon, Thomas, of Gravesend, husbandman 0
4697162 2264590 2264590 defendant Mordon Thomas husbandman 588779 588779 Mordon, Thomas, of Gravesend, husbandman 0
4708518 2268031 2268031 defendant Bylane John husbandman 588779 588779 Bylane, John, of Gravesend, husbandman 1
4709607 2268366 2268366 plaintiff Petigo John   588779 588779 Petigo, John, of Gravesend 0
4722026 2272217 2272217 defendant Moreden Thomas husbandman 588779 588779 Moreden, Thomas, of Gravesend, husbandman 0
4733668 2275708 2275708 defendant Spence John husbandman 588779 588779 Spence, John, of Gravesend, husbandman 0
4769635 2286479 2286479 defendant Moretoun Thomas husbandman 588779 588779 Moretoun, Thomas, of Gravesend, husbandman 0
4770991 2286905 2286905 defendant Heyward John shipman 588779 588779 Heyward, John, of Gravesend, shipman 0
4815512 2300956 2300956 defendant Cootyngham William chapman 588779 588779 Cootyngham, William, of Gravesend, chapman 1
4820230 2302396 2302396 defendant Stryke John chandler 588779 588779 Stryke, John, of Gravesend, chandler 6
4830783 2305655 2305655 defendant Lynton John ostler 588779 588779 Lynton, John, of Gravesend, ostler 0
4830784 2305655 2305655 defendant Rede John   588779 588779 Rede, John, of Gravesend, veriar or farrier 1
4833593 2306514 2306514 defendant Clerk William butcher 588779 588779 Clerk, William, of Gravesend, butcher 0
4840269 2308503 2308503 defendant Stowe John laborer 588779 588779 Stowe, John, of Gravesend, laborer 2
4841541 2308886 2308886 defendant Garnon John solder 588779 588779 Garnon, John, of Gravesend, solder 0
4845930 2310234 2310234 plaintiff Petigo John   588779 588779 Petigo, John, of Gravesend 0
4845957 2310242 2310242 defendant Gerard John smith 588779 588779 Gerard, John, of Gravesend, smith 1
4845987 2310249 2310249 defendant Morton Thomas   588779 588779 Morton, Thomas, of Gravesend 0
4852068 2312077 2312077 defendant Herlowe Richard husbandman 588779 588779 Herlowe, Richard, of Gravesend, husbandman 0
5069796 2377460 2377460 defendant Clerk Thomas butcher 588779 588779 Clerk, Thomas, of Gravesend, butcher 0
5145084 2399700 2399700 plaintiff Boote Robert   588779 588779 Boote, Robert, of Gravesend 0
5145147 2399724 2399724 plaintiff Botte Robert   588779 588779 Botte, Robert, of Gravesend 0
5158300 2403552 2403552 defendant Colle Richard water man 588779 588779 Colle, Richard, of Gravesend, water man 0
5165684 2405705 2405705 plaintiff Boote Robert   588779 588779 Boote, Robert, of Gravesend 0
5173919 2408071 2408071 defendant Colle Richard water man 588779 588779 Colle, Richard, of Gravesend, water man 0
5175331 2408475 2408475 defendant Bote Robert husbandman 588779 588779 Bote, Robert, of Gravesend, husbandman 1
5176177 2408723 2408723 defendant Martyn Richard gent 588779 588779 Martyn, Richard, of Gravesend, gent 0
5176277 2408750 2408750 defendant Hardy Thomas mariner 588779 588779 Hardy, Thomas, of Gravesend, mariner 0
5176428 2408791 2408791 defendant Morys William butcher 588779 588779 Morys, William, of Gravesend, butcher 1
5176495 2408813 2408813 defendant Bagshaugh Benedict gent 588779 588779 Bagshaugh, Benedict, of Gravesend, gent 0
5179974 2409876 2409876 plaintiff Boote Robert   588779 588779 Boote, Robert, of Gravesend 0
5194202 2414035 2414035 defendant Colle Richard water man 588779 588779 Colle, Richard, of Gravesend, water man 0
5198591 2415345 2415345 defendant Austen Maud widow 588779 588779 Austen, Maud, of Gravesend, widow 0
5236113 2426147 2426147 defendant Aubrey Richard   588779 588779 Aubrey, Richard, of Gravesend, bailiff 1
5287442 2441351 2441351 defendant Hayton John husbandman 588779 588779 Hayton, John, of Gravesend, husbandman 1
5287443 2441351 2441351 defendant Gunne Richard waterman 588779 588779 Gunne, Richard, of Gravesend, waterman 2
5287444 2441351 2441351 defendant Germyn John waterman 588779 588779 Germyn, John, of Gravesend, waterman 3
5292754 2442878 2442878 defendant Larkyn Geoffrey yeoman 588779 588779 Larkyn, Geoffrey, of Gravesend, yeoman 4

Next page

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