names

88 rows where place_id = 596605

✎ 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
3625474 1875506 1875506 defendant Russhe Thomas gent 596605 596605 Russhe, Thomas, of Parham, gent 1
3629153 1903989 1903989 plaintiff Corbald Robert   596605 596605 (Corbald, Robert, of Parham 1
3658390 1912874 1912874 plaintiff Eskethe Edward   596605 596605 Eskethe, Edward, of Parham, vicar 0
3674089 1917936 1917936 defendant Ramfolt Thomas laborer 596605 596605 Ramfolt, Thomas, of Parham, laborer 2
3685382 1921582 1921582 plaintiff Ball Ralph   596605 596605 Ball, Ralph, of Parham 0
3685385 1921582 1921582 defendant Lawter Ralph husbandman 596605 596605 Lawter, Ralph, of Parham, husbandman 0
3690229 1923103 1923103 defendant Corbald Richard husbandman 596605 596605 Corbald, Richard, of Parham, husbandman 0
3699585 1926103 1926103 defendant Broker Thomas tanner 596605 596605 Broker, Thomas, of Parham, tanner 2
3699586 1926103 1926103 defendant Parham John husbandman 596605 596605 Parham, John, of Parham, husbandman 3
3699587 1926103 1926103 defendant Broker Edward weaver 596605 596605 Broker, Edward, of Parham, weaver 4
3699588 1926103 1926103 defendant Wyker Edmund husbandman 596605 596605 Wyker, Edmund, of Parham, husbandman 5
3712923 1930363 1930363 plaintiff Wulvard Elizabeth (legal representative) 596605 596605 Wulvard, Elizabeth, of Parham, executor of 0
3712925 1930363 1930363 defendant Ramesholt Thomas yeoman 596605 596605 Ramesholt, Thomas, of Parham, yeoman 0
3713072 1930413 1930413 defendant Broker Thomas tanner 596605 596605 Broker, Thomas, of Parham, tanner 3
3713073 1930413 1930413 defendant Parham John husbandman 596605 596605 Parham, John, of Parham, husbandman 4
3713074 1930413 1930413 defendant Broker Edward weaver 596605 596605 Broker, Edward, of Parham, weaver 5
3713075 1930413 1930413 defendant Wyker Edmund husbandman 596605 596605 Wyker, Edmund, of Parham, husbandman 6
3713081 1930414 1930414 defendant Broker Thomas tanner 596605 596605 Broker, Thomas, of Parham, tanner 2
3713084 1930414 1930414 defendant Broker Robert tanner 596605 596605 Broker, Robert, of Parham, tanner 5
3713085 1930414 1930414 defendant Smyth Gabriel tanner 596605 596605 Smyth, Gabriel, of Parham, tanner 6
3713086 1930414 1930414 defendant Smyth Richard tanner 596605 596605 Smyth, Richard, of Parham, tanner 7
3713087 1930414 1930414 defendant Bacheler Henry husbandman 596605 596605 Bacheler, Henry, of Parham, husbandman 8
3713088 1930414 1930414 defendant Duke Edmund husbandman 596605 596605 Duke, Edmund, of Parham, husbandman 9
3713089 1930414 1930414 defendant Duke Edward, junior husbandman 596605 596605 Duke, Edward, junior, of Parham, husbandman 10
3713091 1930414 1930414 defendant Wyker Richard husbandman 596605 596605 Wyker, Richard, of Parham, husbandman 12
3737021 1937824 1937824 defendant Parker John (legal representative) 596605 596605 Parker, John, of Parham, gent, executor of 0
3755592 1943706 1943706 plaintiff Wulward Elizabeth (legal representative) 596605 596605 Wulward, Elizabeth, of Parham, executor of 0
3755594 1943706 1943706 defendant Ramesholt Thomas husbandman 596605 596605 Ramesholt, Thomas, of Parham, husbandman 0
3759084 1944826 1944826 defendant Darnforth James husbandman 596605 596605 Darnforth, James, of Parham, husbandman 0
3759119 1944839 1944839 defendant Darnforth James husbandman 596605 596605 Darnforth, James, of Parham, husbandman 0
3773540 1949436 1949436 plaintiff Wulward Elizabeth (legal representative) 596605 596605 Wulward, Elizabeth, of Parham, executor of 0
3773542 1949436 1949436 defendant Ramesholt Thomasm husbandman 596605 596605 Ramesholt, Thomasm, of Parham, husbandman 0
3788841 1954314 1954314 defendant Cosyn Thomas husbandman 596605 596605 Cosyn, Thomas, of Parham, husbandman 0
3788842 1954314 1954314 defendant Lawter Thomas husbandman 596605 596605 Lawter, Thomas, of Parham, husbandman 1
3788843 1954314 1954314 defendant Cosyn Robert husbandman 596605 596605 Cosyn, Robert, of Parham, husbandman 2
3814806 1962543 1962543 defendant Corbold Richard yeoman 596605 596605 Corbold, Richard, of Parham, yeoman 0
3863176 1977887 1977887 defendant Willoughby Christopher   596605 596605 Willoughby, Christopher, of Parham, knight 0
3913910 1994999 1994999 plaintiff Brome Thomas husbandman 596605 596605 Brome, Thomas, of Parham, husbandman 0
3913911 1994999 1994999 defendant Wylloughby William   596605 596605 Wylloughby, William, of Parham, knight 0
3924176 1998396 1998396 defendant Broker William tanner 596605 596605 Broker, William, of Parham, tanner 0
3928572 1999896 1999896 plaintiff Bolton Christopher gent 596605 596605 Bolton, Christopher, of Parham, gent 0
3931695 2000901 2000901 plaintiff Duxe Oliver yeoman 596605 596605 Duxe, Oliver, of Parham, yeoman 0
3935260 2002104 2002104 defendant Colvyle Thomas yeoman 596605 596605 Colvyle, Thomas, of Parham, yeoman 1
3947879 2006322 2006322 defendant Colvyll Thomas yeoman 596605 596605 Colvyll, Thomas, of Parham, yeoman 0
4001085 2025166 2025166 defendant Willoughbye Mary spinster 596605 596605 Willoughbye, Mary, of Parham, spinster 1
4173780 2086285 2086285 defendant Bolt Manestrus husbandman 596605 596605 Bolt, Manestrus, of Parham, husbandman 0
4173781 2086285 2086285 defendant Stanforth Nicholas husbandman 596605 596605 Stanforth, Nicholas, of Parham, husbandman 1
4173782 2086285 2086285 defendant Dodd John husbandman 596605 596605 Dodd, John, of Parham, husbandman 2
4216230 2101166 2101166 defendant Norman Francis butcher 596605 596605 Norman, Francis, of Parham, butcher 1
4233102 2107085 2107085 defendant Toftes William yeoman 596605 596605 Toftes, William, of Parham, yeoman 1
4240630 2109847 2109847 defendant Curtys Edmund blacksmith 596605 596605 Curtys, Edmund, of Parham, blacksmith 1
4244085 2111003 2111003 defendant Norman Francis butcher 596605 596605 Norman, Francis, of Parham, butcher 1
4278555 2122435 2122435 defendant Edward Ambrose   596605 596605 Edward, Ambrose, of Parham, twill weaver 1
4278558 2122436 2122436 defendant Downes Thomas husbandman 596605 596605 Downes, Thomas, of Parham, husbandman 1
4382677 2158913 2158913 defendant Jemy William gent 596605 596605 Jemy, William, of Parham, gent 2
4382681 2158914 2158914 defendant Jemy William gent 596605 596605 Jemy, William, of Parham, gent 2
4713129 2269429 2269429 plaintiff Stebbyng John   596605 596605 Stebbyng, John, of Parham 0
4748849 2280152 2280152 plaintiff Mory Adam (legal representative) 596605 596605 Mory, Adam, of Parham, clerk & parson, executor of 0
4768256 2286042 2286042 plaintiff Mory Adam (legal representative) 596605 596605 Mory, Adam, of Parham, clerk & rector, executor of 0
4820355 2302435 2302435 defendant Stebbyng John butcher 596605 596605 Stebbyng, John, of Parham, butcher 1
4861340 2314915 2314915 defendant Frenssh Stephen husbandman 596605 596605 Frenssh, Stephen, of Parham, husbandman 0
4916990 2331820 2331820 defendant Stebbyng John, senior husbandman 596605 596605 Stebbyng, John, senior, of Parham, husbandman 0
4916991 2331820 2331820 defendant Stebbyng John, junior butcher 596605 596605 Stebbyng, John, junior, of Parham, butcher 1
4916996 2331821 2331821 defendant Stebbyng John, senior husbandman 596605 596605 Stebbyng, John, senior, of Parham, husbandman 0
4916997 2331821 2331821 defendant Stebbyng John, junior butcher 596605 596605 Stebbyng, John, junior, of Parham, butcher 1
5245811 2428941 2428941 defendant Elmham Thomas cordwainer 596605 596605 Elmham, Thomas, of Parham, cordwainer 0
5268928 2436021 2436021 defendant Taillour L--- tailor 596605 596605 Taillour, L---, of Parham, tailor 3
5291913 2442641 2442641 defendant Palmer Robert laborer 596605 596605 Palmer, Robert, of Parham, laborer 0
5295160 2443573 2443573 defendant Hogan Walter husbandman 596605 596605 Hogan, Walter, of Parham, husbandman 1
5308464 2447568 2447568 defendant Colvyle John yeoman 596605 596605 Colvyle, John, of Parham, yeoman 1
5308465 2447568 2447568 defendant Colvyle Robert yeoman 596605 596605 Colvyle, Robert, of Parham, yeoman 2
5308467 2447568 2447568 defendant Ferrour John yeoman 596605 596605 Ferrour, John, of Parham, yeoman 4
5323898 2452230 2452230 defendant Hoo John (legal representative) 596605 596605 Hoo, John, of Parham, gent, administrator of 0
5342376 2457810 2457810 defendant Wulvard Richard husbandman 596605 596605 Wulvard, Richard, of Parham, husbandman 0
5382339 2470008 2470008 defendant Ramesholt William husbandman 596605 596605 Ramesholt, William, of Parham, husbandman 1
5387922 2471602 2471602 defendant Corbold Richard laborer 596605 596605 Corbold, Richard, of Parham, laborer 1
5395760 2473869 2473869 defendant Mathewe (illegible) husbandman 596605 596605 Mathewe, ---, of Parham, husbandman 3
5424821 2482379 2482379 defendant Ramesholt William yeoman 596605 596605 Ramesholt, William, of Parham, yeoman 0
5443497 2487964 2487964 defendant Rameshole William yeoman 596605 596605 Rameshole, William, of Parham, yeoman 0
5456219 2491774 2491774 defendant Ramesholt William yeoman 596605 596605 Ramesholt, William, of Parham, yeoman 0
5462384 2493650 2493650 defendant Ramesholt William husbandman 596605 596605 Ramesholt, William, of Parham, husbandman 0
5479283 2498820 2498820 defendant Ramesholt William yeoman 596605 596605 Ramesholt, William, of Parham, yeoman 0
5528823 2513536 2513536 defendant Rodeley Thomas yeoman 596605 596605 Rodeley, Thomas, of Parham, yeoman 1
5532517 2514713 2514713 defendant Hogan Walter yeoman 596605 596605 Hogan, Walter, of Parham, yeoman 2
5555375 2521577 2521577 defendant Whetecroft Thomas gent 596605 596605 Whetecroft, Thomas, of Parham, gent 1
5585914 2530647 2530647 defendant Parker John gent 596605 596605 Parker, John, of Parham, gent 2
5586098 2530693 2530693 defendant Parker John gent 596605 596605 Parker, John, of Parham, gent 2
5600841 2535150 2535150 defendant Corbold Richard husbandman 596605 596605 Corbold, Richard, of Parham, husbandman 3

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