names

136 rows where place_id = 592730

✎ 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
3608660 1870369 1870369 defendant Hakker Robert shipman 592730 592730 Hakker, Robert, of Bradwell, shipman 1
3609505 1870632 1870632 defendant Middilton John husbandman 592730 592730 Middilton, John, of Bradwell, husbandman 12
3609506 1870632 1870632 defendant Elot William husbandman 592730 592730 Elot, William, of Bradwell, husbandman 13
3609507 1870632 1870632 defendant Cokke Christopher husbandman 592730 592730 Cokke, Christopher, of Bradwell, husbandman 14
3609508 1870632 1870632 defendant Eyre Brian laborer 592730 592730 Eyre, Brian, of Bradwell, laborer 15
3618265 1873338 1873338 defendant Hakker Robert mariner 592730 592730 Hakker, Robert, of Bradwell, mariner 0
3637972 1906696 1906696 defendant Raffe Robert miller 592730 592730 Raffe, Robert, of Bradwell, miller 0
3641359 1907751 1907751 defendant Smyth Henry husbandman 592730 592730 Smyth, Henry, of Bradwell, husbandman 0
3650671 1910575 1910575 defendant Salman John husbandman 592730 592730 Salman, John, of Bradwell, husbandman 1
3650672 1910575 1910575 defendant Over William husbandman 592730 592730 Over, William, of Bradwell, husbandman 2
3655400 1911948 1911948 plaintiff (not given) Robert prior of Boston 592730 592730 Boston, Robert, of Bradwell, formerly prior of the same House & church 0
3655401 1911948 1911948 defendant (not given) John prior of Asshby 592730 592730 Asshby, John, of Bradwell, prior of the House & church of the Blessed Virgin Mary 0
3656054 1912146 1912146 defendant Catell Alexander husbandman 592730 592730 Catell, Alexander, of Bradwell, husbandman 0
3659737 1913297 1913297 defendant (not given) John prior of Ashly 592730 592730 Ashly, John, of Bradwell, prior of the Abbey of St Mary 0
3666415 1915446 1915446 defendant Thomson Robert laborer 592730 592730 Thomson, Robert, of Bradwell, laborer 3
3684460 1921272 1921272 defendant Smyth Henry husbandman 592730 592730 Smyth, Henry, of Bradwell, husbandman 0
3688368 1922517 1922517 defendant Webbe John husbandman 592730 592730 Webbe, John, of Bradwell, husbandman 0
3689353 1922836 1922836 defendant Kyrke Roger husbandman 592730 592730 Kyrke, Roger, of Bradwell, husbandman 0
3750849 1942187 1942187 plaintiff Lorkyn Arnold   592730 592730 (Lorkyn, Arnold, of Bradwell 1
3762925 1946036 1946036 defendant Smyth Henry husbandman 592730 592730 Smyth, Henry, of Bradwell, husbandman 0
3764975 1946710 1946710 defendant Glasyour John husbandman 592730 592730 Glasyour, John, of Bradwell, husbandman 0
3780587 1951657 1951657 defendant Costeyn Henry husbandman 592730 592730 Costeyn, Henry, of Bradwell, husbandman 2
3781086 1951821 1951821 defendant Johnson John husbandman 592730 592730 Johnson, John, of Bradwell, husbandman 0
3787775 1953966 1953966 defendant Page John goldsmith 592730 592730 Page, John, of Bradwell, goldsmith 3
3805279 1959596 1959596 defendant Carter John husbandman 592730 592730 Carter, John, of Bradwell, husbandman 0
3815141 1962655 1962655 defendant Johnson John husbandman 592730 592730 Johnson, John, of Bradwell, husbandman 0
3826926 1966272 1966272 defendant Askewe Leonard clerk 592730 592730 Askewe, Leonard, of Bradwell, clerk 0
3829642 1967162 1967162 defendant Clerk John husbandman 592730 592730 Clerk, John, of Bradwell, husbandman 2
3829989 1967275 1967275 defendant Furne Thomas carpenter 592730 592730 Furne, Thomas, of Bradwell, carpenter 1
3844681 1971879 1971879 defendant Clerk John husbandman 592730 592730 Clerk, John, of Bradwell, husbandman 1
3858053 1976169 1976169 defendant Askewe Leonard clerk 592730 592730 Askewe, Leonard, of Bradwell, clerk 0
3858055 1976170 1976170 defendant Askewe Leonard clerk 592730 592730 Askewe, Leonard, of Bradwell, clerk 0
3877884 1982846 1982846 defendant Fortye Thomas husbandman 592730 592730 Fortye, Thomas, of Bradwell, husbandman 0
3883623 1984792 1984792 defendant More Anthony gent 592730 592730 More, Anthony, of Bradwell, gent 0
3908965 1993292 1993292 defendant Muryell Agnes widow 592730 592730 Muryell, Agnes, of Bradwell, widow 0
3956643 2009388 2009388 defendant Harrold Robert yeoman 592730 592730 Harrold, Robert, of Bradwell, yeoman 0
3963530 2011852 2011852 defendant Clopton Henry (legal representative) 592730 592730 Clopton, Henry, of Bradwell, gent, executor of 0
3963533 2011853 2011853 defendant Clopton Henry (legal representative) 592730 592730 Clopton, Henry, of Bradwell, gent, executor of 0
4010181 2028408 2028408 defendant Smyth John husbandman 592730 592730 Smyth, John, of Bradwell, husbandman 2
4010835 2028650 2028650 plaintiff Peasse John husbandman 592730 592730 Peasse, John, of Bradwell, husbandman 0
4026047 2033963 2033963 plaintiff Burdock John (legal representative) 592730 592730 Burdock, John, of Bradwell, husbandman, executor of 0
4026050 2033964 2033964 plaintiff Burdock John (legal representative) 592730 592730 Burdock, John, of Bradwell, husbandman, executor of 0
4068115 2048902 2048902 defendant Flower Thomas husbandman 592730 592730 Flower, Thomas, of Bradwell, husbandman 1
4074912 2051330 2051330 defendant Pesse or Peaze John husbandman 592730 592730 Pesse or Peaze, John, of Bradwell, husbandman 0
4075591 2051574 2051574 defendant Pesse John husbandman 592730 592730 Pesse, John, of Bradwell, husbandman 0
4215233 2100822 2100822 defendant Doggett Robert gent 592730 592730 (Doggett, Robert, of Bradwell, gent 1
4216777 2101364 2101364 defendant Berrye John carpenter 592730 592730 Berrye, John, of Bradwell, carpenter 1
4241495 2110137 2110137 defendant Doggett Robert gent 592730 592730 (Doggett, Robert, of Bradwell, gent 1
4281594 2123469 2123469 defendant Delowe George   592730 592730 Delowe, George, of Bradwell, "gressman" 0
4308141 2132994 2132994 defendant Whitney William esq 592730 592730 Whitney, William, of Bradwell, esq 0
4308142 2132994 2132994 defendant Clopton Anthony gent 592730 592730 Clopton, Anthony, of Bradwell, gent 1
4337783 2142965 2142965 defendant Seridge John husbandman 592730 592730 Seridge, John, of Bradwell, husbandman 0
4352848 2148225 2148225 defendant Blake John   592730 592730 Blake, John, of Bradwell, shepherd 1
4393205 2162335 2162335 defendant Clarke Lawrence weaver 592730 592730 Clarke, Lawrence, of Bradwell, weaver 0
4425483 2172795 2172795 defendant Dunyng John   592730 592730 Dunyng, John, of Bradwell 0
4460156 2188234 2188234 defendant Whelere John   592730 592730 Whelere, John, of Bradwell 2
4530189 2209733 2209733 defendant Doune John   592730 592730 Doune, John, of Bradwell 0
4545260 2214438 2214438 defendant Salvage John   592730 592730 Salvage, John, of Bradwell 0
4547018 2215000 2215000 defendant Pecok Henry   592730 592730 Pecok, Henry, of Bradwell 0
4588348 2227746 2227746 defendant Bacheler John   592730 592730 Bacheler, John, of Bradwell 0
4617604 2236514 2236514 defendant Borliare William   592730 592730 Borliare, William, of Bradwell 1
4622772 2238099 2238099 defendant Coke William   592730 592730 Coke, William, of Bradwell, son of John 0
4672992 2257196 2257196 defendant Cottemore Thomas   592730 592730 Cottemore, Thomas, of Bradwell, milward 0
4679691 2259264 2259264 plaintiff Kyng isabel   592730 592730 Kyng, isabel, of Bradwell, formerly wife of Richard Kynge alias Pulter 0
4694346 2263733 2263733 plaintiff Bocher Edmund (legal representative) 592730 592730 Bocher, Edmund, of Bradwell, executors of 0
4699271 2265238 2265238 defendant Pacok John shipman 592730 592730 Pacok, John, of Bradwell, senior, shipman 1
4703043 2266335 2266335 defendant Estcourt John   592730 592730 Estcourt, John, of Bradwell, parson 0
4703045 2266335 2266335 defendant Bette Robert husbandman 592730 592730 Bette, Robert, of Bradwell, husbandman 2
4703047 2266335 2266335 defendant Irissh Peter chaplain 592730 592730 Irissh, Peter, of Bradwell, chaplain 4
4752012 2281084 2281084 defendant Boof Thomas clerk 592730 592730 Boof, Thomas, of Bradwell, clerk 0
4754252 2281708 2281708 defendant Cok Richard heoman 592730 592730 Cok, Richard, of Bradwell, heoman 0
4761265 2283871 2283871 defendant Idacok John, sen husbandman 592730 592730 Idacok, John, sen, of Bradwell, husbandman 0
4769125 2286320 2286320 defendant Wasshburn Richard husbandman 592730 592730 Wasshburn, Richard, of Bradwell, husbandman 0
4782141 2290416 2290416 defendant Weston John yeoman 592730 592730 Weston, John, of Bradwell, yeoman 0
4791178 2293342 2293342 defendant Cok John husbandman 592730 592730 Cok, John, of Bradwell, husbandman 2
4793414 2294046 2294046 defendant Sangger John weaver 592730 592730 Sangger, John, of Bradwell, weaver 1
4797643 2295442 2295442 defendant Jonys Richard husbandman 592730 592730 Jonys, Richard, of Bradwell, husbandman 0
4797644 2295442 2295442 defendant Jonys John laborer 592730 592730 Jonys, John, of Bradwell, laborer 1
4797661 2295449 2295449 defendant Jonys Richard husbandman 592730 592730 Jonys, Richard, of Bradwell, husbandman 0
4797662 2295449 2295449 defendant Jonys John laborer 592730 592730 Jonys, John, of Bradwell, laborer 1
4805497 2297930 2297930 defendant Hemmesby John husbandman 592730 592730 Hemmesby, John, of Bradwell, husbandman 0
4819347 2302126 2302126 defendant Scot John husbandman 592730 592730 Scot, John, of Bradwell, husbandman 3
4836825 2307479 2307479 defendant Busshop John husbandman 592730 592730 Busshop, John, of Bradwell, husbandman 0
4845341 2310055 2310055 defendant Godehyve James husbandman 592730 592730 Godehyve, James, of Bradwell, husbandman 0
4845342 2310055 2310055 defendant Rede William husbandman 592730 592730 Rede, William, of Bradwell, husbandman 1
4864099 2315748 2315748 defendant Busshop John husbandman 592730 592730 Busshop, John, of Bradwell, husbandman 0
4924446 2334083 2334083 defendant Stamford John husbandman 592730 592730 Stamford, John, of Bradwell, husbandman 2
4928391 2335300 2335300 defendant Conbrygge John   592730 592730 Conbrygge, John, of Bradwell, parson 3
4928397 2335302 2335302 defendant Coubrigge John   592730 592730 Coubrigge, John, of Bradwell, parson 1
4978526 2350528 2350528 defendant Midlyng Adam gent 592730 592730 Midlyng, Adam, of Bradwell, gent 0
5065137 2376106 2376106 defendant Alwey John husbandman 592730 592730 Alwey, John, of Bradwell, husbandman 0
5065139 2376107 2376107 defendant Alwey John husbandman 592730 592730 Alwey, John, of Bradwell, husbandman 0
5065141 2376108 2376108 defendant Alwey John husbandman 592730 592730 Alwey, John, of Bradwell, husbandman 0
5065143 2376109 2376109 defendant Alwey John husbandman 592730 592730 Alwey, John, of Bradwell, husbandman 0
5066924 2376632 2376632 defendant Spycer John yeoman 592730 592730 Spycer, John, of Bradwell, yeoman 1
5073554 2378575 2378575 defendant Buk John husbandman 592730 592730 Buk, John, of Bradwell, husbandman 0
5086204 2382362 2382362 defendant Pycot John husbandman 592730 592730 Pycot, John, of Bradwell, husbandman 0
5099390 2386251 2386251 defendant Bonde Robert mercer 592730 592730 Bonde, Robert, of Bradwell, mercer 0
5142586 2398960 2398960 defendant Sponer William husbandman 592730 592730 Sponer, William, of Bradwell, husbandman 0
5142587 2398960 2398960 defendant Sponer Robert husbandman 592730 592730 Sponer, Robert, of Bradwell, husbandman 1

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