names

48 rows where place_id = 586708

✎ 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
3589438 1864334 1864334 defendant Gilez Thomas husbandman 586708 586708 Gilez, Thomas, of Brenchesley, husbandman 0
3590726 1864740 1864740 defendant Haler William husbandman 586708 586708 Haler, William, of Brenchesley, husbandman 0
3590727 1864740 1864740 defendant Mone Thomas laborer 586708 586708 Mone, Thomas, of Brenchesley, laborer 1
3613778 1871964 1871964 defendant Burre Robert husbandman 586708 586708 Burre, Robert, of Brenchesley, husbandman 0
3613781 1871964 1871964 defendant Burre William husbandman 586708 586708 Burre, William, of Brenchesley, husbandman 3
3620871 1874090 1874090 defendant Burre William husbandman 586708 586708 Burre, William, of Brenchesley, husbandman 0
3633518 1905295 1905295 defendant Symond William husbandman 586708 586708 Symond, William, of Brenchesley, husbandman 1
3633519 1905295 1905295 defendant Horsmonden Thomas laborer 586708 586708 Horsmonden, Thomas, of Brenchesley, laborer 2
3633524 1905296 1905296 defendant Symond alias Symcok William husbandman 586708 586708 Symond alias Symcok, William, of Brenchesley, husbandman 1
3642655 1908148 1908148 defendant Downer William husbandman 586708 586708 Downer, William, of Brenchesley, husbandman 0
3642656 1908148 1908148 defendant Downer Thomas laborer 586708 586708 Downer, Thomas, of Brenchesley, laborer 1
3642657 1908148 1908148 defendant Honyngton Elizabeth single woman 586708 586708 Honyngton, Elizabeth, of Brenchesley, single woman 2
3647065 1909476 1909476 plaintiff Kyppyng Thomas (legal representative) 586708 586708 Kyppyng, Thomas, of Brenchesley, executors of 0
3715085 1931014 1931014 defendant Godfrey Nicholas cooper 586708 586708 Godfrey, Nicholas, of Brenchesley, cooper 2
3728123 1935054 1935054 defendant Fordman Stephen husbandman 586708 586708 Fordman, Stephen, of Brenchesley, husbandman 0
3758040 1944499 1944499 defendant Cheseman Robert carpenter 586708 586708 Cheseman, Robert, of Brenchesley, carpenter 0
3772198 1948990 1948990 defendant Andrewe Edmund weaver 586708 586708 Andrewe, Edmund, of Brenchesley, weaver 2
3772199 1948990 1948990 defendant Bratyll William husbandman 586708 586708 Bratyll, William, of Brenchesley, husbandman 3
3783416 1952562 1952562 defendant Dow John butcher 586708 586708 Dow, John, of Brenchesley, butcher 0
3809174 1960752 1960752 defendant Moyse John wheeler 586708 586708 Moyse, John, of Brenchesley, wheeler 0
3813544 1962154 1962154 defendant Rotynbrygge John husbandman 586708 586708 Rotynbrygge, John, of Brenchesley, husbandman 0
3831072 1967603 1967603 defendant Robarde John yeoman 586708 586708 Robarde, John, of Brenchesley, yeoman 0
3838628 1970007 1970007 defendant Moyse John husbandman 586708 586708 Moyse, John, of Brenchesley, husbandman 4
3841467 1970910 1970910 defendant Moyse John yeoman 586708 586708 Moyse, John, of Brenchesley, yeoman 0
3848425 1973084 1973084 defendant Roberth George mercer 586708 586708 Roberth, George, of Brenchesley, mercer 0
3884437 1985065 1985065 defendant Bower John yeoman 586708 586708 Bower, John, of Brenchesley, yeoman 1
3899085 1989902 1989902 defendant Dan Roger husbandman 586708 586708 Dan, Roger, of Brenchesley, husbandman 2
4126429 2069737 2069737 defendant Ellys John tailor 586708 586708 Ellys, John, of Brenchesley, tailor 1
4619655 2237133 2237133 defendant Hellys Thomas   586708 586708 Hellys, Thomas, of Brenchesley 0
4667733 2255620 2255620 defendant Talbot Thomas   586708 586708 Talbot, Thomas, of Brenchesley 1
4670131 2256361 2256361 defendant Ougley or Ongley Richard husbandman 586708 586708 Ougley or Ongley, Richard, of Brenchesley, husbandman 0
4672699 2257103 2257103 defendant Poyle Gilbert thatcher 586708 586708 Poyle, Gilbert, of Brenchesley, thatcher 3
4672700 2257103 2257103 defendant Cloute Thomas shoemaker 586708 586708 Cloute, Thomas, of Brenchesley, shoemaker 4
4695409 2264042 2264042 defendant Ongley Richard husbandman 586708 586708 Ongley, Richard, of Brenchesley, husbandman 0
4792539 2293756 2293756 defendant Cloud William tailor 586708 586708 Cloud, William, of Brenchesley, tailor 2
4995679 2355550 2355550 defendant Clement John, sen husbandman 586708 586708 Clement, John, sen, of Brenchesley, husbandman 0
4995680 2355550 2355550 defendant Clement John laborer 586708 586708 Clement, John, of Brenchesley, laborer 1
5183689 2410963 2410963 defendant Tebbe Thomas yeoman 586708 586708 Tebbe, Thomas, of Brenchesley, yeoman 0
5328868 2453711 2453711 defendant Kyppyng Robert yeoman 586708 586708 Kyppyng, Robert, of Brenchesley, yeoman 2
5484259 2500218 2500218 defendant Golde Richard cordwainer 586708 586708 Golde, Richard, of Brenchesley, cordwainer 2
5484264 2500219 2500219 defendant Golde Richard cordwainer 586708 586708 Golde, Richard, of Brenchesley, cordwainer 2
5494235 2503179 2503179 defendant at Mille William husbandman 586708 586708 at Mille, William, of Brenchesley, husbandman 0
5552504 2520788 2520788 defendant Honyngton Paul gent 586708 586708 Honyngton, Paul, of Brenchesley, gent 0
5589780 2531795 2531795 defendant Bratyll Richard husbabndman 586708 586708 Bratyll, Richard, of Brenchesley, husbabndman 2
5597490 2534116 2534116 defendant Downer William laborer 586708 586708 Downer, William, of Brenchesley, laborer 0
5607646 2537289 2537289 defendant Vynsherst John   586708 586708 Vynsherst, John, of Brenchesley, millwright 0
5607647 2537289 2537289 defendant Drabull John carpenter 586708 586708 Drabull, John, of Brenchesley, carpenter 1
5607648 2537289 2537289 defendant Hucchon John laborer 586708 586708 Hucchon, John, of Brenchesley, laborer 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);