names

113 rows where place_id = 588868

✎ 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
3595842 1866337 1866337 defendant Craddok William yeoman 588868 588868 Craddok, William, of Kynges Norton, yeoman 0
3595844 1866338 1866338 defendant Craddok William yeoman 588868 588868 Craddok, William, of Kynges Norton, yeoman 0
3595846 1866339 1866339 defendant Craddok William yeoman 588868 588868 Craddok, William, of Kynges Norton, yeoman 0
3611729 1871330 1871330 defendant Bent Lawrence husbandman 588868 588868 Bent, Lawrence, of Kynges Norton, husbandman 0
3620381 1873959 1873959 defendant Blakton Thomas yeoman 588868 588868 Blakton, Thomas, of Kynges Norton, yeoman 0
3625455 1875499 1875499 defendant Fitter Richard   588868 588868 Fitter, Richard, of Kynges Norton, wheelwright 1
3635037 1905758 1905758 defendant Middelmore John gent 588868 588868 Middelmore, John, of Kynges Norton, gent 0
3650739 1910594 1910594 defendant Lynden John husbandman 588868 588868 Lynden, John, of Kynges Norton, husbandman 4
3650740 1910594 1910594 defendant Bedell William husbandman 588868 588868 Bedell, William, of Kynges Norton, husbandman 5
3662477 1914177 1914177 defendant Vytter Richard   588868 588868 Vytter, Richard, of Kynges Norton, Worcs yeoman 1
3663050 1914354 1914354 defendant Denton Ralph turner 588868 588868 Denton, Ralph, of Kynges Norton, turner 0
3664240 1914764 1914764 defendant Byssett Henry wheeler 588868 588868 Byssett, Henry, of Kynges Norton, wheeler 0
3672280 1917330 1917330 defendant Norton Thomas gent 588868 588868 Norton, Thomas, of Kynges Norton, gent 0
3681174 1920195 1920195 defendant Parsonage Henry husbandman 588868 588868 Parsonage, Henry, of Kynges Norton, husbandman 1
3682281 1920556 1920556 defendant Nayshe Roger yeoman 588868 588868 Nayshe, Roger, of Kynges Norton, yeoman 0
3704941 1927837 1927837 defendant Middelmore John gent 588868 588868 Middelmore, John, of Kynges Norton, gent 1
3753164 1942930 1942930 plaintiff Sergaunt Thomas mercer 588868 588868 Sergaunt, Thomas, of Kynges Norton, mercer 0
3828024 1966631 1966631 defendant Sergeant Robert yeoman 588868 588868 Sergeant, Robert, of Kynges Norton, yeoman 0
3837576 1969660 1969660 plaintiff Sparry William gent 588868 588868 Sparry, William, of Kynges Norton, gent 0
3845937 1972286 1972286 defendant Feld William   588868 588868 Feld, William, of Kynges Norton, wheel wright, son of Feld, John, of Hawkeslowe, Kynges Norton, wheel wright 0
3889152 1986608 1986608 plaintiff Fyld John mercer 588868 588868 Fyld, John, of Kynges Norton, mercer 0
3889154 1986608 1986608 defendant Chaunders Hugh husbandman 588868 588868 Chaunders, Hugh, of Kynges Norton, husbandman 0
3889155 1986609 1986609 plaintiff Fylde John mercer 588868 588868 Fylde, John, of Kynges Norton, mercer 0
3889157 1986609 1986609 defendant Chaunders Hugh husbandman 588868 588868 Chaunders, Hugh, of Kynges Norton, husbandman 0
3900802 1990499 1990499 plaintiff Chamber Richard   588868 588868 Chamber, Richard, of Kynges Norton, wheelwright 0
3906975 1992620 1992620 defendant Lyndon John yeoman 588868 588868 Lyndon, John, of Kynges Norton, yeoman 1
3906976 1992620 1992620 defendant Chaunders Hugh yeoman 588868 588868 Chaunders, Hugh, of Kynges Norton, yeoman 2
3916785 1995980 1995980 defendant Byssyll William wheeler 588868 588868 Byssyll, William, of Kynges Norton, wheeler 2
3916786 1995980 1995980 defendant Mylward Richard husbandman 588868 588868 Mylward, Richard, of Kynges Norton, husbandman 3
3946003 2005679 2005679 plaintiff Brydgende John   588868 588868 Brydgende, John, of Kynges Norton, "trougher" 0
3971389 2014551 2014551 defendant Walker William husbandman 588868 588868 Walker, William, of Kynges Norton, husbandman 1
3971390 2014551 2014551 defendant Mortybys Thomas husbandman 588868 588868 Mortybys, Thomas, of Kynges Norton, husbandman 2
4000641 2025003 2025003 defendant Martyn John laborer 588868 588868 Martyn, John, of Kynges Norton, laborer 0
4074601 2051218 2051218 plaintiff Raynold John   588868 588868 Raynold, John, of Kynges Norton 0
4121918 2068134 2068134 defendant Kylcop Thomas yeoman 588868 588868 Kylcop, Thomas, of Kynges Norton, yeoman 0
4141256 2075102 2075102 defendant Wharton Thomas tailor 588868 588868 Wharton, Thomas, of Kynges Norton, tailor 1
4141257 2075102 2075102 defendant Wharton Edmund tailor 588868 588868 Wharton, Edmund, of Kynges Norton, tailor 2
4181287 2088936 2088936 defendant Tuttyll Ambrose yeoman 588868 588868 Tuttyll, Ambrose, of Kynges Norton, yeoman 0
4423798 2172290 2172290 defendant Ruydynge Richard de la   588868 588868 Ruydynge, Richard de la, of Kynges Norton 1
4424315 2172447 2172447 defendant Othehull William   588868 588868 Othehull, William, of Kynges Norton 0
4451373 2185399 2185399 defendant Sparken John   588868 588868 Sparken, John, of Kynges Norton 2
4483487 2195521 2195521 defendant Hedley Thomas   588868 588868 Hedley, Thomas, of Kynges Norton 0
4483503 2195527 2195527 defendant Belne William   588868 588868 Belne, William, of Kynges Norton 0
4483508 2195529 2195529 defendant Belne William   588868 588868 Belne, William, of Kynges Norton 0
4486866 2196606 2196606 plaintiff Selley Robert   588868 588868 Selley, Robert, of Kynges Norton 0
4513805 2204742 2204742 defendant Sergeant (illegible)   588868 588868 Sergeant, _, of Kynges Norton 0
4546221 2214763 2214763 defendant Basse Thomas   588868 588868 Basse, Thomas, of Kynges Norton 0
4555063 2217512 2217512 plaintiff Haukeslowe Henry   588868 588868 Haukeslowe, Henry, of Kynges Norton 0
4555064 2217512 2217512 defendant Benton William   588868 588868 Benton, William, of Kynges Norton 0
4592500 2229007 2229007 plaintiff Norton Thomas   588868 588868 Norton, Thomas, of Kynges Norton 0
4606429 2233123 2233123 defendant Serieant William   588868 588868 Serieant, William, of Kynges Norton 4
4636153 2242139 2242139 defendant Roper William   588868 588868 Roper, William, of Kynges Norton 0
4764854 2284987 2284987 defendant Halle Richard yeoman 588868 588868 Halle, Richard, of Kynges Norton, yeoman 0
4764855 2284987 2284987 defendant Clerk John yeoman 588868 588868 Clerk, John, of Kynges Norton, yeoman 1
4768767 2286209 2286209 defendant Breche Richard   588868 588868 Breche, Richard, of Kynges Norton 0
4768768 2286209 2286209 defendant Middilton Richard   588868 588868 Middilton, Richard, of Kynges Norton, bow maker 1
4768769 2286209 2286209 defendant Middelton Baldwin husbandman 588868 588868 Middelton, Baldwin, of Kynges Norton, husbandman 2
4768770 2286209 2286209 defendant Blakdam William yeoman 588868 588868 Blakdam, William, of Kynges Norton, yeoman 3
4789283 2292710 2292710 defendant Halle Richard yeoman 588868 588868 Halle, Richard, of Kynges Norton, yeoman 0
4920964 2333070 2333070 plaintiff Ketell John   588868 588868 Ketell, John, of Kynges Norton 0
4920965 2333070 2333070 plaintiff Byshull Thomas   588868 588868 Byshull, Thomas, of Kynges Norton 1
4941393 2339330 2339330 defendant Radolf John yeoman 588868 588868 Radolf, John, of Kynges Norton, yeoman 2
4949011 2341678 2341678 defendant Middilton Alice widow 588868 588868 Middilton, Alice, of Kynges Norton, widow 0
4976166 2349827 2349827 defendant Barne William chapman 588868 588868 Barne, William, of Kynges Norton, chapman 0
4976171 2349828 2349828 defendant Barne William chapman 588868 588868 Barne, William, of Kynges Norton, chapman 0
5010010 2359795 2359795 defendant Marche Thomas yeoman 588868 588868 Marche, Thomas, of Kynges Norton, yeoman 5
5010011 2359795 2359795 defendant Ketille John yeoman 588868 588868 Ketille, John, of Kynges Norton, yeoman 6
5086494 2382439 2382439 defendant Baren or Berne William husbandman 588868 588868 Baren or Berne, William, of Kynges Norton, husbandman 0
5086495 2382439 2382439 defendant Kyngge James husbandman 588868 588868 Kyngge, James, of Kynges Norton, husbandman 1
5096879 2385517 2385517 defendant Hawekeslowe Agnes widow 588868 588868 Hawekeslowe, Agnes, of Kynges Norton, widow 1
5101355 2386808 2386808 defendant Kyllycoppe John husbandman 588868 588868 Kyllycoppe, John, of Kynges Norton, husbandman 0
5115149 2390852 2390852 defendant Sy John Brommesgrove, laborer 588868 588868 Sy John, of Kynges Norton, Brommesgrove, laborer 4
5136322 2397144 2397144 defendant Barowe John chaplain 588868 588868 Barowe, John, of Kynges Norton, chaplain 0
5139977 2398171 2398171 defendant Norton John yeoman 588868 588868 Norton, John, of Kynges Norton, yeoman 1
5139978 2398171 2398171 defendant Drage Thomas laborer 588868 588868 Drage, Thomas, of Kynges Norton, laborer 2
5142108 2398812 2398812 defendant Erlyche John gent 588868 588868 Erlyche, John, of Kynges Norton, gent 0
5142109 2398812 2398812 defendant Hawkeslowe Thomas gent 588868 588868 Hawkeslowe, Thomas, of Kynges Norton, gent 1
5160979 2404314 2404314 defendant Norton John yeoman 588868 588868 Norton, John, of Kynges Norton, yeoman 1
5160980 2404314 2404314 defendant Brage Thomas laborer 588868 588868 Brage, Thomas, of Kynges Norton, laborer 2
5160983 2404315 2404315 defendant Norton John yeoman 588868 588868 Norton, John, of Kynges Norton, yeoman 1
5160984 2404315 2404315 defendant Brage Thomas laborer 588868 588868 Brage, Thomas, of Kynges Norton, laborer 2
5175569 2408539 2408539 defendant Norton John yeoman 588868 588868 Norton, John, of Kynges Norton, yeoman 1
5175570 2408539 2408539 defendant Brage Thomas laborer 588868 588868 Brage, Thomas, of Kynges Norton, laborer 2
5260736 2433479 2433479 defendant Middelmore John gent 588868 588868 Middelmore, John, of Kynges Norton, gent 2
5388544 2471779 2471779 defendant Halle William, junior husbandman 588868 588868 Halle, William, junior, of Kynges Norton, husbandman 0
5389307 2471988 2471988 plaintiff Barker Thomas   588868 588868 Barker, Thomas, of Kynges Norton 1
5395602 2473822 2473822 defendant Avenaunte John   588868 588868 Avenaunte, John, of Kynges Norton, husbandman, son & heir of Robert Avenaunte, of Kyntes Norton 0
5434459 2485247 2485247 plaintiff Othe Felde Baldwin   588868 588868 Othe Felde, Baldwin, of Kynges Norton 0
5445487 2488547 2488547 plaintiff Felde Baldewin othe   588868 588868 Felde, Baldewin othe, of Kynges Norton 0
5462013 2493535 2493535 plaintiff Otheffelde Baldwin   588868 588868 Otheffelde, Baldwin, of Kynges Norton 0
5497933 2504326 2504326 defendant Kyng Thomas yeoman 588868 588868 Kyng, Thomas, of Kynges Norton, yeoman 0
5497935 2504327 2504327 defendant Kyng Thomas yeoman 588868 588868 Kyng, Thomas, of Kynges Norton, yeoman 0
5499901 2504924 2504924 defendant Bawedryk William yeoman 588868 588868 Bawedryk, William, of Kynges Norton, yeoman 0
5527381 2513144 2513144 plaintiff Lokok Richard yeoman 588868 588868 Lokok, Richard, of Kynges Norton, yeoman 0
5557121 2522039 2522039 defendant Felde Baldwin husbandman 588868 588868 Felde, Baldwin, of Kynges Norton, husbandman 0
5557472 2522136 2522136 defendant Feld Baldwin husbandman 588868 588868 Feld, Baldwin, of Kynges Norton, husbandman 0
5571567 2526240 2526240 defendant Gylbard Nicholas yeoman 588868 588868 Gylbard, Nicholas, of Kynges Norton, yeoman 1
5571898 2526323 2526323 defendant Lee Thomas yeoman 588868 588868 Lee, Thomas, of Kynges Norton, yeoman 1
5571899 2526323 2526323 defendant Hogge Richard yeoman 588868 588868 Hogge, Richard, of Kynges Norton, yeoman 2
5571900 2526323 2526323 defendant Colyns John husbandman 588868 588868 Colyns, John, of Kynges Norton, husbandman 3

Next page

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