names

59 rows where place_id = 596436

✎ 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
3624756 1875279 1875279 defendant Halle Thomas yeoman 596436 596436 Halle, Thomas, of Swyneshede, yeoman 0
3685694 1921683 1921683 defendant Polle Thomas husbandman 596436 596436 Polle, Thomas, of Swyneshede, husbandman 1
3919937 1997004 1997004 defendant Browne William mercer 596436 596436 Browne, William, of Swyneshede, mercer 0
4036398 2037701 2037701 defendant Hartley John husbandman 596436 596436 Hartley, John, of Swyneshede, husbandman 0
4507209 2202720 2202720 defendant Strakur Robert   596436 596436 Strakur, Robert, of Swyneshede 2
4563888 2220276 2220276 plaintiff Rousyng Robert   596436 596436 Rousyng, Robert, of Swyneshede 0
4563889 2220276 2220276 defendant Typler John   596436 596436 Typler, John, of Swyneshede 0
4654098 2247163 2247163 defendant Adildewe John salter 596436 596436 Adildewe, John, of Swyneshede, salter 0
4664931 2250512 2250512 defendant Helwys William (legal representative) 596436 596436 Helwys, William, of Swyneshede, executors of 0
4664932 2250512 2250512 defendant Terry Richard draper 596436 596436 (Terry, Richard, of Swyneshede, draper 1
4665510 2250685 2250685 defendant Lenten Alan miller 596436 596436 Lenten, Alan, of Swyneshede, miller 0
4675798 2258039 2258039 defendant Dene Thomas husbandman 596436 596436 Dene, Thomas, of Swyneshede, husbandman 0
4675799 2258039 2258039 defendant Terry John husbandman 596436 596436 Terry, John, of Swyneshede, husbandman 1
4675801 2258039 2258039 defendant Lyndesay Thomas husbandman 596436 596436 Lyndesay, Thomas, of Swyneshede, husbandman 3
4764382 2284852 2284852 defendant Mayse William husbandman 596436 596436 Mayse, William, of Swyneshede, husbandman 0
4764383 2284852 2284852 defendant Garner Robert husbandman 596436 596436 Garner, Robert, of Swyneshede, husbandman 1
4764384 2284852 2284852 defendant Garner William husbandman 596436 596436 Garner, William, of Swyneshede, husbandman 2
4774101 2287885 2287885 defendant Knyght John, sen husbandman 596436 596436 Knyght, John, sen, of Swyneshede, husbandman 0
4848066 2310862 2310862 defendant Molle Thomas husbandman 596436 596436 Molle, Thomas, of Swyneshede, husbandman 0
4862784 2315343 2315343 defendant Bolle John, junior gent 596436 596436 Bolle, John, junior, of Swyneshede, gent 0
4927178 2334935 2334935 defendant Broune Thomas husbandman 596436 596436 Broune, Thomas, of Swyneshede, husbandman 1
4927185 2334936 2334936 defendant Bukke Richard husbandman 596436 596436 Bukke, Richard, of Swyneshede, husbandman 0
4927186 2334936 2334936 defendant Maye Roger husbandman 596436 596436 Maye, Roger, of Swyneshede, husbandman 1
4927187 2334936 2334936 defendant Bereney Thomas husbandman 596436 596436 Bereney, Thomas, of Swyneshede, husbandman 2
4956359 2343865 2343865 defendant Bardeney Thomas husbandman 596436 596436 Bardeney, Thomas, of Swyneshede, husbandman 0
4965641 2346645 2346645 defendant Smyth William husbandman 596436 596436 Smyth, William, of Swyneshede, husbandman 0
4993442 2354907 2354907 plaintiff Hoton Robert   596436 596436 Hoton, Robert, of Swyneshede 2
5035225 2367165 2367165 defendant Proktour Thomas yeoman 596436 596436 Proktour, Thomas, of Swyneshede, yeoman 0
5076910 2379589 2379589 defendant Smyth John husbandman 596436 596436 Smyth, John, of Swyneshede, son of Smyth, John, of Swyneshede, husbandman 0
5133626 2396328 2396328 defendant Carter John, senior milner 596436 596436 Carter, John, senior, of Swyneshede, milner 0
5153439 2402160 2402160 defendant Carter John, sen miller 596436 596436 Carter, John, sen, of Swyneshede, miller 0
5162532 2404769 2404769 defendant Wynder Robert yeoman 596436 596436 Wynder, Robert, of Swyneshede, yeoman 0
5164311 2405299 2405299 defendant Frythe Thomas gent 596436 596436 Frythe, Thomas, of Swyneshede, gent 0
5170851 2407200 2407200 defendant Carter John, sen miller 596436 596436 Carter, John, sen, of Swyneshede, miller 0
5188886 2412485 2412485 defendant Carter John miller 596436 596436 Carter, John, of Swyneshede, miller 0
5192351 2413499 2413499 defendant Lofte William clerk 596436 596436 (Lofte, William, of Swyneshede, clerk 1
5207714 2417995 2417995 defendant Loste William clerk 596436 596436 (Loste, William, of Swyneshede, clerk 1
5207724 2417997 2417997 defendant Lofte William clerk 596436 596436 (Lofte, William, of Swyneshede, clerk 1
5215724 2420324 2420324 defendant Bray John tailor 596436 596436 Bray, John, of Swyneshede, tailor 1
5216703 2420620 2420620 defendant Jaye John   596436 596436 Jaye, John, of Swyneshede, laborer, son of Jaye, Paul 1
5216704 2420620 2420620 defendant Odene John laborer 596436 596436 Odene, John, of Swyneshede, laborer 2
5216705 2420620 2420620 defendant Straker William husbandman 596436 596436 Straker, William, of Swyneshede, husbandman 3
5216706 2420620 2420620 defendant Mille Nicholas   596436 596436 Mille, Nicholas, of Swyneshede, fen man 4
5264784 2434745 2434745 defendant Strakar William husbandman 596436 596436 Strakar, William, of Swyneshede, husbandman 0
5345846 2458836 2458836 defendant Kerchener Lambert husbandman 596436 596436 Kerchener, Lambert, of Swyneshede, husbandman 2
5345847 2458836 2458836 defendant Shypwryght Thomas husbandman 596436 596436 Shypwryght, Thomas, of Swyneshede, husbandman 3
5388137 2471662 2471662 defendant Drury Andrew laborer 596436 596436 Drury, Andrew, of Swyneshede, laborer 16
5388138 2471662 2471662 defendant Fyssher John laborer 596436 596436 Fyssher, John, of Swyneshede, laborer 17
5388149 2471663 2471663 defendant Drowry Andrew laborer 596436 596436 Drowry, Andrew, of Swyneshede, laborer 0
5400743 2475276 2475276 defendant Drowry Andrew laborer 596436 596436 Drowry, Andrew, of Swyneshede, laborer 0
5400744 2475276 2475276 defendant Fyssher John   596436 596436 Fyssher, John, of Swyneshede, turf man 1
5413751 2479040 2479040 defendant Drowry Andrew laborer 596436 596436 Drowry, Andrew, of Swyneshede, laborer 0
5413752 2479040 2479040 defendant Fyssher John   596436 596436 Fyssher, John, of Swyneshede, turf man 1
5429112 2483631 2483631 defendant Fissher John laborer 596436 596436 Fissher, John, of Swyneshede, laborer 6
5510912 2508253 2508253 defendant Lomson Richard husbandman 596436 596436 Lomson, Richard, of Swyneshede, husbandman 0
5510918 2508254 2508254 defendant Lomson Richard skinner 596436 596436 Lomson, Richard, of Swyneshede, skinner 0
5510921 2508255 2508255 defendant Hardpeny John laborer 596436 596436 Hardpeny, John, of Swyneshede, laborer 1
5625847 2552031 2552031 defendant Terry John, junior husbandman 596436 596436 Terry, John, junior, of Swyneshede, husbandman 0
5635405 2555037 2555037 defendant Peryn Robert husbandman 596436 596436 Peryn, Robert, of Swyneshede, 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);