names

82 rows where place_id = 588388

✎ 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
3594329 1865858 1865858 defendant Person Isabel   588388 588388 Person, Isabel, of Boxley 0
3615203 1872400 1872400 defendant Hert John husbandman 588388 588388 Hert, John, of Boxley, husbandman 4
3619193 1873602 1873602 defendant Walley John laborer 588388 588388 Walley, John, of Boxley, laborer 3
3637193 1906432 1906432 defendant Borne Bartholomew husbandman 588388 588388 Borne, Bartholomew, of Boxley, husbandman 4
3674378 1918032 1918032 plaintiff Goldsmyth Peter   588388 588388 Goldsmyth, Peter, of Boxley 0
3693426 1924160 1924160 defendant Pett Reginald husbandman 588388 588388 Pett, Reginald, of Boxley, husbandman 0
3718985 1932217 1932217 defendant Master John husbandman 588388 588388 Master, John, of Boxley, husbandman 4
3718986 1932217 1932217 defendant Browne Edmund   588388 588388 Browne, Edmund, of Boxley, groom 5
3718987 1932217 1932217 defendant Austen Richard yeoman 588388 588388 Austen, Richard, of Boxley, yeoman 6
3734736 1937110 1937110 defendant Master John husbandman 588388 588388 Master, John, of Boxley, husbandman 4
3734737 1937110 1937110 defendant Austen Richard yeoman 588388 588388 Austen, Richard, of Boxley, yeoman 5
3738705 1938313 1938313 defendant Borne Bartholomew husbandman 588388 588388 Borne, Bartholomew, of Boxley, husbandman 0
3738706 1938313 1938313 defendant Smyth William husbandman 588388 588388 Smyth, William, of Boxley, husbandman 1
3738707 1938313 1938313 defendant Kember William husbandman 588388 588388 Kember, William, of Boxley, husbandman 2
3738708 1938313 1938313 defendant Rede William husbandman 588388 588388 Rede, William, of Boxley, husbandman 3
3738709 1938313 1938313 defendant Man John husbandman 588388 588388 Man, John, of Boxley, husbandman 4
3739458 1938550 1938550 defendant Bryce John husbandman 588388 588388 Bryce, John, of Boxley, husbandman 0
3773944 1949567 1949567 defendant Maister John   588388 588388 Maister, John, of Boxley 0
3827387 1966431 1966431 defendant at Wode Lawrence husbandman 588388 588388 at Wode, Lawrence, of Boxley, husbandman 0
3858511 1976324 1976324 defendant Atwood Lawrence husbandman 588388 588388 Atwood, Lawrence, of Boxley, husbandman 0
3860112 1976879 1976879 defendant Colney alias Coveney Gregory yeoman 588388 588388 Colney alias Coveney, Gregory, of Boxley, yeoman 0
3871218 1980627 1980627 defendant Tynley George yeoman 588388 588388 Tynley, George, of Boxley, yeoman 2
4002121 2025541 2025541 defendant Nott Peter gent 588388 588388 Nott, Peter, of Boxley, gent 1
4002124 2025542 2025542 defendant Nott Peter gent 588388 588388 Nott, Peter, of Boxley, gent 1
4002127 2025543 2025543 defendant Nott Peter gent 588388 588388 Nott, Peter, of Boxley, gent 1
4002522 2025668 2025668 defendant Gore William husbandman 588388 588388 Gore, William, of Boxley, husbandman 0
4002523 2025668 2025668 defendant Burbage John, junior husbandman 588388 588388 Burbage, John, junior, of Boxley, husbandman 1
4106342 2062558 2062558 defendant Wyat Edward gent 588388 588388 Wyat, Edward, of Boxley, gent 1
4111463 2064348 2064348 defendant Goodale William yeoman 588388 588388 Goodale, William, of Boxley, yeoman 0
4111466 2064349 2064349 defendant Vycars Stephen gent 588388 588388 Vycars, Stephen, of Boxley, gent 0
4112728 2064813 2064813 defendant Barnes William yeoman 588388 588388 Barnes, William, of Boxley, yeoman 0
4390305 2161379 2161379 defendant Burbage William yeoman 588388 588388 Burbage, William, of Boxley, yeoman 2
4408450 2167405 2167405 defendant Jennett Robert husbandman 588388 588388 Jennett, Robert, of Boxley, husbandman 0
4412245 2168686 2168686 defendant Stevenson Lancelot husbandman 588388 588388 Stevenson, Lancelot, of Boxley, husbandman 0
4693995 2263628 2263628 defendant Serle Richard laborer 588388 588388 Serle, Richard, of Boxley, laborer 0
4801528 2296659 2296659 defendant Assby John husbandman 588388 588388 Assby, John, of Boxley, husbandman 1
4838920 2308105 2308105 defendant Overstede John yeoman 588388 588388 Overstede, John, of Boxley, yeoman 0
4937971 2338251 2338251 defendant Benet John   588388 588388 Benet, John, of Boxley, mason 0
4937972 2338251 2338251 defendant Benet William   588388 588388 Benet, William, of Boxley, mason 1
5066423 2376485 2376485 defendant Asby Henry husbandman 588388 588388 Asby, Henry, of Boxley, husbandman 1
5071795 2378058 2378058 defendant Snelgar Richard husbandman 588388 588388 Snelgar, Richard, of Boxley, husbandman 0
5089023 2383166 2383166 defendant Asshby Henry husbandman 588388 588388 Asshby, Henry, of Boxley, husbandman 2
5103136 2387341 2387341 defendant Pastron Henry husbandman 588388 588388 Pastron, Henry, of Boxley, husbandman 0
5103137 2387341 2387341 defendant Lane Richard carpenter 588388 588388 Lane, Richard, of Boxley, carpenter 1
5103138 2387341 2387341 defendant Hale John laborer 588388 588388 Hale, John, of Boxley, laborer 2
5103139 2387341 2387341 defendant Beche Thomas laborer 588388 588388 Beche, Thomas, of Boxley, laborer 3
5127593 2394555 2394555 defendant Suelgar or Snelgar Richard yeoman 588388 588388 Suelgar or Snelgar, Richard, of Boxley, yeoman 0
5146613 2400146 2400146 defendant Snelgar Richard yeoman 588388 588388 Snelgar, Richard, of Boxley, yeoman 0
5166679 2405978 2405978 defendant Snelgare Richard yeoman 588388 588388 Snelgare, Richard, of Boxley, yeoman 0
5181647 2410374 2410374 defendant Snelgare Richard yeoman 588388 588388 Snelgare, Richard, of Boxley, yeoman 0
5185923 2411630 2411630 defendant Snelger Richard yeoman 588388 588388 Snelger, Richard, of Boxley, yeoman 2
5186518 2411805 2411805 defendant Stowe Walter laborer 588388 588388 Stowe, Walter, of Boxley, laborer 1
5186804 2411886 2411886 defendant Snelger Richard yeoman 588388 588388 Snelger, Richard, of Boxley, yeoman 2
5203010 2416642 2416642 defendant Snelgar Richard yeoman 588388 588388 Snelgar, Richard, of Boxley, yeoman 0
5206245 2417561 2417561 defendant Snelgar Richard yeoman 588388 588388 Snelgar, Richard, of Boxley, yeoman 0
5268731 2435973 2435973 defendant Colet William laborer 588388 588388 Colet, William, of Boxley, laborer 0
5268732 2435973 2435973 defendant Merywedyr Roger laborer 588388 588388 Merywedyr, Roger, of Boxley, laborer 1
5281574 2439677 2439677 defendant Gylder Roger laborer 588388 588388 Gylder, Roger, of Boxley, laborer 0
5293187 2442986 2442986 defendant Dore Richard yeoman 588388 588388 Dore, Richard, of Boxley, yeoman 8
5305363 2446611 2446611 defendant May Thomas smith 588388 588388 May, Thomas, of Boxley, smith 0
5356095 2461984 2461984 defendant Kember John yeoman 588388 588388 Kember, John, of Boxley, yeoman 1
5360529 2463322 2463322 defendant Creyke John husbandman 588388 588388 Creyke, John, of Boxley, husbandman 2
5360530 2463322 2463322 defendant Boland Robert husbandman 588388 588388 Boland, Robert, of Boxley, husbandman 3
5364893 2464689 2464689 defendant Sedcoppe Bernard laborer 588388 588388 Sedcoppe, Bernard, of Boxley, laborer 1
5366849 2465289 2465289 defendant Person William husbandman 588388 588388 Person, William, of Boxley, husbandman 2
5384689 2470705 2470705 defendant Munden John   588388 588388 Munden, John, of Boxley, vicar & clerk 0
5396670 2474136 2474136 defendant Munden John clerk & perpetual vicar 588388 588388 Munden, John, of Boxley, clerk & perpetual vicar 0
5396672 2474137 2474137 defendant Munden John clerk & vicar 588388 588388 Munden, John, of Boxley, clerk & vicar 0
5396674 2474138 2474138 defendant Munden John clerk & vicar 588388 588388 Munden, John, of Boxley, clerk & vicar 0
5455776 2491627 2491627 defendant Kember Thomas laborer 588388 588388 Kember, Thomas, of Boxley, laborer 2
5467599 2495238 2495238 defendant Kember Thomas laborer 588388 588388 Kember, Thomas, of Boxley, laborer 2
5477335 2498231 2498231 defendant Hayte John yeoman 588388 588388 Hayte, John, of Boxley, yeoman 0
5491952 2502502 2502502 defendant Chalyse Thomas husbandman 588388 588388 Chalyse, Thomas, of Boxley, husbandman 0
5491954 2502503 2502503 defendant Chalyse Thomas husbandman 588388 588388 Chalyse, Thomas, of Boxley, husbandman 0
5507478 2507235 2507235 defendant Gardon Robert (legal representative) 588388 588388 Gardon, Robert, of Boxley, yeoman, executor of 0
5511834 2508558 2508558 defendant Kymber Thomas laborer 588388 588388 Kymber, Thomas, of Boxley, laborer 0
5532420 2514682 2514682 defendant Hert John yeoman 588388 588388 Hert, John, of Boxley, yeoman 0
5541907 2517587 2517587 defendant Hert John husbandman 588388 588388 Hert, John, of Boxley, husbandman 0
5541908 2517587 2517587 defendant Hert Richard husbandman 588388 588388 Hert, Richard, of Boxley, husbandman 1
5564998 2524349 2524349 defendant Bukmer Margaret widow 588388 588388 Bukmer, Margaret, of Boxley, widow 1
5589782 2531795 2531795 defendant Wodde Thomas tiler 588388 588388 Wodde, Thomas, of Boxley, tiler 4
5602198 2535587 2535587 defendant Harte Arnold yeoman 588388 588388 Harte, Arnold, of Boxley, yeoman 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);