names

63 rows where place_id = 600700

✎ 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
3642143 1907991 1907991 defendant Slotte John butcher 600700 600700 Slotte, John, of Hytchyn, butcher 0
3653704 1911421 1911421 defendant Myller Peter miller 600700 600700 Myller, Peter, of Hytchyn, miller 2
3670623 1916778 1916778 defendant Clerke William   600700 600700 Clerke, William, of Hytchyn, tallow chandler 0
3674996 1918210 1918210 defendant Mathewe Thomas mercer 600700 600700 Mathewe, Thomas, of Hytchyn, mercer 0
3674997 1918210 1918210 defendant Toly Thomas   600700 600700 Toly, Thomas, of Hytchyn, tile maker 1
3674998 1918210 1918210 defendant Bell Thomas carpenter 600700 600700 Bell, Thomas, of Hytchyn, carpenter 2
3674999 1918210 1918210 defendant Tyler John tiler 600700 600700 Tyler, John, of Hytchyn, tiler 3
3675000 1918210 1918210 defendant Dawes William dyer 600700 600700 Dawes, William, of Hytchyn, dyer 4
3675002 1918211 1918211 defendant Saunder Thomas laborer 600700 600700 Saunder, Thomas, of Hytchyn, laborer 0
3684395 1921250 1921250 defendant Toly Thomas tilemaker 600700 600700 Toly, Thomas, of Hytchyn, tilemaker 1
3684396 1921250 1921250 defendant Borage Thomas laborer 600700 600700 Borage, Thomas, of Hytchyn, laborer 2
3691406 1923470 1923470 defendant Fage William maltman 600700 600700 Fage, William, of Hytchyn, maltman 2
3804673 1959401 1959401 defendant Okeley John   600700 600700 Okeley, John, of Hytchyn, collar maker or smith 0
3819768 1964063 1964063 defendant Clerke William   600700 600700 Clerke, William, of Hytchyn, tallow chandler 0
3819769 1964063 1964063 defendant Perlys William butcher 600700 600700 Perlys, William, of Hytchyn, butcher 1
3826882 1966258 1966258 defendant Barfote Thomas maltman 600700 600700 Barfote, Thomas, of Hytchyn, maltman 0
3834430 1968716 1968716 defendant Jenynes Peter smith 600700 600700 Jenynes, Peter, of Hytchyn, smith 0
3847854 1972904 1972904 defendant Marshall Robert yeoman 600700 600700 Marshall, Robert, of Hytchyn, yeoman 1
3859000 1976503 1976503 defendant Tyler John glover 600700 600700 Tyler, John, of Hytchyn, glover 3
3863116 1977864 1977864 defendant Marshall Robert yeoman 600700 600700 Marshall, Robert, of Hytchyn, yeoman 1
3864099 1978176 1978176 defendant Smyth William butcher 600700 600700 Smyth, William, of Hytchyn, butcher 0
3877576 1982740 1982740 defendant Smyth William butcher 600700 600700 Smyth, William, of Hytchyn, butcher 0
3891417 1987396 1987396 defendant Gatys Thomas chapman 600700 600700 Gatys, Thomas, of Hytchyn, chapman 0
3899993 1990217 1990217 defendant Yattys Thomas haberdasher 600700 600700 Yattys, Thomas, of Hytchyn, haberdasher 0
3921141 1997423 1997423 defendant Love John, senior   600700 600700 Love, John, senior, of Hytchyn, wheelwright 0
3921142 1997423 1997423 defendant Love John, junior butcher 600700 600700 Love, John, junior, of Hytchyn, butcher 1
3932524 2001168 2001168 defendant Moysyer John turner 600700 600700 Moysyer, John, of Hytchyn, turner 0
4027920 2034636 2034636 plaintiff Coker Thomas yeoman 600700 600700 (Coker, Thomas, of Hytchyn, yeoman 1
4027921 2034636 2034636 plaintiff Coker William yeoman 600700 600700 Coker, William, of Hytchyn, yeoman 2
4028452 2034827 2034827 defendant Audeley Ralph (legal representative) 600700 600700 Audeley, Ralph, of Hytchyn, shoemaker, executors of 0
4028453 2034827 2034827 defendant Hewes George shoemaker 600700 600700 (Hewes, George, of Hytchyn, shoemaker 1
4081843 2053809 2053809 defendant Moncke Ralph draper 600700 600700 Moncke, Ralph, of Hytchyn, draper 0
4094563 2058391 2058391 defendant Perles John butcher 600700 600700 Perles, John, of Hytchyn, butcher 2
4123898 2068847 2068847 defendant Coker Thomas yeoman 600700 600700 Coker, Thomas, of Hytchyn, yeoman 0
4175747 2086990 2086990 defendant Pasfylde Walter roper 600700 600700 Pasfylde, Walter, of Hytchyn, innholder, roper 0
4201110 2095938 2095938 defendant Hurst Edward yeoman 600700 600700 Hurst, Edward, of Hytchyn, yeoman 1
4221177 2102906 2102906 defendant Hitchynson John yeoman 600700 600700 Hitchynson, John, of Hytchyn, yeoman 0
4228733 2105535 2105535 defendant Wiseman Thomas gent 600700 600700 Wiseman, Thomas, of Hytchyn, or of Revenell, gent 0
4274867 2121157 2121157 defendant Dey John laborer 600700 600700 Dey, John, of Hytchyn, laborer 0
4279263 2122677 2122677 defendant Cooper John brewer 600700 600700 Cooper, John, of Hytchyn, brewer 0
4279515 2122753 2122753 defendant Draper Richard yeoman 600700 600700 Draper, Richard, of Hytchyn, yeoman 3
4400930 2164901 2164901 defendant Graveley William yeoman 600700 600700 Graveley, William, of Hytchyn, yeoman 3
4409658 2167830 2167830 defendant Moncke Ralph tailor 600700 600700 Moncke, Ralph, of Hytchyn, tailor 0
4409659 2167830 2167830 defendant Barfoote John yeoman 600700 600700 Barfoote, John, of Hytchyn, yeoman 1
4412279 2168695 2168695 defendant Hurste Daniel yeoman 600700 600700 Hurste, Daniel, of Hytchyn, yeoman 3
4412562 2168791 2168791 defendant Cowper John, junior yeoman 600700 600700 Cowper, John, junior, of Hytchyn, yeoman 0
4412563 2168791 2168791 defendant Draper Thomas yeoman 600700 600700 Draper, Thomas, of Hytchyn, yeoman 1
4412565 2168791 2168791 defendant Underwood William yeoman 600700 600700 Underwood, William, of Hytchyn, yeoman 3
4456234 2186970 2186970 defendant atte Broke Robert   600700 600700 atte Broke, Robert, of Hytchyn 1
4919190 2332513 2332513 defendant Bestney Richard husbandman 600700 600700 Bestney, Richard, of Hytchyn, husbandman 0
5044021 2369840 2369840 defendant Bestny William husbandman 600700 600700 Bestny, William, of Hytchyn, husbandman 0
5135874 2397007 2397007 defendant Cock or Cook John laborer 600700 600700 Cock or Cook, John, of Hytchyn, laborer 0
5400228 2475140 2475140 defendant Tayllour William yeoman 600700 600700 Tayllour, William, of Hytchyn, yeoman 0
5406584 2476950 2476950 defendant Fellys William yeoman 600700 600700 Fellys, William, of Hytchyn, yeoman 0
5406585 2476950 2476950 defendant Tayllour William tailor 600700 600700 Tayllour, William, of Hytchyn, tailor 1
5429543 2483773 2483773 defendant Lawe William   600700 600700 Lawe, William, of Hytchyn, tile maker 1
5429545 2483773 2483773 defendant Dykerleder Henry shoemaker 600700 600700 Dykerleder, Henry, of Hytchyn, shoemaker 3
5545133 2518581 2518581 defendant Clayton Richard laborer 600700 600700 Clayton, Richard, of Hytchyn, laborer 0
5545139 2518582 2518582 defendant Clayton Richard laborer 600700 600700 Clayton, Richard, of Hytchyn, laborer 0
5545155 2518585 2518585 defendant Manyng John yeoman 600700 600700 Manyng, John, of Hytchyn, yeoman 3
5596000 2533660 2533660 defendant Slote John butcher 600700 600700 Slote, John, of Hytchyn, butcher 0
5596001 2533660 2533660 defendant Hurst Christopher tiler 600700 600700 Hurst, Christopher, of Hytchyn, tiler 1
5596002 2533660 2533660 defendant Perlys Henry butcher 600700 600700 Perlys, Henry, of Hytchyn, butcher 2

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