names

70 rows where place_id = 589340

✎ 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
3597286 1866772 1866772 defendant Wyld Thomas laborer 589340 589340 Wyld, Thomas, of Est Todenham, laborer 0
3698102 1925633 1925633 plaintiff Tylney Richard   589340 589340 Tylney, Richard, of Est Todenham 0
3698105 1925633 1925633 plaintiff Crane William   589340 589340 Crane, William, of Est Todenham 3
3735309 1937276 1937276 plaintiff Neve Robert husbandman 589340 589340 Neve, Robert, of Est Todenham, husbandman 1
3738225 1938169 1938169 defendant Proo John yeoman 589340 589340 Proo, John, of Est Todenham, yeoman 0
3793521 1955838 1955838 defendant Proo John husbandman 589340 589340 Proo, John, of Est Todenham, husbandman 0
3832027 1967914 1967914 defendant Bukke John husbandman 589340 589340 Bukke, John, of Est Todenham, husbandman 2
3850802 1973845 1973845 defendant Proo Robert husbandman 589340 589340 Proo, Robert, of Est Todenham, husbandman 1
3853936 1974869 1974869 plaintiff Stork Georgem husbandman 589340 589340 Stork, Georgem, of Est Todenham, husbandman 0
3874363 1981651 1981651 defendant Proo Robert husbandman 589340 589340 Proo, Robert, of Est Todenham, husbandman 0
3961581 2011148 2011148 plaintiff Tylney Robert yeoman 589340 589340 Tylney, Robert, of Est Todenham, yeoman 0
3986578 2019938 2019938 defendant Burrowe John carpenter 589340 589340 Burrowe, John, of Est Todenham, carpenter 3
4447235 2184044 2184044 defendant Wolwyn Roger   589340 589340 Wolwyn, Roger, of East Todenham 0
4640434 2243313 2243313 defendant Davy John   589340 589340 Davy, John, of East Todenham, vicar 1
4640438 2243314 2243314 defendant Davy John   589340 589340 Davy, John, of East Todenham, vicar 1
4675472 2257938 2257938 defendant Davy William husbandman 589340 589340 Davy, William, of East Todenham, husbandman 0
4676307 2258200 2258200 defendant Broun William yeoman 589340 589340 Broun, William, of East Todenham, yeoman 1
4700375 2265532 2265532 defendant Hunte Andrew husbandman 589340 589340 Hunte, Andrew, of East Todenham, husbandman 0
4700380 2265532 2265532 defendant atte Welle John husbandman 589340 589340 atte Welle, John, of East Todenham, husbandman 5
4718005 2270972 2270972 plaintiff atte Hagh William   589340 589340 atte Hagh, William, of East Todenham 0
4808631 2298863 2298863 defendant atte Hagh William draper 589340 589340 atte Hagh, William, of East Todenham, draper 0
4808632 2298863 2298863 defendant Smyth alias atte Hill Thomas yeoman 589340 589340 Smyth alias atte Hill, Thomas, of East Todenham, yeoman 1
4827521 2304656 2304656 defendant Note Simon yeoman 589340 589340 Note, Simon, of East Todenham, yeoman 0
4878855 2320320 2320320 defendant atte Haghe William yeoman 589340 589340 atte Haghe, William, of Est Todenham, yeoman 0
4888393 2323170 2323170 defendant Aphawe Henry yeoman 589340 589340 Aphawe, Henry, of Est Todenham, yeoman 0
4911302 2330038 2330038 defendant Aphawe Henry yeoman 589340 589340 Aphawe, Henry, of East Todenham, yeoman 9
4924595 2334129 2334129 defendant Hawe William yeoman 589340 589340 Hawe, William, of East Todenham, yeoman 3
4929505 2335643 2335643 defendant Apehawe Henry yeoman 589340 589340 Apehawe, Henry, of East Todenham, yeoman 4
4930906 2336066 2336066 defendant Waleys Richard yeoman 589340 589340 Waleys, Richard, of East Todenham, yeoman 0
4930907 2336066 2336066 defendant Hawe William yeoman 589340 589340 Hawe, William, of East Todenham, yeoman 1
4930911 2336066 2336066 defendant ap Haghe Henry yeoman 589340 589340 ap Haghe, Henry, of East Todenham, yeoman 5
4930918 2336067 2336067 defendant Hawe William gent 589340 589340 Hawe, William, of East Todenham, gent 5
4934367 2337139 2337139 defendant Teny or Tevy John husbandman 589340 589340 Teny or Tevy, John, of Est Todenham, husbandman 0
4936628 2337840 2337840 defendant atte Hawe William yeoman 589340 589340 atte Hawe, William, of Est Todenham, yeoman 2
4939898 2338866 2338866 defendant Waleys Richard husbandman 589340 589340 Waleys, Richard, of Est Todenham, husbandman 1
4939899 2338866 2338866 defendant Hawe William husbandman 589340 589340 Hawe, William, of Est Todenham, husbandman 2
5003166 2357829 2357829 defendant Waleys Richard husbandman 589340 589340 Waleys, Richard, of East Todenham, husbandman 0
5016724 2361782 2361782 defendant Gogeney John husbandman 589340 589340 Gogeney, John, of Est Todenham, husbandman 0
5033754 2366752 2366752 defendant atte Haughe William gent 589340 589340 atte Haughe, William, of Est Todenham, gent 0
5043217 2369591 2369591 defendant Howet Thomas husbandman 589340 589340 Howet, Thomas, of East Todenham, husbandman 1
5043218 2369591 2369591 defendant Holdman alias Okeman John husbandman 589340 589340 Holdman alias Okeman, John, of East Todenham, husbandman 2
5095967 2385248 2385248 defendant Waleys Richard yeoman 589340 589340 Waleys, Richard, of Est Todenham, yeoman 8
5110938 2389591 2389591 defendant Waleys Richard yeoman 589340 589340 Waleys, Richard, of Est Todenham, yeoman 0
5116797 2391341 2391341 defendant Waleys Richard yeoman 589340 589340 Waleys, Richard, of Est Todenham, yeoman 2
5136862 2397304 2397304 defendant atte Hill John tailor 589340 589340 atte Hill, John, of Est Todenham, tailor 1
5136863 2397304 2397304 defendant atte Hill John smith 589340 589340 atte Hill, John, of Est Todenham, smith 2
5136864 2397304 2397304 defendant Teny or Tevy John husbandman 589340 589340 Teny or Tevy, John, of Est Todenham, husbandman 3
5141689 2398679 2398679 plaintiff Waleys Richard yeoman 589340 589340 Waleys, Richard, of East Todenham, yeoman 0
5156156 2402961 2402961 defendant Waleys Richard yeoman 589340 589340 Waleys, Richard, of East Todenham, yeoman 0
5157425 2403310 2403310 defendant atte Hill John tailor 589340 589340 atte Hill, John, of East Todenham, tailor 1
5157426 2403310 2403310 defendant atte Hill John smith 589340 589340 atte Hill, John, of East Todenham, smith 2
5162312 2404703 2404703 defendant Sterlyng Margaret widow 589340 589340 Sterlyng, Margaret, of East Todenham, widow 2
5173345 2407913 2407913 defendant atte Hill John tailor 589340 589340 atte Hill, John, of East Todenham, tailor 0
5173346 2407913 2407913 defendant atte Hill John smith 589340 589340 atte Hill, John, of East Todenham, smith 1
5173347 2407913 2407913 defendant Teny John husbandman 589340 589340 Teny, John, of East Todenham, husbandman 2
5209773 2418594 2418594 defendant Walleys Richard husbandman 589340 589340 Walleys, Richard, of East Todenham, husbandman 3
5242473 2428007 2428007 defendant Charlys Henry husbandman 589340 589340 Charlys, Henry, of Est Todenham, husbandman 0
5257927 2432601 2432601 defendant Smyth John husbandman 589340 589340 Smyth, John,of Est Todenham, husbandman 2
5262668 2434070 2434070 defendant Tenny John husbandman 589340 589340 Tenny, John, of Est Todenham, husbandman 3
5265796 2435054 2435054 defendant Hewet Henry husbandman 589340 589340 Hewet, Henry, of Est Todenham, husbandman 0
5265797 2435054 2435054 defendant Hot Thomas husbandman 589340 589340 Hot, Thomas, of Est Todenham, husbandman 1
5265798 2435054 2435054 defendant Holt John husbandman 589340 589340 Holt, John, of Est Todenham, husbandman 2
5278643 2438860 2438860 defendant Charlys Henry husbandman 589340 589340 Charlys, Henry, of Est Todenham, husbandman 24
5290974 2442361 2442361 defendant Waleys Richard (legal representative) 589340 589340 Waleys, Richard, of Est Todenham, yeoman, executors of 2
5300306 2445049 2445049 plaintiff Charles Henry husbandman 589340 589340 Charles, Henry, of East Todenham, husbandman 0
5330678 2454254 2454254 defendant atte Welle Thomas husbandman 589340 589340 atte Welle, Thomas, of Est Todenham, husbandman 1
5357603 2462448 2462448 defendant Charles Henry husbandman 589340 589340 Charles, Henry, of East Todenham, husbandman 1
5466478 2494911 2494911 plaintiff atte Welle Thomas   589340 589340 atte Welle, Thomas, of East Todenham 0
5477820 2498385 2498385 plaintiff Attewelle Thomas   589340 589340 Attewelle, Thomas, of Est Todenham 0
5552553 2520803 2520803 defendant Beyne William yeoman 589340 589340 Beyne, William, of Est Todenham, 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);