names

104 rows where place_id = 592626

✎ 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
3608284 1870248 1870248 defendant Batayll Richard gent 592626 592626 Batayll, Richard, of Stratford Langthorn, gent 0
3623691 1874941 1874941 defendant Clerke John brewer 592626 592626 Clerke, John, of Stratford Langthorn, brewer 0
3626460 1903131 1903131 defendant Stodard John glover 592626 592626 Stodard, John, of Stratford Langthorn, glover 2
3626788 1903225 1903225 defendant Danyell William husbandman 592626 592626 Danyell, William, of Stratford Langthorn, husbandman 1
3636735 1906283 1906283 defendant Brigges John cooper 592626 592626 Brigges, John, of Stratford Langthorn, cooper, son of Brigges, Francis, of Stratford Langthorn, cooper 0
3666354 1915426 1915426 defendant Osburne John hsubandman 592626 592626 Osburne, John, of Stratford Langthorn, hsubandman 0
3679494 1919655 1919655 defendant Brewster Francis cooper 592626 592626 Brewster, Francis, of Stratford Langthorn, cooper 0
3751879 1942504 1942504 defendant Banys Thomas yeoman 592626 592626 Banys, Thomas, of Stratford Langthorn, yeoman 0
3751885 1942505 1942505 defendant Banys Thomas yeoman 592626 592626 Banys, Thomas, of Stratford Langthorn, yeoman 0
3781204 1951862 1951862 defendant Eskewell Francis gent 592626 592626 Eskewell, Francis, of Stratford Langthorn, gent 0
3781206 1951863 1951863 defendant Eskewell Francis gent 592626 592626 Eskewell, Francis, of Stratford Langthorn, gent 0
3781323 1951901 1951901 defendant Lane John brewer 592626 592626 Lane, John, of Stratford Langthorn, brewer 0
3786713 1953642 1953642 defendant Chalenger John baker 592626 592626 Chalenger, John, of Stratford Langthorn, baker 0
3826545 1966149 1966149 defendant Fisher Edward husbandman 592626 592626 Fisher, Edward, of Stratford Langthorn, husbandman 3
4583235 2226181 2226181 defendant Sagor John   592626 592626 Sagor, John, of Stratford langthorn 0
4666215 2250904 2250904 defendant Toleys John fisher 592626 592626 Toleys, John, of Stratford Langthorn, fisher 2
4680824 2259623 2259623 defendant Webbe John husbandman 592626 592626 Webbe, John, of Stratford Langthorn, husbandman 0
4680826 2259624 2259624 defendant Webbe John husbandman 592626 592626 Webbe, John, of Stratford Langthorn, husbandman 0
4755814 2282202 2282202 defendant Whitby William laborer 592626 592626 Whitby, William, of Stratford Langthorn, laborer 0
4755815 2282202 2282202 defendant Barbour John   592626 592626 Barbour, John, of Stratford Langthorn, rope maker 1
4760199 2283540 2283540 defendant Waryn William butcher 592626 592626 Waryn, William, of Stratford Langthorn, butcher 0
4771673 2287115 2287115 defendant Sagore William smith 592626 592626 Sagore, William, of Stratford Langthorn, smith 0
4782569 2290560 2290560 defendant Norys Richard husbandman 592626 592626 Norys, Richard, of Stratford Langthorn, husbandman 1
4794816 2294523 2294523 defendant de Berkyng John butcher 592626 592626 de Berkyng, John, of Stratford Langthorn, butcher 0
4856498 2313412 2313412 defendant Stevenes Thomas tanner 592626 592626 Stevenes, Thomas, of Stratford Langthorn, tanner 0
4857772 2313807 2313807 plaintiff Boton Robert   592626 592626 Boton, Robert, of Stratford Langthorn 0
4990044 2353932 2353932 defendant Edward Roger husbandman 592626 592626 (Edward, Roger, of Stratford Langthorn, husbandman 3
4994300 2355168 2355168 defendant Bocher Thomas butcher 592626 592626 Bocher, Thomas, of Stratford Langthorn, butcher 0
4994303 2355169 2355169 defendant Bocher Thomas butcher 592626 592626 Bocher, Thomas, of Stratford Langthorn, butcher 0
4996440 2355791 2355791 defendant Wymbyll William   592626 592626 Wymbyll, William, of Stratford Langthorn, abbot of the house & church of the BM 0
5023755 2363853 2363853 defendant Norys John smith 592626 592626 Norys, John, of Stratford Langthorn, smith 0
5023756 2363853 2363853 defendant Edward Roger husbandman 592626 592626 Edward, Roger, of Stratford Langthorn, husbandman 1
5037696 2367897 2367897 defendant Benet John carpenter 592626 592626 Benet, John, of Stratford Langthorn, carpenter 0
5051783 2372145 2372145 defendant Havelok William   592626 592626 Havelok, William, of Stratford Langthorn 0
5051785 2372146 2372146 defendant Havelok William   592626 592626 Havelok, William, of Stratford Langthorn 0
5051786 2372146 2372146 defendant Harleston Margaret   592626 592626 Harleston, Margaret, of Stratford Langthorn 1
5070397 2377639 2377639 defendant Havelok William brewer or smith 592626 592626 Havelok, William, of Stratford Langthorn, brewer or smith 1
5081620 2381010 2381010 plaintiff Dale John   592626 592626 Dale, John, of Stratford Langthorn 0
5093799 2384586 2384586 defendant Wynterborn John   592626 592626 Wynterborn, John, of Stratford Langthorn, servant 0
5101652 2386907 2386907 defendant Glovyer Robert laborer 592626 592626 Glovyer, Robert, of Stratford Langthorn, laborer 0
5106222 2388258 2388258 defendant Edward Roger husbandman 592626 592626 Edward, Roger, of Stratford Langthorn, husbandman 2
5106227 2388259 2388259 defendant Edward Roger husbandman 592626 592626 Edward, Roger, of Stratford Langthorn, husbandman 2
5123384 2393282 2393282 defendant Smalwode William brewer 592626 592626 Smalwode, William, of Stratford Langthorn, brewer 0
5140296 2398265 2398265 defendant Havelok William brewer 592626 592626 Havelok, William, of Stratford Langthorn, brewer 2
5159442 2403879 2403879 defendant Clerke John laborer 592626 592626 Clerke, John, of Stratford Langthorn, laborer 0
5159443 2403879 2403879 defendant Harre William   592626 592626 Harre, William, of Stratford Langthorn, wheel wright 1
5168930 2406643 2406643 defendant Clerk John tailor 592626 592626 Clerk, John, of Stratford Langthorn, tailor 1
5172615 2407717 2407717 defendant Reyfeld John   592626 592626 Reyfeld, John, of Stratford Langthorn, abbot of the monastery of the BM 0
5184402 2411177 2411177 defendant Benet John carpenter 592626 592626 Benet, John, of Stratford Langthorn, carpenter 2
5184418 2411180 2411180 defendant Benet John carpenter 592626 592626 Benet, John, of Stratford Langthorn, carpenter 2
5192214 2413456 2413456 defendant Rayfeld John   592626 592626 Rayfeld, John, of Stratford Langthorn, abbot of the monastery of the BM 0
5192216 2413457 2413457 defendant Ryfeld John   592626 592626 Ryfeld, John, of Stratford Langthorn, abbot 0
5192218 2413458 2413458 defendant Reyfeld John   592626 592626 Reyfeld, John, of Stratford Langthorn, abbot of the monastery of the BM 0
5192220 2413459 2413459 defendant Reyfeld John   592626 592626 Reyfeld, John, of Stratford Langthorn, abbot of the monastery of the BM 0
5195322 2414381 2414381 defendant Clerk John laborer 592626 592626 Clerk, John, of Stratford Langthorn, laborer 0
5195323 2414381 2414381 defendant Harre William   592626 592626 Harre, William, of Stratford Langthorn, wheel wright 1
5195733 2414495 2414495 defendant Havelok William brewer 592626 592626 Havelok, William, of Stratford Langthorn, brewer 1
5204311 2417014 2417014 defendant Benet John carpenter 592626 592626 Benet, John, of Stratford Langthorn, carpenter 2
5207676 2417984 2417984 defendant Rayfeld John   592626 592626 Rayfeld, John, of Stratford Langthorn, abbot of the monastery of the BM 0
5207678 2417985 2417985 defendant Rayfeld John   592626 592626 Rayfeld, John, of Stratford Langthorn, abbot of the monastery of the BM 0
5244946 2428695 2428695 defendant Payn John brewer 592626 592626 Payn, John, of Stratford Langthorn, brewer 2
5275738 2437967 2437967 defendant Fote John cordwainer 592626 592626 Fote, John, of Stratford Langthorn, cordwainer 0
5276429 2438176 2438176 plaintiff Watford Hugh   592626 592626 Watford, Hugh, of Stratford Langthorn, abbot 0
5276431 2438177 2438177 plaintiff Watford Hugh   592626 592626 Watford, Hugh, of Stratford Langthorn, abbot 0
5276433 2438178 2438178 plaintiff Watford Hugh   592626 592626 Watford, Hugh, of Stratford Langthorn, abbot of the Monastery of the BM 0
5316915 2450137 2450137 defendant Hardwyn William smith 592626 592626 Hardwyn, William, of Stratford Langthorn, smith 5
5328443 2453582 2453582 defendant Saunderson Henry baker 592626 592626 Saunderson, Henry, of Stratford Langthorn, baker 2
5356799 2462193 2462193 defendant Todymer John yeoman 592626 592626 Todymer, John, of Stratford Langthorn, yeoman 0
5356803 2462194 2462194 defendant Todymer John yeoman 592626 592626 together with Todymer, John, of Stratford Langthorn, yeoman 1
5356892 2462217 2462217 defendant Todymer John yeoman 592626 592626 Todymer, John, of Stratford Langthorn, yeoman 1
5359207 2462918 2462918 defendant Lee Hugh brewer 592626 592626 Lee, Hugh, of Stratford Langthorn, brewer 0
5363142 2464126 2464126 defendant Brewester Thomas tanner 592626 592626 Brewester, Thomas, of Stratford Langthorn, tanner 0
5389914 2472179 2472179 defendant Hoke John butcher 592626 592626 Hoke, John, of Stratford Langthorn, butcher 1
5432058 2484556 2484556 defendant Hoke John butcher 592626 592626 Hoke, John, of Stratford Langthorn, butcher 1
5432064 2484557 2484557 defendant Hoke John butcher 592626 592626 Hoke, John, of Stratford Langthorn, butcher 1
5437108 2486035 2486035 defendant Wryght Richard butcher 592626 592626 Wryght, Richard, of Stratford Langthorn, butcher 4
5447293 2489078 2489078 defendant Wryght Richard butcher 592626 592626 Wryght, Richard, of Stratford Langthorn, butcher 0
5453639 2490981 2490981 defendant Root John brewer 592626 592626 Root, John, of Stratford Langthorn, brewer 0
5475869 2497786 2497786 defendant Wryght Bartholomew yeoman 592626 592626 Wryght, Bartholomew, of Stratford Langthorn, yeoman 1
5483615 2500050 2500050 defendant Hoke John butcher 592626 592626 Hoke, John, of Stratford Langthorn, butcher 0
5515550 2509706 2509706 defendant Topyas Luke miller 592626 592626 Topyas, Luke, of Stratford Langthorn, miller 4
5520193 2511137 2511137 defendant Strangham William barker 592626 592626 Strangham, William, of Stratford Langthorn, barker 0
5520194 2511137 2511137 defendant Smyth Robert husbandman 592626 592626 Smyth, Robert, of Stratford Langthorn, husbandman 1
5520196 2511138 2511138 defendant Strangham William barker 592626 592626 Strangham, William, of Stratford Langthorn, barker 0
5520197 2511138 2511138 defendant Smyth Robert husbandman 592626 592626 Smyth, Robert, of Stratford Langthorn, husbandman 1
5520199 2511139 2511139 defendant Strangham William barker 592626 592626 Strangham, William, of Stratford Langthorn, barker 0
5520200 2511139 2511139 defendant Smyth Robert husbandman 592626 592626 Smyth, Robert, of Stratford Langthorn, husbandman 1
5521175 2511439 2511439 defendant Barker alias Bocher John butcher 592626 592626 Barker alias Bocher, John, of Stratford Langthorn, butcher 0
5523036 2512031 2512031 defendant Barker John butcher 592626 592626 Barker, John, of Stratford Langthorn, butcher 1
5526173 2512759 2512759 defendant Tanner alias Bocher John butcher 592626 592626 Tanner alias Bocher, John, of Stratford Langthorn, butcher 0
5553604 2521089 2521089 defendant Rote John yeoman 592626 592626 (Rote, John, of Stratford Langthorn, yeoman 1
5555099 2521498 2521498 defendant Clay William laborer 592626 592626 Clay, William, of Stratford Langthorn, laborer 2
5570620 2525972 2525972 defendant Broke Robert cordwainer 592626 592626 Broke, Robert, of Stratford Langthorn, cordwainer 0
5570622 2525972 2525972 defendant Rooye Thomas brewer 592626 592626 Rooye, Thomas, of Stratford Langthorn, brewer 2
5570623 2525972 2525972 defendant Monden Thomas laborer 592626 592626 Monden, Thomas, of Stratford Langthorn, laborer 3
5570625 2525972 2525972 defendant Prate Thomas husbandman 592626 592626 Prate, Thomas, of Stratford Langthorn, husbandman 5
5570627 2525972 2525972 defendant Byer or Dyer Thomas tailor 592626 592626 Byer or Dyer, Thomas, of Stratford Langthorn, tailor 7
5576573 2527722 2527722 defendant Blount John husbandman 592626 592626 Blount, John, of Stratford Langthorn, husbandman 2
5584302 2530158 2530158 defendant Beveregge William tanner 592626 592626 Beveregge, William, of Stratford Langthorn, tanner 0
5602371 2535639 2535639 defendant Bensted John baker 592626 592626 Bensted, John, of Stratford Langthorn, baker 0

Next page

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);