names

66 rows where place_id = 589441

✎ 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
3597656 1866891 1866891 defendant Lovet William gent 589441 589441 Lovet, William, of Welford, gent 0
3608868 1870429 1870429 defendant Post William yeoman 589441 589441 Post, William, of Welford, yeoman 0
3629653 1904128 1904128 defendant More Thomas gent 589441 589441 More, Thomas, of Welford, gent 0
3674420 1918044 1918044 defendant West John yeoman 589441 589441 West, John, of Welford, yeoman 0
3696383 1925093 1925093 defendant Alyn Thomas   589441 589441 Alyn, Thomas, of Welford, yeoman, son of Alyn, Richard 0
3704879 1927818 1927818 defendant Bate John miller 589441 589441 Bate, John, of Welford, miller 1
3704880 1927818 1927818 defendant Barker Mathew yeoman 589441 589441 Barker, Mathew, of Welford, yeoman 2
3718926 1932199 1932199 defendant Urvey John miller 589441 589441 Urvey, John, of Welford, miller 0
3718927 1932199 1932199 defendant Bate John miller 589441 589441 Bate, John, of Welford, miller 1
3753050 1942891 1942891 defendant Standyshe Hugh gent 589441 589441 Standyshe, Hugh, of Welford, gent 0
3770033 1948290 1948290 defendant Standysshe Hugh gent 589441 589441 Standysshe, Hugh, of Welford, gent 0
3799768 1957848 1957848 defendant Tomson John yeoman 589441 589441 Tomson, John, of Welford, yeoman 0
3799771 1957849 1957849 defendant Tomson John yeoman 589441 589441 Tomson, John, of Welford, yeoman 0
3815058 1962631 1962631 defendant Harryson Stephen carpenter 589441 589441 Harryson, Stephen, of Welford, carpenter 0
3815061 1962631 1962631 defendant Ancorne Thomas miller 589441 589441 Ancorne, Thomas, of Welford, miller 3
3984675 2019277 2019277 defendant Edmondes Richard laborer 589441 589441 Edmondes, Richard, of Welford, laborer 1
4209028 2098710 2098710 defendant Jones Philip clerk 589441 589441 Jones, Philip, of Welford, clerk 1
4275743 2121464 2121464 defendant Huntley Francis gent 589441 589441 Huntley, Francis, of Welford, gent 0
4439751 2181708 2181708 defendant Brayn John   589441 589441 Brayn, John, of Welford 0
4522654 2207425 2207425 defendant Betson Thomas   589441 589441 Betson, Thomas, of Welford 0
4529857 2209625 2209625 plaintiff Neel Ralph   589441 589441 Neel, Ralph, of Welford 0
4543886 2213989 2213989 defendant Drake Hugh   589441 589441 Drake, Hugh, of Welford 0
4564581 2220482 2220482 defendant Scrayfeld Richard   589441 589441 Scrayfeld, Richard, of Welford 0
4565279 2220712 2220712 defendant Scrayfeld Richard   589441 589441 Scrayfeld, Richard, of Welford 0
4602736 2232069 2232069 defendant Dasshe John   589441 589441 Dasshe, John, of Welford 0
4626471 2239227 2239227 defendant Shephurd John   589441 589441 Shephurd, John, of Welford 4
4629210 2240067 2240067 defendant Wythenale John   589441 589441 Wythenale, John, of Welford 0
4643584 2244225 2244225 defendant Welford Richard   589441 589441 Welford, Richard, of Welford 0
4650872 2246276 2246276 defendant Shepherd John   589441 589441 Shepherd, John, of Welford 0
4666844 2255355 2255355 defendant Scrayfeld Richard husbandman 589441 589441 Scrayfeld, Richard, of Welford, husbandman 0
4666846 2255356 2255356 defendant Scrayfeld Richard husbandman 589441 589441 Scrayfeld, Richard, of Welford, husbandman 0
4742449 2278291 2278291 defendant Tybot John husbandman 589441 589441 Tybot, John, of Welford, husbandman 0
4763746 2284649 2284649 defendant Croke William fuller 589441 589441 Croke, William, of Welford, fuller 4
4763747 2284649 2284649 defendant Nel William husbandman 589441 589441 Nel, William, of Welford, husbandman 5
4763752 2284650 2284650 defendant Croke William fuller 589441 589441 Croke, William, of Welford, fuller 3
4763753 2284650 2284650 defendant Nel William husbandman 589441 589441 Nel, William, of Welford, husbandman 4
4775741 2288409 2288409 defendant Swan William   589441 589441 Swan, William, of Welford, parson 1
4801672 2296706 2296706 defendant Bolere Robert clerk 589441 589441 Bolere, Robert, of Welford, clerk 0
4826914 2304455 2304455 defendant Dasshe John chandler 589441 589441 Dasshe, John, of Welford, chandler 0
4841860 2308987 2308987 defendant Scarburgh John gent 589441 589441 Scarburgh, John, of Welford, gent 0
4872777 2318435 2318435 defendant Fynton William yeoman 589441 589441 Fynton, William, of Welford, yeoman 0
4886854 2322743 2322743 defendant Lovet William   589441 589441 Lovet, William, of Welford 0
4926636 2334749 2334749 defendant Crooke William husbandman 589441 589441 Crooke, William, of Welford, husbandman 1
4945610 2340607 2340607 defendant Wright Robert carpenter 589441 589441 Wright, Robert, of Welford, carpenter 3
4970578 2348142 2348142 defendant Sulby Robert husbandman 589441 589441 Sulby, Robert, of Welford, husbandman 0
4970579 2348142 2348142 defendant Carter John husbandman 589441 589441 Carter, John, of Welford, husbandman 1
4973161 2348906 2348906 defendant Berde John husbandman 589441 589441 Berde, John, of Welford, husbandman 1
4973162 2348906 2348906 defendant Crook William husbandman 589441 589441 Crook, William, of Welford, husbandman 2
4993528 2354936 2354936 defendant Aylemere Thomas husbandman 589441 589441 Aylemere, Thomas, of Welford, husbandman 3
5007093 2358967 2358967 defendant Ive Robert yeoman 589441 589441 Ive, Robert, of Welford, yeoman 8
5095463 2385092 2385092 defendant Deyster John yeoman 589441 589441 Deyster, John, of Welford, yeoman 0
5095465 2385093 2385093 defendant Lovet Thomas yeoman 589441 589441 Lovet, Thomas, of Welford, yeoman 0
5095467 2385093 2385093 defendant Deyster John husbandman 589441 589441 together with Deyster, John, of Welford, husbandman 2
5135298 2396823 2396823 defendant Aylton John   589441 589441 Aylton, John, of Welford husbandman 1
5225440 2423119 2423119 plaintiff Scarburgh John esq 589441 589441 Scarburgh, John, of Welford, esq 0
5246719 2429203 2429203 plaintiff Seynt German Henry   589441 589441 Seynt German, Henry, of Welford 0
5249050 2429845 2429845 defendant Nicols Richard husbandman 589441 589441 Nicols, Richard, of Welford, husbandman 1
5312164 2448672 2448672 defendant Lovet Thomas gent 589441 589441 Lovet, Thomas, of Welford, gent 0
5319443 2450906 2450906 defendant Harnes John husbandman 589441 589441 Harnes, John, of Welford, husbandman 1
5336752 2456060 2456060 defendant Hayward John husbandman 589441 589441 Hayward, John, of Welford, husbandman 0
5336753 2456060 2456060 defendant Harnes or Harves John husbandman 589441 589441 Harnes or Harves, John, of Welford, husbandman 1
5367156 2465374 2465374 defendant Lovet William gent 589441 589441 Lovet, William, of Welford, gent 0
5377334 2468501 2468501 defendant Lewesham Robert yeoman 589441 589441 Lewesham, Robert, of Welford, yeoman 0
5392431 2472913 2472913 plaintiff Saunders Edward   589441 589441 Saunders, Edward, of Welford 0
5569104 2525515 2525515 defendant Gilberd John laborer 589441 589441 Gilberd, John, of Welford, laborer 0
5612669 2547711 2547711 defendant Sulby Richard   589441 589441 Sulby, Richard, of Welford 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);