names

123 rows where place_id = 590799

✎ 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
3602345 1868396 1868396 plaintiff Bulwer John (legal representative) 590799 590799 Bulwer, John, of Woddallyng, executors of 0
3602355 1868397 1868397 plaintiff Bulwer Simon yeoman 590799 590799 Bulwer, Simon, of Woddallyng, yeoman 0
3603647 1868809 1868809 defendant Wygot William husbandman 590799 590799 Wygot, William, of Woddallyng, husbandman 0
3603993 1868915 1868915 defendant Crane William   590799 590799 Crane, William, of Woddallyng, chaplain, son of Crane, Thomas, of Woddallyng 0
3605444 1869368 1869368 plaintiff Jerwys Richard   590799 590799 Jerwys, Richard, of Woddallyng 0
3616674 1872845 1872845 defendant Wygot William husbandman 590799 590799 Wygot, William, of Woddallyng, husbandman 1
3631511 1904670 1904670 defendant Ferrour Thomas   590799 590799 Ferrour, Thomas, of Woddallyng, worsted weaver 2
3664755 1914925 1914925 plaintiff Selth John   590799 590799 Selth, John, of Woddallyng 0
3676151 1918582 1918582 defendant Bulwer Roger yeoman 590799 590799 Bulwer, Roger, of Woddallyng, yeoman 1
3694871 1924604 1924604 defendant Bullware Roger yeoman 590799 590799 Bullware, Roger, of Woddallyng, yeoman 1
3709163 1929161 1929161 defendant Bulwer Margaret widow 590799 590799 Bulwer, Margaret, of Woddallyng, widow 0
3720665 1932752 1932752 defendant Bulware Roger husbandman 590799 590799 Bulware, Roger, of Woddallyng, husbandman 0
3720668 1932753 1932753 defendant Bulware Roger husbandman 590799 590799 Bulware, Roger, of Woddallyng, husbandman 0
3724724 1934018 1934018 defendant Wygott John husbandman 590799 590799 Wygott, John, of Woddallyng, husbandman 2
3763312 1946158 1946158 defendant Cokman John butcher 590799 590799 Cokman, John, of Woddallyng, butcher 2
3770447 1948437 1948437 defendant Cokman John butcher 590799 590799 Cokman, John, of Woddallyng, butcher 0
3781346 1951908 1951908 defendant Cokeman John butcher 590799 590799 Cokeman, John, of Woddallyng, butcher 2
3782821 1952376 1952376 defendant Balwer Roger yeoman 590799 590799 Balwer, Roger, of Woddallyng, yeoman 0
3782823 1952377 1952377 defendant Balwer Roger yeoman 590799 590799 Balwer, Roger, of Woddallyng, yeoman 0
3798118 1957307 1957307 defendant Cokeman John butcher 590799 590799 Cokeman, John, of Woddallyng, butcher 3
3805529 1959670 1959670 defendant Cokeman John butcher 590799 590799 Cokeman, John, of Woddallyng, butcher 1
3830701 1967485 1967485 defendant Crane Thomas yeoman 590799 590799 Crane, Thomas, of Woddallyng, yeoman 1
3830705 1967486 1967486 defendant Crane Thomas yeoman 590799 590799 Crane, Thomas, of Woddallyng, yeoman 1
3861985 1977469 1977469 defendant Cocke John butcher 590799 590799 Cocke, John, of Woddallyng, butcher 0
3875202 1981945 1981945 defendant Cokman John husbandman 590799 590799 Cokman, John, of Woddallyng, husbandman 0
3876710 1982453 1982453 defendant Bulwer Roger (legal representative) 590799 590799 Bulwer, Roger, of Woddallyng, yeoman, executor of 0
3900297 1990331 1990331 defendant Bulwer Simon yeoman 590799 590799 Bulwer, Simon, of Woddallyng, yeoman 0
3914109 1995065 1995065 plaintiff Bulwere William   590799 590799 Bulwere, William, of Woddallyng 0
3963603 2011880 2011880 defendant Thompson Simon husbandman 590799 590799 Thompson, Simon, of Woddallyng, husbandman 2
3970647 2014322 2014322 defendant Whytaker Robert tanner 590799 590799 Whytaker, Robert, of Woddallyng, tanner 0
4055394 2044324 2044324 defendant Leman Thomas butcher 590799 590799 Leman, Thomas, of Woddallyng, butcher 1
4196673 2094382 2094382 defendant Oke or Okes Alice widow 590799 590799 Oke or Okes, Alice, of Woddallyng, widow 2
4834957 2306938 2306938 plaintiff Wattes Richard   590799 590799 Wattes, Richard, of Woddallyng 1
4848874 2311114 2311114 defendant Wylde John husbandman 590799 590799 Wylde, John, of Woddallyng, husbandman 0
4868894 2317247 2317247 defendant Skyn John husbandman 590799 590799 Skyn, John, of Woddallyng, husbandman 1
4872459 2318347 2318347 defendant Mounceux Thomas gent 590799 590799 Mounceux, Thomas, of Woddallyng, gent 1
4875921 2319429 2319429 defendant Felbek William yeoman 590799 590799 Felbek, William, of Woddallyng, yeoman 0
4888483 2323194 2323194 defendant Wodecroft Richard   590799 590799 Wodecroft, Richard, of Woddallyng, mason 0
4959056 2344675 2344675 defendant Davy William husbandman 590799 590799 Davy, William, of Woddallyng, husbandman 0
4967027 2347072 2347072 defendant Bolwer Roger husbandman 590799 590799 Bolwer Roger, of Woddallyng, husbandman 0
4984423 2352273 2352273 defendant Bolwer William husbandman 590799 590799 Bolwer, William, of Woddallyng, husbandman 0
4985635 2352619 2352619 defendant Ayleward Thomas yeoman 590799 590799 Ayleward, Thomas, of Woddallyng, yeoman 1
4994306 2355170 2355170 defendant Aylward Thomas yeoman 590799 590799 Aylward, Thomas, of Woddallyng, yeoman 0
5020480 2362879 2362879 defendant Davy William yeoman 590799 590799 Davy, William, of Woddallyng, yeoman 0
5031527 2366081 2366081 defendant Ayleward Thomas husbandman 590799 590799 Ayleward, Thomas, of Woddallyng, husbandman 0
5111293 2389692 2389692 defendant Bulwer Roger yeoman 590799 590799 Bulwer, Roger, of Woddallyng, yeoman 0
5135748 2396967 2396967 defendant Loksmyth John husbandman 590799 590799 Loksmyth, John, of Woddallyng, husbandman 3
5166308 2405870 2405870 plaintiff Bulwer Roger   590799 590799 Bulwer, Roger, of Woddallyng 0
5221710 2422047 2422047 plaintiff Bulwer Roger   590799 590799 Bulwer, Roger, of Woddallyng 2
5221714 2422048 2422048 plaintiff Bulwer Roger   590799 590799 Bulwer, Roger, of Woddallyng 2
5221718 2422049 2422049 plaintiff Bulwer Roger   590799 590799 Bulwer, Roger, of Woddallyng 2
5254117 2431410 2431410 plaintiff Bullewer Roger   590799 590799 Bullewer, Roger, of Woddallyng 0
5272964 2437166 2437166 defendant Bulware or Bulward William butcher 590799 590799 Bulware or Bulward, William, of Woddallyng, butcher 0
5288464 2441648 2441648 defendant Crane Thomas yeoman 590799 590799 Crane, Thomas, of Woddallyng, yeoman 0
5288465 2441648 2441648 defendant Wattys John tailor 590799 590799 Wattys, John, of Woddallyng, tailor 1
5288466 2441648 2441648 defendant Herber Roger laborer 590799 590799 Herber, Roger, of Woddallyng, laborer 2
5288467 2441648 2441648 defendant Lokke Richar laborer 590799 590799 Lokke, Richar, of Woddallyng, laborer 3
5288468 2441648 2441648 defendant Cley Thomas smith 590799 590799 Cley, Thomas, of Woddallyng, smith 4
5288469 2441648 2441648 defendant Cokman Thomas laborer 590799 590799 Cokman, Thomas, of Woddallyng, laborer 5
5288470 2441648 2441648 defendant Overdon John laborer 590799 590799 Overdon, John, of Woddallyng, laborer 6
5288471 2441648 2441648 defendant Loksmyth John husbandman 590799 590799 Loksmyth, John, of Woddallyng, husbandman 7
5288472 2441648 2441648 defendant Loksmyth William butcher 590799 590799 Loksmyth, William, of Woddallyng, butcher 8
5288473 2441648 2441648 defendant Lytylwode Richard butcher 590799 590799 Lytylwode, Richard, of Woddallyng, butcher 9
5288474 2441648 2441648 defendant Wodecroft Peter butcher 590799 590799 Wodecroft, Peter, of Woddallyng, butcher 10
5288475 2441648 2441648 defendant Wodecroft Thomas butcher 590799 590799 Wodecroft, Thomas, of Woddallyng, butcher 11
5288476 2441648 2441648 defendant Jerveys Thomas butcher 590799 590799 Jerveys, Thomas, of Woddallyng, butcher 12
5288480 2441648 2441648 defendant Bulwer John, junior yeoman 590799 590799 Bulwer, John, junior, of Woddallyng, yeoman 16
5288482 2441648 2441648 defendant Bulwer William laborer 590799 590799 Bulwer, William, of Woddallyng, laborer 18
5288483 2441648 2441648 defendant Wygot William laborer 590799 590799 Wygot, William, of Woddallyng, laborer 19
5288484 2441648 2441648 defendant Wygot Thomas laborer 590799 590799 Wygot, Thomas, of Woddallyng, laborer 20
5292440 2442786 2442786 plaintiff Bullowere Roger   590799 590799 (Bullowere, Roger, of Woddallyng 1
5318842 2450728 2450728 defendant Cokeman Thomas husbandman 590799 590799 Cokeman, Thomas, of Woddallyng, husbandman 0
5320479 2451208 2451208 defendant Cokeman Thomas husbandman 590799 590799 Cokeman, Thomas, of Woddallyng, husbandman 0
5324811 2452498 2452498 defendant Andrewys Edward clerk 590799 590799 Andrewys, Edward, of Woddallyng, clerk 0
5328005 2453442 2453442 defendant Litelwode Richard husbandman 590799 590799 Litelwode, Richard, of Woddallyng, husbandman 2
5329916 2454019 2454019 defendant Wodecroft Thomas yeoman 590799 590799 Wodecroft, Thomas, of Woddallyng, yeoman 0
5330483 2454198 2454198 defendant Cokeman Thomas carpenter 590799 590799 Cokeman, Thomas, of Woddallyng, carpenter 0
5334067 2455255 2455255 defendant Cley Thomas smith 590799 590799 Cley, Thomas, of Woddallyng, smith 0
5340528 2457235 2457235 defendant Wodecroft Thomas husbandman 590799 590799 Wodecroft, Thomas, of Woddallyng, husbandman 2
5340529 2457235 2457235 defendant Wodecroft Peter husbandman 590799 590799 Wodecroft, Peter, of Woddallyng, husbandman 3
5348992 2459816 2459816 defendant Wattys John tailor 590799 590799 Wattys, John, of Woddallyng, tailor 1
5348994 2459816 2459816 defendant Arnold Adam butcher 590799 590799 Arnold, Adam, of Woddallyng, butcher 3
5350708 2460332 2460332 defendant Cleye Thomas smith 590799 590799 Cleye, Thomas, of Woddallyng, smith 1
5357908 2462541 2462541 defendant Bulwer John yeoman 590799 590799 Bulwer, John, of Woddallyng, yeoman 0
5361339 2463567 2463567 defendant Woddcroft Thomas butcher 590799 590799 Woddcroft, Thomas, of Woddallyng, butcher 2
5366535 2465186 2465186 defendant Wodecroft John hsubandman 590799 590799 Wodecroft, John, of Woddallyng, hsubandman 4
5372012 2466839 2466839 defendant Woodcroft Thomas butcher 590799 590799 Woodcroft, Thomas, of Woddallyng, butcher 0
5372013 2466839 2466839 defendant Belle Richard weaver 590799 590799 Belle, Richard, of Woddallyng, weaver 1
5380535 2469485 2469485 plaintiff Bulwer John yeoman 590799 590799 Bulwer, John, of Woddallyng, yeoman 0
5380536 2469485 2469485 plaintiff Bulwer Simon yeoman 590799 590799 Bulwer, Simon, of Woddallyng, yeoman 1
5380757 2469549 2469549 defendant W_croft Thomas husbandman 590799 590799 W_croft, Thomas, of Woddallyng, husbandman 2
5385244 2470855 2470855 plaintiff Bulwer John yeoman 590799 590799 Bulwer, John, of Woddallyng, yeoman 0
5385245 2470855 2470855 plaintiff Bulwar Simon yeoman 590799 590799 Bulwar, Simon, of Woddallyng, yeoman 1
5397248 2474296 2474296 defendant Wodcroft Thomas laborer 590799 590799 Wodcroft, Thomas, of Woddallyng, laborer 5
5410461 2478074 2478074 defendant Wodcroft Thomas laborer 590799 590799 Wodcroft, Thomas, of Woddallyng, laborer 4
5424335 2482243 2482243 defendant Wodcroft Thomas laborer 590799 590799 Wodcroft, Thomas, of Woddallyng, laborer 4
5424341 2482244 2482244 defendant Wodcroft Thomas laborer 590799 590799 Wodcroft, Thomas, of Woddallyng, laborer 4
5424419 2482270 2482270 plaintiff Bulwar John yeoman 590799 590799 Bulwar, John, of Woddallyng, yeoman 0
5424428 2482274 2482274 plaintiff Bulwer John yeoman 590799 590799 Bulwer, John, of Woddallyng, yeoman 0
5424431 2482275 2482275 plaintiff Bulwer John yeoman 590799 590799 Bulwer, John, of Woddallyng, yeoman 0

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