names

45 rows where place_id = 610086

✎ 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
3681854 1920430 1920430 defendant Browne Richard yeoman 610086 610086 Browne, Richard, of Lamborne, yeoman 0
3687060 1922125 1922125 defendant Kyng Henry tailor 610086 610086 Kyng, Henry, of Lamborne, tailor 0
3753308 1942972 1942972 defendant Garard Edward gent 610086 610086 Garard, Edward, of Lamborne, gent 0
3755052 1943530 1943530 defendant Maynerd John husbandman 610086 610086 Maynerd, John, of Lamborne, husbandman 2
3755053 1943530 1943530 defendant Baker Richard husbandman 610086 610086 Baker, Richard, of Lamborne, husbandman 3
3837120 1969511 1969511 defendant Broman Richard husbandman 610086 610086 Broman, Richard, of Lamborne, husbandman 0
3916200 1995805 1995805 defendant Whelpedale Gilbert clerk 610086 610086 Whelpedale, Gilbert, of Lamborne, clerk 0
3931933 2000981 2000981 defendant Grey Henry laborer 610086 610086 Grey, Henry, of Lamborne, laborer 1
3932220 2001081 2001081 defendant Grey Henry laborer 610086 610086 Grey, Henry, of Lamborne, laborer 1
3979696 2017492 2017492 plaintiff Organ alias Tayler John yeoman 610086 610086 Organ alias Tayler, John, of Lamborne, yeoman 0
3979702 2017494 2017494 plaintiff Organ John husbandman 610086 610086 Organ, John, of Lamborne, husbandman 0
3985355 2019520 2019520 defendant Hill Thomas Essex, yeoman 610086 610086 Hill Thomas, of Lamborne, Essex, yeoman 1
4004191 2026274 2026274 defendant Colton John yeoman 610086 610086 Colton, John, of Lamborne, yeoman 0
4004192 2026274 2026274 defendant Plumtre Arthur yeoman 610086 610086 Plumtre, Arthur, of Lamborne, yeoman 1
4015846 2030353 2030353 defendant Barfoote Benedict gent 610086 610086 Barfoote, Benedict, of Lamborne, gent 0
4015847 2030353 2030353 defendant Noke John husbandman 610086 610086 Noke, John, of Lamborne, husbandman 1
4085749 2055177 2055177 defendant Blagrowe Margaret widow 610086 610086 Blagrowe, Margaret, of Lamborne, widow 0
4085750 2055177 2055177 defendant Blagrowe Mary spinster 610086 610086 Blagrowe, Mary, of Lamborne, spinster 1
4085751 2055177 2055177 defendant Newman William husbandman 610086 610086 Newman, William, of Lamborne, husbandman 2
4107568 2062994 2062994 defendant Mundaye William carpenter 610086 610086 Mundaye, William, of Lamborne, carpenter 2
4107573 2062994 2062994 defendant Lunne John tailor 610086 610086 Lunne, John, of Lamborne, tailor 7
4120780 2067718 2067718 defendant Spenser William husbandman 610086 610086 Spenser, William, of Lamborne, husbandman 1
4159150 2081270 2081270 defendant Mundaye William carpenter 610086 610086 Mundaye, William, of Lamborne, carpenter 2
4159154 2081270 2081270 defendant Lune or Lime John tailor 610086 610086 Lune or Lime, John, of Lamborne, tailor 6
4182918 2089509 2089509 defendant Waldron John gent 610086 610086 Waldron, John, of Lamborne, gent 0
4182921 2089509 2089509 defendant Waldron Robert gent 610086 610086 Waldron, Robert, of Lamborne, gent 3
4186306 2090696 2090696 defendant Barfotte Thomas gent 610086 610086 Barfotte, Thomas, of Lamborne, gent 0
4302290 2130916 2130916 defendant Edmund William husbandman 610086 610086 Edmund, William, of Lamborne, husbandman 0
4303034 2131189 2131189 defendant Edmond William husbandman 610086 610086 Edmond, William, of Lamborne, husbandman 0
4528919 2209324 2209324 defendant Smyth Richard   610086 610086 Smyth, Richard, of Lamborne 2
4528927 2209326 2209326 defendant Smyth Richard   610086 610086 Smyth, Richard, of Lamborne 2
4541002 2213092 2213092 defendant Tannere William   610086 610086 Tannere, William, of Lamborne 2
4845848 2310210 2310210 defendant Flewelyn Lewis chapman 610086 610086 Flewelyn, Lewis, of Lamborne, chapman 0
4954885 2343417 2343417 defendant Notte John husbandman 610086 610086 Notte, John, of Lamborne, husbandman 0
5050013 2371623 2371623 defendant Bocher John   610086 610086 Bocher, John, of Lamborne, "herde" 4
5052624 2372376 2372376 defendant Poyntell Alice widow 610086 610086 Poyntell, Alice, of Lamborne, widow 0
5069626 2377411 2377411 defendant Daweson William clerk 610086 610086 Daweson, William, of Lamborne, clerk 0
5089258 2383228 2383228 defendant Felde John husbandman 610086 610086 Felde, John, of Lamborne, husbandman 0
5445462 2488541 2488541 defendant Poyngton Richard maltman 610086 610086 Poyngton, Richard, of Lamborne, maltman 0
5458245 2492367 2492367 defendant Poyngton Richard maltman 610086 610086 Poyngton, Richard, of Lamborne, maltman 0
5458247 2492367 2492367 defendant Wattys John husbandman 610086 610086 Wattys, John, of Lamborne, husbandman 2
5469884 2495917 2495917 defendant Poyngton Richard maltman 610086 610086 Poyngton, Richard, of Lamborne, maltman 0
5469886 2495917 2495917 defendant Wattys John husbandman 610086 610086 Wattys, John, of Lamborne, husbandman 2
5476496 2497975 2497975 defendant Poyngton Richard maltman 610086 610086 Poyngton, Richard, of Lamborne, maltman 0
5476498 2497975 2497975 defendant Wattys John husbandman 610086 610086 Wattys, John, of Lamborne, husbandman 2

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