names

73 rows where place_id = 671356

✎ 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
4001213 2025212 2025212 plaintiff Hall alias Bray Robert maltster 671356 671356 Hall alias Bray, Robert, of Bedfordshire, maltster 0
4236449 2108322 2108322 defendant Kyllingsworth Thomas yeoman 671356 671356 Kyllingsworth, Thomas, of Bedfordshire, yeoman 0
4279346 2122702 2122702 defendant Simonde Richard husbandman 671356 671356 Simonde, Richard, of Bedfordshire, husbandman 1
4279347 2122702 2122702 defendant Forrest John husbandman 671356 671356 Forrest, John, of Bedfordshire, husbandman 2
4403961 2165895 2165895 defendant Gostwicke William esq 671356 671356 Gostwicke, William, of Bedfordshire, esq 0
4444421 2183236 2183236 defendant Holgrave Colecus   671356 671356 Holgrave, Colecus, of Bedfordshire 2
4444422 2183236 2183236 defendant Holdich William   671356 671356 Holdich, William, of Bedfordshire 3
4444423 2183236 2183236 defendant Seler Richard de   671356 671356 Seler, Richard de, of Bedfordshire 4
4444424 2183236 2183236 defendant Andrewe Thomas   671356 671356 Andrewe, Thomas, of Bedfordshire 5
4469546 2191138 2191138 defendant Kyng Richard   671356 671356 Kyng, Richard, of Bedfordshire 0
4469585 2191149 2191149 defendant Lyle William   671356 671356 Lyle, William, of Bedfordshire, knight 1
4475825 2193109 2193109 defendant Barbour John   671356 671356 Barbour, John, of Bedfordshire 4
4478147 2193838 2193838 defendant Wassyngle William   671356 671356 Wassyngle, William, of Bedfordshire 3
4478151 2193839 2193839 defendant Wassyngle William   671356 671356 Wassyngle, William, of Bedfordshire 2
4485807 2196270 2196270 defendant del Isle William   671356 671356 del Isle, William, of Bedfordshire, knight 0
4490582 2197749 2197749 defendant Stokes John esq 671356 671356 Stokes, John, of Bedfordshire, esq 0
4491525 2198035 2198035 defendant Godfrey William   671356 671356 Godfrey, William, of Bedfordshire 0
4491720 2198096 2198096 defendant Kyng Richard   671356 671356 Kyng, Richard, of Bedfordshire 0
4494725 2199045 2199045 defendant Eston Thomas esq 671356 671356 Eston, Thomas, of Bedfordshire, esq 0
4494727 2199046 2199046 defendant Eston Thomas esq 671356 671356 Eston, Thomas, of Bedfordshire, esq 0
4495584 2199303 2199303 defendant Hoo William de   671356 671356 Hoo, William de, of Bedfordshire, knight 0
4507848 2202916 2202916 plaintiff Worsshap John   671356 671356 Worsshap, John, of Bedfordshire, on his own account 0
4507850 2202917 2202917 plaintiff Worsship John   671356 671356 Worsship, John, of Bedfordshire, on his own account 0
4513057 2204520 2204520 defendant Eston Thomas esq 671356 671356 Eston, Thomas, of Bedfordshire, esq 0
4513060 2204521 2204521 defendant Eston Thomas esq 671356 671356 Eston, Thomas, of Bedfordshire, esq 0
4516837 2205670 2205670 defendant Bere Stephen   671356 671356 Bere, Stephen, of Bedfordshire 0
4526806 2208661 2208661 defendant Bere Stephen   671356 671356 Bere, Stephen, of Bedfordshire 0
4557064 2218136 2218136 defendant Lorde John   671356 671356 Lorde, John, of Bedfordshire 1
4561997 2219681 2219681 defendant Eston Thomas   671356 671356 Eston, Thomas, of Bedfordshire 0
4561999 2219682 2219682 defendant Oston Thomas   671356 671356 Oston, Thomas, of Bedfordshire 0
4564057 2220329 2220329 defendant Isle William de   671356 671356 Isle, William de, of Bedfordshire, knight 0
4564061 2220330 2220330 defendant Isle William de   671356 671356 Isle, William de, of Bedfordshire, knight 0
4567175 2221295 2221295 defendant Copmanford Richard   671356 671356 Copmanford, Richard, of Bedfordshire 0
4573701 2223290 2223290 defendant Campion Richard   671356 671356 Campion, Richard, of Bedfordshire 1
4574661 2223601 2223601 defendant Campion Richard   671356 671356 Campion, Richard, of Bedfordshire 1
4576332 2224104 2224104 defendant Pirwell Ralph   671356 671356 Pirwell, Ralph, of Bedfordshire 2
4593435 2229233 2229233 defendant Beauchamp Ralph   671356 671356 Beauchamp, Ralph, of Bedfordshire 1
4593704 2229304 2229304 plaintiff Penere Thomas   671356 671356 Penere, Thomas, of Bedfordshire 0
4593706 2229305 2229305 plaintiff Penere Thomas   671356 671356 Penere, Thomas, of Bedfordshire 0
4597297 2230396 2230396 defendant Hoo Thomas de   671356 671356 Hoo, Thomas de, of Bedfordshire, knight 1
4597306 2230397 2230397 defendant Hoo Thomas de   671356 671356 Hoo, Thomas de, of Bedfordshire, knight 1
4619752 2237165 2237165 defendant Eston Thomas esq 671356 671356 Eston, Thomas, of Bedfordshire, esq 0
4620331 2237340 2237340 defendant Wassyngle William   671356 671356 (Wassyngle, William, of Bedfordshire 1
4620338 2237341 2237341 defendant Wassyngle William   671356 671356 (Wassyngle, William, of Bedfordshire 1
4624418 2238620 2238620 defendant Hewet Robert   671356 671356 Hewet, Robert, of Bedfordshire 0
4625588 2238962 2238962 plaintiff Penere Thomas   671356 671356 Penere, Thomas, of Bedfordshire 0
4625591 2238963 2238963 plaintiff Penere Thomas   671356 671356 Penere, Thomas, of Bedfordshire 0
4635991 2242088 2242088 defendant Borle Richard   671356 671356 Borle, Richard, of Bedfordshire 4
4636467 2242239 2242239 defendant Claypole John   671356 671356 Claypole, John, of Bedfordshire 0
4636471 2242240 2242240 defendant Claypole John   671356 671356 Claypole, John, of Bedfordshire 0
4639180 2242977 2242977 defendant Stacheden William   671356 671356 Stacheden, William, of Bedfordshire 0
4642197 2243834 2243834 defendant Haselden Hugh   671356 671356 Haselden, Hugh, of Bedfordshire 0
4643037 2244072 2244072 defendant Pafray John   671356 671356 Pafray, John, of Bedfordshire 0
4643425 2244180 2244180 defendant Barlycon John   671356 671356 Barlycon, John, of Bedfordshire 2
4643432 2244181 2244181 defendant Barlyton John   671356 671356 Barlyton, John, of Bedfordshire 2
4649047 2245770 2245770 defendant Stoppesley Edward   671356 671356 Stoppesley, Edward, of Bedfordshire 6
4757804 2282818 2282818 plaintiff Brokeman Richard   671356 671356 Brokeman, Richard, of Bedfordshire 0
4918583 2332329 2332329 plaintiff Hampden John esq & sheriff 671356 671356 Hampden, John, of Bedfordshire, esq & sheriff 0
4927723 2335106 2335106 defendant Enderby John gent 671356 671356 Enderby, John, of Bedfordshire, gent 0
5052070 2372233 2372233 defendant Ragun Thomas (legal representative) 671356 671356 Ragun, Thomas, of Bedfordshire, esq, executors of 0
5052073 2372234 2372234 defendant Ragun Thomas (legal representative) 671356 671356 Ragun, Thomas, of Bedfordshire, esq, executors of 0
5133410 2396261 2396261 defendant Dysney Robert gent 671356 671356 Dysney, Robert, of Bedfordshire, gent 1
5135801 2396985 2396985 defendant Borough John husbandman 671356 671356 Borough, John, of Bedfordshire, husbandman 0
5188236 2412272 2412272 defendant Copyll Launcelyn de esq 671356 671356 Copyll, Launcelyn de, of Bedfordshire, esq 1
5302285 2445648 2445648 plaintiff Enderby Richard esq 671356 671356 Enderby, Richard, of Bedfordshire, esq 0
5378600 2468891 2468891 plaintiff Verney John   671356 671356 Verney, John, of Bedfordshire, sheriff 0
5378604 2468892 2468892 plaintiff Verney John   671356 671356 Verney, John, of Bedfordshire, sheriff 0
5378606 2468893 2468893 plaintiff Verney John   671356 671356 Verney, John, of Bedfordshire, sheriff 0
5378609 2468894 2468894 plaintiff Verney John   671356 671356 Verney, John, of Bedfordshire, sheriff 0
5378613 2468895 2468895 plaintiff Verney John   671356 671356 Verney, John, of Bedfordshire, Sheriff 0
5379847 2469282 2469282 defendant Spencer Robert gent 671356 671356 Spencer, Robert, of Bedfordshire, gent 0
5413831 2479061 2479061 defendant (illegible) John sadler 671356 671356 _, John, of Bedfordshire, sadler 3
5417902 2480282 2480282 defendant Smyth Thomas chapman 671356 671356 Smyth, Thomas, of Bedfordshire, chapman 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);