names

78 rows where place_id = 595849

✎ 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
3622125 1874455 1874455 defendant Warter John miller 595849 595849 Warter, John, of Cawod, miller 2
3674301 1918006 1918006 defendant Clerk Thomas yeoman 595849 595849 Clerk, Thomas, of Cawod, yeoman 0
3723658 1933674 1933674 defendant Lether William yeoman 595849 595849 Lether, William, of Cawod, yeoman 2
3827268 1966396 1966396 plaintiff Boswell Miles   595849 595849 Boswell, Miles, of Cawod 0
3841824 1971026 1971026 plaintiff Boswell Miles   595849 595849 Boswell, Miles, of Cawod 0
3881543 1984087 1984087 defendant Conyars Christopher gent 595849 595849 Conyars, Christopher, of Cawod, gent 1
3901106 1990596 1990596 defendant Romans John, junior   595849 595849 Romans, John, junior, of Cawod 0
3922432 1997818 1997818 defendant Clerk Robert chaplain 595849 595849 Clerk, Robert, of Cawod, chaplain 1
4439753 2181709 2181709 plaintiff Cok John   595849 595849 Cok, John, of Cawod 1
4443592 2182962 2182962 defendant Lawys Robert   595849 595849 Lawys, Robert, of Cawod 1
4460585 2188367 2188367 defendant Goye John   595849 595849 Goye, John, of Cawod 0
4495685 2199329 2199329 defendant Blakeman Thomas Jon-servant butcher 595849 595849 Blakeman, Thomas Jon-servant, of Cawod, butcher 0
4508151 2203025 2203025 defendant Cawod John de   595849 595849 Cawod, John de, of Cawod 0
4571033 2222508 2222508 defendant del Brwehous John   595849 595849 del Brwehous, John, of Cawod 0
4579207 2224979 2224979 defendant Stede Robert   595849 595849 Stede, Robert, of Cawod 0
4588312 2227736 2227736 defendant del Stede Robert   595849 595849 del Stede, Robert, of Cawod 0
4594282 2229473 2229473 defendant Serle Roger   595849 595849 Serle, Roger, of Cawod 1
4594285 2229473 2229473 defendant Brewhous John   595849 595849 Brewhous, John, of Cawod 4
4597265 2230388 2230388 defendant Stede Robert   595849 595849 Stede, Robert, of Cawod 0
4617030 2236335 2236335 defendant Brewehous John   595849 595849 Brewehous, John, of Cawod 3
4669027 2256018 2256018 defendant del Stede Robert yeoman 595849 595849 del Stede, Robert, of Cawod, yeoman 3
4682304 2260089 2260089 defendant Stede Robert yeoman 595849 595849 Stede, Robert, of Cawod, yeoman 0
4708189 2267941 2267941 defendant Grantham Thomas tiler 595849 595849 Grantham, Thomas, of Cawod, tiler 0
4710678 2268698 2268698 defendant Turnour John   595849 595849 Turnour, John, of Cawod, cap maker 0
4742166 2278202 2278202 defendant Bedemaker Robert bedmaker 595849 595849 Bedemaker, Robert, of Cawod, bedmaker 0
4742168 2278202 2278202 defendant Gunby John   595849 595849 Gunby, John, of Cawod, shipwright 2
4761617 2283978 2283978 defendant Soweleby Henry gent 595849 595849 Soweleby, Henry, of Cawod, gent 5
4761618 2283978 2283978 defendant Wyot Thomas clerk 595849 595849 Wyot, Thomas, of Cawod, clerk 6
4784862 2291274 2291274 defendant Tollerton Thomas barker 595849 595849 Tollerton, Thomas, of Cawod, barker 1
4785067 2291344 2291344 defendant Sowelby Henry gent 595849 595849 together with Sowelby, Henry, of Cawod, gent 2
4785068 2291344 2291344 defendant Wyot Thomas clerk 595849 595849 Wyot, Thomas, of Cawod, clerk 3
4787546 2292179 2292179 defendant Gosselyn John butcher 595849 595849 Gosselyn, John, of Cawod, butcher 0
4793086 2293930 2293930 defendant Scot Robert forester 595849 595849 Scot, Robert, of Cawod, forester 1
4805758 2298010 2298010 defendant Fayrfax John esq 595849 595849 Fayrfax, John, of Cawod, esq 0
4815244 2300879 2300879 defendant Scroby Henry yeoman 595849 595849 Scroby, Henry, of Cawod, yeoman 0
4822815 2303220 2303220 plaintiff Souleby Henry (legal representative) 595849 595849 Souleby, Henry, of Cawod, esq, executrix of 0
4822817 2303220 2303220 defendant Bowet Henry, junior clerk & Archdeacon of Richmond 595849 595849 Bowet, Henry, junior, of Cawod, clerk & Archdeacon of Richmond 0
4849072 2311182 2311182 plaintiff Souleby Henry (legal representative) 595849 595849 Souleby, Henry, of Cawod, esq, executors of 0
4876707 2319686 2319686 plaintiff Souleby Henry (legal representative) 595849 595849 Souleby, Henry, of Cawod, esq, executors of 0
4888684 2323253 2323253 defendant Fairchilde John husbandman 595849 595849 Fairchilde, John, of Cawod, husbandman 1
4898539 2326190 2326190 defendant Moslay Thomas skinner 595849 595849 Moslay, Thomas, of Cawod, skinner 0
4898540 2326190 2326190 defendant Barker Thomas barker 595849 595849 Barker, Thomas, of Cawod, barker 1
4930735 2336022 2336022 plaintiff Tupe Nicholas   595849 595849 Tupe, Nicholas, of Cawod 0
4954021 2343166 2343166 plaintiff Souleby Henry (legal representative) 595849 595849 Souleby, Henry, of Cawod, esq, executors of 0
4966907 2347031 2347031 defendant Watson William butcher 595849 595849 Watson, William, of Cawod, butcher 0
5070806 2377763 2377763 defendant Palden William gent 595849 595849 Palden, William, of Cawod, gent 3
5084289 2381809 2381809 defendant Carman Thomas yeoman 595849 595849 Carman, Thomas, of Cawod, yeoman 0
5096741 2385484 2385484 defendant Sayntpaule Thomas   595849 595849 Sayntpaule, Thomas, of Cawod, franklin 4
5107790 2388711 2388711 defendant Watson William butcher 595849 595849 Watson, William, of Cawod, butcher 1
5113535 2390348 2390348 defendant Holdernes John (legal representative) 595849 595849 Holdernes, John, of Cawod, or of Ledes, yeoman, executrix of 0
5120335 2392375 2392375 defendant Shoter John tilemaker 595849 595849 Shoter, John, of Cawod, tilemaker 4
5140040 2398190 2398190 defendant Soulby Henry gent 595849 595849 Soulby, Henry, of Cawod, gent 0
5140842 2398438 2398438 defendant St Paul Thomas   595849 595849 St Paul, Thomas, of Cawod 0
5161061 2404337 2404337 defendant Palden William   595849 595849 Palden, William, of Cawod, mason 0
5162001 2404620 2404620 defendant St Paul Thomas gent 595849 595849 St Paul, Thomas, of Cawod, gent 0
5175615 2408551 2408551 defendant Palden William   595849 595849 Palden, William, of Cawod, mason 0
5224424 2422817 2422817 defendant Thakwray James husbandman 595849 595849 Thakwray, James, of Cawod, husbandman 8
5224438 2422818 2422818 defendant Thakwray James husbandman 595849 595849 Thakwray, James, of Cawod, husbandman 8
5263556 2434349 2434349 defendant Smyth Thomas fisher 595849 595849 Smyth, Thomas, of Cawod, fisher 1
5352397 2460850 2460850 defendant Forman William, senior husbandman 595849 595849 Forman, William, senior, of Cawod, husbandman 0
5352398 2460850 2460850 defendant Forman William, junior laborer 595849 595849 Forman, William, junior, of Cawod, laborer 1
5352399 2460850 2460850 defendant Romanes Richard laborer 595849 595849 Romanes, Richard, of Cawod, laborer 2
5352400 2460850 2460850 defendant Stowe Thomas laborer 595849 595849 Stowe, Thomas, of Cawod, laborer 3
5373100 2467181 2467181 defendant Pawdon William   595849 595849 Pawdon, William, of Cawod, mason 0
5382156 2469955 2469955 defendant Paulden Robert gent 595849 595849 Paulden, Robert, of Cawod, gent 1
5390433 2472326 2472326 defendant Paulden William   595849 595849 Paulden, William, of Cawod 0
5390434 2472326 2472326 defendant Paulden Robert gent 595849 595849 Paulden, Robert, of Cawod, gent 1
5422227 2481595 2481595 defendant Haley Robert husbandman 595849 595849 Haley, Robert, of Cawod, husbandman 0
5443133 2487858 2487858 defendant Wrightyngton Henry gent 595849 595849 Wrightyngton, Henry, of Cawod, gent 0
5454653 2491312 2491312 defendant Barton Walter laborer 595849 595849 Barton, Walter, of Cawod, laborer 0
5454654 2491312 2491312 defendant Symmes William laborer 595849 595849 Symmes, William, of Cawod, laborer 1
5455835 2491650 2491650 defendant Wrightyngton Henry gent 595849 595849 Wrightyngton, Henry, of Cawod, gent 0
5467692 2495269 2495269 defendant Wrightington Henry gent 595849 595849 Wrightington, Henry, of Cawod, gent 0
5507417 2507214 2507214 plaintiff Dykson Robert   595849 595849 Dykson, Robert, of Cawod 1
5514963 2509519 2509519 defendant White Richard husbandman 595849 595849 White, Richard, of Cawod, husbandman 0
5578662 2528393 2528393 defendant Romans Robert husbandman 595849 595849 Romans, Robert, of Cawod, husbandman 0
5582764 2529681 2529681 defendant Bryndholme John yeoman 595849 595849 Bryndholme, John, of Cawod, yeoman 0
5610238 2546916 2546916 plaintiff atte Tounende John   595849 595849 atte Tounende, John, of Cawod 0

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