names

79 rows where place_id = 608963

✎ 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
3676306 1918633 1918633 defendant Cotys Richard yeoman 608963 608963 Cotys, Richard, of Burley, yeoman 0
3714304 1930774 1930774 plaintiff Bayly John (legal representative) 608963 608963 Bayly, John, of Burley, plumber, executors of 0
3749072 1941640 1941640 defendant Calverley Robert gent 608963 608963 Calverley, Robert, of Burley, gent 0
3749073 1941640 1941640 defendant Thornhyll Henry yeoman 608963 608963 Thornhyll, Henry, of Burley, yeoman 1
3775740 1950162 1950162 defendant Sapcotys Edward esq 608963 608963 Sapcotys, Edward, of Burley, esq 0
3781678 1952011 1952011 defendant Calverley Robert gent 608963 608963 Calverley, Robert, of Burley, gent 0
3781679 1952011 1952011 defendant Thornhyll Henry yeoman 608963 608963 Thornhyll, Henry, of Burley, yeoman 1
3784419 1952909 1952909 defendant Hussey Robert gent 608963 608963 Hussey, Robert, of Burley, gent 0
3784420 1952909 1952909 defendant Banys Thomas yeoman 608963 608963 Banys, Thomas, of Burley, yeoman 1
3811140 1961380 1961380 defendant Johnson Richard yeoman 608963 608963 Johnson, Richard, of Burley, yeoman 2
3812358 1961757 1961757 defendant Barnesley Richard husbandman 608963 608963 Barnesley, Richard, of Burley, husbandman 0
3871005 1980555 1980555 defendant ap Rees David gent 608963 608963 ap Rees, David, of Burley, gent 3
3873469 1981343 1981343 defendant Dorston Philip husbandman 608963 608963 Dorston, Philip, of Burley, husbandman 0
3879978 1983562 1983562 defendant Sharpe Thomas husbandman 608963 608963 Sharpe, Thomas, of Burley, husbandman 0
3900787 1990492 1990492 plaintiff Cecyll Richard esq 608963 608963 Cecyll, Richard, of Burley, esq 0
3936011 2002361 2002361 defendant Vellam Henry husbandman 608963 608963 Vellam, Henry, of Burley, husbandman 0
3936012 2002361 2002361 defendant Smyth Robert laborer 608963 608963 Smyth, Robert, of Burley, laborer 1
3989793 2021097 2021097 plaintiff Batten William gent 608963 608963 Batten, William, of Burley, gent 0
4020001 2031883 2031883 defendant Mosse Thomas yeoman 608963 608963 Mosse, Thomas, of Burley, yeoman 0
4030284 2035485 2035485 plaintiff Dyke Thomas husbandman 608963 608963 Dyke, Thomas, of Burley, husbandman 0
4031029 2035769 2035769 defendant Sowden George tailor 608963 608963 Sowden, George, of Burley, tailor 0
4031034 2035769 2035769 defendant Watson William miller 608963 608963 Watson, William, of Burley, miller 5
4047388 2041522 2041522 defendant Farnell John yeoman 608963 608963 Farnell, John, of Burley, yeoman 0
4152009 2078813 2078813 defendant Dymmock Edward esq 608963 608963 Dymmock, Edward, of Burley, or of Skrielsby, Lincs, esq 0
4311915 2134304 2134304 defendant Dyson Edmund laborer 608963 608963 Dyson, Edmund, of Burley, laborer 2
4311916 2134304 2134304 defendant Dyson George husbandman 608963 608963 Dyson, George, of Burley, husbandman 3
4316872 2136018 2136018 defendant Crofte John laborer 608963 608963 Crofte, John, of Burley, laborer 1
4367279 2153353 2153353 defendant Bulman Robert yeoman 608963 608963 Bulman, Robert, of Burley, yeoman 1
4663694 2250127 2250127 defendant Pokker William husbandman 608963 608963 Pokker, William, of Burley, husbandman 1
4670721 2256522 2256522 defendant Lyndon John chaplain 608963 608963 (Lyndon, John, of Burley, chaplain 2
4670722 2256522 2256522 defendant Bendowe Robert yeoman 608963 608963 Bendowe, Robert, of Burley, yeoman 3
4686728 2261461 2261461 defendant Barker Richard husbandman 608963 608963 Barker, Richard, of Burley, husbandman 0
4686729 2261461 2261461 defendant Barker Nicholas laborer 608963 608963 Barker, Nicholas, of Burley, laborer 1
4717296 2270740 2270740 defendant Pykerd William yeoman 608963 608963 Pykerd, William, of Burley, yeoman 1
4755473 2282090 2282090 defendant Roggere William   608963 608963 Roggere, William, of Burley, wool man 0
4764805 2284973 2284973 defendant Barker Richard   608963 608963 Barker, Richard, of Burley, vicar 0
4765095 2285062 2285062 defendant Crowe John husbandman 608963 608963 Crowe, John, of Burley, husbandman 0
4771966 2287205 2287205 plaintiff Smyth John, sen   608963 608963 Smyth, John, sen, of Burley 0
4794235 2294335 2294335 defendant Spicer John   608963 608963 Spicer, John, of Burley, bailiff 1
4950473 2342114 2342114 defendant Parkyn John husbandman 608963 608963 Parkyn, John, of Burley, husbandman 4
5068458 2377066 2377066 defendant Couper William, senior husbandman 608963 608963 Couper, William, senior, of Burley, husbandman 0
5068459 2377066 2377066 defendant Couper Willia, junior husbandman 608963 608963 Couper, Willia, junior, of Burley, husbandman 1
5068460 2377066 2377066 defendant Lane William husbandman 608963 608963 Lane, William, of Burley, husbandman 2
5068461 2377066 2377066 defendant Wryght John husbandman 608963 608963 Wryght, John, of Burley, husbandman 3
5068462 2377066 2377066 defendant Dykeman Robert husbandman 608963 608963 Dykeman, Robert, of Burley, husbandman 4
5068463 2377066 2377066 defendant Coulle Nicholas husbandman 608963 608963 Coulle, Nicholas, of Burley, husbandman 5
5068467 2377067 2377067 defendant Goulle John pardoner 608963 608963 Goulle, John, of Burley, pardoner 0
5068468 2377067 2377067 defendant Goulle John husbandman 608963 608963 Goulle, John, of Burley, husbandman 1
5068469 2377067 2377067 defendant Parkyn John husbandman 608963 608963 Parkyn,John, of Burley, husbandman 2
5068470 2377067 2377067 defendant Felete John husbandman 608963 608963 Felete, John, of Burley, husbandman 3
5068471 2377067 2377067 defendant Homore John husbandman 608963 608963 Homore, John, of Burley, husbandman 4
5068475 2377068 2377068 defendant Holande Thomas husbandman 608963 608963 Holande, Thomas, of Burley, husbandman 0
5068476 2377068 2377068 defendant Saxby William husbandman 608963 608963 Saxby, William, of Burley, husbandman 1
5068477 2377068 2377068 defendant Goulle William husbandman 608963 608963 Goulle, William, of Burley, husbandman 2
5068478 2377068 2377068 defendant Lane John husbandman 608963 608963 Lane, John, of Burley, husbandman 3
5068479 2377068 2377068 defendant Goulle John husbandman 608963 608963 Goulle, John, of Burley, husbandman 4
5068483 2377069 2377069 defendant Rawelyn John husbandman 608963 608963 Rawelyn, John, of Burley, husbandman 0
5068484 2377069 2377069 defendant Marshall John husbandman 608963 608963 Marshall, John, of Burley, husbandman 1
5068485 2377069 2377069 defendant Smyth John husbandman 608963 608963 Smyth, John, of Burley, husbandman 2
5068486 2377069 2377069 defendant Walker John husbandman 608963 608963 Walker, John, of Burley, husbandman 3
5068487 2377069 2377069 defendant Laweton William husbandman 608963 608963 Laweton, William, of Burley, husbandman 4
5068488 2377069 2377069 defendant Smyth Richard husbandman 608963 608963 Smyth, Richard, of Burley, husbandman 5
5121205 2392631 2392631 defendant Golle William husbandman 608963 608963 Golle, William, of Burley, husbandman 0
5121708 2392777 2392777 defendant Jacson Thomas chaplain 608963 608963 Jacson, Thomas, of Burley, chaplain 3
5153810 2402274 2402274 defendant Jenkynson John husbandman 608963 608963 Jenkynson, John, of Burley, husbandman 0
5153811 2402274 2402274 defendant Jenkynson William smith 608963 608963 Jenkynson, William, of Burley, smith 1
5153812 2402274 2402274 defendant Jenkynson Richard laborer 608963 608963 Jenkynson, Richard, of Burley, laborer 2
5171081 2407266 2407266 defendant Jenkynson John husbandman 608963 608963 Jenkynson, John, of Burley, husbandman 0
5171082 2407266 2407266 defendant Jenkynson William smith 608963 608963 Jenkynson, William, of Burley, smith 1
5171083 2407266 2407266 defendant Jenkynson Richard laborer 608963 608963 Jenkynson, Richard, of Burley, laborer 2
5284989 2440632 2440632 defendant Scot Richard laborer 608963 608963 Scot, Richard, of Burley, laborer 1
5309682 2447933 2447933 defendant Jenkynson William husbandman 608963 608963 Jenkynson, William, of Burley, husbandman 4
5309683 2447933 2447933 defendant Wilson John husbandman 608963 608963 Wilson, John, of Burley, husbandman 5
5321129 2451418 2451418 defendant Dekynson Richard yeoman 608963 608963 Dekynson, Richard, of Burley, yeoman 0
5369872 2466165 2466165 plaintiff Fraunceys John (legal representative) 608963 608963 Fraunceys, John, of Burley, knight, executrix of 0
5455821 2491644 2491644 defendant Chauncys John yeoman 608963 608963 Chauncys, John, of Burley, yeoman 2
5467680 2495264 2495264 defendant Chauncys John yeoman 608963 608963 Chauncys, John, of Burley, yeoman 2
5478983 2498734 2498734 defendant Chaunces John yeoman 608963 608963 Chaunces, John, of Burley, yeoman 0
5581738 2529367 2529367 defendant Colman John yeoman 608963 608963 Colman, John, of Burley, yeoman 1

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