names

43 rows where place_id = 594744

✎ 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
3617417 1873067 1873067 defendant Broun John husbandman 594744 594744 Broun, John, of Welburn, husbandman 0
3717460 1931746 1931746 defendant Clerke John husbandman 594744 594744 Clerke, John, of Welburn, husbandman 0
3812800 1961899 1961899 defendant Hynde Robert husbandman 594744 594744 Hynde, Robert, of Welburn, husbandman 0
3893604 1988086 1988086 defendant Wyllyngton John husbandman 594744 594744 Wyllyngton, John, of Welburn, husbandman 1
4434345 2175502 2175502 plaintiff Killum Alan de   594744 594744 Killum, Alan de, of Welburn, parson 0
4544895 2214321 2214321 defendant Gamell Robert   594744 594744 Gamell, Robert, of Welburn 0
4595974 2229992 2229992 defendant Bernard Richard   594744 594744 Bernard, Richard, of Welburn 2
4659656 2248875 2248875 defendant Keld William yeoman 594744 594744 Keld, William, of Welburn, yeoman 0
4818208 2301771 2301771 defendant Tomson Henry shoemaker 594744 594744 Tomson, Henry, of Welburn, shoemaker 1
4821950 2302937 2302937 defendant Martyn William husbandman 594744 594744 Martyn, William, of Welburn, husbandman 3
4831043 2305738 2305738 defendant Philipp John chaplain 594744 594744 Philipp, John, of Welburn, chaplain 3
4832661 2306237 2306237 plaintiff Carter John (legal representative) 594744 594744 Carter, John, of Welburn, executor of 0
4859545 2314357 2314357 plaintiff Carter John (legal representative) 594744 594744 Carter, John, of Welburn, executors of 0
4911667 2330150 2330150 defendant Lanford William   594744 594744 Lanford, William, of Welburn, parson 1
4912452 2330400 2330400 plaintiff Cappe Henry   594744 594744 Cappe, Henry, of Welburn 0
4937214 2338006 2338006 defendant Thomson Henry yeoman 594744 594744 Thomson, Henry, of Welburn, yeoman 0
4955026 2343456 2343456 defendant Dervy John pedder 594744 594744 Dervy, John, of Welburn, pedder 2
4960370 2345070 2345070 plaintiff Wyllysford Thomas   594744 594744 Wyllysford, Thomas, of Welburn 1
4988456 2353507 2353507 defendant Colson John husbandman 594744 594744 Colson, John, of Welburn, husbandman 3
5012135 2360398 2360398 defendant Gaywod William chaplain 594744 594744 Gaywod, William, of Welburn, chaplain 4
5012306 2360452 2360452 defendant Martyn John laborer 594744 594744 Martyn, John, of Welburn, laborer 3
5035216 2367163 2367163 plaintiff Leton Robert   594744 594744 Leton, Robert, of Welburn 2
5037984 2367993 2367993 defendant Spycer John laborer 594744 594744 Spycer, John, of Welburn, laborer 0
5073253 2378488 2378488 defendant Stupton John husbandman 594744 594744 Stupton, John, of Welburn, husbandman 1
5113941 2390465 2390465 plaintiff Leton Robert   594744 594744 Leton, Robert, of Welburn 0
5113943 2390466 2390466 plaintiff Leton Robert   594744 594744 Leton, Robert, of Welburn 0
5127645 2394570 2394570 defendant Tyngell William husbandman 594744 594744 Tyngell, William, of Welburn, husbandman 0
5154404 2402444 2402444 plaintiff Leton Robert   594744 594744 Leton, Robert, of Welburn 0
5171497 2407386 2407386 plaintiff Leton Robert   594744 594744 Leton, Robert, of Welburn 0
5228020 2423805 2423805 defendant Hous Gilbert husbandman 594744 594744 Hous, Gilbert, of Welburn, husbandman 7
5305490 2446644 2446644 defendant Lamberd John husbandman 594744 594744 Lamberd, John, of Welburn, husbandman 2
5305494 2446645 2446645 defendant Lamberd John husbandman 594744 594744 Lamberd, John, of Welburn, husbandman 2
5323990 2452260 2452260 defendant Foulden John yeoman 594744 594744 Foulden, John, of Welburn, yeoman 4
5435398 2485528 2485528 defendant Ferrour Edmund yeoman 594744 594744 Ferrour, Edmund, of Welburn, yeoman 0
5490766 2502130 2502130 defendant Felmyngham Edmund chaplain 594744 594744 Felmyngham, Edmund, of Welburn, chaplain 0
5490770 2502131 2502131 defendant Felmyngham Edmund chaplain 594744 594744 Felmyngham, Edmund, of Welburn, chaplain 0
5493888 2503080 2503080 defendant Marys William clerk 594744 594744 Marys, William, of Welburn, clerk 0
5493890 2503081 2503081 defendant Marys William clerk 594744 594744 Marys, William, of Welburn, clerk 0
5527233 2513096 2513096 defendant Multon Thomas yeoman 594744 594744 Multon, Thomas, of Welburn, yeoman 4
5538640 2516567 2516567 defendant Fuldon William husbandman 594744 594744 Fuldon, William, of Welburn, husbandman 1
5550617 2520205 2520205 defendant Darby Robert husbandman 594744 594744 Darby, Robert, of Welburn, husbandman 0
5595018 2533410 2533410 defendant Clerk Thomas yeoman 594744 594744 Clerk, Thomas, of Welburn, yeoman 0
5617490 2549290 2549290 defendant Clerk John   594744 594744 Clerk, John, of Welburn 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);