names

83 rows where place_id = 586439

✎ 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
3588729 1864118 1864118 defendant Marys William clerk 586439 586439 Marys, William, of Fretenham, clerk 0
3589893 1864480 1864480 defendant Bysshop James clerk 586439 586439 Bysshop, James, of Fretenham, clerk 1
3602189 1868350 1868350 defendant Skernyng Thomas clerk 586439 586439 Skernyng, Thomas, of Fretenham, clerk 4
3608223 1870228 1870228 defendant Spenlefe Stephen carpenter 586439 586439 Spenlefe, Stephen, of Fretenham, carpenter 0
3614105 1872075 1872075 defendant Hermer Thomas carpenter 586439 586439 Hermer, Thomas, of Fretenham, carpenter 1
3627474 1903450 1903450 defendant Spenlove Stephen husbandman 586439 586439 Spenlove, Stephen, of Fretenham, husbandman 0
3665654 1915207 1915207 defendant Papar Richard husbandman 586439 586439 Papar, Richard, of Fretenham, husbandman 1
3699972 1926224 1926224 defendant Brown Thomas   586439 586439 Brown, Thomas, of Fretenham, worsted weaver 1
3706231 1928236 1928236 defendant Broun Thomas   586439 586439 Broun, Thomas, of Fretenham, worsted weaver 2
3752465 1942694 1942694 defendant Carman John butcher 586439 586439 Carman, John, of Fretenham, butcher 1
3836574 1969342 1969342 defendant Davy Nicholas husbandman 586439 586439 Davy, Nicholas, of Fretenham, husbandman 0
3851959 1974202 1974202 defendant Watson William clerk 586439 586439 Watson, William, of Fretenham, clerk 0
3852694 1974451 1974451 defendant Carman John butcher 586439 586439 Carman, John, of Fretenham, butcher 0
3857752 1976062 1976062 defendant Phelippis William, senior husbandman 586439 586439 Phelippis, William, senior, of Fretenham, husbandman 2
3857878 1976103 1976103 defendant Phelippys William, senior husbandman 586439 586439 Phelippys, William, senior, of Fretenham, husbandman 2
4424424 2172478 2172478 defendant atte Hill John   586439 586439 atte Hill, John, of Fretenham 0
4446194 2183720 2183720 defendant Vaus William   586439 586439 Vaus, William, of Fretenham 0
4446195 2183720 2183720 defendant Clyve John   586439 586439 Clyve, John, of Fretenham 1
4454004 2186268 2186268 defendant Wax William   586439 586439 Wax, William, of Fretenham 1
4467602 2190545 2190545 defendant Acrys John de   586439 586439 Acrys, John de, of Fretenham 0
4497686 2199923 2199923 defendant Acres John   586439 586439 Acres, John, of Fretenham 0
4607374 2233415 2233415 defendant Hill William   586439 586439 Hill, William, of Fretenham 0
4637323 2242468 2242468 defendant Acres John   586439 586439 Acres, John, of Fretenham 5
4639972 2243197 2243197 defendant Gunny John   586439 586439 Gunny, John, of Fretenham 0
4672070 2256913 2256913 defendant Wallere John   586439 586439 Wallere, John, of Fretenham, shepherd 0
4672071 2256913 2256913 defendant Summy John husbandman 586439 586439 Summy, John, of Fretenham, husbandman 1
4672072 2256913 2256913 defendant Aylmere Henry husbandman 586439 586439 Aylmere, Henry, of Fretenham, husbandman 2
4811216 2299619 2299619 defendant Foweler Thomas, junior yeoman 586439 586439 Foweler, Thomas, junior, of Fretenham, yeoman 0
4825772 2304096 2304096 defendant Fowelere Thomas husbandman 586439 586439 Fowelere, Thomas, of Fretenham, husbandman 1
5001758 2357409 2357409 defendant Carman Thomas   586439 586439 Carman, Thomas, of Fretenham, wright 1
5093043 2384355 2384355 defendant Foweler Thomas yeoman 586439 586439 Foweler, Thomas, of Fretenham, yeoman 1
5119554 2392149 2392149 defendant Gilberd John husbandman 586439 586439 Gilberd, John, of Fretenham, husbandman 0
5119558 2392150 2392150 defendant Gilberd John husbandman 586439 586439 Gilberd, John, of Fretenham, husbandman 0
5126109 2394117 2394117 defendant Fouler Thomas husbandman 586439 586439 Fouler, Thomas, of Fretenham, husbandman 8
5126912 2394348 2394348 defendant Monger alias Smyth William yeoman 586439 586439 Monger alias Smyth, William, of Fretenham, yeoman 3
5134957 2396725 2396725 defendant Fyssh Edmund   586439 586439 Fyssh, Edmund, of Fretenham, parson 1
5136866 2397305 2397305 defendant Fyssh Edmund clerk & parson 586439 586439 Fyssh, Edmund, of Fretenham, clerk & parson 0
5136868 2397305 2397305 defendant Carman Thomas husbandman 586439 586439 Carman, Thomas, of Fretenham, husbandman 2
5145617 2399860 2399860 defendant Manger William yeoman 586439 586439 Manger, William, of Fretenham, yeoman 4
5157435 2403312 2403312 defendant Fyssh Edmund clerk & parson 586439 586439 Fyssh, Edmund, of Fretenham, clerk & parson 0
5157438 2403312 2403312 defendant Carman Thomas husbandman 586439 586439 Carman, Thomas, of Fretenham, husbandman 3
5162466 2404748 2404748 defendant Gilberd John butcher 586439 586439 Gilberd, John, of Fretenham, butcher 0
5162467 2404748 2404748 defendant Broun Thomas husbandman 586439 586439 Broun, Thomas, of Fretenham, husbandman 1
5173357 2407916 2407916 defendant Fysshe Edmund clerk 586439 586439 Fysshe, Edmund, of Fretenham, clerk 0
5173360 2407916 2407916 defendant Carman Thomas husbandman 586439 586439 Carman, Thomas, of Fretenham, husbandman 3
5195798 2414519 2414519 plaintiff Seman William   586439 586439 Seman, William, of Fretenham 1
5215701 2420315 2420315 defendant Myllegate John   586439 586439 Myllegate, John, of Fretenham, shepherd 0
5217694 2420908 2420908 defendant Fissh Edmund clerk 586439 586439 Fissh, Edmund, of Fretenham, clerk 3
5217766 2420926 2420926 defendant Brown Thomas yeoman 586439 586439 Brown, Thomas, of Fretenham, yeoman 0
5217767 2420926 2420926 defendant Brown Reginald   586439 586439 Brown, Reginald, of Fretenham, laborer, his son 1
5224644 2422878 2422878 defendant Fyssh Edmund clerk 586439 586439 Fyssh, Edmund, of Fretenham, clerk 1
5224645 2422878 2422878 defendant Fouler Thomas yeoman 586439 586439 Fouler, Thomas, of Fretenham, yeoman 2
5224646 2422878 2422878 defendant Gylberd John butcher 586439 586439 Gylberd, John, of Fretenham, butcher 3
5240005 2427276 2427276 defendant Fysshe Edmund clerk 586439 586439 Fysshe, Edmund, of Fretenham, clerk 3
5240334 2427386 2427386 defendant Woderoff Henry husbandman 586439 586439 Woderoff, Henry, of Fretenham, husbandman 1
5245456 2428826 2428826 defendant Fyssh Edmund clerk 586439 586439 Fyssh, Edmund, of Fretenham, clerk 1
5245457 2428826 2428826 defendant Fouler Thomas yeoman 586439 586439 Fouler, Thomas, of Fretenham, yeoman 2
5245458 2428826 2428826 defendant Gylberd John butcher 586439 586439 Gylberd, John, of Fretenham, butcher 3
5252943 2431034 2431034 defendant Gylberte John butcher 586439 586439 Gylberte, John, of Fretenham, butcher 1
5296404 2443937 2443937 defendant Fouler Thomas yeoman 586439 586439 Fouler, Thomas, of Fretenham, yeoman 2
5307290 2447184 2447184 defendant Fyssh (illegible) clerk 586439 586439 Fyssh, _, of Fretenham, clerk 0
5313829 2449164 2449164 defendant Foweler Thomas husbandman 586439 586439 Foweler, Thomas, of Fretenham, husbandman 3
5314612 2449403 2449403 defendant Fouler Thomas, senior husbandman 586439 586439 Fouler, Thomas, senior, of Fretenham, husbandman 2
5314613 2449403 2449403 defendant Fouler William laborer 586439 586439 Fouler, William, of Fretenham, laborer 3
5339920 2457054 2457054 defendant Carman John carpenter 586439 586439 Carman, John, of Fretenham, carpenter 1
5437160 2486048 2486048 defendant Breese William husbandman 586439 586439 Breese, William, of Fretenham, husbandman 0
5462849 2493799 2493799 defendant Gyrdyng John husbandman 586439 586439 Gyrdyng, John, of Fretenham, husbandman 0
5478312 2498541 2498541 defendant Neell Thomas   586439 586439 Neell, Thomas, of Fretenham, shepherd 0
5490178 2501947 2501947 defendant Gyrdyng John husbandman 586439 586439 Gyrdyng, John, of Fretenham, husbandman 0
5493877 2503077 2503077 plaintiff Brese William   586439 586439 Brese, William, of Fretenham 1
5493880 2503078 2503078 defendant Carman John carpenter 586439 586439 Carman, John, of Fretenham, carpenter 0
5493881 2503078 2503078 defendant Asshe Thomas smith 586439 586439 Asshe, Thomas, of Fretenham, smith 1
5493882 2503078 2503078 defendant Harmer Thomas carpenter 586439 586439 Harmer, Thomas, of Fretenham, carpenter 2
5496494 2503860 2503860 defendant Brese William husbandman 586439 586439 Brese, William, of Fretenham, husbandman 2
5496495 2503860 2503860 defendant Gilbert John husbandman 586439 586439 Gilbert, John, of Fretenham, husbandman 3
5508896 2507638 2507638 defendant Brownyng Thomas husbandman 586439 586439 Brownyng, Thomas, of Fretenham, husbandman 1
5519876 2511054 2511054 defendant Kyndell John husbandman 586439 586439 Kyndell, John, of Fretenham, husbandman 0
5519878 2511054 2511054 defendant Spendell Thomas carpenter 586439 586439 Spendell, Thomas, of Fretenham, carpenter 2
5519879 2511054 2511054 defendant Browenyng William laborer 586439 586439 Browenyng, William, of Fretenham, laborer 3
5533920 2515150 2515150 defendant Gyles Alexander husbandman 586439 586439 Gyles, Alexander, of Fretenham, husbandman 2
5534773 2515416 2515416 defendant Neell Thomas   586439 586439 Neell, Thomas, of Fretenham, shepherd 0
5534779 2515417 2515417 defendant Neell Thomas   586439 586439 Neell, Thomas, of Fretenham, shepherd 1
5557722 2522210 2522210 defendant Heton John clerk 586439 586439 Heton, John, of Fretenham, clerk 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);