names

121 rows where place_id = 589306

✎ 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
3597158 1866735 1866735 defendant Dey alias Ponde Andrew husbandman 589306 589306 Dey alias Ponde, Andrew, of Catfeld, husbandman 0
3597160 1866735 1866735 defendant Clerk William laborer 589306 589306 Clerk, William, of Catfeld, laborer 2
3619558 1873685 1873685 defendant Gedgebald Henry tailor 589306 589306 Gedgebald, Henry, of Catfeld, tailor 1
3620562 1874007 1874007 defendant Grey Robert husbandman 589306 589306 Grey, Robert, of Catfeld, husbandman 0
3620564 1874008 1874008 defendant Haddon Robert husbandman 589306 589306 Haddon, Robert, of Catfeld, husbandman 0
3620566 1874008 1874008 defendant Martyns Robert husbandman 589306 589306 Martyns, Robert, of Catfeld, husbandman 2
3628622 1903826 1903826 defendant Brady John clerk 589306 589306 Brady, John, of Catfeld, clerk 0
3653884 1911479 1911479 defendant Bottys Robert husbandman 589306 589306 Bottys, Robert, of Catfeld, husbandman 0
3662160 1914082 1914082 defendant Grave Nicholas yeoman 589306 589306 Grave, Nicholas, of Catfeld, yeoman 0
3663258 1914434 1914434 defendant Battys Robert hsubandman 589306 589306 Battys, Robert, of Catfeld, hsubandman 0
3671513 1917073 1917073 defendant Brady John chaplain 589306 589306 Brady, John, of Catfeld, chaplain 0
3685682 1921680 1921680 defendant Grave Nicholas gent 589306 589306 Grave, Nicholas, of Catfeld, gent 0
3689638 1922919 1922919 defendant Brade John clerk 589306 589306 Brade, John, of Catfeld, clerk 1
3702442 1927024 1927024 defendant Brady John clerk 589306 589306 Brady, John, of Catfeld, clerk 1
3705115 1927889 1927889 defendant Grave Nicholas gent 589306 589306 Grave, Nicholas, of Catfeld, gent 0
3706905 1928446 1928446 defendant Grave Nicholas gent 589306 589306 Grave, Nicholas, of Catfeld, gent 1
3716128 1931333 1931333 defendant Brady John clerk 589306 589306 Brady, John, of Catfeld, clerk 1
3724223 1933862 1933862 defendant Fayer John husbandman 589306 589306 Fayer, John, of Catfeld, husbandman 1
3734708 1937104 1937104 plaintiff Cook Henry   589306 589306 Cook, Henry, of Catfeld 1
3734709 1937104 1937104 defendant Rede Richard husbandman 589306 589306 Rede, Richard, of Catfeld, husbandman 0
3736945 1937803 1937803 defendant Grave Nicholas gent 589306 589306 Grave, Nicholas, of Catfeld, gent 4
3736951 1937804 1937804 defendant Grave Nicholas gent 589306 589306 Grave, Nicholas, of Catfeld, gent 4
3745780 1940583 1940583 defendant Coke Henry yeoman 589306 589306 Coke, Henry, of Catfeld, yeoman 0
3748390 1941427 1941427 defendant Empson William tailor 589306 589306 Empson, William, of Catfeld, tailor 0
3751319 1942337 1942337 defendant Johnson Thomas grocer 589306 589306 Johnson, Thomas, of Catfeld, grocer 1
3755848 1943779 1943779 defendant Jurdan Edward husbandman 589306 589306 Jurdan, Edward, of Catfeld, husbandman 0
3755850 1943780 1943780 defendant Jurdon Edward husbandman 589306 589306 Jurdon, Edward, of Catfeld, husbandman 0
3758137 1944531 1944531 defendant Jurdan Edmund husbandman 589306 589306 Jurdan, Edmund, of Catfeld, husbandman 1
3762788 1945999 1945999 defendant Estmore Thomas carpenter 589306 589306 Estmore, Thomas, of Catfeld, carpenter 2
3762957 1946046 1946046 defendant Jurden Edmund yeoman 589306 589306 Jurden, Edmund, of Catfeld, yeoman 1
3762964 1946047 1946047 defendant Jurdon Edmund yeoman 589306 589306 Jurdon, Edmund, of Catfeld, yeoman 1
3792036 1955361 1955361 defendant Bowyer John husbandman 589306 589306 Bowyer, John, of Catfeld, husbandman 0
3829089 1966979 1966979 defendant Fayerman John husbandman 589306 589306 Fayerman, John, of Catfeld, husbandman 0
3839547 1970293 1970293 defendant Halle George husbandman 589306 589306 Halle, George, of Catfeld, husbandman 1
3844816 1971922 1971922 defendant Baillys Thomas husbandman 589306 589306 Baillys, Thomas, of Catfeld, husbandman 2
3847634 1972829 1972829 defendant Grave Nicholas yeoman 589306 589306 Grave, Nicholas, of Catfeld, yeoman 2
3860004 1976845 1976845 defendant Fayreman John husbandman 589306 589306 Fayreman, John, of Catfeld, husbandman 7
3861166 1977211 1977211 defendant Lytle Philip husbandman 589306 589306 Lytle, Philip, of Catfeld, husbandman 2
3861189 1977218 1977218 defendant Lytle Philip husbandman 589306 589306 Lytle, Philip, of Catfeld, husbandman 2
3862990 1977819 1977819 defendant Bere John husbandman 589306 589306 Bere, John, of Catfeld, husbandman 1
3878822 1983168 1983168 defendant Fayerman John husbandman 589306 589306 Fayerman, John, of Catfeld, husbandman 0
3914520 1995200 1995200 defendant Reade Robert carpenter 589306 589306 Reade, Robert, of Catfeld, carpenter 1
3923989 1998334 1998334 defendant Jermy William gent 589306 589306 Jermy, William, of Catfeld, gent 0
3948792 2006643 2006643 defendant Amund John husbandman 589306 589306 Amund, John, of Catfeld, husbandman 4
3982890 2018657 2018657 defendant Levys Robert husbandman 589306 589306 Levys, Robert, of Catfeld, husbandman 1
4060874 2046295 2046295 defendant Boult George husbandman 589306 589306 Boult, George, of Catfeld, husbandman 0
4060875 2046295 2046295 defendant Graye John husbandman 589306 589306 Graye, John, of Catfeld, husbandman 1
4091992 2057431 2057431 defendant Graye John husbandman 589306 589306 Graye, John, of Catfeld, husbandman 2
4096279 2058999 2058999 defendant Bolte George husbandman 589306 589306 Bolte, George, of Catfeld, husbandman 0
4153287 2079247 2079247 defendant Bower George husbandman 589306 589306 Bower, George, of Catfeld, husbandman 0
4195411 2093940 2093940 defendant Padon Thomas husbandman 589306 589306 Padon, Thomas, of Catfeld, husbandman 1
4260130 2116352 2116352 defendant Buntyng William tailor 589306 589306 Buntyng, William, of Catfeld, tailor 0
4260132 2116352 2116352 defendant Nuse Edward husbandman 589306 589306 Nuse, Edward, of Catfeld, husbandman 2
4260133 2116352 2116352 defendant Sheldrake Richard husbandman 589306 589306 Sheldrake, Richard, of Catfeld, husbandman 3
4745882 2279300 2279300 defendant Bocher William yeoman 589306 589306 Bocher, William, of Catfeld, yeoman 1
4830177 2305482 2305482 defendant Gogebald Nicholas   589306 589306 Gogebald, Nicholas, of Catfeld, franklin 0
4830178 2305482 2305482 defendant Chirche Thomas yeoman 589306 589306 Chirche, Thomas, of Catfeld, yeoman 1
4830179 2305482 2305482 defendant Befeld Richard yeoman 589306 589306 Befeld, Richard, of Catfeld, yeoman 2
4837702 2307725 2307725 plaintiff Frysby William   589306 589306 Frysby, William, of Catfeld, parson of half the church 0
4837704 2307726 2307726 plaintiff Frysby William   589306 589306 Frysby, William, of Catfeld, parson of half the church 0
4837706 2307727 2307727 plaintiff Frysby William   589306 589306 Frysby, William, of Catfeld, parson of half the church 0
4837708 2307727 2307727 defendant atte Chyrche Thomas sadler alias husbandman 589306 589306 atte Chyrche, Thomas, of Catfeld, sadler alias husbandman 1
4837709 2307728 2307728 plaintiff Frysby William   589306 589306 Frysby, William, of Catfeld, parson of half the church, alias parson of Fylby 0
4837711 2307728 2307728 defendant atte Cherche Thomas sadler 589306 589306 atte Cherche, Thomas, of Catfeld, sadler 1
4845034 2309963 2309963 defendant Therne Robert yeoman 589306 589306 Therne, Robert, of Catfeld, yeoman 1
4857650 2313773 2313773 defendant Gegebald Richard husbandman 589306 589306 Gegebald, Richard, of Catfeld, husbandman 0
4865278 2316112 2316112 defendant Wode John husbandman 589306 589306 Wode, John, of Catfeld, husbandman 2
4885018 2322211 2322211 defendant Geggebald Nicholas yeoman 589306 589306 Geggebald, Nicholas, of Catfeld, yeoman 0
4948724 2341584 2341584 defendant Chirche Thomas husbandman 589306 589306 Chirche, Thomas, of Catfeld, husbandman 1
4962213 2345601 2345601 defendant Cobbe John yeoman 589306 589306 Cobbe, John, of Catfeld, yeoman 0
4962215 2345601 2345601 defendant atte Cherche Thomas yeoman 589306 589306 atte Cherche, Thomas, of Catfeld, yeoman 2
4976267 2349853 2349853 defendant Haghe John   589306 589306 Haghe, John, of Catfeld, wright 1
4981913 2351511 2351511 defendant Taillour Edmund yeoman 589306 589306 Taillour, Edmund, of Catfeld, yeoman 2
5011761 2360290 2360290 defendant Gegebald William husbandman 589306 589306 Gegebald, William, of Catfeld, husbandman 2
5016323 2361666 2361666 defendant Wode John husbandman 589306 589306 Wode, John, of Catfeld, husbandman 0
5022202 2363387 2363387 plaintiff Gegebald Nicholas, junior (legal representative) 589306 589306 Gegebald, Nicholas, junior, of Catfeld, executors of 0
5023327 2363729 2363729 defendant Wode John husbandman 589306 589306 Wode, John, of Catfeld, husbandman 0
5057373 2373773 2373773 defendant Iware John husbandman 589306 589306 Iware, John, of Catfeld, husbandman 0
5074607 2378907 2378907 defendant Hawe John   589306 589306 Hawe, John, of Catfeld, wright 1
5074608 2378907 2378907 defendant Potter John husbandman 589306 589306 Potter, John, of Catfeld, husbandman 2
5100508 2386570 2386570 defendant Hawe John carpenter 589306 589306 Hawe, John, of Catfeld, carpenter 0
5109519 2389214 2389214 plaintiff Gegebald John (legal representative) 589306 589306 Gegebald, John, of Catfeld, executors of 0
5112949 2390181 2390181 defendant Gegebald Nicholas clerk 589306 589306 Gegebald, Nicholas, of Catfeld, clerk 0
5136583 2397217 2397217 defendant Besteb-- John husbandman 589306 589306 Besteb--, John, of Catfeld, husbandman 3
5157125 2403223 2403223 defendant Befeld John husbandman 589306 589306 Befeld, John, of Catfeld, husbandman 3
5157132 2403224 2403224 defendant Lyncoln Thomas husbandman 589306 589306 Lyncoln, Thomas, of Catfeld, husbandman 4
5173167 2407862 2407862 defendant Befeld John husbandman 589306 589306 Befeld, John, of Catfeld, husbandman 2
5173174 2407863 2407863 defendant Lyncoln Thomas husbandman 589306 589306 Lyncoln, Thomas, of Catfeld, husbandman 4
5193032 2413690 2413690 defendant Lyncoln Thomas   589306 589306 Lyncoln, Thomas, of Catfeld 4
5196669 2414778 2414778 plaintiff Aylward John yeoman 589306 589306 Aylward, John, of Catfeld, yeoman 3
5201054 2416065 2416065 defendant Lyncoln William husbandman 589306 589306 Lyncoln, William, of Catfeld, husbandman 2
5209743 2418588 2418588 plaintiff Aylward John yeoman 589306 589306 Aylward, John, of Catfeld, yeoman 4
5239510 2427139 2427139 defendant Lyncoln Thomas yeoman 589306 589306 Lyncoln, Thomas, of Catfeld, yeoman 1
5243046 2428169 2428169 defendant Ederyk Richard yeoman 589306 589306 Ederyk, Richard, of Catfeld, yeoman 3
5255189 2431739 2431739 defendant Clubbe William laborer 589306 589306 Clubbe, William, of Catfeld, laborer 0
5255190 2431739 2431739 defendant Coryour John laborer 589306 589306 Coryour, John, of Catfeld, laborer 1
5300740 2445184 2445184 defendant Here John husbandman 589306 589306 Here, John, of Catfeld, husbandman 0
5326666 2453045 2453045 defendant Dekyn Geoffrey husbandman 589306 589306 Dekyn, Geoffrey, of Catfeld, husbandman 2
5353503 2461170 2461170 plaintiff Godered John   589306 589306 Godered, John, of Catfeld 0
5353504 2461170 2461170 plaintiff Haddon Seman, junior   589306 589306 Haddon, Seman, junior, of Catfeld 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);