names

150 rows where place_id = 636100

✎ 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
3654339 1911618 1911618 plaintiff Asshburnam William   636100 636100 Asshburnam, William, of Sussex, Sheriff 0
3828873 1966910 1966910 plaintiff Collyn Thomas yeoman 636100 636100 Collyn, Thomas, of Sussex, yeoman 0
3955784 2009098 2009098 plaintiff Moore John esq 636100 636100 Moore, John, of Sussex, esq 0
3974179 2015538 2015538 plaintiff Harrys Roland gent 636100 636100 Harrys, Roland, of Sussex, gent 0
4063594 2047269 2047269 defendant Button Thomas yeoman 636100 636100 Button, Thomas, of Sussex, yeoman 0
4209433 2098850 2098850 defendant Sackvyle John esq 636100 636100 Sackvyle, John, of Sussex, esq 1
4269158 2119279 2119279 defendant Michell John gent 636100 636100 Michell, John, of Sussex, gent 2
4306002 2132238 2132238 defendant Alderton Roger gent 636100 636100 Alderton, Roger, of Sussex, gent 1
4341999 2144481 2144481 defendant Aunslowe John esq 636100 636100 Aunslowe, John, of Sussex, esq 0
4413843 2169227 2169227 defendant Bavent Roger   636100 636100 Bavent, Roger, of Sussex, knight 0
4450938 2185262 2185262 defendant Herst Richard de   636100 636100 Herst, Richard de, of Sussex 2
4465300 2189818 2189818 defendant Asshebournham John   636100 636100 Asshebournham, John, of Sussex 0
4465302 2189819 2189819 defendant Asshebournham John   636100 636100 Asshebournham, John, of Sussex 0
4465304 2189820 2189820 defendant Asshebourheham John   636100 636100 Asshebourheham, John, of Sussex 0
4469920 2191257 2191257 defendant Hurst Richard de   636100 636100 (Hurst, Richard de, of Sussex 1
4473177 2192275 2192275 defendant Asshebourneham John   636100 636100 Asshebourneham, John, of Sussex 2
4477756 2193709 2193709 plaintiff Halle John   636100 636100 Halle, John, of Sussex, junior 0
4479360 2194196 2194196 defendant Wylcumbe Nicholas   636100 636100 Wylcumbe, Nicholas, of Sussex 0
4486908 2196620 2196620 defendant Frenssh John   636100 636100 Frenssh, John, of Sussex 1
4486909 2196620 2196620 defendant Shirlok John (legal representative) 636100 636100 Shirlok, John, of Sussex, administrator of 2
4490430 2197705 2197705 defendant Herst Richard   636100 636100 Herst, Richard, of Sussex 2
4490432 2197705 2197705 defendant Waywyle Richard   636100 636100 Waywyle, Richard, of Sussex 4
4494247 2198893 2198893 defendant Hunt William   636100 636100 Hunt, William, of Sussex 0
4497871 2199974 2199974 defendant Fryde Roger   636100 636100 Fryde, Roger, of Sussex 3
4498057 2200039 2200039 defendant Cobeham Reginald esq 636100 636100 Cobeham, Reginald, of Sussex, esq 0
4501895 2201192 2201192 defendant Weyfeld Richard   636100 636100 Weyfeld, Richard, of Sussex 3
4505543 2202266 2202266 defendant Goryng John   636100 636100 Goryng, John, of Sussex 0
4505657 2202280 2202280 defendant Goryno- John   636100 636100 Goryno-, John, of Sussex 0
4507559 2202825 2202825 defendant Hendeman Richard   636100 636100 Hendeman, Richard, of Sussex 4
4509452 2203425 2203425 defendant Halsham John esq 636100 636100 Halsham, John, of Sussex, esq 4
4509463 2203426 2203426 defendant Halsham John esq 636100 636100 Halsham, John, of Sussex, esq 4
4510596 2203775 2203775 defendant Aleyn Robert   636100 636100 Aleyn, Robert, of Sussex 5
4510603 2203776 2203776 defendant Aleyn Robert   636100 636100 Aleyn, Robert, of Sussex 5
4512904 2204469 2204469 defendant Marecokes Thomas   636100 636100 Marecokes, Thomas, of Sussex 0
4516863 2205678 2205678 defendant Tylere John   636100 636100 Tylere, John, of Sussex 3
4517551 2205886 2205886 defendant Hamme Henry de   636100 636100 Hamme, Henry de, of Sussex 0
4520055 2206602 2206602 defendant Cobeham Reginald esq 636100 636100 Cobeham, Reginald, of Sussex, esq 0
4541136 2213130 2213130 defendant Kirkelenton John   636100 636100 (Kirkelenton, John, of Sussex 7
4546132 2214738 2214738 defendant Botiller Hugh esq 636100 636100 Botiller, Hugh, of Sussex, esq 0
4546133 2214738 2214738 defendant Scotte William esq 636100 636100 Scotte, William, of Sussex, esq 1
4548933 2215597 2215597 defendant Gootle Henry   636100 636100 Gootle, Henry, of Sussex 0
4548935 2215598 2215598 defendant Wolfe John   636100 636100 Wolfe, John, of Sussex 0
4550351 2216051 2216051 defendant Wilby John   636100 636100 Wilby, John, of Sussex 0
4555926 2217791 2217791 defendant Horn Thomas   636100 636100 Horn, Thomas, of Sussex 2
4556538 2217980 2217980 plaintiff Hunte William   636100 636100 Hunte, William, of Sussex 0
4559846 2219030 2219030 defendant Asshebernere John   636100 636100 Asshebernere, John, of Sussex 2
4559860 2219034 2219034 defendant Eclesale William   636100 636100 Eclesale, William, of Sussex 2
4559861 2219034 2219034 defendant Warbulton John   636100 636100 Warbulton, John, of Sussex 3
4560407 2219194 2219194 defendant Pyke Richard   636100 636100 Pyke, Richard, of Sussex 0
4560746 2219312 2219312 defendant St Cler Philip   636100 636100 St Cler, Philip, of Sussex 0
4562953 2219982 2219982 defendant atte Lee Thomas   636100 636100 atte Lee, Thomas, of Sussex 0
4564180 2220370 2220370 plaintiff Sakevyle Thomas   636100 636100 Sakevyle, Thomas, of Sussex, knight 0
4564185 2220371 2220371 plaintiff Sakevyle Thomas   636100 636100 Sakevyle, Thomas, of Sussex, knight 0
4569512 2222049 2222049 defendant Aylard Richard   636100 636100 Aylard, Richard, of Sussex 0
4569680 2222100 2222100 defendant Hendeman Richard   636100 636100 Hendeman, Richard, of Sussex 0
4570237 2222263 2222263 defendant Halsham John esq 636100 636100 Halsham, John, of Sussex, esq 0
4572149 2222841 2222841 defendant Watte William   636100 636100 Watte, William, of Sussex 0
4572912 2223068 2223068 defendant Lacy John   636100 636100 Lacy, John, of Sussex 0
4576003 2223990 2223990 plaintiff Cheyne William   636100 636100 Cheyne, William, of Sussex 3
4576197 2224054 2224054 defendant Assheburnham John   636100 636100 Assheburnham, John, of Sussex 0
4576199 2224055 2224055 defendant Assheburnham John   636100 636100 Assheburnham, John, of Sussex 0
4579830 2225177 2225177 defendant Dover Walter   636100 636100 Dover, Walter, of Sussex 1
4581563 2225678 2225678 defendant Benefeld John   636100 636100 Benefeld, John, of Sussex 0
4581566 2225679 2225679 defendant Benefeld John   636100 636100 Benefeld, John, of Sussex 1
4583771 2226340 2226340 defendant Beche Richard   636100 636100 Beche, Richard, of Sussex 0
4585028 2226742 2226742 defendant Burgeys Robert   636100 636100 Burgeys, Robert, of Sussex 1
4587435 2227473 2227473 defendant Hendyman Richard   636100 636100 Hendyman, Richard, of Sussex 5
4588214 2227709 2227709 defendant Sharp John   636100 636100 Sharp, John, of Sussex 0
4588218 2227710 2227710 defendant Sharp John   636100 636100 Sharp, John, of Sussex 0
4589440 2228071 2228071 defendant Halsham John esq 636100 636100 Halsham, John, of Sussex, esq 0
4589444 2228072 2228072 defendant Halsham John esq 636100 636100 Halsham, John, of Sussex, esq 0
4589547 2228103 2228103 defendant Wolf John   636100 636100 Wolf, John, of Sussex 4
4589555 2228104 2228104 defendant Wolf John   636100 636100 Wolf, John, of Sussex 4
4589563 2228105 2228105 defendant Wolf John   636100 636100 Wolf, John, of Sussex 4
4591796 2228789 2228789 defendant Stamer William   636100 636100 Stamer, William, of Sussex 0
4594045 2229400 2229400 defendant Bodull Alan   636100 636100 Bodull, Alan, of Sussex 0
4594299 2229477 2229477 defendant Wallere John   636100 636100 Wallere, John, of Sussex 3
4594305 2229478 2229478 defendant Wallere John   636100 636100 Wallere, John, of Sussex 3
4598111 2230659 2230659 defendant Aleyn Robert   636100 636100 Aleyn, Robert, of Sussex 1
4601634 2231728 2231728 defendant Benefeld John   636100 636100 Benefeld, John, of Sussex 0
4601739 2231762 2231762 defendant Wolf John   636100 636100 Wolf, John, of Sussex 1
4601900 2231820 2231820 defendant Wolf John   636100 636100 Wolf, John, of Sussex 0
4603447 2232270 2232270 plaintiff Wolf John   636100 636100 Wolf, John, of Sussex 0
4608273 2233696 2233696 defendant Pacchynge Roger slater 636100 636100 Pacchynge, Roger, of Sussex, slater 1
4615762 2235926 2235926 defendant Brewes John   636100 636100 Brewes, John, of Sussex, knight 0
4615766 2235927 2235927 defendant Brewes John   636100 636100 Brewes, John, of Sussex, knight 0
4626050 2239105 2239105 defendant Damory John, sen   636100 636100 Damory, John, sen, of Sussex 0
4626052 2239106 2239106 defendant Dautry John, sen   636100 636100 Dautry, John, sen, of Sussex 0
4628083 2239708 2239708 plaintiff Sakevile Thomas   636100 636100 Sakevile, Thomas, of Sussex, knight 0
4628093 2239712 2239712 plaintiff Sakevyle Thomas   636100 636100 Sakevyle, Thomas, of Sussex, knight 0
4628095 2239713 2239713 plaintiff Sakevyle Thomas   636100 636100 Sakevyle, Thomas, of Sussex, knight 0
4635006 2241794 2241794 defendant Brewes John de   636100 636100 Brewes, John de, of Sussex, knight 0
4635022 2241802 2241802 defendant Brewes John de   636100 636100 Brewes, John de, of Sussex, knight 0
4637393 2242490 2242490 defendant Kyng John clerk 636100 636100 Kyng, John, of Sussex, clerk 4
4637401 2242491 2242491 defendant Kynge John clerk 636100 636100 Kynge, John, of Sussex, clerk 4
4642222 2243844 2243844 plaintiff Halle John, sen   636100 636100 Halle, John, sen, of Sussex 0
4646871 2245147 2245147 defendant Notebem John   636100 636100 Notebem, John, of Sussex 3
4653651 2247069 2247069 defendant Langerigge Robert   636100 636100 Langerigge, Robert, of Sussex 0
4654048 2247151 2247151 defendant Shawe Thomas   636100 636100 Shawe, Thomas, of Sussex 0
4672702 2257104 2257104 plaintiff Sakevyle Thomas   636100 636100 Sakevyle, Thomas, of Sussex 1

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