names

68 rows where place_id = 587134

✎ 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
3590563 1864689 1864689 defendant Fowyll John husbandman 587134 587134 Fowyll, John, of Hallyng, husbandman 0
3604923 1869205 1869205 defendant Coke Roger husbandman 587134 587134 Coke, Roger, of Hallyng, husbandman 2
3605851 1869496 1869496 defendant Symon William husbandman 587134 587134 Symon, William, of Hallyng, husbandman 2
3609044 1870485 1870485 defendant Symond William husbandman 587134 587134 Symond, William, of Hallyng, husbandman 1
3613391 1871834 1871834 defendant Lunce John laborer 587134 587134 Lunce, John, of Hallyng, laborer 0
3614229 1872118 1872118 defendant Goode William yeoman 587134 587134 Goode, William, of Hallyng, yeoman 0
3645215 1908909 1908909 defendant Tayler Henry husbandman 587134 587134 Tayler, Henry, of Hallyng, husbandman 1
3673461 1917722 1917722 defendant Wadman Thomas husbandman 587134 587134 Wadman, Thomas, of Hallyng, husbandman 0
3673463 1917723 1917723 defendant Aspelond John husbandman 587134 587134 Aspelond, John, of Hallyng, husbandman 0
3689449 1922858 1922858 defendant Wadman Thomas yeoman 587134 587134 Wadman, Thomas, of Hallyng, yeoman 0
3689662 1922925 1922925 defendant Grafton Nicholas yeoman 587134 587134 Grafton, Nicholas, of Hallyng, yeoman 0
3689663 1922925 1922925 defendant Frith John laborer 587134 587134 Frith, John, of Hallyng, laborer 1
3689668 1922927 1922927 defendant Norman William husbandman 587134 587134 Norman, William, of Hallyng, husbandman 1
3747994 1941290 1941290 defendant Evethe William husbandman 587134 587134 Evethe, William, of Hallyng, husbandman 4
3756459 1943993 1943993 defendant Hatche John husbandman 587134 587134 Hatche, John, of Hallyng, husbandman 0
3831574 1967766 1967766 defendant Fyssher Robert gent 587134 587134 Fyssher, Robert, of Hallyng, gent 1
3831575 1967766 1967766 defendant Whyte Edard gent 587134 587134 Whyte, Edard, of Hallyng, gent 2
3848728 1973188 1973188 defendant Stocke Thomas clerk 587134 587134 Stocke, Thomas, of Hallyng, clerk 0
4502382 2201333 2201333 plaintiff Michell Richard   587134 587134 Michell, Richard, of Hallyng 0
4502389 2201333 2201333 defendant Holewe John   587134 587134 Holewe, John, of Hallyng 6
4602206 2231908 2231908 defendant Somere Roger   587134 587134 Somere, Roger, of Hallyng 1
4667579 2255578 2255578 defendant Wynnegold John husbandman 587134 587134 Wynnegold, John, of Hallyng, husbandman 0
4718463 2271116 2271116 defendant Wyngold John yeoman 587134 587134 Wyngold, John, of Hallyng, yeoman 1
4726777 2273645 2273645 defendant Parker John farmer 587134 587134 Parker, John, of Hallyng, farmer 0
4742986 2278463 2278463 defendant Fyrauf John husbandman 587134 587134 Fyrauf, John, of Hallyng, husbandman 0
4747329 2279722 2279722 defendant Parker John laborer 587134 587134 Parker, John, of Hallyng, laborer 0
4871646 2318098 2318098 defendant Styklane William clerk 587134 587134 Styklane, William, of Hallyng, clerk 0
4900263 2326714 2326714 defendant Parker Thomas yeoman 587134 587134 Parker, Thomas, of Hallyng, yeoman 1
4917774 2332072 2332072 defendant Peverell Thomas gent 587134 587134 Peverell, Thomas, of Hallyng, gent 1
4923548 2333798 2333798 defendant Peverell Thomas gent 587134 587134 Peverell, Thomas, of Hallyng, gent 0
4939708 2338804 2338804 defendant Parker Thomas husbandman 587134 587134 Parker, Thomas, of Hallyng, husbandman 3
4948853 2341624 2341624 defendant Peverell Thomas gent 587134 587134 Peverell, Thomas, of Hallyng, gent 0
4991697 2354400 2354400 defendant Parker Thomas laborer 587134 587134 Parker, Thomas, of Hallyng, laborer 2
4997827 2356207 2356207 defendant Aylwyn Walter husbandman 587134 587134 Aylwyn, Walter, of Hallyng, husbandman 0
5004917 2358338 2358338 defendant Parker Thomas husbandman 587134 587134 Parker, Thomas, of Hallyng, husbandman 0
5008495 2359380 2359380 defendant Shipman Thomas mariner 587134 587134 Shipman, Thomas, of Hallyng, mariner 3
5023285 2363714 2363714 defendant Moryth John husbandman 587134 587134 Moryth, John, of Hallyng, husbandman 2
5023289 2363715 2363715 defendant Moryth John husbandman 587134 587134 Moryth, John, of Hallyng, husbandman 2
5094376 2384759 2384759 defendant Parker Thomas, junior husbandman 587134 587134 Parker, Thomas, junior, of Hallyng, husbandman 1
5094378 2384759 2384759 defendant Palmer alias Parker Thomas, senior husbandman 587134 587134 Palmer alias Parker, Thomas, senior, of Hallyng, husbandman 3
5103790 2387532 2387532 defendant Parker Thomas husbandman 587134 587134 Parker, Thomas, of Hallyng, husbandman, Slepere, William, husbandman 0
5109258 2389134 2389134 defendant Feraf William carpenter 587134 587134 Feraf, William, of Hallyng, carpenter 2
5118600 2391872 2391872 defendant Parker Thomas, junior husbandman 587134 587134 Parker, Thomas, junior, of Hallyng, husbandman 0
5121575 2392742 2392742 defendant Absolon Roger shoemaker 587134 587134 Absolon, Roger, of Hallyng, shoemaker 0
5205934 2417471 2417471 defendant Coke Thomas husbandman 587134 587134 Coke, Thomas, of Hallyng, husbandman 3
5354638 2461527 2461527 defendant Wodeman John thatcher 587134 587134 Wodeman, John, of Hallyng, thatcher 0
5389613 2472090 2472090 defendant Talbot John gent 587134 587134 Talbot, John, of Hallyng, gent 0
5415283 2479509 2479509 defendant Talbot John gent 587134 587134 Talbot, John, of Hallyng, gent 0
5417437 2480133 2480133 defendant Hyet William husbandman 587134 587134 Hyet, William, of Hallyng, husbandman 2
5482192 2499615 2499615 defendant Taillour Henry husbandman 587134 587134 Taillour, Henry, of Hallyng, husbandman 2
5495501 2503555 2503555 defendant Andrewe John yeoman 587134 587134 Andrewe, John, of Hallyng, yeoman 0
5498923 2504615 2504615 defendant Coke Thomas husbandman 587134 587134 Coke, Thomas, of Hallyng, husbandman 1
5499012 2504639 2504639 defendant Gryce William husbandman 587134 587134 Gryce, William, of Hallyng, husbandman 3
5505456 2506623 2506623 defendant Tayllour Henry husbandman 587134 587134 Tayllour, Henry, of Hallyng, husbandman 3
5521208 2511448 2511448 defendant Baker Roger tailor 587134 587134 Baker, Roger, of Hallyng, tailor 0
5525659 2512618 2512618 defendant Goode William yeoman 587134 587134 Goode, William, of Hallyng, yeoman 0
5525661 2512619 2512619 defendant Goode William yeoman 587134 587134 Goode, William, of Hallyng, yeoman 0
5529524 2513733 2513733 defendant Ussher John husbandman 587134 587134 Ussher, John, of Hallyng, husbandman 0
5544951 2518528 2518528 defendant Pylton Richard carpenter 587134 587134 Pylton, Richard, of Hallyng, carpenter 3
5551645 2520522 2520522 defendant Cotton John chaplain 587134 587134 Cotton, John, of Hallyng, chaplain 0
5551646 2520522 2520522 defendant Hubberd John yeoman 587134 587134 Hubberd, John, of Hallyng, yeoman 1
5556158 2521797 2521797 defendant Coton John clerk 587134 587134 Coton, John, of Hallyng, clerk 0
5556159 2521797 2521797 defendant Hobard John husbandman 587134 587134 Hobard, John, of Hallyng, husbandman 1
5556160 2521797 2521797 defendant Bocher Robert butcher 587134 587134 Bocher, Robert, of Hallyng, butcher 2
5556161 2521797 2521797 defendant Apselyn John   587134 587134 Apselyn, John, of Hallyng, horse collar maker 3
5562374 2523596 2523596 defendant Baker Roger   587134 587134 Baker, Roger, of Hallyng yeoman 1
5571517 2526224 2526224 defendant Barbour Thomas husbandman 587134 587134 Barbour, Thomas, of Hallyng, husbandman 1
5618377 2549571 2549571 plaintiff Michal Richard   587134 587134 Michal, Richard, of Hallyng 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);