names

107 rows where place_id = 601865

✎ 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
3615406 1872460 1872460 plaintiff Clere Elizabeth (legal representative) 601865 601865 Clere, Elizabeth, of Tacolneston, widow of Clere, Robert, of Ormesby, esq, executors of 0
3647345 1909555 1909555 defendant Sowthawe John yeoman 601865 601865 Sowthawe, John, of Tacolneston, yeoman 0
3647348 1909556 1909556 defendant Sowthehawe John yeoman 601865 601865 Sowthehawe, John, of Tacolneston, yeoman 0
3695989 1924985 1924985 defendant Broun John butcher 601865 601865 Broun, John, of Tacolneston, butcher 1
3695990 1924985 1924985 defendant Turnour Richard husbandman 601865 601865 Turnour, Richard, of Tacolneston, husbandman 2
3706545 1928331 1928331 plaintiff Isbellys William clerk 601865 601865 Isbellys, William, of Tacolneston, clerk 0
3706546 1928331 1928331 defendant Pertriche John carpenter 601865 601865 Pertriche, John, of Tacolneston, carpenter 0
3740620 1938927 1938927 defendant Seyntwary Robert smith 601865 601865 Seyntwary, Robert, of Tacolneston, smith 2
3746580 1940843 1940843 defendant Luce Robert husbandman 601865 601865 Luce, Robert, of Tacolneston, husbandman 6
3749691 1941815 1941815 plaintiff Isabellys William clerk 601865 601865 Isabellys, William, of Tacolneston, clerk 0
3764736 1946635 1946635 plaintiff Isabell William clerk 601865 601865 Isabell, William, of Tacolneston, clerk 0
3764740 1946636 1946636 plaintiff Isabelles William clerk 601865 601865 Isabelles, William, of Tacolneston, clerk 0
3809293 1960787 1960787 defendant Amore Henry husbandman 601865 601865 Amore, Henry, of Tacolneston, husbandman 0
3817228 1963304 1963304 defendant Broun Thoma husbandman 601865 601865 Broun, Thoma, of Tacolneston, husbandman 2
3841225 1970835 1970835 defendant Bexwell William husbandman 601865 601865 Bexwell, William, of Tacolneston, husbandman 0
3877815 1982822 1982822 defendant Isbellys Thomas carpenter 601865 601865 Isbellys, Thomas, of Tacolneston, carpenter 0
3921631 1997580 1997580 defendant Broun Robert butcher 601865 601865 Broun, Robert, of Tacolneston, butcher 0
3923554 1998186 1998186 defendant Andrewes John husbandman 601865 601865 Andrewes, John, of Tacolneston, husbandman 0
4037505 2038077 2038077 defendant Browen John yeoman 601865 601865 Browen, John, of Tacolneston, yeoman 0
4066784 2048420 2048420 defendant Isbell William yeoman 601865 601865 Isbell, William, of Tacolneston, yeoman 0
4075948 2051697 2051697 defendant Browne John yeoman 601865 601865 Browne, John, of Tacolneston, yeoman 5
4087518 2055832 2055832 defendant Isbels William yeoman 601865 601865 Isbels, William, of Tacolneston, yeoman 0
4115094 2065687 2065687 defendant Browne John, junior yeoman 601865 601865 Browne, John, junior, of Tacolneston, yeoman 0
4162503 2082447 2082447 defendant Bannyster John laborer 601865 601865 Bannyster, John, of Tacolneston, laborer 1
4172974 2086000 2086000 defendant Isbell William yeoman 601865 601865 Isbell, William, of Tacolneston, yeoman 0
4173267 2086111 2086111 plaintiff Dey Michael   601865 601865 Dey, Michael, of Tacolneston 0
4173268 2086111 2086111 defendant Bexwell William yeoman 601865 601865 Bexwell, William, of Tacolneston, yeoman 0
4173269 2086112 2086112 plaintiff Dey Michael   601865 601865 Dey, Michael, of Tacolneston 0
4173270 2086112 2086112 defendant Isbell William, senior yeoman 601865 601865 Isbell, William, senior, of Tacolneston, yeoman 0
4176143 2087130 2087130 defendant Gurney George clerk 601865 601865 Gurney, George, of Tacolneston, clerk 0
4178446 2087935 2087935 defendant Gurney George clerk 601865 601865 Gurney, George, of Tacolneston, clerk 0
4181067 2088853 2088853 defendant Bannyster John husbandman 601865 601865 Bannyster, John, of Tacolneston, husbandman 1
4187899 2091266 2091266 defendant Browne John yeoman 601865 601865 Browne, John, of Tacolneston, yeoman 2
4193664 2093352 2093352 defendant Gurney George clerk 601865 601865 Gurney, George, of Tacolneston, clerk 0
4193665 2093352 2093352 defendant Bexwell William yeoman 601865 601865 Bexwell, William, of Tacolneston, yeoman 1
4196595 2094356 2094356 defendant Gurney or Gurnell George clerk 601865 601865 Gurney or Gurnell, George, of Tacolneston, clerk 0
4198630 2095079 2095079 defendant Gurney George clerk 601865 601865 Gurney, George, of Tacolneston, clerk 0
4199358 2095328 2095328 defendant Isbelly Robert husbandman 601865 601865 Isbelly, Robert, of Tacolneston, husbandman 1
4199359 2095328 2095328 defendant Sherwyn William husbandman 601865 601865 Sherwyn, William, of Tacolneston, husbandman 2
4201491 2096068 2096068 defendant Bannyster John husbandman 601865 601865 Bannyster, John, of Tacolneston, husbandman 0
4205485 2097468 2097468 defendant Partricke Nicholas yeoman 601865 601865 Partricke, Nicholas, of Tacolneston, yeoman 0
4205486 2097468 2097468 defendant Isbell William yeoman 601865 601865 Isbell, William, of Tacolneston, yeoman 1
4205487 2097468 2097468 defendant Marshe Robert yeoman 601865 601865 Marshe, Robert, of Tacolneston, yeoman 2
4205488 2097468 2097468 defendant Marche Richard yeoman 601865 601865 Marche, Richard, of Tacolneston, yeoman 3
4212235 2099826 2099826 defendant Gurney George clerk 601865 601865 Gurney, George, of Tacolneston, clerk 0
4212387 2099881 2099881 defendant Bannyster John yeoman 601865 601865 Bannyster, John, of Tacolneston, yeoman 3
4218126 2101837 2101837 defendant Browne Robert yeoman 601865 601865 Browne, Robert, of Tacolneston, yeoman, son of Robert Browne, senior, of Tacolneston, yeoman 1
4221161 2102899 2102899 defendant Gurney George clerk 601865 601865 Gurney, George, of Tacolneston, clerk 0
4221162 2102899 2102899 defendant Browne Robert yeoman 601865 601865 Browne, Robert, of Tacolneston, yeoman, son of Robert Browne, senior, of Tacolneston, yeoman 1
4221163 2102899 2102899 defendant Peers John yeoman 601865 601865 Peers, John, of Tacolneston, yeoman 2
4226202 2104636 2104636 defendant Browne Robert husbandman 601865 601865 Browne, Robert, of Tacolneston, husbandman 3
4226464 2104728 2104728 defendant Gourney George clerk 601865 601865 Gourney, George, of Tacolneston, clerk 1
4226465 2104728 2104728 defendant Browne Robert yeoman 601865 601865 Browne, Robert, of Tacolneston, yeoman 2
4226466 2104728 2104728 defendant Peirs or Peirot John yeoman 601865 601865 Peirs or Peirot, John, of Tacolneston, yeoman 3
4226474 2104731 2104731 defendant Gourney George clerk 601865 601865 Gourney, George, of Tacolneston, clerk 0
4226475 2104731 2104731 defendant Browne Robert yeoman 601865 601865 Browne, Robert, of Tacolneston, yeoman 1
4226476 2104731 2104731 defendant Piers John yeoman 601865 601865 Piers, John, of Tacolneston, yeoman 2
4269938 2119530 2119530 defendant Isbells Henry yeoman 601865 601865 Isbells, Henry, of Tacolneston, yeoman 0
4276223 2121627 2121627 defendant Grene Thomas yeoman 601865 601865 Grene, Thomas, of Tacolneston, yeoman 3
4279916 2122888 2122888 defendant Barnes Daniel   601865 601865 Barnes, Daniel, of Tacolneston, apothecary 2
4281044 2123270 2123270 defendant Gurney George clerk 601865 601865 Gurney, George, of Tacolneston, clerk 0
4312582 2134535 2134535 defendant Grene Thomas yeoman 601865 601865 Grene, Thomas, of Tacolneston, yeoman 0
4315688 2135597 2135597 defendant Mylles John yeoman 601865 601865 Mylles, John, of Tacolneston, yeoman 1
4315689 2135597 2135597 defendant Hynde Richard tailor 601865 601865 Hynde, Richard, of Tacolneston, tailor 2
4316066 2135734 2135734 defendant Gurney George clerk 601865 601865 Gurney, George, of Tacolneston, clerk 2
4320704 2137336 2137336 defendant Syndall or Sendalle Geoffrey yeoman 601865 601865 Syndall or Sendalle, Geoffrey, of Tacolneston, yeoman 0
4325833 2139013 2139013 defendant Tuttell Richard husbandman 601865 601865 Tuttell, Richard, of Tacolneston, husbandman 2
4330101 2140366 2140366 defendant Browne Robert, junior yeoman 601865 601865 Browne, Robert, junior, of Tacolneston, yeoman 1
4345990 2145857 2145857 defendant Gurney George clerk 601865 601865 Gurney, George, of Tacolneston, clerk 0
4345991 2145857 2145857 defendant Bullytont John husbandman 601865 601865 Bullytont, John, of Tacolneston, husbandman 1
4345993 2145857 2145857 defendant Cullyn Thomas husbandman 601865 601865 Cullyn, Thomas, of Tacolneston, husbandman 3
4345996 2145858 2145858 defendant Style Roger husbandman 601865 601865 Style, Roger, of Tacolneston, husbandman 1
4353884 2148583 2148583 defendant Gurney George clerk 601865 601865 Gurney, George, of Tacolneston, clerk 0
4374941 2156097 2156097 defendant Isbell William, senior yeoman 601865 601865 Isbell, William, senior, of Tacolneston, yeoman 0
4403683 2165806 2165806 defendant Isbelles William, senior yeoman 601865 601865 Isbelles, William, senior, of Tacolneston, yeoman 0
4409823 2167888 2167888 defendant Hudson Thomas husbandman 601865 601865 Hudson, Thomas, of Tacolneston, or of Forncett, husbandman 1
4710115 2268517 2268517 defendant Talyour John chaplain 601865 601865 Talyour, John, of Tacolneston, chaplain 0
4766883 2285632 2285632 defendant Hokere Stephen husbandman 601865 601865 Hokere, Stephen, of Tacolneston, husbandman 1
4855284 2313005 2313005 defendant Aleyn John husbandman 601865 601865 Aleyn, John, of Tacolneston, husbandman 1
5085039 2382035 2382035 defendant Buk John husbandman 601865 601865 Buk, John, of Tacolneston, husbandman 3
5115772 2391039 2391039 defendant Buk John yeoman 601865 601865 Buk, John, of Tacolneston, yeoman 11
5128257 2394741 2394741 defendant Broun John yeoman 601865 601865 Broun, John, of Tacolneston, yeoman 0
5128258 2394741 2394741 defendant Chapman Thomas husbandman 601865 601865 Chapman, Thomas, of Tacolneston, husbandman 1
5128261 2394742 2394742 defendant Lyrlyng (illegible) husbandman 601865 601865 Lyrlyng, --, of Tacolneston, husbandman 1
5128262 2394742 2394742 defendant Bronster Robert husbandman 601865 601865 Bronster, Robert, of Tacolneston, husbandman 2
5128264 2394743 2394743 defendant Wadker Robert, junior husbandman 601865 601865 Wadker, Robert, junior, of Tacolneston, husbandman 0
5128265 2394743 2394743 defendant Turnour John husbandman 601865 601865 Turnour, John, of Tacolneston, husbandman 1
5128267 2394743 2394743 defendant Wacy Thomas loaborer 601865 601865 Wacy, Thomas, of Tacolneston, loaborer 3
5239172 2427046 2427046 defendant Barbour alias Lyrlyng Richard husbandman 601865 601865 Barbour alias Lyrlyng, Richard, of Tacolneston, husbandman 1
5243544 2428305 2428305 defendant Wasy John husbandman 601865 601865 Wasy, John, of Tacolneston, husbandman 0
5315073 2449562 2449562 defendant Mylsent Robert laborer 601865 601865 Mylsent, Robert, of Tacolneston, laborer 0
5506723 2507023 2507023 plaintiff Clere Elizabeth   601865 601865 Clere, Elizabeth, of Tacolneston 0
5506727 2507024 2507024 plaintiff Clere Elizabeth widow 601865 601865 Clere, Elizabeth, of Tacolneston, widow 0
5506729 2507025 2507025 plaintiff Clere Elizabeth widow 601865 601865 Clere, Elizabeth, of Tacolneston, widow 0
5520335 2511179 2511179 defendant Lone or Love John husbandman 601865 601865 Lone or Love, John, of Tacolneston, husbandman 0
5521343 2511492 2511492 plaintiff Clere Elizabeth (legal representative) 601865 601865 Clere, Elizabeth, of Tacolneston, widow of Clere, Robert, of Ormesby, esq, executor of 0
5521346 2511493 2511493 plaintiff Clere Elizabeth (legal representative) 601865 601865 Clere, Elizabeth, of Tacolneston, widow of Clere, Robert, of Ormesby, esq, executor of 0
5536325 2515849 2515849 defendant Southawe John husbandman 601865 601865 Southawe, John, of Tacolneston, husbandman 1
5571072 2526099 2526099 defendant Southawe John yeoman 601865 601865 Southawe, John, of Tacolneston, yeoman 4
5573178 2526705 2526705 defendant Southaugh John yeoman 601865 601865 Southaugh, John, of Tacolneston, yeoman 3

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