names

75 rows where place_id = 598887

✎ 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
3634451 1905576 1905576 defendant Tyknall William clerk 598887 598887 Tyknall, William, of Torkesey, clerk 0
3638143 1906747 1906747 defendant Smyth Mathew shoemaker 598887 598887 Smyth, Mathew, of Torkesey, shoemaker 0
3710851 1929711 1929711 defendant Bisshop William butcher 598887 598887 Bisshop, William, of Torkesey, butcher 2
4072903 2050605 2050605 defendant Clapham Thomas yeoman 598887 598887 Clapham, Thomas, of Torkesey, yeoman 0
4263162 2117345 2117345 defendant Goodale Thomas chapman 598887 598887 Goodale, Thomas, of Torkesey, chapman 0
4453893 2186234 2186234 defendant Madersey Thomas de   598887 598887 Madersey, Thomas de, of Torkesey 0
4534187 2210956 2210956 defendant Fyssher John shipman 598887 598887 Fyssher, John, of Torkesey, shipman 0
4600596 2231411 2231411 defendant Grene John   598887 598887 Grene, John, of Torkesey 0
4600597 2231411 2231411 defendant Sange John   598887 598887 Sange, John, of Torkesey 1
4605557 2232858 2232858 defendant Lyster Walter   598887 598887 Lyster, Walter, of Torkesey 0
4615712 2235913 2235913 defendant Grayne John   598887 598887 Grayne, John, of Torkesey 7
4628448 2239819 2239819 plaintiff Saxilby John   598887 598887 Saxilby, John, of Torkesey 0
4628449 2239819 2239819 defendant Grayne John   598887 598887 Grayne, John, of Torkesey 0
4628450 2239820 2239820 plaintiff Saxilby John   598887 598887 Saxilby, John, of Torkesey 0
4628452 2239821 2239821 plaintiff Saxilby John   598887 598887 Saxilby, John, of Torkesey 0
4649035 2245767 2245767 defendant Grayne John   598887 598887 Grayne, John, of Torkesey 0
4673993 2257482 2257482 defendant Chaumberleyn John yeoman 598887 598887 Chaumberleyn, John, of Torkesey, yeoman 0
4674386 2257599 2257599 defendant Chaunmberleyn John yeoman 598887 598887 Chaunmberleyn, John, of Torkesey, yeoman 1
4677723 2258650 2258650 defendant Sparwe John   598887 598887 Sparwe, John, of Torkesey 0
4682952 2260283 2260283 defendant Kyrmund alias Taillour John laborer 598887 598887 Kyrmund alias Taillour, John, of Torkesey, laborer 0
4718541 2271137 2271137 plaintiff Barbour Thomas   598887 598887 Barbour, Thomas, of Torkesey 0
4744399 2278886 2278886 plaintiff (not given) Richard prior of Ellay 598887 598887 Ellay, Richard, of Torkesey, prior of the house of St Leonard 0
4744400 2278886 2278886 defendant Goselyn Alan yeoman 598887 598887 Goselyn, Alan, of Torkesey, yeoman 0
4744401 2278886 2278886 defendant Chamberleyn John yeoman 598887 598887 Chamberleyn, John, of Torkesey, yeoman 1
4744402 2278886 2278886 defendant Clerk Thomas yeoman 598887 598887 Clerk, Thomas, of Torkesey, yeoman 2
4771448 2287052 2287052 plaintiff Saxilby John   598887 598887 Saxilby, John, of Torkesey 0
4789135 2292654 2292654 defendant Goselyn Alan husbandman 598887 598887 Goselyn, Alan, of Torkesey, husbandman 2
4814948 2300785 2300785 defendant Tailour John yeoman 598887 598887 Tailour, John, of Torkesey, yeoman 1
4821947 2302937 2302937 defendant Assheburn Robert chapman 598887 598887 Assheburn, Robert, of Torkesey, chapman 0
4821951 2302938 2302938 plaintiff Scarburgh Thomas   598887 598887 Scarburgh, Thomas, of Torkesey 0
4831042 2305738 2305738 defendant Scarbrugh Thomas gent 598887 598887 Scarbrugh, Thomas, of Torkesey, gent 2
4834605 2306826 2306826 defendant Grendale Nicholas merchant 598887 598887 Grendale, Nicholas, of Torkesey, merchant 2
4849582 2311344 2311344 defendant Scarburgh Thomas gent 598887 598887 Scarburgh, Thomas, of Torkesey, gent 1
4850683 2311670 2311670 defendant Sterbe_ Thomas gent 598887 598887 Sterbe_, Thomas, of Torkesey, gent 0
4869336 2317376 2317376 defendant Howegate John laborer 598887 598887 Howegate, John, of Torkesey, laborer 2
4874008 2318809 2318809 plaintiff Pounfreyt Thomas   598887 598887 Pounfreyt, Thomas, of Torkesey 0
4900715 2326862 2326862 defendant Swaton Thomas husbandman 598887 598887 Swaton, Thomas, of Torkesey, husbandman 0
4902437 2327375 2327375 defendant Colby William laborer 598887 598887 Colby, William, of Torkesey, laborer 3
4923320 2333720 2333720 defendant Tyler Simon tiler 598887 598887 Tyler, Simon, of Torkesey, tiler 0
4931093 2336116 2336116 defendant Elley Richard   598887 598887 Elley, Richard, of Torkesey, Lincs, prior 0
4937357 2338051 2338051 defendant Jonson Robert chapman 598887 598887 Jonson, Robert, of Torkesey, chapman 0
4939545 2338754 2338754 defendant Wyneld John husbandman 598887 598887 Wyneld, John, of Torkesey, husbandman 3
4940844 2339163 2339163 defendant Whasse Robert carpenter 598887 598887 Whasse, Robert, of Torkesey, carpenter 0
4943955 2340074 2340074 defendant Coly Thomas yeoman 598887 598887 Coly, Thomas, of Torkesey, yeoman 0
4949474 2341829 2341829 defendant Rynghaly John husbandman 598887 598887 Rynghaly, John, of Torkesey, husbandman 0
4951244 2342355 2342355 plaintiff Pounfreyt Thomas   598887 598887 Pounfreyt, Thomas, of Torkesey 0
4979884 2350938 2350938 defendant Ryffyn George husbandman 598887 598887 Ryffyn, George, of Torkesey, husbandman 1
5000042 2356894 2356894 defendant Baker John barber 598887 598887 Baker, John, of Torkesey, barber 1
5007565 2359108 2359108 defendant Frank William yeoman 598887 598887 Frank, William, of Torkesey, yeoman 0
5007566 2359108 2359108 defendant Hull Robert weaver 598887 598887 Hull, Robert, of Torkesey, weaver 1
5040342 2368714 2368714 defendant Frank William yeoman 598887 598887 Frank, William, of Torkesey, yeoman 0
5046516 2370599 2370599 defendant Fraunke William yeoman 598887 598887 Fraunke, William, of Torkesey, yeoman 2
5072845 2378360 2378360 defendant Uty William   598887 598887 Uty, William, of Torkesey, wright 0
5072846 2378360 2378360 defendant Hegge William shoemaker 598887 598887 Hegge, William, of Torkesey, shoemaker 1
5078612 2380095 2380095 defendant Barbour John yeoman 598887 598887 Barbour, John, of Torkesey, yeoman 0
5098951 2386123 2386123 defendant Pierson Robert shipman 598887 598887 Pierson, Robert, of Torkesey, shipman 0
5109048 2389066 2389066 defendant Coweper Thomas cooper 598887 598887 Coweper, Thomas, of Torkesey, cooper 0
5109050 2389066 2389066 defendant Toft William yeoman 598887 598887 Toft, William, of Torkesey, yeoman 2
5109057 2389067 2389067 defendant Feryman William shipman 598887 598887 Feryman, William, of Torkesey, shipman 4
5119785 2392225 2392225 defendant Sawemon Thomas tailor 598887 598887 Sawemon, Thomas, of Torkesey, tailor 1
5119787 2392225 2392225 defendant Barbour John barber 598887 598887 Barbour, John, of Torkesey, barber 3
5132244 2395927 2395927 defendant Alvewyke William chapman 598887 598887 Alvewyke, William, of Torkesey, chapman 0
5219071 2421309 2421309 defendant Thukyll William gent 598887 598887 Thukyll, William, of Torkesey, gent 2
5229673 2424299 2424299 plaintiff Alnewyk William   598887 598887 Alnewyk, William, of Torkesey 0
5231664 2424836 2424836 defendant Smyth Robert yeoman 598887 598887 Smyth, Robert, of Torkesey, yeoman 0
5236300 2426205 2426205 defendant Romesley William plumber 598887 598887 Romesley, William, of Torkesey, plumber 2
5238714 2426920 2426920 defendant Thirkyll William gent 598887 598887 Thirkyll, William, of Torkesey, gent 2
5261209 2433619 2433619 defendant Parker John yeoman 598887 598887 Parker, John, of Torkesey, yeoman 0
5265945 2435103 2435103 defendant Bene John barker 598887 598887 Bene, John, of Torkesey, barker 0
5365133 2464767 2464767 defendant Leylond Thomas sheerman 598887 598887 Leylond, Thomas, of Torkesey, sheerman 0
5404419 2476335 2476335 defendant Fox Nicholas mercer 598887 598887 Fox, Nicholas, of Torkesey, mercer 3
5510329 2508069 2508069 defendant Wellys Henry tiler 598887 598887 Wellys, Henry, of Torkesey, tiler 1
5591940 2532466 2532466 defendant Bysshop William butcher 598887 598887 Bysshop, William, of Torkesey, butcher 0
5591941 2532466 2532466 defendant Colynson Robert husbandman 598887 598887 Colynson, Robert, of Torkesey, husbandman 1
5635219 2554987 2554987 defendant Wayte John   598887 598887 Wayte, John, of Torkesey 4

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