names

99 rows where place_id = 600094

✎ 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
3639661 1907214 1907214 defendant Baldwenson John yeoman 600094 600094 Baldwenson, John, of Halifax, yeoman 2
3646726 1909377 1909377 defendant Burneley William dyer 600094 600094 Burneley, William, of Halifax, dyer 0
3656231 1912197 1912197 defendant Wattys William clothier 600094 600094 Wattys, William, of Halifax, clothier 3
3678289 1919266 1919266 plaintiff Michell William, senior   600094 600094 Michell, William, senior, of Halifax 0
3695517 1924821 1924821 defendant Fairbank Robert dyer 600094 600094 Fairbank, Robert, of Halifax, dyer 0
3695519 1924822 1924822 defendant Waker Nicholas dyer 600094 600094 Waker, Nicholas, of Halifax, dyer 0
3695520 1924822 1924822 defendant Burnley William dyer 600094 600094 Burnley, William, of Halifax, dyer 1
3699296 1925995 1925995 defendant Sunderland Richard clothier 600094 600094 Sunderland, Richard, of Halifax, clothier 0
3724438 1933928 1933928 defendant Smyth John yeoman 600094 600094 Smyth, John, of Halifax, yeoman 4
3783347 1952543 1952543 defendant Hebilthwait Thomas yeoman 600094 600094 Hebilthwait, Thomas, of Halifax, yeoman 1
3815934 1962888 1962888 defendant Ferrour Richard yeoman 600094 600094 Ferrour, Richard, of Halifax, yeoman 1
3817302 1963323 1963323 defendant Otys John yeoman 600094 600094 Otys, John, of Halifax, yeoman 0
3931603 2000866 2000866 plaintiff Drake William clothier 600094 600094 Drake, William, of Halifax, clothier 0
3933707 2001566 2001566 plaintiff Haldesworth Robert Master & Doctor 600094 600094 Haldesworth, Robert, of Halifax, clerk, vicar, Master & Doctor 0
3978281 2016985 2016985 defendant Otes Michael   600094 600094 Otes, Michael, of Halifax, linen draper 0
3992033 2021916 2021916 plaintiff Bryge Richard clothier 600094 600094 Bryge, Richard, of Halifax, clothier 0
4041220 2039350 2039350 plaintiff Mylner Edward clothier 600094 600094 Mylner, Edward, of Halifax, clothier 0
4041221 2039350 2039350 defendant Lyster John chapman 600094 600094 Lyster, John, of Halifax, chapman 0
4092016 2057438 2057438 defendant Hrenefeld John clothier 600094 600094 Hrenefeld, John, of Halifax, clothier 0
4121118 2067844 2067844 defendant Knowles Edward currier 600094 600094 Knowles, Edward, of Halifax, currier 0
4121840 2068109 2068109 defendant Lyster Thomas clothier 600094 600094 Lyster, Thomas, of Halifax, clothier 2
4133398 2072269 2072269 defendant Hill Charles dyer 600094 600094 Hill, Charles, of Halifax, dyer 0
4144964 2076398 2076398 defendant Lister Thomas clothier 600094 600094 Lister, Thomas, of Halifax, clothier 2
4322432 2137914 2137914 defendant Cosine George laborer 600094 600094 Cosine, George, of Halifax, laborer 1
4322434 2137914 2137914 defendant Mitchell Henry yeoman 600094 600094 Mitchell, Henry, of Halifax, yeoman 3
4323097 2138139 2138139 defendant Wood Edward clothier 600094 600094 Wood, Edward, of Halifax, clothier 0
4478493 2193945 2193945 defendant Halifax William baker 600094 600094 Halifax, William, of Halifax, baker 0
4486923 2196626 2196626 defendant Halifax William   600094 600094 Halifax, William, of Halifax, bow maker 0
4534549 2211078 2211078 plaintiff Kyng John   600094 600094 (Kyng, John, of Halifax, vicar 1
4534557 2211079 2211079 plaintiff Kyng John   600094 600094 (Kyng, John, of Halifax, vicar 1
4703688 2266534 2266534 defendant Stisse Robert chapman 600094 600094 Stisse, Robert, of Halifax, chapman 1
4709294 2268277 2268277 defendant Langbothonne Richard chapman 600094 600094 Langbothonne, Richard, of Halifax, chapman 1
4710197 2268539 2268539 defendant del Hole Henry husbandman 600094 600094 del Hole, Henry, of Halifax, husbandman 0
4719833 2271548 2271548 defendant Walker Richard draper 600094 600094 Walker, Richard, of Halifax, draper 2
4730748 2274817 2274817 defendant Sounderlond Richard yeoman 600094 600094 Sounderlond, Richard, of Halifax, yeoman 4
4736609 2276580 2276580 plaintiff Kyng John   600094 600094 Kyng, John, of Halifax, vicar 1
4755931 2282238 2282238 defendant Milner Robert yeoman 600094 600094 Milner, Robert, of Halifax, yeoman 0
4755932 2282238 2282238 defendant Sta_f John yeoman 600094 600094 Sta_f, John, of Halifax, yeoman 1
4755933 2282238 2282238 defendant Beverley John yeoman 600094 600094 Beverley, John, of Halifax, yeoman 2
4755934 2282238 2282238 defendant Milner Henry yeoman 600094 600094 Milner, Henry, of Halifax, yeoman 3
4759412 2283285 2283285 defendant Litster William yeoman 600094 600094 together with Litster, William, of Halifax, yeoman 5
4759413 2283285 2283285 defendant Crodhare Nicholas husbandman 600094 600094 Crodhare, Nicholas, of Halifax, husbandman 6
4766678 2285569 2285569 defendant del Hole John husbandman 600094 600094 del Hole, John, of Halifax, husbandman 0
4766679 2285569 2285569 defendant Ridyng William de yeoman 600094 600094 Ridyng, William de, of Halifax, yeoman 1
4766680 2285569 2285569 defendant Burgh John de husbandman 600094 600094 Burgh, John de, of Halifax, husbandman 2
4836271 2307322 2307322 defendant Mawde Richard husbandman 600094 600094 Mawde, Richard, of Halifax, husbandman 2
4836272 2307322 2307322 defendant Fryth William yeoman 600094 600094 Fryth, William, of Halifax, yeoman 3
4845619 2310140 2310140 plaintiff Pecke Richard   600094 600094 Pecke, Richard, of Halifax 0
4856140 2313291 2313291 defendant Beverley John husbandman 600094 600094 Beverley, John, of Halifax, husbandman 2
4856141 2313291 2313291 defendant Beverley Adam husbandman 600094 600094 Beverley, Adam, of Halifax, husbandman 3
4872478 2318351 2318351 defendant Rissheworth John gent 600094 600094 Rissheworth, John, of Halifax, gent 1
4873207 2318572 2318572 plaintiff Pecke Richard   600094 600094 Pecke, Richard, of Halifax 0
4982113 2351566 2351566 defendant Frith Richard draper 600094 600094 Frith, Richard, of Halifax, draper 3
5004322 2358157 2358157 defendant Otes John mercer 600094 600094 Otes, John, of Halifax, mercer 0
5031197 2366003 2366003 defendant Fournesse Ralph yeoman 600094 600094 Fournesse, Ralph, of Halifax, yeoman 1
5031216 2366003 2366003 defendant Fournesse John yeoman 600094 600094 Fournesse, John, of Halifax, yeoman 20
5034152 2366854 2366854 defendant Brodle John yeoman 600094 600094 Brodle, John, of Halifax, yeoman 3
5148562 2400706 2400706 defendant Etlesley Robert yeoman 600094 600094 Etlesley, Robert, of Halifax, yeoman 0
5167811 2406300 2406300 defendant Eltesley Robert yeoman 600094 600094 Eltesley, Robert, of Halifax, yeoman 0
5183423 2410893 2410893 defendant Etlesley Robert yeoman 600094 600094 Etlesley, Robert, of Halifax, yeoman 0
5275120 2437800 2437800 defendant Holgate (illegible) yeoman 600094 600094 Holgate, ----, of Halifax, yeoman 2
5303106 2445919 2445919 plaintiff Gibson Richard   600094 600094 Gibson, Richard, of Halifax 0
5303542 2446055 2446055 plaintiff Gybson Richard   600094 600094 Gybson, Richard, of Halifax 0
5305297 2446589 2446589 defendant Holgate William draper 600094 600094 Holgate, William, of Halifax, draper 0
5305300 2446590 2446590 defendant Holgate William draper 600094 600094 Holgate, William, of Halifax, draper 0
5316289 2449958 2449958 defendant Curson John chapman 600094 600094 Curson, John, of Halifax, chapman 0
5340150 2457128 2457128 plaintiff Newall Richard, senior   600094 600094 Newall, Richard, senior, of Halifax 0
5340156 2457129 2457129 plaintiff Newall Richard, senior   600094 600094 Newall, Richard, senior, of Halifax 0
5360128 2463208 2463208 defendant Barestawe Robert yeoman 600094 600094 Barestawe, Robert, of Halifax, yeoman 1
5363071 2464100 2464100 defendant Thorp Richard chapman 600094 600094 Thorp, Richard, of Halifax, chapman 2
5373611 2467344 2467344 defendant Bates Robert tailor 600094 600094 Bates, Robert, of Halifax, tailor 1
5373612 2467344 2467344 defendant Bates Thomas (legal representative) 600094 600094 Bates, Thomas, of Halifax, tailor, executor of 2
5373613 2467344 2467344 defendant Bates Robert yeoman 600094 600094 Bates, Robert, of Halifax, yeoman 3
5379213 2469093 2469093 plaintiff Wilkynson Thomas (legal representative) 600094 600094 Wilkynson, Thomas, of Halifax, vicar, executor of 0
5379215 2469093 2469093 defendant Milnere Thomas yeoman 600094 600094 Milnere, Thomas, of Halifax, yeoman 0
5390374 2472310 2472310 defendant More Richard husbandman 600094 600094 More, Richard, of Halifax, husbandman 0
5390375 2472310 2472310 defendant Bates Robert tailor 600094 600094 Bates, Robert, of Halifax, tailor 1
5390376 2472310 2472310 defendant Bates Thomas (legal representative) 600094 600094 Bates, Thomas, of Halifax, tailor, executor of 2
5394577 2473511 2473511 defendant Brodle William, junior yeoman 600094 600094 Brodle, William, junior, of Halifax, yeoman 0
5394583 2473512 2473512 plaintiff Wilkynson Thomas (legal representative) 600094 600094 Wilkynson, Thomas, of Halifax, vicar, executors of 0
5394585 2473512 2473512 defendant Milner Thaoms yeoman 600094 600094 Milner, Thaoms, of Halifax, yeoman 0
5395638 2473834 2473834 defendant Longbothum Richard gent 600094 600094 Longbothum, Richard, of Halifax, gent 0
5395828 2473891 2473891 defendant Otes William yeoman 600094 600094 Otes, William, of Halifax, yeoman 0
5399128 2474819 2474819 defendant Otes William yeoman 600094 600094 (Otes, William, of Halifax, yeoman 5
5403442 2476058 2476058 defendant Dughty John yeoman 600094 600094 Dughty, John, of Halifax, yeoman 0
5403450 2476059 2476059 defendant Bacheler Henry dyer 600094 600094 Bacheler, Henry, of Halifax, dyer 3
5409106 2477691 2477691 defendant Otes William yeoman 600094 600094 together with Otes, William, of Halifax, yeoman 2
5409108 2477692 2477692 defendant Otes William yeoman 600094 600094 Otes, William, of Halifax, yeoman 0
5416448 2479840 2479840 defendant More Richard husbandman 600094 600094 More, Richard, of Halifax, husbandman 0
5416449 2479840 2479840 defendant Bates Robert tailor 600094 600094 Bates, Robert, of Halifax, tailor 1
5416451 2479840 2479840 defendant Bates Robert yeoman 600094 600094 Bates, Robert, of Halifax, yeoman 3
5416521 2479858 2479858 defendant Bacheler Henry dyer 600094 600094 Bacheler, Henry, of Halifax, dyer 3
5416577 2479872 2479872 defendant Otes William yeoman 600094 600094 together with Otes, William, of Halifax, yeoman 6
5433399 2484948 2484948 defendant Dughty John yeoman 600094 600094 Dughty, John, of Halifax, yeoman 0
5433404 2484949 2484949 defendant Dughty John yeoman 600094 600094 Dughty, John, of Halifax, yeoman 0
5433411 2484950 2484950 defendant Bachiler Henry dyer 600094 600094 Bachiler, Henry, of Halifax, dyer 2
5489167 2501644 2501644 defendant Holgate John chapman 600094 600094 Holgate, John, of Halifax, chapman 1
5549634 2519940 2519940 defendant Brodley John yeoman 600094 600094 Brodley, John, of Halifax, yeoman 0
5549849 2519988 2519988 defendant Brodle John yeoman 600094 600094 Brodle, John, of Halifax, yeoman 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);