names

88 rows where place_id = 589219

✎ 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
3596929 1866672 1866672 defendant Hayton John yeoman 589219 589219 Hayton, John, of Gravesende, yeoman 2
3620779 1874072 1874072 defendant Pynke John (legal representative) 589219 589219 Pynke, John, of Gravesende, butcher, executors of 1
3620780 1874072 1874072 defendant Herde Henry butcher 589219 589219 (Herde, Henry, of Gravesende, butcher 2
3685587 1921645 1921645 defendant Ingold Richard husbandman 589219 589219 Ingold, Richard, of Gravesende, husbandman 0
3685588 1921645 1921645 defendant Smyth Richard laborer 589219 589219 Smyth, Richard, of Gravesende, laborer 1
3685589 1921645 1921645 defendant Rynold John laborer 589219 589219 Rynold, John, of Gravesende, laborer 2
3685680 1921679 1921679 defendant Ingold Richard husbandman 589219 589219 Ingold, Richard, of Gravesende, husbandman 0
3685986 1921776 1921776 plaintiff Blake John (legal representative) 589219 589219 Blake, John, of Gravesende, executor of 0
3686987 1922097 1922097 defendant Brownynge Robert innholder 589219 589219 Brownynge, Robert, of Gravesende, innholder 0
3686993 1922100 1922100 defendant Brownyng Robert innholder 589219 589219 Brownyng, Robert, of Gravesende, innholder 0
3692835 1923954 1923954 defendant Ingold Richard husbandman 589219 589219 Ingold, Richard, of Gravesende, husbandman 0
3712190 1930129 1930129 defendant Swaynlande Thomas yeoman 589219 589219 Swaynlande, Thomas, of Gravesende, yeoman 0
3776178 1950294 1950294 defendant Whipwand William yeoman 589219 589219 Whipwand, William, of Gravesende, yeoman 0
3923619 1998210 1998210 defendant Alburne Thomas baker 589219 589219 Alburne, Thomas, of Gravesende, baker 1
3923620 1998210 1998210 defendant Smythe Tilman shoemaker 589219 589219 Smythe, Tilman, of Gravesende, shoemaker 2
3955938 2009146 2009146 defendant Darbishire Edward yeoman 589219 589219 Darbishire, Edward, of Gravesende, yeoman 0
3958958 2010215 2010215 defendant Causton John husbandman 589219 589219 Causton, John, of Gravesende, husbandman 1
3993444 2022398 2022398 defendant Saunders Richard blacksmith 589219 589219 Saunders, Richard, of Gravesende, blacksmith 0
4006920 2027249 2027249 defendant Darbyshere Edward (legal representative) 589219 589219 Darbyshere, Edward, of Gravesende, yeoman, executors of 0
4006923 2027249 2027249 defendant Darbyshere John yeoman 589219 589219 Darbyshere, John, of Gravesende, yeoman 3
4009205 2028060 2028060 defendant Darbyshere William gent 589219 589219 (Darbyshere, William, of Gravesende, gent 1
4009207 2028060 2028060 defendant Darbyshere John yeoman 589219 589219 Darbyshere, John, of Gravesende, yeoman 3
4020226 2031956 2031956 defendant Tynnesley Thomas   589219 589219 Tynnesley, Thomas, of Gravesende, Kent yeoman 0
4055102 2044222 2044222 plaintiff Beare John mercer 589219 589219 Beare, John, of Gravesende, mercer 0
4198299 2094954 2094954 defendant Potter Robert yeoman 589219 589219 Potter, Robert, of Gravesende, yeoman 0
4450999 2185280 2185280 defendant Sutton Henry de   589219 589219 Sutton, Henry de, of Gravesende 2
4451000 2185280 2185280 defendant Gerlond Thomas   589219 589219 Gerlond, Thomas, of Gravesende 3
4458067 2187549 2187549 defendant Neve Agnes   589219 589219 Neve, Agnes, of Gravesende, wife of John 0
4496968 2199718 2199718 defendant Kent Richard de   589219 589219 Kent, Richard de, of Gravesende 3
4517942 2205991 2205991 plaintiff Daundelyon John   589219 589219 Daundelyon, John, of Gravesende 0
4595861 2229961 2229961 defendant Wappelode John   589219 589219 Wappelode, John, of Gravesende 3
4618771 2236872 2236872 defendant Curtays John   589219 589219 Curtays, John, of Gravesende 4
4618784 2236874 2236874 defendant curtaye John   589219 589219 curtaye, John, of Gravesende 7
4642595 2243952 2243952 defendant Curtays John   589219 589219 Curtays, John, of Gravesende 4
4647683 2245378 2245378 defendant Petygo John   589219 589219 Petygo, John, of Gravesende 0
4661914 2249573 2249573 defendant Pette John cordwainer 589219 589219 Pette, John, of Gravesende, cordwainer 2
4677984 2258731 2258731 defendant Colle John skinner 589219 589219 Colle, John, of Gravesende, skinner 0
4751695 2280984 2280984 defendant Hunt Henry shipman 589219 589219 Hunt, Henry, of Gravesende, shipman 0
4865561 2316193 2316193 defendant Flaxton Richard yeoman 589219 589219 Flaxton, Richard, of Gravesende, yeoman 0
4873581 2318681 2318681 defendant Morton Thomas   589219 589219 Morton, Thomas, of Gravesende 0
4927130 2334919 2334919 defendant Spaldyng Andrew chapman 589219 589219 Spaldyng, Andrew, of Gravesende, chapman 1
4927131 2334919 2334919 defendant Flour William chapman 589219 589219 Flour, William, of Gravesende, chapman 2
4932811 2336649 2336649 defendant Fullere John hosteler 589219 589219 Fullere, John, of Gravesende, hosteler 1
4938721 2338496 2338496 defendant Uttelawe John cordwainer 589219 589219 Uttelawe, John, of Gravesende, cordwainer 1
4969685 2347880 2347880 defendant Clement William shipman 589219 589219 Clement, William, of Gravesende, shipman 0
4969687 2347880 2347880 defendant Bryse Thomas husbandman 589219 589219 Bryse, Thomas, of Gravesende, husbandman 2
4974355 2349296 2349296 defendant Denant or Devant William hosteler 589219 589219 Denant or Devant, William, of Gravesende, hosteler 2
4980404 2351080 2351080 defendant Paxston William   589219 589219 Paxston, William, of Gravesende 0
4986141 2352778 2352778 defendant Payntour Nicholas laborer 589219 589219 Payntour, Nicholas, of Gravesende, laborer 0
4986142 2352778 2352778 defendant Malton John laborer 589219 589219 Malton, John, of Gravesende, laborer 1
5048330 2371134 2371134 defendant Seman Robert laborer 589219 589219 Seman, Robert, of Gravesende, laborer 0
5057617 2373846 2373846 defendant Thorneton Thomas laborer 589219 589219 Thorneton, Thomas, of Gravesende, laborer 0
5068084 2376959 2376959 defendant Boot Robert yeoman 589219 589219 Boot, Robert, of Gravesende, yeoman 0
5086243 2382370 2382370 defendant Fille William carpenter 589219 589219 Fille, William, of Gravesende, carpenter 2
5105638 2388099 2388099 defendant Moryce William husbandman 589219 589219 Moryce, William, of Gravesende, husbandman 1
5105639 2388099 2388099 defendant Mersshe John mariner 589219 589219 Mersshe, John, of Gravesende, mariner 2
5105640 2388099 2388099 defendant Fell William carpenter 589219 589219 Fell, William, of Gravesende, carpenter 3
5121439 2392701 2392701 defendant Gunne Richard husbandman 589219 589219 Gunne, Richard, of Gravesende, husbandman 2
5127142 2394415 2394415 defendant Thornton Thomas   589219 589219 Thornton, Thomas, of Gravesende, hackney man 0
5141285 2398574 2398574 defendant Bagshaugh Benedict gent 589219 589219 Bagshaugh, Benedict, of Gravesende, gent 0
5141421 2398607 2398607 defendant Laurens Gerard husbandman 589219 589219 Laurens, Gerard, of Gravesende, husbandman 3
5162330 2404708 2404708 defendant Morys William butcher 589219 589219 Morys, William, of Gravesende, butcher 2
5179977 2409877 2409877 plaintiff Boote Robert   589219 589219 Boote, Robert, of Gravesende 0
5193157 2413728 2413728 defendant Fouler Thomas husbandman 589219 589219 Fouler, Thomas, of Gravesende, husbandman 0
5216315 2420511 2420511 defendant Glover John baker 589219 589219 Glover, John, of Gravesende, baker 0
5235291 2425900 2425900 defendant Honchon Richard bucher 589219 589219 Honchon, Richard, of Gravesende, bucher 1
5237679 2426603 2426603 defendant Clerk Willim laborer 589219 589219 Clerk, Willim, of Gravesende, laborer 0
5246022 2429001 2429001 defendant Clerke Thomas butcher 589219 589219 Clerke, Thomas, of Gravesende, butcher 0
5263174 2434227 2434227 defendant Glover John baker 589219 589219 Glover, John, of Gravesende, baker 0
5279034 2438976 2438976 defendant Acton John husbandman 589219 589219 Acton, John, of Gravesende, husbandman 3
5335477 2455680 2455680 defendant Mendewe Stephen ironmonger 589219 589219 Mendewe, Stephen, of Gravesende, ironmonger 0
5336601 2456013 2456013 defendant Rotland William husbandman 589219 589219 Rotland, William, of Gravesende, husbandman 0
5343886 2458276 2458276 defendant Bocher William butcher 589219 589219 Bocher, William, of Gravesende, butcher 2
5344642 2458498 2458498 defendant Hochen William butcher 589219 589219 Hochen, William, of Gravesende, butcher 0
5351869 2460687 2460687 defendant Doget John yeoman 589219 589219 Doget, John, of Gravesende, yeoman 2
5364714 2464626 2464626 defendant Passhele John barber 589219 589219 Passhele, John, of Gravesende, barber 0
5365144 2464770 2464770 defendant Burston Matilda widow 589219 589219 Burston, Matilda, of Gravesende, widow 0
5365145 2464770 2464770 defendant Johnson Giles   589219 589219 Johnson, Giles, of Gravesende, shoe maker 1
5377191 2468457 2468457 defendant Baker John yeoman 589219 589219 Baker, John, of Gravesende, yeoman 2
5453190 2490835 2490835 defendant Classe Nicholas   589219 589219 Classe, Nicholas, of Gravesende 3
5488012 2501305 2501305 plaintiff Ussher John   589219 589219 Ussher, John, of Gravesende 0
5495392 2503524 2503524 defendant Stace William butcher 589219 589219 Stace, William, of Gravesende, butcher 0
5498789 2504576 2504576 defendant Hampton Thomas clerk 589219 589219 Hampton, Thomas, of Gravesende, clerk 1
5529607 2513759 2513759 defendant Stace John butcher 589219 589219 Stace, John, of Gravesende, butcher 2
5538124 2516413 2516413 defendant Plotte Richard waterman 589219 589219 Plotte, Richard, of Gravesende, waterman 2
5542590 2517807 2517807 defendant Clerke John   589219 589219 Clerke, John, of Gravesende, parish clerk 0
5542591 2517807 2517807 defendant Lyle alias Baker Thomas baker 589219 589219 Lyle alias Baker, Thomas, of Gravesende, baker 1
5581750 2529371 2529371 defendant Lyle Thomas baker 589219 589219 Lyle, Thomas, of Gravesende, baker 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);