names

91 rows where place_id = 587945

✎ 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
3592902 1865398 1865398 defendant Plome William husbandman 587945 587945 Plome, William, of Dagenham, husbandman 1
3615436 1872469 1872469 defendant Clerk Thomas laborer 587945 587945 Clerk, Thomas, of Dagenham, laborer 0
3626458 1903131 1903131 defendant Upney Walter husbandman 587945 587945 Upney, Walter, of Dagenham, husbandman 0
3631553 1904684 1904684 defendant Sparowe John husbandman 587945 587945 Sparowe, John, of Dagenham, husbandman 2
3667786 1915866 1915866 defendant Kyng William weaver 587945 587945 Kyng, William, of Dagenham, weaver 1
3667787 1915866 1915866 defendant Sparowe John husbandman 587945 587945 Sparowe, John, of Dagenham, husbandman 2
3719955 1932509 1932509 defendant Stephyn Richard yeoman 587945 587945 Stephyn, Richard, of Dagenham, yeoman 3
3724781 1934035 1934035 defendant Clerk William husbandman 587945 587945 Clerk, William, of Dagenham, husbandman 0
3724783 1934036 1934036 defendant Clerk William husbandman 587945 587945 Clerk, William, of Dagenham, husbandman 0
3727251 1934797 1934797 defendant Ferr John husbandman 587945 587945 Ferr, John, of Dagenham, husbandman 0
3728710 1935221 1935221 defendant Webster William tailor 587945 587945 Webster, William, of Dagenham, tailor 0
3733638 1936762 1936762 defendant Noller Henry laborer 587945 587945 Noller, Henry, of Dagenham, laborer 0
3768967 1947946 1947946 defendant Stokley John laborer 587945 587945 Stokley, John, of Dagenham, laborer 2
3786313 1953510 1953510 defendant Huntyng Thomas   587945 587945 Huntyng, Thomas, of Dagenham, wheelwright 1
3786314 1953510 1953510 defendant Shirwode John husbandman 587945 587945 Shirwode, John, of Dagenham, husbandman 2
3790177 1954747 1954747 defendant Balden William laborer 587945 587945 Balden, William, of Dagenham, laborer 0
3790178 1954747 1954747 defendant Woodland Peter laborer 587945 587945 Woodland, Peter, of Dagenham, laborer 1
3854032 1974896 1974896 defendant Clerke William waterman 587945 587945 Clerke, William, of Dagenham, waterman 0
3890501 1987082 1987082 plaintiff Horne Richard, senior husbandman 587945 587945 Horne, Richard, senior, of Dagenham, husbandman 0
3914838 1995309 1995309 plaintiff Clerke Henry, senior   587945 587945 Clerke, Henry, senior, of Dagenham 0
3977845 2016823 2016823 plaintiff Lytle John (legal representative) 587945 587945 Lytle, John, of Dagenham, yeoman, executors of 0
4275579 2121401 2121401 defendant Browne Richard yeoman 587945 587945 Browne, Richard, of Dagenham, yeoman 0
4281444 2123415 2123415 defendant Grene William weaver 587945 587945 Grene, William, of Dagenham, weaver 0
4281445 2123415 2123415 defendant Browne Richard yeoman 587945 587945 Browne, Richard, of Dagenham, yeoman 1
4290879 2126796 2126796 defendant Browne Richard yeoman 587945 587945 Browne, Richard, of Dagenham, yeoman 0
4290881 2126797 2126797 defendant Greene William yeoman 587945 587945 Greene, William, of Dagenham, yeoman 0
4710104 2268515 2268515 defendant Noloth Richard husbandman 587945 587945 Noloth, Richard, of Dagenham, husbandman 0
4710105 2268515 2268515 defendant Wryght Thomas tanner 587945 587945 Wryght, Thomas, of Dagenham, tanner 1
4741571 2278031 2278031 defendant Haynton Robert clerk 587945 587945 Haynton, Robert, of Dagenham, clerk 0
4755313 2282049 2282049 defendant Langle Richard tailor 587945 587945 Langle, Richard, of Dagenham, tailor 1
4755857 2282213 2282213 defendant Haynton Robert   587945 587945 Haynton, Robert, of Dagenham, vicar & clerk 0
4788794 2292551 2292551 defendant Loster William laborer 587945 587945 Loster, William, of Dagenham, laborer 1
4789286 2292711 2292711 defendant Romayn Ralph husbandman 587945 587945 Romayn, Ralph, of Dagenham, husbandman 0
4791626 2293477 2293477 defendant Romayn Ralph husbandman 587945 587945 Romayn, Ralph, of Dagenham, husbandman 0
4828917 2305085 2305085 defendant Spragill Thomas husbandman 587945 587945 Spragill, Thomas, of Dagenham, husbandman 0
5078294 2379996 2379996 defendant Calcote Richard chapman 587945 587945 Calcote, Richard, of Dagenham, chapman 3
5079994 2380496 2380496 defendant Cappys John collier 587945 587945 Cappys, John, of Dagenham, collier 2
5081992 2381109 2381109 defendant Estbroke Thomas husbandman 587945 587945 Estbroke, Thomas, of Dagenham, husbandman 1
5081993 2381109 2381109 defendant Clerk John, junior husbandman 587945 587945 Clerk, John, junior, of Dagenham, husbandman 2
5106950 2388463 2388463 defendant Estbrooke Thomas, senior husbandman 587945 587945 Estbrooke, Thomas, senior, of Dagenham, husbandman 0
5106952 2388464 2388464 defendant Estbrooke Thomas, senior husbandman 587945 587945 Estbrooke, Thomas, senior, of Dagenham, husbandman 0
5115462 2390947 2390947 defendant Sparowe William husbandman 587945 587945 Sparowe, William, of Dagenham, husbandman 1
5119847 2392239 2392239 defendant Serle Nicholas husbandman 587945 587945 Serle, Nicholas, of Dagenham, husbandman 2
5131918 2395818 2395818 defendant Wodelond Geoffrey husbandman 587945 587945 Wodelond, Geoffrey, of Dagenham, husbandman 0
5136003 2397041 2397041 defendant Hathon (illegible) husbandman 587945 587945 Hathon, ----, of Dagenham, husbandman 1
5156187 2402971 2402971 defendant Pete John husbandman 587945 587945 Pete, John, of Dagenham, husbandman 0
5156188 2402971 2402971 defendant Hatthorn Thomas husbandman 587945 587945 Hatthorn, Thomas, of Dagenham, husbandman 1
5226760 2423493 2423493 defendant Pragill John husbandman 587945 587945 Pragill, John, of Dagenham, husbandman 0
5233404 2425360 2425360 defendant Peryman John husbandman 587945 587945 Peryman, John, of Dagenham, husbandman 0
5233405 2425360 2425360 defendant Pacche John laborer 587945 587945 Pacche, John, of Dagenham, laborer 1
5241030 2427577 2427577 defendant Champeneys John husbandman 587945 587945 Champeneys, John, of Dagenham, husbandman 0
5241031 2427577 2427577 defendant Longe Thomas husbandman 587945 587945 Longe, Thomas, of Dagenham, husbandman 1
5241034 2427578 2427578 defendant Champeneys John husbandman 587945 587945 Champeneys, John, of Dagenham, husbandman 0
5241035 2427578 2427578 defendant Longe Thomas husbandman 587945 587945 Longe, Thomas, of Dagenham, husbandman 1
5267376 2435563 2435563 defendant Pacche John husbandman 587945 587945 Pacche, John, of Dagenham, husbandman 2
5267378 2435563 2435563 defendant Elston Richard butcher 587945 587945 Elston, Richard, of Dagenham, butcher 4
5280893 2439484 2439484 defendant Horell John husbandman 587945 587945 Horell, John, of Dagenham, husbandman 1
5328519 2453605 2453605 defendant Elston Richard bucher 587945 587945 Elston, Richard, of Dagenham, bucher 4
5344981 2458592 2458592 defendant Danyell John barber 587945 587945 Danyell, John, of Dagenham, barber 0
5352422 2460858 2460858 defendant Pecok John laborer 587945 587945 Pecok, John, of Dagenham, laborer 4
5386536 2471216 2471216 defendant Palmer John   587945 587945 (Palmer, John, of Dagenham 1
5415447 2479557 2479557 defendant Hoke Thomas husbandman 587945 587945 Hoke, Thomas, of Dagenham, husbandman 0
5415448 2479557 2479557 defendant Hoke William husbandman 587945 587945 Hoke, William, of Dagenham, husbandman 1
5417997 2480309 2480309 defendant Bruer Thomas husbandman 587945 587945 Bruer, Thomas, of Dagenham, husbandman 0
5418136 2480348 2480348 defendant Lincoln John shoemaker 587945 587945 Lincoln, John, of Dagenham, shoemaker 3
5424503 2482300 2482300 defendant Egham John husbandman 587945 587945 Egham, John, of Dagenham, husbandman 1
5426462 2482857 2482857 defendant Palmer John gent 587945 587945 (Palmer, John, of Dagenham, gent 1
5435721 2485622 2485622 defendant Brewer Thomas husbandman 587945 587945 Brewer, Thomas, of Dagenham, husbandman 0
5435879 2485675 2485675 defendant Lincolne John shoemaker 587945 587945 Lincolne, John, of Dagenham, shoemaker 3
5436090 2485733 2485733 defendant Pragill John husbandman 587945 587945 Pragill, John, of Dagenham, husbandman 3
5437686 2486207 2486207 defendant Palmer John gent 587945 587945 Palmer, John, of Dagenham, gent 0
5443271 2487904 2487904 defendant Egham (illegible) husbandman 587945 587945 Egham, _, of Dagenham, husbandman 1
5450672 2490085 2490085 defendant Brewer Thomas husbandman 587945 587945 Brewer, Thomas, of Dagenham, husbandman 0
5450676 2490087 2490087 defendant Brower Thomas   587945 587945 Brower, Thomas, of Dagenham 0
5450784 2490124 2490124 defendant Lynam John shoemaker 587945 587945 Lynam, John, of Dagenham, shoemaker 2
5450790 2490125 2490125 defendant Lincoln John shoemaker 587945 587945 Lincoln, John, of Dagenham, shoemaker 3
5456018 2491713 2491713 defendant Egham John husbandman 587945 587945 Egham, John, of Dagenham, husbandman 1
5471261 2496341 2496341 defendant Lyncoln William carpenter 587945 587945 Lyncoln, William, of Dagenham, carpenter 0
5499346 2504745 2504745 defendant Baldewyn William husbandman 587945 587945 Baldewyn, William, of Dagenham, husbandman 1
5503317 2505947 2505947 defendant Pragyll William (legal representative) 587945 587945 Pragyll, William, of Dagenham, husbandman, executors of 0
5503319 2505947 2505947 defendant Raffe John husbandman 587945 587945 Raffe, John, of Dagenham, husbandman 2
5514433 2509360 2509360 defendant Clerk Thomas laborer 587945 587945 Clerk, Thomas, of Dagenham, laborer 0
5517011 2510152 2510152 defendant Sparowe John (legal representative) 587945 587945 Sparowe, John, of Dagenham, yeoman, executors of 0
5517012 2510152 2510152 defendant Frost John yeoman 587945 587945 (Frost, John, of Dagenham, yeoman 1
5517013 2510152 2510152 defendant Sparowe Alice widow 587945 587945 Sparowe, Alice, of Dagenham, widow 2
5518016 2510477 2510477 defendant Barbour Henry husbandman 587945 587945 Barbour, Henry, of Dagenham, husbandman 4
5521356 2511497 2511497 defendant Clerk Thomas waterman 587945 587945 Clerk, Thomas, of Dagenham, waterman 0
5521358 2511498 2511498 defendant Clerk Thomas waterman 587945 587945 Clerk, Thomas, of Dagenham, waterman 0
5543819 2518175 2518175 defendant Hook Thomas husbandman 587945 587945 Hook, Thomas, of Dagenham, husbandman 0
5563464 2523916 2523916 defendant Skelton William sawyer 587945 587945 Skelton, William, of Dagenham, sawyer 0
5609557 2537885 2537885 defendant Prakell William husbandman 587945 587945 Prakell, William, of Dagenham, 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);