names

90 rows where place_id = 600786

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3642544 1908110 1908110 defendant Fyscher Thomas husbandman 600786 600786 Fyscher, Thomas, of Heton, husbandman 0
3660734 1913622 1913622 defendant Shitfeld John husbandman 600786 600786 Shitfeld, John, of Heton, husbandman 0
3660735 1913622 1913622 defendant Ferrand Miles husbandman 600786 600786 Ferrand, Miles, of Heton, husbandman 1
3660736 1913622 1913622 defendant Smyth Ralph husbandman 600786 600786 Smyth, Ralph, of Heton, husbandman 2
3660737 1913622 1913622 defendant Blakbourn Robert husbandman 600786 600786 Blakbourn, Robert, of Heton, husbandman 3
3660738 1913622 1913622 defendant Gregson John husbandman 600786 600786 Gregson, John, of Heton, husbandman 4
3660739 1913622 1913622 defendant Settell John, senior husbandman 600786 600786 Settell, John, senior, of Heton, husbandman 5
3660740 1913622 1913622 defendant Settell Richard husbandman 600786 600786 Settell, Richard, of Heton, husbandman 6
3660741 1913622 1913622 defendant Frankland Roger husbandman 600786 600786 Frankland, Roger, of Heton, husbandman 7
3660742 1913622 1913622 defendant Carlell John husbandman 600786 600786 Carlell, John, of Heton, husbandman 8
3660743 1913622 1913622 defendant Lawson Reginald husbandman 600786 600786 Lawson, Reginald, of Heton, husbandman 9
3660744 1913622 1913622 defendant Horton Henry husbandman 600786 600786 Horton, Henry, of Heton, husbandman 10
3660745 1913622 1913622 defendant Hargrave John husbandman 600786 600786 Hargrave, John, of Heton, husbandman 11
3660746 1913622 1913622 defendant Kyghley John husbandman 600786 600786 Kyghley, John, of Heton, husbandman 12
3680317 1919920 1919920 defendant Marchande John laborer 600786 600786 Marchande, John, of Heton, laborer 2
3680318 1919920 1919920 defendant Hepworth Edmund clothier 600786 600786 Hepworth, Edmund, of Heton, clothier 3
3686869 1922056 1922056 defendant Hopton John gent 600786 600786 Hopton, John, of Heton, gent 0
3686870 1922056 1922056 defendant Skargill William gent 600786 600786 Skargill, William, of Heton, gent 1
3686871 1922056 1922056 defendant North William laborer 600786 600786 North, William, of Heton, laborer 2
3686873 1922057 1922057 defendant Hopton John gent 600786 600786 Hopton, John, of Heton, gent 0
3686874 1922057 1922057 defendant Skargill William gent 600786 600786 Skargill, William, of Heton, gent 1
3686875 1922057 1922057 defendant North William laborer 600786 600786 North, William, of Heton, laborer 2
3691025 1923357 1923357 defendant Broke Edmund husbandman 600786 600786 Broke, Edmund, of Heton, husbandman 2
3691891 1923625 1923625 defendant Hopton John gent 600786 600786 Hopton, John, of Heton, gent 0
3691892 1923625 1923625 defendant Skargill William gent 600786 600786 Skargill, William, of Heton, gent 1
3691894 1923626 1923626 defendant Hopton John gent 600786 600786 Hopton, John, of Heton, gent 0
3691895 1923626 1923626 defendant Skargill William gent 600786 600786 Skargill, William, of Heton, gent 1
3826648 1966180 1966180 defendant Sharpe Robert smith 600786 600786 Sharpe, Robert, of Heton, smith 1
3826649 1966180 1966180 defendant Nayler Thomas smith 600786 600786 Nayler, Thomas, of Heton, smith 2
3826650 1966180 1966180 defendant Willie Richard smith 600786 600786 Willie, Richard, of Heton, smith 3
3826651 1966180 1966180 defendant Sampson Richard smith 600786 600786 Sampson, Richard, of Heton, smith 4
3879667 1983455 1983455 defendant Darcy Thomas yeoman 600786 600786 Darcy, Thomas, of Heton, yeoman 2
4474144 2192566 2192566 defendant Dike Thomas   600786 600786 Dike, Thomas, of Heton 3
4518342 2206111 2206111 defendant Marchant Richard, sen   600786 600786 Marchant, Richard, sen, of Heton 0
4518343 2206111 2206111 defendant Marchant Thomas   600786 600786 Marchant, Thomas, of Heton 1
4539500 2212613 2212613 defendant Wayte John   600786 600786 Wayte, John, of Heton 0
4584830 2226683 2226683 defendant Gray Thomas   600786 600786 Gray, Thomas, of Heton, knight 0
4614501 2235543 2235543 defendant Gray Thomas   600786 600786 Gray, Thomas, of Heton, knight, lord of Werk 0
4646886 2245151 2245151 defendant Litster John   600786 600786 Litster, John, of Heton 0
4681040 2259695 2259695 defendant Borell John gent 600786 600786 Borell, John, of Heton, gent 2
4712761 2269305 2269305 defendant Dundre John husbandman 600786 600786 Dundre, John, of Heton, husbandman 0
4718938 2271266 2271266 defendant Borell John esq 600786 600786 Borell, John, of Heton, esq 0
4808748 2298903 2298903 defendant Brygge John yeoman 600786 600786 Brygge, John, of Heton, yeoman 0
4849603 2311351 2311351 defendant Greneham Thomas esq 600786 600786 Greneham, Thomas, of Heton, esq 0
4854536 2312805 2312805 defendant Leventhorp Thomas yeoman 600786 600786 Leventhorp, Thomas, of Heton, yeoman 0
4854537 2312805 2312805 defendant B_ Thomas husbandman 600786 600786 B_, Thomas, of Heton, husbandman 1
4859164 2314241 2314241 defendant Hynde Robert husbandman 600786 600786 Hynde, Robert, of Heton, husbandman 0
4877122 2319810 2319810 defendant Bates Thomas husbandman 600786 600786 Bates, Thomas, of Heton, husbandman 0
4877129 2319811 2319811 defendant Cappe William husbandman 600786 600786 Cappe, William, of Heton, husbandman 3
4877189 2319825 2319825 defendant Leventhorp Thomas yeoman 600786 600786 Leventhorp, Thomas, of Heton, yeoman 0
5020851 2362995 2362995 defendant Robynson John husbandman 600786 600786 Robynson, John, of Heton, husbandman 2
5053811 2372741 2372741 defendant Thomlynson Thomas husbandman 600786 600786 Thomlynson, Thomas, of Heton, husbandman 0
5053812 2372741 2372741 defendant Thomlynson John husbandman 600786 600786 Thomlynson, John, of Heton, husbandman 1
5053813 2372741 2372741 defendant Robynson John husbandman 600786 600786 Robynson, John, of Heton, husbandman 2
5053814 2372741 2372741 defendant Boyes John husbandman 600786 600786 Boyes, John, of Heton, husbandman 3
5053815 2372741 2372741 defendant Templeman Robert husbandman 600786 600786 Templeman, Robert, of Heton, husbandman 4
5053816 2372741 2372741 defendant Clotherom William husbandman 600786 600786 Clotherom, William, of Heton, husbandman 5
5053817 2372741 2372741 defendant Malmagh Robert husbandman 600786 600786 Malmagh, Robert, of Heton, husbandman 6
5053818 2372741 2372741 defendant Hudson John husbandman 600786 600786 Hudson, John, of Heton, husbandman 7
5053819 2372741 2372741 defendant Templeman Robert, junior husbandman 600786 600786 Templeman, Robert, junior, of Heton, husbandman 8
5053820 2372741 2372741 defendant Templeman William, senior husbandman 600786 600786 Templeman, William, senior, of Heton, husbandman 9
5060772 2374802 2374802 defendant Hatter John husbandman 600786 600786 Hatter, John, of Heton, husbandman 3
5064777 2376006 2376006 defendant Thomlynson Thomas husbandman 600786 600786 Thomlynson, Thomas, of Heton, husbandman 0
5064778 2376006 2376006 defendant Thomlynson John husbandman 600786 600786 Thomlynson, John, of Heton, husbandman 1
5064779 2376006 2376006 defendant Robynson John husbandman 600786 600786 Robynson, John, of Heton, husbandman 2
5064780 2376006 2376006 defendant Boyes John husbandman 600786 600786 Boyes, John, of Heton, husbandman 3
5064781 2376006 2376006 defendant Templeman Robert, senior husbandman 600786 600786 Templeman, Robert, senior, of Heton, husbandman 4
5064782 2376006 2376006 defendant Clotherom William husbandman 600786 600786 Clotherom, William, of Heton, husbandman 5
5064783 2376006 2376006 defendant Malmagh Robert husbandman 600786 600786 Malmagh, Robert, of Heton, husbandman 6
5064784 2376006 2376006 defendant Hudson John husbandman 600786 600786 Hudson, John, of Heton, husbandman 7
5064785 2376006 2376006 defendant Templeman Robert, junior husbandman 600786 600786 Templeman, Robert, junior, of Heton, husbandman 8
5064786 2376006 2376006 defendant Templeman William, senior husbandman 600786 600786 Templeman, William, senior, of Heton, husbandman 9
5072639 2378301 2378301 defendant Thomlynson Thomas husbandman 600786 600786 Thomlynson, Thomas, of Heton, husbandman 0
5072640 2378301 2378301 defendant Thomlynson John husbandman 600786 600786 Thomlynson, John, of Heton, husbandman 1
5072641 2378301 2378301 defendant Robynson John husbandman 600786 600786 Robynson, John, of Heton, husbandman 2
5072642 2378301 2378301 defendant Boyes John husbandman 600786 600786 Boyes, John, of Heton, husbandman 3
5072643 2378301 2378301 defendant Templeman Robert husbandman 600786 600786 Templeman, Robert, of Heton, husbandman 4
5072644 2378301 2378301 defendant Clotherom William husbandman 600786 600786 Clotherom, William, of Heton, husbandman 5
5072645 2378301 2378301 defendant Malmagh Robert husbandman 600786 600786 Malmagh, Robert, of Heton, husbandman 6
5072646 2378301 2378301 defendant Hudson John husbandman 600786 600786 Hudson, John, of Heton, husbandman 7
5072647 2378301 2378301 defendant Templeman Robert, junior husbandman 600786 600786 Templeman, Robert, junior, of Heton, husbandman 8
5072648 2378301 2378301 defendant Templeman William, senior husbandman 600786 600786 Templeman, William, senior, of Heton, husbandman 9
5078055 2379920 2379920 defendant Musgrave Robert gent 600786 600786 Musgrave, Robert, of Heton juxta Byker, gent 0
5078056 2379920 2379920 defendant Rothirford George gent 600786 600786 Rothirford, George, of Heton juxta Byker, gent 1
5091406 2383874 2383874 defendant Wilson John husbandman 600786 600786 Wilson, John, of Heton, husbandman 13
5091433 2383879 2383879 defendant Wilson John husbandman 600786 600786 Wilson, John, of Heton, husbandman 11
5103118 2387335 2387335 defendant Rothirford George gent 600786 600786 Rothirford, George, of Heton juxta Byker, gent 1
5232703 2425147 2425147 defendant Candlend John yeoman 600786 600786 Candlend, John, of Heton, yeoman 0
5363138 2464124 2464124 defendant Croft Oliver clerk 600786 600786 Croft, Oliver, of Heton, clerk 1
5537886 2516338 2516338 defendant Johnson Robert husbandman 600786 600786 Johnson, Robert, of Heton, husbandman 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);