names

89 rows where place_id = 593662

✎ 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
3612830 1871661 1871661 defendant Symson John yeoman 593662 593662 Symson, John, of Croft, yeoman 0
3704370 1927668 1927668 defendant Ellerbek William yeoman 593662 593662 Ellerbek, William, of Croft, yeoman 3
3756016 1943836 1943836 defendant Smyth William husbandman 593662 593662 Smyth, William, of Croft, husbandman 1
3768756 1947878 1947878 defendant Wyke Edward yeoman 593662 593662 Wyke, Edward, of Croft, yeoman 0
3786561 1953591 1953591 defendant Wyke Edward yeoman 593662 593662 Wyke, Edward, of Croft, yeoman 0
3787817 1953977 1953977 defendant Edlyngton Alan husbandman 593662 593662 Edlyngton, Alan, of Croft, husbandman 0
3791367 1955136 1955136 defendant Wykes Walter yeoman 593662 593662 Wykes, Walter, of Croft, yeoman 3
3802855 1958789 1958789 defendant Wyke Edward yeoman 593662 593662 Wyke, Edward, of Croft, yeoman 0
3867864 1979484 1979484 defendant Anderson Thomas husbandman 593662 593662 Anderson, Thomas, of Croft, husbandman 0
3867866 1979485 1979485 defendant Anderson Thomas husbandman 593662 593662 Anderson, Thomas, of Croft, husbandman 0
3877270 1982641 1982641 plaintiff Holand Thomas   593662 593662 Holand, Thomas, of Croft 0
4022994 2032943 2032943 defendant Jonson Alexander husbandman 593662 593662 Jonson, Alexander, of Croft, husbandman 1
4125324 2069341 2069341 defendant Bawdrie John yeoman 593662 593662 Bawdrie, John, of Croft, yeoman 2
4150725 2078393 2078393 defendant Croft Edward esq 593662 593662 Croft, Edward, of Croft, esq 1
4444331 2183216 2183216 defendant Wawet henry master & parson 593662 593662 Wawet, henry, of Croft, master & parson 0
4459422 2187997 2187997 defendant Sareson Thomas   593662 593662 Sareson, Thomas, of Croft 0
4491830 2198124 2198124 defendant Sareson Nicholas   593662 593662 Sareson, Nicholas, of Croft 1
4511898 2204171 2204171 plaintiff Bod Thomas   593662 593662 Bod, Thomas, of Croft 0
4511899 2204171 2204171 plaintiff Thomasson John   593662 593662 Thomasson, John, of Croft 1
4534024 2210912 2210912 defendant Ferrour Robert chaplain 593662 593662 Ferrour, Robert, of Croft, chaplain 0
4548459 2215457 2215457 plaintiff Chok Philip   593662 593662 Chok, Philip, of Croft 0
4591239 2228618 2228618 defendant Saresson John   593662 593662 Saresson, John, of Croft 0
4636182 2242149 2242149 defendant Dale Richard de   593662 593662 Dale, Richard de, of Croft 2
4643658 2244246 2244246 defendant Pynder Hugh   593662 593662 Pynder, Hugh, of Croft 1
4646607 2245072 2245072 defendant Umfravile Gilbert esq 593662 593662 Umfravile, Gilbert, of Croft, esq 0
4657218 2248143 2248143 defendant Umframvile Gilbert   593662 593662 Umframvile, Gilbert, of Croft, knight 0
4669206 2256073 2256073 defendant Jay Hugh yeoman 593662 593662 Jay, Hugh, of Croft, yeoman 0
4679683 2259261 2259261 defendant Pynder Hugh yeoman 593662 593662 Pynder, Hugh, of Croft, yeoman 0
4721946 2272195 2272195 defendant Symson Thomas chaplain 593662 593662 Symson, Thomas, of Croft, chaplain 0
4740183 2277642 2277642 defendant Wyotson John husbandman 593662 593662 Wyotson, John, of Croft, husbandman 4
4807879 2298650 2298650 defendant del Wall William shoemaker 593662 593662 del Wall, William, of Croft, shoemaker 0
4817316 2301506 2301506 defendant Pynder Alan (legal representative) 593662 593662 Pynder, Alan, of Croft, executors of 1
4817317 2301506 2301506 defendant Pynder Robert husbandman 593662 593662 Pynder, Robert, of Croft, husbandman 2
4841578 2308899 2308899 defendant Sareson Thomas husbandman 593662 593662 Sareson, Thomas, of Croft, husbandman 0
4846045 2310267 2310267 defendant Dautre William gent 593662 593662 Dautre, William, of Croft, gent 3
4854878 2312880 2312880 defendant Wyotson John   593662 593662 Wyotson, John, of Croft, husbandman, son of Wyotson, Robert 0
4861064 2314818 2314818 defendant Mason Richard yeoman 593662 593662 Mason, Richard, of Croft, yeoman 0
4861735 2315042 2315042 defendant Hudson Richard husbandman 593662 593662 Hudson, Richard, of Croft, husbandman 3
4871352 2318008 2318008 defendant Pynder Hugh husbandman 593662 593662 Pynder, Hugh, of Croft, husbandman 0
4903097 2327583 2327583 plaintiff Roper John chaplain 593662 593662 Roper, John, of Croft, chaplain 0
4933103 2336746 2336746 defendant Sutton William laborer & son of Thomas Sutton 593662 593662 Sutton, William, of Croft, laborer & son of Thomas Sutton 2
4933104 2336746 2336746 defendant Hobson Alan laborer 593662 593662 Hobson, Alan, of Croft, laborer 3
4933105 2336746 2336746 defendant Watson Walter laborer 593662 593662 Watson, Walter, of Croft, laborer 4
4933106 2336746 2336746 defendant in the Deyles William laborer 593662 593662 in the Deyles, William, of Croft, laborer 5
4935478 2337493 2337493 defendant Symson Henry chaplain 593662 593662 Symson, Henry, of Croft, chaplain 0
4940361 2339007 2339007 defendant Damme Alice widow 593662 593662 Damme, Alice, of Croft, widow 3
4979699 2350883 2350883 defendant Westmelles Robert husbandman 593662 593662 Westmelles, Robert, of Croft, husbandman 0
5037957 2367983 2367983 defendant atte Gote Richard husbandman 593662 593662 atte Gote, Richard, of Croft, husbandman 1
5043969 2369825 2369825 defendant Lowes Alan husbandman 593662 593662 Lowes, Alan, of Croft, husbandman 0
5050334 2371724 2371724 defendant Watson Walter husbandman 593662 593662 Watson, Walter, of Croft, husbandman 2
5052644 2372383 2372383 defendant Meldon Thomas shoemaker 593662 593662 Meldon, Thomas, of Croft, shoemaker 0
5058378 2374053 2374053 defendant Wyotson John, junior husbandman 593662 593662 Wyotson, John, junior, of Croft, husbandman 0
5072119 2378151 2378151 defendant Grenne John laborer 593662 593662 Grenne, John, of Croft, laborer 0
5082803 2381363 2381363 defendant Valantyne Richard husbandman 593662 593662 Valantyne, Richard, of Croft, husbandman 0
5084661 2381928 2381928 defendant Hopkynson John husbandman 593662 593662 Hopkynson, John, of Croft, husbandman 0
5084662 2381928 2381928 defendant Hopkynson Henry husbandman 593662 593662 Hopkynson, Henry, of Croft, husbandman 1
5084663 2381928 2381928 defendant Nevyll William husbandman 593662 593662 Nevyll, William, of Croft, husbandman 2
5084664 2381928 2381928 defendant Wyberd John tailor 593662 593662 Wyberd, John, of Croft, tailor 3
5084665 2381928 2381928 defendant Partenay Walter laborer 593662 593662 Partenay, Walter, of Croft, laborer 4
5108227 2388837 2388837 defendant Pelson William husbandman 593662 593662 Pelson, William, of Croft, husbandman 0
5124740 2393712 2393712 defendant Brynne William   593662 593662 Brynne, William, of Croft, wright 1
5139760 2398107 2398107 plaintiff Sparke John   593662 593662 Sparke, John, of Croft 0
5143324 2399186 2399186 defendant Grynne William   593662 593662 Grynne, William, of Croft, wright 1
5160400 2404135 2404135 defendant Watson Walter husbandman 593662 593662 Watson, Walter, of Croft, husbandman 1
5160401 2404135 2404135 defendant Wyotson John husbandman 593662 593662 Wyotson, John, of Croft, husbandman 2
5177941 2409254 2409254 defendant Grynne William   593662 593662 Grynne, William, of Croft, wright 1
5196314 2414673 2414673 defendant Watson Walter husbandman 593662 593662 Watson, Walter, of Croft, husbandman 2
5196315 2414673 2414673 defendant Wyotson John husbandman 593662 593662 Wyotson, John, of Croft, husbandman 3
5201189 2416106 2416106 defendant Grynne William   593662 593662 Grynne, William, of Croft, wright 1
5209584 2418544 2418544 defendant Watson Walter husbandman 593662 593662 Watson, Walter, of Croft, husbandman 2
5209585 2418544 2418544 defendant Wyatson John husbandman 593662 593662 Wyatson, John, of Croft, husbandman 3
5234304 2425621 2425621 defendant Tent William husbandman 593662 593662 Tent, William, of Croft, husbandman 1
5254998 2431679 2431679 plaintiff Clarvaux Richard esq 593662 593662 Clarvaux, Richard, of Croft, esq 0
5255002 2431680 2431680 plaintiff Clarvaux Richard esq 593662 593662 Clarvaux, Richard, of Croft, esq 0
5255006 2431681 2431681 plaintiff Clarvaux Richard esq 593662 593662 Clarvaux, Richard, of Croft, esq 0
5255010 2431682 2431682 plaintiff Clarvaux Richard esq 593662 593662 Clarvaux, Richard, of Croft, esq 0
5293975 2443209 2443209 defendant Watyrlade Thomas husbandman 593662 593662 Watyrlade, Thomas, of Croft, husbandman 0
5300466 2445101 2445101 plaintiff Clarnaux Richard esq 593662 593662 Clarnaux, Richard, of Croft, esq 0
5349872 2460095 2460095 plaintiff Clarvaux Richard esq 593662 593662 Clarvaux, Richard, of Croft, esq 0
5469892 2495919 2495919 defendant Pere John husbandman 593662 593662 Pere, John, of Croft, husbandman 0
5492508 2502671 2502671 defendant Wyot John yeoman 593662 593662 Wyot, John, of Croft, yeoman 1
5563642 2523973 2523973 defendant Spence William clerk 593662 593662 Spence, William, of Croft, clerk 0
5612877 2547789 2547789 plaintiff Clervaux John   593662 593662 Clervaux, John, of Croft 0
5616787 2549053 2549053 defendant Clerevaux John   593662 593662 Clerevaux, John, of Croft 0
5629636 2553259 2553259 defendant Umframvile Gilbert   593662 593662 Umframvile, Gilbert, of Croft, knight 0
5629639 2553259 2553259 defendant Stretton John clerk 593662 593662 Stretton, John, of Croft, clerk 3
5629743 2553296 2553296 defendant Graneson or Graveson Agnes widow 593662 593662 Graneson or Graveson, Agnes, of Croft, widow 2
5635676 2555115 2555115 defendant Umframvile Gilbert   593662 593662 Umframvile, Gilbert, of Croft, knight 0
5635680 2555115 2555115 defendant Stretton John clerk 593662 593662 Stretton, John, of Croft, clerk 4

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