names

83 rows where place_id = 597826

✎ 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
3630007 1904237 1904237 defendant Grace William gent 597826 597826 Grace, William, of Brampton, Hunts, gent 0
3791117 1955056 1955056 defendant Irelonde John husbandman 597826 597826 Irelonde, John, of Brampton, Hunts, husbandman 1
3791120 1955057 1955057 defendant Notyngham Thomas smith 597826 597826 Notyngham, Thomas, of Brampton, Hunts, smith 1
3828625 1966832 1966832 defendant Sterlyng Robert husbandman 597826 597826 Sterlyng, Robert, of Brampton, Hunts, husbandman 0
3828629 1966833 1966833 defendant Sterlyng Robert husbandman 597826 597826 Sterlyng, Robert, of Brampton, Hunts, husbandman 0
3865118 1978536 1978536 defendant Wyndesor George gent 597826 597826 Wyndesor, George, of Brampton, Hunts, gent 4
3884190 1984978 1984978 defendant Trece Thomas husbandman 597826 597826 Trece, Thomas, of Brampton, Hunts, husbandman 1
3932574 2001183 2001183 defendant Tesymond Adam husbandman 597826 597826 Tesymond, Adam, of Brampton, Hunts, husbandman 0
3944043 2005027 2005027 defendant Throkmarton Simon esq 597826 597826 Throkmarton, Simon, of Brampton, Hunts, esq 0
3993209 2022316 2022316 defendant Luddyngton John husbandman 597826 597826 Luddyngton, John, of Brampton, Hunts, husbandman 0
3993211 2022317 2022317 defendant Thodye Thomas yeoman 597826 597826 Thodye, Thomas, of Brampton, Hunts, yeoman 0
4006640 2027153 2027153 defendant Knolles Reginald yeoman 597826 597826 Knolles, Reginald, of Brampton, Hunts, yeoman 0
4028851 2034967 2034967 defendant Thody Thomas esq 597826 597826 Thody, Thomas, of Brampton, Hunts, yeoman, servant to Simon Throkmorton, of Branton, Hunts, esq 0
4028854 2034968 2034968 defendant Thodye Thomas esq 597826 597826 Thodye, Thomas, of Brampton, Hunts, yeoman, servant of Simon Throckmorton, of Brampton, esq 0
4030486 2035560 2035560 defendant Perpoynte Richard yeoman 597826 597826 Perpoynte, Richard, of Brampton, Hunts, yeoman 0
4030537 2035578 2035578 defendant Blunster Leonard yeoman 597826 597826 Blunster, Leonard, of Brampton, Hunts, yeoman 2
4030552 2035584 2035584 defendant Perpoynte Richard yeoman 597826 597826 Perpoynte, Richard, of Brampton, Hunts, yeoman 0
4030585 2035599 2035599 defendant Blunster Leonard yeoman 597826 597826 Blunster, Leonard, of Brampton, Hunts, yeoman 2
4042002 2039627 2039627 defendant Luddington John yeoman 597826 597826 Luddington, John, of Brampton, Hunts, yeoman 1
4055193 2044251 2044251 plaintiff Bell Alice widow 597826 597826 Bell, Alice, of Brampton, Hunts, widow 0
4055195 2044252 2044252 plaintiff Bell Alice widow 597826 597826 Bell, Alice, of Brampton, Hunts, widow 0
4098642 2059845 2059845 defendant Ventres Edward gent 597826 597826 Ventres, Edward, of Brampton, Hunts, gent 0
4151000 2078480 2078480 defendant Halle William yeoman 597826 597826 Halle, William, of Brampton, Hunts, yeoman 2
4163424 2082731 2082731 defendant Hedley William tanner 597826 597826 Hedley, William, of Brampton, Hunts, tanner 0
4238341 2109021 2109021 defendant Powell George butcher 597826 597826 Powell, George, of Brampton, Hunts, butcher 0
4269020 2119234 2119234 defendant Ayshton Gilbert yeoman 597826 597826 Ayshton, Gilbert, of Brampton, Hunts, yeoman 1
4285738 2124951 2124951 defendant Brande Richard yeoman 597826 597826 Brande, Richard, of Brampton, Hunts, yeoman 0
4285740 2124952 2124952 defendant Brande Richard yeoman 597826 597826 Brande, Richard, of Brampton, Hunts, yeoman 0
4285742 2124953 2124953 defendant Chapman Giles gent 597826 597826 Chapman, Giles, of Brampton, Hunts, gent 0
4285744 2124954 2124954 defendant Chapman Giles gent 597826 597826 Chapman, Giles, of Brampton, Hunts, gent 0
4679628 2259245 2259245 defendant Kyng Thomas yeoman 597826 597826 Kyng, Thomas, of Brampton, Hunts, yeoman 0
4695316 2264016 2264016 defendant Lucas William chapman 597826 597826 Lucas, William, of Brampton, Hunts, chapman 4
4706969 2267561 2267561 defendant Crosse John, sen husbandman 597826 597826 Crosse, John, sen, of Brampton, Hunts, husbandman 0
4706974 2267563 2267563 defendant Crosse John, sen husbandman 597826 597826 Crosse, John, sen, of Brampton, Hunts, husbandman 0
4730596 2274770 2274770 defendant Crosse John, sen husbandman 597826 597826 Crosse, John, sen, of Brampton, Hunts, husbandman 0
4755076 2281971 2281971 defendant Smyth Ralph smith 597826 597826 Smyth, Ralph, of Brampton, Hunts, smith 0
4770237 2286665 2286665 defendant Stydman William chapman 597826 597826 Stydman, William, of Brampton, Hunts, chapman 1
4884379 2322017 2322017 defendant Skynner William chapman 597826 597826 Skynner, William, of Brampton, Hunts, chapman 1
4890682 2323840 2323840 defendant Skynner William chapman 597826 597826 Skynner, William, of Brampton, Hunts, chapman 1
4903452 2327687 2327687 defendant Skynner William husbandman 597826 597826 Skynner, William, of Brampton, Hunts, husbandman 1
4908890 2329329 2329329 defendant Grethe William fuller 597826 597826 Grethe, William, of Brampton, Hunts, fuller 2
4914222 2330963 2330963 defendant Capron Henry butcher 597826 597826 Capron, Henry, of Brampton, Hunts, butcher 0
4925740 2334485 2334485 defendant Wraweley William clerk 597826 597826 Wraweley, William, of Brampton, Hunts, clerk 0
4934625 2337222 2337222 defendant Capron Henry butcher 597826 597826 Capron, Henry, of Brampton, Hunts, butcher 1
4974271 2349268 2349268 defendant Wynwyk John yeoman 597826 597826 Wynwyk, John, of Brampton, Hunts, yeoman 0
5039882 2368570 2368570 defendant Wraweby William   597826 597826 Wraweby, William, of Brampton, Hunts, parson 3
5062916 2375441 2375441 defendant Ive John husbandman 597826 597826 Ive, John, of Brampton, Hunts, husbandman 9
5131600 2395723 2395723 defendant Forster Gerard husbandman 597826 597826 Forster, Gerard, of Brampton, Hunts, husbandman 1
5131687 2395752 2395752 defendant Forster Gerard husbandman 597826 597826 Forster, Gerard, of Brampton, Hunts, husbandman 1
5151208 2401496 2401496 defendant Forster Gerard yeoman 597826 597826 Forster, Gerard, of Brampton, Hunts, yeoman 1
5154684 2402524 2402524 defendant Aleyn John tailor 597826 597826 Aleyn, John, of Brampton, Hunts, tailor 0
5154685 2402524 2402524 defendant Aleyn Richard husbandman 597826 597826 Aleyn, Richard, of Brampton, Hunts, husbandman 1
5154687 2402525 2402525 defendant Aleyn John tailor 597826 597826 Aleyn, John, of Brampton, Hunts, tailor 0
5154688 2402525 2402525 defendant Aleyn Richard husbandman 597826 597826 Aleyn, Richard, of Brampton, Hunts, husbandman 1
5162809 2404842 2404842 defendant Craweley William husbandman 597826 597826 Craweley, William, of Brampton, Hunts, husbandman 2
5171648 2407429 2407429 defendant Aleyn John tailor 597826 597826 Aleyn, John, of Brampton, Hunts, tailor 0
5176719 2408875 2408875 defendant Craueley William husbandman 597826 597826 Craueley, William, of Brampton, Hunts, husbandman 2
5176724 2408876 2408876 defendant Craueley William husbandman 597826 597826 Craueley, William, of Brampton, Hunts, husbandman 2
5190311 2412910 2412910 defendant Aleyn John tailor 597826 597826 Aleyn, John, of Brampton, Hunts, tailor 0
5190312 2412910 2412910 defendant Aleyn Richard husbandman 597826 597826 Aleyn, Richard, of Brampton, Hunts, husbandman 1
5199047 2415472 2415472 defendant Craueley William husbandman 597826 597826 Craueley, William, of Brampton, Hunts, husbandman 2
5210922 2418926 2418926 defendant Craueley William husbandman 597826 597826 Craueley, William, of Brampton, Hunts, husbandman 2
5317987 2450470 2450470 defendant Croxston John husbandman 597826 597826 Croxston, John, of Brampton, Hunts, husbandman 0
5333522 2455098 2455098 defendant Gryme William husbandman 597826 597826 Gryme, William, of Brampton, Hunts, husbandman 0
5335398 2455655 2455655 defendant Gryme William husbandman 597826 597826 Gryme, William, of Brampton, Hunts, husbandman 0
5353098 2461048 2461048 defendant Croxton John carter 597826 597826 Croxton, John, of Brampton, Hunts, carter 3
5353104 2461049 2461049 defendant Croxton John carter 597826 597826 Croxton, John, of Brampton, Hunts, carter 3
5386987 2471344 2471344 plaintiff Downe Thomas   597826 597826 Downe, Thomas, of Brampton, Hunts, rector & clerk 0
5399445 2474919 2474919 plaintiff Downe Thomas clerk & prebendary 597826 597826 Downe, Thomas, of Brampton, Hunts, clerk & prebendary 0
5399457 2474922 2474922 defendant Forster Gerard gent 597826 597826 Forster, Gerard, of Brampton, Hunts, gent 1
5412420 2478662 2478662 plaintiff Downe Thomas   597826 597826 Downe, Thomas, of Brampton, Hunts, clerk, rector & prebendary 0
5412440 2478667 2478667 defendant Forster Gerard gent 597826 597826 Forster, Gerard, of Brampton, Hunts, gent 1
5439234 2486662 2486662 defendant Crosse Thomas husbandman 597826 597826 Crosse, Thomas, of Brampton, Hunts, husbandman 2
5440944 2487198 2487198 defendant Crosse Thomas husbandman 597826 597826 Crosse, Thomas, of Brampton, Hunts, husbandman 3
5465028 2494446 2494446 defendant Crosse Thomas husbandman 597826 597826 Crosse, Thomas, of Brampton, Hunts, husbandman 3
5469542 2495814 2495814 plaintiff Downe Thomas clerk of the prebendary 597826 597826 Downe, Thomas, of Brampton, Hunts, clerk of the prebendary 0
5500553 2505102 2505102 defendant Greke Thomas gent 597826 597826 Greke, Thomas, of Brampton, Hunts, or of Polruan, gent 0
5500555 2505103 2505103 defendant Greke Thomas gent 597826 597826 Greke, Thomas, of Brampton, Hunts, or of Polruan, gent 0
5529964 2513876 2513876 defendant Salman John carrier 597826 597826 Salman, John, of Brampton, Hunts, carrier 0
5529966 2513877 2513877 defendant Salman John carrier 597826 597826 Salman, John,of Brampton, Hunts, carrier 0
5608663 2537611 2537611 plaintiff Downe Thomas   597826 597826 Downe, Thomas, of Brampton, Hunts, parson & clerk 0
5608667 2537612 2537612 plaintiff Downe Thomas   597826 597826 Downe, Thomas, of Brampton, Hunts, parson & priest 0
5614773 2548418 2548418 defendant Bole John   597826 597826 Bole, John, of Brampton, Hunts 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);