names

53 rows where place_id = 593588

✎ 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
3612472 1871533 1871533 defendant Catelyn Robert yeoman 593588 593588 Catelyn, Robert, of Haynton, yeoman 0
3735610 1937371 1937371 plaintiff Hennege John   593588 593588 Hennege, John, of Haynton 0
3749131 1941659 1941659 plaintiff Hennege John esq 593588 593588 Hennege, John, of Haynton, esq 0
3777997 1950828 1950828 defendant Bowgham Margaret widow 593588 593588 Bowgham, Margaret, of Haynton, widow 1
3846381 1972421 1972421 defendant Milford Thomas gent 593588 593588 Milford, Thomas, of Haynton, gent 1
3919925 1996999 1996999 defendant Gybson John clerk 593588 593588 Gybson, John, of Haynton, clerk 0
3932355 2001120 2001120 defendant Walles Robert husbandman 593588 593588 Walles, Robert, of Haynton, husbandman 12
4198256 2094936 2094936 defendant Dakyns George gent 593588 593588 Dakyns, George, of Haynton, gent 4
4351728 2147847 2147847 defendant Burton Edward gent 593588 593588 Burton, Edward, of Haynton, gent 0
4462148 2188858 2188858 defendant Wryght Walter   593588 593588 Wryght, Walter, of Haynton 0
4503034 2201517 2201517 plaintiff Odenell John   593588 593588 Odenell, John, of Haynton 0
4507411 2202783 2202783 plaintiff Webster Nicholas   593588 593588 Webster, Nicholas, of Haynton 0
4508742 2203209 2203209 plaintiff Anot Alice   593588 593588 Anot, Alice, of Haynton, formerly wife of Nicholas 0
4511843 2204153 2204153 defendant Burre Robert   593588 593588 Burre, Robert, of Haynton 1
4527372 2208841 2208841 defendant Dirby Walter   593588 593588 Dirby, Walter, of Haynton 0
4527374 2208841 2208841 defendant Byddes John   593588 593588 Byddes, John, of Haynton 2
4529892 2209637 2209637 defendant Byddes John   593588 593588 Byddes, John, of Haynton 1
4541499 2213237 2213237 plaintiff Wright John   593588 593588 Wright, John, of Haynton 0
4551022 2216260 2216260 plaintiff Donce John   593588 593588 Donce, John, of Haynton 0
4558176 2218499 2218499 defendant Anot Alice   593588 593588 Anot, Alice, of Haynton, formerly wife of Nicholas 0
4596773 2230232 2230232 defendant Smart John   593588 593588 Smart, John, of Haynton 0
4596774 2230232 2230232 defendant Wright John   593588 593588 Wright, John, of Haynton 1
4621180 2237614 2237614 defendant Appulgarth Henry de   593588 593588 Appulgarth, Henry de, of Haynton, vicar 1
4708810 2268126 2268126 defendant Barkeworth Robert husbandman 593588 593588 Barkeworth, Robert, of Haynton, husbandman 0
4735204 2276157 2276157 defendant Blaunche John husbandman 593588 593588 Blaunche, John, of Haynton, husbandman 0
4776038 2288505 2288505 plaintiff Henege John   593588 593588 Henege, John, of Haynton 2
4803255 2297211 2297211 defendant Wryght John husbandman 593588 593588 Wryght, John, of Haynton, husbandman 0
4809422 2299123 2299123 plaintiff Draper Nicholas   593588 593588 Draper, Nicholas, of Haynton 0
4839856 2308377 2308377 plaintiff Henage John   593588 593588 Henage, John, of Haynton 0
4850035 2311476 2311476 defendant Smyth John   593588 593588 Smyth, John, of Haynton, bailiff 3
4857541 2313746 2313746 defendant Percy Richard   593588 593588 Percy, Richard, of Haynton, cartwright 0
4867092 2316671 2316671 plaintiff Henage John   593588 593588 Henage, John, of Haynton 0
4869231 2317344 2317344 defendant Smyth John yeoman 593588 593588 Smyth, John, of Haynton, yeoman 9
4887773 2323008 2323008 defendant Draper Nicholas merchant 593588 593588 Draper, Nicholas, of Haynton, merchant 1
4971990 2348563 2348563 plaintiff Henege John   593588 593588 Henege, John, of Haynton 1
4971994 2348564 2348564 plaintiff Henege John   593588 593588 Henege, John, of Haynton 1
5026753 2364695 2364695 defendant Lockowe William tailor 593588 593588 Lockowe, William, of Haynton, tailor 0
5035037 2367109 2367109 defendant Hoggeson John   593588 593588 Hoggeson, John, of Haynton, wright 0
5059111 2374292 2374292 plaintiff Draper Nicholas (legal representative) 593588 593588 Draper, Nicholas, of Haynton, executors of 0
5206416 2417609 2417609 defendant Butteller John husbandman 593588 593588 (Butteller, John, of Haynton, husbandman 6
5206417 2417609 2417609 defendant Done Nicholas husbandman 593588 593588 Done, Nicholas, of Haynton, husbandman 7
5220813 2421779 2421779 defendant Draper Nicholas   593588 593588 Draper, Nicholas, of Haynton, gent, son of Richard 1
5233295 2425325 2425325 defendant Draper Nicholas gent 593588 593588 Draper, Nicholas, of Haynton, gent 1
5240501 2427436 2427436 defendant Draper Nicholas gent 593588 593588 Draper, Nicholas, of Haynton, gent 1
5251869 2430693 2430693 defendant Draper Nicholas merchant of the staple 593588 593588 Draper, Nicholas, of Haynton, gent, merchant of the staple 0
5258390 2432738 2432738 defendant Henege John gent 593588 593588 Henege, John, of Haynton, gent 0
5309834 2447980 2447980 defendant Draper Nicholas gent 593588 593588 Draper, Nicholas, of Haynton, gent 0
5309835 2447980 2447980 defendant Dawson John husbandman 593588 593588 Dawson, John, of Haynton, husbandman 1
5360644 2463359 2463359 defendant Smyth Robert husbandman 593588 593588 Smyth, Robert, of haynton, husbandman 4
5461351 2493344 2493344 defendant Hoggeson Robert husbandman 593588 593588 Hoggeson, Robert, of Haynton, husbandman 1
5472996 2496879 2496879 defendant Hoggeson Robert husbandman 593588 593588 Hoggeson, Robert, of Haynton, husbandman 1
5584769 2530310 2530310 defendant Henege William gent 593588 593588 Henege, William, of Haynton, gent 0
5584771 2530311 2530311 defendant Henge William gent 593588 593588 Henge, William, of Haynton, gent 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);