names

69 rows where place_id = 593442

✎ 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
3611842 1871364 1871364 defendant Smyth William yeoman 593442 593442 Smyth, William, of Uffyngton, yeoman 0
3644131 1908597 1908597 defendant Sleford John gent 593442 593442 Sleford, John, of Uffyngton, gent 1
3689125 1922761 1922761 defendant Sleford John gent 593442 593442 Sleford, John, of Uffyngton, gent 1
3706733 1928391 1928391 defendant Barker Richard husbandman 593442 593442 Barker, Richard, of Uffyngton, husbandman 0
3706734 1928391 1928391 defendant Barker Thomas husbandman 593442 593442 Barker, Thomas, of Uffyngton, husbandman 1
3713830 1930624 1930624 defendant Cristofer John husbandman 593442 593442 Cristofer, John, of Uffyngton, husbandman 0
3774453 1949736 1949736 defendant Webbe John, senior husbandman 593442 593442 Webbe, John, senior, of Uffyngton, husbandman 0
3774454 1949736 1949736 defendant Pounde Thomas husbandman 593442 593442 Pounde, Thomas, of Uffyngton, husbandman 1
3774455 1949736 1949736 defendant Wolman John husbandman 593442 593442 Wolman, John, of Uffyngton, husbandman 2
3774456 1949736 1949736 defendant Mortemer John husbandman 593442 593442 Mortemer, John, of Uffyngton, husbandman 3
3830577 1967441 1967441 defendant Colfax Richard husbandman 593442 593442 Colfax, Richard, of Uffyngton, husbandman 1
3845462 1972139 1972139 defendant Rysley Arthur husbandman 593442 593442 Rysley, Arthur, of Uffyngton, husbandman 0
3845463 1972139 1972139 defendant Smyth William husbandman 593442 593442 Smyth, William, of Uffyngton, husbandman 1
3845464 1972139 1972139 defendant Pownde Thomas husbandman 593442 593442 Pownde, Thomas, of Uffyngton, husbandman 2
3860351 1976961 1976961 defendant Johnson John clerk 593442 593442 Johnson, John, of Uffyngton, clerk 0
3861472 1977297 1977297 defendant Colfax Richard husbandman 593442 593442 Colfax, Richard, of Uffyngton, husbandman 0
3960780 2010874 2010874 defendant Cater William gent 593442 593442 Cater, William, of Uffyngton, gent 0
4299028 2129748 2129748 defendant Heyton Thomas yeoman 593442 593442 Heyton, Thomas, of Uffyngton, yeoman 0
4466617 2190237 2190237 defendant Heyremaker Robert   593442 593442 Heyremaker, Robert, of Uffyngton 0
4526947 2208713 2208713 plaintiff Lee Robert   593442 593442 Lee, Robert, of Uffyngton 0
4568745 2221808 2221808 plaintiff Warner Robert   593442 593442 Warner, Robert, of Uffyngton 1
4594846 2229642 2229642 defendant Sutton Peter   593442 593442 Sutton, Peter, of Uffyngton 0
4621820 2237810 2237810 plaintiff Lee Robert   593442 593442 Lee, Robert, of Uffyngton 0
4659426 2248809 2248809 defendant de Shropshire Richard esq 593442 593442 de Shropshire, Richard, of Uffyngton, esq 0
4685229 2260977 2260977 defendant Warner Robert yeoman 593442 593442 Warner, Robert, of Uffyngton, yeoman 1
4688876 2262076 2262076 defendant Pole William yeoman 593442 593442 Pole, William, of Uffyngton, yeoman 0
4691637 2262918 2262918 defendant Payn William husbandman 593442 593442 Payn, William, of Uffyngton, husbandman 0
4716378 2270441 2270441 defendant Playstowe William tailor 593442 593442 Playstowe, William, of Uffyngton, tailor 0
4716380 2270442 2270442 defendant Playstewe William tailor 593442 593442 Playstewe, William, of Uffyngton, tailor 0
4716966 2270638 2270638 defendant Dey Edmund laborer 593442 593442 Dey, Edmund, of Uffyngton, laborer 0
4719413 2271416 2271416 defendant Milner Adam miller 593442 593442 Milner, Adam, of Uffyngton, miller 2
4764315 2284834 2284834 defendant Dygill Richard   593442 593442 Dygill, Richard, of Uffyngton, parson 0
4770934 2286889 2286889 defendant Pole William de yeoman 593442 593442 Pole, William de, of Uffyngton, yeoman 0
4771706 2287128 2287128 defendant Stoner William husbandman 593442 593442 Stoner, William, of Uffyngton, husbandman 0
4771707 2287128 2287128 defendant Whityngton John husbandman 593442 593442 Whityngton, John, of Uffyngton, husbandman 1
4773690 2287746 2287746 defendant Tyler John   593442 593442 (Tyler, John, of Uffyngton, tile maker 1
4775852 2288448 2288448 plaintiff Wylughby Edmund esq 593442 593442 Wylughby, Edmund, of Uffyngton, esq 0
4794794 2294513 2294513 defendant Tounesende John husbandman 593442 593442 Tounesende, John, of Uffyngton, husbandman 0
4801783 2296740 2296740 plaintiff Wylughby Edmund esq 593442 593442 Wylughby, Edmund, of Uffyngton, esq 0
4840036 2308432 2308432 defendant Cook Robert laborer 593442 593442 Cook, Robert, of Uffyngton, laborer 0
4860489 2314641 2314641 defendant Pole William yeoman 593442 593442 Pole, William, of Uffyngton, yeoman 0
4906717 2328687 2328687 defendant West Reginald   593442 593442 West, Reginald, of Uffyngton, knight 0
4924976 2334242 2334242 defendant att Well Simon husbandman 593442 593442 att Well, Simon, of Uffyngton, husbandman 0
4924978 2334243 2334243 defendant att Well Simon husbandman 593442 593442 att Well, Simon, of Uffyngton, husbandman 0
4930690 2336011 2336011 defendant Mount John yeoman 593442 593442 Mount, John, of Uffyngton, yeoman 0
4933655 2336903 2336903 defendant Beke Robert husbandman 593442 593442 Beke, Robert, of Uffyngton, husbandman 1
4957927 2344342 2344342 defendant Knollis John husbandman 593442 593442 Knollis, John, of Uffyngton, husbandman 1
4975970 2349777 2349777 defendant Barker William   593442 593442 Barker, William, of Uffyngton 0
4975971 2349777 2349777 defendant Warner Richard   593442 593442 Warner, Richard, of Uffyngton 1
4983562 2352001 2352001 defendant Fysshemere Thomas husbandman 593442 593442 Fysshemere, Thomas, of Uffyngton, husbandman 0
4983563 2352001 2352001 defendant Fysshemere William husbandman 593442 593442 Fysshemere, William, of Uffyngton, husbandman 1
4991622 2354376 2354376 defendant Spray Richard husbandman 593442 593442 Spray, Richard, of Uffyngton, husbandman 0
5020597 2362914 2362914 plaintiff Edynham John   593442 593442 Edynham, John, of Uffyngton 0
5061745 2375109 2375109 defendant Leyland Richard (legal representative) 593442 593442 Leyland, Richard, of Uffyngton, esq, executors of 0
5061748 2375109 2375109 defendant Hareby Simon gent 593442 593442 Hareby, Simon, of Uffyngton, gent 3
5140890 2398451 2398451 defendant Huntte John husbandman 593442 593442 Huntte, John, of Uffyngton, husbandman 0
5188888 2412486 2412486 defendant Pykworth Roland husbandman 593442 593442 Pykworth, Roland, of Uffyngton, husbandman 0
5255624 2431876 2431876 defendant Philipp John husbandman 593442 593442 Philipp, John, of Uffyngton, husbandman 0
5255625 2431876 2431876 defendant Barker John husbandman 593442 593442 Barker, John, of Uffyngton, husbandman 1
5284508 2440481 2440481 defendant Pound William husbandman 593442 593442 Pound, William, of Uffyngton, husbandman 0
5287294 2441305 2441305 defendant Pound William husbandman 593442 593442 Pound, William, of Uffyngton, husbandman 0
5351232 2460478 2460478 defendant Barker William husbandman 593442 593442 Barker, William, of Uffyngton, husbandman 0
5394122 2473379 2473379 defendant Castylford Robert chaplain 593442 593442 Castylford, Robert, of Uffyngton, chaplain 3
5406381 2476896 2476896 plaintiff Standard John   593442 593442 Standard, John, of Uffyngton 0
5440667 2487115 2487115 defendant Haywode John laborer 593442 593442 Haywode, John, of Uffyngton, laborer 1
5440668 2487115 2487115 defendant Warner Thomas husbandman 593442 593442 Warner, Thomas, of Uffyngton, husbandman 2
5476033 2497846 2497846 defendant Wellys John husbandman 593442 593442 Wellys, John, of Uffyngton, husbandman 1
5616969 2549118 2549118 defendant Ryale John   593442 593442 Ryale, John, of Uffyngton 0
5623273 2551213 2551213 plaintiff Wryght simon   593442 593442 Wryght, simon, of Uffyngton 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);