names

38 rows where place_id = 630896

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3797292 1957040 1957040 defendant Dawbery John laborer 630896 630896 Dawbery, John, of Ixnyng, Suff, laborer 0
4668816 2255953 2255953 defendant Gardener John, junior husbandman 630896 630896 Gardener, John, junior, of Ixnyng, Suff, husbandman 0
4681657 2259874 2259874 defendant Gardener Richard husbandman 630896 630896 Gardener, Richard, of Ixnyng, Suff, husbandman 1
4707475 2267712 2267712 defendant Gardener Richard yeoman 630896 630896 Gardener, Richard, of Ixnyng, Suff, yeoman 1
4715819 2270263 2270263 defendant Beel William   630896 630896 Beel, William, of Ixnyng, Suff, yeoman, formerly living in London 1
4716113 2270345 2270345 defendant Gladewyn John yeoman 630896 630896 Gladewyn, John, of Ixnyng, Suff, yeoman 4
4725924 2273395 2273395 defendant Barker Richard tanner 630896 630896 Barker, Richard, of Ixnyng, Suff, tanner 0
4727706 2273908 2273908 defendant Barker Richard tanner 630896 630896 Barker, Richard, of Ixnyng, Suff, tanner 0
4732988 2275496 2275496 defendant Gardener John, sen yeoman 630896 630896 Gardener, John, sen, of Ixnyng, Suff, yeoman 0
4744315 2278858 2278858 defendant Mewer John husbandman 630896 630896 Mewer, John, of Ixnyng, Suff, husbandman 5
4749845 2280429 2280429 defendant Broughton John husbandman 630896 630896 Broughton, John, of Ixnyng, Suff, husbandman 0
4750899 2280745 2280745 defendant Gardener John, senior farmer 630896 630896 Gardener, John, senior, of Ixnyng, Suff, farmer 0
4752388 2281156 2281156 defendant Broughton John husbandman 630896 630896 Broughton, John, of Ixnyng, Suff, husbandman 0
4794462 2294404 2294404 defendant Gydney William yeoman 630896 630896 Gydney, William, of Ixnyng, Suff, yeoman 4
4811480 2299700 2299700 defendant Worlyche Richard, junior   630896 630896 Worlyche, Richard, junior, of Ixnyng, Suff, shepherd 1
4816578 2301276 2301276 defendant Tredegold Henry husbandman 630896 630896 Tredegold, Henry, of Ixnyng, Suff, husbandman 0
4816579 2301276 2301276 defendant Gladekyn John husbandman 630896 630896 Gladekyn, John, of Ixnyng, Suff, husbandman 1
4816583 2301278 2301278 defendant Tredegold Henry husbandman 630896 630896 Tredegold, Henry, of Ixnyng, Suff, husbandman 0
4818661 2301920 2301920 defendant Bickton John husbandman 630896 630896 Bickton, John, of Ixnyng, Suff, husbandman 1
4839326 2308223 2308223 defendant Gladewyn John husbandman 630896 630896 Gladewyn, John, of Ixnyng, Suff, husbandman 0
4868780 2317207 2317207 defendant Tredegold Henry yeoman 630896 630896 Tredegold, Henry, of Ixnyng, Suff, yeoman 0
4914547 2331071 2331071 defendant Aillewyn John husbandman 630896 630896 Aillewyn, John, of Ixnyng, Suff, husbandman 1
4919279 2332539 2332539 defendant Wyot Robert yeoman 630896 630896 Wyot, Robert, of Ixnyng, Suff, yeoman 3
4946728 2340978 2340978 defendant Tredegold alias Bayly Henry yeoman 630896 630896 Tredegold alias Bayly, Henry, of Ixnyng, Suff, yeoman 1
4965249 2346529 2346529 defendant Lete Robert miller 630896 630896 Lete, Robert, of Ixnyng, Suff, miller 0
4976654 2349975 2349975 defendant Cottrell Nicholas yeoman 630896 630896 Cottrell, Nicholas, of Ixnyng, Suff, yeoman 3
4985626 2352616 2352616 defendant Coterell Nicholas husbandman 630896 630896 Coterell, Nicholas, of Ixnyng, Suff, husbandman 2
4985772 2352660 2352660 defendant Coterell Nicholas husbandman 630896 630896 Coterell, Nicholas, of Ixnyng, Suff, husbandman 2
4999022 2356588 2356588 defendant Tredegold John yeoman 630896 630896 Tredegold, John, of Ixnyng, Suff, yeoman 5
5059039 2374268 2374268 defendant Cote Henry cordwainer 630896 630896 Cote, Henry, of Ixnyng, Suff, cordwainer 0
5116938 2391378 2391378 defendant Coterell Nicholas yeoman 630896 630896 Coterell, Nicholas, of Ixnyng, Suff, yeoman 4
5133289 2396223 2396223 defendant Grene Thomas miller 630896 630896 Grene, Thomas, of Ixnyng, Suff, miller 3
5159203 2403807 2403807 defendant Tredgold John   630896 630896 Tredgold, John, of Ixnyng, Suff, bailiff 3
5193516 2413827 2413827 defendant Cottrell Nicholas yeoman 630896 630896 Cottrell, Nicholas, of Ixnyng, Suff, yeoman 3
5250033 2430120 2430120 defendant Kember William butcher 630896 630896 Kember, William, of Ixnyng, Suff, butcher 0
5259826 2433195 2433195 defendant Kymber William butcher 630896 630896 Kymber, William, of Ixnyng, Suff, butcher 0
5301352 2445358 2445358 defendant Whitemouth Thomas yeoman 630896 630896 Whitemouth, Thomas, of Ixnyng, Suff, yeoman 0
5353365 2461130 2461130 defendant Kember William yeoman 630896 630896 Kember, William, of Ixnyng, Suff, yeoman 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);