names

78 rows where place_id = 598146

✎ 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
3631335 1904611 1904611 defendant Mychell Henry husbandman 598146 598146 Mychell, Henry, of Ixnyng, husbandman 0
3759342 1944911 1944911 defendant Mott Robert husbandman 598146 598146 Mott, Robert, of Ixnyng, husbandman 0
3763410 1946186 1946186 defendant Mott Robert husbandman 598146 598146 Mott, Robert, of Ixnyng, husbandman 0
3777668 1950764 1950764 plaintiff Colyn Thomas yeoman 598146 598146 Colyn, Thomas, of Ixnyng, yeoman 0
3777669 1950764 1950764 plaintiff Smyth William yeoman 598146 598146 Smyth, William, of Ixnyng, yeoman 1
3777673 1950765 1950765 plaintiff Smyth William yeoman 598146 598146 Smyth, William, of Ixnyng, yeoman 1
3777678 1950766 1950766 plaintiff Smyth William yeoman 598146 598146 Smyth, William, of Ixnyng, yeoman 1
4443433 2182907 2182907 defendant Burwell John   598146 598146 Burwell, John, of Ixnyng 0
4449516 2184795 2184795 defendant Burton John   598146 598146 Burton, John, of Ixnyng 0
4519310 2206398 2206398 plaintiff Edons Thomas   598146 598146 Edons, Thomas, of Ixnyng, son of Henry 0
4519311 2206398 2206398 defendant Skyppe Thomas (legal representative) 598146 598146 Skyppe, Thomas, of Ixnyng, executrix of 0
4521853 2207171 2207171 plaintiff Gladwyne John   598146 598146 Gladwyne, John, of Ixnyng 0
4544055 2214052 2214052 defendant Bull Thomas   598146 598146 Bull, Thomas, of Ixnyng 0
4553264 2216952 2216952 defendant Dygon John   598146 598146 Dygon, John, of Ixnyng 0
4559596 2218952 2218952 defendant Burwell John   598146 598146 Burwell, John, of Ixnyng 0
4559598 2218953 2218953 defendant Chekwold John   598146 598146 Chekwold, John, of Ixnyng 0
4560832 2219345 2219345 plaintiff Odye John   598146 598146 Odye, John, of Ixnyng 0
4560884 2219357 2219357 defendant Odye John   598146 598146 Odye, John, of Ixnyng 1
4583996 2226412 2226412 defendant Chokhold John   598146 598146 Chokhold, John, of Ixnyng 0
4594500 2229538 2229538 defendant Braunford John   598146 598146 Braunford, John, of Ixnyng 8
4621321 2237660 2237660 plaintiff Lacy John   598146 598146 Lacy, John, of Ixnyng 0
4641796 2243700 2243700 plaintiff Gladewyne John   598146 598146 Gladewyne, John, of Ixnyng 0
4652780 2246803 2246803 defendant Swayn John miller 598146 598146 Swayn, John, of Ixnyng, miller 0
4652785 2246804 2246804 defendant Swayn John miller 598146 598146 Swayn, John, of Ixnyng, miller 0
4663312 2249996 2249996 plaintiff Gladewyn John   598146 598146 Gladewyn, John, of Ixnyng 0
4672415 2257026 2257026 defendant Sampson John husbandman 598146 598146 Sampson, John, of Ixnyng, husbandman 0
4679840 2259303 2259303 defendant Fyssh Hugh laborer 598146 598146 Fyssh, Hugh, of Ixnyng, laborer 0
4679841 2259303 2259303 defendant Harwode Thomas gent 598146 598146 Harwode, Thomas, of Ixnyng, gent 1
4695938 2264215 2264215 defendant George Richard husbandman 598146 598146 George, Richard, of Ixnyng, husbandman 0
4698472 2265000 2265000 defendant Beele William yeoman 598146 598146 Beele, William, of Ixnyng, yeoman 1
4704925 2266918 2266918 defendant Bele William yeoman 598146 598146 Bele, William, of Ixnyng, yeoman 1
4705526 2267092 2267092 defendant Fyssh Hugh laborer 598146 598146 Fyssh, Hugh, of Ixnyng, laborer 0
4705527 2267092 2267092 defendant Harwode Thomas gent 598146 598146 Harwode, Thomas, of Ixnyng, gent 1
4720930 2271879 2271879 defendant George Richard yeoman 598146 598146 George, Richard, of Ixnyng, yeoman 0
4725518 2273272 2273272 defendant Padlee Ralph yeoman 598146 598146 Padlee, Ralph, of Ixnyng, yeoman 3
4725520 2273272 2273272 defendant Cotton John laborer 598146 598146 together with Cotton, John, of Ixnyng, laborer 5
4742213 2278213 2278213 defendant Gecage Richard yeoman 598146 598146 Gecage, Richard, of Ixnyng, yeoman 0
4756369 2282357 2282357 defendant Fabyan John husbandman 598146 598146 Fabyan, John, of Ixnyng, husbandman 0
4756370 2282357 2282357 defendant Chokwold John laborer 598146 598146 Chokwold, John, of Ixnyng, laborer 1
4756604 2282429 2282429 defendant Broghton John yeoman 598146 598146 Broghton, John, of Ixnyng, yeoman 0
4811481 2299700 2299700 defendant Brasyer William   598146 598146 Brasyer, William, of Ixnyng, groom 2
4816584 2301278 2301278 defendant Gladwyn John husbandman 598146 598146 Gladwyn, John, of Ixnyng, husbandman 1
4839327 2308223 2308223 defendant Tredegold Henry husbandman 598146 598146 Tredegold, Henry, of Ixnyng, husbandman 1
4875140 2319179 2319179 defendant Gardener John, senior yeoman 598146 598146 Gardener, John, senior, of Ixnyng, yeoman 1
4890426 2323773 2323773 defendant Gladewyn John yeoman 598146 598146 Gladewyn, John, of Ixnyng, yeoman 0
4890427 2323773 2323773 defendant Barker Richard husbandman 598146 598146 Barker, Richard, of Ixnyng, husbandman 1
4891200 2323979 2323979 defendant Barker John husbandman 598146 598146 Barker, John, of Ixnyng, husbandman 0
4891824 2324183 2324183 defendant Gladewyn John husbandman 598146 598146 Gladewyn, John, of Ixnyng, husbandman 3
4893637 2324709 2324709 defendant Gardner John yeoman 598146 598146 Gardner, John, of Ixnyng, yeoman 0
4893685 2324721 2324721 defendant Gardener John yeoman 598146 598146 Gardener, John, of Ixnyng, yeoman 0
4899576 2326508 2326508 defendant Gladwyn John husbandman 598146 598146 Gladwyn, John, of Ixnyng, husbandman 0
4903927 2327844 2327844 defendant Tredegold Henry husbandman 598146 598146 Tredegold, Henry, of Ixnyng, husbandman 0
4942328 2339587 2339587 defendant Coterell alias Blakewell Nicholas gent 598146 598146 Coterell alias Blakewell, Nicholas, of Ixnyng, gent 0
5000700 2357080 2357080 defendant Gardener John yeoman 598146 598146 Gardener, John, of Ixnyng, yeoman 0
5001638 2357371 2357371 defendant Aylwyn John husbandman 598146 598146 Aylwyn, John, of Ixnyng, husbandman 0
5040609 2368798 2368798 defendant Tredegold Henry yeoman 598146 598146 Tredegold, Henry, of Ixnyng, yeoman 3
5111369 2389717 2389717 defendant Trede- alias Bailly John husbandman 598146 598146 Trede- alias Bailly, John, of Ixnyng, husbandman 1
5118470 2391838 2391838 defendant Tredegold alias Bayly John yeoman or bailiff 598146 598146 Tredegold alias Bayly, John, of Ixnyng, yeoman or bailiff 1
5259827 2433195 2433195 defendant Smyth Thomas carpenter 598146 598146 Smyth, Thomas, of Ixnyng, carpenter 1
5280092 2439251 2439251 defendant Chapman William husbandman 598146 598146 Chapman, William, of Ixnyng, husbandman 4
5286120 2440948 2440948 defendant Gelle Robert husbandman 598146 598146 Gelle, Robert, of Ixnyng, husbandman 0
5286121 2440948 2440948 defendant Kemvere William butcher 598146 598146 Kemvere, William, of Ixnyng, butcher 1
5299717 2444885 2444885 defendant Buklond John husbandman 598146 598146 Buklond, John, of Ixnyng, husbandman 2
5303440 2446025 2446025 defendant Bokelond John husbandman 598146 598146 Bokelond, John, of Ixnyng, husbandman 0
5317222 2450232 2450232 defendant Paxman William husbandman 598146 598146 Paxman, William, of Ixnyng, husbandman 0
5317224 2450233 2450233 defendant Paxman William husbandman 598146 598146 Paxman, William, of Ixnyng, husbandman 0
5336813 2456075 2456075 defendant Paxman William husbandman 598146 598146 Paxman, William, of Ixnyng, husbandman 1
5336817 2456076 2456076 defendant Mason John husbandman 598146 598146 Mason, John, of Ixnyng, husbandman 1
5336818 2456076 2456076 defendant Mason Henry husbandman 598146 598146 Mason, Henry, of Ixnyng, husbandman 2
5336819 2456076 2456076 defendant Mason Thomas husbandman 598146 598146 Mason, Thomas, of Ixnyng, husbandman 3
5353367 2461130 2461130 defendant Gylle Robert yeoman 598146 598146 Gylle, Robert, of Ixnyng, yeoman 2
5371856 2466782 2466782 plaintiff (not given) Richard vicar of Hyndeson 598146 598146 Hyndeson, Richard, of Ixnyng, vicar of St Martin's church, executor of 0
5430756 2484140 2484140 plaintiff Hore John   598146 598146 Hore, John, of Ixnyng 0
5430760 2484141 2484141 plaintiff Hore John   598146 598146 Hore, John, of Ixnyng 0
5528164 2513374 2513374 defendant Hunnuntis Ralph   598146 598146 Hunnuntis, Ralph, of Ixnyng, shepherd 0
5539205 2516748 2516748 defendant Hore John yeoman 598146 598146 Hore, John, of Ixnyng, yeoman 0
5620813 2550377 2550377 defendant Wolrych William   598146 598146 Wolrych, William, of Ixnyng 2
5628030 2552738 2552738 defendant Gladewyn John husbandman 598146 598146 Gladewyn, John, of Ixnyng, 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);