names

63 rows where place_id = 587448

✎ 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
3591441 1864950 1864950 defendant Mydylgate William yeoman 587448 587448 Mydylgate, William, of Brandeston, yeoman 2
3591442 1864950 1864950 defendant Corbrygge Thomas husbandman 587448 587448 Corbrygge, Thomas, of Brandeston, husbandman 3
3622694 1874627 1874627 defendant Midilgate Adam clerk 587448 587448 Midilgate, Adam, of Brandeston, clerk 1
3632404 1904953 1904953 defendant Thrower Henry butcher 587448 587448 Thrower, Henry, of Brandeston, butcher 0
3655583 1912009 1912009 plaintiff Braunche William   587448 587448 Braunche, William, of Brandeston 0
3795642 1956520 1956520 plaintiff Crapenell Thomas husbandman 587448 587448 Crapenell, Thomas, of Brandeston, husbandman 1
3812553 1961814 1961814 plaintiff Crapenell Robert   587448 587448 Crapenell, Robert, of Brandeston 0
4044710 2040556 2040556 defendant Mapes John clerk 587448 587448 Mapes, John, of Brandeston, clerk 0
4104943 2062045 2062045 defendant Bett Philip husbandman 587448 587448 Bett, Philip, of Brandeston, husbandman 0
4176991 2087426 2087426 defendant Baxter John husbandman 587448 587448 Baxter, John, of Brandeston, husbandman 3
4187748 2091217 2091217 defendant Baxter John yeoman 587448 587448 Baxter, John, of Brandeston, yeoman 0
4216900 2101407 2101407 defendant Sankye or Saukye Christopher clerk 587448 587448 Sankye or Saukye, Christopher, of Brandeston, clerk 0
4241540 2110154 2110154 defendant Godfrey Robert gent 587448 587448 Godfrey, Robert, of Brandeston, or of Guton Hall, gent 1
4251736 2113571 2113571 defendant Baxter William singleman 587448 587448 Baxter, William, of Brandeston, husbandman, singleman 0
4274088 2120881 2120881 defendant Godfrey Robert gent 587448 587448 Godfrey, Robert, of Brandeston, gent 0
4274089 2120881 2120881 defendant Haylock John yeoman 587448 587448 Haylock, John, of Brandeston, yeoman 1
4285540 2124878 2124878 defendant Godfrey Robert gent 587448 587448 Godfrey Robert, of Brandeston, gent 0
4291183 2126913 2126913 defendant Sankye or Saukye Christopher clerk 587448 587448 Sankye or Saukye, Christopher, of Brandeston, clerk 0
4291184 2126913 2126913 defendant Heylock William yeoman 587448 587448 Heylock, William, of Brandeston, yeoman 1
4337342 2142794 2142794 defendant Godfrey Robert gent 587448 587448 Godfrey, Robert, of Brandeston, or of Guton Hall, gent 0
4387602 2160492 2160492 defendant Godfrey Robert gent 587448 587448 Godfrey, Robert, of Brandeston, gent 0
4388206 2160685 2160685 defendant Godfrey Robert gent 587448 587448 Godfrey, Robert, of Brandeston, gent 0
4444878 2183372 2183372 defendant Taillour John   587448 587448 Taillour, John, of Brandeston 3
4453638 2186150 2186150 defendant Taillour Geoffrey le   587448 587448 Taillour, Geoffrey le, of Brandeston 0
4463441 2189260 2189260 defendant Tailour Geoffrey   587448 587448 Tailour, Geoffrey, of Brandeston 0
4464955 2189710 2189710 defendant Qyntteney Robert   587448 587448 Qyntteney, Robert, of Brandeston 0
4560699 2219295 2219295 defendant Hayward Ellis   587448 587448 Hayward, Ellis, of Brandeston 0
4602092 2231877 2231877 plaintiff Waryn John, sen   587448 587448 Waryn, John, sen, of Brandeston 0
4602093 2231877 2231877 defendant Wade William   587448 587448 Wade, William, of Brandeston 0
4641418 2243584 2243584 plaintiff Founteyn John   587448 587448 Founteyn, John, of Brandeston 0
4641419 2243584 2243584 defendant Esond Everard   587448 587448 Esond, Everard, of Brandeston 0
4656670 2247982 2247982 plaintiff Chapman John   587448 587448 Chapman, John, of Brandeston 0
4678150 2258775 2258775 defendant Symmys Margaret widow 587448 587448 Symmys, Margaret, of Brandeston, widow 4
4678151 2258775 2258775 defendant Strem William laborer 587448 587448 Strem, William, of Brandeston, laborer 5
4714130 2269749 2269749 defendant Chapman John   587448 587448 Chapman, John, of Brandeston, horse dealer 0
4714132 2269750 2269750 defendant Chapman John   587448 587448 Chapman, John, of Brandeston, corsour or horse dealer 0
4828081 2304826 2304826 defendant Folsham John clerk 587448 587448 Folsham, John, of Brandeston, clerk 0
5011286 2360160 2360160 defendant Botheman John butcher 587448 587448 Botheman, John, of Brandeston, butcher 0
5018981 2362444 2362444 defendant Style Edmund fuller 587448 587448 Style, Edmund, of Brandeston, fuller 0
5023209 2363689 2363689 plaintiff Reed Nicholas   587448 587448 Reed, Nicholas, of Brandeston 2
5031526 2366081 2366081 plaintiff Rede Nicholas   587448 587448 Rede, Nicholas, of Brandeston 0
5031531 2366082 2366082 plaintiff Rede Nicholas   587448 587448 Rede, Nicholas, of Brandeston 0
5031564 2366094 2366094 plaintiff Reed Nicholas yeoman 587448 587448 Reed, Nicholas, of Brandeston, yeoman 0
5031567 2366095 2366095 plaintiff Reed Nicholas yeoman 587448 587448 Reed, Nicholas, of Brandeston, yeoman 0
5069367 2377331 2377331 plaintiff Reed Nicholas   587448 587448 Reed, Nicholas, of Brandeston 0
5111936 2389879 2389879 defendant Corbrigge John tailor 587448 587448 Corbrigge, John, of Brandeston, tailor 0
5123643 2393373 2393373 defendant Kene Robert yeoman 587448 587448 Kene, Robert, of Brandeston, yeoman 0
5123644 2393373 2393373 defendant Wade Thomas yeoman 587448 587448 Wade, Thomas, of Brandeston, yeoman 1
5164336 2405305 2405305 defendant Heyth Ralph butcher 587448 587448 Heyth, Ralph, of Brandeston, butcher 1
5177597 2409142 2409142 defendant Heyth Ralph butcher 587448 587448 Heyth, Ralph, of Brandeston, butcher 1
5186609 2411834 2411834 defendant Botheman Robert husbandman 587448 587448 Botheman, Robert, of Brandeston, husbandman 0
5197707 2415072 2415072 defendant Corbrygge John husbandman 587448 587448 Corbrygge, John, of Brandeston, husbandman 2
5200322 2415852 2415852 defendant Curteys Richard husbandman 587448 587448 Curteys, Richard, of Brandeston, husbandman 1
5205274 2417298 2417298 defendant Botheman Robert husbandman 587448 587448 Botheman, Robert, of Brandeston, husbandman 0
5211422 2419073 2419073 defendant Curteys Richard husbandman 587448 587448 together with Curteys, Richard, of Brandeston, husbandman 1
5373741 2467379 2467379 defendant Corbrygge Thomas husbandman 587448 587448 Corbrygge, Thomas, of Brandeston, husbandman 0
5422516 2481680 2481680 defendant Corbrygge Thomas husbandman 587448 587448 Corbrygge, Thomas, of Brandeston, husbandman 1
5442162 2487573 2487573 defendant Corbrygge Thomas husbandman 587448 587448 Corbrygge, Thomas, of Brandeston, husbandman 1
5454900 2491383 2491383 defendant Corbrygge Thomas husbandman 587448 587448 Corbrygge, Thomas, of Brandeston, husbandman 1
5466744 2495000 2495000 defendant Corbrygge Thomas husbandman 587448 587448 Corbrygge, Thomas, of Brandeston, husbandman 1
5508454 2507513 2507513 defendant Middehate William husbandman 587448 587448 Middehate, William, of Brandeston, husbandman 3
5508455 2507513 2507513 defendant Isowde John husbandman 587448 587448 Isowde, John, of Brandeston, husbandman 4
5533149 2514914 2514914 defendant Broun Peter husbandman 587448 587448 Broun, Peter, of Brandeston, husbandman 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);