names

51 rows where place_id = 624138

✎ 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
3756328 1943945 1943945 defendant Wasshyngton Lawrence yeoman 624138 624138 Wasshyngton, Lawrence, of Brigstoke, yeoman 0
3763782 1946317 1946317 defendant Smyth Thomas husbandman 624138 624138 Smyth, Thomas, of Brigstoke, husbandman 1
3765403 1946841 1946841 defendant Burton Richard esq 624138 624138 Burton, Richard, of Brigstoke, esq 1
4585239 2226807 2226807 defendant Syke John   624138 624138 Syke, John, of Brigstoke 0
4635821 2242045 2242045 defendant Couper John   624138 624138 Couper, John, of Brigstoke 5
4635828 2242045 2242045 defendant Giles Thomas   624138 624138 Giles, Thomas, of Brigstoke 12
4649184 2245812 2245812 plaintiff Tuk William   624138 624138 Tuk, William, of Brigstoke 0
4673034 2257210 2257210 defendant Doresworth John laborer 624138 624138 Doresworth, John, of Brigstoke, laborer 0
4689652 2262326 2262326 defendant Taillour John husbandman 624138 624138 Taillour, John, of Brigstoke, husbandman 0
4709785 2268417 2268417 defendant Gyles Thomas drover 624138 624138 Gyles, Thomas, of Brigstoke, drover 0
4715621 2270212 2270212 defendant Fox Walter yeoman 624138 624138 Fox, Walter, of Brigstoke, yeoman 0
4733317 2275596 2275596 defendant Vescy John laborer 624138 624138 Vescy, John, of Brigstoke, laborer 0
4920879 2333044 2333044 plaintiff Kempe Henry   624138 624138 Kempe, Henry, of Brigstoke, vicar 0
4933770 2336940 2336940 defendant Warton John smith 624138 624138 Warton, John, of Brigstoke, smith 0
4933771 2336940 2336940 defendant Tubbe Richard husbandman 624138 624138 Tubbe, Richard, of Brigstoke, husbandman 1
4970366 2348083 2348083 defendant Warner John yeoman 624138 624138 Warner, John, of Brigstoke, yeoman 1
4970367 2348083 2348083 defendant Warner William yeoman 624138 624138 Warner, William, of Brigstoke, yeoman 2
4970368 2348083 2348083 defendant Plommer Thomas husbandman 624138 624138 Plommer, Thomas, of Brigstoke, husbandman 3
4970369 2348083 2348083 defendant Phelip William husbandman 624138 624138 Phelip, William, of Brigstoke, husbandman 4
5004685 2358275 2358275 defendant Warner John yeoman 624138 624138 Warner, John, of Brigstoke, yeoman 0
5004687 2358275 2358275 defendant Neweman Richard tanner 624138 624138 Neweman, Richard, of Brigstoke, tanner 2
5023445 2363766 2363766 defendant Farmory John   624138 624138 Farmory, John, of Brigstoke, freemason 0
5030837 2365889 2365889 defendant Kyng Robert husbandman 624138 624138 Kyng, Robert, of Brigstoke, husbandman 1
5037892 2367963 2367963 defendant Warner John yeoman 624138 624138 Warner, John, of Brigstoke, yeoman 0
5038964 2368300 2368300 defendant Spicer John husbandman 624138 624138 Spicer, John, of Brigstoke, husbandman 1
5056134 2373410 2373410 defendant Kyng Robert drover 624138 624138 Kyng, Robert, of Brigstoke, or of Stanyern, drover 0
5068445 2377062 2377062 plaintiff Pittes Richard gent 624138 624138 Pittes, Richard, of Brigstoke, gent 0
5117337 2391503 2391503 defendant Fox John yeoman 624138 624138 Fox, John, of Brigstoke, yeoman 1
5117338 2391503 2391503 defendant Gregory John yeoman 624138 624138 Gregory, John, of Brigstoke, yeoman 2
5124133 2393516 2393516 defendant Barker John cordwainer 624138 624138 Barker, John, of Brigstoke, cordwainer 1
5124134 2393516 2393516 defendant Fox John yeoman 624138 624138 Fox, John, of Brigstoke, yeoman 2
5154182 2402379 2402379 defendant Johnson Adam barber 624138 624138 Johnson, Adam, of Brigstoke, barber 0
5171335 2407341 2407341 defendant Jonson Adam barber 624138 624138 Jonson, Adam, of Brigstoke, barber 0
5179781 2409825 2409825 defendant Humby Richard   624138 624138 Humby, Richard, of Brigstoke, park man 0
5181213 2410249 2410249 defendant Warner John yeoman 624138 624138 Warner, John, of Brigstoke, yeoman 0
5181216 2410250 2410250 defendant Warner John yeoman 624138 624138 Warner, John, of Brigstoke, yeoman 0
5181219 2410251 2410251 defendant Warner John yeoman 624138 624138 Warner, John, of Brigstoke, yeoman 0
5181222 2410252 2410252 defendant Warner John yeoman 624138 624138 Warner, John, of Brigstoke, yeoman 0
5202051 2416366 2416366 defendant Humby Richard   624138 624138 Humby, Richard, of Brigstoke, park man 0
5231105 2424696 2424696 defendant Weldon John husbandman 624138 624138 Weldon, John, of Brigstoke, husbandman 0
5245316 2428791 2428791 defendant Parker John butcher 624138 624138 Parker, John, of Brigstoke, butcher 0
5245317 2428791 2428791 defendant Gregory John yeoman 624138 624138 Gregory, John, of Brigstoke, yeoman 1
5251675 2430628 2430628 defendant Wattes Peter barker 624138 624138 Wattes, Peter, of Brigstoke, barker 0
5360360 2463275 2463275 defendant Taillour John tailor 624138 624138 Taillour, John, of Brigstoke, tailor 1
5446195 2488748 2488748 defendant Kynybbes John baker 624138 624138 Kynybbes, John, of Brigstoke, baker 0
5499765 2504874 2504874 defendant Armeston Richard gent 624138 624138 Armeston, Richard, of Brigstoke, gent 0
5547898 2519409 2519409 defendant Burton Richard gent 624138 624138 Burton, Richard, of Brigstoke, gent 0
5547901 2519410 2519410 defendant Burton Richard gent 624138 624138 Burton, Richard, of Brigstoke, gent 0
5571412 2526192 2526192 defendant Wassyngton John baker 624138 624138 Wassyngton, John, of Brigstoke, baker 0
5584314 2530160 2530160 defendant Gylys John husbandman 624138 624138 Gylys, John, of Brigstoke, husbandman 2
5628537 2552894 2552894 defendant Warton William laborer 624138 624138 Warton, William, of Brigstoke, laborer 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);