names

85 rows where place_id = 588385

✎ 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
3594318 1865855 1865855 defendant Sharp Edmund yeoman 588385 588385 Sharp, Edmund, of Steventon, yeoman 0
3607995 1870153 1870153 defendant Hopkyns John husbandman 588385 588385 Hopkyns, John, of Steventon, husbandman 0
3608475 1870311 1870311 defendant Sharp Edmund yeoman 588385 588385 Sharp, Edmund, of Steventon, yeoman 0
3615067 1872357 1872357 defendant Nicoll Robert husbandman 588385 588385 Nicoll, Robert, of Steventon, husbandman 1
3626673 1903188 1903188 defendant Baker Richard husbandman 588385 588385 Baker, Richard, of Steventon, husbandman 1
3661182 1913773 1913773 defendant Buker John butcher 588385 588385 Buker, John, of Steventon, butcher 1
3859781 1976772 1976772 defendant Derlyng Robert, junior husbandman 588385 588385 Derlyng, Robert, junior, of Steventon, husbandman 0
3859782 1976772 1976772 defendant Derlyng Robert, senior husbandman 588385 588385 Derlyng, Robert, senior, of Steventon, husbandman 1
3859783 1976772 1976772 defendant Lawrence John pulter 588385 588385 Lawrence, John, of Steventon, pulter 2
3859784 1976772 1976772 defendant Ratell John husbandman 588385 588385 Ratell, John, of Steventon, husbandman 3
3859785 1976772 1976772 defendant Pake Robert butcher 588385 588385 Pake, Robert, of Steventon, butcher 4
3874011 1981531 1981531 defendant Derlyng Robert, junior husbandman 588385 588385 Derlyng, Robert, junior, of Steventon, husbandman 0
3874012 1981531 1981531 defendant Derlyng Robert, senior husbandman 588385 588385 Derlyng, Robert, senior, of Steventon, husbandman 1
3874013 1981531 1981531 defendant Lawrence John poulter 588385 588385 Lawrence, John, of Steventon, poulter 2
3874014 1981531 1981531 defendant Ratell John husbandman 588385 588385 Ratell, John, of Steventon, husbandman 3
3874015 1981531 1981531 defendant Pake Robert husbandman 588385 588385 Pake, Robert, of Steventon, husbandman 4
4017207 2030859 2030859 plaintiff Taylor Robert yeoman 588385 588385 Taylor, Robert, of Steventon, yeoman 0
4244191 2111041 2111041 defendant Stuckey John husbandman 588385 588385 Stuckey, John, of Steventon, husbandman 0
4303175 2131235 2131235 defendant Crooke John yeoman 588385 588385 Crooke, John, of Steventon, yeoman 0
4307380 2132717 2132717 defendant Frysbie Richard yeoman 588385 588385 Frysbie, Richard, of Steventon, yeoman 0
4451862 2185562 2185562 defendant Crisp William   588385 588385 Crisp, William, of Steventon 1
4451863 2185562 2185562 defendant Crisp Richard   588385 588385 Crisp, Richard, of Steventon 2
4451864 2185562 2185562 defendant Tayllour Richard   588385 588385 Tayllour, Richard, of Steventon 3
4451870 2185562 2185562 defendant Dalot John   588385 588385 Dalot, John, of Steventon 9
4451872 2185562 2185562 defendant atte Hull William   588385 588385 atte Hull, William, of Steventon 11
4490686 2197787 2197787 plaintiff Warner William   588385 588385 Warner, William, of Steventon 0
4582936 2226090 2226090 defendant Smyth Thomas   588385 588385 Smyth, Thomas, of Steventon 1
4651450 2246459 2246459 defendant Smyth William smith 588385 588385 Smyth, William, of Steventon, smith 1
4661237 2249336 2249336 defendant Hipholde John husbandman 588385 588385 Hipholde, John, of Steventon, husbandman 4
4674128 2257515 2257515 defendant Clere Richard husbandman 588385 588385 Clere, Richard, of Steventon, husbandman 0
4692612 2263206 2263206 defendant Rouell William husbandman 588385 588385 Rouell, William, of Steventon, husbandman 1
4694727 2263846 2263846 defendant Chapman Nicholas husbandman 588385 588385 Chapman, Nicholas, of Steventon, husbandman 1
4710273 2268567 2268567 plaintiff Pullok William   588385 588385 Pullok, William, of Steventon 0
4715561 2270196 2270196 plaintiff Ware William (legal representative) 588385 588385 Ware, William, of Steventon, executors of 0
4715562 2270196 2270196 plaintiff Fysshere Richard   588385 588385 (Fysshere, Richard, of Steventon 1
4764333 2284840 2284840 defendant Wynchestre Joihn husbandman 588385 588385 Wynchestre, Joihn, of Steventon, husbandman 0
4765442 2285177 2285177 defendant Skarlet Robert draper 588385 588385 Skarlet, Robert, of Steventon, draper 0
4779083 2289434 2289434 defendant Doly Walter scrivener 588385 588385 Doly, Walter, of Steventon, scrivener 0
4812522 2300032 2300032 defendant Doo Richard husbandman 588385 588385 Doo, Richard, of Steventon, husbandman 0
4823517 2303444 2303444 defendant Walsheman Mathewe laborer 588385 588385 Walsheman, Mathewe, of Steventon, laborer 0
4863774 2315644 2315644 defendant de Lynne John (legal representative) 588385 588385 de Lynne, John, of Steventon, executors of 0
4863775 2315644 2315644 defendant Lynne John yeoman 588385 588385 (Lynne, John, of Steventon, yeoman 1
4886859 2322745 2322745 defendant Tuppa Walter gent 588385 588385 Tuppa, Walter, of Steventon, gent 0
4902704 2327464 2327464 defendant Tuppa Walter gent 588385 588385 Tuppa, Walter, of Steventon, gent 0
4929667 2335695 2335695 defendant Carter Nicholas chapman 588385 588385 Carter, Nicholas, of Steventon, chapman 0
4946766 2340990 2340990 defendant Carter Nicholas chapman 588385 588385 Carter, Nicholas, of Steventon, chapman 0
4969150 2347735 2347735 defendant Bryttewelton Richard, senior husbandman 588385 588385 Bryttewelton, Richard, senior, of Steventon, husbandman 0
4969152 2347735 2347735 defendant Bryttewelton John, junior husbandman 588385 588385 Bryttewelton, John, junior, of Steventon, husbandman 2
5145940 2399938 2399938 defendant Carpenter William carpenter 588385 588385 Carpenter, William, of Steventon, carpenter 0
5166252 2405850 2405850 defendant Carpenter William carpenter 588385 588385 Carpenter, William, of Steventon, carpenter 0
5181010 2410184 2410184 defendant Carpenter William carpenter 588385 588385 Carpenter, William, of Steventon, carpenter 0
5202688 2416548 2416548 defendant Carpenter William carpenter 588385 588385 Carpenter, William, of Steventon, carpenter 0
5249207 2429890 2429890 defendant Sharpe Edmund butcher 588385 588385 Sharpe, Edmund, of Steventon, butcher 4
5263003 2434171 2434171 plaintiff Plummer alias Webbe John (legal representative) 588385 588385 Plummer alias Webbe, John, of Steventon, executors of 0
5279910 2439200 2439200 defendant Sharp Edmund butcher 588385 588385 Sharp, Edmund, of Steventon, butcher 1
5280315 2439321 2439321 defendant Sharp Edmund butcher 588385 588385 Sharp, Edmund, of Steventon, butcher 1
5294098 2443248 2443248 defendant Wythe Simon husbandman 588385 588385 Wythe, Simon, of Steventon, husbandman 0
5294099 2443248 2443248 defendant Bromley William husbandman 588385 588385 Bromley, William, of Steventon, husbandman 1
5294101 2443248 2443248 defendant Smyte alias Clerk Thomas husbandman 588385 588385 Smyte alias Clerk, Thomas, of Steventon, husbandman 3
5294103 2443249 2443249 defendant Wythe Simon husbandman 588385 588385 Wythe, Simon, of Steventon, husbandman 0
5294105 2443249 2443249 defendant Smyte alias Clerk Thomas husbandman 588385 588385 Smyte alias Clerk, Thomas, of Steventon, husbandman 2
5300381 2445071 2445071 defendant Newenton Richard yeoman 588385 588385 Newenton, Richard, of Steventon, yeoman 0
5300382 2445071 2445071 defendant Heyward John butcher 588385 588385 Heyward, John, of Steventon, butcher 1
5317439 2450300 2450300 defendant Sharp Edmund butcher 588385 588385 Sharp, Edmund, of Steventon, butcher 0
5318780 2450706 2450706 defendant Fox Edmund gent 588385 588385 Fox, Edmund, of Steventon, gent 0
5331187 2454402 2454402 defendant Sharp Robert chapman 588385 588385 Sharp, Robert, of Steventon, chapman 1
5333702 2455153 2455153 defendant Merssh William yeoman 588385 588385 Merssh, William, of Steventon, yeoman 0
5349437 2459959 2459959 defendant Nicoll Gerard husbandman 588385 588385 Nicoll, Gerard, of Steventon, husbandman 0
5351728 2460641 2460641 plaintiff Doo Richard (legal representative) 588385 588385 Doo, Richard, of Steventon, executors of 0
5356988 2462247 2462247 defendant Boweche Thomas draper 588385 588385 Boweche, Thomas, of Steventon, draper 1
5431890 2484507 2484507 defendant Grene Richard clerk 588385 588385 Grene, Richard, of Steventon, clerk 0
5431893 2484508 2484508 defendant Grene Richard clerk 588385 588385 Grene, Richard, of Steventon, clerk 0
5436846 2485950 2485950 plaintiff Sharpe Edmund butcher 588385 588385 Sharpe, Edmund, of Steventon, butcher 0
5451449 2490307 2490307 plaintiff Sharpe Richard butcher 588385 588385 Sharpe, Richard, of Steventon, butcher 0
5463451 2493978 2493978 plaintiff Sharp Edmund butcher 588385 588385 Sharp, Edmund, of Steventon, butcher 0
5501638 2505445 2505445 defendant Sharp Edmund husbandman 588385 588385 Sharp, Edmund, of Steventon, husbandman 0
5501640 2505446 2505446 defendant Sharp Edmund yeoman 588385 588385 Sharp, Edmund, of Steventon, yeoman 0
5501642 2505446 2505446 defendant Sharp Robert yeoman 588385 588385 Sharp, Robert, of Steventon, yeoman 2
5501643 2505446 2505446 defendant Burley William butcher 588385 588385 Burley, William, of Steventon, butcher 3
5501644 2505446 2505446 defendant Hoppyns John husbandman 588385 588385 Hoppyns, John, of Steventon, husbandman 4
5501645 2505446 2505446 defendant Hamyssham Thomas husbandman 588385 588385 Hamyssham, Thomas, of Steventon, husbandman 5
5509230 2507744 2507744 defendant Gogyn Thomas husbandman 588385 588385 Gogyn, Thomas, of Steventon, husbandman 3
5545596 2518694 2518694 defendant Bolte John husbandman 588385 588385 Bolte, John, of Steventon, husbandman 1
5586503 2530817 2530817 defendant Sharp John husbandman 588385 588385 Sharp, John, of Steventon, husbandman 3
5606026 2536773 2536773 defendant Syssons Robert husbandman 588385 588385 Syssons, Robert, of Steventon, husbandman 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);