names

74 rows where place_id = 609117

✎ 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
3677115 1918883 1918883 defendant Beverley John gent 609117 609117 Beverley, John, of Elsham, gent 0
3892040 1987589 1987589 plaintiff Manby William gent 609117 609117 Manby, William, of Elsham, gent 0
3912410 1994481 1994481 defendant Smythe Henry husbandman 609117 609117 Smythe, Henry, of Elsham, husbandman 0
4170989 2085335 2085335 defendant Johnson James yeoman 609117 609117 Johnson, James, of Elsham, yeoman 1
4195125 2093856 2093856 defendant Dudicke Alexander yeoman 609117 609117 Dudicke, Alexander, of Elsham, yeoman 0
4225919 2104534 2104534 defendant Eggleston John gent 609117 609117 Eggleston, John, of Elsham, gent 0
4252904 2113965 2113965 defendant Eggleston John gent 609117 609117 Eggleston, John, of Elsham, gent 0
4313356 2134779 2134779 defendant Jenyson Robert husbandman 609117 609117 Jenyson, Robert, of Elsham, husbandman 0
4318992 2136757 2136757 defendant Manbye Anne widow 609117 609117 Manbye, Anne, of Elsham, widow 1
4419598 2171017 2171017 defendant Rate William   609117 609117 Rate, William, of Elsham 0
4441998 2182428 2182428 defendant Blythe Richard de   609117 609117 Blythe, Richard de, of Elsham 1
4472636 2192108 2192108 defendant Cotes Robert de   609117 609117 Cotes, Robert de, of Elsham 2
4473156 2192267 2192267 defendant Dyle William   609117 609117 Dyle, William, of Elsham 1
4488174 2197017 2197017 defendant Rate John   609117 609117 Rate, John, of Elsham 1
4488185 2197019 2197019 defendant Rate John   609117 609117 Rate, John, of Elsham 1
4500869 2200891 2200891 defendant Saxby John de   609117 609117 Saxby, John de, of Elsham 5
4508977 2203286 2203286 defendant Breton John   609117 609117 Breton, John, of Elsham 0
4553936 2217151 2217151 plaintiff Godsaule William   609117 609117 Godsaule, William, of Elsham 0
4650972 2246303 2246303 defendant Benesley or Bevesley Richard gent 609117 609117 Benesley or Bevesley, Richard, of Elsham, gent 1
4650979 2246306 2246306 defendant Scryveyn William merchant 609117 609117 Scryveyn, William, of Elsham, merchant 0
4650980 2246306 2246306 defendant Breton John esq 609117 609117 Breton, John, of Elsham, esq 1
4660407 2249080 2249080 defendant Scryven William merchant 609117 609117 Scryven, William, of Elsham, merchant 0
4660408 2249080 2249080 defendant Breton John esq 609117 609117 Breton, John, of Elsham, esq 1
4660410 2249081 2249081 defendant Scryveyn William merchant 609117 609117 Scryveyn, William, of Elsham, merchant 0
4660411 2249081 2249081 defendant Breton John esq 609117 609117 Breton, John, of Elsham, esq 1
4661082 2249291 2249291 defendant Beverley Richard gent 609117 609117 Beverley, Richard, of Elsham, gent 1
4661516 2249433 2249433 defendant Cole William husbandman 609117 609117 Cole, William, of Elsham, husbandman 0
4674359 2257587 2257587 defendant Beverley Richard gent 609117 609117 Beverley, Richard, of Elsham, gent 0
4674703 2257699 2257699 defendant Rogerson Robert laborer 609117 609117 Rogerson, Robert, of Elsham, laborer 0
4675860 2258059 2258059 defendant Gudesaule William   609117 609117 Gudesaule, William, of Elsham 0
4675861 2258059 2258059 defendant Gudesaule John, senior   609117 609117 Gudesaule, John, senior, of Elsham 1
4700391 2265536 2265536 defendant Cotes John husbandman 609117 609117 Cotes, John, of Elsham, husbandman 0
4701371 2265830 2265830 defendant Gudesaull John husbandman 609117 609117 Gudesaull, John, of Elsham, husbandman 0
4708164 2267931 2267931 defendant Cotes John de   609117 609117 Cotes, John de, of Elsham 0
4715877 2270279 2270279 defendant Haburgh Robert de husbandman 609117 609117 Haburgh, Robert de, of Elsham, husbandman 3
4715878 2270279 2270279 defendant Crakker Hugh husbandman 609117 609117 Crakker, Hugh, of Elsham, husbandman 4
4726443 2273553 2273553 defendant Couper John yeoman 609117 609117 Couper, John, of Elsham, yeoman 1
4726445 2273553 2273553 defendant Breton John gent 609117 609117 Breton, John, of Elsham, gent 3
4726446 2273553 2273553 defendant Wryght Thomas   609117 609117 Wryght, Thomas, of Elsham, wright 4
4729538 2274449 2274449 defendant Breton John gent 609117 609117 Breton, John, of Elsham, gent 2
4733400 2275624 2275624 defendant Besyng William husbandman 609117 609117 Besyng, William, of Elsham, husbandman 0
4759935 2283444 2283444 defendant Coke Henry (legal representative) 609117 609117 Coke, Henry, of Elsham, executrix of 0
4759936 2283444 2283444 defendant Coke Margaret widow 609117 609117 Coke, Margaret, of Elsham, widow 1
4775348 2288284 2288284 defendant Shepherd Robert   609117 609117 Shepherd, Robert, of Elsham, shepherd 0
4782182 2290426 2290426 plaintiff Coke Robert   609117 609117 Coke, Robert, of Elsham 0
4782183 2290426 2290426 defendant Coke Henry (legal representative) 609117 609117 Coke, Henry, of Elsham, executrix of 0
4782184 2290426 2290426 defendant Coke Margaret widow 609117 609117 Coke, Margaret, of Elsham, widow 1
4782456 2290522 2290522 plaintiff Cook Margaret   609117 609117 Cook, Margaret, of Elsham 0
4827315 2304590 2304590 defendant Rogerson Ralph husbandman 609117 609117 Rogerson, Ralph, of Elsham, husbandman 0
4829992 2305426 2305426 defendant Breton John husbandman 609117 609117 Breton, John, of Elsham, husbandman 0
4835847 2307201 2307201 defendant Rogerson Ralph   609117 609117 Rogerson, Ralph, of Elsham 2
4837279 2307605 2307605 defendant Marchaund Nicholas husbandman 609117 609117 Marchaund, Nicholas, of Elsham, husbandman 0
4837297 2307610 2307610 defendant Clerk John glasier 609117 609117 Clerk, John, of Elsham, glasier 0
4861264 2314891 2314891 plaintiff Cotes John   609117 609117 Cotes, John, of Elsham 0
4863262 2315479 2315479 defendant Horn John husbandman 609117 609117 Horn, John, of Elsham, husbandman 4
4864534 2315880 2315880 defendant Clerk John glasier 609117 609117 Clerk, John, of Elsham, glasier 0
4880586 2320838 2320838 plaintiff Holm Robert   609117 609117 Holm, Robert, of Elsham 1
4880589 2320839 2320839 plaintiff Holme Robert husbandman 609117 609117 Holme, Robert, of Elsham, husbandman 1
4892131 2324279 2324279 defendant Besyng John husbandman 609117 609117 Besyng, John, of Elsham, husbandman 0
4892132 2324279 2324279 defendant Boy John laborer 609117 609117 Boy, John, of Elsham, laborer 1
4914510 2331056 2331056 plaintiff Matebek William   609117 609117 Matebek, William, of Elsham 1
4997664 2356158 2356158 plaintiff Holme Robert   609117 609117 Holme, Robert, of Elsham 0
5093784 2384580 2384580 defendant Typpull William husbandman 609117 609117 Typpull, William, of Elsham, husbandman 0
5126046 2394102 2394102 defendant Besyng John husbandman 609117 609117 Besyng, John, of Elsham, husbandman 0
5126047 2394102 2394102 defendant Joneson John, senior husbandman 609117 609117 Joneson, John, senior, of Elsham, husbandman 1
5165418 2405633 2405633 defendant Besyng John husbandman 609117 609117 Besyng, John, of Elsham, husbandman 0
5165419 2405633 2405633 defendant Joneson John, sen husbandman 609117 609117 Joneson, John, sen, of Elsham, husbandman 1
5236321 2426212 2426212 defendant Typpell John husbandman 609117 609117 Typpell, John, of Elsham, husbandman 0
5290823 2442324 2442324 defendant Bryan William gent 609117 609117 Bryan, William, of Elsham, gent 0
5290824 2442324 2442324 defendant Neyll Alan fisher 609117 609117 Neyll, Alan, of Elsham, fisher 1
5323547 2452124 2452124 defendant Sandall William husbandman 609117 609117 Sandall, William, of Elsham, husbandman 1
5629357 2553161 2553161 plaintiff Rate John   609117 609117 Rate, John, of Elsham 0
5629358 2553161 2553161 defendant Cotes John husbandman 609117 609117 Cotes, John, of Elsham, husbandman 0
5629359 2553162 2553162 plaintiff Rate John   609117 609117 Rate, John, of Elsham 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);