names

53 rows where place_id = 586825

✎ 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
3589746 1864432 1864432 defendant Warde John husbandman 586825 586825 Warde, John, of Debden, husbandman 0
3589750 1864432 1864432 defendant Tyler John husbandman 586825 586825 Tyler, John, of Debden, husbandman 4
3643730 1908466 1908466 defendant Cryspe Robert husbandman 586825 586825 Cryspe, Robert, of Debden, husbandman 3
3654483 1911661 1911661 defendant Garrard Thomas husbandman 586825 586825 Garrard, Thomas, of Debden, husbandman 2
3654484 1911661 1911661 defendant Chekold Peter husbandman 586825 586825 Chekold, Peter, of Debden, husbandman 3
3679927 1919788 1919788 defendant Ilger Robert husbandman 586825 586825 Ilger, Robert, of Debden, husbandman 0
3688962 1922708 1922708 defendant Sparowe John husbandman 586825 586825 Sparowe, John, of Debden, husbandman 1
3710358 1929559 1929559 defendant Sparowe John husbandman 586825 586825 Sparowe, John, of Debden, husbandman 0
3729830 1935585 1935585 defendant Sparowe John husbandman 586825 586825 Sparowe, John, of Debden, husbandman 0
3729833 1935586 1935586 defendant Sprowe John husbandman 586825 586825 Sprowe, John, of Debden, husbandman 0
3730588 1935802 1935802 defendant Sparowe Robert husbandman 586825 586825 Sparowe, Robert, of Debden, husbandman 2
3732940 1936526 1936526 defendant Chekold Peter laborer 586825 586825 Chekold, Peter, of Debden, laborer 1
3733257 1936636 1936636 defendant Sparowe John husbandman 586825 586825 Sparowe, John, of Debden, husbandman 1
3743570 1939864 1939864 defendant Ilger Robert husbandman 586825 586825 Ilger, Robert, of Debden, husbandman 0
3743571 1939864 1939864 defendant Roger William carpenter 586825 586825 Roger, William, of Debden, carpenter 1
3747045 1940992 1940992 defendant Ilger John husbandman 586825 586825 Ilger, John, of Debden, husbandman 0
3754216 1943267 1943267 defendant Browne John, junior husbandman 586825 586825 Browne, John, junior, of Debden, husbandman 0
3760936 1945426 1945426 defendant Sparowe John husbandman 586825 586825 Sparowe, John, of Debden, husbandman 0
3799753 1957843 1957843 defendant Oterell William carpenter 586825 586825 Oterell, William, of Debden, carpenter 1
3804527 1959356 1959356 defendant Barbour Nicholas husbandman 586825 586825 Barbour, Nicholas, of Debden, husbandman 1
3815468 1962752 1962752 defendant Ilger John carpenter 586825 586825 Ilger, John, of Debden, carpenter 4
3826621 1966172 1966172 defendant Birde John yeoman 586825 586825 Birde, John, of Debden, yeoman 3
3829993 1967277 1967277 defendant Poole Hugh yeoman 586825 586825 Poole, Hugh, of Debden, yeoman 0
3846423 1972435 1972435 defendant Ilger John husbandman 586825 586825 Ilger, John, of Debden, husbandman 2
3847134 1972656 1972656 defendant Ilger John carpenter 586825 586825 Ilger, John, of Debden, carpenter 2
3851854 1974173 1974173 defendant West William   586825 586825 West, William, of Debden, knight, sheriff of Essex 0
3853827 1974829 1974829 defendant Sparowe John yeoman 586825 586825 Sparowe, John, of Debden, yeoman 2
3881794 1984162 1984162 defendant Smyth alias Thresher John husbandman 586825 586825 Smyth alias Thresher, John, of Debden, husbandman 0
3904226 1991658 1991658 defendant Sparowe John yeoman 586825 586825 Sparowe, John, of Debden, yeoman 2
3914587 1995223 1995223 defendant Colman Robert husbandman 586825 586825 (Colman, Robert, of Debden, husbandman 3
3925651 1998892 1998892 plaintiff Wryght Robert   586825 586825 Wryght, Robert, of Debden 0
3961478 2011111 2011111 defendant Davye Henry laborer 586825 586825 Davye, Henry, of Debden, husbandman, son of John Davye, of Amberden, Debden, laborer 0
3965872 2012681 2012681 defendant Curteys John husbandman 586825 586825 Curteys, John, of Debden, husbandman 1
3976382 2016314 2016314 defendant Cutt Richard gent 586825 586825 Cutt, Richard, of Debden, gent 0
3976383 2016314 2016314 defendant Hamond Richard yeoman 586825 586825 Hamond, Richard, of Debden, yeoman 1
3986404 2019879 2019879 defendant Meade John yeoman 586825 586825 Meade, John, of Debden, yeoman 0
3999272 2024496 2024496 plaintiff Fryer Hamnet or Hamlet yeoman 586825 586825 Fryer, Hamnet or Hamlet, of Debden, yeoman 0
4018290 2031269 2031269 plaintiff Tyler Thomas laborer 586825 586825 Tyler, Thomas, of Debden, laborer 0
4268747 2119140 2119140 defendant Cutt Richard gent 586825 586825 Cutt, Richard, of Debden, gent 3
4268752 2119141 2119141 defendant Cutt Richard gent 586825 586825 Cutt, Richard, of Debden, gent 3
4282572 2123806 2123806 defendant Cowell John singleman 586825 586825 Cowell, John, of Debden, yeoman, singleman 1
4401082 2164956 2164956 defendant Pilgram George yeoman 586825 586825 Pilgram, George, of Debden, yeoman 0
4937105 2337976 2337976 defendant Machon Robert yeoman 586825 586825 Machon, Robert, of Debden, yeoman 0
4950034 2341978 2341978 defendant Sergeaunt Thomas yeoman 586825 586825 Sergeaunt, Thomas, of Debden, yeoman 1
5014058 2360966 2360966 defendant Sergeant Thomas husbandman 586825 586825 Sergeant, Thomas, of Debden, husbandman 0
5039602 2368492 2368492 defendant Sergeant Thomas husbandman 586825 586825 Sergeant, Thomas, of Debden, husbandman 2
5219487 2421424 2421424 defendant Machoun Richard husbandman 586825 586825 Machoun, Richard, of Debden, husbandman 0
5365360 2464839 2464839 defendant Goldyng Lawrence tailor 586825 586825 Goldyng, Lawrence, of Debden, tailor 1
5490192 2501951 2501951 defendant Garard Thomas husbandman 586825 586825 Garard, Thomas, of Debden, husbandman 0
5522629 2511902 2511902 defendant Garard Thomas husbandman 586825 586825 Garard, Thomas, of Debden, husbandman 2
5525603 2512598 2512598 defendant Motte William yeoman 586825 586825 Motte, William, of Debden, yeoman 3
5567242 2524995 2524995 defendant Turnour John laborer 586825 586825 Turnour, John, of Debden, laborer 0
5574676 2527155 2527155 defendant Cryspe Robert husbandman 586825 586825 Cryspe, Robert, of Debden, 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);